114 lines
4.4 KiB
PHP
114 lines
4.4 KiB
PHP
<?php
|
|
if ($GLOBALS['loggedIn'] == true) {
|
|
// This awards badges or removes them.
|
|
|
|
if ($GLOBALS['userTable']['rank'] == 1) {
|
|
// Check if the admin badge is owned
|
|
$stmt = $GLOBALS['dbcon']->prepare("SELECT id FROM badges WHERE uid = :uid AND badgeId = 2");
|
|
$stmt->bindParam(':uid', $GLOBALS['userTable']['id'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
if ($stmt->rowCount() == 0) {
|
|
// Award badge
|
|
$query = "INSERT INTO badges (`uid`, `badgeId`) VALUES (:uid, 2);";
|
|
$stmt = $GLOBALS['dbcon']->prepare($query);
|
|
$stmt->bindParam(':uid', $_COOKIE['auth_uid'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
}
|
|
|
|
// Check if the moderator badge is owned
|
|
$stmt = $GLOBALS['dbcon']->prepare("SELECT id FROM badges WHERE uid = :uid AND badgeId = 3");
|
|
$stmt->bindParam(':uid', $GLOBALS['userTable']['id'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
if ($stmt->rowCount() == 0) {
|
|
// Award badge
|
|
$query = "INSERT INTO badges (`uid`, `badgeId`) VALUES (:uid, 3);";
|
|
$stmt = $GLOBALS['dbcon']->prepare($query);
|
|
$stmt->bindParam(':uid', $_COOKIE['auth_uid'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
}
|
|
}
|
|
|
|
if ($GLOBALS['userTable']['rank'] == 2) {
|
|
// Check if the moderator badge is owned
|
|
$stmt = $GLOBALS['dbcon']->prepare("SELECT id FROM badges WHERE uid = :uid AND badgeId = 3");
|
|
$stmt->bindParam(':uid', $GLOBALS['userTable']['id'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
if ($stmt->rowCount() == 0) {
|
|
// Award badge
|
|
$query = "INSERT INTO badges (`uid`, `badgeId`) VALUES (:uid, 3);";
|
|
$stmt = $GLOBALS['dbcon']->prepare($query);
|
|
$stmt->bindParam(':uid', $_COOKIE['auth_uid'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
}
|
|
|
|
// Remove admin badge if any
|
|
$query = "DELETE FROM badges WHERE badgeId = 2 AND uid = :uid";
|
|
$stmt = $GLOBALS['dbcon']->prepare($query);
|
|
$stmt->bindParam(':uid', $_COOKIE['auth_uid'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
}
|
|
|
|
if ($GLOBALS['userTable']['rank'] == 0) {
|
|
// Remove staff badges if any
|
|
$query = "DELETE FROM badges WHERE badgeId = 2 AND uid = :uid";
|
|
$stmt = $GLOBALS['dbcon']->prepare($query);
|
|
$stmt->bindParam(':uid', $_COOKIE['auth_uid'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
|
|
$query = "DELETE FROM badges WHERE badgeId = 3 AND uid = :uid";
|
|
$stmt = $GLOBALS['dbcon']->prepare($query);
|
|
$stmt->bindParam(':uid', $_COOKIE['auth_uid'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
}
|
|
|
|
// Check if the member badge is owned
|
|
$stmt = $GLOBALS['dbcon']->prepare("SELECT id FROM badges WHERE uid = :uid AND badgeId = 5");
|
|
$stmt->bindParam(':uid', $GLOBALS['userTable']['id'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
if ($stmt->rowCount() == 0) {
|
|
// Award badge
|
|
$query = "INSERT INTO badges (`uid`, `badgeId`) VALUES (:uid, 5);";
|
|
$stmt = $GLOBALS['dbcon']->prepare($query);
|
|
$stmt->bindParam(':uid', $_COOKIE['auth_uid'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
}
|
|
|
|
// Get forum post count
|
|
$postCount = $GLOBALS['userTable']['posts'];
|
|
$stmt = $GLOBALS['dbcon']->prepare("SELECT id FROM badges WHERE uid = :uid AND badgeId = 4");
|
|
$stmt->bindParam(':uid', $GLOBALS['userTable']['id'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
if ($stmt->rowCount() == 0 and $postCount > 999) {
|
|
// Award badge
|
|
$query = "INSERT INTO badges (`uid`, `badgeId`) VALUES (:uid, 4);";
|
|
$stmt = $GLOBALS['dbcon']->prepare($query);
|
|
$stmt->bindParam(':uid', $_COOKIE['auth_uid'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
}else{
|
|
if ($postCount < 1000) {
|
|
$query = "DELETE FROM badges WHERE badgeId = 4 AND uid = :uid";
|
|
$stmt = $GLOBALS['dbcon']->prepare($query);
|
|
$stmt->bindParam(':uid', $_COOKIE['auth_uid'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
}
|
|
}
|
|
|
|
$stmt = $GLOBALS['dbcon']->prepare("SELECT id FROM badges WHERE uid = :uid AND badgeId = 7");
|
|
$stmt->bindParam(':uid', $GLOBALS['userTable']['id'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
if ($stmt->rowCount() == 0 and $GLOBALS['userTable']['id'] < 101) {
|
|
// Award badge
|
|
$query = "INSERT INTO badges (`uid`, `badgeId`) VALUES (:uid, 7);";
|
|
$stmt = $GLOBALS['dbcon']->prepare($query);
|
|
$stmt->bindParam(':uid', $_COOKIE['auth_uid'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
}else{
|
|
if ($GLOBALS['userTable']['id'] > 100) {
|
|
$query = "DELETE FROM badges WHERE badgeId = 7 AND uid = :uid";
|
|
$stmt = $GLOBALS['dbcon']->prepare($query);
|
|
$stmt->bindParam(':uid', $_COOKIE['auth_uid'], PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
}
|
|
}
|
|
}
|
|
?>
|