[Mediv]

Portal Spawns

Добавляет порталы по городам в соотношении 3 штуки на город.

=DOWNLOAD=

INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES

('500024','176500','1','1472.4','-4214.37','58.9939','1.18515','0','0','0.5585','0.829505','25','100','1'),
('500022','176497','1','9633.73','2515.15','1331.54','1.31642','0','0','0.611701','0.791089','25','100','1'),
('500020','176296','1','9638.24','2531.07','1331.56','4.45408','0','0','0.79229','-0.610145','25','100','1'),
('500016','176499','1','-953.82','289.415','109.83','5.78068','0','0','0.248619','-0.968601','25','100','1'),
('500014','176501','1','-974.05','296.006','109.817','2.92968','0','0','0.994392','0.10576','25','100','1'),
('500013','176501','1','1467.68','-4227.25','58.9939','1.2087','0','0','0.568229','0.82287','25','100','1'),
('500012','176499','0','1772.22','70.2139','-46.3213','1.51851','0','0','0.688381','0.72535','25','100','1'),
('500011','176500','0','1763.96','62.1076','-46.3213','3.1004','0','0','0.999788','0.0205952','25','100','1'),
('500010','176498','0','-8994.51','844.666','29.6206','4.85493','0','0','0.654959','-0.755665','25','100','1'),
('500008','176497','0','-8981.44','854.3','29.6206','3.31946','0','0','0.996048','-0.0888143','25','100','1'),
('500007','176296','0','-4671.01','-950.097','500.377','5.4351','0','0','0.411449','-0.911433','25','100','1'),
('500006','176498','0','-4659.25','-963.725','500.377','0.722701','0','0','0.353538','0.93542','25','100','1');

UPDATE `gameobject_template` SET `data2` = 0 WHERE `entry` IN (176498,178404,176497,176499,176296,176500,176501);