hasFuse(USER_ID, 'fuse_housekeeping_moderation'))
{
exit;
}
$searchResults = null;
if (isset($_GET['timeSearch']))
{
$_POST['searchQuery'] = $_GET['timeSearch'];
$_POST['searchType'] = '4';
}
if (isset($_POST['searchQuery']))
{
$query = filter($_POST['searchQuery']);
$type = $_POST['searchType'];
$q = "SELECT * FROM chatlogs WHERE ";
switch ($type)
{
default:
case '1':
$q .= "user_name = '" . $query . "'";
break;
case '2':
$q .= "message LIKE '%" . $query . "%'";
break;
case '3':
$q .= "room_id = '" . $query . "'";
break;
case '4':
$cutMin = intval($query) - 300;
$cutMax = intval($query) + 300;
$q .= "timestamp >= " . $cutMin . " AND timestamp <= " . $cutMax;
}
$searchResults = dbquery($q);
}
require_once "top.php";
?>
Chatlogs
This tool may be used to look up and review room chatlogs. Special chat such as IM and minimail is not being monitored here. Seperate tools
may be available for them.
IMPORTANT: Chatlogs are only kept for a limited period of time.
Chatlogs older than 2 weeks will be permanently deleted. If you would
like to keep them for a longer period, please save them locally.
Search results - You searched for "' . clean($_POST['searchQuery']) . '"';
echo '
Clear search
| Date |
Time |
User |
Room |
Message |
Timestamp |
';
while ($result = mysql_fetch_assoc($searchResults))
{
if (strlen($result['hour']) < 2)
{
$result['hour'] = '0' . $result['hour'];
}
if (strlen($result['minute']) < 2)
{
$result['minute'] = '0' . $result['minute'];
}
echo '
| ' . $result['full_date'] . ' |
' . $result['hour'] . ':' . $result['minute'] . ' |
' . clean($result['user_name']) . ' (' . $result['user_id'] . ') |
' . clean(RoomManager::GetRoomVar($result['room_id'], 'caption')) . ' (' . $result['room_id'] . ') |
' . clean($result['message']) . ' |
' . clean($result['timestamp']) . ' (Search) |
';
}
echo '
';
}
else
{
echo 'Search chatlogs
Recent activity
| Date |
Time |
User |
Room |
Message |
Timestamp |
';
$getRecent = dbquery("SELECT * FROM chatlogs ORDER BY id DESC LIMIT 30");
while ($recent = mysql_fetch_assoc($getRecent))
{
if (strlen($recent['hour']) < 2)
{
$recent['hour'] = '0' . $recent['hour'];
}
if (strlen($recent['minute']) < 2)
{
$recent['minute'] = '0' . $recent['minute'];
}
echo '
| ' . $recent['full_date'] . ' |
' . $recent['hour'] . ':' . $recent['minute'] . ' |
' . clean($recent['user_name']) . ' (' . $recent['user_id'] . ') |
' . clean(RoomManager::GetRoomVar($recent['room_id'], 'caption')) . ' (' . $recent['room_id'] . ') |
' . clean($recent['message']) . ' |
' . clean($recent['timestamp']) . ' (Search) |
';
}
echo '
';
}
require_once "bottom.php";
?>