aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-02-25 01:32:29 +0100
committerKillyana <morphone1@gmail.com>2018-02-25 01:32:29 +0100
commitacdf7be800ec937c2334caf629d3376037d4b863 (patch)
treedadc1db6ecb3f0bee0ed2825ce061f28c454005b
parent34967e9c32b2c7e871bb93f41609a3b08ad92931 (diff)
DB/GameObject: Make spawned Bountiful Feast not selectable
Closes #20957
-rw-r--r--sql/updates/world/3.3.5/2018_02_25_00_world_335.sql23
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_02_25_00_world_335.sql b/sql/updates/world/3.3.5/2018_02_25_00_world_335.sql
new file mode 100644
index 00000000000..7762bbbbe8e
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_02_25_00_world_335.sql
@@ -0,0 +1,23 @@
+--
+DELETE FROM `gameobject_overrides` WHERE `spawnId` IN (76499, 76498, 76436, 76435, 76229, 76228, 76182, 76181, 76147, 76146, 76145, 76144, 76099, 76098, 76097, 76067, 76066, 76065, 76579, 76580);
+INSERT INTO `gameobject_overrides` (`spawnId`, `faction`, `flags`) VALUES
+(76499, 0, 16),
+(76498, 0, 16),
+(76436, 0, 16),
+(76435, 0, 16),
+(76229, 0, 16),
+(76228, 0, 16),
+(76182, 0, 16),
+(76181, 0, 16),
+(76147, 0, 16),
+(76146, 0, 16),
+(76145, 0, 16),
+(76144, 0, 16),
+(76099, 0, 16),
+(76098, 0, 16),
+(76097, 0, 16),
+(76067, 0, 16),
+(76066, 0, 16),
+(76065, 0, 16),
+(76579, 0, 16),
+(76580, 0, 16);