function charbar($charname)
{
global $sqlc;
if (charclass($charname) == "Warrior") {
$query = $sqlc->query("SELECT power2 FROM characters WHERE name='{$charname}'");
$res = $sqlc->fetch_assoc($query);
if ($res['power2'] == null) {
$level = 0;
} else {
$level = $res['power2'];
}
return '<div id="char_rage">Rage: ' . $level . '</div>';
} elseif (charclass($charname) == "Hunter") {
$query = $sqlc->query("SELECT power3 FROM characters WHERE name='{$charname}'");
$res = $sqlc->fetch_assoc($query);
if ($res['power3'] == null) {
$level = 0;
} else {
$level = $res['power3'];
}
return '<div id="char_focus">Focus: ' . $level . '</div>';
} elseif (charclass($charname) == "Death Knight") {
$query = $sqlc->query("SELECT power7 FROM characters WHERE name='{$charname}'");
$res = $sqlc->fetch_assoc($query);
if ($res['power7'] == null) {
$level = 0;
} else {
$level = $res['power7'];
}
return '<div id="char_rune">Runic Power: ' . $level . '</div>';
} else {
$query = $sqlc->query("SELECT power1 FROM characters WHERE name='{$charname}'");
$res = $sqlc->fetch_assoc($query);
if ($res['power1'] == null) {
$level = 0;
} else {
$level = $res['power1'];
}
return '<div id="char_mana">Mana: ' . $level . '</div>';
}
}
<div class="contentbox_title">Character Info: ' . $character['name'] . '</div>
<div class="contentbox_body">
<ul id="tabnav">
<li><a href="#" id="tabnav-current">Character</a></li>
<li><a href="characters.php?action=reputation&id=' . $character['guid'] . '">Reputation</a></li>
<li><a href="characters.php?action=skills&id=' . $character['guid'] . '">Skills</a></li>
<li><a href="characters.php?action=talents&id=' . $character['guid'] . '">Talents</a></li>
</ul>
<div id="tabcontent">
<div id="char_panel">
<div id="char_maininfo">
<h3><span id="char_name">' . $character['name'] . '</span> <br />
<span id="char_guild">' . getguildbychar($character['name']) . '</span></h3>
<span id="char_level">Level ' . $character['level'] . '</span>
<span id="char_race">' . charrace($character['name']) . '</span>
<span id="char_class">' . charclass($character['name']) . '</span><br />
<span id="char_location">' . getcharlocation($character['guid']) . '</span> <br />
<div id="char_health">Health: ' . charhealth($character['name']) . '</div>';
$output .= charbar($character['name']);
$output .= '</div>
<div style="float:left">
<!-- generate icon urls inside of ins style attribute-->' . "\n";
$output .= getequip($character['guid'], 0) . "\n";
$output .= getequip($character['guid'], 1) . "\n";
$output .= getequip($character['guid'], 2) . "\n";
$output .= getequip($character['guid'], 14) . "\n";
$output .= getequip($character['guid'], 4) . "\n";
$output .= getequip($character['guid'], 3) . "\n";
$output .= getequip($character['guid'], 18) . "\n";
$output .= getequip($character['guid'], 8) . "\n";
$output .= '</div>
