recipies that use item ID < 1000

[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?

[GeorgeS]

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

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?

[sdabbs65]

Originally Posted by GeorgeS

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

your right.

13 - Unknown combine type (Maybe for Augments?)
17 - Forge
19 - Brew Barrel
21 &amp; 22 - Kiln &amp; Pottery Wheel, not sure which is which
23 - Unimplemented Tradeskill
24 - Wiz only combine container (Research container?)
25 - Mage only
26 - Necro only
27 - Ench Only
28 - Unimplemented Tradeskill
29 - Unimplemented Tradeskill
31 - High Elves Forge
32 - Dark Elves Forge
33 - Ogre Forge
34 - Dwarve Forge
35 - Gnome Forge
36 - Barbarian Forge
37 - Unimplemented Tradeskill
38 - Iksar Forge
39 - Human Forge
40 - Human Forge (but why 2?)
41 - Halfling Tailoring kit
42 - Erudite Tailor
43 - Wood Elf Tailor
44 - Wood Elf Fletching kit
45 - Iksar Pottery Wheel
47 - Troll Forge
48 - Wood Elf Forge
49 - Halfling Forge
50 - Erudite Forge