RESOLVED: Auction House Limitation Help
Posted: 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.
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:
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";
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