$res = $db->query($getClassQuery);
//execute query
$ClassTableData = "['Class', 'Population'],";
while ($obj = $res->fetchObject()) {
$HeroClass = HeroClass::loadHeroClass($obj->Class);
$ClassTableData .= "['" . $HeroClass->Name . "', " . $obj->count . "],";
}
$ClassTableData = rtrim($ClassTableData, ",");
$smarty->assign("ClassTableData", $ClassTableData);
//get Race count
$getRaceQuery = "SELECT Race,COUNT(*) as count FROM Hero Where OwnerID <> 146 AND CurrentHP > 0 GROUP BY Race ORDER BY count DESC;";
$res = $db->query($getRaceQuery);
//execute query
$RaceTableData = "['Race', 'Population'],";
while ($obj = $res->fetchObject()) {
$HeroRace = Race::loadRace($obj->Race);
$RaceTableData .= "['" . $HeroRace->Name . "', " . $obj->count . "],";
}
$RaceTableData = rtrim($RaceTableData, ",");
$smarty->assign("RaceTableData", $RaceTableData);
//Get Level Count
$getLevelQuery = "SELECT Level,COUNT(*) as count FROM Hero Where OwnerID <> 146 AND CurrentHP > 0 GROUP BY Level ORDER BY Level ASC;";
$res = $db->query($getLevelQuery);
//execute query
$LevelTableData = "";
$i = 1;
$obj = $res->fetchObject();
while ($i <= 50) {
if ($obj != false) {
if ($obj->Level == $i) {
$LevelTableData .= "[" . $obj->Level . ", " . $obj->count . "],";
function GenerateRace()
{
//This is pretty terrible but it matches the DB for now
$human = Race::loadRace(1);
$dwarf = Race::loadRace(2);
$elf = Race::loadRace(3);
$halfling = Race::loadRace(4);
$races = array($human, $dwarf, $elf, $halfling);
$newRace = $races[rand(0, 3)];
return $newRace;
}
function GenerateRace()
{
//@TODO:Load all StarterRaces from race table and pick a random one.
$human = Race::loadRace(1);
$dwarf = Race::loadRace(2);
$elf = Race::loadRace(3);
$halfling = Race::loadRace(4);
$races = array($human, $human, $dwarf, $elf, $halfling);
$newRace = $races[rand(0, 4)];
return $newRace;
}
