openside("ostani news");

$result = dbquery(

"SELECT tn.*, tc.*, user_id, user_name FROM ".DB_NEWS." tn

LEFT JOIN ".DB_USERS." tu ON tn.news_name=tu.user_id

LEFT JOIN ".DB_NEWS_CATS." tc ON tn.news_cat=tc.news_cat_id

WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0'

ORDER BY news_sticky DESC, news_datestamp DESC LIMIT 1"

);

$r = dbarray($result);



echo "<table width='100%' cellpadding='0' cellspacing='0'>

<tr><td class='tbl2'><strong>".stripslashes($r['news_subject'])."</strong></td>\n</tr>

<tr><td class='tbl1' style='text-align:justify'>".nl2br(stripslashes($r['news_news']))."</td>\n</tr>

<tr><td align='center' class='tbl2'>

<span class='small2'>".THEME_BULLET." <a href='".BASEDIR."profile.php?lookup=".$r['user_id']."'>".$r['user_name']."</a> dnia 

".showdate("longdate", $r['news_datestamp'])."

<a href='".BASEDIR."news.php?readmore=".$r['news_id']."'>Czytaj wiecej</a>

</td></tr>

</table>";

closeside();