• 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! 👋

  • A TLP without truebox has thawed (Very Vanilla ready)
    Frostreaver
Resource icon

Release Tradeskill Construction Set NeXt 4.1991b

Overview Commands Instructions F.A.Q. Updates (253) Reviews (34) History Discussion Terms and conditions
This one works :(
1658180686249.png


Ok I'm stumped.. this just did an earring which is not a pendant but uses the same method...

1658180652479.png

Is there any context around this? Perks? New Install?
 
Last edited:
Not sure, I just made all my scale ore into Palladium Bars and basically bypassed it. Didn't change anything on my system besides get your more recent update.
 
Yea, I skipped the Palladium stuff as I wasn't going to be arsed to do another tradeskill quest after just completing my Artisan's Prize chain.
 
jb321 said:
What? I even got the Coffin Poison Bottle and Rogue Sketches.. !!!!!!!!!
Click to expand...
I need like a week break. I did it all in 1 shot, including the PoP flagging and Quintessence farming/finishing. I was offering 100k+ for a Quintessence port to pick up the damn ground spawn there for the Warez achievement, no takers. So did it myself.
 
Szazor said:
Now - just in case you are running out of things to enhance your already great product....have you though about doing a Search function based on an ingredient.

ie Lets say I am walking around Innothule Swamp and I kill a mob. It drops a Bulb Lotus
View attachment 40893

It would be extremely cool if tcg could do a search and tell me what recipes this ingredient is in.....and if I need it for my Artisan's Prize.
Click to expand...
Not vehemently opposed, just vehemently opposed to user typing in TCG. When you create the list using Artisan it provides a .csv for every farmed item. If a person has a single monitor, I can see usage there.

The Boring TLDR details:

Identify all components DISTINCTLY that are not sub-recipes and not vendored. What is left is the list of ID's and Item Names that are all farmable components. Possibly add in a by letter drop-down which would provide # amount of components to scroll through or provide a text box to type in (partial, full matches), or both.

Here is one way to not do it..

SELECT Distinct * FROM MasterCompTable WHERE ItemID NOT IN (Select ItemID FROM VendorTable) AND SubRecipeID = 0 Group by ItemID
 
Last edited:
Forgot to mention it from last update, when you load the artisan recipes it will display a list of known and unknown recipes in a window for reference.

Note: if you don't know any recipes it won't list any.
 
Last edited:
Wow, down for 24 hours, are they re-launching Shadows of Luclin?

I have a bunch of things I want to break in TCG, how can I, this is an injustice.
 
Maybe they are actually performing hardware maintenance? Nothing in the notes or files downloaded would signify more than 2 hours.
 
Shadow said:
Maybe they are actually performing hardware maintenance? Nothing in the notes or files downloaded would signify more than 2 hours.
Click to expand...
I suspect it is on a VM cluster or whatever the kids call it these days, unless I give too much credit.
 
This is a feasible way to delete records in SQLite?

Code: 
local data_array = {1,2,3,4,5,6}

for x = 1, #data_array do
db:exec("DELETE FROM MasterCompTable WHERE RecipeID ="..data_array[x]) 
end

Change my mind?
 
Lua: 
local data_array = {1,2,3,4,5,6}
local dbCommand = string.format("DELETE FROM MasterCompTable WHERE RecipeID IN (%s)", table.concat(data_array, ", "))

db:exec(dbCommand)
 
rouneq said:
Lua: 
local data_array = {1,2,3,4,5,6}
local dbCommand = string.format("DELETE FROM MasterCompTable WHERE RecipeID IN (%s)", table.concat(data_array, ", "))

db:exec(dbCommand)
Click to expand...
I was thinking something like that, but did not know how to properly construct, thank you.
 
Sevlen said:
View attachment 41066
Banked the Intricate Jewelers Glass to check, but nah -- it's using the JC Table for this (and similar) fletching recipes :(
Click to expand...


1659067813246.png

Found these 3

73210 75560 CLASS 5 Dragorn Point Arrow (Large Groove) 228 5 Jewelry Making Table Jewelry Making
73211 75561 CLASS 5 Dragorn Point Arrow (Medium Groove) 228 5 Jewelry Making Table Jewelry Making
73225 75575 CLASS 6 Dragorn Point Arrow (Large Groove) 228 5 Jewelry Making Table Jewelry Making

Fixed.. next release --

but if you want to delve, you can go into the database with DB browser in the MasterRecipeTable table, and change them to Fletching Table and Fletching for the skill..

apparently a couple of these had "collapsible jeweler's kit" in the recipe and they decided to use that instead of a fletching table. go figure.

Edit: My parser (long time ago) got it confused and it has an order to the craft type and craft bag/table, so if it sees jeweler something it tags it as JC and JC table.
 
Last edited:
This is an amazing piece of work!

I can't fathom what went into scraping the data for recipes and etc.
I'm sure I am not using your product to the fullest, but I've tumbled my way through to do what I know I need to do. Currently maxing out my skills to 300, then pushing to 350.

How do I search vendor purchased reciepes?
 
Tiny_Ape said:
This is an amazing piece of work!

I can't fathom what went into scraping the data for recipes and etc.
I'm sure I am not using your product to the fullest, but I've tumbled my way through to do what I know I need to do. Currently maxing out my skills to 300, then pushing to 350.

How do I search vendor purchased reciepes?
Click to expand...
There are about 2500 recipes that can be bought, which is a very small fraction.. However, I did do the data massage and got a working list of those recipes that I will put in the next release. Also, documentation is going to get some love.
 
There seems to be a problem in the TSS baking freebie. When it is time to turn in the "Simple Pie", it does not turn them in and cycles back through simple muffins. I ran it on 8 toons, same thing every time. If you stop the quest and turn them in it gets happy and continues on it's merry way.
 
Randyleo said:
There seems to be a problem in the TSS baking freebie. When it is time to turn in the "Simple Pie", it does not turn them in and cycles back through simple muffins. I ran it on 8 toons, same thing every time. If you stop the quest and turn them in it gets happy and continues on it's merry way.
Click to expand...
So, I have tested this a lot and it worked (as in run in on toon after new toon until my mobo smoked), but I will test it again.
 
jb321 said:
There are about 2500 recipes that can be bought, which is a very small fraction.. However, I did do the data massage and got a working list of those recipes that I will put in the next release. Also, documentation is going to get some love.
Click to expand...
Is there a do all the bought combines button?
 
jb321 said:
So, I have tested this a lot and it worked (as in run in on toon after new toon until my mobo smoked), but I will test it again.
Click to expand...
I don't like when there are problems, but I do like it when I can re-create them. I think I have a fix. In this case it is a matter of cycling through the recipes and one of them sharing components with another, Simple Pie and Simple Muffin both share 2 of the same ingredients.

But the reason it cycles is that a later or prior recipe will be used in the craft, specifically pottery, and sometimes fletching.

The problem: we end up with more than 20 simple pies and we keep ending up with over 20 pies, it is told to craft them and when it reaches it breaks out and cycles, which then comes upon the simple muffin recipe and starts making those, and then since it is on the muffins it thinks those need to be turned in, and it destroys the craft components, and starts all over.
 
Last edited:
Looks like

Code: 
     local tss_item_id, tss_recipe_name, hc =
                lib.return_recipe_info(l_recipe_id)
            if mq.TLO.FindItemCount(tss_item_id)() > 19 and l_recipe_id == 36599 then
                break
            end

fixed the unruly pies..
 
Randyleo said:
Thank you sir.
Click to expand...

It's annoying because it wasn't supposed to over-make pies, at least I thought it wasn't supposed to. For GOD I destroy everything that is left over, for TSS I leave it up to chance, see where that gets me. My thought was, hey if I have some left over food to eat, why destroy it, we can eat it..
 
Last edited:
Randyleo said:
Do I need to download it again and reinstall?
Click to expand...
When I put out the new release you should be able to download it from the redguides launcher

If you feel like being a daredevil..

add these lines around 285-290 in TCN_TSS.Lua

Code: 
    local tss_item_id, tss_recipe_name, hc =
                lib.return_recipe_info(l_recipe_id)
            if mq.TLO.FindItemCount(tss_item_id)() > 19 and l_recipe_id == 36599 then
                break
            end

1659310406396.png
 
Last edited:
1659477678424.png
Any clue why this might be happening? Trying to run the Tailoring Trophy quest. Am I missing components?
 
EQman0311 said:
View attachment 41181
Any clue why this might be happening? Trying to run the Tailoring Trophy quest. Am I missing components?
Click to expand...
Which level, expert, master, beginner?

Just a guess, you don't have the quest, or it is not selecting the right quest to get the number from the quest journal..

Does your alt-q show that tailor test?

If it is Expert, I need to add that one for the next release, it does have all the other tailor tests.
 
Next Release:

Added Trophy Tests:

Expert Potter Test
Master Brewer Test
Expert Tailor Test
Journeyman Baker Test
Expert Baker Test
Expert Brewer Test
Journeyman Potter Test
Apprentice Smith Test
Apprentice Jeweler Test
Journeyman Jeweler Test
Apprentice Fletcher Test
Expert Fletcher Test
Journeyman Researcher Test
Expert Researcher Test
Master Researcher Test
 
You must log in or register to reply here.
Release Tradeskill Construction Set NeXt
Next unread thread 🦁

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top
Cart

Cart

Total -