aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/trinityscript_script_texts.sql12
-rw-r--r--sql/updates/3999_sd2.sql2
-rw-r--r--sql/updates/4000_world_spell_proc_event.sql (renamed from sql/updates/3997_world_spell_proc_event.sql)0
-rw-r--r--sql/updates/4003_world_scritp_waypoint.sql28
-rw-r--r--sql/updates/4006_sd2.sql10
-rw-r--r--sql/updates/4016_world_spell_#dk.sql5
-rw-r--r--sql/updates/4023_world_spell_proc_event.sql4
-rw-r--r--sql/updates/4030_world.sql1
-rw-r--r--sql/updates/4031_world_spell_proc_event.sql5
-rw-r--r--sql/updates/4032_world_spell_proc_event.sql4
-rw-r--r--sql/world.sql1055
-rw-r--r--sql/world_script_waypoints.sql29
-rw-r--r--sql/world_scripts_full.sql5
-rw-r--r--sql/world_scripts_structure.sql68
-rw-r--r--sql/world_spell_full.sql111
15 files changed, 119 insertions, 1220 deletions
diff --git a/sql/trinityscript_script_texts.sql b/sql/trinityscript_script_texts.sql
index b0dd3ce636e..c15fc6ba557 100644
--- a/sql/trinityscript_script_texts.sql
+++ b/sql/trinityscript_script_texts.sql
@@ -32,7 +32,7 @@ INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content
(-1000000, '<TrinityScript Text Entry Missing!>', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'DEFAULT_TEXT'),
(-1000001, 'goes into a killing frenzy!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 0, 0, 'EMOTE_GENERIC_FRENZY_KILL'),
(-1000004, 'goes into a berserker rage!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 0, 0, 'EMOTE_GENERIC_BERSERK'),
-(-1000005, 'Greetings citizen', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 7, 0, 'general_marcus SAY_GREETING');
+(-1000005, 'UNUSED', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'REUSE ME');
--
-- Normal text entries. Say/Yell/Whisper/Emote for any regular world object.
@@ -325,7 +325,7 @@ INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content
(-1000406, 'Meet me down by the orchard--I just need to put my gun away.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 7, 0, 'stilwell SAY_DS_PROLOGUE'),
(-1000407, '%s howls in delight at the sight of his lunch!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 0, 0, 'kyle EMOTE_SEE_LUNCH'),
(-1000408, '%s eats his lunch.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 0, 0, 'kyle EMOTE_EAT_LUNCH'),
-(-1000409, '%s thanks you with a special dance.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 0, 0, 'kyle EMOTE_DANCE');
+(-1000409, '%s thanks you with a special dance.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 0, 0, 'kyle EMOTE_DANCE'),
(-1000411, 'Mist! I feared I would never see you again! Yes, I am well, do not worry for me. You must rest and recover your health.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 7, 0, 'mist SAY_AT_HOME'),
(-1000412, 'growls in acknowledgement before straightening and making her way off into the forest.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 0, 0, 'mist EMOTE_AT_HOME'),
(-1000413, 'Threshwackonator First Mate unit prepared to follow', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 0, 0, 'threshwackonator EMOTE_START'),
@@ -342,7 +342,13 @@ INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content
(-1000424, 'Nope. didn\'t leave the fossil back here!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 7, 0, 'remtravel SAY_REM_PROGRESS'),
(-1000425, 'Ah. I remember now! I gave the mysterious fossil to Hollee! Check with her.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 7, 0, 'remtravel SAY_REM_REMEMBER'),
(-1000426, '%s goes back to work, oblivious to everything around him.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 7, 0, 'remtravel EMOTE_REM_END'),
-(-1000427, 'Something tells me this $r wants the mysterious fossil too. Help!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 7, 0, 'remtravel SAY_REM_AGGRO');
+(-1000427, 'Something tells me this $r wants the mysterious fossil too. Help!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 7, 0, 'remtravel SAY_REM_AGGRO'),
+
+(-1000428, 'Ah...the wondrous sound of kodos. I love the way they make the ground shake... inspect the beast for me.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0,'kodo round SAY_SMEED_HOME_1'),
+(-1000429, 'Hey, look out with that kodo! You had better inspect that beast before i give you credit!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0,'kodo round SAY_SMEED_HOME_2'),
+(-1000430, 'That kodo sure is a beauty. Wait a minute, where are my bifocals? Perhaps you should inspect the beast for me.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'kodo round SAY_SMEED_HOME_3');
+
+
-- -1 033 000 SHADOWFANG KEEP
INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
diff --git a/sql/updates/3999_sd2.sql b/sql/updates/3999_sd2.sql
index 7815b7aa857..aefda08bd2e 100644
--- a/sql/updates/3999_sd2.sql
+++ b/sql/updates/3999_sd2.sql
@@ -2,4 +2,4 @@ DELETE FROM script_texts WHERE entry BETWEEN -1000342 AND -1000340;
INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES
(-1000340, 'We made it! Thanks, $N. I couldn''t have gotten without you.', 0, 0, 0, 0, 'npc_deathstalker_erland - SAY_THANKS'),
(-1000341, 'It''s good to see you again, Erland. What is your report?', 0, 0, 0, 0, 'npc_deathstalker_erland - SAY_RANE'),
-(-1000342, 'Masses of wolves are to the east, and whoever lived at Malden''s Orchard is gone.', 0, 0, 0, 0, 'npc_deathstalker_erland - SAY_ANSWER'),
+(-1000342, 'Masses of wolves are to the east, and whoever lived at Malden''s Orchard is gone.', 0, 0, 0, 0, 'npc_deathstalker_erland - SAY_ANSWER');
diff --git a/sql/updates/3997_world_spell_proc_event.sql b/sql/updates/4000_world_spell_proc_event.sql
index d426dc437cb..d426dc437cb 100644
--- a/sql/updates/3997_world_spell_proc_event.sql
+++ b/sql/updates/4000_world_spell_proc_event.sql
diff --git a/sql/updates/4003_world_scritp_waypoint.sql b/sql/updates/4003_world_scritp_waypoint.sql
new file mode 100644
index 00000000000..603115f72c0
--- /dev/null
+++ b/sql/updates/4003_world_scritp_waypoint.sql
@@ -0,0 +1,28 @@
+DELETE FROM script_waypoint WHERE entry=17969;
+INSERT INTO script_waypoint VALUES
+(17969, 0, -930.048950, 5288.080078, 23.848402, 0, ''),
+(17969, 1, -925.677917, 5296.482910, 18.183748, 0, ''),
+(17969, 2, -924.297180, 5299.016113, 17.710915, 0, ''),
+(17969, 3, -928.390076, 5317.022949, 18.208593, 0, ''),
+(17969, 4, -930.620972, 5329.915039, 18.773422, 0, 'SAY_AMBUSH1'),
+(17969, 5, -931.490295, 5357.654785, 18.027155, 0, 'SAY_PROGRESS'),
+(17969, 6, -934.777771, 5369.341797, 22.278048, 0, ''),
+(17969, 7, -934.521851, 5373.407227, 22.834690, 0, ''),
+(17969, 8, -937.008545, 5382.980469, 22.699078, 0, ''),
+(17969, 9, -941.948059, 5404.141602, 22.669743, 0, ''),
+(17969, 10, -931.244263, 5415.846680, 23.063961, 0, 'at crossroad'),
+(17969, 11, -901.497925, 5420.315430, 24.213270, 0, ''),
+(17969, 12, -860.311707, 5415.617676, 23.671139, 0, ''),
+(17969, 13, -777.988953, 5391.982422, 23.001669, 0, ''),
+(17969, 14, -750.362000, 5385.786621, 22.765791, 0, ''),
+(17969, 15, -731.339417, 5382.449707, 22.517065, 0, ''),
+(17969, 16, -681.235901, 5381.377930, 22.050159, 2500, 'end bridge SAY_AMBUSH2'),
+(17969, 17, -637.944458, 5384.338379, 22.205647, 0, 'SAY_END'),
+(17969, 18, -608.954407, 5408.715332, 21.630386, 0, ''),
+(17969, 19, -598.134277, 5413.608398, 21.412275, 0, ''),
+(17969, 20, -571.268982, 5420.771973, 21.184925, 0, ''),
+(17969, 21, -553.099915, 5424.616211, 21.193716, 0, ''),
+(17969, 22, -524.745483, 5443.945313, 20.977013, 0, ''),
+(17969, 23, -502.984985, 5446.283691, 22.149435, 0, ''),
+(17969, 24, -472.463959, 5449.546875, 22.561453, 0, ''),
+(17969, 25, -454.533264, 5461.302246, 22.602837, 30000, 'quest complete');
diff --git a/sql/updates/4006_sd2.sql b/sql/updates/4006_sd2.sql
new file mode 100644
index 00000000000..8ac01de7acf
--- /dev/null
+++ b/sql/updates/4006_sd2.sql
@@ -0,0 +1,10 @@
+UPDATE creature_template SET ScriptName='' WHERE entry=466;
+UPDATE script_texts SET content_default='UNUSED', language=0, comment='REUSE ME' WHERE entry=-1000005;
+
+UPDATE creature_template SET ScriptName='npc_aged_dying_ancient_kodo' WHERE entry IN (4700, 4701, 4702, 11627);
+
+DELETE FROM script_texts WHERE entry BETWEEN -1000430 AND -1000428;
+INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES
+(-1000428, 'Ah...the wondrous sound of kodos. I love the way they make the ground shake... inspect the beast for me.',0,0,0,0,'kodo round SAY_SMEED_HOME_1'),
+(-1000429, 'Hey, look out with that kodo! You had better inspect that beast before i give you credit!',0,0,0,0,'kodo round SAY_SMEED_HOME_2'),
+(-1000430, 'That kodo sure is a beauty. Wait a minute, where are my bifocals? Perhaps you should inspect the beast for me.',0,0,0,0,'kodo round SAY_SMEED_HOME_3');
diff --git a/sql/updates/4016_world_spell_#dk.sql b/sql/updates/4016_world_spell_#dk.sql
new file mode 100644
index 00000000000..c88b70b8277
--- /dev/null
+++ b/sql/updates/4016_world_spell_#dk.sql
@@ -0,0 +1,5 @@
+DELETE FROM `spell_script_target` WHERE entry IN
+(53110);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(53110,1,28940);
+
diff --git a/sql/updates/4023_world_spell_proc_event.sql b/sql/updates/4023_world_spell_proc_event.sql
new file mode 100644
index 00000000000..caa53b3c119
--- /dev/null
+++ b/sql/updates/4023_world_spell_proc_event.sql
@@ -0,0 +1,4 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (51521, 51522);
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+( 51521, 0x00, 11, 0x00000000, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Improved Stormspike
+( 51522, 0x00, 11, 0x00000000, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Improved Stormspike \ No newline at end of file
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/updates/4031_world_spell_proc_event.sql b/sql/updates/4031_world_spell_proc_event.sql
new file mode 100644
index 00000000000..f887ea24b9e
--- /dev/null
+++ b/sql/updates/4031_world_spell_proc_event.sql
@@ -0,0 +1,5 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (51698, 51700, 51701);
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+( 51698, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 1), -- Honor Among Thieves
+( 51700, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 1), -- Honor Among Thieves
+( 51701, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 1); -- Honor Among Thieves
diff --git a/sql/updates/4032_world_spell_proc_event.sql b/sql/updates/4032_world_spell_proc_event.sql
new file mode 100644
index 00000000000..25c0b56ccdb
--- /dev/null
+++ b/sql/updates/4032_world_spell_proc_event.sql
@@ -0,0 +1,4 @@
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (51209, 50334);
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+(51209, 55095, 1, 'Hungering cold - frost fever'),
+(50334, 58923, 2, 'Berserk - modify target number aura');
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_script_waypoints.sql b/sql/world_script_waypoints.sql
index 0e57a8db004..e8c541a9b07 100644
--- a/sql/world_script_waypoints.sql
+++ b/sql/world_script_waypoints.sql
@@ -52,6 +52,35 @@ INSERT INTO script_waypoint VALUES
(16295, 33, 7603.768066, -7667.000488, 153.997726, 8000, 'SAY_END_2'),
(16295, 34, 7603.768066, -7667.000488, 153.997726, 0, '');
+DELETE FROM script_waypoint WHERE entry=17969;
+INSERT INTO script_waypoint VALUES
+(17969, 0, -930.048950, 5288.080078, 23.848402, 0, ''),
+(17969, 1, -925.677917, 5296.482910, 18.183748, 0, ''),
+(17969, 2, -924.297180, 5299.016113, 17.710915, 0, ''),
+(17969, 3, -928.390076, 5317.022949, 18.208593, 0, ''),
+(17969, 4, -930.620972, 5329.915039, 18.773422, 0, 'SAY_AMBUSH1'),
+(17969, 5, -931.490295, 5357.654785, 18.027155, 0, 'SAY_PROGRESS'),
+(17969, 6, -934.777771, 5369.341797, 22.278048, 0, ''),
+(17969, 7, -934.521851, 5373.407227, 22.834690, 0, ''),
+(17969, 8, -937.008545, 5382.980469, 22.699078, 0, ''),
+(17969, 9, -941.948059, 5404.141602, 22.669743, 0, ''),
+(17969, 10, -931.244263, 5415.846680, 23.063961, 0, 'at crossroad'),
+(17969, 11, -901.497925, 5420.315430, 24.213270, 0, ''),
+(17969, 12, -860.311707, 5415.617676, 23.671139, 0, ''),
+(17969, 13, -777.988953, 5391.982422, 23.001669, 0, ''),
+(17969, 14, -750.362000, 5385.786621, 22.765791, 0, ''),
+(17969, 15, -731.339417, 5382.449707, 22.517065, 0, ''),
+(17969, 16, -681.235901, 5381.377930, 22.050159, 2500, 'end bridge SAY_AMBUSH2'),
+(17969, 17, -637.944458, 5384.338379, 22.205647, 0, 'SAY_END'),
+(17969, 18, -608.954407, 5408.715332, 21.630386, 0, ''),
+(17969, 19, -598.134277, 5413.608398, 21.412275, 0, ''),
+(17969, 20, -571.268982, 5420.771973, 21.184925, 0, ''),
+(17969, 21, -553.099915, 5424.616211, 21.193716, 0, ''),
+(17969, 22, -524.745483, 5443.945313, 20.977013, 0, ''),
+(17969, 23, -502.984985, 5446.283691, 22.149435, 0, ''),
+(17969, 24, -472.463959, 5449.546875, 22.561453, 0, ''),
+(17969, 25, -454.533264, 5461.302246, 22.602837, 30000, 'quest complete');
+
DELETE FROM script_waypoint WHERE entry=467;
INSERT INTO script_waypoint VALUES
(467, 0, -10508.40, 1068.00, 55.21, 0, ''),
diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql
index 024e437c472..cec2944c6df 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;
@@ -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 */
@@ -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 */
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 8a0f67e5933..08c23a2b726 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'),
@@ -80,6 +72,8 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comm
( 50720, 59665, 0, 'Vigilance (redirect threat)'),
( 52610, 62071, 0, 'Savage Roar'),
( -52610, -62071, 0, 'Savage Roar'),
+(51209, 55095, 1, 'Hungering cold - frost fever'),
+(50334, 58923, 2, 'Berserk - modify target number aura'),
-- Creature
( 36574, 36650, 0, 'Apply Phase Slip Vulnerability'),
@@ -544,53 +538,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
-- --------
/*
@@ -606,22 +553,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)
@@ -1284,6 +1216,8 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell
( 51474, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0, 0, 0), -- Astral Shift (Rank 1)
( 51478, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0, 0, 0), -- Astral Shift (Rank 2)
( 51479, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0, 0, 0), -- Astral Shift (Rank 3)
+( 51521, 0x00, 11, 0x00000000, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Improved Stormstrike
+( 51522, 0x00, 11, 0x00000000, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Improved Stormstrike
( 51528, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 2.5, 0, 0), -- Maelstrom Weapon (Rank 1)
( 51529, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 5, 0, 0), -- Maelstrom Weapon (Rank 2)
( 51530, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 7.5, 0, 0), -- Maelstrom Weapon (Rank 3)
@@ -1310,6 +1244,9 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell
( 51667, 0x00, 8, 0x00020000, 0x00000008, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Cut to the Chase (Rank 3)
( 51668, 0x00, 8, 0x00020000, 0x00000008, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Cut to the Chase (Rank 4)
( 51669, 0x00, 8, 0x00020000, 0x00000008, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Cut to the Chase (Rank 5)
+( 51698, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 1), -- Honor Among Thieves
+( 51700, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 1), -- Honor Among Thieves
+( 51701, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 1), -- Honor Among Thieves
( 51672, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000010, 0, 0, 1), -- Unfair Advantage (Rank 1)
( 51674, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000010, 0, 0, 1), -- Unfair Advantage (Rank 2)
( 51679, 0x00, 8, 0x00000001, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Throwing Specialization (Rank 2)
@@ -1404,7 +1341,7 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell
( 55380, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Skyflare Swiftness
( 55381, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0, 0, 15), -- Mana Restore
( 55440, 0x00, 11, 0x00000040, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Glyph of Healing Wave
-( 55610, 0x00, 15, 0x00000000, 0x04000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Improved Icy Talons
+( 55610, 0x00, 15, 0x00000000, 0x04000000, 0x00000000, 0x00001000, 0x00000000, 0, 0, 0), -- Improved Icy Talons
( 55620, 0x00, 15, 0x00000001, 0x08000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Night of the Dead (Rank 1)
( 55623, 0x00, 15, 0x00000001, 0x08000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Night of the Dead (Rank 2)
( 55640, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 45), -- Lightweave Embroidery
@@ -1530,14 +1467,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
@@ -1553,16 +1483,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
@@ -1658,6 +1579,12 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
-- frostbrood vanquisher
update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110, VehicleId = 156 where entry = 28670;
+DELETE FROM `spell_script_target` WHERE entry IN
+(53110);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(53110,1,28940);
+
+
-- --------
-- NAXXARAMAS