diff options
| -rw-r--r-- | sql/updates/3593_world_spellclick_(dk).sql (renamed from sql/updates/3467_world_spellclick_spell.sql) | 7 | ||||
| -rw-r--r-- | sql/world_spell_full.sql | 15 |
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; |