Advertisement
Guest User

Untitled

a guest
Feb 5th, 2014
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.61 KB | None | 0 0
  1. DELETE FROM `gossip_menu_option` where `menu_id`=524;
  2. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`) VALUES
  3. (524, 0, 0, 'Give me some E.C.A.C.!', 1, 1, 0, 0, 0, 0, '');
  4.  
  5. DELETE FROM locales_gossip_menu_option WHERE `menu_id`=524;
  6. Insert into `locales_gossip_menu_option` (menu_id, id, option_text_loc3) VALUES
  7. (524, 0, 'Gebt mir E.C.A.C.!');
  8.  
  9. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=524;
  10. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  11. (15, 524, 0, 0, 0, 9, 0, 2381, 0, 0, 0, 0, 0, '', 'Show gossip option 0 if player has Quest 2381');
  12.  
  13. DELETE FROM `smart_scripts` WHERE `entryorguid`=7166;
  14. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  15. (7166, 0, 0, 0, 62, 0, 100, 0, 524, 0, 0, 0, 56, 7970, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Wrenix\'s Gizmotronic Apparatus - On Gossip Option 0 Selected - Add Item \'E.C.A.C.\' 1 Time');
  16.  
  17. DELETE FROM `smart_scripts` WHERE `entryorguid`=7167;
  18. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  19. (7167, 0, 0, 0, 1, 0, 100, 0, 73000, 73000, 60000, 60000, 11, 8822, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Polly - Out of Combat - Cast \'Stealth\' (Phase 1) (No Repeat)'),
  20. (7167, 0, 1, 0, 8, 0, 100, 1, 9976, 0, 0, 0, 36, 7168, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Polly - On Spellhit \'Polly Eats the E.C.A.C.\' - Update Template To \'Polly\'');
  21.  
  22. UPDATE `creature_template` SET `lootid`=0 WHERE `entry`=7167;
  23. UPDATE `creature_template` SET `lootid`=7167 WHERE `entry`=7168;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement