function load($ID)
{
//check ID is not blank and exists and such
$db = DB::GetConn();
$id_con = $db->quoteInto("ID = ?", $ID);
$getQuery = "SELECT * FROM `User` WHERE {$id_con} limit 1;";
$res = $db->query($getQuery);
$obj = $res->fetchObject();
return User::loadUserFromObject($obj);
}
function getTop10ByKillToDeathRatio()
{
$db = DB::GetConn();
$getQuery = "SELECT *, `kills` / (`deaths` + 1) AS KtoD FROM `User` WHERE `ID` <> 146 ORDER BY `KtoD` DESC LIMIT 10;";
$res = $db->query($getQuery);
//execute query
$returnUsers = array();
while ($obj = $res->fetchObject()) {
array_push($returnUsers, User::loadUserFromObject($obj));
}
return $returnUsers;
}
