<?php

	// Connect to database
	require('connect.php');

	// Check for submission
	if(isset($_POST['adduser'])) {
		// Set some variables
		$username = mysqli_real_escape_string($db,$_POST['username']);
		$password = md5(mysqli_real_escape_string($db,$_POST['password']));
		$fullname = mysqli_real_escape_string($db,$_POST['fullname']);
		$linkedcode = mysqli_real_escape_string($db,$_POST['linkedcode']);
		$level = mysqli_real_escape_string($db,$_POST['level']);

		// Check database for duplicates
		$check = mysqli_query($db,"SELECT * FROM users WHERE username = '$username' OR fullname = '$fullname' OR linkedcode = '$linkedcode'");
			if(mysqli_num_rows($check) >= 1) {
				echo "A user like this already exists!";
			}

		// Insert user into database
		$adduser = mysqli_query($db,"INSERT INTO users (username, password, fullname, linkedcodes, level) VALUES ('$username', '$password', '$fullname', '$linkedcode', '$level')");

		// Check query success
		if(!$adduser) {
			die('Error :' . mysqli_error($db));
		} else {
			echo "User added successfully!";
		}
	}

?>