diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/3593_world_spellclick_(dk).sql (renamed from sql/updates/3467_world_spellclick_spell.sql) | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/sql/updates/3467_world_spellclick_spell.sql b/sql/updates/3593_world_spellclick_(dk).sql index 41f93f190d4..52cc8eb4459 100644 --- a/sql/updates/3467_world_spellclick_spell.sql +++ b/sql/updates/3593_world_spellclick_(dk).sql @@ -2,6 +2,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'); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES +('29488', '54568', '12670', '1', '3'), +('29501', '54575', '12670', '1', '3'); + |