How to make character reset on phpmyadmin

[Marilyekon]

Hello dear otlanders!
I'm trying to reset my server without deleting the database. I think there is a command or query to do that, but i don't know wich one it is. A query there items, levels and skills get reseted could also be nice.
Rep+++

 

[Acubens]

http://img155.imageshack.us/f/dibujoyz.jpg/

 

[Nottinghster]

//Account
UPDATE accounts SET premend=0;

//Players
UPDATE players SET level = 1 WHERE group_id = 1;
UPDATE players SET experience = 0 WHERE group_id = 1;
UPDATE players SET maglevel = 0 WHERE group_id = 1;
UPDATE players SET health = 150 WHERE group_id = 1;
UPDATE players SET healthmax = 150 WHERE group_id = 1;
UPDATE players SET mana = 0 WHERE group_id = 1;
UPDATE players SET manamax = 0 WHERE group_id = 1;
UPDATE players SET manaspent = 0 WHERE group_id = 1;
UPDATE players SET redskulltime = 0 WHERE group_id = 1;
UPDATE players SET soul = 100 WHERE group_id = 1;
UPDATE players SET town_id = 11 WHERE group_id = 1;
UPDATE players SET cap = 400 WHERE group_id = 1;
UPDATE players SET vocation = 0 WHERE group_id = 1;
UPDATE players SET posx = 32097, posy = 32219, posz = 7 WHERE group_id = 1;
UPDATE players SET lastlogin=0 WHERE group_id = 1;
UPDATE players SET lastlogout=0 WHERE group_id = 1;
UPDATE players SET rank_id=0 WHERE group_id = 1;
UPDATE players SET lastip=0 WHERE group_id = 1;
UPDATE players SET looktype = 128 WHERE looktype = 0;
UPDATE players SET looktype = 128 WHERE sex = 0;
UPDATE players SET looktype = 136 WHERE sex = 1;
UPDATE players SET guildnick = '' WHERE group_id = 1;

//Skills
UPDATE player_skills SET value=10, count=0 WHERE skillid=0;
UPDATE player_skills SET value=10, count=0 WHERE skillid=1;
UPDATE player_skills SET value=10, count=0 WHERE skillid=2;
UPDATE player_skills SET value=10, count=0 WHERE skillid=3;
UPDATE player_skills SET value=10, count=0 WHERE skillid=4;
UPDATE player_skills SET value=10, count=0 WHERE skillid=5;
UPDATE player_skills SET value=10, count=0 WHERE skillid=6;

 

[Acubens]

//Account
UPDATE accounts SET premend=0;

//Players
UPDATE players SET level = 1 WHERE group_id = 1;
UPDATE players SET experience = 0 WHERE group_id = 1;
UPDATE players SET maglevel = 0 WHERE group_id = 1;
UPDATE players SET health = 150 WHERE group_id = 1;
UPDATE players SET healthmax = 150 WHERE group_id = 1;
UPDATE players SET mana = 0 WHERE group_id = 1;
UPDATE players SET manamax = 0 WHERE group_id = 1;
UPDATE players SET manaspent = 0 WHERE group_id = 1;
UPDATE players SET redskulltime = 0 WHERE group_id = 1;
UPDATE players SET soul = 100 WHERE group_id = 1;
UPDATE players SET town_id = 11 WHERE group_id = 1;
UPDATE players SET cap = 400 WHERE group_id = 1;
UPDATE players SET vocation = 0 WHERE group_id = 1;
UPDATE players SET posx = 32097, posy = 32219, posz = 7 WHERE group_id = 1;
UPDATE players SET lastlogin=0 WHERE group_id = 1;
UPDATE players SET lastlogout=0 WHERE group_id = 1;
UPDATE players SET rank_id=0 WHERE group_id = 1;
UPDATE players SET lastip=0 WHERE group_id = 1;
UPDATE players SET looktype = 128 WHERE looktype = 0;
UPDATE players SET looktype = 128 WHERE sex = 0;
UPDATE players SET looktype = 136 WHERE sex = 1;
UPDATE players SET guildnick = '' WHERE group_id = 1;

//Skills
UPDATE player_skills SET value=10, count=0 WHERE skillid=0;
UPDATE player_skills SET value=10, count=0 WHERE skillid=1;
UPDATE player_skills SET value=10, count=0 WHERE skillid=2;
UPDATE player_skills SET value=10, count=0 WHERE skillid=3;
UPDATE player_skills SET value=10, count=0 WHERE skillid=4;
UPDATE player_skills SET value=10, count=0 WHERE skillid=5;
UPDATE player_skills SET value=10, count=0 WHERE skillid=6;

He need clean all (depot_items, storages, houses and others) to start again.

Dont use this.