Сообщений: 214 Зарегистрирован: 27.09.11 Со дня регистрации: 4980 Пол:
Может кому, то понадобиться...
Код
openside("Новости");
$result = dbquery(
"SELECT news_id, news_subject, news_datestamp
FROM ".DB_NEWS."
WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().")
AND (news_end='0'||news_end>=".time().") AND news_draft='0'
GROUP BY news_id
ORDER BY news_datestamp DESC LIMIT 0,10");
if (dbrows($result)) {
echo "<div class='side-label'><b>Последние</b></div>";
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
while($data=dbarray($result)){
$news_subject = trimlink($data['news_subject'], 24);
echo THEME_BULLET." <a href='".BASEDIR."news.php?news_id=".$data['news_id']."' title='".$data['news_subject']."' class='side'>".$news_subject."</a><br>\n";
}
echo "</table>";
}
$result = dbquery(
"SELECT news_id, news_subject, news_datestamp
FROM ".DB_NEWS."
WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().")
AND (news_end='0'||news_end>=".time().") AND news_draft='0'
GROUP BY news_id
ORDER BY RAND() DESC LIMIT 0,10");
if (dbrows($result)) {
echo "<div class='side-label'><b>Случайные</b></div>";
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
while($data=dbarray($result)){
$news_subject = trimlink($data['news_subject'], 24);
echo THEME_BULLET." <a href='".BASEDIR."news.php?news_id=".$data['news_id']."' title='".$data['news_subject']."' class='side'>".$news_subject."</a><br>\n";
}
echo "</table>";
}
$result = dbquery(
"SELECT news_id, news_subject, news_datestamp
FROM ".DB_NEWS."
WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().")
AND (news_end='0'||news_end>=".time().") AND news_draft='0'
GROUP BY news_id
ORDER BY news_reads DESC LIMIT 0,10");
if (dbrows($result)) {
echo "<div class='side-label'><b>Популярные</b></div>";
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
while($data=dbarray($result)){
$news_subject = trimlink($data['news_subject'], 24);
echo THEME_BULLET." <a href='".BASEDIR."news.php?news_id=".$data['news_id']."' title='".$data['news_subject']."' class='side'>".$news_subject."</a><br>\n";
}
Vova
Опубликовано 25-02-2012 12:28
