From 45f91feaa8465df9da136d145c115bc498a8b4c5 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 26 Feb 2011 12:53:17 +0100 Subject: DB: Fixed startup errors and formatting Core/Vehicles: Prevent "unprocessed tail data" vehicle packet spam --- sql/updates/world/2011_02_25_0_world_creatures.sql | 2 +- sql/updates/world/2011_02_25_1_world_spell_script_names.sql | 3 ++- sql/updates/world/2011_02_26_3_world_creatures.sql | 2 ++ 3 files changed, 5 insertions(+), 2 deletions(-) create mode 100644 sql/updates/world/2011_02_26_3_world_creatures.sql (limited to 'sql') diff --git a/sql/updates/world/2011_02_25_0_world_creatures.sql b/sql/updates/world/2011_02_25_0_world_creatures.sql index e790c6b7273..d2e49048865 100644 --- a/sql/updates/world/2011_02_25_0_world_creatures.sql +++ b/sql/updates/world/2011_02_25_0_world_creatures.sql @@ -5,4 +5,4 @@ UPDATE `creature_model_info` SET `bounding_radius`=0.31, `combat_reach`=25 WHERE DELETE FROM `creature` WHERE `id` IN(32933,32934); -- Update spawn data -UPDATE `creature` SET `unit_flags`=33554432, `deathstate`= 1, `MovementType`=0 WHERE `id`=34297; \ No newline at end of file +UPDATE `creature` SET `unit_flags`=33554432, `deathstate`= 1, `MovementType`=0 WHERE `id`=34297; diff --git a/sql/updates/world/2011_02_25_1_world_spell_script_names.sql b/sql/updates/world/2011_02_25_1_world_spell_script_names.sql index 1e4e89b15fd..ae57aad0e93 100644 --- a/sql/updates/world/2011_02_25_1_world_spell_script_names.sql +++ b/sql/updates/world/2011_02_25_1_world_spell_script_names.sql @@ -1,2 +1,3 @@ DELETE FROM `spell_script_names` WHERE `spell_id`=64702; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (64702, 'spell_ulduar_squeezed_lifeless'); \ No newline at end of file +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(64702, 'spell_ulduar_squeezed_lifeless'); diff --git a/sql/updates/world/2011_02_26_3_world_creatures.sql b/sql/updates/world/2011_02_26_3_world_creatures.sql new file mode 100644 index 00000000000..b8dc70fea7d --- /dev/null +++ b/sql/updates/world/2011_02_26_3_world_creatures.sql @@ -0,0 +1,2 @@ +UPDATE `creature` SET `spawndist`=0 WHERE `guid`=137582; +DELETE FROM `creature_addon` WHERE `guid` IN (136768,136769); -- cgit v1.2.3