[Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's

Yes, new daily updates will be nice ;)

ABD
Black DB
DarkRevolution DB
FGDB
PDB
Rus DB
SDB
Yelly DB

Doomed? No. Delayed? Yes

In the end it comes down to personal preference on which server one uses.

Both exceed well at what they do they just have different development methods and visions but for the end user I think it comes down to personal preference.

Only the future will tell.

next release will be ready tomorow, i'm at school right now and will be home at 1:00am.
So i dont really have time now.... (webdesign school so no c++ compiler here on pc)

Tomorow i'll make a new post with daily update's of the newest rev's

if anyone has some suggestions for the new release or maybe some new extra's they want, let me know and i'll see what i can do...

Next release is gonna be tomorow at about 19:30 - 22:00 +1 GTM (i live in holland (netherlands) )

Quote:

---

Originally Posted by VizualG

if anyone has some suggestions for the new release or maybe some new extra's they want, let me know and i'll see what i can do...

---

Updated Character DB?


PS: Thanks for doing these daily compiles.:juggle:

thanks for the compiles VisualG! Appreciate it alot!

do u have the fix for first aid profession?

Thx for release just I have a problem with an coin item that would be your ID??

How do i install this do i need any other db or is everythign included ? :/

Cant figure out how to install it lol

These are just the trunk files to make a server with, i DONT include a character or world Database in the releases. just look at the sticky topic for a perfect guide to setup a server, only change is u use these files for the server...

if u mean the coin NPC the spawn id is: 55560

what is the best DB to use with this? i used NCDB milestone 0.2.1 and then executed your updates on top of that, and everything works fine, except for a few things. it seems that the flags for about 90% of the NPCs are wrong....for example....you cannot speak to normal quest givers, vendors, or anyone else......all of the trainers are acting like they only have the "gossip" flag set, where they display the "book" icon when you highlight them, but display the simple gossip text, with no available selections. the flags in the DB are correct, but im not sure where the problem would be....i dont have a clue where to find the new NCDB revs and the only SVN link i had, doesnt work anymore....any help would be greatly appreciated.....

they changed the NPC flags, so youre DB needs the NPCflags update for everything to work again.

Code:

---

update creature_proto set npcflags=4224 where entry=54;
update creature_proto set npcflags=128 where entry=66;
update creature_proto set npcflags=268435457 where entry=68;
update creature_proto set npcflags=4224 where entry=74;
update creature_proto set npcflags=4224 where entry=78;
update creature_proto set npcflags=128 where entry=151;
update creature_proto set npcflags=128 where entry=152;
update creature_proto set npcflags=4224 where entry=167;
update creature_proto set npcflags=4224 where entry=190;
update creature_proto set npcflags=2 where entry=196;
update creature_proto set npcflags=3 where entry=197;
update creature_proto set npcflags=19 where entry=198;
update creature_proto set npcflags=4226 where entry=222;
update creature_proto set npcflags=19 where entry=223;
update creature_proto set npcflags=4224 where entry=225;
update creature_proto set npcflags=4224 where entry=226;
update creature_proto set npcflags=384 where entry=227;
update creature_proto set npcflags=4480 where entry=228;
update creature_proto set npcflags=643 where entry=233;
update creature_proto set npcflags=2 where entry=234;
update creature_proto set npcflags=2 where entry=235;
update creature_proto set npcflags=2 where entry=237;
update creature_proto set npcflags=2 where entry=238;
update creature_proto set npcflags=2 where entry=239;
update creature_proto set npcflags=2 where entry=240;
update creature_proto set npcflags=2 where entry=241;
update creature_proto set npcflags=2 where entry=244;
update creature_proto set npcflags=2 where entry=246;
update creature_proto set npcflags=2 where entry=247;
update creature_proto set npcflags=2 where entry=248;
update creature_proto set npcflags=2 where entry=250;
update creature_proto set npcflags=2 where entry=251;
update creature_proto set npcflags=2 where entry=252;
update creature_proto set npcflags=2 where entry=253;
update creature_proto set npcflags=2 where entry=255;
update creature_proto set npcflags=128 where entry=258;
update creature_proto set npcflags=2 where entry=261;
update creature_proto set npcflags=2 where entry=263;
update creature_proto set npcflags=2 where entry=264;
update creature_proto set npcflags=2 where entry=265;
update creature_proto set npcflags=2 where entry=266;
update creature_proto set npcflags=2 where entry=267;
update creature_proto set npcflags=2 where entry=268;
update creature_proto set npcflags=2 where entry=270;
update creature_proto set npcflags=2 where entry=271;
update creature_proto set npcflags=2 where entry=272;
update creature_proto set npcflags=2 where entry=273;
update creature_proto set npcflags=640 where entry=274;
update creature_proto set npcflags=2 where entry=275;
update creature_proto set npcflags=2 where entry=276;
update creature_proto set npcflags=641 where entry=277;
update creature_proto set npcflags=2 where entry=278;
update creature_proto set npcflags=2 where entry=279;
update creature_proto set npcflags=2 where entry=288;
update creature_proto set npcflags=2 where entry=289;
update creature_proto set npcflags=2 where entry=294;
update creature_proto set npcflags=65667 where entry=295;
update creature_proto set npcflags=2 where entry=297;
update creature_proto set npcflags=2 where entry=302;
update creature_proto set npcflags=2 where entry=311;
update creature_proto set npcflags=2 where entry=313;
update creature_proto set npcflags=19 where entry=328;
update creature_proto set npcflags=19 where entry=331;
update creature_proto set npcflags=3 where entry=332;
update creature_proto set npcflags=2 where entry=338;
update creature_proto set npcflags=128 where entry=340;
update creature_proto set npcflags=2 where entry=341;
update creature_proto set npcflags=2 where entry=342;
update creature_proto set npcflags=2 where entry=343;
update creature_proto set npcflags=2 where entry=344;
update creature_proto set npcflags=2 where entry=346;
update creature_proto set npcflags=1048577 where entry=347;
update creature_proto set npcflags=2 where entry=348;
update creature_proto set npcflags=2 where entry=349;
update creature_proto set npcflags=8195 where entry=352;
update creature_proto set npcflags=8195 where entry=353;
update creature_proto set npcflags=130 where entry=372;
update creature_proto set npcflags=2 where entry=374;
update creature_proto set npcflags=19 where entry=375;
update creature_proto set npcflags=19 where entry=376;
update creature_proto set npcflags=19 where entry=377;
update creature_proto set npcflags=2 where entry=379;
update creature_proto set npcflags=2 where entry=381;
update creature_proto set npcflags=2 where entry=382;
update creature_proto set npcflags=2 where entry=383;
update creature_proto set npcflags=131 where entry=384;
update creature_proto set npcflags=2 where entry=392;
update creature_proto set npcflags=2 where entry=415;
update creature_proto set npcflags=19 where entry=459;
update creature_proto set npcflags=19 where entry=460;
update creature_proto set npcflags=19 where entry=461;
update creature_proto set npcflags=2 where entry=464;
update creature_proto set npcflags=128 where entry=465;
update creature_proto set npcflags=2 where entry=466;
update creature_proto set npcflags=2 where entry=467;
update creature_proto set npcflags=2 where entry=469;
update creature_proto set npcflags=2 where entry=482;
update creature_proto set npcflags=641 where entry=483;
update creature_proto set npcflags=387 where entry=491;
update creature_proto set npcflags=19 where entry=514;
update creature_proto set npcflags=8195 where entry=523;
update creature_proto set npcflags=19 where entry=543;
update creature_proto set npcflags=2 where entry=576;
update creature_proto set npcflags=2 where entry=621;
update creature_proto set npcflags=2 where entry=633;
update creature_proto set npcflags=2 where entry=656;
update creature_proto set npcflags=2 where entry=658;
update creature_proto set npcflags=2 where entry=661;
update creature_proto set npcflags=2 where entry=663;
update creature_proto set npcflags=2 where entry=664;
update creature_proto set npcflags=2 where entry=713;
update creature_proto set npcflags=2 where entry=714;
update creature_proto set npcflags=3 where entry=715;
update creature_proto set npcflags=3 where entry=716;
update creature_proto set npcflags=2 where entry=717;
update creature_proto set npcflags=2 where entry=718;
update creature_proto set npcflags=268435457 where entry=727;
update creature_proto set npcflags=2 where entry=733;
update creature_proto set npcflags=128 where entry=734;
update creature_proto set npcflags=2 where entry=737;
update creature_proto set npcflags=3 where entry=738;
update creature_proto set npcflags=2 where entry=739;
update creature_proto set npcflags=2 where entry=770;
update creature_proto set npcflags=2 where entry=771;
update creature_proto set npcflags=2 where entry=773;
update creature_proto set npcflags=128 where entry=777;
update creature_proto set npcflags=2 where entry=786;
update creature_proto set npcflags=4480 where entry=789;
update creature_proto set npcflags=128 where entry=790;
update creature_proto set npcflags=384 where entry=791;
update creature_proto set npcflags=4224 where entry=793;
update creature_proto set npcflags=17 where entry=812;
update creature_proto set npcflags=2 where entry=820;
update creature_proto set npcflags=2 where entry=821;
update creature_proto set npcflags=2 where entry=823;
update creature_proto set npcflags=130 where entry=829;
update creature_proto set npcflags=4227 where entry=836;
update creature_proto set npcflags=19 where entry=837;
update creature_proto set npcflags=2 where entry=840;
update creature_proto set npcflags=128 where entry=843;
update creature_proto set npcflags=128 where entry=844;
update creature_proto set npcflags=2 where entry=851;
update creature_proto set npcflags=1048577 where entry=857;
update creature_proto set npcflags=2 where entry=859;
update creature_proto set npcflags=2 where entry=878;
update creature_proto set npcflags=2 where entry=888;
update creature_proto set npcflags=2 where entry=893;
update creature_proto set npcflags=128 where entry=894;
update creature_proto set npcflags=19 where entry=895;
update creature_proto set npcflags=4224 where entry=896;
update creature_proto set npcflags=2 where entry=900;
update creature_proto set npcflags=2 where entry=903;
update creature_proto set npcflags=17 where entry=906;
update creature_proto set npcflags=1048577 where entry=907;
update creature_proto set npcflags=16 where entry=908;
update creature_proto set npcflags=19 where entry=911;
update creature_proto set npcflags=19 where entry=912;
update creature_proto set npcflags=19 where entry=913;
update creature_proto set npcflags=17 where entry=914;
update creature_proto set npcflags=19 where entry=915;
update creature_proto set npcflags=19 where entry=916;
update creature_proto set npcflags=19 where entry=917;
update creature_proto set npcflags=19 where entry=918;
update creature_proto set npcflags=19 where entry=925;
update creature_proto set npcflags=19 where entry=926;
update creature_proto set npcflags=19 where entry=927;
update creature_proto set npcflags=19 where entry=928;
update creature_proto set npcflags=8193 where entry=931;
update creature_proto set npcflags=19 where entry=944;
update creature_proto set npcflags=4224 where entry=945;
update creature_proto set npcflags=2 where entry=951;
update creature_proto set npcflags=2 where entry=952;
update creature_proto set npcflags=4226 where entry=954;
update creature_proto set npcflags=128 where entry=955;
update creature_proto set npcflags=4224 where entry=956;
update creature_proto set npcflags=17 where entry=957;
update creature_proto set npcflags=128 where entry=958;
update creature_proto set npcflags=4224 where entry=959;
update creature_proto set npcflags=128 where entry=960;
update creature_proto set npcflags=3 where entry=963;
update creature_proto set npcflags=4224 where entry=980;
update creature_proto set npcflags=4224 where entry=981;
update creature_proto set npcflags=128 where entry=982;
update creature_proto set npcflags=128 where entry=983;
update creature_proto set npcflags=4224 where entry=984;
update creature_proto set npcflags=17 where entry=985;
update creature_proto set npcflags=17 where entry=986;
update creature_proto set npcflags=17 where entry=987;
update creature_proto set npcflags=17 where entry=988;
update creature_proto set npcflags=128 where entry=989;
update creature_proto set npcflags=2 where entry=1068;
update creature_proto set npcflags=2 where entry=1070;
update creature_proto set npcflags=2 where entry=1071;
update creature_proto set npcflags=2 where entry=1072;
update creature_proto set npcflags=2 where entry=1073;
update creature_proto set npcflags=2 where entry=1074;
update creature_proto set npcflags=2 where entry=1075;
update creature_proto set npcflags=2 where entry=1076;
update creature_proto set npcflags=2 where entry=1077;
update creature_proto set npcflags=2 where entry=1078;
update creature_proto set npcflags=2 where entry=1089;
update creature_proto set npcflags=2 where entry=1090;
update creature_proto set npcflags=2 where entry=1091;
update creature_proto set npcflags=2 where entry=1092;
update creature_proto set npcflags=2 where entry=1093;
update creature_proto set npcflags=17 where entry=1103;
update creature_proto set npcflags=4224 where entry=1104;
update creature_proto set npcflags=2 where entry=1105;
update creature_proto set npcflags=2 where entry=1139;
update creature_proto set npcflags=2 where entry=1141;
update creature_proto set npcflags=4224 where entry=1146;
update creature_proto set npcflags=4224 where entry=1147;
update creature_proto set npcflags=128 where entry=1148;
update creature_proto set npcflags=128 where entry=1149;
update creature_proto set npcflags=2 where entry=1154;
update creature_proto set npcflags=2 where entry=1156;
update creature_proto set npcflags=2 where entry=1182;
update creature_proto set npcflags=2 where entry=1187;
update creature_proto set npcflags=4224 where entry=1198;
update creature_proto set npcflags=2 where entry=1212;
update creature_proto set npcflags=4224 where entry=1213;
update creature_proto set npcflags=4226 where entry=1214;
update creature_proto set npcflags=19 where entry=1215;
update creature_proto set npcflags=2 where entry=1217;
update creature_proto set npcflags=19 where entry=1218;
update creature_proto set npcflags=19 where entry=1226;
update creature_proto set npcflags=19 where entry=1228;
update creature_proto set npcflags=19 where entry=1229;
update creature_proto set npcflags=19 where entry=1231;
update creature_proto set npcflags=19 where entry=1232;
update creature_proto set npcflags=8195 where entry=1233;
update creature_proto set npcflags=19 where entry=1234;
update creature_proto set npcflags=130 where entry=1237;
update creature_proto set npcflags=4226 where entry=1238;
update creature_proto set npcflags=2 where entry=1239;
update creature_proto set npcflags=4224 where entry=1240;
update creature_proto set npcflags=19 where entry=1241;
update creature_proto set npcflags=2 where entry=1242;
update creature_proto set npcflags=4226 where entry=1243;
update creature_proto set npcflags=2 where entry=1244;
update creature_proto set npcflags=2 where entry=1245;
update creature_proto set npcflags=17 where entry=1246;
update creature_proto set npcflags=65667 where entry=1247;
update creature_proto set npcflags=4224 where entry=1249;
update creature_proto set npcflags=128 where entry=1250;
update creature_proto set npcflags=2 where entry=1252;
update creature_proto set npcflags=2 where entry=1254;
update creature_proto set npcflags=2 where entry=1256;
update creature_proto set npcflags=2177 where entry=1257;
update creature_proto set npcflags=129 where entry=1261;
update creature_proto set npcflags=130 where entry=1263;
update creature_proto set npcflags=2 where entry=1265;
update creature_proto set npcflags=2 where entry=1266;
update creature_proto set npcflags=2 where entry=1267;
update creature_proto set npcflags=2 where entry=1268;
update creature_proto set npcflags=2 where entry=1269;
update creature_proto set npcflags=4224 where entry=1273;
update creature_proto set npcflags=2 where entry=1274;
update creature_proto set npcflags=2177 where entry=1275;
update creature_proto set npcflags=2 where entry=1276;
update creature_proto set npcflags=2 where entry=1277;
update creature_proto set npcflags=2 where entry=1278;
update creature_proto set npcflags=2 where entry=1279;
update creature_proto set npcflags=2 where entry=1280;
update creature_proto set npcflags=2 where entry=1281;
update creature_proto set npcflags=2 where entry=1282;
update creature_proto set npcflags=2 where entry=1283;
update creature_proto set npcflags=2 where entry=1284;
update creature_proto set npcflags=385 where entry=1285;
update creature_proto set npcflags=129 where entry=1286;
update creature_proto set npcflags=4225 where entry=1287;
update creature_proto set npcflags=4225 where entry=1289;
update creature_proto set npcflags=4224 where entry=1291;
update creature_proto set npcflags=81 where entry=1292;
update creature_proto set npcflags=4225 where entry=1294;
update creature_proto set npcflags=4225 where entry=1295;
update creature_proto set npcflags=4224 where entry=1296;
update creature_proto set npcflags=4225 where entry=1297;
update creature_proto set npcflags=4481 where entry=1298;
update creature_proto set npcflags=4225 where entry=1299;
update creature_proto set npcflags=17 where entry=1300;
update creature_proto set npcflags=641 where entry=1301;
update creature_proto set npcflags=129 where entry=1302;
update creature_proto set npcflags=129 where entry=1303;
update creature_proto set npcflags=129 where entry=1304;
update creature_proto set npcflags=641 where entry=1305;
update creature_proto set npcflags=2177 where entry=1307;
update creature_proto set npcflags=2177 where entry=1308;
update creature_proto set npcflags=4227 where entry=1309;
update creature_proto set npcflags=4225 where entry=1310;
update creature_proto set npcflags=641 where entry=1311;
update creature_proto set npcflags=4225 where entry=1312;
update creature_proto set npcflags=129 where entry=1313;
update creature_proto set npcflags=4225 where entry=1314;
update creature_proto set npcflags=4225 where entry=1315;
update creature_proto set npcflags=128 where entry=1316;
update creature_proto set npcflags=17 where entry=1317;
update creature_proto set npcflags=129 where entry=1318;
update creature_proto set npcflags=4225 where entry=1319;
update creature_proto set npcflags=4225 where entry=1320;
update creature_proto set npcflags=129 where entry=1321;
update creature_proto set npcflags=4224 where entry=1322;
update creature_proto set npcflags=4227 where entry=1323;
update creature_proto set npcflags=4225 where entry=1324;
update creature_proto set npcflags=129 where entry=1325;
update creature_proto set npcflags=129 where entry=1326;
update creature_proto set npcflags=1 where entry=1327;
update creature_proto set npcflags=128 where entry=1328;
update creature_proto set npcflags=2 where entry=1329;
update creature_proto set npcflags=2 where entry=1330;
update creature_proto set npcflags=2 where entry=1331;
update creature_proto set npcflags=2 where entry=1332;
update creature_proto set npcflags=4225 where entry=1333;
update creature_proto set npcflags=2 where entry=1334;
update creature_proto set npcflags=2 where entry=1335;
update creature_proto set npcflags=2 where entry=1336;
update creature_proto set npcflags=2 where entry=1337;
update creature_proto set npcflags=2 where entry=1338;
update creature_proto set npcflags=4225 where entry=1339;
update creature_proto set npcflags=2 where entry=1340;
update creature_proto set npcflags=4225 where entry=1341;
update creature_proto set npcflags=2 where entry=1342;
update creature_proto set npcflags=2 where entry=1343;
update creature_proto set npcflags=2 where entry=1344;
update creature_proto set npcflags=2 where entry=1345;
update creature_proto set npcflags=17 where entry=1346;
update creature_proto set npcflags=129 where entry=1347;
update creature_proto set npcflags=4225 where entry=1348;
update creature_proto set npcflags=4225 where entry=1349;
update creature_proto set npcflags=4225 where entry=1350;
update creature_proto set npcflags=129 where entry=1351;
update creature_proto set npcflags=19 where entry=1355;
update creature_proto set npcflags=2 where entry=1356;
update creature_proto set npcflags=2 where entry=1358;
update creature_proto set npcflags=2 where entry=1360;
update creature_proto set npcflags=4224 where entry=1362;
update creature_proto set npcflags=3 where entry=1365;
update creature_proto set npcflags=2 where entry=1373;
update creature_proto set npcflags=2 where entry=1374;
update creature_proto set npcflags=2 where entry=1375;
update creature_proto set npcflags=2 where entry=1376;
update creature_proto set npcflags=2 where entry=1377;
update creature_proto set npcflags=2 where entry=1378;
update creature_proto set npcflags=2 where entry=1379;
update creature_proto set npcflags=4224 where entry=1381;
update creature_proto set npcflags=17 where entry=1382;
update creature_proto set npcflags=17 where entry=1383;
update creature_proto set npcflags=17 where entry=1385;
update creature_proto set npcflags=17 where entry=1386;
update creature_proto set npcflags=8193 where entry=1387;
update creature_proto set npcflags=17 where entry=1404;
update creature_proto set npcflags=4226 where entry=1407;
update creature_proto set npcflags=17 where entry=1411;
update creature_proto set npcflags=3 where entry=1416;
update creature_proto set npcflags=2 where entry=1422;
update creature_proto set npcflags=268435457 where entry=1423;
update creature_proto set npcflags=2 where entry=1427;
update creature_proto set npcflags=2 where entry=1428;
update creature_proto set npcflags=2 where entry=1429;
update creature_proto set npcflags=17 where entry=1430;
update creature_proto set npcflags=2 where entry=1431;
update creature_proto set npcflags=3 where entry=1432;
update creature_proto set npcflags=2 where entry=1435;
update creature_proto set npcflags=2 where entry=1437;
update creature_proto set npcflags=2 where entry=1439;
update creature_proto set npcflags=2 where entry=1440;
update creature_proto set npcflags=4224 where entry=1441;
update creature_proto set npcflags=2 where entry=1442;
update creature_proto set npcflags=2 where entry=1443;
update creature_proto set npcflags=2 where entry=1444;
update creature_proto set npcflags=386 where entry=1448;
update creature_proto set npcflags=2 where entry=1449;
update creature_proto set npcflags=4224 where entry=1450;
update creature_proto set npcflags=2 where entry=1451;
update creature_proto set npcflags=386 where entry=1452;
update creature_proto set npcflags=130 where entry=1453;
update creature_proto set npcflags=4226 where entry=1454;
update creature_proto set npcflags=130 where entry=1456;
update creature_proto set npcflags=1154 where entry=1457;
update creature_proto set npcflags=19 where entry=1458;
update creature_proto set npcflags=4482 where entry=1459;
update creature_proto set npcflags=131 where entry=1460;
update creature_proto set npcflags=4226 where entry=1461;
update creature_proto set npcflags=4482 where entry=1462;
update creature_proto set npcflags=2178 where entry=1463;
update creature_proto set npcflags=66179 where entry=1464;
update creature_proto set npcflags=130 where entry=1465;
update creature_proto set npcflags=19 where entry=1466;
update creature_proto set npcflags=4226 where entry=1469;
update creature_proto set npcflags=19 where entry=1470;
update creature_proto set npcflags=4224 where entry=1471;
update creature_proto set npcflags=16 where entry=1473;
update creature_proto set npcflags=130 where entry=1474;
update creature_proto set npcflags=268435457 where entry=1475;
update creature_proto set npcflags=2 where entry=1476;
update creature_proto set npcflags=2 where entry=1479;
update creature_proto set npcflags=2 where entry=1480;
update creature_proto set npcflags=2 where entry=1481;
update creature_proto set npcflags=2 where entry=1482;
update creature_proto set npcflags=2 where entry=1483;
update creature_proto set npcflags=2 where entry=1484;
update creature_proto set npcflags=2 where entry=1495;
update creature_proto set npcflags=3 where entry=1496;
update creature_proto set npcflags=2 where entry=1497;
update creature_proto set npcflags=2 where entry=1498;
update creature_proto set npcflags=2 where entry=1499;
update creature_proto set npcflags=2 where entry=1500;
update creature_proto set npcflags=2 where entry=1515;
update creature_proto set npcflags=2 where entry=1518;
update creature_proto set npcflags=2 where entry=1519;
update creature_proto set npcflags=2 where entry=1521;
update creature_proto set npcflags=2 where entry=1560;
update creature_proto set npcflags=2 where entry=1568;
update creature_proto set npcflags=3 where entry=1569;
update creature_proto set npcflags=2 where entry=1570;
update creature_proto set npcflags=8195 where entry=1571;
update creature_proto set npcflags=8195 where entry=1572;
update creature_proto set npcflags=8195 where entry=1573;
update creature_proto set npcflags=8195 where entry=1574;
update creature_proto set npcflags=8195 where entry=1575;
update creature_proto set npcflags=17 where entry=1632;
update creature_proto set npcflags=4224 where entry=1645;
update creature_proto set npcflags=2 where entry=1646;
update creature_proto set npcflags=128 where entry=1650;
update creature_proto set npcflags=17 where entry=1651;
update creature_proto set npcflags=3 where entry=1652;
update creature_proto set npcflags=2 where entry=1661;
update creature_proto set npcflags=4480 where entry=1668;
update creature_proto set npcflags=4224 where entry=1669;
update creature_proto set npcflags=640 where entry=1670;
update creature_proto set npcflags=642 where entry=1671;
update creature_proto set npcflags=128 where entry=1672;
update creature_proto set npcflags=2176 where entry=1673;
update creature_proto set npcflags=17 where entry=1676;
update creature_proto set npcflags=640 where entry=1678;
update creature_proto set npcflags=2 where entry=1679;
update creature_proto set npcflags=81 where entry=1680;
update creature_proto set npcflags=19 where entry=1681;
update creature_proto set npcflags=130 where entry=1682;
update creature_proto set npcflags=19 where entry=1683;
update creature_proto set npcflags=130 where entry=1684;
update creature_proto set npcflags=130 where entry=1685;
update creature_proto set npcflags=4226 where entry=1686;
update creature_proto set npcflags=4226 where entry=1687;
update creature_proto set npcflags=4226 where entry=1690;
update creature_proto set npcflags=130 where entry=1691;
update creature_proto set npcflags=130 where entry=1692;
update creature_proto set npcflags=130 where entry=1694;
update creature_proto set npcflags=4226 where entry=1695;
update creature_proto set npcflags=130 where entry=1697;
update creature_proto set npcflags=4224 where entry=1698;
update creature_proto set npcflags=19 where entry=1699;
update creature_proto set npcflags=19 where entry=1700;
update creature_proto set npcflags=19 where entry=1701;
update creature_proto set npcflags=19 where entry=1702;
update creature_proto set npcflags=19 where entry=1703;
update creature_proto set npcflags=2 where entry=1719;
update creature_proto set npcflags=2 where entry=1721;
update creature_proto set npcflags=2 where entry=1733;
update creature_proto set npcflags=268435457 where entry=1735;
update creature_proto set npcflags=268435457 where entry=1736;
update creature_proto set npcflags=268435457 where entry=1737;
update creature_proto set npcflags=268435457 where entry=1738;
update creature_proto set npcflags=268435457 where entry=1739;
update creature_proto set npcflags=2 where entry=1740;
update creature_proto set npcflags=268435457 where entry=1742;
update creature_proto set npcflags=268435457 where entry=1743;
update creature_proto set npcflags=268435457 where entry=1744;
update creature_proto set npcflags=268435459 where entry=1745;
update creature_proto set npcflags=268435457 where entry=1746;
update creature_proto set npcflags=2 where entry=1747;
update creature_proto set npcflags=2 where entry=1748;
update creature_proto set npcflags=3 where entry=1749;
update creature_proto set npcflags=2 where entry=1755;
update creature_proto set npcflags=2 where entry=1775;
update creature_proto set npcflags=2 where entry=1776;
update creature_proto set npcflags=2 where entry=1777;
update creature_proto set npcflags=2 where entry=1842;
update creature_proto set npcflags=2 where entry=1854;
update creature_proto set npcflags=3 where entry=1855;
update creature_proto set npcflags=2 where entry=1872;
update creature_proto set npcflags=19 where entry=1901;
update creature_proto set npcflags=2 where entry=1931;
update creature_proto set npcflags=2 where entry=1937;
update creature_proto set npcflags=2 where entry=1938;
update creature_proto set npcflags=2 where entry=1949;
update creature_proto set npcflags=2 where entry=1950;
update creature_proto set npcflags=2 where entry=1951;
update creature_proto set npcflags=2 where entry=1952;
update creature_proto set npcflags=2 where entry=1959;
update creature_proto set npcflags=2 where entry=1960;
update creature_proto set npcflags=2 where entry=1963;
update creature_proto set npcflags=2 where entry=1965;
update creature_proto set npcflags=268435457 where entry=1976;
update creature_proto set npcflags=2 where entry=1977;
update creature_proto set npcflags=2 where entry=1978;
update creature_proto set npcflags=2 where entry=1992;
update creature_proto set npcflags=268435456 where entry=2041;
update creature_proto set npcflags=4224 where entry=2046;
update creature_proto set npcflags=2 where entry=2050;
update creature_proto set npcflags=2 where entry=2055;
update creature_proto set npcflags=2 where entry=2057;
update creature_proto set npcflags=2 where entry=2058;
update creature_proto set npcflags=2 where entry=2077;
update creature_proto set npcflags=2 where entry=2078;
update creature_proto set npcflags=2 where entry=2079;
update creature_proto set npcflags=2 where entry=2080;
update creature_proto set npcflags=2 where entry=2082;
update creature_proto set npcflags=2 where entry=2083;
update creature_proto set npcflags=130 where entry=2084;
update creature_proto set npcflags=2 where entry=2086;
update creature_proto set npcflags=2 where entry=2092;
update creature_proto set npcflags=2 where entry=2093;
update creature_proto set npcflags=2 where entry=2094;
update creature_proto set npcflags=2 where entry=2096;
update creature_proto set npcflags=2 where entry=2097;
update creature_proto set npcflags=2 where entry=2099;
update creature_proto set npcflags=2 where entry=2104;
update creature_proto set npcflags=2 where entry=2105;
update creature_proto set npcflags=2 where entry=2107;
update creature_proto set npcflags=2 where entry=2111;
update creature_proto set npcflags=4226 where entry=2113;
update creature_proto set npcflags=19 where entry=2114;
update creature_proto set npcflags=386 where entry=2115;
update creature_proto set npcflags=4224 where entry=2116;
update creature_proto set npcflags=4224 where entry=2117;
update creature_proto set npcflags=130 where entry=2118;
update creature_proto set npcflags=19 where entry=2119;
update creature_proto set npcflags=2 where entry=2121;
update creature_proto set npcflags=51 where entry=2122;
update creature_proto set npcflags=19 where entry=2123;
update creature_proto set npcflags=19 where entry=2124;
update creature_proto set npcflags=19 where entry=2126;
update creature_proto set npcflags=19 where entry=2127;
update creature_proto set npcflags=19 where entry=2128;
update creature_proto set npcflags=19 where entry=2129;
update creature_proto set npcflags=51 where entry=2130;
update creature_proto set npcflags=19 where entry=2131;
update creature_proto set npcflags=19 where entry=2132;
update creature_proto set npcflags=386 where entry=2134;
update creature_proto set npcflags=4224 where entry=2135;
update creature_proto set npcflags=4224 where entry=2136;
update creature_proto set npcflags=4226 where entry=2137;
update creature_proto set npcflags=386 where entry=2140;
update creature_proto set npcflags=2 where entry=2142;
update creature_proto set npcflags=2 where entry=2150;
update creature_proto set npcflags=2 where entry=2151;
update creature_proto set npcflags=2 where entry=2153;
update creature_proto set npcflags=2 where entry=2155;
update creature_proto set npcflags=3 where entry=2198;
update creature_proto set npcflags=268435457 where entry=2209;
update creature_proto set npcflags=268435457 where entry=2210;
update creature_proto set npcflags=2 where entry=2211;
update creature_proto set npcflags=2 where entry=2214;
update creature_proto set npcflags=2 where entry=2215;
update creature_proto set npcflags=2 where entry=2216;
update creature_proto set npcflags=128 where entry=2225;
update creature_proto set npcflags=8195 where entry=2226;
update creature_proto set npcflags=2 where entry=2227;
update creature_proto set npcflags=2 where entry=2228;
update creature_proto set npcflags=2 where entry=2229;
update creature_proto set npcflags=2 where entry=2230;
update creature_proto set npcflags=3 where entry=2238;
update creature_proto set npcflags=3 where entry=2239;
update creature_proto set npcflags=2 where entry=2263;
update creature_proto set npcflags=147 where entry=2264;
update creature_proto set npcflags=130 where entry=2265;
update creature_proto set npcflags=2 where entry=2274;
update creature_proto set npcflags=2 where entry=2276;
update creature_proto set npcflags=2 where entry=2277;
update creature_proto set npcflags=2 where entry=2278;
update creature_proto set npcflags=2 where entry=2285;
update creature_proto set npcflags=8195 where entry=2299;
update creature_proto set npcflags=1048577 where entry=2302;
update creature_proto set npcflags=130 where entry=2303;
update creature_proto set npcflags=2 where entry=2308;
update creature_proto set npcflags=2 where entry=2316;
update creature_proto set npcflags=2 where entry=2317;
update creature_proto set npcflags=19 where entry=2326;
update creature_proto set npcflags=17 where entry=2327;
update creature_proto set npcflags=17 where entry=2329;
update creature_proto set npcflags=2 where entry=2333;
update creature_proto set npcflags=66179 where entry=2352;
update creature_proto set npcflags=131 where entry=2357;
update creature_proto set npcflags=2 where entry=2361;
update creature_proto set npcflags=2 where entry=2362;
update creature_proto set npcflags=2 where entry=2363;
update creature_proto set npcflags=642 where entry=2364;
update creature_proto set npcflags=642 where entry=2365;
update creature_proto set npcflags=642 where entry=2366;
update creature_proto set npcflags=83 where entry=2367;
update creature_proto set npcflags=2 where entry=2378;
update creature_proto set npcflags=2 where entry=2379;
update creature_proto set npcflags=130 where entry=2380;
update creature_proto set npcflags=130 where entry=2381;
update creature_proto set npcflags=2 where entry=2382;
update creature_proto set npcflags=130 where entry=2383;
update creature_proto set npcflags=2 where entry=2386;
update creature_proto set npcflags=66179 where entry=2388;
update creature_proto set npcflags=8195 where entry=2389;
update creature_proto set npcflags=19 where entry=2390;
update creature_proto set npcflags=19 where entry=2391;
update creature_proto set npcflags=131 where entry=2393;
update creature_proto set npcflags=130 where entry=2394;
update creature_proto set npcflags=128 where entry=2397;
update creature_proto set npcflags=19 where entry=2399;
update creature_proto set npcflags=386 where entry=2401;
update creature_proto set npcflags=4226 where entry=2404;
update creature_proto set npcflags=268435456 where entry=2405;
update creature_proto set npcflags=8193 where entry=2409;
update creature_proto set npcflags=2 where entry=2410;
update creature_proto set npcflags=2 where entry=2418;
update creature_proto set npcflags=2 where entry=2419;
update creature_proto set npcflags=3 where entry=2425;
update creature_proto set npcflags=2 where entry=2429;
update creature_proto set npcflags=2 where entry=2430;
update creature_proto set npcflags=8195 where entry=2432;
update creature_proto set npcflags=2 where entry=2433;
update creature_proto set npcflags=2 where entry=2434;
update creature_proto set npcflags=2 where entry=2437;
update creature_proto set npcflags=2 where entry=2438;
update creature_proto set npcflags=2 where entry=2439;
update creature_proto set npcflags=131073 where entry=2455;
update creature_proto set npcflags=131073 where entry=2456;
update creature_proto set npcflags=131073 where entry=2457;
update creature_proto set npcflags=131073 where entry=2458;
update creature_proto set npcflags=131073 where entry=2459;
update creature_proto set npcflags=131073 where entry=2460;
update creature_proto set npcflags=131073 where entry=2461;
update creature_proto set npcflags=2 where entry=2464;
update creature_proto set npcflags=2 where entry=2465;
update creature_proto set npcflags=2 where entry=2466;
update creature_proto set npcflags=2 where entry=2468;
update creature_proto set npcflags=2 where entry=2469;
update creature_proto set npcflags=2 where entry=2477;
update creature_proto set npcflags=2 where entry=2478;
update creature_proto set npcflags=130 where entry=2480;
update creature_proto set npcflags=130 where entry=2481;
update creature_proto set npcflags=4224 where entry=2482;
update creature_proto set npcflags=4224 where entry=2483;
update creature_proto set npcflags=17 where entry=2485;
update creature_proto set npcflags=2 where entry=2486;
update creature_proto set npcflags=2 where entry=2487;
update creature_proto set npcflags=2 where entry=2488;
update creature_proto set npcflags=19 where entry=2489;
update creature_proto set npcflags=2 where entry=2490;
update creature_proto set npcflags=2 where entry=2491;
update creature_proto set npcflags=19 where entry=2492;
update creature_proto set npcflags=2 where entry=2493;
update creature_proto set npcflags=2 where entry=2494;
update creature_proto set npcflags=2 where entry=2495;
update creature_proto set npcflags=3 where entry=2496;
update creature_proto set npcflags=2 where entry=2497;
update creature_proto set npcflags=2 where entry=2498;
update creature_proto set npcflags=2 where entry=2499;
update creature_proto set npcflags=2 where entry=2500;
update creature_proto set npcflags=2 where entry=2501;
update creature_proto set npcflags=2 where entry=2502;
update creature_proto set npcflags=2 where entry=2504;
update creature_proto set npcflags=2 where entry=2506;
update creature_proto set npcflags=2 where entry=2507;
update creature_proto set npcflags=2 where entry=2508;
update creature_proto set npcflags=2 where entry=2509;
update creature_proto set npcflags=2 where entry=2510;
update creature_proto set npcflags=2 where entry=2511;
update creature_proto set npcflags=2 where entry=2512;
update creature_proto set npcflags=2 where entry=2513;
update creature_proto set npcflags=2 where entry=2514;
update creature_proto set npcflags=2 where entry=2515;
update creature_proto set npcflags=2 where entry=2516;
update creature_proto set npcflags=2 where entry=2517;
update creature_proto set npcflags=2 where entry=2518;
update creature_proto set npcflags=2 where entry=2519;
update creature_proto set npcflags=2 where entry=2524;
update creature_proto set npcflags=2 where entry=2525;
update creature_proto set npcflags=2 where entry=2526;
update creature_proto set npcflags=2 where entry=2527;
update creature_proto set npcflags=2 where entry=2528;
update creature_proto set npcflags=2 where entry=2530;
update creature_proto set npcflags=2 where entry=2542;
update creature_proto set npcflags=2 where entry=2543;
update creature_proto set npcflags=2 where entry=2545;
update creature_proto set npcflags=2 where entry=2546;
update creature_proto set npcflags=2 where entry=2594;
update creature_proto set npcflags=2 where entry=2602;
update creature_proto set npcflags=2 where entry=2607;
update creature_proto set npcflags=2 where entry=2608;
update creature_proto set npcflags=2 where entry=2610;
update creature_proto set npcflags=2 where entry=2612;
update creature_proto set npcflags=2 where entry=2616;
update creature_proto set npcflags=268435456 where entry=2621;
update creature_proto set npcflags=1152 where entry=2622;
update creature_proto set npcflags=131072 where entry=2625;
update creature_proto set npcflags=128 where entry=2626;
update creature_proto set npcflags=81 where entry=2627;
update creature_proto set npcflags=2 where entry=2634;
update creature_proto set npcflags=128 where entry=2663;
update creature_proto set npcflags=128 where entry=2664;
update creature_proto set npcflags=128 where entry=2668;
update creature_proto set npcflags=128 where entry=2669;
update creature_proto set npcflags=131 where entry=2670;
update creature_proto set npcflags=128 where entry=2672;
update creature_proto set npcflags=4226 where entry=2679;
update creature_proto set npcflags=130 where entry=2682;
update creature_proto set npcflags=130 where entry=2683;
update creature_proto set npcflags=130 where entry=2684;
update creature_proto set npcflags=384 where entry=2685;
update creature_proto set npcflags=128 where entry=2687;
update creature_proto set npcflags=130 where entry=2688;
update creature_proto set npcflags=2 where entry=2695;
update creature_proto set npcflags=2 where entry=2696;
update creature_proto set npcflags=130 where entry=2697;
update creature_proto set npcflags=130 where entry=2698;
update creature_proto set npcflags=128 where entry=2699;
update creature_proto set npcflags=2 where entry=2700;
update creature_proto set npcflags=2 where entry=2703;
update creature_proto set npcflags=19 where entry=2704;
update creature_proto set npcflags=2 where entry=2705;
update creature_proto set npcflags=2 where entry=2706;
update creature_proto set npcflags=3 where entry=2708;
update creature_proto set npcflags=2 where entry=2711;
update creature_proto set npcflags=2 where entry=2712;
update creature_proto set npcflags=2 where entry=2713;
update creature_proto set npcflags=2 where entry=2738;
update creature_proto set npcflags=2 where entry=2766;
update creature_proto set npcflags=2 where entry=2767;
update creature_proto set npcflags=2 where entry=2768;
update creature_proto set npcflags=2 where entry=2769;
update creature_proto set npcflags=2 where entry=2770;
update creature_proto set npcflags=2 where entry=2771;
update creature_proto set npcflags=2 where entry=2772;
update creature_proto set npcflags=2 where entry=2774;
update creature_proto set npcflags=2 where entry=2780;
update creature_proto set npcflags=2 where entry=2781;
update creature_proto set npcflags=2 where entry=2782;
update creature_proto set npcflags=2 where entry=2784;
update creature_proto set npcflags=2 where entry=2785;
update creature_proto set npcflags=2 where entry=2786;
update creature_proto set npcflags=2 where entry=2787;
update creature_proto set npcflags=3 where entry=2788;
update creature_proto set npcflags=2 where entry=2789;
update creature_proto set npcflags=2 where entry=2790;
update creature_proto set npcflags=2 where entry=2792;
update creature_proto set npcflags=19 where entry=2796;
update creature_proto set npcflags=19 where entry=2798;
update creature_proto set npcflags=19 where entry=2801;
update creature_proto set npcflags=16 where entry=2802;
update creature_proto set npcflags=130 where entry=2803;
update creature_proto set npcflags=1048577 where entry=2804;
update creature_proto set npcflags=2178 where entry=2805;
update creature_proto set npcflags=130 where entry=2806;
update creature_proto set npcflags=386 where entry=2808;
update creature_proto set npcflags=130 where entry=2810;
update creature_proto set npcflags=130 where entry=2812;
update creature_proto set npcflags=642 where entry=2814;
update creature_proto set npcflags=130 where entry=2816;
update creature_proto set npcflags=2 where entry=2817;
update creature_proto set npcflags=208 where entry=2818;
update creature_proto set npcflags=130 where entry=2819;
update creature_proto set npcflags=386 where entry=2820;
update creature_proto set npcflags=130 where entry=2821;
update creature_proto set npcflags=640 where entry=2832;
update creature_proto set npcflags=81 where entry=2834;
update creature_proto set npcflags=8195 where entry=2835;
update creature_proto set npcflags=17 where entry=2836;
update creature_proto set npcflags=17 where entry=2837;
update creature_proto set npcflags=128 where entry=2838;
update creature_proto set npcflags=4480 where entry=2839;
update creature_proto set npcflags=4224 where entry=2840;
update creature_proto set npcflags=640 where entry=2842;
update creature_proto set npcflags=4224 where entry=2843;
update creature_proto set npcflags=4224 where entry=2844;
update creature_proto set npcflags=4224 where entry=2845;
update creature_proto set npcflags=128 where entry=2846;
update creature_proto set npcflags=4224 where entry=2847;
update creature_proto set npcflags=128 where entry=2848;
update creature_proto set npcflags=4224 where entry=2849;
update creature_proto set npcflags=8195 where entry=2851;
update creature_proto set npcflags=19 where entry=2855;
update creature_proto set npcflags=16 where entry=2856;
update creature_proto set npcflags=19 where entry=2857;
update creature_proto set npcflags=8193 where entry=2858;
update creature_proto set npcflags=8193 where entry=2859;
update creature_proto set npcflags=2 where entry=2860;
update creature_proto set npcflags=8195 where entry=2861;
update creature_proto set npcflags=19 where entry=2878;
update creature_proto set npcflags=17 where entry=2879;
update creature_proto set npcflags=19 where entry=2880;
update creature_proto set npcflags=19 where entry=2881;
update creature_proto set npcflags=2 where entry=2888;
update creature_proto set npcflags=386 where entry=2908;
update creature_proto set npcflags=2 where entry=2909;
update creature_proto set npcflags=130 where entry=2910;
update creature_proto set npcflags=2 where entry=2911;
update creature_proto set npcflags=2 where entry=2912;
update creature_proto set npcflags=2 where entry=2913;
update creature_proto set npcflags=2 where entry=2916;
update creature_proto set npcflags=2 where entry=2917;
update creature_proto set npcflags=2 where entry=2918;
update creature_proto set npcflags=2 where entry=2920;
update creature_proto set npcflags=2 where entry=2921;
update creature_proto set npcflags=2 where entry=2930;
update creature_proto set npcflags=2 where entry=2934;
update creature_proto set npcflags=8195 where entry=2941;
update creature_proto set npcflags=144 where entry=2942;
update creature_proto set npcflags=1 where entry=2943;
update creature_proto set npcflags=2 where entry=2947;
update creature_proto set npcflags=2 where entry=2948;
update creature_proto set npcflags=2 where entry=2980;
update creature_proto set npcflags=2 where entry=2981;
update creature_proto set npcflags=2 where entry=2982;
update creature_proto set npcflags=2 where entry=2984;
update creature_proto set npcflags=2 where entry=2985;
update creature_proto set npcflags=2 where entry=2986;
update creature_proto set npcflags=2 where entry=2987;
update creature_proto set npcflags=2 where entry=2988;
update creature_proto set npcflags=2 where entry=2991;
update creature_proto set npcflags=2 where entry=2993;
update creature_proto set npcflags=2 where entry=2994;
update creature_proto set npcflags=8195 where entry=2995;
update creature_proto set npcflags=131073 where entry=2996;
update creature_proto set npcflags=4226 where entry=2997;
update creature_proto set npcflags=19 where entry=2998;
update creature_proto set npcflags=4226 where entry=2999;
update creature_proto set npcflags=4226 where entry=3000;
update creature_proto set npcflags=19 where entry=3001;
update creature_proto set npcflags=130 where entry=3002;
update creature_proto set npcflags=642 where entry=3003;
update creature_proto set npcflags=81 where entry=3004;
update creature_proto set npcflags=130 where entry=3005;
update creature_proto set npcflags=19 where entry=3007;
update creature_proto set npcflags=19 where entry=3008;
update creature_proto set npcflags=19 where entry=3009;
update creature_proto set npcflags=130 where entry=3010;
update creature_proto set npcflags=81 where entry=3011;
update creature_proto set npcflags=130 where entry=3012;
update creature_proto set npcflags=19 where entry=3013;
update creature_proto set npcflags=130 where entry=3014;
update creature_proto set npcflags=4482 where entry=3015;
update creature_proto set npcflags=130 where entry=3016;
update creature_proto set npcflags=642 where entry=3017;
update creature_proto set npcflags=4226 where entry=3018;
update creature_proto set npcflags=4226 where entry=3019;
update creature_proto set npcflags=4226 where entry=3020;
update creature_proto set npcflags=4226 where entry=3021;
update creature_proto set npcflags=4226 where entry=3022;
update creature_proto set npcflags=4226 where entry=3023;
update creature_proto set npcflags=642 where entry=3025;
update creature_proto set npcflags=83 where entry=3026;
update creature_proto set npcflags=130 where entry=3027;
update creature_proto set npcflags=83 where entry=3028;
update creature_proto set npcflags=130 where entry=3029;
update creature_proto set npcflags=19 where entry=3030;
update creature_proto set npcflags=19 where entry=3031;
update creature_proto set npcflags=19 where entry=3032;
update creature_proto set npcflags=19 where entry=3033;
update creature_proto set npcflags=19 where entry=3034;
update creature_proto set npcflags=19 where entry=3036;
update creature_proto set npcflags=19 where entry=3038;
update creature_proto set npcflags=19 where entry=3039;
update creature_proto set npcflags=19 where entry=3040;
update creature_proto set npcflags=19 where entry=3041;
update creature_proto set npcflags=19 where entry=3042;
update creature_proto set npcflags=19 where entry=3043;
update creature_proto set npcflags=19 where entry=3044;
update creature_proto set npcflags=19 where entry=3045;
update creature_proto set npcflags=19 where entry=3046;
update creature_proto set npcflags=19 where entry=3047;
update creature_proto set npcflags=19 where entry=3048;
update creature_proto set npcflags=19 where entry=3049;
update creature_proto set npcflags=2 where entry=3050;
update creature_proto set npcflags=3 where entry=3052;
update creature_proto set npcflags=4226 where entry=3053;
update creature_proto set npcflags=2 where entry=3054;
update creature_proto set npcflags=2 where entry=3055;
update creature_proto set npcflags=3 where entry=3057;
update creature_proto set npcflags=19 where entry=3059;
update creature_proto set npcflags=19 where entry=3060;
update creature_proto set npcflags=19 where entry=3061;
update creature_proto set npcflags=19 where entry=3062;
update creature_proto set npcflags=19 where entry=3063;
update creature_proto set npcflags=19 where entry=3064;
update creature_proto set npcflags=19 where entry=3065;
update creature_proto set npcflags=19 where entry=3066;
update creature_proto set npcflags=19 where entry=3067;
update creature_proto set npcflags=19 where entry=3069;
update creature_proto set npcflags=130 where entry=3072;
update creature_proto set npcflags=4224 where entry=3073;
update creature_proto set npcflags=4226 where entry=3074;
update creature_proto set npcflags=4224 where entry=3075;
update creature_proto set npcflags=130 where entry=3076;
update creature_proto set npcflags=4224 where entry=3077;
update creature_proto set npcflags=4226 where entry=3078;
update creature_proto set npcflags=4226 where entry=3079;
update creature_proto set npcflags=4224 where entry=3080;
update creature_proto set npcflags=130 where entry=3081;
update creature_proto set npcflags=2 where entry=3083;
update creature_proto set npcflags=268435457 where entry=3084;
update creature_proto set npcflags=128 where entry=3085;
update creature_proto set npcflags=640 where entry=3086;
update creature_proto set npcflags=81 where entry=3087;
update creature_proto set npcflags=4224 where entry=3088;
update creature_proto set npcflags=640 where entry=3089;
update creature_proto set npcflags=1152 where entry=3090;
update creature_proto set npcflags=128 where entry=3091;
update creature_proto set npcflags=4226 where entry=3092;
update creature_proto set npcflags=4226 where entry=3093;
update creature_proto set npcflags=4226 where entry=3095;
update creature_proto set npcflags=130 where entry=3096;
update creature_proto set npcflags=4226 where entry=3097;
update creature_proto set npcflags=128 where entry=3133;
update creature_proto set npcflags=130 where entry=3134;
update creature_proto set npcflags=1152 where entry=3135;
update creature_proto set npcflags=17 where entry=3136;
update creature_proto set npcflags=81 where entry=3137;
update creature_proto set npcflags=640 where entry=3138;
update creature_proto set npcflags=2 where entry=3139;
update creature_proto set npcflags=2 where entry=3140;
update creature_proto set npcflags=2 where entry=3142;
update creature_proto set npcflags=2 where entry=3143;
update creature_proto set npcflags=2 where entry=3144;
update creature_proto set npcflags=2 where entry=3145;
update creature_proto set npcflags=2 where entry=3147;
update creature_proto set npcflags=1 where entry=3149;
update creature_proto set npcflags=1 where entry=3150;
update creature_proto set npcflags=19 where entry=3153;
update creature_proto set npcflags=19 where entry=3154;
update creature_proto set npcflags=19 where entry=3155;
update creature_proto set npcflags=19 where entry=3156;
update creature_proto set npcflags=19 where entry=3157;
update creature_proto set npcflags=130 where entry=3158;
update creature_proto set npcflags=4224 where entry=3159;
update creature_proto set npcflags=4226 where entry=3160;
update creature_proto set npcflags=4224 where entry=3161;
update creature_proto set npcflags=4226 where entry=3162;
update creature_proto set npcflags=4224 where entry=3163;
update creature_proto set npcflags=130 where entry=3164;
update creature_proto set npcflags=4226 where entry=3165;
update creature_proto set npcflags=4226 where entry=3166;
update creature_proto set npcflags=4224 where entry=3167;
update creature_proto set npcflags=130 where entry=3168;
update creature_proto set npcflags=19 where entry=3169;
update creature_proto set npcflags=19 where entry=3170;
update creature_proto set npcflags=19 where entry=3171;
update creature_proto set npcflags=19 where entry=3172;
update creature_proto set npcflags=19 where entry=3173;
update creature_proto set npcflags=19 where entry=3174;
update creature_proto set npcflags=19 where entry=3175;
update creature_proto set npcflags=4224 where entry=3177;
update creature_proto set npcflags=640 where entry=3178;
update creature_proto set npcflags=83 where entry=3179;
update creature_proto set npcflags=130 where entry=3180;
update creature_proto set npcflags=83 where entry=3181;
update creature_proto set npcflags=19 where entry=3184;
update creature_proto set npcflags=19 where entry=3185;
update creature_proto set npcflags=130 where entry=3186;
update creature_proto set npcflags=130 where entry=3187;
update creature_proto set npcflags=2 where entry=3188;
update creature_proto set npcflags=2 where entry=3189;
update creature_proto set npcflags=2 where entry=3190;
update creature_proto set npcflags=2 where entry=3191;
update creature_proto set npcflags=2 where entry=3193;
update creature_proto set npcflags=2 where entry=3194;
update creature_proto set npcflags=2 where entry=3208;
update creature_proto set npcflags=2 where entry=3209;
update creature_proto set npcflags=268435457 where entry=3210;
update creature_proto set npcflags=268435457 where entry=3211;
update creature_proto set npcflags=268435457 where entry=3212;
update creature_proto set npcflags=268435457 where entry=3213;
update creature_proto set npcflags=268435457 where entry=3214;
update creature_proto set npcflags=268435457 where entry=3215;
update creature_proto set npcflags=3 where entry=3216;
update creature_proto set npcflags=268435457 where entry=3217;
update creature_proto set npcflags=268435457 where entry=3218;
update creature_proto set npcflags=268435457 where entry=3219;
update creature_proto set npcflags=268435457 where entry=3220;
update creature_proto set npcflags=268435457 where entry=3221;
update creature_proto set npcflags=268435457 where entry=3222;
update creature_proto set npcflags=268435457 where entry=3223;
update creature_proto set npcflags=268435457 where entry=3224;
update creature_proto set npcflags=3 where entry=3230;
update creature_proto set npcflags=2 where entry=3233;
update creature_proto set npcflags=2 where entry=3287;
update creature_proto set npcflags=19 where entry=3290;
update creature_proto set npcflags=130 where entry=3291;
update creature_proto set npcflags=2 where entry=3292;
update creature_proto set npcflags=2 where entry=3293;
update creature_proto set npcflags=2 where entry=3294;
update creature_proto set npcflags=268435457 where entry=3296;
update creature_proto set npcflags=268435456 where entry=3297;
update creature_proto set npcflags=642 where entry=3298;
update creature_proto set npcflags=2 where entry=3304;
update creature_proto set npcflags=8195 where entry=3305;
update creature_proto set npcflags=19 where entry=3306;
update creature_proto set npcflags=131075 where entry=3309;
update creature_proto set npcflags=8195 where entry=3310;
update creature_proto set npcflags=642 where entry=3312;
update creature_proto set npcflags=386 where entry=3313;
update creature_proto set npcflags=4227 where entry=3314;
update creature_proto set npcflags=4226 where entry=3315;
update creature_proto set npcflags=4226 where entry=3316;
update creature_proto set npcflags=4226 where entry=3317;
update creature_proto set npcflags=131073 where entry=3318;
update creature_proto set npcflags=4226 where entry=3319;
update creature_proto set npcflags=131073 where entry=3320;
update creature_proto set npcflags=4226 where entry=3321;
update creature_proto set npcflags=4226 where entry=3322;
update creature_proto set npcflags=2178 where entry=3323;
update creature_proto set npcflags=19 where entry=3324;
update creature_proto set npcflags=19 where entry=3325;
update creature_proto set npcflags=19 where entry=3326;
update creature_proto set npcflags=51 where entry=3327;
update creature_proto set npcflags=51 where entry=3328;
update creature_proto set npcflags=640 where entry=3329;
update creature_proto set npcflags=4224 where entry=3330;
update creature_proto set npcflags=4224 where entry=3331;
update creature_proto set npcflags=83 where entry=3332;
update creature_proto set npcflags=130 where entry=3333;
update creature_proto set npcflags=1152 where entry=3334;
update creature_proto set npcflags=2176 where entry=3335;
update creature_proto set npcflags=2 where entry=3336;
update creature_proto set npcflags=2 where entry=3337;
update creature_proto set npcflags=2 where entry=3338;
update creature_proto set npcflags=2 where entry=3339;
update creature_proto set npcflags=2 where entry=3341;
update creature_proto set npcflags=640 where entry=3342;
update creature_proto set npcflags=4224 where entry=3343;
update creature_proto set npcflags=19 where entry=3344;
update creature_proto set npcflags=81 where entry=3345;
update creature_proto set npcflags=130 where entry=3346;
update creature_proto set npcflags=17 where entry=3347;
update creature_proto set npcflags=128 where entry=3348;
update creature_proto set npcflags=4226 where entry=3349;
update creature_proto set npcflags=386 where entry=3350;
update creature_proto set npcflags=2178 where entry=3351;
update creature_proto set npcflags=19 where entry=3352;
update creature_proto set npcflags=19 where entry=3353;
update creature_proto set npcflags=19 where entry=3354;
update creature_proto set npcflags=19 where entry=3355;
update creature_proto set npcflags=4226 where entry=3356;
update creature_proto set npcflags=19 where entry=3357;
update creature_proto set npcflags=128 where entry=3358;
update creature_proto set npcflags=4224 where entry=3359;
update creature_proto set npcflags=4226 where entry=3360;
update creature_proto set npcflags=4226 where entry=3361;
update creature_proto set npcflags=131 where entry=3362;
update creature_proto set npcflags=83 where entry=3363;
update creature_proto set npcflags=130 where entry=3364;
update creature_proto set npcflags=19 where entry=3365;
update creature_proto set npcflags=130 where entry=3366;
update creature_proto set npcflags=130 where entry=3367;
update creature_proto set npcflags=642 where entry=3368;
update creature_proto set npcflags=130 where entry=3369;
update creature_proto set npcflags=786433 where entry=3370;
update creature_proto set npcflags=19 where entry=3373;
update creature_proto set npcflags=2 where entry=3387;
update creature_proto set npcflags=2 where entry=3388;
update creature_proto set npcflags=2 where entry=3389;
update creature_proto set npcflags=2 where entry=3390;
update creature_proto set npcflags=2 where entry=3391;
update creature_proto set npcflags=83 where entry=3399;
update creature_proto set npcflags=130 where entry=3400;
update creature_proto set npcflags=51 where entry=3401;
update creature_proto set npcflags=3 where entry=3402;
update creature_proto set npcflags=19 where entry=3403;
update creature_proto set npcflags=19 where entry=3404;
update creature_proto set npcflags=130 where entry=3405;
update creature_proto set npcflags=19 where entry=3406;
update creature_proto set npcflags=19 where entry=3407;
update creature_proto set npcflags=19 where entry=3408;
update creature_proto set npcflags=4226 where entry=3409;
update creature_proto set npcflags=4480 where entry=3410;
update creature_proto set npcflags=130 where entry=3411;
update creature_proto set npcflags=19 where entry=3412;
update creature_proto set npcflags=131 where entry=3413;
update creature_proto set npcflags=2 where entry=3418;
update creature_proto set npcflags=2 where entry=3419;
update creature_proto set npcflags=2 where entry=3421;
update creature_proto set npcflags=2 where entry=3428;
update creature_proto set npcflags=3 where entry=3429;
update creature_proto set npcflags=2 where entry=3430;
update creature_proto set npcflags=2 where entry=3431;
update creature_proto set npcflags=3 where entry=3432;
update creature_proto set npcflags=2 where entry=3433;
update creature_proto set npcflags=2 where entry=3439;
update creature_proto set npcflags=2 where entry=3441;
update creature_proto set npcflags=3 where entry=3442;
update creature_proto set npcflags=2 where entry=3443;
update creature_proto set npcflags=2 where entry=3446;
update creature_proto set npcflags=2 where entry=3447;
update creature_proto set npcflags=2 where entry=3448;
update creature_proto set npcflags=2 where entry=3449;
update creature_proto set npcflags=2 where entry=3451;
update creature_proto set npcflags=2 where entry=3453;
update creature_proto set npcflags=2 where entry=3464;
update creature_proto set npcflags=2 where entry=3465;
update creature_proto set npcflags=2 where entry=3468;
update creature_proto set npcflags=268435457 where entry=3469;
update creature_proto set npcflags=4226 where entry=3477;
update creature_proto set npcflags=19 where entry=3478;
update creature_proto set npcflags=4224 where entry=3479;
update creature_proto set npcflags=642 where entry=3480;
update creature_proto set npcflags=386 where entry=3481;
update creature_proto set npcflags=130 where entry=3482;
update creature_proto set npcflags=4226 where entry=3483;
update creature_proto set npcflags=83 where entry=3484;
update creature_proto set npcflags=130 where entry=3485;
update creature_proto set npcflags=4226 where entry=3486;
update creature_proto set npcflags=130 where entry=3487;
update creature_proto set npcflags=4226 where entry=3488;
update creature_proto set npcflags=643 where entry=3489;
update creature_proto set npcflags=3202 where entry=3490;
update creature_proto set npcflags=4224 where entry=3491;
update creature_proto set npcflags=4226 where entry=3492;
update creature_proto set npcflags=4224 where entry=3493;
update creature_proto set npcflags=19 where entry=3494;
update creature_proto set npcflags=130 where entry=3495;
update creature_proto set npcflags=131073 where entry=3496;
update creature_proto set npcflags=640 where entry=3497;
update creature_proto set npcflags=130 where entry=3498;
update creature_proto set npcflags=130 where entry=3499;
update creature_proto set npcflags=130 where entry=3500;
update creature_proto set npcflags=268435457 where entry=3502;
update creature_proto set npcflags=2 where entry=3514;
update creature_proto set npcflags=2 where entry=3515;
update creature_proto set npcflags=2 where entry=3516;
update creature_proto set npcflags=2 where entry=3517;
update creature_proto set npcflags=641 where entry=3518;
update creature_proto set npcflags=2 where entry=3519;
update creature_proto set npcflags=2 where entry=3520;
update creature_proto set npcflags=2 where entry=3521;
update creature_proto set npcflags=4226 where entry=3522;
update creature_proto set npcflags=19 where entry=3523;
update creature_proto set npcflags=4224 where entry=3528;
update creature_proto set npcflags=4224 where entry=3530;
update creature_proto set npcflags=4224 where entry=3532;
update creature_proto set npcflags=4224 where entry=3534;
update creature_proto set npcflags=2 where entry=3535;
update creature_proto set npcflags=4226 where entry=3536;
update creature_proto set npcflags=4226 where entry=3537;
update creature_proto set npcflags=4224 where entry=3539;
update creature_proto set npcflags=642 where entry=3540;
update creature_proto set npcflags=386 where entry=3541;
update creature_proto set npcflags=3202 where entry=3542;
update creature_proto set npcflags=4224 where entry=3543;
update creature_proto set npcflags=642 where entry=3544;
update creature_proto set npcflags=19 where entry=3545;
update creature_proto set npcflags=128 where entry=3546;
update creature_proto set npcflags=642 where entry=3547;
update creature_proto set npcflags=130 where entry=3548;
update creature_proto set npcflags=17 where entry=3549;
update creature_proto set npcflags=128 where entry=3550;
update creature_proto set npcflags=1154 where entry=3551;
update creature_proto set npcflags=4226 where entry=3552;
update creature_proto set npcflags=4224 where entry=3553;
update creature_proto set npcflags=4226 where entry=3554;
update creature_proto set npcflags=83 where entry=3555;
update creature_proto set npcflags=130 where entry=3556;
update creature_proto set npcflags=19 where entry=3557;
update creature_proto set npcflags=130 where entry=3561;
update creature_proto set npcflags=2178 where entry=3562;
update creature_proto set npcflags=2 where entry=3567;
update creature_proto set npcflags=2 where entry=3568;
update creature_proto set npcflags=268435457 where entry=3571;
update creature_proto set npcflags=128 where entry=3572;
update creature_proto set npcflags=640 where entry=3577;
update creature_proto set npcflags=128 where entry=3578;
update creature_proto set npcflags=2 where entry=3583;
update creature_proto set npcflags=2 where entry=3584;
update creature_proto set npcflags=2 where entry=3585;
update creature_proto set npcflags=130 where entry=3587;
update creature_proto set npcflags=4224 where entry=3588;
update creature_proto set npcflags=4226 where entry=3589;
update creature_proto set npcflags=4226 where entry=3590;
update creature_proto set npcflags=4226 where entry=3591;
update creature_proto set npcflags=4224 where entry=3592;
update creature_proto set npcflags=19 where entry=3593;
update creature_proto set npcflags=19 where entry=3594;
update creature_proto set npcflags=19 where entry=3595;
update creature_proto set npcflags=19 where entry=3596;
update creature_proto set npcflags=19 where entry=3597;
update creature_proto set npcflags=19 where entry=3598;
update creature_proto set npcflags=19 where entry=3599;
update creature_proto set npcflags=19 where entry=3600;
update creature_proto set npcflags=19 where entry=3601;
update creature_proto set npcflags=19 where entry=3602;
update creature_proto set npcflags=19 where entry=3603;
update creature_proto set npcflags=19 where entry=3604;
update creature_proto set npcflags=19 where entry=3605;
update creature_proto set npcflags=19 where entry=3606;
update creature_proto set npcflags=19 where entry=3607;
update creature_proto set npcflags=130 where entry=3608;
update creature_proto set npcflags=4224 where entry=3609;
update creature_proto set npcflags=4226 where entry=3610;
update creature_proto set npcflags=4226 where entry=3611;
update creature_proto set npcflags=4226 where entry=3612;
update creature_proto set npcflags=4224 where entry=3613;
update creature_proto set npcflags=130 where entry=3614;
update creature_proto set npcflags=8195 where entry=3615;
update creature_proto set npcflags=2 where entry=3616;
update creature_proto set npcflags=19 where entry=3620;
update creature_proto set npcflags=130 where entry=3621;
update creature_proto set npcflags=17 where entry=3622;
update creature_proto set npcflags=17 where entry=3624;
update creature_proto set npcflags=128 where entry=3625;
update creature_proto set npcflags=2 where entry=3639;
update creature_proto set npcflags=2 where entry=3644;
update creature_proto set npcflags=2 where entry=3649;
update creature_proto set npcflags=2 where entry=3650;
update creature_proto set npcflags=2 where entry=3657;
update creature_proto set npcflags=4226 where entry=3658;
update creature_proto set npcflags=2 where entry=3661;
update creature_proto set npcflags=2 where entry=3663;
update creature_proto set npcflags=2 where entry=3665;
update creature_proto set npcflags=2 where entry=3666;
update creature_proto set npcflags=1 where entry=3678;
update creature_proto set npcflags=4224 where entry=3682;
update creature_proto set npcflags=4226 where entry=3683;
update creature_proto set npcflags=4226 where entry=3684;
update creature_proto set npcflags=131 where entry=3685;
update creature_proto set npcflags=19 where entry=3688;
update creature_proto set npcflags=130 where entry=3689;
update creature_proto set npcflags=17 where entry=3690;
update creature_proto set npcflags=2 where entry=3691;
update creature_proto set npcflags=2 where entry=3692;
update creature_proto set npcflags=2 where entry=3693;
update creature_proto set npcflags=2 where entry=3694;
update creature_proto set npcflags=19 where entry=3698;
update creature_proto set npcflags=130 where entry=3700;
update creature_proto set npcflags=2 where entry=3701;
update creature_proto set npcflags=2 where entry=3702;
update creature_proto set npcflags=19 where entry=3703;
update creature_proto set npcflags=19 where entry=3704;
update creature_proto set npcflags=130 where entry=3705;
update creature_proto set npcflags=19 where entry=3706;
update creature_proto set npcflags=19 where entry=3707;
update creature_proto set npcflags=642 where entry=3708;
update creature_proto set npcflags=130 where entry=3779;
update creature_proto set npcflags=3 where entry=3836;
update creature_proto set npcflags=8195 where entry=3838;
update creature_proto set npcflags=8195 where entry=3841;
update creature_proto set npcflags=2 where entry=3842;
update creature_proto set npcflags=2 where entry=3845;
update creature_proto set npcflags=2 where entry=3846;
update creature_proto set npcflags=2 where entry=3847;
update creature_proto set npcflags=2 where entry=3848;
update creature_proto set npcflags=1 where entry=3849;
update creature_proto set npcflags=1 where entry=3850;
update creature_proto set npcflags=2 where entry=3880;
update creature_proto set npcflags=130 where entry=3881;
update creature_proto set npcflags=130 where entry=3882;
update creature_proto set npcflags=130 where entry=3883;
update creature_proto set npcflags=130 where entry=3884;
update creature_proto set npcflags=2 where entry=3885;
update creature_proto set npcflags=1048577 where entry=3890;
update creature_proto set npcflags=2 where entry=3891;
update creature_proto set npcflags=2 where entry=3892;
update creature_proto set npcflags=2 where entry=3894;
update creature_proto set npcflags=2 where entry=3895;
update creature_proto set npcflags=2 where entry=3896;
update creature_proto set npcflags=2 where entry=3897;
update creature_proto set npcflags=2 where entry=3901;
update creature_proto set npcflags=2 where entry=3916;
update creature_proto set npcflags=2 where entry=3920;
update creature_proto set npcflags=130 where entry=3933;
update creature_proto set npcflags=66179 where entry=3934;
update creature_proto set npcflags=128 where entry=3935;
update creature_proto set npcflags=2 where entry=3936;
update creature_proto set npcflags=128 where entry=3937;
update creature_proto set npcflags=2 where entry=3945;
update creature_proto set npcflags=130 where entry=3948;
update creature_proto set npcflags=4226 where entry=3951;
update creature_proto set npcflags=4226 where entry=3952;
update creature_proto set npcflags=4226 where entry=3953;
update creature_proto set npcflags=130 where entry=3954;
update creature_proto set npcflags=130 where entry=3955;
update creature_proto set npcflags=130 where entry=3956;
update creature_proto set npcflags=130 where entry=3958;
update creature_proto set npcflags=130 where entry=3959;
update creature_proto set npcflags=130 where entry=3960;
update creature_proto set npcflags=130 where entry=3961;
update creature_proto set npcflags=130 where entry=3962;
update creature_proto set npcflags=19 where entry=3963;
update creature_proto set npcflags=19 where entry=3964;
update creature_proto set npcflags=19 where entry=3965;
update creature_proto set npcflags=19 where entry=3967;
update creature_proto set npcflags=130 where entry=3969;
update creature_proto set npcflags=130 where entry=3970;
update creature_proto set npcflags=2 where entry=3978;
update creature_proto set npcflags=2 where entry=3979;
update creature_proto set npcflags=2 where entry=3980;
update creature_proto set npcflags=2 where entry=3981;
update creature_proto set npcflags=2 where entry=3982;
update creature_proto set npcflags=2 where entry=3994;
update creature_proto set npcflags=2 where entry=3995;
update creature_proto set npcflags=2 where entry=3996;
update creature_proto set npcflags=4226 where entry=4043;
update creature_proto set npcflags=2 where entry=4046;
update creature_proto set npcflags=2 where entry=4047;
update creature_proto set npcflags=2 where entry=4048;
update creature_proto set npcflags=2 where entry=4049;
update creature_proto set npcflags=2 where entry=4050;
update creature_proto set npcflags=2 where entry=4052;
update creature_proto set npcflags=2 where entry=4056;
update creature_proto set npcflags=2 where entry=4061;
update creature_proto set npcflags=2 where entry=4077;
update creature_proto set npcflags=2 where entry=4078;
update creature_proto set npcflags=2 where entry=4079;
update creature_proto set npcflags=2 where entry=4080;
update creature_proto set npcflags=2 where entry=4081;
update creature_proto set npcflags=130 where entry=4082;
update creature_proto set npcflags=130 where entry=4083;
update creature_proto set npcflags=130 where entry=4084;
update creature_proto set npcflags=4226 where entry=4085;
update creature_proto set npcflags=4226 where entry=4086;
update creature_proto set npcflags=19 where entry=4087;
update creature_proto set npcflags=2 where entry=4088;
update creature_proto set npcflags=19 where entry=4089;
update creature_proto set npcflags=19 where entry=4090;
update creature_proto set npcflags=19 where entry=4091;
update creature_proto set npcflags=19 where entry=4092;
update creature_proto set npcflags=2 where entry=4126;
update creature_proto set npcflags=19 where entry=4138;
update creature_proto set npcflags=19 where entry=4146;
update creature_proto set npcflags=131075 where entry=4155;
update creature_proto set npcflags=83 where entry=4156;
update creature_proto set npcflags=19 where entry=4159;
update creature_proto set npcflags=19 where entry=4160;
update creature_proto set npcflags=786433 where entry=4161;
update creature_proto set npcflags=19 where entry=4163;
update creature_proto set npcflags=4224 where entry=4164;
update creature_proto set npcflags=19 where entry=4165;
update creature_proto set npcflags=130 where entry=4167;
update creature_proto set npcflags=130 where entry=4168;
update creature_proto set npcflags=642 where entry=4169;
update creature_proto set npcflags=386 where entry=4170;
update creature_proto set npcflags=4226 where entry=4171;
update creature_proto set npcflags=4226 where entry=4172;
update creature_proto set npcflags=4226 where entry=4173;
update creature_proto set npcflags=4226 where entry=4175;
update creature_proto set npcflags=4226 where entry=4177;
update creature_proto set npcflags=4226 where entry=4180;
update creature_proto set npcflags=642 where entry=4181;
update creature_proto set npcflags=130 where entry=4182;
update creature_proto set npcflags=4224 where entry=4183;
update creature_proto set npcflags=4226 where entry=4184;
update creature_proto set npcflags=4226 where entry=4185;
update creature_proto set npcflags=4226 where entry=4186;
update creature_proto set npcflags=4224 where entry=4187;
update creature_proto set npcflags=4226 where entry=4188;
update creature_proto set npcflags=128 where entry=4189;
update creature_proto set npcflags=130 where entry=4190;
update creature_proto set npcflags=130 where entry=4191;
update creature_proto set npcflags=130 where entry=4192;
update creature_proto set npcflags=16 where entry=4193;
update creature_proto set npcflags=130 where entry=4194;
update creature_proto set npcflags=130 where entry=4195;
update creature_proto set npcflags=2 where entry=4197;
update creature_proto set npcflags=2 where entry=4198;
update creature_proto set npcflags=130 where entry=4200;
update creature_proto set npcflags=2 where entry=4201;
update creature_proto set npcflags=4482 where entry=4203;
update creature_proto set npcflags=19 where entry=4204;
update creature_proto set npcflags=19 where entry=4205;
update creature_proto set npcflags=128 where entry=4207;
update creature_proto set npcflags=131073 where entry=4208;
update creature_proto set npcflags=131073 where entry=4209;
update creature_proto set npcflags=83 where entry=4210;
update creature_proto set npcflags=83 where entry=4211;
update creature_proto set npcflags=83 where entry=4212;
update creature_proto set npcflags=17 where entry=4213;
update creature_proto set npcflags=19 where entry=4214;
update creature_proto set npcflags=19 where entry=4215;
update creature_proto set npcflags=130 where entry=4216;
update creature_proto set npcflags=146 where entry=4217;
update creature_proto set npcflags=19 where entry=4218;
update creature_proto set npcflags=19 where entry=4219;
update creature_proto set npcflags=130 where entry=4220;
update creature_proto set npcflags=642 where entry=4221;
update creature_proto set npcflags=130 where entry=4222;
update creature_proto set npcflags=130 where entry=4223;
update creature_proto set npcflags=130 where entry=4225;
update creature_proto set npcflags=130 where entry=4226;
update creature_proto set npcflags=130 where entry=4228;
update creature_proto set npcflags=130 where entry=4229;
update creature_proto set npcflags=130 where entry=4230;
update creature_proto set npcflags=4226 where entry=4231;
update creature_proto set npcflags=4226 where entry=4232;
update creature_proto set npcflags=4226 where entry=4233;
update creature_proto set npcflags=4226 where entry=4234;
update creature_proto set npcflags=4226 where entry=4235;
update creature_proto set npcflags=4226 where entry=4236;
update creature_proto set npcflags=4226 where entry=4240;
update creature_proto set npcflags=387 where entry=4241;
update creature_proto set npcflags=19 where entry=4254;
update creature_proto set npcflags=128 where entry=4255;
update creature_proto set npcflags=131 where entry=4256;
update creature_proto set npcflags=4224 where entry=4257;
update creature_proto set npcflags=17 where entry=4258;
update creature_proto set npcflags=4224 where entry=4259;
update creature_proto set npcflags=268435457 where entry=4262;
update creature_proto set npcflags=130 where entry=4265;
update creature_proto set npcflags=130 where entry=4266;
update creature_proto set npcflags=8195 where entry=4267;
update creature_proto set npcflags=2 where entry=4276;
update creature_proto set npcflags=640 where entry=4305;
update creature_proto set npcflags=128 where entry=4307;
update creature_proto set npcflags=2 where entry=4309;
update creature_proto set npcflags=2 where entry=4310;
update creature_proto set npcflags=8195 where entry=4312;
update creature_proto set npcflags=8195 where entry=4314;
update creature_proto set npcflags=8195 where entry=4317;
update creature_proto set npcflags=8195 where entry=4319;
update creature_proto set npcflags=19 where entry=4320;
update creature_proto set npcflags=8195 where entry=4321;
update creature_proto set npcflags=8195 where entry=4407;
update creature_proto set npcflags=2 where entry=4409;
update creature_proto set npcflags=2 where entry=4425;
update creature_proto set npcflags=2 where entry=4444;
update creature_proto set npcflags=2 where entry=4449;
update creature_proto set npcflags=2 where entry=4451;
update creature_proto set npcflags=2 where entry=4452;
update creature_proto set npcflags=2 where entry=4453;
update creature_proto set npcflags=2 where entry=4454;
update creature_proto set npcflags=2 where entry=4455;
update creature_proto set npcflags=2 where entry=4456;
update creature_proto set npcflags=2 where entry=4483;
update creature_proto set npcflags=2 where entry=4484;
update creature_proto set npcflags=2 where entry=4485;
update creature_proto set npcflags=2 where entry=4486;
update creature_proto set npcflags=3 where entry=4488;
update creature_proto set npcflags=3 where entry=4489;
update creature_proto set npcflags=2 where entry=4495;
update creature_proto set npcflags=2 where entry=4496;
update creature_proto set npcflags=2 where entry=4498;
update creature_proto set npcflags=2 where entry=4500;
update creature_proto set npcflags=3 where entry=4501;
update creature_proto set npcflags=2 where entry=4502;
update creature_proto set npcflags=2 where entry=4503;
update creature_proto set npcflags=2 where entry=4508;
update creature_proto set npcflags=2 where entry=4510;
update creature_proto set npcflags=2 where entry=4521;
update creature_proto set npcflags=2 where entry=4544;
update creature_proto set npcflags=131073 where entry=4549;
update creature_proto set npcflags=131073 where entry=4550;
update creature_proto set npcflags=8195 where entry=4551;
update creature_proto set npcflags=83 where entry=4552;
update creature_proto set npcflags=130 where entry=4553;
update creature_proto set npcflags=642 where entry=4554;
update creature_proto set npcflags=898 where entry=4555;
update creature_proto set npcflags=4227 where entry=4556;
update creature_proto set npcflags=4226 where entry=4557;
update creature_proto set npcflags=4226 where entry=4558;
update creature_proto set npcflags=4226 where entry=4559;
update creature_proto set npcflags=4226 where entry=4560;
update creature_proto set npcflags=130 where entry=4561;
update creature_proto set npcflags=2178 where entry=4562;
update creature_proto set npcflags=19 where entry=4563;
update creature_proto set npcflags=19 where entry=4564;
update creature_proto set npcflags=19 where entry=4565;
update creature_proto set npcflags=19 where entry=4566;
update creature_proto set npcflags=19 where entry=4567;
update creature_proto set npcflags=19 where entry=4568;
update creature_proto set npcflags=4226 where entry=4569;
update creature_proto set npcflags=4226 where entry=4570;
update creature_proto set npcflags=642 where entry=4571;
update creature_proto set npcflags=83 where entry=4573;
update creature_proto set npcflags=130 where entry=4574;
update creature_proto set npcflags=2178 where entry=4575;
update creature_proto set npcflags=83 where entry=4576;
update creature_proto set npcflags=130 where entry=4577;
update creature_proto set npcflags=19 where entry=4578;
update creature_proto set npcflags=4226 where entry=4580;
update creature_proto set npcflags=130 where entry=4581;
update creature_proto set npcflags=51 where entry=4582;
update creature_proto set npcflags=51 where entry=4583;
update creature_proto set npcflags=51 where entry=4584;
update creature_proto set npcflags=1154 where entry=4585;
update creature_proto set npcflags=19 where entry=4586;
update creature_proto set npcflags=130 where entry=4587;
update creature_proto set npcflags=19 where entry=4588;
update creature_proto set npcflags=130 where entry=4589;
update creature_proto set npcflags=130 where entry=4590;
update creature_proto set npcflags=83 where entry=4591;
update creature_proto set npcflags=4226 where entry=4592;
update creature_proto set npcflags=19 where entry=4593;
update creature_proto set npcflags=19 where entry=4594;
update creature_proto set npcflags=19 where entry=4595;
update creature_proto set npcflags=19 where entry=4596;
update creature_proto set npcflags=4226 where entry=4597;
update creature_proto set npcflags=83 where entry=4598;
update creature_proto set npcflags=130 where entry=4599;
update creature_proto set npcflags=4226 where entry=4600;
update creature_proto set npcflags=4226 where entry=4601;
update creature_proto set npcflags=4226 where entry=4602;
update creature_proto set npcflags=4226 where entry=4603;
update creature_proto set npcflags=4482 where entry=4604;
update creature_proto set npcflags=19 where entry=4605;
update creature_proto set npcflags=51 where entry=4606;
update creature_proto set npcflags=51 where entry=4607;
update creature_proto set npcflags=51 where entry=4608;
update creature_proto set npcflags=19 where entry=4609;
update creature_proto set npcflags=130 where entry=4610;
update creature_proto set npcflags=19 where entry=4611;
update creature_proto set npcflags=786433 where entry=4613;
update creature_proto set npcflags=19 where entry=4614;
update creature_proto set npcflags=130 where entry=4615;
update creature_proto set npcflags=81 where entry=4616;
update creature_proto set npcflags=130 where entry=4617;
update creature_proto set npcflags=2 where entry=4618;
update creature_proto set npcflags=2 where entry=4629;
update creature_proto set npcflags=2 where entry=4630;
update creature_proto set npcflags=3 where entry=4631;
update creature_proto set npcflags=2 where entry=4706;
update creature_proto set npcflags=2 where entry=4708;
update creature_proto set npcflags=2 where entry=4709;
update creature_proto set npcflags=2 where entry=4721;
update creature_proto set npcflags=2 where entry=4722;
update creature_proto set npcflags=131 where entry=4730;
update creature_proto set npcflags=131 where entry=4731;
update creature_proto set npcflags=17 where entry=4732;
update creature_proto set npcflags=16 where entry=4752;
update creature_proto set npcflags=17 where entry=4753;
update creature_proto set npcflags=16 where entry=4772;
update creature_proto set npcflags=17 where entry=4773;
update creature_proto set npcflags=130 where entry=4775;
update creature_proto set npcflags=642 where entry=4782;
update creature_proto set npcflags=2 where entry=4783;
update creature_proto set npcflags=2 where entry=4784;
update creature_proto set npcflags=2 where entry=4786;
update creature_proto set npcflags=2 where entry=4787;
update creature_proto set npcflags=2 where entry=4791;
update creature_proto set npcflags=2 where entry=4792;
update creature_proto set npcflags=2 where entry=4794;
update creature_proto set npcflags=130 where entry=4875;
update creature_proto set npcflags=130 where entry=4876;
update creature_proto set npcflags=130 where entry=4877;
update creature_proto set npcflags=130 where entry=4878;
update creature_proto set npcflags=642 where entry=4879;
update creature_proto set npcflags=2 where entry=4880;
update creature_proto set npcflags=4224 where entry=4883;
update creature_proto set npcflags=4224 where entry=4884;
update creature_proto set npcflags=131 where entry=4885;
update creature_proto set npcflags=4224 where entry=4886;
update creature_proto set npcflags=4224 where entry=4888;
update creature_proto set npcflags=4226 where entry=4889;
update creature_proto set npcflags=4224 where entry=4890;
update creature_proto set npcflags=642 where entry=4891;
update creature_proto set npcflags=4482 where entry=4892;
update creature_proto set npcflags=642 where entry=4893;
update creature_proto set npcflags=640 where entry=4894;
update creature_proto set npcflags=3 where entry=4895;
update creature_proto set npcflags=386 where entry=4896;
update creature_proto set npcflags=130 where entry=4897;
update creature_proto set npcflags=19 where entry=4898;
update creature_proto set npcflags=130 where entry=4899;
update creature_proto set npcflags=19 where entry=4900;
update creature_proto set npcflags=3 where entry=4921;
update creature_proto set npcflags=3 where entry=4926;
update creature_proto set npcflags=2 where entry=4941;
update creature_proto set npcflags=2 where entry=4943;
update creature_proto set npcflags=3 where entry=4944;
update creature_proto set npcflags=2 where entry=4947;
update creature_proto set npcflags=2 where entry=4948;
update creature_proto set npcflags=2 where entry=4949;
update creature_proto set npcflags=642 where entry=4954;
update creature_proto set npcflags=2 where entry=4959;
update creature_proto set npcflags=2 where entry=4960;
update creature_proto set npcflags=2 where entry=4961;
update creature_proto set npcflags=2 where entry=4962;
update creature_proto set npcflags=131 where entry=4963;
update creature_proto set npcflags=2 where entry=4964;
update creature_proto set npcflags=2 where entry=4965;
update creature_proto set npcflags=2 where entry=4966;
update creature_proto set npcflags=3 where entry=4967;
update creature_proto set npcflags=3 where entry=4968;
update creature_proto set npcflags=2 where entry=4973;
update creature_proto set npcflags=786433 where entry=4974;
update creature_proto set npcflags=1 where entry=4979;
update creature_proto set npcflags=2 where entry=4980;
update creature_proto set npcflags=641 where entry=4981;
update creature_proto set npcflags=2 where entry=4982;
update creature_proto set npcflags=2 where entry=4983;
update creature_proto set npcflags=2 where entry=4984;
update creature_proto set npcflags=524288 where entry=5047;
update creature_proto set npcflags=128 where entry=5049;
update creature_proto set npcflags=524417 where entry=5052;
update creature_proto set npcflags=786433 where entry=5054;
update creature_proto set npcflags=2 where entry=5081;
update creature_proto set npcflags=2 where entry=5082;
update creature_proto set npcflags=2 where entry=5083;
update creature_proto set npcflags=3 where entry=5086;
update creature_proto set npcflags=2 where entry=5087;
update creature_proto set npcflags=2 where entry=5089;
update creature_proto set npcflags=2 where entry=5091;
update creature_proto set npcflags=131073 where entry=5099;
update creature_proto set npcflags=128 where entry=5100;
update creature_proto set npcflags=384 where entry=5101;
update creature_proto set npcflags=4224 where entry=5102;
update creature_proto set npcflags=4224 where entry=5103;
update creature_proto set npcflags=4224 where entry=5106;
update creature_proto set npcflags=4224 where entry=5107;
update creature_proto set npcflags=4224 where entry=5108;
update creature_proto set npcflags=640 where entry=5109;
update creature_proto set npcflags=2176 where entry=5110;
update creature_proto set npcflags=66179 where entry=5111;
update creature_proto set npcflags=642 where entry=5112;
update creature_proto set npcflags=19 where entry=5113;
update creature_proto set npcflags=19 where entry=5114;
update creature_proto set npcflags=19 where entry=5115;
update creature_proto set npcflags=19 where entry=5116;
update creature_proto set npcflags=19 where entry=5117;
update creature_proto set npcflags=1048577 where entry=5118;
update creature_proto set npcflags=4226 where entry=5119;
update creature_proto set npcflags=4226 where entry=5120;
update creature_proto set npcflags=4226 where entry=5121;
update creature_proto set npcflags=4482 where entry=5122;
update creature_proto set npcflags=4226 where entry=5123;
update creature_proto set npcflags=640 where entry=5124;
update creature_proto set npcflags=4226 where entry=5125;
update creature_proto set npcflags=4226 where entry=5126;
update creature_proto set npcflags=81 where entry=5127;
update creature_proto set npcflags=128 where entry=5128;
update creature_proto set npcflags=4226 where entry=5129;
update creature_proto set npcflags=786433 where entry=5130;
update creature_proto set npcflags=128 where entry=5132;
update creature_proto set npcflags=4226 where entry=5133;
update creature_proto set npcflags=128 where entry=5134;
update creature_proto set npcflags=128 where entry=5135;
update creature_proto set npcflags=17 where entry=5137;
update creature_proto set npcflags=128 where entry=5138;
update creature_proto set npcflags=128 where entry=5139;
update creature_proto set npcflags=642 where entry=5140;
update creature_proto set npcflags=19 where entry=5141;
update creature_proto set npcflags=19 where entry=5142;
update creature_proto set npcflags=19 where entry=5143;
update creature_proto set npcflags=19 where entry=5144;
update creature_proto set npcflags=19 where entry=5145;
update creature_proto set npcflags=19 where entry=5146;
update creature_proto set npcflags=19 where entry=5147;
update creature_proto set npcflags=19 where entry=5148;
update creature_proto set npcflags=19 where entry=5149;
update creature_proto set npcflags=83 where entry=5150;
update creature_proto set npcflags=2178 where entry=5151;
update creature_proto set npcflags=4226 where entry=5152;
update creature_proto set npcflags=17 where entry=5153;
update creature_proto set npcflags=130 where entry=5154;
update creature_proto set npcflags=4226 where entry=5155;
update creature_proto set npcflags=4226 where entry=5156;
update creature_proto set npcflags=17 where entry=5157;
update creature_proto set npcflags=128 where entry=5158;
update creature_proto set npcflags=83 where entry=5159;
update creature_proto set npcflags=128 where entry=5160;
update creature_proto set npcflags=83 where entry=5161;
update creature_proto set npcflags=130 where entry=5162;
update creature_proto set npcflags=130 where entry=5163;
update creature_proto set npcflags=19 where entry=5164;
update creature_proto set npcflags=19 where entry=5165;
update creature_proto set npcflags=19 where entry=5166;
update creature_proto set npcflags=19 where entry=5167;
update creature_proto set npcflags=1154 where entry=5169;
update creature_proto set npcflags=4226 where entry=5170;
update creature_proto set npcflags=19 where entry=5171;
update creature_proto set npcflags=19 where entry=5172;
update creature_proto set npcflags=19 where entry=5173;
update creature_proto set npcflags=19 where entry=5174;
update creature_proto set npcflags=128 where entry=5175;
update creature_proto set npcflags=17 where entry=5177;
update creature_proto set npcflags=128 where entry=5178;
update creature_proto set npcflags=524416 where entry=5188;
update creature_proto set npcflags=524416 where entry=5189;
update creature_proto set npcflags=524416 where entry=5190;
update creature_proto set npcflags=128 where entry=5191;
update creature_proto set npcflags=524417 where entry=5193;
update creature_proto set npcflags=2 where entry=5204;
update creature_proto set npcflags=2 where entry=5352;
update creature_proto set npcflags=3 where entry=5353;
update creature_proto set npcflags=2 where entry=5384;
update creature_proto set npcflags=2 where entry=5385;
update creature_proto set npcflags=2 where entry=5386;
update creature_proto set npcflags=2 where entry=5387;
update creature_proto set npcflags=2 where entry=5388;
update creature_proto set npcflags=2 where entry=5391;
update creature_proto set npcflags=19 where entry=5392;
update creature_proto set npcflags=2 where entry=5393;
update creature_proto set npcflags=2 where entry=5394;
update creature_proto set npcflags=2 where entry=5395;
update creature_proto set npcflags=2 where entry=5396;
update creature_proto set npcflags=2 where entry=5397;
update creature_proto set npcflags=2 where entry=5398;
update creature_proto set npcflags=2 where entry=5405;
update creature_proto set npcflags=4227 where entry=5411;
update creature_proto set npcflags=2 where entry=5412;
update creature_proto set npcflags=2 where entry=5413;
update creature_proto set npcflags=2 where entry=5414;
update creature_proto set npcflags=2 where entry=5416;
update creature_proto set npcflags=2 where entry=5418;
update creature_proto set npcflags=2 where entry=5464;
update creature_proto set npcflags=2 where entry=5476;
update creature_proto set npcflags=19 where entry=5479;
update creature_proto set npcflags=19 where entry=5480;
update creature_proto set npcflags=17 where entry=5482;
update creature_proto set npcflags=129 where entry=5483;
update creature_proto set npcflags=17 where entry=5484;
update creature_proto set npcflags=19 where entry=5489;
update creature_proto set npcflags=19 where entry=5491;
update creature_proto set npcflags=19 where entry=5492;
update creature_proto set npcflags=81 where entry=5493;
update creature_proto set npcflags=129 where entry=5494;
update creature_proto set npcflags=19 where entry=5495;
update creature_proto set npcflags=19 where entry=5496;
update creature_proto set npcflags=19 where entry=5497;
update creature_proto set npcflags=19 where entry=5498;
update creature_proto set npcflags=17 where entry=5499;
update creature_proto set npcflags=17 where entry=5500;
update creature_proto set npcflags=19 where entry=5501;
update creature_proto set npcflags=17 where entry=5502;
update creature_proto set npcflags=129 where entry=5503;
update creature_proto set npcflags=19 where entry=5504;
update creature_proto set npcflags=19 where entry=5505;
update creature_proto set npcflags=17 where entry=5506;
update creature_proto set npcflags=4224 where entry=5508;
update creature_proto set npcflags=4225 where entry=5509;
update creature_proto set npcflags=4225 where entry=5510;
update creature_proto set npcflags=17 where entry=5511;
update creature_proto set npcflags=4225 where entry=5512;
update creature_proto set npcflags=17 where entry=5513;
update creature_proto set npcflags=129 where entry=5514;
update creature_proto set npcflags=19 where entry=5515;
update creature_proto set npcflags=19 where entry=5516;
update creature_proto set npcflags=19 where entry=5517;
update creature_proto set npcflags=19 where entry=5518;
update creature_proto set npcflags=129 where entry=5519;
update creature_proto set npcflags=131 where entry=5520;
update creature_proto set npcflags=2 where entry=5543;
update creature_proto set npcflags=81 where entry=5564;
update creature_proto set npcflags=129 where entry=5565;
update creature_proto set npcflags=19 where entry=5566;
update creature_proto set npcflags=17 where entry=5567;
update creature_proto set npcflags=130 where entry=5569;
update creature_proto set npcflags=642 where entry=5570;
update creature_proto set npcflags=2 where entry=5591;
update creature_proto set npcflags=2 where entry=5592;
update creature_proto set npcflags=2 where entry=5593;
update creature_proto set npcflags=130 where entry=5594;
update creature_proto set npcflags=268435457 where entry=5595;
update creature_proto set npcflags=2 where entry=5598;
update creature_proto set npcflags=2 where entry=5599;
update creature_proto set npcflags=2 where entry=5605;
update creature_proto set npcflags=642 where entry=5611;
update creature_proto set npcflags=17 where entry=5612;
update creature_proto set npcflags=640 where entry=5620;
update creature_proto set npcflags=268435457 where entry=5624;
update creature_proto set npcflags=2 where entry=5634;
update creature_proto set npcflags=2 where entry=5635;
update creature_proto set npcflags=2 where entry=5636;
update creature_proto set npcflags=2 where entry=5637;
update creature_proto set npcflags=2 where entry=5638;
update creature_proto set npcflags=2 where entry=5639;
update creature_proto set npcflags=2 where entry=5640;
update creature_proto set npcflags=2 where entry=5641;
update creature_proto set npcflags=2 where entry=5642;
update creature_proto set npcflags=2 where entry=5644;
update creature_proto set npcflags=2 where entry=5651;
update creature_proto set npcflags=2 where entry=5667;
update creature_proto set npcflags=2 where entry=5675;
update creature_proto set npcflags=2 where entry=5679;
update creature_proto set npcflags=2 where entry=5683;
update creature_proto set npcflags=66179 where entry=5688;
update creature_proto set npcflags=83 where entry=5690;
update creature_proto set npcflags=2 where entry=5693;
update creature_proto set npcflags=2 where entry=5694;
update creature_proto set npcflags=83 where entry=5695;
update creature_proto set npcflags=1 where entry=5698;
update creature_proto set npcflags=2 where entry=5724;
update creature_proto set npcflags=268435457 where entry=5725;
update creature_proto set npcflags=128 where entry=5748;
update creature_proto set npcflags=131 where entry=5749;
update creature_proto set npcflags=131 where entry=5750;
update creature_proto set npcflags=2 where entry=5752;
update creature_proto set npcflags=131 where entry=5753;
update creature_proto set npcflags=4226 where entry=5754;
update creature_proto set npcflags=130 where entry=5757;
update creature_proto set npcflags=130 where entry=5758;
update creature_proto set npcflags=83 where entry=5759;
update creature_proto set npcflags=2 where entry=5765;
update creature_proto set npcflags=2 where entry=5767;
update creature_proto set npcflags=2 where entry=5768;
update creature_proto set npcflags=3 where entry=5769;
update creature_proto set npcflags=2 where entry=5770;
update creature_proto set npcflags=2 where entry=5782;
update creature_proto set npcflags=130 where entry=5783;
update creature_proto set npcflags=19 where entry=5784;
update creature_proto set npcflags=2 where entry=5797;
update creature_proto set npcflags=2 where entry=5798;
update creature_proto set npcflags=2 where entry=5799;
update creature_proto set npcflags=2 where entry=5800;
update creature_proto set npcflags=2 where entry=5809;
update creature_proto set npcflags=2 where entry=5810;
update creature_proto set npcflags=19 where entry=5811;
update creature_proto set npcflags=4226 where entry=5812;
update creature_proto set npcflags=65665 where entry=5814;
update creature_proto set npcflags=131 where entry=5815;
update creature_proto set npcflags=4226 where entry=5816;
update creature_proto set npcflags=130 where entry=5817;
update creature_proto set npcflags=4226 where entry=5819;
update creature_proto set npcflags=4226 where entry=5820;
update creature_proto set npcflags=4226 where entry=5821;
update creature_proto set npcflags=2 where entry=5833;
update creature_proto set npcflags=2 where entry=5847;
update creature_proto set npcflags=2 where entry=5849;
update creature_proto set npcflags=2 where entry=5851;
update creature_proto set npcflags=130 where entry=5870;
update creature_proto set npcflags=642 where entry=5871;
update creature_proto set npcflags=2 where entry=5875;
update creature_proto set npcflags=2 where entry=5878;
update creature_proto set npcflags=19 where entry=5880;
update creature_proto set npcflags=19 where entry=5882;
update creature_proto set npcflags=19 where entry=5883;
update creature_proto set npcflags=19 where entry=5884;
update creature_proto set npcflags=19 where entry=5885;
update creature_proto set npcflags=642 where entry=5886;
update creature_proto set npcflags=2 where entry=5887;
update creature_proto set npcflags=2 where entry=5888;
update creature_proto set npcflags=2 where entry=5891;
update creature_proto set npcflags=2 where entry=5892;
update creature_proto set npcflags=2 where entry=5895;
update creature_proto set npcflags=2 where entry=5899;
update creature_proto set npcflags=2 where entry=5900;
update creature_proto set npcflags=2 where entry=5901;
update creature_proto set npcflags=2 where entry=5905;
update creature_proto set npcflags=2 where entry=5906;
update creature_proto set npcflags=2 where entry=5907;
update creature_proto set npcflags=2 where entry=5908;
update creature_proto set npcflags=2 where entry=5909;
update creature_proto set npcflags=2 where entry=5910;
update creature_proto set npcflags=2 where entry=5911;
update creature_proto set npcflags=19 where entry=5938;
update creature_proto set npcflags=19 where entry=5939;
update creature_proto set npcflags=130 where entry=5940;
update creature_proto set npcflags=19 where entry=5941;
update creature_proto set npcflags=130 where entry=5942;
update creature_proto set npcflags=19 where entry=5943;
update creature_proto set npcflags=130 where entry=5944;
update creature_proto set npcflags=268435456 where entry=5952;
update creature_proto set npcflags=268435457 where entry=5953;
update creature_proto set npcflags=2 where entry=5955;
update creature_proto set npcflags=19 where entry=5957;
update creature_proto set npcflags=19 where entry=5958;
update creature_proto set npcflags=19 where entry=5994;
update creature_proto set npcflags=19 where entry=6014;
update creature_proto set npcflags=2 where entry=6015;
update creature_proto set npcflags=19 where entry=6018;
update creature_proto set npcflags=2 where entry=6019;
update creature_proto set npcflags=8193 where entry=6026;
update creature_proto set npcflags=130 where entry=6027;
update creature_proto set npcflags=4226 where entry=6028;
update creature_proto set npcflags=2 where entry=6030;
update creature_proto set npcflags=2 where entry=6031;
update creature_proto set npcflags=2 where entry=6034;
update creature_proto set npcflags=2 where entry=6086;
update creature_proto set npcflags=2 where entry=6089;
update creature_proto set npcflags=2 where entry=6090;
update creature_proto set npcflags=130 where entry=6091;
update creature_proto set npcflags=19 where entry=6094;
update creature_proto set npcflags=2 where entry=6114;
update creature_proto set npcflags=3 where entry=6119;
update creature_proto set npcflags=2 where entry=6120;
update creature_proto set npcflags=2 where entry=6121;
update creature_proto set npcflags=3 where entry=6122;
update creature_proto set npcflags=2 where entry=6134;
update creature_proto set npcflags=2 where entry=6142;
update creature_proto set npcflags=2 where entry=6166;
update creature_proto set npcflags=2 where entry=6169;
update creature_proto set npcflags=2 where entry=6171;
update creature_proto set npcflags=2 where entry=6172;
update creature_proto set npcflags=2 where entry=6173;
update creature_proto set npcflags=2 where entry=6174;
update creature_proto set npcflags=2 where entry=6175;
update creature_proto set npcflags=2 where entry=6176;
update creature_proto set npcflags=2 where entry=6177;
update creature_proto set npcflags=2 where entry=6178;
update creature_proto set npcflags=2 where entry=6179;
update creature_proto set npcflags=2 where entry=6181;
update creature_proto set npcflags=2 where entry=6182;
update creature_proto set npcflags=2 where entry=6236;
update creature_proto set npcflags=2 where entry=6241;
update creature_proto set npcflags=2 where entry=6244;
update creature_proto set npcflags=2 where entry=6247;
update creature_proto set npcflags=2 where entry=6251;
update creature_proto set npcflags=2 where entry=6252;
update creature_proto set npcflags=2 where entry=6254;
update creature_proto set npcflags=2 where entry=6266;
update creature_proto set npcflags=66179 where entry=6272;
update creature_proto set npcflags=19 where entry=6286;
update creature_proto set npcflags=19 where entry=6287;
update creature_proto set npcflags=19 where entry=6288;
update creature_proto set npcflags=16 where entry=6289;
update creature_proto set npcflags=19 where entry=6290;
update creature_proto set npcflags=80 where entry=6291;
update creature_proto set npcflags=83 where entry=6292;
update creature_proto set npcflags=2 where entry=6293;
update creature_proto set npcflags=2 where entry=6294;
update creature_proto set npcflags=19 where entry=6295;
update creature_proto set npcflags=19 where entry=6297;
update creature_proto set npcflags=130 where entry=6298;
update creature_proto set npcflags=19 where entry=6299;
update creature_proto set npcflags=4224 where entry=6300;
update creature_proto set npcflags=130 where entry=6301;
update creature_proto set npcflags=16 where entry=6306;
update creature_proto set npcflags=129 where entry=6328;
update creature_proto set npcflags=128 where entry=6367;
update creature_proto set npcflags=129 where entry=6373;
update creature_proto set npcflags=129 where entry=6374;
update creature_proto set npcflags=130 where entry=6376;
update creature_proto set npcflags=131 where entry=6382;
update creature_proto set npcflags=19 where entry=6387;
update creature_proto set npcflags=2 where entry=6389;
update creature_proto set npcflags=2 where entry=6393;
update creature_proto set npcflags=2 where entry=6394;
update creature_proto set npcflags=2 where entry=6395;
update creature_proto set npcflags=2 where entry=6408;
update creature_proto set npcflags=2 where entry=6410;
update creature_proto set npcflags=2 where entry=6411;
update creature_proto set npcflags=2 where entry=6446;
update creature_proto set npcflags=2 where entry=6467;
update creature_proto set npcflags=16385 where entry=6491;
update creature_proto set npcflags=130 where entry=6495;
update creature_proto set npcflags=130 where entry=6496;
update creature_proto set npcflags=1 where entry=6497;
update creature_proto set npcflags=2 where entry=6522;
update creature_proto set npcflags=3 where entry=6546;
update creature_proto set npcflags=130 where entry=6548;
update creature_proto set npcflags=1 where entry=6566;
update creature_proto set npcflags=130 where entry=6567;
update creature_proto set npcflags=130 where entry=6568;
update creature_proto set npcflags=2 where entry=6569;
update creature_proto set npcflags=130 where entry=6574;
update creature_proto set npcflags=130 where entry=6576;
update creature_proto set npcflags=2 where entry=6577;
update creature_proto set npcflags=2 where entry=6579;
update creature_proto set npcflags=2 where entry=6667;
update creature_proto set npcflags=8195 where entry=6706;
update creature_proto set npcflags=51 where entry=6707;
update creature_proto set npcflags=8195 where entry=6726;
update creature_proto set npcflags=66177 where entry=6727;
update creature_proto set npcflags=130 where entry=6730;
update creature_proto set npcflags=130 where entry=6731;
update creature_proto set npcflags=65667 where entry=6734;
update creature_proto set npcflags=66179 where entry=6735;
update creature_proto set npcflags=65667 where entry=6736;
update creature_proto set npcflags=65667 where entry=6737;
update creature_proto set npcflags=65667 where entry=6738;
update creature_proto set npcflags=66179 where entry=6739;
update creature_proto set npcflags=66179 where entry=6740;
update creature_proto set npcflags=66179 where entry=6741;
update creature_proto set npcflags=66179 where entry=6746;
update creature_proto set npcflags=65667 where entry=6747;
update creature_proto set npcflags=4194304 where entry=6749;
update creature_proto set npcflags=3 where entry=6766;
update creature_proto set npcflags=2 where entry=6768;
update creature_proto set npcflags=1 where entry=6771;
update creature_proto set npcflags=2 where entry=6774;
update creature_proto set npcflags=2 where entry=6775;
update creature_proto set npcflags=130 where entry=6776;
update creature_proto set npcflags=130 where entry=6777;
update creature_proto set npcflags=2 where entry=6778;
update creature_proto set npcflags=1154 where entry=6779;
update creature_proto set npcflags=2 where entry=6780;
update creature_proto set npcflags=2 where entry=6781;
update creature_proto set npcflags=2 where entry=6782;
update creature_proto set npcflags=2 where entry=6784;
update creature_proto set npcflags=2 where entry=6785;
update creature_proto set npcflags=2 where entry=6786;
update creature_proto set npcflags=66177 where entry=6790;
update creature_proto set npcflags=65667 where entry=6791;
update creature_proto set npcflags=2 where entry=6806;
update creature_proto set npcflags=66177 where entry=6807;
update creature_proto set npcflags=3 where entry=6826;
update creature_proto set npcflags=2 where entry=6868;
update creature_proto set npcflags=2 where entry=6886;
update creature_proto set npcflags=2 where entry=6887;
update creature_proto set npcflags=2 where entry=6906;
update creature_proto set npcflags=2 where entry=6907;
update creature_proto set npcflags=2 where entry=6908;
update creature_proto set npcflags=2 where entry=6912;
update creature_proto set npcflags=65667 where entry=6928;
update creature_proto set npcflags=66179 where entry=6929;
update creature_proto set npcflags=65665 where entry=6930;
update creature_proto set npcflags=2 where entry=6946;
update creature_proto set npcflags=2 where entry=6966;
update creature_proto set npcflags=2 where entry=6986;
update creature_proto set npcflags=2 where entry=6987;
update creature_proto set npcflags=2 where entry=7007;
update creature_proto set npcflags=2 where entry=7009;
update creature_proto set npcflags=3 where entry=7010;
update creature_proto set npcflags=2 where entry=7024;
update creature_proto set npcflags=19 where entry=7087;
update creature_proto set npcflags=19 where entry=7088;
update creature_proto set npcflags=19 where entry=7089;
update creature_proto set npcflags=2 where entry=7161;
update creature_proto set npcflags=3 where entry=7166;
update creature_proto set npcflags=2 where entry=7170;
update creature_proto set npcflags=3 where entry=7207;
update creature_proto set npcflags=2 where entry=7229;
update creature_proto set npcflags=17 where entry=7230;
update creature_proto set npcflags=146 where entry=7231;
update creature_proto set npcflags=17 where entry=7232;
update creature_proto set npcflags=2 where entry=7233;
update creature_proto set npcflags=2 where entry=7292;
update creature_proto set npcflags=19 where entry=7311;
update creature_proto set npcflags=19 where entry=7312;
update creature_proto set npcflags=2 where entry=7313;
update creature_proto set npcflags=19 where entry=7315;
update creature_proto set npcflags=2 where entry=7316;
update creature_proto set npcflags=2 where entry=7317;
update creature_proto set npcflags=3 where entry=7363;
update creature_proto set npcflags=19 where entry=7406;
update creature_proto set npcflags=2 where entry=7407;
update creature_proto set npcflags=2 where entry=7408;
update creature_proto set npcflags=1048576 where entry=7410;
update creature_proto set npcflags=1048576 where entry=7427;
update creature_proto set npcflags=128 where entry=7485;
update creature_proto set npcflags=2 where entry=7489;
update creature_proto set npcflags=3 where entry=7505;
update creature_proto set npcflags=3 where entry=7506;
update creature_proto set npcflags=130 where entry=7564;
update creature_proto set npcflags=3 where entry=7572;
update creature_proto set npcflags=2 where entry=7583;
update creature_proto set npcflags=1 where entry=7604;
update creature_proto set npcflags=1 where entry=7607;
update creature_proto set npcflags=2 where entry=7623;
update creature_proto set npcflags=2 where entry=7643;
update creature_proto set npcflags=131 where entry=7683;
update creature_proto set npcflags=65667 where entry=7714;
update creature_proto set npcflags=2 where entry=7724;
update creature_proto set npcflags=2 where entry=7729;
update creature_proto set npcflags=2 where entry=7730;
update creature_proto set npcflags=65667 where entry=7731;
update creature_proto set npcflags=65667 where entry=7733;
update creature_proto set npcflags=65667 where entry=7736;
update creature_proto set npcflags=65667 where entry=7737;
update creature_proto set npcflags=2 where entry=7740;
update creature_proto set npcflags=66179 where entry=7744;
update creature_proto set npcflags=2 where entry=7750;
update creature_proto set npcflags=2 where entry=7763;
update creature_proto set npcflags=2 where entry=7764;
update creature_proto set npcflags=2 where entry=7765;
update creature_proto set npcflags=3 where entry=7766;
update creature_proto set npcflags=2 where entry=7771;
update creature_proto set npcflags=130 where entry=7772;
update creature_proto set npcflags=2 where entry=7773;
update creature_proto set npcflags=2 where entry=7774;
update creature_proto set npcflags=130 where entry=7775;
update creature_proto set npcflags=2 where entry=7776;
update creature_proto set npcflags=2 where entry=7777;
update creature_proto set npcflags=2 where entry=7778;
update creature_proto set npcflags=2 where entry=7780;
update creature_proto set npcflags=2 where entry=7783;
update creature_proto set npcflags=2 where entry=7784;
update creature_proto set npcflags=2 where entry=7790;
update creature_proto set npcflags=2 where entry=7792;
update creature_proto set npcflags=2 where entry=7793;
update creature_proto set npcflags=2 where entry=7794;
update creature_proto set npcflags=2 where entry=7798;
update creature_proto set npcflags=131073 where entry=7799;
update creature_proto set npcflags=2 where entry=7801;
update creature_proto set npcflags=2 where entry=7802;
update creature_proto set npcflags=2 where entry=7804;
update creature_proto set npcflags=2 where entry=7806;
update creature_proto set npcflags=2 where entry=7807;
update creature_proto set npcflags=8195 where entry=7823;
update creature_proto set npcflags=8195 where entry=7824;
update creature_proto set npcflags=2 where entry=7825;
update creature_proto set npcflags=2 where entry=7826;
update creature_proto set npcflags=2 where entry=7850;
update creature_proto set npcflags=4226 where entry=7852;
update creature_proto set npcflags=3 where entry=7853;
update creature_proto set npcflags=130 where entry=7854;
update creature_proto set npcflags=2 where entry=7865;
update creature_proto set npcflags=19 where entry=7866;
update creature_proto set npcflags=19 where entry=7867;
update creature_proto set npcflags=19 where entry=7868;
update creature_proto set npcflags=19 where entry=7869;
update creature_proto set npcflags=19 where entry=7870;
update creature_proto set npcflags=19 where entry=7871;
update creature_proto set npcflags=2 where entry=7875;
update creature_proto set npcflags=2 where entry=7876;
update creature_proto set npcflags=2 where entry=7877;
update creature_proto set npcflags=2 where entry=7878;
update creature_proto set npcflags=130 where entry=7879;
update creature_proto set npcflags=2 where entry=7880;
update creature_proto set npcflags=2 where entry=7881;
update creature_proto set npcflags=2 where entry=7882;
update creature_proto set npcflags=2 where entry=7884;
update creature_proto set npcflags=2 where entry=7900;
update creature_proto set npcflags=2 where entry=7907;
update creature_proto set npcflags=2 where entry=7916;
update creature_proto set npcflags=2 where entry=7917;
update creature_proto set npcflags=2 where entry=7918;
update creature_proto set npcflags=2 where entry=7936;
update creature_proto set npcflags=2 where entry=7937;
update creature_proto set npcflags=130 where entry=7940;
update creature_proto set npcflags=130 where entry=7941;
update creature_proto set npcflags=130 where entry=7942;
update creature_proto set npcflags=130 where entry=7943;
update creature_proto set npcflags=19 where entry=7944;
update creature_proto set npcflags=130 where entry=7945;
update creature_proto set npcflags=19 where entry=7946;
update creature_proto set npcflags=130 where entry=7947;
update creature_proto set npcflags=19 where entry=7948;
update creature_proto set npcflags=16 where entry=7949;
update creature_proto set npcflags=2 where entry=7950;
update creature_proto set npcflags=1 where entry=7951;
update creature_proto set npcflags=131 where entry=7952;
update creature_proto set npcflags=16 where entry=7953;
update creature_proto set npcflags=19 where entry=7954;
update creature_proto set npcflags=131 where entry=7955;
update creature_proto set npcflags=2 where entry=7956;
update creature_proto set npcflags=2 where entry=7957;
update creature_proto set npcflags=4226 where entry=7976;
update creature_proto set npcflags=642 where entry=7978;
update creature_proto set npcflags=1 where entry=7998;
update creature_proto set npcflags=2 where entry=7999;
update creature_proto set npcflags=2 where entry=8001;
update creature_proto set npcflags=2 where entry=8015;
update creature_proto set npcflags=8195 where entry=8018;
update creature_proto set npcflags=8195 where entry=8019;
update creature_proto set npcflags=8195 where entry=8020;
update creature_proto set npcflags=2 where entry=8021;
update creature_proto set npcflags=2 where entry=8022;
update creature_proto set npcflags=2 where entry=8026;
update creature_proto set npcflags=2 where entry=8115;
update creature_proto set npcflags=130 where entry=8116;
update creature_proto set npcflags=130 where entry=8117;
update creature_proto set npcflags=130 where entry=8118;
update creature_proto set npcflags=131073 where entry=8119;
update creature_proto set npcflags=130 where entry=8121;
update creature_proto set npcflags=128 where entry=8122;
update creature_proto set npcflags=131072 where entry=8123;
update creature_proto set npcflags=131073 where entry=8124;
update creature_proto set npcflags=131 where entry=8125;
update creature_proto set npcflags=19 where entry=8126;
update creature_proto set npcflags=19 where entry=8128;
update creature_proto set npcflags=4226 where entry=8129;
update creature_proto set npcflags=4226 where entry=8131;
update creature_proto set npcflags=128 where entry=8137;
update creature_proto set npcflags=130 where entry=8139;
update creature_proto set npcflags=19 where entry=8140;
update creature_proto set npcflags=19 where entry=8141;
update creature_proto set npcflags=19 where entry=8142;
update creature_proto set npcflags=130 where entry=8143;
update creature_proto set npcflags=19 where entry=8144;
update creature_proto set npcflags=130 where entry=8145;
update creature_proto set npcflags=19 where entry=8146;
update creature_proto set npcflags=2 where entry=8147;
update creature_proto set npcflags=130 where entry=8150;
update creature_proto set npcflags=268435457 where entry=8151;
update creature_proto set npcflags=130 where entry=8152;
update creature_proto set npcflags=19 where entry=8153;
update creature_proto set npcflags=130 where entry=8157;
update creature_proto set npcflags=130 where entry=8158;
update creature_proto set npcflags=4226 where entry=8159;
update creature_proto set npcflags=130 where entry=8160;
update creature_proto set npcflags=4226 where entry=8161;
update creature_proto set npcflags=4224 where entry=8176;
update creature_proto set npcflags=128 where entry=8177;
update creature_proto set npcflags=128 where entry=8178;
update creature_proto set npcflags=2 where entry=8214;
update creature_proto set npcflags=2 where entry=8256;
update creature_proto set npcflags=2 where entry=8282;
update creature_proto set npcflags=2 where entry=8284;
update creature_proto set npcflags=130 where entry=8305;
update creature_proto set npcflags=19 where entry=8306;
update creature_proto set npcflags=130 where entry=8307;
update creature_proto set npcflags=19 where entry=8308;
update creature_proto set npcflags=131073 where entry=8356;
update creature_proto set npcflags=131073 where entry=8357;
update creature_proto set npcflags=4226 where entry=8358;
update creature_proto set npcflags=4227 where entry=8359;
update creature_proto set npcflags=4226 where entry=8360;
update creature_proto set npcflags=2178 where entry=8361;
update creature_proto set npcflags=386 where entry=8362;
update creature_proto set npcflags=130 where entry=8363;
update creature_proto set npcflags=130 where entry=8364;
update creature_proto set npcflags=2 where entry=8379;
update creature_proto set npcflags=2 where entry=8380;
update creature_proto set npcflags=2 where entry=8385;
update creature_proto set npcflags=2 where entry=8390;
update creature_proto set npcflags=2 where entry=8392;
update creature_proto set npcflags=2 where entry=8393;
update creature_proto set npcflags=2 where entry=8395;
update creature_proto set npcflags=2 where entry=8396;
update creature_proto set npcflags=2 where entry=8397;
update creature_proto set npcflags=4226 where entry=8398;
update creature_proto set npcflags=2 where entry=8399;
update creature_proto set npcflags=130 where entry=8401;
update creature_proto set npcflags=131 where entry=8403;
update creature_proto set npcflags=130 where entry=8404;
update creature_proto set npcflags=2 where entry=8405;
update creature_proto set npcflags=2 where entry=8416;
update creature_proto set npcflags=2 where entry=8417;
update creature_proto set npcflags=2 where entry=8418;
update creature_proto set npcflags=2 where entry=8420;
update creature_proto set npcflags=3 where entry=8436;
update creature_proto set npcflags=2 where entry=8439;
update creature_proto set npcflags=1 where entry=8441;
update creature_proto set npcflags=3 where entry=8479;
update creature_proto set npcflags=3 where entry=8496;
update creature_proto set npcflags=2 where entry=8507;
update creature_proto set npcflags=130 where entry=8508;
update creature_proto set npcflags=3 where entry=8509;
update creature_proto set npcflags=2 where entry=8516;
update creature_proto set npcflags=2 where entry=8517;
update creature_proto set npcflags=2 where entry=8518;
update creature_proto set npcflags=2 where entry=8576;
update creature_proto set npcflags=2 where entry=8579;
update creature_proto set npcflags=2 where entry=8582;
update creature_proto set npcflags=2 where entry=8583;
update creature_proto set npcflags=2 where entry=8584;
update creature_proto set npcflags=2 where entry=8586;
update creature_proto set npcflags=2 where entry=8587;
update creature_proto set npcflags=2 where entry=8588;
update creature_proto set npcflags=8193 where entry=8609;
update creature_proto set npcflags=8195 where entry=8610;
update creature_proto set npcflags=1 where entry=8612;
update creature_proto set npcflags=2 where entry=8617;
update creature_proto set npcflags=3 where entry=8659;
update creature_proto set npcflags=2097154 where entry=8661;
update creature_proto set npcflags=2 where entry=8664;
update creature_proto set npcflags=147 where entry=8665;
update creature_proto set npcflags=130 where entry=8666;
update creature_proto set npcflags=2097154 where entry=8669;
update creature_proto set npcflags=2097152 where entry=8670;
update creature_proto set npcflags=2097152 where entry=8671;
update creature_proto set npcflags=2097154 where entry=8672;
update creature_proto set npcflags=2097154 where entry=8673;
update creature_proto set npcflags=2097154 where entry=8674;
update creature_proto set npcflags=130 where entry=8678;
update creature_proto set npcflags=128 where entry=8679;
update creature_proto set npcflags=128 where entry=8681;
update creature_proto set npcflags=1 where entry=8696;
update creature_proto set npcflags=2097152 where entry=8719;
update creature_proto set npcflags=2097152 where entry=8720;
update creature_proto set npcflags=2097154 where entry=8721;
update creature_proto set npcflags=2097154 where entry=8722;
update creature_proto set npcflags=2097154 where entry=8723;
update creature_proto set npcflags=2097154 where entry=8724;
update creature_proto set npcflags=19 where entry=8736;
update creature_proto set npcflags=2 where entry=8737;
update creature_proto set npcflags=19 where entry=8738;
update creature_proto set npcflags=1 where entry=8767;
update creature_proto set npcflags=1 where entry=8816;
update creature_proto set npcflags=4226 where entry=8878;
update creature_proto set npcflags=3 where entry=8879;
update creature_proto set npcflags=3 where entry=8888;
update creature_proto set npcflags=2 where entry=8929;
update creature_proto set npcflags=66177 where entry=8931;
update creature_proto set npcflags=128 where entry=8934;
update creature_proto set npcflags=3 where entry=8962;
update creature_proto set npcflags=3 where entry=8965;
update creature_proto set npcflags=2 where entry=8997;
update creature_proto set npcflags=65667 where entry=8999;
update creature_proto set npcflags=2 where entry=9020;
update creature_proto set npcflags=3 where entry=9021;
update creature_proto set npcflags=2 where entry=9023;
update creature_proto set npcflags=2 where entry=9024;
update creature_proto set npcflags=1 where entry=9034;
update creature_proto set npcflags=1 where entry=9035;
update creature_proto set npcflags=1 where entry=9036;
update creature_proto set npcflags=1 where entry=9037;
update creature_proto set npcflags=1 where entry=9038;
update creature_proto set npcflags=1 where entry=9039;
update creature_proto set npcflags=1 where entry=9040;
update creature_proto set npcflags=2 where entry=9047;
update creature_proto set npcflags=3 where entry=9076;
update creature_proto set npcflags=3 where entry=9077;
update creature_proto set npcflags=2 where entry=9078;
update creature_proto set npcflags=2 where entry=9079;
update creature_proto set npcflags=3 where entry=9080;
update creature_proto set npcflags=2 where entry=9081;
update creature_proto set npcflags=2 where entry=9082;
update creature_proto set npcflags=2 where entry=9084;
update creature_proto set npcflags=131 where entry=9087;
update creature_proto set npcflags=2 where entry=9095;
update creature_proto set npcflags=641 where entry=9099;
update creature_proto set npcflags=2 where entry=9116;
update creature_proto set npcflags=2 where entry=9117;
update creature_proto set npcflags=2 where entry=9118;
update creature_proto set npcflags=2 where entry=9119;
update creature_proto set npcflags=2 where entry=9136;
update creature_proto set npcflags=2 where entry=9177;
update creature_proto set npcflags=4226 where entry=9179;
update creature_proto set npcflags=2 where entry=9238;
update creature_proto set npcflags=2 where entry=9270;
update creature_proto set npcflags=2 where entry=9271;
update creature_proto set npcflags=2 where entry=9272;
update creature_proto set npcflags=2 where entry=9274;
update creature_proto set npcflags=2 where entry=9296;
update creature_proto set npcflags=2 where entry=9298;
update creature_proto set npcflags=2 where entry=9299;
update creature_proto set npcflags=2 where entry=9316;
update creature_proto set npcflags=2 where entry=9317;
update creature_proto set npcflags=66179 where entry=9356;
update creature_proto set npcflags=3 where entry=9459;
update creature_proto set npcflags=268435457 where entry=9460;
update creature_proto set npcflags=19 where entry=9465;
update creature_proto set npcflags=130 where entry=9499;
update creature_proto set npcflags=3 where entry=9500;
update creature_proto set npcflags=66179 where entry=9501;
update creature_proto set npcflags=1 where entry=9502;
update creature_proto set npcflags=2 where entry=9503;
update creature_proto set npcflags=2 where entry=9516;
update creature_proto set npcflags=2 where entry=9520;
update creature_proto set npcflags=2 where entry=9521;
update creature_proto set npcflags=2 where entry=9528;
update creature_proto set npcflags=2 where entry=9529;
update creature_proto set npcflags=2 where entry=9536;
update creature_proto set npcflags=2 where entry=9540;
update creature_proto set npcflags=3 where entry=9543;
update creature_proto set npcflags=4227 where entry=9544;
update creature_proto set npcflags=1 where entry=9545;
update creature_proto set npcflags=2 where entry=9546;
update creature_proto set npcflags=1 where entry=9547;
update creature_proto set npcflags=4226 where entry=9548;
update creature_proto set npcflags=4226 where entry=9549;
update creature_proto set npcflags=2 where entry=9550;
update creature_proto set npcflags=4226 where entry=9551;
update creature_proto set npcflags=4482 where entry=9552;
update creature_proto set npcflags=4482 where entry=9553;
update creature_proto set npcflags=1 where entry=9554;
update creature_proto set npcflags=4482 where entry=9555;
update creature_proto set npcflags=1 where entry=9558;
update creature_proto set npcflags=1 where entry=9559;
update creature_proto set npcflags=2 where entry=9560;
update creature_proto set npcflags=2 where entry=9561;
update creature_proto set npcflags=2 where entry=9562;
update creature_proto set npcflags=3 where entry=9563;
update creature_proto set npcflags=1 where entry=9564;
update creature_proto set npcflags=2 where entry=9565;
update creature_proto set npcflags=1 where entry=9566;
update creature_proto set npcflags=17 where entry=9584;
update creature_proto set npcflags=2 where entry=9598;
update creature_proto set npcflags=3 where entry=9616;
update creature_proto set npcflags=2 where entry=9618;
update creature_proto set npcflags=2 where entry=9619;
update creature_proto set npcflags=2 where entry=9620;
update creature_proto set npcflags=2 where entry=9623;
update creature_proto set npcflags=130 where entry=9636;
update creature_proto set npcflags=2 where entry=9660;
update creature_proto set npcflags=129 where entry=9676;
update creature_proto set npcflags=2 where entry=9678;
update creature_proto set npcflags=2 where entry=9682;
update creature_proto set npcflags=2 where entry=9706;
update creature_proto set npcflags=2 where entry=9796;
update creature_proto set npcflags=3 where entry=9836;
update creature_proto set npcflags=2097154 where entry=9856;
update creature_proto set npcflags=2097154 where entry=9857;
update creature_proto set npcflags=2097152 where entry=9858;
update creature_proto set npcflags=2097152 where entry=9859;
update creature_proto set npcflags=4194304 where entry=9976;
update creature_proto set npcflags=4194304 where entry=9977;
update creature_proto set npcflags=4194304 where entry=9978;
update creature_proto set npcflags=4194304 where entry=9979;
update creature_proto set npcflags=4194304 where entry=9980;
update creature_proto set npcflags=4194304 where entry=9981;
update creature_proto set npcflags=4194304 where entry=9982;
update creature_proto set npcflags=4194304 where entry=9983;
update creature_proto set npcflags=4194304 where entry=9984;
update creature_proto set npcflags=4194304 where entry=9985;
update creature_proto set npcflags=4194304 where entry=9986;
update creature_proto set npcflags=4194304 where entry=9987;
update creature_proto set npcflags=4194304 where entry=9988;
update creature_proto set npcflags=4194304 where entry=9989;
update creature_proto set npcflags=2 where entry=9996;
update creature_proto set npcflags=2 where entry=9997;
update creature_proto set npcflags=2 where entry=9998;
update creature_proto set npcflags=2 where entry=9999;
update creature_proto set npcflags=3 where entry=10043;
update creature_proto set npcflags=4194304 where entry=10045;
update creature_proto set npcflags=4194304 where entry=10046;
update creature_proto set npcflags=4194304 where entry=10047;
update creature_proto set npcflags=4194304 where entry=10048;
update creature_proto set npcflags=4194304 where entry=10049;
update creature_proto set npcflags=4194304 where entry=10050;
update creature_proto set npcflags=4194304 where entry=10051;
update creature_proto set npcflags=4194304 where entry=10052;
update creature_proto set npcflags=4194304 where entry=10053;
update creature_proto set npcflags=4194304 where entry=10054;
update creature_proto set npcflags=4194304 where entry=10055;
update creature_proto set npcflags=4194304 where entry=10056;
update creature_proto set npcflags=4194304 where entry=10057;
update creature_proto set npcflags=4194304 where entry=10058;
update creature_proto set npcflags=4194304 where entry=10059;
update creature_proto set npcflags=4194304 where entry=10060;
update creature_proto set npcflags=4194304 where entry=10061;
update creature_proto set npcflags=4194304 where entry=10062;
update creature_proto set npcflags=4194304 where entry=10063;
update creature_proto set npcflags=2 where entry=10079;
update creature_proto set npcflags=4194304 where entry=10085;
update creature_proto set npcflags=19 where entry=10086;
update creature_proto set npcflags=19 where entry=10088;
update creature_proto set npcflags=19 where entry=10089;
update creature_proto set npcflags=19 where entry=10090;
update creature_proto set npcflags=130 where entry=10118;
update creature_proto set npcflags=3 where entry=10136;
update creature_proto set npcflags=2 where entry=10176;
update creature_proto set npcflags=268435459 where entry=10181;
update creature_proto set npcflags=2 where entry=10182;
update creature_proto set npcflags=130 where entry=10216;
update creature_proto set npcflags=2 where entry=10219;
update creature_proto set npcflags=2 where entry=10257;
update creature_proto set npcflags=2 where entry=10260;
update creature_proto set npcflags=17 where entry=10266;
update creature_proto set npcflags=3 where entry=10267;
update creature_proto set npcflags=17 where entry=10276;
update creature_proto set npcflags=17 where entry=10277;
update creature_proto set npcflags=19 where entry=10278;
update creature_proto set npcflags=4226 where entry=10293;
update creature_proto set npcflags=2 where entry=10296;
update creature_proto set npcflags=2 where entry=10300;
update creature_proto set npcflags=2 where entry=10301;
update creature_proto set npcflags=2 where entry=10302;
update creature_proto set npcflags=2 where entry=10303;
update creature_proto set npcflags=3 where entry=10304;
update creature_proto set npcflags=2 where entry=10305;
update creature_proto set npcflags=2 where entry=10306;
update creature_proto set npcflags=2 where entry=10307;
update creature_proto set npcflags=2 where entry=10321;
update creature_proto set npcflags=1048576 where entry=10360;
update creature_proto set npcflags=4224 where entry=10361;
update creature_proto set npcflags=128 where entry=10364;
update creature_proto set npcflags=128 where entry=10367;
update creature_proto set npcflags=4226 where entry=10369;
update creature_proto set npcflags=19 where entry=10370;
update creature_proto set npcflags=2 where entry=10377;
update creature_proto set npcflags=8195 where entry=10378;
update creature_proto set npcflags=4226 where entry=10379;
update creature_proto set npcflags=4226 where entry=10380;
update creature_proto set npcflags=2 where entry=10427;
update creature_proto set npcflags=2 where entry=10428;
update creature_proto set npcflags=2 where entry=10431;
update creature_proto set npcflags=1 where entry=10432;
update creature_proto set npcflags=1 where entry=10433;
update creature_proto set npcflags=1 where entry=10445;
update creature_proto set npcflags=2 where entry=10460;
update creature_proto set npcflags=2 where entry=10468;
update creature_proto set npcflags=1 where entry=10475;
update creature_proto set npcflags=2 where entry=10505;
update creature_proto set npcflags=2 where entry=10537;
update creature_proto set npcflags=2 where entry=10539;
update creature_proto set npcflags=3 where entry=10540;
update creature_proto set npcflags=8195 where entry=10583;
update creature_proto set npcflags=2 where entry=10604;
update creature_proto set npcflags=2 where entry=10606;
update creature_proto set npcflags=2 where entry=10616;
update creature_proto set npcflags=130 where entry=10618;
update creature_proto set npcflags=2 where entry=10637;
update creature_proto set npcflags=2 where entry=10638;
update creature_proto set npcflags=2 where entry=10645;
update creature_proto set npcflags=2 where entry=10646;
update creature_proto set npcflags=2 where entry=10665;
update creature_proto set npcflags=2 where entry=10666;
update creature_proto set npcflags=3 where entry=10667;
update creature_proto set npcflags=1 where entry=10668;
update creature_proto set npcflags=268435456 where entry=10676;
update creature_proto set npcflags=268435456 where entry=10682;
update creature_proto set npcflags=2 where entry=10684;
update creature_proto set npcflags=3 where entry=10739;
update creature_proto set npcflags=2 where entry=10740;
update creature_proto set npcflags=2 where entry=10776;
update creature_proto set npcflags=3 where entry=10778;
update creature_proto set npcflags=3 where entry=10781;
update creature_proto set npcflags=3 where entry=10782;
update creature_proto set npcflags=2 where entry=10799;
update creature_proto set npcflags=2 where entry=10800;
update creature_proto set npcflags=3 where entry=10837;
update creature_proto set npcflags=3 where entry=10838;
update creature_proto set npcflags=3 where entry=10839;
update creature_proto set npcflags=3 where entry=10840;
update creature_proto set npcflags=4227 where entry=10856;
update creature_proto set npcflags=4227 where entry=10857;
update creature_proto set npcflags=3 where entry=10877;
update creature_proto set npcflags=2 where entry=10878;
update creature_proto set npcflags=3 where entry=10879;
update creature_proto set npcflags=3 where entry=10880;
update creature_proto set npcflags=3 where entry=10881;
update creature_proto set npcflags=8195 where entry=10897;
update creature_proto set npcflags=2 where entry=10917;
update creature_proto set npcflags=2 where entry=10918;
update creature_proto set npcflags=2 where entry=10920;
update creature_proto set npcflags=2 where entry=10921;
update creature_proto set npcflags=2 where entry=10922;
update creature_proto set npcflags=2 where entry=10924;
update creature_proto set npcflags=2 where entry=10926;
update creature_proto set npcflags=2 where entry=10927;
update creature_proto set npcflags=2 where entry=10929;
update creature_proto set npcflags=19 where entry=10930;
update creature_proto set npcflags=2 where entry=10941;
update creature_proto set npcflags=2 where entry=10954;
update creature_proto set npcflags=2 where entry=10976;
update creature_proto set npcflags=2 where entry=10977;
update creature_proto set npcflags=2 where entry=10978;
update creature_proto set npcflags=19 where entry=10993;
update creature_proto set npcflags=2 where entry=11016;
update creature_proto set npcflags=19 where entry=11017;
update creature_proto set npcflags=2 where entry=11018;
update creature_proto set npcflags=2 where entry=11019;
update creature_proto set npcflags=2 where entry=11020;
update creature_proto set npcflags=2 where entry=11022;
update creature_proto set npcflags=2 where entry=11023;
update creature_proto set npcflags=19 where entry=11025;
update creature_proto set npcflags=17 where entry=11026;
update creature_proto set npcflags=19 where entry=11028;
update creature_proto set npcflags=19 where entry=11029;
update creature_proto set npcflags=19 where entry=11031;
update creature_proto set npcflags=3 where entry=11033;
update creature_proto set npcflags=2 where entry=11034;
update creature_proto set npcflags=3 where entry=11035;
update creature_proto set npcflags=2 where entry=11036;
update creature_proto set npcflags=19 where entry=11037;
update creature_proto set npcflags=899 where entry=11038;
update creature_proto set npcflags=2 where entry=11039;
update creature_proto set npcflags=3 where entry=11040;
update creature_proto set npcflags=19 where entry=11041;
update creature_proto set npcflags=19 where entry=11042;
update creature_proto set npcflags=19 where entry=11044;
update creature_proto set npcflags=17 where entry=11046;
update creature_proto set npcflags=19 where entry=11047;
update creature_proto set npcflags=19 where entry=11048;
update creature_proto set npcflags=19 where entry=11049;
update creature_proto set npcflags=19 where entry=11050;
update creature_proto set npcflags=19 where entry=11051;
update creature_proto set npcflags=19 where entry=11052;
update creature_proto set npcflags=3 where entry=11053;
update creature_proto set npcflags=3 where entry=11055;
update creature_proto set npcflags=131 where entry=11056;
update creature_proto set npcflags=131 where entry=11057;
update creature_proto set npcflags=3 where entry=11063;
update creature_proto set npcflags=1 where entry=11064;
update creature_proto set npcflags=17 where entry=11065;
update creature_proto set npcflags=17 where entry=11066;
update creature_proto set npcflags=19 where entry=11067;
update creature_proto set npcflags=17 where entry=11068;
update creature_proto set npcflags=4194304 where entry=11069;
update creature_proto set npcflags=19 where entry=11070;
update creature_proto set npcflags=19 where entry=11071;
update creature_proto set npcflags=17 where entry=11072;
update creature_proto set npcflags=16 where entry=11073;
update creature_proto set npcflags=19 where entry=11074;
update creature_proto set npcflags=2 where entry=11079;
update creature_proto set npcflags=19 where entry=11081;
update creature_proto set npcflags=19 where entry=11083;
update creature_proto set npcflags=19 where entry=11084;
update creature_proto set npcflags=17 where entry=11096;
update creature_proto set npcflags=19 where entry=11097;
update creature_proto set npcflags=19 where entry=11098;
update creature_proto set npcflags=65665 where entry=11103;
update creature_proto set npcflags=4194304 where entry=11104;
update creature_proto set npcflags=4194304 where entry=11105;
update creature_proto set npcflags=65667 where entry=11106;
update creature_proto set npcflags=130 where entry=11111;
update creature_proto set npcflags=65667 where entry=11116;
update creature_proto set npcflags=4194304 where entry=11117;
update creature_proto set npcflags=65667 where entry=11118;
update creature_proto set npcflags=4194304 where entry=11119;
update creature_proto set npcflags=4224 where entry=11137;
update creature_proto set npcflags=8195 where entry=11138;
update creature_proto set npcflags=8195 where entry=11139;
update creature_proto set npcflags=2 where entry=11140;
update creature_proto set npcflags=2 where entry=11142;
update creature_proto set npcflags=3 where entry=11145;
update creature_proto set npcflags=19 where entry=11146;
update creature_proto set npcflags=2 where entry=11152;
update creature_proto set npcflags=3 where entry=11176;
update creature_proto set npcflags=19 where entry=11177;
update creature_proto set npcflags=19 where entry=11178;
update creature_proto set npcflags=2 where entry=11180;
update creature_proto set npcflags=4226 where entry=11182;
update creature_proto set npcflags=4226 where entry=11183;
update creature_proto set npcflags=4224 where entry=11184;
update creature_proto set npcflags=130 where entry=11185;
update creature_proto set npcflags=130 where entry=11186;
update creature_proto set npcflags=130 where entry=11187;
update creature_proto set npcflags=130 where entry=11188;
update creature_proto set npcflags=130 where entry=11189;
update creature_proto set npcflags=268435457 where entry=11190;
update creature_proto set npcflags=2 where entry=11191;
update creature_proto set npcflags=2 where entry=11192;
update creature_proto set npcflags=2 where entry=11193;
update creature_proto set npcflags=2 where entry=11194;
update creature_proto set npcflags=3 where entry=11216;
update creature_proto set npcflags=2 where entry=11217;
update creature_proto set npcflags=130 where entry=11218;
update creature_proto set npcflags=2 where entry=11219;
update creature_proto set npcflags=2 where entry=11259;
update creature_proto set npcflags=2 where entry=11261;
update creature_proto set npcflags=4226 where entry=11278;
update creature_proto set npcflags=2 where entry=11286;
update creature_proto set npcflags=130 where entry=11287;
update creature_proto set npcflags=2 where entry=11317;
update creature_proto set npcflags=2 where entry=11378;
update creature_proto set npcflags=2 where entry=11391;
update creature_proto set npcflags=19 where entry=11397;
update creature_proto set npcflags=19 where entry=11401;
update creature_proto set npcflags=19 where entry=11406;
update creature_proto set npcflags=1 where entry=11407;
update creature_proto set npcflags=2 where entry=11438;
update creature_proto set npcflags=2 where entry=11469;
update creature_proto set npcflags=2 where entry=11470;
update creature_proto set npcflags=131 where entry=11536;
update creature_proto set npcflags=2 where entry=11548;
update creature_proto set npcflags=2 where entry=11554;
update creature_proto set npcflags=130 where entry=11555;
update creature_proto set npcflags=2 where entry=11556;
update creature_proto set npcflags=146 where entry=11557;
update creature_proto set npcflags=2 where entry=11558;
update creature_proto set npcflags=2 where entry=11596;
update creature_proto set npcflags=3 where entry=11608;
update creature_proto set npcflags=3 where entry=11609;
update creature_proto set npcflags=3 where entry=11610;
update creature_proto set npcflags=3 where entry=11615;
update creature_proto set npcflags=3 where entry=11616;
update creature_proto set npcflags=2 where entry=11624;
update creature_proto set npcflags=2 where entry=11625;
update creature_proto set npcflags=2 where entry=11626;
update creature_proto set npcflags=2 where entry=11629;
update creature_proto set npcflags=3 where entry=11696;
update creature_proto set npcflags=2 where entry=11699;
update creature_proto set npcflags=2 where entry=11700;
update creature_proto set npcflags=3 where entry=11701;
update creature_proto set npcflags=3 where entry=11702;
update creature_proto set npcflags=4226 where entry=11703;
update creature_proto set npcflags=2 where entry=11704;
update creature_proto set npcflags=2 where entry=11705;
update creature_proto set npcflags=2 where entry=11706;
update creature_proto set npcflags=2 where entry=11707;
update creature_proto set npcflags=2 where entry=11708;
update creature_proto set npcflags=2 where entry=11709;
update creature_proto set npcflags=2 where entry=11711;
update creature_proto set npcflags=2 where entry=11712;
update creature_proto set npcflags=2 where entry=11715;
update creature_proto set npcflags=2 where entry=11716;
update creature_proto set npcflags=2 where entry=11717;
update creature_proto set npcflags=2 where entry=11741;
update creature_proto set npcflags=2 where entry=11748;
update creature_proto set npcflags=2 where entry=11749;
update creature_proto set npcflags=3 where entry=11750;
update creature_proto set npcflags=2 where entry=11754;
update creature_proto set npcflags=2 where entry=11755;
update creature_proto set npcflags=2 where entry=11756;
update creature_proto set npcflags=2 where entry=11758;
update creature_proto set npcflags=1 where entry=11798;
update creature_proto set npcflags=3 where entry=11799;
update creature_proto set npcflags=1 where entry=11800;
update creature_proto set npcflags=3 where entry=11801;
update creature_proto set npcflags=3 where entry=11802;
update creature_proto set npcflags=2 where entry=11806;
update creature_proto set npcflags=2 where entry=11807;
update creature_proto set npcflags=2 where entry=11808;
update creature_proto set npcflags=2 where entry=11810;
update creature_proto set npcflags=2 where entry=11811;
update creature_proto set npcflags=2 where entry=11812;
update creature_proto set npcflags=2 where entry=11813;
update creature_proto set npcflags=2 where entry=11814;
update creature_proto set npcflags=2 where entry=11820;
update creature_proto set npcflags=2 where entry=11821;
update creature_proto set npcflags=2 where entry=11823;
update creature_proto set npcflags=2 where entry=11824;
update creature_proto set npcflags=2 where entry=11825;
update creature_proto set npcflags=2 where entry=11826;
update creature_proto set npcflags=2 where entry=11827;
update creature_proto set npcflags=2 where entry=11828;
update creature_proto set npcflags=2 where entry=11832;
update creature_proto set npcflags=3 where entry=11833;
update creature_proto set npcflags=2 where entry=11834;
update creature_proto set npcflags=3 where entry=11835;
update creature_proto set npcflags=2 where entry=11856;
update creature_proto set npcflags=2 where entry=11857;
update creature_proto set npcflags=2 where entry=11860;
update creature_proto set npcflags=2 where entry=11861;
update creature_proto set npcflags=2 where entry=11862;
update creature_proto set npcflags=2 where entry=11863;
update creature_proto set npcflags=2 where entry=11864;
update creature_proto set npcflags=19 where entry=11865;
update creature_proto set npcflags=19 where entry=11866;
update creature_proto set npcflags=17 where entry=11867;
update creature_proto set npcflags=19 where entry=11868;
update creature_proto set npcflags=19 where entry=11869;
update creature_proto set npcflags=19 where entry=11870;
update creature_proto set npcflags=2 where entry=11871;
update creature_proto set npcflags=3 where entry=11872;
update creature_proto set npcflags=128 where entry=11874;
update creature_proto set npcflags=2 where entry=11877;
update creature_proto set npcflags=3 where entry=11878;
update creature_proto set npcflags=2 where entry=11898;
update creature_proto set npcflags=8195 where entry=11899;
update creature_proto set npcflags=8195 where entry=11900;
update creature_proto set npcflags=8195 where entry=11901;
update creature_proto set npcflags=2 where entry=11936;
update creature_proto set npcflags=3 where entry=11939;
update creature_proto set npcflags=2 where entry=11940;
update creature_proto set npcflags=2 where entry=11941;
update creature_proto set npcflags=2 where entry=11942;
update creature_proto set npcflags=2 where entry=11943;
update creature_proto set npcflags=2 where entry=11944;
update creature_proto set npcflags=2 where entry=11945;
update creature_proto set npcflags=1 where entry=11946;
update creature_proto set npcflags=1 where entry=11956;
update creature_proto set npcflags=3 where entry=11997;
update creature_proto set npcflags=642 where entry=12019;
update creature_proto set npcflags=386 where entry=12021;
update creature_proto set npcflags=130 where entry=12022;
update creature_proto set npcflags=4226 where entry=12023;
update creature_proto set npcflags=4224 where entry=12024;
update creature_proto set npcflags=19 where entry=12025;
update creature_proto set npcflags=642 where entry=12026;
update creature_proto set npcflags=130 where entry=12027;
update creature_proto set npcflags=130 where entry=12028;
update creature_proto set npcflags=4226 where entry=12029;
update creature_proto set npcflags=19 where entry=12030;
update creature_proto set npcflags=130 where entry=12031;
update creature_proto set npcflags=19 where entry=12032;
update creature_proto set npcflags=130 where entry=12033;
update creature_proto set npcflags=19 where entry=12042;
update creature_proto set npcflags=130 where entry=12043;
update creature_proto set npcflags=4226 where entry=12045;
update creature_proto set npcflags=131 where entry=12096;
update creature_proto set npcflags=131 where entry=12097;
update creature_proto set npcflags=2 where entry=12126;
update creature_proto set npcflags=1 where entry=12136;
update creature_proto set npcflags=1 where entry=12137;
update creature_proto set npcflags=1 where entry=12144;
update creature_proto set npcflags=65665 where entry=12196;
update creature_proto set npcflags=1048576 where entry=12197;
update creature_proto set npcflags=1048576 where entry=12198;
update creature_proto set npcflags=2 where entry=12238;
update creature_proto set npcflags=130 where entry=12245;
update creature_proto set npcflags=130 where entry=12246;
update creature_proto set npcflags=2 where entry=12277;
update creature_proto set npcflags=2 where entry=12336;
update creature_proto set npcflags=268435457 where entry=12338;
update creature_proto set npcflags=2 where entry=12340;
update creature_proto set npcflags=131 where entry=12384;
update creature_proto set npcflags=2 where entry=12425;
update creature_proto set npcflags=2 where entry=12427;
update creature_proto set npcflags=2 where entry=12428;
update creature_proto set npcflags=2 where entry=12430;
update creature_proto set npcflags=2 where entry=12576;
update creature_proto set npcflags=8195 where entry=12577;
update creature_proto set npcflags=8195 where entry=12578;
update creature_proto set npcflags=2 where entry=12580;
update creature_proto set npcflags=8195 where entry=12596;
update creature_proto set npcflags=8195 where entry=12616;
update creature_proto set npcflags=8195 where entry=12617;
update creature_proto set npcflags=8195 where entry=12636;
update creature_proto set npcflags=2 where entry=12656;
update creature_proto set npcflags=3 where entry=12657;
update creature_proto set npcflags=3 where entry=12658;
update creature_proto set npcflags=2 where entry=12677;
update creature_proto set npcflags=2 where entry=12678;
update creature_proto set npcflags=2 where entry=12696;
update creature_proto set npcflags=1 where entry=12716;
update creature_proto set npcflags=2 where entry=12717;
update creature_proto set npcflags=2 where entry=12718;
update creature_proto set npcflags=2 where entry=12719;
update creature_proto set npcflags=2 where entry=12721;
update creature_proto set npcflags=2 where entry=12724;
update creature_proto set npcflags=2 where entry=12736;
update creature_proto set npcflags=2 where entry=12737;
update creature_proto set npcflags=2 where entry=12738;
update creature_proto set npcflags=8195 where entry=12740;
update creature_proto set npcflags=2 where entry=12757;
update creature_proto set npcflags=130 where entry=12776;
update creature_proto set npcflags=4224 where entry=12777;
update creature_proto set npcflags=128 where entry=12781;
update creature_proto set npcflags=4224 where entry=12782;
update creature_proto set npcflags=128 where entry=12783;
update creature_proto set npcflags=128 where entry=12784;
update creature_proto set npcflags=128 where entry=12785;
update creature_proto set npcflags=130 where entry=12792;
update creature_proto set npcflags=128 where entry=12793;
update creature_proto set npcflags=130 where entry=12794;
update creature_proto set npcflags=130 where entry=12795;
update creature_proto set npcflags=128 where entry=12796;
update creature_proto set npcflags=4224 where entry=12799;
update creature_proto set npcflags=4224 where entry=12805;
update creature_proto set npcflags=129 where entry=12807;
update creature_proto set npcflags=2 where entry=12816;
update creature_proto set npcflags=2 where entry=12818;
update creature_proto set npcflags=2 where entry=12836;
update creature_proto set npcflags=2 where entry=12837;
update creature_proto set npcflags=2 where entry=12858;
update creature_proto set npcflags=2 where entry=12862;
update creature_proto set npcflags=2 where entry=12863;
update creature_proto set npcflags=2 where entry=12864;
update creature_proto set npcflags=2 where entry=12866;
update creature_proto set npcflags=2 where entry=12867;
update creature_proto set npcflags=2 where entry=12877;
update creature_proto set npcflags=3 where entry=12919;
update creature_proto set npcflags=19 where entry=12920;
update creature_proto set npcflags=19 where entry=12939;
update creature_proto set npcflags=130 where entry=12941;
update creature_proto set npcflags=4226 where entry=12942;
update creature_proto set npcflags=130 where entry=12943;
update creature_proto set npcflags=131 where entry=12944;
update creature_proto set npcflags=130 where entry=12956;
update creature_proto set npcflags=130 where entry=12957;
update creature_proto set npcflags=130 where entry=12958;
update creature_proto set npcflags=130 where entry=12959;
update creature_proto set npcflags=130 where entry=12960;
update creature_proto set npcflags=19 where entry=12961;
update creature_proto set npcflags=130 where entry=12962;
update creature_proto set npcflags=268435456 where entry=12996;
update creature_proto set npcflags=3 where entry=12997;
update creature_proto set npcflags=131 where entry=13018;
update creature_proto set npcflags=3 where entry=13020;
update creature_proto set npcflags=268435457 where entry=13076;
update creature_proto set npcflags=2 where entry=13079;
update creature_proto set npcflags=2 where entry=13081;
update creature_proto set npcflags=19 where entry=13084;
update creature_proto set npcflags=3 where entry=13085;
update creature_proto set npcflags=2 where entry=13088;
update creature_proto set npcflags=2 where entry=13089;
update creature_proto set npcflags=2 where entry=13097;
update creature_proto set npcflags=32768 where entry=13116;
update creature_proto set npcflags=32768 where entry=13117;
update creature_proto set npcflags=1 where entry=13140;
update creature_proto set npcflags=2 where entry=13151;
update creature_proto set npcflags=2 where entry=13153;
update creature_proto set npcflags=3 where entry=13154;
update creature_proto set npcflags=2 where entry=13155;
update creature_proto set npcflags=3 where entry=13176;
update creature_proto set npcflags=8195 where entry=13177;
update creature_proto set npcflags=2 where entry=13178;
update creature_proto set npcflags=3 where entry=13179;
update creature_proto set npcflags=2 where entry=13180;
update creature_proto set npcflags=3 where entry=13181;
update creature_proto set npcflags=4224 where entry=13216;
update creature_proto set npcflags=4224 where entry=13217;
update creature_proto set npcflags=4224 where entry=13218;
update creature_proto set npcflags=4226 where entry=13219;
update creature_proto set npcflags=2 where entry=13220;
update creature_proto set npcflags=3 where entry=13236;
update creature_proto set npcflags=2 where entry=13256;
update creature_proto set npcflags=2 where entry=13257;
update creature_proto set npcflags=2 where entry=13278;
update creature_proto set npcflags=19 where entry=13283;
update creature_proto set npcflags=1 where entry=13284;
update creature_proto set npcflags=2 where entry=13316;
update creature_proto set npcflags=2 where entry=13319;
update creature_proto set npcflags=3 where entry=13320;
update creature_proto set npcflags=2 where entry=13377;
update creature_proto set npcflags=2 where entry=13397;
update creature_proto set npcflags=19 where entry=13417;
update creature_proto set npcflags=131 where entry=13418;
update creature_proto set npcflags=131 where entry=13420;
update creature_proto set npcflags=131 where entry=13429;
update creature_proto set npcflags=131 where entry=13430;
update creature_proto set npcflags=130 where entry=13431;
update creature_proto set npcflags=130 where entry=13432;
update creature_proto set npcflags=131 where entry=13433;
update creature_proto set npcflags=131 where entry=13434;
update creature_proto set npcflags=131 where entry=13435;
update creature_proto set npcflags=131 where entry=13436;
update creature_proto set npcflags=3 where entry=13437;
update creature_proto set npcflags=2 where entry=13438;
update creature_proto set npcflags=3 where entry=13439;
update creature_proto set npcflags=2 where entry=13441;
update creature_proto set npcflags=3 where entry=13442;
update creature_proto set npcflags=1 where entry=13443;
update creature_proto set npcflags=2 where entry=13444;
update creature_proto set npcflags=3 where entry=13445;
update creature_proto set npcflags=2 where entry=13446;
update creature_proto set npcflags=3 where entry=13447;
update creature_proto set npcflags=3 where entry=13448;
update creature_proto set npcflags=2 where entry=13449;
update creature_proto set npcflags=2178 where entry=13476;
update creature_proto set npcflags=2 where entry=13531;
update creature_proto set npcflags=2 where entry=13534;
update creature_proto set npcflags=2 where entry=13535;
update creature_proto set npcflags=2 where entry=13536;
update creature_proto set npcflags=2 where entry=13537;
update creature_proto set npcflags=2 where entry=13538;
update creature_proto set npcflags=2 where entry=13539;
update creature_proto set npcflags=2 where entry=13542;
update creature_proto set npcflags=2 where entry=13545;
update creature_proto set npcflags=3 where entry=13577;
update creature_proto set npcflags=2 where entry=13597;
update creature_proto set npcflags=2 where entry=13598;
update creature_proto set npcflags=2 where entry=13602;
update creature_proto set npcflags=4194306 where entry=13616;
update creature_proto set npcflags=4194306 where entry=13617;
update creature_proto set npcflags=2 where entry=13636;
update creature_proto set npcflags=2 where entry=13656;
update creature_proto set npcflags=2 where entry=13697;
update creature_proto set npcflags=2 where entry=13698;
update creature_proto set npcflags=2 where entry=13699;
update creature_proto set npcflags=2 where entry=13716;
update creature_proto set npcflags=2 where entry=13717;
update creature_proto set npcflags=3 where entry=13776;
update creature_proto set npcflags=3 where entry=13777;
update creature_proto set npcflags=2 where entry=13797;
update creature_proto set npcflags=2 where entry=13798;
update creature_proto set npcflags=2 where entry=13816;
update creature_proto set npcflags=2 where entry=13817;
update creature_proto set npcflags=2 where entry=13839;
update creature_proto set npcflags=3 where entry=13840;
update creature_proto set npcflags=3 where entry=13841;
update creature_proto set npcflags=2 where entry=13842;
update creature_proto set npcflags=2 where entry=13843;
update creature_proto set npcflags=2 where entry=13916;
update creature_proto set npcflags=131073 where entry=13917;
update creature_proto set npcflags=268435458 where entry=14182;
update creature_proto set npcflags=2 where entry=14183;
update creature_proto set npcflags=2 where entry=14185;
update creature_proto set npcflags=2 where entry=14186;
update creature_proto set npcflags=2 where entry=14187;
update creature_proto set npcflags=2 where entry=14188;
update creature_proto set npcflags=8195 where entry=14242;
update creature_proto set npcflags=4226 where entry=14301;
update creature_proto set npcflags=268435456 where entry=14304;
update creature_proto set npcflags=2 where entry=14305;
update creature_proto set npcflags=2 where entry=14322;
update creature_proto set npcflags=2 where entry=14325;
update creature_proto set npcflags=2 where entry=14326;
update creature_proto set npcflags=4226 where entry=14337;
update creature_proto set npcflags=2 where entry=14338;
update creature_proto set npcflags=2 where entry=14347;
update creature_proto set npcflags=2 where entry=14354;
update creature_proto set npcflags=2 where entry=14355;
update creature_proto set npcflags=2 where entry=14358;
update creature_proto set npcflags=2 where entry=14364;
update creature_proto set npcflags=2 where entry=14368;
update creature_proto set npcflags=4226 where entry=14371;
update creature_proto set npcflags=2 where entry=14373;
update creature_proto set npcflags=2 where entry=14374;
update creature_proto set npcflags=268435456 where entry=14375;
update creature_proto set npcflags=268435456 where entry=14376;
update creature_proto set npcflags=268435456 where entry=14377;
update creature_proto set npcflags=2 where entry=14378;
update creature_proto set npcflags=2 where entry=14379;
update creature_proto set npcflags=2 where entry=14380;
update creature_proto set npcflags=2 where entry=14381;
update creature_proto set npcflags=2 where entry=14382;
update creature_proto set npcflags=2 where entry=14383;
update creature_proto set npcflags=3 where entry=14387;
update creature_proto set npcflags=3 where entry=14392;
update creature_proto set npcflags=3 where entry=14394;
update creature_proto set npcflags=17 where entry=14401;
update creature_proto set npcflags=2 where entry=14402;
update creature_proto set npcflags=2 where entry=14403;
update creature_proto set npcflags=2 where entry=14404;
update creature_proto set npcflags=3 where entry=14436;
update creature_proto set npcflags=131 where entry=14437;
update creature_proto set npcflags=2 where entry=14440;
update creature_proto set npcflags=2 where entry=14441;
update creature_proto set npcflags=2 where entry=14442;
update creature_proto set npcflags=2 where entry=14444;
update creature_proto set npcflags=131 where entry=14450;
update creature_proto set npcflags=3 where entry=14451;
update creature_proto set npcflags=3 where entry=14463;
update creature_proto set npcflags=2 where entry=14469;
update creature_proto set npcflags=2 where entry=14470;
update creature_proto set npcflags=130 where entry=14480;
update creature_proto set npcflags=130 where entry=14481;
update creature_proto set npcflags=2 where entry=14494;
update creature_proto set npcflags=2 where entry=14504;
update creature_proto set npcflags=3 where entry=14508;
update creature_proto set npcflags=128 where entry=14522;
update creature_proto set npcflags=2 where entry=14524;
update creature_proto set npcflags=2 where entry=14525;
update creature_proto set npcflags=2 where entry=14526;
update creature_proto set npcflags=1 where entry=14529;
update creature_proto set npcflags=2 where entry=14566;
update creature_proto set npcflags=2 where entry=14567;
update creature_proto set npcflags=2 where entry=14568;
update creature_proto set npcflags=130 where entry=14581;
update creature_proto set npcflags=4995 where entry=14624;
update creature_proto set npcflags=2 where entry=14625;
update creature_proto set npcflags=3 where entry=14626;
update creature_proto set npcflags=3 where entry=14627;
update creature_proto set npcflags=3 where entry=14628;
update creature_proto set npcflags=3 where entry=14634;
update creature_proto set npcflags=130 where entry=14637;
update creature_proto set npcflags=2 where entry=14717;
update creature_proto set npcflags=3 where entry=14720;
update creature_proto set npcflags=3 where entry=14721;
update creature_proto set npcflags=3 where entry=14722;
update creature_proto set npcflags=3 where entry=14723;
update creature_proto set npcflags=3 where entry=14724;
update creature_proto set npcflags=3 where entry=14725;
update creature_proto set npcflags=3 where entry=14726;
update creature_proto set npcflags=2 where entry=14727;
update creature_proto set npcflags=3 where entry=14728;
update creature_proto set npcflags=3 where entry=14729;
update creature_proto set npcflags=66179 where entry=14731;
update creature_proto set npcflags=2 where entry=14733;
update creature_proto set npcflags=3 where entry=14736;
update creature_proto set npcflags=4227 where entry=14737;
update creature_proto set npcflags=131 where entry=14738;
update creature_proto set npcflags=2179 where entry=14739;
update creature_proto set npcflags=211 where entry=14740;
update creature_proto set npcflags=4194307 where entry=14741;
update creature_proto set npcflags=1 where entry=14742;
update creature_proto set npcflags=4226 where entry=14753;
update creature_proto set npcflags=4226 where entry=14754;
update creature_proto set npcflags=3 where entry=14757;
update creature_proto set npcflags=2 where entry=14781;
update creature_proto set npcflags=3 where entry=14822;
update creature_proto set npcflags=3 where entry=14823;
update creature_proto set npcflags=3 where entry=14827;
update creature_proto set npcflags=3 where entry=14828;
update creature_proto set npcflags=3 where entry=14829;
update creature_proto set npcflags=3 where entry=14832;
update creature_proto set npcflags=3 where entry=14833;
update creature_proto set npcflags=3 where entry=14841;
update creature_proto set npcflags=3 where entry=14842;
update creature_proto set npcflags=3 where entry=14843;
update creature_proto set npcflags=641 where entry=14844;
update creature_proto set npcflags=641 where entry=14845;
update creature_proto set npcflags=129 where entry=14846;
update creature_proto set npcflags=131 where entry=14847;
update creature_proto set npcflags=3 where entry=14848;
update creature_proto set npcflags=1 where entry=14849;
update creature_proto set npcflags=129 where entry=14860;
update creature_proto set npcflags=1 where entry=14866;
update creature_proto set npcflags=3 where entry=14871;
update creature_proto set npcflags=3 where entry=14875;
update creature_proto set npcflags=3 where entry=14902;
update creature_proto set npcflags=3 where entry=14903;
update creature_proto set npcflags=3 where entry=14904;
update creature_proto set npcflags=3 where entry=14905;
update creature_proto set npcflags=3 where entry=14910;
update creature_proto set npcflags=4227 where entry=14921;
update creature_proto set npcflags=1048577 where entry=14942;
update creature_proto set npcflags=642 where entry=14961;
update creature_proto set npcflags=642 where entry=14962;
update creature_proto set npcflags=130 where entry=14963;
update creature_proto set npcflags=130 where entry=14964;
update creature_proto set npcflags=1048576 where entry=14981;
update creature_proto set npcflags=1048576 where entry=14982;
update creature_proto set npcflags=3 where entry=14983;
update creature_proto set npcflags=3 where entry=14984;
update creature_proto set npcflags=1048576 where entry=14990;
update creature_proto set npcflags=1048576 where entry=14991;
update creature_proto set npcflags=1048577 where entry=15006;
update creature_proto set npcflags=1048577 where entry=15007;
update creature_proto set npcflags=1048576 where entry=15008;
update creature_proto set npcflags=131 where entry=15011;
update creature_proto set npcflags=131 where entry=15012;
update creature_proto set npcflags=3 where entry=15021;
update creature_proto set npcflags=3 where entry=15022;
update creature_proto set npcflags=3 where entry=15042;
update creature_proto set npcflags=2 where entry=15069;
update creature_proto set npcflags=3 where entry=15070;
update creature_proto set npcflags=1 where entry=15076;
update creature_proto set npcflags=2 where entry=15077;
update creature_proto set npcflags=2 where entry=15078;
update creature_proto set npcflags=2 where entry=15079;
update creature_proto set npcflags=1 where entry=15080;
update creature_proto set npcflags=1048576 where entry=15102;
update creature_proto set npcflags=1048576 where entry=15103;
update creature_proto set npcflags=1048576 where entry=15105;
update creature_proto set npcflags=1048576 where entry=15106;
update creature_proto set npcflags=2 where entry=15116;
update creature_proto set npcflags=3 where entry=15119;
update creature_proto set npcflags=642 where entry=15124;
update creature_proto set npcflags=642 where entry=15125;
update creature_proto set npcflags=4226 where entry=15126;
update creature_proto set npcflags=4226 where entry=15127;
update creature_proto set npcflags=4194304 where entry=15131;
update creature_proto set npcflags=2 where entry=15165;
update creature_proto set npcflags=3 where entry=15170;
update creature_proto set npcflags=2 where entry=15171;
update creature_proto set npcflags=65667 where entry=15174;
update creature_proto set npcflags=130 where entry=15175;
update creature_proto set npcflags=4226 where entry=15176;
update creature_proto set npcflags=8195 where entry=15177;
update creature_proto set npcflags=8195 where entry=15178;
update creature_proto set npcflags=128 where entry=15179;
update creature_proto set npcflags=2 where entry=15180;
update creature_proto set npcflags=2 where entry=15181;
update creature_proto set npcflags=2 where entry=15182;
update creature_proto set npcflags=2 where entry=15183;
update creature_proto set npcflags=268435457 where entry=15184;
update creature_proto set npcflags=2 where entry=15187;
update creature_proto set npcflags=2 where entry=15188;
update creature_proto set npcflags=2 where entry=15189;
update creature_proto set npcflags=2 where entry=15190;
update creature_proto set npcflags=2 where entry=15191;
update creature_proto set npcflags=2 where entry=15192;
update creature_proto set npcflags=2 where entry=15194;
update creature_proto set npcflags=130 where entry=15197;
update creature_proto set npcflags=128 where entry=15198;
update creature_proto set npcflags=2 where entry=15199;
update creature_proto set npcflags=2 where entry=15270;
update creature_proto set npcflags=3 where entry=15278;
update creature_proto set npcflags=19 where entry=15279;
update creature_proto set npcflags=19 where entry=15280;
update creature_proto set npcflags=3 where entry=15281;
update creature_proto set npcflags=2 where entry=15282;
update creature_proto set npcflags=19 where entry=15283;
update creature_proto set npcflags=19 where entry=15284;
update creature_proto set npcflags=19 where entry=15285;
update creature_proto set npcflags=128 where entry=15287;
update creature_proto set npcflags=4224 where entry=15289;
update creature_proto set npcflags=4224 where entry=15291;
update creature_proto set npcflags=4224 where entry=15292;
update creature_proto set npcflags=128 where entry=15293;
update creature_proto set npcflags=3 where entry=15295;
update creature_proto set npcflags=3 where entry=15296;
update creature_proto set npcflags=3 where entry=15297;
update creature_proto set npcflags=3 where entry=15301;
update creature_proto set npcflags=1 where entry=15303;
update creature_proto set npcflags=2 where entry=15306;
update creature_proto set npcflags=3 where entry=15309;
update creature_proto set npcflags=2 where entry=15310;
update creature_proto set npcflags=4224 where entry=15315;
update creature_proto set npcflags=2 where entry=15350;
update creature_proto set npcflags=2 where entry=15351;
update creature_proto set npcflags=130 where entry=15353;
update creature_proto set npcflags=128 where entry=15354;
update creature_proto set npcflags=2 where entry=15362;
update creature_proto set npcflags=2 where entry=15378;
update creature_proto set npcflags=2 where entry=15379;
update creature_proto set npcflags=2 where entry=15380;
update creature_proto set npcflags=2 where entry=15395;
update creature_proto set npcflags=65667 where entry=15397;
update creature_proto set npcflags=3 where entry=15398;
update creature_proto set npcflags=3 where entry=15399;
update creature_proto set npcflags=4243 where entry=15400;
update creature_proto set npcflags=3 where entry=15401;
update creature_proto set npcflags=2 where entry=15402;
update creature_proto set npcflags=3 where entry=15403;
update creature_proto set npcflags=3 where entry=15404;
update creature_proto set npcflags=3 where entry=15405;
update creature_proto set npcflags=2 where entry=15406;
update creature_proto set npcflags=3 where entry=15416;
update creature_proto set npcflags=2 where entry=15417;
update creature_proto set npcflags=2 where entry=15418;
update creature_proto set npcflags=128 where entry=15419;
update creature_proto set npcflags=1 where entry=15420;
update creature_proto set npcflags=65539 where entry=15433;
update creature_proto set npcflags=1 where entry=15440;
update creature_proto set npcflags=2 where entry=15443;
update creature_proto set npcflags=2 where entry=15444;
update creature_proto set npcflags=128 where entry=15471;
update creature_proto set npcflags=2 where entry=15477;
update creature_proto set npcflags=2 where entry=15493;
update creature_proto set npcflags=129 where entry=15494;
update creature_proto set npcflags=2 where entry=15498;
update creature_proto set npcflags=2 where entry=15499;
update creature_proto set npcflags=2 where entry=15500;
update creature_proto set npcflags=17 where entry=15501;
update creature_proto set npcflags=2 where entry=15502;
update creature_proto set npcflags=2 where entry=15503;
update creature_proto set npcflags=2 where entry=15504;
update creature_proto set npcflags=2 where entry=15508;
update creature_proto set npcflags=19 where entry=15513;
update creature_proto set npcflags=2 where entry=15515;
update creature_proto set npcflags=2 where entry=15526;
update creature_proto set npcflags=4098 where entry=15528;
update creature_proto set npcflags=2 where entry=15540;
update creature_proto set npcflags=2 where entry=15549;
update creature_proto set npcflags=2 where entry=15556;
update creature_proto set npcflags=2 where entry=15557;
update creature_proto set npcflags=2 where entry=15558;
update creature_proto set npcflags=3 where entry=15559;
update creature_proto set npcflags=2 where entry=15560;
update creature_proto set npcflags=3 where entry=15561;
update creature_proto set npcflags=3 where entry=15562;
update creature_proto set npcflags=2 where entry=15563;
update creature_proto set npcflags=3 where entry=15564;
update creature_proto set npcflags=2 where entry=15565;
update creature_proto set npcflags=3 where entry=15566;
update creature_proto set npcflags=2 where entry=15567;
update creature_proto set npcflags=2 where entry=15568;
update creature_proto set npcflags=2 where entry=15569;
update creature_proto set npcflags=2 where entry=15570;
update creature_proto set npcflags=2 where entry=15572;
update creature_proto set npcflags=2 where entry=15573;
update creature_proto set npcflags=2 where entry=15574;
update creature_proto set npcflags=2 where entry=15575;
update creature_proto set npcflags=3 where entry=15576;
update creature_proto set npcflags=2 where entry=15577;
update creature_proto set npcflags=2 where entry=15578;
update creature_proto set npcflags=3 where entry=15579;
update creature_proto set npcflags=3 where entry=15580;
update creature_proto set npcflags=2 where entry=15581;
update creature_proto set npcflags=3 where entry=15582;
update creature_proto set npcflags=2 where entry=15583;
update creature_proto set npcflags=2 where entry=15584;
update creature_proto set npcflags=2 where entry=15585;
update creature_proto set npcflags=2 where entry=15586;
update creature_proto set npcflags=2 where entry=15587;
update creature_proto set npcflags=2 where entry=15588;
update creature_proto set npcflags=2 where entry=15589;
update creature_proto set npcflags=3 where entry=15592;
update creature_proto set npcflags=2 where entry=15593;
update creature_proto set npcflags=3 where entry=15594;
update creature_proto set npcflags=2 where entry=15595;
update creature_proto set npcflags=2 where entry=15596;
update creature_proto set npcflags=3 where entry=15597;
update creature_proto set npcflags=2 where entry=15598;
update creature_proto set npcflags=2 where entry=15599;
update creature_proto set npcflags=2 where entry=15600;
update creature_proto set npcflags=2 where entry=15601;
update creature_proto set npcflags=3 where entry=15602;
update creature_proto set npcflags=2 where entry=15603;
update creature_proto set npcflags=2 where entry=15604;
update creature_proto set npcflags=2 where entry=15605;
update creature_proto set npcflags=2 where entry=15606;
update creature_proto set npcflags=2 where entry=15607;
update creature_proto set npcflags=2 where entry=15608;
update creature_proto set npcflags=1 where entry=15612;
update creature_proto set npcflags=2 where entry=15613;
update creature_proto set npcflags=2 where entry=15614;
update creature_proto set npcflags=2 where entry=15615;
update creature_proto set npcflags=2 where entry=15624;
update creature_proto set npcflags=2097152 where entry=15659;
update creature_proto set npcflags=1 where entry=15664;
update creature_proto set npcflags=2097154 where entry=15675;
update creature_proto set npcflags=2097154 where entry=15676;
update creature_proto set npcflags=2097152 where entry=15677;
update creature_proto set npcflags=2097154 where entry=15678;
update creature_proto set npcflags=2097154 where entry=15679;
update creature_proto set npcflags=2097152 where entry=15681;
update creature_proto set npcflags=2097154 where entry=15682;
update creature_proto set npcflags=2097154 where entry=15683;
update creature_proto set npcflags=2097154 where entry=15684;
update creature_proto set npcflags=2097154 where entry=15686;
update creature_proto set npcflags=2 where entry=15700;
update creature_proto set npcflags=2 where entry=15702;
update creature_proto set npcflags=2 where entry=15704;
update creature_proto set npcflags=2 where entry=15707;
update creature_proto set npcflags=2 where entry=15708;
update creature_proto set npcflags=4194304 where entry=15722;
update creature_proto set npcflags=3 where entry=15732;
update creature_proto set npcflags=1 where entry=15760;
update creature_proto set npcflags=3 where entry=15761;
update creature_proto set npcflags=3 where entry=15762;
update creature_proto set npcflags=3 where entry=15763;
update creature_proto set npcflags=3 where entry=15764;
update creature_proto set npcflags=3 where entry=15765;
update creature_proto set npcflags=3 where entry=15766;
update creature_proto set npcflags=3 where entry=15767;
update creature_proto set npcflags=3 where entry=15768;
update creature_proto set npcflags=3 where entry=15871;
update creature_proto set npcflags=2 where entry=15891;
update creature_proto set npcflags=2 where entry=15892;
update creature_proto set npcflags=3 where entry=15895;
update creature_proto set npcflags=128 where entry=15898;
update creature_proto set npcflags=3 where entry=15920;
update creature_proto set npcflags=3 where entry=15921;
update creature_proto set npcflags=3 where entry=15924;
update creature_proto set npcflags=3 where entry=15939;
update creature_proto set npcflags=2 where entry=15940;
update creature_proto set npcflags=2 where entry=15941;
update creature_proto set npcflags=3 where entry=15942;
update creature_proto set npcflags=2 where entry=15945;
update creature_proto set npcflags=3 where entry=15951;
update creature_proto set npcflags=3 where entry=15969;
update creature_proto set npcflags=3 where entry=15970;
update creature_proto set npcflags=3 where entry=15991;
update creature_proto set npcflags=3 where entry=16012;
update creature_proto set npcflags=3 where entry=16013;
update creature_proto set npcflags=2 where entry=16014;
update creature_proto set npcflags=130 where entry=16015;
update creature_proto set npcflags=2 where entry=16016;
update creature_proto set npcflags=2 where entry=16031;
update creature_proto set npcflags=2 where entry=16032;
update creature_proto set npcflags=2 where entry=16033;
update creature_proto set npcflags=1 where entry=16070;
update creature_proto set npcflags=2 where entry=16073;
update creature_proto set npcflags=1 where entry=16076;
update creature_proto set npcflags=2 where entry=16091;
update creature_proto set npcflags=4194304 where entry=16094;
update creature_proto set npcflags=3 where entry=16112;
update creature_proto set npcflags=3 where entry=16113;
update creature_proto set npcflags=3 where entry=16114;
update creature_proto set npcflags=3 where entry=16115;
update creature_proto set npcflags=3 where entry=16116;
update creature_proto set npcflags=3 where entry=16131;
update creature_proto set npcflags=3 where entry=16132;
update creature_proto set npcflags=3 where entry=16133;
update creature_proto set npcflags=3 where entry=16134;
update creature_proto set npcflags=3 where entry=16135;
update creature_proto set npcflags=3 where entry=16144;
update creature_proto set npcflags=1 where entry=16147;
update creature_proto set npcflags=1 where entry=16153;
update creature_proto set npcflags=4194304 where entry=16156;
update creature_proto set npcflags=1 where entry=16159;
update creature_proto set npcflags=17 where entry=16160;
update creature_proto set npcflags=17 where entry=16161;
update creature_proto set npcflags=1 where entry=16169;
update creature_proto set npcflags=3 where entry=16183;
update creature_proto set npcflags=4194304 where entry=16185;
update creature_proto set npcflags=4224 where entry=16186;
update creature_proto set npcflags=131 where entry=16187;
update creature_proto set npcflags=8195 where entry=16189;
update creature_proto set npcflags=131 where entry=16191;
update creature_proto set npcflags=8195 where entry=16192;
update creature_proto set npcflags=3 where entry=16196;
update creature_proto set npcflags=3 where entry=16197;
update creature_proto set npcflags=3 where entry=16198;
update creature_proto set npcflags=3 where entry=16199;
update creature_proto set npcflags=2 where entry=16200;
update creature_proto set npcflags=3 where entry=16201;
update creature_proto set npcflags=3 where entry=16202;
update creature_proto set npcflags=3 where entry=16203;
update creature_proto set npcflags=2 where entry=16204;
update creature_proto set npcflags=3 where entry=16205;
update creature_proto set npcflags=1 where entry=16206;
update creature_proto set npcflags=1 where entry=16208;
update creature_proto set npcflags=1 where entry=16209;
update creature_proto set npcflags=3 where entry=16210;
update creature_proto set npcflags=3 where entry=16213;
update creature_proto set npcflags=1 where entry=16217;
update creature_proto set npcflags=3 where entry=16219;
update creature_proto set npcflags=3 where entry=16220;
update creature_proto set npcflags=268435457 where entry=16221;
update creature_proto set npcflags=268435457 where entry=16222;
update creature_proto set npcflags=131 where entry=16224;
update creature_proto set npcflags=2 where entry=16226;
update creature_proto set npcflags=8195 where entry=16227;
update creature_proto set npcflags=3 where entry=16231;
update creature_proto set npcflags=2 where entry=16237;
update creature_proto set npcflags=2 where entry=16239;
update creature_proto set npcflags=2 where entry=16240;
update creature_proto set npcflags=3 where entry=16251;
update creature_proto set npcflags=3 where entry=16252;
update creature_proto set npcflags=147 where entry=16253;
update creature_proto set npcflags=66179 where entry=16256;
update creature_proto set npcflags=4224 where entry=16257;
update creature_proto set npcflags=4224 where entry=16258;
update creature_proto set npcflags=128 where entry=16259;
update creature_proto set npcflags=4224 where entry=16260;
update creature_proto set npcflags=4224 where entry=16261;
update creature_proto set npcflags=128 where entry=16262;
update creature_proto set npcflags=4225 where entry=16263;
update creature_proto set npcflags=129 where entry=16264;
update creature_proto set npcflags=17 where entry=16266;
update creature_proto set npcflags=129 where entry=16267;
update creature_proto set npcflags=131 where entry=16268;
update creature_proto set npcflags=17 where entry=16269;
update creature_proto set npcflags=17 where entry=16270;
update creature_proto set npcflags=17 where entry=16271;
update creature_proto set npcflags=17 where entry=16272;
update creature_proto set npcflags=16 where entry=16273;
update creature_proto set npcflags=4224 where entry=16274;
update creature_proto set npcflags=19 where entry=16275;
update creature_proto set npcflags=19 where entry=16276;
update creature_proto set npcflags=17 where entry=16277;
update creature_proto set npcflags=4112 where entry=16278;
update creature_proto set npcflags=17 where entry=16279;
update creature_proto set npcflags=4113 where entry=16280;
update creature_proto set npcflags=3 where entry=16283;
update creature_proto set npcflags=3 where entry=16287;
update creature_proto set npcflags=3 where entry=16288;
update creature_proto set npcflags=3 where entry=16289;
update creature_proto set npcflags=2 where entry=16291;
update creature_proto set npcflags=3 where entry=16293;
update creature_proto set npcflags=3 where entry=16295;
update creature_proto set npcflags=2 where entry=16361;
update creature_proto set npcflags=3 where entry=16362;
update creature_proto set npcflags=145 where entry=16366;
update creature_proto set npcflags=145 where entry=16367;
update creature_proto set npcflags=4227 where entry=16376;
update creature_proto set npcflags=4227 where entry=16388;
update creature_proto set npcflags=3 where entry=16397;
update creature_proto set npcflags=3 where entry=16399;
update creature_proto set npcflags=2 where entry=16416;
update creature_proto set npcflags=2 where entry=16417;
update creature_proto set npcflags=2 where entry=16418;
update creature_proto set npcflags=1 where entry=16426;
update creature_proto set npcflags=2 where entry=16431;
update creature_proto set npcflags=641 where entry=16442;
update creature_proto set npcflags=128 where entry=16443;
update creature_proto set npcflags=129 where entry=16444;
update creature_proto set npcflags=65667 where entry=16458;
update creature_proto set npcflags=3 where entry=16462;
update creature_proto set npcflags=3 where entry=16463;
update creature_proto set npcflags=3 where entry=16464;
update creature_proto set npcflags=2 where entry=16475;
update creature_proto set npcflags=3 where entry=16476;
update creature_proto set npcflags=3 where entry=16477;
update creature_proto set npcflags=2 where entry=16478;
update creature_proto set npcflags=2 where entry=16480;
update creature_proto set npcflags=2 where entry=16494;
update creature_proto set npcflags=19 where entry=16499;
update creature_proto set npcflags=19 where entry=16500;
update creature_proto set npcflags=19 where entry=16501;
update creature_proto set npcflags=19 where entry=16502;
update creature_proto set npcflags=19 where entry=16503;
update creature_proto set npcflags=3 where entry=16514;
update creature_proto set npcflags=1 where entry=16519;
update creature_proto set npcflags=4225 where entry=16528;
update creature_proto set npcflags=2 where entry=16531;
update creature_proto set npcflags=3 where entry=16535;
update creature_proto set npcflags=65665 where entry=16542;
update creature_proto set npcflags=128 where entry=16543;
update creature_proto set npcflags=3 where entry=16546;
update creature_proto set npcflags=2 where entry=16551;
update creature_proto set npcflags=65667 where entry=16553;
update creature_proto set npcflags=3 where entry=16554;
update creature_proto set npcflags=786433 where entry=16568;
update creature_proto set npcflags=3 where entry=16574;
update creature_proto set npcflags=2 where entry=16575;
update creature_proto set npcflags=3 where entry=16576;
update creature_proto set npcflags=2 where entry=16577;
update creature_proto set npcflags=4243 where entry=16583;
update creature_proto set npcflags=3 where entry=16584;
update creature_proto set npcflags=128 where entry=16585;
update creature_proto set npcflags=4194304 where entry=16586;
update creature_proto set npcflags=8193 where entry=16587;
update creature_proto set npcflags=147 where entry=16588;
update creature_proto set npcflags=2 where entry=16601;
update creature_proto set npcflags=65665 where entry=16602;
update creature_proto set npcflags=1 where entry=16603;
update creature_proto set npcflags=128 where entry=16610;
update creature_proto set npcflags=128 where entry=16611;
update creature_proto set npcflags=2176 where entry=16612;
update creature_proto set npcflags=128 where entry=16613;
update creature_proto set npcflags=131073 where entry=16615;
update creature_proto set npcflags=131073 where entry=16616;
update creature_proto set npcflags=131073 where entry=16617;
update creature_proto set npcflags=66177 where entry=16618;
update creature_proto set npcflags=4224 where entry=16619;
update creature_proto set npcflags=4224 where entry=16620;
update creature_proto set npcflags=16 where entry=16621;
update creature_proto set npcflags=4224 where entry=16623;
update creature_proto set npcflags=128 where entry=16624;
update creature_proto set npcflags=4224 where entry=16625;
update creature_proto set npcflags=4224 where entry=16626;
update creature_proto set npcflags=2097152 where entry=16627;
update creature_proto set npcflags=2097152 where entry=16628;
update creature_proto set npcflags=2097152 where entry=16629;
update creature_proto set npcflags=4224 where entry=16631;
update creature_proto set npcflags=4224 where entry=16632;
update creature_proto set npcflags=81 where entry=16633;
update creature_proto set npcflags=17 where entry=16634;
update creature_proto set npcflags=128 where entry=16635;
update creature_proto set npcflags=4224 where entry=16636;
update creature_proto set npcflags=4224 where entry=16637;
update creature_proto set npcflags=128 where entry=16638;
update creature_proto set npcflags=17 where entry=16639;
update creature_proto set npcflags=17 where entry=16640;
update creature_proto set npcflags=128 where entry=16641;
update creature_proto set npcflags=17 where entry=16642;
update creature_proto set npcflags=17 where entry=16643;
update creature_proto set npcflags=17 where entry=16644;
update creature_proto set npcflags=19 where entry=16646;
update creature_proto set npcflags=19 where entry=16647;
update creature_proto set npcflags=19 where entry=16648;
update creature_proto set npcflags=131 where entry=16649;
update creature_proto set npcflags=128 where entry=16650;
update creature_proto set npcflags=19 where entry=16651;
update creature_proto set npcflags=19 where entry=16652;
update creature_proto set npcflags=17 where entry=16653;
update creature_proto set npcflags=17 where entry=16654;
update creature_proto set npcflags=19 where entry=16655;
update creature_proto set npcflags=4194304 where entry=16656;
update creature_proto set npcflags=128 where entry=16657;
update creature_proto set npcflags=51 where entry=16658;
update creature_proto set npcflags=51 where entry=16659;
update creature_proto set npcflags=49 where entry=16660;
update creature_proto set npcflags=81 where entry=16662;
update creature_proto set npcflags=17 where entry=16663;
update creature_proto set npcflags=128 where entry=16664;
update creature_proto set npcflags=4194305 where entry=16665;
update creature_proto set npcflags=4224 where entry=16666;
update creature_proto set npcflags=17 where entry=16667;
update creature_proto set npcflags=17 where entry=16668;
update creature_proto set npcflags=19 where entry=16669;
update creature_proto set npcflags=4224 where entry=16670;
update creature_proto set npcflags=17 where entry=16671;
update creature_proto set npcflags=19 where entry=16672;
update creature_proto set npcflags=19 where entry=16673;
update creature_proto set npcflags=17 where entry=16674;
update creature_proto set npcflags=19 where entry=16675;
update creature_proto set npcflags=81 where entry=16676;
update creature_proto set npcflags=128 where entry=16677;
update creature_proto set npcflags=4224 where entry=16678;
update creature_proto set npcflags=17 where entry=16679;
update creature_proto set npcflags=17 where entry=16680;
update creature_proto set npcflags=19 where entry=16681;
update creature_proto set npcflags=1152 where entry=16683;
update creature_proto set npcflags=19 where entry=16684;
update creature_proto set npcflags=19 where entry=16685;
update creature_proto set npcflags=17 where entry=16686;
update creature_proto set npcflags=17 where entry=16687;
update creature_proto set npcflags=17 where entry=16688;
update creature_proto set npcflags=128 where entry=16689;
update creature_proto set npcflags=128 where entry=16690;
update creature_proto set npcflags=4224 where entry=16691;
update creature_proto set npcflags=17 where entry=16692;
update creature_proto set npcflags=4224 where entry=16693;
update creature_proto set npcflags=1048576 where entry=16694;
update creature_proto set npcflags=1048576 where entry=16695;
update creature_proto set npcflags=1048576 where entry=16696;
update creature_proto set npcflags=19 where entry=16702;
update creature_proto set npcflags=17 where entry=16703;
update creature_proto set npcflags=128 where entry=16705;
update creature_proto set npcflags=128 where entry=16706;
update creature_proto set npcflags=2097152 where entry=16707;
update creature_proto set npcflags=128 where entry=16708;
update creature_proto set npcflags=128 where entry=16709;
update creature_proto set npcflags=131073 where entry=16710;
update creature_proto set npcflags=19 where entry=16712;
update creature_proto set npcflags=128 where entry=16713;
update creature_proto set npcflags=4224 where entry=16714;
update creature_proto set npcflags=4224 where entry=16715;
update creature_proto set npcflags=4224 where entry=16716;
update creature_proto set npcflags=128 where entry=16718;
update creature_proto set npcflags=19 where entry=16719;
update creature_proto set npcflags=19 where entry=16721;
update creature_proto set npcflags=128 where entry=16722;
update creature_proto set npcflags=17 where entry=16723;
update creature_proto set npcflags=17 where entry=16724;
update creature_proto set npcflags=17 where entry=16725;
update creature_proto set npcflags=17 where entry=16726;
update creature_proto set npcflags=17 where entry=16727;
update creature_proto set npcflags=17 where entry=16728;
update creature_proto set npcflags=17 where entry=16729;
update creature_proto set npcflags=17 where entry=16731;
update creature_proto set npcflags=128 where entry=16732;
update creature_proto set npcflags=268435457 where entry=16733;
update creature_proto set npcflags=786433 where entry=16734;
update creature_proto set npcflags=4224 where entry=16735;
update creature_proto set npcflags=17 where entry=16736;
update creature_proto set npcflags=19 where entry=16738;
update creature_proto set npcflags=65667 where entry=16739;
update creature_proto set npcflags=17 where entry=16740;
update creature_proto set npcflags=17 where entry=16741;
update creature_proto set npcflags=17 where entry=16742;
update creature_proto set npcflags=17 where entry=16743;
update creature_proto set npcflags=19 where entry=16744;
update creature_proto set npcflags=17 where entry=16745;
update creature_proto set npcflags=17 where entry=16746;
update creature_proto set npcflags=4224 where entry=16747;
update creature_proto set npcflags=128 where entry=16748;
update creature_proto set npcflags=17 where entry=16749;
update creature_proto set npcflags=4224 where entry=16750;
update creature_proto set npcflags=128 where entry=16751;
update creature_proto set npcflags=17 where entry=16752;
update creature_proto set npcflags=4224 where entry=16753;
update creature_proto set npcflags=17 where entry=16755;
update creature_proto set npcflags=19 where entry=16756;
update creature_proto set npcflags=128 where entry=16757;
update creature_proto set npcflags=19 where entry=16761;
update creature_proto set npcflags=4224 where entry=16762;
update creature_proto set npcflags=17 where entry=16763;
update creature_proto set npcflags=4194304 where entry=16764;
update creature_proto set npcflags=4224 where entry=16765;
update creature_proto set npcflags=128 where entry=16766;
update creature_proto set npcflags=128 where entry=16767;
update creature_proto set npcflags=130 where entry=16768;
update creature_proto set npcflags=19 where entry=16771;
update creature_proto set npcflags=17 where entry=16773;
update creature_proto set npcflags=17 where entry=16774;
update creature_proto set npcflags=81 where entry=16780;
update creature_proto set npcflags=130 where entry=16782;
update creature_proto set npcflags=2 where entry=16788;
update creature_proto set npcflags=3 where entry=16789;
update creature_proto set npcflags=3 where entry=16790;
update creature_proto set npcflags=3 where entry=16791;
update creature_proto set npcflags=3 where entry=16792;
update creature_proto set npcflags=3 where entry=16793;
update creature_proto set npcflags=3 where entry=16794;
update creature_proto set npcflags=3 where entry=16796;
update creature_proto set npcflags=3 where entry=16797;
update creature_proto set npcflags=128 where entry=16798;
update creature_proto set npcflags=3 where entry=16799;
update creature_proto set npcflags=3 where entry=16802;
update creature_proto set npcflags=1 where entry=16806;
update creature_proto set npcflags=1 where entry=16811;
update creature_proto set npcflags=1 where entry=16812;
update creature_proto set npcflags=2 where entry=16813;
update creature_proto set npcflags=2 where entry=16814;
update creature_proto set npcflags=2 where entry=16815;
update creature_proto set npcflags=1 where entry=16816;
update creature_proto set npcflags=3 where entry=16817;
update creature_proto set npcflags=3 where entry=16818;
update creature_proto set npcflags=3 where entry=16819;
update creature_proto set npcflags=3 where entry=16820;
update creature_proto set npcflags=8193 where entry=16822;
update creature_proto set npcflags=4241 where entry=16823;
update creature_proto set npcflags=4194304 where entry=16824;
update creature_proto set npcflags=2 where entry=16825;
update creature_proto set npcflags=65667 where entry=16826;
update creature_proto set npcflags=3 where entry=16827;
update creature_proto set npcflags=130 where entry=16829;
update creature_proto set npcflags=3 where entry=16830;
update creature_proto set npcflags=2 where entry=16832;
update creature_proto set npcflags=3 where entry=16833;
update creature_proto set npcflags=3 where entry=16834;
update creature_proto set npcflags=3 where entry=16837;
update creature_proto set npcflags=2 where entry=16839;
update creature_proto set npcflags=3 where entry=16841;
update creature_proto set npcflags=3 where entry=16845;
update creature_proto set npcflags=3 where entry=16848;
update creature_proto set npcflags=3 where entry=16850;
update creature_proto set npcflags=3 where entry=16851;
update creature_proto set npcflags=2 where entry=16852;
update creature_proto set npcflags=1 where entry=16856;
update creature_proto set npcflags=3 where entry=16858;
update creature_proto set npcflags=3 where entry=16859;
update creature_proto set npcflags=129 where entry=16860;
update creature_proto set npcflags=1 where entry=16862;
update creature_proto set npcflags=3 where entry=16885;
update creature_proto set npcflags=1 where entry=16886;
update creature_proto set npcflags=3 where entry=16888;
update creature_proto set npcflags=3 where entry=16915;
update creature_proto set npcflags=4224 where entry=16917;
update creature_proto set npcflags=4224 where entry=16918;
update creature_proto set npcflags=4224 where entry=16919;
update creature_proto set npcflags=128 where entry=16920;
update creature_proto set npcflags=3 where entry=16924;
update creature_proto set npcflags=3 where entry=16991;
update creature_proto set npcflags=2 where entry=16993;
update creature_proto set npcflags=2 where entry=17002;
update creature_proto set npcflags=17 where entry=17005;
update creature_proto set npcflags=3 where entry=17006;
update creature_proto set npcflags=2 where entry=17015;
update creature_proto set npcflags=1 where entry=17046;
update creature_proto set npcflags=1 where entry=17056;
update creature_proto set npcflags=2 where entry=17062;
update creature_proto set npcflags=2 where entry=17069;
update creature_proto set npcflags=3 where entry=17071;
update creature_proto set npcflags=2 where entry=17072;
update creature_proto set npcflags=1 where entry=17073;
update creature_proto set npcflags=3 where entry=17076;
update creature_proto set npcflags=2 where entry=17079;
update creature_proto set npcflags=2 where entry=17080;
update creature_proto set npcflags=2 where entry=17085;
update creature_proto set npcflags=3 where entry=17087;
update creature_proto set npcflags=1 where entry=17088;
update creature_proto set npcflags=19 where entry=17089;
update creature_proto set npcflags=3 where entry=17092;
update creature_proto set npcflags=2 where entry=17093;
update creature_proto set npcflags=2 where entry=17094;
update creature_proto set npcflags=2 where entry=17095;
update creature_proto set npcflags=2 where entry=17097;
update creature_proto set npcflags=2 where entry=17098;
update creature_proto set npcflags=3 where entry=17099;
update creature_proto set npcflags=2 where entry=17100;
update creature_proto set npcflags=147 where entry=17101;
update creature_proto set npcflags=3 where entry=17103;
update creature_proto set npcflags=3 where entry=17104;
update creature_proto set npcflags=3 where entry=17105;
update creature_proto set npcflags=2 where entry=17106;
update creature_proto set npcflags=3 where entry=17109;
update creature_proto set npcflags=19 where entry=17110;
update creature_proto set npcflags=2 where entry=17114;
update creature_proto set npcflags=3 where entry=17116;
update creature_proto set npcflags=1 where entry=17119;
update creature_proto set npcflags=19 where entry=17120;
update creature_proto set npcflags=17 where entry=17121;
update creature_proto set npcflags=17 where entry=17122;
update creature_proto set npcflags=3 where entry=17123;
update creature_proto set npcflags=3 where entry=17127;
update creature_proto set npcflags=19 where entry=17204;
update creature_proto set npcflags=3 where entry=17205;
update creature_proto set npcflags=1 where entry=17209;
update creature_proto set npcflags=1 where entry=17211;
update creature_proto set npcflags=19 where entry=17212;
update creature_proto set npcflags=19 where entry=17214;
update creature_proto set npcflags=19 where entry=17215;
update creature_proto set npcflags=2 where entry=17218;
update creature_proto set npcflags=19 where entry=17219;
update creature_proto set npcflags=147 where entry=17222;
update creature_proto set npcflags=3 where entry=17223;
update creature_proto set npcflags=2 where entry=17224;
update creature_proto set npcflags=3 where entry=17226;
update creature_proto set npcflags=1 where entry=17228;
update creature_proto set npcflags=2 where entry=17232;
update creature_proto set npcflags=3 where entry=17238;
update creature_proto set npcflags=3 where entry=17240;
update creature_proto set npcflags=3 where entry=17241;
update creature_proto set npcflags=3 where entry=17242;
update creature_proto set npcflags=1 where entry=17243;
update creature_proto set npcflags=4241 where entry=17245;
update creature_proto set npcflags=147 where entry=17246;
update creature_proto set npcflags=1 where entry=17249;
update creature_proto set npcflags=3 where entry=17275;
update creature_proto set npcflags=128 where entry=17277;
update creature_proto set npcflags=2 where entry=17287;
update creature_proto set npcflags=3 where entry=17290;
update creature_proto set npcflags=2 where entry=17291;
update creature_proto set npcflags=3 where entry=17296;
update creature_proto set npcflags=2 where entry=17303;
update creature_proto set npcflags=2 where entry=17310;
update creature_proto set npcflags=3 where entry=17311;
update creature_proto set npcflags=2 where entry=17312;
update creature_proto set npcflags=2 where entry=17329;
update creature_proto set npcflags=2 where entry=17355;
update creature_proto set npcflags=2 where entry=17360;
update creature_proto set npcflags=2 where entry=17361;
update creature_proto set npcflags=2 where entry=17362;
update creature_proto set npcflags=2 where entry=17363;
update creature_proto set npcflags=2 where entry=17364;
update creature_proto set npcflags=1 where entry=17380;
update creature_proto set npcflags=128 where entry=17412;
update creature_proto set npcflags=131 where entry=17421;
update creature_proto set npcflags=3 where entry=17423;
update creature_proto set npcflags=19 where entry=17424;
update creature_proto set npcflags=2 where entry=17431;
update creature_proto set npcflags=2 where entry=17433;
update creature_proto set npcflags=19 where entry=17434;
update creature_proto set npcflags=2 where entry=17435;
update creature_proto set npcflags=3 where entry=17440;
update creature_proto set npcflags=19 where entry=17441;
update creature_proto set npcflags=19 where entry=17442;
update creature_proto set npcflags=3 where entry=17443;
update creature_proto set npcflags=3 where entry=17445;
update creature_proto set npcflags=129 where entry=17446;
update creature_proto set npcflags=2 where entry=17447;
update creature_proto set npcflags=3 where entry=17468;
update creature_proto set npcflags=1 where entry=17469;
update creature_proto set npcflags=3 where entry=17479;
update creature_proto set npcflags=19 where entry=17480;
update creature_proto set npcflags=19 where entry=17481;
update creature_proto set npcflags=19 where entry=17482;
update creature_proto set npcflags=19 where entry=17483;
update creature_proto set npcflags=17 where entry=17484;
update creature_proto set npcflags=4194304 where entry=17485;
update creature_proto set npcflags=128 where entry=17486;
update creature_proto set npcflags=17 where entry=17487;
update creature_proto set npcflags=19 where entry=17488;
update creature_proto set npcflags=128 where entry=17489;
update creature_proto set npcflags=129 where entry=17490;
update creature_proto set npcflags=3 where entry=17493;
update creature_proto set npcflags=17 where entry=17504;
update creature_proto set npcflags=19 where entry=17505;
update creature_proto set npcflags=2 where entry=17508;
update creature_proto set npcflags=19 where entry=17509;
update creature_proto set npcflags=17 where entry=17510;
update creature_proto set npcflags=19 where entry=17511;
update creature_proto set npcflags=128 where entry=17512;
update creature_proto set npcflags=19 where entry=17513;
update creature_proto set npcflags=19 where entry=17514;
update creature_proto set npcflags=4224 where entry=17518;
update creature_proto set npcflags=19 where entry=17519;
update creature_proto set npcflags=19 where entry=17520;
update creature_proto set npcflags=2 where entry=17538;
update creature_proto set npcflags=2 where entry=17545;
update creature_proto set npcflags=65667 where entry=17553;
update creature_proto set npcflags=8195 where entry=17554;
update creature_proto set npcflags=8195 where entry=17555;
update creature_proto set npcflags=2 where entry=17557;
update creature_proto set npcflags=3 where entry=17558;
update creature_proto set npcflags=131 where entry=17584;
update creature_proto set npcflags=129 where entry=17585;
update creature_proto set npcflags=2 where entry=17586;
update creature_proto set npcflags=2 where entry=17587;
update creature_proto set npcflags=384 where entry=17598;
update creature_proto set npcflags=3 where entry=17599;
update creature_proto set npcflags=2 where entry=17600;
update creature_proto set npcflags=3 where entry=17613;
update creature_proto set npcflags=3 where entry=17614;
update creature_proto set npcflags=2097152 where entry=17627;
update creature_proto set npcflags=2097152 where entry=17628;
update creature_proto set npcflags=2097152 where entry=17629;
update creature_proto set npcflags=66177 where entry=17630;
update creature_proto set npcflags=131073 where entry=17631;
update creature_proto set npcflags=131073 where entry=17632;
update creature_proto set npcflags=131073 where entry=17633;
update creature_proto set npcflags=19 where entry=17634;
update creature_proto set npcflags=2 where entry=17636;
update creature_proto set npcflags=19 where entry=17637;
update creature_proto set npcflags=3 where entry=17642;
update creature_proto set npcflags=3 where entry=17649;
update creature_proto set npcflags=4225 where entry=17655;
update creature_proto set npcflags=129 where entry=17656;
update creature_proto set npcflags=129 where entry=17657;
update creature_proto set npcflags=3 where entry=17658;
update creature_proto set npcflags=3 where entry=17663;
update creature_proto set npcflags=4194304 where entry=17666;
update creature_proto set npcflags=4224 where entry=17667;
update creature_proto set npcflags=3 where entry=17674;
update creature_proto set npcflags=3 where entry=17676;
update creature_proto set npcflags=2 where entry=17682;
update creature_proto set npcflags=3 where entry=17684;
update creature_proto set npcflags=3 where entry=17686;
update creature_proto set npcflags=3 where entry=17703;
update creature_proto set npcflags=3 where entry=17712;
update creature_proto set npcflags=3 where entry=17717;
update creature_proto set npcflags=2 where entry=17718;
update creature_proto set npcflags=1 where entry=17769;
update creature_proto set npcflags=131073 where entry=17773;
update creature_proto set npcflags=3 where entry=17804;
update creature_proto set npcflags=2 where entry=17807;
update creature_proto set npcflags=1 where entry=17822;
update creature_proto set npcflags=1 where entry=17824;
update creature_proto set npcflags=2 where entry=17825;
update creature_proto set npcflags=3 where entry=17831;
update creature_proto set npcflags=3 where entry=17834;
update creature_proto set npcflags=3 where entry=17841;
update creature_proto set npcflags=3 where entry=17843;
update creature_proto set npcflags=19 where entry=17844;
update creature_proto set npcflags=2 where entry=17849;
update creature_proto set npcflags=3 where entry=17856;
update creature_proto set npcflags=3 where entry=17857;
update creature_proto set npcflags=3 where entry=17858;
update creature_proto set npcflags=3 where entry=17866;
update creature_proto set npcflags=2 where entry=17876;
update creature_proto set npcflags=3 where entry=17877;
update creature_proto set npcflags=3 where entry=17884;
update creature_proto set npcflags=1 where entry=17885;
update creature_proto set npcflags=4194304 where entry=17896;
update creature_proto set npcflags=1 where entry=17900;
update creature_proto set npcflags=1 where entry=17901;
update creature_proto set npcflags=4224 where entry=17904;
update creature_proto set npcflags=3 where entry=17909;
update creature_proto set npcflags=3 where entry=17923;
update creature_proto set npcflags=3 where entry=17924;
update creature_proto set npcflags=3 where entry=17925;
update creature_proto set npcflags=3 where entry=17926;
update creature_proto set npcflags=3 where entry=17927;
update creature_proto set npcflags=4224 where entry=17929;
update creature_proto set npcflags=4224 where entry=17930;
update creature_proto set npcflags=3 where entry=17956;
update creature_proto set npcflags=2 where entry=17969;
update creature_proto set npcflags=3 where entry=17982;
update creature_proto set npcflags=16 where entry=17983;
update creature_proto set npcflags=3 where entry=17986;
update creature_proto set npcflags=3 where entry=18003;
update creature_proto set npcflags=3 where entry=18004;
update creature_proto set npcflags=131 where entry=18005;
update creature_proto set npcflags=131 where entry=18006;
update creature_proto set npcflags=3 where entry=18007;
update creature_proto set npcflags=3 where entry=18008;
update creature_proto set npcflags=131 where entry=18009;
update creature_proto set npcflags=4227 where entry=18010;
update creature_proto set npcflags=4227 where entry=18011;
update creature_proto set npcflags=3 where entry=18012;
update creature_proto set npcflags=3 where entry=18013;
update creature_proto set npcflags=3 where entry=18014;
update creature_proto set npcflags=131 where entry=18015;
update creature_proto set npcflags=3 where entry=18016;
update creature_proto set npcflags=131 where entry=18017;
update creature_proto set npcflags=147 where entry=18018;
update creature_proto set npcflags=131 where entry=18019;
update creature_proto set npcflags=3 where entry=18020;
update creature_proto set npcflags=3 where entry=18024;
update creature_proto set npcflags=1 where entry=18030;
update creature_proto set npcflags=2 where entry=18035;
update creature_proto set npcflags=268435457 where entry=18038;
update creature_proto set npcflags=3 where entry=18063;
update creature_proto set npcflags=3 where entry=18066;
update creature_proto set npcflags=3 where entry=18067;
update creature_proto set npcflags=3 where entry=18068;
update creature_proto set npcflags=3 where entry=18070;
update creature_proto set npcflags=3 where entry=18071;
update creature_proto set npcflags=3 where entry=18072;
update creature_proto set npcflags=3 where entry=18073;
update creature_proto set npcflags=3 where entry=18074;
update creature_proto set npcflags=2 where entry=18090;
update creature_proto set npcflags=2 where entry=18091;
update creature_proto set npcflags=2 where entry=18097;
update creature_proto set npcflags=3 where entry=18098;
update creature_proto set npcflags=3 where entry=18099;
update creature_proto set npcflags=3 where entry=18106;
update creature_proto set npcflags=3 where entry=18141;
update creature_proto set npcflags=3 where entry=18165;
update creature_proto set npcflags=3 where entry=18166;
update creature_proto set npcflags=3 where entry=18180;
update creature_proto set npcflags=2 where entry=18183;
update creature_proto set npcflags=1 where entry=18197;
update creature_proto set npcflags=3 where entry=18200;
update creature_proto set npcflags=2 where entry=18209;
update creature_proto set npcflags=2 where entry=18210;
update creature_proto set npcflags=3 where entry=18218;
update creature_proto set npcflags=3 where entry=18221;
update creature_proto set npcflags=2 where entry=18222;
update creature_proto set npcflags=2 where entry=18223;
update creature_proto set npcflags=2 where entry=18224;
update creature_proto set npcflags=3 where entry=18229;
update creature_proto set npcflags=2 where entry=18233;
update creature_proto set npcflags=2 where entry=18234;
update creature_proto set npcflags=128 where entry=18243;
update creature_proto set npcflags=4194304 where entry=18244;
update creature_proto set npcflags=65665 where entry=18245;
update creature_proto set npcflags=3 where entry=18248;
update creature_proto set npcflags=2 where entry=18249;
update creature_proto set npcflags=4194304 where entry=18250;
update creature_proto set npcflags=65665 where entry=18251;
update creature_proto set npcflags=3 where entry=18252;
update creature_proto set npcflags=3 where entry=18253;
update creature_proto set npcflags=128 where entry=18255;
update creature_proto set npcflags=3 where entry=18261;
update creature_proto set npcflags=2 where entry=18262;
update creature_proto set npcflags=3 where entry=18265;
update creature_proto set npcflags=131 where entry=18266;
update creature_proto set npcflags=131 where entry=18267;
update creature_proto set npcflags=2 where entry=18273;
update creature_proto set npcflags=3 where entry=18276;
update creature_proto set npcflags=128 where entry=18277;
update creature_proto set npcflags=4224 where entry=18278;
update creature_proto set npcflags=2 where entry=18294;
update creature_proto set npcflags=2 where entry=18295;
update creature_proto set npcflags=2 where entry=18300;
update creature_proto set npcflags=2 where entry=18301;
update creature_proto set npcflags=3 where entry=18302;
update creature_proto set npcflags=3 where entry=18333;
update creature_proto set npcflags=3 where entry=18335;
update creature_proto set npcflags=128 where entry=18347;
update creature_proto set npcflags=2097152 where entry=18348;
update creature_proto set npcflags=2097152 where entry=18349;
update creature_proto set npcflags=131073 where entry=18350;
update creature_proto set npcflags=1 where entry=18351;
update creature_proto set npcflags=2 where entry=18353;
update creature_proto set npcflags=3 where entry=18369;
update creature_proto set npcflags=4224 where entry=18382;
update creature_proto set npcflags=3 where entry=18383;
update creature_proto set npcflags=3 where entry=18384;
update creature_proto set npcflags=3 where entry=18385;
update creature_proto set npcflags=3 where entry=18386;
update creature_proto set npcflags=3 where entry=18387;
update creature_proto set npcflags=3 where entry=18389;
update creature_proto set npcflags=3 where entry=18390;
update creature_proto set npcflags=3 where entry=18407;
update creature_proto set npcflags=3 where entry=18408;
update creature_proto set npcflags=3 where entry=18414;
update creature_proto set npcflags=3 where entry=18415;
update creature_proto set npcflags=3 where entry=18416;
update creature_proto set npcflags=2 where entry=18417;
update creature_proto set npcflags=3 where entry=18424;
update creature_proto set npcflags=4224 where entry=18426;
update creature_proto set npcflags=128 where entry=18427;
update creature_proto set npcflags=1 where entry=18439;
update creature_proto set npcflags=2 where entry=18442;
update creature_proto set npcflags=2 where entry=18443;
update creature_proto set npcflags=2 where entry=18445;
update creature_proto set npcflags=3 where entry=18446;
update creature_proto set npcflags=3 where entry=18447;
update creature_proto set npcflags=2 where entry=18448;
update creature_proto set npcflags=3 where entry=18459;
update creature_proto set npcflags=3 where entry=18471;
update creature_proto set npcflags=3 where entry=18481;
update creature_proto set npcflags=3 where entry=18482;
update creature_proto set npcflags=131 where entry=18484;
update creature_proto set npcflags=128 where entry=18525;
update creature_proto set npcflags=2 where entry=18530;
update creature_proto set npcflags=3 where entry=18531;
update creature_proto set npcflags=3 where entry=18537;
update creature_proto set npcflags=3 where entry=18538;
update creature_proto set npcflags=65664 where entry=18542;
update creature_proto set npcflags=268435457 where entry=18549;
update creature_proto set npcflags=129 where entry=18564;
update creature_proto set npcflags=3 where entry=18565;
update creature_proto set npcflags=3 where entry=18566;
update creature_proto set npcflags=268435457 where entry=18568;
update creature_proto set npcflags=129 where entry=18581;
update creature_proto set npcflags=3 where entry=18584;
update creature_proto set npcflags=1 where entry=18585;
update creature_proto set npcflags=1 where entry=18586;
update creature_proto set npcflags=1 where entry=18588;
update creature_proto set npcflags=3 where entry=18596;
update creature_proto set npcflags=3 where entry=18597;
update creature_proto set npcflags=3 where entry=18653;
update creature_proto set npcflags=128 where entry=18664;
update creature_proto set npcflags=4224 where entry=18672;
update creature_proto set npcflags=3 where entry=18675;
update creature_proto set npcflags=2 where entry=18687;
update creature_proto set npcflags=3 where entry=18704;
update creature_proto set npcflags=3 where entry=18705;
update creature_proto set npcflags=3 where entry=18712;
update creature_proto set npcflags=3 where entry=18713;
update creature_proto set npcflags=3 where entry=18714;
update creature_proto set npcflags=3 where entry=18715;
update creature_proto set npcflags=1 where entry=18716;
update creature_proto set npcflags=1 where entry=18717;
update creature_proto set npcflags=1 where entry=18719;
update creature_proto set npcflags=1 where entry=18720;
update creature_proto set npcflags=2 where entry=18723;
update creature_proto set npcflags=3 where entry=18745;
update creature_proto set npcflags=17 where entry=18747;
update creature_proto set npcflags=17 where entry=18748;
update creature_proto set npcflags=145 where entry=18749;
update creature_proto set npcflags=145 where entry=18751;
update creature_proto set npcflags=145 where entry=18752;
update creature_proto set npcflags=145 where entry=18753;
update creature_proto set npcflags=145 where entry=18754;
update creature_proto set npcflags=17 where entry=18755;
update creature_proto set npcflags=2 where entry=18756;
update creature_proto set npcflags=3 where entry=18760;
update creature_proto set npcflags=2097152 where entry=18761;
update creature_proto set npcflags=145 where entry=18771;
update creature_proto set npcflags=145 where entry=18772;
update creature_proto set npcflags=145 where entry=18773;
update creature_proto set npcflags=145 where entry=18774;
update creature_proto set npcflags=145 where entry=18775;
update creature_proto set npcflags=17 where entry=18776;
update creature_proto set npcflags=17 where entry=18777;
update creature_proto set npcflags=17 where entry=18779;
update creature_proto set npcflags=1 where entry=18781;
update creature_proto set npcflags=8193 where entry=18785;
update creature_proto set npcflags=8193 where entry=18788;
update creature_proto set npcflags=8193 where entry=18789;
update creature_proto set npcflags=1 where entry=18790;
update creature_proto set npcflags=8193 where entry=18791;
update creature_proto set npcflags=1 where entry=18792;
update creature_proto set npcflags=147 where entry=18802;
update creature_proto set npcflags=3 where entry=18803;
update creature_proto set npcflags=18 where entry=18804;
update creature_proto set npcflags=8193 where entry=18807;
update creature_proto set npcflags=8193 where entry=18808;
update creature_proto set npcflags=8193 where entry=18809;
update creature_proto set npcflags=128 where entry=18810;
update creature_proto set npcflags=128 where entry=18811;
update creature_proto set npcflags=2 where entry=18816;
update creature_proto set npcflags=3 where entry=18817;
update creature_proto set npcflags=128 where entry=18821;
update creature_proto set npcflags=129 where entry=18822;
update creature_proto set npcflags=2 where entry=18891;
update creature_proto set npcflags=3 where entry=18893;
update creature_proto set npcflags=1048576 where entry=18895;
update creature_proto set npcflags=262145 where entry=18897;
update creature_proto set npcflags=1 where entry=18898;
update creature_proto set npcflags=65665 where entry=18905;
update creature_proto set npcflags=65665 where entry=18906;
update creature_proto set npcflags=65665 where entry=18907;
update creature_proto set npcflags=65665 where entry=18908;
update creature_proto set npcflags=128 where entry=18911;
update creature_proto set npcflags=65665 where entry=18913;
update creature_proto set npcflags=65665 where entry=18914;
update creature_proto set npcflags=4224 where entry=18926;
update creature_proto set npcflags=3 where entry=18927;
update creature_proto set npcflags=128 where entry=18929;
update creature_proto set npcflags=8195 where entry=18930;
update creature_proto set npcflags=8195 where entry=18931;
update creature_proto set npcflags=3 where entry=18933;
update creature_proto set npcflags=8193 where entry=18937;
update creature_proto set npcflags=8193 where entry=18938;
update creature_proto set npcflags=8193 where entry=18939;
update creature_proto set npcflags=8195 where entry=18940;
update creature_proto set npcflags=8193 where entry=18942;
update creature_proto set npcflags=129 where entry=18947;
update creature_proto set npcflags=128 where entry=18951;
update creature_proto set npcflags=8193 where entry=18953;
update creature_proto set npcflags=128 where entry=18954;
update creature_proto set npcflags=65665 where entry=18957;
update creature_proto set npcflags=128 where entry=18959;
update creature_proto set npcflags=128 where entry=18960;
update creature_proto set npcflags=4224 where entry=18962;
update creature_proto set npcflags=4194304 where entry=18984;
update creature_proto set npcflags=1 where entry=18985;
update creature_proto set npcflags=145 where entry=18987;
update creature_proto set npcflags=145 where entry=18988;
update creature_proto set npcflags=128 where entry=18990;
update creature_proto set npcflags=128 where entry=18991;
update creature_proto set npcflags=145 where entry=18993;
update creature_proto set npcflags=4225 where entry=18997;
update creature_proto set npcflags=129 where entry=18998;
update creature_proto set npcflags=4225 where entry=19001;
update creature_proto set npcflags=129 where entry=19004;
update creature_proto set npcflags=4225 where entry=19011;
update creature_proto set npcflags=4225 where entry=19012;
update creature_proto set npcflags=129 where entry=19013;
update creature_proto set npcflags=129 where entry=19014;
update creature_proto set npcflags=129 where entry=19015;
update creature_proto set npcflags=129 where entry=19017;
update creature_proto set npcflags=4194304 where entry=19018;
update creature_proto set npcflags=4194304 where entry=19019;
update creature_proto set npcflags=129 where entry=19020;
update creature_proto set npcflags=129 where entry=19021;
update creature_proto set npcflags=1 where entry=19033;
update creature_proto set npcflags=131073 where entry=19034;
update creature_proto set npcflags=3 where entry=19035;
update creature_proto set npcflags=128 where entry=19038;
update creature_proto set npcflags=128 where entry=19042;
update creature_proto set npcflags=4224 where entry=19043;
update creature_proto set npcflags=130 where entry=19045;
update creature_proto set npcflags=65537 where entry=19046;
update creature_proto set npcflags=4225 where entry=19047;
update creature_proto set npcflags=128 where entry=19049;
update creature_proto set npcflags=640 where entry=19050;
update creature_proto set npcflags=1 where entry=19051;
update creature_proto set npcflags=19 where entry=19052;
update creature_proto set npcflags=128 where entry=19053;
update creature_proto set npcflags=4224 where entry=19056;
update creature_proto set npcflags=17 where entry=19063;
update creature_proto set npcflags=128 where entry=19065;
update creature_proto set npcflags=128 where entry=19074;
update creature_proto set npcflags=3 where entry=19133;
update creature_proto set npcflags=3 where entry=19137;
update creature_proto set npcflags=1 where entry=19140;
update creature_proto set npcflags=1 where entry=19141;
update creature_proto set npcflags=3 where entry=19148;
update creature_proto set npcflags=1 where entry=19156;
update creature_proto set npcflags=1 where entry=19158;
update creature_proto set npcflags=1 where entry=19169;
update creature_proto set npcflags=1 where entry=19172;
update creature_proto set npcflags=3 where entry=19175;
update creature_proto set npcflags=1 where entry=19176;
update creature_proto set npcflags=1 where entry=19177;
update creature_proto set npcflags=3 where entry=19178;
update creature_proto set npcflags=17 where entry=19180;
update creature_proto set npcflags=128 where entry=19182;
update creature_proto set npcflags=17 where entry=19184;
update creature_proto set npcflags=81 where entry=19185;
update creature_proto set npcflags=147 where entry=19186;
update creature_proto set npcflags=17 where entry=19187;
update creature_proto set npcflags=128 where entry=19194;
update creature_proto set npcflags=128 where entry=19195;
update creature_proto set npcflags=128 where entry=19196;
update creature_proto set npcflags=384 where entry=19197;
update creature_proto set npcflags=128 where entry=19213;
update creature_proto set npcflags=3 where entry=19217;
update creature_proto set npcflags=640 where entry=19223;
update creature_proto set npcflags=131 where entry=19227;
update creature_proto set npcflags=2 where entry=19229;
update creature_proto set npcflags=66177 where entry=19232;
update creature_proto set npcflags=128 where entry=19234;
update creature_proto set npcflags=128 where entry=19235;
update creature_proto set npcflags=4224 where entry=19236;
update creature_proto set npcflags=4224 where entry=19238;
update creature_proto set npcflags=5248 where entry=19239;
update creature_proto set npcflags=4224 where entry=19240;
update creature_proto set npcflags=128 where entry=19243;
update creature_proto set npcflags=128 where entry=19244;
update creature_proto set npcflags=128 where entry=19245;
update creature_proto set npcflags=131073 where entry=19246;
update creature_proto set npcflags=16 where entry=19248;
update creature_proto set npcflags=16 where entry=19249;
update creature_proto set npcflags=16 where entry=19250;
update creature_proto set npcflags=16 where entry=19251;
update creature_proto set npcflags=17 where entry=19252;
update creature_proto set npcflags=3 where entry=19253;
update creature_proto set npcflags=3 where entry=19254;
update creature_proto set npcflags=3 where entry=19255;
update creature_proto set npcflags=3 where entry=19256;
update creature_proto set npcflags=2 where entry=19257;
update creature_proto set npcflags=2 where entry=19258;
update creature_proto set npcflags=3 where entry=19265;
update creature_proto set npcflags=3 where entry=19266;
update creature_proto set npcflags=3 where entry=19273;
update creature_proto set npcflags=3 where entry=19293;
update creature_proto set npcflags=3 where entry=19294;
update creature_proto set npcflags=65665 where entry=19296;
update creature_proto set npcflags=2 where entry=19308;
update creature_proto set npcflags=2 where entry=19309;
update creature_proto set npcflags=3 where entry=19310;
update creature_proto set npcflags=4225 where entry=19314;
update creature_proto set npcflags=4225 where entry=19315;
update creature_proto set npcflags=2 where entry=19316;
update creature_proto set npcflags=8193 where entry=19317;
update creature_proto set npcflags=131073 where entry=19318;
update creature_proto set npcflags=65537 where entry=19319;
update creature_proto set npcflags=128 where entry=19321;
update creature_proto set npcflags=128 where entry=19330;
update creature_proto set npcflags=128 where entry=19331;
update creature_proto set npcflags=3 where entry=19332;
update creature_proto set npcflags=4227 where entry=19333;
update creature_proto set npcflags=131073 where entry=19338;
update creature_proto set npcflags=4224 where entry=19339;
update creature_proto set npcflags=17 where entry=19340;
update creature_proto set npcflags=17 where entry=19341;
update creature_proto set npcflags=4224 where entry=19342;
update creature_proto set npcflags=128 where entry=19343;
update creature_proto set npcflags=3 where entry=19344;
update creature_proto set npcflags=128 where entry=19345;
update creature_proto set npcflags=128 where entry=19348;
update creature_proto set npcflags=4224 where entry=19351;
update creature_proto set npcflags=65665 where entry=19352;
update creature_proto set npcflags=3 where entry=19361;
update creature_proto set npcflags=2 where entry=19363;
update creature_proto set npcflags=3 where entry=19367;
update creature_proto set npcflags=4194304 where entry=19368;
update creature_proto set npcflags=16 where entry=19369;
update creature_proto set npcflags=4227 where entry=19370;
update creature_proto set npcflags=128 where entry=19371;
update creature_proto set npcflags=128 where entry=19372;
update creature_proto set npcflags=4224 where entry=19373;
update creature_proto set npcflags=128 where entry=19374;
update creature_proto set npcflags=1 where entry=19375;
update creature_proto set npcflags=2 where entry=19382;
update creature_proto set npcflags=4224 where entry=19383;
update creature_proto set npcflags=3 where entry=19401;
update creature_proto set npcflags=3 where entry=19409;
update creature_proto set npcflags=2 where entry=19412;
update creature_proto set npcflags=3 where entry=19417;
update creature_proto set npcflags=128 where entry=19435;
update creature_proto set npcflags=4224 where entry=19436;
update creature_proto set npcflags=128 where entry=19450;
update creature_proto set npcflags=128 where entry=19451;
update creature_proto set npcflags=4224 where entry=19452;
update creature_proto set npcflags=2 where entry=19456;
update creature_proto set npcflags=3 where entry=19466;
update creature_proto set npcflags=3 where entry=19467;
update creature_proto set npcflags=3 where entry=19468;
update creature_proto set npcflags=2 where entry=19469;
update creature_proto set npcflags=65665 where entry=19470;
update creature_proto set npcflags=130 where entry=19471;
update creature_proto set npcflags=128 where entry=19472;
update creature_proto set npcflags=4224 where entry=19473;
update creature_proto set npcflags=128 where entry=19474;
update creature_proto set npcflags=4194304 where entry=19476;
update creature_proto set npcflags=17 where entry=19478;
update creature_proto set npcflags=4224 where entry=19479;
update creature_proto set npcflags=3 where entry=19481;
update creature_proto set npcflags=2 where entry=19485;
update creature_proto set npcflags=3 where entry=19488;
update creature_proto set npcflags=3 where entry=19489;
update creature_proto set npcflags=65665 where entry=19495;
update creature_proto set npcflags=3 where entry=19496;
update creature_proto set npcflags=128 where entry=19497;
update creature_proto set npcflags=128 where entry=19498;
update creature_proto set npcflags=4224 where entry=19499;
update creature_proto set npcflags=4224 where entry=19517;
update creature_proto set npcflags=128 where entry=19518;
update creature_proto set npcflags=128 where entry=19520;
update creature_proto set npcflags=128 where entry=19521;
update creature_proto set npcflags=4224 where entry=19526;
update creature_proto set npcflags=128 where entry=19528;
update creature_proto set npcflags=4224 where entry=19530;
update creature_proto set npcflags=65665 where entry=19531;
update creature_proto set npcflags=128 where entry=19532;
update creature_proto set npcflags=128 where entry=19533;
update creature_proto set npcflags=128 where entry=19534;
update creature_proto set npcflags=128 where entry=19535;
update creature_proto set npcflags=4224 where entry=19536;
update creature_proto set npcflags=128 where entry=19537;
update creature_proto set npcflags=128 where entry=19538;
update creature_proto set npcflags=16 where entry=19539;
update creature_proto set npcflags=16 where entry=19540;
update creature_proto set npcflags=3 where entry=19542;
update creature_proto set npcflags=2 where entry=19556;
update creature_proto set npcflags=8193 where entry=19558;
update creature_proto set npcflags=128 where entry=19559;
update creature_proto set npcflags=128 where entry=19560;
update creature_proto set npcflags=4224 where entry=19561;
update creature_proto set npcflags=128 where entry=19562;
update creature_proto set npcflags=3 where entry=19569;
update creature_proto set npcflags=3 where entry=19570;
update creature_proto set npcflags=65537 where entry=19571;
update creature_proto set npcflags=128 where entry=19572;
update creature_proto set npcflags=128 where entry=19573;
update creature_proto set npcflags=128 where entry=19574;
update creature_proto set npcflags=4224 where entry=19575;
update creature_proto set npcflags=17 where entry=19576;
update creature_proto set npcflags=3 where entry=19578;
update creature_proto set npcflags=8193 where entry=19581;
update creature_proto set npcflags=8193 where entry=19583;
update creature_proto set npcflags=2 where entry=19589;
update creature_proto set npcflags=1 where entry=19606;
update creature_proto set npcflags=131 where entry=19617;
update creature_proto set npcflags=128 where entry=19625;
update creature_proto set npcflags=3 where entry=19634;
update creature_proto set npcflags=3 where entry=19644;
update creature_proto set npcflags=3 where entry=19645;
update creature_proto set npcflags=268435456 where entry=19647;
update creature_proto set npcflags=128 where entry=19649;
update creature_proto set npcflags=128 where entry=19661;
update creature_proto set npcflags=4224 where entry=19662;
update creature_proto set npcflags=128 where entry=19663;
update creature_proto set npcflags=641 where entry=19664;
update creature_proto set npcflags=1 where entry=19669;
update creature_proto set npcflags=2 where entry=19670;
update creature_proto set npcflags=2 where entry=19671;
update creature_proto set npcflags=3 where entry=19674;
update creature_proto set npcflags=3 where entry=19676;
update creature_proto set npcflags=2179 where entry=19678;
update creature_proto set npcflags=129 where entry=19679;
update creature_proto set npcflags=2 where entry=19682;
update creature_proto set npcflags=2 where entry=19683;
update creature_proto set npcflags=2 where entry=19684;
update creature_proto set npcflags=268435457 where entry=19687;
update creature_proto set npcflags=3 where entry=19690;
update creature_proto set npcflags=1 where entry=19693;
update creature_proto set npcflags=4224 where entry=19694;
update creature_proto set npcflags=2 where entry=19697;
update creature_proto set npcflags=2 where entry=19698;
update creature_proto set npcflags=3 where entry=19705;
update creature_proto set npcflags=3 where entry=19709;
update creature_proto set npcflags=2 where entry=19715;
update creature_proto set npcflags=129 where entry=19718;
update creature_proto set npcflags=3 where entry=19720;
update creature_proto set npcflags=128 where entry=19722;
update creature_proto set npcflags=3 where entry=19728;
update creature_proto set npcflags=2 where entry=19736;
update creature_proto set npcflags=129 where entry=19772;
update creature_proto set npcflags=129 where entry=19773;
update creature_proto set npcflags=19 where entry=19774;
update creature_proto set npcflags=17 where entry=19775;
update creature_proto set npcflags=19 where entry=19777;
update creature_proto set npcflags=17 where entry=19778;
update creature_proto set npcflags=1 where entry=19830;
update creature_proto set npcflags=1 where entry=19831;
update creature_proto set npcflags=3 where entry=19832;
update creature_proto set npcflags=128 where entry=19836;
update creature_proto set npcflags=128 where entry=19837;
update creature_proto set npcflags=3 where entry=19840;
update creature_proto set npcflags=2 where entry=19844;
update creature_proto set npcflags=1048577 where entry=19855;
update creature_proto set npcflags=262145 where entry=19856;
update creature_proto set npcflags=1 where entry=19857;
update creature_proto set npcflags=1048576 where entry=19858;
update creature_proto set npcflags=4224 where entry=19879;
update creature_proto set npcflags=3 where entry=19880;
update creature_proto set npcflags=1 where entry=19882;
update creature_proto set npcflags=1048577 where entry=19905;
update creature_proto set npcflags=1048577 where entry=19906;
update creature_proto set npcflags=1048577 where entry=19907;
update creature_proto set npcflags=1048576 where entry=19908;
update creature_proto set npcflags=1048577 where entry=19909;
update creature_proto set npcflags=1048576 where entry=19910;
update creature_proto set npcflags=1048576 where entry=19911;
update creature_proto set npcflags=1048577 where entry=19912;
update creature_proto set npcflags=1048577 where entry=19915;
update creature_proto set npcflags=1048576 where entry=19923;
update creature_proto set npcflags=1048576 where entry=19925;
update creature_proto set npcflags=2 where entry=19932;
update creature_proto set npcflags=2 where entry=19935;
update creature_proto set npcflags=2 where entry=19937;
update creature_proto set npcflags=2 where entry=19942;
update creature_proto set npcflags=1048576 where entry=20002;
update creature_proto set npcflags=4098 where entry=20010;
update creature_proto set npcflags=4098 where entry=20011;
update creature_proto set npcflags=4098 where entry=20012;
update creature_proto set npcflags=4098 where entry=20013;
update creature_proto set npcflags=4098 where entry=20014;
update creature_proto set npcflags=4098 where entry=20020;
update creature_proto set npcflags=4098 where entry=20022;
update creature_proto set npcflags=128 where entry=20028;
update creature_proto set npcflags=3 where entry=20066;
update creature_proto set npcflags=3 where entry=20067;
update creature_proto set npcflags=3 where entry=20068;
update creature_proto set npcflags=3 where entry=20071;
update creature_proto set npcflags=128 where entry=20080;
update creature_proto set npcflags=128 where entry=20081;
update creature_proto set npcflags=4224 where entry=20082;
update creature_proto set npcflags=3 where entry=20084;
update creature_proto set npcflags=131 where entry=20092;
update creature_proto set npcflags=128 where entry=20096;
update creature_proto set npcflags=128 where entry=20097;
update creature_proto set npcflags=1 where entry=20102;
update creature_proto set npcflags=3 where entry=20110;
update creature_proto set npcflags=2 where entry=20111;
update creature_proto set npcflags=4227 where entry=20112;
update creature_proto set npcflags=1048576 where entry=20118;
update creature_proto set npcflags=1048576 where entry=20119;
update creature_proto set npcflags=1048576 where entry=20120;
update creature_proto set npcflags=128 where entry=20121;
update creature_proto set npcflags=16 where entry=20124;
update creature_proto set npcflags=16 where entry=20125;
update creature_proto set npcflags=128 where entry=20130;
update creature_proto set npcflags=3 where entry=20142;
update creature_proto set npcflags=2 where entry=20154;
update creature_proto set npcflags=2 where entry=20159;
update creature_proto set npcflags=3 where entry=20162;
update creature_proto set npcflags=129 where entry=20194;
update creature_proto set npcflags=2 where entry=20201;
update creature_proto set npcflags=2 where entry=20205;
update creature_proto set npcflags=2 where entry=20206;
update creature_proto set npcflags=1 where entry=20227;
update creature_proto set npcflags=4225 where entry=20231;
update creature_proto set npcflags=3 where entry=20232;
update creature_proto set npcflags=3 where entry=20233;
update creature_proto set npcflags=8195 where entry=20234;
update creature_proto set npcflags=3 where entry=20235;
update creature_proto set npcflags=1 where entry=20236;
update creature_proto set npcflags=128 where entry=20240;
update creature_proto set npcflags=128 where entry=20241;
update creature_proto set npcflags=128 where entry=20242;
update creature_proto set npcflags=128 where entry=20249;
update creature_proto set npcflags=128 where entry=20250;
update creature_proto set npcflags=1048577 where entry=20269;
update creature_proto set npcflags=1048576 where entry=20271;
update creature_proto set npcflags=1048576 where entry=20272;
update creature_proto set npcflags=1048576 where entry=20273;
update creature_proto set npcflags=1048577 where entry=20274;
update creature_proto set npcflags=1048577 where entry=20276;
update creature_proto set npcflags=129 where entry=20278;
update creature_proto set npcflags=3 where entry=20281;
update creature_proto set npcflags=1 where entry=20339;
update creature_proto set npcflags=2 where entry=20341;
update creature_proto set npcflags=1048576 where entry=20362;
update creature_proto set npcflags=128 where entry=20377;
update creature_proto set npcflags=130 where entry=20378;
update creature_proto set npcflags=1048576 where entry=20381;
update creature_proto set npcflags=1048576 where entry=20382;
update creature_proto set npcflags=1048577 where entry=20383;
update creature_proto set npcflags=1048577 where entry=20384;
update creature_proto set npcflags=1 where entry=20385;
update creature_proto set npcflags=1048577 where entry=20386;
update creature_proto set npcflags=3 where entry=20389;
update creature_proto set npcflags=1048576 where entry=20390;
update creature_proto set npcflags=3 where entry=20393;
update creature_proto set npcflags=1 where entry=20395;
update creature_proto set npcflags=1 where entry=20397;
update creature_proto set npcflags=19 where entry=20406;
update creature_proto set npcflags=19 where entry=20407;
update creature_proto set npcflags=2 where entry=20415;
update creature_proto set npcflags=1 where entry=20416;
update creature_proto set npcflags=1 where entry=20435;
update creature_proto set npcflags=3 where entry=20448;
update creature_proto set npcflags=3 where entry=20449;
update creature_proto set npcflags=3 where entry=20450;
update creature_proto set npcflags=4227 where entry=20463;
update creature_proto set npcflags=2 where entry=20464;
update creature_proto set npcflags=3 where entry=20470;
update creature_proto set npcflags=3 where entry=20471;
update creature_proto set npcflags=2 where entry=20482;
update creature_proto set npcflags=130 where entry=20494;
update creature_proto set npcflags=1048577 where entry=20497;
update creature_proto set npcflags=18 where entry=20500;
update creature_proto set npcflags=130 where entry=20510;
update creature_proto set npcflags=18 where entry=20511;
update creature_proto set npcflags=8193 where entry=20515;
update creature_proto set npcflags=2 where entry=20518;
update creature_proto set npcflags=3 where entry=20551;
update creature_proto set npcflags=2 where entry=20552;
update creature_proto set npcflags=268435456 where entry=20556;
update creature_proto set npcflags=3 where entry=20563;
update creature_proto set npcflags=3 where entry=20604;
update creature_proto set npcflags=3 where entry=20612;
update creature_proto set npcflags=4224 where entry=20613;
update creature_proto set npcflags=4224 where entry=20616;
update creature_proto set npcflags=268435457 where entry=20674;
update creature_proto set npcflags=3 where entry=20677;
update creature_proto set npcflags=3 where entry=20678;
update creature_proto set npcflags=3 where entry=20679;
update creature_proto set npcflags=3 where entry=20722;
update creature_proto set npcflags=3 where entry=20724;
update creature_proto set npcflags=8193 where entry=20762;
update creature_proto set npcflags=2 where entry=20763;
update creature_proto set npcflags=3 where entry=20780;
update creature_proto set npcflags=17 where entry=20791;
update creature_proto set npcflags=2 where entry=20793;
update creature_proto set npcflags=128 where entry=20807;
update creature_proto set npcflags=128 where entry=20808;
update creature_proto set npcflags=3 where entry=20810;
update creature_proto set npcflags=2 where entry=20811;
update creature_proto set npcflags=2 where entry=20871;
update creature_proto set npcflags=4224 where entry=20890;
update creature_proto set npcflags=128 where entry=20891;
update creature_proto set npcflags=128 where entry=20892;
update creature_proto set npcflags=128 where entry=20893;
update creature_proto set npcflags=1 where entry=20903;
update creature_proto set npcflags=3 where entry=20907;
update creature_proto set npcflags=2 where entry=20913;
update creature_proto set npcflags=17 where entry=20914;
update creature_proto set npcflags=128 where entry=20915;
update creature_proto set npcflags=128 where entry=20916;
update creature_proto set npcflags=4224 where entry=20917;
update creature_proto set npcflags=3 where entry=20920;
update creature_proto set npcflags=2 where entry=20921;
update creature_proto set npcflags=128 where entry=20980;
update creature_proto set npcflags=128 where entry=20981;
update creature_proto set npcflags=1 where entry=20985;
update creature_proto set npcflags=128 where entry=20986;
update creature_proto set npcflags=128 where entry=20989;
update creature_proto set npcflags=3 where entry=21006;
update creature_proto set npcflags=3 where entry=21007;
update creature_proto set npcflags=128 where entry=21019;
update creature_proto set npcflags=3 where entry=21024;
update creature_proto set npcflags=2 where entry=21026;
update creature_proto set npcflags=2 where entry=21027;
update creature_proto set npcflags=2 where entry=21050;
update creature_proto set npcflags=2 where entry=21059;
update creature_proto set npcflags=2 where entry=21061;
update creature_proto set npcflags=3 where entry=21066;
update creature_proto set npcflags=2 where entry=21073;
update creature_proto set npcflags=128 where entry=21082;
update creature_proto set npcflags=128 where entry=21083;
update creature_proto set npcflags=128 where entry=21084;
update creature_proto set npcflags=128 where entry=21085;
update creature_proto set npcflags=4224 where entry=21086;
update creature_proto set npcflags=16 where entry=21087;
update creature_proto set npcflags=65539 where entry=21088;
update creature_proto set npcflags=2 where entry=21092;
update creature_proto set npcflags=2 where entry=21094;
update creature_proto set npcflags=2 where entry=21095;
update creature_proto set npcflags=2 where entry=21096;
update creature_proto set npcflags=2 where entry=21097;
update creature_proto set npcflags=2 where entry=21102;
update creature_proto set npcflags=8195 where entry=21107;
update creature_proto set npcflags=2 where entry=21108;
update creature_proto set npcflags=65667 where entry=21110;
update creature_proto set npcflags=128 where entry=21111;
update creature_proto set npcflags=4226 where entry=21112;
update creature_proto set npcflags=128 where entry=21113;
update creature_proto set npcflags=2 where entry=21116;
update creature_proto set npcflags=3 where entry=21117;
update creature_proto set npcflags=3 where entry=21118;
update creature_proto set npcflags=3 where entry=21133;
update creature_proto set npcflags=129 where entry=21145;
update creature_proto set npcflags=3 where entry=21147;
update creature_proto set npcflags=2 where entry=21151;
update creature_proto set npcflags=2 where entry=21155;
update creature_proto set npcflags=2 where entry=21156;
update creature_proto set npcflags=3 where entry=21158;
update creature_proto set npcflags=1 where entry=21160;
update creature_proto set npcflags=129 where entry=21172;
update creature_proto set npcflags=2 where entry=21175;
update creature_proto set npcflags=4226 where entry=21183;
update creature_proto set npcflags=2 where entry=21197;
update creature_proto set npcflags=4099 where entry=21209;
update creature_proto set npcflags=1048577 where entry=21235;
update creature_proto set npcflags=2 where entry=21256;
update creature_proto set npcflags=3 where entry=21257;
update creature_proto set npcflags=3 where entry=21277;
update creature_proto set npcflags=3 where entry=21279;
update creature_proto set npcflags=4099 where entry=21283;
update creature_proto set npcflags=2 where entry=21291;
update creature_proto set npcflags=3 where entry=21292;
update creature_proto set npcflags=3 where entry=21293;
update creature_proto set npcflags=3 where entry=21311;
update creature_proto set npcflags=3 where entry=21318;
update creature_proto set npcflags=2 where entry=21330;
update creature_proto set npcflags=4194304 where entry=21336;
update creature_proto set npcflags=3 where entry=21349;
update creature_proto set npcflags=3 where entry=21357;
update creature_proto set npcflags=3 where entry=21359;
update creature_proto set npcflags=1 where entry=21382;
update creature_proto set npcflags=1 where entry=21383;
update creature_proto set npcflags=3 where entry=21402;
update creature_proto set npcflags=2 where entry=21411;
update creature_proto set npcflags=128 where entry=21432;
update creature_proto set npcflags=3 where entry=21460;
update creature_proto set npcflags=1 where entry=21461;
update creature_proto set npcflags=3 where entry=21465;
update creature_proto set npcflags=3 where entry=21469;
update creature_proto set npcflags=3 where entry=21471;
update creature_proto set npcflags=2 where entry=21472;
update creature_proto set npcflags=128 where entry=21474;
update creature_proto set npcflags=3 where entry=21475;
update creature_proto set npcflags=128 where entry=21483;
update creature_proto set npcflags=128 where entry=21484;
update creature_proto set npcflags=4224 where entry=21485;
update creature_proto set npcflags=128 where entry=21487;
update creature_proto set npcflags=128 where entry=21488;
update creature_proto set npcflags=17 where entry=21493;
update creature_proto set npcflags=17 where entry=21494;
update creature_proto set npcflags=2 where entry=21496;
update creature_proto set npcflags=4194304 where entry=21517;
update creature_proto set npcflags=4194304 where entry=21518;
update creature_proto set npcflags=1 where entry=21637;
update creature_proto set npcflags=2 where entry=21638;
update creature_proto set npcflags=128 where entry=21643;
update creature_proto set npcflags=128 where entry=21655;
update creature_proto set npcflags=3 where entry=21657;
update creature_proto set npcflags=1 where entry=21664;
update creature_proto set npcflags=1 where entry=21682;
update creature_proto set npcflags=1 where entry=21683;
update creature_proto set npcflags=1 where entry=21684;
update creature_proto set npcflags=3 where entry=21690;
update creature_proto set npcflags=3 where entry=21691;
update creature_proto set npcflags=3 where entry=21700;
update creature_proto set npcflags=1 where entry=21726;
update creature_proto set npcflags=131073 where entry=21732;
update creature_proto set npcflags=131073 where entry=21733;
update creature_proto set npcflags=131073 where entry=21734;
update creature_proto set npcflags=65665 where entry=21744;
update creature_proto set npcflags=65665 where entry=21746;
update creature_proto set npcflags=1 where entry=21747;
update creature_proto set npcflags=1 where entry=21748;
update creature_proto set npcflags=1 where entry=21750;
update creature_proto set npcflags=1 where entry=21752;
update creature_proto set npcflags=3 where entry=21755;
update creature_proto set npcflags=8193 where entry=21766;
update creature_proto set npcflags=3 where entry=21769;
update creature_proto set npcflags=2 where entry=21770;
update creature_proto set npcflags=2 where entry=21771;
update creature_proto set npcflags=3 where entry=21772;
update creature_proto set npcflags=3 where entry=21773;
update creature_proto set npcflags=3 where entry=21774;
update creature_proto set npcflags=2 where entry=21775;
update creature_proto set npcflags=2 where entry=21777;
update creature_proto set npcflags=2 where entry=21782;
update creature_proto set npcflags=2 where entry=21789;
update creature_proto set npcflags=2 where entry=21790;
update creature_proto set npcflags=3 where entry=21797;
update creature_proto set npcflags=1 where entry=21810;
update creature_proto set npcflags=3 where entry=21822;
update creature_proto set npcflags=3 where entry=21824;
update creature_proto set npcflags=2 where entry=21826;
update creature_proto set npcflags=3 where entry=21860;
update creature_proto set npcflags=2 where entry=21895;
update creature_proto set npcflags=2 where entry=21896;
update creature_proto set npcflags=128 where entry=21905;
update creature_proto set npcflags=128 where entry=21906;
update creature_proto set npcflags=2 where entry=21937;
update creature_proto set npcflags=2 where entry=21938;
update creature_proto set npcflags=2 where entry=21950;
update creature_proto set npcflags=2 where entry=21953;
update creature_proto set npcflags=2 where entry=21954;
update creature_proto set npcflags=2 where entry=21955;
update creature_proto set npcflags=2 where entry=21962;
update creature_proto set npcflags=3 where entry=21970;
update creature_proto set npcflags=3 where entry=21971;
update creature_proto set npcflags=1 where entry=21981;
update creature_proto set npcflags=3 where entry=21983;
update creature_proto set npcflags=3 where entry=21984;
update creature_proto set npcflags=2 where entry=21998;
update creature_proto set npcflags=3 where entry=22004;
update creature_proto set npcflags=19 where entry=22005;
update creature_proto set npcflags=3 where entry=22007;
update creature_proto set npcflags=1 where entry=22013;
update creature_proto set npcflags=1 where entry=22019;
update creature_proto set npcflags=3 where entry=22020;
update creature_proto set npcflags=3 where entry=22024;
update creature_proto set npcflags=2 where entry=22042;
update creature_proto set npcflags=2 where entry=22043;
update creature_proto set npcflags=3 where entry=22053;
update creature_proto set npcflags=3 where entry=22059;
update creature_proto set npcflags=3 where entry=22073;
update creature_proto set npcflags=4225 where entry=22099;
update creature_proto set npcflags=3 where entry=22103;
update creature_proto set npcflags=3 where entry=22107;
update creature_proto set npcflags=3 where entry=22112;
update creature_proto set npcflags=2 where entry=22113;
update creature_proto set npcflags=2 where entry=22115;
update creature_proto set npcflags=3 where entry=22127;
update creature_proto set npcflags=2 where entry=22133;
update creature_proto set npcflags=3 where entry=22149;
update creature_proto set npcflags=2 where entry=22150;
update creature_proto set npcflags=131 where entry=22208;
update creature_proto set npcflags=3 where entry=22211;
update creature_proto set npcflags=131 where entry=22212;
update creature_proto set npcflags=131 where entry=22213;
update creature_proto set npcflags=3 where entry=22214;
update creature_proto set npcflags=3 where entry=22215;
update creature_proto set npcflags=8193 where entry=22216;
update creature_proto set npcflags=4224 where entry=22225;
update creature_proto set npcflags=4224 where entry=22227;
update creature_proto set npcflags=3 where entry=22231;
update creature_proto set npcflags=1 where entry=22234;
update creature_proto set npcflags=2 where entry=22272;
update creature_proto set npcflags=3 where entry=22278;
update creature_proto set npcflags=2 where entry=22292;
update creature_proto set npcflags=2 where entry=22293;
update creature_proto set npcflags=1 where entry=22308;
update creature_proto set npcflags=3 where entry=22312;
update creature_proto set npcflags=3 where entry=22364;
update creature_proto set npcflags=2 where entry=22365;
update creature_proto set npcflags=3 where entry=22370;
update creature_proto set npcflags=2 where entry=22373;
update creature_proto set npcflags=2 where entry=22377;
update creature_proto set npcflags=3 where entry=22386;
update creature_proto set npcflags=1 where entry=22396;
update creature_proto set npcflags=3 where entry=22420;
update creature_proto set npcflags=2 where entry=22421;
update creature_proto set npcflags=2 where entry=22423;
update creature_proto set npcflags=2 where entry=22424;
update creature_proto set npcflags=3 where entry=22427;
update creature_proto set npcflags=3 where entry=22429;
update creature_proto set npcflags=3 where entry=22430;
update creature_proto set npcflags=3 where entry=22431;
update creature_proto set npcflags=1 where entry=22432;
update creature_proto set npcflags=2 where entry=22433;
update creature_proto set npcflags=1 where entry=22442;
update creature_proto set npcflags=2 where entry=22446;
update creature_proto set npcflags=8193 where entry=22455;
update creature_proto set npcflags=2 where entry=22456;
update creature_proto set npcflags=2 where entry=22458;
update creature_proto set npcflags=2 where entry=22462;
update creature_proto set npcflags=4194304 where entry=22468;
update creature_proto set npcflags=4194304 where entry=22469;
update creature_proto set npcflags=4224 where entry=22476;
update creature_proto set npcflags=17 where entry=22477;
update creature_proto set npcflags=131 where entry=22479;
update creature_proto set npcflags=2 where entry=22481;
update creature_proto set npcflags=8193 where entry=22485;
update creature_proto set npcflags=2 where entry=22488;
update creature_proto set npcflags=2 where entry=22489;
update creature_proto set npcflags=4224 where entry=22491;
update creature_proto set npcflags=2 where entry=22497;
update creature_proto set npcflags=1048576 where entry=22656;
update creature_proto set npcflags=3 where entry=22819;
update creature_proto set npcflags=3 where entry=22832;
update creature_proto set npcflags=2 where entry=22893;
update creature_proto set npcflags=3 where entry=22899;
update creature_proto set npcflags=65537 where entry=22922;
update creature_proto set npcflags=2 where entry=22924;
update creature_proto set npcflags=3 where entry=22940;
update creature_proto set npcflags=3 where entry=23038;
update creature_proto set npcflags=2 where entry=23042;
update creature_proto set npcflags=3 where entry=23048;
update creature_proto set npcflags=1 where entry=23050;
update creature_proto set npcflags=1 where entry=23079;
update creature_proto set npcflags=51 where entry=23127;
update creature_proto set npcflags=640 where entry=23263;
update creature_proto set npcflags=2 where entry=23270;
update creature_proto set npcflags=2 where entry=23271;
update creature_proto set npcflags=2 where entry=23272;
update creature_proto set npcflags=2 where entry=23273;
update creature_proto set npcflags=3 where entry=23306;
update creature_proto set npcflags=129 where entry=23363;
update creature_proto set npcflags=128 where entry=23367;
update creature_proto set npcflags=4224 where entry=23381;
update creature_proto set npcflags=2 where entry=23383;
update creature_proto set npcflags=2 where entry=23291;
update creature_proto set npcflags=3 where entry=23415;
update creature_proto set npcflags=2 where entry=23433;
update creature_proto set npcflags=2 where entry=23434;
update creature_proto set npcflags=129 where entry=23437;
update creature_proto set npcflags=2 where entry=23443;
update creature_proto set npcflags=128 where entry=23446;
update creature_proto set npcflags=2 where entry=23449;
update creature_proto set npcflags=3 where entry=23461;
update creature_proto set npcflags=3 where entry=23462;
update creature_proto set npcflags=3 where entry=23463;
update creature_proto set npcflags=3 where entry=23464;
update creature_proto set npcflags=3 where entry=23465;
update creature_proto set npcflags=3 where entry=23466;
update creature_proto set npcflags=129 where entry=23483;
update creature_proto set npcflags=129 where entry=23484;
update creature_proto set npcflags=128 where entry=23489;
update creature_proto set npcflags=2 where entry=22834;
update creature_proto set npcflags=2 where entry=22837;
update creature_proto set npcflags=2 where entry=22932;
update creature_proto set npcflags=2 where entry=22981;
update creature_proto set npcflags=2 where entry=23338;
update creature_proto set npcflags=8193 where entry=22931;
update creature_proto set npcflags=3 where entry=15383;
update creature_proto set npcflags=3 where entry=15431;
update creature_proto set npcflags=3 where entry=15432;
update creature_proto set npcflags=3 where entry=15434;
update creature_proto set npcflags=3 where entry=15437;
update creature_proto set npcflags=3 where entry=15445;
update creature_proto set npcflags=3 where entry=15446;
update creature_proto set npcflags=3 where entry=15448;
update creature_proto set npcflags=3 where entry=15450;
update creature_proto set npcflags=3 where entry=15451;
update creature_proto set npcflags=3 where entry=15452;
update creature_proto set npcflags=3 where entry=15453;
update creature_proto set npcflags=3 where entry=15455;
update creature_proto set npcflags=3 where entry=15456;
update creature_proto set npcflags=3 where entry=15457;
update creature_proto set npcflags=1 where entry=15539;
update creature_proto set npcflags=3 where entry=15701;
update creature_proto set npcflags=3 where entry=15709;
update creature_proto set npcflags=3 where entry=15731;
update creature_proto set npcflags=3 where entry=15733;
update creature_proto set npcflags=3 where entry=15734;
update creature_proto set npcflags=3 where entry=15735;
update creature_proto set npcflags=3 where entry=18528;
update creature_proto set npcflags=8193 where entry=22935;
update creature_proto set npcflags=3 where entry=23268;
update creature_proto set npcflags=4225 where entry=23373;
update creature_proto set npcflags=129 where entry=23396;
update creature_proto set npcflags=2 where entry=23452;
update creature_proto set npcflags=2 where entry=23454;
update creature_proto set npcflags=19 where entry=23534;
update creature_proto set npcflags=131 where entry=23535;
update creature_proto set npcflags=129 where entry=23699;
update creature_proto set npcflags=131073 where entry=5060;
update creature_proto set npcflags=4194304 where entry=9896;
update creature_proto set npcflags=2 where entry=15459;
update creature_proto set npcflags=2 where entry=15460;
update creature_proto set npcflags=2 where entry=15469;
update creature_proto set npcflags=2 where entry=15512;
update creature_proto set npcflags=2 where entry=15522;
update creature_proto set npcflags=2 where entry=15525;
update creature_proto set npcflags=2 where entry=15529;
update creature_proto set npcflags=2 where entry=15532;
update creature_proto set npcflags=2 where entry=15533;
update creature_proto set npcflags=2 where entry=15534;
update creature_proto set npcflags=2 where entry=15535;
update creature_proto set npcflags=2 where entry=15693;
update creature_proto set npcflags=1 where entry=15694;
update creature_proto set npcflags=1 where entry=15719;
update creature_proto set npcflags=2 where entry=15797;
update creature_proto set npcflags=2 where entry=15798;
update creature_proto set npcflags=2 where entry=15799;
update creature_proto set npcflags=3 where entry=15864;
update creature_proto set npcflags=1 where entry=15905;
update creature_proto set npcflags=1 where entry=15906;
update creature_proto set npcflags=1 where entry=15907;
update creature_proto set npcflags=1 where entry=15908;
update creature_proto set npcflags=3 where entry=15909;
update creature_proto set npcflags=2 where entry=16001;
update creature_proto set npcflags=2 where entry=16002;
update creature_proto set npcflags=2 where entry=16003;
update creature_proto set npcflags=2 where entry=16004;
update creature_proto set npcflags=2 where entry=16005;
update creature_proto set npcflags=2 where entry=16007;
update creature_proto set npcflags=2 where entry=16008;
update creature_proto set npcflags=2 where entry=16009;
update creature_proto set npcflags=2 where entry=16105;
update creature_proto set npcflags=2 where entry=16106;
update creature_proto set npcflags=2 where entry=16107;
update creature_proto set npcflags=2 where entry=16108;
update creature_proto set npcflags=2 where entry=16109;
update creature_proto set npcflags=3 where entry=16212;
update creature_proto set npcflags=2 where entry=16281;
update creature_proto set npcflags=1 where entry=16284;
update creature_proto set npcflags=2 where entry=17081;
update creature_proto set npcflags=2 where entry=17082;
update creature_proto set npcflags=2 where entry=17288;
update creature_proto set npcflags=2 where entry=17294;
update creature_proto set npcflags=4194304 where entry=19325;
update creature_proto set npcflags=4225 where entry=22264;
update creature_proto set npcflags=128 where entry=22266;
update creature_proto set npcflags=128 where entry=22270;
update creature_proto set npcflags=128 where entry=22271;
update creature_proto set npcflags=4194304 where entry=22551;
update creature_proto set npcflags=4194304 where entry=22577;
update creature_proto set npcflags=3 where entry=22820;
update creature_proto set npcflags=2 where entry=22941;
update creature_proto set npcflags=2 where entry=22995;
update creature_proto set npcflags=4224 where entry=23007;
update creature_proto set npcflags=2 where entry=23053;
update creature_proto set npcflags=128 where entry=23110;
update creature_proto set npcflags=128 where entry=23112;
update creature_proto set npcflags=268435456 where entry=23115;
update creature_proto set npcflags=2 where entry=23120;
update creature_proto set npcflags=17 where entry=23128;
update creature_proto set npcflags=128 where entry=23208;
update creature_proto set npcflags=2 where entry=23233;
update creature_proto set npcflags=2 where entry=23253;
update creature_proto set npcflags=2 where entry=23300;
update creature_proto set npcflags=2 where entry=23316;
update creature_proto set npcflags=2 where entry=23334;
update creature_proto set npcflags=2 where entry=23335;
update creature_proto set npcflags=4096 where entry=23406;
update creature_proto set npcflags=1 where entry=23413;
update creature_proto set npcflags=130 where entry=23428;
update creature_proto set npcflags=2 where entry=23473;
update creature_proto set npcflags=128 where entry=23157;
update creature_proto set npcflags=128 where entry=23243;
update creature_proto set npcflags=128 where entry=23244;
update creature_proto set npcflags=128 where entry=23245;
update creature_proto set npcflags=128 where entry=23447;
update creature_proto set npcflags=2 where entry=23139;
update creature_proto set npcflags=2 where entry=23140;
update creature_proto set npcflags=2 where entry=23149;
update creature_proto set npcflags=129 where entry=23511;
update creature_proto set npcflags=129 where entry=23482;
update creature_proto set npcflags=129 where entry=23510;
update creature_proto set npcflags=128 where entry=23521;
update creature_proto set npcflags=3 where entry=23558;
update creature_proto set npcflags=2 where entry=23628;
update creature_proto set npcflags=2 where entry=23627;
update creature_proto set npcflags=131 where entry=23710;
update creature_proto set npcflags=3 where entry=24468;
update creature_proto set npcflags=3 where entry=24710;
update creature_proto set npcflags=128 where entry=23522;
update creature_proto set npcflags=128 where entry=23525;
update creature_proto set npcflags=3 where entry=23486;
update creature_proto set npcflags=128 where entry=23481;
update creature_proto set npcflags=1 where entry=23635;
update creature_proto set npcflags=3 where entry=24497;
update creature_proto set npcflags=131 where entry=24510;
update creature_proto set npcflags=128 where entry=23605;
update creature_proto set npcflags=128 where entry=23606;
update creature_proto set npcflags=3 where entry=24711;
update creature_proto set npcflags=129 where entry=24501;
update creature_proto set npcflags=2 where entry=24498;
update creature_proto set npcflags=3 where entry=24657;
update creature_proto set npcflags=131 where entry=24495;
update creature_proto set npcflags=2 where entry=24499;
update creature_proto set npcflags=128 where entry=23604;
update creature_proto set npcflags=128 where entry=23603;
update creature_proto set npcflags=129 where entry=23533;
update creature_proto set npcflags=3 where entry=24519;
update creature_proto set npcflags=3 where entry=23973;
update creature_proto set npcflags=1 where entry=23712;
update creature_proto set npcflags=18 where entry=23103;
update creature_proto set npcflags=1 where entry=23713;
update creature_proto set npcflags=1 where entry=23971;
update creature_proto set npcflags=129 where entry=23064;
update creature_proto set npcflags=131 where entry=23065;
update creature_proto set npcflags=3 where entry=23141;
update creature_proto set npcflags=2 where entry=23158;
update creature_proto set npcflags=2 where entry=23166;
update creature_proto set npcflags=2 where entry=23265;
update creature_proto set npcflags=2 where entry=23280;
update creature_proto set npcflags=2 where entry=23340;
update creature_proto set npcflags=2 where entry=23342;
update creature_proto set npcflags=2 where entry=23344;
update creature_proto set npcflags=2 where entry=23346;
update creature_proto set npcflags=2 where entry=23348;
update creature_proto set npcflags=2 where entry=23376;
update creature_proto set npcflags=2 where entry=23427;
update creature_proto set npcflags=2 where entry=23618;
update creature_proto set npcflags=2 where entry=23872;
update creature_proto set npcflags=1 where entry=23988;
update creature_proto set npcflags=268435456 where entry=24491;
update creature_proto set npcflags=8195 where entry=24366;
update creature_proto set npcflags=3 where entry=23559;
update creature_proto set npcflags=2176 where entry=23560;
update creature_proto set npcflags=2 where entry=23566;
update creature_proto set npcflags=3 where entry=23567;
update creature_proto set npcflags=3 where entry=23568;
update creature_proto set npcflags=3 where entry=23569;
update creature_proto set npcflags=2 where entry=23570;
update creature_proto set npcflags=4224 where entry=23571;
update creature_proto set npcflags=2 where entry=23572;
update creature_proto set npcflags=640 where entry=23573;
update creature_proto set npcflags=3 where entry=23579;
update creature_proto set npcflags=3 where entry=23600;
update creature_proto set npcflags=3 where entry=23601;
update creature_proto set npcflags=1 where entry=23602;
update creature_proto set npcflags=8193 where entry=23612;
update creature_proto set npcflags=1 where entry=23704;
update creature_proto set npcflags=1 where entry=23718;
update creature_proto set npcflags=3 where entry=23723;
update creature_proto set npcflags=4224 where entry=23724;
update creature_proto set npcflags=640 where entry=23748;
update creature_proto set npcflags=2 where entry=23761;
update creature_proto set npcflags=1 where entry=23790;
update creature_proto set npcflags=3 where entry=23797;
update creature_proto set npcflags=3 where entry=23835;
update creature_proto set npcflags=2 where entry=23843;
update creature_proto set npcflags=2 where entry=23858;
update creature_proto set npcflags=1 where entry=23861;
update creature_proto set npcflags=2 where entry=23892;
update creature_proto set npcflags=643 where entry=23896;
update creature_proto set npcflags=2 where entry=23897;
update creature_proto set npcflags=2 where entry=23905;
update creature_proto set npcflags=2 where entry=23942;
update creature_proto set npcflags=2 where entry=23948;
update creature_proto set npcflags=3 where entry=23949;
update creature_proto set npcflags=3 where entry=23950;
update creature_proto set npcflags=3 where entry=23951;
update creature_proto set npcflags=66177 where entry=23995;
update creature_proto set npcflags=66177 where entry=24208;
update creature_proto set npcflags=2 where entry=24393;
update creature_proto set npcflags=128 where entry=24520;
update creature_proto set npcflags=2 where entry=24727;
update creature_proto set npcflags=2 where entry=24729;
update creature_proto set npcflags=4225 where entry=24780;
update creature_proto set npcflags=640 where entry=24834;
update creature_proto set npcflags=1 where entry=24835;
update creature_proto set npcflags=1 where entry=24836;
update creature_proto set npcflags=1 where entry=24837;
update creature_proto set npcflags=1 where entry=24839;
update creature_proto set npcflags=1 where entry=24841;
update creature_proto set npcflags=1 where entry=24842;
update creature_proto set npcflags=8192 where entry=24851;
update creature_proto set npcflags=17 where entry=24868;
update creature_proto set npcflags=640 where entry=24934;
update creature_proto set npcflags=2176 where entry=24935;
update creature_proto set npcflags=1 where entry=25070;
update creature_proto set npcflags=1 where entry=25071;
update creature_proto set npcflags=1 where entry=25072;
update creature_proto set npcflags=1 where entry=25074;
update creature_proto set npcflags=1 where entry=25076;
update creature_proto set npcflags=1 where entry=25077;
update creature_proto set npcflags=1 where entry=25079;
update creature_proto set npcflags=1 where entry=25083;
update creature_proto set npcflags=17 where entry=25099;
update creature_proto set npcflags=1 where entry=25100;
update creature_proto set npcflags=1 where entry=25101;
update creature_proto set npcflags=1 where entry=25102;
update creature_proto set npcflags=1 where entry=25103;
update creature_proto set npcflags=1 where entry=25104;
update creature_proto set npcflags=1 where entry=25105;
update creature_proto set npcflags=1 where entry=25106;
update creature_proto set npcflags=1 where entry=25107;
update creature_proto set npcflags=129 where entry=25176;
update creature_proto set npcflags=129 where entry=25177;
update creature_proto set npcflags=129 where entry=25179;
update creature_proto set npcflags=4224 where entry=25196;
update creature_proto set npcflags=1 where entry=25200;
update creature_proto set npcflags=1 where entry=25202;
update creature_proto set npcflags=1 where entry=25207;

---

found this on ascentemu forum....

Quote:

---

Originally Posted by VizualG

These are just the trunk files to make a server with, i DONT include a character or world Database in the releases. just look at the sticky topic for a perfect guide to setup a server, only change is u use these files for the server...

if u mean the coin NPC the spawn id is: 55560

---

oh man! you're a life-saver! that took care of my vendors / quests, but what about the trainers? they still seem to be "gossip" only. they dont give you the "learn spell" screen :(....ive looked everywhere for a fix to all of these and you have taken care of 90% of the problem, thank you very much! but ya know :) if you could help me find the fix for the trainers, i would tell tales all over the net, of your awesome-ness :):)

oh man! you're a life-saver! that took care of about 90% of the problem. unfortunately, that didnt fix the trainers, you can still speak to them, but they still seem to be "gossip" only. they don't give you the "learn spell" screen.....i really appreciate your help thus far, but if you could help me find the fix for the trainers for the 4385 core, i would tell tales of your awesome-ness all over the net!......ive looked everywhere and have been using google all day, with no luck....i would've never even found THIS fix, if it weren't for you, so thank you again!

i almost got all the bugs out, i'll post it when done

How do i update this on Linux/FreeBS?