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

03/28/2015 15:15 Score8#1
In game: [Only registered and activated users can see links. Click Here To Register...]
Logout: [Only registered and activated users can see links. Click Here To Register...]
Help me please.
Thanks.
03/28/2015 15:21 AncientCompiler#2
Tlogout function ---> TGAME
03/28/2015 15:24 iJirkusCZ#3
Itīs Five files, which have exploit :D :D :D :D
03/28/2015 17:28 AncientCompiler#4
Simply replace Tlogout in TGAME with this code:

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!
03/28/2015 17:46 iJirkusCZ#5
It wonīt work, it is in services
03/28/2015 19:18 Score8#6
iSuicideBomber - I'm going to try it

Dont work
03/28/2015 19:28 AncientCompiler#7
Then watch over the item functions, or the source code.
03/28/2015 19:59 iJirkusCZ#8
He donīt have the source code lol
03/28/2015 20:22 Score8#9
Jirkus - Problem services or everything in the database?
03/29/2015 10:44 Sicarium#10
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
03/29/2015 11:04 iJirkusCZ#11
Nope, Itīs my files, where are comment-outed save function and much more functions lol
03/29/2015 12:12 julianjl#12
I have make a duplication fix but I don't give it, it's not difficult to do :)
04/04/2015 02:38 NightProfit#13
I have the fix too ;)
If u need still help PM me on epvp ;)