Account wide stats';
echo '| Title | Title Rank | Title Points | Current Rank | Points Remaining | Max Title % | Next Rank |
|---|
';
// $gas = GetAccountStats
$gas = $con->prepare("SELECT * FROM gwstats WHERE charid = 0 AND userid = ? AND accid = ? ORDER BY percent DESC, currentstrank DESC, percent ASC");
$gas->bind_param("ii", $_SESSION['userid'], $_SESSION['prefaccid']);
$gas->execute();
$result = $gas->get_result();
while ($row = $result->fetch_assoc()) {
// $gnr = Get Next Rank
$gnr = $con->prepare("SELECT stpoints, stname FROM gwsubtitles WHERE titlenameid = ? AND stpoints >= ? ORDER BY stpoints ASC LIMIT 1");
$gnr->bind_param("ii", $row['titlenameid'], $row['titlepoints']);
$gnr->execute();
$gnr->bind_result($stpoints, $stname);
$gnr->fetch();
$gnr->close();
// $gt = Get Title
$gt = $con->prepare("SELECT titlename FROM gwtitles WHERE titlenameid = ?");
$gt->bind_param("i", $row['titlenameid']);
$gt->execute();
$gt->bind_result($titlename);
$gt->fetch();
$gt->close();
$pr = number_format(($stpoints - $row['titlepoints']));
if ($pr <= 0) {
$pr = "Highest rank achieved!";
$stname = "Highest rank achieved!";
}
if ($row['currentstrankname'] === NULL) {
$row['currentstrankname'] = "No title earned yet!";
$row['currentstrank'] = "0";
}
if ($row['percent'] >= 100) {
$ohp = 100;
} else {
$ohp = $row['percent'];
}
echo '| ' . $titlename . ' | ' . $row['currentstrankname'] . ' | ' . number_format($row['titlepoints']) . ' | ' . $row['currentstrank'] . ' | ';
echo '' . $pr . ' | ';
echo $ohp;
echo '% completed | ' . $stname . ' |
';
}
$gas->close();
echo '
';
}
?>