INSERT INTO `game_event` VALUES
(121, '2007-03-30 22:00:00', '2020-12-31 00:00:00', 1440, 480, 'Stormwind Nights');

INSERT INTO `game_event_creature` VALUES
(300023, 121),
(300024, 121),
(300025, 121),
(300026, 121),
(300027, 121),
(300028, 121),
(300029, 121),
(300030, 121),
(300031, 121),
(300032, 121),
(300033, 121),
(300034, 121),
(300035, 121),
(300036, 121),
(300037, 121);

INSERT INTO `creature_template` VALUES
(14, 0, 1931, 1931, 1931, 1931, 'Elenium', 'Hire mounts', NULL, 59, 61, 6700, 24000, 5598, 5875, 20, 35, 35, 2, 1.48, 0, 0, 170, 182, 0, 1235, 1400, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, 0, ''),
(4, 0, 18, 18, 18, 18, 'Germo Trully', 'Hire mounts', NULL, 59, 61, 6700, 24000, 5598, 5875, 20, 35, 35, 2, 1.48, 0, 0, 170, 182, 0, 1235, 1400, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, 0, ''),
(5, 0, 13410, 13410, 13410, 13410, 'Gygyr Bagyr', 'Hire mounts', NULL, 59, 61, 6700, 24000, 5598, 5875, 20, 35, 35, 2, 1.48, 0, 0, 170, 182, 0, 1235, 1400, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, 0, ''),
(7, 0, 5525, 18748, 17895, 20711, 'Besdoban Durnoye', 'Arena-Honor Exchange', NULL, 59, 61, 6700, 24000, 5598, 5875, 20, 35, 35, 1, 1.48, 0, 0, 170, 182, 0, 1235, 1400, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, 0, 'npc_arena_honor'),
(8, 0, 9257, 9257, 9257, 9257, 'Durynda Baldara', 'Material Vendor', NULL, 10, 10, 1000, 1000, 0, 0, 1, 11, 11, 4224, 0.96, 0, 0, 12, 15, 0, 47, 1910, 2101, 0, 0, 0, 0, 0, 0, 0, 16.808, 23.111, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 494, 0, 2, ''),
(9, 0, 1295, 1295, 1295, 1295, 'Berdanka Karamultuk', 'Material Vendor', NULL, 10, 10, 1000, 1000, 0, 0, 1, 11, 11, 4224, 0.96, 0, 0, 12, 15, 0, 47, 1910, 2101, 0, 0, 0, 0, 0, 0, 0, 16.808, 23.111, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 494, 0, 2, ''),
(10, 0, 1296, 1296, 1296, 1296, 'Bezmozga Noshkura', 'Material Vendor', NULL, 10, 10, 1000, 1000, 0, 0, 1, 11, 11, 4224, 0.96, 0, 0, 12, 15, 0, 47, 1910, 2101, 0, 0, 0, 0, 0, 0, 0, 16.808, 23.111, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 494, 0, 2, ''),
(11, 0, 18, 18, 18, 18, 'Na Port-a-Chil', 'Teleport Guild', NULL, 52, 82, 6700, 24000, 5598, 5875, 20, 35, 35, 1, 1.48, 0, 0, 170, 182, 0, 1235, 1400, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, 0, 'teleguy'),
(12, 0, 14615, 14615, 14615, 14615, 'Alisa', '', NULL, 59, 61, 6700, 24000, 0, 0, 1, 11, 11, 4224, 0.96, 0, 0, 12, 15, 0, 47, 1910, 2101, 0, 0, 0, 0, 0, 0, 0, 16.808, 23.111, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 494, 0, 2, ''),
(13, 0, 18748, 5525, 20711, 17895, 'Bruenno Guilde', 'Guildhouse Keeper', NULL, 52, 82, 6700, 24000, 5598, 5875, 20, 35, 35, 1, 1.48, 0, 0, 170, 182, 0, 1235, 1400, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, 0, 'guildmaster');

INSERT INTO `locales_creature` VALUES 
('14', '', '', '', '', '', '', '', 'Элениум', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Наемные тигры'),
('4', '', '', '', '', '', '', '', 'Гермо Трулли', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Наемные лошади'),
('5', '', '', '', '', '', '', '', 'Гыгыр Багыр', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Наемные волки'),
('7', '', '', '', '', '', '', '', 'Бездобан Дурнойе', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Обмен Арены и Хонора'),
('8', '', '', '', '', '', '', '', 'Дурында Балдара', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Продажа материалов'),
('9', '', '', '', '', '', '', '', 'Берданка Карамультук', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Продажа материалов'),
('10', '', '', '', '', '', '', '', 'Безмозга Ношкура', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Продажа материалов'),
('11', '', '', '', '', '', '', '', 'На Порт-а-Чил', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Телепортовая Гильдия'),
('12', '', '', '', '', '', '', '', 'Алиса', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('13', '', '', '', '', '', '', '', 'Брюенно Гвильде', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Хранитель Гильдейских Домов');

INSERT INTO `npc_vendor` VALUES
(8, 2320, 0, 0, 0),
(8, 2321, 0, 0, 0),
(8, 2325, 0, 0, 0),
(8, 2604, 0, 0, 0),
(8, 2605, 0, 0, 0),
(8, 2996, 0, 0, 0),
(8, 2997, 0, 0, 0),
(8, 4291, 0, 0, 0),
(8, 4305, 0, 0, 0),
(8, 4339, 0, 0, 0),
(8, 4340, 0, 0, 0),
(8, 4341, 0, 0, 0),
(8, 4342, 0, 0, 0),
(8, 6260, 0, 0, 0),
(8, 6261, 0, 0, 0),
(8, 8343, 0, 0, 0),
(8, 10290, 0, 0, 0),
(8, 14048, 0, 0, 0),
(8, 14341, 0, 0, 0),
(8, 14342, 0, 0, 0),
(8, 21840, 0, 0, 0),
(8, 21842, 0, 0, 0),
(8, 21844, 0, 0, 0),
(8, 21845, 0, 0, 0),
(8, 24271, 0, 0, 0),
(8, 24272, 0, 0, 0),
(8, 24288, 0, 0, 0),
(9, 2840, 0, 0, 0),
(9, 2841, 0, 0, 0),
(9, 2842, 0, 0, 0),
(9, 3575, 0, 0, 0),
(9, 3576, 0, 0, 0),
(9, 3577, 0, 0, 0),
(9, 3859, 0, 0, 0),
(9, 3860, 0, 0, 0),
(9, 6037, 0, 0, 0),
(9, 11371, 0, 0, 0),
(9, 12359, 0, 0, 0),
(9, 12360, 0, 0, 0),
(9, 23445, 0, 0, 0),
(9, 23446, 0, 0, 0),
(9, 23447, 0, 0, 0),
(9, 23448, 0, 0, 0),
(9, 23449, 0, 0, 0),
(10, 2318, 0, 0, 0),
(10, 2319, 0, 0, 0),
(10, 4231, 0, 0, 0),
(10, 4232, 0, 0, 0),
(10, 4233, 0, 0, 0),
(10, 4234, 0, 0, 0),
(10, 4235, 0, 0, 0),
(10, 4236, 0, 0, 0),
(10, 4289, 0, 0, 0),
(10, 4304, 0, 0, 0),
(10, 5082, 0, 0, 0),
(10, 8170, 0, 0, 0),
(10, 8172, 0, 0, 0),
(10, 12810, 0, 0, 0),
(10, 15407, 0, 0, 0),
(10, 17012, 0, 0, 0),
(10, 21881, 0, 0, 0),
(10, 21884, 0, 0, 0),
(10, 21885, 0, 0, 0),
(10, 21886, 0, 0, 0),
(10, 21887, 0, 0, 0),
(10, 22451, 0, 0, 0),
(10, 22452, 0, 0, 0),
(10, 22456, 0, 0, 0),
(10, 23571, 0, 0, 0),
(10, 23572, 0, 0, 0),
(10, 23793, 0, 0, 0);

INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(300023, 910, 0, 1, 0, 50, -8527.51, 577.311, 101.813, 2.0899, 1296, 0, 0, 679, 1707, 0, 2),
(300024, 910, 0, 1, 0, 50, -8526.9, 609.09, 102.877, 2.54545, 1296, 0, 0, 679, 1707, 0, 2),
(300025, 2482, 0, 1, 0, 0, -8545.68, 547.894, 102.734, 0.684034, 2064, 0, 0, 2700, 0, 0, 0),
(300026, 2839, 0, 1, 0, 5, -8541.8, 543.105, 102.734, 1.2024, 1968, 0, 0, 1900, 0, 0, 0),
(300027, 2845, 0, 1, 0, 494, -8546.7, 543.399, 102.734, 0.841121, 2016, 0, 0, 2000, 0, 0, 0),
(300028, 8, 0, 1, 0, 494, -8543.78, 555.173, 109.78, 4.7006, 480, 0, 0, 1000, 0, 0, 0),
(300029, 910, 0, 1, 0, 50, -8517.17, 590.424, 101.813, 2.44334, 1296, 0, 0, 679, 1707, 0, 2),
(300030, 215, 0, 1, 0, 434, -8535.93, 597.369, 101.813, 5.5339, 1200, 0, 0, 662, 686, 0, 2),
(300031, 215, 0, 1, 0, 434, -8527.13, 601.437, 101.813, 4.43826, 1200, 0, 0, 662, 686, 0, 2),
(300032, 909, 0, 1, 0, 265, -8543.92, 566.287, 101.813, 6.16614, 1248, 0, 0, 732, 660, 0, 2),
(300033, 7056, 0, 1, 0, 799, -8545.22, 579.78, 101.928, 0.99429, 1152, 0, 0, 660, 0, 0, 2),
(300034, 7052, 0, 1, 0, 828, -8518.75, 606.714, 101.812, 4.04953, 1104, 0, 0, 622, 0, 0, 2),
(300035, 2810, 0, 1, 0, 476, -8539.41, 542.703, 109.78, 6.18184, 1680, 0, 0, 1300, 0, 0, 0),
(300036, 9, 0, 1, 0, 494, -8536.37, 552.375, 109.78, 4.31967, 480, 0, 0, 1000, 0, 0, 0),
(300037, 10, 0, 1, 0, 494, -8543.6, 548.365, 109.781, 1.28962, 480, 0, 0, 1000, 0, 0, 0);


INSERT INTO `creature_movement` VALUES
(300023, 1, -8527.28, 577.418, 101.813, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 3.43106, 0, 0),
(300023, 2, -8529.14, 578.581, 101.813, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 2.58153, 0, 0),
(300023, 3, -8528.85, 576.155, 101.812, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 4.69338, 0, 0),
(300024, 1, -8526.7, 609.092, 102.878, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 2.22154, 0, 0),
(300024, 2, -8533.32, 617.818, 102.878, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 2.20235, 0, 0),
(300029, 1, -8517.41, 590.477, 101.813, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 2.77787, 0, 0),
(300029, 2, -8519.07, 590.861, 101.813, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 2.28831, 0, 0),
(300029, 3, -8527.33, 597.848, 101.812, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 2.3747, 0, 0),
(300029, 4, -8518.64, 598.904, 101.399, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0.133262, 0, 0),
(300029, 5, -8520.94, 592.385, 101.813, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 5.66291, 0, 0),
(300029, 6, -8518.04, 590.063, 101.813, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 5.54291, 0, 0),
(300030, 1, -8535.72, 597.107, 101.812, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 3.91582, 0, 0),
(300030, 2, -8538.88, 593.782, 101.812, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 4.09341, 0, 0),
(300031, 1, -8527.29, 601.286, 101.812, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 1.11763, 0, 0),
(300031, 2, -8526.57, 599.567, 101.812, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 5.23137, 0, 0),
(300031, 3, -8524.5, 602.242, 101.812, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0.877651, 0, 0),
(300032, 1, -8543.93, 566.402, 101.813, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0.032904, 0, 0),
(300032, 2, -8531.48, 565.783, 101.813, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 6.22969, 0, 0),
(300032, 3, -8536.8, 571.874, 101.399, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 2.25994, 0, 0),
(300033, 1, -8544.91, 579.643, 102.015, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0.791248, 0, 0),
(300033, 2, -8538.29, 587.929, 102.179, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0.90644, 0, 0),
(300033, 3, -8535.57, 577.485, 101.4, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 5.23137, 0, 0),
(300034, 1, -8518.77, 606.56, 101.813, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 4.01269, 0, 0),
(300034, 2, -8527.31, 596.611, 101.399, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 3.97429, 0, 0),
(300034, 3, -8541.4, 576.336, 101.813, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 4.12309, 0, 0),
(300034, 4, -8541.27, 566.94, 101.813, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 4.84303, 0, 0),
(300034, 5, -8530, 565.737, 101.813, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 6.11974, 0, 0),
(300034, 6, -8527.76, 575.984, 101.813, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 1.33405, 0, 0),
(300034, 7, -8531.87, 580.009, 101.399, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 2.33718, 0, 0),
(300034, 8, -8523.29, 592.666, 101.4, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0.959675, 0, 0),
(300034, 9, -8510.33, 602.056, 101.813, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0.729292, 0, 0),
(300034, 10, -8513.83, 607.508, 101.813, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 3.24911, 0, 0);