opentable("Naujausia Muzika ");
$top = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_datestamp DESC LIMIT 0,20");
echo "<a name='top' id='top'></a>";
echo "<table cellspacing='0' cellpanding='0' width='100%' align='center'><tr><td class='cell'><strong>Nr.</strong></td><td class='cell'><strong>Dainos Pavadinimas</strong></td><td class='cell'><strong>Idėta</strong></td><td class='cell'><strong>Siuntėsi</strong></td><td class='cell' width='5'>       <strong>    Įdėjo</strong></td></tr>";
$a = 1;
while($data = dbarray($top)){
$result = dbquery("SELECT user_id FROM ".$db_prefix."users WHERE user_name='".$data['download_license']."'");
$data2 = dbarray($result);
echo "<tr><td valign='top' class='cell'>$a.</td><td valign='top' class='cell'><a href='".BASEDIR.seoname($data['download_title']).",daina".$data['download_id'].".html' title='".$data['download_title']."' class='side'>".$data['download_title']."</a></td><td class='cell'>".showdate("%Y.%m.%d", $data['download_datestamp'])."</td><td class='cell' align='center'>".$data['download_count']."</td><td class='cell' align='center'><a href='".seoname($data['download_license'])."-uid".$data2['user_id'].".html'>".$data['download_license']."</a></td></tr>";
$a++;
}
echo "</table>";
closetable();