- Joined
- Jan 9, 2005
- Messages
- 669
- Reaction score
- 83
Hi anyone knows how to modify this one that i can add corresponding amount like let say 25 credits will be added on their game-credits per reset on this auto-reset script:
or somekind of like this(pseudocode)
IF character reseted, add leveluppoints 350 * number of resets - 10,000,000 zen money, warp back in lorencia, PK count and time = 0 resets = resets plus 1 and credits = credits + 25
like the sql script will add up credits at the same time the character reseted. i would like to do it myself but im not knowledgeably capable with sql. =c cuz i wanna make use of their reset as a game credit to purchase in Muweb(by themad)
please help =c
P.S: if this is something can help with my problem here is the path of the credits in the database.
MuOnline > MEMB_CREDITS(Tables are : memb___Id and Credits
thank you so much in advance and i msorry if i can't explain it in great detail (english is not good
):?:
Code:
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 350 * (Resets + 1), Money = Money - (100000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (clevel >= 400) AND (Money >= (100000000)) AND (ConnectStat = 0) ;
or somekind of like this(pseudocode)
IF character reseted, add leveluppoints 350 * number of resets - 10,000,000 zen money, warp back in lorencia, PK count and time = 0 resets = resets plus 1 and credits = credits + 25
like the sql script will add up credits at the same time the character reseted. i would like to do it myself but im not knowledgeably capable with sql. =c cuz i wanna make use of their reset as a game credit to purchase in Muweb(by themad)
please help =c
P.S: if this is something can help with my problem here is the path of the credits in the database.
MuOnline > MEMB_CREDITS(Tables are : memb___Id and Credits
thank you so much in advance and i msorry if i can't explain it in great detail (english is not good