SQL Query to copy items

[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 :/