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;
}
}
}
