WoW-Info — информационный World of Warcraft портал

1. Часть эвента воздушного боя.
-- бой кораблей 17 фаза
-- 201580
-- 36970
-- Transport POS: (X:35.651 Y:20.29211 Z:25.11613)
-- Transport POS: (X:35.57132 Y:-20.18365 Z:25.1162)
-- Transport POS: (X:-36.38065 Y:2.928953 Z:20.5322)
-- Transport POS: (X:29.25061 Y:-6.920386 Z:23.37144)
-- Transport POS: (X:41.96808 Y:43.83936 Z:25.03383)
-- Transport POS: (X:9.26111 Y:-22.73216 Z:21.84549)
-- Transport POS: (X:-36.22218 Y:-2.960294 Z:20.53312)
-- Transport POS: (X:-64.70975 Y:4.575944 Z:23.52326)

-- 37540
-- Transport POS: (X:-13.14293 Y:-0.36969 Z:12.89091)
-- 37182
-- Transport POS: (X:42.78902 Y:-0.010491 Z:25.24052)
-- 37184
-- Transport POS: (X:18.8226 Y:9.700101 Z:20.41841)
-- 37519
-- Transport POS: (X:-28.27504 Y:15.59459 Z:20.5379)
-- Transport POS: (X:39.44747 Y:0.136515 Z:25.23212)
-- Transport POS: (X:-19.90114 Y:-11.19758 Z:33.48487)
-- Transport POS: (X:22.17635 Y:-11.41252 Z:34.99731)

-- 37547
-- Transport POS: (X:-34.2702 Y:-26.18966 Z:21.37483)
-- Transport POS: (X:-11.64459 Y:-19.85176 Z:20.88428)
-- Transport POS: (X:-19.88223 Y:-6.578763 Z:20.57444)
-- Transport POS: (X:-41.4456 Y:-7.647498 Z:20.49746)
-- Transport POS: (X:0.554884 Y:-1.232897 Z:20.53705)
-- Transport POS: (X:-50.16516 Y:9.716236 Z:23.58709)
-- Transport POS: (X:11.45844 Y:16.36624 Z:20.54192)
-- Transport POS: (X:19.72286 Y:-2.193787 Z:33.06982)
-- Transport POS: (X:8.599396 Y:-28.55855 Z:24.79919)
-- Transport POS: (X:38.94339 Y:-33.808 Z:25.39618)
-- Transport POS: (X:-58.15474 Y:0.748094 Z:41.87663)
-- Transport POS: (X:-5.607554 Y:-6.350654 Z:34.00357)
-- Transport POS: (X:4.780305 Y:-29.05227 Z:35.09634)

-- 36948
-- Transport POS: (X:13.51547 Y:-0.160213 Z:20.87252)

-- 201581
-- 36982
-- Transport POS: (X:-11.44849 Y:-25.71838 Z:33.64343)
-- Transport POS: (X:12.30336 Y:-25.69653 Z:35.32373)
-- 37117
-- Transport POS: (X:47.2929 Y:-4.308941 Z:37.5555) -- кастит 43897
-- Transport POS: (X:47.34621 Y:4.032004 Z:37.70952) -- кастит 43897
-- 36968
-- Transport POS: (X:-3.170555 Y:28.30652 Z:34.21082)
-- Transport POS: (X:-12.0928 Y:27.65942 Z:33.58557)
-- Transport POS: (X:14.92804 Y:26.18018 Z:35.47803)
-- Transport POS: (X:24.70331 Y:25.36584 Z:35.97845)

-- 37215
-- Transport POS: (X:3.838599 Y:0.183334 Z:24.10049)
-- 36939
-- Transport POS: (X:37.18615 Y:0.00016 Z:36.78849)
-- 32780
-- Transport POS: (X:37.30764 Y:-0.143823 Z:36.7936)

-- После конца боя выходят из портала
-- 36957
-- Transport POS: (X:60.16509 Y:2.196409 Z:38.73351)
-- Transport POS: (X:58.88887 Y:-0.032922 Z:38.57119)
-- 36968
-- Transport POS: (X:60.61772 Y:-0.04089 Z:38.71772)
-- Transport POS: (X:60.78434 Y:-0.084965 Z:38.73293)
-- 37117
-- Transport POS: (X:60.84844 Y:-0.103837 Z:38.73883)
-- 36982
-- Transport POS: (X:60.52059 Y:-0.041272 Z:38.70951)
-- Transport POS: (X:60.60733 Y:-0.139769 Z:38.71933)
-- 36960
-- Transport POS: (X:62.56792 Y:-2.108244 Z:38.93467)
-- 37227 (портал тп)
-- Transport POS: (X:47.55099 Y:-0.101778 Z:37.61111)
-- 37488 (точка выхода)
-- Transport POS: (X:-17.55738 Y:-0.090421 Z:21.68366)
Бой кораблей,спелы на пушки прикрепил. Тут часть тригеров , вероятно их пушки дмг и считается урон кораблю общий.

DELETE FROM `creature_template_addon` WHERE entry = 37186;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES (37186, 0, 0, 0, 0, 0, '70022 0');

UPDATE waypoint_scripts SET delay = 3 WHERE dataint = 38879 AND command = 15;

DELETE FROM `conditions` WHERE SourceEntry=45905;
INSERT INTO `conditions` VALUES (3, 3537, 45905, 0, 1, 46221, 0, 0, 0, '', NULL);

UPDATE `fishing_loot_template` SET `ChanceOrQuestChance`='-10' WHERE (`entry`='3537') AND (`item`='45905')

UPDATE `creature_template` SET `faction_A` = 1802, `faction_H` = 1802 WHERE `entry` = 37597;

DELETE FROM event_scripts` WHERE `id`=13470;
INSERT INTO `event_scripts` VALUES (13470, 0, 15, 35936, 4, 21039, 3000, 0, 0, 0);

UPDATE `quest_template` SET `ReqCreatureOrGOId2` = -184725 WHERE `entry` = 10446;

DELETE FROM `spell_scripts` WHERE id=47701;
INSERT INTO `spell_scripts` VALUES (47701, 0, 0, 10, 26902, 300000, 0, 4647.22, -4860.69, 35.480, 0.153);

UPDATE `creature_template` SET `flags_extra` = `flags_extra`-128 WHERE `entry` = 26902;
или
UPDATE `creature_template` SET `flags_extra` = 2 WHERE `entry` = 26902;

DELETE FROM `creature` WHERE `id`=27199;
INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
(null, 27199, 571, 1, 2, 0, 0, 4633.51, -4866.71, 36.3653, 0.164495, 300, 0, 0, 5939, 0, 0, 0, 0, 0, 0);

## 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','1 80045','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.169 1','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','90 0000','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.8 79','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),
(9 00000,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,37 719,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,4461 4,0,0,0),
(900000,46861,0,0,0);

UPDATE `quest_template` SET `SpecialFlags` = 0 WHERE `entry` = 10162;

UPDATE `spell_group` SET `spell_id` = '-1101' WHERE `id` =1103 AND `spell_group`.`spell_id` = -1001;
UPDATE `spell_group` SET `spell_id` = '-1102' WHERE `id` =1103 AND `spell_group`.`spell_id` = -1002;

UPDATE `creature_template` SET `faction_h`=7,`faction_a`=7 WHERE `entry` IN (15571);

DELETE FROM `creature_template_addon` WHERE (`entry`=40626);
INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES (40626, 0, 7, 1, 0, 0, '29266 0');
UPDATE `creature_template` SET `flags_extra` = 2 WHERE `entry` = 40626;