Most visitors online was 12720 , on 2 May 2024
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
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