Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

Reply
 
Thread Tools Display Modes
  #1  
Old 08-07-2024, 01:49 AM
ccyre3
Fire Beetle
 
Join Date: Nov 2022
Posts: 20
Default SQL Query to copy items

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
Reply With Quote
  #2  
Old 08-07-2024, 12:00 PM
nilbog
Hill Giant
 
Join Date: Nov 2007
Posts: 198
Default

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:

Code:
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
__________________
https://www.project1999.com
Reply With Quote
  #3  
Old 08-07-2024, 02:11 PM
ccyre3
Fire Beetle
 
Join Date: Nov 2022
Posts: 20
Default

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
Reply With Quote
  #4  
Old 08-07-2024, 02:56 PM
ccyre3
Fire Beetle
 
Join Date: Nov 2022
Posts: 20
Default

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 :/
Reply With Quote
  #5  
Old 08-07-2024, 06:21 PM
ccyre3
Fire Beetle
 
Join Date: Nov 2022
Posts: 20
Default

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);
Reply With Quote
  #6  
Old 08-07-2024, 09:56 PM
ccyre3
Fire Beetle
 
Join Date: Nov 2022
Posts: 20
Default

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


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 05:18 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3