<?php

session_start();


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

if( session_is_registered("alogin") ) {
    $query = "SELECT * FROM members WHERE deleted=''";
	$result = mysql_query ($query)
	     or die ("Query failed");
       $num_rows = mysql_num_rows($result);
    	?><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>";
    echo "<center><p><b>";
    echo "$num_rows Results found<br><br>";
	
	echo mysql_result(mysql_query("SELECT COUNT(*) FROM members WHERE memtype = 'FREE' and deleted=''"),0). " Free members<br>";
	echo mysql_result(mysql_query("SELECT COUNT(*) FROM members WHERE memtype = 'PRO' and deleted=''"),0). " $proname members<br>";
	echo mysql_result(mysql_query("SELECT COUNT(*) FROM members WHERE memtype = 'PRO2' and deleted=''"),0). " $pro2name members<br>";
	
	echo "<br><br><a href=\"memberlist.php\">Download member list</a>";
	
    echo "</center></p></b>";
    ?>
    <table width=70% border=0 cellpadding=2 cellspacing=2>


  		<tr>
          <td bgcolor="<? echo $contrastcolour; ?>"><center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>">Name</font></center></td>
          <td bgcolor="<? echo $contrastcolour; ?>"><center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>">Userid</font></center></td>
          <td bgcolor="<? echo $contrastcolour; ?>"><center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>">Membership</font></center></td>
          <td bgcolor="<? echo $contrastcolour; ?>"><center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>">Contact Email</font></center></td>
          <td bgcolor="<? echo $contrastcolour; ?>"><center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>">IP</font></center></td>
		  <td bgcolor="<? echo $contrastcolour; ?>"><center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>">Came from</font></center></td>
          <td bgcolor="<? echo $contrastcolour; ?>"><center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>">Edit Member</font></center></td>
          <td bgcolor="<? echo $contrastcolour; ?>"><center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>">Verified</font></center></td>
        </tr>
    <?

    while ($line = mysql_fetch_array($result)) {
		$name = $line["name"];
        $userid = $line["userid"];
	    $contactemail = $line["contact_email"];
        $subscribedemail = $line["subscribed_email"];
        $verified = $line["verified"];
        $ip = $line["ip"];
        $memtype = $line["memtype"];
		
		$referrer = $line["referrer"];
		if(strlen($referrer) > 65) $referrer = substr($referrer,0,63)."..";
        ?>
  		<tr>
          <td bgcolor="<? echo $basecolour; ?>"><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>"><center><? echo $name; ?></font></center></td>
          <td bgcolor="<? echo $basecolour; ?>"><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>"><center><a href="memberlogin.php?userid=<? echo $userid; ?>"><? echo $userid; ?></a><br>referred by <? echo $line["referid"]; ?></font></center></td>
          <td bgcolor="<? echo $basecolour; ?>"><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>"><center>
		  		<? 			
				if($memtype=="PRO") echo $proname;
				elseif($memtype=="PRO2") echo $pro2name;
				else echo 'Free';
				?>
		  </font></center></td>
          <td bgcolor="<? echo $basecolour; ?>"><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>"><center><? echo $contactemail; ?></font></center></td>
          <td bgcolor="<? echo $basecolour; ?>"><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>"><center><? echo $ip; ?></font></center></td>
		  <td bgcolor="<? echo $basecolour; ?>"><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>"><center><? echo $referrer; ?></font></center></td>
          <td valign="middle" bgcolor="<? echo $basecolour; ?>"><center><br>
          <form method=POST action=edit.php>
          <input type="hidden" name="userid" value="<? echo $userid; ?>">
          <input type="submit" value="Edit">
          </form> </center>
          </td>

          <? if ($verified == 1) { ?>
             <td bgcolor="<? echo $basecolour; ?>"<center><font size=2 face="<? echo $fonttype; ?>" color="<? echo $fontcolour; ?>">Yes</font></center></td>
          <? } if ($verified == 0) { ?>
          	<td bgcolor="<? echo $basecolour; ?>" valign="middle"><center><br>
          	<form method="POST" action="resendv.php">
          	<input type="hidden" name="userid" value="<? echo $userid; ?>">
          	<input type="hidden" name="email" value="<? echo $subscribedemail; ?>">
          	<input type="submit" value="Resend">
          	</form> </center>
          	</td>
        	</tr>
        <? }
     }
     echo "</table></td></tr></table>";
  	}
else  {
	echo "Unauthorised Access!";
    }

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