From 41c12d173b8d0cf297edf70e40b8e13b9bf3af35 Mon Sep 17 00:00:00 2001
From: QAston <none@none>
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

