判断是否登陆

$rs = $mysqli->query("select `uid` from `k_user_login` where uid=".$t_uid." limit 1");

$login_id = $time.'_'.$t_uid.'_'.$username;

if($row = $rs->fetch_array()){

$stmt = $mysqli->prepare("update `k_user_login` set `login_id`=?,`login_time`=?,`is_login`=1,www=? WHERE `uid`=?");

$stmt->bind_param("sisi",$login_id,$time,$conf_www,$t_uid);

$stmt->execute();

$stmt->close();

//$mysqli->query("update `k_user_login` set `login_id`='$time".'_'.$t_uid.'_'."$username',`login_time`='$time',`is_login`=1,www='$conf_www' WHERE `uid`='".$t_uid."'");

}else{

$stmt = $mysqli->prepare("insert into `k_user_login` (`login_id`,`uid`,`login_time`,`is_login`,www) VALUES (?,?,?,1,?)");

$stmt->bind_param("siis",$login_id,$t_uid,$time,$conf_www);

$stmt->execute();

$stmt->close();

//$mysqli->query("insert into `k_user_login` (`login_id`,`uid`,`login_time`,`is_login`,www) VALUES ('$time".'_'.$t_uid.'_'."$username','".$t_uid."','$time',1,'$conf_www')");

}

 

$_SESSION["uid"] = $t_uid;

$_SESSION["is_daili"] = $t_is_daili;

$_SESSION["gid"] = $t_gid; //所属权限组

$_SESSION["username"] = $username;

$_SESSION["denlu"] = "one";

$_SESSION['user_login_id'] = $time.'_'.$t_uid.'_'.$username;

$_SESSION["password"] = $passwrod;

$sql="UPDATE `k_user` SET `log_session`='".$_SESSION['user_login_id']."' WHERE (`uid`='$t_uid')";

 

 

 

 

$loginid= @$_SESSION['user_login_id'];

renovate($uid,$loginid); //验证是否登陆

 

/*删除不在线用户*/

function renovate($uid,$loginid){

if($uid && $loginid) {

global $mysqli;

$sql = "select uid from k_user where uid=$uid and log_session='".$_SESSION['user_login_id']."' limit 1";

$query = $mysqli->query($sql);

$rs = $query->fetch_array();

if(!$rs['uid']){

session_destroy();

echo "<script>alert('您的账号已在别处登录！');window.open('/logout.php','_top');</script>";  

exit();

}

/*

$tims = time();

$time = $tims-36000;

 

$mysqli->autocommit(FALSE);

$mysqli->query("BEGIN"); //事务开始

try{

$mysqli->query("update `k_user_login` set `is_login`=0 WHERE login_time<$time and `is_login`>0");

$q1 = $mysqli->affected_rows;

if($q1 > 0){

$mysqli->commit(); //事务提交

}else{

$mysqli->rollback(); //数据回滚

}

}catch(Exception $e){

$mysqli->rollback(); //数据回滚

}

 

$query = $mysqli->query("select id from `k_user_login` where `uid`='$uid' and `login_id`='$loginid' and `is_login`=0 limit 1");

$rs = $query->fetch_array();

if($rs['id'] > 0){

$mysqli->query("update `k_user_login` set `is_login`=0 where `uid`=$uid");

session_destroy();

echo "<script>parent.location.href='/'</script>";

exit;

}

*/

}else{

return true;

}

return true;

}