View Single Post
  #3  
Old 03-21-2005, 06:27 AM
Sensu-Bean
Sarnak
 
Join Date: Jul 2004
Posts: 36
Default re: knightz

ok, so what your saying is after i insert this line:

INSERT INTO tradeskill_recipe (name,tradeskill,skillneeded,trivial,nofail,
replace_container,notes) VALUES ('Filled Penance Bag,69,0,0,1,0);

the recipe_id is automatically adjusted to a certain number. my question is how can I find out what that number was set to. because where the 0000 is after VALUES in the post below is the same recipe_id that it was set to above. how can i find this number? still learning sql.

#8 bone fragments to be combined in container
INSERT INTO tradeskill_recipe_entries (recipe_id,item_id,successcount,failcount,
componentcount,iscontainer) VALUES (0000,24769,0,0,8,0);