SqlItems

[fubotix]

So I was poking around for a way to query a list of all items for those sellable on the AH,
(My current AH bot set's up its own price's I just feed it a list of names). Poking around Intellisense I discovered the sqlCore stuff,

I tried to use it but it just hangs the bot completely after listing the first 4 results.
UI freeze and all.

public List<SqlItem> GetAllItems() {
           return (from s in this.sqlCore.sqlItems
                   where s.Value.sellable select s.Value).ToList();
}

foreach(SqlItem i in GetAllItems()) {
     Log(i.name);
}

Any suggestions?

 

[fubotix]

Also. Is there anyway to walk the pages of the AH results yourself.
Im usually only interested in the first few. not all of them. and it slows the bot down massively.

 

[Out]

Any suggestions?

Dont try to log 15619 items? ^^

 

[fubotix]

It was failing without the log. Shall give it another try tho. thanks for the quick response.

Edit I was logging them in later code and hadn't realized. Working like a charm, Thanks Out.