From 522e3151fc54f45bab7de4b4a3e103b24dd14593 Mon Sep 17 00:00:00 2001 From: Kazuki Przyborowski Date: Sat, 5 Jun 2010 18:04:43 +0000 Subject: [PATCH] Small update to User Online List. git-svn-id: svn://svn.code.sf.net/p/intdb/svn/trunk@513 2b68903e-0b30-0410-9a39-a2e4f3c5be39 --- inc/members.php | 12 +++++++----- inc/versioninfo.php | 4 ++-- sql.php | 8 +++++--- 3 files changed, 14 insertions(+), 10 deletions(-) diff --git a/inc/members.php b/inc/members.php index bd73353..f190c10 100644 --- a/inc/members.php +++ b/inc/members.php @@ -11,7 +11,7 @@ Copyright 2004-2010 iDB Support - http://idb.berlios.de/ Copyright 2004-2010 Game Maker 2k - http://gamemaker2k.org/ - $FileInfo: members.php - Last Update: 06/04/2010 SVN 509 - Author: cooldude2k $ + $FileInfo: members.php - Last Update: 06/05/2010 SVN 513 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="members.php"||$File3Name=="/members.php") { @@ -412,13 +412,15 @@ if($pagenum>1) { while ($i < $num) { $AmIHiddenUser = "no"; $session_data=sql_result($result,$i,"session_data"); +$session_user_agent=sql_result($result,$i,"user_agent"); +$session_ip_address=sql_result($result,$i,"ip_address"); $session_expires=sql_result($result,$i,"expires"); $session_expires = GMTimeChange("F j Y, g:i a",$session_expires,$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']); $UserSessInfo = unserialize_session($session_data); if(!isset($UserSessInfo['UserGroup'])) { $UserSessInfo['UserGroup'] = $Settings['GuestGroup']; } -if(!isset($UserSessInfo['UserIP'])) { - $UserSessInfo['UserIP'] = "127.0.0.1"; } +if(!isset($session_ip_address)) { + $session_ip_address = "127.0.0.1"; } if($UserSessInfo['UserGroup']!=$Settings['GuestGroup']) { $PreAmIHiddenUser = GetUserName($UserSessInfo['UserID'],$Settings['sqltable'],$SQLStat); $AmIHiddenUser = $PreAmIHiddenUser['Hidden']; } @@ -519,7 +521,7 @@ if($AmIHiddenUser=="no"&&$UserSessInfo['UserID']>0) { "> - ( ) + ( ) "> @@ -535,7 +537,7 @@ if($_GET['list']=="all"||$_GET['list']=="guests") { - ( ) + ( ) "> diff --git a/inc/versioninfo.php b/inc/versioninfo.php index 8788ac8..fafb097 100644 --- a/inc/versioninfo.php +++ b/inc/versioninfo.php @@ -11,7 +11,7 @@ Copyright 2004-2010 iDB Support - http://idb.berlios.de/ Copyright 2004-2010 Game Maker 2k - http://gamemaker2k.org/ - $FileInfo: versioninfo.php - Last Update: 06/05/2010 SVN 512 - Author: cooldude2k $ + $FileInfo: versioninfo.php - Last Update: 06/05/2010 SVN 513 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="versioninfo.php"||$File3Name=="/versioninfo.php") { @@ -27,7 +27,7 @@ function version_info($proname,$subver,$ver,$supver,$reltype,$svnver,$showsvn) { return $return_var; } // Version number and date stuff. :P $VER1[0] = 0; $VER1[1] = 4; $VER1[2] = 0; $VERFull[1] = $VER1[0].".".$VER1[1].".".$VER1[2]; -$VER2[0] = "Alpha"; $VER2[1] = "Al"; $VER2[2] = "SVN"; $SubVerN = 512; $RName = "iDB"; $SFName = "IntDB"; +$VER2[0] = "Alpha"; $VER2[1] = "Al"; $VER2[2] = "SVN"; $SubVerN = 513; $RName = "iDB"; $SFName = "IntDB"; $SVNDay[0] = 06; $SVNDay[1] = 05; $SVNDay[2] = 2010; $SVNDay[3] = $SVNDay[0]."/".$SVNDay[1]."/".$SVNDay[2]; $VerInfo['iDB_Ver'] = version_info($RName,$VER1[0],$VER1[1],$VER1[2],$VER2[1],$SubVerN,false); $VerInfo['iDB_Ver_SVN'] = version_info($RName,$VER1[0],$VER1[1],$VER1[2],$VER2[1],$SubVerN,true); diff --git a/sql.php b/sql.php index 627da01..c0e1554 100644 --- a/sql.php +++ b/sql.php @@ -11,7 +11,7 @@ Copyright 2004-2010 iDB Support - http://idb.berlios.de/ Copyright 2004-2010 Game Maker 2k - http://gamemaker2k.org/ - $FileInfo: sql.php - Last Update: 06/05/2010 SVN 512 - Author: cooldude2k $ + $FileInfo: sql.php - Last Update: 06/05/2010 SVN 513 - Author: cooldude2k $ */ /* Some ini setting changes uncomment if you need them. Display PHP Errors */ @@ -325,9 +325,9 @@ sql_query(sql_pre_query("UPDATE \"".$sqltable."sessions\" SET \"session_data\"=' return $data; } } //Session Write Function function sqlsession_write($id,$data) { -global $sqltable,$SQLStat,$SQLSType; +global $sqltable,$SQLStat,$SQLSType,$temp_user_ip,$temp_user_agent; $time = GMTimeStamp(); -$rs = sql_query(sql_pre_query("UPDATE \"".$sqltable."sessions\" SET \"session_data\"='%s',\"expires\"=%i WHERE \"session_id\"='%s'", array($data,$time,$id)),$SQLStat); +$rs = sql_query(sql_pre_query("UPDATE \"".$sqltable."sessions\" SET \"session_data\"='%s',\"user_agent\"='%s',\"ip_address\"='%s',\"expires\"=%i WHERE \"session_id\"='%s'", array($data,$temp_user_agent,$temp_user_ip,$time,$id)),$SQLStat); return true; } //Session Destroy Function function sqlsession_destroy($id) { @@ -355,6 +355,8 @@ header("Pragma: private, no-cache, must-revalidate"); header("Date: ".gmdate("D, d M Y H:i:s")." GMT"); header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT"); header("Expires: ".gmdate("D, d M Y H:i:s")." GMT"); +if(!isset($_COOKIE[$Settings['sqltable']."sess"])) { +sql_query(sql_pre_query("DELETE FROM \"".$Settings['sqltable']."sessions\" WHERE \"expires\" < %i OR ip_address='%s'", array(GMTimeStamp(),$temp_user_ip)),$SQLStat); } session_name($Settings['sqltable']."sess"); session_start(); //header("Set-Cookie: PHPSESSID=" . session_id() . "; path=".$cbasedir); -- 2.11.0