Показать сообщение отдельно
Старый 30.10.2012, 18:37   #297
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 Репутация неоспорима
По умолчанию

1, добавка(всплыло из-за желания узнать, а кому собственно аура должна принадлежать)
Код:
UPDATE `creature` SET `spawndist`='0', `MovementType`='0' WHERE `guid`=70804;
UPDATE `creature` SET `spawndist`='0', `MovementType`='0' WHERE `guid`=70783;
UPDATE `creature` SET `spawndist`='0', `MovementType`='0' WHERE `guid`=70813;
UPDATE `creature` SET `spawndist`='0', `MovementType`='0' WHERE `guid`=70777;
UPDATE `creature` SET `spawndist`='0', `MovementType`='0' WHERE `guid`=70741;
UPDATE `creature` SET `spawndist`='0', `MovementType`='0' WHERE `guid`=70811;
UPDATE `creature` SET `spawndist`='0', `MovementType`='0' WHERE `guid`=70812;
UPDATE `creature` SET `spawndist`='0', `MovementType`='0' WHERE `guid`=70818;
DELETE FROM `creature_addon` WHERE `guid` = 70835;
DELETE FROM `creature_addon` WHERE `guid` = 70790;
DELETE FROM `creature_addon` WHERE `guid` = 70789;
DELETE FROM `creature_addon` WHERE `guid` = 70784;
DELETE FROM `creature_addon` WHERE `guid` = 70773;
DELETE FROM `creature_addon` WHERE `guid` = 70810;
UPDATE creature SET position_x = '-2871.585205', position_y = '6355.595703', position_z = '87.491272', orientation = '3.285670' WHERE guid = '70789';
UPDATE creature SET position_x = '-2884.708252', position_y = '6374.736328', position_z = '81.824265', orientation = '0.553269' WHERE guid = '70777';
UPDATE creature SET position_x = '-2928.191406', position_y = '6416.012695', position_z = '82.323212', orientation = '1.838185' WHERE guid = '70783';
UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry`=17147;
UPDATE `creature_addon` SET `auras`=NULL WHERE `guid` in (70813,70777,70783);
DELETE FROM `creature_addon` WHERE `guid` = 70834;
DELETE FROM `creature_addon` WHERE `guid` = 70832;
DELETE FROM `creature_addon` WHERE `guid` = 70831;
DELETE FROM `creature_addon` WHERE `guid` = 70830;
DELETE FROM `creature_addon` WHERE `guid` = 70823;
DELETE FROM `creature_addon` WHERE `guid` = 70822;
DELETE FROM `creature_addon` WHERE `guid` = 70817;
DELETE FROM `creature_addon` WHERE `guid` = 70776;
DELETE FROM `creature_addon` WHERE `guid` = 70741;
DELETE FROM `creature_addon` WHERE `guid` = 70775;
DELETE FROM `creature_addon` WHERE `guid` = 70774;
DELETE FROM `creature_addon` WHERE `guid` = 70841;
2, возможно
3, правильно
NeatElves вне форума   Ответить с цитированием
Пользователь сказал cпасибо:
YuruY (30.10.2012)