aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorModoX <moardox@gmail.com>2023-10-22 13:38:07 +0200
committerModoX <moardox@gmail.com>2023-10-22 13:38:07 +0200
commitb2393d6adeca9a54b6ff1fb62a87da48c068f010 (patch)
treec5bde3029d3cc73e818c5cd1671142c0900683d9 /sql
parent9eceff2bc243946998c006418229dbb639e898d6 (diff)
Scripts/World: Dropped deprecated npc_innkeeper script
* costume stuff should be handled by candy buckets
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2023_10_22_02_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_10_22_02_world.sql b/sql/updates/world/master/2023_10_22_02_world.sql
new file mode 100644
index 00000000000..f648851661e
--- /dev/null
+++ b/sql/updates/world/master/2023_10_22_02_world.sql
@@ -0,0 +1,5 @@
+--
+UPDATE `creature_template` SET `ScriptName`='' WHERE `ScriptName`='npc_innkeeper';
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup` IN(344,348,349,441,1290,1293,1294,1296,1297,1581,6525,6620,7173,7288,7301,7324,7468,7481,7855,9123) AND `SourceEntry` IN(0, 2);
+DELETE FROM `gossip_menu_option` WHERE (`MenuID`=344 AND `OptionID` IN(2, 3)) OR (`MenuID`=348 AND `OptionID`=2) OR (`MenuID`=349 AND `OptionID` IN(2, 3)) OR (`MenuID`=441 AND `OptionID` IN(2, 4)) OR (`MenuID`=6620 AND `OptionID`=2) OR (`MenuID`=7173 AND `OptionID` IN(2, 3)) OR (`MenuID`=7288 AND `OptionID` IN(2, 3)) OR (`MenuID`=7301 AND `OptionID`=2) OR (`MenuID`=7324 AND `OptionID`=2) OR (`MenuID`=7481 AND `OptionID`=2) OR (`MenuID`=7855 AND `OptionID`=2) OR (`MenuID`=9123 AND `OptionID` IN(2, 3));