diff options
| author | QAston <none@none> | 2009-08-17 02:53:39 +0200 |
|---|---|---|
| committer | QAston <none@none> | 2009-08-17 02:53:39 +0200 |
| commit | 41c12d173b8d0cf297edf70e40b8e13b9bf3af35 (patch) | |
| tree | 483b138dcad5abd803330495cc211c3a90218173 /sql/world.sql | |
| parent | 6359bfb27ac42392dc3a314fc5fe194964485931 (diff) | |
*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
Diffstat (limited to 'sql/world.sql')
| -rw-r--r-- | sql/world.sql | 4 |
1 files changed, 3 insertions, 1 deletions
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; |