Register
Results 1 to 2 of 2
  1. #1

    Undermine Journal listing things that I didn't list or sell

    Hiya, I am foo from foo-wow.blogspot.com

    http://theunderminejournal.com/selle...ller=Foofreeit

    Currently Foofreeit is posting glyphs. Lots of glyphs. Exceptionally cheap glyphs. He does not sell anything else. Especially not Vrykul Rune Sticks or Nerubian Obelisk. So I was surprised to find the data below.

    4 [Vrykul Rune Stick] 50g 5s 50g 25s 2 days, 2 hours ago 1 day, 9 hours ago
    4 [Vrykul Rune Stick] 50g 5s 50g 25s 2 days, 2 hours ago 1 day, 9 hours ago
    4 [Vrykul Rune Stick] 50g 5s 50g 25s 2 days, 2 hours ago 1 day, 9 hours ago
    4 [Vrykul Rune Stick] 50g 5s 50g 25s 2 days, 2 hours ago 1 day, 9 hours ago
    1 [Nerubian Obelisk] 100g 90s 101g 0s 2 days, 2 hours ago 1 day, 9 hours ago
    1 [Nerubian Obelisk] 100g 90s 101g 0s 2 days, 2 hours ago 1 day, 9 hours ago
    4 [Vrykul Rune Stick] 50g 5s 50g 25s 2 days, 2 hours ago 1 day, 9 hours ago
    4 [Vrykul Rune Stick] 50g 5s 50g 25s 2 days, 2 hours ago 1 day, 9 hours ago
    4 [Vrykul Rune Stick] 50g 5s 50g 25s 2 days, 2 hours ago 1 day, 9 hours ago
    1 [Nerubian Obelisk] 100g 90s 101g 0s 2 days, 2 hours ago 1 day, 9 hours ago
    1 [Nerubian Obelisk] 100g 90s 101g 0s 2 days, 2 hours ago 1 day, 9 hours ago

    There were a few other items a little earlier as well.

    If you were going to hack someone to post auctions I would be astounded at leaving them up for 15 hours. The prices were roughly reasonable, within price swings. I can understand using a sleeper account to shift high value items in an effort to 'launder' gold, but surely for more than 2000g

    I do have an authenticator. I do have a bagfull of gold; not necessarily as big as some that post on here, but large enough. I also have far too much in stock, including several darkmoon cards.

    I really would have thought that if someone was going to hack me, then they would have the courtesy of clearing me out. It would at least make a worthy (if somewhat sad) blog posting.

    I know that Breevok posted something similar a little while ago.

    I have changed both my email and blizzard passwords.

    I have checked my stocks and bank accounts.

    I am wondering if
    • there is a bug in the blizzard data feeds?
    • there is a bug in the undermine journal database?
    • someone is intercepting or determining my authenticator codes?
    • someone is bypassing authenticator codes?

  2. #2
    Erorus's Avatar
    Posts
    1,404
    Reputation
    114
    Tagged in
    677 Posts
    Add to this user's reputation
    Hi, Foo!

    There was a bug in the auction parser for The Undermine Journal. This bug has been in there for a while, and took me about an hour to dig out. Breevok's friend probably fell victim to the same bug, so my conclusion at that time was probably incorrect. Your account is safe.

    And, for the record, the auction data is still accurate as far as what was posted, in what quantities, for what prices, and when. The only thing incorrect was the seller name for some auctions.

    Somewhat ugly technical details follow.

    Let's start by looking at the raw XML for the scan where we saw those items. If you search for 1636357238 you'll find the auction line (and surrounding auctions) for the Vrykul Rune Stick. The Armory returned the seller name as "???".

    When we see "???", it's the Armory saying that it can't find the seller name for the seller ID attached to that auction. It's a special value that is seen on all realms. Sometimes it's temporary and a name is supplied on the next scan, but sometimes that's all we see. That's the case with this set of Vrykul Rune Stick auctions.

    In our auction database, we store all seller names in a lookup table, and store the seller IDs on the auction lines. It saves space and makes queries a lot quicker. When we parse results to insert them into the database, we cache seller ID lookups in an array as we create the insert statements for the database. The problem came up because the parser can loop through multiple realms, but it didn't clear the seller ID cache array after it switched realms. Foofreeit is seller ID 53 (or whatever) on Caelestrasz Alliance, but seller ID 53 is "???" on some other realm. So when the first realm was scanned, the lookup cached "???" as ID 53, and saved that as the ID for all "???" lookups in subsequent scans.

    The parser script would only process up to 50 realms before being forced to shut down and restart, and our parse queue depth is low anyway, so it's rare that a script would process more than a couple realms at a time before quitting (clearing the lookup cache). This error would show up most often on items with the "???" seller since that name exists on all realms, but it's plausible that another name shared on two realms that were scanned back-to-back would have misattributed items.

    Now that the bug is fixed, current and future auctions will have the correct sellers, but past auctions will remain slightly incorrect.

    Thanks for reporting the issue!

 

 

Similar Threads

  1. Sold Items list is WAY off on Undermine Journal
    By annamaria in forum Official Forum of The Undermine Journal
    Replies: 40
    Last Post: June 8th, 2011, 10:17 PM