|
   |
| Модератор форума: Dimitro |
| Форум ArcEmu ArcEmu Апдейт для варлок пета |
| Апдейт для варлок пета |
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. 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!!
Помогаю ставить сервера Trinity, Mangos,ArcEmu.
Сообщение # 1 написано 05.09.2010 в 13:50
|
| |||
| |||