X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fonline_functions.php;h=bc8818fa22f5e8d14fb604deb73f193cd5632a4f;hp=c65a4953f7a17208a4138f5a839734495cbe7e83;hb=63f159414369b5ea19a8ca75d8cd8033c45d8341;hpb=3af8b17c962e094e3eaffbd6d111290cdb286c92 diff --git a/inc/libs/online_functions.php b/inc/libs/online_functions.php index c65a4953f7..bc8818fa22 100644 --- a/inc/libs/online_functions.php +++ b/inc/libs/online_functions.php @@ -1,7 +1,7 @@ 0) && (IS_MEMBER())) { - // Is valid user - $uid = getUserId(); - $MEM = "Y"; - } // END - if - - if (IS_ADMIN()) { - // Is administrator - $ADMIN = "Y"; - } // END - if - - if (!empty($GLOBALS['refid'])) { - // Read cookie - $rid = bigintval($GLOBALS['refid']); - } // END - if - - // Now search for the user - $result = SQL_QUERY_ESC("SELECT timestamp FROM `{!_MYSQL_PREFIX!}_online` WHERE sid='%s' LIMIT 1", - array(session_id()), __FUNCTION__, __LINE__); - - // Entry found? - if (SQL_NUMROWS($result) == 1) { - // Then update it - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_online` SET -`module`='%s', -`action`='%s', -`what`='%s', -userid=%s, -refid=%s, -is_member='%s', -is_admin='%s', -timestamp=UNIX_TIMESTAMP(), -ip='%s' -WHERE sid='%s' LIMIT 1", - array( - $GLOBALS['module'], - $GLOBALS['action'], - $GLOBALS['what'], - $uid, - $rid, - $MEM, - $ADMIN, - GET_REMOTE_ADDR(), - session_id() - ), __FUNCTION__, __LINE__ - ); - } else { - // No entry does exists so we simply add it! - SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_online` (module, action, what, userid, refid, is_member, is_admin, timestamp, sid, ip) VALUES ('%s','%s','%s', %s, %s, '%s','%s', UNIX_TIMESTAMP(), '%s','%s')", - array( - $GLOBALS['module'], - $GLOBALS['action'], - $GLOBALS['what'], - $uid, - $rid, - $MEM, - $ADMIN, - session_id(), - GET_REMOTE_ADDR() - ), __FUNCTION__, __LINE__ - ); - } - - // Free result - SQL_FREERESULT($result); - - // Purge old entries - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_online` WHERE timestamp <= (UNIX_TIMESTAMP() - %s)", - array(getConfig('online_timeout')), __FUNCTION__, __LINE__); -} - -// +// [EOF] ?>