Advertisement
Guest User

13123123

a guest
Aug 26th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.86 KB | None | 0 0
  1. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `AIName`, `ScriptName`, `VerifiedBuild`) VALUES('180204','8','299','Uther\'s Tomb Statue','','','','0','0','1','0','0','0','0','0','0','1323','10','0','1','0','0','-1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','','-18019');
  2. UPDATE `conditions` SET `SourceGroup`='2' WHERE  `SourceTypeOrReferenceId`=13 AND `SourceGroup`=7 AND `SourceEntry`=30098 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=31 AND `ConditionTarget`=0 AND `ConditionValue1`=3 AND `ConditionValue2`=45418 AND `ConditionValue3`=0;
  3. UPDATE `conditions` SET `SourceGroup`='1' WHERE  `SourceTypeOrReferenceId`=13 AND `SourceGroup`=7 AND `SourceEntry`=30098 AND `SourceId`=0 AND `ElseGroup`=1 AND `ConditionTypeOrReference`=31 AND `ConditionTarget`=0 AND `ConditionValue1`=5 AND `ConditionValue2`=181653 AND `ConditionValue3`=0;
  4.  
  5. SET @CENTRY := 45418; /* trigger entry */
  6.  
  7. DELETE FROM `smart_scripts` WHERE (source_type = 0 AND entryorguid = @CENTRY);
  8. 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
  9. (@CENTRY, 0, 0, 0, 8, 0, 100, 0, 30098, 0, 60000, 60000, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defile Uther\'s Tomb Trigger - On Spellhit \'Defile Uther\'s Tomb\' - Set Event Phase 2'),
  10. (@CENTRY, 0, 1, 2, 1, 2, 100, 0, 5000, 5000, 5000, 5000, 1, 4, 10000, 0, 0, 0, 0, 9, 17233, 0, 200, 0, 0, 0, 0, 'Defile Uther\'s Tomb Trigger - Out of Combat - Say Line 4 (Phase 2)'),
  11. (@CENTRY, 0, 2, 0, 61, 2, 100, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defile Uther\'s Tomb Trigger - Out of Combat - Set Event Phase 0 (Phase 2)'),
  12. (@CENTRY, 0, 3, 0, 52, 0, 100, 0, 4, 17233, 0, 0, 1, 5, 10000, 0, 0, 0, 0, 9, 17233, 0, 200, 0, 0, 0, 0, 'Defile Uther\'s Tomb Trigger - On Text 4 Over - Say Line 5'),
  13. (@CENTRY, 0, 4, 0, 52, 0, 100, 0, 5, 17233, 0, 0, 1, 6, 10000, 0, 0, 0, 0, 9, 17233, 0, 200, 0, 0, 0, 0, 'Defile Uther\'s Tomb Trigger - On Text 5 Over - Say Line 6'),
  14. (@CENTRY, 0, 5, 0, 52, 0, 100, 0, 6, 17233, 0, 0, 1, 7, 10000, 0, 0, 0, 0, 9, 17233, 0, 200, 0, 0, 0, 0, 'Defile Uther\'s Tomb Trigger - On Text 6 Over - Say Line 7'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement