openside("Naujausi");

echo "<table>

<td><div class='side-label'><b>Naujausi siuntiniai :</b></div>\n";

$result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_datestamp DESC LIMIT 0,5");

if (dbrows($result) != 0) {

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

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

echo "<tr>

<td class='small'>

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

<a href='".BASEDIR."downloads.php?cat_id=".$data['download_cat']."&download_id=".$data['download_id']."' title='".$data['download_title']."' class='side'>".trimlink($data['download_title'], 23)."</a>

</td>

<td align='right'>><font color=red--> Parsisiūsta</font> : <b>".$data['download_count']."</b> <font color=red>kartus</font></td>

</tr>";

}

echo "</table>";

} else {

echo "<div style='text-align:center'>".$locale['004']."</div>\n";

}

echo "<br>";

echo "</td><td><div class='side-label'><b>".$locale['023']."</b></div>\n";

$result = dbquery(

"SELECT ta.*,tac.* FROM ".$db_prefix."articles ta

INNER JOIN ".$db_prefix."article_cats tac ON ta.article_cat=tac.article_cat_id

WHERE ".groupaccess('article_cat_access')." ORDER BY article_datestamp DESC LIMIT 0,5"

);

if (dbrows($result) != 0) {

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

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

echo "<img src='".THEME."images/bullet.gif' alt=''> <a href='".BASEDIR."readarticle.php?article_id=".$data['article_id']."' title='".$data['article_subject']."' class='side'>$itemsubject</a><br>\n";

}

} else {

echo "<center>".$locale['004']."</center>\n";

}

echo "</td></table>";

closeside();