YTDB dev
Регистрация: 05.11.2009
Сообщений: 5,920
Сказал(а) спасибо: 91
Поблагодарили 5,383 раз(а) в 4,847 сообщениях
|
К п83, тест.))
Код:
DELETE FROM `creature_movement_scripts` WHERE `id` = 641;
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES ('641', '0', '18', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
#
UPDATE `creature` SET `position_x` = '5795.568',`position_y` = '545.54',`position_z` = '648.2127',`orientation` = '0',`MovementType` = '2' WHERE `guid` =128279;
DELETE FROM `creature_movement` WHERE `id` = 128279;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(128279, 1, 5793.982, 542.8198, 648.1455),
(128279, 2, 5788.732, 540.0698, 648.1455),
(128279, 3, 5786.482, 538.0698, 648.1455),
(128279, 4, 5782.982, 533.5698, 648.6455),
(128279, 5, 5778.732, 533.3198, 648.6455),
(128279, 6, 5770.482, 542.5698, 647.6455),
(128279, 7, 5757.982, 551.8198, 647.1455),
(128279, 8, 5744.982, 560.0698, 646.8955),
(128279, 9, 5730.982, 569.5698, 646.6455),
(128279, 10, 5716.732, 580.5698, 646.3955),
(128279, 11, 5712.982, 585.3198, 646.1455),
(128279, 12, 5715.732, 590.8198, 647.3955),
(128279, 13, 5717.982, 594.5698, 648.3955);
UPDATE `creature_movement` SET `script_id` = '641' WHERE `id` =128279 AND `point` =13;
#
REPLACE 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
(114089, 32704, 571, 1, 65535, 0, 0, 5785.337, 531.7715, 641.5594, 0, 300, 0, 0, 10635, 3561, 0, 2);
DELETE FROM `creature_movement` WHERE `id` = 114089;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(114089, 1, 5784.264, 536.9761, 641.1866),
(114089, 2, 5791.264, 545.2261, 639.6866),
(114089, 3, 5798.514, 551.2261, 638.6866),
(114089, 4, 5806.264, 562.9761, 638.4366),
(114089, 5, 5812.514, 577.2261, 638.9366),
(114089, 6, 5821.764, 585.9761, 639.1866),
(114089, 7, 5830.264, 594.4761, 639.1866),
(114089, 8, 5839.264, 604.2261, 638.9366),
(114089, 9, 5845.264, 613.7261, 640.1866),
(114089, 10, 5848.514, 618.9761, 640.9366);
UPDATE `creature_movement` SET `script_id` = '641' WHERE `id` =114089 AND `point` =10;
#
REPLACE 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
(114090, 32704, 571, 1, 65535, 0, 0, 5860.69, 633.1807, 647.8139, 0, 300, 0, 0, 10635, 3561, 0, 2);
DELETE FROM `creature_movement` WHERE `id` = 114090;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(114090, 1, 5857.287, 632.0367, 647.663),
(114090, 2, 5853.787, 633.5367, 647.663);
UPDATE `creature_movement` SET `script_id` = '641' WHERE `id` =114090 AND `point` =2;
#
REPLACE 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
(114091, 32704, 571, 1, 65535, 0, 0, 5849.384, 636.8926, 647.5121, 0, 300, 0, 0, 10635, 3561, 0, 2);
DELETE FROM `creature_movement` WHERE `id` = 114091;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(114091, 1, 5850.643, 636.0583, 647.3645),
(114091, 2, 5860.643, 639.8083, 647.6145),
(114091, 3, 5881.143, 641.8083, 646.3645),
(114091, 4, 5889.143, 643.0583, 646.1145),
(114091, 5, 5898.143, 642.5583, 646.1145),
(114091, 6, 5905.393, 637.8083, 646.1145),
(114091, 7, 5911.893, 631.8083, 646.3645),
(114091, 8, 5914.143, 627.3083, 646.1145),
(114091, 9, 5918.393, 622.3083, 644.6145),
(114091, 10, 5921.893, 621.8083, 644.6145),
(114091, 11, 5924.893, 625.5583, 644.6145),
(114091, 12, 5924.393, 642.3083, 644.6145),
(114091, 13, 5924.893, 646.0583, 644.6145),
(114091, 14, 5928.9, 650.2239, 644.7169);
UPDATE `creature_movement` SET `script_id` = '641' WHERE `id` =114091 AND `point` =14;
#
REPLACE INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES ('240', '1', 'npc=32704');
REPLACE INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES ('128279', '240', '0', 'npc=32704'),('114089', '240', '0', 'npc=32704'),('114090', '240', '0', 'npc=32704'),('114091', '240', '0', 'npc=32704');
|