Топ-100

<!--

-->
<? if ($_GET['show'] == 'nodes') : ?>

<?
$res = db_query('SELECT * FROM {node} n LEFT JOIN {node_comment_statistics} s ON n.nid = s.nid ORDER BY s.comment_count DESC LIMIT 300');
$counter = 1;
while ($n = db_fetch_object($res)) {
echo '

';
$counter++;
}
?>

<? endif; ?>
<? if ($_GET['show'] != 'nodes') : ?>

<?
$res = db_query('SELECT * FROM {users} WHERE uid > 1 and uid <> 2453 ORDER BY karma DESC LIMIT 100');
$counter = 1;
while ($u = db_fetch_object($res)) {
$c1 = db_fetch_object(db_query('SELECT count(*) as nodes FROM {node} WHERE uid = '.$u->uid));
$c2 = db_fetch_object(db_query('SELECT count(*) as comments FROM {comments} WHERE uid = '.$u->uid));
echo '

';
$counter++;
}
?>

<? endif; ?>Air Zoom Pegasus 33