chat_rd.php

<?php
error_reporting(E_ALL);
/*
12/26/09 added user id restriction, ordering logic, DELETE query
5/29/10 reviseD to accommodate asynch ajax post call
chat_messages : // id message  when chat_room_id user_id from
7/28/10 Added inclusion of startup.inc.php for checking of network status and setting of file name variables to support no-maps versions of scripts.
*/

@session_start();
session_write_close();
require_once(isset($_SESSION['fip']) ? $_SESSION['fip'] : './incs/functions.inc.php');        //7/28/10
$last_id = sanitize_int($_REQUEST['last_id']);
$max_ct = sanitize_int($_REQUEST['max_ct']);
//    snap(basename(__FILE__),$last_id );
$query = "DELETE from `{$GLOBALS['mysql_prefix']}chat_messages` WHERE `when` < DATE_SUB(NOW(),INTERVAL 1 DAY )";
$result = db_query($query);

$query_p1 = "SELECT * FROM (" ;
$query_p2 = "SELECT `{$GLOBALS['mysql_prefix']}chat_messages`.*, `{$GLOBALS['mysql_prefix']}user`.`user` AS `user_name`,
    `{$GLOBALS['mysql_prefix']}chat_messages`.`id` AS chat_messages_id
    FROM `{$GLOBALS['mysql_prefix']}chat_messages`
    LEFT JOIN `{$GLOBALS['mysql_prefix']}user` ON `{$GLOBALS['mysql_prefix']}chat_messages`.`user_id` = `{$GLOBALS['mysql_prefix']}user`.`id`
    WHERE `{$GLOBALS['mysql_prefix']}chat_messages`.`id` > ?
    ORDER BY `chat_messages_id` DESC LIMIT " . intval($max_ct);
$query_p3 = ") AS r ORDER BY `chat_messages_id` ASC ";

$query = $query_p1 . $query_p2 . $query_p3;
$result = db_query($query, [$last_id]);
//    snap(__LINE__, $query );
$return = "";
while ($row = stripslashes_deep($result->fetch_array())){
    $return .= $row['user_name'] . "\t" . substr($row['when'], 11,5) . "\t" .$row['message'] . "\t" .$row['chat_messages_id'] . "\t". 0xFF;
    }
print $return;
?>