public static function createFromSQLWithUser($db_field) { if (!empty($db_field)) { $bot = GameBots::createFromSQL($db_field); $bot->user = GameUsers::createFromSQL($db_field); return $bot; } return null; }
public static function getUsersProfileByLostLeftGame($minMatch, $minRatio) { $SQL = "SELECT users.*,(( users.lostCountConnectionLostGame / users.lostGameCount ) *100 ) AS ratio FROM " . TBL_GAME_USERS . " AS users WHERE users.lostGameCount>" . $minMatch . " AND (( users.lostCountConnectionLostGame / users.lostGameCount ) *100 )>" . $minRatio . " ORDER BY ratio DESC"; $query = mysql_query($SQL, DBUtils::getManualConnection()); if (!empty($query)) { $users = array(); while ($db_field = mysql_fetch_assoc($query)) { $user = GameUsers::createFromSQL($db_field); if (!empty($user)) { $obj = new stdClass(); $obj->user = $user; $obj->ratio = 0; if (isset($db_field["ratio"])) { $obj->ratio = $db_field["ratio"]; } array_push($users, $obj); } } if (!empty($users) && sizeof($users) > 0) { return $users; } return null; } }
public static function getUserListOrderBy($str, $index, $limit) { $SQL = "SELECT * FROM " . TBL_GAME_USERS . " ORDER BY " . $str . " LIMIT " . $index . " , " . $limit; $query = mysql_query($SQL, DBUtils::getManualConnection()); if (!empty($query)) { $users = array(); while ($db_field = mysql_fetch_assoc($query)) { $user = GameUsers::createFromSQL($db_field); if (!empty($user)) { array_push($users, $user); } } if (!empty($users) && sizeof($users) > 0) { return $users; } } }