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();