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 {