diff options
| author | megamage <none@none> | 2009-06-15 23:07:43 -0500 |
|---|---|---|
| committer | megamage <none@none> | 2009-06-15 23:07:43 -0500 |
| commit | 00f4a31b735f327b715ff12d82f78de33c95539e (patch) | |
| tree | eedf5857ff1a8be6bbbb7eb98b005565a07b9cb5 /sql/updates | |
| parent | 572a9191d970b9b960555c8a5d31efd3160a8b44 (diff) | |
[8016] Work at npc click table data use. Author: VladimirMangos
* New fields in `npc_spellclick_spells` for allow set npc spell click mode from quest to infinity
or to another quest, or from reward quest.
* Not expect (and forbid set UNIT_NPC_FLAG_SPELLCLICK in DB and set it at `npc_spellclick_spells` loading.
* Apply some speedups for creature checks affected by spel click state
*Also add target position of 51852. By Roland
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/4043_world_npc_spellclick_spells.sql | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/sql/updates/4043_world_npc_spellclick_spells.sql b/sql/updates/4043_world_npc_spellclick_spells.sql new file mode 100644 index 00000000000..2e1895a25fd --- /dev/null +++ b/sql/updates/4043_world_npc_spellclick_spells.sql @@ -0,0 +1,28 @@ +ALTER TABLE npc_spellclick_spells + DROP COLUMN quest_status, + CHANGE COLUMN quest_id quest_start mediumint(8) unsigned NOT NULL COMMENT 'reference to quest_template', + ADD COLUMN quest_start_active tinyint(1) unsigned NOT NULL default '0' AFTER quest_start, + ADD COLUMN quest_end mediumint(8) unsigned NOT NULL default '0' AFTER quest_start_active; + +/* compatibility with old data */ +UPDATE npc_spellclick_spells + SET quest_end = quest_start, quest_start_active = 1 + WHERE quest_start <> 0; + +DELETE FROM `npc_spellclick_spells` WHERE `spell_id` IN ( +54568, 54575, 52263, 52280, 52447); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`) VALUES +(29488, 54568, 12670, 1, 0, 3), -- Taxi to Death's Breath +(29501, 54575, 12670, 1, 0, 3), +(28605, 52263, 12680, 1, 12680, 1), -- Stolen Horse +(28606, 52263, 12680, 1, 12680, 1), +(28607, 52263, 12680, 1, 12680, 1), +(28782, 52280, 12687, 1, 12687, 1), -- Unbound Charger +(28833, 52447, 12701, 1, 12701, 1), -- Scarlet Cannon Master +(28887, 52447, 12701, 1, 12701, 1); + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (29912); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`) VALUES +(29912, 55479, 0, 0, 0, 3); # Obedience Crystal - Force Obedience + +REPLACE into `spell_target_position` values (51852, 609, 2361.21, -5660.45, 503.828, 4.49);
\ No newline at end of file |