|
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
Убрал юнит и динамик флаги.Чтобы вы не тратили время на "чистку"
Код:
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 809;
UPDATE `creature_model_info` SET `combat_reach` = '2.125' WHERE modelid = 833;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 842;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 913;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1037;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 2161;
UPDATE `creature_model_info` SET `combat_reach` = '0.5' WHERE modelid = 2954;
UPDATE `creature_model_info` SET `bounding_radius` = '0.15' WHERE modelid = 3233;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3233;
UPDATE `creature_model_info` SET `combat_reach` = '0.5' WHERE modelid = 5448;
UPDATE `creature_model_info` SET `combat_reach` = '0.5' WHERE modelid = 5554;
UPDATE `creature_model_info` SET `combat_reach` = '0.5' WHERE modelid = 5585;
UPDATE `creature_model_info` SET `bounding_radius` = '0.25' WHERE modelid = 5966;
UPDATE `creature_model_info` SET `combat_reach` = '0.3125' WHERE modelid = 5966;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 7803;
UPDATE `creature_model_info` SET `combat_reach` = '0.5' WHERE modelid = 9563;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 10618;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 11554;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 11631;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 12350;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 13989;
UPDATE `creature_model_info` SET `combat_reach` = '2.025' WHERE modelid = 16024;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 17170;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 17444;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 17456;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17476;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19284;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 19595;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 19744;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 20017;
UPDATE `creature_model_info` SET `bounding_radius` = '0.383' WHERE modelid = 20707;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20707;
UPDATE `creature_model_info` SET `combat_reach` = '5' WHERE modelid = 20763;
UPDATE `creature_model_info` SET `combat_reach` = '0.9' WHERE modelid = 20833;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 21114;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 21270;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 21271;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 21272;
UPDATE `creature_model_info` SET `bounding_radius` = '0.5' WHERE modelid = 21342;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 21342;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 21342;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 21718;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 21961;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 21983;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 21984;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 21985;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 21986;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 21987;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 22005;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 22015;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 22042;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 22042;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 22115;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 22116;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 22136;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22152;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 22181;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 22207;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 22229;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 22243;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 22243;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 22342;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 22392;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 22447;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 22471;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 22475;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 22501;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 22607;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 22648;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 22649;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 23167;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 23277;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 23317;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 23319;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 23356;
UPDATE `creature_model_info` SET `bounding_radius` = '0.2205' WHERE modelid = 23513;
UPDATE `creature_model_info` SET `combat_reach` = '0.945' WHERE modelid = 23513;
UPDATE `creature_model_info` SET `combat_reach` = '1.2' WHERE modelid = 23517;
UPDATE `creature_model_info` SET `combat_reach` = '0.6' WHERE modelid = 23521;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 23724;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 23772;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 23772;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 23774;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 23774;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 23819;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 23826;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 23826;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 23828;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 23926;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 23951;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 24235;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 24235;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 24416;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 24418;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 24443;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 24448;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 24454;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 24491;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24607;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 24654;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 24805;
UPDATE `creature_model_info` SET `bounding_radius` = '0.91' WHERE modelid = 24890;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 24890;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 24895;
UPDATE `creature_model_info` SET `bounding_radius` = '0.1' WHERE modelid = 24897;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 24897;
UPDATE `creature_model_info` SET `bounding_radius` = '0.1' WHERE modelid = 24898;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 24898;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 24916;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 24938;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25016;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 25071;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25096;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25128;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25155;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25157;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25166;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25192;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25218;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25254;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25269;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25300;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 25318;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 25334;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25395;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25400;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25442;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25454;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25455;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25484;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25485;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25491;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25515;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25588;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25594;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25595;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 25602;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25603;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25604;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25605;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25607;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25608;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25609;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25610;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25611;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25612;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25613;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25614;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25615;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25616;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 25618;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 25619;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25620;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25621;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25622;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25623;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25635;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25636;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25637;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25641;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25644;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25645;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25646;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25647;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25648;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25649;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25650;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25651;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25655;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25673;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25674;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 25692;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25743;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 25748;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25748;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 25754;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25754;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 25755;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25755;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 25757;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25757;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 25758;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25758;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25770;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 25791;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25806;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25807;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 25871;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 25871;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25875;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25876;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25877;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25878;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25879;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25880;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25881;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25882;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 25889;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25924;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25926;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 25940;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25947;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25983;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26067;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26068;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26069;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26070;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26071;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26072;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26074;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26075;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 26078;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 26122;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26138;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 26254;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26299;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 26300;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 26303;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 26303;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26307;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26309;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26310;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26311;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26312;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26313;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26321;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26330;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26335;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26336;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26337;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26338;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26339;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26347;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26372;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 26372;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26373;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 26374;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26375;
UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 26375;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26376;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26377;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 26378;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26390;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26394;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26395;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26396;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26397;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26398;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26413;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26414;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26417;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 26417;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 26437;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26438;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26440;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26441;
UPDATE `creature_model_info` SET `combat_reach` = '0.75' WHERE modelid = 26442;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26443;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26444;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26445;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26463;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26464;
UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 26464;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26465;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 26484;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 26495;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 26496;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 26499;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 26501;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 26502;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 26503;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 26504;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 26505;
UPDATE `creature_model_info` SET `combat_reach` = '0.3125' WHERE modelid = 26524;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26525;
UPDATE `creature_model_info` SET `combat_reach` = '0.15' WHERE modelid = 26530;
UPDATE `creature_model_info` SET `combat_reach` = '0.15' WHERE modelid = 26531;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 26532;
UPDATE `creature_model_info` SET `combat_reach` = '0.15' WHERE modelid = 26547;
UPDATE `creature_model_info` SET `combat_reach` = '0.1' WHERE modelid = 26557;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 26570;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 26656;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26766;
UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 26770;
UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 26771;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26779;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 26779;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26998;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 27019;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27068;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27157;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27158;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27159;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27160;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27161;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 27174;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 27187;
UPDATE `creature_model_info` SET `combat_reach` = '3' WHERE modelid = 27211;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27211;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 27215;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 27216;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 27217;
UPDATE `creature_model_info` SET `combat_reach` = '4' WHERE modelid = 27244;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27244;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27287;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27332;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27334;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27398;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27448;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27449;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 27465;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27509;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27518;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27524;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27556;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27557;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27559;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27560;
UPDATE `creature_model_info` SET `combat_reach` = '2.1' WHERE modelid = 27585;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 27587;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 27592;
UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 27616;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 27657;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 27667;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27667;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27682;
UPDATE `creature_model_info` SET `combat_reach` = '0.3' WHERE modelid = 27718;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27718;
UPDATE `creature_model_info` SET `combat_reach` = '0.375' WHERE modelid = 27719;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27719;
UPDATE `creature_model_info` SET `combat_reach` = '1.25' WHERE modelid = 27726;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27726;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27756;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27782;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27799;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27800;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27801;
UPDATE `creature_model_info` SET `combat_reach` = '1.35' WHERE modelid = 27821;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27822;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27852;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27853;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27854;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27881;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27882;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 27886;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27912;
UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 27912;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 27914;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27915;
UPDATE `creature_model_info` SET `combat_reach` = '2.9325' WHERE modelid = 27917;
UPDATE `creature_model_info` SET `combat_reach` = '2.55' WHERE modelid = 27918;
UPDATE `creature_model_info` SET `combat_reach` = '2.55' WHERE modelid = 27919;
UPDATE `creature_model_info` SET `combat_reach` = '6.885' WHERE modelid = 27920;
UPDATE `creature_model_info` SET `combat_reach` = '2.55' WHERE modelid = 27921;
UPDATE `creature_model_info` SET `combat_reach` = '2.55' WHERE modelid = 27925;
UPDATE `creature_model_info` SET `combat_reach` = '2.55' WHERE modelid = 27926;
UPDATE `creature_model_info` SET `combat_reach` = '2.9325' WHERE modelid = 27927;
UPDATE `creature_model_info` SET `combat_reach` = '2.55' WHERE modelid = 27928;
UPDATE `creature_model_info` SET `combat_reach` = '2.55' WHERE modelid = 27929;
UPDATE `creature_model_info` SET `combat_reach` = '2.55' WHERE modelid = 27930;
UPDATE `creature_model_info` SET `combat_reach` = '2.55' WHERE modelid = 27931;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27944;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27949;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27952;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27954;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27955;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27956;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27958;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 27959;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27960;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27961;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27962;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27963;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27965;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27972;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27998;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27999;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28000;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28006;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28119;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28123;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28124;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28125;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 28143;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 28144;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28145;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 28146;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28147;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28148;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28149;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28150;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28152;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28153;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28154;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28155;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28156;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28157;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28159;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 28160;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28161;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 28162;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28163;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28164;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 28165;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28166;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 28167;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28168;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28169;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28170;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 28171;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28172;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28173;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28174;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28175;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28178;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28180;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28181;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28182;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28184;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28185;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 28186;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28187;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28188;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28189;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28191;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 28192;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28193;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28194;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28195;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28196;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 28199;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28200;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28201;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28202;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28203;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28204;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 28205;
UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 28207;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28208;
UPDATE `creature_model_info` SET `combat_reach` = '0.6' WHERE modelid = 28212;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 28212;
UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 28222;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 28282;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28317;
UPDATE `creature_model_info` SET `combat_reach` = '0.825' WHERE modelid = 28318;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 28318;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 28432;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28433;
UPDATE `creature_model_info` SET `gender` = '0' WHERE modelid = 28618;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28680;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28755;
UPDATE `creature_model_info` SET `bounding_radius` = '1' WHERE modelid = 28918;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28918;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28986;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28987;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 29076;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 29132;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 29145;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 29743;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 30310;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 30311;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 30358;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 30415;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 30439;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 30764;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 30841;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 30842;
UPDATE `creature_model_info` SET `combat_reach` = '0' WHERE modelid = 31548;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 385;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 721;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 1412;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 3835;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 4075;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 6653;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 10218;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 10218;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 14881;
UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 16128;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 17213;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 19481;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 19481;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 19871;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 20735;
UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 22015;
UPDATE `creature_template` SET `faction_A` = '2204', `faction_H` = '2204' WHERE entry = 22445;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 24026;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 24196;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 24206;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 24212;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 24261;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 25058;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 27852;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 27870;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 27870;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 28036;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 28053;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 28078;
UPDATE `creature_template` SET `speed_walk` = '1.11111' WHERE entry = 28113;
UPDATE `creature_template` SET `faction_A` = '14', `faction_H` = '14' WHERE entry = 28123;
UPDATE `creature_template` SET `faction_A` = '14', `faction_H` = '14' WHERE entry = 28124;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 28255;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 28274;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 28401;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 28561;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 28672;
UPDATE `creature_template` SET `faction_A` = '2027', `faction_H` = '2027' WHERE entry = 28705;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 28844;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28990;
UPDATE `creature_template` SET `faction_A` = '2007', `faction_H` = '2007' WHERE entry = 29156;
UPDATE `creature_template` SET `speed_run` = '2.14286' WHERE entry = 29264;
UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 29264;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 29264;
UPDATE `creature_template` SET `faction_A` = '2007', `faction_H` = '2007' WHERE entry = 29512;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29667;
UPDATE `creature_template` SET `faction_A` = '534', `faction_H` = '534' WHERE entry = 29667;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29668;
UPDATE `creature_template` SET `faction_A` = '534', `faction_H` = '534' WHERE entry = 29668;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29669;
UPDATE `creature_template` SET `faction_A` = '534', `faction_H` = '534' WHERE entry = 29669;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29670;
UPDATE `creature_template` SET `faction_A` = '534', `faction_H` = '534' WHERE entry = 29670;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29671;
UPDATE `creature_template` SET `faction_A` = '534', `faction_H` = '534' WHERE entry = 29671;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29672;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29673;
UPDATE `creature_template` SET `faction_A` = '714', `faction_H` = '714' WHERE entry = 29673;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29674;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29675;
UPDATE `creature_template` SET `faction_A` = '714', `faction_H` = '714' WHERE entry = 29675;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29676;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29691;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 29692;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29763;
UPDATE `creature_template` SET `faction_A` = '1375', `faction_H` = '1375' WHERE entry = 29763;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29764;
UPDATE `creature_template` SET `faction_A` = '1375', `faction_H` = '1375' WHERE entry = 29764;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29765;
UPDATE `creature_template` SET `faction_A` = '1375', `faction_H` = '1375' WHERE entry = 29765;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29766;
UPDATE `creature_template` SET `faction_A` = '1375', `faction_H` = '1375' WHERE entry = 29766;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29802;
UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 29802;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 29807;
UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 29929;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 30094;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 30095;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 30115;
UPDATE `creature_template` SET `faction_A` = '2007', `faction_H` = '2007' WHERE entry = 30116;
UPDATE `creature_template` SET `faction_A` = '2007', `faction_H` = '2007' WHERE entry = 30117;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 30560;
UPDATE `creature_template` SET `scale` = '1' WHERE entry = 30856;
UPDATE `creature_template` SET `speed_run` = '1.14286' WHERE entry = 30864;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 31081;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 31085;
UPDATE `creature_template` SET `faction_A` = '634', `faction_H` = '634' WHERE entry = 31231;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 31238;
UPDATE `creature_template` SET `faction_A` = '2007', `faction_H` = '2007' WHERE entry = 31238;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31709;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31710;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31711;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31714;
UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 31719;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31728;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31729;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31730;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31732;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31733;
UPDATE `creature_template` SET `speed_walk` = '0.4' WHERE entry = 31733;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31735;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31740;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31741;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31742;
UPDATE `creature_template` SET `speed_walk` = '1' WHERE entry = 31755;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31795;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31796;
UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 31852;
UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 31852;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 31885;
UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 31885;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 31886;
UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 31886;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 32207;
UPDATE `creature_template` SET `speed_walk` = '0.4' WHERE entry = 32265;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 32336;
UPDATE `creature_template` SET `speed_run` = '0.714286' WHERE entry = 32428;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 32450;
UPDATE `creature_template` SET `speed_run` = '0.714286' WHERE entry = 32466;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 32470;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 32597;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 32598;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 32600;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 32606;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 32653;
UPDATE `creature_template` SET `baseattacktime` = '1000' WHERE entry = 32653;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 32695;
UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 32697;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 32700;
UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 32702;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 32704;
UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 32706;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 32708;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 32710;
UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 32711;
UPDATE `creature_template` SET `faction_A` = '2007', `faction_H` = '2007' WHERE entry = 32712;
UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 32713;
UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 32715;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 32716;
UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 32717;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 32718;
UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 32719;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 32746;
UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 32751;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 32752;
UPDATE `creature_template` SET `faction_A` = '2007', `faction_H` = '2007' WHERE entry = 32844;
UPDATE `creature_template` SET `faction_A` = '2204', `faction_H` = '2204' WHERE entry = 33010;
UPDATE `creature_template` SET `faction_A` = '2204', `faction_H` = '2204' WHERE entry = 33011;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 33224;
UPDATE `creature_template` SET `faction_A` = '2070', `faction_H` = '2070' WHERE entry = 34244;
UPDATE `creature_template` SET `faction_A` = '2007', `faction_H` = '2007' WHERE entry = 34252;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 34330;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 34952;
UPDATE `creature_template` SET `faction_A` = '534', `faction_H` = '534' WHERE entry = 34952;
UPDATE `creature_template` SET `speed_run` = '1' WHERE entry = 34953;
UPDATE `creature_template` SET `faction_A` = '714', `faction_H` = '714' WHERE entry = 34953;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 34984;
UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 35495;
UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 35508;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 35594;
UPDATE `creature_template` SET `faction_A` = '534', `faction_H` = '534' WHERE entry = 35594;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 35607;
UPDATE `creature_template` SET `faction_A` = '714', `faction_H` = '714' WHERE entry = 35607;
UPDATE `creature_template` SET `unit_class` = '4' WHERE entry = 36774;
UPDATE `creature_template` SET `faction_A` = '2027', `faction_H` = '2027' WHERE entry = 36774;
UPDATE `creature_template` SET `unit_class` = '4' WHERE entry = 36776;
UPDATE `creature_template` SET `faction_A` = '534', `faction_H` = '534' WHERE entry = 37776;
UPDATE `creature_template` SET `faction_A` = '714', `faction_H` = '714' WHERE entry = 37780;
UPDATE `creature_template` SET `speed_run` = '2.28571' WHERE entry = 40160;
Код:
-- Wow Object: (High: Unit, Entry: 4075, Counter: 10,010,922)
SET @GUID := 101279;
REPLACE 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 ('@GUID', '4075', '571', '1', '1', '1141', '0', '5744.057', '530.3785', '652.8215', '5.613226', '300', '0', '0', '8', '0', '0', '2');
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID*10, 0, 0, 1, 0, '');
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID*10, '1', '5735.67300', '5735.67300', '652.83320'),
(@GUID*10, '2', '5736.59100', '5736.59100', '652.83320'),
(@GUID*10, '3', '5737.96800', '5737.96800', '652.81840'),
(@GUID*10, '4', '5739.18400', '5739.18400', '652.82040'),
(@GUID*10, '5', '5739.74400', '5739.74400', '652.82460'),
(@GUID*10, '6', '5746.11000', '5746.11000', '652.82000'),
(@GUID*10, '7', '5751.63800', '5751.63800', '652.79990'),
(@GUID*10, '8', '5752.31800', '5752.31800', '652.87450'),
(@GUID*10, '9', '5752.31800', '5752.31800', '652.87450');
Код:
-- Wow Object: (High: Unit, Entry: 32265, Counter: 39,358)
SET @GUID := 112281;
REPLACE 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('@GUID', '32265', '571', '1', '1', '17200', '0', '5702.116', '586.9582', '653.6385', '0.8802986', '300', '0', '0', '6986', '0', '0', '2');
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID*10, 0, 50331648, 1, 0, '');
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID*10, '1', '5700.71900', '5700.71900', '653.64290'),
(@GUID*10, '2', '5701.35500', '5701.35500', '653.64290'),
(@GUID*10, '3', '5702.14300', '5702.14300', '653.63830'),
(@GUID*10, '4', '5704.13700', '5704.13700', '653.64000'),
(@GUID*10, '5', '5704.13700', '5704.13700', '653.64000');
Код:
-- Wow Object: (High: Unit, Entry: 30137, Counter: 7,949)
SET @GUID := 98230;
REPLACE 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 ('@GUID', '30137', '571', '1', '1', '26779', '0', '5817.645', '647.8217', '609.8859', '5.015419', '300', '0', '0', '10282', '0', '0', '2');
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID*10, 0, 0, 1, 0, '');
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID*10, '1', '5819.04900', '5819.04900', '609.27090'),
(@GUID*10, '2', '5818.50900', '5818.50900', '609.27090'),
(@GUID*10, '3', '5817.78400', '5817.78400', '609.91120'),
(@GUID*10, '4', '5817.21900', '5817.21900', '609.88590'),
(@GUID*10, '5', '5818.43500', '5818.43500', '609.88590'),
(@GUID*10, '6', '5819.58800', '5819.58800', '609.88590'),
(@GUID*10, '7', '5819.83700', '5819.83700', '609.88590'),
(@GUID*10, '8', '5819.83700', '5819.83700', '609.88590');
Код:
-- Wow Object: (High: Unit, Entry: 32725, Counter: 21,472)
SET @GUID := 108995;
REPLACE 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 ('@GUID', '32725', '571', '1', '1', '23337', '0', '5823.797', '776.4014', '661.3621', '0.2817785', '300', '0', '0', '7688', '7500', '0', '2');
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID*10, 0, 0, 1, 0, '');
DELETE FROM `waypoint_data` WHERE `id` = @GUID*10;
INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID*10, '1', '5821.90100', '5821.90100', '661.36200'),
(@GUID*10, '2', '5822.86100', '5822.86100', '661.36200'),
(@GUID*10, '3', '5826.87300', '5826.87300', '661.36250'),
(@GUID*10, '4', '5826.87300', '5826.87300', '661.36250');
Код:
-- Wow Object: (High: Unit, Entry: 29802, Counter: 13,619)
SET @GUID := 108925;
REPLACE 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 ('@GUID', '29802', '571', '1', '1', '26557', '0', '5813.73', '682.5225', '653.603', '0.1830185', '300', '0', '0', '42', '0', '0', '2');
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID*10, 0, 0, 1, 0, '');
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID*10, '1', '5808.22500', '5808.22500', '653.63230'),
(@GUID*10, '2', '5809.84200', '5809.84200', '653.68620'),
(@GUID*10, '3', '5813.70900', '5813.70900', '653.60330'),
(@GUID*10, '4', '5816.81500', '5816.81500', '653.57550'),
(@GUID*10, '5', '5817.20000', '5817.20000', '653.63100'),
(@GUID*10, '6', '5814.23500', '5814.23500', '653.65870'),
(@GUID*10, '7', '5809.92900', '5809.92900', '653.76970'),
(@GUID*10, '8', '5808.22500', '5808.22500', '653.63230'),
(@GUID*10, '9', '5809.84200', '5809.84200', '653.68620'),
(@GUID*10, '10', '5813.70900', '5813.70900', '653.60330');
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян
Последний раз редактировалось Heisenberg; 23.03.2011 в 21:13.
|