X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fonline_functions.php;h=ec0dffee1fc24f135b9b8c0d9608275d24f1d796;hb=0187fd5903cddd98c2152dbb4c84da58e5083303;hp=02c0b4166336ca35043b6448801dc40e2348f711;hpb=0f9689b7d070311251abdc1dc3c5f970a4227021;p=mailer.git diff --git a/inc/libs/online_functions.php b/inc/libs/online_functions.php index 02c0b41663..ec0dffee1f 100644 --- a/inc/libs/online_functions.php +++ b/inc/libs/online_functions.php @@ -1,7 +1,7 @@ "; - debug_print_backtrace(); - die(""); + debug_report_bug(__FUNCTION__, __LINE__, 'Invalid session.'); } // END - if // Initialize variables - $uid = 0; $rid = 0; $MEM = "N"; $ADMIN = "N"; + $userid = '0'; + $isMember = 'N'; + $isAdmin = 'N'; + $action = getActionFromModuleWhat(getModule(), getWhat()); // Valid userid? - if ((!empty($GLOBALS['userid'])) && ($GLOBALS['userid'] > 0) && (IS_MEMBER())) { + if (isMember()) { // Is valid user - $uid = bigintval($GLOBALS['userid']); - $MEM = "Y"; + $userid = getMemberId(); + $isMember = 'Y'; } // END - if - if (IS_ADMIN()) { + if (isAdmin()) { // Is administrator - $ADMIN = "Y"; - } // END - if - - if (!empty($GLOBALS['refid'])) { - // Read cookie - $rid = bigintval($GLOBALS['refid']); + $isAdmin = 'Y'; } // END - if // Now search for the user - $result = SQL_QUERY_ESC("SELECT timestamp FROM "._MYSQL_PREFIX."_online WHERE sid='%s' LIMIT 1", - array($PHPSESSID), __FILE__, __LINE__); + $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(), - $PHPSESSID - ), __FILE__, __LINE__ - ); + 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( + getModule(), + $action, + getWhat(), + $userid, + makeDatabaseUserId(determineReferalId()), + $isMember, + $isAdmin, + detectRemoteAddr(), + 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')", + 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, - $PHPSESSID, - GET_REMOTE_ADDR() - ), __FILE__, __LINE__ - ); + getModule(), + $action, + getWhat(), + $userid, + makeDatabaseUserId(determineReferalId()), + $isMember, + $isAdmin, + session_id(), + detectRemoteAddr() + ), __FUNCTION__, __LINE__); } // Free result SQL_FREERESULT($result); // Purge old entries - $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_online WHERE timestamp <= (UNIX_TIMESTAMP() - %s)", - array(getConfig('online_timeout')), __FILE__, __LINE__); + SQL_QUERY('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_online` WHERE `timestamp` <= (UNIX_TIMESTAMP() - {?online_timeout?})', __FUNCTION__, __LINE__); } -// +// [EOF] ?>