<?php
	include 'MS.php';
	include 'AdminRedirect.php';
	include 'top.php';
	
	$UserName;
	$Error = 0;
	
	if (!empty($_POST['submitAdmin'])) {
		if (empty($_POST['User'])) {
			echo ("<script>alert('Please select a user');</script>");
			$Error++;
		}
		else {
			$UserName = $_POST['User'];
		}
		
		if ($Error == 0) {
			$dbName = "brentsweldingadmin";
			RemoveAccount($ServerName, $ServerUserName, $ServerPassword, $dbName, $UserName);
		}
	}
	
	if (!empty($_POST['submitUser'])) {
		if (empty($_POST['User2'])) {
			echo ("<script>alert('Please select a user');</script>");
			$Error++;
		}
		else {
			$UserName = $_POST['User2'];
		}
		
		if ($Error == 0) {
			$dbName = "brentswelding";
			RemoveAccount($ServerName, $ServerUserName, $ServerPassword, $dbName, $UserName);
		}
	}
	
	function RemoveAccount($ServerName, $ServerUserName, $ServerPassword, $dbName, $UserName)
	{
		//Create Connection
		$conDataBase = new mysqli($ServerName, $ServerUserName, $ServerPassword, $dbName);
		if ($conDataBase->connect_error) {
			die ("Connection failed: " . $conDataBase->connect_error);
		}
		
		$sql = "DELETE FROM users where username='".$UserName."'";
		
		if ($conDataBase->query($sql) === TRUE) {
			echo ("<script>alert('done');</script>");
		}
		else {
			echo ("<script>alert('Error ". $conDataBase->error ."');</script>");
		}
		
		$conDataBase->close();
	}
?>
<!DOCTYPE html>
<html>
	<head>
    	<link rel="stylesheet" type="text/css" href="body.css">
        <link rel="stylesheet" type="text/css" href="AdminSideBar.css">
        <style>
			div.AccountsContainer {width: 100%; margin: 0px auto; margin-botton: 50px; text-align: center; border: 1px solid white;}
			div.Accounts {width: 100; height: 500px; margin: 0px auto; text-align: center; border: 5px solid white; overflow: auto;}
			div.button {float: right; width: 100px; height: 20px; text-align: center; border: 5px solid white;}
			
			table, th, td {border: 1px solid white; border-collapse: collapse; color: white;}
		</style>
    </head>
    <body class="background">
    	<div class="sidebar">
            <div class="infoContainer"><a href="AccountManager.php">Account Manager</a></div>
            <div class="infoContainer"><a href="TextEdit.php">Page Text Editor</a></div>
            <div class="infoContainer"><a href="APhotoManager.php">Photos</a></div>
            <div class="infoContainer"><a href="AReview.php">Review Manager</a></div>
            <div class="infoContainer"><a href="ALogOut.php">LogOut</a></div>
        </div>
        <div style="float: left; width: 75%; border: 1px solid grey; background-color: black; line-height: 150%; text-align: center;">
        	<h1>Admin Accounts</h1>
            <form method="post" name="adminAccounts">
            	<div class="Accounts">
            		<table style="width: 100%;">
                    	<tr>
                        	<td></td>
                            <td>#</td>
                            <td>UserName</td>
                            <td>Password</td>
                            <td>Email</td>
                            <td>First Name</td>
                            <td>Last Name</td>
                            <td>Time Stamp</td>
                        </tr>
                        <?php
							$dbName = "brentsweldingadmin";
							
							//Create Connection
							$conDataBase = new mysqli($ServerName, $ServerUserName, $ServerPassword, $dbName);
							if ($conDataBase->connect_error) {
								die ("Connection failed: " . $conDataBase->connect_error);
							}
							
							$sql = "SELECT id, username, password, firstname, lastname, email, reg_data FROM users";
							$result = $conDataBase->query($sql);
							
							if ($result->num_rows > 0) {
								while ($row = $result->fetch_assoc()) {
									echo ("<tr><td><input type='radio' name='User' value='".$row['username']."' /></td><td>".$row['id']."</td><td>".$row['username']."</td><td>".$row['password']."</td><td>".$row['email']."</td><td>".$row['firstname']."</td><td>".$row['lastname']."</td><td>".$row['reg_data']."</td></tr>");
								}
							}
							else {
								echo ("<p>0 Results</p>");
							}
							
							$conDataBase->close();
						?>
                    </table>
            	</div>
                <div class="button">
                	<input type="submit" name="submitAdmin" value="Remove" style="width: 100%; height: 100%; background-color: black; color: white; border: none;">
                </div>                
            </form>
            <h1 style="margin-top: 50px;">User Accounts</h1>
            <form method="post" name="UserAccounts">
            	<div class="Accounts">
                	<table style="width: 100%;">
                    	<tr>
                        	<td></td>
                            <td>#</td>
                            <td>UserName</td>
                            <td>Password</td>
                            <td>Email</td>
                            <td>First Name</td>
                            <td>Last Name</td>
                            <td>Time Stamp</td>
                        </tr>
                        <?php
							$dbName = "brentswelding";
							
							//Create Connection
							$conDataBase = new mysqli($ServerName, $ServerUserName, $ServerPassword, $dbName);
							if ($conDataBase->connect_error) {
								die ("Connection failed: " . $conDataBase->connect_error);
							}
							
							$sql = "SELECT id, username, password, firstname, lastname, email, reg_data FROM users";
							$result = $conDataBase->query($sql);
							
							if ($result->num_rows > 0) {
								while ($row = $result->fetch_assoc()) {
									echo ("<tr><td><input type='radio' name='User2' value='".$row['username']."' /></td><td>".$row['id']."</td><td>".$row['username']."</td><td>".$row['password']."</td><td>".$row['email']."</td><td>".$row['firstname']."</td><td>".$row['lastname']."</td><td>".$row['reg_data']."</td></tr>");
								}
							}
							else {
								echo ("<p>0 Results</p>");
							}
							
							$conDataBase->close();
						?>
                    </table>
                </div>
                <div class="button">
                	<input type="submit" name="submitUser" value="Remove" style="width: 100%; height: 100%; background-color: black; color: white; border: none;">
                </div> 
            </form>
        </div>
        <div class="sidebarRight">
            <div class="infoContainer"><a href="AView.php">View</a></div>
            <div class="infoContainer"><a href="ASignUp.php">SignUp</a></div>
        	<div class="infoContainer"><a href="AdminAccountEdit.php">Edit Account</a></div>
            <div class="infoContainer"><a href="RemoveAccounts.php">Remove Account</a></div>
        </div>
    </body>
</html>