aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBlaymoira <none@none>2008-12-12 20:39:40 +0100
committerBlaymoira <none@none>2008-12-12 20:39:40 +0100
commit7827d743a67798f0e5a38f5a2f2b5f65e5080f82 (patch)
tree5167155cffddbccd01f2fcd2f0568f46172b4bd1
parentab59d3adcc2a4afc743afe1a998290b99ed95929 (diff)
*Missing file in prev commit for SSC bridge.
--HG-- branch : trunk
-rw-r--r--sql/updates/471_world.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/471_world.sql b/sql/updates/471_world.sql
new file mode 100644
index 00000000000..637c999fdea
--- /dev/null
+++ b/sql/updates/471_world.sql
@@ -0,0 +1,9 @@
+UPDATE gameobject_template SET faction=1375 WHERE entry IN (184203, 184204, 184205);
+UPDATE gameobject_template SET Scriptname='go_bridge_console' WHERE entry=184568;
+
+DELETE FROM gameobject WHERE id IN (184205, 184204, 184203, 184568);
+INSERT INTO gameobject (id, map, spawnMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state) VALUES
+(184568, 548, 1, 47.7806, -582.962, 2.88104, 3.14159, 0, 0, 1, 0, 0, 1, 1),
+(184203, 548, 1, 26.198, -654.59, 15.5, 3.14159, 0, 0, 1, 0, 0, 1, 1),
+(184204, 548, 1, 26.198, -654.59, 15.5, 3.14159, 0, 0, 1, 0, 0, 1, 1),
+(184205, 548, 1, 26.198, -654.59, 15.5, 3.14159, 0, 0, 1, 0, 0, 1, 1); \ No newline at end of file