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

Player lvl reset

GOD Wille

GOD Wille

Excellent OT User
Joined
Jan 11, 2010
Messages
2,826
Solutions
2
Reaction score
815
Location
Sweden
How to do a mysql query all players will get lvl 8 with start mana/health but they'll keep their items?
 
Sort by date Sort by votes
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`;
UPDATE `player_skills` SET `value` = 10, `count` = 0;
 
Upvote 0 Downvote
Back
Top