X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fonline_functions.php;h=9bf00786400cc069000bb391454a0a491ee623cd;hb=b1cf96c4a5a63a1d334119a0681e5fbf68edf527;hp=0348497e653d61eabc66243f9e87ac155c72e31a;hpb=a14286dbeccc671261191608fbab164d0f35c507;p=mailer.git diff --git a/inc/libs/online_functions.php b/inc/libs/online_functions.php index 0348497e65..9bf0078640 100644 --- a/inc/libs/online_functions.php +++ b/inc/libs/online_functions.php @@ -1,6 +1,6 @@ 0) && (IS_MEMBER())) { + if ((isMemberIdSet()) && (getMemberId() > 0) && (isMember())) { // Is valid user - $uid = getUserId(); + $userid = getMemberId(); $MEM = 'Y'; } // END - if - if (IS_ADMIN()) { + if (isAdmin()) { // Is administrator $ADMIN = 'Y'; } // END - if - if (!empty($GLOBALS['refid'])) { - // Read cookie - $rid = bigintval($GLOBALS['refid']); - } // END - if + // Get refid + $rid = determineReferalId(); // 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__); + $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` + `{?_MYSQL_PREFIX?}_online` SET `module`='%s', `action`='%s', `what`='%s', `userid`=%s, - `refid`=%s, + `refid`='%s', `is_member`='%s', `is_admin`='%s', `timestamp`=UNIX_TIMESTAMP(), @@ -99,7 +98,7 @@ LIMIT 1", getModule(), getAction(), getWhat(), - $uid, + $userid, $rid, $MEM, $ADMIN, @@ -108,12 +107,12 @@ LIMIT 1", ), __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( getModule(), getAction(), getWhat(), - $uid, + $userid, $rid, $MEM, $ADMIN, @@ -126,8 +125,7 @@ LIMIT 1", 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__); + SQL_QUERY('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_online` WHERE `timestamp` <= (UNIX_TIMESTAMP() - {?online_timeout?})', __FUNCTION__, __LINE__); } // [EOF]