Download
(117Kb)
Download
Compatible with Retail, Classic & TBC
Updated: 02-08-24 06:35 PM
Pictures
File Info
Compatibility:
Classic (1.15.1)
Seeds of Renewal (10.2.5)
WOTLK Patch (3.4.3)
Updated:02-08-24 06:35 PM
Created:08-20-19 11:40 PM
Downloads:37,794
Favorites:39
MD5:
Categories:Classic - General, Auction House & Vendors, Data Mods

Auction House DataBase (AHDB) Classic  Popular! (More than 5000 hits)

Version: v1.07.09
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

ChangeLog for Auction House DataBase (AHDB) by MooreaTv ([email protected])

Coming next:
- Your input/suggestions welcome !
- See open issues for ideas https://github.com/mooreatv/AuctionDB/issues

v1.07.07 Feb 8th 2024
- Classic / Season of Discovery is now 1.15.1

v1.07.07 Nov 18th 2023
- Classic is now 1.15.0

v1.07.06 Oct 24th 2023
- Wrath is now 3.4.3

v1.07.05 Aug 22nd 2023
- Update for Classic 1.14.4 - in time for Classic Hardcore launch!

v1.07.04 Jun 24th 2023
- Update wrath to 3.4.2

v1.07.03 Jan 27th 2023
- Update wrath TOC

v1.07.02 Sept 5th 2022
- Avoid shipping wrong MoLib in SL even if AHDB doesn't work with SL

v1.07.01 Sept 4th 2022
- Pick up latest MoLib with isBurningCrusade / isWrath fix.

v1.07.00 July 17th 2022
- Wrath Classic (beta) 3.4.0

v1.06.05 June 4th 2022
- Updated for Classic Era 1.14.3

v1.06.04 March 26th 2022
- Update Burning Crusade TOC for 2.5.4
- peg luacheck to 0.23.0

v1.06.02 Feb 22nd 2022
- Updated the TOC (even though Shadowlands is still not supported, sorry)
and updated packager again to latest community packager (v2)

v1.06.01 Feb 12th 2022
- Single zip build + TOC updates + warning that wait for sellers has been broken by blizzard.

v1.05.04 November 9th 2021
- New option to skip over stuck items in config. Applies rarely to tbc AH
(most of the fix in MoLib 8.1.1) - fixes #36

v1.05.03 Sept 2nd 2021
- BCC 2.5.2
- Disable waiting for seller info BCC as it doesn't work

v1.05.02 May 23rd 2021
- Actually add the multiple TOCs this time (Classic BC support)
and right version in the file

v1.05.00 May 10th 2021
- Multi TOC support for Burning Crusade vs Classic Era

v1.04.05 April 21st 2021
- Classic now 1.13.07

v1.04.04 March 9th 2021
- Fix up github action packager version.
- Sorry still doesn't work on retail

v1.04.03 Dec 2nd 2020
- Classic 1.13.06 + other TOC info additions.
- Sorry still doesn't work on retail

v1.04.01 Oct 18th 2020
- Fix for multiple flip/flop of show/hide minimap generating molib error. (pick up new molib too)

v1.04.00 Oct 18th 2020
- Added option to hide minimap button in config `/ahdb conf`

v1.03.01 Aug 8th 2020
- Misc dev mode improvements: Seen filter for lowbid is now a set and corrected whisper message.

v1.03.00 July 24th 2020
- Auction Item Database schema v5, now contains itemSellPrice, itemStackCount, itemClassID,
itemSubClassID, itemRarity, itemMinLevel prefix before the link (MoLib change)
- The internal item database will enrich automatically with item info as you scan but if you have
a large one you want to manually update, do `/ahdb infoscan` a few times (wait a bit and /reload in between)
- See the matching schema change in https://github.com/mooreatv/AHDBapp

v1.02.02 July 8th 2020
- Updated for Classic 1.13.5
- [bfa] doesn't yet work with the recent AH revamp of BfA 8.3

v1.02.01 March 3rd 2020
- Updated for Classic 1.13.4
- doesn't yet work with the recent AH revamp of BfA 8.3

v1.02.00 December 10th 2019
- Updated for Classic 1.13.3

v1.01.04 October 14th 2019
- Add ProjectAzilroka to optional deps so it can manage our minimap icon.
- [wip] Pickup/Use latest MoLib scrolling frame (for now just `/run AuctionDB:TableDemo()`)

v1.01.03 Sept 30th 2019
- Fix rounding issue in MoLib's :round() and improved AH info calc
fixes https://github.com/mooreatv/BetterVendorPrice/issues/6

v1.01.02 Sept 25th 2019
- Now (optionally) waits for seller info (you can turn it off in options for fastest scan)
to consider the scan complete - most of the work as usual is in MoLib.

v1.00.01 Sept 11th 2019
- Stable enough for 1.0!
- Make the dependency on BVP optional because curseforge/twitch is broken
- Trying to flip around retail and classic tags and default to see if it helps
- Now use periodic yield to avoid (rare) DCs, from MoLib - should fix #23
- Config option to not show the periodic "you can scan" chat text - Fixes #29

v0.14.00 Sept 9th 2019
- Added support for LibDBIcon / SexyMap through MoLib changes (Fixes #20)
- Added support to disable all AHDB temporary keybindings (Fixes #21)
v0.12.03 Sept 9th 2019
- Adding option to hide the big button per request (Fixes #16)
v0.12.01,.02 Sept 5th 2019
- Re tag to get curse to pickup the dependency
v0.12.00 Sept 5th 2019
- Fix for #18: Raw data was fine but AH tooltip and TSM pricing info could miss the min for the first auction
found if it had multiple items
v0.11.05 Aug 29th 2019
- Don't print warning about scan not doable at every AH open (Fixed #15)
v0.11.04 Aug 28th 2019
- Fixed minimap button and big button drag to move forgetting location on reload (thx Bayart for the report!)
v0.11.03 Aug 28th 2019
- Fix bogus "Can't scan outside of cities..."
v0.11.02 Aug 28th 2019
- Software is hard... Really fixed #12, #13, #14 now. Should not show button unless rested and should
not spam the chat periodically either
v0.11.01 Aug 28th 2019
- Opsa... was still starting with button shown irrespective of resting state (!) - sorry - fixed now!
v0.11.00 Aug 27th 2019
- No more pause/hang on classic at the end of the first scan!
- Unlike in BfA which doesn't mind despite 100x more items, for classic we needed to not restore
the item update event immediately, yet keep the UI functional even if you search after
and hit enter in Name editbox for instance (still haven't found how to hide previous results
if you manual search first and then do a full scan but it's only cosmetically wrong in that case)
- Fix the inital /tar -> /scan button binding
- Detect "in combat" overlapping with start/end of resting to avoid addon blocked errors

v0.10.00 Aug 27th 2019
- Don't show the big pulsating button unless IsResting() (ie in city/inns) - Fixing Issue #12
- Don't bind key for full scan unless at AH
- Option to turn off the /tar auctioneer binding
- Now works even if another addon (like aux-addon) hides the standard UI (moved ah open/close events to MoLib)
- Also from MoLib: Bug fixes on normally shrinking auctions list
(in classic unlike BfA it seems the list refreshes faster despite having fewer auctions)

v0.09.02 Aug 26th 2019
- Pick up another MoLib small fix (round to .1 copper when dividing (avoids 16.6666666 copper),
coding error in 1 of the warnings)
v0.09.01 Aug 26th 2019
- Pick up MoLib fix with typo in classic code path that couldn't be tested until now (!) sorry!
v0.09.00 Aug 26th 2019
- Rebranded from short name "AuctionDB" to "AHDB" to avoid confusion with TSM's internal module of the same name
- Now include current bid in scan DB v6 and deserialization on load.
- (for now) Requires Better Vendor Price to display AH results information through tooltip
- Classic is today !

v0.08.00 Aug 25th 2019
- Pickup from MoLib: itemdb version 4 (20% shorter), and a bug fix for suffixid
- Better/more Localization strings

v0.07.01 Aug 24th 2019
(from MoLib)
- Fixed bogus realm mismatch warning
v0.07.00 Aug 23rd 2019
(from MoLib:)
- New ItemDB even more compact format
- Scan data also better structure: group by item and seller,
now down to 1.5Mb a scan from 30Mb when I started.

v0.06.00 Aug 23rd 2019
- Pick up big AH changes in MoLib - https://github.com/mooreatv/MoLib/blob/master/ChangeLog.txt
- Also bind IWT (so hitting it 3 times starts a scan (target, open, start scan))
- New transparent, glowing button
- Added shift key to prevent auto scan feature (auto scan delay is noop atm)

v0.05.00 Aug 22nd 2019
- The build now includes localization
- bug fix: use PLAYER_REGEN_DISABLED as the event to hide our button, avoids combat error
(thanks humfras!)
v0.04.00 Aug 22nd 2019
- Now with functional auto scan as well as secure button to target, scan and reload
- options panel controls how many newly found items should be shown in each scan
v0.03.00 Aug 21st 2019
- Pick up MoLib changes to split item DB and scan results yielding 30Mb -> 2Mb decrease
(+ couple Mb for itemDB but that's fixed cost with number of scans)
v0.02.01 Aug 20th 2019
- Initial functional version, click to scan
v0.01.01 August 20th 2019
- AH context call and key bindings (and pick up newer MoLib)
v0.01.00 August 19th 2019
- Options/config pane
- initial version, created from MooreaTv/WowAddonTemplate
./newaddon.sh 'AuctionDB' 'ADB' 'Auction House DataBase' 'AUCTIONDB' 'ahdb' 'Auction House DataBase, records DB history and offline queries, for classic and more'
Optional Files (0)


Archived Files (21)
File Name
Version
Size
Author
Date
v1.07.08
117kB
MooreaTv
02-08-24 06:32 PM
v1.07.07
117kB
MooreaTv
11-18-23 01:07 PM
v1.07.06
117kB
MooreaTv
10-24-23 07:50 PM
v1.07.05
117kB
MooreaTv
08-22-23 07:36 PM
v1.07.04
117kB
MooreaTv
06-24-23 10:49 PM
v1.07.03
117kB
MooreaTv
01-27-23 11:37 PM
v1.07.02
117kB
MooreaTv
09-05-22 12:49 PM
v1.07.01
116kB
MooreaTv
09-04-22 11:40 AM
v1.07.00
116kB
MooreaTv
07-17-22 01:42 PM
v1.06.05
115kB
MooreaTv
06-04-22 11:12 AM
v1.06.04
102kB
MooreaTv
03-26-22 01:19 PM
v1.06.02
103kB
MooreaTv
02-22-22 05:20 PM
v1.06.01
103kB
MooreaTv
02-12-22 10:54 PM
v1.06.00
103kB
MooreaTv
02-12-22 10:51 PM
v1.06.00
103kB
MooreaTv
02-12-22 10:49 PM
v1.05.04
102kB
MooreaTv
11-09-21 05:32 PM
v1.05.03
102kB
MooreaTv
09-02-21 01:42 PM
v1.05.02
102kB
MooreaTv
05-23-21 10:10 AM
v1.05.00
99kB
MooreaTv
05-10-21 10:29 PM
v1.04.05
98kB
MooreaTv
04-21-21 10:50 AM
v1.04.04
98kB
MooreaTv
03-09-21 06:49 PM


Post A Reply Comment Options
Unread 06-27-20, 09:52 AM  
MooreaTv
An Aku'mai Servant
AddOn Author - Click to view AddOns

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
Report comment to moderator  
Reply With Quote
Unread 05-06-20, 07:47 PM  
Cerenza
A Kobold Labourer
AddOn Compiler - Click to view compilations

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?
Report comment to moderator  
Reply With Quote
Unread 12-03-19, 04:57 PM  
MooreaTv
An Aku'mai Servant
AddOn Author - Click to view AddOns

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
Report comment to moderator  
Reply With Quote
Unread 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,
Report comment to moderator  
Reply With Quote
Unread 09-23-19, 05:42 AM  
MooreaTv
An Aku'mai Servant
AddOn Author - Click to view AddOns

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)
Report comment to moderator  
Reply With Quote
Unread 09-22-19, 02:46 PM  
subducocaligos
A Kobold Labourer

Forum posts: 0
File comments: 1
Uploads: 0
Question 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.
Report comment to moderator  
Reply With Quote
Unread 09-11-19, 10:31 PM  
MooreaTv
An Aku'mai Servant
AddOn Author - Click to view AddOns

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)
Report comment to moderator  
Reply With Quote
Unread 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?
Report comment to moderator  
Reply With Quote
Unread 09-10-19, 07:30 PM  
MooreaTv
An Aku'mai Servant
AddOn Author - Click to view AddOns

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
Report comment to moderator  
Reply With Quote
Unread 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
Report comment to moderator  
Reply With Quote
Unread 08-31-19, 05:26 AM  
MooreaTv
An Aku'mai Servant
AddOn Author - Click to view AddOns

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
Report comment to moderator  
Reply With Quote
Unread 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 comment to moderator  
Reply With Quote
Post A Reply



Category Jump: