diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/3467_world_spellclick_spell.sql | 7 |
1 files changed, 7 insertions, 0 deletions
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'); |