API tools faq
paste
Advertisement
Guest User

wallker

a guest
Jul 1st, 2010
222
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.24 KB | None | 0 0
raw download clone embed print report
  1. UPDATE `mangos`.`gameobject_template` SET `data1` = 5165 WHERE `entry` IN (176158, 176159, 176160, 176161);
  2.  
  3. UPDATE `mangos`.`creature_template` SET `unit_flags` = 0 WHERE `entry` = 19055;
  4.  
  5. UPDATE `mangos`.`quest_template` SET `ReqCreatureOrGOId1` = 21050, `ReqCreatureOrGOId2` = 21061 WHERE `entry` = 10458;
  6.  
  7. DELETE FROM `mangos`.`quest_start_scripts` WHERE `id`=5944;
  8. INSERT INTO `mangos`.`quest_start_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`,`dataint`, `x`, `y`, `z`, `o`) VALUES
  9. (5944, 0, 3, 0, 6000, 0, 0, 0, '0', 2932.488281, -1409.700195, 165.943878, 4.243466),
  10. (5944, 6, 3, 0, 4000, 0, 0, 0, '0', 2948.319580, -1417.525757, 165.943878, 0.976210),
  11. (5944, 10, 3, 0, 6000, 0, 0, 0, '0', 2956.389648, -1401.879883, 160.842102, 1.097946),
  12. (5944, 16, 3, 0, 4000, 0, 0, 0, '0', 2946.727051, -1396.390991, 160.842102, 1.127771),
  13. (5944, 20, 3, 0, 5000, 0, 0, 0, '0', 2953.245117, -1382.865234, 155.949188, 2.627882),
  14. (5944, 25, 3, 0, 4000, 0, 0, 0, '0', 2943.695801, -1377.817993, 152.020370, 2.655371),
  15. (5944, 29, 3, 0, 7000, 0, 0, 0, '0', 2936.438477, -1392.422241, 152.020370, 4.257582),
  16. (5944, 36, 3, 0, 7000, 0, 0, 0, '0', 2959.562500, -1404.895386, 152.020370, 5.794590),
  17. (5944, 43, 3, 0, 5000, 0, 0, 0, '0', 2954.494141, -1415.392944, 152.020370, 4.226063),
  18. (5944, 48, 3, 0, 7000, 0, 0, 0, '0', 2935.236816, -1406.175415, 150.521713, 4.230774),
  19. (5944, 55, 3, 0, 15000, 0, 0, 0, '0', 2913.166016, -1448.402588, 148.671951, 4.230774),
  20. (5944, 70, 3, 0, 17000, 0, 0, 0, '0', 2863.102051, -1443.235229, 145.797180, 3.039184),
  21. (5944, 87, 3, 0, 15000, 0, 0, 0, '0', 2833.429199, -1473.628296, 146.323318,3.957290),
  22. (5944, 102, 3, 0, 15000, 0, 0, 0, '0', 2802.712402, -1509.083252, 145.035156,3.980853),
  23. (5944, 117, 3, 0, 20000, 0, 0, 0, '0', 2757.023438, -1567.095825, 132.174072, 4.075918),
  24. (5944, 137, 3, 0, 10000, 0, 0, 0, '0', 2779.359863, -1615.095337, 128.984818, 5.175468),
  25. (5944, 147, 3, 0, 20000, 0, 0, 0, '0', 2749.197754, -1650.254028, 126.900162, 4.043682),
  26. (5944, 167, 3, 0, 20000, 0, 0, 0, '0', 2711.982910, -1700.045532, 125.666725, 4.071981),
  27. (5944, 187, 7, 5944, 20, 0, 0, 0, '0', 0, 0, 0, 0),
  28. (5944, 188, 3, 0, 1000, 0, 0, 0, '0', 2942.58, -1390.09, 167.421, 4.2586);
  29. UPDATE `mangos`.`quest_template` SET `StartScript` = 5944 WHERE `entry` = 5944;
  30. DELETE FROM `mangos`.`quest_template` WHERE `entry` = 5944;
  31. INSERT INTO `mangos`.`quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`,`RewArenaPoints`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (5944, 2, 28, 0, 52, 60, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 2, 0, 0, 0, 5862, 0, 0, 0, 7, 0, 0, 0, 'In Dreams', 'For so long, I have been a puppet of the Grand Crusader. What reason was there to fight against what the Scarlet Crusade had become? It has been decades, yet the memories of my father; those precious memories, they are what have kept me alive.$B$BI have dreams, stranger. In these dreams my father is with me. He stands proudly at my side as I am inducted into the Order. We battle legion of Scourge, side by side. We bring honor to the Alliance, to Lordaeron.$B$BI want not to dream anymore.$B$BTake me to him.', 'Escort Taelan Fordring out of Hearthglen.', 'The death of my son at the hands of these monsters will not pass without incident. Take solace in knowing that the Order is reborn.$b$bI now take my place as Highlord of the new Order of the Silver Hand.$b$bThese possessions of my past - they are all that I have to offer for all that you have done. Please, take these as a symbol of my gratitude; all have served me well over the years.$b$bMay we meet again, in better times, and reminisce of days long past... battles hard fought... dreams redeemed.', '<Tirion regains his composure.>', 'Redemption?', 'Return to Tirion Fordring at Throndroril River in Eastern Plaguelands.', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15411, 15413, 15418, 15421, 16058, 0, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 85800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 5944, 0);
  32.  
  33. DELETE FROM `mangos`.`gameobject` WHERE (`guid`=99891);
  34. INSERT INTO `mangos`.`gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (99891, 300034, 0, 1, 1, 1384.44, -1515.28, 59.12, 0, 0, 0, 0, 0, 180, 0, 1);
  35.  
  36. DELETE FROM `mangos`.`creature_movement` WHERE `id`=63614;
  37.  
  38. UPDATE `mangos`.`gameobject` SET `spawntimesecs` = 300 WHERE `guid` = 27091;
  39.  
  40. DELETE FROM `mangos`.`quest_start_scripts` WHERE `id`=2845;
  41. INSERT INTO `mangos`.`quest_start_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`,`dataint`, `x`, `y`, `z`, `o`) VALUES
  42. (2845, 0, 3, 0, 6000, 0, 0, 0, '0', -2848.540283, 2794.602295, 94.396042, 2.030877),
  43. (2845, 6, 3, 0, 4000, 0, 0, 0, '0', -2852.013184, 2800.857666, 95.633316, 2.042658),
  44. (2845, 10, 3, 0, 8000, 0, 0, 0, '0', -2853.765381, 2822.716553, 96.957283, 1.84376),
  45. (2845, 18, 3, 0, 4000, 0, 0, 0, '0', -2858.803223, 2832.161865, 97.404694, 2.890098),
  46. (2845, 22, 3, 0, 8000, 0, 0, 0, '0', -2889.912354, 2826.144287, 83.733757, 4.704368),
  47. (2845, 30, 3, 0, 8000, 0, 0, 0, '0', -2893.885254, 2795.213867, 78.509018, 4.657245),
  48. (2845, 38, 3, 0, 6000, 0, 0, 0, '0', -2887.243164, 2776.087158, 76.019371, 4.998898),
  49. (2845, 44, 3, 0, 4000, 0, 0, 0, '0', -2893.027344, 2769.934570, 77.699562, 3.997651),
  50. (2845, 48, 3, 0, 6000, 0, 0, 0, '0', -2897.383301, 2756.649170, 76.718895, 4.784616),
  51. (2845, 54, 3, 0, 4000, 0, 0, 0, '0', -2896.787598, 2746.498291, 73.987198, 4.472818),
  52. (2845, 58, 3, 0, 14000, 0, 0, 0, '0', -2932.530762, 2704.434814, 72.987793, 4.091114),
  53. (2845, 72, 3, 0, 6000, 0, 0, 0, '0', -2948.024658, 2687.618896, 68.600891, 3.966006),
  54. (2845, 78, 3, 0, 8000, 0, 0, 0, '0', -2965.716553, 2670.848633, 62.069168, 3.954225),
  55. (2845, 86, 3, 0, 22000, 0, 0, 0, '0', -3002.102539, 2617.917969, 51.042591, 4.130938),
  56. (2845, 108, 3, 0, 14000, 0, 0, 0, '0', -3020.807861, 2582.144287, 37.578850, 4.131720),
  57. (2845, 122, 7, 2845, 20, 0, 0, 0, '0', 0, 0, 0, 0),
  58. (2845, 123, 3, 0, 1000, 0, 0, 0, '0', -2843.75, 2785.17, 94.4791, 3.21141);
  59. UPDATE `mangos`.`quest_template` SET `StartScript` = 2845 WHERE `entry` = 2845;
  60.  
  61. DELETE FROM `mangos`.`gameobject_loot_template` WHERE (`entry`=26877);
  62. INSERT INTO `mangos`.`gameobject_loot_template` VALUES
  63. (26877, 45058, -100, 1, 1, 1, 0, 0, 0);
  64.  
  65. DELETE FROM `mangos`.`gameobject_template` WHERE (`entry`=177673);
  66. INSERT INTO `mangos`.`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`, `mingold`, `maxgold`, `ScriptName`) VALUES (177673, 1, 4853, 'Serpent Statue', '', '', '', 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 1299, 3000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  67. DELETE FROM `mangos`.`gameobject_scripts` WHERE `id`=177673;
  68. INSERT INTO `mangos`.`gameobject_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`,`dataint`, `x`, `y`, `z`, `o`) VALUES
  69. (12609, 2, 10, 12369, 300000, 0, 0, 0, '0', 251.381, 2962.47, 2.76527, 0.860446);
  70.  
  71. DELETE FROM `scriptdev2`.`script_waypoint` WHERE entry=1379;
  72. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','1','-5751.12','-3441.01','301.743','0','');
  73. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','2','-5738.58','-3485.14','302.41','0','');
  74. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','3','-5721.62','-3507.85','304.011','0','');
  75. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','4','-5710.21','-3527.97','304.708','0','');
  76. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','5','-5706.92','-3542.89','304.871','0','');
  77. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','6','-5701.53','-3551.24','305.962','0','');
  78. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','7','-5699.53','-3555.69','306.505','0','');
  79. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','8','-5690.56','-3571.98','309.035','0','');
  80. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','9','-5678.61','-3587.17','310.607','0','');
  81. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','10','-5677.05','-3594.35','311.527','0','');
  82. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','11','-5674.39','-3605.19','312.239','0','');
  83. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','12','-5674.45','-3614.39','312.337','0','');
  84. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','13','-5673.05','-3630.56','311.105','0','');
  85. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','14','-5680.34','-3645.44','315.185','0','');
  86. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','15','-5684.46','-3650.05','314.687','0','');
  87. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','16','-5693.9','-3674.14','313.03','0','');
  88. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','17','-5701.43','-3712.54','313.959','0','');
  89. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','18','-5698.79','-3720.88','316.943','0','');
  90. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','19','-5699.95','-3733.63','318.597','0','Protecting the Shipment - Ambush');
  91. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','20','-5698.61','-3754.74','322.047','0','');
  92. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','21','-5688.68','-3769','323.957','0','');
  93. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','22','-5688.14','-3782.65','322.667','0','');
  94. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','23','-5699.23','-3792.65','322.448','30000','Protecting the Shipment - End');
  95. INSERT INTO `scriptdev2`.`script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES('1379','24','-5700.8','-3792.78','322.588','0','');
  96.  
  97. DELETE FROM `mangos`.`quest_start_scripts` WHERE `id`=12321;
  98. INSERT INTO `mangos`.`quest_start_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`,`dataint`, `x`, `y`, `z`, `o`) VALUES
  99. (12321, 0, 3, 0, 2000, 0, 0, 0, 0, 3801.641602, -678.555298, 213.75914, 4.303207),
  100. (12321, 2, 3, 0, 2000, 0, 0, 0, 0, 3800.594238, -681.045776, 213.75914, 4.342479),
  101. (12321, 4, 0, 0, 27316, 10, 0, 0x02, '2000000139', 0, 0, 0, 0),
  102. (12321, 4, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  103. (12321, 8, 0, 0, 27316, 10, 0, 0x02, '2000000140', 0, 0, 0, 0),
  104. (12321, 8, 1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  105. (12321, 11, 1, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  106. (12321, 12, 0, 2, 27577, 10, 0, 0x02, '2000000141', 0, 0, 0, 0),
  107. (12321, 12, 16, 409, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  108. (12321, 14, 0, 0, 27316, 10, 0, 0x02, '2000000142', 0, 0, 0, 0),
  109. (12321, 14, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  110. (12321, 16, 1, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  111. (12321, 17, 0, 0, 27316, 10, 0, 0x02, '2000000143', 0, 0, 0, 0),
  112. (12321, 17, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  113. (12321, 18, 1, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  114. (12321, 20, 1, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  115. (12321, 22, 0, 2, 27577, 10, 0, 0x02, '2000000144', 0, 0, 0, 0),
  116. (12321, 22, 16, 412, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  117. (12321, 24, 0, 0, 27577, 10, 0, 0x02, '2000000145', 0, 0, 0, 0),
  118. (12321, 28, 0, 0, 27577, 10, 0, 0x02, '2000000146', 0, 0, 0, 0),
  119. (12321, 32, 0, 0, 27577, 10, 0, 0x02, '2000000147', 0, 0, 0, 0),
  120. (12321, 35, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  121. (12321, 36, 0, 0, 27316, 10, 0, 0x02, '2000000148', 0, 0, 0, 0),
  122. (12321, 40, 0, 0, 27316, 10, 0, 0x02, '2000000149', 0, 0, 0, 0),
  123. (12321, 40, 1, 16, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  124. (12321, 44, 0, 0, 27316, 10, 0, 0x02, '2000000150', 0, 0, 0, 0),
  125. (12321, 44, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  126. (12321, 48, 0, 0, 27316, 10, 0, 0x02, '2000000151', 0, 0, 0, 0),
  127. (12321, 52, 0, 0, 27316, 10, 0, 0x02, '2000000152', 0, 0, 0, 0),
  128. (12321, 53, 15, 15237, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  129. (12321, 53, 1, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  130. (12321, 56, 0, 0, 27316, 10, 0, 0x02, '2000000153', 0, 0, 0, 0),
  131. (12321, 60, 0, 0, 27316, 10, 0, 0x02, '2000000154', 0, 0, 0, 0),
  132. (12321, 61, 15, 15237, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  133. (12321, 61, 1, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  134. (12321, 64, 0, 0, 27577, 10, 0, 0x02, '2000000155', 0, 0, 0, 0),
  135. (12321, 68, 0, 0, 27577, 10, 0, 0x02, '2000000156', 0, 0, 0, 0),
  136. (12321, 72, 0, 0, 27316, 10, 0, 0x02, '2000000157', 0, 0, 0, 0),
  137. (12321, 73, 15, 15237, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  138. (12321, 73, 1, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  139. (12321, 76, 0, 0, 27577, 10, 0, 0x02, '2000000158', 0, 0, 0, 0),
  140. (12321, 80, 0, 0, 27316, 10, 0, 0x02, '2000000159', 0, 0, 0, 0),
  141. (12321, 80, 1, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  142. (12321, 84, 0, 0, 27577, 10, 0, 0x02, '2000000160', 0, 0, 0, 0),
  143. (12321, 88, 0, 0, 27316, 10, 0, 0x02, '2000000161', 0, 0, 0, 0),
  144. (12321, 88, 1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  145. (12321, 90, 1, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  146. (12321, 92, 1, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  147. (12321, 93, 0, 0, 27577, 10, 0, 0x02, '2000000162', 0, 0, 0, 0),
  148. (12321, 96, 0, 0, 27577, 10, 0, 0x02, '2000000163', 0, 0, 0, 0),
  149. (12321, 100, 0, 0, 27316, 10, 0, 0x02, '2000000164', 0, 0, 0, 0),
  150. (12321, 100, 1, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  151. (12321, 103, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  152. (12321, 104, 0, 0, 27577, 10, 0, 0x02, '2000000165', 0, 0, 0, 0),
  153. (12321, 108, 0, 0, 27577, 10, 0, 0x02, '2000000166', 0, 0, 0, 0),
  154. (12321, 112, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  155. (12321, 112, 0, 0, 27316, 10, 0, 0x02, '2000000167', 0, 0, 0, 0),
  156. (12321, 115, 3, 0, 2000, 0, 0, 0, 0, 3801.641602, -678.555298, 213.75914, 1.271553),
  157. (12321, 116, 0, 0, 27316, 10, 0, 0x02, '2000000168', 0, 0, 0, 0),
  158. (12321, 116, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  159. (12321, 119, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  160. (12321, 120, 0, 0, 27316, 10, 0, 0x02, '2000000169', 0, 0, 0, 0),
  161. (12321, 120, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  162. (12321, 121, 7, 12321, 15, 0, 0, 0, 0, 0, 0, 0, 0),
  163. (12321, 124, 3, 0, 4000, 0, 0, 0, 0, 3805.308105, -679.679810, 213.75914, 1.256658);
  164. UPDATE `mangos`.`quest_template` SET `StartScript` = 12321 WHERE `entry` = 12321;
  165. DELETE FROM `mangos`.`db_script_string` WHERE entry BETWEEN 2000000139 AND 2000000169;
  166. INSERT INTO `mangos`.`db_script_string` VALUES
  167. (2000000139, 'Stand back, the beast might lash out and harm you.', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  168. (2000000140, 'GODFREY! Hear me, fiend! Hear me, for I am the Light, here to deliver you from evil!', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  169. (2000000141, 'Mayor Godfrey growls.', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  170. (2000000142, 'Good. I have your attention, then, Godfrey?', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  171. (2000000143, 'We can do this in one of two ways, Godfrey. First, I will simply ask you to tell me what the unholy markings etched upon the pages of this tome mean. What say you?', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  172. (2000000144, 'Mayor Godfrey hisses!', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  173. (2000000145, 'Tell you nothing, preacher.', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  174. (2000000146, 'What can you do to me that Kel\'Thuzad has not? That the Lich King will not?', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  175. (2000000147, 'The book is your salvation, yes... but nothing will you know! NOTHING I SAY! NOTHING! ', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  176. (2000000148, 'Then it is option two.', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  177. (2000000149, 'I say a prayer for you now, lost soul. May the Light take you gracefully.', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  178. (2000000150, 'Let the sermon begin.', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  179. (2000000151, 'The power of the Lich King pales in comparison to the glory of the Light!', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  180. (2000000152, 'BURN IN HOLY FIRE!', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  181. (2000000153, 'Do not fight me, fiend! The time of your atonement is now!', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  182. (2000000154, 'BURN IN HOLY FIRE!', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  183. (2000000155, 'IT BURNSSSSS!', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  184. (2000000156, 'The pain is unbearable!', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  185. (2000000157, 'BURN IN HOLY FIRE!', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  186. (2000000158, 'IT BURNSSSSS!', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  187. (2000000159, 'I thought you would see the Light, Godfrey... Now speak quickly, fiend. What does it say?', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  188. (2000000160, 'It tells of the coming apocalypse. How this world will burn and be reborn from death.', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  189. (2000000161, 'RUBBISH! Godfrey do you take me for a fool? Do not spew your Scourge propoganda at a man of the Light, heathen! Speak now or I will have the peasants craft a holy water bath and dip you into it like a dog with fleas!', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  190. (2000000162, 'NOOOO! I tell you! I tell you everything!', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  191. (2000000163, 'Humans... Beneath the earth of Wintergarde Village you built a mausoleum! Why do you think Naxxramas attacked that spot? Thel\'zan hides deep in your own crypt and sends a thousand-thousand corpses at you! Perish you will...', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  192. (2000000164, 'What? There is a mausoleum beneath the old village? What fools we are to not have noticed! We will find and strike down your master now, Godfrey. We will end this nightmare.', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  193. (2000000165, 'How? Humans truly are stupid, yes? Thel\'zan the Duskbringer! Thel\'zan the Lich! He who is born of human flesh and bone, sacrificed all for power, protected by the Lich King!', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  194. (2000000166, 'You cannot stop Thel\'zan! He bears the dark gift, bestowed upon him by the Lich King himself!', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  195. (2000000167, 'You let us worry about how we kill the monster, Godfrey.', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  196. (2000000168, 'Return to Halford with the information that the good mayor was kind enough to submit. I will finish here and squeeze whatever else this wretch might know about Thel\'zan. Now, I will show Godfrey the rarely seen "option three."', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL),
  197. (2000000169, 'Let\'s you and I have a chat about some things, Godfrey.', NULL, NULL, NULL, NULL, NULL ,NULL, NULL, NULL);
  198. UPDATE `mangos`.`quest_template` SET `SpecialFlags` = 2, `ReqCreatureOrGOId1` = 0, `ReqCreatureOrGOCount1` = 0 WHERE `entry` = 12321;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!