QueryFetchArrayAll("SELECT a.ref, COUNT(a.id) AS total, b.login FROM users a LEFT JOIN users b ON b.id = a.ref WHERE (a.ref != '0' AND a.ref_paid = 1) AND b.login != ''".$db_custom." GROUP BY a.ref ORDER BY total DESC LIMIT 15"); $j = 0; foreach($refs as $ref){ ++$j; echo ''; } if($j == 0){ echo ''; } ?>
#
'.($j == 1 ? ''.$j.'' : ($j == 2 ? ''.$j.'' : ($j == 3 ? ''.$j.'' : $j))).''.$ref['login'].''.number_format($ref['total']).'
'.$lang['b_250'].'
QueryFetchArray("SELECT COUNT(*) AS `total`, SUM(`views`) AS `views`, SUM(`clicks`) AS `clicks` FROM `banners`"); } if($site['allow_withdraw'] == 1){ $total_paid = $db->QueryFetchArray("SELECT COUNT(*) AS `payouts`, SUM(`amount`) AS `total` FROM `requests` WHERE `paid`='1'"); } ?>

Please wait...
Please wait...
QueryFetchArrayAll("SELECT a.uid, SUM(a.today_clicks) AS clicks, b.login FROM user_clicks a LEFT JOIN users b ON b.id = a.uid WHERE b.login != '' GROUP BY a.uid ORDER BY clicks DESC LIMIT 3"); if($tops){ ?> '.$top['login'].''; } ?>
123
0