API tools faq
paste
Advertisement
bucur35

Untitled

bucur35
Dec 25th, 2012
112
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 16.42 KB | None | 0 0
raw download clone embed print report
  1.     /* ***********
  2.       Relatii:
  3.     ************ */
  4.      
  5.     DELETE FROM `creature_questrelation` WHERE `id`=1501 AND `quest`=28608;
  6.      
  7.     UPDATE `quest_template` SET `PrevQuestId`=0, `NextQuestId`=28608, `NextQuestIdChain`=0 WHERE  `Id`=24959;
  8.     UPDATE `quest_template` SET `PrevQuestId`=24959, `NextQuestId`=26799, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=28608;
  9.     UPDATE `quest_template` SET `PrevQuestId`=28608, `NextQuestId`=28652, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=26799;
  10.     UPDATE `quest_template` SET `PrevQuestId`=24959, `NextQuestId`=26799, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=28608;
  11.     UPDATE `quest_template` SET `PrevQuestId`=28608, `NextQuestId`=28652, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=26799;
  12.     UPDATE `quest_template` SET `PrevQuestId`=26799, `NextQuestId`=24960, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=28652;
  13.     UPDATE `quest_template` SET `PrevQuestId`=28652, `NextQuestId`=25089, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=24960;
  14.     UPDATE `quest_template` SET `PrevQuestId`=24960, `NextQuestId`=26800, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=25089;
  15.     UPDATE `quest_template` SET `PrevQuestId`=25089, `NextQuestId`=28653, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=26800;
  16.     UPDATE `quest_template` SET `PrevQuestId`=26800, `NextQuestId`=26801, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=28653;
  17.     UPDATE `quest_template` SET `PrevQuestId`=28653, `NextQuestId`=0, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=26801;
  18.     UPDATE `quest_template` SET `PrevQuestId`=26801, `NextQuestId`=24969, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=3095;
  19.     UPDATE `quest_template` SET `PrevQuestId`=26801, `NextQuestId`=24967, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=3096;
  20.     UPDATE `quest_template` SET `PrevQuestId`=26801, `NextQuestId`=24966, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=3097;
  21.     UPDATE `quest_template` SET `PrevQuestId`=26801, `NextQuestId`=24965, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=3098;
  22.     UPDATE `quest_template` SET `PrevQuestId`=26801, `NextQuestId`=24968, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=3099;
  23.     UPDATE `quest_template` SET `PrevQuestId`=26801, `NextQuestId`=24964, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=24962;
  24.     UPDATE `quest_template` SET `PrevQuestId`=3095, `NextQuestId`=28651, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=24969;
  25.     UPDATE `quest_template` SET `PrevQuestId`=3096, `NextQuestId`=28651, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=24967;
  26.     UPDATE `quest_template` SET `PrevQuestId`=3097, `NextQuestId`=28651, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=24966;
  27.     UPDATE `quest_template` SET `PrevQuestId`=3098, `NextQuestId`=28651, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=24965;
  28.     UPDATE `quest_template` SET `PrevQuestId`=3099, `NextQuestId`=28651, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=24968;
  29.     UPDATE `quest_template` SET `PrevQuestId`=24962, `NextQuestId`=28651, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=24964;
  30.     UPDATE `quest_template` SET `PrevQuestId`=28651, `NextQuestId`=28672, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=24961;
  31.     UPDATE `quest_template` SET `PrevQuestId`=24961, `NextQuestId`=26802, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=28672;
  32.     UPDATE `quest_template` SET `PrevQuestId`=28672, `NextQuestId`=24973, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=26802;
  33.     UPDATE `quest_template` SET `PrevQuestId`=26802, `NextQuestId`=24970, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=24973;
  34.     UPDATE `quest_template` SET `PrevQuestId`=24973, `NextQuestId`=24971, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=24970;
  35.     UPDATE `quest_template` SET `PrevQuestId`=24970, `NextQuestId`=24972, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=24971;
  36.     UPDATE `quest_template` SET `PrevQuestId`=24971, `NextQuestId`=0, `NextQuestIdChain`=0, `Flags`=0 WHERE  `Id`=24972;
  37.      
  38.  
  39.      
  40. -- "The Shadow Gave";
  41.      
  42. UPDATE `gameobject_template` SET `questItem1`=64582, `data1`=207255 WHERE  `entry`=207255;
  43. UPDATE `gameobject_template` SET `questItem1`=64581, `data1`=207256 WHERE  `entry`=207256;
  44.      
  45. DELETE FROM `gameobject_loot_template` WHERE  `entry`=207255 AND `item`=64582;
  46. INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (207255, 64582, 100, 1, 0, 1, 1);
  47.      
  48. DELETE FROM `gameobject_loot_template` WHERE  `entry`=207256 AND `item`=64581;
  49. INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (207256, 64581, 100, 1, 0, 1, 1);
  50.      
  51. "The Wakening";
  52.      
  53. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=49231;
  54. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=38895;
  55. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=49230;
  56.      
  57. UPDATE `creature_template` SET `gossip_menu_id`=49231 WHERE  `entry`=49231;
  58. UPDATE `creature_template` SET `gossip_menu_id`=38895 WHERE  `entry`=38895;
  59. UPDATE `creature_template` SET `gossip_menu_id`=49230 WHERE  `entry`=49230;
  60.      
  61. UPDATE `creature_template` SET `npcflag`=1 WHERE `entry`=49231;
  62. UPDATE `creature_template` SET `npcflag`=1 WHERE `entry`=38895;
  63. UPDATE `creature_template` SET `npcflag`=1 WHERE `entry`=49230;
  64.      
  65. DELETE FROM `npc_text` WHERE `ID`=49231;
  66. DELETE FROM `npc_text` WHERE `ID`=38895;
  67. DELETE FROM `npc_text` WHERE `ID`=49230;
  68. 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
  69. (49231, 'What... What\'s goint on? Who are you? What happened with me?', 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),
  70. (38895, 'Get away from me, you abomination!', 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. (49230, 'Stand back monster. You want to fight? Because I\'ll fight you. I\'ll fight any one of you creatures! Do you hear me?', 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);
  72.      
  73. DELETE FROM `gossip_menu_option` WHERE `menu_id`=49231;
  74. DELETE FROM `gossip_menu_option` WHERE `menu_id`=38895;
  75. DELETE FROM `gossip_menu_option` WHERE `menu_id`=49230;
  76. 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
  77. (49231, 0, 0, 'Don\'t you remember? You died.', 1, 1, 0, 0, 0, 0, NULL),
  78. (38895, 0, 0, 'I\'m not an abomination. I\'m simply undead. I just want to speak with you.', 1, 1, 0, 0, 0, 0, NULL),
  79. (49230, 0, 0, 'I\'m not here to fight. I\'ve only been asked to speak with you.', 1, 1, 0, 0, 0, 0, NULL);
  80.      
  81. DELETE FROM `gossip_menu` WHERE `entry`=49231 AND `text_id`=49231;
  82. DELETE FROM `gossip_menu` WHERE `entry`=38895 AND `text_id`=38895;
  83. DELETE FROM `gossip_menu` WHERE `entry`=49230 AND `text_id`=49230;
  84. INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
  85. (49231, 49231),
  86. (38895, 38895),
  87. (49230, 49230);
  88.      
  89. DELETE FROM `smart_scripts` WHERE  `entryorguid`=49231;
  90. DELETE FROM `smart_scripts` WHERE  `entryorguid`=38895;
  91. DELETE FROM `smart_scripts` WHERE  `entryorguid`=49230;
  92. 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
  93. (49231, 0, 0, 0, 62, 0, 100, 0, 49231, 0, 0, 0, 33, 49231, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip select - Give credit'),
  94. (38895, 0, 0, 0, 62, 0, 100, 0, 38895, 0, 0, 0, 33, 38895, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip select - Give credit'),
  95. (49230, 0, 0, 0, 62, 0, 100, 0, 49230, 0, 0, 0, 33, 49230, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip select - Give credit');
  96.      
  97. DELETE FROM `conditions` WHERE `SourceGroup`=49231;
  98. DELETE FROM `conditions` WHERE `SourceGroup`=38895;
  99. DELETE FROM `conditions` WHERE `SourceGroup`=49230;
  100. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  101. (15, 38895, 0, 0, 0, 9, 0, 24960, 0, 0, 0, 0, '', 'show gossip if player has quest'),
  102. (15, 49230, 0, 0, 0, 9, 0, 24960, 0, 0, 0, 0, '', 'show gossip if player has quest'),
  103. (15, 49231, 0, 0, 0, 9, 0, 24960, 0, 0, 0, 0, '', 'show gossip if player has quest');
  104.      
  105.      
  106. -- "Recruitment":
  107.      
  108. UPDATE `creature_template` SET `IconName`='Interact' WHERE  `entry`=49340;
  109. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=49340;
  110. UPDATE `creature_template` SET `gossip_menu_id`=49340 WHERE  `entry`=49340;
  111. UPDATE `creature_template` SET `npcflag`=1 WHERE  `entry`=49340;
  112.      
  113. DELETE FROM `npc_text` WHERE `ID`=49340;
  114. 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
  115. (49340, 'What\'s going on?', 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);
  116.      
  117. DELETE FROM `gossip_menu_option` WHERE `menu_id`=49340;
  118. 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
  119. (49340, 0, 0, 'I\'m here to revive you.', 1, 1, 0, 0, 0, 0, NULL);
  120.      
  121. DELETE FROM `gossip_menu` WHERE `entry`=49340;
  122. INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
  123. (49340, 49340);
  124.      
  125. DELETE FROM `smart_scripts` WHERE  `entryorguid`=49340;
  126. 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
  127. (49340, 0, 0, 0, 62, 0, 100, 0, 49340, 0, 0, 0, 33, 49340, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip select - Give credit'),
  128. (49340, 0, 1, 0, 62, 0, 100, 0, 49340, 0, 0, 0, 41, 1000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On gossip select - Give credit');
  129.      
  130. DELETE FROM `conditions` WHERE `SourceGroup`=49340;
  131. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  132. (15, 49340, 0, 0, 0, 9, 0, 26800, 0, 0, 0, 0, '', 'show gossip if player has quest');
  133.      
  134. -- "The Truth of the Grave"
  135.      
  136. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=38910;
  137. UPDATE `creature_template` SET `gossip_menu_id`=38910 WHERE  `entry`=38910;
  138. UPDATE `creature_template` SET `npcflag`=1 WHERE  `entry`=38910;
  139.      
  140. DELETE FROM `npc_text` WHERE `ID`=38910;
  141. 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
  142. (38910, 'Get away from me, you monster! Don\'t look at me! I\'m hideous!', 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);
  143.      
  144. DELETE FROM `gossip_menu_option` WHERE `menu_id`=38910;
  145. 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
  146. (38910, 0, 0, 'You\'re not hideous. Lilian... you\'re one of us. Here, look in this mirror, see for yourself.', 1, 1, 0, 0, 0, 0, NULL);
  147.      
  148. DELETE FROM `gossip_menu` WHERE `entry`=38910;
  149. INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
  150. (38910, 38910);
  151.      
  152. DELETE FROM `creature_text` WHERE  `entry`=38910;
  153. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES (38910, 0, 0, 'You don\'t understand... I CAN\'T be undead! Not me, not now...', 12, 0, 100, 18, 0, 0, 'Say line 1');
  154.      
  155. DELETE FROM `smart_scripts` WHERE  `entryorguid`=38910;
  156. 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
  157. (38910, 0, 0, 0, 62, 0, 100, 0, 38910, 0, 0, 0, 33, 38910, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip select - Give credit'),
  158. (38910, 0, 1, 0, 62, 0, 100, 0, 49340, 0, 0, 0, 84, 38910, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On gossip select - Say line 1');
  159.      
  160. DELETE FROM `conditions` WHERE `SourceGroup`=38910;
  161. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  162. (15, 38910, 0, 0, 0, 9, 0, 24961, 0, 0, 0, 0, '', 'show gossip if player has quest');
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!