• 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
MQ2LinkDB

Release MQ2LinkDB

Overview Updates (14) Discussion
Does not feel like a big deal, but I can do a /link faded bloodied luclinite and I get a small list of links and it says found 73 items and shows me 10, cool. But the item I wanted a link for does not show in the 10, so I type /link faded bloodied luclinite charm, there should be 3 however it says nothing found. I typed the full name with charm of vigor, still nothing. Is there a limit to how long it goes?
 
Redfrog said:
Does not feel like a big deal, but I can do a /link faded bloodied luclinite and I get a small list of links and it says found 73 items and shows me 10, cool. But the item I wanted a link for does not show in the 10, so I type /link faded bloodied luclinite charm, there should be 3 however it says nothing found. I typed the full name with charm of vigor, still nothing. Is there a limit to how long it goes?
Click to expand...
I just tried doing /link faded bloodied luclinite charm and I got 3 results.. brilliance security and vigor.. so its possible your database isnt up to date and doesnt contain (or have learned those via chat links) yet?
 
Redfrog said:
Does not feel like a big deal, but I can do a /link faded bloodied luclinite and I get a small list of links and it says found 73 items and shows me 10, cool. But the item I wanted a link for does not show in the 10, so I type /link faded bloodied luclinite charm, there should be 3 however it says nothing found. I typed the full name with charm of vigor, still nothing. Is there a limit to how long it goes?
Click to expand...
make sure you update your DB "/link /import"
 
"found 0 items from database of 0 total items"

just did fresh reguides install + unloaded and reloaded plugin
then did a /link /import
says 130k+ items added.. then when i do a /link wurmslayer ... i get the found 0 items from database of 0 total items"...

any suggestions? thnx

1677210568487.png
 
So I've noticed this before but items now happened enough for me to ask about it. On some items I can search and find the item, but clicking the result does not view the item. Most items do work, but some examples of ones that do not work for me are...
Frozen Maiden's Tear
Candles of Everburning
Pure Energeian Ice Orb (As well as Earth, Disease, Decay, Death, Air, and possibly more, but Growth, Fire, Ethereal, and Elemental all work fine)

Anyway again, most items do work, there are many more items I've tried to create links to in the past where /link finds a result but the result doesn't work to show the item.
 
Last edited by a moderator:
Hey all - just a quick heads up I refactored a lot of this plugin and moved it to a sqlite db. This means that lookups that used to take second are now instant. There is also some new functionality with:

/link /update - which will download the latest items db from RG and install it (no more manual downloads)
/link /query will query the DB from in game. IE: /link /query tradeskills=1 AND lore LIKE '%lbs.%' LIMIT 25

If you run into any issues hit me up in discord as I don't often check these forums.
 
I am getting a lot of these errors lately:

1704465823402.png

"Error inserting into item_link table: database is locked"

Just thought I'd mention it if anyone was looking out.
 
Weird error trying /link /update today. This happens and totally locks up the character (endless output):

1709065834203.png

Otherwise, as long as I don't try to update it, it seems to work ok:

1709065983932.png

I have been noticing quite a few missing items, so I was trying to update it.
 
Apologies if I'm simply jumping the gun or shark or whatever...
When does the update for new items get imported in? I did an import and it refreshed all the links fine, but the new Heritage stuff (Guktan) were not there. If its normal and they are added in a day or two later.. just ignore this. ty.
 
Good MoraftnooEve all.

I seem to be running into an issue when trying to do /link /update.

Screenshot 2024-08-09 101211.png

So I went to the link and manually downloaded the 'items.txt' from the link and placed it in the root of the MQ folder. Stopped and restarted MQ2LinkDB.

Screenshot 2024-08-09 100346.png

Should the downloaded file be placed in another location fopr a manual import?

Thank you,
- M
 
Derple updated MQ2LinkDB with a new update entry:

08/21/2024

〰️Commits​


Fix item name handling (#12)

* making the field buffer larger - should refactor this to not use staticly sized arrays later

* fix for crash root cause

* - Added item_name to the link table so we no longer join against the

raw_data table this should fix issues on EMU and Live with discovered
links

- Fixed a bug with how item links and item names were being stored.

* SQL Cleanup


Moved...
Click to expand...
Click to expand...

Read the rest of this update entry...
 
mjwhittier6396 said:
Good MoraftnooEve all.

I seem to be running into an issue when trying to do /link /update.

View attachment 63977

So I went to the link and manually downloaded the 'items.txt' from the link and placed it in the root of the MQ folder. Stopped and restarted MQ2LinkDB.

View attachment 63978

Should the downloaded file be placed in another location fopr a manual import?

Thank you,
- M
Click to expand...

Where did you place it? It should be in resources.
 
You must log in or register to reply here.
Release MQ2LinkDB
Next unread thread 🦁

Users who are viewing this thread

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

Cart

Total -