Advertisement
_Stuff_

Don't be Shellfish (Quest=25219)

Apr 12th, 2020
870
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.50 KB | None | 0 0
  1. UPDATE `creature_template` SET `npcflag` = 16777216 WHERE `entry` = 39422;
  2.  
  3. DELETE FROM npc_spellclick_spells WHERE npc_entry = 39422;
  4. INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`) VALUES
  5. (39422, 74489, 2);
  6.  
  7. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`= 18 AND `ConditionTypeOrReference` = 9 AND `SourceGroup` = 39422 AND `SourceEntry` = 74489;
  8. INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`, `ErrorType`, `ErrorTextId`,`ScriptName`,`Comment`) VALUES
  9. (18, 39422, 74489, 0, 0, 9, 0, 25219, 0, 0, 0, 0, 0, '', 'On SpellClick Event - Only if quest accepted');
  10.  
  11. UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 39422;
  12. DELETE FROM `smart_scripts` WHERE entryorguid = 39422 AND source_type = 0;
  13. 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
  14. (39422, 0, 0, 0, 73, 0, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Coilshell Sifter - On SpellClick - Force Despawn');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement