<?php

session_start();

include "../config.php";
include "../header.php";
include "../style.php";

if( session_is_registered("alogin") ) {

    	?><table>
      	<tr>
        <td width="15%" valign=top><br>
        <? include("adminnavigation.php"); ?>
        </td>
        <td valign="top" align="center"><br><br> <?
    echo "<font size=2 face='$fonttype' color='$fontcolour'><p><center>";
    ?>
                        <table cellpadding="10" cellspacing="0" border="1">
                            <tr>
                                <td>Userid</td>
								<td align="right">Referrals</td>
                            </tr>
							<?php 	
									$_sql = "SELECT m1.referid, m2.userid, count(*) as referrals FROM members m1
									inner join members m2 on m1.referid=m2.userid 
									where m2.verified=1 and m1.verified=1 and m1.deleted='' and m2.deleted='' 
									group by m1.referid, m2.name ORDER BY referrals DESC";
									$list=mysql_query($_sql) or die(mysql_error());
									if(mysql_affected_rows()>0) {
										while ($row = mysql_fetch_array($list)) {
											echo "<tr><td>" . $row["userid"] . "</td>";
											echo "<td align=\"right\">" . $row["referrals"] . "</td></tr>";
										}
									}

     echo "</table></td></tr></table>";
  	}
else  {
	echo "Unauthorised Access!";
    }

include "../footer.php";
mysql_close($dblink);
?>