Sql code for wipe items,resets & stats

Anyone can post a sql code for deleting all items, resets and stats

If it can quest for bk, sm,elf, too

Without deleting accounts and characters

Thx

i think its possible with CzF editor

Quote:

---

Originally Posted by =Ady=

Anyone can post a sql code for deleting all items, resets and stats

If it can quest for bk, sm,elf, too

Without deleting accounts and characters

Thx

---

use muonline
UPDATE dbo.Character
SET inventory = null ,
clevel=1,
Experience = '0',
LevelUpPoint= '0',
Strength= '26',
Dexterity= '26',
Vitality= '26',
Energy= '26'

use muonline
UPDATE dbo.Warehouse
SET items= null

thx guys, and for 2nd/3rd class back to 1st ?

use muonline
UPDATE dbo.Character
SET class='0' where class='1' or class='2'
UPDATE dbo.Character
SET class='16' where class='17' or class='18'
UPDATE dbo.Character
SET class='32' where class='33' or class='34'
UPDATE dbo.Character
SET class='48' where class='49'
UPDATE dbo.Character
SET class='64' where class='65'

thanks man