diff options
| author | QAston <none@none> | 2009-08-17 14:55:50 +0200 |
|---|---|---|
| committer | QAston <none@none> | 2009-08-17 14:55:50 +0200 |
| commit | 445b8236a18c37fe683f7bbfd2bf8800aa9926ae (patch) | |
| tree | d0a588e6f814a99ee173929d05dab6d71fb4d1f8 /sql | |
| parent | 798ff48c597eb267a450ebff41c8764d2c886345 (diff) | |
*Implement aura type SPELL_AURA_MOD_XP_QUEST_PCT (291) and fix SPELL_AURA_MOD_XP_PCT(200) handler.
*Correct structure stored in world.sql for npc_spellclick_spells and fix world_script_text application.
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/FULL/world_script_texts.sql | 2 | ||||
| -rw-r--r-- | sql/world.sql | 4 |
2 files changed, 4 insertions, 2 deletions
diff --git a/sql/FULL/world_script_texts.sql b/sql/FULL/world_script_texts.sql index ba097629279..94ec7a1bdbc 100644 --- a/sql/FULL/world_script_texts.sql +++ b/sql/FULL/world_script_texts.sql @@ -2074,5 +2074,5 @@ INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, ` -- Dual Spec `npc_option` change UPDATE `npc_option` SET `id`=52,`action`=19 WHERE `id`=51 AND `action`=18 AND `option_text`='UNIT_NPC_FLAG_OUTDOORPVP'; -DELETE FROM `npc_option` WHERE `id`=51 AND `action`=16 AND `option_text`='Purchase a Dual Talent Specialization.'; +DELETE FROM `npc_option` WHERE `id`=51; INSERT INTO `npc_option` (`id`, `gossip_id`, `npcflag`, `icon`, `action`, `box_money`, `coded`, `option_text`, `box_text`) values('51','0','16','0','18','10000000','0','Purchase a Dual Talent Specialization.','Are you sure you wish to purchase a Dual Talent Specialization?'); diff --git a/sql/world.sql b/sql/world.sql index d8b81c9897f..94d3658aa89 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -1890,7 +1890,9 @@ SET character_set_client = utf8; CREATE TABLE `npc_spellclick_spells` ( `npc_entry` int(10) unsigned NOT NULL COMMENT 'reference to creature_template', `spell_id` int(10) unsigned NOT NULL COMMENT 'spell which should be casted ', - `quest_id` int(10) unsigned NOT NULL COMMENT 'reference to quest_template', + `quest_start` mediumint(8) unsigned NOT NULL COMMENT 'reference to quest_template', + `quest_start_active` tinyint(1) unsigned NOT NULL default '0', + `quest_end` mediumint(8) unsigned NOT NULL default '0', `cast_flags` tinyint(3) unsigned NOT NULL COMMENT 'first bit defines caster: 1=player, 0=creature; second bit defines target, same mapping as caster bit', `aura_required` int(11) unsigned NOT NULL default '0' COMMENT 'player without aura cant click', `aura_forbidden` int(11) unsigned NOT NULL default '0' COMMENT 'player with aura cant click', |