Recent Chat
count_all("
arrowchat
");
$pagenum = 1;
$self = htmlentities($_SERVER['PHP_SELF']);
$nav = 'Page ';
$maxpage = 10;
$total_pages = ceil($numrows / $maxpage);
if(var_check('page'))
{
$pagenum = get_var('page');
}
for ($i = 1; $i <= $total_pages; $i++)
{
if ($i == $pagenum)
{
$nav .= " $i ";
}
else if ($i <= 5)
{
$nav .= "
" . floor($i) . " ";
}
}
$offset = ($pagenum - 1) * $maxpage;
$result = $db->execute("
SELECT *
FROM arrowchat
ORDER BY id DESC
LIMIT " . $db->escape_string($offset) . ", " . $db->escape_string($maxpage) . "
");
if ($result AND $db->count_select() > 0)
{
?>
| From |
To |
Message |
Read |
Sent |
fetch_array($result))
{
if (check_if_guest($row['from']))
{
$from_username = $language[83] . " " . substr($row['from'], 1);
}
else
{
$from_result = $db->execute("
SELECT " . DB_USERTABLE_NAME . ", " . DB_USERTABLE_USERID . "
FROM " . TABLE_PREFIX . DB_USERTABLE . "
WHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string($row['from']) . "'
");
$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("
SELECT " . DB_USERTABLE_NAME . ", " . DB_USERTABLE_USERID . "
FROM " . TABLE_PREFIX . DB_USERTABLE . "
WHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string($row['to']) . "'
");
$to_username = $db->fetch_array($to_result);
$to_username = $to_username[DB_USERTABLE_NAME];
}
?>
|
|
|
Yes';
}
else
{
echo 'No | ';
}
?>
|
|
|
No one has ever chatted!