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

арррр (часть 1)
-- tc_434 fix console errors
-- fix smart_scripts console errors
Код:
DELETE FROM `smart_scripts` WHERE  `entryorguid`=1268 AND `source_type`=0 AND `id`=4 AND `link`=5;
UPDATE `smart_scripts` SET `id`=4 WHERE  `entryorguid`=1268 AND `source_type`=0 AND `id`=5 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=6119 AND `source_type`=0 AND `id`=4 AND `link`=5;
UPDATE `smart_scripts` SET `id`=4, `action_param2`=2 WHERE  `entryorguid`=6119 AND `source_type`=0 AND `id`=5 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=7955 AND `source_type`=0 AND `id`=3 AND `link`=4;
UPDATE `smart_scripts` SET `id`=3, `action_param2`=3 WHERE  `entryorguid`=7955 AND `source_type`=0 AND `id`=4 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=39712 AND `source_type`=0 AND `id`=0 AND `link`=0;
INSERT INTO `smart_scripts` VALUES 
(39712, 0, 0, 1, 38, 0, 100, 1, 1, 1, 0, 0, 11, 74154, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'High Tinker Mekkatorque - on data set- credit quest'),
(39712, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'High Tinker Mekkatorque - on data set- despawn'),
(39712, 0, 2, 3, 38, 0, 100, 1, 1, 2, 0, 0, 11, 74156, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'High Tinker Mekkatorque - on data set- credit quest'),
(39712, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'High Tinker Mekkatorque - on data set- despawn'),
(39712, 0, 4, 5, 38, 0, 100, 1, 1, 3, 0, 0, 11, 74155, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'High Tinker Mekkatorque - on data set- credit quest'),
(39712, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'High Tinker Mekkatorque - on data set- despawn');

DELETE FROM `smart_scripts` WHERE  `entryorguid`=4351 AND `source_type`=0 AND `id`=0 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=4352 AND `source_type`=0 AND `id`=0 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=4353 AND `source_type`=0 AND `id`=0 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=4354 AND `source_type`=0 AND `id`=0 AND `link`=0;

DELETE FROM `smart_scripts` WHERE  `entryorguid`=5284 AND `source_type`=2 AND `id`=0 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=5285 AND `source_type`=2 AND `id`=0 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=5286 AND `source_type`=2 AND `id`=0 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=5287 AND `source_type`=2 AND `id`=0 AND `link`=0;

DELETE FROM `smart_scripts` WHERE  `entryorguid`=4393 AND `source_type`=0 AND `id`=0 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=4394 AND `source_type`=0 AND `id`=0 AND `link`=0;

DELETE FROM `smart_scripts` WHERE  `entryorguid`=15273 AND `source_type`=0 AND `id`=0 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=15273 AND `source_type`=0 AND `id`=1 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=15294 AND `source_type`=0 AND `id`=0 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=15294 AND `source_type`=0 AND `id`=1 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=15298 AND `source_type`=0 AND `id`=0 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=15298 AND `source_type`=0 AND `id`=1 AND `link`=0;

UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=102760, `target_type`=1 WHERE  `entryorguid`=15664 AND `source_type`=0 AND `id`=1 AND `link`=0;
MENZ411 вне форума   Ответить с цитированием
Пользователь сказал cпасибо:
YuruY (18.09.2013)