Norganna's AddOns

Norganna

Hi everyone,

As many of you know, I have for the past 12 months or so been working on a WoW Auction Database application and online website/database called AuctioneerDb. It is designed to be a primarily free application with premium features available to paying customers, such as more frequently updated and more comprehensive statistics.

It is by no means necessary to obtain the premium service unless you're a serious user of these stats, however to support those that have supported us all these years, I will be gifting all of the Norganna's AddOns donators who have donated $5 or more prior to 5th of February 2009 with a complimentary 24 month membership to the service when it goes live next week.

It is important to note that the paid subscription service is necessary to cover the costs of the bandwidth and servers required to receive, store, process and redistribute all the data. Anyone who knows what kind of load this is on the servers knows that it can't be done well for free, however the client software that runs on your PC is completely open-source and you can use it in a standalone mode if you desire absolutely free of charge.

I'll announce more details when the time arrives!

SilverVixen

Let me be the first to say: Congrats!

And also, thank you in advance!

~SilverVixen :)

Norganna

I've just ordered and paid for the first month of the new server, so we're about 12 hours away from starting the configuration and setup of the server side software now.

Munazz

I tried to do something like this on our Guild's website. I wrote a PHP page that would take the auctioneer data (one of the old formats) and would then save the current price of every item to the database. That was then searchable by anyone.

Of course, this has the downside of only using one person's data at a time and did not accumulate the different scans by different users. And I never updated it to the new data format.

So... what is this about sharing the code to allow us to host our own data?

Norganna

The client application itself can accumulate your data in it's own SQL database, and reports can be written/run on your personal data from within the client.

Thandril

You should add a link to the donation site!

thor1701

so does this mean there will be a new updated auctioneer as well? its been a little while sense the last update came out and i can never find any post's on how the progress is going or if they are ever gonna add a refresh button to the post tab or not

MattBnr

try the wotlk release it has everything your looking for.

thor1701

yeah thanks, been useing that one for a while, i was just mearly saying if there was going to be another update to the actual thing or not, also there was something in the works on putting a refresh button on the post tab, but i havnt heard anything new on it and was wondering when the next update will be comeing out

MattBnr

your not using the wotlk release if you don't have the refresh button. not 3715 that is old. use 3953 i think it is which has all the features your looking for. do a clean install when upgrading.

thor1701

ok i wonder how long thats been there, beacuse every time i checked, it would always show me the 3715 version, and there wouldnt be any notice or anything in the main page, thats why i asked if anyone was gonna update, so i downloaded it and there's a button woohoo tyvm lol

dinesh

it's not on the main page because it is still a beta/preview release.

thor1701

well what i ment was a while back when i checked out the beta area, nothing would ever come up so i figured nothing was there, it works now and im extreemly happy about it lol

redplane

This thread reminded me to send a long over due donation. Ty and keep it up!

Rincewind

This sounds quite a good thing, have been using auctioneer for a very long time now and have seen it evolve over a long period of time.

gant.aggramar

that was money well spent for my all time favourite addonn.....thx for all the hard work norganna :}

sufanek

What sort of "data" should this database contain? Something similar to wowecon? In particular I'm interested in possibility of exporting data (like auctioneerdb, which doesnt work for me, should do), for computing some additional statistics..
thx

Norganna

How do you mean it doesn't work for you, sufanek?

sufanek

Tried to install n run the app on three different computers (all Win XP pro, with .net 35 sp1 installed). After launching auctioneerDB I got totally no response. Not even an error. The app seems to kill itself before it outputs anything visible on the screen (it does not leave any process running either).

sufanek

but forget about that, probably just some local bug :). Should i post complaints about it somewhere, where it belongs (certainly not in here)?

What about the new database content anyway?

Norganna

Hmm, well, we're still working on it, and admittedly I haven't tested it on a broad range of computers yet. I have tested it on a fresh install of XP pro + all service packs + .net 3.5sp1, and it works fine.

Question: What version are you using at the moment?

Also, what do you want to know about the database content? It will contain all the auctions that you have ever scanned, and all the details therein, you can write reports that process this data in LUA and it will be capable of exporting the data from the reports.

Should you wish, you may also use the sqlite.exe to access your on-disk database via SQL commands and export data that way as well.

sufanek

Posted By: Norganna
Question: What version are you using at the moment?

Win XP Pro Build 2600.xpsp_sp2.qfe.080814-1242 (Service Pack 2). Am not sure about other two computers, but I guess, they got SP2 too. Anyway, these are far from being fresh install, with tons of soft installed, so i reckon that it's gonna be hard to trace the problem.

Posted By: Norganna
Also, what do you want to know about the database content? It will contain all the auctions that you have ever scanned, and all the details therein, you can write reports that process this data in LUA and it will be capable of exporting the data from the reports.

Oh I see. I think the initial post was a bit confusing for me - as it speaks of database application, and then of database/website. I didn't recognize these are two distinctive things - so I'll be running own sql server with my data, and there will be some general online database as well(with paid access), where this data wil merge?

Q: Will I need current AuctioneerDB for moving data from Auctioneer to database? (If I should keep trying to run it..)

Posted By: Norganna
Should you wish, you may also use the sqlite.exe to access your on-disk database via SQL commands and export data that way as well.

Great, that's precisely what I needed.

Norganna

Posted By: sufanek

Win XP Pro Build 2600.xpsp_sp2.qfe.080814-1242 (Service Pack 2). Am not sure about other two computers, but I guess, they got SP2 too. Anyway, these are far from being fresh install, with tons of soft installed, so i reckon that it's gonna be hard to trace the problem.

Actually I was talking about the version of AuctioneerDb, but that's interesting because I'm testing on XP Pro Build 2600.xpsp_sp3_gdr.080814-1236: Service Pack 3 (fully patched and updated)... I wonder If I should create a vm of an unpatched windows to test on.

Oh I see. I think the initial post was a bit confusing for me - as it speaks of database application, and then of database/website. I didn't recognize these are two distinctive things - so I'll be running own sql server with my data, and there will be some general online database as well(with paid access), where this data wil merge?

There is a client which maintains it's own database and then *optionally* uploads to/downloads from the website.

Uploads/downloads from the website are free. Completely 100% free.

The premium (subscription) version are for people who want more frequent data (daily stats) downloads, and additional services such as sms alerts etc.

Q: Will I need current AuctioneerDB for moving data from Auctioneer to database? (If I should keep trying to run it..)

The AuctioneerDb application will collect and collate the scan data and store it in the local database and optionally sync data to/from the server.

krendar

I think this sounds very interesting. I will definately pay for the service even though I might not use the premium services. I know it can be expensive to run such server if a lot of transfers is going to take place.

sufanek

Posted By: Norganna
Actually I was talking about the version of AuctioneerDb, but that's interesting because I'm testing on XP Pro Build 2600.xpsp_sp3_gdr.080814-1236: Service Pack 3 (fully patched and updated)... I wonder If I should create a vm of an unpatched windows to test on.

I am using AucDB v1.0.8.4962 (seems, that most recent version is not downloadable at the moment, saying ERROR: Unknown path: /dl/AucDbSetup-1.0.9.4973.exe). Anyway, forget about the windows related problems - i updated to the very same version of WinXP SP3 like you have got, and it made no change. I just hope, than new version of AucDB will work.

Edit: I installed latest AucDb version - 1.0.9.4973 and works fine now. I'll try to install it on SP2 machines later, to see if this was the problem

Otherwise i agree - this is gonna be really cool service. How is it with that sql server. Is it running while AucDB is launched? Is it possible to connect to it?

krendar

A few bugs on Vista x64 (.Net 3.5 SP 1 is installed):

-The installer does not ask if I want to "run as administrator". You can right-click and select that, so its no big deal just want to mention it.

-Each time I start it says that AucDB is not installed if I want to download. No matter what I select I get an exception:

http://norganna.pastey.net/105918

Program starts up anyway.

-If I click the "Import" option in the program I get the message that the program has stopped working and it exits.

Hirsute

Posted By: krendar
A few bugs on Vista x64 (.Net 3.5 SP 1 is installed):

-The installer does not ask if I want to "run as administrator". You can right-click and select that, so its no big deal just want to mention it.

Hopefully norgs wrote the program in such a way that it doesn't need escalation. If so, then it shouldn't be prompting.

-Each time I start it says that AucDB is not installed if I want to download. No matter what I select I get an exception:

http://norganna.pastey.net/105918

Program starts up anyway.

This occurs for me on Vista Ultimate 32-bit, as well.

-If I click the "Import" option in the program I get the message that the program has stopped working and it exits.

I got this the first time, but the second time I tried it, it imported just fine.

krendar

Posted By: Hirsute

Hopefully norgs wrote the program in such a way that it doesn't need escalation. If so, then it shouldn't be prompting.

It wants to install in "Program Files" per default so it needs admin rights unless you change that.

MattBnr

cant you just move it? or change the install location?

Hirsute

Posted By: krendar
[quote]
Posted By: Hirsute

Hopefully norgs wrote the program in such a way that it doesn't need escalation. If so, then it shouldn't be prompting.

It wants to install in "Program Files" per default so it needs admin rights unless you change that.[/quote]

Ah, you're right.

Hirsute

Posted By: MattBnr
cant you just move it? or change the install location?

Sure, but if it's going to default there, it would be nice for it to be able to post an escalation request to actually enable you to install it there if you want.

MattBnr

ok everytime i load up the auctioneerdb program it tells me i don't have the aucdb program installed and if i want to download and install it. i have done this 3 times what am i doing wrong.

Hirsute

Looks like a few of us, at least, get that error. I find it will generally work just fine for me once I tell it "ok"

MattBnr

ok one more question. what do the values mean in the min bid column. like i see strange dust min bid 60000 is that 60000 copper, silver, gold, some other different number completely?

Hirsute

Should be 60000 copper, or 6g.

MattBnr

hmm im pretty sure strange dust doesn't get that high.

rts1007

getting a weird error after installing and running for first time
Fatal Exception in InitializationLua:
"
Message: Could not load or assemble 'lua51, Version 0.0.0.0, Culture=neutral, PublikKeyToken=1e1fb15b02227b8a' or one of its dependencies. Tha application had failed to start because its side-by0side configuration is incorrect. Please see the application loff got more detail(Exception from HRESULT=0x800736B1)
Source:LuaInterface
"

Any ideas?

pfenrir

Install ASP.NET. I got the same error and could have swore I had it installed, but didn't. Installed ASP.NET, using the link on the AuctioneerDB page, and AuctioneerDB worked....

Oh when you install the ASP.NET I got an odd "please close the install program so I can install the program" message. Really odd. Anyway, if you get that as well just click ignore and reboot and you should be set to go.

Norganna

Just FYI, the version that's up there at the moment isn't 100% complete.

The version that I'm currently developing will be the "announced" release version, and it will have all the upload/download/update options completed.

I'm just working on the download portion at the moment, and it's looking like tomorrow it should be complete (fingers crossed).

Once this is done, I'll repackage the download version on the website so you guys can give it a test run, then I have to code up the website to support the premium subscription stuff (until I do this, the program will run in premium mode for everyone)

Once the premium upgrade stuff is done, I'll send out the complimentary upgrade codes to all donation email addresses.

askjosh

Norganna,

I must say that you are awesome, you have truly made what I think is one of the 3 best Addon suites for WOW. The other two being MobMap and Carbonite (Carbonite has a free light and paid full version of their addon). I wont link to there sites but for those that dont know about them I highly suggest you do a google search.

I currently have a yearly subscription to Carbonite and so far I feel that I have gotten more than my $$$ worth out of it. So if you were to price the Premium subscription around the same as what Carbonite charges for their addon, then I will most certainly sign up for a yearly subscription to your premium service.

Again thank you for all of your hard work on this :-)

saytr79

I am sure its right in my face but where do i download AucDB from ? I cannot find the link :/

MattBnr

http://www.auctioneerdb.com/

dkalweit

Thanks for this tool-- being able to easily extract the data for use in whatever we want is a critical piece many of us have been missing. Is there any source for information on the SQLite database it creates? Possibly a wiki article that can be updated? Most of it is self-explanatory or I've figured out, but I have a few questions, and if there's a stub I can help document a couple of the fields I've figured out(i.e. that 'seen' is a time_t in UTC I believe, but lacks its most significant digit of 1(i.e. add 1 billion to the number to make it a valid time_t) and maybe get some definition on the others. If not, I'll be able to figure them out eventually after I get more scans/imports done, but it's just easier if there's a reference. ;-) Thanks.

--
Derek

Marth

Norganna - thanks for all of this - I just sent in a donation (albeit long overdue!)

Marth

Marth

Dame errors happen in XP SP2 Compat mode.

Marth

After seeing the above errors, I went and looked ot see that Auc-DB had indeed been loading and running in game. In my SavedVariables folder, there's an Auc-Db.lua file...it's only 40KB tho, 287 lines total. Not sure if it's supposed to be that small, or if it's supposed to be a set of the auction house scan data (there were over 17k items on Stonemaul's AH this evening), or if something didn't work right :)

Nechckn

Marth,

Although such information is helpful, it would likely be of better use to test and report on any findings in the new, overhauled client, which should be posted in the next few days.

Happy Sales,

Nikk :shades:

Deckard

Hi Norganna,

Any chance for a Mac OS X client for AuctioneerDb? I realize with the virtualization software available today that I could just run Windows on an Intel Mac, but I don't yet have one.

Thanks for all your efforts, AuctioneerDb sounds very promising.

Marth

Posted By: Nechckn
Marth,

Although such information is helpful, it would likely be of better use to test and report on any findings in the new, overhauled client, which should be posted in the next few days.

Happy Sales,

Nikk

Not a problem :) Figured I'd try and jump in feet first.

Might you be able to answer for me, though, what exactly is supposed to be saved in the Auc-Db.lua file in SavedVariables? That way I know for sure what I'm looking at while testing.

Thanks!

Nechckn

Marth,

You basically just ensure that the addon is loaded, as the statistics are formulated during the final 3 phases of scanning, the data will be added to Auc-DB.

The format is defined - http://wiki.norganna.org/Development#defined_file_formats - it should grow the more you scan the different AHes you normally visit.

Happy Sales,

Nikk :shades:

Marth

Thanks for the pointers! I guess my question - shouldn't there be more than just a couple hundred lines of info in the Auc-Db.lua file that is created?

Norganna's AddOns

Howdy, Stranger!

Categories

In this Discussion