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(); }