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

freaked1

Active Member
Joined
Jan 30, 2008
Messages
486
Solutions
5
Reaction score
28
Location
Sweden
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 :)
 
Top