diff options
| author | megamage <none@none> | 2009-05-26 23:19:49 -0500 |
|---|---|---|
| committer | megamage <none@none> | 2009-05-26 23:19:49 -0500 |
| commit | 1497d8f3914177fff8a4ce0a69fb33ac2263b3c5 (patch) | |
| tree | 6fd826cb329016df25a9f56d6fc1a3b550fa6ac6 /sql/updates | |
| parent | 9dda6392c1edc7a3f31ee31e942b0f7ad4d11a33 (diff) | |
*Fix a typo in 3467 sql that makes dk start zone taxi not work.
--HG--
branch : trunk
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'); + |