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 10-23-2004, 01:21 PM
Xothin
Sarnak
 
Join Date: Oct 2004
Posts: 68
Default Adding Tradeskill Recipes

I've been trying for a while now to add the recipes for the newbie gear quests, and cannot seem to get the container to allow combines.

I've added the recipe, and the recipe_entries, is there something that I am missing?

EDIT: Bit more info

values for Tradeskill_Recipes (6782, "leafrunners boots material", 61, 0, 15, 1, 0, "")

values for Tradeskill_recipe_entries(6782, 27551, 1, 0, 0, 0), (6782, 10299, 0, 0, 1, 0), (6782, 13006, 0, 0, 1, 0), (6782, 9914, 0, 0, 3, 0), (6782, 17366, 0, 0, 0, 1)
Reply With Quote
  #2  
Old 10-23-2004, 02:35 PM
Cutter
Sarnak
 
Join Date: Sep 2004
Posts: 85
Default

This is done much easier in front mysql.. but ill try to help you

if you look.. theres a few things you need ..

1 the finished item...
the single items to make the item
then the containers to combine them in..

in the other table..
you need to give the chance of making the item
and min to make it
and the trival part..

If it was my best guess you just got the fields mixed up...

again something like this is better to do in front mysql
Reply With Quote
  #3  
Old 10-23-2004, 02:37 PM
Xothin
Sarnak
 
Join Date: Oct 2004
Posts: 68
Default

My setup is fine because-

Was able to change the container type to combine in to 17966(deluxe sewing kit) and it combined fine.

Is there maybe an issue with quest container combines?
Reply With Quote
  #4  
Old 10-31-2004, 03:49 PM
Sarepean
Discordant
 
Join Date: Sep 2004
Posts: 253
Default

I seem to be having the same problem as you.

-Sarepean
Reply With Quote
  #5  
Old 10-31-2004, 04:16 PM
Sarepean
Discordant
 
Join Date: Sep 2004
Posts: 253
Default

I have found a possible fix.

Change the bag type of the container that you're using to "20" instead of whatever it is (I'm assuming 30). Change the tradeskill in the "tradeskill_recipe" to 68.

Now, you've just set the container up as a Jewelry container and the recipe as a Jewelry Crafting tradeskill. When you hit combine inside the quest container, it'll combine. I've got the skill set to 0, trivial at 0, and a nofail flag on. On my end, this worked well.

Let me know if it works for you.

(I used MySQL Front. Easiest way to do it.)

-Sarepean
Reply With Quote
  #6  
Old 11-01-2004, 02:46 AM
fathernitwit
Developer
 
Join Date: Jul 2004
Posts: 773
Default

FYI that container is type 30, thats pottery (see tradeskill.cpp)... so tradeskill to make it work WITHOUT editing items (WHICH IS BAD, mmkay) is 69
Reply With Quote
  #7  
Old 11-01-2004, 06:29 AM
Sarepean
Discordant
 
Join Date: Sep 2004
Posts: 253
Default

Ah! Thank you! That will help a lot since that's what every quest container type is! =P

I'll go back through and make the changes back to the way things were tonight. Thank you for bringing that to my attention. =)

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