Core/Quests: Update `quest_template` and SMSG_QUEST_QUERY_RESPONSE

TODO:
- Validate SkillId and reward it
- Validate Currency, add it to the requires and reward it (after being able to read currency dbc)
- Update other quest related opcodes

6 files changed, 31 insertions, 0 deletions

diff --git a/sql/updates/world/2011_11_24_01_world_command.sql b/sql/updates/world/4.x/2011_11_24_01_world_command.sql
index 849a7538621..849a7538621 100644
--- a/sql/updates/world/2011_11_24_01_world_command.sql
+++ b/sql/updates/world/4.x/2011_11_24_01_world_command.sql
diff --git a/sql/updates/world/2011_11_24_02_world_player_xp_for_level.sql b/sql/updates/world/4.x/2011_11_24_02_world_player_xp_for_level.sql
index d108b01824d..d108b01824d 100644
--- a/sql/updates/world/2011_11_24_02_world_player_xp_for_level.sql
+++ b/sql/updates/world/4.x/2011_11_24_02_world_player_xp_for_level.sql
diff --git a/sql/updates/world/2011_11_25_02_world_item_script_names.sql b/sql/updates/world/4.x/2011_11_25_02_world_item_script_names.sql
index aaf843b91ae..aaf843b91ae 100644
--- a/sql/updates/world/2011_11_25_02_world_item_script_names.sql
+++ b/sql/updates/world/4.x/2011_11_25_02_world_item_script_names.sql
diff --git a/sql/updates/world/2011_11_25_02_world_item_template.sql b/sql/updates/world/4.x/2011_11_25_02_world_item_template.sql
index 8a047ed9d11..8a047ed9d11 100644
--- a/sql/updates/world/2011_11_25_02_world_item_template.sql
+++ b/sql/updates/world/4.x/2011_11_25_02_world_item_template.sql
diff --git a/sql/updates/world/2011_11_25_02_world_item_template_addon.sql b/sql/updates/world/4.x/2011_11_25_02_world_item_template_addon.sql
index 2d99d9fc610..2d99d9fc610 100644
--- a/sql/updates/world/2011_11_25_02_world_item_template_addon.sql
+++ b/sql/updates/world/4.x/2011_11_25_02_world_item_template_addon.sql
diff --git a/sql/updates/world/4.x/2011_12_26_02_world_quest_template.sql b/sql/updates/world/4.x/2011_12_26_02_world_quest_template.sql
new file mode 100644
index 00000000000..b43abd6f85d
--- /dev/null
+++ b/sql/updates/world/4.x/2011_12_26_02_world_quest_template.sql
@@ -0,0 +1,31 @@
+ALTER TABLE `quest_template` ADD COLUMN `MinimapTargetMark` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'  AFTER `SpecialFlags`,
+   ADD COLUMN `RewardSkillId` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RewardArenaPoints`,
+   ADD COLUMN `RewardSkillPoints` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RewardSkillId`,
+   ADD COLUMN `RewardReputationMask` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RewardSkillPoints`,
+   ADD COLUMN `QuestGiverPortrait` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RewardReputationMask`,
+   ADD COLUMN `QuestTurnInPortrait` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0'  AFTER `QuestGiverPortrait`,
+   ADD COLUMN `RequiredSpell` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RequiredItemCount6`,
+   ADD COLUMN `RewardCurrencyId1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'  AFTER `ObjectiveText4`,
+   ADD COLUMN `RewardCurrencyId2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RewardCurrencyId1`,
+   ADD COLUMN `RewardCurrencyId3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RewardCurrencyId2`,
+   ADD COLUMN `RewardCurrencyId4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RewardCurrencyId3`,
+   ADD COLUMN `RewardCurrencyCount1` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RewardCurrencyId4`,
+   ADD COLUMN `RewardCurrencyCount2` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RewardCurrencyCount1`,
+   ADD COLUMN `RewardCurrencyCount3` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RewardCurrencyCount2`,
+   ADD COLUMN `RewardCurrencyCount4` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RewardCurrencyCount3`,
+   ADD COLUMN `RequiredCurrencyId1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RewardCurrencyCount4`,
+   ADD COLUMN `RequiredCurrencyId2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RequiredCurrencyId1`,
+   ADD COLUMN `RequiredCurrencyId3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RequiredCurrencyId2`,
+   ADD COLUMN `RequiredCurrencyId4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RequiredCurrencyId3`,
+   ADD COLUMN `RequiredCurrencyCount1` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RequiredCurrencyId4`,
+   ADD COLUMN `RequiredCurrencyCount2` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RequiredCurrencyCount1`,
+   ADD COLUMN `RequiredCurrencyCount3` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RequiredCurrencyCount2`,
+   ADD COLUMN `RequiredCurrencyCount4` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'  AFTER `RequiredCurrencyCount3`,
+   ADD COLUMN `QuestGiverTextWindow` TEXT NULL DEFAULT NULL  AFTER `RequiredCurrencyCount4`,
+   ADD COLUMN `QuestGiverTargetName` TEXT NULL DEFAULT NULL  AFTER `QuestGiverTextWindow`,
+   ADD COLUMN `QuestTurnTextWindow` TEXT NULL DEFAULT NULL  AFTER `QuestGiverTargetName`,
+   ADD COLUMN `QuestTurnTargetName` TEXT NULL DEFAULT NULL  AFTER `QuestTurnTextWindow`,
+   ADD COLUMN `SoundAccept` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '890'  AFTER `QuestTurnTargetName`,
+   ADD COLUMN `SoundTurnIn` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '878'  AFTER `SoundAccept`;
+
+ALTER TABLE `quest_template` DROP COLUMN `Unknown0`; -- Not found on 422