public function codeExist($code) { $statement = ConnectionFactory::SelectAsStatementHandler("SELECT * FROM soldier_code WHERE code = ?", array($code)); $count = $statement->rowCount(); if ($count == 0) { return false; } else { return true; } }
public static function getMissionRequiredItemsIDsToQuantity($missionID) { $query = "SELECT missions_itemreqs.item_quantity, items.id FROM missions_itemreqs JOIN items ON " . "(missions_itemreqs.item_id = items.id) WHERE missions_itemreqs.mission_id = ?"; $itemSth = ConnectionFactory::SelectAsStatementHandler($query, array($missionID)); $itemIDsToQuantity = array(); while ($row = $itemSth->fetch(PDO::FETCH_ASSOC)) { $itemID = $row["id"]; $itemIDsToQuantity[$itemID] = $row["item_quantity"]; } return $itemIDsToQuantity; }
public function invitePlayer($inviteeAgencyCode) { $userIDQuery = "SELECT id FROM users WHERE agency_code = ?"; $userIDSth = ConnectionFactory::SelectAsStatementHandler($userIDQuery, array($inviteeAgencyCode)); $userIDRow = $userIDSth->fetch(PDO::FETCH_ASSOC); if ($userIDRow) { $inviteeID = $userIDRow['id']; $success = ConnectionFactory::InsertIgnoreIntoTableBasic("agencies", array('user_one_id' => $this->id, 'user_two_id' => $inviteeID, 'accepted' => 0)); if (!$success) { return "fail"; } else { return "success"; } } else { return "noUserWithAgencyCode"; } }
public static function isUSerExists($user_id) { $user_data = ConnectionFactory::SelectAsStatementHandler("SELECT user_id FROM user_timers WHERE user_id = ? ", array($user_id)); if ($user_data->rowCount() > 0) { return true; } else { return false; } }
public static function SelectRowAsAssociativeArray($query, $values) { $sth = ConnectionFactory::SelectAsStatementHandler($query, $values); return $sth->fetch(); }
public function invitePlayerUsingLvl6id($lvl6id) { $userIDQuery = "SELECT id FROM users WHERE id = ?"; $userIDSth = ConnectionFactory::SelectAsStatementHandler($userIDQuery, array($lvl6id)); $userIDRow = $userIDSth->fetch(PDO::FETCH_ASSOC); if ($userIDRow) { $inviteeID = $userIDRow['id']; $already_existing_check = "Select count(0) as numrows FROM agencies WHERE user_one_id = {$this->id} AND user_two_id = {$inviteeID} OR user_one_id = {$inviteeID} AND user_two_id = {$this->id}"; $counter = ConnectionFactory::executeQuerySimple($already_existing_check); if ($counter > 0) { return "alreadyExisting"; } $success = ConnectionFactory::InsertIgnoreIntoTableBasic("agencies", array('user_one_id' => $this->id, 'user_two_id' => $inviteeID, 'accepted' => 0)); if (!$success) { return "fail"; } else { return "success"; } } else { return "noUserWithLvl6id"; } }