if (iADMIN && checkrights("A")) {

//Szkice artykułów

$i=0; 

{

$result = dbquery("SELECT ta.*,tac.*, tu.user_id,user_name FROM ".DB_ARTICLES." ta

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

   LEFT JOIN ".DB_USERS." tu ON ta.article_name=tu.user_id

   WHERE ".groupaccess("article_cat_access")." AND article_draft='1'

   ORDER BY article_datestamp DESC LIMIT 0,25");

}



$rows = dbrows($result);

if ($rows!=0) {

	opentable("Ostatnio dodane szkice artykułów");

	echo "\n<table border='0' cellspacing='0' cellpadding='0' width='100%'>\n";

	while ($data = dbarray($result)) {

		echo "<tr>\n		

		<td class='".($i% 2==0?"tbl1 tdleft":"tbl2 tdleft")."'>\n";

		echo "<img src='".THEME."images/bullet.gif' alt='bullet'> 

<a href='".ADMIN."articles.php".$aidlink."&amp;action=edit&amp;article_id=".$data['article_id']."'>".$data['article_subject']."</a> - <span class='small'>Dodał: <span class='small3'>".$data['user_name']."</span> w dniu: ".showdate("longdate", $data['article_datestamp'])."</span>\n";

		echo "		</td>\n	</tr>\n";

		$i++;

	}

	echo "</table>\n";

	closetable();

}

}