Register
Welcome to the Stormspire.net WoW Gold Forums!

Greetings, guest! Welcome to Stormspire.net, your #1 resource for WoW and Diablo 3 Gold, Professions, and everything in between!


Enjoy what the site offers? Consider Premium Membership if you wish to get the most out of the site. Premium Membership benefits include the acclaimed Goblineer's World of Warcraft Gold Guide, private forum access, a complimentary high-quality avatar, and much more!


If this is your first visit, make sure to check out the Stormspire.net Survival Guide for a quick site orientation. You may also register to unlock all standard forum features, and to get rid of these lovely ads!


We proudly host the Official forums for TradeSkillMaster, The Undermine Journal, and WoWuction.

Page 1 of 37 12311 ... Last
Results 1 to 10 of 363
  1. #1
    Sapy on US-Tichondrius(H)
    TSM Lead Developer
    Sapu94's Avatar
    Posts
    5,509
    Reputation
    271
    Blog Entries
    21
    Tagged in
    1607 Posts
    Add to this user's reputation

    Update AuctionDB Data Automatically (without scanning)

    Closing and unsticking thread as the new application is out! (See sticky post).


    Background: http://consortium.stormspire.net/off...g-ah-ever.html

    This post will explain how to get the TradeSkillMaster - Auction Data application set up to automatically update your AuctionDB data using the new AH APIs. This means you never have to scan the AH again! The data will be updated once an hour (that's how often blizzard updates it) and all you have to do is reload your UI to get the latest data in game.

    So I finally finished this application and it seems to work as far as I can tell (although I doubt it'll work on mac - sorry).


    Installation:

    Step 1: Download r120 or later of AuctionDB from curseforge (v0.3.4Beta won't work).

    Step 2: After installing the new version make sure you restart wow.

    Step 3: Download the application from the attachments of this post. The icon should look like this.

    Step 4: Place the application wherever is convenient for you. It really doesn't matter which directory you put it in.

    Step 5: Run the application. The screens should be straightforward and self-explanatory.

    Step 6: Whenever the application updates your data, simply reload your UI in game to get the latest data into AuctionDB. You'll get a print out from AuctionDB if it worked (may get lost in the loading text so scroll up). Note that it'll only update with the latest scan when you reload, so if you don't reload for 4 hours, you won't get all 4 hours worth of data, only the latest.


    Possible Issues:
    Issue:"No/old version of TradeSkillMaster_AuctionDB found"
    Solution:See step 1.

    Issue:I messed up the inital setup.
    Solution:There will be a TSMConfig.txt file in the same directory as the application. Simply delete this file and restart the application to redo the initial setup.

    Issue:It seems to freeze.
    Solution:This is most likely an issue with either your internet connection or blizzard's servers being down. Note that it will temporarily appear frozen while it's downloading and processing auction data. This is a roughly 1MB download and a substantial amount of processing so be patient with it!

    Issue:I don't trust running .exe files!
    Solution:Go ahead and do a virus scan. If that doesn't satisfy you, here are the project files (including source code) for you to review and build the application yourself (I used Microsoft Visual C# 2010 Express). If that still doesn't satisfy you, please save us both some time and just don't use it.

    Issue:OMG I GOT HACKED!
    Solution:By downloading and running this application you agree with the "NOTE" listed below.

    Issue:What is the license on this application?
    Solution:I reserve all rights on this application, project files, and source code. If you would like to share this with others, simply link to this page. I hope everybody would agree that allowing people to post modified versions of a .exe is not a good idea. If you have ideas or code changes you'd like to contribute, feel free to do so by posting diff files (or just explaining your idea).

    Update 4/20/12: Fixed a bug caused by blizzard changing the realm list file and added automatic WoW directory finding.
    Update 12/5/11: Hopefully fixed 404 bug.
    Update 9/24/11: New file up to fix a bug caused by blizzard's new status file format.


    NOTE: By downloading and/or running this application you agree with the following statement: In no way will this application increase or otherwise influence the chance of my account being compromised. If I am concerned about this, I will do everything I can to prevent it including everything discussed in the "I don't trust running .exe files!" solution. If I am still concerned about this, I will not use this application.

    Note: If you're on a realm with a non-English name, download the second file below.

    EDIT: Removed files below as they don't work with 5.0.4. New application will be out well before MoP if all goes well.
    Last edited by Sapu94; September 11th, 2012 at 06:39 PM.


    Follow me and TSM on Twitter for important updates, news, and giveaways!
    TSM Website | TSM Chat Channel (IRC) | Donate | TSM FAQ

    "A good programmer is someone who always looks both ways before crossing a one-way street." ~Doug Linder

  2. #2
    Entrepreneur
    Parket's Avatar
    Posts
    9
    Reputation
    0
    Tagged in
    3 Posts
    Add to this user's reputation

    Thumbs up

    This is, in a word - amazing!

    Link removed. I have attached the file to the post above. ~Sapu
    Last edited by Sapu94; August 14th, 2011 at 06:31 PM.

  3. #3
    Entrepreneur
    Builtokill's Avatar
    Posts
    34
    Reputation
    0
    Tagged in
    3 Posts
    Add to this user's reputation
    AWESOME!!!
    have you figured out how much bandwidth it ends up using per download? - edit: saw your issue 3 bit
    Also, an option to change the amount of time the app downloads the data would be amazing (eg every 15 minutes, every hr, every 2 hrs etc.)
    Last edited by Builtokill; August 14th, 2011 at 06:52 PM.

  4. #4
    Sapy on US-Tichondrius(H)
    TSM Lead Developer
    Sapu94's Avatar
    Posts
    5,509
    Reputation
    271
    Blog Entries
    21
    Tagged in
    1607 Posts
    Add to this user's reputation
    The list of realms which gets downloaded once during the initial setup only is ~40KB. The check to see if the auction data has been updated is practically nothing (less than 1KB). The auction data itself is ~1MB depending on your server's auction house size. Checking more than every hour would be pointless because blizzard only updates it once an hour (usually closer to every 62 minutes in my testing).

    Glad you guys like it!
    Last edited by Sapu94; August 14th, 2011 at 06:33 PM.


    Follow me and TSM on Twitter for important updates, news, and giveaways!
    TSM Website | TSM Chat Channel (IRC) | Donate | TSM FAQ

    "A good programmer is someone who always looks both ways before crossing a one-way street." ~Doug Linder

  5. #5
    Entrepreneur
    Builtokill's Avatar
    Posts
    34
    Reputation
    0
    Tagged in
    3 Posts
    Add to this user's reputation
    thanks for quick response! I'm really looking forward to actually getting ah data... i've been relying on my knowledge on prices because i always get DC'd when doing scans (yay australia T.T)

  6. #6
    Entrepreneur
    skmzarn's Avatar
    Posts
    60
    Reputation
    0
    Tagged in
    16 Posts
    Add to this user's reputation
    W.....o...w.....WOW! Amazing! There's not even a word for how cool this is. Thank you so much!

  7. #7
    EU-Twilight's Hammer(H)
    Entrepreneur
    savchris's Avatar
    Posts
    7
    Reputation
    0
    Tagged in
    1 Posts
    Add to this user's reputation
    TUJ for EU servers and now that... TY!

  8. #8
    Sapy on US-Tichondrius(H)
    TSM Lead Developer
    Sapu94's Avatar
    Posts
    5,509
    Reputation
    271
    Blog Entries
    21
    Tagged in
    1607 Posts
    Add to this user's reputation
    Known bug: If you have the option checked, the window will flash when the application checks for new data, which may or may not mean it actually updated the data. If the data didn't actually get updated, it'll try again in 2 minutes so if the "next check for updates" is less than 2 minutes when it flashes, it didn't update.


    Follow me and TSM on Twitter for important updates, news, and giveaways!
    TSM Website | TSM Chat Channel (IRC) | Donate | TSM FAQ

    "A good programmer is someone who always looks both ways before crossing a one-way street." ~Doug Linder

  9. #9
    EU-Greymane
    Entrepreneur
    sklyanka's Avatar
    Posts
    23
    Reputation
    0
    Tagged in
    5 Posts
    Add to this user's reputation
    Got an error.
    EU region. RU realm. Седогрив. Horde side.

    Подробная информация об использовании оперативной
    (JIT) отладки вместо данного диалогового
    окна содержится в конце этого сообщения.

    ************** Текст исключения **************
    System.Net.WebException: Удаленный сервер возвратил ошибку: (404) Не найден.
    в System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
    в System.Net.WebClient.DownloadData(Uri address)
    в TradeSkillMasterAuctionData.Backend.GetContent(Str ing url)
    в TradeSkillMasterAuctionData.Backend.GetData(String realm, Int64 lastUpdateTime)
    в TradeSkillMasterAuctionData.Realm.UpdateAuctionDat a()
    в TradeSkillMasterAuctionData.GUI.UpdateLastUpdateTi mes(Object sender, EventArgs e)
    в System.Windows.Forms.Timer.OnTick(EventArgs e)
    в System.Windows.Forms.Timer.TimerNativeWindow.WndPr oc(Message& m)
    в System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


    ************** Загруженные сборки **************
    mscorlib
    Версия сборки: 4.0.0.0
    Версия Win32: 4.0.30319.235 (RTMGDR.030319-2300)
    CodeBase: file:///D:/WINDOWS/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
    ----------------------------------------
    TradeSkillMasterAuctionData
    Версия сборки: 1.0.0.0
    Версия Win32: 1.0.0.0
    CodeBase: file:///G:/Games/World%20of%20Warcraft/TradeSkillMasterAuctionData.exe
    ----------------------------------------
    System.Windows.Forms
    Версия сборки: 4.0.0.0
    Версия Win32: 4.0.30319.235 built by: RTMGDR
    CodeBase: file:///D:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    ----------------------------------------
    System.Drawing
    Версия сборки: 4.0.0.0
    Версия Win32: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///D:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    ----------------------------------------
    System
    Версия сборки: 4.0.0.0
    Версия Win32: 4.0.30319.236 built by: RTMGDR
    CodeBase: file:///D:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    System.Configuration
    Версия сборки: 4.0.0.0
    Версия Win32: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///D:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    ----------------------------------------
    System.Xml
    Версия сборки: 4.0.0.0
    Версия Win32: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///D:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
    ----------------------------------------
    System.resources
    Версия сборки: 4.0.0.0
    Версия Win32: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///D:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.resources/v4.0_4.0.0.0_ru_b77a5c561934e089/System.resources.dll
    ----------------------------------------
    System.Windows.Forms.resources
    Версия сборки: 4.0.0.0
    Версия Win32: 4.0.30319.235 built by: RTMGDR
    CodeBase: file:///D:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms.resources/v4.0_4.0.0.0_ru_b77a5c561934e089/System.Windows.Forms.resources.dll
    ----------------------------------------
    mscorlib.resources
    Версия сборки: 4.0.0.0
    Версия Win32: 4.0.30319.235 (RTMGDR.030319-2300)
    CodeBase: file:///D:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/mscorlib.resources/v4.0_4.0.0.0_ru_b77a5c561934e089/mscorlib.resources.dll
    ----------------------------------------

    ************** Оперативная отладка (JIT) **************
    Для подключения оперативной (JIT) отладки файл .config данного
    приложения или компьютера (machine.config) должен иметь
    значение jitDebugging, установленное в секции system.windows.forms.
    Приложение также должно быть скомпилировано с включенной
    отладкой.

    Например:

    <configuration>
    <system.windows.forms jitDebugging="true" />
    </configuration>

    При включенной отладке JIT любое необрабатываемое исключение
    пересылается отладчику JIT, зарегистрированному на данном компьютере,
    вместо того чтобы обрабатываться данным диалоговым окном.

  10. #10
    Sapy on US-Tichondrius(H)
    TSM Lead Developer
    Sapu94's Avatar
    Posts
    5,509
    Reputation
    271
    Blog Entries
    21
    Tagged in
    1607 Posts
    Add to this user's reputation
    That error just means it couldn't connect to battle.net for whatever reason. Just ignore it (you can restart if you want but you don't have to).


    Follow me and TSM on Twitter for important updates, news, and giveaways!
    TSM Website | TSM Chat Channel (IRC) | Donate | TSM FAQ

    "A good programmer is someone who always looks both ways before crossing a one-way street." ~Doug Linder

 

 
Page 1 of 37 12311 ... Last

Similar Threads

  1. Automatically buy parchments and take Inks out of my Bank
    By barrettj in forum General TradeSkillMaster Discussion
    Replies: 15
    Last Post: April 15th, 2011, 02:55 PM
  2. AuctionDB market value fomula.
    By Mr Alpha in forum General TradeSkillMaster Discussion
    Replies: 1
    Last Post: March 16th, 2011, 01:35 PM
  3. TSM crafting cost vs auctiondb/auctioneer minimum buyout value, and the AH
    By MrBlah in forum General TradeSkillMaster Discussion
    Replies: 4
    Last Post: March 9th, 2011, 02:41 PM
  4. AuctionDb - Time since last scan
    By Tseng in forum General TradeSkillMaster Discussion
    Replies: 2
    Last Post: February 28th, 2011, 02:27 PM