From 42d904a8bf8c7a856f8303bf1f5577ca9079af73 Mon Sep 17 00:00:00 2001 From: teacher Date: Wed, 13 Jan 2010 21:28:35 +0100 Subject: Added long forgotten sql update for Rev6693 (Add support for RewSpellCast=-1. If -1 remove all auras applied to player at quest start). Thank you Warhead. --HG-- branch : trunk --- sql/updates/6979_world_scriptname.sql | 2 ++ sql/updates/6979_world_scriptnames.sql | 2 -- sql/updates/6984_world_quest_template.sql | 4 ++++ sql/updates/CMakeLists.txt | 1 + sql/world.sql | 8 ++++---- 5 files changed, 11 insertions(+), 6 deletions(-) create mode 100644 sql/updates/6979_world_scriptname.sql delete mode 100644 sql/updates/6979_world_scriptnames.sql create mode 100644 sql/updates/6984_world_quest_template.sql (limited to 'sql') diff --git a/sql/updates/6979_world_scriptname.sql b/sql/updates/6979_world_scriptname.sql new file mode 100644 index 00000000000..c4fb669d47d --- /dev/null +++ b/sql/updates/6979_world_scriptname.sql @@ -0,0 +1,2 @@ +UPDATE `creature_template` SET `ScriptName`='npc_bushwhacker' WHERE `entry`=28317; + diff --git a/sql/updates/6979_world_scriptnames.sql b/sql/updates/6979_world_scriptnames.sql deleted file mode 100644 index c4fb669d47d..00000000000 --- a/sql/updates/6979_world_scriptnames.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_bushwhacker' WHERE `entry`=28317; - diff --git a/sql/updates/6984_world_quest_template.sql b/sql/updates/6984_world_quest_template.sql new file mode 100644 index 00000000000..546898d10aa --- /dev/null +++ b/sql/updates/6984_world_quest_template.sql @@ -0,0 +1,4 @@ +ALTER TABLE `quest_template` CHANGE `RewSpellCast1` `RewSpellCast1` int(11) SIGNED NOT NULL DEFAULT 0; +ALTER TABLE `quest_template` CHANGE `RewSpellCast2` `RewSpellCast2` int(11) SIGNED NOT NULL DEFAULT 0; +ALTER TABLE `quest_template` CHANGE `RewSpellCast3` `RewSpellCast3` int(11) SIGNED NOT NULL DEFAULT 0; +ALTER TABLE `quest_template` CHANGE `RewSpellCast4` `RewSpellCast4` int(11) SIGNED NOT NULL DEFAULT 0; diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt index f8f6ac50e4b..3097e2d715d 100644 --- a/sql/updates/CMakeLists.txt +++ b/sql/updates/CMakeLists.txt @@ -1,6 +1,7 @@ add_subdirectory(2.4.3_old) add_subdirectory(3.0.9_old) add_subdirectory(3.1.3_old) +add_subdirectory(3.2.2a_old) FILE(GLOB _SQL_UPDATES *.sql) diff --git a/sql/world.sql b/sql/world.sql index b0552ec6646..63c669178e1 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -4308,10 +4308,10 @@ CREATE TABLE `quest_template` ( `ReqCreatureOrGOCount2` smallint(5) unsigned NOT NULL DEFAULT '0', `ReqCreatureOrGOCount3` smallint(5) unsigned NOT NULL DEFAULT '0', `ReqCreatureOrGOCount4` smallint(5) unsigned NOT NULL DEFAULT '0', - `ReqSpellCast1` mediumint(8) unsigned NOT NULL DEFAULT '0', - `ReqSpellCast2` mediumint(8) unsigned NOT NULL DEFAULT '0', - `ReqSpellCast3` mediumint(8) unsigned NOT NULL DEFAULT '0', - `ReqSpellCast4` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ReqSpellCast1` int(11) signed NOT NULL DEFAULT '0', + `ReqSpellCast2` int(11) signed NOT NULL DEFAULT '0', + `ReqSpellCast3` int(11) signed NOT NULL DEFAULT '0', + `ReqSpellCast4` int(11) signed NOT NULL DEFAULT '0', `RewChoiceItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewChoiceItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewChoiceItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0', -- cgit v1.2.3