diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/characters.sql | 2 | ||||
| -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 |
4 files changed, 38 insertions, 1 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index 55a8796e6e4..f5650a35981 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -263,7 +263,7 @@ CREATE TABLE `characters` ( `position_y` float NOT NULL default '0', `position_z` float NOT NULL default '0', `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier', - `dungeon_difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0', + `dungeon_difficulty` tinyint(1) unsigned NOT NULL default '0', `orientation` float NOT NULL default '0', `taximask` longtext, `online` tinyint(3) unsigned NOT NULL default '0', 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); + + + + |