From f9f72b53af271873b268d6d977bb3425d2c23970 Mon Sep 17 00:00:00 2001 From: teacher Date: Mon, 21 Jun 2010 09:34:38 +0200 Subject: Added missed sql update file for Rev 8613. Removed hackish non-TrinityCore related 8640_world_creature_template.sql. Proper fix can be found on forum (Accepted Fixes). Don't worry if you used it, it was a harmless hotfix and it will not cause any issue when using proper fix from forum. Added to world_database missed changes updates. Minor sql standards cleanup. --HG-- branch : trunk --- sql/base/world_database.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'sql/base/world_database.sql') diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index f84a6b76705..f32713e4be6 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -567,6 +567,7 @@ INSERT INTO `command` VALUES ('reload areatrigger_teleport',3,'Syntax: .reload areatrigger_teleport\nReload areatrigger_teleport table.'), ('reload autobroadcast',3,'Syntax: .reload autobroadcast\nReload autobroadcast table.'), ('reload command',3,'Syntax: .reload command\nReload command table.'), +('reload conditions', 3, 'Reload conditions table.'), ('reload config',3,'Syntax: .reload config\r\n\r\nReload config settings (by default stored in trinityd.conf). Not all settings can be change at reload: some new setting values will be ignored until restart, some values will applied with delay or only to new objects/maps, some values will explicitly rejected to change at reload.'), ('reload creature_involvedrelation',3,'Syntax: .reload creature_involvedrelation\nReload creature_involvedrelation table.'), ('reload creature_linked_respawn',2,'Syntax: .reload creature_linked_respawn\r\nReload creature_linked_respawn table.'), @@ -624,10 +625,9 @@ INSERT INTO `command` VALUES ('reload spell_proc_event',3,'Syntax: .reload spell_proc_event\nReload spell_proc_event table.'), ('reload spell_required',3,'Syntax: .reload spell_required\nReload spell_required table.'), ('reload spell_scripts',3,'Syntax: .reload spell_scripts\nReload spell_scripts table.'), -('reload spell_script_target',3,'Syntax: .reload spell_script_target\nReload spell_script_target table.'), ('reload spell_target_position',3,'Syntax: .reload spell_target_position\nReload spell_target_position table.'), ('reload spell_threats',3,'Syntax: .reload spell_threats\nReload spell_threats table.'), -('reload creature_template','3','Syntax: .reload creature_template $entry\r\nReload the specified creature\'s template.'), +('reload creature_template','3','Syntax: .reload creature_template $entry\r\nReload the specified creature''s template.'), ('reload trinity_string',3,'Syntax: .reload trinity_string\nReload trinity_string table.'), ('reload waypoint_scripts',3,'Syntax: .reload waypoint_scripts\nReload waypoint_scripts table.'), ('repairitems',2,'Syntax: .repairitems\r\n\r\nRepair all selected player''s items.'), @@ -6110,6 +6110,7 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment (-59907, 7, 0, 'Lightwell Charges - Suicide'), ( 19263, 67801, 2, 'Deterrence'), ( 45524, 55095, 0, 'Chains of Ice - Frost Fever'), +( 20066,-61840, 0, 'Repentance'), -- Quest ( 40214, 40216, 2, 'Dragonmaw Illusion'), ( 40214, 42016, 2, 'Dragonmaw Illusion'), -- cgit v1.2.3