[DEV] Help us to solve the mounts bug

[eedouardu44]

Hi,
I create this post only for the purpose of development. This bug affects the mounts . I've found a few tips:

1- The bug is in these functions, "TChangedPetToMount" and "TChangedPetSystemToMountSystem" ( TGAME --> dbo --> fonctions )

2- And then they come in "TPETTABLE" ( TGAME --> dbo --> tables )


Notes :

I just tried to change the table but it does not work. So the problem is just on these functions.


Previews of original fonctions (not fixed):

TChangedPetToMount:

 Spoiler

ALTER PROCEDURE TChangedPetToMount
@dwUserID	INT,
@wPetID		SMALLINT,
@wSaddleItemID	SMALLINT,
@wAddItemID	SMALLINT
AS
-- PETTABLE Changed

DECLARE @dEndTime	SMALLDATETIME

SELECT @dEndTime = timeUse FROM TPETTABLE WHERE dwUserID = @dwUserID AND wPetID = @wPetID
IF(@@ROWCOUNT > 0)
BEGIN
	INSERT TGLOBAL_GSP.DBO.TCASHITEMCABINETTABLE(
		dwUserID, wItemID, bLevel, bCount, bGLevel, dwDuraMax, dwDuraCur, bRefineCur, dEndTime,bGradeEffect,
		bMagic1, bMagic2, bMagic3, bMagic4, bMagic5, bMagic6,
		wValue1, wValue2, wValue3, wValue4, wValue5, wValue6,
		dwTime1, dwTime2, dwTime3, dwTime4, dwTime5, dwTime6)
	VALUES( @dwUserID, @wSaddleItemID, 0, 1, 0, 0, 0, 0, @dEndTime, 0, 
		0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

	IF(@wAddItemID != 0)
	BEGIN
		INSERT TGLOBAL_GSP.DBO.TCASHITEMCABINETTABLE(
			dwUserID, wItemID, bLevel, bCount, bGLevel, dwDuraMax, dwDuraCur, bRefineCur, dEndTime,bGradeEffect,
			bMagic1, bMagic2, bMagic3, bMagic4, bMagic5, bMagic6,
			wValue1, wValue2, wValue3, wValue4, wValue5, wValue6,
			dwTime1, dwTime2, dwTime3, dwTime4, dwTime5, dwTime6)
		VALUES( @dwUserID, @wAddItemID, 0, 1, 0, 0, 0, 0, @dEndTime, 0, 
			0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
	END
END

TChangedPetSystemToMountSystem:

 Spoiler

 
ALTER PROCEDURE [dbo].[TChangedPetSystemToMountSystem]
@dwUserID	INT
AS

DECLARE @wCount	SMALLINT

--ItemChanged
SET @wCount = 0
SELECT @wCount = COUNT(dlID) FROM TITEMTABLE WHERE dwOwnerID IN(SELECT dwCharID FROM TCHARTABLE WHERE dwUserID = @dwUserID) AND bOwnerType = 0 AND wItemID IN(7549,7550,7551,7552,7553,7554,7555,7556,7557)
SELECT @wCount = @wCount + COUNT(dlID) FROM TGLOBAL_GSP.DBO.TCASHITEMCABINETTABLE WHERE dwUserID = @dwUserID AND wItemID IN(7549,7550,7551,7552,7553,7554,7555,7556,7557)

IF(@wCount > 0)
BEGIN
	EXEC TChangedMountItem @dwUserID, 7549, 7709, 7559
	EXEC TChangedMountItem @dwUserID, 7550, 7709, 7560
	EXEC TChangedMountItem @dwUserID, 7551, 7709, 7561
	EXEC TChangedMountItem @dwUserID, 7552, 7530, 7562
	EXEC TChangedMountItem @dwUserID, 7553, 7539, 7563
	EXEC TChangedMountItem @dwUserID, 7554, 7548, 7564
	EXEC TChangedMountItem @dwUserID, 7555, 7518, 7565
	EXEC TChangedMountItem @dwUserID, 7556, 7709, 7566
	EXEC TChangedMountItem @dwUserID, 7557, 7558, 7567
END

--PetChanged
SET @wCount = 0
SELECT @wCount = COUNT(wPetID) FROM TPETTABLE WHERE dwUserID = @dwUserID
IF(@wCount > 0)
BEGIN	
	EXEC TChangedPetToMount @dwUserID, 1, 7501, 0
	EXEC TChangedPetToMount @dwUserID, 4, 7501, 0
	EXEC TChangedPetToMount @dwUserID, 7, 7501, 0
	EXEC TChangedPetToMount @dwUserID, 10, 7501, 0
	EXEC TChangedPetToMount @dwUserID, 102, 7501, 0
	EXEC TChangedPetToMount @dwUserID, 81, 7501, 0
	EXEC TChangedPetToMount @dwUserID, 2, 7502, 0
	EXEC TChangedPetToMount @dwUserID, 5, 7502, 0
	EXEC TChangedPetToMount @dwUserID, 8, 7502, 0
	EXEC TChangedPetToMount @dwUserID, 11, 7502, 0
	EXEC TChangedPetToMount @dwUserID, 103, 7502, 0
	EXEC TChangedPetToMount @dwUserID, 3, 7503, 0
	EXEC TChangedPetToMount @dwUserID, 6, 7503, 0
	EXEC TChangedPetToMount @dwUserID, 9, 7503, 0
	EXEC TChangedPetToMount @dwUserID, 12, 7503, 0
	EXEC TChangedPetToMount @dwUserID, 13, 7709, 7559
	EXEC TChangedPetToMount @dwUserID, 14, 7709, 7560
	EXEC TChangedPetToMount @dwUserID, 15, 7709, 7561
	EXEC TChangedPetToMount @dwUserID, 16, 7518, 7565
	EXEC TChangedPetToMount @dwUserID, 17, 7709, 7566

	DELETE TPETTABLE WHERE dwUserID = @dwUserID
END

Thanks for reading.

[stotterer09]

I know a bypass for this problem but no solution

[AncientCompiler]

Originally Posted by stotterer09

I know a bypass for this problem but no solution

i need the bypass!!! Pls send me a link to it

[Andrejpica]

stotterer09 can u show your bypass? maybe help to solve it.

[eedouardu44]

Originally Posted by stotterer09

I know a bypass for this problem but no solution

Can you send me your "bypass" ? I will try to change the bypass in fonction.
Thanks

[RedSwag]

Please man, release your bypass