I got sick of bashing my head against the wall because of my sql ignorance.
I exported the list of
Code:
SELECT
a.name as 'Recipe Name',
b.item_id as 'Items Table ID'
FROM
tradeskill_recipe as a,
tradeskill_recipe_entries as b
WHERE
a.id = b.recipe_id AND
a.tradeskill = 59
to CSV, imported it into excel and exported it as tab delimited, then used GeorgeS' merchant tool to paste in the list that way. Very clumsy, but it seemed to work. I think i'm stuffing up the
Code:
INSERT INTO merchantlist (merchantid, slot, item)
(SELECT 'MERCHANTID', slot, itemid FROM merchantlist_tskills);
section. I'll try booting up and if it worked i'll post, otherwise time to call it a night.