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