From 7827d743a67798f0e5a38f5a2f2b5f65e5080f82 Mon Sep 17 00:00:00 2001
From: Blaymoira <none@none>
Date: Fri, 12 Dec 2008 20:39:40 +0100
Subject: *Missing file in prev commit for SSC bridge.

--HG--
branch : trunk
---
 sql/updates/471_world.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 sql/updates/471_world.sql

(limited to 'sql')

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
-- 
cgit v1.2.3