aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2016-04-10 03:28:13 +0200
committerKillyana <morphone1@gmail.com>2016-04-10 03:28:13 +0200
commitccd748f3bcbf62ae69249a4ea3160aa5f9c8f350 (patch)
tree4a9108507ebb9d3b891b820541f358ba4277bcd2 /sql
parent0b72b6a893303836a9d8cafbe1803ad16aafaecc (diff)
DB/Misc: Fix Hero's call boards
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2016_04_10_02_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2016_04_10_02_world.sql b/sql/updates/world/2016_04_10_02_world.sql
new file mode 100644
index 00000000000..1aecae16062
--- /dev/null
+++ b/sql/updates/world/2016_04_10_02_world.sql
@@ -0,0 +1,5 @@
+--
+UPDATE `gameobject_template` SET `faction`= 29 WHERE `entry` IN (206116, 206109, 207324, 207279, 208317, 207323, 207325);
+UPDATE `gameobject_template` SET `faction`= 12 WHERE `entry` IN (206111, 206294, 207320, 208316, 207321, 207322);
+UPDATE `quest_template` SET `AllowableRaces`=`AllowableRaces` | 1 | 4 | 8 | 64 | 1024 | 2097152 | 16777216 WHERE `id` IN (SELECT `quest` FROM `gameobject_queststarter` WHERE `id` IN (206111, 206294, 207320, 208316, 207321, 207322));
+UPDATE `quest_template` SET `AllowableRaces`=`AllowableRaces` | 2 | 16 | 32 | 128 | 256 | 512 | 33554432 WHERE `id` IN (SELECT `quest` FROM `gameobject_queststarter` WHERE `id` IN (206116, 206109, 207324, 207279, 208317, 207323, 207325));