## event 88 - Holiday on 8th of March

INSERT INTO `game_event` (`entry`, `start_time`, `end_time`, `occurence`, `length`, `description`) VALUES (88, '2010-03-07 21:00:00', '2020-03-09 03:00:00', 525600, 1800, 'Holiday on 8th of March');

## повозки
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES  
('7700800','180045','0','1','1','-9139.4','389.031','90.8613','3.84293','0','0','0.939143','-0.343526','25','0','1'),
('7700801','180045','530','1','1','9480.31','-7300.92','14.3791','6.19046','0','0','0.0463464','-0.998925','25','0','1'),
('7700802','180045','0','1','1','-5034.9','-788.668','495.141','1.67286','0','0','0.742255','0.670118','25','0','1'),
('7700803','180045','530','1','1','-1845.07','5346.96','-12.4282','3.3048','0','0','0.996672','-0.0815115','25','0','1'),
('7700804','180045','1','1','1','1582.8','-4428.91','7.04203','2.1691','0','0','0.884093','0.467311','25','0','1'),
('7700805','180045','1','1','1','-1447.59','69.2999','14.7232','3.79644','0','0','0.946875','-0.321603','25','0','1'),
('7700806','180045','0','1','1','-14250.3','287.78','26.9','4.70357','0','0','0.710218','-0.703982','25','0','1'),
('7700807','180045','0','1','1','-5183.14','642.833','348.279','5.26637','0','0','0.486786','-0.873521','25','0','1');

INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES (7700800,88),(7700801,88),(7700802,88),(7700803,88),(7700804,88),(7700805,88),(7700806,88),(7700807,88);

## Цветочницы
INSERT INTO `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) 
VALUES (900000, 4488, 0, 4488, 0, 'The spring Florist', 'The seller of flowers', '', 20, 20, 10000, 10000, 5000, 5000, 1000, 35, 35, 641, 1, 1, 1, 10, 20, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'EventAI', 0, 3, 0, 1, 0, 0, 0, '');

INSERT INTO `locales_creature` (`entry`, `name_loc8`, `subname_loc8`)  VALUES (900000,'Весенняя Цветочница','Продавец Цветов');

INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
('408000','900000','0','1','1','0','0','-9137.73','387.865','90.8809','5.41953','25','0','0','10000','5000','0','0'),
('408001','900000','1','1','1','0','0','1578.22','-4427.64','6.9756','3.55655','25','0','0','10000','5000','0','0'),
('408002','900000','0','1','1','0','0','-5038.02','-789.453','495.13','3.20941','25','0','0','10000','5000','0','0'),
('408003','900000','0','1','1','0','0','-14247.1','286.879','26.904','5.38731','25','0','0','10000','5000','0','0'),
('408004','900000','1','1','1','0','0','-1448.91','65.0989','14.8429','4.4409','25','0','0','10000','5000','0','0'),
('408005','900000','0','1','1','0','0','-5181.09','645.445','348.279','0.875178','25','0','0','10000','5000','0','0'),
('408006','900000','530','1','1','0','0','-1841.43','5344.77','-12.4277','5.41006','25','0','0','10000','5000','0','0'),
('408007','900000','530','1','1','0','0','9482.98','-7298.25','14.3631','0.903948','25','0','0','10000','5000','0','0');

INSERT INTO `game_event_creature` VALUES ('408000', '88'), ('408001', '88'), ('408002', '88'), ('408003', '88'), ('408004', '88'), ('408005', '88'), ('408006', '88'), ('408007', '88');

## Скрипт для цветочниц
INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) 
VALUES ('90000051', '900000', '1', '0', '100', '1', '10000', '50000', '10000', '50000', '1', '-80000', '-80001', '-80002', '0', '0', '0', '0', '0', '0', '0', '0', '(900000) event 88 - Holiday on 8th of March');

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 
('-80000','Heroes! Buy bouquet for the loved ladies!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Герои! Купите букетик для своих любимых дам!','0','0','0','0','(900000) event 88 - Holiday on 8th of March'),
('-80001','Dear Ladies, I Congratulate you on spring women`s day!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Дорогие Леди, Поздравляю вас с весенним женским днем!','0','0','0','0','(900000) event 88 - Holiday on 8th of March'),
('-80002','Flowers! Spring flowers! Only one day in year...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Цветы! Весенние цветы! Только раз в году...','0','0','0','0','(900000) event 88 - Holiday on 8th of March');

## Товар.
INSERT INTO `npc_vendor` VALUES 
(900000,765,0,0,0),
(900000,785,0,0,0),
(900000,1401,0,0,0),
(900000,2562,0,0,0),
(900000,3419,0,0,0),
(900000,3421,0,0,0),
(900000,3422,0,0,0),
(900000,3423,0,0,0),
(900000,3424,0,0,0),
(900000,3818,0,0,0),
(900000,11973,0,0,0),
(900000,11997,0,0,0),
(900000,13463,0,0,0),
(900000,15805,0,0,0),
(900000,24338,0,0,0),
(900000,25045,0,0,0),
(900000,31943,0,0,0),
(900000,36907,0,0,0),
(900000,37719,0,0,0),
(900000,38090,0,0,0),
(900000,38293,0,0,0),
(900000,39207,0,0,0),
(900000,43521,0,0,0),
(900000,44605,0,0,0),
(900000,44614,0,0,0),
(900000,46861,0,0,0);