• 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!

[sql query] RESET

Yaze

Well-Known Member
Joined
Sep 15, 2014
Messages
382
Reaction score
61
Hello i would like to reset the DB,
I want the players to lose their skills ,lvls ,stoarges and get the same skills like the samples,
they should only keep their items.

So is there someone who could help me with the SQL query?



Regards,
 
Code:
UPDATE `players` SET `level` = 8, `experience` = 4200, `health` = 185, `healthmax` = 185, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `cap` = 470, `skull` = 0, `skulltime` = 0, `blessings` = 0, `stamina` = 151200000, `online` = 0, `promotion` = 0;DELETE FROM `player_storage`, `player_items`, `player_depotitems`, `tile_items`, `house_lists`, `house_data`, `house_auctions`, `houses`;UPDATE `player_skills` SET `value` = 10, `count` = 0;
This resets everything including houses and items :)
 
Back
Top