• 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

Request - character sheets

xalpus

New member
Joined
Aug 8, 2013
RedCents
122¢
I've been looking for a macro that would dump all the equipment and banked items to a excel sheet and make the items linked to the zam site. i'm sure this is possible .. if there is a macro already made somewhere that you know about please point me in the direction if not any tips that might help me get started would be awesome..keeping in mind i haven't written code in 20 years and pascal was my language back then.. so I've got a huge learning curve
 
I have to say that would be a pretty badass macro. I would be highly interested in something like this although I don't have a large number of toons.
 
/mac inventory is the closest thing that you want that I know of. Saves a file to Your macroquest folder > log > inventory.mac.log
 
That sounds like an interesting project. Take the inventory mac, run the output through a parser and output a csv should be pretty straightforward. Then if you really want excel, that's a straightforward conversion.
 
UPDATED

Let me see what I can do :P

- - - Updated - - -

I've got a parser written, and I'm able to retrieve 13th floor item links with no problems.
ZAM's web responses aren't nearly as clean, was feeling lazy and didn't want to Parse ZAM.

I'll mess with it some more

- - - Updated - - -

This is a sample of what I've got so far. I used the LINQPad object dumper instead of an excel spreadsheet.
MQ2InventoryDumper.PNG

- - - Updated - - -

Links are clickable now:
MQ2InventoryDumper.PNG
Sample Item Link:
mq2itemlink.PNG

- - - Updated - - -

Forgot to mention, I support multiple Inventory dumps in the mq2log file. Just in case some one wanted to track character / money / inventory progression between runs. I dunno it was really to make sure I kept the Inventory dumps grouped together(by Run) and accurate, in the event that your logfile had more than 1 dump.
MQ2InventoryDumper.PNG
 

Attachments

Last edited:
Still cleaning it up some, I've got a flight to Texas today, so I'll prob mess with it in the airport / in flight.
 
Added group support and some other crap while on the plane. I will slap on a front end and post something to test when I get time :).
 
Ok, so I got this almost done and ready to get some people testing.
After adding group support, I tried running a full group with links for all worn items / bank items / inventory items.... Lets just say I'm gonna bring 13th Floor to the freaking ground in the applications current state. It will be like a DDOS if enough people are using it lol.
I'm currently working on changing my app to fetch links from using their Items.xml file, so that I can do bulk searches either 1 request per char or 1 request per group. Debating right now if I make you guys download the 800mb yourself, or if I host a web service on my end ><
 
will this be able to link to quests so you can figure out wth all this quest shit is ie if you wanna do something with it?
 
I use magelo in my baz posts, it makes it easy to link via item id

http://eq.magelo.com/item/${ItemID}
 
Ya, thought about using magelo originally. I already switched to Zam, good now and it will do the quest linking etc..
 
Which reminds me: Is there a way to get augment id that are currently inserted into a piece of gear? I've poked around but haven't found a way yet. I must be overlooking something...
 
- - - Updated - - -

Which reminds me: Is there a way to get augment id that are currently inserted into a piece of gear? I've poked around but haven't found a way yet. I must be overlooking something...

Code:
${Me.Inventory[chest].Item[1].ID}

Code:
${Me.Inventory[mainhand].Item[1]}
will return the first Aug in your mainhand.


Just checked my chest and got my 3 augs with this:

Rich (BB code):
${Me.Inventory[chest].Item[1]}
${Me.Inventory[chest].Item[2]}
${Me.Inventory[chest].Item[3]}

Couldn't get anything to return Aug count / If aug was equipped, but getting the Aug Name and ID is possible.
 
Last edited:
I like how Magelo's item DB uses the same Item IDs as EQ. ZAM / 13th floor / etc... all use internal item IDs which means you have to search by name. Good suggestion Sym ><
 
Request - character sheets

Users who are viewing this thread

Back
Top
Cart