Parašė 123456788999999999· 2009 Kov. 1 20:03:42
#1
Sveiki gal kas turite tokia panele rodo populiariausias naujienas kaip pvz siuntinius buvau kažkur rades tačiau ji buvo bloga tai jei kas turit numeskit;)
Parašė vuiter· 2009 Kov. 2 17:03:57
#4
Fiksas parašė:
Sveiki gal kas turite tokia panele rodo populiariausias naujienas kaip pvz siuntinius buvau kažkur rades tačiau ji buvo bloga tai jei kas turit numeskit;)
kazkokia turiu....
opentable($locale['046']);
$result = dbquery("SELECT * FROM ".DB_PREFIX."news WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_datestamp DESC LIMIT 0,10");
echo "<table width='100%' cellpadding='0' cellspacing='0'>\n";
while ($data = dbarray($result)) {
$title = $data['news_subject'];
$sh_title = $title;
$n_id = $data['news_id'];
$v_id = $data['news_reads'];
$comments_n = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id=$n_id");
$date = $data['news_datestamp'];
$n_date = showdate("%d-%m-%Y", $date);
echo "<tr><td class='tbl' style='border-top:1px #ccc dotted;'> <img src='".THEME."images/bullet.gif'> $n_date | <a href='news.php?readmore=$n_id'><b>$sh_title</b></a> [$v_id Skaityta]<span class='side'></span></td></tr>\n";
}
echo "<tr><td align='center' class='tbl' style='border-top:1px #ccc dotted;'><a href='".BASEDIR."news.php'>Visos naujienos</a> - <a href='".BASEDIR."news_archive.php'>Naujienu Archyvas</a></td></tr>\n";
echo "</table>\n";
closetable();