function loadHero($ID)
{
//check ID is not blank and exists and such
$db = DB::GetConn();
$id_con = $db->quoteInto("ID = ?", $ID);
$getQuery = "SELECT * FROM `Hero` WHERE {$id_con} limit 1;";
$res = $db->query($getQuery);
$obj = $res->fetchObject();
$returnHero = Hero::loadHeroFromObject($obj);
$returnHero->checkFightCooldown();
return $returnHero;
}
function getTop10ByKills()
{
$db = DB::GetConn();
$getQuery = "SELECT * FROM `Hero` ORDER BY `Hero`.`Kills` DESC LIMIT 10;";
$res = $db->query($getQuery);
//execute query
$returnHeroes = array();
while ($obj = $res->fetchObject()) {
array_push($returnHeroes, Hero::loadHeroFromObject($obj));
}
return $returnHeroes;
}
