} else {
$show_user = true;
}
}
}
} else {
if ($users_chat_with == 1) {
if (check_if_guest($chat['userid'])) {
$show_user = true;
}
} else {
if ($users_chat_with == 2) {
$show_user = true;
} else {
if ($users_chat_with == 3) {
if (!check_if_guest($chat['userid'])) {
$show_user = true;
}
} else {
$show_user = true;
}
}
}
}
if (!in_array($chat['userid'], $block_chats_unserialized)) {
if (!empty($chat['username']) and $show_user) {
$buddyList[] = array('id' => $chat['userid'], 'n' => stripslashes($db->escape_string(strip_tags($chat['username']))), 's' => $chat['status'], 'a' => $avatar, 'l' => $link);
}
}
}
}
$fetchid = $row['report_from'];
if (check_if_guest($fetchid)) {
$sql = get_guest_details($fetchid);
$result2 = $db->execute($sql);
$user = $db->fetch_array($result2);
$from_name = create_guest_username($user['userid'], $user['guest_name']);
$from_avatar = $base_url . AC_FOLDER_ADMIN . "/images/img-no-avatar.gif";
} else {
$sql = get_user_details($fetchid);
$result3 = $db->execute($sql);
$user = $db->fetch_array($result3);
$from_name = $user['username'];
$from_avatar = get_avatar($user['avatar'], $fetchid);
}
$fetchid = $row['report_about'];
if (check_if_guest($fetchid)) {
$sql = get_guest_details($fetchid);
$result2 = $db->execute($sql);
$user = $db->fetch_array($result2);
$about_name = create_guest_username($user['userid'], $user['guest_name']);
$about_avatar = $base_url . AC_FOLDER_ADMIN . "/images/img-no-avatar.gif";
} else {
$sql = get_user_details($fetchid);
$result3 = $db->execute($sql);
$user = $db->fetch_array($result3);
$about_name = $user['username'];
$about_avatar = get_avatar($user['avatar'], $fetchid);
}
$reports[] = array('id' => $row['id'], 'from' => $from_name, 'from_pic' => $from_avatar, 'about' => $about_name, 'about_pic' => $about_avatar, 'time' => relative_time($row['report_time']), 'about_num' => $row['COUNT(id)']);
}
$result = $db->execute("\n\t\t\tSELECT COUNT(id)\n\t\t\tFROM arrowchat_reports\n\t\t\tWHERE (working_time < (" . time() . " - 600)\n\t\t\t\t\t\tOR working_by = '" . $db->escape_string($userid) . "')\n\t\t\t\tAND completed_time = 0\n\t\t");
} else {
$link = get_link($chat['link'], $chat['userid']);
$avatar = get_avatar($chat['avatar'], $chat['userid']);
}
}
// End Receive User Details
$settings .= 'unfocus_chat[' . $i . '] = "' . $unfocus_chat[$i] . '";';
$settings .= 'uc_name["' . $unfocus_chat[$i] . '"] = "' . $db->escape_string(strip_tags($chat['username'])) . '";';
$settings .= 'uc_status["' . $unfocus_chat[$i] . '"] = "' . $chat['status'] . '";';
$settings .= 'uc_avatar["' . $unfocus_chat[$i] . '"] = "' . $avatar . '";';
$settings .= 'uc_link["' . $unfocus_chat[$i] . '"] = "' . $link . '";';
$double_check[] = $unfocus_chat[$i];
}
}
// Get the logged in user's avatar
if (check_if_guest($userid)) {
$user_username = create_guest_username($userid, $guest_name);
$user_avatar = $base_url . AC_FOLDER_ADMIN . "/images/img-no-avatar.gif";
$user_is_guest = 1;
} else {
$user_is_guest = 0;
$user_username = get_username($userid);
$sql = get_user_details($userid);
$result = $db->execute($sql);
if ($result and $db->count_select() > 0) {
$row = $db->fetch_array($result);
$user_avatar = $row['avatar'];
$user_avatar = get_avatar($user_avatar, $userid);
} else {
$user_avatar = $base_url . AC_FOLDER_ADMIN . "/images/img-no-avatar.gif";
}
// ########################## INCLUDE BACK-END ###########################
require_once dirname(dirname(dirname(dirname(__FILE__)))) . DIRECTORY_SEPARATOR . 'bootstrap.php';
require_once dirname(dirname(dirname(dirname(__FILE__)))) . DIRECTORY_SEPARATOR . AC_FOLDER_INCLUDES . DIRECTORY_SEPARATOR . 'init.php';
// ########################### INITILIZATION #############################
$response = array();
$blocklist = array();
// ###################### START NOTIFICATION RECEIVE ######################
if (logged_in($userid)) {
$result = $db->execute("\n\t\t\tSELECT block_chats \n\t\t\tFROM arrowchat_status \n\t\t\tWHERE userid = '" . $db->escape_string($userid) . "' \n\t\t");
if ($row = $db->fetch_array($result)) {
$block_chats_array = unserialize($row['block_chats']);
if (!is_array($block_chats_array)) {
$block_chats_array = array();
}
foreach ($block_chats_array as $id) {
if (check_if_guest($id)) {
$username = create_guest_username($id, '', true);
if (empty($username)) {
$username = create_guest_username($id, '', false);
}
} else {
$username = get_username($id);
}
if (!empty($id) && !empty($username)) {
$blocklist[] = array('id' => $id, 'username' => $username);
}
}
}
if (!empty($blocklist)) {
$response['blocklist'] = $blocklist;
}
</form>
</div>
</div>
<div class="title_bg">
<div class="title">Administrators</div>
<div class="module_content">
<div class="subtitle">Current Administrators</div>
<div class="subExplain"><i>Administrators have the same access that moderators have as well as additional options available.</i></div>
<h2 class="subHeading">Administrators</h2>
<ol class="scrollable">
<?php
$result = $db->execute("\n\t\t\tSELECT arrowchat_status.userid userid\n\t\t\tFROM arrowchat_status\n\t\t\tWHERE arrowchat_status.is_admin = 1\n\t\t\tORDER BY arrowchat_status.userid ASC\n\t\t");
if ($result and $db->count_select() > 0) {
while ($row = $db->fetch_array($result)) {
if (check_if_guest($row['userid'])) {
$mod_username = create_guest_username($row['userid'], '', true);
if (empty($mod_username)) {
$mod_username = create_guest_username($row['userid'], '', false);
}
} else {
$sql = get_user_details($row['userid']);
$result2 = $db->execute($sql);
if ($result2 and $db->count_select() > 0) {
$row = $db->fetch_array($result2);
$mod_username = $row['username'];
}
}
?>
<li class="listItem">
<a href="users.php?do=view&id=<?php
<td style="width: 125px;" class="row2">From</td>
<td style="width: 125px;" class="row2">To</td>
<td style="width: 305px;" class="row2">Message</td>
<td style="width: 50px;" class="row2">Read</td>
<td style="width: 125px;" class="row2">Sent</td>
</tr>
<?php
while ($row = $db->fetch_array($result)) {
if (check_if_guest($row['from'])) {
$from_username = $language[83] . " " . substr($row['from'], 1);
} else {
$from_result = $db->execute("\n\t\t\t\t\t\t\tSELECT " . DB_USERTABLE_NAME . ", " . DB_USERTABLE_USERID . " \n\t\t\t\t\t\t\tFROM " . TABLE_PREFIX . DB_USERTABLE . " \n\t\t\t\t\t\t\tWHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string($row['from']) . "'\n\t\t\t\t\t\t");
$from_username = $db->fetch_array($from_result);
$from_username = $from_username[DB_USERTABLE_NAME];
}
if (check_if_guest($row['to'])) {
$to_username = $language[83] . " " . substr($row['to'], 1);
} else {
$to_result = $db->execute("\n\t\t\t\t\t\t\tSELECT " . DB_USERTABLE_NAME . ", " . DB_USERTABLE_USERID . " \n\t\t\t\t\t\t\tFROM " . TABLE_PREFIX . DB_USERTABLE . " \n\t\t\t\t\t\t\tWHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string($row['to']) . "'\n\t\t\t\t\t\t");
$to_username = $db->fetch_array($to_result);
$to_username = $to_username[DB_USERTABLE_NAME];
}
?>
<tr style="height: 25px;">
<td class="row1"><a href="users.php?do=logs&id=<?php
echo $row['from'];
?>
"><?php
echo $from_username;
?>
</a></td>
$user_ip = $row['ip_address'];
} else {
$user_ip = '';
}
$db->execute("\n\t\t\t\tINSERT INTO arrowchat_chatroom_banlist (\n\t\t\t\t\tuser_id, \n\t\t\t\t\tchatroom_id, \n\t\t\t\t\tban_length, \n\t\t\t\t\tban_time,\n\t\t\t\t\tip_address\n\t\t\t\t) \n\t\t\t\tVALUES (\n\t\t\t\t\t'" . $db->escape_string($chatroom_ban) . "',\n\t\t\t\t\t'" . $db->escape_string($chatroom_id) . "',\n\t\t\t\t\t'" . $db->escape_string($chatroom_ban_length) . "',\n\t\t\t\t\t'" . time() . "',\n\t\t\t\t\t'" . $db->escape_string($user_ip) . "'\n\t\t\t\t)\n\t\t\t");
$db->execute("\n\t\t\t\tUPDATE arrowchat_chatroom_users \n\t\t\t\tSET session_time = '0'\n\t\t\t\tWHERE user_id = '" . $db->escape_string($chatroom_ban) . "'\n\t\t\t\t\tAND chatroom_id = '" . $db->escape_string($chatroom_id) . "'\n\t\t\t");
}
echo "1";
close_session();
exit(0);
}
// ####################### START POST SILENCE USER ##########################
if (var_check('chatroom_silence')) {
$result = $db->execute("\n\t\t\tSELECT is_mod, is_admin \n\t\t\tFROM arrowchat_chatroom_users \n\t\t\tWHERE user_id = '" . $db->escape_string($userid) . "'\n\t\t\t\tAND chatroom_id = '" . $db->escape_string($chatroom_id) . "'\n\t\t\t\tAND (is_admin = '1'\n\t\t\t\t\tOR is_mod = '1')\n\t\t");
if ($result and $db->count_select() > 0 and is_numeric($chatroom_silence_length)) {
if (check_if_guest($chatroom_silence)) {
$silence_username = create_guest_username($chatroom_silence, '', true);
if (empty($silence_username)) {
$silence_username = create_guest_username($chatroom_silence, '', false);
}
} else {
$sql = get_user_details($chatroom_silence);
$result = $db->execute($sql);
if ($result and $db->count_select() > 0) {
$row = $db->fetch_array($result);
$silence_username = $row['username'];
}
}
$silence_message = $silence_username . $language[163] . $db->escape_string(strip_tags(get_username($userid))) . ".";
$db->execute("\n\t\t\t\tINSERT INTO arrowchat_chatroom_messages (\n\t\t\t\t\tchatroom_id,\n\t\t\t\t\tuser_id,\n\t\t\t\t\tusername,\n\t\t\t\t\tmessage,\n\t\t\t\t\tglobal_message,\n\t\t\t\t\tsent\n\t\t\t\t) \n\t\t\t\tVALUES (\n\t\t\t\t\t'" . $db->escape_string($chatroom_id) . "', \n\t\t\t\t\t'" . $db->escape_string($userid) . "', \n\t\t\t\t\t'Global',\n\t\t\t\t\t'" . $silence_message . "',\n\t\t\t\t\t'1',\n\t\t\t\t\t'" . time() . "'\n\t\t\t\t)\n\t\t\t");
if ($push_on == 1) {
">[Edit this user]</a> </div></div>
<div class="module_content">
<form method="post" action="<?php
echo htmlentities($_SERVER['PHP_SELF']);
?>
?do=<?php
echo $do;
?>
" enctype="multipart/form-data">
<div style="height: 300px; padding: 10px; overflow: auto;border:1px solid #C0C0C0;border-radius: 4px;-webkit-border-radius: 4px;-moz-border-radius: 4px;-khtml-border-radius: 4px;" id="chatboxes3">
<?php
$result = $db->execute("\n\t\t\t\tSELECT * \n\t\t\t\tFROM arrowchat_reports\n\t\t\t\tWHERE completed_by = '" . $db->escape_string(get_var('aid')) . "' \n\t\t\t\tORDER BY completed_time ASC\n\t\t\t\tLIMIT 100\n\t\t\t");
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("\n\t\t\t\t\t\t\t\tSELECT " . DB_USERTABLE_NAME . " \n\t\t\t\t\t\t\t\tFROM " . TABLE_PREFIX . DB_USERTABLE . " \n\t\t\t\t\t\t\t\tWHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string($row['report_about']) . "'\n\t\t\t\t\t\t\t");
$row3 = $db->fetch_array($result3);
$username = $row3[DB_USERTABLE_NAME];
}
} else {
$username = "******";
}
?>
<div style="padding:0px 10px 10px 0px; float: left; background-color: #fff; width: 470px;"><span style="font-size:13px;font-weight:bold">Report about <a href="users.php?do=logs&id=<?php
echo $row['report_about'];
?>
</fieldset>
<dl class="selectionBox submitBox">
<dt></dt>
<dd>
<div class="floatr">
<a class="fwdbutton" onclick="document.forms[0].submit(); return false">
<span>Search</span>
</a>
<input type="hidden" name="user_search" value="1" />
</div>
</dd>
</dl>
<?php
if (!empty($_REQUEST['id'])) {
$request_id = get_var('id');
if (check_if_guest(get_var('id'))) {
$username = $language[83] . " " . substr(get_var('id'), 1);
} else {
$result = $db->execute("\n\t\t\t\t\tSELECT " . DB_USERTABLE_NAME . ", " . DB_USERTABLE_USERID . " \n\t\t\t\t\tFROM " . TABLE_PREFIX . DB_USERTABLE . " \n\t\t\t\t\tWHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string($request_id) . "'\n\t\t\t\t");
$row = $db->fetch_array($result);
$username = $row[DB_USERTABLE_NAME];
}
$result = $db->execute("\n\t\t\t\tSELECT * \n\t\t\t\tFROM arrowchat_status \n\t\t\t\tWHERE userid = '" . $db->escape_string($request_id) . "'\n\t\t\t");
$row = $db->fetch_array($result);
$status = $row['status'];
$is_admin = $row['is_admin'];
$hide_bar = $row['hide_bar'];
$play_sound = $row['play_sound'];
$window_open = $row['window_open'];
$only_names = $row['only_names'];
$announcement = $row['announcement'];
