EQEmulator Forums - A guide to modifying a non tradeskill combine...

This is an example that I recently used to write part of the Greenmist quest. These values get inserted directly into the database, and we'll follow right along with them.

Code:

INSERT INTO tradeskill_recipe VALUES(9712,'Greenmist Khukri Blade',75,0,0,1,0,'Greenmist Quest #8');

The first query you'll have to run will add the tradeskill combine's general information to the tradeskill_recipe table.

In the example above, the first number is just the next sequential number in the database.
The second entry is the name of the combine.
The third signifies the tradeskill, which in this case (75) means that it is a quest combine.
The next two entries show what skill is needed and which skill rank it would trivial at (0 in both cases, as it's a quest combine).
The '1' signifies that the combine is no fail, and the following '0' shows that it does not replace the container (which you will want it to do in your case).
The last entry is just a note to help everyone understand what the combine is, or who submitted it.

The second bit of code goes into the tradeskill_recipe_entries table.

Code:

INSERT INTO tradeskill_recipe_entries VALUES(124067,9712,3894,1,0,0,0);

INSERT INTO tradeskill_recipe_entries VALUES(124068,9712,3886,0,0,1,0);

INSERT INTO tradeskill_recipe_entries VALUES(124069,9712,3890,0,0,1,0);

INSERT INTO tradeskill_recipe_entries VALUES(124070,9712,3891,0,0,1,0);

INSERT INTO tradeskill_recipe_entries VALUES(124071,9712,18320,0,0,1,0);

INSERT INTO tradeskill_recipe_entries VALUES(124072,9712,3891,1,0,0,0);

INSERT INTO tradeskill_recipe_entries VALUES(124073,9712,18320,1,0,0,0);

INSERT INTO tradeskill_recipe_entries VALUES(124074,9712,30,0,0,0,1);

Again, the first entry is the next sequential set of numbers in the database to show that they are the most recently added for this table.
The second number comes from the entry we put in the tradeskill_recipe table. Make sure the number matches for all of the entries that correspond to the same recipe.
The third number is the item number of each entry.
Successcount -- How many of this item are returned on a successful combine.
Failcount -- How many are returned on a failure.
Componentcount -- How many must be in the tradeskill container to do the combine.
Iscontainer -- Signifies that this is the container that the combine is intended to be done in.

All that said, these would be the entries that you would need to add to your database. Please note the variables, which I will explain afterwards.

Code:

INSERT INTO tradeskill_recipe VALUES(XXXX,'Bag of Ice Necklaces',75,0,0,1,1,'Ice Goblin Beads Quest');



INSERT INTO tradeskill_recipe_entries VALUES(YYYYYY,XXXX,13898,1,0,0,0);

INSERT INTO tradeskill_recipe_entries VALUES(YYYYYY,XXXX,13897,0,0,6,0);

INSERT INTO tradeskill_recipe_entries VALUES(YYYYYY,XXXX,17944,0,0,0,1);

This would give you what you want, you just have to make sure that the XXXXs correspond to the next available spot in your tradeskill_recipe table. Then, plug that number into the next three queries. Be sure that the YYYYYYs correspond to the next three entries available in your tradeskill_recipe_entries table. And you're done :)

Hope this little tutorial has helped!