Показать сообщение отдельно
Старый 18.09.2013, 21:16   #355
MENZ411
Helper TC_YTDB
 
Аватар для MENZ411
 
Регистрация: 03.02.2013
Адрес: Murmansk, Russian Federation
Сообщений: 50
Сказал(а) спасибо: 27
Поблагодарили 38 раз(а) в 32 сообщениях
MENZ411 На верном пути
По умолчанию

часть 2-я
Код:
UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=61314, `action_param2`=0 WHERE  `entryorguid`=15274 AND `source_type`=0 AND `id`=0 AND `link`=0;
UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=61314, `action_param2`=0 WHERE  `entryorguid`=15274 AND `source_type`=0 AND `id`=1 AND `link`=0;
UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=61314, `action_param2`=0 WHERE  `entryorguid`=15274 AND `source_type`=0 AND `id`=2 AND `link`=0;
UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=61314, `action_param2`=0 WHERE  `entryorguid`=15274 AND `source_type`=0 AND `id`=3 AND `link`=0;
UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=61314, `action_param2`=0 WHERE  `entryorguid`=15274 AND `source_type`=0 AND `id`=4 AND `link`=0;

DELETE FROM `conditions` WHERE  `SourceTypeOrReferenceId`=22 AND `SourceGroup`=7 AND `SourceEntry`=23219 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=29 AND `ConditionTarget`=0 AND `ConditionValue1`=23439 AND `ConditionValue2`=15 AND `ConditionValue3`=0;
UPDATE `smart_scripts` SET `event_type`=11, `event_param2`=0, `action_param2`=0 WHERE  `entryorguid`=23219 AND `source_type`=0 AND `id`=1 AND `link`=0;
UPDATE `smart_scripts` SET `action_type`=45, `action_param1`=1, `action_param2`=1, `target_type`=19, `target_param1`=23439, `target_param2`=10, `comment`='Blackwind Warp Chaser - On Death - Set Data on Hungry Nether Ray' WHERE  `entryorguid`=23219 AND `source_type`=0 AND `id`=6 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=23219 AND `source_type`=0 AND `id`=2 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=23219 AND `source_type`=0 AND `id`=5 AND `link`=0;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE  `entry`=23439;
INSERT INTO `smart_scripts` VALUES 
(23439, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 11, 41427, 0, 0, 0, 0, 0, 21, 10, 0, 0, 0, 0, 0, 0, 'Hungry Nether Ray - On Data Set - Cast on Master');

DELETE FROM `smart_scripts` WHERE  `entryorguid`=23652 AND `source_type`=0 AND `id`=0 AND `link`=0;
UPDATE `creature_template` SET `AIName`='' WHERE  `entry`=23652;

UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=43341 WHERE  `entryorguid`=23678 AND `source_type`=0 AND `id`=6 AND `link`=7;

#UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=43174 WHERE  `entryorguid`=23689 AND `source_type`=0 AND `id`=2 AND `link`=0;
#UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=43174 WHERE  `entryorguid`=24170 AND `source_type`=0 AND `id`=1 AND `link`=0;

DELETE FROM `smart_scripts` WHERE  `entryorguid`=24108 AND `source_type`=0 AND `id`=0 AND `link`=0;
UPDATE `creature_template` SET `AIName`='' WHERE  `entry`=24108;

Последний раз редактировалось MENZ411; 18.09.2013 в 21:20.
MENZ411 вне форума   Ответить с цитированием
Пользователь сказал cпасибо:
YuruY (18.09.2013)