From 6f1a4247a4261d7f61f2b246e4a39f5e8a9334f7 Mon Sep 17 00:00:00 2001
From: Kudlaty <none@none>
Date: Mon, 15 Jun 2009 03:31:11 +0200
Subject: Merge [SD2] r1010 Removed script for general marcus (can be done with
 eventAI) r1011 Fix typos. Should not assign value. Expected equal-to
 operator. r1012 Added support for quest 5561 r1013 Remove redundant directory
 path, already in include path - Skip. r1014 Remove old tables in SD2 database
 no longer used. Remove ScriptName for script 'mob_eventai' that does no
 longer exist - Skip r1015 Added PostgreSQL database create structure - Skip

--HG--
branch : trunk
---
 sql/world_scripts_full.sql | 1 -
 1 file changed, 1 deletion(-)

(limited to 'sql/world_scripts_full.sql')

diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql
index 024e437c472..50b540967c4 100644
--- a/sql/world_scripts_full.sql
+++ b/sql/world_scripts_full.sql
@@ -799,7 +799,6 @@ UPDATE `creature_template` SET `ScriptName`='npc_kaya_flathoof' WHERE `entry`=11
 UPDATE `creature_template` SET `ScriptName`='npc_archmage_malin' WHERE `entry`=2708;
 UPDATE `creature_template` SET `ScriptName`='npc_bartleby' WHERE `entry`=6090;
 UPDATE `creature_template` SET `ScriptName`='npc_dashel_stonefist' WHERE `entry`=4961;
-UPDATE `creature_template` SET `ScriptName`='npc_general_marcus_jonathan' WHERE `entry`=466;
 UPDATE `creature_template` SET `ScriptName`='npc_lady_katrana_prestor' WHERE `entry`=1749;
 
 /* STRANGLETHORN VALE */
-- 
cgit v1.2.3


From 088884ba707ee2772a8d60b28bfa45742dbc4cbd Mon Sep 17 00:00:00 2001
From: QAston <none@none>
Date: Mon, 15 Jun 2009 14:42:46 +0200
Subject: *Some cleanup in full sqls.

--HG--
branch : trunk
---
 sql/world.sql                   | 1055 +--------------------------------------
 sql/world_scripts_full.sql      |    2 +-
 sql/world_scripts_structure.sql |   68 ---
 sql/world_spell_full.sql        |   96 +---
 4 files changed, 8 insertions(+), 1213 deletions(-)
 delete mode 100644 sql/world_scripts_structure.sql

(limited to 'sql/world_scripts_full.sql')

diff --git a/sql/world.sql b/sql/world.sql
index 47c7f8a6425..9915e83dc2a 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -13994,6 +13994,8 @@ INSERT INTO `spell_bonus_data` VALUES
 /*!40000 ALTER TABLE `spell_bonus_data` ENABLE KEYS */;
 UNLOCK TABLES;
 
+// TODO: update this after UDB release
+
 --
 -- Table structure for table `spell_disabled`
 --
@@ -14156,25 +14158,6 @@ CREATE TABLE `spell_enchant_proc_data` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Spell enchant proc data';
 SET character_set_client = @saved_cs_client;
 
---
--- Dumping data for table `spell_enchant_proc_data`
---
-
-LOCK TABLES `spell_enchant_proc_data` WRITE;
-/*!40000 ALTER TABLE `spell_enchant_proc_data` DISABLE KEYS */;
-INSERT INTO `spell_enchant_proc_data` VALUES
-(2,0,8.8,0),
-(12,0,8.8,0),
-(524,0,8.8,0),
-(1667,0,8.8,0),
-(1668,0,8.8,0),
-(2635,0,8.8,0),
-(3782,0,8.8,0),
-(3783,0,8.8,0),
-(3784,0,8.8,0);
-/*!40000 ALTER TABLE `spell_enchant_proc_data` ENABLE KEYS */;
-UNLOCK TABLES;
-
 --
 -- Table structure for table `spell_learn_spell`
 --
@@ -14247,134 +14230,6 @@ CREATE TABLE `spell_linked_spell` (
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Spell System';
 SET character_set_client = @saved_cs_client;
 
---
--- Dumping data for table `spell_linked_spell`
---
-
-LOCK TABLES `spell_linked_spell` WRITE;
-/*!40000 ALTER TABLE `spell_linked_spell` DISABLE KEYS */;
-INSERT INTO `spell_linked_spell` VALUES
-(-55053,55601,0,'Deathbloom (H)'),
-(-52610,-62071,0,'Savage Roar'),
-(-49012,49010,0,'Wyvern Sting'),
-(-49011,49009,0,'Wyvern Sting'),
-(-47953,60406,0,'Divine hymn buff to enemies'),
-(-46021,46020,0,'Teleport: Normal Realm'),
-(-41917,41915,0,'Summon Parasitic Shadowfiend'),
-(-41914,41915,0,'Summon Parasitic Shadowfiend'),
-(-41376,41377,0,'Spite'),
-(-39091,-39092,0,'Negative Charge'),
-(-39088,-29659,0,'Positive Charge'),
-(-38794,33686,0,'Murmur\'s Shockwave (Heroic)'),
-(-33711,33686,0,'Murmur\'s Shockwave (Normal)'),
-(-30410,44032,0,'Manticron Cube Mind Exhaustion'),
-(-29865,55594,0,'Deathbloom'),
-(-28169,28206,0,'Mutating Injection - Mutagen Explosion'),
-(-28169,28240,0,'Mutating Injection - Poison Cloud'),
-(-28084,-29660,0,'Negative Charge'),
-(-28059,-29659,0,'Positive Charge'),
-(-27068,27069,0,'Wyvern Sting'),
-(-24133,24135,0,'Wyvern Sting'),
-(-24132,24134,0,'Wyvern Sting'),
-(-19386,24131,0,'Wyvern Sting'),
-(781,56446,0,'Disengage'),
-(15237,23455,0,'Holy Nova (rank1)'),
-(15430,23458,0,'Holy Nova (rank2)'),
-(15431,23459,0,'Holy Nova (rank3)'),
-(16857,60089,0,'Faerie Fire (Feral) Rank 1'),
-(17390,60089,0,'Faerie Fire (Feral) Rank 2'),
-(17391,60089,0,'Faerie Fire (Feral) Rank 3'),
-(17392,60089,0,'Faerie Fire (Feral) Rank 4'),
-(17767,54501,2,'Consume Shadows - Rank 1'),
-(17850,54501,2,'Consume Shadows - Rank 2'),
-(17851,54501,2,'Consume Shadows - Rank 3'),
-(17852,54501,2,'Consume Shadows - Rank 4'),
-(17853,54501,2,'Consume Shadows - Rank 5'),
-(17854,54501,2,'Consume Shadows - Rank 6'),
-(25331,25329,0,'Holy Nova (rank7)'),
-(27011,60089,0,'Faerie Fire (Feral) Rank 5'),
-(27272,54501,2,'Consume Shadows - Rank 7'),
-(27799,27803,0,'Holy Nova (rank4)'),
-(27800,27804,0,'Holy Nova (rank5)'),
-(27801,27805,0,'Holy Nova (rank6)'),
-(28059,-28084,1,'Positive Charge - Negative Charge'),
-(28084,-28059,1,'Negative Charge - Positive Charge'),
-(28732,-28798,1,'Widow\'s Embrace - Frenzy'),
-(31224,-1543,2,'Cloak of Shadows - Flare'),
-(32386,60448,2,'Shadow Embrace Rank1'),
-(32388,60465,2,'Shadow Embrace Rank2'),
-(32389,60466,2,'Shadow Embrace Rank3'),
-(32390,60467,2,'Shadow Embrace Rank4'),
-(32391,60468,2,'Shadow Embrace Rank5'),
-(33206,44416,2,'Pain Suppression (threat)'),
-(33686,31705,0,'Murmur\'s Shockwave Jump'),
-(36574,36650,0,'Apply Phase Slip Vulnerability'),
-(39088,-39091,1,'Positive Charge - Negative Charge'),
-(39091,-39088,1,'Negative Charge - Positive Charge'),
-(39835,39968,1,'Needle Spine'),
-(39908,40017,1,'Eye Blast'),
-(40604,40616,1,'Fel Rage Aura'),
-(40616,41625,1,'Fel Rage Aura'),
-(41126,41131,1,'Flame Crash'),
-(41292,42017,2,'Aura of Suffering'),
-(43648,44007,1,'Storm Eye Safe Zone'),
-(43658,43655,0,'Electrical Arc Visual'),
-(43658,43656,0,'Electrical Arc Visual'),
-(43658,43659,0,'Electrical Arc Visual'),
-(43658,43654,0,'Electrical Arc Visual'),
-(43658,43653,0,'Electrical Arc Visual'),
-(44007,-43657,2,'Storm Eye Safe Zone Immune'),
-(44008,45265,1,'Static Disruption Visual'),
-(44867,-46019,2,'Spectral Exhaustion - Teleport: Spectral Realm'),
-(44869,44866,1,'Spectral Blast Portal'),
-(44869,-45018,1,'Remove Arcane Buffet'),
-(44869,46019,1,'Spectral Blast Teleport'),
-(45246,45348,1,'Apply Flame Touched'),
-(45248,45347,1,'Apply Dark Touched'),
-(45256,45347,1,'Apply Dark Touched'),
-(45270,45347,1,'Apply Dark Touched'),
-(45271,45347,1,'Apply Dark Touched'),
-(45329,45347,1,'Apply Dark Touched'),
-(45342,45348,1,'Apply Flame Touched'),
-(45347,-45348,1,'Remove Flame Touched'),
-(45348,-45347,1,'Remove Dark Touched'),
-(45661,45665,1,'Encapsulate'),
-(46019,-45018,1,'Remove Arcane Buffet'),
-(46019,46021,1,'Spectral Realm Aura'),
-(46020,44867,1,'Spectral Exhaustion'),
-(46228,-46247,0,'Black Hole Visual (Grown)'),
-(46228,46235,0,'Black Hole Visual (Grown)'),
-(46242,46247,0,'Black Hole Visual (Birth)'),
-(46262,46265,0,'Void Zone Visual'),
-(46771,45348,1,'Apply Flame Touched'),
-(47585,60069,0,'Dispersion (transform/regen)'),
-(47897,47960,1,'Shadowflame Rank 1'),
-(47987,54501,2,'Consume Shadows - Rank 8'),
-(47988,54501,2,'Consume Shadows - Rank 9'),
-(48077,48075,0,'Holy Nova (rank8)'),
-(48078,48076,0,'Holy Nova (rank9)'),
-(48263,61261,2,'Frost Presence'),
-(48265,49772,2,'Unholy Presence'),
-(48475,60089,0,'Faerie Fire (Feral) Rank 6'),
-(49576,49560,0,'Death Grip'),
-(49772,55222,2,'Unholy Presence'),
-(50720,59665,0,'Vigilance (redirect threat)'),
-(51723,52874,0,'Fan Of Knives'),
-(52610,62071,0,'Savage Roar'),
-(53563,53651,2,'Beacon of Light'),
-(54097,-54100,1,'Widow\'s Embrace - Frenzy (H)'),
-(54643,-54643,2,'Wintergrasp Defender Teleport'),
-(57635,57636,0,'Disengage'),
-(58666,58672,1,'Impale (Archavon)'),
-(60882,58672,1,'Impale (Archavon)'),
-(60932,60934,0,'Disengage'),
-(61290,61291,1,'Shadowflame Rank 2'),
-(61507,61508,0,'Disengage'),
-(61846,61848,2,'Aspect of te dragonhawk'),
-(61847,61848,2,'Aspect of te dragonhawk');
-/*!40000 ALTER TABLE `spell_linked_spell` ENABLE KEYS */;
-UNLOCK TABLES;
-
 --
 -- Table structure for table `spell_loot_template`
 --
@@ -14490,912 +14345,6 @@ CREATE TABLE `spell_proc_event` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
---
--- Dumping data for table `spell_proc_event`
---
-
-LOCK TABLES `spell_proc_event` WRITE;
-/*!40000 ALTER TABLE `spell_proc_event` DISABLE KEYS */;
-INSERT INTO `spell_proc_event` VALUES
-(324,0,0,0,0,0,0,0,0,0,3),
-(325,0,0,0,0,0,0,0,0,0,3),
-(905,0,0,0,0,0,0,0,0,0,3),
-(945,0,0,0,0,0,0,0,0,0,3),
-(974,0,0,0,0,0,0,0,0,0,3),
-(1463,0,0,0,0,0,0,1024,0,0,0),
-(3232,0,0,0,0,0,0,2,0,0,0),
-(5952,0,8,1,1,0,0,0,0,0,0),
-(6346,0,0,0,0,0,0,256,0,0,0),
-(7383,1,0,0,0,0,0,256,0,0,0),
-(7434,0,0,0,0,0,0,2,0,0,0),
-(8134,0,0,0,0,0,0,0,0,0,3),
-(8178,0,0,0,0,0,0,65536,0,0,0),
-(8494,0,0,0,0,0,0,1024,0,0,0),
-(8495,0,0,0,0,0,0,1024,0,0,0),
-(9452,0,0,0,0,0,0,0,3,0,0),
-(9782,0,0,0,0,0,0,64,0,0,0),
-(9784,0,0,0,0,0,0,64,0,0,0),
-(9799,0,0,0,0,0,0,2,0,0,0),
-(10191,0,0,0,0,0,0,1024,0,0,0),
-(10192,0,0,0,0,0,0,1024,0,0,0),
-(10193,0,0,0,0,0,0,1024,0,0,0),
-(10431,0,0,0,0,0,0,0,0,0,3),
-(10432,0,0,0,0,0,0,0,0,0,3),
-(11095,0,3,16,0,0,0,0,0,0,0),
-(11119,4,3,0,0,0,0,2,0,0,0),
-(11120,4,3,0,0,0,0,2,0,0,0),
-(11129,0,3,12582935,64,0,0,0,0,0,0),
-(11180,16,3,0,0,0,0,0,0,0,0),
-(11185,0,3,128,0,0,327680,0,0,0,0),
-(11255,0,3,16384,0,0,0,0,0,0,0),
-(12169,0,0,0,0,0,0,64,0,0,0),
-(12281,0,0,0,0,0,0,0,0,0,6),
-(12289,0,4,2,0,0,0,0,0,0,0),
-(12298,0,0,0,0,0,0,64,0,0,0),
-(12311,0,4,2048,1,0,0,0,0,0,0),
-(12319,0,0,0,0,0,0,2,0,0,0),
-(12322,0,0,0,0,0,0,0,2,0,0),
-(12487,0,3,128,0,0,327680,0,0,0,0),
-(12488,0,3,128,0,0,327680,0,0,0,0),
-(12598,0,3,16384,0,0,0,0,0,0,0),
-(12668,0,4,2,0,0,0,0,0,0,0),
-(12724,0,0,0,0,0,0,64,0,0,0),
-(12725,0,0,0,0,0,0,64,0,0,0),
-(12726,0,0,0,0,0,0,64,0,0,0),
-(12727,0,0,0,0,0,0,64,0,0,0),
-(12797,0,4,1024,0,0,0,0,0,0,0),
-(12799,0,4,1024,0,0,0,0,0,0,0),
-(12812,0,0,0,0,0,0,0,0,0,6),
-(12813,0,0,0,0,0,0,0,0,0,6),
-(12814,0,0,0,0,0,0,0,0,0,6),
-(12815,0,0,0,0,0,0,0,0,0,6),
-(12834,0,0,0,0,0,0,2,0,0,0),
-(12846,4,3,0,0,0,0,2,0,0,0),
-(12847,4,3,0,0,0,0,2,0,0,0),
-(12848,4,3,0,0,0,0,2,0,0,0),
-(12849,0,0,0,0,0,0,2,0,0,0),
-(12867,0,0,0,0,0,0,2,0,0,0),
-(12872,0,3,16,0,0,0,0,0,0,0),
-(12873,0,3,16,0,0,0,0,0,0,0),
-(12958,0,4,2048,1,0,0,0,0,0,0),
-(12966,0,0,0,0,0,0,65536,0,0,0),
-(12967,0,0,0,0,0,0,65536,0,0,0),
-(12968,0,0,0,0,0,0,65536,0,0,0),
-(12969,0,0,0,0,0,0,65536,0,0,0),
-(12970,0,0,0,0,0,0,65536,0,0,0),
-(12971,0,0,0,0,0,0,2,0,0,0),
-(12972,0,0,0,0,0,0,2,0,0,0),
-(12973,0,0,0,0,0,0,2,0,0,0),
-(12974,0,0,0,0,0,0,2,0,0,0),
-(12999,0,0,0,0,0,0,0,4,0,0),
-(13000,0,0,0,0,0,0,0,6,0,0),
-(13001,0,0,0,0,0,0,0,8,0,0),
-(13002,0,0,0,0,0,0,0,10,0,0),
-(13163,0,0,0,0,0,0,16,0,0,0),
-(13165,0,9,1,0,0,0,0,0,0,0),
-(13754,0,8,16,0,0,0,0,0,0,0),
-(13867,0,8,16,0,0,0,0,0,0,0),
-(13983,0,0,0,0,0,0,24,0,0,0),
-(14070,0,0,0,0,0,0,24,0,0,0),
-(14071,0,0,0,0,0,0,24,0,0,0),
-(14156,0,8,4063232,0,0,0,0,0,0,0),
-(14160,0,8,4063232,0,0,0,0,0,0,0),
-(14161,0,8,4063232,0,0,0,0,0,0,0),
-(14186,0,8,1082131720,2,0,0,2,0,0,0),
-(14190,0,8,1082131720,2,0,0,2,0,0,0),
-(14193,0,8,1082131720,2,0,0,2,0,0,0),
-(14194,0,8,1082131720,2,0,0,2,0,0,0),
-(14195,0,8,1082131720,2,0,0,2,0,0,0),
-(14318,0,9,1,0,0,0,0,0,0,0),
-(14319,0,9,1,0,0,0,0,0,0,0),
-(14320,0,9,1,0,0,0,0,0,0,0),
-(14321,0,9,1,0,0,0,0,0,0,0),
-(14322,0,9,1,0,0,0,0,0,0,0),
-(14531,0,0,0,0,0,0,2,0,0,0),
-(14774,0,0,0,0,0,0,2,0,0,0),
-(14892,0,6,268443136,65540,0,0,2,0,0,0),
-(15088,0,0,0,0,0,0,2,0,0,0),
-(15128,4,0,0,0,0,0,0,0,0,0),
-(15277,0,0,0,0,0,0,0,6,0,0),
-(15286,32,6,0,0,0,0,0,0,0,0),
-(15337,0,6,8192,2,0,0,2,0,0,0),
-(15338,0,6,8192,2,0,0,2,0,0,0),
-(15346,0,0,0,0,0,0,0,6,0,0),
-(15362,0,6,268443136,65540,0,0,2,0,0,0),
-(15363,0,6,268443136,65540,0,0,2,0,0,0),
-(15600,0,0,0,0,0,0,0,1,0,0),
-(16086,0,11,0,262144,0,0,0,0,0,0),
-(16164,0,11,2416967875,0,0,0,2,0,0,0),
-(16176,0,11,448,0,0,0,2,0,0,0),
-(16180,0,11,192,0,16,0,2,0,0,0),
-(16196,0,11,192,0,16,0,2,0,0,0),
-(16198,0,11,192,0,16,0,2,0,0,0),
-(16235,0,11,448,0,0,0,2,0,0,0),
-(16240,0,11,448,0,0,0,2,0,0,0),
-(16256,0,0,0,0,0,0,2,0,0,0),
-(16257,0,0,0,0,0,0,65536,0,0,0),
-(16277,0,0,0,0,0,0,65536,0,0,0),
-(16278,0,0,0,0,0,0,65536,0,0,0),
-(16279,0,0,0,0,0,0,65536,0,0,0),
-(16280,0,0,0,0,0,0,65536,0,0,0),
-(16281,0,0,0,0,0,0,2,0,0,0),
-(16282,0,0,0,0,0,0,2,0,0,0),
-(16283,0,0,0,0,0,0,2,0,0,0),
-(16284,0,0,0,0,0,0,2,0,0,0),
-(16487,0,0,0,0,0,0,2,0,0,0),
-(16489,0,0,0,0,0,0,2,0,0,0),
-(16492,0,0,0,0,0,0,2,0,0,0),
-(16544,0,11,0,262144,0,0,0,0,0,0),
-(16550,0,0,0,0,0,0,2,0,0,0),
-(16620,0,0,0,0,0,0,0,0,0,30),
-(16624,0,0,0,0,0,0,64,0,0,0),
-(16850,0,7,4,0,0,0,0,0,0,0),
-(16864,0,0,0,0,0,0,0,2,0,0),
-(16880,72,7,0,0,0,0,2,0,0,0),
-(16923,0,7,4,0,0,0,0,0,0,0),
-(16924,0,7,4,0,0,0,0,0,0,0),
-(16952,0,7,233472,1024,0,0,2,0,0,0),
-(16954,0,7,233472,1024,0,0,2,0,0,0),
-(16958,0,0,0,0,0,0,2,0,0,0),
-(16961,0,0,0,0,0,0,2,0,0,0),
-(17106,0,7,524288,0,0,0,0,0,0,0),
-(17107,0,7,524288,0,0,0,0,0,0,0),
-(17108,0,7,524288,0,0,0,0,0,0,0),
-(17364,8,0,0,0,0,0,0,0,0,0),
-(17495,0,0,0,0,0,0,64,0,0,0),
-(17619,0,13,0,0,0,32768,0,0,0,0),
-(17793,0,5,1,0,0,0,2,0,0,0),
-(17796,0,5,1,0,0,0,2,0,0,0),
-(17801,0,5,1,0,0,0,2,0,0,0),
-(17802,0,5,1,0,0,0,2,0,0,0),
-(17803,0,5,1,0,0,0,2,0,0,0),
-(18073,0,5,96,8388736,0,0,0,0,0,0),
-(18094,0,5,10,0,0,0,0,0,0,0),
-(18095,0,5,10,0,0,0,0,0,0,0),
-(18096,0,5,96,8388736,0,0,0,0,0,0),
-(18119,0,5,997,4288,0,0,0,0,0,0),
-(18120,0,5,997,4288,0,0,0,0,0,0),
-(18820,0,0,0,0,0,0,65536,0,0,0),
-(19184,0,9,20,8192,0,0,0,0,0,0),
-(19387,0,9,20,8192,0,0,0,0,0,0),
-(19388,0,9,20,8192,0,0,0,0,0,0),
-(19572,0,9,8388608,0,0,16384,0,0,0,0),
-(19573,0,9,8388608,0,0,16384,0,0,0,0),
-(20049,0,0,0,0,0,0,2,0,0,0),
-(20056,0,0,0,0,0,0,2,0,0,0),
-(20057,0,0,0,0,0,0,2,0,0,0),
-(20128,0,0,0,0,0,0,64,0,0,0),
-(20131,0,0,0,0,0,0,64,0,0,0),
-(20132,0,0,0,0,0,0,64,0,0,0),
-(20164,0,0,0,0,0,0,0,5,0,0),
-(20165,0,0,0,0,0,0,0,20,0,0),
-(20166,0,0,0,0,0,0,0,12,0,0),
-(20177,0,0,0,0,0,0,67,0,0,0),
-(20179,0,0,0,0,0,0,67,0,0,0),
-(20180,0,0,0,0,0,0,67,0,0,0),
-(20181,0,0,0,0,0,0,67,0,0,0),
-(20182,0,0,0,0,0,0,67,0,0,0),
-(20210,0,10,3221225472,0,0,0,2,0,0,0),
-(20212,0,10,3221225472,0,0,0,2,0,0,0),
-(20213,0,10,3221225472,0,0,0,2,0,0,0),
-(20214,0,10,3221225472,0,0,0,2,0,0,0),
-(20215,0,10,3221225472,0,0,0,2,0,0,0),
-(20234,0,10,32768,0,0,0,0,0,0,0),
-(20235,0,10,32768,0,0,0,0,0,0,0),
-(20375, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 7, 0, 1), -- Seal of Command
-(20500,0,4,268435456,0,0,0,0,0,0,0),
-(20501,0,4,268435456,0,0,0,0,0,0,0),
-(20705,0,0,0,0,0,0,2,0,0,0),
-(20911,0,0,0,0,0,0,112,0,0,0),
-(20925,0,0,0,0,0,0,64,0,0,0),
-(20927,0,0,0,0,0,0,64,0,0,0),
-(20928,0,0,0,0,0,0,64,0,0,0),
-(21185,0,0,0,0,0,0,0,0,0,10),
-(21882,0,0,0,0,0,0,2,0,0,0),
-(21890,0,4,712396527,876,0,0,0,0,0,0),
-(22007,0,3,2097185,0,0,0,65536,0,0,0),
-(22618,0,0,0,0,0,0,64,0,0,0),
-(22648,0,0,0,0,0,0,2,0,0,0),
-(23547,0,0,0,0,0,0,32,0,0,0),
-(23548,0,0,0,0,0,0,64,0,0,0),
-(23551,0,11,192,0,0,0,0,0,0,0),
-(23552,0,0,0,0,0,0,0,0,0,3),
-(23572,0,11,192,0,0,0,0,0,0,0),
-(23578,0,0,0,0,0,0,0,2,0,0),
-(23581,0,0,0,0,0,0,0,2,0,0),
-(23602,0,0,0,0,0,0,64,0,0,0),
-(23686,0,0,0,0,0,0,0,2,0,0),
-(23688,0,0,0,0,0,0,65536,0,0,0),
-(23689,0,0,0,0,0,0,0,4,0,0),
-(23695,0,4,2,0,0,0,0,0,0,0),
-(23721,0,9,2048,0,0,0,0,0,0,0),
-(23920,0,0,0,0,0,0,2048,0,0,0),
-(24353,0,0,0,0,0,0,2,0,0,0),
-(24389,0,3,12582935,64,0,0,0,0,0,0),
-(24398,0,0,0,0,0,0,0,0,0,3),
-(24658,0,0,0,0,0,82192,0,0,0,0),
-(24905,0,0,0,0,0,0,2,15,0,0),
-(24932,0,0,0,0,0,0,2,0,0,6),
-(25050,4,0,0,0,0,0,0,0,0,0),
-(25296,0,9,1,0,0,0,0,0,0,0),
-(25469,0,0,0,0,0,0,0,0,0,3),
-(25472,0,0,0,0,0,0,0,0,0,3),
-(25669,0,0,0,0,0,0,0,1,0,0),
-(25899,0,0,0,0,0,0,112,0,0,0),
-(25988,0,0,0,0,0,0,2,0,0,0),
-(26016,0,0,0,0,0,0,0,2,0,0),
-(26107,0,0,0,0,0,0,100,0,0,0),
-(26119,0,10,2416967683,0,0,0,65536,0,0,0),
-(26128,0,0,0,0,0,0,8,0,0,0),
-(26135,0,10,8388608,0,0,0,65536,0,0,0),
-(26480,0,0,0,0,0,0,0,3,0,0),
-(26605,0,0,0,0,0,0,2,0,0,0),
-(27044,0,9,1,0,0,0,0,0,0,0),
-(27131,0,0,0,0,0,0,1024,0,0,0),
-(27179,0,0,0,0,0,0,64,0,0,0),
-(27419,0,0,0,0,0,0,0,3,0,0),
-(27498,0,0,0,0,0,0,0,3,0,0),
-(27521,0,0,0,0,0,0,65536,0,0,15),
-(27656,0,0,0,0,0,0,0,3,0,0),
-(27774,0,0,0,0,0,0,65536,0,0,0),
-(27787,0,0,0,0,0,0,0,3,0,0),
-(27811,0,0,0,0,0,0,2,0,0,0),
-(27815,0,0,0,0,0,0,2,0,0,0),
-(27816,0,0,0,0,0,0,2,0,0,0),
-(28592,16,3,0,0,0,0,0,0,0,0),
-(28593,16,3,0,0,0,0,0,0,0,0),
-(28716,0,7,16,0,0,294912,0,0,0,0),
-(28719,0,7,32,0,0,0,2,0,0,0),
-(28744,0,7,64,0,0,278528,0,0,0,0),
-(28752,0,0,0,0,0,0,2,0,0,0),
-(28789,0,10,3221225472,0,0,0,0,0,0,0),
-(28802,0,0,0,0,0,0,65536,0,0,0),
-(28809,0,6,4096,0,0,0,2,0,0,0),
-(28812,0,8,33554438,0,0,0,2,0,0,0),
-(28816,0,0,0,0,0,0,0,3,0,0),
-(28823,0,11,192,0,0,0,0,0,0,0),
-(28847,0,7,32,0,0,0,0,0,0,0),
-(28849,0,11,128,0,0,0,0,0,0,0),
-(29074,20,3,0,0,0,0,2,0,0,0),
-(29075,20,3,0,0,0,0,2,0,0,0),
-(29076,20,3,0,0,0,0,2,0,0,0),
-(29150,0,0,0,0,0,0,0,3,0,0),
-(29179,0,0,0,0,0,0,2,0,0,0),
-(29180,0,0,0,0,0,0,2,0,0,0),
-(29385,0,0,0,0,0,0,0,7,0,0),
-(29441,0,0,0,0,0,0,8,0,0,1),
-(29444,0,0,0,0,0,0,8,0,0,1),
-(29455,0,0,0,0,0,0,64,0,0,0),
-(29501,0,0,0,0,0,0,0,3,0,0),
-(29593,0,0,0,0,0,0,112,0,0,0),
-(29594,0,0,0,0,0,0,112,0,0,0),
-(29624,0,0,0,0,0,0,0,3,0,0),
-(29625,0,0,0,0,0,0,0,3,0,0),
-(29626,0,0,0,0,0,0,0,3,0,0),
-(29632,0,0,0,0,0,0,0,3,0,0),
-(29633,0,0,0,0,0,0,0,3,0,0),
-(29634,0,0,0,0,0,0,0,3,0,0),
-(29635,0,0,0,0,0,0,0,3,0,0),
-(29636,0,0,0,0,0,0,0,3,0,0),
-(29637,0,0,0,0,0,0,0,3,0,0),
-(29801,0,0,0,0,0,0,2,0,0,0),
-(29834,0,0,0,0,0,0,65536,0,0,0),
-(29838,0,0,0,0,0,0,65536,0,0,0),
-(29977,0,3,12582935,64,0,0,0,0,0,0),
-(30003,0,0,0,0,0,0,2048,0,0,0),
-(30160,0,0,0,0,0,0,2,0,0,0),
-(30293,0,5,897,131264,0,0,0,0,0,0),
-(30295,0,5,897,131264,0,0,0,0,0,0),
-(30296,0,5,897,131264,0,0,0,0,0,0),
-(30299,126,0,0,0,0,0,0,0,0,0),
-(30301,126,0,0,0,0,0,0,0,0,0),
-(30302,126,0,0,0,0,0,0,0,0,0),
-(30675,0,11,3,0,0,0,0,0,0,0),
-(30678,0,11,3,0,0,0,0,0,0,0),
-(30679,0,11,3,0,0,0,0,0,0,0),
-(30701,28,0,0,0,0,0,0,0,0,0),
-(30705,28,0,0,0,0,0,0,0,0,0),
-(30802,0,0,0,0,0,0,2,0,0,0),
-(30803,0,0,0,0,0,0,2,0,0,0),
-(30804,0,0,0,0,0,0,2,0,0,0),
-(30805,0,0,0,0,0,0,2,0,0,0),
-(30806,0,0,0,0,0,0,2,0,0,0),
-(30807,0,0,0,0,0,0,2,0,0,0),
-(30808,0,0,0,0,0,0,2,0,0,0),
-(30809,0,0,0,0,0,0,2,0,0,0),
-(30810,0,0,0,0,0,0,2,0,0,0),
-(30811,0,0,0,0,0,0,2,0,0,0),
-(30823,0,0,0,0,0,0,0,10.5,0,0),
-(30881,0,0,0,0,0,0,0,0,0,5),
-(30883,0,0,0,0,0,0,0,0,0,5),
-(30884,0,0,0,0,0,0,0,0,0,5),
-(30885,0,0,0,0,0,0,0,0,0,5),
-(30886,0,0,0,0,0,0,0,0,0,5),
-(30937,32,0,0,0,0,0,0,0,0,0),
-(31124,0,8,16777222,0,0,0,0,0,0,0),
-(31126,0,8,16777222,0,0,0,0,0,0,0),
-(31221,0,8,4194304,0,0,81920,24577,0,0,0),
-(31222,0,8,4194304,0,0,81920,24577,0,0,0),
-(31223,0,8,4194304,0,0,81920,24577,0,0,0),
-(31244,0,8,4063232,9,0,0,4,0,0,0),
-(31245,0,8,4063232,9,0,0,4,0,0,0),
-(31394,32,0,0,0,0,0,0,0,0,0),
-(31569,0,3,65536,0,0,0,0,0,0,0),
-(31570,0,3,65536,0,0,0,0,0,0,0),
-(31571,0,3,0,34,0,16384,0,0,0,0),
-(31572,0,3,0,34,0,16384,0,0,0,0),
-(31794,0,0,0,0,0,0,65536,0,0,0),
-(31801,0,0,0,0,0,0,0,20,0,0),
-(31833,0,10,2147483648,0,0,0,0,0,0,0),
-(31835,0,10,2147483648,0,0,0,0,0,0,0),
-(31836,0,10,2147483648,0,0,0,0,0,0,0),
-(31871,0,10,16,0,0,16384,0,0,0,0),
-(31872,0,10,16,0,0,16384,0,0,0,0),
-(31876,0,10,8388608,0,0,0,0,0,0,0),
-(31877,0,10,8388608,0,0,0,0,0,0,0),
-(31878,0,10,8388608,0,0,0,0,0,0,0),
-(31904,0,0,0,0,0,0,64,0,0,0),
-(32385,0,5,1,262144,0,0,0,0,0,0),
-(32387,0,5,1,262144,0,0,0,0,0,0),
-(32392,0,5,1,262144,0,0,0,0,0,0),
-(32393,0,5,1,262144,0,0,0,0,0,0),
-(32394,0,5,1,262144,0,0,0,0,0,0),
-(32409,0,0,0,0,0,0,0,0,0,0),
-(32587,0,0,0,0,0,0,64,0,0,0),
-(32593,0,0,0,0,0,0,0,0,0,3),
-(32594,0,0,0,0,0,0,0,0,0,3),
-(32642,0,0,0,0,0,0,64,0,0,0),
-(32734,0,0,0,0,0,0,0,0,0,3),
-(32748,0,8,0,1,0,320,0,0,0,0),
-(32776,0,0,0,0,0,0,64,0,0,0),
-(32777,0,0,0,0,0,0,64,0,0,0),
-(32837,0,0,0,0,0,0,65536,0,0,45),
-(32844,0,0,0,0,0,0,0,2,0,0),
-(32885,0,0,0,0,0,0,2,0,0,0),
-(33076,0,0,0,0,0,656040,0,0,0,0),
-(33089,0,0,0,0,0,0,64,0,0,0),
-(33127,0,0,0,0,0,0,0,7,0,0),
-(33142,0,0,0,0,0,0,2,0,0,0),
-(33145,0,0,0,0,0,0,2,0,0,0),
-(33146,0,0,0,0,0,0,2,0,0,0),
-(33150,0,0,0,0,0,0,2,0,0,0),
-(33151,0,0,0,0,0,0,2,0,0,0),
-(33154,0,0,0,0,0,0,2,0,0,0),
-(33174,0,6,32,0,0,16384,0,0,0,0),
-(33182,0,6,32,0,0,16384,0,0,0,0),
-(33191,0,6,8421376,1024,0,0,0,0,0,0),
-(33192,0,6,8421376,1024,0,0,0,0,0,0),
-(33193,0,6,8421376,1024,0,0,0,0,0,0),
-(33297, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Quagmirrans Eye
-(33299,0,0,0,0,0,0,65536,0,0,0),
-(33510,0,0,0,0,0,0,0,5,0,0),
-(33648,0,0,0,0,0,0,2,0,0,0),
-(33719,0,0,0,0,0,0,2048,0,0,0),
-(33736,0,0,0,0,0,0,0,0,0,3),
-(33746,0,0,0,0,0,0,0,0,0,10),
-(33757,0,0,0,0,0,0,0,0,0,3),
-(33759,0,0,0,0,0,0,0,0,0,10),
-(33881,0,0,0,0,0,0,2,0,0,0),
-(33882,0,0,0,0,0,0,2,0,0,0),
-(33883,0,0,0,0,0,0,2,0,0,0),
-(33953,0,0,0,0,0,16384,0,0,0,45),
-(34074,0,0,0,0,0,0,3,0,0,0),
-(34080,0,0,0,0,0,0,8,0,0,0),
-(34138,0,11,128,0,0,0,0,0,0,0),
-(34139,0,10,1073741824,0,0,0,0,0,0,0),
-(34258,0,10,1024,8,0,0,0,0,0,0),
-(34262,0,10,8388608,0,0,0,65536,0,0,0),
-(34320, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 45), -- Shiffars Nexus-Horn
-(34355,0,0,0,0,0,0,0,0,0,3),
-(34457,0,0,0,0,0,0,2,0,0,0),
-(34497,0,0,0,0,0,0,2,0,0,0),
-(34498,0,0,0,0,0,0,2,0,0,0),
-(34499,0,0,0,0,0,0,2,0,0,0),
-(34500,0,0,0,0,0,0,2,0,0,0),
-(34502,0,0,0,0,0,0,2,0,0,0),
-(34503,0,0,0,0,0,0,2,0,0,0),
-(34584,0,0,0,0,0,0,0,0,0,30),
-(34586,0,0,0,0,0,0,0,1.5,0,0),
-(34598,0,0,0,0,0,0,0,0,0,45),
-(34749,0,0,0,0,0,0,8,0,0,0),
-(34753,0,6,6144,4,0,0,2,0,0,0),
-(34774,0,0,0,0,0,0,0,1.5,0,20),
-(34783,0,0,0,0,0,0,2048,0,0,0),
-(34827,0,0,0,0,0,0,0,0,0,3),
-(34859,0,6,6144,4,0,0,2,0,0,0),
-(34860,0,6,6144,4,0,0,2,0,0,0),
-(34914,0,6,8192,0,0,0,0,0,0,0),
-(34916,0,6,8192,0,0,0,0,0,0,0),
-(34917,0,6,8192,0,0,0,0,0,0,0),
-(34935,0,0,0,0,0,0,0,0,0,8),
-(34938,0,0,0,0,0,0,0,0,0,8),
-(34939,0,0,0,0,0,0,0,0,0,8),
-(34950,0,0,0,0,0,0,2,0,0,0),
-(34954,0,0,0,0,0,0,2,0,0,0),
-(35077,0,0,0,0,0,0,0,0,0,60),
-(35080,0,0,0,0,0,0,0,1,0,60),
-(35083,0,0,0,0,0,0,0,0,0,60),
-(35086,0,0,0,0,0,0,0,0,0,60),
-(35100,0,9,12289,0,0,65856,0,0,0,0),
-(35102,0,9,12289,0,0,0,0,0,0,0),
-(35121,0,0,0,0,0,0,2,0,0,0),
-(35541,	0x00,	0,	0x00000000,	0x00000000,	0x00000000,	0x00800000,	0x00000000,	0,	0,	0), -- Combat Potency
-(35550,	0x00,	0,	0x00000000,	0x00000000,	0x00000000,	0x00800000,	0x00000000,	0,	0,	0), -- Combat Potency
-(35551,	0x00,	0,	0x00000000,	0x00000000,	0x00000000,	0x00800000,	0x00000000,	0,	0,	0), -- Combat Potency
-(35552,	0x00,	0,	0x00000000,	0x00000000,	0x00000000,	0x00800000,	0x00000000,	0,	0,	0), -- Combat Potency
-(35553,	0x00,	0,	0x00000000,	0x00000000,	0x00000000,	0x00800000,	0x00000000,	0,	0,	0), -- Combat Potency
-(36032,0,3,2048,32768,0,0,0,0,0,0),
-(36096,0,0,0,0,0,0,2048,0,0,0),
-(36111,0,0,0,0,0,0,0,0,0,0),
-(36541,4,0,0,0,0,0,0,0,0,0),
-(37165,0,8,2098176,0,0,0,0,0,0,0),
-(37168,0,8,4063232,9,0,0,0,0,0,0),
-(37170,0,0,0,0,0,0,0,1,0,0),
-(37173,0,8,750519704,262,0,0,0,0,0,30),
-(37189,0,10,3221225472,0,0,0,2,0,0,60),
-(37193,0,0,0,0,0,0,64,0,0,0),
-(37195,0,10,8388608,0,0,0,0,0,0,0),
-(37197,0,0,0,0,0,0,65536,0,0,45),
-(37213,0,0,0,0,0,0,2,0,0,0),
-(37214,0,0,0,0,0,0,65536,0,0,0),
-(37227,0,11,448,0,0,0,2,0,0,60),
-(37237,0,11,1,0,0,0,2,0,0,0),
-(37247,8,0,0,0,0,0,65536,0,0,45),
-(37377,32,0,0,0,0,0,65536,0,0,0),
-(37379,32,5,0,0,0,0,0,0,0,0),
-(37384,0,5,1,0,0,0,0,0,0,0),
-(37443,0,0,0,0,0,0,2,0,0,0),
-(37514,0,0,0,0,0,0,32,0,0,0),
-(37516,0,4,1024,0,0,0,0,0,0,0),
-(37519,0,0,0,0,0,0,48,0,0,0),
-(37523,0,0,0,0,0,0,64,0,0,0),
-(37528,0,4,4,0,0,0,0,0,0,0),
-(37536,0,4,65536,0,0,0,0,0,0,0),
-(37568,0,6,2048,0,0,0,0,0,0,0),
-(37594,0,6,4096,0,0,0,0,0,0,0),
-(37600,0,0,0,0,0,0,65536,0,0,0),
-(37601,0,0,0,0,0,0,65536,0,0,0),
-(37603,0,6,32768,0,0,0,0,0,0,0),
-(37655,0,0,0,0,0,0,0,0,0,60),
-(37657,0,0,0,0,0,0,2,0,0,3),
-(38026,1,0,0,0,0,0,256,0,0,0),
-(38031,0,0,0,0,0,0,64,0,0,0),
-(38290,0,0,0,0,0,0,0,1.6,0,0),
-(38299, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 15), -- Fel Reavers Piston
-(38326,0,0,0,0,0,0,2,0,0,0),
-(38327,0,0,0,0,0,0,2,0,0,0),
-(38334,0,0,0,0,0,0,0,0,0,60),
-(38347, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 45), -- Sextant of Unstable Currents
-(38350,0,0,0,0,0,0,2,0,0,0),
-(38394,0,5,6,0,0,0,0,0,0,0),
-(38857,0,0,0,0,0,0,65536,0,0,0),
-(39027,0,0,0,0,0,0,0,0,0,3),
-(39372,48,0,0,0,0,0,0,0,0,0),
-(39437,4,5,4964,192,0,0,65536,0,0,0),
-(39442,0,0,0,0,0,0,1,0,0,0),
-(39443,0,0,0,0,0,0,2,0,0,0),
-(39530,0,0,0,0,0,0,65536,0,0,0),
-(39958,0,0,0,0,0,0,0,0.7,0,40),
-(40407,0,0,0,0,0,0,0,6,0,0),
-(40438,0,6,32832,0,0,0,0,0,0,0),
-(40442,0,7,20,1088,0,0,0,0,0,0),
-(40444,0,0,0,0,0,0,64,0,0,0),
-(40458,0,4,33554432,1537,0,0,0,0,0,0),
-(40463,0,11,129,16,0,0,0,0,0,0),
-(40470,0,10,3229614080,0,0,0,0,0,0,0),
-(40475,0,0,0,0,0,0,0,3,0,0),
-(40478,0,5,2,0,0,0,0,0,0,0),
-(40482,0,0,0,0,0,0,2,0,0,0),
-(40485,0,9,0,1,0,0,0,0,0,0),
-(40899,0,0,0,0,0,0,0,0,0,3),
-(41034,0,0,0,0,0,0,1024,0,0,0),
-(41260,0,0,0,0,0,0,0,0,0,10),
-(41262,0,0,0,0,0,0,0,0,0,10),
-(41381,0,0,0,0,0,0,256,0,0,0),
-(41393,0,0,0,0,0,0,32,0,0,0),
-(41434,0,0,0,0,0,0,0,2,0,45),
-(41469,0,0,0,0,0,0,0,7,0,0),
-(41635,0,0,0,0,0,656040,0,0,0,0),
-(41989,0,0,0,0,0,0,0,0.5,0,0),
-(42083,0,0,0,0,0,0,2,0,0,45),
-(42135,0,0,0,0,0,0,0,0,0,90),
-(42136,0,0,0,0,0,0,0,0,0,90),
-(42368,0,10,1073741824,0,0,0,0,0,0,0),
-(42370,0,11,64,0,0,0,0,0,0,0),
-(42770,0,0,0,0,0,0,65536,0,0,0),
-(43019,0,0,0,0,0,0,1024,0,0,0),
-(43020,0,0,0,0,0,0,1024,0,0,0),
-(43338,0,0,0,0,0,0,2,0,0,0),
-(43443,0,0,0,0,0,0,2048,0,0,0),
-(43726,0,10,1073741824,0,0,0,0,0,0,0),
-(43728,0,11,128,0,0,0,0,0,0,0),
-(43737,0,7,0,1088,0,0,0,0,0,10),
-(43739,0,7,2,0,0,0,0,0,0,0),
-(43741,0,10,2147483648,0,0,0,0,0,0,0),
-(43745,0,10,0,512,0,0,0,0,0,0),
-(43748,0,11,2416967680,0,0,0,0,0,0,0),
-(43750,0,11,1,0,0,0,0,0,0,0),
-(43819,0,0,0,0,0,0,65536,0,0,0),
-(44394,0,0,0,0,0,0,1024,0,0,0),
-(44395,0,0,0,0,0,0,1024,0,0,0),
-(44396,0,0,0,0,0,0,1024,0,0,0),
-(44401,0,3,2097152,0,0,0,4095,0,0,0),
-(44404,0,3,536870945,36864,0,0,0,0,0,0),
-(44442,0,3,8388608,64,0,0,65536,0,0,1),
-(44443,0,3,8388608,64,0,0,65536,0,0,1),
-(44445,0,3,19,4096,0,0,0,0,0,0),
-(44446,0,3,19,4096,0,0,0,0,0,0),
-(44448,0,3,19,4096,0,0,0,0,0,0),
-(44449,0,3,551686775,102472,0,0,2,0,0,0),
-(44469,0,3,551686775,102472,0,0,2,0,0,0),
-(44470,0,3,551686775,102472,0,0,2,0,0,0),
-(44471,0,3,551686775,102472,0,0,2,0,0,0),
-(44472,0,3,551686775,102472,0,0,2,0,0,0),
-(44543,0,3,1049120,4096,0,65536,0,0,7,0),
-(44545,0,3,1049120,4096,0,65536,0,0,15,0),
-(44546,0,3,33555104,0,0,0,0,0,0,0),
-(44548,0,3,33555104,0,0,0,0,0,0,0),
-(44549,0,3,33555104,0,0,0,0,0,0,0),
-(44745,0,3,0,1,0,32768,8192,0,0,0),
-(44835,0,7,0,128,0,16,0,0,0,0),
-(45054,0,0,0,0,0,0,0,0,0,15),
-(45057,0,0,0,0,0,0,0,0,0,30),
-(45234,0,0,0,0,0,0,2,0,0,0),
-(45243,0,0,0,0,0,0,2,0,0,0),
-(45244,0,0,0,0,0,0,2,0,0,0),
-(45354,0,0,0,0,0,0,0,0,0,45),
-(45469,0,15,16,0,0,16,0,0,0,0),
-(45481,0,0,0,0,0,0,0,0,0,45),
-(45482,0,0,0,0,0,0,0,0,0,45),
-(45483,0,0,0,0,0,0,0,0,0,45),
-(45484,0,0,0,0,0,16384,0,0,0,45),
-(46025,32,6,0,0,0,0,0,0,0,0),
-(46092,0,10,1073741824,0,0,0,0,0,0,0),
-(46098,0,11,128,0,0,0,0,0,0,0),
-(46569,0,0,0,0,0,0,0,0,0,45),
-(46662,0,0,0,0,0,0,0,0,0,20),
-(46832,0,7,1,0,0,0,65536,0,0,0),
-(46854,0,0,0,0,0,0,2,0,0,0),
-(46855,0,0,0,0,0,0,2,0,0,0),
-(46867,0,0,0,0,0,0,2,0,0,0),
-(46910,0,0,0,0,0,0,1,5.5,0,0),
-(46911,0,0,0,0,0,0,1,7.5,0,0),
-(46913,0,4,0,1024,0,0,0,0,0,0),
-(46914,0,4,0,1024,0,0,0,0,0,0),
-(46915,0,4,0,1024,0,0,0,0,0,0),
-(46916,0,4,0,1024,0,0,2,0,0,0),
-(46951,0,4,1024,64,0,0,0,0,0,0),
-(46952,0,0,1024,64,0,0,0,0,0,0),
-(46953,0,0,1024,64,0,0,0,0,0,0),
-(47195,0,5,2,0,0,0,0,0,0,30),
-(47196,0,5,2,0,0,0,0,0,0,30),
-(47197,0,5,2,0,0,0,0,0,0,30),
-(47201,0,5,8,262144,0,0,65536,0,0,0),
-(47202,0,5,8,262144,0,0,0,0,0,0),
-(47203,0,5,8,262144,0,0,0,0,0,0),
-(47204,0,5,8,262144,0,0,0,0,0,0),
-(47205,0,5,8,262144,0,0,0,0,0,0),
-(47245,32,5,0,0,0,0,0,0,0,0),
-(47246,32,5,0,0,0,0,0,0,0,0),
-(47247,32,5,0,0,0,0,0,0,0,0),
-(47258,0,5,0,8388608,0,0,65536,0,0,0),
-(47259,0,5,0,8388608,0,0,65536,0,0,0),
-(47260,0,5,0,8388608,0,0,65536,0,0,0),
-(47263,32,5,0,0,0,0,2,0,0,20),
-(47264,32,5,0,0,0,0,2,0,0,20),
-(47265,32,5,0,0,0,0,2,0,0,20),
-(47509,0,0,0,0,0,0,2,0,0,0),
-(47511,0,0,0,0,0,0,2,0,0,0),
-(47515,0,0,0,0,0,0,2,0,0,0),
-(47516,0,6,6144,65536,0,0,0,0,0,0),
-(47517,0,6,6144,65536,0,0,0,0,0,0),
-(47535,0,6,6144,65536,0,81936,0,0,0,0),
-(47536,0,6,6144,65536,0,81936,0,0,0,0),
-(47537,0,6,6144,65536,0,81936,0,0,0,0),
-(47569,0,6,16384,0,0,16384,0,0,50,0),
-(47570,0,6,16384,0,0,16384,0,0,100,0),
-(47571,0,6,65536,0,0,65536,24576,0,50,0),
-(47580,0,6,0,0,64,0,65536,0,0,0),
-(47581,0,6,0,0,64,0,65536,0,0,0),
-(47582,0,6,0,0,64,0,65536,0,0,0),
-(48110,0,0,0,0,0,656040,0,0,0,0),
-(48111,0,0,0,0,0,656040,0,0,0,0),
-(48112,0,0,0,0,0,656040,0,0,0,0),
-(48113,0,0,0,0,0,656040,0,0,0,0),
-(48159,0,6,8192,0,0,0,0,0,0,0),
-(48160,0,6,8192,0,0,0,0,0,0,0),
-(48483,0,7,34816,1088,0,0,0,0,0,0),
-(48484,0,7,34816,1088,0,0,0,0,0,0),
-(48485,0,7,34816,1088,0,0,0,0,0,0),
-(48496,0,7,96,33554434,0,0,2,0,0,0),
-(48499,0,7,96,33554434,0,0,2,0,0,0),
-(48500,0,7,96,33554434,0,0,2,0,0,0),
-(48506,0,7,5,0,0,0,0,0,0,0),
-(48510,0,7,5,0,0,0,0,0,0,0),
-(48511,0,7,5,0,0,0,0,0,0,0),
-(48516,0,7,5,0,0,0,2,0,0,30),
-(48521,0,7,5,0,0,0,2,0,0,30),
-(48525,0,7,5,0,0,0,2,0,0,30),
-(48833,0,7,0,1088,0,0,0,0,0,0),
-(48835,0,10,0,8,0,0,0,0,0,0),
-(48837,0,11,2416967680,0,0,0,0,0,0,0),
-(48951,0,0,0,0,0,0,64,0,0,0),
-(48952,0,0,0,0,0,0,64,0,0,0),
-(48988,0,0,0,0,0,0,2,0,0,0),
-(49018,0,15,20971520,0,0,0,0,0,0,0),
-(49137,0,15,0,16384,0,0,0,0,0,0),
-(49188,0,15,2,0,0,0,0,0,0,0),
-(49208,0,15,4456448,0,0,0,0,0,0,0),
-(49222,0,0,0,0,0,0,0,0,0,3),
-(49280,0,0,0,0,0,0,0,0,0,3),
-(49281,0,0,0,0,0,0,0,0,0,3),
-(49283,0,0,0,0,0,0,0,0,0,3),
-(49284,0,0,0,0,0,0,0,0,0,3),
-(49503,0,0,0,0,0,0,2,0,0,0),
-(49504,0,0,0,0,0,0,2,0,0,0),
-(49529,0,15,20971520,0,0,0,0,0,0,0),
-(49530,0,15,20971520,0,0,0,0,0,0,0),
-(49622,0,0,0,0,0,0,0,0,0,60),
-(49657,0,15,0,16384,0,0,0,0,0,0),
-(50781, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 6), -- Fate Rune of Primal Energy
-(51123,0,0,0,0,0,0,2,0,0,0),
-(51127,0,0,0,0,0,0,2,0,0,0),
-(51128,0,0,0,0,0,0,2,0,0,0),
-(51129,0,0,0,0,0,0,2,0,0,0),
-(51130,0,0,0,0,0,0,2,0,0,0),
-(51346,0,0,0,0,0,0,0,0,0,10),
-(51349,0,0,0,0,0,0,0,0,0,10),
-(51352,0,0,0,0,0,0,0,0,0,10),
-(51359,0,0,0,0,0,0,0,0,0,10),
-(51414, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Venomous Tome
-(51466,0,0,0,0,0,0,2,0,0,0),
-(51470,0,0,0,0,0,0,2,0,0,0),
-(51474,0,0,0,0,0,0,65536,0,0,0),
-(51478,0,0,0,0,0,0,65536,0,0,0),
-(51479,0,0,0,0,0,0,65536,0,0,0),
-(51528,0,0,0,0,0,0,0,2.5,0,0),
-(51529,0,0,0,0,0,0,0,5,0,0),
-(51530,0,0,0,0,0,0,0,7.5,0,0),
-(51531,0,0,0,0,0,0,0,10,0,0),
-(51532,0,0,0,0,0,0,0,12.5,0,0),
-(51556,0,11,192,0,16,0,2,0,0,0),
-(51557,0,11,192,0,16,0,2,0,0,0),
-(51558,0,11,192,0,16,0,2,0,0,0),
-(51562,0,11,256,0,16,0,0,0,0,0),
-(51563,0,11,256,0,16,0,0,0,0,0),
-(51564,0,11,256,0,16,0,0,0,0,0),
-(51565,0,11,256,0,16,0,0,0,0,0),
-(51566,0,11,256,0,16,0,0,0,0,0),
-(51625,0,8,268476416,0,0,0,0,0,0,0),
-(51626,0,8,268476416,0,0,0,0,0,0,0),
-(51627,0,0,0,0,0,0,112,0,0,0),
-(51628,0,0,0,0,0,0,112,0,0,0),
-(51629,0,0,0,0,0,0,112,0,0,0),
-(51634,0,0,0,0,0,0,2,0,0,0),
-(51635,0,0,0,0,0,0,2,0,0,0),
-(51636,0,0,0,0,0,0,2,0,0,0),
-(51664,0,8,131072,8,0,0,0,0,0,0),
-(51665,0,8,131072,8,0,0,0,0,0,0),
-(51667,0,8,131072,8,0,0,0,0,0,0),
-(51668,0,8,131072,8,0,0,0,0,0,0),
-(51669,0,8,131072,8,0,0,0,0,0,0),
-(51672,0,0,0,0,0,0,16,0,0,1),
-(51674,0,0,0,0,0,0,16,0,0,1),
-(51679,0,8,1,1,0,0,0,0,0,0),
-(51692,0,8,512,0,0,0,2,0,0,0),
-(51696,0,8,512,0,0,0,2,0,0,0),
-(51698,0,0,0,0,0,0,2,0,0,1),
-(51700,0,0,0,0,0,0,2,0,0,1),
-(51701,0,0,0,0,0,0,2,0,0,1),
-(51940,0,0,0,0,0,0,0,0,20,0),
-(51989,0,0,0,0,0,0,0,0,20,0),
-(52004,0,0,0,0,0,0,0,0,20,0),
-(52005,0,0,0,0,0,0,0,0,20,0),
-(52007,0,0,0,0,0,0,0,0,20,0),
-(52008,0,0,0,0,0,0,0,0,20,0),
-(52020,0,7,32768,1048576,0,0,0,0,0,0),
-(52127,0,0,0,0,0,0,0,0,0,3),
-(52129,0,0,0,0,0,0,0,0,0,3),
-(52131,0,0,0,0,0,0,0,0,0,3),
-(52134,0,0,0,0,0,0,0,0,0,3),
-(52136,0,0,0,0,0,0,0,0,0,3),
-(52138,0,0,0,0,0,0,0,0,0,3),
-(52420,0,0,0,0,0,0,0,0,0,30),
-(52423,0,0,0,0,0,0,32,0,0,0),
-(52610,0,7,80000000,0,0,4000,0,0,0,0),
-(52795,0,6,1,0,0,0,0,0,0,0),
-(52797,0,6,1,0,0,0,0,0,0,0),
-(52798,0,6,1,0,0,0,0,0,0,0),
-(52799,0,6,1,0,0,0,0,0,0,0),
-(52800,0,6,1,0,0,0,0,0,0,0),
-(52898,0,0,0,0,0,0,2,0,0,0),
-(53137,0,15,20971520,0,0,0,0,0,0,0),
-(53138,0,15,20971520,0,0,0,0,0,0,0),
-(53215,0,9,1,0,0,0,0,0,0,0),
-(53216,0,9,1,0,0,0,0,0,0,0),
-(53217,0,9,1,0,0,0,0,0,0,0),
-(53221,0,9,0,1,0,0,0,0,0,0),
-(53222,0,9,0,1,0,0,0,0,0,0),
-(53224,0,9,0,1,0,0,0,0,0,0),
-(53228,0,9,32,16777216,0,0,0,0,0,0),
-(53232,0,9,32,16777216,0,0,0,0,0,0),
-(53256,0,9,2048,8388609,0,0,2,0,0,0),
-(53259,0,9,2048,8388609,0,0,2,0,0,0),
-(53260,0,9,2048,8388609,0,0,2,0,0,0),
-(53290,0,9,2048,2147483647,0,0,2,0,0,0),
-(53291,0,9,2048,2147483647,0,0,2,0,0,0),
-(53292,0,9,2048,2147483647,0,0,2,0,0,0),
-(53375,0,10,0,8192,0,16384,0,0,0,6),
-(53380,0,10,8388608,131072,0,0,2,0,0,0),
-(53381,0,10,8388608,131072,0,0,2,0,0,0),
-(53382,0,10,8388608,131072,0,0,2,0,0,0),
-(53397,0,0,0,0,0,0,2,0,0,0),
-(53486,0,10,8388608,163840,0,0,2,0,0,0),
-(53488,0,10,8388608,163840,0,0,2,0,0,0),
-(53501,0,0,0,0,0,0,2,0,0,0),
-(53502,0,0,0,0,0,0,2,0,0,0),
-(53503,0,0,0,0,0,0,2,0,0,0),
-(53551,0,10,4096,0,0,0,0,0,0,0),
-(53552,0,10,4096,0,0,0,0,0,0,0),
-(53553,0,10,4096,0,0,0,0,0,0,0),
-(53569,0,10,2097152,65536,0,0,2,0,0,0),
-(53576,0,10,2097152,65536,0,0,2,0,0,0),
-(53601,0,0,0,0,0,0,0,0,0,6),
-(53646,0,0,0,0,0,0,2,0,0,0),
-(53671,0,10,8388608,0,0,0,0,0,0,0),
-(53672,0,10,2097152,65536,0,0,2,0,0,0),
-(53673,0,10,8388608,0,0,0,0,0,0,0),
-(53754,0,5,0,1024,0,0,24576,0,0,0),
-(53759,0,5,0,1024,0,0,24576,0,0,0),
-(54149,0,10,2097152,65536,0,0,2,0,0,0),
-(54151,0,10,8388608,0,0,0,0,0,0,0),
-(54154,0,10,8388608,0,0,0,0,0,0,0),
-(54155,0,10,8388608,0,0,0,0,0,0,0),
-(54278,0,0,0,0,0,0,2,0,0,0),
-(54486,0,0,536870945,36864,0,0,0,0,0,0),
-(54488,0,0,536870945,36864,0,0,0,0,0,0),
-(54489,0,0,536870945,36864,0,0,0,0,0,0),
-(54490,0,0,536870945,36864,0,0,0,0,0,0),
-(54695, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Death Knights Anguish
-(54707,0,0,0,0,0,0,0,0,0,60),
-(54738,0,0,0,0,0,0,2,0,0,45),
-(54747,0,0,0,0,0,0,65536,0,0,0),
-(54749,0,0,0,0,0,0,65536,0,0,0),
-(54754,0,7,16,0,0,0,0,0,0,0),
-(54787,0,3,0,1,0,32768,8192,0,0,0),
-(54808,0,0,0,0,0,0,0,0,0,60),
-(54838, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Valonforths Remembrance
-(54841, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 3), -- Thunder Capacitor
-(54936,0,10,1073741824,0,0,0,0,0,0,0),
-(54937,0,10,2147483648,0,0,0,0,0,0,0),
-(54939,0,10,32768,0,0,0,0,0,0,0),
-(55198,0,11,448,0,0,16384,2,0,0,0),
-(55380,0,0,0,0,0,0,0,0,0,45),
-(55381,0,0,0,0,0,0,65536,0,0,15),
-(55440,0,11,64,0,0,0,0,0,0,0),
-(55640,0,0,0,0,0,0,0,0,0,45),
-(55666,0,15,1,0,0,0,0,0,0,0),
-(55667,0,15,1,0,0,0,0,0,0,0),
-(55668,0,15,1,0,0,0,0,0,0,0),
-(55669,0,15,1,0,0,0,0,0,0,0),
-(55670,0,15,1,0,0,0,0,0,0,0),
-(55672,0,6,1,0,0,16384,0,0,0,0),
-(55677,0,6,0,1,0,0,0,0,0,0),
-(55680,0,6,512,0,0,0,0,0,0,0),
-(55689,0,0,0,0,0,0,2,0,0,0),
-(55747, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Horn of Argent Fury
-(55768,0,0,0,0,0,0,0,0,0,45),
-(55776,0,0,0,0,0,0,0,0,0,45),
-(56218,0,5,2,0,0,0,0,0,0,0),
-(56249,0,5,0,0,1024,0,0,0,0,0),
-(56342,0,9,16384,0,0,0,0,0,0,0),
-(56343,0,9,16384,0,0,0,0,0,0,0),
-(56344,0,9,16384,0,0,0,0,0,0,0),
-(56355,0,0,0,0,0,0,64,0,0,0),
-(56364,0,3,0,16777216,0,0,0,0,0,0),
-(56372,0,3,0,128,0,16384,0,0,0,0),
-(56374,0,3,0,4000,0,4000,0,0,0,0),
-(56451,0,0,0,0,0,0,0,0,0,3),
-(56611,0,0,0,0,0,0,2,0,0,0),
-(56612,0,0,0,0,0,0,2,0,0,0),
-(56613,0,0,0,0,0,0,2,0,0,0),
-(56614,0,0,0,0,0,0,2,0,0,0),
-(56636,0,4,32,0,0,0,0,0,0,0),
-(56637,0,4,32,0,0,0,0,0,0,0),
-(56638,0,4,32,0,0,0,0,0,0,0),
-(56816,0,0,0,0,0,0,48,0,0,0),
-(56821,0,8,2,0,0,0,2,0,0,0),
-(56822,0,15,2,0,0,0,0,0,0,0),
-(56834,0,15,4456448,0,0,0,0,0,0,0),
-(56835,0,15,4456448,0,0,0,0,0,0,0),
-(57318,0,10,0,8192,0,16384,0,0,0,6),
-(57345,0,0,0,0,0,0,0,0,0,45),
-(57352, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x000288AA, 0x00000000, 0, 0, 45), -- Darkmoon Card: Death
-(57878,0,0,0,0,0,0,16,0,0,0),
-(57880,0,0,0,0,0,0,16,0,0,0),
-(57881,0,0,0,0,0,0,16,0,0,0),
-(57907,0,7,2,0,0,0,0,0,0,0),
-(57960,0,0,0,0,0,0,0,0,0,3),
-(58357,0,4,64,0,0,0,2,0,0,0),
-(58364,0,4,1024,0,0,0,0,0,0,0),
-(58372,0,4,2,0,0,0,0,0,0,0),
-(58386,0,0,0,0,0,0,32,0,0,0),
-(58426,0,8,4194304,0,0,81920,24577,0,0,0),
-(58435,0,5,2,256,0,0,0,0,0,0),
-(58442, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 15), -- Airy Pale Ale
-(58444, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 5), -- Worg Tooth Oatmeal Stout
-(58616,0,15,262144,0,0,0,0,0,0,0),
-(58620,0,15,0,16384,0,0,0,0,0,0),
-(58626,0,15,33554432,0,0,0,0,0,0,0),
-(58631,0,15,2,0,0,0,0,0,0,0),
-(58642,0,15,0,134217728,0,0,0,0,0,0),
-(58644,0,15,0,4,0,0,0,0,0,0),
-(58647,0,15,0,4,0,0,0,0,0,0),
-(58676,0,15,0,8,0,0,0,0,0,0),
-(58677,0,15,8192,0,0,0,0,0,0,0),
-(58872,0,0,0,0,0,0,64,0,0,0),
-(58874,0,0,0,0,0,0,64,0,0,0),
-(58901, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 45), -- Tears of Bitter Anguish
-(59057,0,15,2,0,0,0,0,0,0,0),
-(59088,0,4,0,2,0,4000,0,0,0,0),
-(59089,0,4,0,2,0,4000,0,0,0,0),
-(59176,0,0,0,0,0,0,2,0,0,0),
-(59327,0,15,134217728,0,0,0,0,0,0,0),
-(59345, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Crusaders Locket
-(59630, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Black Magic
-(59725,0,0,0,0,0,0,2048,0,0,0),
-(60061, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Scarab of the Infinite Cycle
-(60063, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Sundial of the Exiled
-(60066, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Hourglass of the Unraveller
-(60132,0,15,0,134348800,0,0,0,0,0,0),
-(60170,0,5,6,0,0,0,0,0,0,0),
-(60172,0,5,262144,0,0,0,65536,0,0,0),
-(60176,0,4,32,16,0,0,0,0,0,0),
-(60221, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Essence of Gossamer
-(60301, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Meteorite Whetstone
-(60306, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Vestige of Haldor
-(60317, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Signet of Edward the Odd
-(60436, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Grim Toll
-(60442,0,0,0,0,0,0,0,0,0,45),
-(60473, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Forge Ember
-(60482, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Pendulum of Telluric Currents
-(60487, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 15), -- Extract of Necromantic Power
-(60490, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Embrace of the Spider
-(60493,0,0,0,0,0,0,0,0,0,45),
-(60519, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Spark of Life
-(60529,0,0,0,0,0,0,0,0,0,45),
-(60537, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 45), -- Soul of the Dead
-(60564,0,11,2416967680,0,0,0,0,0,0,0),
-(60571,0,11,2416967680,0,0,0,0,0,0,0),
-(60572,0,11,2416967680,0,0,0,0,0,0,0),
-(60573,0,11,2416967680,0,0,0,0,0,0,0),
-(60574,0,11,2416967680,0,0,0,0,0,0,0),
-(60575,0,11,2416967680,0,0,0,0,0,0,0),
-(60617,0,0,0,0,0,0,32,0,0,0),
-(60710,0,7,2,0,0,0,0,0,0,0),
-(60717,0,7,2,0,0,0,0,0,100,0),
-(60719,0,7,2,0,0,0,0,0,0,0),
-(60722,0,7,2,0,0,0,0,0,0,0),
-(60724,0,7,2,0,0,0,0,0,0,0),
-(60726,0,7,2,0,0,0,0,0,0,0),
-(60770,0,11,1,0,0,0,0,0,0,0),
-(60818,0,10,0,512,0,0,0,0,0,0),
-(60826,0,15,20971520,0,0,0,0,0,0,0),
-(61188,0,5,4,0,0,0,0,0,0,0),
-(61257,0,0,0,0,0,131752,65536,0,0,0),
-(61324,0,10,0,131072,0,0,0,0,0,0),
-(61345,0,0,0,0,0,0,2,0,0,0),
-(61346,0,0,0,0,0,0,2,0,0,0),
-(61356, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x000002A8, 0x00000002, 0, 0, 90), -- Invigorating Earthsiege Diamond
-(61618,0,0,0,0,0,0,0,0,0,45),
-(61846,0,0,0,0,0,0,16,0,0,0),
-(61847,0,0,0,0,0,0,16,0,0,0),
-(61848,0,0,0,0,0,0,16,0,0,0),
-(62147,0,15,2,0,0,0,0,0,0,0),
-(62459,0,15,4,0,0,0,0,0,0,0);
-/*!40000 ALTER TABLE `spell_proc_event` ENABLE KEYS */;
-UNLOCK TABLES;
-
 --
 -- Table structure for table `spell_required`
 --
diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql
index 50b540967c4..728cce3fa69 100644
--- a/sql/world_scripts_full.sql
+++ b/sql/world_scripts_full.sql
@@ -1,4 +1,4 @@
--- Up to TC2 3515
+-- Up to TC2 4006
 
 /* WORLD BOSS */
 UPDATE `creature_template` SET `ScriptName`='boss_ysondre' WHERE `entry`=14887;
diff --git a/sql/world_scripts_structure.sql b/sql/world_scripts_structure.sql
deleted file mode 100644
index 0087c4e1d1b..00000000000
--- a/sql/world_scripts_structure.sql
+++ /dev/null
@@ -1,68 +0,0 @@
--- Up to ACID 0.0.9
-
-DROP TABLE IF EXISTS `creature_ai_scripts`;
-CREATE TABLE `creature_ai_scripts` (
-  `id` int(11) unsigned NOT NULL COMMENT 'Identifier' AUTO_INCREMENT,
-  `creature_id` int(11) unsigned NOT NULL default '0' COMMENT 'Creature Template Identifier',
-  `event_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Event Type',
-  `event_inverse_phase_mask` int(11) signed NOT NULL default '0' COMMENT 'Mask which phases this event will not trigger in',
-  `event_chance` int(3) unsigned NOT NULL default '100',
-  `event_flags` int(3) unsigned NOT NULL default '0',
-  `event_param1` int(11) signed NOT NULL default '0',
-  `event_param2` int(11) signed NOT NULL default '0',
-  `event_param3` int(11) signed NOT NULL default '0',
-  `event_param4` int(11) signed NOT NULL default '0',
-  `action1_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
-  `action1_param1` int(11) signed NOT NULL default '0',
-  `action1_param2` int(11) signed NOT NULL default '0',
-  `action1_param3` int(11) signed NOT NULL default '0',
-  `action2_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
-  `action2_param1` int(11) signed NOT NULL default '0',
-  `action2_param2` int(11) signed NOT NULL default '0',
-  `action2_param3` int(11) signed NOT NULL default '0',
-  `action3_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
-  `action3_param1` int(11) signed NOT NULL default '0',
-  `action3_param2` int(11) signed NOT NULL default '0',
-  `action3_param3` int(11) signed NOT NULL default '0',
-  `comment` varchar(255) NOT NULL default '' COMMENT 'Event Comment',
-  PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Scripts';
-
-DROP TABLE IF EXISTS `creature_ai_summons`;
-CREATE TABLE `creature_ai_summons` (
-  `id` int(11) unsigned NOT NULL COMMENT 'Location Identifier' AUTO_INCREMENT,
-  `position_x` float NOT NULL default '0',
-  `position_y` float NOT NULL default '0',
-  `position_z` float NOT NULL default '0',
-  `orientation` float NOT NULL default '0',
-  `spawntimesecs` int(11) unsigned NOT NULL default '120',
-  `comment` varchar(255) NOT NULL default '' COMMENT 'Summon Comment',
-  PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Summoning Locations';
-
-DROP TABLE IF EXISTS `creature_ai_texts`;
-CREATE TABLE `creature_ai_texts` (
-  `entry` mediumint(8) NOT NULL,
-  `content_default` text NOT NULL,
-  `content_loc1` text,
-  `content_loc2` text,
-  `content_loc3` text,
-  `content_loc4` text,
-  `content_loc5` text,
-  `content_loc6` text,
-  `content_loc7` text,
-  `content_loc8` text,
-  `sound` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `language` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `emote` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `comment` text,
-  PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';
-
-CREATE TABLE IF NOT EXISTS `version` (
-    `core_version` varchar(120) default NULL COMMENT 'Core revision dumped at startup.',
-    `core_revision` varchar(120) default '0',
-    `db_version` varchar(120) default NULL COMMENT 'Version of world DB.',
-    `script_version` varchar(120) default NULL COMMENT 'Version of scripts DB.'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Version Notes';
\ No newline at end of file
diff --git a/sql/world_spell_full.sql b/sql/world_spell_full.sql
index a16eb3e30fc..4580801b457 100644
--- a/sql/world_spell_full.sql
+++ b/sql/world_spell_full.sql
@@ -1,4 +1,4 @@
--- Up to TC2 3515
+-- Up to TC2 4018
 
 -- --------
 -- LINKED
@@ -13,15 +13,7 @@
 # - + 0 target casts 2 on self (originalCaster = caster) when aura 1 casted by caster is removed
 # - - 0 aura 2 is removed when aura 1 is removed
 
-DROP TABLE IF EXISTS `spell_linked_spell`;
-CREATE TABLE `spell_linked_spell` (
-  `spell_trigger` mediumint(8) NOT NULL,
-  `spell_effect` mediumint(8) NOT NULL default '0',
-  `type` tinyint(3) unsigned NOT NULL default '0',
-  `comment` text NOT NULL,
-  UNIQUE KEY `trigger_effect_type` (`spell_trigger`,`spell_effect`,`type`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Spell System';
-
+TRUNCATE TABLE `spell_linked_spell`;
 INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
 -- class
 ( 31224, -1543, 2, 'Cloak of Shadows - Flare'),
@@ -544,53 +536,6 @@ DELETE FROM `playercreateinfo_spell` WHERE Spell = 56816;
 INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
 (0, 6, 56816, 'Rune Strike');
 
--- --------
--- REQUIRED
--- --------
-DROP TABLE IF EXISTS `spell_required`;
-CREATE TABLE `spell_required` (
-  `spell_id` mediumint(9) NOT NULL default '0',
-  `req_spell` mediumint(9) NOT NULL default '0',
-  PRIMARY KEY  (`spell_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell Additinal Data';
-
-INSERT INTO `spell_required` (`spell_id`, `req_spell`) VALUES
-(53312, 53308),
-(48938, 48936),
-(48937, 48935),
-(48934, 48932),
-(48933, 48931),
-(27143, 27142),
-(27141, 27140),
-(27009, 26989),
-(25916, 25291),
-(25918, 25290),
-(25894, 19854),
-(25782, 19838),
-(27681, 14752),
-(17329, 9853),
-(16813, 9852),
-(16812, 5196),
-(16811, 5195),
-(16810, 1062),
-(16689, 339),
-(9788, 9785),
-(17039, 9787),
-(17040, 9787),
-(17041, 9787),
-(10660, 10662),
-(10658, 10662),
-(10656, 10662),
-(28672, 28596),
-(28675, 28596),
-(28677, 28596),
-(26801, 26790),
-(26798, 26790),
-(26797, 26790),
-(20222, 12656),
-(20219, 12656),
-(25899, 20911);
-
 -- --------
 -- PROC
 -- --------
@@ -607,22 +552,7 @@ CONCAT('0x',LPAD(HEX(procex),8,'0')),
 ppmrate, customchance, cooldown
 from spell_proc_event order by entry;
 */
-DROP TABLE IF EXISTS `spell_proc_event`;
-CREATE TABLE `spell_proc_event` (
-  `entry` smallint(5) unsigned NOT NULL default '0',
-  `SchoolMask` tinyint(4) NOT NULL default '0',
-  `SpellFamilyName` smallint(5) unsigned NOT NULL default '0',
-  `SpellFamilyMask0` int(10) unsigned NOT NULL default '0',
-  `SpellFamilyMask1` int(10) unsigned NOT NULL default '0',
-  `SpellFamilyMask2` int(10) unsigned NOT NULL default '0',
-  `procFlags` int(10) unsigned NOT NULL default '0',
-  `procEx` int(10) unsigned NOT NULL default '0',
-  `ppmRate` float NOT NULL default '0',
-  `CustomChance` float NOT NULL default '0',
-  `Cooldown` int(10) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
+TRUNCATE TABLE `spell_proc_event`;
 INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
 (   324, 0x00,   0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000,   0,   0,   3), -- Lightning Shield (Rank 1)
 (   325, 0x00,   0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000,   0,   0,   3), -- Lightning Shield (Rank 2)
@@ -1531,14 +1461,7 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell
 -- --------
 -- ENCHANT PROC
 -- --------
-DROP TABLE IF EXISTS `spell_enchant_proc_data`;
-CREATE TABLE `spell_enchant_proc_data` (
-  `entry` INT(10) UNSIGNED NOT NULL,
-  `customChance` INT(10) UNSIGNED NOT NULL DEFAULT '0',
-  `PPMChance` FLOAT UNSIGNED NOT NULL DEFAULT '0', 
-  `procEx` FLOAT UNSIGNED NOT NULL DEFAULT '0'
-) ENGINE=MYISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Spell enchant proc data';
-
+TRUNCATE TABLE `spell_enchant_proc_data`;
 INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES 
 (2, 0, 8.8,0), -- Frostbrand Weapon
 (12, 0, 8.8,0), -- Frostbrand Weapon
@@ -1554,16 +1477,7 @@ INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procE
 -- SPELL AFFECT
 -- --------
 
-DROP TABLE IF EXISTS `spell_affect`;
-CREATE TABLE `spell_affect` (
-  `entry` smallint(5) unsigned NOT NULL default '0',
-  `effectId` tinyint(3) unsigned NOT NULL default '0',
-  `SpellClassMask0` int(5) unsigned NOT NULL default '0',
-  `SpellClassMask1` int(5) unsigned NOT NULL default '0',
-  `SpellClassMask2` int(5) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`entry`,`effectId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
+TRUNCATE TABLE `spell_affect`;
 INSERT INTO `spell_affect` (`entry`, `effectId`, `SpellClassMask0`, `SpellClassMask1`, `SpellClassMask2`) VALUES
 (44544,0,685904631,1151048,0); -- Fingers of frost
 
-- 
cgit v1.2.3


From 20cd3a6613581f809084db497f398c3d326f37ab Mon Sep 17 00:00:00 2001
From: Kudlaty <none@none>
Date: Mon, 15 Jun 2009 21:51:23 +0200
Subject: Fix script for creature 16518

--HG--
branch : trunk
---
 sql/updates/4030_world.sql                         |  1 +
 sql/world_scripts_full.sql                         |  2 +-
 .../scripts/zone/azuremyst_isle/azuremyst_isle.cpp | 79 +++++++++++++---------
 3 files changed, 49 insertions(+), 33 deletions(-)
 create mode 100644 sql/updates/4030_world.sql

(limited to 'sql/world_scripts_full.sql')

diff --git a/sql/updates/4030_world.sql b/sql/updates/4030_world.sql
new file mode 100644
index 00000000000..579bfa49d23
--- /dev/null
+++ b/sql/updates/4030_world.sql
@@ -0,0 +1 @@
+UPDATE creature_template SET ScriptName='npc_nestlewood_owlkin' WHERE entry=16518;
diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql
index 728cce3fa69..cec2944c6df 100644
--- a/sql/world_scripts_full.sql
+++ b/sql/world_scripts_full.sql
@@ -177,7 +177,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_engineer_spark_overgrind' WHERE
 UPDATE `creature_template` SET `ScriptName`='npc_injured_draenei' WHERE `entry`=16971;
 UPDATE `creature_template` SET `ScriptName`='npc_magwin' WHERE `entry`=17312;
 UPDATE `creature_template` SET `ScriptName`='npc_geezle' WHERE `entry`=17318;
-UPDATE `creature_template` SET `ScriptName`='mob_nestlewood_owlkin' WHERE `entry`=16518;
+UPDATE `creature_template` SET `ScriptName`='npc_nestlewood_owlkin' WHERE `entry`=16518;
 UPDATE `creature_template` SET `ScriptName`='npc_draenei_survivor' WHERE `entry`=16483;
 
 /* BADLANDS */
diff --git a/src/bindings/scripts/scripts/zone/azuremyst_isle/azuremyst_isle.cpp b/src/bindings/scripts/scripts/zone/azuremyst_isle/azuremyst_isle.cpp
index 320a1610827..ae2ac22ae71 100644
--- a/src/bindings/scripts/scripts/zone/azuremyst_isle/azuremyst_isle.cpp
+++ b/src/bindings/scripts/scripts/zone/azuremyst_isle/azuremyst_isle.cpp
@@ -565,56 +565,71 @@ CreatureAI* GetAI_npc_geezleAI(Creature *_Creature)
 
 enum
 {
-    INOCULATION_CHANNEL = 29528,
-    INOCULATED_OWLKIN   = 16534
+    SPELL_INOCULATE_OWLKIN  = 29528,
+    ENTRY_OWLKIN            = 16518,
+    ENTRY_OWLKIN_INOC       = 16534
 };
 
-struct TRINITY_DLL_DECL mob_nestlewood_owlkinAI : public ScriptedAI
+struct TRINITY_DLL_DECL npc_nestlewood_owlkinAI : public ScriptedAI
 {
-    mob_nestlewood_owlkinAI(Creature *c) : ScriptedAI(c) {}
+    npc_nestlewood_owlkinAI(Creature *c) : ScriptedAI(c) {}
 
-    uint32 ChannelTimer;
-    bool Channeled;
-    bool Hitted;
+    uint32 DespawnTimer;
 
     void Reset()
     {
-        ChannelTimer = 0;
-        Channeled = false;
-        Hitted = false;
+        DespawnTimer = 0;
+        m_creature->SetVisibility(VISIBILITY_ON);
     }
 
-    void EnterCombat(Unit *who){}
+    void Aggro(Unit *who) {}
 
-    void SpellHit(Unit* caster, const SpellEntry* spell)
+    void UpdateAI(const uint32 diff)
     {
-        if(!caster)
-            return;
-
-        if(caster->GetTypeId() == TYPEID_PLAYER && spell->Id == INOCULATION_CHANNEL)
+        //timer gets adjusted by the triggered aura effect
+        if (DespawnTimer)
         {
-            ChannelTimer = 3000;
-            Hitted = true;
+            if (DespawnTimer <= diff)
+            {
+                //once we are able to, despawn us
+                m_creature->SetVisibility(VISIBILITY_OFF);
+                m_creature->setDeathState(JUST_DIED);
+                m_creature->SetHealth(0);
+                m_creature->CombatStop();
+                m_creature->DeleteThreatList();
+                m_creature->RemoveCorpse();
+            }else DespawnTimer -= diff;
         }
-    }
 
-    void UpdateAI(const uint32 diff)
-    {
-        if(ChannelTimer < diff && !Channeled && Hitted)
-        {
-            m_creature->DealDamage(m_creature, m_creature->GetHealth(), NULL, DIRECT_DAMAGE, SPELL_SCHOOL_MASK_NORMAL, NULL, false);
-            m_creature->RemoveCorpse();
-            m_creature->SummonCreature(INOCULATED_OWLKIN, m_creature->GetPositionX(), m_creature->GetPositionY(), m_creature->GetPositionZ(), 0.0f, TEMPSUMMON_TIMED_DESPAWN, 180000);
-            Channeled = true;
-        }else ChannelTimer -= diff;
+        if (!UpdateVictim())
+            return;
 
         DoMeleeAttackIfReady();
     }
 };
 
-CreatureAI* GetAI_mob_nestlewood_owlkinAI(Creature *_Creature)
+CreatureAI* GetAI_npc_nestlewood_owlkinAI(Creature* pCreature)
+{
+    return new npc_nestlewood_owlkinAI (pCreature);
+}
+
+bool EffectDummyCreature_npc_nestlewood_owlkin(Unit *pCaster, uint32 spellId, uint32 effIndex, Creature *pCreatureTarget)
 {
-    return new mob_nestlewood_owlkinAI (_Creature);
+    //always check spellid and effectindex
+    if (spellId == SPELL_INOCULATE_OWLKIN && effIndex == 0)
+    {
+        if (pCreatureTarget->GetEntry() != ENTRY_OWLKIN)
+            return true;
+
+        pCreatureTarget->UpdateEntry(ENTRY_OWLKIN_INOC);
+
+        //set despawn timer, since we want to remove creature after a short time
+        ((npc_nestlewood_owlkinAI*)pCreatureTarget->AI())->DespawnTimer = 15000;
+
+        //always return true when we are handling this spell and effect
+        return true;
+    }
+    return false;
 }
 
 void AddSC_azuremyst_isle()
@@ -650,8 +665,8 @@ void AddSC_azuremyst_isle()
     newscript->RegisterSelf();
 
     newscript = new Script;
-    newscript->Name="mob_nestlewood_owlkin";
-    newscript->GetAI = &GetAI_mob_nestlewood_owlkinAI;
+    newscript->Name="npc_nestlewood_owlkin";
+    newscript->GetAI = &GetAI_npc_nestlewood_owlkinAI;
     newscript->RegisterSelf();
 }
 
-- 
cgit v1.2.3

