Deprecated Darkstar fourms

PrBlahBlahtson wrote:- Similar, but to exclude taboo items, like L75+ armor and GM gear.

Individual server admins would just set the 'aH' value to 0 in the item_basic table to prevent that item from ever being listed.

You might like this one. SELECT itemid, stackSize, COUNT(sale) AS saleCount FROM (SELECT Item.itemid, Item.stackSize, AH.itemid AS sale FROM (SELECT itemid, 1 as stackSize FROM item_basic WHERE aH > 0 UNION SELECT itemid, stackSize FROM item_basic WHERE aH > 0 AND stackSize > 1) as Item LEFT JOIN au...

I came up with rather long, probably improvable query that returns a list of itemid's and how many AH listings it has as long as it has less listings than $forsale(I used 10 in this example). Any item that has $forsale or more AH listings will not be returned, meaning that no listings need to be add...

I was thinking of a different approach which should greatly reduce some of the memory/cpu problems. I'll try to pseudocode it here. ---Building history for all items--- 1. Select all AH-able items where the history count is zero.(should be able to do this with single sql statement)(should also retur...

They do have double attack on SE servers.

Source(confirmed in 3 comment posts)
http://ffxi.allakhazam.com/db/bestiary.html?fmob=1023