public static function findByDivision($game_id, $limit = false) { if (!$limit) { $limit = 10; } return arrayToObject(Flight::aod()->from(self::$table)->where(array("member.game_id" => $game_id))->limit($limit)->sortDesc('date')->join('actions', array('actions.id' => 'user_actions.type_id'))->join('member', array('member.member_id' => 'user_actions.target_id'))->select(array('date', 'user_id', 'type_id', 'target_id', 'verbage', 'icon'))->many()); }
public static function delete($id) { $pt = self::find(array('id' => $id)); if (count($pt)) { Flight::aod()->remove($pt); } return (bool) Flight::aod()->affected_rows; }
public static function findSquadMembers($squad_id, $div_struc_sort = false, $recruiter = false) { $conditions = $recruiter ? array('squad_id' => $squad_id, 'position_id' => 6, 'recruiter !%' => $recruiter, 'status_id @' => array(1, 3, 999)) : array('squad_id' => $squad_id, 'position_id' => 6, 'status_id @' => array(1, 3, 999)); if ($div_struc_sort) { return Flight::aod()->from(Member::$table)->where($conditions)->sortDesc('rank_id')->sortAsc('forum_name')->many(); } else { return Flight::aod()->from(Member::$table)->where($conditions)->sortAsc('last_activity')->many(); } }
public static function findHandle($member_id, $type) { $params = Flight::aod()->using('MemberHandle')->where(array('member_id' => $member_id, 'handle_type' => $type))->find(); if (is_object($params)) { $handle = Handle::findByType($params->handle_type); $params->handle_name = $handle->type; $params->name = $handle->name; $params->isInvalid = (bool) $params->invalid; $params->isVisible = (bool) $handle->show_on_profile; if (!is_null($handle->url)) { $params->url = $handle->url; } } return $params; }
function _doBattlelogIdUpdate() { $members = array(); $battlelog_names = objectToArray(Member::find(array('status_id' => 1, 'battlelog_name !%' => 0, 'battlelog_id' => 0))); $countNames = count($battlelog_names); echo "Fetched battlelog names. ({$countNames})<br /><br />"; foreach ($battlelog_names as $row) { $battlelog_id = Member::getBattlelogId($row['battlelog_name']); if (!$battlelog_id['error']) { $sql = "UPDATE member SET battlelog_id = {$battlelog_id['id']} WHERE battlelog_name = '{$row['battlelog_name']}'"; Flight::aod()->sql($sql)->one(); echo "Added ID {$battlelog_id['id']} to {$row['battlelog_name']}<br />"; } else { echo "ERROR: {$row['battlelog_name']} - {$battlelog_id['message']}<br />"; } } echo "done syncing battlelog ids."; }
public static function remove($member_id) { $flag = self::find(array('member_id' => $member_id)); Flight::aod()->remove($flag); }
public static function findAll($game_id) { return Flight::aod()->using('RecruitingTask')->where(array('game_id @' => array(0, $game_id)))->sortDesc('game_id')->sortAsc('sort_order')->find(); }
public static function modify($params) { $member = new self(); foreach ($params as $key => $value) { $member->{$key} = $value; } $member->update($params); return Flight::aod()->affected_rows; }
public static function resetValidation($email) { $user = self::find(array('email' => $email)); if (empty($user)) { return false; } else { $user->validation = md5(time() . rand()); $user->validated = 0; Flight::aod()->save($user); Email::validate($user); return true; } }
public static function recruitingByTheMonth($game_id) { $sql = "SELECT DATE(DATE_FORMAT(date, '%Y-%m-01')) AS month_beginning, count( * ) AS count\n\t\t\t\tFROM user_actions\n\t\t\t\tJOIN member ON member.member_id = user_actions.user_id\n\t\t\t\tWHERE member.game_id = {$game_id}\n\t\t\t\tAND date > DATE_SUB(NOW(), INTERVAL 4 MONTH)\n\t\t\t\tAND type_id = 1\n\t\t\t\tGROUP BY DATE(DATE_FORMAT(date, '%Y-%m-01'))\n\t\t\t\tORDER BY DATE(DATE_FORMAT(date, '%Y-%m-01'))"; $params = Flight::aod()->sql($sql)->many(); return objectToArray($params); }
public static function findByName($name, $game_id) { $data = Flight::aod()->using('RecruitingString'); return $data->find(['name' => $name, 'game_id' => $game_id]); }
public static function delete($id) { $pt = self::find($id); Flight::aod()->remove($pt); }
echo $js; ?> .js"></script> <?php } if (!empty($extrajs) && is_array($extrajs)) { foreach ($extrajs as $js) { if (isset($js) && file_exists("assets/js/{$js}.js")) { ?> <script src="assets/js/<?php echo $js; ?> .js"></script> <?php } } } ?> <?php // debug information if (isset($_SESSION['userid'])) { Flight::aod()->show_sql = true; error_reporting(E_ALL); ini_set('display_errors', '1'); } ?> </body> </html>
public static function get_number_from_id($platoon_id) { $sql = "SELECT number FROM " . Platoon::$table . " WHERE id = {$platoon_id}"; $params = Flight::aod()->sql($sql)->one(); return $params['number']; }
/** * fetch all alerts not seen by user * @return array array of alerts */ public static function find_all($user) { $sql = "SELECT DISTINCT * FROM " . self::$table . " WHERE start_date < CURRENT_TIMESTAMP AND end_date > CURRENT_TIMESTAMP AND NOT EXISTS ( SELECT * FROM " . AlertStatus::$table . " WHERE alert_id = alerts.id AND user_id = {$user} )"; $params = Flight::aod()->sql($sql)->many(); return arrayToObject($params); }
public static function toplistMonthlyAODTotal() { $sql = "SELECT round((SELECT count(*) FROM " . self::$table . " a WHERE (server LIKE '%AOD%') AND a.datetime BETWEEN DATE_SUB(NOW(), INTERVAL 30 day) AND CURRENT_TIMESTAMP) / count(*)*100, 1) as pct FROM " . self::$table . " a WHERE a.datetime BETWEEN DATE_SUB( NOW(), INTERVAL 30 day ) AND CURRENT_TIMESTAMP"; $params = Flight::aod()->sql($sql)->one(); return $params['pct']; }
public static function count_all() { $results = Flight::aod()->using(get_called_class())->sql("SELECT * FROM " . static::$table)->count(); return is_object($results) ? array($results) : $results; }
public static function totalCount($game_id) { $sql = "SELECT count(*) as count FROM " . Member::$table . " WHERE member.game_id = {$game_id} AND status_id IN (1,3,999)"; return arrayToObject(Flight::aod()->sql($sql)->one()); }
public static function getGamesPlayed($member) { return Flight::aod()->from(self::$table)->where(array('member_id' => $member->id, 'game_id' => $member->game_id))->join('subgames', array('subgames.id' => self::$table . '.subgame_id'))->select('subgames.short_name')->many(); }
public static function delete($loa_id) { $loa = self::find($loa_id); Flight::aod()->remove($loa); return array('success' => true); }