RESOLVED: Auction House Limitation Help

Post Reply
Posts: 9
Joined: Sat Dec 08, 2012 9:42 am
Location: Winter Park, FL

RESOLVED: Auction House Limitation Help

Post by ScubaSteve » Wed Feb 22, 2017 10:19 pm

Hey guys,

So I am trying to keep AH only displaying item from level 75 or below. I want into: data_loader.cpp to changed the SQL.

Code: Select all

const int8* fmtQuery = "SELECT item_basic.itemid, item_basic.stackSize, COUNT(*)-SUM(stack), SUM(stack) "
        "FROM item_basic "
        "LEFT JOIN auction_house ON item_basic.itemId = auction_house.itemid AND auction_house.buyer_name IS NULL "
        "LEFT JOIN item_armor ON item_basic.itemid = item_armor.itemid [color=#FF0000]AND item_armor.`level` < 76[/color] "
        "LEFT JOIN item_weapon ON item_basic.itemid = item_weapon.itemid "
        "WHERE aH = %u "
        "GROUP BY item_basic.itemid "
My change is listed in red. Why would armor above level 75 appear in the result set with a level of 'NULL'?

RESOLVED: After about 10 minutes of stupidity I realized that they were NULL and I can use that. Added under where:

Code: Select all

AND item_armor.`level`IS NOT NULL

Danny 1993
Posts: 11
Joined: Sun May 28, 2017 4:18 am

Re: RESOLVED: Auction House Limitation Help

Post by Danny 1993 » Mon May 29, 2017 4:18 am

Hey there,

I've been having a lot of trouble trying to get the auction house to be stocked normally, and I also wanted it to show items that were level 75 and below - is there any chance you could copy and paste what the appropriate sql files now say please? I'm a complete novice at all of this and I'm struggling haha

Post Reply