prepare("SELECT MAX(strank) FROM gwsubtitles WHERE titlenameid = ?");
$trank->bind_param("i", $_POST['tid']);
$trank->execute();
$trank->store_result();
$trank->bind_result($gwstmr);
while ($trank->fetch()) {
if (is_null($gwstmr)) {
$tr = 1;
} else {
$tr = $gwstmr + 1;
}
}
}
$stmtname = $con->prepare("SELECT titlename, titlemaxrank FROM gwtitles WHERE titlenameid = ?");
$stmtname->bind_param("i", $_POST['tid']);
$stmtname->execute();
$stmtname->store_result();
$stmtname->bind_result($gwtn, $gwtmr);
while ($stmtname->fetch()) {
echo 'Adding rank to title ' . $gwtn . ' The maximum rank achievable in game is ' . $gwtmr . ' ';
if ($tr > $gwtmr) {
echo ' No more ranks can be added!
';
} else {
echo ' ';
}
}
$stmtname->free_result();
$stmtname->close();
echo 'Here are the currently associated title ranks, starting with rank 1: ';
echo ' If anything looks off, please fix it!