/**
* To post the comment
* @param The user who have posted the comment $senderID
* @param The user to which comment was posted $receiverID
* @param The content of the comment $content
* @return boolean
*/
public static function postComment($senderID, $receiverID, $content, $time)
{
$comment = array();
$comment['sender_id'] = $senderID;
$comment['receiver_id'] = $receiverID;
$comment['comments'] = $content;
//$comment['time_posted'] = 'NOW()';
$success = ConnectionFactory::InsertIntoTableBasic("comments", $comment);
return $success;
}
public static function addPurchasedDiamond($udid, $amount, $diamonds, $product_id, $transaction_id, $purchase_date, $app_item_id, $quantity, $bid, $bvrs, $valid_request, $level)
{
$diamond_purchased_history = array();
$diamond_purchased_history['udid'] = $udid;
$diamond_purchased_history['amount'] = floatval($amount);
$diamond_purchased_history['diamonds'] = $diamonds;
$diamond_purchased_history['product_id'] = $product_id;
$diamond_purchased_history['transaction_id'] = $transaction_id;
$diamond_purchased_history['purchase_date'] = $purchase_date;
$diamond_purchased_history['app_item_id'] = $app_item_id;
$diamond_purchased_history['quantity'] = $quantity;
$diamond_purchased_history['bid'] = $bid;
$diamond_purchased_history['bvrs'] = $bvrs;
$diamond_purchased_history['valid_request'] = $valid_request;
$diamond_purchased_history['level'] = $level;
$success = ConnectionFactory::InsertIntoTableBasic("diamond_purchased_history", $diamond_purchased_history);
return $success;
}
public function insertCode($soldierCode)
{
$params['code'] = $soldierCode;
$query = ConnectionFactory::InsertIntoTableBasic("soldier_code", $params);
if ($query == 1) {
$backupSoldierCode = new SoldierCodeBackup();
if (!$backupSoldierCode->backupCodeExist($soldierCode)) {
if ($backupSoldierCode->insertCode($soldierCode)) {
return true;
} else {
deleteCode($soldierCode);
return false;
}
} else {
deleteCode($soldierCode);
return false;
}
} else {
return false;
}
}
public static function createUser($name)
{
$userparams = array();
$userparams['name'] = $name;
$justAddedID = ConnectionFactory::InsertIntoTableBasicReturnInsertID("users", $userparams);
if ($justAddedID) {
$usercitiesparams = array();
$usercitiesparams['user_id'] = $justAddedID;
$usercitiesparams['city_id'] = 1;
$usercitiesparams['rank_avail'] = 1;
$success = ConnectionFactory::InsertIntoTableBasic("users_cities", $usercitiesparams);
if ($success) {
return self::getUser($justAddedID);
}
}
return NULL;
}
public function insertCode($soldierCode)
{
$params['code'] = $soldierCode;
$query = ConnectionFactory::InsertIntoTableBasic("soldier_code_backup", $params);
return $query;
}
public function postBroadcastMessage($content)
{
$params = array();
$params['sender_id'] = $this->id;
$params['content'] = $content;
//$params['time_posted'] = strftime('%c');
$success = ConnectionFactory::InsertIntoTableBasic("broadcast", $params);
return $success;
}
