Warrior Stances SQL Query

[toxic11b]

Here is a small query that I made for my server that will start all warriors off with there stances . This script is really meant for instant 70 funservers but it could be used for a blizzlike. Enjoy

INSERT INTO `playercreateinfo_spells` VALUES('1','71');
INSERT INTO `playercreateinfo_spells` VALUES('1','2458');
INSERT INTO `playercreateinfo_spells` VALUES('1','20611');
INSERT INTO `playercreateinfo_spells` VALUES('2','71');
INSERT INTO `playercreateinfo_spells` VALUES('2','2458');
INSERT INTO `playercreateinfo_spells` VALUES('2','20611');
INSERT INTO `playercreateinfo_spells` VALUES('3','71');
 
INSERT INTO `playercreateinfo_spells` VALUES('3','2458');
INSERT INTO `playercreateinfo_spells` VALUES('3','20611');
INSERT INTO `playercreateinfo_spells` VALUES('4','71');
INSERT INTO `playercreateinfo_spells` VALUES('4','2458');
INSERT INTO `playercreateinfo_spells` VALUES('4','20611');
INSERT INTO `playercreateinfo_spells` VALUES('5','71');
INSERT INTO `playercreateinfo_spells` VALUES('5','2458');
INSERT INTO `playercreateinfo_spells` VALUES('5','20611');
INSERT INTO `playercreateinfo_spells` VALUES('6','71');
INSERT INTO `playercreateinfo_spells` VALUES('6','2458');
INSERT INTO `playercreateinfo_spells` VALUES('6','20611');
INSERT INTO `playercreateinfo_spells` VALUES('7','71');
INSERT INTO `playercreateinfo_spells` VALUES('7','2458');
INSERT INTO `playercreateinfo_spells` VALUES('7','20611');
INSERT INTO `playercreateinfo_spells` VALUES('8','71');
INSERT INTO `playercreateinfo_spells` VALUES('8','2458');
INSERT INTO `playercreateinfo_spells` VALUES('8','20611');
INSERT INTO `playercreateinfo_spells` VALUES('44','71');
INSERT INTO `playercreateinfo_spells` VALUES('44','2458');
INSERT INTO `playercreateinfo_spells` VALUES('44','20611');

Here is another for Druids stances . =D

INSERT INTO `playercreateinfo_spells` VALUES('42','40120'); 
INSERT INTO `playercreateinfo_spells` VALUES('42','33943');
INSERT INTO `playercreateinfo_spells` VALUES('42','24858');
INSERT INTO `playercreateinfo_spells` VALUES('42','9634');
INSERT INTO `playercreateinfo_spells` VALUES('42','783');
INSERT INTO `playercreateinfo_spells` VALUES('42','768');
INSERT INTO `playercreateinfo_spells` VALUES('42','5487');
INSERT INTO `playercreateinfo_spells` VALUES('42','1066');
INSERT INTO `playercreateinfo_spells` VALUES('42','33891');
INSERT INTO `playercreateinfo_spells` VALUES('43','40120'); 
INSERT INTO `playercreateinfo_spells` VALUES('43','33943');
INSERT INTO `playercreateinfo_spells` VALUES('43','24858');
INSERT INTO `playercreateinfo_spells` VALUES('43','9634');
INSERT INTO `playercreateinfo_spells` VALUES('43','783');
INSERT INTO `playercreateinfo_spells` VALUES('43','768');
INSERT INTO `playercreateinfo_spells` VALUES('43','5487');
INSERT INTO `playercreateinfo_spells` VALUES('43','1066');
INSERT INTO `playercreateinfo_spells` VALUES('43','33891');

[Dryice]

Good Job, +rep

[Illidan1]

Great going toxic11b

[toxic11b]

Yah sorry they posted wrong in the code box. I will update it here in a few with all of the common missing talents .

These are the common missing talents people can not train on my server so I am going to start them off with these to decrease the amount of tickets for the GM's . I figured it would help someone else also. But I will upload a SQL that will install all of it here within a hour or so .


Warrior

MS Rank 6
Intercept
Stances

Druid
Stances

Warlock
Pets
Mounts

Paladin
Redemption
Hammer of Justice
Mounts

[Pwntzyou]

Sweet post man... very nice