Most visitors online was 8830 , on 6 Feb 2024
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!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
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
/* 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
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