[Fix] Behemoth to Storage Ticket

06/29/2013 15:43 Konst™#1
Hello,

At first i wana say, its not the fix of Simcarium!
I made this fix by myself and because he deleted his i will release my.

Idk if other Summon scrolls are bugging to storage ticket too so tell me if yes, i will edit the code.

Code:
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, 7549, 7549
    EXEC TChangedMountItem @dwUserID, 7550, 7550, 7550
    EXEC TChangedMountItem @dwUserID, 7551, 7551, 7551
    EXEC TChangedMountItem @dwUserID, 7552, 7552, 7552
    EXEC TChangedMountItem @dwUserID, 7553, 7553, 7553
    EXEC TChangedMountItem @dwUserID, 7554, 7554, 7554
    EXEC TChangedMountItem @dwUserID, 7555, 7555, 7555
    EXEC TChangedMountItem @dwUserID, 7556, 7556, 7556
    EXEC TChangedMountItem @dwUserID, 7557, 7557, 7557
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


END
Just put it in the TChangePetSystemToMountSystem (TGAME_GSP.dbo.Functions)

Best Regards, Konst
06/29/2013 16:32 Weom#2
Useless, you can change the name of this function and this "bug" was fixed ;).
06/29/2013 17:38 *Wayne*#3
vorallem hab ich das auch schon public gestellt
06/30/2013 18:17 randleman#4
The complete function isnt needed.
I deleted all functions about mounts cause just the petfunctions are needed.:cool: