Query to set all starting skills to 375

[Sorayazlawl]

Could I get some help designing a simple query to do the following:

If #<375 in the columns level or maxlevel in the playercreateinfo_skills table, alter them to 375.

That's what I'm looking for, and im sure it's possible, but not quite sure exactly how to do that. Help would be greatly appreciated!

[Power of Illuminati]

UPDATE playercreateinfo_skills SET level = '375' WHERE level < '375';
UPDATE playercreateinfo_skills SET maxlevel = '375' WHERE maxlevel < '375';

Tested and Working

[Sorayazlawl]

Thanks! +rep if I can!

[wefwef123]

That will let everyone wear plate and mail armor even mages wont it?

[Sorayazlawl]

No.. armor skills are different ID's. And it only makes the current ones 375, not add a bunch of new ones.

[wefwef123]

Armor skills are in playercreateinfo_skills thats how my script is giving everyone plate and mail skill
My problem is how to identity the race/class IDs so I can only give it to warriors, Paladins etc