DB/Misc: Add data for gnome hunter

By Regigicas and funjoker
Closes #18052

1 files changed, 129 insertions, 0 deletions

diff --git a/sql/updates/world/master/2016_11_01_00_world.sql b/sql/updates/world/master/2016_11_01_00_world.sql
new file mode 100644
index 00000000000..c9d66aa0152
--- /dev/null
+++ b/sql/updates/world/master/2016_11_01_00_world.sql
@@ -0,0 +1,129 @@
+--
+DELETE FROM `playercreateinfo_cast_spell` WHERE `racemask` = 64 AND `classMask` = 4;
+INSERT INTO `playercreateinfo_cast_spell` (`racemask`,`classmask`,`spell`,`note`) VALUES
+(64, 4, 153724, 'Gnome - Hunter - Mechanical Bunny');
+
+DELETE FROM `playercreateinfo` WHERE `race` = 7 AND `class` = 3;
+INSERT INTO `playercreateinfo` (`race`,`class`,`map`,`zone`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES
+(7, 3, 0, 5495, -4983.42, 877.7, 274.31, 3.06393);
+
+DELETE FROM `playercreateinfo_action` WHERE `race` = 7 AND `class` = 3;
+INSERT INTO `playercreateinfo_action` (race`,`class`,`button`,`action`,`type`) VALUES
+(7, 3, 0, 193455, 0),
+(7, 3, 9, 20589, 0),
+(7, 3, 10, 982, 0),
+(7, 3, 11, 9, 48);
+
+DELETE FROM `player_levelstats` WHERE `race` = 7 AND `class` = 3;
+INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`) VALUES
+(7, 3, 1, 5, 17, 11, 13),
+(7, 3, 2, 7, 19, 12, 14),
+(7, 3, 3, 7, 20, 12, 14),
+(7, 3, 4, 8, 21, 13, 15),
+(7, 3, 5, 8, 21, 13, 15),
+(7, 3, 6, 8, 21, 13, 15),
+(7, 3, 7, 9, 22, 14, 16),
+(7, 3, 8, 10, 23, 15, 17),
+(7, 3, 9, 11, 25, 16, 18),
+(7, 3, 10, 11, 26, 17, 19),
+(7, 3, 11, 13, 28, 18, 20),
+(7, 3, 12, 15, 31, 20, 22),
+(7, 3, 13, 16, 33, 22, 23),
+(7, 3, 14, 18, 36, 24, 25),
+(7, 3, 15, 20, 38, 25, 27),
+(7, 3, 16, 22, 41, 27, 28),
+(7, 3, 17, 24, 43, 29, 30),
+(7, 3, 18, 26, 47, 31, 32),
+(7, 3, 19, 28, 49, 33, 34),
+(7, 3, 20, 29, 52, 35, 36),
+(7, 3, 21, 31, 54, 36, 37),
+(7, 3, 22, 33, 58, 39, 40),
+(7, 3, 23, 35, 60, 41, 41),
+(7, 3, 24, 38, 64, 43, 44),
+(7, 3, 25, 39, 67, 45, 46),
+(7, 3, 26, 41, 69, 47, 47),
+(7, 3, 27, 43, 71, 48, 49),
+(7, 3, 28, 46, 75, 51, 51),
+(7, 3, 29, 47, 78, 53, 53),
+(7, 3, 30, 49, 80, 54, 55),
+(7, 3, 31, 50, 83, 56, 56),
+(7, 3, 32, 52, 85, 58, 58),
+(7, 3, 33, 54, 88, 59, 60),
+(7, 3, 34, 57, 92, 63, 63),
+(7, 3, 35, 59, 95, 64, 64),
+(7, 3, 36, 61, 97, 66, 66),
+(7, 3, 37, 63, 100, 68, 68),
+(7, 3, 38, 64, 102, 70, 69),
+(7, 3, 39, 66, 105, 71, 71),
+(7, 3, 40, 69, 108, 74, 73),
+(7, 3, 41, 70, 111, 76, 75),
+(7, 3, 42, 72, 113, 77, 77),
+(7, 3, 43, 74, 116, 79, 78),
+(7, 3, 44, 75, 118, 81, 80),
+(7, 3, 45, 78, 122, 83, 82),
+(7, 3, 46, 80, 126, 86, 85),
+(7, 3, 47, 82, 128, 88, 87),
+(7, 3, 48, 84, 131, 89, 88),
+(7, 3, 49, 85, 133, 91, 90),
+(7, 3, 50, 87, 136, 93, 91),
+(7, 3, 51, 89, 138, 94, 93),
+(7, 3, 52, 91, 142, 97, 96),
+(7, 3, 53, 93, 144, 99, 97),
+(7, 3, 54, 95, 147, 100, 99),
+(7, 3, 55, 97, 149, 102, 100),
+(7, 3, 56, 99, 153, 105, 103),
+(7, 3, 57, 101, 155, 106, 105),
+(7, 3, 58, 102, 158, 108, 106),
+(7, 3, 59, 104, 160, 110, 108),
+(7, 3, 60, 106, 164, 112, 110),
+(7, 3, 61, 114, 175, 120, 118),
+(7, 3, 62, 122, 186, 128, 125),
+(7, 3, 63, 130, 197, 135, 132),
+(7, 3, 64, 131, 200, 137, 134),
+(7, 3, 65, 134, 203, 140, 137),
+(7, 3, 66, 136, 206, 141, 138),
+(7, 3, 67, 137, 208, 143, 140),
+(7, 3, 68, 139, 211, 145, 141),
+(7, 3, 69, 141, 213, 146, 143),
+(7, 3, 70, 148, 224, 154, 150),
+(7, 3, 71, 153, 230, 158, 155),
+(7, 3, 72, 160, 242, 166, 162),
+(7, 3, 73, 168, 253, 174, 169),
+(7, 3, 74, 170, 255, 175, 171),
+(7, 3, 75, 171, 258, 177, 173),
+(7, 3, 76, 173, 260, 179, 174),
+(7, 3, 77, 175, 264, 181, 177),
+(7, 3, 78, 177, 266, 183, 178),
+(7, 3, 79, 179, 270, 186, 181),
+(7, 3, 80, 183, 275, 189, 184),
+(7, 3, 81, 191, 286, 197, 191),
+(7, 3, 82, 198, 297, 204, 199),
+(7, 3, 83, 203, 303, 209, 203),
+(7, 3, 84, 204, 306, 210, 205),
+(7, 3, 85, 206, 308, 212, 206),
+(7, 3, 86, 214, 319, 220, 214),
+(7, 3, 87, 221, 330, 227, 221),
+(7, 3, 88, 229, 341, 235, 228),
+(7, 3, 89, 237, 352, 243, 236),
+(7, 3, 90, 244, 363, 250, 243),
+(7, 3, 91, 336, 497, 343, 331),
+(7, 3, 92, 398, 587, 405, 391),
+(7, 3, 93, 467, 686, 474, 458),
+(7, 3, 94, 548, 803, 555, 535),
+(7, 3, 95, 644, 943, 652, 628),
+(7, 3, 96, 758, 1109, 767, 739),
+(7, 3, 97, 789, 1153, 797, 768),
+(7, 3, 98, 820, 1198, 828, 798),
+(7, 3, 99, 850, 1242, 859, 827),
+(7, 3, 100, 881, 1286, 890, 857),
+(7, 3, 101, 2413, 3507, 2429, 2334),
+(7, 3, 102, 2764, 4014, 2781, 2672),
+(7, 3, 103, 3162, 4592, 3182, 3056),
+(7, 3, 104, 3585, 5205, 3606, 3463),
+(7, 3, 105, 3939, 5718, 3962, 3805),
+(7, 3, 106, 4321, 6272, 4346, 4173),
+(7, 3, 107, 4708, 6832, 4734, 4546),
+(7, 3, 108, 5166, 7495, 5194, 4987),
+(7, 3, 109, 5672, 8230, 5703, 5475),
+(7, 3, 110, 6226, 9032, 6259, 6009);
+--