Request - Appraisal value

[iforgotmyoldlogin]

How do you get appraisal value in a macro variable?

 

[nostress]

It depends how you are going about it. If it's on a corpse
${Corpse.Item[#here].Value}

If it's on your cursor
${Cursor.Value}

If it's in a bag
${FindItem[name].Value}

It will be displayed in copper, so you might want to add a /1000 to it.

 

[iforgotmyoldlogin]

Thanks. Is there a bazaar option?

 

[Maskoi]

No the bazaar no longer passes the value of an item along. Sony removed it with the release of RoF and the offline trader additions

 

[nostress]

No the bazaar no longer passes the value of an item along. Sony removed it with the release of RoF and the offline trader additions

Yeah I found a fix for that. Kind of.

I took a dump of the 13th floor item database, put it into a sql database.
After some slamming my head against my desk I got mq2sql working, and I've been able to query items to get the value of them from the bazaar.

Seeing as mq2sql hadn't been touched for years, I was amazed at how well it works.

 

[Maskoi]

Not a very elegant solution since only you have access to your database.

 

[nostress]

Hence the kind of.

But if they are doing what I think they are trying to do, it's worth the hassle to learn to accomplish it!
Unless you are on my server, then don't bother! It's impossible and you should just leave it at that =)


I'm thinking about cleaning it up and just throwing it up on some web hosting that I've been doing nothing with for years, and posting macro, ya know. just to see the bazaar burn. Only road block is people would have to trust me that I'm not doing anything nefarious! Also would posting a compiled mq2sql binary not be kosher since it is mq2vip (abandoned since like freaking 05 aside from break fixes)

 

[Maskoi]

We have several posted mq2sql versions floating around. We have not had any issues about plugins being posted that have been abandoned by their authors for that long.