Lua Urgent and Important! PhpMyAdmin

[Vrotz]

Hello guys,

Im being necessary reset the level and skill of the players of my server and my server is enforced.

Then, by example, Im going to put all players to level 130.

Ok, Ok! Im going to put this command:

UPDATE players SET level = 130, experience = 34963300

Alright, now comes the problem.. I need reset just the players Druids and Sorcerers for the ML 65 and the paladins and knights for the skill 100. If I put the command for Skill 10 or 0, all the vocations will be reached and be put I for skill 100, druids and sorcerer also will be reached. There is some way of add/remove attributes for specific vocations? It stayed clear or necessary express me better?

Thanks.

 

[Loney]

UPDATE players SET maglevel=65 WHERE vocation=1;
UPDATE players SET maglevel=65 WHERE vocation=2;
UPDATE players SET maglevel=65 WHERE vocation=5;
UPDATE players SET maglevel=65 WHERE vocation=6;

 

[Vrotz]

For knight and paladins, how i put the command? I need add skill 100/100 just ek and rp.

Thanks.

 

[Vrotz]

Bump

 

[Vrotz]

Bump

 

[Xon vanetta]

UPDATE players SET Skill_distance=100 WHERE vocation=7;

This is for vocation 7 only and i think that is RP not sure since im in school and cant check all the tables right now...

and vocation 8 is for elite knight's

i will update the query once i get home.