diff options
| -rw-r--r-- | sql/updates/1304_world.sql | 3 | ||||
| -rw-r--r-- | sql/updates/1311_characters.sql | 1 | ||||
| -rw-r--r-- | sql/updates/2444_world.sql | 3 | ||||
| -rw-r--r-- | sql/updates/2508_characters.sql | 1 | ||||
| -rw-r--r-- | sql/updates/2515_world_scripts.sql (renamed from sql/updates/1318_world_scripts.sql) | 15 | ||||
| -rw-r--r-- | sql/updates/2521_world.sql (renamed from sql/updates/2520_world.sql) | 2 | ||||
| -rw-r--r-- | sql/updates/2522_mangos_7627_01_world_achievement_criteria_data.sql (renamed from sql/updates/7627_01_mangos_achievement_criteria_data.sql) | 4 | ||||
| -rw-r--r-- | sql/updates/2528_mangos_7633_01_world_achievement_criteria_data.sql | 5 | ||||
| -rw-r--r-- | sql/updates/7633_01_mangos_achievement_criteria_data.sql | 5 | ||||
| -rw-r--r-- | sql/world_scripts_full.sql | 16 |
10 files changed, 30 insertions, 25 deletions
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/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/1318_world_scripts.sql b/sql/updates/2515_world_scripts.sql index bae41913997..e334e241585 100644 --- a/sql/updates/1318_world_scripts.sql +++ b/sql/updates/2515_world_scripts.sql @@ -8,26 +8,15 @@ UPDATE `creature_template` SET `ScriptName`='mob_fel_stalker' WHERE `entry`=1791 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); +/*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); - - - - +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/2521_world.sql index dfd7d97c292..310996b88a4 100644 --- a/sql/updates/2520_world.sql +++ b/sql/updates/2521_world.sql @@ -2,4 +2,4 @@ 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); +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/7627_01_mangos_achievement_criteria_data.sql b/sql/updates/2522_mangos_7627_01_world_achievement_criteria_data.sql index 29a095c5dd5..da2fecf8971 100644 --- a/sql/updates/7627_01_mangos_achievement_criteria_data.sql +++ b/sql/updates/2522_mangos_7627_01_world_achievement_criteria_data.sql @@ -1,4 +1,4 @@ -ALTER TABLE db_version CHANGE COLUMN required_7622_03_mangos_creature_ai_texts required_7627_01_mangos_achievement_criteria_data bit; +/*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` ( @@ -7,4 +7,4 @@ CREATE TABLE `achievement_criteria_data` ( `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'; +) 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/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; |