aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-10-17 18:19:39 +0200
committerShauren <shauren.trinity@gmail.com>2021-11-15 13:56:38 +0100
commit90e42843a463615d9e577f2ba73581ccaffeab71 (patch)
tree93d5c4247767cc68aa0d8843c749112c5a5eaef6
parent34e3cac078cf677d64ac27abe162d525506e7d15 (diff)
DB/Creature: Update the correct gossips for Pusillin
(cherry picked from commit 0ea598b0eada3685601f64809793572ae9c576db)
-rw-r--r--sql/updates/world/master/2021_11_15_02_world_2018_10_17_04_world_335.sql16
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_15_02_world_2018_10_17_04_world_335.sql b/sql/updates/world/master/2021_11_15_02_world_2018_10_17_04_world_335.sql
new file mode 100644
index 00000000000..68ba9810d98
--- /dev/null
+++ b/sql/updates/world/master/2021_11_15_02_world_2018_10_17_04_world_335.sql
@@ -0,0 +1,16 @@
+--
+UPDATE `gossip_menu_option` SET `OptionType`=1, `OptionNpcFlag`=1 WHERE `MenuId` IN (5709);
+DELETE FROM `gossip_menu_option` WHERE `MenuId` IN (6877,6878,6879,6880,6881);
+
+DELETE FROM `gossip_menu` WHERE `MenuID`=5709 AND `TextID` IN (6878,6879,6880,6881);
+UPDATE `smart_scripts` SET `action_param1`=5709, `action_param2`=6877 WHERE `entryorguid`=14354 AND `source_type`=0 AND `id`=1;
+UPDATE `smart_scripts` SET `action_param1`=5710, `action_param2`=6878 WHERE `entryorguid`=14354 AND `source_type`=0 AND `id`=2;
+UPDATE `smart_scripts` SET `action_param1`=5711, `action_param2`=6879 WHERE `entryorguid`=14354 AND `source_type`=0 AND `id`=3;
+UPDATE `smart_scripts` SET `action_param1`=5712, `action_param2`=6880 WHERE `entryorguid`=14354 AND `source_type`=0 AND `id`=4;
+UPDATE `smart_scripts` SET `action_param1`=5713, `action_param2`=6881 WHERE `entryorguid`=14354 AND `source_type`=0 AND `id`=5;
+
+UPDATE `smart_scripts` SET `event_param1`=5709 WHERE `entryorguid`=14354 AND `source_type`=0 AND `id`=6;
+UPDATE `smart_scripts` SET `event_param1`=5710 WHERE `entryorguid`=14354 AND `source_type`=0 AND `id`=7;
+UPDATE `smart_scripts` SET `event_param1`=5711 WHERE `entryorguid`=14354 AND `source_type`=0 AND `id`=8;
+UPDATE `smart_scripts` SET `event_param1`=5712 WHERE `entryorguid`=14354 AND `source_type`=0 AND `id`=9;
+UPDATE `smart_scripts` SET `event_param1`=5713 WHERE `entryorguid`=14354 AND `source_type`=0 AND `id`=10;