diff options
| author | Nay <dnpd.dd@gmail.com> | 2013-07-17 00:55:36 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2013-07-17 00:56:05 +0100 |
| commit | b95b19b3cb21f0b51481c71b77ac58bf7268b2c4 (patch) | |
| tree | f21610c31b7694af5e0928151b663fa146f08813 /sql/updates | |
| parent | b27777fa3e875ad6998fc853ece143dedccd746f (diff) | |
TDB 424.05
Diffstat (limited to 'sql/updates')
28 files changed, 0 insertions, 1296 deletions
diff --git a/sql/updates/characters/2013_06_19_00_characters_achievements_progress.sql b/sql/updates/characters/2013_06_19_00_characters_achievements_progress.sql deleted file mode 100644 index bf281aa04c7..00000000000 --- a/sql/updates/characters/2013_06_19_00_characters_achievements_progress.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `character_achievement_progress` CHANGE `counter` `counter` bigint(20) unsigned NOT NULL DEFAULT '0'; -ALTER TABLE `guild_achievement_progress` CHANGE `counter` `counter` bigint(20) unsigned NOT NULL DEFAULT '0'; diff --git a/sql/updates/world/2013_01_26_01_world_misc_434.sql b/sql/updates/world/2013_01_26_01_world_misc_434.sql deleted file mode 100644 index 2abe6090c3f..00000000000 --- a/sql/updates/world/2013_01_26_01_world_misc_434.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id` IN (82676, 82691); -INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES -(82676, 'spell_mage_ring_of_frost'), -(82691, 'spell_mage_ring_of_frost_freeze'); - --- Set flags UNIT_FLAG_DISABLE_MOVE| UNIT_FLAG_STUNNED|UNIT_FLAG_NOT_SELECTABLE on Ring of Frost -UPDATE `creature_template` SET `unit_flags` = 0x4|0x40000|0x2000000 WHERE `entry` = 44199; diff --git a/sql/updates/world/2013_01_26_01_world_spell_script_names_434.sql b/sql/updates/world/2013_01_26_01_world_spell_script_names_434.sql deleted file mode 100644 index 89b70f0980a..00000000000 --- a/sql/updates/world/2013_01_26_01_world_spell_script_names_434.sql +++ /dev/null @@ -1,5 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id` IN (51562,51563,51564); -INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES -(51562, 'spell_sha_tidal_waves'), -(51563, 'spell_sha_tidal_waves'), -(51564, 'spell_sha_tidal_waves'); diff --git a/sql/updates/world/2013_02_27_00_world_creature_summon_groups_434.sql b/sql/updates/world/2013_02_27_00_world_creature_summon_groups_434.sql deleted file mode 100644 index 4cdd26a83e8..00000000000 --- a/sql/updates/world/2013_02_27_00_world_creature_summon_groups_434.sql +++ /dev/null @@ -1,10 +0,0 @@ -DELETE FROM `creature_summon_groups` WHERE `summonerId`=52151 AND `groupId`=0; -INSERT INTO `creature_summon_groups` (`summonerId`, `summonerType`, `groupId`, `entry`, `position_x`, `position_y`, `position_z`, `orientation`, `summonType`, `summonTime`) VALUES -(52151, 0, 0, 52156, -12330.3, -1878.41, 127.32, 3.89208, 8, 0), -(52151, 0, 0, 52156, -12351.94, -1861.51, 127.4807, 4.677482, 8, 0), -(52151, 0, 0, 52156, -12326.71, -1904.328, 127.4111, 2.75762, 8, 0), -(52151, 0, 0, 52156, -12347.41, -1917.535, 127.3196, 1.553343, 8, 0), -(52151, 0, 0, 52156, -12378.57, -1861.222, 127.5416, 5.340707, 8, 0), -(52151, 0, 0, 52156, -12397.79, -1887.731, 127.5453, 0.03490658, 8, 0), -(52151, 0, 0, 52156, -12372.36, -1918.844, 127.343, 1.151917, 8, 0), -(52151, 0, 0, 52156, -12391.23, -1905.273, 127.3196, 0.6108652, 8, 0); diff --git a/sql/updates/world/2013_03_15_01_world_keychain_db2_434.sql b/sql/updates/world/2013_03_15_01_world_keychain_db2_434.sql deleted file mode 100644 index fb8364d47d0..00000000000 --- a/sql/updates/world/2013_03_15_01_world_keychain_db2_434.sql +++ /dev/null @@ -1,43 +0,0 @@ -DROP TABLE IF EXISTS `keychain_db2`; -CREATE TABLE `keychain_db2` ( - `keyId` INT UNSIGNED NOT NULL DEFAULT '0', - `k1` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k2` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k3` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k4` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k5` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k6` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k7` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k8` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k9` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k10` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k11` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k12` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k13` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k14` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k15` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k16` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k17` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k18` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k19` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k20` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k21` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k22` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k23` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k24` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k25` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k26` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k27` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k28` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k29` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k30` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k31` TINYINT UNSIGNED NOT NULL DEFAULT '0', - `k32` TINYINT UNSIGNED NOT NULL DEFAULT '0', - PRIMARY KEY (`keyId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -INSERT INTO `keychain_db2` VALUES -(33, 53, 6, 164, 135, 117, 210, 209, 135, 247, 162, 85, 200, 76, 220, 107, 56, 80, 214, 44, 121, 29, 66, 81, 25, 41, 38, 208, 8, 235, 154, 58, 139), -(35, 16, 209, 60, 47, 154, 100, 204, 97, 125, 161, 79, 126, 191, 163, 7, 45, 64, 188, 199, 88, 141, 46, 153, 90, 143, 40, 6, 80, 29, 133, 217, 135), -(36, 3, 169, 217, 5, 156, 76, 33, 82, 75, 181, 233, 203, 230, 52, 67, 197, 57, 99, 27, 108, 100, 197, 93, 156, 174, 2, 248, 216, 244, 115, 164, 210), -(37, 119, 7, 189, 206, 199, 253, 234, 73, 232, 17, 162, 79, 0, 35, 222, 224, 7, 98, 132, 147, 229, 36, 19, 253, 79, 59, 198, 59, 48, 121, 97, 215); diff --git a/sql/updates/world/2013_03_23_00_world_playercreateinfo_spell_434.sql b/sql/updates/world/2013_03_23_00_world_playercreateinfo_spell_434.sql deleted file mode 100644 index 667022eaba9..00000000000 --- a/sql/updates/world/2013_03_23_00_world_playercreateinfo_spell_434.sql +++ /dev/null @@ -1,777 +0,0 @@ -TRUNCATE TABLE `playercreateinfo_spell`; -TRUNCATE TABLE `playercreateinfo_spell_custom`; - -ALTER TABLE `playercreateinfo_spell` - CHANGE `race` `racemask` INT(10) UNSIGNED DEFAULT 0 NOT NULL, - CHANGE `class` `classmask` INT(10) UNSIGNED DEFAULT 0 NOT NULL; - -ALTER TABLE `playercreateinfo_spell_custom` - CHANGE `race` `racemask` INT(10) UNSIGNED DEFAULT 0 NOT NULL, - CHANGE `class` `classmask` INT(10) UNSIGNED DEFAULT 0 NOT NULL; - -INSERT INTO `playercreateinfo_spell` (`racemask`, `classmask`, `Spell`, `Note`) VALUES --- Races: All --- Classes: Warrior, Paladin, Hunter, Death Knight -(0x0, 0x27, 202, "Two-Handed Swords"), --- Races: All --- Classes: Warrior, Paladin, Hunter, Rogue, Death Knight, Shaman -(0x0, 0x6F, 196, "One-Handed Axes"), --- Races: All --- Classes: Warrior -(0x0, 0x1, 2457, "Battle Stance"), --- Races: All --- Classes: Warrior -(0x0, 0x1, 88161, "Strike"), --- Races: All --- Classes: Warrior, Hunter, Rogue -(0x0, 0xD, 5011, "Crossbows"), --- Races: All --- Classes: Warrior, Rogue -(0x0, 0x9, 3018, "Shoot"), --- Races: All --- Classes: Warrior, Paladin, Hunter, Death Knight, Shaman -(0x0, 0x67, 197, "Two-Handed Axes"), --- Races: All --- Classes: Warrior, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid -(0x0, 0x5DD, 1180, "Daggers"), --- Races: All --- Classes: All -(0x0, 0x0, 45927, "Summon Friend"), --- Races: All --- Classes: All -(0x0, 0x0, 6478, "Opening"), --- Races: All --- Classes: All -(0x0, 0x0, 6603, "Auto Attack"), --- Races: All --- Classes: All -(0x0, 0x0, 22027, "Remove Insignia"), --- Races: All --- Classes: All -(0x0, 0x0, 22810, "Opening - No Text"), --- Races: All --- Classes: All -(0x0, 0x0, 21651, "Opening"), --- Races: All --- Classes: All -(0x0, 0x0, 21652, "Closing"), --- Races: All --- Classes: All -(0x0, 0x0, 2382, "Generic"), --- Races: All --- Classes: All -(0x0, 0x0, 3365, "Opening"), --- Races: All --- Classes: All -(0x0, 0x0, 3050, "Detect"), --- Races: All --- Classes: All -(0x0, 0x0, 9125, "Generic"), --- Races: All --- Classes: All -(0x0, 0x0, 8386, "Attacking"), --- Races: All --- Classes: All -(0x0, 0x0, 7266, "Duel"), --- Races: All --- Classes: All -(0x0, 0x0, 7267, "Grovel"), --- Races: All --- Classes: All -(0x0, 0x0, 7355, "Stuck"), --- Races: All --- Classes: All -(0x0, 0x0, 6233, "Closing"), --- Races: All --- Classes: All -(0x0, 0x0, 6246, "Closing"), --- Races: All --- Classes: All -(0x0, 0x0, 6247, "Opening"), --- Races: All --- Classes: All -(0x0, 0x0, 6477, "Opening"), --- Races: All --- Classes: All -(0x0, 0x0, 61437, "Opening"), --- Races: All --- Classes: All -(0x0, 0x0, 68398, "Opening"), --- Races: All --- Classes: All -(0x0, 0x0, 96220, "Opening"), --- Races: All --- Classes: All -(0x0, 0x0, 203, "Unarmed"), --- Races: Human --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Mage, Warlock -(0x1, 0x1BF, 20864, "Mace Specialization"), --- Races: Human --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Mage, Warlock -(0x1, 0x1BF, 20599, "Diplomacy"), --- Races: Human --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Mage, Warlock -(0x1, 0x1BF, 20597, "Sword Specialization"), --- Races: Human --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Mage, Warlock -(0x1, 0x1BF, 20598, "The Human Spirit"), --- Races: Human --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Mage, Warlock -(0x1, 0x1BF, 59752, "Every Man for Himself"), --- Races: Human --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Mage, Warlock -(0x1, 0x1BF, 79738, "Languages"), --- Races: All --- Classes: Warrior, Paladin, Death Knight -(0x0, 0x23, 49410, "Forceful Deflection"), --- Races: All --- Classes: Warrior, Paladin, Death Knight, Shaman, Druid -(0x0, 0x463, 199, "Two-Handed Maces"), --- Races: All --- Classes: Warrior, Hunter, Rogue, Shaman, Druid -(0x0, 0x44D, 15590, "Fist Weapons"), --- Races: All --- Classes: Warrior -(0x0, 0x1, 76268, "Armor Skills"), --- Races: All --- Classes: Warrior -(0x0, 0x1, 76290, "Weapon Skills"), --- Races: All --- Classes: Warrior -(0x0, 0x1, 88163, "Attack"), --- Races: All --- Classes: Warrior, Paladin, Hunter, Death Knight, Druid -(0x0, 0x427, 200, "Polearms"), --- Races: Human, Dwarf, Night elf, Gnome, Dranei, Worgen --- Classes: All -(0x20044D, 0x0, 668, "Language Common"), --- Races: All --- Classes: Warrior, Hunter, Priest, Shaman, Mage, Warlock, Druid -(0x0, 0x5D5, 227, "Staves"), --- Races: All --- Classes: Warrior, Paladin, Shaman -(0x0, 0x43, 9116, "Shield"), --- Races: All --- Classes: Warrior, Paladin, Death Knight -(0x0, 0x23, 8737, "Mail"), --- Races: All --- Classes: Warrior, Paladin, Hunter, Rogue, Death Knight, Shaman, Druid -(0x0, 0x46F, 9077, "Leather"), --- Races: All --- Classes: Warrior, Hunter, Rogue -(0x0, 0xD, 264, "Bows"), --- Races: All --- Classes: Warrior, Hunter, Rogue -(0x0, 0xD, 266, "Guns"), --- Races: All --- Classes: Warrior, Paladin, Shaman -(0x0, 0x43, 107, "Block"), --- Races: All --- Classes: All -(0x0, 0x0, 81, "Dodge"), --- Races: All --- Classes: Warrior -(0x0, 0x1, 32215, "Victorious State"), --- Races: All --- Classes: Warrior -(0x0, 0x1, 5301, "Defensive State (DND)"), --- Races: All --- Classes: All -(0x0, 0x0, 204, "Defense"), --- Races: All --- Classes: All -(0x0, 0x0, 522, "SPELLDEFENSE (DND)"), --- Races: All --- Classes: Warrior, Rogue -(0x0, 0x9, 2764, "Throw"), --- Races: All --- Classes: Warrior, Rogue -(0x0, 0x9, 2567, "Thrown"), --- Races: All --- Classes: All -(0x0, 0x0, 9078, "Cloth"), --- Races: All --- Classes: Warrior, Paladin, Rogue, Priest, Death Knight, Shaman, Druid -(0x0, 0x47B, 198, "One-Handed Maces"), --- Races: All --- Classes: Warrior, Paladin, Hunter, Rogue, Death Knight, Mage, Warlock -(0x0, 0x1AF, 201, "One-Handed Swords"), --- Races: Human, Dwarf, Tauren, Blood elf, Dranei --- Classes: Paladin -(0x625, 0x2, 27762, "Relic"), --- Races: Human, Dwarf, Tauren, Blood elf, Dranei --- Classes: Paladin -(0x625, 0x2, 76271, "Armor Skills"), --- Races: Human, Dwarf, Tauren, Blood elf, Dranei --- Classes: Paladin -(0x625, 0x2, 76294, "Weapon Skills"), --- Races: Human, Dwarf, Tauren, Blood elf, Dranei --- Classes: Paladin -(0x625, 0x2, 35395, "Crusader Strike"), --- Races: Human, Dwarf, Tauren, Blood elf, Dranei --- Classes: Paladin -(0x625, 0x2, 60091, "Judgement Anti-Parry/Dodge Passive"), --- Races: Human, Dwarf, Tauren, Blood elf, Dranei --- Classes: Paladin -(0x625, 0x2, 20208, "Paladin pushback resistance"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Hunter -(0x2007BF, 0x4, 3044, "Arcane Shot"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Hunter -(0x2007BF, 0x4, 75, "Auto Shot"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Hunter -(0x2007BF, 0x4, 82928, "Aimed Shot!"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Hunter -(0x2007BF, 0x4, 34082, "Hunter Passive Auras (DND)"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Hunter -(0x2007BF, 0x4, 883, "Call Pet 1"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Hunter -(0x2007BF, 0x4, 982, "Revive Pet"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Hunter -(0x2007BF, 0x4, 13358, "Defensive State (DND)"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Hunter -(0x2007BF, 0x4, 24949, "Defensive State 2 (DND)"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Hunter -(0x2007BF, 0x4, 77442, "Focus"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Hunter -(0x2007BF, 0x4, 76249, "Weapon Skills"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Hunter -(0x2007BF, 0x4, 76250, "Armor Skills"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Hunter -(0x2007BF, 0x4, 87324, "Focused Aim"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Hunter -(0x2007BF, 0x4, 87816, "General Hunter Passives"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Goblin, Blood elf, Worgen --- Classes: Rogue -(0x2003DF, 0x8, 1752, "Sinister Strike"), --- Races: All --- Classes: Rogue, Death Knight -(0x0, 0x28, 674, "Dual Wield"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Goblin, Blood elf, Worgen --- Classes: Rogue -(0x2003DF, 0x8, 76273, "Armor Skills"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Goblin, Blood elf, Worgen --- Classes: Rogue -(0x2003DF, 0x8, 76297, "Weapon Skills"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Goblin, Blood elf, Worgen --- Classes: Rogue -(0x2003DF, 0x8, 16092, "Defensive State (DND)"), --- Races: All --- Classes: Priest, Mage, Warlock -(0x0, 0x190, 5009, "Wands"), --- Races: All --- Classes: Priest, Mage, Warlock -(0x0, 0x190, 5019, "Shoot"), --- Races: Human, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Priest -(0x2007FD, 0x10, 585, "Smite"), --- Races: Human, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Priest -(0x2007FD, 0x10, 84733, "Holy Focus"), --- Races: Human, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Priest -(0x2007FD, 0x10, 88685, "Holy Word: Sanctuary"), --- Races: Human, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Priest -(0x2007FD, 0x10, 88684, "Holy Word: Serenity"), --- Races: Human, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Priest -(0x2007FD, 0x10, 101062, "Flash Heal"), --- Races: Human, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Priest -(0x2007FD, 0x10, 76301, "Weapon Skills"), --- Races: Human, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Priest -(0x2007FD, 0x10, 76279, "Armor Skills"), --- Races: Human, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Priest -(0x2007FD, 0x10, 84734, "Dark Thoughts"), --- Races: Human, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Priest -(0x2007FD, 0x10, 77486, "Shadow Orb Power"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Mage -(0x2007DF, 0x80, 71761, "Deep Freeze Immunity State"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Mage -(0x2007DF, 0x80, 79684, "Offensive State (DND)"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Mage -(0x2007DF, 0x80, 133, "Fireball"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Mage -(0x2007DF, 0x80, 92315, "Pyroblast!"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Mage, Warlock -(0x2007DF, 0x180, 85801, "DPS Caster Crit Damage Bonus"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Mage -(0x2007DF, 0x80, 76298, "Weapon Skills"), --- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Goblin, Blood elf, Dranei, Worgen --- Classes: Mage -(0x2007DF, 0x80, 76276, "Armor Skills"), --- Races: Human, Orc, Dwarf, Undead, Gnome, Troll, Goblin, Blood elf, Worgen --- Classes: Warlock -(0x2003D7, 0x100, 688, "Summon Imp"), --- Races: Human, Orc, Dwarf, Undead, Gnome, Troll, Goblin, Blood elf, Worgen --- Classes: Warlock -(0x2003D7, 0x100, 86213, "Soul Swap Exhale"), --- Races: Human, Orc, Dwarf, Undead, Gnome, Troll, Goblin, Blood elf, Worgen --- Classes: Warlock -(0x2003D7, 0x100, 89420, "Drain Life"), --- Races: Human, Orc, Dwarf, Undead, Gnome, Troll, Goblin, Blood elf, Worgen --- Classes: Warlock -(0x2003D7, 0x100, 76299, "Weapon Skills"), --- Races: Human, Orc, Dwarf, Undead, Gnome, Troll, Goblin, Blood elf, Worgen --- Classes: Warlock -(0x2003D7, 0x100, 76277, "Armor Skills"), --- Races: Human, Orc, Dwarf, Undead, Gnome, Troll, Goblin, Blood elf, Worgen --- Classes: Warlock -(0x2003D7, 0x100, 87330, "Suppression"), --- Races: Human, Orc, Dwarf, Undead, Gnome, Troll, Goblin, Blood elf, Worgen --- Classes: Warlock -(0x2003D7, 0x100, 75445, "Demonic Immolate"), --- Races: Human, Orc, Dwarf, Undead, Gnome, Troll, Goblin, Blood elf, Worgen --- Classes: Warlock -(0x2003D7, 0x100, 686, "Shadow Bolt"), --- Races: Human, Orc, Dwarf, Undead, Gnome, Troll, Goblin, Blood elf, Worgen --- Classes: Warlock -(0x2003D7, 0x100, 58284, "Chaos Bolt Passive"), --- Races: Orc, Undead, Tauren, Troll, Goblin, Blood elf --- Classes: All -(0x3B2, 0x0, 669, "Language Orcish"), --- Races: Orc --- Classes: Warrior, Rogue, Mage -(0x2, 0x89, 21563, "Command"), --- Races: Orc --- Classes: Warrior, Hunter, Rogue, Death Knight -(0x2, 0x2D, 20572, "Blood Fury"), --- Races: Orc --- Classes: Warrior, Hunter, Rogue, Death Knight, Shaman, Mage, Warlock -(0x2, 0x1ED, 20573, "Hardiness"), --- Races: Orc --- Classes: Warrior, Hunter, Rogue, Death Knight, Shaman, Mage, Warlock -(0x2, 0x1ED, 20574, "Axe Specialization"), --- Races: Orc --- Classes: Warrior, Hunter, Rogue, Death Knight, Shaman, Mage, Warlock -(0x2, 0x1ED, 79743, "Languages"), --- Races: Orc --- Classes: Hunter -(0x2, 0x4, 20576, "Command"), --- Races: Orc, Dwarf, Troll, Goblin, Dranei --- Classes: Shaman -(0x586, 0x40, 27763, "Relic"), --- Races: Orc --- Classes: Shaman -(0x2, 0x40, 65222, "Command"), --- Races: Orc --- Classes: Shaman -(0x2, 0x40, 33697, "Blood Fury"), --- Races: Orc, Dwarf, Troll, Goblin, Dranei --- Classes: Shaman -(0x586, 0x40, 76272, "Armor Skills"), --- Races: Orc, Dwarf, Troll, Goblin, Dranei --- Classes: Shaman -(0x586, 0x40, 76296, "Weapon Skills"), --- Races: Orc, Dwarf, Troll, Goblin, Dranei --- Classes: Shaman -(0x586, 0x40, 89920, "Ancestral Focus"), --- Races: Orc, Dwarf, Tauren, Troll, Goblin, Dranei --- Classes: Shaman -(0x5A6, 0x40, 403, "Lightning Bolt"), --- Races: Orc --- Classes: Mage, Warlock -(0x2, 0x180, 33702, "Blood Fury"), --- Races: Dwarf --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock -(0x4, 0x1FF, 20596, "Frost Resistance"), --- Races: Dwarf --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock -(0x4, 0x1FF, 20595, "Gun Specialization"), --- Races: Dwarf --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock -(0x4, 0x1FF, 20594, "Stoneform"), --- Races: Dwarf --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock -(0x4, 0x1FF, 59224, "Mace Specialization"), --- Races: Dwarf --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock -(0x4, 0x1FF, 92682, "Explorer"), --- Races: Dwarf --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock -(0x4, 0x1FF, 79739, "Languages"), --- Races: Dwarf --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock -(0x4, 0x1FF, 672, "Language Dwarven"), --- Races: Night elf --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Mage, Druid -(0x8, 0x4BD, 76252, "Languages"), --- Races: Night elf --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Mage, Druid -(0x8, 0x4BD, 20583, "Nature Resistance"), --- Races: Night elf --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Mage, Druid -(0x8, 0x4BD, 20582, "Quickness"), --- Races: Night elf --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Mage, Druid -(0x8, 0x4BD, 20585, "Wisp Spirit"), --- Races: Night elf --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Mage, Druid -(0x8, 0x4BD, 21009, "Elusiveness"), --- Races: Night elf --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Mage, Druid -(0x8, 0x4BD, 58984, "Shadowmeld"), --- Races: Night elf --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Mage, Druid -(0x8, 0x4BD, 671, "Language Darnassian"), --- Races: Night elf, Tauren, Troll, Worgen --- Classes: Druid -(0x2000A8, 0x400, 84736, "Nature's Focus"), --- Races: Night elf, Tauren, Troll, Worgen --- Classes: Druid -(0x2000A8, 0x400, 81170, "Ravage!"), --- Races: Night elf, Tauren, Troll, Worgen --- Classes: Druid -(0x2000A8, 0x400, 79577, "Eclipse Mastery Driver Passive"), --- Races: Night elf, Tauren, Troll, Worgen --- Classes: Druid -(0x2000A8, 0x400, 76300, "Weapon Skills"), --- Races: Night elf, Tauren, Troll, Worgen --- Classes: Druid -(0x2000A8, 0x400, 76275, "Armor Skills"), --- Races: Night elf, Tauren, Troll, Worgen --- Classes: Druid -(0x2000A8, 0x400, 5176, "Wrath"), --- Races: Night elf, Tauren, Troll, Worgen --- Classes: Druid -(0x2000A8, 0x400, 84738, "Celestial Focus"), --- Races: Undead --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Mage -(0x10, 0xBD, 17737, "Language Gutterspeak"), --- Races: Undead --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Mage, Warlock -(0x10, 0x1BD, 5227, "Underwater Breathing"), --- Races: Undead --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Mage, Warlock -(0x10, 0x1BD, 7744, "Will of the Forsaken"), --- Races: Undead --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Mage, Warlock -(0x10, 0x1BD, 20577, "Cannibalize"), --- Races: Undead --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Mage, Warlock -(0x10, 0x1BD, 20579, "Shadow Resistance"), --- Races: Undead --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Mage, Warlock -(0x10, 0x1BD, 79747, "Languages"), --- Races: Undead --- Classes: Warlock -(0x10, 0x100, 17747, "Language Gutterspeak"), --- Races: Tauren --- Classes: Warrior, Paladin, Hunter, Priest, Death Knight, Druid -(0x20, 0x437, 670, "Language Taurahe"), --- Races: Tauren --- Classes: Warrior, Paladin, Hunter, Priest, Death Knight, Druid -(0x20, 0x437, 20549, "War Stomp"), --- Races: Tauren --- Classes: Warrior, Paladin, Hunter, Priest, Death Knight, Druid -(0x20, 0x437, 20550, "Endurance"), --- Races: Tauren --- Classes: Warrior, Paladin, Hunter, Priest, Death Knight, Druid -(0x20, 0x437, 20551, "Nature Resistance"), --- Races: Tauren --- Classes: Warrior, Paladin, Hunter, Priest, Death Knight, Druid -(0x20, 0x437, 20552, "Cultivation"), --- Races: Tauren --- Classes: Warrior, Paladin, Hunter, Priest, Death Knight, Druid -(0x20, 0x437, 79746, "Languages"), --- Races: Gnome --- Classes: Warrior, Rogue, Priest, Death Knight, Mage, Warlock -(0x40, 0x1B9, 20591, "Expansive Mind"), --- Races: Gnome --- Classes: Warrior, Rogue, Priest, Death Knight, Mage, Warlock -(0x40, 0x1B9, 20593, "Engineering Specialization"), --- Races: Gnome --- Classes: Warrior, Rogue, Priest, Death Knight, Mage, Warlock -(0x40, 0x1B9, 20592, "Arcane Resistance"), --- Races: Gnome --- Classes: Warrior, Rogue, Priest, Death Knight, Mage, Warlock -(0x40, 0x1B9, 92680, "Shortblade Specialization"), --- Races: Gnome --- Classes: Warrior, Rogue, Priest, Death Knight, Mage, Warlock -(0x40, 0x1B9, 79740, "Languages"), --- Races: Gnome --- Classes: Warrior, Rogue, Priest, Death Knight, Mage, Warlock -(0x40, 0x1B9, 7340, "Language Gnomish"), --- Races: Troll --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid -(0x80, 0x5FD, 7341, "Language Troll"), --- Races: Troll --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid -(0x80, 0x5FD, 26290, "Bow Specialization"), --- Races: Troll --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid -(0x80, 0x5FD, 26297, "Berserking"), --- Races: Troll --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid -(0x80, 0x5FD, 58943, "Da Voodoo Shuffle"), --- Races: Troll --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid -(0x80, 0x5FD, 20555, "Regeneration"), --- Races: Troll --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid -(0x80, 0x5FD, 20557, "Beast Slaying"), --- Races: Troll --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid -(0x80, 0x5FD, 20558, "Throwing Specialization"), --- Races: Troll --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid -(0x80, 0x5FD, 79744, "Languages"), --- Races: Goblin --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock -(0x100, 0x1FD, 69269, "Language Goblin"), --- Races: Goblin --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock -(0x100, 0x1FD, 69070, "Rocket Jump"), --- Races: Goblin --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock -(0x100, 0x1FD, 69041, "Rocket Barrage"), --- Races: Goblin --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock -(0x100, 0x1FD, 69044, "Best Deals Anywhere"), --- Races: Goblin --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock -(0x100, 0x1FD, 69045, "Better Living Through Chemistry"), --- Races: Goblin --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock -(0x100, 0x1FD, 69042, "Time is Money"), --- Races: Goblin --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock -(0x100, 0x1FD, 79749, "Languages"), --- Races: Blood elf --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Mage, Warlock -(0x200, 0x1BF, 813, "Language Thalassian"), --- Races: Blood elf --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Mage, Warlock -(0x200, 0x1BF, 822, "Arcane Resistance"), --- Races: Blood elf --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Mage, Warlock -(0x200, 0x1BF, 28877, "Arcane Affinity"), --- Races: Blood elf --- Classes: Warrior -(0x200, 0x1, 69179, "Arcane Torrent"), --- Races: Blood elf --- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Mage, Warlock -(0x200, 0x1BF, 79748, "Languages"), --- Races: Blood elf --- Classes: Paladin, Priest, Mage, Warlock -(0x200, 0x192, 28730, "Arcane Torrent"), --- Races: Blood elf --- Classes: Hunter -(0x200, 0x4, 80483, "Arcane Torrent"), --- Races: Blood elf --- Classes: Rogue -(0x200, 0x8, 25046, "Arcane Torrent"), --- Races: Dranei --- Classes: Warrior, Paladin, Hunter, Priest, Death Knight, Shaman, Mage -(0x400, 0xF7, 29932, "Language Draenei"), --- Races: Dranei --- Classes: Warrior, Paladin, Hunter, Priest, Death Knight, Shaman, Mage -(0x400, 0xF7, 79741, "Languages"), --- Races: Dranei --- Classes: Warrior, Paladin, Hunter, Death Knight -(0x400, 0x27, 6562, "Heroic Presence"), --- Races: Dranei --- Classes: Warrior -(0x400, 0x1, 28880, "Gift of the Naaru"), --- Races: Dranei --- Classes: Warrior, Paladin, Hunter, Priest, Death Knight, Shaman, Mage -(0x400, 0xF7, 28875, "Gemcutting"), --- Races: Dranei --- Classes: Warrior -(0x400, 0x1, 59221, "Shadow Resistance"), --- Races: Dranei --- Classes: Paladin -(0x400, 0x2, 59535, "Shadow Resistance"), --- Races: Dranei --- Classes: Paladin -(0x400, 0x2, 59542, "Gift of the Naaru"), --- Races: Dranei --- Classes: Hunter -(0x400, 0x4, 59543, "Gift of the Naaru"), --- Races: Dranei --- Classes: Hunter -(0x400, 0x4, 59536, "Shadow Resistance"), --- Races: Dranei --- Classes: Priest -(0x400, 0x10, 59538, "Shadow Resistance"), --- Races: Dranei --- Classes: Priest, Shaman, Mage -(0x400, 0xD0, 28878, "Heroic Presence"), --- Races: Dranei --- Classes: Priest -(0x400, 0x10, 59544, "Gift of the Naaru"), --- Races: Dranei --- Classes: Shaman -(0x400, 0x40, 59540, "Shadow Resistance"), --- Races: Dranei --- Classes: Shaman -(0x400, 0x40, 59547, "Gift of the Naaru"), --- Races: Dranei --- Classes: Mage -(0x400, 0x80, 59541, "Shadow Resistance"), --- Races: Dranei --- Classes: Mage -(0x400, 0x80, 59548, "Gift of the Naaru"), --- Races: Worgen --- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Mage, Warlock, Druid -(0x200000, 0x5BD, 79742, "Languages"), --- Races: Worgen --- Classes: Warrior, Hunter, Rogue, Priest, Mage, Warlock, Druid -(0x200000, 0x59D, 69001, ""), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 52665, "Relic"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 63645, "Activating Primary Spec"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 63644, "Activating Secondary Spec"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 45902, "Blood Strike"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 82246, "Parry"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 89832, "Death Strike Enabler"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 45477, "Icy Touch"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 48266, "Frost Presence"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 61455, "Runic Focus"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 59921, "Frost Fever"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 33391, "Journeyman Riding"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 89964, "Clear Glyph"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 76282, "Armor Skills"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 76292, "Weapon Skills"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 750, "Plate Mail"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 45462, "Plague Strike"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 47541, "Death Coil"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 49576, "Death Grip"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 59879, "Blood Plague"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 45903, "Offensive State (DND)"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 10846, "First Aid"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 3275, "Linen Bandage"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 18630, "Heavy Runecloth Bandage"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 3276, "Heavy Linen Bandage"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 3277, "Wool Bandage"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 3278, "Heavy Wool Bandage"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 7928, "Silk Bandage"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 7929, "Heavy Silk Bandage"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 10840, "Mageweave Bandage"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 10841, "Heavy Mageweave Bandage"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 18629, "Runecloth Bandage"), --- Races: All --- Classes: Death Knight -(0x0, 0x20, 7934, "Anti-Venom"), --- Races: Orc --- Classes: Death Knight -(0x2, 0x20, 54562, "Command"), --- Races: Gnome --- Classes: Death Knight -(0x40, 0x20, 20589, "Escape Artist"), --- Races: Goblin --- Classes: Death Knight -(0x100, 0x20, 69046, "Pack Hobgoblin"), --- Races: Blood elf --- Classes: Death Knight -(0x200, 0x20, 50613, "Arcane Torrent"), --- Races: Dranei --- Classes: Death Knight -(0x400, 0x20, 59539, "Shadow Resistance"), --- Races: Dranei --- Classes: Death Knight -(0x400, 0x20, 59545, "Gift of the Naaru"), --- Races: Worgen --- Classes: Death Knight -(0x200000, 0x20, 68978, "Flayer"), --- Races: Worgen --- Classes: Death Knight -(0x200000, 0x20, 68992, "Darkflight"), --- Races: Worgen --- Classes: Death Knight -(0x200000, 0x20, 68976, "Aberration"), --- Races: Worgen --- Classes: Death Knight -(0x200000, 0x20, 68996, "Two Forms"), --- Races: Worgen --- Classes: Death Knight -(0x200000, 0x20, 68975, "Viciousness"), --- Races: Worgen --- Classes: Death Knight -(0x200000, 0x20, 94293, "Enable Worgen Altered Form"), --- Races: Worgen --- Classes: Death Knight -(0x200000, 0x20, 87840, "Running Wild"); diff --git a/sql/updates/world/2013_04_03_00_world_playercreateinfo_button_434.sql b/sql/updates/world/2013_04_03_00_world_playercreateinfo_button_434.sql deleted file mode 100644 index b7281422712..00000000000 --- a/sql/updates/world/2013_04_03_00_world_playercreateinfo_button_434.sql +++ /dev/null @@ -1,4 +0,0 @@ --- Fixes tauren druids not having wrath in their spell bar on character creation. -DELETE FROM `playercreateinfo_action` WHERE `race`=6 AND `class`=11 AND `action`=5176; -INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES -(6, 11, 0, 5176, 0); diff --git a/sql/updates/world/2013_05_09_00_world_spell_dbc_434.sql b/sql/updates/world/2013_05_09_00_world_spell_dbc_434.sql deleted file mode 100644 index 11fc9e7ed51..00000000000 --- a/sql/updates/world/2013_05_09_00_world_spell_dbc_434.sql +++ /dev/null @@ -1,138 +0,0 @@ -DROP TABLE IF EXISTS `spell_dbc`; -CREATE TABLE `spell_dbc` ( - `Id` INT(10) UNSIGNED NOT NULL, - `Attributes` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `AttributesEx` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `AttributesEx2` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `AttributesEx3` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `AttributesEx4` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `AttributesEx5` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `AttributesEx6` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `AttributesEx7` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `AttributesEx8` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `AttributesEx9` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `AttributesEx10` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `CastingTimeIndex` INT(10) UNSIGNED NOT NULL DEFAULT '1', - `DurationIndex` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `RangeIndex` INT(10) UNSIGNED NOT NULL DEFAULT '1', - `SchoolMask` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `SpellAuraOptionsId` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `SpellCastingRequirementsId` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `SpellCategoriesId` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `SpellClassOptionsId` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `SpellEquippedItemsId` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `SpellLevelsId` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `SpellTargetRestrictionsId` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `SpellInterruptsId` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `Comment` TEXT NOT NULL, - PRIMARY KEY (`Id`) -) -COMMENT='Custom spell.dbc entries' -COLLATE='utf8_general_ci' -ENGINE=MyISAM; - -INSERT INTO `spell_dbc` (`Id`, `Attributes`, `AttributesEx`, `AttributesEx2`, `AttributesEx3`, `AttributesEx4`, `AttributesEx5`, `AttributesEx6`, `AttributesEx7`, `AttributesEx8`, `AttributesEx9`, `AttributesEx10`, `CastingTimeIndex`, `DurationIndex`, `RangeIndex`, `SchoolMask`, `SpellAuraOptionsId`, `SpellCastingRequirementsId`, `SpellCategoriesId`, `SpellClassOptionsId`, `SpellEquippedItemsId`, `SpellLevelsId`, `SpellTargetRestrictionsId`, `SpellInterruptsId`, `Comment`) VALUES -(11202, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Item 3776 spellid_1 serverside spell'), -(25347, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Item_template serverside spell'), -(25359, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Item 21293 spellid_2 serverside spell'), -(27488, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Grimoire of Blood Pack Rank 6: spell filler'), -(32780, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 10040 reward serverside spell'), -(34145, 0, 0, 0, 67108864, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0, 0, 0, 0, 0, 1035, 0, 0, 'Ritual of Souls Rank 1 - Trigger Create Soulwell (29886)'), -(34448, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Serverside spell orb of translocation (gobjid=180911)'), -(34452, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Serverside spell orb of translocation (gobjid=180912)'), -(38406, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 10721 RewSpellCast serverside spell'), -(38665, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, '[PH] Quest reward: Exorcising the Trees'), -(38758, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, '[PH] Quest reward: Nether Gas In a Fel Fire Engine'), -(38788, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, '[PH] Quest reward: Spirit Calling'), -(39613, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 10967 reward serverside spell'), -(39616, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 10966 reward serverside spell'), -(40145, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 11000 RewSpellCast serverside spell'), -(42876, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 9275 reward serverside spell'), -(43236, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 11288 reward serverside spell'), -(43459, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 11332 reward serverside spell'), -(43499, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 11250 reward serverside spell'), -(43503, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 11261 reward serverside spell'), -(44275, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 11432 reward serverside spell'), -(44805, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Aura used in creature_addon - serverside spell'), -(44987, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 11521 reward serverside spell'), -(45140, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, '[PH] Quest reward: Making Ready / Don\'t Stop Now....'), -(45144, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, '[PH] Quest reward: Disrupt the Greengill Coast'), -(45148, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, '[PH] Quest reward: Ata\'mal Armaments'), -(45315, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 11566 reward serverside spell'), -(45453, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 11587 reward serverside spell'), -(45459, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Placeholder, Missing Aura'), -(45460, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Placeholder, Missing Aura'), -(45767, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 11670 RewSpellCast serverside spell'), -(46251, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, '[PH] Quest reward: Blood for Blood'), -(48803, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 12214 reward serverside spell'), -(50574, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 12597 reward serverside spell'), -(58888, 0, 0, 0, 67108864, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0, 0, 0, 0, 0, 91, 0, 0, 'Ritual of Souls Rank 2 - Trigger Create Soulwell (58889)'), -(59046, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Tribunal of Ages - Criteria Marker'), -(62388, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 21, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Demonic Circle: Teleport(48020) - casterAuraSpell'), -(62791, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'XT-002 Heart Overload Trigger Spell'), -(64689, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 13854 and 13862 reward serverside spell'), -(65037, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Nerf the Scrapbots Achievement Criteria Marker'), -(65074, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Freya Achievement spell - Criteria Marker'), -(68496, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Item_template serverside spell'), -(70816, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2146 spellid0 serverside spell'), -(70878, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Creature 40160 creature_addon serverside spell'), -(71098, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Quest 24451 RewSpellCast serverside spell'), -(71356, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2108 spellid0 serverside spell'), -(71803, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2108 spellid1 serverside spell'), -(72111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2136 spellid0 serverside spell'), -(72125, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2136 spellid1 serverside spell'), -(72233, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2146 spellid1 serverside spell'), -(72234, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2146 spellid2 serverside spell'), -(72235, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Spelldifficulty_dbc id:2146 spellid3 serverside spell'), -(100001, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 8, 1, 1, 38, 0, 0, 1205, 0, 0, 0, 0, 'Drain Soul increased damage - serverside spell'), -(3617, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC 32958 suicide spell'), -(18954, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Ranshalla Despawn'), -(24308, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 26, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Summon Shade of Jin\'Do'), -(24677, 256, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 6, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'GY Mid Trigger - 2.0.12 spell - AV Snowfall Graveyard'), -(25900, 256, 268435456, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stun Self'), -(28782, 256, 268435456, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stun Self + Immune'), -(30023, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 26, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Gushing Wound Removal'), -(30426, 256, 268435456, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 40, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stillpine Ancestor Akida'), -(30429, 256, 268435456, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 40, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stillpine Ancestor Coo'), -(30432, 256, 268435456, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 40, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stillpine Ancestor Tikti'), -(30454, 256, 268435456, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 40, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stillpine Ancestor Vark'), -(31247, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Silithyst Cap Reward'), -(40200, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 26, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bombing Run: See Invisibility Aura Remover'), -(70507, 256, 1024, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 21, 1, 0, 702, 0, 0, 0, 0, 0, 0, 0, 'Halion - Combustion & Consumption Scale Aura'), -(74810, 256, 268435456, 4, 0, 0, 0, 16785408, 0, 0, 0, 0, 1, 21, 13, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Halion - Copy Damage'), -(7056, 336, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Pacified'), -(25042, 384, 268435592, 4, 131072, 0, 0, 0, 0, 0, 0, 0, 1, 29, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Triggerspell - Mark of Nature'), -(31934, 384, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 21, 1, 0, 3190, 0, 0, 0, 0, 0, 0, 0, 'Blessed Life'), -(37794, 384, 0, 0, 1048576, 0, 0, 0, 0, 0, 0, 0, 1, 21, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Transform Infernal'), -(39707, 384, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 21, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Creature 23487 creature_addon serverside spell'), -(63975, 384, 0, 0, 262144, 128, 0, 0, 0, 0, 0, 0, 1, 0, 13, 1, 38, 0, 0, 0, 0, 0, 0, 0, 'Glyph of Blackstab - 3.2.2'), -(24899, 400, 1024, 0, 0, 2097152, 0, 0, 0, 0, 0, 0, 1, 21, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Heart of the Wild Bear Effect'), -(24900, 400, 1024, 0, 0, 2097152, 0, 0, 0, 0, 0, 0, 1, 21, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Heart of the Wild Cat Effect'), -(72958, 448, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Shaman T10 shoulder visual'), -(12507, 464, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 1, 21, 1, 0, 38, 0, 0, 0, 0, 2, 0, 0, 'Atal\'ai Skeleton Totem'), -(31982, 464, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 21, 1, 0, 38, 0, 0, 0, 0, 1337, 0, 0, 'Tainted Earthgrab Totem'), -(30437, 2304, 268435456, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 36, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stillpine Ancestor Akida TRIGGER'), -(30442, 2304, 268435456, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 36, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stillpine Ancestor Coo TRIGGER'), -(30443, 2304, 268435456, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 36, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stillpine Ancestor Tikti TRIGGER'), -(30453, 2304, 268435456, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 36, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stillpine Ancestor Vark TRIGGER'), -(13377, 2512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 21, 1, 2, 0, 0, 22835, 0, 0, 141, 0, 0, 'Fire Shield'), -(33134, 65920, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 85, 1, 2, 38, 0, 0, 0, 0, 20, 0, 0, 'Tainted Nova Totem'), -(31980, 328064, 1024, 4, 268894208, 0, 0, 0, 0, 0, 0, 0, 1, 0, 13, 1, 0, 0, 0, 2826, 0, 37, 0, 0, 'Righteous Defense Trigger Spell'), -(25893, 8388864, 268435456, 5, 269484032, 0, 0, 0, 0, 0, 0, 0, 1, 225, 13, 0, 5, 0, 0, 0, 0, 0, 0, 0, 'Viscidus Shrinks'), -(65387, 8388864, 0, 5, 268697600, 128, 0, 16777216, 0, 0, 0, 0, 1, 0, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Steelforged Defender - Credit marker'), -(58630, 8388992, 0, 5, 269484288, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Mal\'ganis credit marker'), -(35009, 134545792, 1024, 268435460, 65536, 0, 0, 0, 0, 0, 0, 0, 1, 0, 13, 6, 0, 0, 0, 50, 0, 0, 2, 0, 'Invisibility - Reducing threat'), -(68308, 159383808, 1056, 16389, 268697600, 128, 8, 4096, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Vault of Archavon - Earth, Wind & Fire - Achievement Check'), -(59450, 536870912, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Four Horsemen credit marker'), -(64899, 536870912, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Hodir credit marker'), -(64985, 536870912, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Thorim credit marker'), -(65195, 536870912, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'The Iron Council credit marker'), -(68572, 536870912, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Grand Champions credit marker'), -(68574, 536870912, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Argent Champion credit marker'), -(61698, 536871296, 269058048, 67108868, 268894272, 2048, 0, 1024, 0, 0, 0, 0, 1, 0, 1, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Flush - Knockback effect'), -(5302, 536871312, 1024, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 28, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Defensive State - Follows a successful block,dodge or parry.'), -(68184, 545259904, 0, 5, 268697856, 128, 0, 16777216, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Faction Champions - credit marker'), -(68620, 545259904, 0, 5, 268697856, 128, 0, 16777216, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Resilience Will Fix It - achievement credit marker'), -(60937, 562036736, 32, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Seaforium charges damaging wall achievement credit'), -(58428, 671089024, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 18, 1, 1, 1, 0, 0, 297, 0, 0, 0, 0, 'Overkill - aura remove spell'), -(61988, 671089024, 268436480, 4, 269484032, 0, 0, 0, 0, 0, 0, 0, 1, 25, 13, 0, 38, 0, 0, 0, 0, 0, 0, 0, 'Divine Shield Exclude Aura - 61988'); diff --git a/sql/updates/world/2013_05_09_01_world_spelleffect_dbc_434.sql b/sql/updates/world/2013_05_09_01_world_spelleffect_dbc_434.sql deleted file mode 100644 index a5446589859..00000000000 --- a/sql/updates/world/2013_05_09_01_world_spelleffect_dbc_434.sql +++ /dev/null @@ -1,105 +0,0 @@ -DROP TABLE IF EXISTS `spelleffect_dbc`; -CREATE TABLE `spelleffect_dbc` ( - `Id` INT(10) UNSIGNED NOT NULL, - `Effect` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `EffectValueMultiplier` FLOAT UNSIGNED NOT NULL DEFAULT '0', - `EffectApplyAuraName` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `EffectAplitude` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `EffectBasePoints` INT(10) NOT NULL DEFAULT '0', - `EffectBonusMultiplier` FLOAT UNSIGNED NOT NULL DEFAULT '0', - `EffectDamageMultiplier` FLOAT UNSIGNED NOT NULL DEFAULT '0', - `EffectChainTarget` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `EffectDieSides` INT(10) NOT NULL DEFAULT '0', - `EffectMechanic` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `EffectMiscValue` INT(10) NOT NULL DEFAULT '0', - `EffectMiscValueB` INT(10) NOT NULL DEFAULT '0', - `EffectRadiusIndex` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `EffectRadiusIndexMax` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `EffectRealPointsPerLevel` FLOAT UNSIGNED NOT NULL DEFAULT '0', - `EffectSpellClassMaskA` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `EffectSpellClassMaskB` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `EffectSpellClassMaskC` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `EffectTriggerSpell` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `EffectImplicitTargetA` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `EffectImplicitTargetB` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `EffectSpellId` INT(10) UNSIGNED NOT NULL, - `EffectIndex` INT(10) UNSIGNED NOT NULL, - PRIMARY KEY (`Id`) -) -COLLATE='utf8_general_ci' -ENGINE=MyISAM; - -INSERT INTO `spelleffect_dbc` (`Id`, `Effect`, `EffectValueMultiplier`, `EffectApplyAuraName`, `EffectAplitude`, `EffectBasePoints`, `EffectBonusMultiplier`, `EffectDamageMultiplier`, `EffectChainTarget`, `EffectDieSides`, `EffectMechanic`, `EffectMiscValue`, `EffectMiscValueB`, `EffectRadiusIndex`, `EffectRadiusIndexMax`, `EffectRealPointsPerLevel`, `EffectSpellClassMaskA`, `EffectSpellClassMaskB`, `EffectSpellClassMaskC`, `EffectTriggerSpell`, `EffectImplicitTargetA`, `EffectImplicitTargetB`, `EffectSpellId`, `EffectIndex`) VALUES -(153020, 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 62388, 1), -(153021, 64, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29886, 1, 0, 34145, 1), -(153022, 64, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 58889, 1, 0, 58888, 1), -(153023, 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 61988, 1), -(153024, 6, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 100001, 1), -(153025, 6, 0, 23, 85000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 72957, 1, 0, 72958, 1), -(153026, 6, 0, 226, 20000, 9, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 58428, 1), -(153027, 6, 0, 137, 0, -1, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 24899, 1), -(153028, 6, 0, 166, 0, -1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 24900, 1), -(153029, 77, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 34448, 1), -(153030, 77, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 34452, 1), -(153031, 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 70878, 1), -(153032, 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 44805, 1), -(153033, 6, 0, 18, 0, 49, 0, 1, 0, 1, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 39707, 1), -(153034, 6, 0, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7056, 1), -(153035, 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 45459, 1), -(153036, 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 45460, 1), -(153037, 1, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3617, 1), -(153038, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 22, 7, 58630, 1), -(153039, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 18, 16, 68572, 1), -(153040, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 18, 16, 68574, 1), -(153041, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 22, 30, 59046, 1), -(153042, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 22, 7, 68184, 1), -(153043, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 18, 16, 59450, 1), -(153044, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 18, 16, 65195, 1), -(153045, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 18, 16, 64899, 1), -(153046, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 18, 16, 64985, 1), -(153047, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 22, 30, 65074, 1), -(153048, 16, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10855, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38758, 1), -(153049, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 60937, 1), -(153050, 6, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 5302, 1), -(153051, 6, 0, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 25900, 1), -(153052, 6, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 12, 0, 0, 0, 0, 0, 0, 22, 15, 25042, 1), -(153053, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 62791, 1), -(153054, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 65037, 1), -(153055, 28, 0, 0, 0, 0, 0, 1, 0, 1, 0, 14986, 64, 0, 0, 0, 0, 0, 0, 0, 18, 0, 24308, 1), -(153056, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 68308, 1), -(153057, 77, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 63975, 1), -(153058, 77, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, 0, 24677, 1), -(153059, 6, 0, 56, 0, 0, 0, 1, 0, 0, 0, 16963, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 37794, 1), -(153060, 77, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 31247, 1), -(153061, 6, 0, 23, 5000, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12504, 1, 0, 12507, 1), -(153062, 6, 0, 23, 5000, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 31983, 1, 0, 31982, 1), -(153063, 6, 0, 23, 18000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29878, 1, 0, 33134, 1), -(153064, 164, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35321, 18, 0, 30023, 1), -(153065, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 12, 0, 0, 0, 0, 0, 0, 22, 15, 31980, 1), -(153066, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, 0, 61698, 1), -(153067, 6, 0, 87, 0, -51, 0, 1, 0, 1, 0, 127, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 31934, 1), -(153068, 6, 0, 23, 3000, -1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13376, 21, 0, 13377, 1), -(153069, 6, 0, 12, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 28782, 1), -(153070, 28, 0, 0, 0, 0, 0, 1, 0, 0, 0, 17379, 64, 15, 0, 0, 0, 0, 0, 0, 32, 0, 30426, 1), -(153071, 6, 0, 23, 1000, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30426, 21, 0, 30437, 1), -(153072, 28, 0, 0, 0, 0, 0, 1, 0, 0, 0, 17391, 64, 7, 0, 0, 0, 0, 0, 0, 32, 0, 30429, 1), -(153073, 6, 0, 23, 1000, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30429, 21, 0, 30442, 1), -(153074, 28, 0, 0, 0, 0, 0, 1, 0, 0, 0, 17410, 64, 7, 0, 0, 0, 0, 0, 0, 32, 0, 30454, 1), -(153075, 6, 0, 23, 1000, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30454, 21, 0, 30453, 1), -(153076, 28, 0, 0, 0, 0, 0, 1, 0, 0, 0, 17392, 64, 7, 0, 0, 0, 0, 0, 0, 32, 0, 30432, 1), -(153077, 6, 0, 23, 1000, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30432, 21, 0, 30443, 1), -(153078, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 22, 7, 65387, 1), -(153079, 125, 0, 0, 0, -11, 0, 1, 0, 1, 0, 0, 0, 27, 0, 0, 0, 0, 0, 0, 22, 16, 35009, 1), -(153080, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 22, 7, 68620, 1), -(153081, 164, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40195, 18, 0, 40200, 1), -(153082, 6, 0, 61, 0, 10, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 70507, 1), -(153083, 6, 1, 300, 0, 100, 0, 0, 0, 0, 0, 127, 0, 22, 0, 0, 0, 0, 0, 0, 25, 0, 74810, 1), -(153084, 6, 0, 61, 0, -5, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 25893, 1), -(153085, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 18954, 1), -(153088, 164, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38363, 0, 0, 30023, 2), -(153089, 6, 0, 40, 0, 0, 0, 1, 0, 1, 0, 127, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 28782, 2), -(153090, 6, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 30426, 2), -(153091, 6, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 30429, 2), -(153092, 6, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 30454, 2), -(153093, 6, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 30432, 2), -(153095, 164, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 39215, 0, 0, 30023, 3);
\ No newline at end of file diff --git a/sql/updates/world/2013_05_11_00_world_spelleffect_dbc_434.sql b/sql/updates/world/2013_05_11_00_world_spelleffect_dbc_434.sql deleted file mode 100644 index 31a7b7b5b89..00000000000 --- a/sql/updates/world/2013_05_11_00_world_spelleffect_dbc_434.sql +++ /dev/null @@ -1,75 +0,0 @@ -TRUNCATE `spelleffect_dbc`; -INSERT INTO `spelleffect_dbc` (`Id`, `Effect`, `EffectValueMultiplier`, `EffectApplyAuraName`, `EffectAplitude`, `EffectBasePoints`, `EffectBonusMultiplier`, `EffectDamageMultiplier`, `EffectChainTarget`, `EffectDieSides`, `EffectMechanic`, `EffectMiscValue`, `EffectMiscValueB`, `EffectRadiusIndex`, `EffectRadiusIndexMax`, `EffectRealPointsPerLevel`, `EffectSpellClassMaskA`, `EffectSpellClassMaskB`, `EffectSpellClassMaskC`, `EffectTriggerSpell`, `EffectImplicitTargetA`, `EffectImplicitTargetB`, `EffectSpellId`, `EffectIndex`) VALUES -(153020, 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 62388, 0), -(153021, 64, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29886, 1, 0, 34145, 0), -(153022, 64, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 58889, 1, 0, 58888, 0), -(153023, 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 61988, 0), -(153024, 6, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 100001, 0), -(153025, 6, 0, 23, 85000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 72957, 1, 0, 72958, 0), -(153026, 6, 0, 226, 20000, 9, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 58428, 0), -(153027, 6, 0, 137, 0, -1, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 24899, 0), -(153028, 6, 0, 166, 0, -1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 24900, 0), -(153029, 77, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 34448, 0), -(153030, 77, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 34452, 0), -(153031, 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 70878, 0), -(153032, 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 44805, 0), -(153033, 6, 0, 18, 0, 49, 0, 1, 0, 1, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 39707, 0), -(153034, 6, 0, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7056, 0), -(153035, 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 45459, 0), -(153036, 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 45460, 0), -(153037, 1, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3617, 0), -(153038, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 22, 7, 58630, 0), -(153039, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 18, 16, 68572, 0), -(153040, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 18, 16, 68574, 0), -(153041, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 22, 30, 59046, 0), -(153042, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 22, 7, 68184, 0), -(153043, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 18, 16, 59450, 0), -(153044, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 18, 16, 65195, 0), -(153045, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 18, 16, 64899, 0), -(153046, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 18, 16, 64985, 0), -(153047, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 22, 30, 65074, 0), -(153048, 16, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10855, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38758, 0), -(153049, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 60937, 0), -(153050, 6, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 5302, 0), -(153051, 6, 0, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 25900, 0), -(153052, 6, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 12, 0, 0, 0, 0, 0, 0, 22, 15, 25042, 0), -(153053, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 62791, 0), -(153054, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 65037, 0), -(153055, 28, 0, 0, 0, 0, 0, 1, 0, 1, 0, 14986, 64, 0, 0, 0, 0, 0, 0, 0, 18, 0, 24308, 0), -(153056, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 68308, 0), -(153057, 77, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 63975, 0), -(153058, 77, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, 0, 24677, 0), -(153059, 6, 0, 56, 0, 0, 0, 1, 0, 0, 0, 16963, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 37794, 0), -(153060, 77, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 31247, 0), -(153061, 6, 0, 23, 5000, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12504, 1, 0, 12507, 0), -(153062, 6, 0, 23, 5000, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 31983, 1, 0, 31982, 0), -(153063, 6, 0, 23, 18000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29878, 1, 0, 33134, 0), -(153064, 164, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35321, 18, 0, 30023, 0), -(153065, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 12, 0, 0, 0, 0, 0, 0, 22, 15, 31980, 0), -(153066, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, 0, 61698, 0), -(153067, 6, 0, 87, 0, -51, 0, 1, 0, 1, 0, 127, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 31934, 0), -(153068, 6, 0, 23, 3000, -1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13376, 21, 0, 13377, 0), -(153069, 6, 0, 12, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 28782, 0), -(153070, 28, 0, 0, 0, 0, 0, 1, 0, 0, 0, 17379, 64, 15, 0, 0, 0, 0, 0, 0, 32, 0, 30426, 0), -(153071, 6, 0, 23, 1000, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30426, 21, 0, 30437, 0), -(153072, 28, 0, 0, 0, 0, 0, 1, 0, 0, 0, 17391, 64, 7, 0, 0, 0, 0, 0, 0, 32, 0, 30429, 0), -(153073, 6, 0, 23, 1000, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30429, 21, 0, 30442, 0), -(153074, 28, 0, 0, 0, 0, 0, 1, 0, 0, 0, 17410, 64, 7, 0, 0, 0, 0, 0, 0, 32, 0, 30454, 0), -(153075, 6, 0, 23, 1000, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30454, 21, 0, 30453, 0), -(153076, 28, 0, 0, 0, 0, 0, 1, 0, 0, 0, 17392, 64, 7, 0, 0, 0, 0, 0, 0, 32, 0, 30432, 0), -(153077, 6, 0, 23, 1000, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30432, 21, 0, 30443, 0), -(153078, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 22, 7, 65387, 0), -(153079, 125, 0, 0, 0, -11, 0, 1, 0, 1, 0, 0, 0, 27, 0, 0, 0, 0, 0, 0, 22, 16, 35009, 0), -(153080, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 22, 7, 68620, 0), -(153081, 164, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40195, 18, 0, 40200, 0), -(153082, 6, 0, 61, 0, 10, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 70507, 0), -(153083, 6, 1, 300, 0, 100, 0, 0, 0, 0, 0, 127, 0, 22, 0, 0, 0, 0, 0, 0, 25, 0, 74810, 0), -(153084, 6, 0, 61, 0, -5, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 25893, 0), -(153085, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 18954, 0), -(153088, 164, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38363, 0, 0, 30023, 1), -(153089, 6, 0, 40, 0, 0, 0, 1, 0, 1, 0, 127, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 28782, 1), -(153090, 6, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 30426, 1), -(153091, 6, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 30429, 1), -(153092, 6, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 30454, 1), -(153093, 6, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 30432, 1), -(153095, 164, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 39215, 0, 0, 30023, 2); diff --git a/sql/updates/world/2013_05_12_00_world_spell_learn_spell_434.sql b/sql/updates/world/2013_05_12_00_world_spell_learn_spell_434.sql deleted file mode 100644 index 04daf03b95e..00000000000 --- a/sql/updates/world/2013_05_12_00_world_spell_learn_spell_434.sql +++ /dev/null @@ -1,16 +0,0 @@ -ALTER TABLE `spell_learn_spell` - CHANGE `entry` `entry` INT(10) UNSIGNED NOT NULL DEFAULT '0', - CHANGE `SpellID` `SpellID` INT(10) UNSIGNED NOT NULL DEFAULT '0'; - -DELETE FROM `spell_learn_spell` WHERE `entry` IN (86467,87491,87492,87493,87494,87495,87496,87497,87498,87500); -INSERT INTO `spell_learn_spell` (`entry`,`SpellID`,`Active`) VALUES -(86467,86473,1), -- Mage -(87491,86470,1), -- Druid -(87492,86471,1), -- Death Knight -(87493,86472,1), -- Hunter -(87494,86474,1), -- Paladin -(87495,86475,1), -- Priest -(87496,86476,1), -- Rogue -(87497,86477,1), -- Shaman -(87498,86478,1), -- Warlock -(87500,86479,1); -- Warrior diff --git a/sql/updates/world/2013_05_21_00_world_trinity_string_434.sql b/sql/updates/world/2013_05_21_00_world_trinity_string_434.sql deleted file mode 100644 index ce82a4d0972..00000000000 --- a/sql/updates/world/2013_05_21_00_world_trinity_string_434.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `trinity_string` WHERE `entry` IN (183, 184); -INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES -(183, '|cff0099FFPhaseMgr: Report for player: %s, zoneId: %u, level: %u, team: %u, phaseupdateflag: %u|r'), -(184, '|cff663399PhaseMgr: There are no definitions defined for zoneId %u.|r'); diff --git a/sql/updates/world/2013_06_14_00_world_zul_aman_434.sql b/sql/updates/world/2013_06_14_00_world_zul_aman_434.sql deleted file mode 100644 index 23334cd1d06..00000000000 --- a/sql/updates/world/2013_06_14_00_world_zul_aman_434.sql +++ /dev/null @@ -1,18 +0,0 @@ -UPDATE `creature_template` SET `speed_walk`=2.5,`ScriptName`='npc_voljin_zulaman' WHERE `entry`=52924; - -DELETE FROM `creature_template_addon` WHERE `entry`=52924; -INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES -(52924, 29261, 0x0, 0x1, ''); - -DELETE FROM `creature_equip_template` WHERE `entry`=52924; -INSERT INTO `creature_equip_template` (`entry`, `id`, `itemEntry1`, `itemEntry2`, `itemEntry3`) VALUES -(52924, 1, 53835, 0, 0); - -DELETE FROM `creature_text` WHERE `entry` IN (52924,24363); -INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES -(52924, 0, 0, 'Follow me, $c. It be takin'' da both of us to open these gates.', 14, 0, 100, 1, 0, 0, 'Vol''jin - SAY_INTRO_1'), -(52924, 1, 0, 'Da ritual to open da gates be requirin'' both of us to hit da gong together.', 14, 0, 100, 1, 0, 0, 'Vol''jin - SAY_INTRO_3'), -(52924, 2, 0, 'Hear me, Zandalari schemers... Da Darkspears and our allies will deny you rulership of da Amani!', 14, 0, 100, 25, 0, 0, 'Vol''jin - SAY_INTRO_3'), -(52924, 3, 0, 'Da Amani know we''re here. Now is da time to attack! ', 14, 0, 100, 5, 0, 0, 'Vol''jin - SAY_INTRO_4'), -(52924, 4, 0, 'Perhaps we''re not ready yet. Speak to me again when you be wantin'' to open da gates.', 14, 0, 100, 1, 0, 0, 'Vol''jin - SAY_INTRO_FAIL'), -(24363, 0, 0, 'Da spirits gonna feast today! Begin da ceremonies, sacrifice da prisoners... make room for our new guests!', 14, 0, 100, 0, 0, 12053, 'Hex Lord Malacrass Trigger - SAY_HEXLOR_INTRO'); diff --git a/sql/updates/world/2013_06_16_00_world_spell_misc_434.sql b/sql/updates/world/2013_06_16_00_world_spell_misc_434.sql deleted file mode 100644 index 917c05bfad8..00000000000 --- a/sql/updates/world/2013_06_16_00_world_spell_misc_434.sql +++ /dev/null @@ -1,11 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id` IN (86183,86184,86185); -INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES -(86183, 'spell_sha_feedback'), -(86184, 'spell_sha_feedback'), -(86185, 'spell_sha_feedback'); - -DELETE FROM `spell_proc_event` WHERE `entry` IN (86183,86184,86185); -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(86183, 0, 11, 0x3, 0, 0, 0, 0, 0, 0, 0), -(86184, 0, 11, 0x3, 0, 0, 0, 0, 0, 0, 0), -(86185, 0, 11, 0x3, 0, 0, 0, 0, 0, 0, 0); diff --git a/sql/updates/world/2013_06_16_00_world_spell_script_names_434.sql b/sql/updates/world/2013_06_16_00_world_spell_script_names_434.sql deleted file mode 100644 index de5fa8f4956..00000000000 --- a/sql/updates/world/2013_06_16_00_world_spell_script_names_434.sql +++ /dev/null @@ -1,5 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id` IN (77755,77756,77762); -INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES -(77755, 'spell_sha_lava_surge'), -(77756, 'spell_sha_lava_surge'), -(77762, 'spell_sha_lava_surge_proc'); diff --git a/sql/updates/world/2013_06_18_00_world_spell_script_names_434.sql b/sql/updates/world/2013_06_18_00_world_spell_script_names_434.sql deleted file mode 100644 index 7bb30c6b4b7..00000000000 --- a/sql/updates/world/2013_06_18_00_world_spell_script_names_434.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id` IN (86181,86209); -INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES -(86181, 'spell_mage_nether_vortex'), -(86209, 'spell_mage_nether_vortex'); diff --git a/sql/updates/world/2013_06_23_00_world_spell_script_names_434.sql b/sql/updates/world/2013_06_23_00_world_spell_script_names_434.sql deleted file mode 100644 index 33b0e8981b9..00000000000 --- a/sql/updates/world/2013_06_23_00_world_spell_script_names_434.sql +++ /dev/null @@ -1 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_magic_broom','spell_headless_horseman_mount','spell_winged_steed_of_the_ebon_blade','spell_big_love_rocket','spell_invincible','spell_blazing_hippogryph','spell_celestial_steed','spell_x53_touring_rocket'); diff --git a/sql/updates/world/2013_06_24_00_world_spell_script_names_434.sql b/sql/updates/world/2013_06_24_00_world_spell_script_names_434.sql deleted file mode 100644 index 577c0e524ab..00000000000 --- a/sql/updates/world/2013_06_24_00_world_spell_script_names_434.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id`=97462; -INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES -(97462, 'spell_warr_rallying_cry'); diff --git a/sql/updates/world/2013_06_25_00_world_spell_script_names_434.sql b/sql/updates/world/2013_06_25_00_world_spell_script_names_434.sql deleted file mode 100644 index 437f0c3702c..00000000000 --- a/sql/updates/world/2013_06_25_00_world_spell_script_names_434.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id` IN (88756,88764); -INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES -(88756, 'spell_sha_rolling_thunder'), -(88764, 'spell_sha_rolling_thunder'); diff --git a/sql/updates/world/2013_06_26_00_world_spell_misc_434.sql b/sql/updates/world/2013_06_26_00_world_spell_misc_434.sql deleted file mode 100644 index 6a0e79f1d4a..00000000000 --- a/sql/updates/world/2013_06_26_00_world_spell_misc_434.sql +++ /dev/null @@ -1,9 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id` IN (82984,82988); -INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES -(82984, 'spell_sha_telluric_currents'), -(82988, 'spell_sha_telluric_currents'); - -DELETE FROM `spell_proc_event` WHERE `entry` IN (82984,82988); -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(82984, 0, 11, 0x1, 0, 0, 0, 0, 0, 0, 0), -(82988, 0, 11, 0x1, 0, 0, 0, 0, 0, 0, 0); diff --git a/sql/updates/world/2013_06_27_00_world_spell_misc_434.sql b/sql/updates/world/2013_06_27_00_world_spell_misc_434.sql deleted file mode 100644 index 17055afe2bf..00000000000 --- a/sql/updates/world/2013_06_27_00_world_spell_misc_434.sql +++ /dev/null @@ -1,11 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id` IN (77794,77795,77796); -INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES -(77794, 'spell_sha_focused_insight'), -(77795, 'spell_sha_focused_insight'), -(77796, 'spell_sha_focused_insight'); - -DELETE FROM `spell_proc_event` WHERE `entry` IN (77794,77795,77796); -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(77794, 0, 11, 0x90100000, 0, 0, 0, 0, 0, 0, 0), -(77795, 0, 11, 0x90100000, 0, 0, 0, 0, 0, 0, 0), -(77796, 0, 11, 0x90100000, 0, 0, 0, 0, 0, 0, 0); diff --git a/sql/updates/world/2013_06_28_00_world_spell_misc_434.sql b/sql/updates/world/2013_06_28_00_world_spell_misc_434.sql deleted file mode 100644 index 3f1cac1a4ed..00000000000 --- a/sql/updates/world/2013_06_28_00_world_spell_misc_434.sql +++ /dev/null @@ -1,11 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id` IN (34497,34498,34499); -INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES -(34497, 'spell_hun_thrill_of_the_hunt'), -(34498, 'spell_hun_thrill_of_the_hunt'), -(34499, 'spell_hun_thrill_of_the_hunt'); - -DELETE FROM `spell_proc_event` WHERE `entry` IN (34497,34498,34499); -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(34497, 0, 9, 0x880, 0x88000000, 0, 0, 0, 0, 0, 0), -(34498, 0, 9, 0x880, 0x88000000, 0, 0, 0, 0, 0, 0), -(34499, 0, 9, 0x880, 0x88000000, 0, 0, 0, 0, 0, 0); diff --git a/sql/updates/world/2013_06_28_00_world_spell_proc_event_434.sql b/sql/updates/world/2013_06_28_00_world_spell_proc_event_434.sql deleted file mode 100644 index b5b690acad8..00000000000 --- a/sql/updates/world/2013_06_28_00_world_spell_proc_event_434.sql +++ /dev/null @@ -1,6 +0,0 @@ --- Shadow and Flame -DELETE FROM `spell_proc_event` WHERE `entry` IN (17793,17796,17801); -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(17793, 0, 5, 0x1, 0x40, 0, 0, 0, 0, 0, 0), -(17796, 0, 5, 0x1, 0x40, 0, 0, 0, 0, 0, 0), -(17801, 0, 5, 0x1, 0x40, 0, 0, 0, 0, 0, 0); diff --git a/sql/updates/world/2013_06_28_01_world_spell_misc_434.sql b/sql/updates/world/2013_06_28_01_world_spell_misc_434.sql deleted file mode 100644 index 2571007f65b..00000000000 --- a/sql/updates/world/2013_06_28_01_world_spell_misc_434.sql +++ /dev/null @@ -1,9 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `ScriptName`="spell_pal_eye_for_an_eye"; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(9799, "spell_pal_eye_for_an_eye"), -(25988, "spell_pal_eye_for_an_eye"); - -DELETE FROM `spell_proc_event` WHERE `entry` IN (9799,25988); -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(9799, 0, 0, 0, 0, 0, 0x10000, 0, 0, 0, 0), -(25988, 0, 0, 0, 0, 0, 0x10000, 0, 0, 0, 0); diff --git a/sql/updates/world/2013_06_28_02_world_spell_script_names_434.sql b/sql/updates/world/2013_06_28_02_world_spell_script_names_434.sql deleted file mode 100644 index b1547f873e7..00000000000 --- a/sql/updates/world/2013_06_28_02_world_spell_script_names_434.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `ScriptName`="spell_pri_renew"; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(139, "spell_pri_renew"); diff --git a/sql/updates/world/2013_06_29_00_world_phase_definitions_434.sql b/sql/updates/world/2013_06_29_00_world_phase_definitions_434.sql deleted file mode 100644 index c78620f72d1..00000000000 --- a/sql/updates/world/2013_06_29_00_world_phase_definitions_434.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `phase_definitions` - CHANGE COLUMN `phaseId` `phaseId` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `phasemask`; diff --git a/sql/updates/world/2013_07_06_00_world_spell_script_names.sql b/sql/updates/world/2013_07_06_00_world_spell_script_names.sql deleted file mode 100644 index 57633c16145..00000000000 --- a/sql/updates/world/2013_07_06_00_world_spell_script_names.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM spell_script_names WHERE spell_id IN (527, -527, 97690, 97691); -DELETE FROM spell_script_names WHERE ScriptName="spell_pri_dispel_magic"; -INSERT INTO spell_script_names (spell_id, ScriptName) VALUES -(527, "spell_pri_dispel_magic"); diff --git a/sql/updates/world/2013_07_17_00_world_spell_script_names_434.sql b/sql/updates/world/2013_07_17_00_world_spell_script_names_434.sql deleted file mode 100644 index dd5c637d458..00000000000 --- a/sql/updates/world/2013_07_17_00_world_spell_script_names_434.sql +++ /dev/null @@ -1,9 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id` IN (29834,29838,29841,29842,42770,42771); -INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES --- Warrior -(29834,'spell_warr_second_wind_proc'), -(29838,'spell_warr_second_wind_proc'), -(29841,'spell_warr_second_wind_trigger'), -(29842,'spell_warr_second_wind_trigger'), --- Utgarde Keep -(42770,'spell_uk_second_wind_proc'); |