function showAllForUser($id)
{
$db = DB::GetConn();
$getQuery = "SELECT `ID` FROM `Hero` WHERE `OwnerID` = {$id};";
$res = $db->query($getQuery);
//execute query
echo "<table style='width: 100%;'>\n\t\t\t<tr>\n\t\t\t<td>Name</td>\n\t\t\t<!--<td>OwnerID</td>\n\t\t\t<td>PartyID</td>-->\n\t\t\t<td>Race</td>\n\t\t\t<td>Class</td>\n\t\t\t<td>HP</td>\n\t\t\t<td>Level</td>\n\t\t\t<td>XP</td>\n\t\t\t<td>Str</td>\n\t\t\t<td>Dex</td>\n\t\t\t<td>Con</td>\n\t\t\t<td>Int</td>\n\t\t\t<td>Wis</td>\n\t\t\t<td>Cha</td>\n\t\t\t<td>Weapon</td>\n\t\t\t<td>Level UP</td>\n\t\t\t<td>Revive</td>\n\t\t\t<td>Fight</td>\n\t\t\t</tr>";
$totalHeros = 0;
while ($obj = $res->fetchObject()) {
$Hero = new Hero();
$this->outputInTable($Hero->loadHero($obj->ID));
$totalHeros++;
}
echo "Showing " . $totalHeros . " results.<br />";
echo "</table>";
return $totalHeros;
}
