Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

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. :D:



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 :p
 
Back
Top