<?php

include("../include/class.mysqldb.php");
include("../include/config.inc.php");

if ($_REQUEST["action"] == "login") {

    $passwd = md5("O]O" . $_REQUEST["pass"] . "O[O");

    //$sql = "SELECT * FROM ums2.umuser WHERE UsLogin = '" . $_REQUEST["user"] . "' AND UsPassword = '" . $passwd . "' AND UsActive = '1' AND UsAdmin = '1'";
    $sql = "SELECT * FROM ums2.umuser uu
            LEFT JOIN ums2.umusergroup uug ON uug.UgUsId = uu.UsId
            WHERE uu.UsLogin = '" . $_REQUEST["user"] . "' AND uu.UsPassword = '" . $passwd . "' AND uu.UsActive = '1' AND (uu.UsAdmin = '1' OR uug.UgGpID = '70070')";
    $link->query($sql);
    //$data = $link->getnext();
    $permission = 0;
    $usName;
    $usLogin;

    if ($link->num_rows()) {
        while ($data = $link->getnext()) {
            if($data->UsAdmin == "1" || $data->UgGpID == "70070"){
                $permission = 1;
                $usName = $data->UsName;
                $usLogin = $data->UsLogin;
            }
        }
    }

    if ($permission == "1") {
        $_SESSION["isLogin"] = true;
        $_SESSION["UsName"] = $usName;
        $_SESSION["UsLogin"] = $usLogin;
        echo "Login success";
    } else {
        echo "Login failed";
    }
}
?>