diff options
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', |