From ffca6ec384419fab9b9217fc39e922f47c5d65ba Mon Sep 17 00:00:00 2001 From: megamage Date: Wed, 27 May 2009 12:42:38 -0500 Subject: *Change vehicle faction the same as the driver's when driver enters it. *Fix 3593 sql. --HG-- branch : trunk --- sql/updates/3467_world_spellclick_(dk).sql | 8 ++++++++ sql/updates/3593_world_spellclick_(dk).sql | 3 --- 2 files changed, 8 insertions(+), 3 deletions(-) create mode 100644 sql/updates/3467_world_spellclick_(dk).sql (limited to 'sql') diff --git a/sql/updates/3467_world_spellclick_(dk).sql b/sql/updates/3467_world_spellclick_(dk).sql new file mode 100644 index 00000000000..52cc8eb4459 --- /dev/null +++ b/sql/updates/3467_world_spellclick_(dk).sql @@ -0,0 +1,8 @@ +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` (`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/updates/3593_world_spellclick_(dk).sql b/sql/updates/3593_world_spellclick_(dk).sql index 52cc8eb4459..5c31fcf65a3 100644 --- a/sql/updates/3593_world_spellclick_(dk).sql +++ b/sql/updates/3593_world_spellclick_(dk).sql @@ -1,6 +1,3 @@ -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` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES ('29488', '54568', '12670', '1', '3'), -- cgit v1.2.3