- Seller
- #761
I have changed the sub-recipe to the same recipe but with a different ID and different yield. Should be fixed - Next Release
Uses Velious Angel Fish
-
You've discovered RedGuides, an EverQuest multi-boxing and scripting community 🧙♀️⚙️. We want you to play several EQ characters at once, come join us and say hello! 👋
Resource icon
- Thread starter jb321
- Start date
Uses Velious Angel Fish
Kingfisher
Member
- Joined
- Jun 19, 2021
- RedCents
- 17¢
Thanks!
Kingfisher
Member
- Joined
- Jun 19, 2021
- RedCents
- 17¢
Question regarding Artisan Prize:
I have not started it yet (only made the prereq Earring of Soltice so far), but want to start it soon.
I'm sure many of my toons hold some items that might prove usefull in learning recipes.
How does the Request other chars for items work exactly? I clicked it but didnt see any response or errors for that matter.
Anyone can enlighten me?
Cheers!
I have not started it yet (only made the prereq Earring of Soltice so far), but want to start it soon.
I'm sure many of my toons hold some items that might prove usefull in learning recipes.
How does the Request other chars for items work exactly? I clicked it but didnt see any response or errors for that matter.
Anyone can enlighten me?
Cheers!
- Seller
- #764
You put your toons in the same zone as your toon with a local bank and when you get the farm list, click 'request' and it will query each toon for each item in the amount off the list. If the toon has it on them or in the bank it will get it and bring it to you.. DanNet needs to be enabled..
- Seller
- #765
Missing Artisan Lists have become a point of pain, cycling through 4000 research recipes and then waiting 8 hrs or longer for the results.
NO LONGER!
Stay Tuned!
For the TLDR's = Too Long Did Read
Everything was done in arrays, arrays are great but they are not meant for handling certain amounts and sizes of data with expediency. I have converted the de-duping, sorting, and counting to use SQL which takes hours down to seconds for farmed lists.
NO LONGER!
Stay Tuned!
For the TLDR's = Too Long Did Read
Everything was done in arrays, arrays are great but they are not meant for handling certain amounts and sizes of data with expediency. I have converted the de-duping, sorting, and counting to use SQL which takes hours down to seconds for farmed lists.
I began doing the GOD Pottery freebie quest in Abysmal using this Lua (looks awesome, by the way) and crashed after a few combines. Tried again, then unloaded the CWTN plugin and tried again. The latest crash log is attached. In the meantime I downloaded the macro version and the toon is grinding away with no problems 
- Seller
- #768
Open for all:
Trying to get the ItemID to show up in a query but everytime it tells me an unrelated column doesn't exist.. when I know it does. Any thoughts
Trying to get the ItemID to show up in a query but everytime it tells me an unrelated column doesn't exist.. when I know it does. Any thoughts
Code:
WITH RecipeDump (
ItemName,
ItemID,
SubRecipeID,
ItemCount
)
AS (
SELECT e.ItemName,
e.ItemID,
e.SubRecipeID,
e.ItemCount
FROM MasterCompTable e
WHERE e.RecipeID = 18031-- AND e.SubRecipeID > 0
UNION ALL
SELECT e.ItemName,
e.ItemID,
e.SubRecipeID,
e.ItemCount
FROM MasterCompTable e
JOIN
RecipeDump c ON c.SubRecipeID = e.RecipeID-- strips out children tool layers
WHERE c.SubRecipeID NOT IN (
SELECT ToolRecipeID
FROM ToolTable
)
)
SELECT ItemName, ItemID,
SubRecipeID,
ItemCount
FROM RecipeDump r-- strips out primary tool ID layer
JOIN
MasterRecipeTable f ON r.SubRecipeID = f.RecipeID
WHERE SubRecipeID = 0 AND
SubRecipeID NOT IN (
SELECT ToolRecipeID
FROM ToolTable
)/* leaves only primary tool recipe ID */;-- WHERE SubRecipeID >0 and SubRecipeID IN (Select ToolRecipeID FROM ToolTable)
- Seller
- #771
I began doing the GOD Pottery freebie quest in Abysmal using this lua (looks awesome, by the way) and crashed after a few combines. Tried again, then unloaded the CWTN plugin and tried again. The latest crash log is attached. In the meantime I downloaded the macro version and the toon is grinding away with no problems
To see what may be causing the crash, I would need screenshots, and details about what it was doing at that time, (As stated you said during combines). I can test this on another toon to see what might be happening. Whenever there are changes, especially the most recent of going 64 things may not work perfectly or exactly how they used to until some time has passed and there has been some time to massage the quirks out.I began doing the GOD Pottery freebie quest in Abysmal using this lua (looks awesome, by the way) and crashed after a few combines. Tried again, then unloaded the CWTN plugin and tried again. The latest crash log is attached. In the meantime I downloaded the macro version and the toon is grinding away with no problems
A lot of macros/luas work great but over time things happen and sometimes they need to be revisited.
I'll poke around.
so far the next toon is not having any problems. This is a great product! I will continue to test to see if I can gather some info. 4 toons to go...
ok I got set up and began taking screenshots as soon as the toon started combining at the kiln. Got exactly 1 screenshot before crashing :P. Toon1 (checked the logs) crashed on Wayfarer Plate. Toon2 (screenshot) crashed on Wayfarer Mug. They both are kiln recipes, not pottery wheel. Hope this helps. Obviously not high priority since there is a pretty nice workaround. Thanks again for the great work.
Attachments
- Seller
- #775
The conundrum is this: It uses the exact same crafting engine script as everything else (standard, artisan) , which is why it makes it difficult to track down. However, I will run it on a character and see what's what.
- Seller
- #780
jb321 updated Tradeskill Construction Set NeXt with a new update entry:
Luck be with you on this day...and speed!
Read the rest of this update entry...
Luck be with you on this day...and speed!
Read the rest of this update entry...
Was working great but now when I'm trying to craft recipes that I need under Artisan it just Banks shops, processes recipe and moves to the next one without actually moving to the crafting table. It states the vendor items are missing items but Auto-Shop is check marked.
- Seller
- #783
Investigating..
My guess is the format is messed, which, it should not be, but of course..
Standard Crafting is now shopping again, now for Max..
Fixed.. and releasing..
TLDR Section:
Feeder.Lua
Artisan:
was: r_max_array[0] = l_recipe_list[x]
now: r_max_array[1] = l_recipe_list[x]
The new shopping list creation starts at array index 1 based on table.insert() ..prior I was using a variable to count entries that started at 0
Standard:
was: shopping_list[0]
now: shopping_list[1]
The new shopping list creation returns array starting at index of 1 instead of 0, So.. update..
Last edited:
- Seller
- #785
jb321 updated Tradeskill Construction Set NeXt with a new update entry:
Added some more mass shop features, and fixed what I broke.
Read the rest of this update entry...
Added some more mass shop features, and fixed what I broke.
Read the rest of this update entry...
- Seller
- #787
When I was testing something else I REM'd out 1 line too many, this is causing it to ignore adding components to be grabbed from the bank. Until I get the fix out you can do this IN cruncher.Lua file
Version 2.51b
ensure this line does not have any "--" before it..
I want to add a couple of things before I release but this will get you through..
Version 2.51b
ensure this line does not have any "--" before it..
Code:
table.insert(final_banked_components, final_comp_string)I want to add a couple of things before I release but this will get you through..
Last edited:
- Seller
- #788
- Seller
- #790
This has a couple of key points, it grabs from the bank automatically any materials you have, and is able to generate a mass list for shopping and farming, and it will mass shop for you with a button click, additionally, it can request farmed materials from other toons you have in the zone that are carrying a bunch of tradeskill items that you just don't want to sort or transfer. It will query them and ask for all the materials, with a button click.
Will it do everything no, meaning, it won't try to go to zones like Shard's Landing or OT2 for some vials and stuff. Basically I try to avoid dangerous zones.
It will go to Thurgadin, West Freeport, Plane of Tranquility, Bazaar (Plate Molds), POK Vendors, Crescent Reach, Stratos, prolly forgot one or two.. but it travels to these zones for shopping and returns to POK.
It also has quite a few trophy quests to get you your tradeskill trophy with the only real requirement, having any farmed materials.
It has all the recipes to get you to 300 in each skill and there are many skill up paths, I have some suggestions in this thread, you would have to go back a few pages.
It also has freebies which will get all your Tradeskills (except for research) to 54. I have a free offering which will do GOD/TSS freebies and do the research as well. The original Tradeskill Construction Set
Trade / Skill - Tradeskill Construction Set |Quests:GOD,TSS,POK,POR Freebie Assister
2020 ESA Winner WARNING: Please test 3.73b and report issues. OVERVIEW TSC.mac levels your tradeskills fully automated to 50+ TSC.mac will do tradeskills quests in Abyssmal Sea to get your toon fully automated to 50+ Skill or to get recipes in...
www.redguides.com
Last edited:
Damn! Consider me sold. I will purchase as soon as I get paid.This has a couple of key points, it grabs from the bank automatically any materials you have, and is able to generate a mass list for shopping and farming, and it will mass shop for you with a button click, additionally, it can request farmed materials from other toons you have in the zone that are carrying a bunch of tradeskill items that you just don't want to sort or transfer. It will query them and ask for all the materials, with a button click.
View attachment 38821
Will it do everything no, meaning, it won't try to go to zones like Shard's Landing or OT2 for some vials and stuff. Basically I try to avoid dangerous zones.
It will go to Thurgadin, West Freeport, Plane of Tranquility, Bazaar (Plate Molds), POK Vendors, Crescent Reach, Stratos, prolly forgot one or two.. but it travels to these zones for shopping and returns to POK.
It also has quite a few trophy quests to get you your tradeskill trophy with the only real requirement, having any farmed materials.
It has all the recipes to get you to 300 in each skill and there are many skill up paths, I have some suggestions in this thread, you would have to go back a few pages.
It also has freebies which will get all your Tradeskills (except for research) to 54. I have a free offering which will do GOD/TSS freebies and do the research as well. The original Tradeskill Construction Set
Trade / Skill - Tradeskill Construction Set |Quests:GOD,TSS,POK,POR Freebie Assister
2020 ESA Winner WARNING: Please test 3.73b and report issues. OVERVIEW TSC.mac levels your tradeskills fully automated to 50+ TSC.mac will do tradeskills quests in Abyssmal Sea to get your toon fully automated to 50+ Skill or to get recipes in...
Thanks for providing this!
Shadow
Ultimate seasoned veteran member
- Joined
- Feb 15, 2022
- RedCents
- 1,877¢
Ok, so maybe this has been answered, I did a search, but came up without an answer. 1st, I love this script! Saved me so much time today as I leveled smithing only for a specific purpose but will go back and do all of them. LOVE IT! However...
1. Running a batch for Plate armor pieces. Conflag. Making a full set. I set batch adds for the set, quantity of one. I learned the hard way, to prebuy components in batches, otherwise it will buy 1 of every ingredient at a time. Not very efficient doing a combine, failing, and going back to the vendor for 1 more item, Rinse/repeat. Can we have a place to put buying quantity? Like 5 in case of fails.
2. This is the silly part. Really silly. Running batch. He finishes making a piece of armor. Runs to bank, puts smithing hammer, trophy, and my geerlock hammer in bank. Then he processes the next batch item, and RETRIEVES them from the bank that he just put them into. Why? Does this after every item completion. Can you make it so it does a check for those items on character, if so, skip to the next batch item. Or what about a toggle of that subroutine? "Mod Bank: On/Off". Then we can choose to keep the mods on person and skip the banking entirely. Especially for batch runs.
If I find anything else, I will let you know. Thanks again. Haven't really touched your Artisan prize script, but bought that too. I assume I use this to get all tradeskills to 300, then use that one for 300-350 and artisan?
1. Running a batch for Plate armor pieces. Conflag. Making a full set. I set batch adds for the set, quantity of one. I learned the hard way, to prebuy components in batches, otherwise it will buy 1 of every ingredient at a time. Not very efficient doing a combine, failing, and going back to the vendor for 1 more item, Rinse/repeat. Can we have a place to put buying quantity? Like 5 in case of fails.
2. This is the silly part. Really silly. Running batch. He finishes making a piece of armor. Runs to bank, puts smithing hammer, trophy, and my geerlock hammer in bank. Then he processes the next batch item, and RETRIEVES them from the bank that he just put them into. Why? Does this after every item completion. Can you make it so it does a check for those items on character, if so, skip to the next batch item. Or what about a toggle of that subroutine? "Mod Bank: On/Off". Then we can choose to keep the mods on person and skip the banking entirely. Especially for batch runs.
If I find anything else, I will let you know. Thanks again. Haven't really touched your Artisan prize script, but bought that too. I assume I use this to get all tradeskills to 300, then use that one for 300-350 and artisan?
- Seller
- #793
My intent from the beginning was to be efficient on the wallet and inventory space, and I figured, since it would auto-continue no one would grumble..
Over buying to account for failures, I am not quite there yet, I am trying to preserve variables, Lua allows a finite amount and I am a little under that. I want to ensure if I add something it is appropriate, works, and is worth it.
Upon closer inspection:
Bug: Not Mass buying bug was self inflicted. - fixed. (Remnant from switching to my new SQL shopping list generator).
Bug: The issue of making 1 item at a time has persisted for awhile, I had code to address this and I thought it worked, but that code led to nowhere - fixed.
Bug: It would try to mass grab trophies and tools, it would try to grab 7 baking trophies, and 23 Dairy spoons, which is no good upon the mass bank list, so that part is fixed, with the caveat, if you need 2 laminator rollers, which there are 4 recipes that use it (it will ask for 1), AFAIK every single tool requires 1, except those 4 silly recipes. This is known and is an action item. - mostly fixed.
Bug: Buying way too much based on the initial make count - fixed.
The routine has been changed to not deposit any bank items until the whole batch process has completed - Next Release.
Cloned the Standard crafting routine and massaged it into Batch crafting routine.
I didn't think batch would be > 350... well after , yes, for bazaar selling.
People buy this for reasons other than getting to 350, inconceivable!
Last edited:
- Seller
- #795
jb321 updated Tradeskill Construction Set NeXt with a new update entry:
All about that batch, bout that batch, and a crafting table fix.
Read the rest of this update entry...
All about that batch, bout that batch, and a crafting table fix.
Read the rest of this update entry...
- Seller
- #798
I have reached the limit of local variables. But doesn't mean it's over...
Is this for batch, standard, or artisan? Under what conditions?
I was going to mention this to you. It happened a few times to me and I think I got it pinpointed down to having multiple containers to combine in. I’m a dumbass and bought 10 deluxe toolboxes and used them as bags.
Retested it with a few Jewelry kits and it did recreate it.
I was just thinking for in general. Batch or crafting just one item. When in POK it looks very "botty" running back and forth from the bank to the research table. Say Im making a ring. I dont want to run back to the bank if I mess up. I just want to keep going at a station.