View Single Post
  #2  
Old 11-12-2006, 06:08 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Yes, that's correct
GeorgeS

The SQL for items which are containers
SELECT DISTINCT(tradeskill_recipe_entries.item_id),items. name FROM tradeskill_recipe_entries,items WHERE items.id=tradeskill_recipe_entries.item_id AND tradeskill_recipe_entries.iscontainer=1
ORDER BY item_id



Quote:
Originally Posted by Rhodan
We've noticed that there are large numbers of tradeskill recipies that reference item IDs below 1000 and that these IDs don't exist in the database.

Are we right in assuming that these are things like looms and forges that are hard-coded into EQEmu?
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//

Last edited by GeorgeS; 11-12-2006 at 02:22 PM..
Reply With Quote