From 01396ac8e9185b3b1670a33dfc55af6634f450ef Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Tue, 6 Aug 2013 20:38:12 +0200 Subject: SQL: Rename sql in correct date --- sql/updates/world/2013_08_06_01_world_hor.sql | 24 ++++++++++++++++++++++++ sql/updates/world/2013_08_16_01_world_hor.sql | 24 ------------------------ 2 files changed, 24 insertions(+), 24 deletions(-) create mode 100644 sql/updates/world/2013_08_06_01_world_hor.sql delete mode 100644 sql/updates/world/2013_08_16_01_world_hor.sql (limited to 'sql') diff --git a/sql/updates/world/2013_08_06_01_world_hor.sql b/sql/updates/world/2013_08_06_01_world_hor.sql new file mode 100644 index 00000000000..c9b8ccf8266 --- /dev/null +++ b/sql/updates/world/2013_08_06_01_world_hor.sql @@ -0,0 +1,24 @@ +-- areatrigger for the shadow throne +DELETE FROM `areatrigger_scripts` WHERE `entry` = 5605; +INSERT INTO `areatrigger_scripts` (`entry`,`scriptname`) VALUES +(5605, 'at_shadow_throne'); + +-- jaina's equipment +DELETE FROM `creature_equip_template` WHERE `entry` = 36955 AND `id` = 1; +INSERT INTO `creature_equip_template` (`entry`, `id`, `itementry1`, `itementry2`,`itementry3`) VALUES +(36955, 1, 2177, 12869, 0); + +-- jaina's gossip menu (the same one FROM sylvanas) +UPDATE `creature_template` SET `gossip_menu_id` = 10909 WHERE `entry` = 36955; + +-- jaina's scriptai part 2 +UPDATE `creature_template` SET `ScriptName` = 'npc_jaina_or_sylvanas_escape_hor' WHERE `entry` in (36955, 37554); + +-- Raging Ghoul scriptai +UPDATE `creature_template` SET `ScriptName` = 'npc_raging_ghoul' WHERE `entry` = 36940; + +-- Risen Witch Doctor scriptai +UPDATE `creature_template` SET `ScriptName` = 'npc_risen_witch_doctor' WHERE `entry` = 36941; + +-- LumberINg Abomination scriptai +UPDATE `creature_template` SET `ScriptName` = 'npc_lumbering_abomination' WHERE `entry` = 37069; diff --git a/sql/updates/world/2013_08_16_01_world_hor.sql b/sql/updates/world/2013_08_16_01_world_hor.sql deleted file mode 100644 index c9b8ccf8266..00000000000 --- a/sql/updates/world/2013_08_16_01_world_hor.sql +++ /dev/null @@ -1,24 +0,0 @@ --- areatrigger for the shadow throne -DELETE FROM `areatrigger_scripts` WHERE `entry` = 5605; -INSERT INTO `areatrigger_scripts` (`entry`,`scriptname`) VALUES -(5605, 'at_shadow_throne'); - --- jaina's equipment -DELETE FROM `creature_equip_template` WHERE `entry` = 36955 AND `id` = 1; -INSERT INTO `creature_equip_template` (`entry`, `id`, `itementry1`, `itementry2`,`itementry3`) VALUES -(36955, 1, 2177, 12869, 0); - --- jaina's gossip menu (the same one FROM sylvanas) -UPDATE `creature_template` SET `gossip_menu_id` = 10909 WHERE `entry` = 36955; - --- jaina's scriptai part 2 -UPDATE `creature_template` SET `ScriptName` = 'npc_jaina_or_sylvanas_escape_hor' WHERE `entry` in (36955, 37554); - --- Raging Ghoul scriptai -UPDATE `creature_template` SET `ScriptName` = 'npc_raging_ghoul' WHERE `entry` = 36940; - --- Risen Witch Doctor scriptai -UPDATE `creature_template` SET `ScriptName` = 'npc_risen_witch_doctor' WHERE `entry` = 36941; - --- LumberINg Abomination scriptai -UPDATE `creature_template` SET `ScriptName` = 'npc_lumbering_abomination' WHERE `entry` = 37069; -- cgit v1.2.3