PDA

View Full Version : tradeskill_recipe_entries has bad? item_ids?


MurphTheNerph
11-15-2010, 06:23 PM
I just started messing with my own server, d/l'd peqdb_rev1667, and started a vah bst, tried to do the first bst quest - combine stuff in the Stitching Pack - and got the "you can't combine those in that container!" error message.

I started poking around and found that in tradeskill_recipe_entries, what should have been the item_id for the Stitching Pack (17237) was a 16.
I thought this kinda weird as the lowest item id I saw in items was 1001.
With some trepidation :) I changed it to 17237, and lo and behold the combine worked.

I then selected for item_id < 1001 in tradeskill_recipe_entries and found a ton (well, 6719) of them.

I tried a few forum searches and didn't stumble over anything relevant..
Can someone tell me if this is intentional (and how its supposed to work like that?) or did I clobber my db with a bad update, or what.. Thanks.

joligario
11-15-2010, 10:27 PM
There are several world containers that are in that range.

16 is a loom

trevius
11-16-2010, 12:42 AM
If you need to add a new combine container type for your recipe, then just add it as an extra line. Don't remove or change existing container types for those recipies. Some recipes can combine in special containers, but almost all of them can combine in the normal world version of the containers such as looms, brew barrels, kilns, etc.

Recipes are fairly easy to edit if you use GeorgeS' tool for them. At least it makes it easier to get the hang of it I think.

joligario
11-16-2010, 02:13 AM
Just a shameless plug: PEQ's PHP Editor also works great as an all-in-one tool.