(118Kb)

Compatible with Retail, Classic & TBC

Updated: 08-13-24 08:45 PM

Add Favorite

Install Help

Portal

Bugs

Features

Pictures

File Info

Compatibility:	The War Within (11.0.2) Classic (1.15.2)
Updated:	08-13-24 08:45 PM
Created:	08-20-19 11:40 PM
Downloads:	38,096
Favorites:	39
MD5:
Categories:	Classic - General, Auction House & Vendors, Data Mods

11.0.2

Auction House DataBase (AHDB) Classic

Version: v1.08.01

by: MooreaTv [More]

Auction House DataBase

Auction House DataBase, records DB history and allows offline queries, for classic and more.

This Open Source addon (AHDB for short) is mostly to capture the evolution of the WoW classic economy from empty to mature.

We have a unique chance to record that history and that's what this addon attempts to accomplish

As you might know the Blizzard APIs to query the AH from the web (like The Undermine Journal does for instance) won't exist at launch and for some undetermined time after launch, so let's together create and maintain that DataBase.* (DB uploader in the works)

What does it do?

AuctionDB shows a (moveable) button to take the next step (target the auctioneer, start scan, save,...)

If you configured it to do so, each time you open the auction house (if available and unless you hold shift or cancel the scan), AHDB will take a full snapshot of your auction house and record it in your saved variables under the realm, faction and timestamp

You will be able to later query that DB even when not at the AH

More information

Get the binary release using curse/twitch client or on wowinterface

The source of the addon resides on https://github.com/mooreatv/AuctionDB
(and the MoLib library at https://github.com/mooreatv/MoLib)

Releases detail/changes are on https://github.com/mooreatv/AuctionDB/releases

Auction House DataBase (AHDB)
v1.08.01 (2024-08-14)
Full Changelog Previous Releases

Retail / 11.0.2: Fix for change in GetAddOnMetadata (in MoLib); toc update; note this does NOT work in retail

Optional Files (0)

Archived Files (21)

File Name	Version	Size	Author	Date
Auction House DataBase (AHDB) Classic	v1.08.00	118kB	MooreaTv	07-25-24 02:48 PM
Auction House DataBase (AHDB) Classic	v1.07.11	117kB	MooreaTv	07-09-24 02:27 PM
Auction House DataBase (AHDB) Classic	v1.07.10	117kB	MooreaTv	04-02-24 01:35 PM
Auction House DataBase (AHDB) Classic	v1.07.09	117kB	MooreaTv	02-08-24 06:35 PM
Auction House DataBase (AHDB) Classic	v1.07.08	117kB	MooreaTv	02-08-24 06:32 PM
Auction House DataBase (AHDB) Classic	v1.07.07	117kB	MooreaTv	11-18-23 01:07 PM
Auction House DataBase (AHDB) Classic	v1.07.06	117kB	MooreaTv	10-24-23 07:50 PM
Auction House DataBase (AHDB) Classic	v1.07.05	117kB	MooreaTv	08-22-23 07:36 PM
Auction House DataBase (AHDB) Classic	v1.07.04	117kB	MooreaTv	06-24-23 10:49 PM
Auction House DataBase (AHDB) Classic	v1.07.03	117kB	MooreaTv	01-27-23 11:37 PM
Auction House DataBase (AHDB) Classic	v1.07.02	117kB	MooreaTv	09-05-22 12:49 PM
Auction House DataBase (AHDB) Classic	v1.07.01	116kB	MooreaTv	09-04-22 11:40 AM
Auction House DataBase (AHDB) Classic	v1.07.00	116kB	MooreaTv	07-17-22 01:42 PM
Auction House DataBase (AHDB) Classic	v1.06.05	115kB	MooreaTv	06-04-22 11:12 AM
Auction House DataBase (AHDB) Classic	v1.06.04	102kB	MooreaTv	03-26-22 01:19 PM
Auction House DataBase (AHDB) Classic	v1.06.02	103kB	MooreaTv	02-22-22 05:20 PM
Auction House DataBase (AHDB) Classic	v1.06.01	103kB	MooreaTv	02-12-22 10:54 PM
Auction House DataBase (AHDB) Classic	v1.06.00	103kB	MooreaTv	02-12-22 10:51 PM
Auction House DataBase (AHDB) Classic	v1.06.00	103kB	MooreaTv	02-12-22 10:49 PM
Auction House DataBase (AHDB) Classic	v1.05.04	102kB	MooreaTv	11-09-21 05:32 PM
Auction House DataBase (AHDB) Classic	v1.05.03	102kB	MooreaTv	09-02-21 01:42 PM

Comment Options

06-27-20, 09:52 AM

MooreaTv

An Aku'mai Servant

Forum posts: 38

File comments: 20

Uploads: 8

Originally Posted by Cerenza

It is telling me it doesn't have my server when it's scanning?

'Ashbringer EU'? I opened the .lua for the servers and I can't find it there either?

Please send /ahdb bug output

05-06-20, 07:47 PM
Cerenza A Kobold Labourer Forum posts: 1 File comments: 31 Uploads: 1	It is telling me it doesn't have my server when it's scanning? 'Ashbringer EU'? I opened the .lua for the servers and I can't find it there either?

12-03-19, 04:57 PM

MooreaTv

An Aku'mai Servant

Forum posts: 38

File comments: 20

Uploads: 8

Re: Data

Originally Posted by drjoeus

Hi,

is the database saved anywhere locally so I can query this myself outside of the game?

Thanks,

yes it is in saved vars and I have a github project that puts it in a MySQL DB:

https://github.com/mooreatv/AHDBapp

11-30-19, 08:00 AM
drjoeus A Kobold Labourer Forum posts: 0 File comments: 1 Uploads: 0	Data Hi, is the database saved anywhere locally so I can query this myself outside of the game? Thanks,

09-23-19, 05:42 AM

MooreaTv

An Aku'mai Servant

Forum posts: 38

File comments: 20

Uploads: 8

Re: Cannot get ADHB tooltip with pricing data

Originally Posted by subducocaligos

Hello All:

Looking for assistance, I installed the add-on, it scans the database, tells me what new items it found in the database etc., but when I go to my backpack, there is no ADHB tooltip with pricing data showing? Any idea how to get that information to show? Also, when the AH is not open, and I left click it just tells me that I am not at the AH, and cannot scan, how to I get to what is considered "offline" to scan the database that is saved? Thanks all for help.

You need to install Better Vendor Price to see the tooltip

I had to make the dependency optional instead of required because of general brokenness of curseforge/twitch (not that wowi supports anything either)

09-22-19, 02:46 PM
subducocaligos A Kobold Labourer Forum posts: 0 File comments: 1 Uploads: 0	Cannot get ADHB tooltip with pricing data Hello All: Looking for assistance, I installed the add-on, it scans the database, tells me what new items it found in the database etc., but when I go to my backpack, there is no ADHB tooltip with pricing data showing? Any idea how to get that information to show? Also, when the AH is not open, and I left click it just tells me that I am not at the AH, and cannot scan, how to I get to what is considered "offline" to scan the database that is saved? Thanks all for help.

09-11-19, 10:31 PM

MooreaTv

An Aku'mai Servant

Forum posts: 38

File comments: 20

Uploads: 8

Re: Re: Re: How to update?

Originally Posted by Emrak

Originally Posted by MooreaTv

As long as you don't delete your saved variables you can update that way

Thanks for the speedy response! How would I know if I'm deleting saved variables?

You can check in your WTF folder for AuctionDB.lua and it should not be empty
or mouse over any item before scanning it should have ADHB tooltip with pricing data
(I need to add some stats about last scan date, number of scans etc)

09-11-19, 06:30 PM

Emrak

A Kobold Labourer

Forum posts: 0

File comments: 6

Uploads: 0

Re: Re: How to update?

Originally Posted by MooreaTv

As long as you don't delete your saved variables you can update that way

Thanks for the speedy response! How would I know if I'm deleting saved variables?

09-10-19, 07:30 PM

MooreaTv

An Aku'mai Servant

Forum posts: 38

File comments: 20

Uploads: 8

Re: How to update?

Originally Posted by Emrak

Hi there! Great add-on and I think it'll be cool to see the final collated dataset you create out of this.

That said, I do have a question about upgrading. When you release a new version, should I just delete the old version and replace it with the new version? That is what I do with most add-ons, but I don't want to delete the local data that AHDB is collecting. Or is the data stored in a separate folder somewhere?

Thanks

As long as you don't delete your saved variables you can update that way (or use the otherwise terribad twitch app to do so)

When I change the internal format (did only once so far) I upgrade the database the first load

09-10-19, 09:55 AM
Emrak A Kobold Labourer Forum posts: 0 File comments: 6 Uploads: 0	How to update? Hi there! Great add-on and I think it'll be cool to see the final collated dataset you create out of this. That said, I do have a question about upgrading. When you release a new version, should I just delete the old version and replace it with the new version? That is what I do with most add-ons, but I don't want to delete the local data that AHDB is collecting. Or is the data stored in a separate folder somewhere? Thanks

08-31-19, 05:26 AM

MooreaTv

An Aku'mai Servant

Forum posts: 38

File comments: 20

Uploads: 8

Re: Keeps warning me even after scan

Originally Posted by Veilor

Why do the addon keep warning me that it can't scan when I've already made a succesfull scan?

Also it keeps bugging me to scan and the popup thing shows up all the time, please make an option to silence the addon and this thing that pops up. Otherwise great addon.

Sorry about that, was the very first version rushed to not miss the start of the wow economy (hope you recorded / are recording!)

It's fixed since v0.11.03

Let me know if you have any other issue

08-27-19, 10:05 PM
Veilor A Kobold Labourer Forum posts: 0 File comments: 1 Uploads: 0	Keeps warning me even after scan Why do the addon keep warning me that it can't scan when I've already made a succesfull scan? Also it keeps bugging me to scan and the popup thing shows up all the time, please make an option to silence the addon and this thing that pops up. Otherwise great addon. Last edited by Veilor : 08-27-19 at 10:07 PM.

Report this File

Category Jump: