Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
Код:
UPDATE `creature_template` SET `gossip_menu_id` = 10426 WHERE `entry` = 33557;
UPDATE `gossip_menu` SET `entry` = 10426`, `text_id` = 14465 WHERE `entry` = 33557;
UPDATE `gossip_menu_option` SET `menu_id` = 10426 WHERE `menu_id` = 33557;
UPDATE `creature_template` SET `gossip_menu_id` = 10380 WHERE `entry` = 33361;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (10380, 14403);
UPDATE `creature_template` SET `gossip_menu_id` = 10597 WHERE `entry` = 34882;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (10597, 14659);
Турнир облетел раз 5 и раза 3 ИЧ нормал пронес
Модельки
Код:
UPDATE `creature_model_info` SET `combat_reach` = '1.05' WHERE modelid = 850;
UPDATE `creature_model_info` SET `combat_reach` = '0.75' WHERE modelid = 4449;
UPDATE `creature_model_info` SET `bounding_radius` = '1.15' WHERE modelid = 14255;
UPDATE `creature_model_info` SET `combat_reach` = '2.3' WHERE modelid = 14255;
UPDATE `creature_model_info` SET `combat_reach` = '0.25' WHERE modelid = 17188;
UPDATE `creature_model_info` SET `combat_reach` = '0.25' WHERE modelid = 17200;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 21601;
UPDATE `creature_model_info` SET `bounding_radius` = '1' WHERE modelid = 22471;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 22474;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 24225;
UPDATE `creature_model_info` SET `combat_reach` = '1.15' WHERE modelid = 24997;
UPDATE `creature_model_info` SET `bounding_radius` = '0.18445' WHERE modelid = 25390;
UPDATE `creature_model_info` SET `combat_reach` = '0.595' WHERE modelid = 25390;
UPDATE `creature_model_info` SET `bounding_radius` = '0.2108' WHERE modelid = 25391;
UPDATE `creature_model_info` SET `combat_reach` = '0.68' WHERE modelid = 25391;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 27173;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 27177;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 27177;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 27183;
UPDATE `creature_model_info` SET `combat_reach` = '15' WHERE modelid = 27769;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28630;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28633;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28674;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28702;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28705;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28707;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 28714;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28715;
UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 28715;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28716;
UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 28716;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28735;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28744;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28747;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28748;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28749;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28749;
UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 28751;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28752;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28753;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28755;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28756;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28842;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28843;
UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 28848;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28849;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28850;
UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 28851;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28851;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28852;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28853;
UPDATE `creature_model_info` SET `bounding_radius` = '0.8725' WHERE modelid = 28855;
UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 28855;
UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 28855;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28861;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28864;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28897;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28898;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28903;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28908;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28913;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28914;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28921;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28927;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28930;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28930;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28932;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28933;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 28976;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 29075;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 29146;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 29147;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 29148;
UPDATE `creature_model_info` SET `bounding_radius` = '1' WHERE modelid = 29255;
UPDATE `creature_model_info` SET `bounding_radius` = '0.818' WHERE modelid = 29258;
UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 29258;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 29283;
UPDATE `creature_model_info` SET `bounding_radius` = '0.2502' WHERE modelid = 29556;
UPDATE `creature_model_info` SET `combat_reach` = '0.9' WHERE modelid = 29556;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 29556;
UPDATE `creature_model_info` SET `bounding_radius` = '0.7344' WHERE modelid = 29570;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29570;
UPDATE `creature_model_info` SET `bounding_radius` = '0.7344' WHERE modelid = 29571;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29571;
UPDATE `creature_model_info` SET `bounding_radius` = '0.4992' WHERE modelid = 29572;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29572;
UPDATE `creature_model_info` SET `bounding_radius` = '0.8328' WHERE modelid = 29574;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29574;
UPDATE `creature_model_info` SET `bounding_radius` = '0.8328' WHERE modelid = 29575;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29575;
UPDATE `creature_model_info` SET `bounding_radius` = '2.4' WHERE modelid = 29576;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29576;
UPDATE `creature_model_info` SET `bounding_radius` = '2.4' WHERE modelid = 29577;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29577;
UPDATE `creature_model_info` SET `bounding_radius` = '0.8928' WHERE modelid = 29578;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29578;
UPDATE `creature_model_info` SET `bounding_radius` = '0.8928' WHERE modelid = 29579;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29579;
UPDATE `creature_model_info` SET `bounding_radius` = '0.9192' WHERE modelid = 29580;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29580;
UPDATE `creature_model_info` SET `bounding_radius` = '0.9192' WHERE modelid = 29581;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29581;
UPDATE `creature_model_info` SET `bounding_radius` = '2.33928' WHERE modelid = 29582;
UPDATE `creature_model_info` SET `combat_reach` = '9.72' WHERE modelid = 29582;
UPDATE `creature_model_info` SET `bounding_radius` = '2.33928' WHERE modelid = 29583;
UPDATE `creature_model_info` SET `combat_reach` = '9.72' WHERE modelid = 29583;
UPDATE `creature_model_info` SET `combat_reach` = '4.5' WHERE modelid = 29588;
UPDATE `creature_model_info` SET `combat_reach` = '3' WHERE modelid = 29589;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 29589;
UPDATE `creature_model_info` SET `combat_reach` = '4.5' WHERE modelid = 29591;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 29614;
UPDATE `creature_model_info` SET `bounding_radius` = '0.8328' WHERE modelid = 29634;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29634;
UPDATE `creature_model_info` SET `bounding_radius` = '0.8328' WHERE modelid = 29635;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29635;
UPDATE `creature_model_info` SET `bounding_radius` = '0.7344' WHERE modelid = 29636;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29636;
UPDATE `creature_model_info` SET `bounding_radius` = '0.7344' WHERE modelid = 29637;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29637;
UPDATE `creature_model_info` SET `bounding_radius` = '0.4992' WHERE modelid = 29638;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29638;
UPDATE `creature_model_info` SET `bounding_radius` = '2.4' WHERE modelid = 29639;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29639;
UPDATE `creature_model_info` SET `bounding_radius` = '2.4' WHERE modelid = 29640;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29640;
UPDATE `creature_model_info` SET `bounding_radius` = '2.4' WHERE modelid = 29641;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29641;
UPDATE `creature_model_info` SET `bounding_radius` = '0.84456' WHERE modelid = 29643;
UPDATE `creature_model_info` SET `combat_reach` = '4.14' WHERE modelid = 29643;
UPDATE `creature_model_info` SET `bounding_radius` = '0.7344' WHERE modelid = 29644;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29644;
UPDATE `creature_model_info` SET `bounding_radius` = '2.33928' WHERE modelid = 29645;
UPDATE `creature_model_info` SET `combat_reach` = '9.72' WHERE modelid = 29645;
UPDATE `creature_model_info` SET `bounding_radius` = '2.33928' WHERE modelid = 29646;
UPDATE `creature_model_info` SET `combat_reach` = '9.72' WHERE modelid = 29646;
UPDATE `creature_model_info` SET `bounding_radius` = '2.094' WHERE modelid = 29647;
UPDATE `creature_model_info` SET `combat_reach` = '9' WHERE modelid = 29647;
UPDATE `creature_model_info` SET `bounding_radius` = '0.7344' WHERE modelid = 29648;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29648;
UPDATE `creature_model_info` SET `bounding_radius` = '0.7344' WHERE modelid = 29649;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29649;
UPDATE `creature_model_info` SET `bounding_radius` = '0.7344' WHERE modelid = 29650;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29650;
UPDATE `creature_model_info` SET `bounding_radius` = '0.9192' WHERE modelid = 29651;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29651;
UPDATE `creature_model_info` SET `bounding_radius` = '0.9192' WHERE modelid = 29652;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29652;
UPDATE `creature_model_info` SET `bounding_radius` = '0.9192' WHERE modelid = 29653;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29653;
UPDATE `creature_model_info` SET `bounding_radius` = '0.9192' WHERE modelid = 29655;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29655;
UPDATE `creature_model_info` SET `bounding_radius` = '0.5664' WHERE modelid = 29658;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29658;
UPDATE `creature_model_info` SET `bounding_radius` = '0.8928' WHERE modelid = 29659;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29659;
UPDATE `creature_model_info` SET `bounding_radius` = '0.8928' WHERE modelid = 29660;
UPDATE `creature_model_info` SET `combat_reach` = '3.6' WHERE modelid = 29660;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 29828;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 29881;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 29882;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 29883;
Без unit flags and dynamic flags
Код:
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 417;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 417;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 417;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 417;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 6491;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 6491;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 8996;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 8996;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 10928;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 10928;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 12922;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 12922;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 17252;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 31702;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 32498;
UPDATE `creature_template` SET `scale` = '1.36' WHERE entry = 32498;
UPDATE `creature_template` SET `faction_A` = '1078', `faction_H` = '1078' WHERE entry = 33222;
UPDATE `creature_template` SET `faction_A` = '1078', `faction_H` = '1078' WHERE entry = 33223;
UPDATE `creature_template` SET `faction_A` = '1078', `faction_H` = '1078' WHERE entry = 33225;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 33229;
UPDATE `creature_template` SET `faction_A` = '1078', `faction_H` = '1078' WHERE entry = 33307;
UPDATE `creature_template` SET `faction_A` = '2155', `faction_H` = '2155' WHERE entry = 33310;
UPDATE `creature_template` SET `faction_A` = '2155', `faction_H` = '2155' WHERE entry = 33312;
UPDATE `creature_template` SET `faction_A` = '2155', `faction_H` = '2155' WHERE entry = 33315;
UPDATE `creature_template` SET `faction_A` = '64', `faction_H` = '64' WHERE entry = 33335;
UPDATE `creature_template` SET `faction_A` = '1074', `faction_H` = '1074' WHERE entry = 33361;
UPDATE `creature_template` SET `faction_A` = '1695', `faction_H` = '1695' WHERE entry = 33379;
UPDATE `creature_template` SET `faction_A` = '104', `faction_H` = '104' WHERE entry = 33403;
UPDATE `creature_template` SET `faction_A` = '1074', `faction_H` = '1074' WHERE entry = 33405;
UPDATE `creature_template` SET `faction_A` = '1695', `faction_H` = '1695' WHERE entry = 33538;
UPDATE `creature_template` SET `faction_A` = '104', `faction_H` = '104' WHERE entry = 33539;
UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 33542;
UPDATE `creature_template` SET `faction_A` = '1074', `faction_H` = '1074' WHERE entry = 33544;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 33548;
UPDATE `creature_template` SET `faction_A` = '104', `faction_H` = '104' WHERE entry = 33556;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 33557;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 33561;
UPDATE `creature_template` SET `faction_A` = '1076', `faction_H` = '1076' WHERE entry = 33592;
UPDATE `creature_template` SET `faction_A` = '1694', `faction_H` = '1694' WHERE entry = 33593;
UPDATE `creature_template` SET `faction_A` = '2071', `faction_H` = '2071' WHERE entry = 33644;
UPDATE `creature_template` SET `faction_A` = '2027', `faction_H` = '2027' WHERE entry = 33646;
UPDATE `creature_template` SET `faction_A` = '64', `faction_H` = '64' WHERE entry = 33648;
UPDATE `creature_template` SET `faction_A` = '64', `faction_H` = '64' WHERE entry = 33649;
UPDATE `creature_template` SET `faction_A` = '64', `faction_H` = '64' WHERE entry = 33650;
UPDATE `creature_template` SET `faction_A` = '1076', `faction_H` = '1076' WHERE entry = 33652;
UPDATE `creature_template` SET `faction_A` = '1076', `faction_H` = '1076' WHERE entry = 33653;
UPDATE `creature_template` SET `faction_A` = '1076', `faction_H` = '1076' WHERE entry = 33654;
UPDATE `creature_template` SET `faction_A` = '1694', `faction_H` = '1694' WHERE entry = 33655;
UPDATE `creature_template` SET `faction_A` = '1694', `faction_H` = '1694' WHERE entry = 33656;
UPDATE `creature_template` SET `faction_A` = '1694', `faction_H` = '1694' WHERE entry = 33657;
UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 33658;
UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 33659;
UPDATE `creature_template` SET `faction_A` = '14', `faction_H` = '14' WHERE entry = 33738;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33743;
UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33743;
UPDATE `creature_template` SET `speed_run` = '1.03929' WHERE entry = 33747;
UPDATE `creature_template` SET `speed_walk` = '0.75' WHERE entry = 33747;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33842;
UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 33843;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33870;
UPDATE `creature_template` SET `faction_A` = '2025', `faction_H` = '2025' WHERE entry = 33970;
UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 33971;
UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 34657;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 34658;
UPDATE `creature_template` SET `VehicleID` = '430' WHERE entry = 34658;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 34658;
UPDATE `creature_template` SET `faction_A` = '875', `faction_H` = '875' WHERE entry = 34702;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 34703;
UPDATE `creature_template` SET `faction_A` = '55', `faction_H` = '55' WHERE entry = 34703;
UPDATE `creature_template` SET `VehicleID` = '477' WHERE entry = 34705;
UPDATE `creature_template` SET `faction_A` = '12', `faction_H` = '12' WHERE entry = 34705;
UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 34771;
UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 34772;
UPDATE `creature_template` SET `faction_A` = '634', `faction_H` = '634' WHERE entry = 34788;
UPDATE `creature_template` SET `scale` = '2.4' WHERE entry = 34856;
UPDATE `creature_template` SET `scale` = '2.4' WHERE entry = 34857;
UPDATE `creature_template` SET `scale` = '2.4' WHERE entry = 34858;
UPDATE `creature_template` SET `scale` = '2.4' WHERE entry = 34859;
UPDATE `creature_template` SET `scale` = '2.4' WHERE entry = 34860;
UPDATE `creature_template` SET `scale` = '2.4' WHERE entry = 34861;
UPDATE `creature_template` SET `scale` = '2.4' WHERE entry = 34868;
UPDATE `creature_template` SET `scale` = '2.4' WHERE entry = 34869;
UPDATE `creature_template` SET `scale` = '2.4' WHERE entry = 34870;
UPDATE `creature_template` SET `scale` = '2.4' WHERE entry = 34871;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 34883;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 34887;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 34900;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 34901;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 34902;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 34903;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 34904;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 34905;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 34906;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 34908;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 34909;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 34910;
UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 34914;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 34928;
UPDATE `creature_template` SET `scale` = '2.4' WHERE entry = 34966;
UPDATE `creature_template` SET `scale` = '2.4' WHERE entry = 34970;
UPDATE `creature_template` SET `scale` = '2.4' WHERE entry = 34974;
UPDATE `creature_template` SET `scale` = '2.4' WHERE entry = 34975;
UPDATE `creature_template` SET `scale` = '2.4' WHERE entry = 34977;
UPDATE `creature_template` SET `scale` = '2.4' WHERE entry = 34979;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 34990;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 34992;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 34995;
UPDATE `creature_template` SET `unit_class` = '1' WHERE entry = 34996;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 35016;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 35029;
UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 35029;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 35029;
UPDATE `creature_template` SET `scale` = '0.1' WHERE entry = 35029;
UPDATE `creature_template` SET `faction_A` = '2121', `faction_H` = '2121' WHERE entry = 35290;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 35305;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 35307;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 35309;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 35311;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 35328;
UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 35328;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 35329;
UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 35329;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 35331;
UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 35331;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 35332;
UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 35332;
UPDATE `creature_template` SET `faction_A` = '14', `faction_H` = '14' WHERE entry = 35451;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 35451;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 35545;
UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 35545;
UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 35574;
UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 35576;
UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 35578;
UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 35580;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 35590;
UPDATE `creature_template` SET `faction_A` = '14', `faction_H` = '14' WHERE entry = 35614;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 35633;
UPDATE `creature_template` SET `VehicleID` = '478' WHERE entry = 35633;
UPDATE `creature_template` SET `faction_A` = '14', `faction_H` = '14' WHERE entry = 35633;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 35636;
UPDATE `creature_template` SET `VehicleID` = '481' WHERE entry = 35636;
UPDATE `creature_template` SET `faction_A` = '14', `faction_H` = '14' WHERE entry = 35636;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 35637;
UPDATE `creature_template` SET `VehicleID` = '482' WHERE entry = 35637;
UPDATE `creature_template` SET `faction_A` = '14', `faction_H` = '14' WHERE entry = 35637;
UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 35644;
UPDATE `creature_template` SET `VehicleID` = '529' WHERE entry = 35644;
UPDATE `creature_template` SET `faction_A` = '14', `faction_H` = '14' WHERE entry = 35644;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 36108;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 36109;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 36114;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 36116;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 36118;
UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 36119;
UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 36120;
UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 36121;
UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 36122;
UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 36124;
UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 36558;
И юнит и динамик флаги отдельно
Код:
UPDATE `creature_template` SET `unit_flags` = '526344' WHERE entry = 19668;
UPDATE `creature_template` SET `unit_flags` = '655360' WHERE entry = 33229;
UPDATE `creature_template` SET `unit_flags` = '17301512' WHERE entry = 33320;
UPDATE `creature_template` SET `unit_flags` = '17301512' WHERE entry = 33321;
UPDATE `creature_template` SET `unit_flags` = '526338' WHERE entry = 33382;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 33382;
UPDATE `creature_template` SET `unit_flags` = '2147779328' WHERE entry = 33460;
UPDATE `creature_template` SET `unit_flags` = '2147779328' WHERE entry = 33479;
UPDATE `creature_template` SET `unit_flags` = '8914944' WHERE entry = 33738;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 33738;
UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 33740;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 33740;
UPDATE `creature_template` SET `unit_flags` = '8913168' WHERE entry = 33747;
UPDATE `creature_template` SET `unit_flags` = '16777224' WHERE entry = 33844;
UPDATE `creature_template` SET `unit_flags` = '559360' WHERE entry = 34657;
UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 34657;
UPDATE `creature_template` SET `unit_flags` = '34113536' WHERE entry = 34658;
UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 34658;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 34702;
UPDATE `creature_template` SET `unit_flags` = '8947968' WHERE entry = 34703;
UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 34703;
UPDATE `creature_template` SET `unit_flags` = '8947968' WHERE entry = 34705;
UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 34705;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 34856;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 34857;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 34858;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 34859;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 34860;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 34861;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 34868;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 34869;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 34870;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 34871;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 34928;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 34966;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 34970;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 34974;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 34975;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 34977;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 34979;
UPDATE `creature_template` SET `unit_flags` = '514' WHERE entry = 34990;
UPDATE `creature_template` SET `unit_flags` = '514' WHERE entry = 34992;
UPDATE `creature_template` SET `unit_flags` = '514' WHERE entry = 34994;
UPDATE `creature_template` SET `unit_flags` = '514' WHERE entry = 34995;
UPDATE `creature_template` SET `unit_flags` = '514' WHERE entry = 34996;
UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 35004;
UPDATE `creature_template` SET `unit_flags` = '33719042' WHERE entry = 35016;
UPDATE `creature_template` SET `unit_flags` = '537690176' WHERE entry = 35029;
UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 35305;
UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 35307;
UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 35309;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 35328;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 35329;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 35331;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 35332;
UPDATE `creature_template` SET `unit_flags` = '33600' WHERE entry = 35361;
UPDATE `creature_template` SET `unit_flags` = '320' WHERE entry = 35451;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 35491;
UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 35545;
UPDATE `creature_template` SET `unit_flags` = '33554432' WHERE entry = 35614;
UPDATE `creature_template` SET `unit_flags` = '33587456' WHERE entry = 35633;
UPDATE `creature_template` SET `unit_flags` = '42502400' WHERE entry = 35636;
UPDATE `creature_template` SET `unit_flags` = '42502400' WHERE entry = 35637;
UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 35637;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 35644;
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян
Последний раз редактировалось Heisenberg; 05.04.2011 в 20:04.
|