Parašė Taranas· 2011 Kov. 14 18:03:09
#258
openside("Aktyviausi forumieciai");
$result = dbquery("SELECT * FROM ".$db_prefix."users ORDER BY user_posts DESC LIMIT 0, 5");
echo "<table cellpadding='0' cellspacing='0' width='100%'>";
echo "<td class='side-small' align='left'>";
echo "<b><font color='cc3300'>Aktyviausi latrai</b>";
echo "<td class='side-small' align='right'>";
echo "<b><font color='cc3300'>Ž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();
Redagavo Taranas· 2011 Kov. 14 18:03:41