• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Reset players and skills

I

ikul

Banned User
Joined
Jul 31, 2009
Messages
22
Reaction score
0
hiho i need sql query to reset players levels and skills. i have seen this long time ago but now i cant find it.
 
Code: 
UPDATE `players` SET `level` = 8, `maglevel` = 0, `experience` = 0, `health` = 185, `healthmax` = 185, `mana` = 35, `manamax` = 35, `conditions` = NULL, `soul` = 100, `cap` = 400, `posx` = 0, `posy` = 0, `posz` = 0, `town_id` = 1, `lastlogin` = 0, `lastip` = 0, `skull` = 0, `skulltime` = 0, `rank_id` = 0, `blessings` = 0;

Code: 
UPDATE `player_skills` SET `value` = 10, `count` = 0;
 
Back
Top