diff options
| -rw-r--r-- | sql/world.sql | 1055 | ||||
| -rw-r--r-- | sql/world_scripts_full.sql | 2 | ||||
| -rw-r--r-- | sql/world_scripts_structure.sql | 68 | ||||
| -rw-r--r-- | sql/world_spell_full.sql | 96 |
4 files changed, 8 insertions, 1213 deletions
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` -- @@ -14157,25 +14159,6 @@ CREATE TABLE `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` -- @@ -14248,134 +14231,6 @@ CREATE TABLE `spell_linked_spell` ( 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` -- @@ -14491,912 +14346,6 @@ CREATE TABLE `spell_proc_event` ( 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'), @@ -545,53 +537,6 @@ 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 |