Advertisement
Guest User

Untitled

a guest
May 23rd, 2017
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.95 KB | None | 0 0
  1. DELETE FROM `creature` WHERE `guid`=2200003;
  2.  
  3. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
  4. (2200003, 32540, 571, 1, 1, 0, 0, 7440, -2878.25, 822.55, 2.191, 30, 3, 0, 50400, 0, 0, 0);
  5.  
  6. DELETE FROM `creature_questrelation` WHERE `id`= 32540 AND `quest`=13559;
  7. INSERT INTO `creature_questrelation` (`id` , `quest`)VALUES ('32540', '13559');
  8.  
  9. UPDATE `quest_template` SET `SpecialFlags` = '1' WHERE `entry` =13559;
  10.  
  11. UPDATE `quest_template` SET `NextQuestId` = '13559', `ExclusiveGroup` = '12870' WHERE `entry` IN (12870, 12882);
  12.  
  13.  
  14. -- UPDATE `quest_template` SET `NextQuestId` = '0', `ExclusiveGroup` = '0' WHERE `entry` IN (12870, 12882);
  15.  
  16. -- UPDATE `world`.`quest_template` SET `PrevQuestId` = '12870' WHERE `quest_template`.`entry` =13559;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement