<?
//*********************************************************************************
// Original Website By : Niadesain.com Di Jual melalui http://niadesain.com
// Please Call / SMS : 081384745483 (support@niadesain.com)
// Niadesain.com - Jasa Pembuatan Website Paling Murah dan Paling Lengkap
//*********************************************************************************
?>
<?
	if($user_status > 0) {
?>

<?
$user = $user_session;
$data = preg_replace("{NAMAMEMBER}", $user_nama, $data);
$data = preg_replace("{USERNAME}", $user, $data);
?>
<div align="center">
  <table width="700" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr bgcolor="#FFFFFF">
      <td height="35" colspan="3"><div align="center"><font color="#FFFFFF"><strong><font color="#000066" size="2" face="Verdana, Arial, Helvetica, sans-serif">HALAMAN LIHAT PIN BELUM TERPAKAI </font></strong></font></div></td>
    </tr>
    <tr>
      <td width="10" bgcolor="#FFFFFF">&nbsp;</td>
      <td><p align="center">Rekan
          <?= $db->dataku("nama", $user_session); ?> 
          Yth, Berikut PIN yang Belum Anda Gunakan Untuk Aktivasi </p>
        <table width="95%" border="0" align="center" cellpadding="2" cellspacing="2" bgcolor="#E7E5D9">
          <tr>
            <td height="25" background="../images/left_head_1px.gif"><div align="center"><font color="#FFFF00" size="2" face="Verdana, Arial, Helvetica, sans-serif"> PIN Belum Terpakai </font></div></td>
          </tr>
          <tr>
            <td bgcolor="#FFFFFF"><table width="100%" border="0" cellpadding="2" cellspacing="2" bgcolor="#CCCCCC">
                <tr>
                  <td width="4%" height="26" align="center" bgcolor="#F2F1EC"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">No.</font></td>
                  <td width="15%" align="center" bgcolor="#F2F1EC"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Serial</font></td>
                  <td width="21%" align="center" bgcolor="#F2F1EC"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">PIN</font></td>
				  <td width="21%" align="center" bgcolor="#F2F1EC"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Username</font></td>
                  <td width="20%" align="center" bgcolor="#F2F1EC"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Dealer</font></td>
                  <td width="21%" align="center" bgcolor="#F2F1EC"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Status</font></td>
                </tr>
                <?
	$sbl=mysql_query("select * from card where dealer2='$user_session' and status='0' order by id");
	$nom=1;
	$jml = 0;
	while($row=mysql_fetch_row($sbl)) {
		echo "<tr bgcolor=#FFFFFF>
          <td align=center>$nom.</td>
          <td align=center>$row[1]</td>
		  <td align=center>$row[2]</td>
		  <td align=center>$row[3]</td>
		  <td align=center>$row[7]</td>
		  <td align=center>Belum Terpakai</td>
        </tr>";
		$jml = $jml + $row[9];
		$nom++;
	}
	?>

            </table></td>
          </tr>
        </table>        
        <p align="center">&nbsp;</p>
        <p align="center">Jumlah PIN Belum Terpakai : 
          <?= $jml; ?> 
          PIN</p></td>
      <td width="10" bgcolor="#FFFFFF">&nbsp;</td>
    </tr>
    <tr bgcolor="#FFFFFF">
      <td colspan="3">&nbsp;</td>
    </tr>
  </table>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>    <?
} else {
	include "index0.php";
}
?>
  </p>
    </p>
</div>
</div>

  