New version of my DB addon - 1.1 beta
 

http://www.edwardpinniger.bctalk.net...ata1.1beta.zip

I've finally got a 0.4.1-compatible DB addon ready for release.
This is a BETA version as the merchant and loot tables are still incomplete
and many NPC merchants don't have the right tables assigned. However the NPCs
data and placement should all be OK.
New features in this version include new merchant and loot tables (using the new item DB),
more NPCs/mobs and Z fixes, guildmasters, and the "bodytype" value for undead and other special
NPC types flagged.
I'll be releasing other, more complete betas and eventually the final 1.1 over the next
few weeks, also within a week I'll release the first version (0.1) of my "quest pack" which
will include quests/dialogue for guildmasters and some NPCs in Qeynos, Kelethin and Rivervale.

Drawde,
Might want to make the inserts in the form of insert into npc_types (id,name,level,race,etc) values (xxxxx).

The database format keeps changing, if you dont specify the fields you are passing, most likely one change will make the update not work properly..

Just a heads up, npc_types is getting resists, so that will kill the inserts as they are now..

Thanks for the world update !

Heres a quick update for the next db.sql though, just puts blanks for the last 5 columns (those will be the FR,CR,PR,etc fields)

Thanks for the info on the resists addition in 4.2, I'll add that to the EQNPC converter ASAP.