[Question]How to fix Bug (Delete all items on Login to game and Logout)

[Score8]

In game:
Logout:
Help me please.
Thanks.

[AncientCompiler]

Tlogout function ---> TGAME

[iJirkusCZ]

It´s Five files, which have exploit

[AncientCompiler]

Simply replace Tlogout in TGAME with this code:

/*
========================================================
-------------Worked by 4Story UnrealReality-------------
========================================================
*/

/* LOGOUT PROCESS

========================================================
PARAMETER
========================================================
@dwUserID		INT

========================================================
RETURN VALUE
========================================================
0	: SUCCESS
1	: NO USER

========================================================
PROCESS
========================================================
1. Check TCURRENTUSER table
2. Delete user from TCURRENTUSER
3. Update log data

*/

ALTER PROCEDURE [dbo].[TLogout]
	@dwUserID	INT,
	@dwCharID	INT
AS
	DECLARE @nResult	INT
	DECLARE @bLevel	TINYINT
	DECLARE @dwExp	INT
	DECLARE @dwPlayTime INT
	DECLARE @dwGold	INT
	DECLARE @dwSilver	INT
	DECLARE @dwCooper	INT
	DECLARE @bWorldID	TINYINT
	DECLARE @dCurDate SMALLDATETIME

	SET @bLevel = 0
	SET @dwExp = 0
	SET @dwGold = 0
	SET @dwSilver = 0
	SET @dwCooper = 0
	SET @dCurDate = GetDate()

	IF(@dwCharID <> 0)
	BEGIN
		SELECT @bLevel = bLevel, @dwExp = dwEXP, @dwGold=dwGold, @dwSilver=dwSilver, @dwCooper=dwCooper FROM TCHARTABLE WHERE dwCharID = @dwCharID

		EXEC TUpdateActiveChar @dwCharID

		UPDATE TCHARTABLE SET dLogoutDate = @dCurDate WHERE dwCharID=@dwCharID

		EXEC @nResult = TGLOBAL_GSP.dbo.TLogout @dwUserID, @dwCharID, @bLevel, @dwExp
		IF(@nResult = 0)
		BEGIN
			SELECT @bWorldID = bWorld+1 FROM TDBITEMINDEXTABLE
			EXEC TGLOBAL_GSP.dbo.TUpdateCharMoney @bWorldID, @dwCharID, @dwGold, @dwSilver, @dwCooper
		END

		
	END

EXEC TGLOBAL_GSP.DBO.TPcBangLogout @dwUserID, @dwPlayTime OUTPUT

SELECT @dwUserID = dwUserID FROM TCHARTABLE WHERE dwCharID = @dwCharID
 
EXEC TGLOBAL_GSP.DBO.TSaveDuringItem @dwUserID
DELETE FROM [TGAME_GSP].[dbo].[TITEMTABLE] where wItemID = '2200';
RETURN @nResult

If still not working it`s in your item functions!

[iJirkusCZ]

It won´t work, it is in services

[Score8]

iSuicideBomber - I'm going to try it

Dont work

[AncientCompiler]

Then watch over the item functions, or the source code.

[iJirkusCZ]

He don´t have the source code lol

[Score8]

Jirkus - Problem services or everything in the database?

[Sicarium]

Services and db.All items are deleted because there are duplicated dlID. I made a fix for this problem but I don't release it more.only few guys have it. Good luck

[iJirkusCZ]

Nope, It´s my files, where are comment-outed save function and much more functions lol

[julianjl]

I have make a duplication fix but I don't give it, it's not difficult to do

[NightProfit]

I have the fix too
If u need still help PM me on epvp