Add a column to npc_spellclick_spells table to check if quest is completed/rewarded or incompleted

1: completed or rewarded; 3: incompleted; default 3

--HG--
branch : trunk

2 files changed, 8 insertions, 0 deletions

diff --git a/sql/mangos.sql b/sql/mangos.sql
index 96da5218048..1561438c0a3 100644
--- a/sql/mangos.sql
+++ b/sql/mangos.sql
@@ -3168,6 +3168,7 @@ CREATE TABLE `npc_spellclick_spells` (
     `npc_entry` INT UNSIGNED NOT NULL COMMENT 'reference to creature_template',
     `spell_id` INT UNSIGNED NOT NULL COMMENT 'spell which should be casted ',
     `quest_id` INT UNSIGNED NOT NULL COMMENT 'reference to quest_template',
+    `quest_status` INT(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Quest status: 3 incompleted, 1 completed/rewarded',
     `cast_flags` TINYINT UNSIGNED NOT NULL COMMENT 'first bit defines caster: 1=player, 0=creature; second bit defines target, same mapping as caster bit'
 ) ENGINE = MYISAM DEFAULT CHARSET=utf8;
 
diff --git a/sql/updates/3467_world_spellclick_spell.sql b/sql/updates/3467_world_spellclick_spell.sql
new file mode 100644
index 00000000000..41f93f190d4
--- /dev/null
+++ b/sql/updates/3467_world_spellclick_spell.sql
@@ -0,0 +1,7 @@
+ALTER TABLE `npc_spellclick_spells`
+  ADD COLUMN `quest_status` int(11) UNSIGNED NOT NULL DEFAULT 3 COMMENT 'Quest status: 3 incompleted, 1 completed/rewarded' AFTER `quest_id`;
+
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN ('29501', '29488');
+INSERT INTO `npc_spellclick_spells` VALUES ('29488', '54568', '12670', '1', '3');
+INSERT INTO `npc_spellclick_spells` VALUES ('29501', '54575', '12670', '1', '3');
+UPDATE `creature_template` SET `npcflag` = 16777216 WHERE `entry` IN ('29501', '29488');