opentable("Naujausia Muzika");
 
 
 
 $result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_datestamp DESC LIMIT 20");
 
 $rows = dbrows($result);
 
 if ($rows != 0) {
 
  $counter = 0; $columns = 1; 
 
  echo "<table align='center' cellpadding='0' cellspacing='2'>\n<tr>\n";
 
  echo "<td align='center'><b>Pavadinimas</b></td>
 
  <td align='center'><b>Data</b></td>
 
  <td align='center'><b>Siuntesi</b></td>
 
  <td align='center'><b>Pateike</b></td></tr><tr>";
 
  while ($data = dbarray($result)) {
 
   if ($counter != 0 && ($counter % $columns == 0)) echo "</tr>\n<tr>\n";
 
   echo "<td align='left' valign='top'><a href='".BASEDIR.seoname($data['download_title']).",daina".$data['download_id'].".html' title='$data['download_title']'>".trimlink($data['download_title'], 40)."</a>";
 
   echo "</td><td align='center'>".date('y.m.d', $data['download_datestamp'])."</td>
 
   <td align='center'>".$data['download_count']."</td>
 
   <td align='left'><a href='".BASEDIR."".seoname($data['download_license']).",u".$data['user_id'].".html' title='$data['download_title']'>".$data['download_license']."</a></td>\n" ;
 
   $counter++;
 
  }
 
  echo "</tr>\n</table>\n";
 
 } else {
 
  echo "<center><br>\n".$locale['430']."<br><br>\n</center>\n";
 
 }
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
closetable();