logoutuser($id);
redirect('char.php?user='******'Player demoted');
} elseif (isset($_POST['ban'])) {
if ($user['banned'] || $user['group_id'] <= PUN_MOD) {
message($lang_common['Bad request']);
}
$db->query('UPDATE ' . $db->prefix . 'rscd_players SET `banned`=1 WHERE `user`=' . $db->escape($id)) or error('Unable to ban player', __FILE__, __LINE__, $db->error());
logoutuser($id);
redirect('char.php?user='******'Player banned');
} else {
if (isset($_POST['unban'])) {
if (!$user['banned'] || $user['group_id'] <= PUN_MOD) {
message($lang_common['Bad request']);
}
$db->query('UPDATE ' . $db->prefix . 'rscd_players SET `banned`=0 WHERE `user`=' . $db->escape($id)) or error('Unable to unban player', __FILE__, __LINE__, $db->error());
logoutuser($id);
redirect('char.php?user='******'Player unbanned');
} else {
message($lang_common['Bad request']);
}
}
}
$rank = $user['g_title'];
if ($user['banned'] == '1' || isset($user['b_id'])) {
$rank = 'Banned';
} elseif ($user['playermod'] == '1') {
$rank = 'Player Mod';
}
$result = $db->query('SELECT COUNT(DISTINCT `killed`) FROM ' . $db->prefix . 'rscd_kills WHERE user='******'Unable to count kills', __FILE__, __LINE__, $db->error());
$kills = $db->result($result);
if ($xml) {
$db->query('DELETE FROM ' . $db->prefix . 'invites WHERE owner=' . $id) or error('Unable to remove users invites', __FILE__, __LINE__, $db->error());
if (isset($_POST['delete_chars'])) {
@set_time_limit(0);
// Delete their bank
$db->query('DELETE FROM ' . $db->prefix . 'rscd_bank WHERE `owner`=' . $id) or error('Unable to delete rscd_bank', __FILE__, __LINE__, $db->error());
// Delete any characters they have
$result = $db->query('SELECT `user` FROM ' . $db->prefix . 'rscd_players WHERE `owner`=' . $id) or error('Unable to fetch player info', __FILE__, __LINE__, $db->error());
while ($char = $db->fetch_assoc($result)) {
$db->query('DELETE FROM ' . $db->prefix . 'rscd_curstats WHERE `user`=' . $db->escape($char['user'])) or error('Unable to delete rscd_curstats', __FILE__, __LINE__, $db->error());
$db->query('DELETE FROM ' . $db->prefix . 'rscd_experience WHERE `user`=' . $db->escape($char['user'])) or error('Unable to delete rscd_experience', __FILE__, __LINE__, $db->error());
$db->query('DELETE FROM ' . $db->prefix . 'rscd_friends WHERE `user`=' . $db->escape($char['user']) . ' OR `friend`=' . $db->escape($char['user'])) or error('Unable to delete rscd_friends', __FILE__, __LINE__, $db->error());
$db->query('DELETE FROM ' . $db->prefix . 'rscd_ignores WHERE `user`=' . $db->escape($char['user']) . ' OR `ignore`=' . $db->escape($char['user'])) or error('Unable to delete rscd_ignores', __FILE__, __LINE__, $db->error());
$db->query('DELETE FROM ' . $db->prefix . 'rscd_invitems WHERE `user`=' . $db->escape($char['user'])) or error('Unable to delete rscd_invitems', __FILE__, __LINE__, $db->error());
$db->query('DELETE FROM ' . $db->prefix . 'rscd_players WHERE `user`=' . $db->escape($char['user'])) or error('Unable to delete rscd_players', __FILE__, __LINE__, $db->error());
$db->query('DELETE FROM ' . $db->prefix . 'rscd_reports WHERE `from`=' . $db->escape($char['user']) . ' OR `about`=' . $db->escape($char['user'])) or error('Unable to delete rscd_reports', __FILE__, __LINE__, $db->error());
logoutuser($char['user']);
}
}
// Should we delete all posts made by this user?
if (isset($_POST['delete_posts'])) {
require PUN_ROOT . 'include/search_idx.php';
@set_time_limit(0);
// Find all posts made by this user
$result = $db->query('SELECT p.id, p.topic_id, t.forum_id FROM ' . $db->prefix . 'posts AS p INNER JOIN ' . $db->prefix . 'topics AS t ON t.id=p.topic_id INNER JOIN ' . $db->prefix . 'forums AS f ON f.id=t.forum_id WHERE p.poster_id=' . $id) or error('Unable to fetch posts', __FILE__, __LINE__, $db->error());
if ($db->num_rows($result)) {
while ($cur_post = $db->fetch_assoc($result)) {
// Determine whether this post is the "topic post" or not
$result2 = $db->query('SELECT id FROM ' . $db->prefix . 'posts WHERE topic_id=' . $cur_post['topic_id'] . ' ORDER BY posted LIMIT 1') or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());
if ($db->result($result2) == $cur_post['id']) {
delete_topic($cur_post['topic_id']);
} else {
