diff options
| author | megamage <none@none> | 2009-04-08 12:28:41 -0500 |
|---|---|---|
| committer | megamage <none@none> | 2009-04-08 12:28:41 -0500 |
| commit | 74d553bc4caad3e35922463ec9d327c7fb741496 (patch) | |
| tree | 7cfd1767e7fa09d5384a97b5feb7d0c3f59b5036 /sql/updates | |
| parent | fc7d2a5393175c460c325f9f778a95aaf67388d3 (diff) | |
| parent | 2ebeb198add74c6d4bf73bf687e7e747355dbfe3 (diff) | |
*Merge.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/1304_world.sql | 3 | ||||
| -rw-r--r-- | sql/updates/1311_characters.sql | 1 | ||||
| -rw-r--r-- | sql/updates/1318_world_scripts.sql | 33 |
3 files changed, 37 insertions, 0 deletions
diff --git a/sql/updates/1304_world.sql b/sql/updates/1304_world.sql new file mode 100644 index 00000000000..9eff09829dc --- /dev/null +++ b/sql/updates/1304_world.sql @@ -0,0 +1,3 @@ +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 new file mode 100644 index 00000000000..2ab9c8ecd93 --- /dev/null +++ b/sql/updates/1311_characters.sql @@ -0,0 +1 @@ +DROP TABLE IF EXISTS `has_logged_in_before`; diff --git a/sql/updates/1318_world_scripts.sql b/sql/updates/1318_world_scripts.sql new file mode 100644 index 00000000000..bae41913997 --- /dev/null +++ b/sql/updates/1318_world_scripts.sql @@ -0,0 +1,33 @@ +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); + + + + |