<?php
include ('include/header.php');
?>

    <!-- BEGIN PAGE LEVEL PLUGINS -->
    <link href="assets/global/plugins/datatables/datatables.min.css" rel="stylesheet" type="text/css" />
    <link href="assets/global/plugins/datatables/plugins/bootstrap/datatables.bootstrap.css" rel="stylesheet" type="text/css" />
    <!-- END PAGE LEVEL PLUGINS -->
	
	

</head>
<body class="page-header-fixed page-sidebar-closed-hide-logo page-content-white">


	
<?php
include ('include/sidebar.php');
?>


<div class="page-content-wrapper">
<div class="page-content">
<h3 class="page-title"> View All Clients <small></small></h3>
<hr>
					
<div class="row">
<div class="col-md-12">


<!-- BEGIN EXAMPLE TABLE PORTLET-->
<div class="portlet light bordered">
<div class="portlet-title">
<div class="caption font-dark">
<!--i class="icon-settings font-dark"></i>
<span class="caption-subject bold uppercase">AAA</span-->
</div>
<div class="tools"> </div>
</div>
<div class="portlet-body">
<table class="table table-striped table-bordered table-hover" id="sample_1">
<thead>

										
										
<tr>
<th> Id </th>
<th> FirstName </th>
<th> LastName </th>
<th> AccountNumber </th>
<th> Mobile </th>
<th> Email </th>
<th> Balance </th>
<th> City </th>
<th> Country </th>
<th> IMFCode </th>
<th> IPNCode </th>
<th> COTCode </th>
<th> SignUpDate </th>
<th> AcountStatus </th>
<th> Edit </th>
</tr>

</thead><tbody>

<?php
$ddaa = mysql_query("SELECT id, accountnumber, firstname, lastname, email, phone, city, country, wallet, activation, signup_date, imfcode, ipncode, cotcode FROM user ORDER BY id");
while ($data = mysql_fetch_array($ddaa)){

if($data[9]=="1"){
$type = "<b style=\"color: red;\"> Banned</b>";
}

if($data[9]=="0"){
$type = "<b style=\"color: green;\"> Active</b>";
}




	

 echo "                                
 <tr>
 
                <td>$data[0]</td>
                <td>$data[2]</td>
                <td>$data[3]</td>
                <td>$data[1]</td>
                <td>$data[5]</td>
                <td>$data[4]</td>
                <td>$data[8]</td>
                <td>$data[6]</td>
                <td>$data[7]</td>
                
                <td>$data[11]</td>
                <td>$data[12]</td>
                <td>$data[13]</td>
                
                <td>$data[10]</td>
                <td>$type</td>
                <td><b><a href='edit_users.php?userID=$data[0]'>Edit</a></b></td>

                



</tr>";
	
	}

	
?>

</tbody>
</table>
</div>
</div>
<!-- END EXAMPLE TABLE PORTLET-->

</div>
</div><!-- ROW-->



</div>
<!-- END CONTENT BODY -->
</div>
<!-- END CONTENT -->



<?php
include ('include/footer.php');
?>

        <!-- BEGIN PAGE LEVEL PLUGINS -->
        <script src="assets/global/scripts/datatable.js" type="text/javascript"></script>
        <script src="assets/global/plugins/datatables/datatables.min.js" type="text/javascript"></script>
        <script src="assets/global/plugins/datatables/plugins/bootstrap/datatables.bootstrap.js" type="text/javascript"></script>
        <!-- END PAGE LEVEL PLUGINS -->
		
		 <!-- BEGIN PAGE LEVEL SCRIPTS -->
        <script src="assets/pages/scripts/table-datatables-buttons.min.js" type="text/javascript"></script>
        <!-- END PAGE LEVEL SCRIPTS -->
 
 </body>
</html>