How to fix 5101 Problem?

Page 2 of 2 1 2
11/17/2014 10:51 PGamerz#16
Quote:
Originally Posted by maikleBT1 View Post
That ptoblem the old rohanauth got it Only in my rohanauth there auto fix it
Can you share rohanauth @maikleBT1?
11/17/2014 14:41 oziel235#17
I use this solution.
BigServGame replace to your character name :D

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) 
:D
11/17/2014 15:20 PGamerz#18
Quote:
Originally Posted by oziel235 View Post
I use this solution.
BigServGame replace to your character name :D

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) 
:D
I hope this's the best solution, thanks for share

Quote:
Originally Posted by oziel235 View Post
I use this solution.
BigServGame replace to your character name :D

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) 
:D
doesn't work for me, still the same :(
Page 2 of 2 1 2