SQL Code: Reset Players to lvl 8.

[Chestnutz]

Hello OTLand,
Im not sure if im in the right spot, but i am looking for a sqlcode i cant seem to find.
I want the code to reset all players to lvl 8 with proper cap, hp/mp speed and exp count.

If you can help me, ++Rep


~Chestnutz

 

[Xellath]

Update all players:

UPDATE players SET level = 8, health = 185, healthmax = 185, experience = 4200, maglevel = 0, mana = 35, manamax = 35, manaspent = 0, soul = 100, posx = 1000, posy = 1000, posz = 7, cap = 440, skull = 0, skulltime = 0, stamina = 201660000, loss_experience = 100, loss_skills = 100, loss_items = 100, blessings = 0

UPDATE player_skills SET value = 10, count = 0

Update specific player:

UPDATE players SET level = 8, health = 185, healthmax = 185, experience = 4200, maglevel = 0, mana = 35, manamax = 35, manaspent = 0, soul = 100, posx = 1000, posy = 1000, posz = 7, cap = 440, skull = 0, skulltime = 0, stamina = 201660000, loss_experience = 100, loss_skills = 100, loss_items = 100, blessings = 0 WHERE id = GUID HERE!

UPDATE player_skills SET value = 10, count = 0 WHERE player_id = GUID HERE!

 

[Chestnutz]

i dont want to delete skills tho.. ;o

 

[Xellath]

Dont paste the last line then.