View Single Post
  #7  
Old 05-29-2008, 11:18 AM
eski2
Hill Giant
 
Join Date: May 2008
Location: sydney
Posts: 177
Default

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.
Reply With Quote