From 260a864031c6c8b6ce1bfda2db4c2060c9437a90 Mon Sep 17 00:00:00 2001 From: Drahy Date: Sun, 3 May 2009 19:21:52 +0200 Subject: * Big cleanup in sql folder * Redone Full sql with scripts * Recommend you only reimport world_scripts_full + 3089_world_trinity_string of course --HG-- branch : trunk --- sql/updates/2.4.3_updates/1437_TC1_world_scripts.sql | 14 -------------- sql/updates/2.4.3_updates/1437_world_scripts.sql | 14 ++++++++++++++ sql/updates/2996_world_trinity_string.sql | 2 +- sql/updates/2997_world_trinity_string.sql | 2 +- sql/updates/3005_world_scripts.sql | 3 --- sql/updates/3008_1437_TC1_world_scripts.sql | 1 + sql/updates/3030_world_scripts.sql | 3 +++ sql/updates/3039_world_spell_linked_spell.sql | 3 +-- sql/updates/3070_TC1_1463_world_scripts.sql | 10 ++++++++++ sql/updates/3075_TC1_1465_world_scripts.sql | 1 + sql/updates/3089_world_trinity_string.sql | 3 +++ sql/updates/TC1_1463_world_scripts.sql | 10 ---------- sql/updates/TC1_1465_world_scripts.sql | 1 - 13 files changed, 35 insertions(+), 32 deletions(-) delete mode 100644 sql/updates/2.4.3_updates/1437_TC1_world_scripts.sql create mode 100644 sql/updates/2.4.3_updates/1437_world_scripts.sql delete mode 100644 sql/updates/3005_world_scripts.sql create mode 100644 sql/updates/3008_1437_TC1_world_scripts.sql create mode 100644 sql/updates/3030_world_scripts.sql create mode 100644 sql/updates/3070_TC1_1463_world_scripts.sql create mode 100644 sql/updates/3075_TC1_1465_world_scripts.sql create mode 100644 sql/updates/3089_world_trinity_string.sql delete mode 100644 sql/updates/TC1_1463_world_scripts.sql delete mode 100644 sql/updates/TC1_1465_world_scripts.sql (limited to 'sql/updates') diff --git a/sql/updates/2.4.3_updates/1437_TC1_world_scripts.sql b/sql/updates/2.4.3_updates/1437_TC1_world_scripts.sql deleted file mode 100644 index 7d53254cc5b..00000000000 --- a/sql/updates/2.4.3_updates/1437_TC1_world_scripts.sql +++ /dev/null @@ -1,14 +0,0 @@ -UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184418 LIMIT 1; -UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184419 LIMIT 1; -UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184420 LIMIT 1; -UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184421 LIMIT 1; -UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184422 LIMIT 1; -UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184423 LIMIT 1; -UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184424 LIMIT 1; -UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184425 LIMIT 1; -UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184426 LIMIT 1; -UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184427 LIMIT 1; -UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184428 LIMIT 1; -UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184429 LIMIT 1; -UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184430 LIMIT 1; -UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184431 LIMIT 1; \ No newline at end of file diff --git a/sql/updates/2.4.3_updates/1437_world_scripts.sql b/sql/updates/2.4.3_updates/1437_world_scripts.sql new file mode 100644 index 00000000000..7d53254cc5b --- /dev/null +++ b/sql/updates/2.4.3_updates/1437_world_scripts.sql @@ -0,0 +1,14 @@ +UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184418 LIMIT 1; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184419 LIMIT 1; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184420 LIMIT 1; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184421 LIMIT 1; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184422 LIMIT 1; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184423 LIMIT 1; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184424 LIMIT 1; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184425 LIMIT 1; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184426 LIMIT 1; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184427 LIMIT 1; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184428 LIMIT 1; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184429 LIMIT 1; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184430 LIMIT 1; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_prison' WHERE `entry` = 184431 LIMIT 1; \ No newline at end of file diff --git a/sql/updates/2996_world_trinity_string.sql b/sql/updates/2996_world_trinity_string.sql index 761ad5d99ee..5bc66239ba2 100644 --- a/sql/updates/2996_world_trinity_string.sql +++ b/sql/updates/2996_world_trinity_string.sql @@ -42,4 +42,4 @@ INSERT INTO `trinity_string` VALUES (1329, 'The Alliance Team is running out of reinforcements!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1330, 'The Horde Team is running out of reinforcements!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1331, 'The Frostwolf General is Dead!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -(1332, 'The Stormpike General is Dead!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); +(1332, 'The Stormpike General is Dead!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); \ No newline at end of file diff --git a/sql/updates/2997_world_trinity_string.sql b/sql/updates/2997_world_trinity_string.sql index 51a3547ec30..e27f7d1fd9c 100644 --- a/sql/updates/2997_world_trinity_string.sql +++ b/sql/updates/2997_world_trinity_string.sql @@ -1,3 +1,3 @@ DELETE FROM `trinity_string` WHERE `entry` = 5010; INSERT INTO `trinity_string` VALUES -(5010,'linkGUID: %u, Entry: %u (%s)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); +(5010,'linkGUID: %u, Entry: %u (%s)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); \ No newline at end of file diff --git a/sql/updates/3005_world_scripts.sql b/sql/updates/3005_world_scripts.sql deleted file mode 100644 index d2d5e4d0d84..00000000000 --- a/sql/updates/3005_world_scripts.sql +++ /dev/null @@ -1,3 +0,0 @@ -update creature_template set scriptname = 'npc_unworthy_initiate' where entry in (29519,29520,29565,29566,29567); -update creature_template set scriptname = 'npc_unworthy_initiate_anchor' where entry = 29521; -update gameobject_template set scriptname = 'go_acherus_soul_prison' where entry in (191577,191580,191581,191582,191583,191584,191585,191586,191587,191588,191589,191590); \ No newline at end of file diff --git a/sql/updates/3008_1437_TC1_world_scripts.sql b/sql/updates/3008_1437_TC1_world_scripts.sql new file mode 100644 index 00000000000..f4e4b7a1e9a --- /dev/null +++ b/sql/updates/3008_1437_TC1_world_scripts.sql @@ -0,0 +1 @@ +UPDATE `gameobject_template` SET `ScriptName`='go_ethereum_prison' WHERE `entry` IN (184418,184419,184420,184421,184422,184423,184424,184425,184426,184427,184428,184429,184430,184431); \ No newline at end of file diff --git a/sql/updates/3030_world_scripts.sql b/sql/updates/3030_world_scripts.sql new file mode 100644 index 00000000000..301e13244a8 --- /dev/null +++ b/sql/updates/3030_world_scripts.sql @@ -0,0 +1,3 @@ +UPDATE `creature_template` SET `ScriptName`='npc_unworthy_initiate' WHERE `entry` IN (29519,29520,29565,29566,29567); +UPDATE `creature_template` SET `ScriptName`='npc_unworthy_initiate_anchor' WHERE `entry`=29521; +UPDATE `gameobject_template` SET `ScriptName`='go_acherus_soul_prison' WHERE `entry` IN (191577,191580,191581,191582,191583,191584,191585,191586,191587,191588,191589,191590); \ No newline at end of file diff --git a/sql/updates/3039_world_spell_linked_spell.sql b/sql/updates/3039_world_spell_linked_spell.sql index 82df917bf11..cc5bbc139ae 100644 --- a/sql/updates/3039_world_spell_linked_spell.sql +++ b/sql/updates/3039_world_spell_linked_spell.sql @@ -1,4 +1,3 @@ DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 38528 AND `spell_effect` = -32124; - INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES -(38528, -32124, 2, 'Protection of Elune - Denouement Wisp'); +(38528, -32124, 2, 'Protection of Elune - Denouement Wisp'); \ No newline at end of file diff --git a/sql/updates/3070_TC1_1463_world_scripts.sql b/sql/updates/3070_TC1_1463_world_scripts.sql new file mode 100644 index 00000000000..cccf264f9ef --- /dev/null +++ b/sql/updates/3070_TC1_1463_world_scripts.sql @@ -0,0 +1,10 @@ +UPDATE `instance_template` SET `script` = 'instance_blackrock_depths' WHERE `map` = 230; +UPDATE `creature_template` SET `ScriptName` = 'mob_voidtraveler' WHERE `entry` = 19226; +UPDATE `creature_template` SET `ScriptName` = 'mob_shadowy_construct' WHERE `entry` = 23111; +UPDATE `creature_template` SET `ScriptName` = 'mob_phalanx' WHERE `entry` = 9502; +UPDATE `creature_template` SET `ScriptName` = 'npc_draenei_survivor' WHERE `entry` = 16483; +UPDATE `creature_template` SET `ScriptName` = 'mob_inner_demon' WHERE entry = 21857; +UPDATE `creature_template` SET `ScriptName` = 'mob_webwrap' WHERE `entry` = 16486; +UPDATE `creature_template` SET `ScriptName` = 'mob_dragonmaw_peon' WHERE `entry` = 22252; +UPDATE `creature_template` SET `ScriptName` = 'npc_karynaku' WHERE `entry` = 22112; +UPDATE `creature_template` SET `ScriptName` = 'mob_ohgan' WHERE `entry` = 14988; \ No newline at end of file diff --git a/sql/updates/3075_TC1_1465_world_scripts.sql b/sql/updates/3075_TC1_1465_world_scripts.sql new file mode 100644 index 00000000000..8ffe4aa1333 --- /dev/null +++ b/sql/updates/3075_TC1_1465_world_scripts.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName` = 'mob_fiendish_imp' WHERE `entry` = 17267; \ No newline at end of file diff --git a/sql/updates/3089_world_trinity_string.sql b/sql/updates/3089_world_trinity_string.sql new file mode 100644 index 00000000000..274ad62e546 --- /dev/null +++ b/sql/updates/3089_world_trinity_string.sql @@ -0,0 +1,3 @@ +DELETE FROM `trinity_string` WHERE `entry` IN (101); +INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES +(101, 'Map: %u (%s) Zone: %u (%s) Area: %u (%s) Phase: %u\nX: %f Y: %f Z: %f Orientation: %f\ngrid[%u,%u]cell[%u,%u] InstanceID: %u\n ZoneX: %f ZoneY: %f\nGroundZ: %f FloorZ: %f Have height data (Map: %u VMap: %u)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); \ No newline at end of file diff --git a/sql/updates/TC1_1463_world_scripts.sql b/sql/updates/TC1_1463_world_scripts.sql deleted file mode 100644 index cccf264f9ef..00000000000 --- a/sql/updates/TC1_1463_world_scripts.sql +++ /dev/null @@ -1,10 +0,0 @@ -UPDATE `instance_template` SET `script` = 'instance_blackrock_depths' WHERE `map` = 230; -UPDATE `creature_template` SET `ScriptName` = 'mob_voidtraveler' WHERE `entry` = 19226; -UPDATE `creature_template` SET `ScriptName` = 'mob_shadowy_construct' WHERE `entry` = 23111; -UPDATE `creature_template` SET `ScriptName` = 'mob_phalanx' WHERE `entry` = 9502; -UPDATE `creature_template` SET `ScriptName` = 'npc_draenei_survivor' WHERE `entry` = 16483; -UPDATE `creature_template` SET `ScriptName` = 'mob_inner_demon' WHERE entry = 21857; -UPDATE `creature_template` SET `ScriptName` = 'mob_webwrap' WHERE `entry` = 16486; -UPDATE `creature_template` SET `ScriptName` = 'mob_dragonmaw_peon' WHERE `entry` = 22252; -UPDATE `creature_template` SET `ScriptName` = 'npc_karynaku' WHERE `entry` = 22112; -UPDATE `creature_template` SET `ScriptName` = 'mob_ohgan' WHERE `entry` = 14988; \ No newline at end of file diff --git a/sql/updates/TC1_1465_world_scripts.sql b/sql/updates/TC1_1465_world_scripts.sql deleted file mode 100644 index ca1d88f5b5c..00000000000 --- a/sql/updates/TC1_1465_world_scripts.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_fiendish_imp' WHERE `entry` = 17267; -- cgit v1.2.3