Показать сообщение отдельно
Старый 14.03.2015, 04:05   #2
Ulduar
Ученый
 
Регистрация: 23.11.2012
Сообщений: 196
Сказал(а) спасибо: 69
Поблагодарили 16 раз(а) в 16 сообщениях
Ulduar На верном пути
По умолчанию

Код:
DELETE FROM creature WHERE guid IN (140328,140329);
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 (140328,17993,553,3,1,0,0,-155.507,389.66,-17.7781,2.1041,7200,0,0,16208,3080,0,0);
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 (140329,17993,553,3,1,0,0,-160.717,374.429,-17.6977,2.19363,7200,0,0,16208,3155,0,0);

DELETE FROM db_script_string WHERE entry IN (2000005558,2000005559);
INSERT INTO db_script_string (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
(2000005558,'Get out of here, there are too many of them! Escape while you can!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,Уходи отсюда, их слишком много! Беги, пока можешь,0,1,0,0,'Sunseeker Protector in Botanica'),
(2000005559,'Help! Someone help us!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,Помогите! Кто-нибудь, помогите!,0,1,0,0,'Sunseeker Protector in Botanica');

DELETE FROM dbscripts_on_creature_movement WHERE id IN (1799301,1799302,1799303,1799304);
INSERT INTO dbscripts_on_creature_movement (id, delay, command, datalong, datalong2, buddy_entry, search_radius, data_flags, dataint, dataint2, dataint3, dataint4, x, y, z, o, comments) VALUES 
(1799301,0,25,1,0,0,0,0,0,0,0,0,0,0,0,0,'Sunseeker Protector (Botanica) - Run Mode On'),
(1799302,0,15,37493,0,0,0,0,0,0,0,0,0,0,0,0,'Sunseeker Protector (Botanica) - Feign Death'),
(1799302,15,18,0,0,0,0,0,0,0,0,0,0,0,0,0,'Sunseeker Protector (Botanica) - Despawn'),
(1799303,0,0,0,0,0,0,0,2000005559,0,0,0,0,0,0,0,''),
(1799304,0,0,0,0,0,0,0,2000005558,0,0,0,0,0,0,0,'');

UPDATE creature SET Spawndist = 0, MovementType = 2 WHERE guid IN (140328);
DELETE FROM creature_movement WHERE id IN (140328);
INSERT INTO creature_movement (id, point, position_x, position_y, position_z, waittime, script_id, textid1, textid2, textid3, textid4, textid5, emote, spell, wpguid, orientation, model1, model2) values
(140328,1,-155.507,389.66,-17.7781,16000,1799301,0,0,0,0,0,0,0,0,2.1041,0,0),
(140328,2,-155.507,389.66,-17.7781,0,0,0,0,0,0,0,0,0,0,2.1041,0,0),
(140328,3,-161.64,398.266,-17.734,0,0,0,0,0,0,0,0,0,0,2.23573,0,0),
(140328,4,-157.994,405.455,-17.6956,0,1799303,0,0,0,0,0,0,0,0,0.805515,0,0),
(140328,5,-164.289,411.495,-17.7221,0,0,0,0,0,0,0,0,0,0,2.44307,0,0),
(140328,6,-169.0393,407.6524,-17.69853,60000,1799302,0,0,0,0,0,0,0,0,1.727011,0,0);

UPDATE creature SET Spawndist = 0, MovementType = 2 WHERE guid IN (140329);
DELETE FROM creature_movement WHERE id IN (140329);
INSERT INTO creature_movement (id, point, position_x, position_y, position_z, waittime, script_id, textid1, textid2, textid3, textid4, textid5, emote, spell, wpguid, orientation, model1, model2) values
(140329,1,-160.717,374.429,-17.6977,16000,1799301,0,0,0,0,0,0,0,0,2.19363,0,0),
(140329,2,-160.717,374.429,-17.6977,0,0,0,0,0,0,0,0,0,0,2.19363,0,0),
(140329,3,-167.591,389.41,-17.6984,0,0,0,0,0,0,0,0,0,0,1.9899,0,0),
(140329,4,-170.008,400.085,-17.696,0,0,0,0,0,0,0,0,0,0,1.75349,0,0),
(140329,5,-161.8523,407.7832,-17.69849,0,1799304,0,0,0,0,0,0,0,0,1.729398,0,0),
(140329,6,-163.7475,428.2452,-17.78011,60000,1799302,0,0,0,0,0,0,0,0,1.727011,0,0);
Вот что мне предложили! Спасибо Grz3s
Думаю стоит добавить в EventAI строчку с ACTION_T_CHANGE_MOVEMENT and EVENT_T_OOC_LOS. Что скажете?
Всю базу заливал YTDB и updatepack, но видимо не заметил наличия этого мини эвента(если он есть).
__________________
Ты кто? Зёбра! Ктооооооо?!

Последний раз редактировалось Ulduar; 14.03.2015 в 04:30. Причина: Русский перевод более приятен не так ли?
Ulduar вне форума   Ответить с цитированием