public function updateUserBlackmarketItems($userID, $bmID, $quantity)
{
$itemParams = array();
$itemParams['user_id'] = $userID;
$itemParams['item_id'] = $bmID;
$itemParams['quantity'] = $quantity + 1;
// print_r($itemParams);
//for this to work, need to modify appropriate tables to have unique constraint over two columns
//http://www.w3schools.com/sql/sql_unique.asp
//although i think the two primary keys are doing it
if (ConnectionFactory::InsertOnDuplicateKeyUpdate("users_items", $itemParams, "quantity", 1)) {
return 1;
}
return 0;
//echo $val;
//die();
}
public function updateDailyBonus($amount, $numConsecDays)
{
if ($numConsecDays < 6) {
$params = array();
$params['user_id'] = $this->id;
$dayString = 'day' . ($numConsecDays + 1);
$params[$dayString] = $amount;
return ConnectionFactory::InsertOnDuplicateKeyUpdate("users_dailybonuses", $params, $dayString, $amount);
} else {
$params = array();
for ($i = 1; $i <= 6; $i++) {
$params['day' . $i] = 0;
}
$conditions = array();
$conditions['user_id'] = $this->id;
return ConnectionFactory::updateTableRowAbsoluteBasic("users_dailybonuses", $params, $conditions);
}
}
