/**
* Gets the most recent chats from the DB
* @param int $map_id The map id
* @param int $time The timestamp
* @return array The rows from the DB
* @member MHP
* @public
*/
function get($map_id, $time)
{
$map_id = (int) $map_id;
$time = (int) $time;
$system = self::TYPE_SYSTEM;
$table = $this->config['Chats']['Table'];
$qry = "\r\n\t\t\tSELECT\r\n\t\t\t\tv_chars.name,\r\n\t\t\t\t{$table}.*\r\n\t\t\tFROM\r\n\t\t\t\t{$table}\r\n\t\t\tLEFT JOIN\r\n\t\t\t\tv_chars\r\n\t\t\tON\r\n\t\t\t\t(v_chars.char_id = {$table}.char_id)\r\n\t\t\tWHERE\r\n\t\t\t\t({$table}.time_posted > {$time})\r\n\t\t\t\tAND (\r\n\t\t\t\t\t{$table}.map_id = {$map_id}\r\n\t\t\t\t\tOR\r\n\t\t\t\t\t{$table}.type = {$system}\r\n\t\t\t\t)\r\n\t\t\tORDER BY\r\n\t\t\t\t{$table}.time_posted ASC,\r\n\t\t\t\t{$table}.chat_id ASC\r\n\t\t";
$rows = $GLOBALS['MHP']->getRows($qry);
foreach ($rows as &$row) {
$row['message'] = Tools::stripHTML($row['message']);
$row['message'] = Tools::formatClickable($row['message']);
}
return $rows;
}
public static function formatMessages($messages, $set_last = true)
{
foreach ($messages as &$message) {
$date = date('g:ia', $message['timestamp']);
$message['date'] = substr($date, 0, -1);
// converts "am" to "a", etc
$message['message'] = self::formatMessage($message['message'], $message['type']);
$message['name'] = Tools::stripHTML($message['name']);
}
if ($set_last) {
self::$last_message_id = $message['message_id'];
error_log(self::$last_message_id);
}
return $messages;
}
<?php
$code = 'Y/m/d';
$day = false;
$today = date($code, time());
?>
<legend>topic: <strong><?php
echo Tools::stripHTML($this->room['topic']);
?>
</strong></legend>
<ul>
<?php
if ($this->message) {
?>
<li class="notice">
<?php
echo $this->message;
?>
</li>
<?php
}
if ($this->num_messages > count($this->messages)) {
?>
<li class="notice">
There are <strong><?php
echo Tools::formatMultiple($this->num_messages, 'message');
?>
</strong> in this room's history. <a href="/room/<?php
echo $this->room['name'];
?>
/history">[view entire room history]</a>
