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!

Need Help with Mount-Save Issue

Initiate Mage
Joined
Jun 30, 2017
Messages
4
Reaction score
0
Hey, I am searching for an Mount-Save Fix.

Whenever I create a mount, it get deleted after I relog.

It would be great when someone would post a fix here =)
 
Initiate Mage
Joined
Jun 24, 2017
Messages
12
Reaction score
4
TGAME_GSP -> Functions

TSavePet
Code:
ALTER PROCEDURE [dbo].[TSavePet]@dwCharID INT,
@wPetID SMALLINT,
@szName VARCHAR(50), @[I][B][URL="http://forum.ragezone.com/members/2296.html"]time[/URL][/B][/I]Use SMALLDATETIME
AS
DECLARE @dwUserID INT


SET @dwUserID = (SELECT dwUserID FROM TCHARTABLE WHERE dwCharID = @dwCharID)


BEGIN TRAN TSAVEMOUNT
IF NOT EXISTS(SELECT TOP 1 @wPetID FROM TPETTABLE WHERE dwUserID = @dwUserID AND wPetID = @wPetID)
BEGIN
    INSERT INTO TPETTABLE(dwUserID, wPetID, szName, timeUse) 
    VALUES(@dwUserID, @wPetID, @szName, @[I][B][URL="http://forum.ragezone.com/members/2296.html"]time[/URL][/B][/I]Use)
END
ELSE
BEGIN
    UPDATE TPETTABLE SET
        szName = @szName, timeUse = @[I][B][URL="http://forum.ragezone.com/members/2296.html"]time[/URL][/B][/I]Use
    WHERE dwUserID = @dwUserID AND wPetID = @wPetID
END
COMMIT TRAN TSAVEMOUNT

TSaveCharDataEnd
Code:
ALTER PROCEDURE [dbo].[TSaveCharDataEnd]@dwCharID INTAS DECLARE @dwUserID INTSELECT @dwUserID = dwUserID FROM TCHARTABLE WHERE dwCharID = @dwCharID BEGIN TRAN SAVECHAREND DELETE TINVENTABLE WHERE dwCharID = @dwCharIDDELETE TCABINETTABLE WHERE dwCharID = @dwCharID/*DELETE TITEMTABLE WHERE dwOwnerID = @dwCharID AND bOwnerType = 0 AND bStorageType <> 2DELETE TSKILLTABLE WHERE dwCharID = @dwCharIDDELETE TSKILLMAINTAINTABLE WHERE dwCharID = @dwCharID*/DELETE TITEMUSEDTABLE WHERE dwCharID = @dwCharIDDELETE TEXPITEMTABLE WHERE dwCharID = @dwCharID/*DELETE TITEMTABLE WHERE dlID IN(SELECT dlID FROM TTEMPITEMTABLE WHERE dwOwnerID = @dwCharID)*/ INSERT INTO TINVENTABLE SELECT * FROM TTEMPINVENTABLE WHERE dwCharID = @dwCharIDINSERT INTO TCABINETTABLE SELECT * FROM TTEMPCABINETTABLE WHERE dwCharID = @dwCharID/*INSERT INTO TSKILLTABLE SELECT * FROM TTEMPSKILLTABLE WHERE dwCharID = @dwCharIDINSERT INTO TSKILLMAINTAINTABLE SELECT * FROM TTEMPSKILLMAINTAINTABLE WHERE dwCharID = @dwCharID*/INSERT INTO TITEMUSEDTABLE SELECT * FROM TTEMPITEMUSEDTABLE WHERE dwCharID = @dwCharIDINSERT INTO TEXPITEMTABLE SELECT * FROM TTEMPEXPITEMTABLE WHERE dwCharID = @dwCharID/*INSERT INTO TITEMTABLE(        dlID, bStorageType, dwStorageID, bOwnerType, dwOwnerID, bItemID, 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)        SELECT * FROM TTEMPITEMTABLE WHERE dwOwnerID = @dwCharID*/ COMMIT TRAN SAVECHAREND EXEC TGLOBAL_GSP.DBO.TSaveDuringItem @dwUserID

TLogout
Code:
/* LOGOUT PROCESS ========================================================PARAMETER========================================================@dwUserID               INT ========================================================RETURN VALUE========================================================0       : SUCCESS1       : NO USER ========================================================PROCESS========================================================1. Check TCURRENTUSER table2. Delete user from TCURRENTUSER3. Update log data */ ALTER PROCEDURE [dbo].[TLogout]        @dwUserID       INT,        @dwCharID       INTAS        DECLARE @nResult        INT        DECLARE @bLevel TINYINT        DECLARE @dwExp  INT        DECLARE @dwPlayTime INT        DECLARE @dwGold INT        DECLARE @dwSilver       INT        DECLARE @dwCooper       INT        DECLARE @[I][B][URL="http://forum.ragezone.com/members/2000234421.html"]bwo[/URL][/B][/I]rldID       TINYINT        DECLARE @dCurDate SMALLDATETIME        DECLARE @bSave TINYINT        DECLARE @[I][B][URL="http://forum.ragezone.com/members/2000135643.html"]Bin[/URL][/B][/I]ven TINYINT        DECLARE @bType1 TINYINT        DECLARE @wID1 SMALLINT        DECLARE @bType2 TINYINT        DECLARE @wID2 SMALLINT        DECLARE @bType3 TINYINT        DECLARE @wID3 SMALLINT        DECLARE @bType4 TINYINT        DECLARE @wID4 SMALLINT        DECLARE @bType5 TINYINT        DECLARE @wID5 SMALLINT        DECLARE @bType6 TINYINT        DECLARE @wID6 SMALLINT        DECLARE @bType7 TINYINT        DECLARE @wID7 SMALLINT        DECLARE @bType8 TINYINT        DECLARE @wID8 SMALLINT        DECLARE @bType9 TINYINT        DECLARE @wID9 SMALLINT        DECLARE @bType10 TINYINT        DECLARE @wID10 SMALLINT        DECLARE @bType11 TINYINT        DECLARE @wID11 SMALLINT        DECLARE @bType12 TINYINT        DECLARE @wID12 SMALLINT       IF(@bSave = 2)        INSERT INTO THOTKEYTABLE VALUES(@dwCharID, @[I][B][URL="http://forum.ragezone.com/members/2000135643.html"]Bin[/URL][/B][/I]ven, @bType1, @wID1, @bType2, @wID2, @bType3, @wID3, @bType4, @wID4,                                                 @bType5, @wID5, @bType6, @wID6, @bType7, @wID7, @bType8, @wID8, @bType9, @wID9,                                                 @bType10, @wID10, @bType11, @wID11, @bType12, @wID12)ELSE IF(@bSave = 3)        UPDATE THOTKEYTABLE SET bType1=@bType1, wID1=@wID1, bType2=@bType2, wID2=@wID2, bType3=@bType3, wID3=@wID3, bType4=@bType4, wID4=@wID4                                        , bType5=@bType5, wID5=@wID5, bType6=@bType6, wID6=@wID6, bType7=@bType7, wID7=@wID7, bType8=@bType8, wID8=@wID8                                        , bType9=@bType9, wID9=@wID9, bType10=@bType10, wID10=@wID10, bType11=@bType11, wID11=@wID11                                        , bType12=@bType12, wID12=@wID12 WHERE dwCharID = @dwCharID AND bInvenID = @[I][B][URL="http://forum.ragezone.com/members/2000135643.html"]Bin[/URL][/B][/I]venELSE        DELETE THOTKEYTABLE WHERE dwCharID=@dwCharID AND bInvenID = @[I][B][URL="http://forum.ragezone.com/members/2000135643.html"]Bin[/URL][/B][/I]ven          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 @[I][B][URL="http://forum.ragezone.com/members/2000234421.html"]bwo[/URL][/B][/I]rldID = bWorld+1 FROM TDBITEMINDEXTABLE                        EXEC TGLOBAL_GSP.dbo.TUpdateCharMoney @[I][B][URL="http://forum.ragezone.com/members/2000234421.html"]bwo[/URL][/B][/I]rldID, @dwCharID, @dwGold, @dwSilver, @dwCooper                END        END         EXEC TGLOBAL_GSP.DBO.TPcBangLogout @dwUserID, @dwPlayTime OUTPUT/*        IF(@dwGuildID <> 0 AND @dwPlayTime <> 0)        BEGIN                INSERT INTO TGUILDPLAYLOG(dwGuildID, dwUserID, dwCharID, dwPlayTime) VALUES(@dwGuildID, @dwUserID, @dwCharID, @dwPlayTime)                UPDATE TGUILDTABLE SET dwPlayTime = dwPlayTime + @dwPlayTime  WHERE dwID = @dwGuildID        END*/--      DELETE TITEMTABLE WHERE @dwCharID = dwOwnerID AND bOwnerType=0 AND wItemID = 7605 SELECT @dwUserID = dwUserID FROM TCHARTABLE WHERE dwCharID = @dwCharID BEGIN TRAN SAVECHAREND DELETE TITEMTABLE WHERE dwOwnerID = @dwCharID AND bOwnerType = 0 AND bStorageType <> 2DELETE TITEMTABLE WHERE dlID IN(SELECT dlID FROM TTEMPITEMTABLE WHERE dwOwnerID = @dwCharID) INSERT INTO TITEMTABLE(        dlID, bStorageType, dwStorageID, bOwnerType, dwOwnerID, bItemID, 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)        SELECT * FROM TTEMPITEMTABLE WHERE dwOwnerID = @dwCharID DELETE TSKILLTABLE WHERE dwCharID = @dwCharIDINSERT INTO TSKILLTABLE SELECT * FROM TTEMPSKILLTABLE WHERE dwCharID = @dwCharID   COMMIT TRAN SAVECHAREND EXEC TGLOBAL_GSP.DBO.TSaveDuringItem @dwUserID

TSaveSkillMaintain
Code:
ALTER PROCEDURE [dbo].[TSaveSkillMaintain]@dwCharID int,@wSkillID smallint,@bLevel smallint,@dwRemainTick int @[I][B][URL="http://forum.ragezone.com/members/1333356102.html"]Bat[/URL][/B][/I]tackType tinyint,@dwAttackID int,@bHostType tinyint,@dwHostID int @[I][B][URL="http://forum.ragezone.com/members/1333356102.html"]Bat[/URL][/B][/I]tackCountry tinyintASBEGIN TRAN TEMPSKILLMAINTAINIF NOT EXISTS( SELECT dwCharID FROM TSKILLMAINTAINTABLE WHERE dwCharID = @dwCharID AND wSkillID = @wSkillID)INSERT INTO TSKILLMAINTAINTABLE(        dwCharID,        wSkillID,        bLevel,        dwRemainTick,        bAttackType,        dwAttackID,        bHostType,        dwHostID,        bAttackCountry)  VALUES(        @dwCharID,        @wSkillID,        @bLevel,        @dwRemainTick,     @[I][B][URL="http://forum.ragezone.com/members/1333356102.html"]Bat[/URL][/B][/I]tackType,        @dwAttackID,        @bHostType,        @dwHostID,     @[I][B][URL="http://forum.ragezone.com/members/1333356102.html"]Bat[/URL][/B][/I]tackCountry)COMMIT TRAN TEMPSKILLMAINTAIN
 
Last edited:
Upvote 0
Initiate Mage
Joined
Jul 20, 2017
Messages
2
Reaction score
0
TSavePet is works to copy it, but others are giving me error-cannot to save them. Anyone who would fix it ? It looks like that is is write in a bad format.
 
Upvote 0
Back
Top