execute(" SELECT ban_ip FROM arrowchat_banlist WHERE ban_ip = '" . $db->escape_string($addy) . "' "); if ($result AND $db->count_select() > 0) { $error = "This IP is already banned."; } if (empty($_POST['ban_ip_submit'])) { $error = "You must enter an IP to ban."; } if (empty($error)) { $result = $db->execute(" INSERT INTO arrowchat_banlist (ban_ip, banned_by, banned_time) VALUES ('" . $db->escape_string($addy) . "', '0', '" . time() . "') "); if (!$result) { $error = "There was a database error. Please try again."; } } } if (empty($error)) { $msg = "IPs successfully banned."; update_config_file(); } } // Unban IP Submit Processor if (var_check('unban_ip_submit')) { $ips = get_var('unban_ip'); if ($ips) { foreach ($ips as $unbans) { $result = $db->execute(" DELETE FROM arrowchat_banlist WHERE ban_id = '" . $unbans . "' "); if (!$result) { $error = "There was a database error"; } } if (empty($error)) { $msg = "The IPs were successfully unbaned."; update_config_file(); } } else { $error = "You did not select any IPs"; } } // Ban Username Submit Processor if (var_check('ban_username_submit')) { $usernames = explode("\\r\\n", get_var('ban_username')); foreach ($usernames as $username) { $result = $db->execute(" SELECT " . DB_USERTABLE_USERID . " FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE LOWER(" . DB_USERTABLE_NAME . ") = '" . strtolower($db->escape_string($username)) . "' "); $row = $db->fetch_array($result); if (!$result OR $db->count_select() < 1) { $error = "We could not find a user with that username."; } $result = $db->execute(" SELECT ban_userid FROM arrowchat_banlist WHERE ban_userid = '" . $row[DB_USERTABLE_USERID] . "' "); if ($result AND $db->count_select() > 0) { $error = "This username is already banned."; } if (empty($error)) { $result = $db->execute(" INSERT INTO arrowchat_banlist (ban_userid, banned_by, banned_time) VALUES ('" . $row[DB_USERTABLE_USERID] . "', '0', '" . time() . "') "); if ($result) { $msg = "Usernames successfully banned."; update_config_file(); } else { $error = "There was a database error. Please try again."; } } } } // Unban Username Submit Processor if (var_check('unban_username_submit')) { $usernames = get_var('unban_username'); if ($usernames) { foreach ($usernames as $unbans) { $result = $db->execute(" DELETE FROM arrowchat_banlist WHERE ban_id = '" . $db->escape_string($unbans) . "' "); if ($result) { $msg = "The Usernames were successfully unbaned."; update_config_file(); } else { $error = "There was a database error"; } } } else { $error = "You did not select any IPs"; } } // User Edit Submit Processor if (var_check('user_submit') && $is_admin == 1) { $result = $db->execute(" SELECT session_time FROM arrowchat_status WHERE userid = '" . get_var('user_id') . "' "); if ($result AND $db->count_select() > 0) { } else { $hash_id = random_string(); $db->execute(" INSERT INTO arrowchat_status (userid, chatroom_window, chatroom_stay, hash_id, session_time, ip_address) VALUES ('" . $db->escape_string(get_var('user_id')) . "', '-1', '0', '" . $hash_id . "', '" . time() . "', '0') "); } $result = $db->execute(" UPDATE arrowchat_status SET play_sound = '" . get_var('play_sound') . "', window_open = '" . get_var('window_open') . "', only_names = '" . get_var('only_names') . "', announcement = '" . get_var('announcement') . "', is_mod = '" . get_var('is_mod') . "' WHERE userid = '" . get_var('user_id') . "' "); if ($result) { $play_sound = get_var('play_sound'); $window_open = get_var('window_open'); $only_names = get_var('only_names'); $announcement = get_var('announcement'); $is_moderator = get_var('is_mod'); if (empty($is_moderator)) { $db->execute(" UPDATE arrowchat_chatroom_users SET is_mod = '0' WHERE user_id = '" . get_var('user_id') . "' "); } $msg = "User settings successfully saved."; } else { $error = "There was an error saving the user's settings."; } } // Delete Guest Name if (var_check('guest_name')) { $db->execute(" UPDATE arrowchat_status SET guest_name = NULL WHERE userid = '" . get_var('id') . "' "); if ($result) { $msg = "The user's name was deleted."; } else { $error = "There was an error deleting the user's name."; } } } else { die("No valid token"); } } require(dirname(__FILE__) . DIRECTORY_SEPARATOR . "layout/pages_header.php"); require(dirname(__FILE__) . DIRECTORY_SEPARATOR . "layout/pages_users.php"); require(dirname(__FILE__) . DIRECTORY_SEPARATOR . "layout/pages_footer.php"); ?>