*Fix a typo in 3467 sql that makes dk start zone taxi not work.

--HG--
branch : trunk

2 files changed, 14 insertions, 8 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');
+
diff --git a/sql/world_spell_full.sql b/sql/world_spell_full.sql
index 9c6f3bf1775..08a95ff1b39 100644
--- a/sql/world_spell_full.sql
+++ b/sql/world_spell_full.sql
@@ -167,11 +167,10 @@ UPDATE creature_template SET speed = 1.0 WHERE entry = 23095; # molten_flame
 -- CLICK
 -- --------
 
-DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (29501, 29488);
-INSERT INTO `npc_spellclick_spells` VALUES
-(29488, 54568, 12670, 1, 3),
-(29501, 54575, 12670, 1, 3);
-UPDATE `creature_template` SET `npcflag` = 16777216 WHERE `entry` IN (29501, 29488);
+DELETE FROM `npc_spellclick_spells` WHERE `npc_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');
 
 -- --------
 -- TARGET
@@ -1565,6 +1564,12 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
 
 update creature_template set minlevel=50,maxlevel=52,minhealth=2215,maxhealth=2317,faction_A=2084,faction_H=2084,mindmg=50,maxdmg=50 where entry=28528; -- ghoul
 
+-- taxi
+DELETE FROM `npc_spellclick_spells` WHERE `npc_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');
+
 -- frostbrood vanquisher
 update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110 where entry = 28670;