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!

Account Log Stuck

Newbie Spellweaver
Joined
Sep 24, 2008
Messages
16
Reaction score
0
I know it's a noob question , but it's not to me.

when players inside the game , and i restart the server. their account will be stuck in the log , and if they want to login the Game will say " you account allready logged in "

i just want a "thing" that can auto delete log.

Heres an SS :-

babitelor - Account Log Stuck - RaGEZONE Forums


If you guys help me , omg i'll love you guys forever. ( LOL )

:lol:
 
MorbidA
Loyal Member
Joined
May 28, 2006
Messages
247
Reaction score
32
search the forum for the fix which i posted like a year ago.
 
Newbie Spellweaver
Joined
Sep 24, 2008
Messages
16
Reaction score
0
allright.

edit : damn , search everywhere.didnt found it.
 
Last edited:
Newbie Spellweaver
Joined
Sep 24, 2008
Messages
16
Reaction score
0
i dont want my topic become useless.


sombody nice enough to give me the links ?
i search everywhere by searching tyfix name


BUMP
 
MorbidA
Loyal Member
Joined
May 28, 2006
Messages
247
Reaction score
32
i dont know maybe they deleted it, seems all the useful threads gets deleted and all the spam stays.

But modify USPCheckBilling_Login SP in BillingDB (pay_gamemyth if you have it called that)

Code:
ALTER PROC [dbo].[USPCheckBilling_Login] @strClientID varchar(20),@UID int,@Check int,@ClientIP varchar(15),@ServerID Tinyint
AS
	SET NOCOUNT ON
	
	DECLARE @FLAG INT
	DECLARE @BillingType Char(2)
	DECLARE @PlayTime INT
	DECLARE @Crmindex INT
	
	SET @FLAG = 1 --ERROR
	SET @BillingType ='N'
	SET @PlayTime = 0
	SET @Crmindex = 0

	--CHECKING
	IF EXISTS (SELECT strClientID FROM TblCurrentUser_Disconn WHERE strClientID = @strClientID)
	BEGIN
		DELETE TblCurrentUser_Disconn
		WHERE strClientID = @strClientID
	END
	ELSE IF EXISTS (SELECT strClientID FROM TblCurrentUser_Temp WHERE strClientID = @strClientID)
	BEGIN
		DELETE TblCurrentUser_Temp
		WHERE strClientID = @strClientID
	END
	ELSE IF EXISTS (SELECT strClientID FROM TblCurrentUser WHERE strClientID = @strClientID)
	BEGIN
		DELETE TblCurrentUser
		WHERE strClientID = @strClientID
	END

	INSERT TblCurrentUser_Temp (strClientID,UID,strIP,tinyServerID)
	VALUES (@strClientID,@UID,@ClientIP,@ServerID)
		
	IF @@ROWCOUNT <> 1
	BEGIN
		SELECT @FLAG,@BillingType,@PlayTime,@Crmindex
	END
	ELSE
	BEGIN
		SET @FLAG = 0 --SUCCESS		
		SELECT @FLAG,@BillingType,@PlayTime,@Crmindex
	END

Also edit USPServer_Start & USPServer_End SP's in same db.

Code:
ALTER PROC [dbo].[USPServer_Start] @ServerID Tinyint
AS
	SET NOCOUNT ON
	
	DELETE TblCurrentUser_Temp
	WHERE tinyServerID = @ServerID

	DELETE TblCurrentUser_Disconn
	WHERE ServerID = @ServerID

	DELETE TblCurrentUser
	WHERE tinyServerID = @ServerID

	SELECT 0 AS SUCCESS
Code:
ALTER PROC [dbo].[USPServer_End] @ServerID Tinyint
AS
	SET NOCOUNT ON
	
	DELETE TblCurrentUser_Temp
	WHERE tinyServerID = @ServerID

	DELETE TblCurrentUser_Disconn
	WHERE ServerID = @ServerID

	DELETE TblCurrentUser
	WHERE tinyServerID = @ServerID

	SELECT 0 AS SUCCESS
 
Last edited:
Newbie Spellweaver
Joined
Sep 24, 2008
Messages
16
Reaction score
0
But modify USPCheckBilling_Login SP in BillingDB (pay_gamemyth if you have it called that)

I dont even know where that thing are, but im still finding it right now.

and thanks for the info:blush:


yes the db are pay gamemyth


edit : yes, i found it . gonna change it now =D

i edit the thingy it doesnt stay there, it keep changing to normal.



another edit : i changed the code you send to me , when i try to login they said i didnt got an id
 
Last edited:
Newbie Spellweaver
Joined
Sep 24, 2008
Messages
16
Reaction score
0
BUMP

i changed the code you send to me , when i try to login they said i didnt got an id
 
Moooooooooooooooo
Loyal Member
Joined
Jul 19, 2006
Messages
442
Reaction score
130
BUMP

i changed the code you send to me , when i try to login they said i didnt got an id

You have to "execute" the codes in the appropriate databases. Have you done that?
 
Newbie Spellweaver
Joined
Sep 24, 2008
Messages
16
Reaction score
0
mine are 1753.

i put the codes inside pay_gamemyth.

they said i didnt got an id
 
MorbidA
Loyal Member
Joined
May 28, 2006
Messages
247
Reaction score
32
mine are 1753.

i put the codes inside pay_gamemyth.

they said i didnt got an id

well then check for the correct name on your table. Prolly ServerID instead of tinyServerID or tinyServerID instead of ServerID is possible you dont have the _Disconn table as well (have seen alot of db's with that one missing)

Just look at what the error tells you should be pretty easy to fix.
 
Newbie Spellweaver
Joined
Mar 10, 2012
Messages
10
Reaction score
0
i need help here also.. map crashed and played id stuck.. how to do it i dont know coz i got friend know but he at hospital now.. can help me??

this my USPCheckBilling Login
CREATE PROC dbo.USPCheckBilling_Login @strClientID varchar(20),@UID int,@Check int,@ClientIP varchar(15),@ServerID Tinyint
AS
SET NOCOUNT ON

DECLARE @FLAG INT
DECLARE @BillingType Char(2)
DECLARE @PlayTime INT
DECLARE @Crmindex INT

SET @FLAG = 1 --ERROR
SET @BillingType ='N'
SET @PlayTime = 0
SET @Crmindex = 0

--CHECKING
IF EXISTS (SELECT strClientID FROM UView_CurrentUser WHERE strClientID = @strClientID)
BEGIN

SELECT @FLAG,@BillingType,@PlayTime,@Crmindex

END
ELSE
BEGIN

INSERT TblCurrentUser_Temp (strClientID,UID,strIP,tinyServerID)
VALUES (@strClientID,@UID,@ClientIP,@ServerID)

IF @@ROWCOUNT <> 1
BEGIN
SELECT @FLAG,@BillingType,@PlayTime,@Crmindex
END
ELSE
BEGIN

SET @FLAG = 0 --SUCCESS

SELECT @FLAG,@BillingType,@PlayTime,@Crmindex
END

END
GO

this my UPSServer_Start
CREATE PROC USPServer_Start @ServerID Tinyint
AS
SET NOCOUNT ON

DELETE TblCurrentUser_Temp
WHERE tinyServerID = @ServerID

DELETE TblCurrentUser
WHERE tinyServerID = @ServerID

SELECT 0 AS SUCCESS
GO

And this UPSServer_End
CREATE PROC USPServer_End @ServerID Tinyint
AS
SET NOCOUNT ON

DELETE TblCurrentUser_Temp
WHERE tinyServerID = @ServerID

DELETE TblCurrentUser
WHERE tinyServerID = @ServerID

SELECT 0 AS SUCCESS
GO

Please help me. Im using Client 1753. already few times follow your guide but still fail.. help me please
 
Newbie Spellweaver
Joined
Sep 22, 2012
Messages
85
Reaction score
1
this topic must be usefull if someone create a newone, with a guide on how to run this query and fix the issue
 
Back
Top