Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 11-15-2010, 06:23 PM
MurphTheNerph
Fire Beetle
 
Join Date: Oct 2010
Location: Atlanta
Posts: 1
Default tradeskill_recipe_entries has bad? item_ids?

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.
Reply With Quote
  #2  
Old 11-15-2010, 10:27 PM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,497
Default

There are several world containers that are in that range.

16 is a loom
Reply With Quote
  #3  
Old 11-16-2010, 12:42 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

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.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #4  
Old 11-16-2010, 02:13 AM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,497
Default

Just a shameless plug: PEQ's PHP Editor also works great as an all-in-one tool.
Reply With Quote
Reply


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 12:40 PM.


 

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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3