• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

CODE Tags and Mentioning

Joined
Aug 14, 2009
Messages
2,304
Reaction score
1,189
In my opinion this shouldn't happen:

Code:
-- update session key/id
	declare   [USER=2000045131]Session[/USER]Key varchar(50) = NEWID()
	declare   [USER=2000045131]Session[/USER]ID int = checksum   [USER=2000045131]Session[/USER]Key)
	if exists (SELECT CustomerID FROM LoginSessions WHERE CustomerID =   [USER=25895]Custom[/USER]erID)
	begin
		UPDATE LoginSessions SET 
			SessionKey   [USER=2000045131]Session[/USER]Key, 
			SessionID   [USER=2000045131]Session[/USER]ID,
			LoginIP=@in_IP, 
			TimeLogged=GETDATE(), 
			TimeUpdated=GETDATE()
		WHERE CustomerID   [USER=25895]Custom[/USER]erID
	end
	else
	begin
		INSERT INTO LoginSessions
			(CustomerID, SessionKey, SessionID, LoginIP, TimeLogged, TimeUpdated)
		VALUES 
			   [USER=25895]Custom[/USER]erID,   [USER=2000045131]Session[/USER]Key,   [USER=2000045131]Session[/USER]ID, @in_IP, GETDATE(), GETDATE())
	end

It just mentions people what actually code is.
 
Joined
Oct 28, 2011
Messages
2,465
Reaction score
1,258
@GigaToni ChewBecca MentaL

Work around. (Solution to get around this issue)
Put the @ Symbol itself in Bold Block.

Here is bolded:
Code:
-- update session key/id
	declare   [B]@[/B]SessionKey varchar(50) = NEWID()
	declare   [B]@[/B]SessionID int = checksum   [B]@[/B]SessionKey)
	if exists (SELECT CustomerID FROM LoginSessions WHERE CustomerID =   [B]@[/B]CustomerID)
	begin
		UPDATE LoginSessions SET 
			SessionKey   [B]@[/B]SessionKey, 
			SessionID   [B]@[/B]SessionID,
			LoginIP=@in_IP, 
			TimeLogged=GETDATE(), 
			TimeUpdated=GETDATE()
		WHERE CustomerID   [B]@[/B]CustomerID
	end
	else
	begin
		INSERT INTO LoginSessions
			(CustomerID, SessionKey, SessionID, LoginIP, TimeLogged, TimeUpdated)
		VALUES 
			  [B]@[/B]CustomerID,   [B]@[/B]SessionKey,  [B]@[/B]SessionID, @in_IP, GETDATE(), GETDATE())
	end
 
Last edited:
Custom Title Activated
Loyal Member
Joined
Oct 23, 2005
Messages
6,598
Reaction score
5,565
Dude. I can't do anything. I'm not admin. Lolwat
 
Joined
Oct 28, 2011
Messages
2,465
Reaction score
1,258
I don't have access to fixing that, nor do I believe the forum has that option.
At least there is a way around it. :



Generally only happens with code.
You generally are copying the code from source to the posted code block.
Takes 1 minute to paste it into notepad++
Search-Replace all instances of @ symbol with [ B]@[/B ] same with # symbol.
Copy / paste into post.
 

Ben

Developer - JS
Developer
Joined
Jul 6, 2013
Messages
1,224
Reaction score
506
Highly suggest that it should ignore it in the code block.... if possible ofcourse, not everyone knows that when you put it in bold it doesn't say the name though thx for that DNC