prepare("SELECT titlenameid FROM gwtitles WHERE gwamm = 1");
$ggid->execute();
$ggid->bind_result($gwammid);
$ggid->fetch();
$ggid->close();
// $rg = Remove GWAMM
$rg = $con->prepare("UPDATE gwtitles SET gwamm = 0 WHERE titlenameid = ?");
$rg->bind_param("i", $gwammid);
$rg->execute();
$rg->close();
}
$stmtins = $con->prepare("INSERT INTO gwtitles (titlename, titletype, titlemaxrank, autofilled, gwamm) VALUES (?, ?, ?, ?, ?)");
$stmtins->bind_param("siiii", $_POST['titlename'], $_POST['titletype'], $_POST['titlemaxrank'], $_POST['autofill'], $_POST['gwamm']);
$stmtins->execute();
$stmtins->close();
echo 'New title added!
';
$stmtview = $con->prepare("SELECT * FROM gwtitles ORDER BY titlenameid DESC LIMIT 1");
$stmtview->execute();
$result = $stmtview->get_result();
while ($row = $result->fetch_assoc()) {
$tid = $row['titlenameid'];
$tname = $row['titlename'];
$ttype = $row['titletype'];
$tmr = $row['titlemaxrank'];
$taf = $row['autofilled'];
echo '| titleid | titlename | titletype | titlemaxrank | autofilled |
|---|
';
echo '| ' . $tid . ' | ' . $tname . ' | ' . $ttype . ' | ' . $tmr . ' | ' . $taf . ' |
';
}
$stmtview->close();
echo 'Return to title manager';
}
?>