-
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
knave23
Cookie Champion 2022
- Joined
- Sep 10, 2019
- RedCents
- 6,290¢
I just bought this and am having trouble getting going. I ran
/lua run tcgsetup and it initially failed, but now seems to be working (ending with status 0). However, when I then go to run /lua run tcn it pops up the packagemanager asking me to download lsqlite3 and I click install but the Lua then says "Failed to load package lsqlite3". I saw in the changelog you said to run "/lua run tcgpkg" but that says "Cannot find tcgpkg in the filesystem." What am I doing wrong?
- Seller
- #2,603
Go in your modules folder and delete the sqlite named dlls
also make sure in your Lua directory there is no instance of sqlite dll
knave23
Cookie Champion 2022
- Joined
- Sep 10, 2019
- RedCents
- 6,290¢
- Seller
- #2,605
You can extract this into the Lua > 5.1 folder and that may work..My modules folder is empty and no sqlite dll's in my lua directory
knave23
Cookie Champion 2022
- Joined
- Sep 10, 2019
- RedCents
- 6,290¢
Should I have a luarocks folder? My Release/modules folder was completely empty when I looked there.
As an additional datapoint- I "installed" this macro via the launcher so maybe that didn't do something I should've?
- Seller
- #2,607
I know this was resolved but I didn't capture the steps for another user, Team RG beat me to the punch, hopefully they are out there lurking.
What should happen is a pop says do you want to install and you click install and then a dos window should flash.
knave23
Cookie Champion 2022
- Joined
- Sep 10, 2019
- RedCents
- 6,290¢
Yeah, like I said when I
/lua run tcn I get the popup and I click install then red text in the MQ box saying "Failed to load package lsqlite3." I thought maybe it was Windows Defender blocking the download or something, but it says it has no recent activity so I'm stumped.- Seller
- #2,609
Can you do a screen snip so we/others can see what is going on?
the red text and all, be sure to blank out any sensitive data..
- Seller
- #2,611
as a test could you put the sqlite3.dll file I put in here in the Lua directory?
This would be to see if you can get it running, but it would not address the concern of when sqlite dll updates.
- Seller
- #2,613
No, just put the sqlite dll in the Lua directory that is part of RG.
knave23
Cookie Champion 2022
- Joined
- Sep 10, 2019
- RedCents
- 6,290¢
That did it! Hooray!
knave23
Cookie Champion 2022
- Joined
- Sep 10, 2019
- RedCents
- 6,290¢
Ok another data point: I just tried installing on my laptop and everything actually seemed to work fine. There was an installer for the DBLite Browser and the PackageManager actually worked. One thing I was wondering was if you need to only have one toon loaded to install this? I intentionally tried the laptop install with only one toon loaded, but on my desktop the other day I tried on the last loaded of like 10 toons. Is that a thing?
- Seller
- #2,616
Yea, you can't install with a bunch of toons running as files are in-use or locked.
- Seller
- #2,618
I have run it with 12 toons, so it is not limited, I am on a 64G, 1070
knave23
Cookie Champion 2022
- Joined
- Sep 10, 2019
- RedCents
- 6,290¢
Ok thanks, must be something else. It's very nice so far!
- Joined
- May 31, 2022
- RedCents
- 4,210¢
Hi Jb, there may be an issue with pottery artisan routine.
I'm on 2012 / 2190 recipes (no NoS add on) and when I run the craft --> artisan for pottery it makes conflagrant masks, charms and idols (brilliance, vigor, adroitness) and known recipes tick up to about 2024 (or 2026), then when the routine finishes it resets itself back to 2012 / 2190.
When I re-run the routine, it does it all over again.
Because I'm not too bright, I had initially though there were difference recipes or paths to the same item, so I now have just under a dozen of each of these items
... which is fine.
But when I attempt to make the remaining 178 odd items on the artisan list, it's going to make more conflagrant items.
Oh, and thanks for sorting out the gate to nakedness issue =D
I'm on 2012 / 2190 recipes (no NoS add on) and when I run the craft --> artisan for pottery it makes conflagrant masks, charms and idols (brilliance, vigor, adroitness) and known recipes tick up to about 2024 (or 2026), then when the routine finishes it resets itself back to 2012 / 2190.
When I re-run the routine, it does it all over again.
Because I'm not too bright, I had initially though there were difference recipes or paths to the same item, so I now have just under a dozen of each of these items
... which is fine.But when I attempt to make the remaining 178 odd items on the artisan list, it's going to make more conflagrant items.
Oh, and thanks for sorting out the gate to nakedness issue =D
- Seller
- #2,621
When it finishes a run it reloads your known recipes and then compares them to unknown recipes, and also, it checks if you set any recipe to skip (prize.db) so it wouldn't make it for whatever you reason you so deem.Hi Jb, there may be an issue with pottery artisan routine.
I'm on 2012 / 2190 recipes (no NoS add on) and when I run the craft --> artisan for pottery it makes conflagrant masks, charms and idols (brilliance, vigor, adroitness) and known recipes tick up to about 2024 (or 2026), then when the routine finishes it resets itself back to 2012 / 2190.
When I re-run the routine, it does it all over again.
Because I'm not too bright, I had initially though there were difference recipes or paths to the same item, so I now have just under a dozen of each of these items
But when I attempt to make the remaining 178 odd items on the artisan list, it's going to make more conflagrant items.
Oh, and thanks for sorting out the gate to nakedness issue =D
If you provide the txt file of your pottery recipes output it can help me identify what is wrong, if anything is wrong.
- Joined
- May 31, 2022
- RedCents
- 4,210¢
Last edited:
Hello JB. First thank you for making this amazing Lua. I had it working until last patch, now it seems as if it cannot see my inventory. I am leveling up tinkering and when i select a recipe to make it doesnt do anything. when i click the info check box the missing, bank, and depot tabs are colored red. I have already tried reinstalling but to the same problems. I love the app and it was working before just not now.
- Seller
- #2,624
It appears that my dos command I run from Lua either worked, kinda worked, or really didn't work at all. I am pretty sure I tested it awhile ago, and thought it worked. So now I am just doing it in Lua.
- Seller
- #2,625
So I updated and ran it, and no issues, so I am presuming you are on Test?
Curious. Since the DB knows so many merchants and what they sell, would it be possible to create a routine that sells all TS items you have that are buyable at vendors? There is no point storing stacks of Malt in the bank, if I can just buy it when I need it.
This would be my biggest feature request atm.
This would be my biggest feature request atm.
- Seller
- #2,628
So, it was blank spaces after text.. when I updated the recipe files for new recipes from the .fr site, a few recipes had a couple of spaces after them, and it wrecked .. everything..
I will put out a release later, but figure just for this it doesn't need to be a whole release just for.. this:
extract the attached file into your TCN\Working directory and overwrite the existing file..
I checked all the other files, they do not seem to suffer from the same malady.
Last edited:
Live servers actually. I noticed if i deleted the sqlite dll files and it reinstalled i am getting an error in the cmd window that pops up saying error in Lua 5.1 interpreter not found at c:\redguides which is the folder that MQ uses. then modules may not install with the correct configurations. where can i go to set the path correctly
- Seller
- #2,630
As a side note, you may see weird numbers like 148 fishing done and 5 to go and a count of 153 total.. which is the right maths, but, pre-TOL it was 150 fishing recipes.
So, it is counting the total amount of recipes you know (including TOL) + the amount of recipes needed from the master list of that trade-skill.
So in reality you have 145 recipes done for the list, and need 5, but it is adding in your TOL and possibly NOS post..
What does it all mean, it is presuming you are doing pre-TOL recipes, and anything else is icing on the cake, and if your skill is 350 and you didn't do 12 recipes on the list, what are you still doing here? it's over!
Rant..
So, it is counting the total amount of recipes you know (including TOL) + the amount of recipes needed from the master list of that trade-skill.
So in reality you have 145 recipes done for the list, and need 5, but it is adding in your TOL and possibly NOS post..
What does it all mean, it is presuming you are doing pre-TOL recipes, and anything else is icing on the cake, and if your skill is 350 and you didn't do 12 recipes on the list, what are you still doing here? it's over!
Rant..
- Seller
- #2,631
for installs/re-installs/copy to somewhere elsers..
the best option is to install RG, and the watch the resource (Lua), after that if it is the first time on a new machine or some other scenario where things went amiss, then /Lua run tcgsetup
after that /Lua run tcn and install SQL if it asks..
I saw this, but it wasn't clear to me what it does.
To clarify, is the sell table comprised of all items I can repurchase from vendors if needed?
- Seller
- #2,633
the "?" next to it should have provided some insight. However, it will sell most everything in that can be purchased from vendor save for a few high dollar items like diamonds, cleaning solutions, stuff like that..
here is a partial list, if you open sell.db and check for fields with >0 in ItemNoSale:
I tried to make a "smart" list or close enough to make sure you are not selling water, or containers you already bought, etc..
Whatever you want to change just make sure the field is 0 instead of 1
Last edited:
- Seller
- #2,635
The Internet is great, some people think I am yelling, some people think I am projecting, some people think I possess 0 art skills, who hurt you, etc...Thanks.
Your passive-aggressive blue circle made me chuckle by the way
It doesn't matter what the truth is, it only matters what you believe...
I would quantify my behavior for that is answering the question with light trolling.
Okay that is how i installed first time but will do a whole new fresh install from RG see if that fixes it
- Seller
- #2,637
Also, don't have other toons (instances of EQ) loaded, after it is working, then run other toons..
ok just did full reinstall still getting same errors which i have attached. and yes only used one toon with it. in the CMD error is when i try to install the sqlite and then the tsc error shows the tabs red out because it is unable to read my inventory. Last week had used the Lua to get from 150 to 220 just this week it having the errors.
Attachments
- Seller
- #2,639
Is this on a new character for the issues or on ALL characters? Depot does not work if you did not buy NOS from DBG for all your toons..
Also if it is red, and depot does work (IE you shelled out fat cat money to DBG), it means there is nothing in the depot that can be used for the craft currently.
If neither condition is true, then there is something to look at..
Last edited:
- Joined
- May 31, 2022
- RedCents
- 4,210¢