Просмотр поста

Вообщем вот код:

define('_IN_JOHNCMS', 1);

$textl = 'Реферальная система';
$rootpath = '../';

require("../incfiles/core.php");
require("../incfiles/head.php");


if($_GET['user']){
    echo '<div class="phdr">Информация о рефералах</div>';
    $usr_info = mysql_query("SELECT id,name FROM `users` WHERE `ref_id` = '".abs(intval($_GET['user']))."'");
    while($all_refs = mysql_fetch_assoc($usr_info)){
      echo '<div class="list1"><a href="../users/profile.php?user='.$all_refs['id'].'">'.$all_refs['name'].'</a></div>';  
    };
}

echo '<div class="phdr">Статистика рефереров</div>';

    $all_usr = mysql_query("SELECT id,name,ref_id FROM `users` WHERE `ref_id` > '0' GROUP BY `ref_id` LIMIT $start,$kmess"); //Все кого пригласили
    
     while($usr = mysql_fetch_assoc($all_usr)){
        
        $referer = mysql_fetch_assoc(mysql_query("SELECT id,name,ref_id FROM `users` WHERE `id` = '$usr[ref_id]' GROUP BY `ref_id`"));
        
        $all_ref = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `ref_id` = '$referer[id]'"),0);
        
        echo '<div class="menu"><a href="ref_stat.php?user='.$referer['id'].'">'.$referer['name'].'</a> - '.$all_ref.' реферал/ов</div>';
     }
     
     $total = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `ref_id` > '0' GROUP BY `ref_id`"),0); 
 
echo '<div class="phdr">Всего: '.$total.'</div>';
     
   echo functions::display_pagination('ref_stat.php?', $start, $total, $kmess);
   
require("../incfiles/end.php");