TimX, # TimX (20.06.2020 / 12:41)
Libraryni faqatgina 1ta tanlangan bo'limidagi maqolalarni qanday bosh sahifaga chiqarsa bo'ladi?
20 daqiqa 28 soniyadan keyin yozdi:
<?php

echo '<div class="phdr"><b>Yangi maqolalar</b></div>';
<?php

echo '<div class="phdr"><b>Yangi maqolalar</b></div>';
$kmess = '7';
$cat_id = 48; //bu yerga kategorya idsini yozasiz
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `library_texts` WHERE `time` AND `premod`=1 AND `cat_id` = '".$cat_id."'"), 0);
$page = $page >= ceil($total / $kmess) ? ceil($total / $kmess) : $page;
$start = $page == 1 ? 0 : ($page - 1) * $kmess;
$sql = mysql_query("SELECT `id`, `name`, `time`, `uploader`, `uploader_id`, `count_views`, `comments`, `count_comments`, `cat_id`, `announce` FROM `library_texts` WHERE `premod`=1 AND `cat_id` = '".$cat_id."' ORDER BY `time` DESC LIMIT " . $start . "," . $kmess);
$nav = ($total > $kmess) ? '<div class="menu"><center>' . functions::display_pagination('?act=new&amp;', $start, $total, $kmess) . '</center></div>' : '';
if ($total) {
$i = 0;
while ($lib = mysql_fetch_assoc($sql)) {
$comm = mysql_result( mysql_query("select count(*) from `cms_library_comments` where `refid` = '".$lib['id']."'"),0);
echo '<div class="menu"><a href="' . $set['homeurl'] . '/library/index.php?id=' . $lib['id'] . '"><b>' . $lib['name'] . '</b></a> ['. functions::display_date($lib['time']) . ']<br>'.mb_substr($lib['announce'],0,100).'...<br>';
$catalog = mysql_fetch_assoc(mysql_query("SELECT `id`, `name` FROM `library_cats` WHERE `id` = " . $lib['cat_id'] . " LIMIT 1"));
echo '[<a href="/library/index.php?do=dir&amp;id=' . $catalog['id'] . '">' . functions::checkout($catalog['name']) . '</a>' . ($page > 1 ? ' | ' . functions::checkout($res['name']) : '') . ']';
echo '<span style="float:right;"><b>[' . $lib['count_views'] . ']</b></span></div>';
++$i;
}
}

echo $nav;

?>