From de11cc3f8ecb3edff0c720f669077594f9602214 Mon Sep 17 00:00:00 2001 From: runningnak3d Date: Mon, 22 Dec 2008 20:59:45 +0000 Subject: * And yet more SQL clean up --HG-- branch : trunk rename : sql/updates/488_world_script.sql => sql/updates/488_world_scripts.sql rename : sql/updates/502_trinity_scripts.sql => sql/updates/502_world_scripts.sql rename : sql/updates/566_world_spell_script_target.sql => sql/updates/566_world.sql --- sql/updates/471_world.sql | 11 ++--------- 1 file changed, 2 insertions(+), 9 deletions(-) (limited to 'sql/updates/471_world.sql') diff --git a/sql/updates/471_world.sql b/sql/updates/471_world.sql index 637c999fdea..2db368326e8 100644 --- a/sql/updates/471_world.sql +++ b/sql/updates/471_world.sql @@ -1,9 +1,2 @@ -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 +UPDATE `gameobject_template` SET `faction`=1375 WHERE `entry` IN (184203, 184204, 184205); +UPDATE `gameobject_template` SET `Scriptname`='go_bridge_console' WHERE entry=184568; -- cgit v1.2.3