Autenticação Externa Moodle - Valodia

<?php
/*
Login Moodle para aplicações externas com identificação de perfil de usuario
Perfil de usuarios no Moodle
1 – Administrador
2 - Criador de Curso
3 – Tutor
4 - Tutor nao editor
5 – Aluno
6 – Visistante
7 - Usuario não autenticado
*/

$conn = new mysqli("#####","###","#####","moodle");
$conn-> set_charset ("utf8");
error_reporting(0);

/* check connection */
if (mysqli_connect_errno()) {
    printf("Falha de conexão", mysqli_connect_error());
    exit();
}

session_start();

$username = $_POST['username'];
$password = $_POST['password'];

if (!empty($username) && !empty($password)) {

$query = "SELECT distinct mdl_user.id, mdl_user.username, mdl_user.password,  mdl_user.firstname, mdl_user.lastname, mdl_role_assignments.userid, mdl_role_assignments.roleid FROM `mdl_user` Inner Join
mdl_role_assignments on mdl_user.id = mdl_role_assignments.userid WHERE username = '{$username}' order by roleid asc ";

$result = $conn->query($query);
while($row = mysqli_fetch_array($result))

{
	$hash = $row['password'];
	$roleid = $row['roleid'];

	if (crypt($password, $hash) === $hash)
	{
		$_SESSION['username']=$username;
		$_SESSION['password']=$password;
		header('location:index.php');

	} else {
		header('location:login.php');

	}
}

}	else {
		header('location:login.php');

	}
/*



*/
?>