Hey friends,
Can someone give me mssql script for reset char like this:
First reset=20 mil
Second Reset=40 mil
and ...etc
till 60 reset after that to be all 1 billion= 1.000.000.000
:)
Hey friends,
Can someone give me mssql script for reset char like this:
First reset=20 mil
Second Reset=40 mil
and ...etc
till 60 reset after that to be all 1 billion= 1.000.000.000
:)
Shore here you go...
*Resets you must creat in MuOnline db, Character table Resets row.UPDATE Character
SET inventory = null ,
clevel=1 ,
Experience = '0' ,
Resets = Resets+1 ,
Strength= '26',
Dexterity= '26' ,
Vitality= '26',
Energy= '26',
MapNumber= '0',
MapPosX= '125',
MapPosY= '125',
Money = Money - (20000000 + 4000000 * Resets)
WHERE cLevel='350'
AND Money>=20000000 + 4000000 * Resets