Parašė PyccKuu· 2008 Vas. 16 00:02:42
#7
opentable("Informacija");
echo "<table width='100%'>
<tr>
<td width='33%'>";
openside("Aktyviausi nariai");
$result = dbquery("SELECT * FROM ".$db_prefix."users ORDER BY user_posts DESC LIMIT 0,20");
echo "<table cellpadding='0' cellspacing='0' width='100%'>";
echo "<td class='side-small' align='left'>";
echo "<b>Aktyviausi nariai</b>";
echo "<td class='side-small' align='right'>";
echo "<b>Žinučių</b>";
if (dbrows($result) != 0) {
while ($data = dbarray($result)) {
echo "<tr>
<td class='side-small' align='left'><a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' title='".$data['user_name']."' class='side'>".trimlink($data['user_name'], 15)."</a></td>
<td class='side-small' align='right'> ".$data['user_posts']."</td>
</tr>\n";
}
}
echo "</table>\n";
closeside();
echo "</td>
<td width='33%'>";
openside("Top 20");
$result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_count DESC LIMIT 0,20");
if (dbrows($result) != 0) {
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
while($data = dbarray($result)) {
$itemsubject = trimlink($data['download_title'], 23);
echo "<tr>\n<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'>$itemsubject</a></td>\n
<td align='right'>".$data['download_count']."</td>\n</tr>\n";
}
echo "</table>";
} else {
echo "<center>".$locale['004']."</center>\n";
}
closeside();
echo"</td><td width='33%'>";
openside("Naujausias atsisiuntimas");
$result=dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_datestamp DESC LIMIT 0,20");
echo "<table width='100%' cellpadding='0' cellspacing='0'>\n";
if(dbrows($result)!=0){
while($data=dbarray($result)){
echo "<tr>
<td class='small'><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'], 22)."</a></td>
<td align='right' class='side'>$data[download_count]</td>
</tr>
<tr>
<td class='small'>".$download_cat_name."</td>
</tr>\n";
}
}
echo "</table>\n";
closeside();
echo "</tr>
</table>";
closetable();
Jajgu kam rejkia pasidariau kaskaip sudėdamas ;)
Redagavo MAnjack· 2008 Vas. 16 09:02:17