Tbigg,
I don't think that is possible. The problem is that we don't have the Names of the items we are missing. One could assume that if there is a gap in the ItemID, that we are missing something, but we just don't know what it is. One way to determine what we need is to ask around to find out what places have not yet been PC'd. Presumably there are some items there. Also, pay attention to the detail. People tend to hang out in the Bazaar or ask high level guys to link their gear, but I managed to update a few items in the items db simply by starting a Halfling Ranger in Rivervale. His starting items had not yet been PC'd.
Now, having said all that, I do actually have a list of items that are missing from the db that I need to complete the tradeskill database. Some of these items are intermediate steps in a complex tradeskill recipes and are not generally seen in the wild (or linked for that matter). If you want to start working on those, find me on the #npcmovdb IRC channel.
Also, now that I think about it, any item that has not been updated since around mid-October 2003 would need to be updated. So, using the following statement would get you that list as well:
select id, name from items where datediff(updated, cur_date()) < 90;
or something like that. I'm not all that great with SQL, but you get the idea.
Regards,
krich
|