## event 16 - Gurubashi Arena Booty Run
## ======================
## Игровое название: Gurubashi Arena Booty Run
## Автор: timmit
## Версия под 3.3.5 (Кот ДаWINчи)
## ======================
## Описание:
#   На арене Гурубаши появляется странная конструкция из ящиков. В самом верху которой, 
#   располагается сундук с призами. Ваша цель - допрыгать вверх по ящикам до сундука и 
#   забрать приз. 
## ======================
# Диапазоны guid в базе:
# gameobject          - 510000 - 510020, 179697
# creature_ai_scripts - 1450801
# creature_ai_texts   - 80010

## Делаем гамеэвент
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
(510001,16),
(510002,16),
(510003,16),
(510004,16),
(510005,16),
(510006,16),
(510007,16),
(510008,16),
(510009,16),
(510010,16),
(510011,16),
(510012,16),
(510013,16),
(510014,16),
(510015,16),
(510016,16),
(510017,16),
(510018,16);

REPLACE INTO `gameobject` 
(`guid`,`id`,   `map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(510001, 178204, 0,    1,          1,          -14289.6,    530.86,      8.93508,     1.17141,      0,          0,          0.552789,   0.833322,   25,             0,             1),
(510002, 178204, 0,    1,          1,          -13211.9,    262.525,     21.7572,     6.06836,      0,          0,          0.107208,   -0.994237,  25,             0,             1),
(510003, 178204, 0,    1,          1,          -13209.4,    262.987,     23.8573,     0.181011,     0,          0,          0.090382,   0.995907,   25,             0,             1),
(510004, 178204, 0,    1,          1,          -13206.8,    263.558,     24.8572,     0.694823,     0,          0,          0.340465,   0.940257,   25,             0,             1),
(510005, 178204, 0,    1,          1,          -13205.7,    265.691,     25.8578,     0.998675,     0,          0,          0.478844,   0.8779,     25,             0,             1),
(510006, 178204, 0,    1,          1,          -13204.8,    270.063,     26.8577,     1.469,        0,          0,          0.670217,   0.742165,   25,             0,             1),
(510007, 178204, 0,    1,          1,          -13204.8,    272.51,      27.6039,     1.53978,      0,          0,          0.696057,   0.717987,   25,             0,             1),
(510008, 178204, 0,    1,          1,          -13208.2,    276.082,     28.1808,     2.299,        0,          0,          0.91256,    0.408943,   25,             0,             1),
(510009, 178204, 0,    1,          1,          -13210.2,    262.448,     33.6787,     3.82536,      0,          0,          0.942124,   -0.335264,  25,             0,             1),
(510010, 178204, 0,    1,          1,          -13213.6,    270.051,     30.8941,     4.86445,      0,          0,          0.651356,   -0.758772,  25,             0,             1),
(510011, 178204, 0,    1,          1,          -13214.2,    266.448,     31.6787,     4.88017,      0,          0,          0.64537,    -0.76387,   25,             0,             1),
(510012, 178204, 0,    1,          1,          -13212.9,    261.961,     32.603,      5.07495,      0,          0,          0.568036,   -0.823004,  25,             0,             1),
(510013, 178204, 0,    1,          1,          -13208.8,    266.624,     35.031,      1.25794,      0,          0,          0.588312,   0.808634,   25,             0,             1),
(510014, 178204, 0,    1,          1,          -13207.3,    271.298,     36.0989,     1.25794,      0,          0,          0.588312,   0.808634,   25,             0,             1),
(510015, 178204, 0,    1,          1,          -13205.8,    276.495,     37.4105,     1.25794,      0,          0,          0.588312,   0.808634,   25,             0,             1),
(510016, 178204, 0,    1,          1,          -13203.4,    281.3,       39.2565,     1.2489,       0,          0,          0.58465,    0.811285,   25,             0,             1),
(510017, 178204, 0,    1,          1,          -13211.3,    273.27,      29.2615,     4.03192,      0,          0,          0.90254,    -0.430605,  25,             0,             1),
(510018, 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 
( 510000, 179697, 0,    1,          1,          -13200,      291.433,     41.5922,     2.7371,       0,          0,          0.979618,   0.200868,   7200,           100,           1);
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES (510000,16);
UPDATE `gameobject_template` SET `faction` = 0 WHERE `entry` = 179697; ## чтобы все видели сундук

## подцепляем квестгивера 
UPDATE `creature_template` SET `ScriptName` = 'mob_eventai' WHERE `entry` = 14508;
# Если раскомментировать, то 334 нпц будет появляться только на момент ивента!!!
# 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, -80010, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Yell on spawn John Mithril');
INSERT INTO `creature_ai_texts` 
(`entry`,  `content_default`,                                                                                                                                                                 `content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES 
('-80010', '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,         '0',    '1',   '0',       '0',    'event 16 - NPC 14508');