Can someone give me a job which reset stats after reset, please? ;] Thanks.
Printable View
Can someone give me a job which reset stats after reset, please? ;] Thanks.
by ur administrator cp i think?
UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=350+350*Reset, Reset=Reset+1,
Strength=('30'), Dexterity=('30'), Vitality=('30'),Energy=('30'), Inventory=null, MagicList=null
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE clevel>349 AND Memb_Stat.ConnectStat = 0 and Vip = 0 and Money>('0')
Customize red words as your preferences.
*MagicList and Inventory=null means it will reset inventory and magic list.
Isn't this an auto reset script?
yes, it is.
I want just to reset stats after reset and add 350 bonus points [350xResets]. I can fix bonus points from my site, but there is no option for reseting stats.