From 499fa9b7cbff18f48529a0b838d63a2af9bb4df3 Mon Sep 17 00:00:00 2001 From: teacher Date: Sun, 27 Jun 2010 11:30:38 +0200 Subject: Added missing script to full (thank you azazel_kon for spotting them). Small sql editing (cosmetic, NO sql need to be re-applied). --HG-- branch : trunk --- sql/scripts/world_scripts_full.sql | 3 +++ sql/updates/8391_world_conditions.sql | 1 + sql/updates/8694_world_transport_events.sql | 2 +- 3 files changed, 5 insertions(+), 1 deletion(-) (limited to 'sql') diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index 191a2ea0106..eb99451c348 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -445,6 +445,8 @@ UPDATE `creature_template` SET `ScriptName`='npc_magmoth_crusher' WHERE `entry`= UPDATE `creature_template` SET `ScriptName`='npc_valiance_keep_cannoneer' WHERE `entry`=25306; UPDATE `creature_template` SET `ScriptName`='npc_warmage_coldarra' WHERE `entry` IN (27173,27904,27906); UPDATE `creature_template` SET `ScriptName`='npc_valiance_keep_cannoneer' WHERE `entry`=25306; +UPDATE `creature_template` SET `ScriptName`= 'npc_seaforium_depth_charge' WHERE `entry`=25401; + /* BURNING STEPPES */ UPDATE `creature_template` SET `ScriptName`='npc_ragged_john' WHERE `entry`=9563; @@ -583,6 +585,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_inquisitor_hallard' WHERE `entr /* DESOLACE */ UPDATE `creature_template` SET `ScriptName`='npc_aged_dying_ancient_kodo' WHERE `entry` IN (4700,4701,4702,11627); UPDATE `gameobject_template` SET `ScriptName`='go_iruxos' WHERE `entry`=176581; +UPDATE `creature_template` SET `ScriptName`='npc_dalinda' WHERE `entry`=5644; /* DIRE MAUL */ diff --git a/sql/updates/8391_world_conditions.sql b/sql/updates/8391_world_conditions.sql index 2eb3d79fac9..fb5cc9fbc9e 100644 --- a/sql/updates/8391_world_conditions.sql +++ b/sql/updates/8391_world_conditions.sql @@ -1,6 +1,7 @@ -- ---------------------------- -- Table structure for conditions -- ---------------------------- +DROP TABLE IF EXISTS `conditions`; CREATE TABLE `conditions` ( `SourceTypeOrReferenceId` mediumint(8) NOT NULL DEFAULT '0', `SourceGroup` mediumint(8) unsigned NOT NULL DEFAULT '0', diff --git a/sql/updates/8694_world_transport_events.sql b/sql/updates/8694_world_transport_events.sql index 480aea9d7c6..0e8786f777f 100644 --- a/sql/updates/8694_world_transport_events.sql +++ b/sql/updates/8694_world_transport_events.sql @@ -1 +1 @@ -DROP TABLE `transport_events`; +DROP TABLE IF EXISTS `transport_events`; -- cgit v1.2.3