SQL Query to copy items

[ccyre3]

Well here is the query for the tradeskill_recipe table just know where your next id is and item names and then tell ole gpt to do it up for you by adding your +1 +2 +3 etc to the list of names you give it.

Now the tradeskill_recipe_entries table. Issue is there is that you have a line item per item involved in the combine, including the resulting item and container used. May be better off using George here and copy/paste recipes and changing the values manually


INSERT INTO `peq`.`tradeskill_recipe` (`id`, `name`, `tradeskill`, `nofail`, `notes`, `min_expansion`, `max_expansion`) VALUES
(31199, 'Shadowsbane Chain Coif +1', 75, 1, 'notes', -1, -1),
(31200, 'Shadowsbane Chain Coif +2', 75, 1, 'notes', -1, -1),
(31201, 'Shadowsbane Chain Coif +3', 75, 1, 'notes', -1, -1),
(31202, 'Shadowsbane Chain Sleeves +1', 75, 1, 'notes', -1, -1),
(31203, 'Shadowsbane Chain Sleeves +2', 75, 1, 'notes', -1, -1),
(31204, 'Shadowsbane Chain Sleeves +3', 75, 1, 'notes', -1, -1),
(31205, 'Shadowsbane Chain Leggings +1', 75, 1, 'notes', -1, -1),
(31206, 'Shadowsbane Chain Leggings +2', 75, 1, 'notes', -1, -1),
(31207, 'Shadowsbane Chain Leggings +3', 75, 1, 'notes', -1, -1),
(31208, 'Shadowsbane Chain Tunic +1', 75, 1, 'notes', -1, -1),
(31209, 'Shadowsbane Chain Tunic +2', 75, 1, 'notes', -1, -1),
(31210, 'Shadowsbane Chain Tunic +3', 75, 1, 'notes', -1, -1),
(31211, 'Shadowsbane Leather Bracer +1', 75, 1, 'notes', -1, -1),
(31212, 'Shadowsbane Leather Bracer +2', 75, 1, 'notes', -1, -1),
(31213, 'Shadowsbane Leather Bracer +3', 75, 1, 'notes', -1, -1),
(31214, 'Shadowsbane Leather Gloves +1', 75, 1, 'notes', -1, -1),
(31215, 'Shadowsbane Leather Gloves +2', 75, 1, 'notes', -1, -1),
(31216, 'Shadowsbane Leather Gloves +3', 75, 1, 'notes', -1, -1),
(31217, 'Shadowsbane Leather Cap +1', 75, 1, 'notes', -1, -1),
(31218, 'Shadowsbane Leather Cap +2', 75, 1, 'notes', -1, -1),
(31219, 'Shadowsbane Leather Cap +3', 75, 1, 'notes', -1, -1),
(31220, 'Shadowsbane Leather Sleeves +1', 75, 1, 'notes', -1, -1),
(31221, 'Shadowsbane Leather Sleeves +2', 75, 1, 'notes', -1, -1),
(31222, 'Shadowsbane Leather Sleeves +3', 75, 1, 'notes', -1, -1),
(31223, 'Shadowsbane Leather Trousers +1', 75, 1, 'notes', -1, -1),
(31224, 'Shadowsbane Leather Trousers +2', 75, 1, 'notes', -1, -1),
(31225, 'Shadowsbane Leather Trousers +3', 75, 1, 'notes', -1, -1),
(31226, 'Shadowsbane Leather Tunic +1', 75, 1, 'notes', -1, -1),
(31227, 'Shadowsbane Leather Tunic +2', 75, 1, 'notes', -1, -1),
(31228, 'Shadowsbane Leather Tunic +3', 75, 1, 'notes', -1, -1),
(31229, 'Shadowsbane Leather Boots +1', 75, 1, 'notes', -1, -1),
(31230, 'Shadowsbane Leather Boots +2', 75, 1, 'notes', -1, -1),
(31231, 'Shadowsbane Leather Boots +3', 75, 1, 'notes', -1, -1),
(31232, 'Shadowsbane Cloth Wristwrap +1', 75, 1, 'notes', -1, -1),
(31233, 'Shadowsbane Cloth Wristwrap +2', 75, 1, 'notes', -1, -1),
(31234, 'Shadowsbane Cloth Wristwrap +3', 75, 1, 'notes', -1, -1),
(31235, 'Shadowsbane Cloth Gloves +1', 75, 1, 'notes', -1, -1),
(31236, 'Shadowsbane Cloth Gloves +2', 75, 1, 'notes', -1, -1),
(31237, 'Shadowsbane Cloth Gloves +3', 75, 1, 'notes', -1, -1),
(31238, 'Shadowsbane Cloth Sandals +1', 75, 1, 'notes', -1, -1),
(31239, 'Shadowsbane Cloth Sandals +2', 75, 1, 'notes', -1, -1),
(31240, 'Shadowsbane Cloth Sandals +3', 75, 1, 'notes', -1, -1),
(31241, 'Shadowsbane Cloth Cap +1', 75, 1, 'notes', -1, -1),
(31242, 'Shadowsbane Cloth Cap +2', 75, 1, 'notes', -1, -1),
(31243, 'Shadowsbane Cloth Cap +3', 75, 1, 'notes', -1, -1),
(31244, 'Shadowsbane Cloth Sleeves +1', 75, 1, 'notes', -1, -1),
(31245, 'Shadowsbane Cloth Sleeves +2', 75, 1, 'notes', -1, -1),
(31246, 'Shadowsbane Cloth Sleeves +3', 75, 1, 'notes', -1, -1),
(31247, 'Shadowsbane Cloth Pantaloons +1', 75, 1, 'notes', -1, -1),
(31248, 'Shadowsbane Cloth Pantaloons +2', 75, 1, 'notes', -1, -1),
(31249, 'Shadowsbane Cloth Pantaloons +3', 75, 1, 'notes', -1, -1),
(31250, 'Shadowsbane Cloth Robe +1', 75, 1, 'notes', -1, -1),
(31251, 'Shadowsbane Cloth Robe +2', 75, 1, 'notes', -1, -1),
(31252, 'Shadowsbane Cloth Robe +3', 75, 1, 'notes', -1, -1),
(31253, 'Shadowsbane Guiding Light +1', 75, 1, 'notes', -1, -1),
(31254, 'Shadowsbane Guiding Light +2', 75, 1, 'notes', -1, -1),
(31255, 'Shadowsbane Guiding Light +3', 75, 1, 'notes', -1, -1),
(31256, 'Shadowsbane Hope +1', 75, 1, 'notes', -1, -1),
(31257, 'Shadowsbane Hope +2', 75, 1, 'notes', -1, -1),
(31258, 'Shadowsbane Hope +3', 75, 1, 'notes', -1, -1),
(31259, 'Shadowsbane Sentinel +1', 75, 1, 'notes', -1, -1),
(31260, 'Shadowsbane Sentinel +2', 75, 1, 'notes', -1, -1),
(31261, 'Shadowsbane Sentinel +3', 75, 1, 'notes', -1, -1);