Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::Packetcollector

Archive::Packetcollector Archive area for Packetcollector's posts that were moved here after an inactivity period of 90 days.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 01-02-2004, 05:17 AM
krich
Hill Giant
 
Join Date: May 2003
Location: The Great Northwest
Posts: 150
Default

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
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 05:38 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3