Файл: modules/diary/include.php
Строк: 19
<?php
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `diary` WHERE `read` = '0'"), 0);
$k_page = k_page($k_post, $set['p_str']);
$page = page($k_page);
$start = $set['p_str'] * $page - $set['p_str'];
$lim = " LIMIT $start, $set[p_str]";
$order = '`time` DESC';
if (isset($_GET['time'])) {
$order = '`time` DESC';
}
if (isset($_GET['komm'])) {
$order = '`komm` DESC';
}
if (isset($_GET['look'])) {
$order = '`look` DESC';
}
$q = mysql_query("SELECT * FROM `diary` WHERE `read` = '0' ORDER BY rand() LIMIT 1");
while ($dnev = mysql_fetch_assoc($q)) {
$ank = user::get_user($dnev['id_user']);
echo "<div class = 'razd'>";
echo "<span style = 'float:right;'>";
echo " " . user($ank['id']);
echo "</span>";
echo img16('diary.png') . " $dnev[name]<br />";
echo text::toOutput(text::cut_text($dnev['msg'])) . "...n";
echo " <a href = '/modules/diary/dnev.php?id=$dnev[id]'>Читать далее »</a><br />";
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `diary_komm` WHERE `id_dnev` = '$dnev[id]'"), 0) != 0) {
$post = mysql_fetch_assoc(mysql_query("SELECT * FROM `diary_komm` WHERE `id_dnev` = '$dnev[id]' ORDER BY `time` DESC LIMIT 1"));
}
echo "</div>";
}