8Gamers.NET

Копия для печати: [panel] [php-fusion 7.02.03] Последные новости

Прислано Ukraine Vova 25-02-2012 12:28
#1
Может кому, то понадобиться...

Код
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";
}

echo "</table>";
}
closeside();




Как панельку сделать и все.
Редактировал Ukraine Vova 05-04-2012 15:10