</script>
</head>
<body>
<div id="mypanelbody">
<?php
global $db, $current_user;
if (empty($db)) {
$db = DBManagerFactory::getInstance();
}
$myTmp = mktime(5, 0, 0, date('m'), date('d') - 15, date('Y'));
require_once 'modules/let_Chat/helper.php';
$helper = new chatHelper();
$all = '';
//ALL MESS
$q = "SELECT mh.id, mh.id as sortid, mh.user as nickname, mh.msg as message, mh.time, mh.foruser, u1.first_name, u1.last_name\n\t\t\t\t\t\t FROM messages_history mh\n\t\t\t\t\t\t LEFT JOIN users u1 ON u1.user_name = mh.user AND u1.deleted = 0\n\t\t\t\t\t\t WHERE mh.foruser = '******' AND mh.time>=" . $myTmp . " ORDER BY sortid";
$q = $helper->escapeSQL($q);
//Taras 2012-12-21
$result = $db->query($q);
while (($message = $db->fetchByAssoc($result)) != null) {
$message['message'] = htmlspecialchars(stripslashes($message['message']));
$all .= '<div class="shoutbox-list">' . '<span class="shoutbox-list-time">' . date($GLOBALS['timedate']->get_date_time_format(), $message['time']) . '</span>' . '<span class="shoutbox-list-nick">' . $helper->format_display_name($message['nickname'], $message['first_name'], $message['last_name']) . ':</span>' . '<span class="shoutbox-list-message">' . $message['message'] . '</span>' . '</div>';
}
?>
<ul class="tabs tabs1">
<li class="t1 tab-current"><a>All (15 days)</a></li>
</ul>
<div id="panelt1" class="mypanel">
<?php
echo $all;
?>
else
{
$otop=$_REQUEST['top'];
$oleft=$_REQUEST['left'];
} */
$q = "INSERT INTO messages_online (usr_id, usr_name, rtime, collapsed) VALUES('" . $current_user->id . "','" . $current_user->user_name . "',{$timestamp}, '" . $_REQUEST['collapsed'] . "')";
$db->query($q);
if (!$_REQUEST['time']) {
$_REQUEST['time'] = 0;
}
$myTmp = mktime(5, 0, 0, date('m'), date('d'), date('Y'));
//history
$currentDate = gmdate('Y-m-d');
if (!isset($_SESSION['let_Chat']['historyDate']) || $_SESSION['let_Chat']['historyDate'] != $currentDate) {
$history_query = "SELECT * FROM messages WHERE time<" . $myTmp . " ORDER BY id ASC";
$history_query = $helper->escapeSQL($history_query);
//Taras 2012-12-21
$history_result = $db->query($history_query);
while (($history = $db->fetchByAssoc($history_result)) != null) {
$h_query = "INSERT INTO messages_history (id, user, msg, time, foruser, del)\n\t VALUES ('" . $history['id'] . "',\n\t '" . $history['user'] . "',\n\t '" . $db->quote($history['msg']) . "',\n\t '" . $history['time'] . "',\n\t '" . $history['foruser'] . "',\n\t '" . $history['del'] . "'\n\t ); ";
$db->query($h_query);
$del = "DELETE FROM messages WHERE id = " . $history['id'];
// letrium v
//$res=$db->limitQuery($del, 0, 1);
$res = $db->query($del);
// letrium v END
}
if (!isset($_SESSION['let_Chat'])) {
$_SESSION['let_Chat'] = array();
}
$_SESSION['let_Chat']['historyDate'] = $currentDate;
