Warlock pet spells SQL
________________________________________
Some time ago Blizz changed it so warlock pets gain their spells automatically as they level, and the spell ranks also go up automatically. In a recent arcemu revision they fixed it so that the spells would go up in rank as the pet (owner) levels but they still do not gain their new spells and the books to teach your pet spells dont work either. Ive looked and asked around but could not find a fix for this but i found a way to manually put the spells in.
1. Using heidi sql or navicat open up the "characters" table
2. Find your warlocks name or any with a 9 under the "class" column
3. once you found a warlock write down the number listed in the "guid" column
4. copy and paste this SQL (either in a new query or new text doc if you want to save it)
Code
INSERT INTO `playersummonspells` VALUES ('guid_goes_here', '1863', '7870');
INSERT INTO `playersummonspells` VALUES ('guid_goes_here', '1863', '6358');
INSERT INTO `playersummonspells` VALUES ('guid_goes_here', '1863', '6360');
INSERT INTO `playersummonspells` VALUES ('guid_goes_here', '1860', '17767');
INSERT INTO `playersummonspells` VALUES ('guid_goes_here', '1860', '17735');
INSERT INTO `playersummonspells` VALUES ('guid_goes_here', '17252', '33698');
INSERT INTO `playersummonspells` VALUES ('guid_goes_here', '17252', '30213');
INSERT INTO `playersummonspells` VALUES ('guid_goes_here', '17252', '30151');
INSERT INTO `playersummonspells` VALUES ('guid_goes_here', '417', '54424');
INSERT INTO `playersummonspells` VALUES ('guid_goes_here', '417', '54049');
INSERT INTO `playersummonspells` VALUES ('guid_goes_here', '417', '19244');
INSERT INTO `playersummonspells` VALUES ('guid_goes_here', '416', '6307');
INSERT INTO `playersummonspells` VALUES ('guid_goes_here', '416', '2947');
INSERT INTO `playersummonspells` VALUES ('guid_goes_here', '416', '4511');
5. Insert the guid number for your warlock (the one you wrote down from the characters table) where it says guid_goes_here.
6. Run that as a query in your database editor and your lock pets will now have all their spells available to them, yes the spells will gain rank as you level and no it doesnt matter if you dont have the pets yet.
If by chance there is a better fix for this, like say one you dont have to input everytime someone makes a warlock, then please ignore this and fill me in on the fix!!
