From 2abfecfb84f056bc79aa93264d825ff7832d6882 Mon Sep 17 00:00:00 2001 From: Drahy Date: Thu, 9 Apr 2009 03:35:51 +0200 Subject: * Updated sql and full_script files --HG-- branch : trunk --- sql/updates/1304_world.sql | 3 -- sql/updates/1311_characters.sql | 1 - sql/updates/1318_world_scripts.sql | 33 ---------------------- sql/updates/2444_world.sql | 3 ++ sql/updates/2508_characters.sql | 1 + sql/updates/2515_world_scripts.sql | 22 +++++++++++++++ sql/updates/2520_world.sql | 5 ---- sql/updates/2521_world.sql | 5 ++++ ...gos_7627_01_world_achievement_criteria_data.sql | 10 +++++++ ...gos_7633_01_world_achievement_criteria_data.sql | 5 ++++ .../7627_01_mangos_achievement_criteria_data.sql | 10 ------- .../7633_01_mangos_achievement_criteria_data.sql | 5 ---- sql/world_scripts_full.sql | 16 +++++++++++ 13 files changed, 62 insertions(+), 57 deletions(-) delete mode 100644 sql/updates/1304_world.sql delete mode 100644 sql/updates/1311_characters.sql delete mode 100644 sql/updates/1318_world_scripts.sql create mode 100644 sql/updates/2444_world.sql create mode 100644 sql/updates/2508_characters.sql create mode 100644 sql/updates/2515_world_scripts.sql delete mode 100644 sql/updates/2520_world.sql create mode 100644 sql/updates/2521_world.sql create mode 100644 sql/updates/2522_mangos_7627_01_world_achievement_criteria_data.sql create mode 100644 sql/updates/2528_mangos_7633_01_world_achievement_criteria_data.sql delete mode 100644 sql/updates/7627_01_mangos_achievement_criteria_data.sql delete mode 100644 sql/updates/7633_01_mangos_achievement_criteria_data.sql (limited to 'sql') diff --git a/sql/updates/1304_world.sql b/sql/updates/1304_world.sql deleted file mode 100644 index 9eff09829dc..00000000000 --- a/sql/updates/1304_world.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM command WHERE name IN ('reload spell_linked_spell'); -INSERT INTO command (name, security, help) VALUES -('reload spell_linked_spell','3','Usage: .reload spell_linked_spell\r\nReloads the spell_linked_spell DB table.'); \ No newline at end of file diff --git a/sql/updates/1311_characters.sql b/sql/updates/1311_characters.sql deleted file mode 100644 index 2ab9c8ecd93..00000000000 --- a/sql/updates/1311_characters.sql +++ /dev/null @@ -1 +0,0 @@ -DROP TABLE IF EXISTS `has_logged_in_before`; diff --git a/sql/updates/1318_world_scripts.sql b/sql/updates/1318_world_scripts.sql deleted file mode 100644 index bae41913997..00000000000 --- a/sql/updates/1318_world_scripts.sql +++ /dev/null @@ -1,33 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='mob_giant_infernal' WHERE `entry`=17908; -UPDATE `creature_template` SET `ScriptName`='mob_abomination' WHERE `entry`=17898; -UPDATE `creature_template` SET `ScriptName`='mob_ghoul' WHERE `entry`=17895; -UPDATE `creature_template` SET `ScriptName`='mob_necromancer' WHERE `entry`=17899; -UPDATE `creature_template` SET `ScriptName`='mob_banshee' WHERE `entry`=17905; -UPDATE `creature_template` SET `ScriptName`='mob_crypt_fiend' WHERE `entry`=17897; -UPDATE `creature_template` SET `ScriptName`='mob_fel_stalker' WHERE `entry`=17916; -UPDATE `creature_template` SET `ScriptName`='mob_frost_wyrm' WHERE `entry`=17907; -UPDATE `creature_template` SET `ScriptName`='mob_gargoyle' WHERE `entry`=17906; -UPDATE `creature_template` SET `ScriptName`='alliance_rifleman' WHERE `entry`=17921; - -UPDATE `creature_template` SET `ScriptName`='mob_towering_infernal' WHERE `entry`=17818; -UPDATE `creature_template` SET `ScriptName`='boss_anetheron' WHERE `entry`=17808; - -UPDATE `creature_template` SET `ScriptName`='boss_azgalor' WHERE `entry`=17842; -UPDATE `creature_template` SET `ScriptName`='mob_lesser_doomguard' WHERE `entry`=17864; - -UPDATE `creature_template` SET `ScriptName`='boss_kazrogal' WHERE `entry`=17888; - -UPDATE `creature_template` SET `ScriptName`='boss_rage_winterchill' WHERE `entry`=17767; - -UPDATE `creature_template` SET `scale`='0.5' WHERE `entry`=17968; - -UPDATE `creature_template` SET `equipment_id`='17888' WHERE `entry`=17888; -UPDATE `creature_template` SET `equipment_id`='17921' WHERE `entry`=17921; - -DELETE FROM creature_equip_template WHERE `entry` IN (17888, 17921); -INSERT INTO creature_equip_template () VALUES (17888, 45776, 0, 0, 33490946, 0, 0, 0, 0, 0); -INSERT INTO creature_equip_template () VALUES (17921, 20732, 0, 20732, 33489666, 0, 33489666, 26, 0, 26); - - - - diff --git a/sql/updates/2444_world.sql b/sql/updates/2444_world.sql new file mode 100644 index 00000000000..7eec5331e50 --- /dev/null +++ b/sql/updates/2444_world.sql @@ -0,0 +1,3 @@ +DELETE FROM `command` WHERE `name` IN ('reload spell_linked_spell'); +INSERT INTO `command` VALUES +('reload spell_linked_spell','3','Usage: .reload spell_linked_spell\r\nReloads the spell_linked_spell DB table.'); \ No newline at end of file diff --git a/sql/updates/2508_characters.sql b/sql/updates/2508_characters.sql new file mode 100644 index 00000000000..33d49010b93 --- /dev/null +++ b/sql/updates/2508_characters.sql @@ -0,0 +1 @@ +DROP TABLE IF EXISTS `has_logged_in_before`; \ No newline at end of file diff --git a/sql/updates/2515_world_scripts.sql b/sql/updates/2515_world_scripts.sql new file mode 100644 index 00000000000..e334e241585 --- /dev/null +++ b/sql/updates/2515_world_scripts.sql @@ -0,0 +1,22 @@ +UPDATE `creature_template` SET `ScriptName`='mob_giant_infernal' WHERE `entry`=17908; +UPDATE `creature_template` SET `ScriptName`='mob_abomination' WHERE `entry`=17898; +UPDATE `creature_template` SET `ScriptName`='mob_ghoul' WHERE `entry`=17895; +UPDATE `creature_template` SET `ScriptName`='mob_necromancer' WHERE `entry`=17899; +UPDATE `creature_template` SET `ScriptName`='mob_banshee' WHERE `entry`=17905; +UPDATE `creature_template` SET `ScriptName`='mob_crypt_fiend' WHERE `entry`=17897; +UPDATE `creature_template` SET `ScriptName`='mob_fel_stalker' WHERE `entry`=17916; +UPDATE `creature_template` SET `ScriptName`='mob_frost_wyrm' WHERE `entry`=17907; +UPDATE `creature_template` SET `ScriptName`='mob_gargoyle' WHERE `entry`=17906; +UPDATE `creature_template` SET `ScriptName`='alliance_rifleman' WHERE `entry`=17921; +UPDATE `creature_template` SET `ScriptName`='mob_towering_infernal' WHERE `entry`=17818; +UPDATE `creature_template` SET `ScriptName`='boss_anetheron' WHERE `entry`=17808; +UPDATE `creature_template` SET `ScriptName`='boss_azgalor' WHERE `entry`=17842; +UPDATE `creature_template` SET `ScriptName`='mob_lesser_doomguard' WHERE `entry`=17864; +UPDATE `creature_template` SET `ScriptName`='boss_kazrogal' WHERE `entry`=17888; +UPDATE `creature_template` SET `ScriptName`='boss_rage_winterchill' WHERE `entry`=17767; +UPDATE `creature_template` SET `scale`='0.5' WHERE `entry`=17968; +UPDATE `creature_template` SET `equipment_id`='17888' WHERE `entry`=17888; +UPDATE `creature_template` SET `equipment_id`='17921' WHERE `entry`=17921; +/*DELETE FROM creature_equip_template WHERE `entry` IN (17888, 17921); +INSERT INTO creature_equip_template () VALUES (17888, 45776, 0, 0, 33490946, 0, 0, 0, 0, 0); +INSERT INTO creature_equip_template () VALUES (17921, 20732, 0, 20732, 33489666, 0, 33489666, 26, 0, 26);*/ \ No newline at end of file diff --git a/sql/updates/2520_world.sql b/sql/updates/2520_world.sql deleted file mode 100644 index dfd7d97c292..00000000000 --- a/sql/updates/2520_world.sql +++ /dev/null @@ -1,5 +0,0 @@ --- Sudden Death -DELETE FROM `spell_proc_event` WHERE `entry` IN (29723, 29725, 29724); -INSERT INTO `spell_proc_event` VALUES (29723, 0x00, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000001, 0.000000, 0.000000, 0); -INSERT INTO `spell_proc_event` VALUES (29725, 0x00, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000001, 0.000000, 0.000000, 0); -INSERT INTO `spell_proc_event` VALUES (29724, 0x00, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000001, 0.000000, 0.000000, 0); diff --git a/sql/updates/2521_world.sql b/sql/updates/2521_world.sql new file mode 100644 index 00000000000..310996b88a4 --- /dev/null +++ b/sql/updates/2521_world.sql @@ -0,0 +1,5 @@ +-- Sudden Death +DELETE FROM `spell_proc_event` WHERE `entry` IN (29723, 29725, 29724); +INSERT INTO `spell_proc_event` VALUES (29723, 0x00, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000001, 0.000000, 0.000000, 0); +INSERT INTO `spell_proc_event` VALUES (29725, 0x00, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000001, 0.000000, 0.000000, 0); +INSERT INTO `spell_proc_event` VALUES (29724, 0x00, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000001, 0.000000, 0.000000, 0); \ No newline at end of file diff --git a/sql/updates/2522_mangos_7627_01_world_achievement_criteria_data.sql b/sql/updates/2522_mangos_7627_01_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..da2fecf8971 --- /dev/null +++ b/sql/updates/2522_mangos_7627_01_world_achievement_criteria_data.sql @@ -0,0 +1,10 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7622_03_mangos_creature_ai_texts required_7627_01_mangos_achievement_criteria_data bit;*/ + +DROP TABLE IF EXISTS `achievement_criteria_data`; +CREATE TABLE `achievement_criteria_data` ( + `criteria_id` mediumint(8) NOT NULL, + `type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `value1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `value2` mediumint(8) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`criteria_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Achievment system'; \ No newline at end of file diff --git a/sql/updates/2528_mangos_7633_01_world_achievement_criteria_data.sql b/sql/updates/2528_mangos_7633_01_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..4cc035e3169 --- /dev/null +++ b/sql/updates/2528_mangos_7633_01_world_achievement_criteria_data.sql @@ -0,0 +1,5 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7627_01_mangos_achievement_criteria_data required_7633_01_mangos_achievement_criteria_data bit;*/ + +ALTER TABLE `achievement_criteria_data` + DROP PRIMARY KEY, + ADD PRIMARY KEY (`criteria_id`,`type`); \ No newline at end of file diff --git a/sql/updates/7627_01_mangos_achievement_criteria_data.sql b/sql/updates/7627_01_mangos_achievement_criteria_data.sql deleted file mode 100644 index 29a095c5dd5..00000000000 --- a/sql/updates/7627_01_mangos_achievement_criteria_data.sql +++ /dev/null @@ -1,10 +0,0 @@ -ALTER TABLE db_version CHANGE COLUMN required_7622_03_mangos_creature_ai_texts required_7627_01_mangos_achievement_criteria_data bit; - -DROP TABLE IF EXISTS `achievement_criteria_data`; -CREATE TABLE `achievement_criteria_data` ( - `criteria_id` mediumint(8) NOT NULL, - `type` tinyint(3) unsigned NOT NULL DEFAULT '0', - `value1` mediumint(8) unsigned NOT NULL DEFAULT '0', - `value2` mediumint(8) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`criteria_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Achievment system'; diff --git a/sql/updates/7633_01_mangos_achievement_criteria_data.sql b/sql/updates/7633_01_mangos_achievement_criteria_data.sql deleted file mode 100644 index 6a8905ef935..00000000000 --- a/sql/updates/7633_01_mangos_achievement_criteria_data.sql +++ /dev/null @@ -1,5 +0,0 @@ -ALTER TABLE db_version CHANGE COLUMN required_7627_01_mangos_achievement_criteria_data required_7633_01_mangos_achievement_criteria_data bit; - -ALTER TABLE `achievement_criteria_data` - DROP PRIMARY KEY, - ADD PRIMARY KEY (`criteria_id`,`type`); diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql index b3ab01427ae..6118ceedbf4 100644 --- a/sql/world_scripts_full.sql +++ b/sql/world_scripts_full.sql @@ -292,6 +292,22 @@ UPDATE `creature_template` SET `ScriptName`='boss_archimonde' WHERE `entry`=1796 UPDATE `creature_template` SET `ScriptName`='mob_doomfire' WHERE `entry`=18095; UPDATE `creature_template` SET `ScriptName`='mob_doomfire_targetting' WHERE `entry`=18104; UPDATE `creature_template` SET `ScriptName`='mob_ancient_wisp' WHERE `entry`=17946; +UPDATE `creature_template` SET `ScriptName`='mob_giant_infernal' WHERE `entry`=17908; +UPDATE `creature_template` SET `ScriptName`='mob_abomination' WHERE `entry`=17898; +UPDATE `creature_template` SET `ScriptName`='mob_ghoul' WHERE `entry`=17895; +UPDATE `creature_template` SET `ScriptName`='mob_necromancer' WHERE `entry`=17899; +UPDATE `creature_template` SET `ScriptName`='mob_banshee' WHERE `entry`=17905; +UPDATE `creature_template` SET `ScriptName`='mob_crypt_fiend' WHERE `entry`=17897; +UPDATE `creature_template` SET `ScriptName`='mob_fel_stalker' WHERE `entry`=17916; +UPDATE `creature_template` SET `ScriptName`='mob_frost_wyrm' WHERE `entry`=17907; +UPDATE `creature_template` SET `ScriptName`='mob_gargoyle' WHERE `entry`=17906; +UPDATE `creature_template` SET `ScriptName`='alliance_rifleman' WHERE `entry`=17921; +UPDATE `creature_template` SET `ScriptName`='mob_towering_infernal' WHERE `entry`=17818; +UPDATE `creature_template` SET `ScriptName`='boss_anetheron' WHERE `entry`=17808; +UPDATE `creature_template` SET `ScriptName`='boss_azgalor' WHERE `entry`=17842; +UPDATE `creature_template` SET `ScriptName`='mob_lesser_doomguard' WHERE `entry`=17864; +UPDATE `creature_template` SET `ScriptName`='boss_kazrogal' WHERE `entry`=17888; +UPDATE `creature_template` SET `ScriptName`='boss_rage_winterchill' WHERE `entry`=17767; /* OLD HILLSBRAD */ UPDATE `instance_template` SET `script`='instance_old_hillsbrad' WHERE `map`=560; -- cgit v1.2.3