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
Unlock this feature by purchasing an ArrowChat license
">

Makes this user have administrator privileges.

Unlock this feature by purchasing an ArrowChat license
">

Makes this user have moderator privileges.

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.

Unlock this feature by purchasing an ArrowChat license
">

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. This includes guest names that have been changed.

You can also search for the User's ID, if known. If you are searching for a guest user such as "Guest 12345", enter 12345 here.

execute(" SELECT " . DB_USERTABLE_NAME . " name, " . DB_USERTABLE_USERID . " userid FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE LOWER(" . DB_USERTABLE_NAME . ") LIKE '%" . $db->escape_string(strtolower($search_name)) . "%' OR " . DB_USERTABLE_USERID . " = '" . intval($db->escape_string(strtolower($search_name))) . "' ORDER BY " . DB_USERTABLE_NAME . " ASC LIMIT 50 "); } else { $result = $db->execute(" SELECT DISTINCT " . DB_USERTABLE_NAME . " name, " . DB_USERTABLE_USERID . " userid FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE LOWER(" . DB_USERTABLE_NAME . ") LIKE '%" . $db->escape_string(strtolower($search_name)) . "%' ORDER BY CASE WHEN LOWER(" . DB_USERTABLE_NAME . ") LIKE '" . $db->escape_string(strtolower($search_name)) . "%' THEN 1 WHEN LOWER(" . DB_USERTABLE_NAME . ") LIKE '%" . $db->escape_string(strtolower($search_name)) . "' THEN 2 ELSE 3 END, " . DB_USERTABLE_NAME . " ASC LIMIT 25 "); if ($result AND $db->count_select() > 0) { while ($rows1[] = $db->fetch_array($result)){} $search_results = true; } $result = $db->execute(" SELECT userid userid, guest_name name FROM arrowchat_status WHERE LOWER(guest_name) LIKE '%" . $db->escape_string(strtolower($search_name)) . "%' ORDER BY CASE WHEN LOWER(name) LIKE '" . $db->escape_string(strtolower($search_name)) . "%' THEN 1 WHEN LOWER(name) LIKE '%" . $db->escape_string(strtolower($search_name)) . "' THEN 2 ELSE 3 END, userid ASC LIMIT 25 "); if ($result AND $db->count_select() > 0) { while ($rows2[] = $db->fetch_array($result)){} $search_results = true; } $merged_results = array_merge($rows1, $rows2); } } ?>
Results
Search Results
  1. Logs Edit

       

  2. execute(" SELECT " . DB_USERTABLE_NAME . " name, " . DB_USERTABLE_USERID . " userid FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE " . DB_USERTABLE_USERID . " = '" . intval($db->escape_string(strtolower($search_name))) . "' ORDER BY " . DB_USERTABLE_NAME . " ASC LIMIT 25 "); if ($result AND $db->count_select() > 0) { while ($rows1[] = $db->fetch_array($result)){} $search_results = true; } $result = $db->execute(" SELECT userid userid, guest_name name FROM arrowchat_status WHERE userid LIKE 'g" . $db->escape_string(strtolower($search_name)) . "%' OR LOWER(guest_name) LIKE '%" . $db->escape_string(strtolower($search_name)) . "%' ORDER BY userid ASC LIMIT 25 "); if ($result AND $db->count_select() > 0) { while ($rows2[] = $db->fetch_array($result)){} $search_results = true; } $merged_results = array_merge($rows1, $rows2); if ($search_results) { foreach ($merged_results as $row) { if (!empty($row)) { ?>
  3. Logs Edit

       

  4. We didn't find any users 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
Unlock this feature by purchasing an ArrowChat license
">
Current Moderators
Moderators have access to moderation options in chat rooms and are able to ban/warn users in the main chat.
  1. Edit Group

    GROUP:

  2. 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)) { ?>
  3. Edit Logs View Actions

  4. There are currently no moderators

Administrators
Unlock this feature by purchasing an ArrowChat license
">
Current Administrators
Administrators have the same access that moderators have as well as additional options available.
  1. Edit Group

    GROUP:

  2. 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)) { ?>
  3. Edit Logs View Actions

  4. There are currently no administrators

Change Permissions
Add Moderator/Admin
Unlock this feature by purchasing an ArrowChat license
">

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
Unlock this feature by purchasing an ArrowChat license
">
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
Unlock this feature by purchasing an ArrowChat license
">
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
Unlock this feature by purchasing an ArrowChat license
">

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.

Features

video chat for this group.

s using chat rooms for this group.

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

Messaging

Choose how this group should be able to send or respond to private messages. The responding selection will only allow responding to messages to users that have chat enabled.

>
" /> min

The user can no longer reply to messages if they have not received a message from another user for this number of minutes. Tip: Enter a high value to allow the user to always be able to respond.

Choose how this group should be able to send or respond to chat room messages. The user will be shown an error message if they try to send a message when it is disabled.

Administration

WARNING: Selecting this will make all users that are a part of this group an administrator in ArrowChat.

WARNING: Selecting this will make all users that are a part of this group a moderator in ArrowChat.

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.