openside("Atsitiktiniai 10 siuntinių");
$result=dbquery("SELECT * FROM ".DB_PREFIX."downloads ORDER BY RAND() LIMIT 10");
 
if(dbrows($result)!=0){
while($data=dbarray($result)){
$result2 = dbquery("SELECT download_cat_name FROM ".DB_PREFIX."download_cats WHERE download_cat_id='$data[download_cat]'");
 
$category = dbresult($result2,0);
 
echo "<a href='".BASEDIR."downloads.php?cat_id=$data[download_cats]&download_id=$data[download_id]' target='blank'
class='slink'>".trimlink($data[download_title], 25)."</a><br>\n";
}
}
closeside();

 
openside("Atsitiktiniai 10 siuntinių");
$result=dbquery("SELECT * FROM ".DB_PREFIX."downloads ORDER BY DESC LIMIT 10");
echo "<table width='599' border='0' cellpadding='0' cellspacing='0'>
  <tr>
    <td width='35'><strong>Nr.</strong></td>
    <td width='306'><strong>Pavadinimas</strong></td>
    <td width='111'><strong>Ideta</strong></td>
    <td width='144'><strong>Siuntesi</strong></td>
  </tr>
</table>";
if(dbrows($result)!=0){
$x = 0;
while($data=dbarray($result)){
$x++;
$z = date("m/d/y",1201154400);
echo "
<table width='599' border='0' cellpadding='0' cellspacing='0'>
  <tr>
    <td width='35'>".$x."</td>
    <td width='306'><a href='".BASEDIR."downloads.php?cat_id=$data[download_cats]&download_id=$data[download_id]' target='blank'
 
class='slink'>".trimlink($data[download_title], 25)."</a></td>
    <td width='111'>".date("o.m.d",$data[download_datestamp])."</td>
    <td width='144'>".$data[download_count]."</td>
  </tr>
</table>\n";
}
 
}else{
echo "<center>Siuntiniu Nera</center>";
}
closeside();