function DB_check_login($dataArray)
{
removeSession();
session_start();
$sql = "SELECT * FROM user WHERE BINARY login_name='" . $dataArray['loginname'] . "' AND login_pw='" . $dataArray['loginpw'] . "'";
$result = mysql_query($sql);
$loginResult = mysql_num_rows($result);
if ($loginResult > 0) {
//login success
$loginUser = mysql_fetch_assoc($result);
session_regenerate_id(true);
$loginUserId = $loginUser['user_id'];
//$_SESSION['user_id'] = $loginUserId;
$_SESSION['identity'] = $loginUser['identity'];
if ($loginUser['identity'] == 'guest') {
$_SESSION['ulevel'] = 1;
} else {
if ($loginUser['identity'] == 'student' || $loginUser['identity'] == 'pre_teacher') {
$_SESSION['ulevel'] = 11;
} else {
if ($loginUser['identity'] == 'teacher') {
$_SESSION['ulevel'] = 31;
} else {
if ($loginUser['identity'] == 'admin') {
$_SESSION['ulevel'] = 101;
}
}
}
}
//$_SESSION['lang'] = $loginUser['lang'];
$sql2 = "SELECT user_id,userkey,username,org_id,userpic,homepage FROM user_profile WHERE user_id='" . $loginUserId . "'";
$result2 = mysql_query($sql2);
$loginUserInfo = mysql_fetch_assoc($result2);
$_SESSION['user_id'] = $loginUserInfo['user_id'];
$_SESSION['userkey'] = $loginUserInfo['userkey'];
$_SESSION['userpic'] = $loginUserInfo['userpic'];
$_SESSION['realname'] = $loginUserInfo['username'];
$_SESSION['org_id'] = $loginUserInfo['org_id'];
//$_SESSION['wall'] = $loginUserInfo['userkey'];
toPrint_oneMsg('userkey', $loginUserInfo['userkey']);
//toPrint_oneMsg('wall',$_SESSION['wall']);
}
toPrint_oneMsg('login_user', $loginResult);
$recordStr = 'Result:' . $loginResult . '|Loginname:' . $dataArray['loginname'] . '|Loginpw:' . $dataArray['loginpw'] . '|Userkey:' . $_SESSION['userkey'];
recordlog('login', 'index', $recordStr);
}
public function desconectar()
{
removeSession();
hasSession();
}
