Advertisement
bucur35

Untitled

Nov 25th, 2012
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.71 KB | None | 0 0
  1. UPDATE `quest_template` SET `RequiredNpcOrGo3`=19009 WHERE  `Id`=10078;
  2.  
  3. DELETE FROM `creature` WHERE  `guid`=68321;
  4. INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `curhealth`) VALUES
  5. (68321, 19009, 530, -183.948, 2773.39, 49.1984, 5.95157, 300, 42);
  6.  
  7. DELETE FROM `smart_scripts` WHERE  `entryorguid`=19009 AND `source_type`=0 AND `id`=0 AND `link`=0;
  8. INSERT INTO `smart_scripts` (`entryorguid`, `event_type`, `event_param1`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `target_type`, `comment`) VALUES
  9. (19009, 8, 32979, 60000, 60000, 11, 34386, 1, 'Invis Horde Siege Engine - West - On Spellhit - Cast Create Hellfire Fire');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement