-- Делаем гуймэвент
UPDATE `game_event` SET `start_time` = '2007-08-04 21:00:00', `end_time` = '2020-12-30 22:00:00', `occurence` = 240, `length` = 120 WHERE `entry` = 16;
DELETE FROM `game_event_gameobject` WHERE abs(`event`) = 16;
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES
(9005108,16),
(9005107,16),
(9005109,16),
(9005118,16),
(9005138,16),
(9005156,16),
(9005384,16),
(9005385,16),
(9005387,16),
(9005388,16),
(9005390,16),
(9005395,16),
(9005400,16),
(9005401,16),
(9005402,16),
(9005463,16),
(9005506,16),
(9005507,16);
-- Спаун обьектов
REPLACE INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(9005091, 178204, 0, 1, 1, -14289.6, 530.86, 8.93508, 1.17141, 0, 0, 0.552789, 0.833322, 25, 0, 1),
(9005107, 178204, 0, 1, 1, -13211.9, 262.525, 21.7572, 6.06836, 0, 0, 0.107208, -0.994237, 25, 0, 1),
(9005109, 178204, 0, 1, 1, -13209.4, 262.987, 23.8573, 0.181011, 0, 0, 0.090382, 0.995907, 25, 0, 1),
(9005118, 178204, 0, 1, 1, -13206.8, 263.558, 24.8572, 0.694823, 0, 0, 0.340465, 0.940257, 25, 0, 1),
(9005138, 178204, 0, 1, 1, -13205.7, 265.691, 25.8578, 0.998675, 0, 0, 0.478844, 0.8779, 25, 0, 1),
(9005156, 178204, 0, 1, 1, -13204.8, 270.063, 26.8577, 1.469, 0, 0, 0.670217, 0.742165, 25, 0, 1),
(9005384, 178204, 0, 1, 1, -13204.8, 272.51, 27.6039, 1.53978, 0, 0, 0.696057, 0.717987, 25, 0, 1),
(9005385, 178204, 0, 1, 1, -13208.2, 276.082, 28.1808, 2.299, 0, 0, 0.91256, 0.408943, 25, 0, 1),
(9005387, 178204, 0, 1, 1, -13210.2, 262.448, 33.6787, 3.82536, 0, 0, 0.942124, -0.335264, 25, 0, 1),
(9005388, 178204, 0, 1, 1, -13213.6, 270.051, 30.8941, 4.86445, 0, 0, 0.651356, -0.758772, 25, 0, 1),
(9005390, 178204, 0, 1, 1, -13214.2, 266.448, 31.6787, 4.88017, 0, 0, 0.64537, -0.76387, 25, 0, 1),
(9005395, 178204, 0, 1, 1, -13212.9, 261.961, 32.603, 5.07495, 0, 0, 0.568036, -0.823004, 25, 0, 1),
(9005400, 178204, 0, 1, 1, -13208.8, 266.624, 35.031, 1.25794, 0, 0, 0.588312, 0.808634, 25, 0, 1),
(9005401, 178204, 0, 1, 1, -13207.3, 271.298, 36.0989, 1.25794, 0, 0, 0.588312, 0.808634, 25, 0, 1),
(9005402, 178204, 0, 1, 1, -13205.8, 276.495, 37.4105, 1.25794, 0, 0, 0.588312, 0.808634, 25, 0, 1),
(9005463, 178204, 0, 1, 1, -13203.4, 281.3, 39.2565, 1.2489, 0, 0, 0.58465, 0.811285, 25, 0, 1),
(9005506, 178204, 0, 1, 1, -13211.3, 273.27, 29.2615, 4.03192, 0, 0, 0.90254, -0.430605, 25, 0, 1),
(9005507, 178204, 0, 1, 1, -13201.5, 285.833, 40.5, 1.25661, 0, 0, 0.587775, 0.809024, 25, 0, 1);
-- Спаунт сундука, куда нам нужно
DELETE FROM `gameobject` WHERE `id`=179697;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) 
VALUES (9005108, 179697, 0, 1, 1, -13200, 291.433, 41.5922, 2.7371, 0, 0, 0.979618, 0.200868, 7200, 100, 1);

-- чтобы все видели сундук.
UPDATE `gameobject_template` SET `faction` = 0 WHERE `entry` = 179697;

-- Дополнение
-- ставим скрипт и добавляем в ивент
UPDATE `creature_template` SET `ScriptName` = 'mob_eventai' WHERE `entry` = 14508;
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES (334,16);
-- Это скрипты
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=14508);
INSERT INTO `creature_ai_scripts` 
VALUES (1450801, 14508, 11, 0, 100, 0, 0, 0, 0, 0, 1, -900100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Yell on spawn John Mithril');
insert into `creature_ai_texts` 
(`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,
`type`,`language`,`emote`,`comment`) values 
( '-900100',
'Arrr, Me Hearties! I be havin\' some extra Treasure that i be givin\' away at the Gurubashi Arena! All ye need to do is collect it is open the chest I leave on the arena floor!',
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','1','0','0','14508');