Race/Class ID INFO here

[wefwef123]

HI there, i Need a little help creating a .sql to add plate and mail skills to new players.

I have a nice script to do it already that contains lots of entries like:

INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 15, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 16, 293, 400,400);

The trouble is it gives plate and mail skills to EVERYONE even mages.

How do I identify which indexID refers to warriors and paladin etc?
I know the indexIDs for races (human=1 orc=2 etc)
And I know the indexIDs for classes (warrior=1 mage=8 etc)
But in this script the indexIDs start at 1 and go to like 56!
How do I know which ones to cut out so that only classes that are supposed to have plate and mail have it?

Heres a link to the file
HI there, i Need a little help creating a .sql to add plate and mail skills to new players.

I have a nice script to do it already that contains lots of entries like:

INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 15, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 16, 293, 400,400);

The trouble is it gives plate and mail skills to EVERYONE even mages.

How do I identify which indexID refers to warriors and paladin etc?
I know the indexIDs for races (human=1 orc=2 etc)
And I know the indexIDs for classes (warrior=1 mage=8 etc)
But in this script the indexIDs start at 1 and go to like 56!
How do I know which ones to cut out so that only classes that are supposed to have plate and mail have it?




Thanks in advance

I need 3 posts to be able to

Post a link so heres the 3 and....

Here the link to the file with every class getting plate and mail skill.
Which ones do I delete to only allow those that SHOULD be able to wear plate and mail to get the skill on creation. THANKS


http://www.alterna-uo.net/wow/pands.sql.zip

[wefwef123]

Anyone? before it drops off the page? I wanted to fix this tonight

[doublehex]

enum Classes { WARRIOR = 1, PALADIN = 2, HUNTER = 3, ROGUE = 4, PRIEST = 5, SHAMAN = 7, MAGE = 8, WARLOCK = 9, DRUID = 11, }; enum Races { RACE_HUMAN = 1, RACE_ORC = 2, RACE_DWARF = 3, RACE_NIGHTELF = 4, RACE_UNDEAD = 5, RACE_TAUREN = 6, RACE_GNOME = 7, RACE_TROLL = 8, RACE_BLOODELF = 10, RACE_DRAENEI = 11, };

[wefwef123]

Yeah i know those but look at that script
whats 39? 55? whats 46?

[b!atch]

you can use snailz generator
http://www.mmowned.com/forums/progra...tml#post833369

[TheSpidey]

The numbers refer directly to the playercreateinfo table. Use it with the enums Doublehex posted, and if you want to grind some rep, post them here too

[wefwef123]

ahhhah! Thanks I will do that

[wefwef123]

here you go, happy to give back to a great forum
(and for a shameless plug for my server LOL)

http://www.alterna-uo.net/wow/raceclasses.html

[xtavie]

ty i needed this too

[wefwef123]

Heres the script to give everyone who is supposed to be able to wear mail/plate the mail and/or plate skill on creation:
Thanks to all that helped with info
----------------------------------------------------
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 1, 293, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 1, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 2, 293, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 2, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 3, 293, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 3, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 4, 293, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 4, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 5, 293, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 5, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 6, 293, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 6, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 7, 293, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 7, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 8, 293, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 8, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 9, 293, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 9, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 10, 293, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 10, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 11, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 12, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 15, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 16, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 17, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 30, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 31, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 32, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 44, 293, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 44, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 45, 293, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 45, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 46, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 48, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 50, 293, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 50, 413, 400,400);
INSERT INTO playercreateinfo_skills ( indexid, skillid, level, maxlevel )VALUES ( 51, 413, 400,400);
--------------------------------------------------------------------------------------------
cut and paste that into notepad and call it whatever.sql
Then from Navicat choose FUN database and then execute sql query and find the file you made