From 061d10d87524d7213676ab3a8618180b465eaad9 Mon Sep 17 00:00:00 2001 From: Drahy Date: Fri, 6 Feb 2009 23:28:26 +0100 Subject: * Removed "()" from sql names because of an error in CMakeLists * Updated CMakeLists for current names * Changed some new sqls to proper names and directories * Reverted changes in ba79b83e93dc - now working properly with fixed Character converter * Some other cleaning --HG-- branch : trunk --- sql/TBC-WLK converter/TBC-WLK_characters.sql | 8 +- sql/updates/1018_wrold.sql | 6 - ...1_characters_character_achievement_progress.sql | 3 - ...1_characters_character_achievement_progress.sql | 3 + ...28_(mangos_7141)_01_world_instance_template.sql | 12 - ...28_(mangos_7147)_01_world_creature_template.sql | 4 - ...angos_7150)_01_world_playercreateinfo_spell.sql | 10 - ...1028_mangos_7141_01_world_instance_template.sql | 12 + ...1028_mangos_7147_01_world_creature_template.sql | 4 + ...mangos_7150_01_world_playercreateinfo_spell.sql | 10 + .../1084_(mangos_7168)_01_world_command.sql | 6 - sql/updates/1084_mangos_7168_01_world_command.sql | 6 + .../1094_(mangos_7193)_01_world_trinity_string.sql | 3 - .../1094_mangos_7193_01_world_trinity_string.sql | 3 + ...108_(mangos_7196)_02_world_spell_bonus_data.sql | 233 ------ ...1108_(mangos_7198)_01_characters_characters.sql | 27 - ...108_(mangos_7199)_01_world_spell_bonus_data.sql | 11 - .../1108_mangos_7196_02_world_spell_bonus_data.sql | 233 ++++++ .../1108_mangos_7198_01_characters_characters.sql | 27 + .../1108_mangos_7199_01_world_spell_bonus_data.sql | 11 + .../1135_(mangos_7207)_01_world_creature.sql | 4 - .../1135_(mangos_7207)_02_world_gameobject.sql | 4 - .../1135_(mangos_7207)_03_characters_corpse.sql | 4 - sql/updates/1135_mangos_7207_01_world_creature.sql | 4 + .../1135_mangos_7207_02_world_gameobject.sql | 4 + .../1135_mangos_7207_03_characters_corpse.sql | 4 + ...140_(mangos_7209)_01_world_spell_bonus_data.sql | 5 - .../1140_mangos_7209_01_world_spell_bonus_data.sql | 5 + .../1185_(mangos_7214)_01_world_command.sql | 8 - .../1185_(mangos_7214)_02_world_trinity_string.sql | 5 - ...85_(mangos_7214)_03_mangos_spell_proc_event.sql | 865 --------------------- sql/updates/1185_mangos_7214_01_world_command.sql | 8 + .../1185_mangos_7214_02_world_trinity_string.sql | 5 + .../1185_mangos_7214_03_world_spell_proc_event.sql | 865 +++++++++++++++++++++ .../1237_mangos_7230_01_world_spell_bonus_data.sql | 9 + sql/updates/1248_mangos_7235_01_world_command.sql | 5 + sql/updates/2.4.3_updates/1018_wrold.sql | 6 + sql/updates/7230_02_mangos_spell_bonus_data.sql | 9 - sql/updates/7235_01_mangos_command.sql | 5 - ...(mangos_7047)_01_characters_character_spell.sql | 22 - .../875_(mangos_7059)_01_characters_pet_spell.sql | 4 - ...5_mangos_7047_01_characters_character_spell.sql | 10 + .../875_mangos_7059_01_characters_pet_spell.sql | 4 + sql/updates/CMakeLists.txt | 40 +- 44 files changed, 1260 insertions(+), 1276 deletions(-) delete mode 100644 sql/updates/1018_wrold.sql delete mode 100644 sql/updates/1026_(mangos_7113)_01_characters_character_achievement_progress.sql create mode 100644 sql/updates/1026_mangos_7113_01_characters_character_achievement_progress.sql delete mode 100644 sql/updates/1028_(mangos_7141)_01_world_instance_template.sql delete mode 100644 sql/updates/1028_(mangos_7147)_01_world_creature_template.sql delete mode 100644 sql/updates/1028_(mangos_7150)_01_world_playercreateinfo_spell.sql create mode 100644 sql/updates/1028_mangos_7141_01_world_instance_template.sql create mode 100644 sql/updates/1028_mangos_7147_01_world_creature_template.sql create mode 100644 sql/updates/1028_mangos_7150_01_world_playercreateinfo_spell.sql delete mode 100644 sql/updates/1084_(mangos_7168)_01_world_command.sql create mode 100644 sql/updates/1084_mangos_7168_01_world_command.sql delete mode 100644 sql/updates/1094_(mangos_7193)_01_world_trinity_string.sql create mode 100644 sql/updates/1094_mangos_7193_01_world_trinity_string.sql delete mode 100644 sql/updates/1108_(mangos_7196)_02_world_spell_bonus_data.sql delete mode 100644 sql/updates/1108_(mangos_7198)_01_characters_characters.sql delete mode 100644 sql/updates/1108_(mangos_7199)_01_world_spell_bonus_data.sql create mode 100644 sql/updates/1108_mangos_7196_02_world_spell_bonus_data.sql create mode 100644 sql/updates/1108_mangos_7198_01_characters_characters.sql create mode 100644 sql/updates/1108_mangos_7199_01_world_spell_bonus_data.sql delete mode 100644 sql/updates/1135_(mangos_7207)_01_world_creature.sql delete mode 100644 sql/updates/1135_(mangos_7207)_02_world_gameobject.sql delete mode 100644 sql/updates/1135_(mangos_7207)_03_characters_corpse.sql create mode 100644 sql/updates/1135_mangos_7207_01_world_creature.sql create mode 100644 sql/updates/1135_mangos_7207_02_world_gameobject.sql create mode 100644 sql/updates/1135_mangos_7207_03_characters_corpse.sql delete mode 100644 sql/updates/1140_(mangos_7209)_01_world_spell_bonus_data.sql create mode 100644 sql/updates/1140_mangos_7209_01_world_spell_bonus_data.sql delete mode 100644 sql/updates/1185_(mangos_7214)_01_world_command.sql delete mode 100644 sql/updates/1185_(mangos_7214)_02_world_trinity_string.sql delete mode 100644 sql/updates/1185_(mangos_7214)_03_mangos_spell_proc_event.sql create mode 100644 sql/updates/1185_mangos_7214_01_world_command.sql create mode 100644 sql/updates/1185_mangos_7214_02_world_trinity_string.sql create mode 100644 sql/updates/1185_mangos_7214_03_world_spell_proc_event.sql create mode 100644 sql/updates/1237_mangos_7230_01_world_spell_bonus_data.sql create mode 100644 sql/updates/1248_mangos_7235_01_world_command.sql create mode 100644 sql/updates/2.4.3_updates/1018_wrold.sql delete mode 100644 sql/updates/7230_02_mangos_spell_bonus_data.sql delete mode 100644 sql/updates/7235_01_mangos_command.sql delete mode 100644 sql/updates/875_(mangos_7047)_01_characters_character_spell.sql delete mode 100644 sql/updates/875_(mangos_7059)_01_characters_pet_spell.sql create mode 100644 sql/updates/875_mangos_7047_01_characters_character_spell.sql create mode 100644 sql/updates/875_mangos_7059_01_characters_pet_spell.sql (limited to 'sql') diff --git a/sql/TBC-WLK converter/TBC-WLK_characters.sql b/sql/TBC-WLK converter/TBC-WLK_characters.sql index 0d56539701f..214c19fef14 100644 --- a/sql/TBC-WLK converter/TBC-WLK_characters.sql +++ b/sql/TBC-WLK converter/TBC-WLK_characters.sql @@ -372,10 +372,4 @@ UPDATE item_instance SET data= CONCAT( SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',30),' ',-30),' 0 0 0 ', SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',60),' ',-60+30),' 0 ', SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',134),' ',-134+60)) -WHERE SUBSTRING_INDEX(data,' ',134) = data AND SUBSTRING_INDEX(data,' ',134-1) <> data; - - - - - - \ No newline at end of file +WHERE SUBSTRING_INDEX(data,' ',134) = data AND SUBSTRING_INDEX(data,' ',134-1) <> data; \ No newline at end of file diff --git a/sql/updates/1018_wrold.sql b/sql/updates/1018_wrold.sql deleted file mode 100644 index ca298faa8f3..00000000000 --- a/sql/updates/1018_wrold.sql +++ /dev/null @@ -1,6 +0,0 @@ -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (31224,41292,44007,44867); -INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES -(31224, -1543, 2, 'Cloak of Shadows - Flare'), -(41292, 42017, 2, 'Aura of Suffering'), -(44007, -43657, 2, 'Storm Eye Safe Zone Immune'), -(44867, -46019, 2, 'Spectral Exhaustion - Teleport: Spectral Realm'); \ No newline at end of file diff --git a/sql/updates/1026_(mangos_7113)_01_characters_character_achievement_progress.sql b/sql/updates/1026_(mangos_7113)_01_characters_character_achievement_progress.sql deleted file mode 100644 index 6f125a6a2e6..00000000000 --- a/sql/updates/1026_(mangos_7113)_01_characters_character_achievement_progress.sql +++ /dev/null @@ -1,3 +0,0 @@ -/*ALTER TABLE character_db_version CHANGE COLUMN required_7100_01_characters_character_spell required_7113_01_characters_character_achievement_progress bit;*/ - -DELETE FROM character_achievement_progress WHERE counter=0; \ No newline at end of file diff --git a/sql/updates/1026_mangos_7113_01_characters_character_achievement_progress.sql b/sql/updates/1026_mangos_7113_01_characters_character_achievement_progress.sql new file mode 100644 index 00000000000..6f125a6a2e6 --- /dev/null +++ b/sql/updates/1026_mangos_7113_01_characters_character_achievement_progress.sql @@ -0,0 +1,3 @@ +/*ALTER TABLE character_db_version CHANGE COLUMN required_7100_01_characters_character_spell required_7113_01_characters_character_achievement_progress bit;*/ + +DELETE FROM character_achievement_progress WHERE counter=0; \ No newline at end of file diff --git a/sql/updates/1028_(mangos_7141)_01_world_instance_template.sql b/sql/updates/1028_(mangos_7141)_01_world_instance_template.sql deleted file mode 100644 index f86b9517a98..00000000000 --- a/sql/updates/1028_(mangos_7141)_01_world_instance_template.sql +++ /dev/null @@ -1,12 +0,0 @@ -/*ALTER TABLE db_version CHANGE COLUMN required_7133_02_mangos_spell_loot_template required_7141_01_mangos_instance_template bit;*/ - -ALTER TABLE instance_template ADD maxPlayersHeroic tinyint(3) unsigned NOT NULL default '0' AFTER maxPlayers; - -UPDATE instance_template SET maxPlayersHeroic = maxPlayers; - -DELETE FROM instance_template WHERE map IN (533,615,616,624); -INSERT INTO instance_template VALUES -(533,0,80,0,10,25,0,NULL,NULL,NULL,NULL,''), -(615,0,80,0,10,25,0,NULL,NULL,NULL,NULL,''), -(616,0,80,0,10,25,0,NULL,NULL,NULL,NULL,''), -(624,0,80,0,10,25,0,NULL,NULL,NULL,NULL,''); \ No newline at end of file diff --git a/sql/updates/1028_(mangos_7147)_01_world_creature_template.sql b/sql/updates/1028_(mangos_7147)_01_world_creature_template.sql deleted file mode 100644 index 385ec769156..00000000000 --- a/sql/updates/1028_(mangos_7147)_01_world_creature_template.sql +++ /dev/null @@ -1,4 +0,0 @@ -/*ALTER TABLE db_version CHANGE COLUMN required_7141_01_mangos_instance_template required_7147_01_mangos_creature_template bit;*/ - -UPDATE creature_template - SET family = 0 WHERE entry = 1; \ No newline at end of file diff --git a/sql/updates/1028_(mangos_7150)_01_world_playercreateinfo_spell.sql b/sql/updates/1028_(mangos_7150)_01_world_playercreateinfo_spell.sql deleted file mode 100644 index 6d4a5993e58..00000000000 --- a/sql/updates/1028_(mangos_7150)_01_world_playercreateinfo_spell.sql +++ /dev/null @@ -1,10 +0,0 @@ -/*ALTER TABLE db_version CHANGE COLUMN required_7149_01_mangos_spell_proc_event required_7150_01_mangos_playercreateinfo_spell bit;*/ - -DELETE FROM `playercreateinfo_spell` WHERE Spell = 58284; - -INSERT INTO `playercreateinfo_spell` VALUES -(1,9,58284,'Chaos Bolt Passive'), -(2,9,58284,'Chaos Bolt Passive'), -(5,9,58284,'Chaos Bolt Passive'), -(7,9,58284,'Chaos Bolt Passive'), -(10,9,58284,'Chaos Bolt Passive'); \ No newline at end of file diff --git a/sql/updates/1028_mangos_7141_01_world_instance_template.sql b/sql/updates/1028_mangos_7141_01_world_instance_template.sql new file mode 100644 index 00000000000..f86b9517a98 --- /dev/null +++ b/sql/updates/1028_mangos_7141_01_world_instance_template.sql @@ -0,0 +1,12 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7133_02_mangos_spell_loot_template required_7141_01_mangos_instance_template bit;*/ + +ALTER TABLE instance_template ADD maxPlayersHeroic tinyint(3) unsigned NOT NULL default '0' AFTER maxPlayers; + +UPDATE instance_template SET maxPlayersHeroic = maxPlayers; + +DELETE FROM instance_template WHERE map IN (533,615,616,624); +INSERT INTO instance_template VALUES +(533,0,80,0,10,25,0,NULL,NULL,NULL,NULL,''), +(615,0,80,0,10,25,0,NULL,NULL,NULL,NULL,''), +(616,0,80,0,10,25,0,NULL,NULL,NULL,NULL,''), +(624,0,80,0,10,25,0,NULL,NULL,NULL,NULL,''); \ No newline at end of file diff --git a/sql/updates/1028_mangos_7147_01_world_creature_template.sql b/sql/updates/1028_mangos_7147_01_world_creature_template.sql new file mode 100644 index 00000000000..385ec769156 --- /dev/null +++ b/sql/updates/1028_mangos_7147_01_world_creature_template.sql @@ -0,0 +1,4 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7141_01_mangos_instance_template required_7147_01_mangos_creature_template bit;*/ + +UPDATE creature_template + SET family = 0 WHERE entry = 1; \ No newline at end of file diff --git a/sql/updates/1028_mangos_7150_01_world_playercreateinfo_spell.sql b/sql/updates/1028_mangos_7150_01_world_playercreateinfo_spell.sql new file mode 100644 index 00000000000..6d4a5993e58 --- /dev/null +++ b/sql/updates/1028_mangos_7150_01_world_playercreateinfo_spell.sql @@ -0,0 +1,10 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7149_01_mangos_spell_proc_event required_7150_01_mangos_playercreateinfo_spell bit;*/ + +DELETE FROM `playercreateinfo_spell` WHERE Spell = 58284; + +INSERT INTO `playercreateinfo_spell` VALUES +(1,9,58284,'Chaos Bolt Passive'), +(2,9,58284,'Chaos Bolt Passive'), +(5,9,58284,'Chaos Bolt Passive'), +(7,9,58284,'Chaos Bolt Passive'), +(10,9,58284,'Chaos Bolt Passive'); \ No newline at end of file diff --git a/sql/updates/1084_(mangos_7168)_01_world_command.sql b/sql/updates/1084_(mangos_7168)_01_world_command.sql deleted file mode 100644 index b9df9bca12d..00000000000 --- a/sql/updates/1084_(mangos_7168)_01_world_command.sql +++ /dev/null @@ -1,6 +0,0 @@ -/*ALTER TABLE db_version CHANGE COLUMN required_7156_01_mangos_spell_proc_event required_7168_01_mangos_command bit;*/ - -DELETE FROM `command` WHERE `name` IN ('learn','unlearn'); -INSERT INTO `command` VALUES -('learn',3,'Syntax: .learn #spell [all]\r\n\r\nSelected character learn a spell of id #spell. If \'all\' provided then all ranks learned.'), -('unlearn',3,'Syntax: .unlearn #spell [all]\r\n\r\nUnlearn for selected player a spell #spell. If \'all\' provided then all ranks unlearned.'); \ No newline at end of file diff --git a/sql/updates/1084_mangos_7168_01_world_command.sql b/sql/updates/1084_mangos_7168_01_world_command.sql new file mode 100644 index 00000000000..b9df9bca12d --- /dev/null +++ b/sql/updates/1084_mangos_7168_01_world_command.sql @@ -0,0 +1,6 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7156_01_mangos_spell_proc_event required_7168_01_mangos_command bit;*/ + +DELETE FROM `command` WHERE `name` IN ('learn','unlearn'); +INSERT INTO `command` VALUES +('learn',3,'Syntax: .learn #spell [all]\r\n\r\nSelected character learn a spell of id #spell. If \'all\' provided then all ranks learned.'), +('unlearn',3,'Syntax: .unlearn #spell [all]\r\n\r\nUnlearn for selected player a spell #spell. If \'all\' provided then all ranks unlearned.'); \ No newline at end of file diff --git a/sql/updates/1094_(mangos_7193)_01_world_trinity_string.sql b/sql/updates/1094_(mangos_7193)_01_world_trinity_string.sql deleted file mode 100644 index 44a390d20f6..00000000000 --- a/sql/updates/1094_(mangos_7193)_01_world_trinity_string.sql +++ /dev/null @@ -1,3 +0,0 @@ -/*ALTER TABLE db_version CHANGE COLUMN required_7175_01_mangos_spell_proc_event required_7193_01_mangos_mangos_string bit;*/ - -UPDATE mangos_string SET content_default = 'Unit Flags: %u.\nDynamic Flags: %u.\nFaction Template: %u.' WHERE entry = 542; \ No newline at end of file diff --git a/sql/updates/1094_mangos_7193_01_world_trinity_string.sql b/sql/updates/1094_mangos_7193_01_world_trinity_string.sql new file mode 100644 index 00000000000..44a390d20f6 --- /dev/null +++ b/sql/updates/1094_mangos_7193_01_world_trinity_string.sql @@ -0,0 +1,3 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7175_01_mangos_spell_proc_event required_7193_01_mangos_mangos_string bit;*/ + +UPDATE mangos_string SET content_default = 'Unit Flags: %u.\nDynamic Flags: %u.\nFaction Template: %u.' WHERE entry = 542; \ No newline at end of file diff --git a/sql/updates/1108_(mangos_7196)_02_world_spell_bonus_data.sql b/sql/updates/1108_(mangos_7196)_02_world_spell_bonus_data.sql deleted file mode 100644 index 8f6fdbd1463..00000000000 --- a/sql/updates/1108_(mangos_7196)_02_world_spell_bonus_data.sql +++ /dev/null @@ -1,233 +0,0 @@ -/*ALTER TABLE db_version CHANGE COLUMN required_7196_01_mangos_spell_chain required_7196_02_mangos_spell_bonus_data bit;*/ - --- ---------------------------- --- Table structure for spell_bonus_data --- ---------------------------- -DROP TABLE IF EXISTS `spell_bonus_data`; -CREATE TABLE `spell_bonus_data` ( - `entry` smallint(5) unsigned NOT NULL, - `direct_bonus` float NOT NULL default '0', - `dot_bonus` float NOT NULL default '0', - `ap_bonus` float NOT NULL default '0', - `comments` varchar(255) default NULL, - PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -INSERT INTO `spell_bonus_data` VALUES -('5185', '1.6104', '0', '0', 'Druid - Healing Touch'), -('33763', '0', '0.09518', '0', 'Druid - Lifebloom'), -('774', '0', '0.37604', '0', 'Druid - Rejuvenation'), -('8936', '0.539', '0.188', '0', 'Druid - Regrowth'), -('18562', '0', '0', '0', 'Druid - Swiftmend'), -('44203', '0.538', '0', '0', 'Druid - Tranquility Triggered'), -('48438', '0', '0.11505', '0', 'Druid - Wild Growth'), -('50464', '0.6611', '0', '0', 'Druid - Nourish'), -('339', '0', '0.1', '0', 'Druid - Entangling Roots'), -('42231', '0.12898', '0', '0', 'Druid - Hurricane Triggered'), -('5570', '0', '0.127', '0', 'Druid - Insect Swarm'), -('8921', '0.1515', '0.13', '0', 'Druid - Moonfire'), -('2912', '1', '0', '0', 'Druid - Starfire'), -('5176', '0.5714', '0', '0', 'Druid - Wrath'), -('30451', '0.7143', '0', '0', 'Mage - Arcane Blast'), -('1449', '0.2128', '0', '0', 'Mage - Arcane Explosion'), -('7268', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 1'), -('7269', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 2'), -('7270', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 3'), -('8419', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 4'), -('8418', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 5'), -('10273', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 6'), -('10274', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 7'), -('25346', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 8'), -('27076', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 9'), -('38700', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 10'), -('38703', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 11'), -('42844', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 12'), -('42845', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 13'), -('1463', '0.8053', '0', '0', 'Mage - Mana Shield'), -('44425', '0.8571', '0', '0', 'Mage - Arcane Barrage'), -('11113', '0.1357', '0', '0', 'Mage - Blast Wave Rank'), -('31661', '0.1357', '0', '0', 'Mage - Dragons Breath'), -('2136', '0.4286', '0', '0', 'Mage - Fire Blast'), -('133', '1', '0', '0', 'Mage - Fire Ball'), -('2120', '0.2357', '0.122', '0', 'Mage - Flamestrike'), -('11366', '1.15', '0.05', '0', 'Mage - Pyroblast'), -('2948', '0.4286', '0', '0', 'Mage - Scorch'), -('44614', '0.8571', '0', '0', 'Frostfire Bolt'), -('44457', '0.4', '0.2', '0', 'Mage - Living Bomb'), -('42208', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 1'), -('42209', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 2'), -('42210', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 3'), -('42211', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 4'), -('42212', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 5'), -('42213', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 6'), -('42198', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 7'), -('42937', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 8'), -('42938', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 9'), -('120', '0.1357', '0', '0', 'Mage - Cone of Cold'), -('122', '0.193', '0', '0', 'Mage - Frost Nova'), -('116', '0.8143', '0', '0', 'Mage - Frost Bolt'), -('11426', '0.8053', '0', '0', 'Mage - Ice Barrier'), -('30455', '0.1429', '0', '0', 'Mage - Ice Lance'), -('19750', '0.4286', '0', '0', 'Paladin - Flash of Light'), -('635', '0.7143', '0', '0', 'Paladin - Holy Light'), -('25912', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 1'), -('25911', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 2'), -('25902', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 3'), -('27176', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 4'), -('33073', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 5'), -('48822', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 6'), -('48823', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 7'), -('25914', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 1'), -('25913', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 2'), -('25903', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 3'), -('27175', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 4'), -('33074', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 5'), -('48820', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 6'), -('48821', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 7'), -('31935', '0.07', '0', '0.07', 'Paladin - Avengers Shiled'), -('26573', '0', '0.04', '0.04', 'Paladin - Consecration'), -('879', '0.15', '0', '0.15', 'Paladin - Exorcism'), -('24275', '0.15', '0', '0.15', 'Paladin - Hammer of Wrath'), -('20925', '0.09', '0', '0.056', 'Paladin - Holy Shield'), -('2812', '0.07', '0', '0.07', 'Paladin - Holy Wrath'), -('31893', '0.25', '0', '0.16', 'Paladin - Seal of Blood Enemy Proc'), -('32221', '0.25', '0', '0.16', 'Paladin - Seal of Blood Self Proc'), -('20424', '0.25', '0', '0.16', 'Paladin - Seal of Command Proc'), -('379', '0', '0', '0', 'Shaman - Earth Shield Triggered'), -('20167', '0.25', '0', '0.16', 'Paladin - Seal of Light Proc'), -('53719', '0.25', '0', '0.16', 'Paladin - Seal of The Martyr Enemy Proc'), -('53718', '0.25', '0', '0.16', 'Paladin - Seal of The Martyr Self Proc'), -('25742', '0.07', '0', '0.039', 'Paladin - Seal of Righteousness Dummy Proc'), -('31803', '0', '0.013', '0.15', 'Paladin - Holy Vengeance'), -('52042', '0.045', '0', '0', 'Shaman - Healing Stream Totem Triggered Heal'), -('32546', '0.8068', '0', '0', 'Priest - Binding Heal'), -('34861', '0.402', '0', '0', 'Priest - Circle of Healing'), -('19236', '0.8068', '0', '0', 'Priest - Desperate Prayer'), -('2061', '0.8068', '0', '0', 'Priest - Flash Heal'), -('2060', '1.6135', '0', '0', 'Priest - Greater Heal'), -('23455', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 1'), -('23458', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 2'), -('23459', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 3'), -('27803', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 4'), -('27804', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 5'), -('27805', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 6'), -('25329', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 7'), -('17', '0.8068', '0', '0', 'Priest - Power Word: Shield'), -('596', '0.8086', '0', '0', 'Priest - Prayer of Healing'), -('33110', '0.8068', '0', '0', 'Priest - Prayer of Mending Heal Proc'), -('139', '1.88', '0', '0', 'Priest - Renew'), -('2944', '0.1849', '0', '0', 'Priest - Devouring Plague'), -('14914', '0.5711', '0.024', '0', 'Priest - Holy Fire'), -('15237', '0.1606', '0', '0', 'Priest - Holy Nova Damage'), -('8129', '0', '0', '0', 'Priest - Mana Burn'), -('8092', '0.4296', '0', '0', 'Priest - Mind Blast'), -('15407', '0.257', '0', '0', 'Priest - Mind Flay'), -('49821', '0.7143', '0', '0', 'Priest - Mind Sear Trigger Rank 1'), -('53022', '0.7143', '0', '0', 'Priest - Mind Sear Trigger Rank 2'), -('34433', '0.65', '0', '0', 'Priest - Shadowfiend'), -('32379', '0.4296', '0', '0', 'Priest - Shadow Word: Death'), -('589', '0', '0.1829', '0', 'Priest - Shadow Word: Pain'), -('585', '0.714', '0', '0', 'Priest - Smite'), -('34914', '0', '0.4', '0', 'Priest - Vampiric Touch'), -('974', '0.4762', '0', '0', 'Shaman - Earth Shield'), -('1064', '1.34', '0', '0', 'Shaman - Chain Heal'), -('331', '1.6106', '0', '0', 'Shaman - Healing Wave'), -('8004', '0.8082', '0', '0', 'Shaman - Lesser Healing Wave'), -('61295', '0.4', '0.18', '0', 'Shaman - Riptide'), -('421', '0.57', '0', '0', 'Shaman - Chain Lightning'), -('8042', '0.3858', '0', '0', 'Shaman - Earth Shock'), -('8443', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 1'), -('8504', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 2'), -('8505', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 3'), -('11310', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 4'), -('11311', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 5'), -('25538', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 6'), -('25539', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 7'), -('61651', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 8'), -('61660', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 9'), -('8050', '0.2142', '0.1', '0', 'Shaman - Flame Shock'), -('8026', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 1'), -('8028', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 2'), -('8029', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 3'), -('10445', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 4'), -('16343', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 5'), -('16344', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 6'), -('25488', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 7'), -('58786', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 8'), -('58787', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 9'), -('58788', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 10'), -('8056', '0.3858', '0', '0', 'Shaman - Frost Shock'), -('8034', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 1'), -('8037', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 2'), -('10458', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 3'), -('16352', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 4'), -('16353', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 5'), -('25501', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 6'), -('58797', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 7'), -('58798', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 8'), -('58799', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 9'), -('51505', '0.5714', '0', '0', 'Shaman - Lava Burst'), -('403', '0.7143', '0', '0', 'Shaman - Lightning Bolt'), -('26364', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 1'), -('26365', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 2'), -('26366', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 3'), -('26367', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 4'), -('26369', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 5'), -('26370', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 6'), -('26363', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 7'), -('26371', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 8'), -('26372', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 9'), -('49278', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 10'), -('49279', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 11'), -('8188', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 1'), -('10582', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 2'), -('10583', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 3'), -('10584', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 4'), -('25551', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 5'), -('58733', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 6'), -('58736', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 7'), -('3606', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 1'), -('6350', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 2'), -('6351', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 3'), -('6352', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 4'), -('10435', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 5'), -('10436', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 6'), -('25530', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 7'), -('58700', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 8'), -('58701', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 9'), -('58702', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 10'), -('980', '0', '0.1', '0', 'Warlock - Curse of Agony'), -('603', '0', '2', '0', 'Warlock - Curse of Doom'), -('172', '0', '0.3', '0', 'Warlock - Corruption'), -('348', '0.2', '0.2', '0', 'Warlock - Immolate'), -('27243', '0.22', '0.25', '0', 'Warlock - Seed of Corruption'), -('18265', '0', '1', '0', 'Warlock - Siphon Life'), -('30108', '0', '0.24', '0', 'Warlock - Unstable Affliction'), -('17962', '0.4286', '0', '0', 'Warlock - Conflagrate'), -('6789', '0.22', '0', '0', 'Warlock - Death Coil'), -('48181', '0.4729', '0', '0', 'Warlock - Haunt'), -('29722', '0.7143', '0', '0', 'Warlock - Incinerate'), -('5676', '0.4286', '0', '0', 'Warlock - Searing Pain'), -('686', '0.8571', '0', '0', 'Warlock - Shadow Bolt'), -('17877', '0.4286', '0', '0', 'Warlock - Shadowburn'), -('30283', '0.195', '0', '0', 'Warlock - Shadowfury'), -('6353', '1.15', '0', '0', 'Warlock - Soul Fire'), -('689', '0', '0.1428', '0', 'Warlock - Drain Life'), -('5138', '0', '0', '0', 'Warlock - Drain Mana'), -('1120', '0', '0.4286', '0', 'Warlock - Drain Soul'), -('755', '0', '0.4485', '0', 'Warlock - Health Funnel'), -('1949', '0', '0.0946', '0', 'Warlock - Hellfire'), -('5857', '0.1428', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 1'), -('11681', '0.1428', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 2'), -('11682', '0.1428', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 3'), -('27214', '0.1428', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 4'), -('47822', '0.1428', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 5'), -('42223', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 1'), -('42224', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 2'), -('42225', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 3'), -('42226', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 4'), -('42218', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 5'), -('47817', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 6'), -('47818', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 7'), -('18220', '0.96', '0', '0', 'Warlock - Dark Pact'), -('6229', '0.3', '0', '0', 'Warlock - Shadow Ward'); \ No newline at end of file diff --git a/sql/updates/1108_(mangos_7198)_01_characters_characters.sql b/sql/updates/1108_(mangos_7198)_01_characters_characters.sql deleted file mode 100644 index 104a31359df..00000000000 --- a/sql/updates/1108_(mangos_7198)_01_characters_characters.sql +++ /dev/null @@ -1,27 +0,0 @@ -/*ALTER TABLE character_db_version CHANGE COLUMN required_7113_01_characters_character_achievement_progress required_7198_01_characters_characters bit;*/ - -UPDATE `characters`.`item_instance` AS `t1` -INNER JOIN `world`.`item_template` AS `t2` ON -`t2`.`entry` = SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',4),' ',-1) -SET `t1`.`data` = CONCAT( - SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',16),' ',-16), ' ', - IF (`t2`.`spellcharges_1` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',17),' ',-1) = 0, IF(`t2`.`spellcharges_1` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',17),' ',-1))), ' ', - IF (`t2`.`spellcharges_2` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',18),' ',-1) = 0, IF(`t2`.`spellcharges_2` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',18),' ',-1))), ' ', - IF (`t2`.`spellcharges_3` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',19),' ',-1) = 0, IF(`t2`.`spellcharges_3` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',19),' ',-1))), ' ', - IF (`t2`.`spellcharges_4` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',20),' ',-1) = 0, IF(`t2`.`spellcharges_4` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',20),' ',-1))), ' ', - IF (`t2`.`spellcharges_5` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',21),' ',-1) = 0, IF(`t2`.`spellcharges_5` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',21),' ',-1))), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',64),' ',-64+21),' ') -WHERE (`t2`.`spellid_1` = 55884) AND (SUBSTRING_INDEX(data,' ',64) = data AND SUBSTRING_INDEX(data,' ',64-1) <> data); - -UPDATE `characters`.`item_instance` AS `t1` -INNER JOIN `world`.`item_template` AS `t2` ON -`t2`.`entry` = SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',4),' ',-1) -SET `t1`.`data` = CONCAT( - SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',16),' ',-16), ' ', - IF (`t2`.`spellcharges_1` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',17),' ',-1) = 0, IF(`t2`.`spellcharges_1` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',17),' ',-1))), ' ', - IF (`t2`.`spellcharges_2` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',18),' ',-1) = 0, IF(`t2`.`spellcharges_2` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',18),' ',-1))), ' ', - IF (`t2`.`spellcharges_3` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',19),' ',-1) = 0, IF(`t2`.`spellcharges_3` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',19),' ',-1))), ' ', - IF (`t2`.`spellcharges_4` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',20),' ',-1) = 0, IF(`t2`.`spellcharges_4` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',20),' ',-1))), ' ', - IF (`t2`.`spellcharges_5` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',21),' ',-1) = 0, IF(`t2`.`spellcharges_5` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',21),' ',-1))), ' ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',138),' ',-138+21),' ') -WHERE (`t2`.`spellid_1` = 55884) AND (SUBSTRING_INDEX(data,' ',138) = data AND SUBSTRING_INDEX(data,' ',138-1) <> data); \ No newline at end of file diff --git a/sql/updates/1108_(mangos_7199)_01_world_spell_bonus_data.sql b/sql/updates/1108_(mangos_7199)_01_world_spell_bonus_data.sql deleted file mode 100644 index 89bad64d3e1..00000000000 --- a/sql/updates/1108_(mangos_7199)_01_world_spell_bonus_data.sql +++ /dev/null @@ -1,11 +0,0 @@ -/*ALTER TABLE db_version CHANGE COLUMN required_7196_02_mangos_spell_bonus_data required_7199_01_mangos_spell_bonus_data bit;*/ - -DELETE FROM `spell_bonus_data` WHERE `entry` IN (44614, 139, 49821, 53022, 18265, 31117, 28176); -INSERT INTO `spell_bonus_data` VALUES -('44614', '0.8571', '0', '0', 'Mage - Frostfire Bolt'), -('139', '0', '0.376', '0', 'Priest - Renew'), -('49821', '0.14286', '0', '0', 'Priest - Mind Sear Trigger Rank 1'), -('53022', '0.14286', '0', '0', 'Priest - Mind Sear Trigger Rank 2'), -('18265', '0', '0.1', '0', 'Warlock - Siphon Life'), -('31117', '1.8', '0', '0', 'Warlock - Unstable Affliction Dispell'), -('28176', '0', '0', '0', 'Warlock - Fel Armor'); \ No newline at end of file diff --git a/sql/updates/1108_mangos_7196_02_world_spell_bonus_data.sql b/sql/updates/1108_mangos_7196_02_world_spell_bonus_data.sql new file mode 100644 index 00000000000..8f6fdbd1463 --- /dev/null +++ b/sql/updates/1108_mangos_7196_02_world_spell_bonus_data.sql @@ -0,0 +1,233 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7196_01_mangos_spell_chain required_7196_02_mangos_spell_bonus_data bit;*/ + +-- ---------------------------- +-- Table structure for spell_bonus_data +-- ---------------------------- +DROP TABLE IF EXISTS `spell_bonus_data`; +CREATE TABLE `spell_bonus_data` ( + `entry` smallint(5) unsigned NOT NULL, + `direct_bonus` float NOT NULL default '0', + `dot_bonus` float NOT NULL default '0', + `ap_bonus` float NOT NULL default '0', + `comments` varchar(255) default NULL, + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +INSERT INTO `spell_bonus_data` VALUES +('5185', '1.6104', '0', '0', 'Druid - Healing Touch'), +('33763', '0', '0.09518', '0', 'Druid - Lifebloom'), +('774', '0', '0.37604', '0', 'Druid - Rejuvenation'), +('8936', '0.539', '0.188', '0', 'Druid - Regrowth'), +('18562', '0', '0', '0', 'Druid - Swiftmend'), +('44203', '0.538', '0', '0', 'Druid - Tranquility Triggered'), +('48438', '0', '0.11505', '0', 'Druid - Wild Growth'), +('50464', '0.6611', '0', '0', 'Druid - Nourish'), +('339', '0', '0.1', '0', 'Druid - Entangling Roots'), +('42231', '0.12898', '0', '0', 'Druid - Hurricane Triggered'), +('5570', '0', '0.127', '0', 'Druid - Insect Swarm'), +('8921', '0.1515', '0.13', '0', 'Druid - Moonfire'), +('2912', '1', '0', '0', 'Druid - Starfire'), +('5176', '0.5714', '0', '0', 'Druid - Wrath'), +('30451', '0.7143', '0', '0', 'Mage - Arcane Blast'), +('1449', '0.2128', '0', '0', 'Mage - Arcane Explosion'), +('7268', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 1'), +('7269', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 2'), +('7270', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 3'), +('8419', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 4'), +('8418', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 5'), +('10273', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 6'), +('10274', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 7'), +('25346', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 8'), +('27076', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 9'), +('38700', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 10'), +('38703', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 11'), +('42844', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 12'), +('42845', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 13'), +('1463', '0.8053', '0', '0', 'Mage - Mana Shield'), +('44425', '0.8571', '0', '0', 'Mage - Arcane Barrage'), +('11113', '0.1357', '0', '0', 'Mage - Blast Wave Rank'), +('31661', '0.1357', '0', '0', 'Mage - Dragons Breath'), +('2136', '0.4286', '0', '0', 'Mage - Fire Blast'), +('133', '1', '0', '0', 'Mage - Fire Ball'), +('2120', '0.2357', '0.122', '0', 'Mage - Flamestrike'), +('11366', '1.15', '0.05', '0', 'Mage - Pyroblast'), +('2948', '0.4286', '0', '0', 'Mage - Scorch'), +('44614', '0.8571', '0', '0', 'Frostfire Bolt'), +('44457', '0.4', '0.2', '0', 'Mage - Living Bomb'), +('42208', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 1'), +('42209', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 2'), +('42210', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 3'), +('42211', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 4'), +('42212', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 5'), +('42213', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 6'), +('42198', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 7'), +('42937', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 8'), +('42938', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 9'), +('120', '0.1357', '0', '0', 'Mage - Cone of Cold'), +('122', '0.193', '0', '0', 'Mage - Frost Nova'), +('116', '0.8143', '0', '0', 'Mage - Frost Bolt'), +('11426', '0.8053', '0', '0', 'Mage - Ice Barrier'), +('30455', '0.1429', '0', '0', 'Mage - Ice Lance'), +('19750', '0.4286', '0', '0', 'Paladin - Flash of Light'), +('635', '0.7143', '0', '0', 'Paladin - Holy Light'), +('25912', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 1'), +('25911', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 2'), +('25902', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 3'), +('27176', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 4'), +('33073', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 5'), +('48822', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 6'), +('48823', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 7'), +('25914', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 1'), +('25913', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 2'), +('25903', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 3'), +('27175', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 4'), +('33074', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 5'), +('48820', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 6'), +('48821', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 7'), +('31935', '0.07', '0', '0.07', 'Paladin - Avengers Shiled'), +('26573', '0', '0.04', '0.04', 'Paladin - Consecration'), +('879', '0.15', '0', '0.15', 'Paladin - Exorcism'), +('24275', '0.15', '0', '0.15', 'Paladin - Hammer of Wrath'), +('20925', '0.09', '0', '0.056', 'Paladin - Holy Shield'), +('2812', '0.07', '0', '0.07', 'Paladin - Holy Wrath'), +('31893', '0.25', '0', '0.16', 'Paladin - Seal of Blood Enemy Proc'), +('32221', '0.25', '0', '0.16', 'Paladin - Seal of Blood Self Proc'), +('20424', '0.25', '0', '0.16', 'Paladin - Seal of Command Proc'), +('379', '0', '0', '0', 'Shaman - Earth Shield Triggered'), +('20167', '0.25', '0', '0.16', 'Paladin - Seal of Light Proc'), +('53719', '0.25', '0', '0.16', 'Paladin - Seal of The Martyr Enemy Proc'), +('53718', '0.25', '0', '0.16', 'Paladin - Seal of The Martyr Self Proc'), +('25742', '0.07', '0', '0.039', 'Paladin - Seal of Righteousness Dummy Proc'), +('31803', '0', '0.013', '0.15', 'Paladin - Holy Vengeance'), +('52042', '0.045', '0', '0', 'Shaman - Healing Stream Totem Triggered Heal'), +('32546', '0.8068', '0', '0', 'Priest - Binding Heal'), +('34861', '0.402', '0', '0', 'Priest - Circle of Healing'), +('19236', '0.8068', '0', '0', 'Priest - Desperate Prayer'), +('2061', '0.8068', '0', '0', 'Priest - Flash Heal'), +('2060', '1.6135', '0', '0', 'Priest - Greater Heal'), +('23455', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 1'), +('23458', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 2'), +('23459', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 3'), +('27803', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 4'), +('27804', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 5'), +('27805', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 6'), +('25329', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 7'), +('17', '0.8068', '0', '0', 'Priest - Power Word: Shield'), +('596', '0.8086', '0', '0', 'Priest - Prayer of Healing'), +('33110', '0.8068', '0', '0', 'Priest - Prayer of Mending Heal Proc'), +('139', '1.88', '0', '0', 'Priest - Renew'), +('2944', '0.1849', '0', '0', 'Priest - Devouring Plague'), +('14914', '0.5711', '0.024', '0', 'Priest - Holy Fire'), +('15237', '0.1606', '0', '0', 'Priest - Holy Nova Damage'), +('8129', '0', '0', '0', 'Priest - Mana Burn'), +('8092', '0.4296', '0', '0', 'Priest - Mind Blast'), +('15407', '0.257', '0', '0', 'Priest - Mind Flay'), +('49821', '0.7143', '0', '0', 'Priest - Mind Sear Trigger Rank 1'), +('53022', '0.7143', '0', '0', 'Priest - Mind Sear Trigger Rank 2'), +('34433', '0.65', '0', '0', 'Priest - Shadowfiend'), +('32379', '0.4296', '0', '0', 'Priest - Shadow Word: Death'), +('589', '0', '0.1829', '0', 'Priest - Shadow Word: Pain'), +('585', '0.714', '0', '0', 'Priest - Smite'), +('34914', '0', '0.4', '0', 'Priest - Vampiric Touch'), +('974', '0.4762', '0', '0', 'Shaman - Earth Shield'), +('1064', '1.34', '0', '0', 'Shaman - Chain Heal'), +('331', '1.6106', '0', '0', 'Shaman - Healing Wave'), +('8004', '0.8082', '0', '0', 'Shaman - Lesser Healing Wave'), +('61295', '0.4', '0.18', '0', 'Shaman - Riptide'), +('421', '0.57', '0', '0', 'Shaman - Chain Lightning'), +('8042', '0.3858', '0', '0', 'Shaman - Earth Shock'), +('8443', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 1'), +('8504', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 2'), +('8505', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 3'), +('11310', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 4'), +('11311', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 5'), +('25538', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 6'), +('25539', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 7'), +('61651', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 8'), +('61660', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 9'), +('8050', '0.2142', '0.1', '0', 'Shaman - Flame Shock'), +('8026', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 1'), +('8028', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 2'), +('8029', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 3'), +('10445', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 4'), +('16343', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 5'), +('16344', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 6'), +('25488', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 7'), +('58786', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 8'), +('58787', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 9'), +('58788', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 10'), +('8056', '0.3858', '0', '0', 'Shaman - Frost Shock'), +('8034', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 1'), +('8037', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 2'), +('10458', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 3'), +('16352', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 4'), +('16353', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 5'), +('25501', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 6'), +('58797', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 7'), +('58798', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 8'), +('58799', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 9'), +('51505', '0.5714', '0', '0', 'Shaman - Lava Burst'), +('403', '0.7143', '0', '0', 'Shaman - Lightning Bolt'), +('26364', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 1'), +('26365', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 2'), +('26366', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 3'), +('26367', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 4'), +('26369', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 5'), +('26370', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 6'), +('26363', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 7'), +('26371', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 8'), +('26372', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 9'), +('49278', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 10'), +('49279', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 11'), +('8188', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 1'), +('10582', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 2'), +('10583', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 3'), +('10584', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 4'), +('25551', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 5'), +('58733', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 6'), +('58736', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 7'), +('3606', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 1'), +('6350', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 2'), +('6351', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 3'), +('6352', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 4'), +('10435', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 5'), +('10436', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 6'), +('25530', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 7'), +('58700', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 8'), +('58701', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 9'), +('58702', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 10'), +('980', '0', '0.1', '0', 'Warlock - Curse of Agony'), +('603', '0', '2', '0', 'Warlock - Curse of Doom'), +('172', '0', '0.3', '0', 'Warlock - Corruption'), +('348', '0.2', '0.2', '0', 'Warlock - Immolate'), +('27243', '0.22', '0.25', '0', 'Warlock - Seed of Corruption'), +('18265', '0', '1', '0', 'Warlock - Siphon Life'), +('30108', '0', '0.24', '0', 'Warlock - Unstable Affliction'), +('17962', '0.4286', '0', '0', 'Warlock - Conflagrate'), +('6789', '0.22', '0', '0', 'Warlock - Death Coil'), +('48181', '0.4729', '0', '0', 'Warlock - Haunt'), +('29722', '0.7143', '0', '0', 'Warlock - Incinerate'), +('5676', '0.4286', '0', '0', 'Warlock - Searing Pain'), +('686', '0.8571', '0', '0', 'Warlock - Shadow Bolt'), +('17877', '0.4286', '0', '0', 'Warlock - Shadowburn'), +('30283', '0.195', '0', '0', 'Warlock - Shadowfury'), +('6353', '1.15', '0', '0', 'Warlock - Soul Fire'), +('689', '0', '0.1428', '0', 'Warlock - Drain Life'), +('5138', '0', '0', '0', 'Warlock - Drain Mana'), +('1120', '0', '0.4286', '0', 'Warlock - Drain Soul'), +('755', '0', '0.4485', '0', 'Warlock - Health Funnel'), +('1949', '0', '0.0946', '0', 'Warlock - Hellfire'), +('5857', '0.1428', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 1'), +('11681', '0.1428', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 2'), +('11682', '0.1428', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 3'), +('27214', '0.1428', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 4'), +('47822', '0.1428', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 5'), +('42223', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 1'), +('42224', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 2'), +('42225', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 3'), +('42226', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 4'), +('42218', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 5'), +('47817', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 6'), +('47818', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 7'), +('18220', '0.96', '0', '0', 'Warlock - Dark Pact'), +('6229', '0.3', '0', '0', 'Warlock - Shadow Ward'); \ No newline at end of file diff --git a/sql/updates/1108_mangos_7198_01_characters_characters.sql b/sql/updates/1108_mangos_7198_01_characters_characters.sql new file mode 100644 index 00000000000..104a31359df --- /dev/null +++ b/sql/updates/1108_mangos_7198_01_characters_characters.sql @@ -0,0 +1,27 @@ +/*ALTER TABLE character_db_version CHANGE COLUMN required_7113_01_characters_character_achievement_progress required_7198_01_characters_characters bit;*/ + +UPDATE `characters`.`item_instance` AS `t1` +INNER JOIN `world`.`item_template` AS `t2` ON +`t2`.`entry` = SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',4),' ',-1) +SET `t1`.`data` = CONCAT( + SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',16),' ',-16), ' ', + IF (`t2`.`spellcharges_1` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',17),' ',-1) = 0, IF(`t2`.`spellcharges_1` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',17),' ',-1))), ' ', + IF (`t2`.`spellcharges_2` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',18),' ',-1) = 0, IF(`t2`.`spellcharges_2` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',18),' ',-1))), ' ', + IF (`t2`.`spellcharges_3` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',19),' ',-1) = 0, IF(`t2`.`spellcharges_3` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',19),' ',-1))), ' ', + IF (`t2`.`spellcharges_4` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',20),' ',-1) = 0, IF(`t2`.`spellcharges_4` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',20),' ',-1))), ' ', + IF (`t2`.`spellcharges_5` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',21),' ',-1) = 0, IF(`t2`.`spellcharges_5` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',21),' ',-1))), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',64),' ',-64+21),' ') +WHERE (`t2`.`spellid_1` = 55884) AND (SUBSTRING_INDEX(data,' ',64) = data AND SUBSTRING_INDEX(data,' ',64-1) <> data); + +UPDATE `characters`.`item_instance` AS `t1` +INNER JOIN `world`.`item_template` AS `t2` ON +`t2`.`entry` = SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',4),' ',-1) +SET `t1`.`data` = CONCAT( + SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',16),' ',-16), ' ', + IF (`t2`.`spellcharges_1` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',17),' ',-1) = 0, IF(`t2`.`spellcharges_1` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',17),' ',-1))), ' ', + IF (`t2`.`spellcharges_2` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',18),' ',-1) = 0, IF(`t2`.`spellcharges_2` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',18),' ',-1))), ' ', + IF (`t2`.`spellcharges_3` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',19),' ',-1) = 0, IF(`t2`.`spellcharges_3` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',19),' ',-1))), ' ', + IF (`t2`.`spellcharges_4` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',20),' ',-1) = 0, IF(`t2`.`spellcharges_4` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',20),' ',-1))), ' ', + IF (`t2`.`spellcharges_5` = 0, 0, IF (SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',21),' ',-1) = 0, IF(`t2`.`spellcharges_5` < 0, 4294967295, 1), SUBSTRING_INDEX(SUBSTRING_INDEX(`t1`.`data`,' ',21),' ',-1))), ' ', + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',138),' ',-138+21),' ') +WHERE (`t2`.`spellid_1` = 55884) AND (SUBSTRING_INDEX(data,' ',138) = data AND SUBSTRING_INDEX(data,' ',138-1) <> data); \ No newline at end of file diff --git a/sql/updates/1108_mangos_7199_01_world_spell_bonus_data.sql b/sql/updates/1108_mangos_7199_01_world_spell_bonus_data.sql new file mode 100644 index 00000000000..89bad64d3e1 --- /dev/null +++ b/sql/updates/1108_mangos_7199_01_world_spell_bonus_data.sql @@ -0,0 +1,11 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7196_02_mangos_spell_bonus_data required_7199_01_mangos_spell_bonus_data bit;*/ + +DELETE FROM `spell_bonus_data` WHERE `entry` IN (44614, 139, 49821, 53022, 18265, 31117, 28176); +INSERT INTO `spell_bonus_data` VALUES +('44614', '0.8571', '0', '0', 'Mage - Frostfire Bolt'), +('139', '0', '0.376', '0', 'Priest - Renew'), +('49821', '0.14286', '0', '0', 'Priest - Mind Sear Trigger Rank 1'), +('53022', '0.14286', '0', '0', 'Priest - Mind Sear Trigger Rank 2'), +('18265', '0', '0.1', '0', 'Warlock - Siphon Life'), +('31117', '1.8', '0', '0', 'Warlock - Unstable Affliction Dispell'), +('28176', '0', '0', '0', 'Warlock - Fel Armor'); \ No newline at end of file diff --git a/sql/updates/1135_(mangos_7207)_01_world_creature.sql b/sql/updates/1135_(mangos_7207)_01_world_creature.sql deleted file mode 100644 index 7566ba87076..00000000000 --- a/sql/updates/1135_(mangos_7207)_01_world_creature.sql +++ /dev/null @@ -1,4 +0,0 @@ -/*ALTER TABLE db_version CHANGE COLUMN required_7205_01_mangos_spell_chain required_7207_01_mangos_creature bit;*/ - -ALTER TABLE creature - ADD COLUMN `phaseMask` smallint(5) unsigned NOT NULL default '1' AFTER `spawnMask`; \ No newline at end of file diff --git a/sql/updates/1135_(mangos_7207)_02_world_gameobject.sql b/sql/updates/1135_(mangos_7207)_02_world_gameobject.sql deleted file mode 100644 index aef9f853f54..00000000000 --- a/sql/updates/1135_(mangos_7207)_02_world_gameobject.sql +++ /dev/null @@ -1,4 +0,0 @@ -/*ALTER TABLE db_version CHANGE COLUMN required_7207_01_mangos_creature required_7207_02_mangos_gameobject bit;*/ - -ALTER TABLE gameobject - ADD COLUMN `phaseMask` smallint(5) unsigned NOT NULL default '1' AFTER `spawnMask`; \ No newline at end of file diff --git a/sql/updates/1135_(mangos_7207)_03_characters_corpse.sql b/sql/updates/1135_(mangos_7207)_03_characters_corpse.sql deleted file mode 100644 index b1fa98e2706..00000000000 --- a/sql/updates/1135_(mangos_7207)_03_characters_corpse.sql +++ /dev/null @@ -1,4 +0,0 @@ -/*ALTER TABLE character_db_version CHANGE COLUMN required_7198_01_characters_characters required_7207_03_characters_corpse bit;*/ - -ALTER TABLE corpse - ADD COLUMN `phaseMask` smallint(5) unsigned NOT NULL default '1' AFTER `map`; \ No newline at end of file diff --git a/sql/updates/1135_mangos_7207_01_world_creature.sql b/sql/updates/1135_mangos_7207_01_world_creature.sql new file mode 100644 index 00000000000..7566ba87076 --- /dev/null +++ b/sql/updates/1135_mangos_7207_01_world_creature.sql @@ -0,0 +1,4 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7205_01_mangos_spell_chain required_7207_01_mangos_creature bit;*/ + +ALTER TABLE creature + ADD COLUMN `phaseMask` smallint(5) unsigned NOT NULL default '1' AFTER `spawnMask`; \ No newline at end of file diff --git a/sql/updates/1135_mangos_7207_02_world_gameobject.sql b/sql/updates/1135_mangos_7207_02_world_gameobject.sql new file mode 100644 index 00000000000..aef9f853f54 --- /dev/null +++ b/sql/updates/1135_mangos_7207_02_world_gameobject.sql @@ -0,0 +1,4 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7207_01_mangos_creature required_7207_02_mangos_gameobject bit;*/ + +ALTER TABLE gameobject + ADD COLUMN `phaseMask` smallint(5) unsigned NOT NULL default '1' AFTER `spawnMask`; \ No newline at end of file diff --git a/sql/updates/1135_mangos_7207_03_characters_corpse.sql b/sql/updates/1135_mangos_7207_03_characters_corpse.sql new file mode 100644 index 00000000000..b1fa98e2706 --- /dev/null +++ b/sql/updates/1135_mangos_7207_03_characters_corpse.sql @@ -0,0 +1,4 @@ +/*ALTER TABLE character_db_version CHANGE COLUMN required_7198_01_characters_characters required_7207_03_characters_corpse bit;*/ + +ALTER TABLE corpse + ADD COLUMN `phaseMask` smallint(5) unsigned NOT NULL default '1' AFTER `map`; \ No newline at end of file diff --git a/sql/updates/1140_(mangos_7209)_01_world_spell_bonus_data.sql b/sql/updates/1140_(mangos_7209)_01_world_spell_bonus_data.sql deleted file mode 100644 index d4863c51494..00000000000 --- a/sql/updates/1140_(mangos_7209)_01_world_spell_bonus_data.sql +++ /dev/null @@ -1,5 +0,0 @@ -/*ALTER TABLE db_version CHANGE COLUMN required_7207_02_mangos_gameobject required_7209_01_mangos_spell_bonus_data bit;*/ - -DELETE FROM `spell_bonus_data` WHERE `entry` IN (53595); -INSERT INTO `spell_bonus_data` VALUES -('53595', '0', '0', '0','Paladin - Hammer of the Righteous'); \ No newline at end of file diff --git a/sql/updates/1140_mangos_7209_01_world_spell_bonus_data.sql b/sql/updates/1140_mangos_7209_01_world_spell_bonus_data.sql new file mode 100644 index 00000000000..d4863c51494 --- /dev/null +++ b/sql/updates/1140_mangos_7209_01_world_spell_bonus_data.sql @@ -0,0 +1,5 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7207_02_mangos_gameobject required_7209_01_mangos_spell_bonus_data bit;*/ + +DELETE FROM `spell_bonus_data` WHERE `entry` IN (53595); +INSERT INTO `spell_bonus_data` VALUES +('53595', '0', '0', '0','Paladin - Hammer of the Righteous'); \ No newline at end of file diff --git a/sql/updates/1185_(mangos_7214)_01_world_command.sql b/sql/updates/1185_(mangos_7214)_01_world_command.sql deleted file mode 100644 index 841d538fa43..00000000000 --- a/sql/updates/1185_(mangos_7214)_01_world_command.sql +++ /dev/null @@ -1,8 +0,0 @@ -/*ALTER TABLE db_version CHANGE COLUMN required_7209_01_mangos_spell_bonus_data required_7214_01_mangos_command bit;*/ - -DELETE FROM `command` WHERE `name` IN ('gps','modify phase','npc phase','gobject phase'); -INSERT INTO `command` VALUES -('gps',1,'Syntax: .gps [$name|$shift-link]\r\n\r\nDisplay the position information for a selected character or creature (also if player name $name provided then for named player, or if creature/gameobject shift-link provided then pointed creature/gameobject if it loaded). Position information includes X, Y, Z, and orientation, map Id and zone Id'), -('modify phase',3,'Syntax: .modify phase #phasemask\r\n\r\nSelected character phasemask changed to #phasemask with related world vision update. Change active until in game phase changed, or GM-mode enable/disable, or re-login. Character pts pasemask update to same value.'), -('npc phase',3,'Syntax: .npc phase #phasemask\r\n\r\nSelected unit or pet phasemask changed to #phasemask with related world vision update for players. In creature case state saved to DB and persistent. In pet case change active until in game phase changed for owner, owner re-login, or GM-mode enable/disable..'), -('gobject phase',3,'Syntax: .gobject phase #guid #phasemask\r\n\r\nGameobject with DB guid #guid phasemask changed to #phasemask with related world vision update for players. Gameobject state saved to DB and persistent.'); \ No newline at end of file diff --git a/sql/updates/1185_(mangos_7214)_02_world_trinity_string.sql b/sql/updates/1185_(mangos_7214)_02_world_trinity_string.sql deleted file mode 100644 index 90c39d42baa..00000000000 --- a/sql/updates/1185_(mangos_7214)_02_world_trinity_string.sql +++ /dev/null @@ -1,5 +0,0 @@ -/*ALTER TABLE db_version CHANGE COLUMN required_7214_01_mangos_command required_7214_02_mangos_mangos_string bit;*/ - -DELETE FROM `mangos_string` WHERE entry = 101; -INSERT INTO `mangos_string` VALUES -(101,'Map: %u (%s) Zone: %u (%s) Area: %u (%s) Phase: %u\nX: %f Y: %f Z: %f Orientation: %f\ngrid[%u,%u]cell[%u,%u] InstanceID: %u\n ZoneX: %f ZoneY: %f\nGroundZ: %f FloorZ: %f Have height data (Map: %u VMap: %u)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); \ No newline at end of file diff --git a/sql/updates/1185_(mangos_7214)_03_mangos_spell_proc_event.sql b/sql/updates/1185_(mangos_7214)_03_mangos_spell_proc_event.sql deleted file mode 100644 index e93dcdc04a1..00000000000 --- a/sql/updates/1185_(mangos_7214)_03_mangos_spell_proc_event.sql +++ /dev/null @@ -1,865 +0,0 @@ -DROP TABLE IF EXISTS `spell_proc_event`; -CREATE TABLE IF NOT EXISTS `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; - -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) 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), -(12317, 0, 0, 0, 0, 0, 0, 2, 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), -(13045, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), -(13046, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), -(13047, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), -(13048, 0, 0, 0, 0, 0, 0, 2, 0, 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), -(15268, 32, 6, 101187584, 2, 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), -(15323, 32, 6, 101187584, 2, 0, 0, 0, 0, 0, 0), -(15324, 32, 6, 101187584, 2, 0, 0, 0, 0, 0, 0), -(15325, 32, 6, 101187584, 2, 0, 0, 0, 0, 0, 0), -(15326, 32, 6, 101187584, 2, 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), -(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, 0, 0, 2, 0, 0, 0), -(16196, 0, 11, 192, 0, 0, 0, 2, 0, 0, 0), -(16198, 0, 11, 192, 0, 0, 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), -(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, 0, 0, 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), -(17793, 0, 5, 1, 0, 0, 0, 2, 0, 0, 0), -(17794, 32, 0, 0, 0, 0, 0, 1, 0, 0, 0), -(17796, 0, 5, 1, 0, 0, 0, 2, 0, 0, 0), -(17797, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0), -(17798, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0), -(17799, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0), -(17800, 32, 0, 0, 0, 0, 0, 0, 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, 128, 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, 128, 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), -(19228, 0, 0, 64, 0, 0, 0, 0, 0, 0, 0), -(19232, 0, 9, 64, 0, 0, 0, 0, 0, 0, 0), -(19233, 0, 9, 64, 0, 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, 20, 0, 0), -(20182, 0, 0, 0, 0, 0, 0, 64, 0, 0, 0), -(20210, 0, 10, 3221225472, 65536, 0, 0, 2, 0, 0, 0), -(20212, 0, 10, 3221225472, 65536, 0, 0, 2, 0, 0, 0), -(20213, 0, 10, 3221225472, 65536, 0, 0, 2, 0, 0, 0), -(20214, 0, 10, 3221225472, 65536, 0, 0, 2, 0, 0, 0), -(20215, 0, 10, 3221225472, 65536, 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, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0), -(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, 0, 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, 0), -(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, 192, 0, 0, 0, 0, 0, 0), -(30295, 0, 5, 897, 192, 0, 0, 0, 0, 0, 0), -(30296, 0, 5, 897, 192, 0, 0, 0, 0, 0, 0), -(30299, 36, 0, 0, 0, 0, 0, 0, 0, 0, 0), -(30301, 36, 0, 0, 0, 0, 0, 0, 0, 0, 0), -(30302, 36, 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), -(30680, 0, 11, 3, 0, 0, 0, 0, 0, 0, 0), -(30681, 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, 536870926, 0, 0, 0, 0, 0, 0, 0), -(31126, 0, 8, 536870926, 0, 0, 0, 0, 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), -(31785, 0, 0, 0, 0, 0, 34816, 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, 1026, 17, 0, 0, 0, 0, 0, 0), -(32387, 0, 5, 1026, 17, 0, 0, 0, 0, 0, 0), -(32392, 0, 5, 1026, 17, 0, 0, 0, 0, 0, 0), -(32393, 0, 5, 1026, 17, 0, 0, 0, 0, 0, 0), -(32394, 0, 5, 1026, 17, 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), -(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), -(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), -(33776, 0, 0, 0, 0, 0, 34816, 0, 0, 0, 0), -(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), -(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, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), -(34355, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3), -(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), -(35103, 0, 9, 12289, 0, 0, 0, 0, 0, 0, 0), -(35121, 0, 0, 0, 0, 0, 0, 2, 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), -(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, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), -(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), -(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), -(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), -(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), -(46913, 0, 4, 0, 1024, 0, 0, 2, 0, 0, 0), -(46914, 0, 4, 0, 1024, 0, 0, 2, 0, 0, 0), -(46915, 0, 4, 0, 1024, 0, 0, 2, 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), -(47232, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), -(47234, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), -(47235, 0, 0, 0, 0, 0, 0, 2, 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, 8388608, 0, 0, 0, 0, 0, 0), -(47536, 0, 6, 6144, 8388608, 0, 0, 0, 0, 0, 0), -(47537, 0, 6, 6144, 8388608, 0, 0, 0, 0, 0, 0), -(47538, 0, 6, 6144, 8388608, 0, 0, 0, 0, 0, 0), -(47539, 0, 6, 6144, 8388608, 0, 0, 0, 0, 0, 0), -(47549, 0, 6, 0, 131072, 0, 0, 0, 0, 0, 0), -(47551, 0, 6, 0, 131072, 0, 0, 0, 0, 0, 0), -(47552, 0, 6, 0, 131072, 0, 0, 0, 0, 0, 0), -(47555, 0, 6, 6144, 0, 0, 0, 0, 0, 0, 0), -(47556, 0, 6, 6144, 0, 0, 0, 0, 0, 0, 0), -(47557, 0, 6, 6144, 0, 0, 0, 0, 0, 0, 0), -(47572, 0, 6, 65536, 0, 0, 0, 0, 0, 0, 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), -(49531, 0, 15, 20971520, 0, 0, 0, 0, 0, 0, 0), -(49532, 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, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), -(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), -(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), -(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), -(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), -(53293, 0, 9, 2048, 2147483647, 0, 0, 2, 0, 0, 0), -(53294, 0, 9, 2048, 2147483647, 0, 0, 2, 0, 0, 0), -(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), -(53383, 0, 10, 8388608, 131072, 0, 0, 2, 0, 0, 0), -(53384, 0, 10, 8388608, 131072, 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, 0, 0, 0, 2, 0, 0, 0), -(53576, 0, 10, 2097152, 0, 0, 0, 2, 0, 0, 0), -(53601, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6), -(53671, 0, 10, 8388608, 0, 0, 0, 0, 0, 0, 0), -(53673, 0, 10, 8388608, 0, 0, 0, 0, 0, 0, 0), -(54149, 0, 10, 2097152, 0, 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), -(54738, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), -(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), -(54841, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), -(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), -(55440, 0, 11, 64, 0, 0, 0, 0, 0, 0, 0), -(55620, 0, 15, 1, 134217728, 0, 0, 0, 0, 0, 0), -(55623, 0, 15, 1, 134217728, 0, 0, 0, 0, 0, 0), -(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), -(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), -(56218, 0, 5, 2, 0, 0, 0, 0, 0, 0, 0), -(56333, 0, 9, 4, 0, 512, 0, 0, 0, 0, 0), -(56336, 0, 9, 4, 0, 512, 0, 0, 0, 0, 0), -(56337, 0, 9, 4, 0, 512, 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), -(56364, 0, 3, 0, 16777216, 0, 0, 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), -(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), -(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), -(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), -(58435, 0, 5, 2, 256, 0, 0, 0, 0, 0, 0), -(58436, 0, 5, 2, 256, 0, 0, 0, 0, 0, 0), -(58437, 0, 5, 2, 256, 0, 0, 0, 0, 0, 0), -(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, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), -(59057, 0, 15, 2, 0, 0, 0, 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), -(59725, 0, 0, 0, 0, 0, 0, 2048, 0, 0, 0), -(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), -(60200, 0, 15, 4096, 0, 0, 0, 65536, 0, 0, 0), -(60493, 0, 0, 0, 0, 0, 0, 0, 0, 0, 45), -(60503, 0, 4, 4, 0, 0, 0, 0, 0, 0, 0), -(60537, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), -(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, 0, 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), -(61846, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0), -(61847, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0); diff --git a/sql/updates/1185_mangos_7214_01_world_command.sql b/sql/updates/1185_mangos_7214_01_world_command.sql new file mode 100644 index 00000000000..841d538fa43 --- /dev/null +++ b/sql/updates/1185_mangos_7214_01_world_command.sql @@ -0,0 +1,8 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7209_01_mangos_spell_bonus_data required_7214_01_mangos_command bit;*/ + +DELETE FROM `command` WHERE `name` IN ('gps','modify phase','npc phase','gobject phase'); +INSERT INTO `command` VALUES +('gps',1,'Syntax: .gps [$name|$shift-link]\r\n\r\nDisplay the position information for a selected character or creature (also if player name $name provided then for named player, or if creature/gameobject shift-link provided then pointed creature/gameobject if it loaded). Position information includes X, Y, Z, and orientation, map Id and zone Id'), +('modify phase',3,'Syntax: .modify phase #phasemask\r\n\r\nSelected character phasemask changed to #phasemask with related world vision update. Change active until in game phase changed, or GM-mode enable/disable, or re-login. Character pts pasemask update to same value.'), +('npc phase',3,'Syntax: .npc phase #phasemask\r\n\r\nSelected unit or pet phasemask changed to #phasemask with related world vision update for players. In creature case state saved to DB and persistent. In pet case change active until in game phase changed for owner, owner re-login, or GM-mode enable/disable..'), +('gobject phase',3,'Syntax: .gobject phase #guid #phasemask\r\n\r\nGameobject with DB guid #guid phasemask changed to #phasemask with related world vision update for players. Gameobject state saved to DB and persistent.'); \ No newline at end of file diff --git a/sql/updates/1185_mangos_7214_02_world_trinity_string.sql b/sql/updates/1185_mangos_7214_02_world_trinity_string.sql new file mode 100644 index 00000000000..90c39d42baa --- /dev/null +++ b/sql/updates/1185_mangos_7214_02_world_trinity_string.sql @@ -0,0 +1,5 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7214_01_mangos_command required_7214_02_mangos_mangos_string bit;*/ + +DELETE FROM `mangos_string` WHERE entry = 101; +INSERT INTO `mangos_string` VALUES +(101,'Map: %u (%s) Zone: %u (%s) Area: %u (%s) Phase: %u\nX: %f Y: %f Z: %f Orientation: %f\ngrid[%u,%u]cell[%u,%u] InstanceID: %u\n ZoneX: %f ZoneY: %f\nGroundZ: %f FloorZ: %f Have height data (Map: %u VMap: %u)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); \ No newline at end of file diff --git a/sql/updates/1185_mangos_7214_03_world_spell_proc_event.sql b/sql/updates/1185_mangos_7214_03_world_spell_proc_event.sql new file mode 100644 index 00000000000..e93dcdc04a1 --- /dev/null +++ b/sql/updates/1185_mangos_7214_03_world_spell_proc_event.sql @@ -0,0 +1,865 @@ +DROP TABLE IF EXISTS `spell_proc_event`; +CREATE TABLE IF NOT EXISTS `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; + +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) 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), +(12317, 0, 0, 0, 0, 0, 0, 2, 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), +(13045, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), +(13046, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), +(13047, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), +(13048, 0, 0, 0, 0, 0, 0, 2, 0, 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), +(15268, 32, 6, 101187584, 2, 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), +(15323, 32, 6, 101187584, 2, 0, 0, 0, 0, 0, 0), +(15324, 32, 6, 101187584, 2, 0, 0, 0, 0, 0, 0), +(15325, 32, 6, 101187584, 2, 0, 0, 0, 0, 0, 0), +(15326, 32, 6, 101187584, 2, 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), +(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, 0, 0, 2, 0, 0, 0), +(16196, 0, 11, 192, 0, 0, 0, 2, 0, 0, 0), +(16198, 0, 11, 192, 0, 0, 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), +(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, 0, 0, 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), +(17793, 0, 5, 1, 0, 0, 0, 2, 0, 0, 0), +(17794, 32, 0, 0, 0, 0, 0, 1, 0, 0, 0), +(17796, 0, 5, 1, 0, 0, 0, 2, 0, 0, 0), +(17797, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(17798, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(17799, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(17800, 32, 0, 0, 0, 0, 0, 0, 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, 128, 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, 128, 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), +(19228, 0, 0, 64, 0, 0, 0, 0, 0, 0, 0), +(19232, 0, 9, 64, 0, 0, 0, 0, 0, 0, 0), +(19233, 0, 9, 64, 0, 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, 20, 0, 0), +(20182, 0, 0, 0, 0, 0, 0, 64, 0, 0, 0), +(20210, 0, 10, 3221225472, 65536, 0, 0, 2, 0, 0, 0), +(20212, 0, 10, 3221225472, 65536, 0, 0, 2, 0, 0, 0), +(20213, 0, 10, 3221225472, 65536, 0, 0, 2, 0, 0, 0), +(20214, 0, 10, 3221225472, 65536, 0, 0, 2, 0, 0, 0), +(20215, 0, 10, 3221225472, 65536, 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, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0), +(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, 0, 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, 0), +(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, 192, 0, 0, 0, 0, 0, 0), +(30295, 0, 5, 897, 192, 0, 0, 0, 0, 0, 0), +(30296, 0, 5, 897, 192, 0, 0, 0, 0, 0, 0), +(30299, 36, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(30301, 36, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(30302, 36, 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), +(30680, 0, 11, 3, 0, 0, 0, 0, 0, 0, 0), +(30681, 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, 536870926, 0, 0, 0, 0, 0, 0, 0), +(31126, 0, 8, 536870926, 0, 0, 0, 0, 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), +(31785, 0, 0, 0, 0, 0, 34816, 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, 1026, 17, 0, 0, 0, 0, 0, 0), +(32387, 0, 5, 1026, 17, 0, 0, 0, 0, 0, 0), +(32392, 0, 5, 1026, 17, 0, 0, 0, 0, 0, 0), +(32393, 0, 5, 1026, 17, 0, 0, 0, 0, 0, 0), +(32394, 0, 5, 1026, 17, 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), +(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), +(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), +(33776, 0, 0, 0, 0, 0, 34816, 0, 0, 0, 0), +(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), +(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, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), +(34355, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3), +(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), +(35103, 0, 9, 12289, 0, 0, 0, 0, 0, 0, 0), +(35121, 0, 0, 0, 0, 0, 0, 2, 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), +(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, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), +(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), +(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), +(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), +(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), +(46913, 0, 4, 0, 1024, 0, 0, 2, 0, 0, 0), +(46914, 0, 4, 0, 1024, 0, 0, 2, 0, 0, 0), +(46915, 0, 4, 0, 1024, 0, 0, 2, 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), +(47232, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), +(47234, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), +(47235, 0, 0, 0, 0, 0, 0, 2, 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, 8388608, 0, 0, 0, 0, 0, 0), +(47536, 0, 6, 6144, 8388608, 0, 0, 0, 0, 0, 0), +(47537, 0, 6, 6144, 8388608, 0, 0, 0, 0, 0, 0), +(47538, 0, 6, 6144, 8388608, 0, 0, 0, 0, 0, 0), +(47539, 0, 6, 6144, 8388608, 0, 0, 0, 0, 0, 0), +(47549, 0, 6, 0, 131072, 0, 0, 0, 0, 0, 0), +(47551, 0, 6, 0, 131072, 0, 0, 0, 0, 0, 0), +(47552, 0, 6, 0, 131072, 0, 0, 0, 0, 0, 0), +(47555, 0, 6, 6144, 0, 0, 0, 0, 0, 0, 0), +(47556, 0, 6, 6144, 0, 0, 0, 0, 0, 0, 0), +(47557, 0, 6, 6144, 0, 0, 0, 0, 0, 0, 0), +(47572, 0, 6, 65536, 0, 0, 0, 0, 0, 0, 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), +(49531, 0, 15, 20971520, 0, 0, 0, 0, 0, 0, 0), +(49532, 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, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), +(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), +(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), +(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), +(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), +(53293, 0, 9, 2048, 2147483647, 0, 0, 2, 0, 0, 0), +(53294, 0, 9, 2048, 2147483647, 0, 0, 2, 0, 0, 0), +(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), +(53383, 0, 10, 8388608, 131072, 0, 0, 2, 0, 0, 0), +(53384, 0, 10, 8388608, 131072, 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, 0, 0, 0, 2, 0, 0, 0), +(53576, 0, 10, 2097152, 0, 0, 0, 2, 0, 0, 0), +(53601, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6), +(53671, 0, 10, 8388608, 0, 0, 0, 0, 0, 0, 0), +(53673, 0, 10, 8388608, 0, 0, 0, 0, 0, 0, 0), +(54149, 0, 10, 2097152, 0, 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), +(54738, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), +(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), +(54841, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), +(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), +(55440, 0, 11, 64, 0, 0, 0, 0, 0, 0, 0), +(55620, 0, 15, 1, 134217728, 0, 0, 0, 0, 0, 0), +(55623, 0, 15, 1, 134217728, 0, 0, 0, 0, 0, 0), +(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), +(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), +(56218, 0, 5, 2, 0, 0, 0, 0, 0, 0, 0), +(56333, 0, 9, 4, 0, 512, 0, 0, 0, 0, 0), +(56336, 0, 9, 4, 0, 512, 0, 0, 0, 0, 0), +(56337, 0, 9, 4, 0, 512, 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), +(56364, 0, 3, 0, 16777216, 0, 0, 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), +(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), +(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), +(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), +(58435, 0, 5, 2, 256, 0, 0, 0, 0, 0, 0), +(58436, 0, 5, 2, 256, 0, 0, 0, 0, 0, 0), +(58437, 0, 5, 2, 256, 0, 0, 0, 0, 0, 0), +(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, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), +(59057, 0, 15, 2, 0, 0, 0, 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), +(59725, 0, 0, 0, 0, 0, 0, 2048, 0, 0, 0), +(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), +(60200, 0, 15, 4096, 0, 0, 0, 65536, 0, 0, 0), +(60493, 0, 0, 0, 0, 0, 0, 0, 0, 0, 45), +(60503, 0, 4, 4, 0, 0, 0, 0, 0, 0, 0), +(60537, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), +(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, 0, 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), +(61846, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0), +(61847, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0); diff --git a/sql/updates/1237_mangos_7230_01_world_spell_bonus_data.sql b/sql/updates/1237_mangos_7230_01_world_spell_bonus_data.sql new file mode 100644 index 00000000000..4b12bf6c546 --- /dev/null +++ b/sql/updates/1237_mangos_7230_01_world_spell_bonus_data.sql @@ -0,0 +1,9 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7230_01_mangos_spell_chain required_7230_02_mangos_spell_bonus_data bit;*/ + +DELETE FROM `spell_bonus_data` WHERE `entry` IN (18220,18937,18938,27265,59092); +INSERT INTO `spell_bonus_data` VALUES +('18220', '0.96', '0', '0', 'Warlock - Dark Pact Rank 1'), +('18937', '0.96', '0', '0', 'Warlock - Dark Pact Rank 2'), +('18938', '0.96', '0', '0', 'Warlock - Dark Pact Rank 3'), +('27265', '0.96', '0', '0', 'Warlock - Dark Pact Rank 4'), +('59092', '0.96', '0', '0', 'Warlock - Dark Pact Rank 5'); \ No newline at end of file diff --git a/sql/updates/1248_mangos_7235_01_world_command.sql b/sql/updates/1248_mangos_7235_01_world_command.sql new file mode 100644 index 00000000000..05c24480fc7 --- /dev/null +++ b/sql/updates/1248_mangos_7235_01_world_command.sql @@ -0,0 +1,5 @@ +ALTER TABLE db_version CHANGE COLUMN required_7230_02_mangos_spell_bonus_data required_7235_01_mangos_command bit; + +DELETE FROM `command` WHERE `name` = 'reset achievements'; +INSERT INTO `command` VALUES +('reset achievements',3,'Syntax: .reset achievements [$playername]\r\n\r\nReset achievements data for selected or named (online or offline) character. Achievements for persistance progress data like completed quests/etc re-filled at reset. Achievements for events like kills/casts/etc will lost.'); diff --git a/sql/updates/2.4.3_updates/1018_wrold.sql b/sql/updates/2.4.3_updates/1018_wrold.sql new file mode 100644 index 00000000000..ca298faa8f3 --- /dev/null +++ b/sql/updates/2.4.3_updates/1018_wrold.sql @@ -0,0 +1,6 @@ +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (31224,41292,44007,44867); +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +(31224, -1543, 2, 'Cloak of Shadows - Flare'), +(41292, 42017, 2, 'Aura of Suffering'), +(44007, -43657, 2, 'Storm Eye Safe Zone Immune'), +(44867, -46019, 2, 'Spectral Exhaustion - Teleport: Spectral Realm'); \ No newline at end of file diff --git a/sql/updates/7230_02_mangos_spell_bonus_data.sql b/sql/updates/7230_02_mangos_spell_bonus_data.sql deleted file mode 100644 index 85333ee2a88..00000000000 --- a/sql/updates/7230_02_mangos_spell_bonus_data.sql +++ /dev/null @@ -1,9 +0,0 @@ -ALTER TABLE db_version CHANGE COLUMN required_7230_01_mangos_spell_chain required_7230_02_mangos_spell_bonus_data bit; - -DELETE FROM `spell_bonus_data` WHERE `entry` IN (18220,18937,18938,27265,59092); -INSERT INTO `spell_bonus_data` VALUES -('18220', '0.96', '0', '0', 'Warlock - Dark Pact Rank 1'), -('18937', '0.96', '0', '0', 'Warlock - Dark Pact Rank 2'), -('18938', '0.96', '0', '0', 'Warlock - Dark Pact Rank 3'), -('27265', '0.96', '0', '0', 'Warlock - Dark Pact Rank 4'), -('59092', '0.96', '0', '0', 'Warlock - Dark Pact Rank 5'); diff --git a/sql/updates/7235_01_mangos_command.sql b/sql/updates/7235_01_mangos_command.sql deleted file mode 100644 index 05c24480fc7..00000000000 --- a/sql/updates/7235_01_mangos_command.sql +++ /dev/null @@ -1,5 +0,0 @@ -ALTER TABLE db_version CHANGE COLUMN required_7230_02_mangos_spell_bonus_data required_7235_01_mangos_command bit; - -DELETE FROM `command` WHERE `name` = 'reset achievements'; -INSERT INTO `command` VALUES -('reset achievements',3,'Syntax: .reset achievements [$playername]\r\n\r\nReset achievements data for selected or named (online or offline) character. Achievements for persistance progress data like completed quests/etc re-filled at reset. Achievements for events like kills/casts/etc will lost.'); diff --git a/sql/updates/875_(mangos_7047)_01_characters_character_spell.sql b/sql/updates/875_(mangos_7047)_01_characters_character_spell.sql deleted file mode 100644 index acced8e0b6e..00000000000 --- a/sql/updates/875_(mangos_7047)_01_characters_character_spell.sql +++ /dev/null @@ -1,22 +0,0 @@ -/*ALTER TABLE character_db_version CHANGE COLUMN required_6976_02_characters_character_db_version required_7047_01_characters_character_spell bit;*/ - -/* ERROR 1136 (21S01) at line 4: Column count doesn't match value count at row 1 -DELETE FROM `character_spell` WHERE `spell` IN ('28880', 59542, 59543, 59544, 59545, 59547, 59548); -INSERT INTO character_spell SELECT characters.guid as guid, 28880, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 1; -INSERT INTO character_spell SELECT characters.guid as guid, 59542, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 2; -INSERT INTO character_spell SELECT characters.guid as guid, 59543, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 3; -INSERT INTO character_spell SELECT characters.guid as guid, 59544, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 5; -INSERT INTO character_spell SELECT characters.guid as guid, 59545, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 6; -INSERT INTO character_spell SELECT characters.guid as guid, 59547, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 7; -INSERT INTO character_spell SELECT characters.guid as guid, 59548, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 8; -*/ - -/* same query , without character_spell.slot*/ -DELETE FROM `character_spell` WHERE `spell` IN ('28880', 59542, 59543, 59544, 59545, 59547, 59548); -INSERT INTO character_spell SELECT characters.guid as guid, 28880, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 1; -INSERT INTO character_spell SELECT characters.guid as guid, 59542, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 2; -INSERT INTO character_spell SELECT characters.guid as guid, 59543, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 3; -INSERT INTO character_spell SELECT characters.guid as guid, 59544, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 5; -INSERT INTO character_spell SELECT characters.guid as guid, 59545, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 6; -INSERT INTO character_spell SELECT characters.guid as guid, 59547, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 7; -INSERT INTO character_spell SELECT characters.guid as guid, 59548, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 8; diff --git a/sql/updates/875_(mangos_7059)_01_characters_pet_spell.sql b/sql/updates/875_(mangos_7059)_01_characters_pet_spell.sql deleted file mode 100644 index 11f1063ebc3..00000000000 --- a/sql/updates/875_(mangos_7059)_01_characters_pet_spell.sql +++ /dev/null @@ -1,4 +0,0 @@ -/*ALTER TABLE character_db_version CHANGE COLUMN required_7059_01_characters_character_spell required_7059_02_characters_pet_spell bit;*/ - -ALTER TABLE pet_spell - DROP slot; \ No newline at end of file diff --git a/sql/updates/875_mangos_7047_01_characters_character_spell.sql b/sql/updates/875_mangos_7047_01_characters_character_spell.sql new file mode 100644 index 00000000000..71c7ee79e3b --- /dev/null +++ b/sql/updates/875_mangos_7047_01_characters_character_spell.sql @@ -0,0 +1,10 @@ +/*ALTER TABLE character_db_version CHANGE COLUMN required_6976_02_characters_character_db_version required_7047_01_characters_character_spell bit;*/ + +DELETE FROM `character_spell` WHERE `spell` IN ('28880', 59542, 59543, 59544, 59545, 59547, 59548); +INSERT INTO character_spell SELECT characters.guid as guid, 28880, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 1; +INSERT INTO character_spell SELECT characters.guid as guid, 59542, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 2; +INSERT INTO character_spell SELECT characters.guid as guid, 59543, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 3; +INSERT INTO character_spell SELECT characters.guid as guid, 59544, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 5; +INSERT INTO character_spell SELECT characters.guid as guid, 59545, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 6; +INSERT INTO character_spell SELECT characters.guid as guid, 59547, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 7; +INSERT INTO character_spell SELECT characters.guid as guid, 59548, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 8; \ No newline at end of file diff --git a/sql/updates/875_mangos_7059_01_characters_pet_spell.sql b/sql/updates/875_mangos_7059_01_characters_pet_spell.sql new file mode 100644 index 00000000000..11f1063ebc3 --- /dev/null +++ b/sql/updates/875_mangos_7059_01_characters_pet_spell.sql @@ -0,0 +1,4 @@ +/*ALTER TABLE character_db_version CHANGE COLUMN required_7059_01_characters_character_spell required_7059_02_characters_pet_spell bit;*/ + +ALTER TABLE pet_spell + DROP slot; \ No newline at end of file diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt index f4962d15292..f409aaeefab 100644 --- a/sql/updates/CMakeLists.txt +++ b/sql/updates/CMakeLists.txt @@ -1,23 +1,25 @@ INSTALL(FILES 805_world_scripts -875_(mangos_7047)_01_characters_character_spell.sql -875_(mangos_7059)_01_characters_pet_spell.sql -1026_(mangos_7113)_01_characters_character_achievement_progress.sql -1028_(mangos_7141)_01_world_instance_template.sql -1028_(mangos_7147)_01_world_creature_template.sql -1028_(mangos_7150)_01_world_playercreateinfo_spell.sql -1084_(mangos_7168)_01_world_command.sql -1094_(mangos_7193)_01_world_trinity_string.sql -1108_(mangos_7196)_02_world_spell_bonus_data.sql -1108_(mangos_7198)_01_characters_characters.sql -1108_(mangos_7199)_01_world_spell_bonus_data.sql -1135_(mangos_7207)_01_world_creature.sql -1135_(mangos_7207)_02_world_gameobject.sql -1135_(mangos_7207)_03_characters_corpse.sql -1140_(mangos_7209)_01_world_spell_bonus_data.sql -1185_(mangos_7214)_01_world_command.sql -1185_(mangos_7214)_02_world_trinity_string.sql -1185_(mangos_7214)_03_mangos_spell_proc_event.sql +875_mangos_7047_01_characters_character_spell.sql +875_mangos_7059_01_characters_pet_spell.sql +1026_mangos_7113_01_characters_character_achievement_progress.sql +1028_mangos_7141_01_world_instance_template.sql +1028_mangos_7147_01_world_creature_template.sql +1028_mangos_7150_01_world_playercreateinfo_spell.sql +1084_mangos_7168_01_world_command.sql +1094_mangos_7193_01_world_trinity_string.sql +1108_mangos_7196_02_world_spell_bonus_data.sql +1108_mangos_7198_01_characters_characters.sql +1108_mangos_7199_01_world_spell_bonus_data.sql +1135_mangos_7207_01_world_creature.sql +1135_mangos_7207_02_world_gameobject.sql +1135_mangos_7207_03_characters_corpse.sql +1140_mangos_7209_01_world_spell_bonus_data.sql +1185_mangos_7214_01_world_command.sql +1185_mangos_7214_02_world_trinity_string.sql +1185_mangos_7214_03_world_spell_proc_event.sql 1206_world_scripts.sql 1207_world_scripts.sql -DESTINATION share/trinity/sql/updates) +1237_mangos_7230_01_world_spell_bonus_data +1248_mangos_7235_01_world_command +DESTINATION share/trinity/sql/updates) \ No newline at end of file -- cgit v1.2.3