How to fix 5101 Problem?

[PGamerz]

Originally Posted by maikleBT1

That ptoblem the old rohanauth got it Only in my rohanauth there auto fix it

Can you share rohanauth @maikleBT1?

[oziel235]

I use this solution.
BigServGame replace to your character name

PHP Code:

GO
DECLARE @id Integer
SELECT @id = [user_id] from [RohanGame].[dbo].[TCharacter]
where [RohanGame].[dbo].[TCharacter].name like 'BigServGame'
BEGIN
INSERT INTO [RohanUser].[dbo].[TDisconnect] (user_id, server_id, char_id)
values(@id,31,0)
END 


or

PHP Code:

INSERT INTO [RohanUser].[dbo].[TDisconnect] (user_id ,server_id, char_id) 
VALUES (21272, 31, 0) 


[PGamerz]

Originally Posted by oziel235

I use this solution.
BigServGame replace to your character name

PHP Code:

GO
DECLARE @id Integer
SELECT @id = [user_id] from [RohanGame].[dbo].[TCharacter]
where [RohanGame].[dbo].[TCharacter].name like 'BigServGame'
BEGIN
INSERT INTO [RohanUser].[dbo].[TDisconnect] (user_id, server_id, char_id)
values(@id,31,0)
END 


or

PHP Code:

INSERT INTO [RohanUser].[dbo].[TDisconnect] (user_id ,server_id, char_id) 
VALUES (21272, 31, 0) 


I hope this's the best solution, thanks for share

Originally Posted by oziel235

I use this solution.
BigServGame replace to your character name

PHP Code:

GO
DECLARE @id Integer
SELECT @id = [user_id] from [RohanGame].[dbo].[TCharacter]
where [RohanGame].[dbo].[TCharacter].name like 'BigServGame'
BEGIN
INSERT INTO [RohanUser].[dbo].[TDisconnect] (user_id, server_id, char_id)
values(@id,31,0)
END 


or

PHP Code:

INSERT INTO [RohanUser].[dbo].[TDisconnect] (user_id ,server_id, char_id) 
VALUES (21272, 31, 0) 


doesn't work for me, still the same