From f81cfca7bd5583cef0254920e3fae234d0789e69 Mon Sep 17 00:00:00 2001 From: Nay Date: Mon, 7 Feb 2011 21:52:14 +0000 Subject: SQL: Any content SQL should be able to be re-imported without errors; Fix an import error in world_scripts_full; P.S Full DB will be available soon Closes #586 --- sql/scripts/world_script_texts.sql | 2 +- sql/scripts/world_script_waypoints.sql | 8 +------- sql/scripts/world_scripts_full.sql | 3 +-- 3 files changed, 3 insertions(+), 10 deletions(-) (limited to 'sql/scripts') diff --git a/sql/scripts/world_script_texts.sql b/sql/scripts/world_script_texts.sql index fbb834f4ee9..b1cea599a86 100644 --- a/sql/scripts/world_script_texts.sql +++ b/sql/scripts/world_script_texts.sql @@ -1,4 +1,4 @@ --- Up to TC2 5408 +-- Up to TC 11181 -- -- trinityscript_script_texts.sql Contains data for table `script_texts` mainly used in C++ parts. -- valid entries for table are between -1000000 and -1999999 diff --git a/sql/scripts/world_script_waypoints.sql b/sql/scripts/world_script_waypoints.sql index cf5c16c8dff..da727e4056e 100644 --- a/sql/scripts/world_script_waypoints.sql +++ b/sql/scripts/world_script_waypoints.sql @@ -1,4 +1,4 @@ --- Up to TC2 5408 +-- Up to TC 11181 -- This file contains all waypoints used by escortAI scripts /* @@ -15,12 +15,6 @@ CREATE TABLE `script_waypoint` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Creature waypoints'; */ --- --- Not sure why we don't just run --- DELETE FROM `script_waypoint`; --- I mean seriously, who has custom waypoint creatures? --- - DELETE FROM `script_waypoint` WHERE `entry`=26170; INSERT INTO `script_waypoint` VALUES (26170,1,3700.08,3574.54,473.322,0, ''), diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index a32a5d1461c..5aac3170c27 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -1,4 +1,4 @@ --- Up to TC2 6928 +-- Up to TC 11181 -- Cleanup first UPDATE `battleground_template` SET `ScriptName`=''; @@ -1824,7 +1824,6 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES ( 46394, 'spell_gen_burn_brutallus'), ( 57685, 'spell_creature_permanent_feign_death'), ( 58601, 'spell_gen_remove_flight_auras'), -( 66118, 'spell_gen_leeching_swarm'), ( 58951, 'spell_creature_permanent_feign_death'), ( 70592, 'spell_creature_permanent_feign_death'), ( 70628, 'spell_creature_permanent_feign_death'), -- cgit v1.2.3