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/old | |
| parent | b27777fa3e875ad6998fc853ece143dedccd746f (diff) | |
TDB 424.05
Diffstat (limited to 'sql/old')
28 files changed, 1296 insertions, 0 deletions
diff --git a/sql/old/4.3.4/2013_01_26_01_world_misc_434.sql b/sql/old/4.3.4/2013_01_26_01_world_misc_434.sql new file mode 100644 index 00000000000..2abe6090c3f --- /dev/null +++ b/sql/old/4.3.4/2013_01_26_01_world_misc_434.sql @@ -0,0 +1,7 @@ +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/old/4.3.4/2013_01_26_01_world_spell_script_names_434.sql b/sql/old/4.3.4/2013_01_26_01_world_spell_script_names_434.sql new file mode 100644 index 00000000000..89b70f0980a --- /dev/null +++ b/sql/old/4.3.4/2013_01_26_01_world_spell_script_names_434.sql @@ -0,0 +1,5 @@ +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/old/4.3.4/2013_02_27_00_world_creature_summon_groups_434.sql b/sql/old/4.3.4/2013_02_27_00_world_creature_summon_groups_434.sql new file mode 100644 index 00000000000..4cdd26a83e8 --- /dev/null +++ b/sql/old/4.3.4/2013_02_27_00_world_creature_summon_groups_434.sql @@ -0,0 +1,10 @@ +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/old/4.3.4/2013_03_15_01_world_keychain_db2_434.sql b/sql/old/4.3.4/2013_03_15_01_world_keychain_db2_434.sql new file mode 100644 index 00000000000..fb8364d47d0 --- /dev/null +++ b/sql/old/4.3.4/2013_03_15_01_world_keychain_db2_434.sql @@ -0,0 +1,43 @@ +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/old/4.3.4/2013_03_23_00_world_playercreateinfo_spell_434.sql b/sql/old/4.3.4/2013_03_23_00_world_playercreateinfo_spell_434.sql new file mode 100644 index 00000000000..667022eaba9 --- /dev/null +++ b/sql/old/4.3.4/2013_03_23_00_world_playercreateinfo_spell_434.sql @@ -0,0 +1,777 @@ +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/old/4.3.4/2013_04_03_00_world_playercreateinfo_button_434.sql b/sql/old/4.3.4/2013_04_03_00_world_playercreateinfo_button_434.sql new file mode 100644 index 00000000000..b7281422712 --- /dev/null +++ b/sql/old/4.3.4/2013_04_03_00_world_playercreateinfo_button_434.sql @@ -0,0 +1,4 @@ +-- 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/old/4.3.4/2013_05_09_00_world_spell_dbc_434.sql b/sql/old/4.3.4/2013_05_09_00_world_spell_dbc_434.sql new file mode 100644 index 00000000000..11fc9e7ed51 --- /dev/null +++ b/sql/old/4.3.4/2013_05_09_00_world_spell_dbc_434.sql @@ -0,0 +1,138 @@ +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/old/4.3.4/2013_05_09_01_world_spelleffect_dbc_434.sql b/sql/old/4.3.4/2013_05_09_01_world_spelleffect_dbc_434.sql new file mode 100644 index 00000000000..a5446589859 --- /dev/null +++ b/sql/old/4.3.4/2013_05_09_01_world_spelleffect_dbc_434.sql @@ -0,0 +1,105 @@ +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/old/4.3.4/2013_05_11_00_world_spelleffect_dbc_434.sql b/sql/old/4.3.4/2013_05_11_00_world_spelleffect_dbc_434.sql new file mode 100644 index 00000000000..31a7b7b5b89 --- /dev/null +++ b/sql/old/4.3.4/2013_05_11_00_world_spelleffect_dbc_434.sql @@ -0,0 +1,75 @@ +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/old/4.3.4/2013_05_12_00_world_spell_learn_spell_434.sql b/sql/old/4.3.4/2013_05_12_00_world_spell_learn_spell_434.sql new file mode 100644 index 00000000000..04daf03b95e --- /dev/null +++ b/sql/old/4.3.4/2013_05_12_00_world_spell_learn_spell_434.sql @@ -0,0 +1,16 @@ +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/old/4.3.4/2013_05_21_00_world_trinity_string_434.sql b/sql/old/4.3.4/2013_05_21_00_world_trinity_string_434.sql new file mode 100644 index 00000000000..ce82a4d0972 --- /dev/null +++ b/sql/old/4.3.4/2013_05_21_00_world_trinity_string_434.sql @@ -0,0 +1,4 @@ +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/old/4.3.4/2013_06_14_00_world_zul_aman_434.sql b/sql/old/4.3.4/2013_06_14_00_world_zul_aman_434.sql new file mode 100644 index 00000000000..23334cd1d06 --- /dev/null +++ b/sql/old/4.3.4/2013_06_14_00_world_zul_aman_434.sql @@ -0,0 +1,18 @@ +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/old/4.3.4/2013_06_16_00_world_spell_misc_434.sql b/sql/old/4.3.4/2013_06_16_00_world_spell_misc_434.sql new file mode 100644 index 00000000000..917c05bfad8 --- /dev/null +++ b/sql/old/4.3.4/2013_06_16_00_world_spell_misc_434.sql @@ -0,0 +1,11 @@ +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/old/4.3.4/2013_06_16_00_world_spell_script_names_434.sql b/sql/old/4.3.4/2013_06_16_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..de5fa8f4956 --- /dev/null +++ b/sql/old/4.3.4/2013_06_16_00_world_spell_script_names_434.sql @@ -0,0 +1,5 @@ +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/old/4.3.4/2013_06_18_00_world_spell_script_names_434.sql b/sql/old/4.3.4/2013_06_18_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..7bb30c6b4b7 --- /dev/null +++ b/sql/old/4.3.4/2013_06_18_00_world_spell_script_names_434.sql @@ -0,0 +1,4 @@ +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/old/4.3.4/2013_06_19_00_characters_achievements_progress.sql b/sql/old/4.3.4/2013_06_19_00_characters_achievements_progress.sql new file mode 100644 index 00000000000..bf281aa04c7 --- /dev/null +++ b/sql/old/4.3.4/2013_06_19_00_characters_achievements_progress.sql @@ -0,0 +1,2 @@ +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/old/4.3.4/2013_06_23_00_world_spell_script_names_434.sql b/sql/old/4.3.4/2013_06_23_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..33b0e8981b9 --- /dev/null +++ b/sql/old/4.3.4/2013_06_23_00_world_spell_script_names_434.sql @@ -0,0 +1 @@ +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/old/4.3.4/2013_06_24_00_world_spell_script_names_434.sql b/sql/old/4.3.4/2013_06_24_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..577c0e524ab --- /dev/null +++ b/sql/old/4.3.4/2013_06_24_00_world_spell_script_names_434.sql @@ -0,0 +1,3 @@ +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/old/4.3.4/2013_06_25_00_world_spell_script_names_434.sql b/sql/old/4.3.4/2013_06_25_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..437f0c3702c --- /dev/null +++ b/sql/old/4.3.4/2013_06_25_00_world_spell_script_names_434.sql @@ -0,0 +1,4 @@ +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/old/4.3.4/2013_06_26_00_world_spell_misc_434.sql b/sql/old/4.3.4/2013_06_26_00_world_spell_misc_434.sql new file mode 100644 index 00000000000..6a0e79f1d4a --- /dev/null +++ b/sql/old/4.3.4/2013_06_26_00_world_spell_misc_434.sql @@ -0,0 +1,9 @@ +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/old/4.3.4/2013_06_27_00_world_spell_misc_434.sql b/sql/old/4.3.4/2013_06_27_00_world_spell_misc_434.sql new file mode 100644 index 00000000000..17055afe2bf --- /dev/null +++ b/sql/old/4.3.4/2013_06_27_00_world_spell_misc_434.sql @@ -0,0 +1,11 @@ +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/old/4.3.4/2013_06_28_00_world_spell_misc_434.sql b/sql/old/4.3.4/2013_06_28_00_world_spell_misc_434.sql new file mode 100644 index 00000000000..3f1cac1a4ed --- /dev/null +++ b/sql/old/4.3.4/2013_06_28_00_world_spell_misc_434.sql @@ -0,0 +1,11 @@ +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/old/4.3.4/2013_06_28_00_world_spell_proc_event_434.sql b/sql/old/4.3.4/2013_06_28_00_world_spell_proc_event_434.sql new file mode 100644 index 00000000000..b5b690acad8 --- /dev/null +++ b/sql/old/4.3.4/2013_06_28_00_world_spell_proc_event_434.sql @@ -0,0 +1,6 @@ +-- 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/old/4.3.4/2013_06_28_01_world_spell_misc_434.sql b/sql/old/4.3.4/2013_06_28_01_world_spell_misc_434.sql new file mode 100644 index 00000000000..2571007f65b --- /dev/null +++ b/sql/old/4.3.4/2013_06_28_01_world_spell_misc_434.sql @@ -0,0 +1,9 @@ +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/old/4.3.4/2013_06_28_02_world_spell_script_names_434.sql b/sql/old/4.3.4/2013_06_28_02_world_spell_script_names_434.sql new file mode 100644 index 00000000000..b1547f873e7 --- /dev/null +++ b/sql/old/4.3.4/2013_06_28_02_world_spell_script_names_434.sql @@ -0,0 +1,3 @@ +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/old/4.3.4/2013_06_29_00_world_phase_definitions_434.sql b/sql/old/4.3.4/2013_06_29_00_world_phase_definitions_434.sql new file mode 100644 index 00000000000..c78620f72d1 --- /dev/null +++ b/sql/old/4.3.4/2013_06_29_00_world_phase_definitions_434.sql @@ -0,0 +1,2 @@ +ALTER TABLE `phase_definitions` + CHANGE COLUMN `phaseId` `phaseId` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `phasemask`; diff --git a/sql/old/4.3.4/2013_07_06_00_world_spell_script_names.sql b/sql/old/4.3.4/2013_07_06_00_world_spell_script_names.sql new file mode 100644 index 00000000000..57633c16145 --- /dev/null +++ b/sql/old/4.3.4/2013_07_06_00_world_spell_script_names.sql @@ -0,0 +1,4 @@ +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/old/4.3.4/2013_07_17_00_world_spell_script_names_434.sql b/sql/old/4.3.4/2013_07_17_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..dd5c637d458 --- /dev/null +++ b/sql/old/4.3.4/2013_07_17_00_world_spell_script_names_434.sql @@ -0,0 +1,9 @@ +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'); |