image

FoS misc.

Jan 27th, 2012
435
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 4.37 KB | None | 0 0
  1. -- FORGE OF SOULS
  2. -- SOULGUARD BONECASTER
  3. UPDATE `creature` SET `currentwaypoint`='1', `MovementType`='2' WHERE `guid`='161187';
  4. DELETE FROM `creature_movement` WHERE `id`='161187';
  5. INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`)
  6. VALUES
  7. ('161187', '1', '5021.49', '2141.48', '643.733', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.88342', '0', '0'),
  8. ('161187', '2', '5041.05', '2131.49', '649.661', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.83237', '0', '0');
  9.  
  10.  
  11. -- SOULGUARD WATCHMAN - 1st BRIDGE
  12. UPDATE `creature` SET `MovementType`='2' WHERE `guid`='161193';
  13. DELETE FROM `creature_movement` WHERE `id`='161193';
  14. INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`)
  15. VALUES
  16. ('161193', '1', '5215.62', '2189.98', '653.54', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.05148', '0', '0'),
  17. ('161193', '2', '5202.51', '2258.22', '664.075', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.79601', '0', '0');
  18.  
  19. DELETE FROM `creature_linking_template` WHERE `master_guid`='161193';
  20. INSERT INTO `creature_linking_template` () VALUES
  21. ('161194', '161193', '4096');
  22.  
  23. -- SOULGUARD BONECASTER
  24. UPDATE `creature` SET `currentwaypoint`='1', `MovementType`='2' WHERE `guid`='161198';
  25. DELETE FROM `creature_movement` WHERE `id`='161198';
  26. INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`)
  27. VALUES
  28. ('161198', '1', '5141.28', '2286.72', '665.429', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.07289', '0', '0'),
  29. ('161198', '2', '5150.05', '2302.89', '665.429', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.05325', '0', '0'),
  30. ('161198', '3', '5137.45', '2312.2', '666.131', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.50231', '0', '0'),
  31. ('161198', '4', '5151.33', '2304.73', '665.429', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.80491', '0', '0');
  32.  
  33.  
  34. -- SOULGUARD WATCHMAN - BEFORE BOSS
  35. UPDATE `creature` SET `MovementType`='2' WHERE `guid`='161209';
  36. DELETE FROM `creature_movement` WHERE `id`='161209';
  37. INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`)
  38. VALUES
  39. ('161209', '1', '5251.87', '2482.11', '677.96', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.13017', '0', '0'),
  40. ('161209', '2', '5250.18', '2518.31', '677.96', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.56839', '0', '0');
  41.  
  42. DELETE FROM `creature_linking_template` WHERE `master_guid`='161209';
  43. INSERT INTO `creature_linking_template` () VALUES
  44. ('161208', '161209', '4096');
  45.  
  46. -- SOULGUARD WATCHMAN - AFTER BOSS
  47. UPDATE `creature` SET `MovementType`='2' WHERE `guid`='161217';
  48. DELETE FROM `creature_movement` WHERE `id`='161217';
  49. INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`)
  50. VALUES
  51. ('161217', '1', '5345.78', '2448.05', '686.64', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.63964', '0', '0'),
  52. ('161217', '2', '5378.66', '2432.45', '691.936', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.84014', '0', '0');
  53.  
  54. DELETE FROM `creature_linking_template` WHERE `master_guid`='161217';
  55. INSERT INTO `creature_linking_template` () VALUES
  56. ('161218', '161217', '4096');
  57.  
  58.  
  59. -- SPECTRAL WARDEN - THEY WILL NOW BE SEEN ON EVERY REALM;)
  60. UPDATE `creature` SET `realmspawn`='0' WHERE `id`='36666';
  61.  
  62.  
  63. -- EQUIP TEMPLATE - BOOHO :P
  64. DELETE FROM `creature_equip_template` WHERE `entry` IN ('1985', '2140', '1987', '2141', '2142');
  65. INSERT INTO `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`)
  66. VALUES
  67. ('1985', '52011', '0', '0'),
  68. ('1987', '49654', '0', '0'),
  69. ('2140', '49363', '0', '0'),
  70. ('2141', '52010', '0', '0'),
  71. ('2142', '49709', '0', '0');
Advertisement
Add Comment
Please, Sign In to add comment