public GEItem getOfferByPlayerSlot(Player p, byte slot)
{
/*
* Gives the player their GrandExchange Items both Buying and Selling are here.
* Returns a GEItem[] of all Item's array based on slot id, null array index = space
*/
long playerHash = p.getLoginDetails().getLongName();
try
{
int itemId;
int amount;
int price;
bool isSoldNull;
bool isBoughtNull;
int sold;
int bought;
int collectedItem;
int collectedGold;
int overpaid;
bool aborted;
GEItem geItem = null;
SQLiteDatabase db = new SQLiteDatabase(Constants.databaseName);
SQLiteVdbe preparedStatement = new SQLiteVdbe(db, "SELECT itemId, amount, price, bought, NULL sold, collectedItem, collectedGold, overpaid, aborted FROM grandExchangeBuying WHERE playerHash = ? AND slot = ? UNION SELECT itemId, amount, price, NULL bought, sold, collectedItem, collectedGold, overpaid, aborted FROM grandExchangeSelling WHERE playerHash = ? AND slot = ?");
preparedStatement.Reset();
preparedStatement.BindLong(1, playerHash);
preparedStatement.BindInteger(2, slot);
preparedStatement.BindLong(3, playerHash);
preparedStatement.BindInteger(4, slot);
while (preparedStatement.ExecuteStep() != Sqlite3.SQLITE_DONE)
{
if (preparedStatement.GetLastError() != "")
{
misc.WriteError("[GrandExchange SQL Error]: " + preparedStatement.GetLastError());
return(null);
}
itemId = preparedStatement.Result_Int(0);
amount = preparedStatement.Result_Int(1);
price = preparedStatement.Result_Int(2);
isBoughtNull = string.IsNullOrEmpty(preparedStatement.Result_Text(3));
isSoldNull = string.IsNullOrEmpty(preparedStatement.Result_Text(4));
collectedItem = preparedStatement.Result_Int(5);
collectedGold = preparedStatement.Result_Int(6);
overpaid = preparedStatement.Result_Int(7);
aborted = Convert.ToBoolean(preparedStatement.Result_Int(8));
if (isSoldNull && !isBoughtNull)
{
bought = Convert.ToInt32(preparedStatement.Result_Text(3));
geItem = new BuyOffer(itemId, amount, price, bought, collectedItem, collectedGold, overpaid, slot, aborted, playerHash);
}
else if (isBoughtNull && !isSoldNull)
{
sold = Convert.ToInt32(preparedStatement.Result_Text(4));
geItem = new SellOffer(itemId, amount, price, sold, collectedItem, collectedGold, overpaid, slot, aborted, playerHash);
}
else
{
misc.WriteError("[GrandExchange Error]: sold or bought both are NULL? how this happen?");
}
}
db.CloseDatabase();
return(geItem);
}
catch (Exception e)
{
misc.WriteError("[GrandExchange Error]: " + e.Message);
}
return(null);
}