[Help] How do I wipe the Characters ONLY?

[Kenshinous]

I would like to wipe the characters on my server because my players voted to start afresh. So, how do I do it?

Thanks very much for those who help me solve this question. :)

[MentaL]

[Liselotte]

I think you should delete "Character" table in muonline database and make a new "Character" table again

[Kenshinous]

But I do not know how to make entries again :/ The columns and such. Is there any other easier way?

[Ragnaros]

Run under query ...

update dbo.character
set clevel=1
update dbo.character
set experience=0
update dbo.character
set leveluppoint=0 [ you can change it if you want ]
update dbo.character
set strength=25
where strength > 1
update dbo.character
set dexterity=25
where dexterity > 1
update dbo.character
set vitality=25
where vitality > 1
update dbo.character
set energy=25
where energy > 1
update dbo.character
set leadership=25
where leadership > 1
update dbo.character
set reset=0

you can custom these values by your own :)

[Kenshinous]

Wow, it works, thanks so much! :D

Oh by the way, can you include how to wipe the items too? ^^;

Thanks so much!

[LoveGod]

Wow, it works, thanks so much! :D

Oh by the way, can you include how to wipe the items too? ^^;

Thanks so much!

you can use czfeditor 1.5 for that

[Kenshinous]

Oh. Oh yeah. I remember theres a function on that. Thanks so much :D


My problem is solved. :D Thanks guys!