Solved Reset levels query

[freddzor11]

Anyone who got a query that sets all players to level 8 with correct exp, hp and mana, not reset skills and items

Kind regards,

 

[Ninja]

UPDATE `players` SET `level` = 8, `experience` = 4200, `health` = 185, `healthmax` = 185, `mana` = 40, `manamax` = 40;

 

[freddzor11]

UPDATE `players` SET `level` = 8, `experience` = 4200, `health` = 185, `healthmax` = 185, `mana` = 40, `manamax` = 40;

isn't 35 mana ? but thank you!

 

[Ninja]

isn't 35 mana ? but thank you!

It's actually 40 nowadays, they changed it a while ago.

 

[freddzor11]

It's actually 40 nowadays, they changed it a while ago.

ah okey sorry then !

 

[Mark]

Don't forget about the cap too.

 

[freddzor11]

Don't forget about the cap too.

Yeah just thinked about that too, do you know the query with cap included?, Also set all players to temple pos (1000, 1000, 7)?

 

[Mark]

UPDATE `players` SET `level` = 8, `experience` = 4200, `health` = 185, `healthmax` = 185, `mana` = 40, `manamax` = 40, `manaspent` = 0, `cap` = 470, `posx` = 1000, `posy` = 1000, `posz` = 7;

 

[freddzor11]

UPDATE `players` SET `level` = 8, `experience` = 4200, `health` = 185, `healthmax` = 185, `mana` = 40, `manamax` = 40, `manaspent` = 0, `cap` = 470, `posx` = 1000, `posy` = 1000, `posz` = 7;

Thank you very much Mark! (Y)

 

[freddzor11]

btw... does this make that ML = 0?

 

[Ninja]

It does not, insert maglevel after posz in the query.

`posz` = 7, `maglevel` = 0;

 

[freddzor11]

It does not, insert maglevel after posz in the query.

`posz` = 7, `maglevel` = 0;

I don't want it to be 0 so that's good like it is, thank you!

 

[nemec]

UPDATE `players` SET `skill_fist` = 10, `skill_club` = 10, `skill_sword` = 10, `skill_axe` = 10, `skill_dist` = 10, `skill_shielding` = 10, `skill_fishing`= 10;