SQL Query to copy items

[ccyre3]

I'm looking for a query to copy a source item (1377) to 3 other item numbers 90525, 90526, 90527. All fields plus adding a +1 +2 +3 to the 3 different 905 numbers. So same name +1 kinda thing. Then I can go in later and add stats by upping the % on em. Or maybe do that via query too.

Just has to be a fast way of doing this.

Thanks

[nilbog]

One approach for a single query would be to utilize a temporary table.

Use this at your own discretion and create a backup to ensure nothing bad happens. If you already have a table named temp_table, choose a new naming schema.

For one item at a time and a bit more manual control:

create temporary table temp_table 
as 
select * from items where id = '1377';
update temp_table set id = '90525' where id = '1377';
insert into items select * from temp_table;
drop temporary table temp_table;

-creates temp table
-inserts a new row in temp table of the specified item from items
-updates the id of the item in the temp table
-inserts the edited row into items table
-drops the temp table

[ccyre3]

Thank you I ended up using Nate's mass item creation tool. located on the discord for eq emu.

Now if only there was a way to copy recipes with changing variables heh ill get there

[ccyre3]

I could probably do the same for the recipes, its annoying though that they are 2 tables. tradeskill_recipie and tradeskill_recipie_entries not sure why they had to do that

I'm just using Georges for now :/

[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);

[ccyre3]

HAH got it!!

INSERT INTO `peq`.`tradeskill_recipe_entries` (`id`, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES
(322235, 31210, 17727, 0, 0, 0, 0, 1),
(322236, 31210, 17726, 0, 0, 1, 0, 0),
(322237, 31210, 4038, 0, 0, 1, 0, 0),
(322238, 31210, 147536, 1, 0, 1, 0, 0);


Just had to have a chat with gpt and eventually it caught on and did all remaining 80, thats 4 entries per 1 of those 80 haha