image

Mindless Ghoul test

Dec 6th, 2011
273
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.85 KB | None | 0 0
  1. -- Mindless Ghoul
  2. UPDATE creature_template SET `modelid2` = "25000", `modelid3` = "10630", `faction_A` = "1801", `faction_H` = "1801" WHERE entry=27556;
  3.  
  4. DELETE FROM creature_ai_texts WHERE entry IN (-1300, -1301, -1302, -1303, -1304);
  5. INSERT INTO creature_ai_texts (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`)
  6. VALUES
  7. ('-1300', 'Give... me... book...', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '27556'),
  8. ('-1301', 'Join us...', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '27556'),
  9. ('-1302', 'Only ruin awaits...', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '27556'),
  10. ('-1303', 'Thel\'zan will have you...', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '27556'),
  11. ('-1304', 'Tome not yours...', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '27556');
  12.  
  13.  
  14. UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '27556';
  15. DELETE FROM `creature_ai_scripts` WHERE `creature_id` = '27556';
  16. INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
  17. ('2755600', '27556', '11', '0', '15', '0', '0', '0', '0', '0', '1', '-1300', '-1301', '-1302', '1', '-1303', '-1304', '0', '0', '0', '0', '0', 'Mindless Ghoul - Random Say on Spawn');
  18.  
  19. -- Shadow of Thel'zan the Duskbringer
  20. UPDATE creature_template SET `modelid3` = "0", `faction_A` = "1975", `faction_H` = "1975", `unit_flags` = "33600" WHERE entry=27510;
Advertisement
Add Comment
Please, Sign In to add comment