Initiate Mage
- Joined
- Dec 8, 2008
- Messages
- 81
- Reaction score
- 8
I dont know if this has been shared before..
I just want to share it maybe sum1 doesnt have this..
This is very usefull for those who have High Reborn already,
We all know that the max StatRemain is 65k
Beyond that the stats will be lost when Reset..
So it came up to my mind to have manually reset stat not all..
For Example ResetPow, ResetDex, ResetInt, ResetVit..
Original Code by: sir phoenix717
Recode by me
Heres the code
Paste this to your Trigger where you have pasted Amend Add stats by sir phoenix717
Paste the code before the word "end" w/o quotations..
The Amendd Commands for Reseting manually
This requires 0 gold to execute...
Credits:
phoenix717
My player F3ng for the idea
I just want to share it maybe sum1 doesnt have this..
This is very usefull for those who have High Reborn already,
We all know that the max StatRemain is 65k
Beyond that the stats will be lost when Reset..
So it came up to my mind to have manually reset stat not all..
For Example ResetPow, ResetDex, ResetInt, ResetVit..
Original Code by: sir phoenix717
Recode by me
Heres the code
Paste this to your Trigger where you have pasted Amend Add stats by sir phoenix717
Paste the code before the word "end" w/o quotations..
Code:
UPDATE ChaInfo SET [ChaInfo].ChaGuName='RESETPOWFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain+([ChaInfo].ChaPower),
[ChaInfo].ChaPower=0,
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(([ChaInfo].ChaPower)*0)
From Inserted
WHERE Inserted.ChaGuName='RESETPOW'
and [ChaInfo].ChaMoney>=(([ChaInfo].ChaPower)*0)
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum
UPDATE ChaInfo SET [ChaInfo].ChaGuName='RESETVITFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain+([ChaInfo].ChaStrong),
[ChaInfo].ChaStrong=0,
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(([ChaInfo].ChaStrong)*0)
From Inserted
WHERE Inserted.ChaGuName='RESETVIT'
and [ChaInfo].ChaMoney>=(([ChaInfo].ChaStrong)*0)
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum
UPDATE ChaInfo SET [ChaInfo].ChaGuName='RESETDEXFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain+([ChaInfo].ChaDex),
[ChaInfo].ChaDex=0,
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(([ChaInfo].ChaDex)*0)
From Inserted
WHERE Inserted.ChaGuName='RESETDEX'
and [ChaInfo].ChaMoney>=(([ChaInfo].ChaDex)*0)
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum
UPDATE ChaInfo SET [ChaInfo].ChaGuName='RESETINTFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain+([ChaInfo].ChaSpirit),
[ChaInfo].ChaSpirit=0,
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(([ChaInfo].ChaSpirit)*0)
From Inserted
WHERE Inserted.ChaGuName='RESETINT'
and [ChaInfo].ChaMoney>=(([ChaInfo].ChaSpirit)*0)
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum
The Amendd Commands for Reseting manually
Code:
Just type
RESETPOW
RESETDEX
RESETINT
RESETVIT
then recon..
This requires 0 gold to execute...
Credits:
phoenix717
My player F3ng for the idea