PDA

View Full Version : Adding Tradeskill Recipes


Xothin
10-23-2004, 01:21 PM
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)

Cutter
10-23-2004, 02:35 PM
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

Xothin
10-23-2004, 02:37 PM
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?

Sarepean
10-31-2004, 03:49 PM
I seem to be having the same problem as you.

-Sarepean

Sarepean
10-31-2004, 04:16 PM
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

fathernitwit
11-01-2004, 02:46 AM
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

Sarepean
11-01-2004, 06:29 AM
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