DB/Misc: updated playercreateinfo_action and playercreateinfo_cast_spell for Cataclysm

1 files changed, 378 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2024_07_28_00_world.sql b/sql/updates/world/cata_classic/2024_07_28_00_world.sql
new file mode 100644
index 00000000000..084a371f980
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_07_28_00_world.sql
@@ -0,0 +1,378 @@
+DELETE FROM `playercreateinfo_action`;
+INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES 
+(1, 1, 72, 88163, 0),
+(1, 1, 73, 88161, 0),
+(1, 1, 81, 59752, 0),
+(1, 1, 84, 6603, 0),
+(1, 1, 96, 6603, 0),
+(1, 1, 108, 6603, 0),
+(1, 2, 0, 35395, 0),
+(1, 2, 9, 59752, 0),
+(1, 3, 0, 3044, 0),
+(1, 3, 9, 59752, 0),
+(1, 3, 10, 9, 48),
+(1, 3, 11, 982, 0),
+(1, 4, 0, 1752, 0),
+(1, 4, 9, 59752, 0),
+(1, 5, 0, 585, 0),
+(1, 5, 9, 59752, 0),
+(1, 6, 0, 6603, 0),
+(1, 6, 1, 49576, 0),
+(1, 6, 2, 45477, 0),
+(1, 6, 3, 45462, 0),
+(1, 6, 4, 45902, 0),
+(1, 6, 5, 47541, 0),
+(1, 6, 11, 59752, 0),
+(1, 8, 0, 133, 0),
+(1, 8, 9, 59752, 0),
+(1, 9, 0, 686, 0),
+(1, 9, 9, 59752, 0),
+(1, 9, 10, 10, 48),
+(2, 1, 72, 88163, 0),
+(2, 1, 73, 88161, 0),
+(2, 1, 81, 20572, 0),
+(2, 1, 84, 6603, 0),
+(2, 1, 96, 6603, 0),
+(2, 1, 108, 6603, 0),
+(2, 3, 0, 3044, 0),
+(2, 3, 9, 20572, 0),
+(2, 3, 10, 9, 48),
+(2, 3, 11, 982, 0),
+(2, 4, 0, 1752, 0),
+(2, 4, 9, 20572, 0),
+(2, 6, 0, 6603, 0),
+(2, 6, 1, 49576, 0),
+(2, 6, 2, 45477, 0),
+(2, 6, 3, 45462, 0),
+(2, 6, 4, 45902, 0),
+(2, 6, 5, 47541, 0),
+(2, 6, 10, 20572, 0),
+(2, 7, 0, 403, 0),
+(2, 7, 9, 20572, 0),
+(2, 7, 72, 403, 0),
+(2, 8, 0, 133, 0),
+(2, 8, 9, 33702, 0),
+(2, 9, 0, 686, 0),
+(2, 9, 9, 33702, 0),
+(2, 9, 10, 10, 48),
+(3, 1, 72, 88163, 0),
+(3, 1, 73, 88161, 0),
+(3, 1, 81, 20594, 0),
+(3, 1, 84, 6603, 0),
+(3, 1, 96, 6603, 0),
+(3, 1, 108, 6603, 0),
+(3, 2, 0, 35395, 0),
+(3, 2, 9, 20594, 0),
+(3, 3, 0, 3044, 0),
+(3, 3, 9, 20594, 0),
+(3, 3, 10, 9, 48),
+(3, 3, 11, 982, 0),
+(3, 3, 75, 20594, 0),
+(3, 4, 0, 1752, 0),
+(3, 4, 9, 20594, 0),
+(3, 5, 0, 585, 0),
+(3, 5, 9, 20594, 0),
+(3, 6, 0, 6603, 0),
+(3, 6, 1, 49576, 0),
+(3, 6, 2, 45477, 0),
+(3, 6, 3, 45462, 0),
+(3, 6, 4, 45902, 0),
+(3, 6, 5, 47541, 0),
+(3, 7, 0, 6603, 0),
+(3, 7, 1, 403, 0),
+(3, 7, 9, 20594, 0),
+(3, 7, 72, 403, 0),
+(3, 8, 0, 133, 0),
+(3, 8, 9, 20594, 0),
+(3, 9, 0, 686, 0),
+(3, 9, 9, 20594, 0),
+(3, 9, 10, 10, 48),
+(4, 1, 72, 88163, 0),
+(4, 1, 73, 88161, 0),
+(4, 1, 81, 58984, 0),
+(4, 1, 84, 6603, 0),
+(4, 1, 96, 6603, 0),
+(4, 1, 108, 6603, 0),
+(4, 3, 0, 3044, 0),
+(4, 3, 9, 58984, 0),
+(4, 3, 10, 9, 48),
+(4, 3, 11, 982, 0),
+(4, 3, 81, 58984, 0),
+(4, 4, 0, 1752, 0),
+(4, 4, 9, 58984, 0),
+(4, 4, 81, 58984, 0),
+(4, 5, 0, 585, 0),
+(4, 5, 9, 58984, 0),
+(4, 5, 81, 58984, 0),
+(4, 6, 0, 6603, 0),
+(4, 6, 1, 49576, 0),
+(4, 6, 2, 45477, 0),
+(4, 6, 3, 45462, 0),
+(4, 6, 4, 45902, 0),
+(4, 6, 5, 47541, 0),
+(4, 6, 10, 58984, 0),
+(4, 6, 83, 58984, 0),
+(4, 8, 0, 133, 0),
+(4, 8, 9, 58984, 0),
+(4, 11, 0, 5176, 0),
+(4, 11, 9, 58984, 0),
+(4, 11, 72, 6603, 0),
+(4, 11, 74, 58984, 0),
+(4, 11, 84, 6603, 0),
+(4, 11, 96, 6603, 0),
+(4, 11, 108, 6603, 0),
+(5, 1, 72, 88163, 0),
+(5, 1, 73, 88161, 0),
+(5, 1, 81, 20577, 0),
+(5, 1, 84, 6603, 0),
+(5, 1, 96, 6603, 0),
+(5, 1, 108, 6603, 0),
+(5, 3, 0, 3044, 0),
+(5, 3, 9, 20577, 0),
+(5, 3, 10, 9, 48),
+(5, 3, 11, 982, 0),
+(5, 4, 0, 1752, 0),
+(5, 4, 9, 20577, 0),
+(5, 5, 0, 585, 0),
+(5, 5, 9, 20577, 0),
+(5, 6, 0, 6603, 0),
+(5, 6, 1, 49576, 0),
+(5, 6, 2, 45477, 0),
+(5, 6, 3, 45462, 0),
+(5, 6, 4, 45902, 0),
+(5, 6, 5, 47541, 0),
+(5, 6, 10, 20577, 0),
+(5, 8, 0, 133, 0),
+(5, 8, 9, 20577, 0),
+(5, 9, 0, 686, 0),
+(5, 9, 9, 20577, 0),
+(5, 9, 10, 10, 48),
+(6, 1, 72, 88163, 0),
+(6, 1, 73, 88161, 0),
+(6, 1, 81, 20549, 0),
+(6, 1, 84, 6603, 0),
+(6, 1, 96, 6603, 0),
+(6, 1, 108, 6603, 0),
+(6, 2, 0, 35395, 0),
+(6, 2, 9, 20549, 0),
+(6, 3, 0, 3044, 0),
+(6, 3, 9, 20549, 0),
+(6, 3, 10, 9, 48),
+(6, 3, 11, 982, 0),
+(6, 3, 75, 20549, 0),
+(6, 5, 0, 585, 0),
+(6, 5, 9, 20549, 0),
+(6, 6, 0, 6603, 0),
+(6, 6, 1, 49576, 0),
+(6, 6, 2, 45477, 0),
+(6, 6, 3, 45462, 0),
+(6, 6, 4, 45902, 0),
+(6, 6, 5, 47541, 0),
+(6, 6, 10, 20549, 0),
+(6, 6, 75, 20549, 0),
+(6, 7, 0, 403, 0),
+(6, 7, 9, 20549, 0),
+(6, 7, 75, 20549, 0),
+(6, 11, 0, 5176, 0),
+(6, 11, 9, 20549, 0),
+(6, 11, 72, 6603, 0),
+(6, 11, 75, 20549, 0),
+(6, 11, 84, 6603, 0),
+(6, 11, 96, 6603, 0),
+(6, 11, 108, 6603, 0),
+(7, 1, 72, 88163, 0),
+(7, 1, 73, 88161, 0),
+(7, 1, 84, 6603, 0),
+(7, 1, 96, 6603, 0),
+(7, 1, 108, 6603, 0),
+(7, 4, 0, 1752, 0),
+(7, 5, 0, 585, 0),
+(7, 6, 0, 6603, 0),
+(7, 6, 1, 49576, 0),
+(7, 6, 2, 45477, 0),
+(7, 6, 3, 45462, 0),
+(7, 6, 4, 45902, 0),
+(7, 6, 5, 47541, 0),
+(7, 6, 10, 20589, 0),
+(7, 6, 72, 6603, 0),
+(7, 6, 83, 117, 128),
+(7, 6, 84, 6603, 0),
+(7, 6, 96, 6603, 0),
+(7, 6, 108, 6603, 0),
+(7, 8, 0, 133, 0),
+(7, 9, 0, 686, 0),
+(7, 9, 10, 10, 48),
+(8, 1, 72, 88163, 0),
+(8, 1, 73, 88161, 0),
+(8, 1, 81, 26297, 0),
+(8, 1, 84, 6603, 0),
+(8, 1, 96, 6603, 0),
+(8, 1, 108, 6603, 0),
+(8, 3, 0, 3044, 0),
+(8, 3, 9, 26297, 0),
+(8, 3, 10, 9, 48),
+(8, 3, 11, 982, 0),
+(8, 4, 0, 1752, 0),
+(8, 4, 9, 26297, 0),
+(8, 4, 76, 26297, 0),
+(8, 5, 0, 585, 0),
+(8, 5, 9, 26297, 0),
+(8, 6, 0, 6603, 0),
+(8, 6, 1, 49576, 0),
+(8, 6, 2, 45477, 0),
+(8, 6, 3, 45462, 0),
+(8, 6, 4, 45902, 0),
+(8, 6, 5, 47541, 0),
+(8, 6, 10, 26297, 0),
+(8, 7, 0, 403, 0),
+(8, 7, 9, 26297, 0),
+(8, 7, 72, 403, 0),
+(8, 8, 0, 133, 0),
+(8, 8, 9, 26297, 0),
+(8, 9, 0, 686, 0),
+(8, 9, 9, 26297, 0),
+(8, 9, 10, 10, 48),
+(8, 11, 0, 5176, 0),
+(8, 11, 9, 26297, 0),
+(8, 11, 72, 6603, 0),
+(8, 11, 84, 6603, 0),
+(8, 11, 96, 6603, 0),
+(9, 1, 72, 88163, 0),
+(9, 1, 73, 88161, 0),
+(9, 1, 81, 69070, 0),
+(9, 1, 82, 69041, 0),
+(9, 3, 0, 3044, 0),
+(9, 3, 8, 982, 0),
+(9, 3, 9, 69070, 0),
+(9, 3, 10, 69041, 0),
+(9, 3, 11, 9, 48),
+(9, 4, 0, 1752, 0),
+(9, 4, 9, 69070, 0),
+(9, 4, 10, 69041, 0),
+(9, 5, 0, 585, 0),
+(9, 5, 9, 69070, 0),
+(9, 5, 10, 69041, 0),
+(9, 6, 0, 6603, 0),
+(9, 6, 1, 49576, 0),
+(9, 6, 2, 45477, 0),
+(9, 6, 3, 45462, 0),
+(9, 6, 4, 45902, 0),
+(9, 6, 5, 47541, 0),
+(9, 6, 9, 69070, 0),
+(9, 6, 10, 69041, 0),
+(9, 6, 11, 69046, 0),
+(9, 7, 0, 403, 0),
+(9, 7, 9, 69070, 0),
+(9, 7, 10, 69041, 0),
+(9, 7, 72, 403, 0),
+(9, 8, 0, 133, 0),
+(9, 8, 9, 69070, 0),
+(9, 8, 10, 69041, 0),
+(9, 9, 0, 686, 0),
+(9, 9, 9, 69070, 0),
+(9, 9, 10, 69041, 0),
+(9, 9, 11, 10, 48),
+(10, 1, 72, 88163, 0),
+(10, 1, 73, 88161, 0),
+(10, 1, 81, 69179, 0),
+(10, 2, 0, 35395, 0),
+(10, 2, 9, 28730, 0),
+(10, 3, 0, 3044, 0),
+(10, 3, 9, 80483, 0),
+(10, 3, 10, 9, 48),
+(10, 3, 11, 982, 0),
+(10, 4, 0, 1752, 0),
+(10, 4, 9, 25046, 0),
+(10, 5, 0, 585, 0),
+(10, 5, 9, 28730, 0),
+(10, 6, 0, 6603, 0),
+(10, 6, 1, 49576, 0),
+(10, 6, 2, 45477, 0),
+(10, 6, 3, 45462, 0),
+(10, 6, 4, 45902, 0),
+(10, 6, 5, 47541, 0),
+(10, 6, 6, 50613, 0),
+(10, 8, 0, 133, 0),
+(10, 8, 9, 28730, 0),
+(10, 9, 0, 686, 0),
+(10, 9, 9, 28730, 0),
+(10, 9, 10, 10, 48),
+(11, 1, 72, 88163, 0),
+(11, 1, 73, 88161, 0),
+(11, 1, 81, 28880, 0),
+(11, 1, 84, 6603, 0),
+(11, 1, 96, 6603, 0),
+(11, 1, 108, 6603, 0),
+(11, 2, 0, 35395, 0),
+(11, 2, 9, 59542, 0),
+(11, 2, 83, 4540, 128),
+(11, 3, 0, 3044, 0),
+(11, 3, 9, 59543, 0),
+(11, 3, 10, 9, 48),
+(11, 3, 11, 982, 0),
+(11, 3, 72, 6603, 0),
+(11, 3, 74, 75, 0),
+(11, 3, 82, 159, 128),
+(11, 3, 83, 4540, 128),
+(11, 5, 0, 585, 0),
+(11, 5, 9, 59544, 0),
+(11, 5, 83, 4540, 128),
+(11, 6, 0, 6603, 0),
+(11, 6, 1, 49576, 0),
+(11, 6, 2, 45477, 0),
+(11, 6, 3, 45462, 0),
+(11, 6, 4, 45902, 0),
+(11, 6, 5, 47541, 0),
+(11, 6, 10, 59545, 0),
+(11, 7, 0, 403, 0),
+(11, 7, 9, 59547, 0),
+(11, 8, 0, 133, 0),
+(11, 8, 9, 59548, 0),
+(11, 8, 83, 4540, 128),
+(22, 1, 72, 88163, 0),
+(22, 1, 73, 88161, 0),
+(22, 3, 0, 3044, 0),
+(22, 3, 10, 9, 48),
+(22, 3, 11, 982, 0),
+(22, 4, 0, 1752, 0),
+(22, 5, 0, 585, 0),
+(22, 6, 0, 6603, 0),
+(22, 6, 1, 49576, 0),
+(22, 6, 2, 45477, 0),
+(22, 6, 3, 45462, 0),
+(22, 6, 4, 45902, 0),
+(22, 6, 5, 47541, 0),
+(22, 6, 9, 68992, 0),
+(22, 6, 10, 68996, 0),
+(22, 6, 11, 87840, 0),
+(22, 8, 0, 133, 0),
+(22, 9, 0, 686, 0),
+(22, 9, 10, 10, 48),
+(22, 11, 0, 5176, 0),
+(22, 11, 72, 6603, 0),
+(22, 11, 84, 6603, 0),
+(22, 11, 96, 6603, 0);
+
+DELETE FROM `playercreateinfo_cast_spell`;
+INSERT INTO `playercreateinfo_cast_spell` (`racemask`, `classMask`,`spell`, `note`) VALUES 
+(0, 32, 48266, 'Death Knight - Frost Presence'),
+(0, 1, 2457, 'Warrior - Battle Stance'),
+(1, 4, 79597, 'Human - Hunter - Young Wolf'),
+(2, 4, 79598, 'Orc - Hunter - Young Boar'),
+(4, 4, 79593, 'Dwarf - Hunter - Young Boar'),
+(8, 4, 79602, 'Night Elf - Hunter - Young Boar'),
+(16, 4, 79600, 'Undead - Hunter - Young Widow'),
+(32, 4, 79603, 'Tauren - Hunter - Young Tallstrider'),
+(128, 4, 79599, 'Troll - Hunter - Young Raptor'),
+(256, 4, 79595, 'Goblin - Hunter - Young Crab'),
+(512, 4, 79594, 'Blood Elf - Hunter - Young Dragonhawk'),
+(1024, 4, 79601, 'Draenei - Hunter - Young Moth'),
+(2097152, 4, 79596, 'Worgen - Hunter - Young Mastiff'),
+(0, 256, 688, 'Warlock - Summon Imp'),
+(16, 925, 73523, 'Undead - Rigor Mortis'),
+(64, 256, 80653, 'Warlock - Gnome - Irradiated Aura'),
+(64, 128, 80653, 'Mage - Gnome - Irradiated Aura'),
+(64, 16, 80653, 'Priest - Gnome - Irradiated Aura'),
+(64, 8, 80653, 'Rogue - Gnome - Irradiated Aura'),
+(64, 1, 80653, 'Warrior - Gnome - Irradiated Aura'),
+(128, 1503, 71033, 'Troll - Calm of the Novice');