Sql code for wipe items,resets & stats

[=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

 

[Sartigan]

Re: [HELP] Sql code for wipe items,resets & stats

i think its possible with CzF editor

 

[oggyss]

Re: [HELP] 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

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

 

[=Ady=]

Re: [HELP] Sql code for wipe items,resets & stats

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

 

[oggyss]

Re: [HELP] Sql code for wipe items,resets & stats

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'

 

[=Ady=]

Re: [HELP] Sql code for wipe items,resets & stats

thanks man