[olist=1]<?php



require_once "maincore.php";



$wynik = dbquery(



"SELECT ta.article_id, ta.article_subject, tac.article_cat_id, tac.article_cat_access FROM ".DB_ARTICLES." ta



INNER JOIN ".DB_ARTICLE_CATS." tac ON ta.article_cat=tac.article_cat_id



".(iSUPERADMIN ? "" : "WHERE ".groupaccess('article_cat_access'))." AND article_draft='0' ORDER BY RAND() LIMIT 1"



);



if(dbrows($wynik) > 0)



{



$r = dbarray($wynik);



$itemsubject = trimlink($r['article_subject'], 23);



echo "<a href='".BASEDIR."articles.php?article_id=".$r['article_id']."' title='".$r['article_subject']."' class='side'>$itemsubject</a><br />\n";



}else {echo "Brak artykułów."; }



?>[/olist]