public static function Login ($login_name, $pass, $redirect)
{
$md5pass = md5($pass);
$user_exists = DataBase::ExecuteScalar("SELECT count(1) FROM users WHERE login = '******' AND password = '******'");
if($user_exists == 1){
$qry = "SELECT * FROM users WHERE login = '******' AND password = '******'";
//echo $qry;
$row = DataBase::ExecuteQuery($qry);
$_SESSION["user"] = new User($row[0][0], $row[0][1], $row[0][2], $row[0][3], $row[0][4], $row[0][5]);
//print_r($row);
#-----------------------------
echo "<script>window.location = '$redirect'</script>";
}else{
echo "Nombre de Usuario y Contraseña no coinciden, Favor de reintentar.";
}
}
function getProfileName($profileID)
{
$sql = "SELECT nombre FROM security_profiles WHERE id=" . $profileID;
return DataBase::ExecuteScalar($sql);
}
