-
[Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
Release
Ascent:
- 4.4Trunk
- rev 4385 (Patch 2.4.x)
- Enabled Collision
Moon++:
LUA++:
Extra's
NonBlizzlikeScripts:
- buff, coin, heal, morph, mounter, stripper, warp NPC
Added to Warp NPC:
- Quel'Danas
- Magister's Terrace
- Sunwell Plateau
Darkmoon Faire:
Patch 2.4 content SQL:
- posted on ascentemu forum by Plexor, gives credits in post to Burlex
- Shattrah 100% GO's & NPC's
- Sunwell 50%
- Magisters Terrace 90% (missing 2 groups of trash only)
- Quel Danas 100% spawns , but it is very very messy, needs major cleanup
File link
Ascent4385.zip - 5.8 Mb
Credits
All Credits go out to the respected creators and dev teams of the mentioned and compiled Projects.
.net framework 3.5 needed, i compile with vs2008
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
Hi, and Thanx for this release :)
It works good, connects to DB etc, no errores, no warnings, and ev'rything Ok.
Just one question: which client can connect with this server?
My client is 2.3.2 (7741) enGB, and get stuck just after login, at "Handshaking".
Everything (DB, server & client) are on the same machine: 127.0.0.1
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
All Ascent releases 43xx and higher are for 2.4
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
Yeah srry forgot to mention that... its 2.4.x compatible
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
VizualG, ev'rithing worked good :)
Thankz for your good work! ;)
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
no problem m8,
if youre looking for some more/other stuff to use, post it on the forum and i'll see what i can do for u....
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
Great Work!But I dont know how to use lua++files,shall I extract them into scripts folder?
And the SQL files,need I to fill into my DB?
THX!!!
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
VizualG can you remove the .net needing? Because I want to run server on unix.
That would be great :)
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
Good release once again, and good to see you included the stuff i suggested in your last thread :)
Quote:
Originally Posted by
nzn-muonline
VizualG can you remove the .net needing? Because I want to run server on unix.
That would be great :)
Sorry but i lol'ed :D
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
LOL, nope srry....
this is a release compiled for windows...
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
I'm planning on making a new post in the forum with daily updates from this release.
the post will contain this release with the latest rev's, and also gonna add more stuff as we go and keep updating the extra's if they release new rev's.
Let me know if anyone wants/needs this, if not i'm not gonna daily update this...
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
Daily updates are always nice. :-)
DO you have one for 4394 ?
EDIT; Typo
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
All tru ascent is nice but with the only db group going underground ascent is doomed realy. Maybee its an good idea to make an new db group for it and continueing where ncdb left us.
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
There are already 8 DB projects running now and Burlex has also started entertaining UDB development as another possible venue
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
When Ascent realy gone suport UDB it will look like mangos becose udb already stated they wont change for ascent ascent need o change to suport it.Besides that did you see any new comits in the udb trunk after it was added ? indd none what so ever meaning that it is not compatble with latest udb.
Besides that is it realy gone suport udb any mangos db will be god as well :D
As i said Ascent is an good project as well no bad things bout it but lets be honnest if ascent gone change so it can be compatble with mangos db in my opinion than is that it is bether to run mangos where the db origianaly is designed for :D
Yes i used ascent and yes i was happy with it as well but im honestly think it can do bether when they work together with an db team and update that team with ther plans and so on. Like mangos,udb,ScripDev2 and acid are doing right now it can be supurb but till then and till burlex realy grows up it wont top or equal mangos in any way.
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
Yes, new daily updates will be nice ;)
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
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.
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
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) )
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
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:
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
thanks for the compiles VisualG! Appreciate it alot!
do u have the fix for first aid profession?
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
Thx for release just I have a problem with an coin item that would be your ID??
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
How do i install this do i need any other db or is everythign included ? :/
Cant figure out how to install it lol
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
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
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
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.....
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
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....
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
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 :):)
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
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!
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
i almost got all the bugs out, i'll post it when done
-
Re: [Release] Ascent 4.4Trunk rev4385, Moon++ rev349, LUA++ rev172 -- + extra's
How do i update this on Linux/FreeBS?