Page 1 of 1

RESOLVED: Auction House Limitation Help

Posted: Wed Feb 22, 2017 10:19 pm
by ScubaSteve
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 "
        "%s";
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

Re: RESOLVED: Auction House Limitation Help

Posted: Mon May 29, 2017 4:18 am
by Danny 1993
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