Показать сообщение отдельно
Старый 12.01.2011, 21:56   #88
NeatElves
YTDB dev
 
Аватар для NeatElves
 
Регистрация: 05.11.2009
Сообщений: 5,920
Сказал(а) спасибо: 91
Поблагодарили 5,383 раз(а) в 4,847 сообщениях
NeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспорима
По умолчанию

К п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');
NeatElves вне форума   Ответить с цитированием
Пользователь сказал cпасибо:
YuruY (12.01.2011)