API tools faq
paste
Advertisement
bucur35

Dustwallow Marsh

bucur35
Jan 27th, 2013
120
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 10.39 KB | None | 0 0
raw download clone embed print report
  1. -- ...and Bugs si Mudrock Soup and Bugs chain
  2. UPDATE `creature_template` SET `npcflag`=2 WHERE `entry`=4794;
  3. UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id`=1204;
  4.  
  5. DELETE FROM `creature_questrelation` WHERE `id`=4794 AND `quest`=1204;
  6. INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES
  7. (4794, 1204);
  8.  
  9. DELETE FROM `creature_involvedrelation` WHERE `id`=4794 AND `quest`=1204;
  10. INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES
  11. (4794, 1204);
  12.  
  13. UPDATE `quest_template` SET `NextQuestId`=1258, `NextQuestIdChain`=0 WHERE `Id`=1204;
  14.  
  15. DELETE FROM `creature_questrelation` WHERE `id`=4794 AND `quest`=1258;
  16. INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES
  17. (4794, 1258);
  18.  
  19. DELETE FROM `creature_involvedrelation` WHERE `id`=4794 AND `quest`=1258;
  20. INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES
  21. (4794, 1258);
  22.  
  23. --Discreditind the Deserters
  24.  
  25. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=4979;
  26. UPDATE `creature_template` SET `gossip_menu_id`=4979 WHERE `entry`=4979;
  27. UPDATE `creature_template` SET `npcflag`=1 WHERE `entry`=4979;
  28.  
  29. DELETE FROM `npc_text` WHERE `ID`=4979;
  30. INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`, `WDBVerified`) VALUES
  31. (4979, 'Why did u come here?', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 1);
  32.  
  33. DELETE FROM `gossip_menu_option` WHERE `menu_id`=4979;
  34. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`) VALUES
  35. (4979, 0, 0, 'Show me the letter.', 1, 1, 0, 0, 0, 0, NULL);
  36.  
  37.  
  38. DELETE FROM `gossip_menu` WHERE `entry`=4979 AND `text_id`=4979;
  39. INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
  40. (4979, 4979);
  41.  
  42. DELETE FROM `smart_scripts` WHERE `entryorguid`=4979;
  43. 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
  44. (4979, 0, 0, 0, 62, 0, 100, 0, 4979, 0, 0, 0, 33, 4979, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip select - Give credit');
  45.  
  46. DELETE FROM `conditions` WHERE `SourceGroup`=4979;
  47. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  48. (15, 4979, 0, 0, 0, 9, 0, 27212, 0, 0, 0, 0, '', 'show gossip if player has quest');
  49.  
  50.  
  51. --Jaina Must Know , asta va rezolva si alte questuri
  52.  
  53. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
  54. (279196, 23569, 1, 1, 1, 21624, 23569, -2629.72, -4321.5, -1.99871, 2.3911, 300, 0, 0, 1093, 1142, 0, 0, 0, 0);
  55.  
  56. --Lieutenant Paval Reethe
  57.  
  58. UPDATE `quest_template` SET `RequiredRaces`=1101 WHERE `Id`=27263; --Alliance
  59. UPDATE `quest_template` SET `RequiredRaces`=690 WHERE `Id`=27260; --Horde
  60.  
  61. --Traitors Among Us
  62.  
  63. UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=23602;
  64. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=23602;
  65. UPDATE `creature_template` SET `gossip_menu_id`=23602 WHERE `entry`=23602;
  66. UPDATE `creature_template` SET `npcflag`=1 WHERE `entry`=23602;
  67.  
  68. DELETE FROM `npc_text` WHERE `ID`=23602;
  69. INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`, `WDBVerified`) VALUES
  70. (23602, 'When you\'re off duty, let\'s go to the inn. I\'ll buy a round and we can reminisce about the good old days.', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 1);
  71.  
  72. DELETE FROM `gossip_menu_option` WHERE `menu_id`=23602;
  73. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`) VALUES
  74. (23602, 0, 0, 'Challenge me!', 1, 1, 0, 0, 0, 0, NULL);
  75.  
  76. DELETE FROM `gossip_menu` WHERE `entry`=23602 AND `text_id`=23602;
  77. INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
  78. (23602, 23602);
  79.  
  80. DELETE FROM `smart_scripts` WHERE `entryorguid`=23602;
  81. 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
  82. (23602, 0, 0, 0, 62, 0, 100, 0, 23602, 0, 0, 0, 2, 16, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On gossip select - Give credit');
  83.  
  84. DELETE FROM `conditions` WHERE `SourceGroup`=23602;
  85. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  86. (15, 23602, 0, 0, 0, 9, 0, 27210, 0, 0, 0, 0, '', 'show gossip if player has quest');
  87.  
  88.  
  89. --Raptor Captor
  90.  
  91. DELETE FROM `smart_scripts` WHERE `entryorguid`=4351;
  92. DELETE FROM `smart_scripts` WHERE `entryorguid`=4352;
  93. 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
  94. (4351, 0, 1, 0, 2, 0, 100, 1, 0, 20, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bloodfen Raptor - At 20% HP - Say Line 0'),
  95. (4351, 0, 0, 0, 8, 0, 100, 0, 42325, 0, 0, 0, 33, 23727, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Bloodfen Raptor - On Spellhit - Quest Credit'),
  96. (4352, 0, 1, 0, 2, 0, 100, 1, 0, 20, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bloodfen Screecher - At 20% HP - Say Line 0'),
  97. (4352, 0, 0, 0, 8, 0, 100, 0, 42325, 0, 0, 0, 33, 23727, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Bloodfen Screecher - On Spellhit - Quest Credit');
  98.  
  99. --Suspicious Hoofprints
  100.  
  101. UPDATE `quest_template` SET `RequiredRaces`=1101 WHERE `Id`=27262; --Alliance
  102. UPDATE `quest_template` SET `RequiredRaces`=690 WHERE `Id`=27259; --Horde
  103.  
  104. --Take Down Tethyr
  105.  
  106. UPDATE `quest_template` SET `Method`=2, `RequiredNpcOrGo1`=23899, `RequiredNpcOrGoCount1`=1 WHERE `Id`=27222;
  107.  
  108. --The Deserters
  109.  
  110. UPDATE `creature_template` SET `faction_A`=35, `faction_H`=35 WHERE `entry`=5089;
  111.  
  112. --Jarl Needs Eyes
  113.  
  114. DELETE FROM `creature_questrelation` WHERE `id`=4792 AND `quest`=27184;
  115. INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES
  116. (4792, 27184);
  117.  
  118. DELETE FROM `creature_involvedrelation` WHERE `id`=4792 AND `quest`=27184;
  119. INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES
  120. (4792, 27184);
  121.  
  122. UPDATE `quest_template` SET `NextQuestId`=27183, `NextQuestIdChain`=0 WHERE `Id`=27182;
  123. UPDATE `quest_template` SET `PrevQuestId`=27182, `NextQuestId`=27184, `NextQuestIdChain`=0 WHERE `Id`=27183;
  124. UPDATE `quest_template` SET `PrevQuestId`=27183 WHERE `Id`=27184;
  125.  
  126. --Baldruc <Gryphon Master>
  127.  
  128. UPDATE `creature_template` SET `npcflag`=8192 WHERE `entry`=4321;
  129.  
  130. --Theoden Manners <Inscription Trainer and Supplies>
  131.  
  132. UPDATE `creature_template` SET `npcflag`=192 WHERE `entry`=53415;
  133.  
  134. --Lissah Spellwick
  135.  
  136. UPDATE `creature_template` SET `npcflag`=192 WHERE `entry`=53410;
  137.  
  138. --"Kobold" Kerik
  139.  
  140. UPDATE `creature_template` SET `npcflag`=192 WHERE `entry`=53409;
  141.  
  142. --Ingo Woolybush
  143.  
  144. UPDATE `creature_template` SET `npcflag`=192 WHERE `entry`=5388;
  145.  
  146. --Eustace Tanwell
  147.  
  148. UPDATE `creature_template` SET `npcflag`=192 WHERE `entry`=53436;
  149.  
  150. --The Black Shield
  151.  
  152. UPDATE `quest_template` SET `RequiredRaces`=1101 WHERE `Id`=27252; --Alliance
  153. UPDATE `quest_template` SET `RequiredRaces`=690 WHERE `Id`=27254; --Horde
  154.  
  155. --SMASH BROODQUEEN
  156.  
  157. UPDATE `quest_template` SET `RequiredRaces`=690 WHERE `Id`=27229;
  158.  
  159. --Seek Out Tabetha
  160.  
  161. UPDATE `quest_template` SET `RequiredRaces`=690 WHERE `Id`=27295;
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!