execute(" SELECT " . DB_USERTABLE_NAME . ", " . DB_USERTABLE_USERID . " FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string(get_var('id')) . "' "); $row = $db->fetch_array($result); $username = $row[DB_USERTABLE_NAME]; $username2 = $username; } ?>
Logs
[Edit this user]   
count_select() > 0) { $row = $db->fetch_array($result); ?>
's Chat Logs
execute(" SELECT arrowchat.to FROM arrowchat WHERE arrowchat.from = '" . $db->escape_string(get_var('id')) . "' GROUP BY arrowchat.to "); $i = 1; if ($result2 AND $db->count_select() > 0) { while ($row2 = $db->fetch_array($result2)) { if (check_if_guest($row2['to'])) { $username = $language[83] . " " . substr($row2['to'], 1); } else { $result3 = $db->execute(" SELECT " . DB_USERTABLE_NAME . " FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string($row2['to']) . "' "); $row3 = $db->fetch_array($result3); $username = $row3[DB_USERTABLE_NAME]; } ?> There is no user with that ID.
This user has never sent any chats.
execute(" SELECT " . DB_USERTABLE_NAME . ", " . DB_USERTABLE_USERID . " FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string(get_var('w')) . "' "); $result3 = $db->execute(" SELECT " . DB_USERTABLE_NAME . ", " . DB_USERTABLE_USERID . " FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string(get_var('id')) . "' "); $result = $db->execute(" SELECT * FROM arrowchat WHERE (arrowchat.to = '" . $db->escape_string(get_var('w')) . "' AND arrowchat.from = '" . $db->escape_string(get_var('id')) . "') OR (arrowchat.to = '" . $db->escape_string(get_var('id')) . "' AND arrowchat.from = '" . $db->escape_string(get_var('w')) . "') ORDER BY id ASC "); if ($result AND $db->count_select() > 0) { $row2 = $db->fetch_array($result2); $row3 = $db->fetch_array($result3); while ($row = $db->fetch_array($result)) { if ($row['from'] == get_var('w')) { if (check_if_guest(get_var('w'))) { $msg_username = $language[83] . " " . substr(get_var('w'), 1); } else { $msg_username = $row2[DB_USERTABLE_NAME]; } ?>
:
:
Oops, we found no chats to or from these users.
Last 20 Messages Sent By
[Edit this user]
execute(" SELECT * FROM arrowchat WHERE arrowchat.from = '" . $db->escape_string(get_var('id')) . "' ORDER BY arrowchat.id DESC LIMIT 20 "); if ($result AND $db->count_select() > 0) { ?> fetch_array($result)) { if (check_if_guest($row['to'])) { $usertable_name = $language[83] . " " . substr($row['to'], 1); } else { $result3 = $db->execute(" SELECT " . DB_USERTABLE_NAME . " FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string($row['to']) . "' "); $row3 = $db->fetch_array($result3); $usertable_name = $row3[DB_USERTABLE_NAME]; } ?> This user has no messages in the database.
Sent To Message
execute(" SELECT " . DB_USERTABLE_NAME . ", " . DB_USERTABLE_USERID . " FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string($request_id) . "' "); $row = $db->fetch_array($result); $username = $row[DB_USERTABLE_NAME]; } $result = $db->execute(" SELECT * FROM arrowchat_status WHERE userid = '" . $db->escape_string($request_id) . "' "); $row = $db->fetch_array($result); $status = $row['status']; $is_admin = $row['is_admin']; $is_mod = $row['is_mod']; $hide_bar = $row['hide_bar']; $play_sound = $row['play_sound']; $window_open = $row['window_open']; $only_names = $row['only_names']; $announcement = $row['announcement']; if ($status == "available" OR empty($status)) { if ((time() - $row['session_time']) < $online_timeout) { $status = "Available"; } else { $status = "Offline"; } } ?>
Edit ( )
Edit

Makes this user have administrator privileges.

Makes this user have moderator privileges.

Hide or show the ArrowChat bar for this user.

Choose whether this user has sounds enabled or disabled.

If checked, the user's buddy list will stay open.

If checked, the user's buddy list, chat, and chat rooms will not show avatars.

If checked, this will mark the user's announcement as read and it will not display.

Click Here

acg (ArrowChat Guest)

Delete User's Guest Name

Click the link above will remove the user's guest name and they will have the option to change it again.

Search
Manage Users

Enter the username or part of the username that you'd like to search for. You may also enter the user ID if known.

Enter the guest ID or guest name that you would like to search for.

execute(" SELECT " . DB_USERTABLE_NAME . ", " . DB_USERTABLE_USERID . " FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE LOWER(" . DB_USERTABLE_NAME . ") LIKE '%" . $db->escape_string(strtolower(get_var('username'))) . "%' OR " . DB_USERTABLE_USERID . " = '" . intval($db->escape_string(strtolower(get_var('username')))) . "' ORDER BY " . DB_USERTABLE_NAME . " ASC LIMIT 50 "); } else { $result = $db->execute(" SELECT " . DB_USERTABLE_NAME . ", " . DB_USERTABLE_USERID . " FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE LOWER(" . DB_USERTABLE_NAME . ") LIKE '%" . $db->escape_string(strtolower(get_var('username'))) . "%' OR " . DB_USERTABLE_USERID . " = '" . $db->escape_string(strtolower(get_var('username'))) . "' ORDER BY " . DB_USERTABLE_NAME . " ASC LIMIT 50 "); } ?>
Results
Search Results
    count_select() > 0 AND empty($_POST['guest_id'])) { while ($row = $db->fetch_array($result)) { ?>
  1. Logs Edit

       

  2. execute(" SELECT userid, guest_name FROM arrowchat_status WHERE userid LIKE 'g" . $db->escape_string(strtolower(get_var('guest_id'))) . "%' OR LOWER(guest_name) LIKE '%" . $db->escape_string(strtolower(get_var('guest_id'))) . "%' ORDER BY userid ASC LIMIT 50 "); if ($result AND $db->count_select() > 0) { while ($row = $db->fetch_array($result)) { ?>
  3. Logs Edit

       

  4. We didn't find any guests with that ID.

  5. We didn't find any usernames matching that search.

execute(" SELECT " . DB_USERTABLE_NAME . " FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string(get_var('aid')) . "' "); $row3 = $db->fetch_array($result3); $mod_username = $row3[DB_USERTABLE_NAME]; } ?>
Last 100 Warnings Given by
execute(" SELECT * FROM arrowchat_warnings WHERE warned_by = '" . $db->escape_string(get_var('aid')) . "' ORDER BY warning_time ASC LIMIT 100 "); if ($result AND $db->count_select() > 0) { while ($row = $db->fetch_array($result)) { if (check_if_guest($row['user_id'])) { $username = $language[83] . " " . substr($row['user_id'], 1); } else { $result3 = $db->execute(" SELECT " . DB_USERTABLE_NAME . " FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string($row['user_id']) . "' "); $row3 = $db->fetch_array($result3); $username = $row3[DB_USERTABLE_NAME]; } if ($row['user_read'] == 1) $is_read = 'Yes'; else $is_read = 'No'; ?>
Warned
User Read:
Warn Reason:
This user hasn't warned anyone yet.
Last 100 Bans Given by
execute(" SELECT * FROM arrowchat_banlist WHERE banned_by = '" . $db->escape_string(get_var('aid')) . "' ORDER BY banned_time ASC LIMIT 100 "); if ($result AND $db->count_select() > 0) { while ($row = $db->fetch_array($result)) { if (!empty($row['ban_userid'])) { if (check_if_guest($row['ban_userid'])) { $username = $language[83] . " " . substr($row['ban_userid'], 1); } else { $result3 = $db->execute(" SELECT " . DB_USERTABLE_NAME . " FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string($row['ban_userid']) . "' "); $row3 = $db->fetch_array($result3); $username = $row3[DB_USERTABLE_NAME]; } } else { $username = "N/A"; } ?>
Banned
IP Address:
This user hasn't banned anyone yet.
Last 100 Reports Completed by
execute(" SELECT * FROM arrowchat_reports WHERE completed_by = '" . $db->escape_string(get_var('aid')) . "' ORDER BY completed_time ASC LIMIT 100 "); if ($result AND $db->count_select() > 0) { while ($row = $db->fetch_array($result)) { if (!empty($row['report_about'])) { if (check_if_guest($row['report_about'])) { $username = $language[83] . " " . substr($row['report_about'], 1); } else { $result3 = $db->execute(" SELECT " . DB_USERTABLE_NAME . " FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string($row['report_about']) . "' "); $row3 = $db->fetch_array($result3); $username = $row3[DB_USERTABLE_NAME]; } } else { $username = "N/A"; } ?>
Report about closed
This user hasn't banned anyone yet.
Moderators
Current Moderators
Moderators have access to moderation options in chat rooms and are able to ban/warn users in the main chat.
    execute(" SELECT arrowchat_status.userid userid, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_NAME . " name FROM " . TABLE_PREFIX . DB_USERTABLE . " LEFT JOIN arrowchat_status ON " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " = arrowchat_status.userid WHERE arrowchat_status.is_mod = 1 ORDER BY arrowchat_status.userid ASC "); if ($result AND $db->count_select() > 0) { while ($row = $db->fetch_array($result)) { ?>
  1. Edit Logs View Actions

  2. There are currently no moderators

Administrators
Current Administrators
Administrators have the same access that moderators have as well as additional options available.
    execute(" SELECT arrowchat_status.userid userid, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_NAME . " name FROM " . TABLE_PREFIX . DB_USERTABLE . " LEFT JOIN arrowchat_status ON " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " = arrowchat_status.userid WHERE arrowchat_status.is_admin = 1 ORDER BY arrowchat_status.userid ASC "); if ($result AND $db->count_select() > 0) { while ($row = $db->fetch_array($result)) { ?>
  1. Edit Logs View Actions

  2. There are currently no administrators

Change Permissions
Add Moderator/Admin

Enter the username or part of the username that you'd like to make an admin or mod. You may also enter the user ID if known.

Enter the guest ID or guest name that you would like to make an admin or mod.

Groups
Group Permissions
Users that are set to groups from your main site can have their ArrowChat permissions set here.
  1. Change Permissions

    ()

  2. The groups feature is either not setup or your site does not have groups. You can setup groups in the includes/integration.php file.

ArrowChat Groups
ArrowChat Permissions
Any guest permissions above will not work. You must control guest permissions via the ArrowChat guest group.
  1. Change Permissions

    ArrowChat Guests (acg)

Group Permission Settings

Checking this will switch all group permissions from 'Disable {Feature}' to 'Enable {Feature}'.

WARNING: This will reset all group permissions. If checked, everyone will have ArrowChat disabled until permissions are enabled.

Edit
Edit

s ArrowChat for this group.

video chat for this group.

s all applications for this group.

s using chat rooms for this group.

s uploading files in private chat and chat rooms for this group.

Only users in this group will be able to send private messages. All others will be shown an error message that can be changed in the language file. Users in this group will be unable to send private messages and will be shown an error message that can be changed in the language file.

Only users in this group will be able to send chat room messages. All others will be shown an error message that can be changed in the language file. Users in this group will be unable to send chat room messages and will be shown an error message that can be changed in the language file.

Group Permissions
We could not find a group with that ID. There is most likely an error with the groups integration. Please check the includes/integration.php file.
Ban Usernames
Ban Usernames

Enter each username you would like to ban separated by a new line.

Remove Bans
Remove Bans

Select the usernames that you would like to unban. Hold Ctrl to select multiple names.

Ban IP Addresses
Ban IP Addresses

Enter each IP address you would like to ban separated by a new line.

Remove Bans
Remove Bans

Select the usernames that you would like to unban. Hold Ctrl to select multiple names.