From 41c12d173b8d0cf297edf70e40b8e13b9bf3af35 Mon Sep 17 00:00:00 2001 From: QAston Date: Mon, 17 Aug 2009 02:53:39 +0200 Subject: *Add spell_bonus_data for lightwell - by Elron *Add aura_required, aura_forbidden, user_type columns to npc_spellclick_spells table for additional requirement checks *Remove workarounds from lightwell code and use new npc_spellclick_spells fields instead. --HG-- branch : trunk --- sql/world.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'sql/world.sql') diff --git a/sql/world.sql b/sql/world.sql index 21ae1fe7a35..d8b81c9897f 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -1892,7 +1892,9 @@ CREATE TABLE `npc_spellclick_spells` ( `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', `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', - `quest_status` int(11) unsigned NOT NULL default '3' COMMENT 'Quest status: 3 incompleted, 1 completed/rewarded' + `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', + `user_type` smallint(3) unsigned NOT NULL default '0' COMMENT 'relation with summoner: 0-no 1-friendly 2-raid 3-party player can click' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- cgit v1.2.3