-// Update "refback table"
-function updateRefbackTable ($userid) {
- // Make it sure referal level zero (member him-/herself) is at least selected
- if (empty($GLOBALS['refback_level'])) {
- $GLOBALS['refback_level'] = NULL;
- } // END - if
- /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',level=' . $GLOBALS['refback_level'] . ' - ENTERED!');
-
- // Init refid and variables
- $GLOBALS['refback_refid'][$GLOBALS['refback_level']] = '0';
- $old = '0';
- $minus = '0';
-
- // Check for his referal
- $result_refid = SQL_QUERY_ESC("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `refid`=%s ORDER BY `userid` ASC",
- array(bigintval($userid)), __FUNCTION__, __LINE__);
-
- // When no entry was updated then we have to create it here
- /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'SQL_NUMROWS()=' . SQL_NUMROWS($result_refid));
- if (!SQL_HASZERONUMS($result_refid)) {
- // Load all refids
- while (list($GLOBALS['refback_refid'][$GLOBALS['refback_level']]) = SQL_FETCHROW($result_refid)) {
- // Remmber userid
- $GLOBALS['refback_userid'][$GLOBALS['refback_refid'][$GLOBALS['refback_level']]] = $userid;
-
- // Refid set?
- /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',ref=' . $GLOBALS['refback_refid'][$GLOBALS['refback_level']]);
- if (($GLOBALS['refback_refid'][$GLOBALS['refback_level']] > 0) && ($GLOBALS['refback_refid'][$GLOBALS['refback_level']] != $userid) && (isset($GLOBALS['refback_refid'][$GLOBALS['refback_level']]))) {
- // New userid?
- if ((isset($GLOBALS['refback_refid'][$GLOBALS['refback_level']-1])) && (isset($GLOBALS['refback_userid'][$GLOBALS['refback_refid'][$GLOBALS['refback_level']-1]]))) {
- // New userid!
- $old = $userid;
- $userid = $GLOBALS['refback_userid'][$GLOBALS['refback_refid'][$GLOBALS['refback_level']-1]];
- $minus = 1;
- /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',old=' . $old . ',level=' . $GLOBALS['refback_level'] . ',ref=' . $GLOBALS['refback_refid'][$GLOBALS['refback_level']] . ' - NEW UID!');
- } // END - if
-
- // Check existence
- if (is_null($GLOBALS['refback_level'])) {
- // Level is NULL
- $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `level` IS NULL AND `refid`=%s LIMIT 1",
- array(
- bigintval($userid),
- bigintval($GLOBALS['refback_refid'][$GLOBALS['refback_level']])
- ), __FUNCTION__, __LINE__);
- } else {
- // Level is > 0
- $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `level`=%s AND `refid`=%s LIMIT 1",
- array(
- bigintval($userid),
- bigintval($GLOBALS['refback_level']),
- bigintval($GLOBALS['refback_refid'][$GLOBALS['refback_level']])
- ), __FUNCTION__, __LINE__);
- }
-
- // Do we have no entry?
- /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',level=' . $GLOBALS['refback_level'] . ',ref=' . $GLOBALS['refback_refid'][$GLOBALS['refback_level']] . ',minus=' . $minus . ',numRows=' . SQL_NUMROWS($result) . ' - FOUND!');
- if (SQL_HASZERONUMS($result)) {
- // Insert this level
- /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',level=' . $GLOBALS['refback_level'] . ',ref=' . $GLOBALS['refback_refid'][$GLOBALS['refback_level']] . ' - ADD!');
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_refs` (`userid`,`level`,`refid`) VALUES (%s,%s,%s)",
- array(
- bigintval($userid),
- $GLOBALS['refback_level'],
- bigintval($GLOBALS['refback_refid'][$GLOBALS['refback_level']])
- ), __FUNCTION__, __LINE__);
-
- // Move to next referal level and count his counter one up!
- $GLOBALS['refback_level']++;
- updateRefbackTable($GLOBALS['refback_refid'][($GLOBALS['refback_level'] - 1)]);
- } // END - if
-
- // Do we have another level here?
- if ((($GLOBALS['refback_level']-$minus) > 0) && ($old > 0)) {
- // Restore old one
- $userid = $old;
-
- // Shall we add this as well?
- $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `level`=%s AND `refid`=%s LIMIT 1",
- array(
- bigintval($userid),
- (bigintval($GLOBALS['refback_level']) - $minus),
- bigintval($GLOBALS['refback_refid'][$GLOBALS['refback_level']])
- ), __FUNCTION__, __LINE__);
-
- // Do we have no entry?
- /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',level=' . ($GLOBALS['refback_level'] - $minus) . ',minus=' . $minus . ',ref=' . $GLOBALS['refback_refid'][$GLOBALS['refback_level']] . ',numRows=' . SQL_NUMROWS($result) . ' - BACK!');
- if (SQL_HASZERONUMS($result)) {
- // Insert this level
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_refs` (`userid`,`level`,`refid`) VALUES (%s,%s,%s)",
- array(
- bigintval($userid),
- ($GLOBALS['refback_level'] - $minus),
- bigintval($GLOBALS['refback_refid'][$GLOBALS['refback_level']])
- ), __FUNCTION__, __LINE__);
- /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',level=' . ($GLOBALS['refback_level'] - $minus) . ',ref=' . $GLOBALS['refback_refid'][$GLOBALS['refback_level']] . ' - RETURNED!');
- } // END - if
- } // END - if
- } // END - if
- } // END - while
-
- // Free memory
- SQL_FREERESULT($result_refid);
- } // END - if
-
- // When he has a referal...
- if ((($GLOBALS['refback_refid'][$GLOBALS['refback_level']] == $userid) || ($GLOBALS['refback_refid'][$GLOBALS['refback_level']] == '0')) && (isExtensionInstalledAndNewer('cache', '0.1.2')) && (!isset($GLOBALS['refback_cached']))) {
- // Remove cache here
- /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',ref=' . $GLOBALS['refback_refid'][$GLOBALS['refback_level']] . ' - CACHE!');
- if ($GLOBALS['cache_instance']->loadCacheFile('refback')) $GLOBALS['cache_instance']->removeCacheFile();
- $GLOBALS['refback_cached'] = 1;
- } // END - if
-
- // "Walk" back here
- $GLOBALS['refback_level']--;
- /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',refback_level=' . $GLOBALS['refback_level'] .' - LEVEL!');
-
- // Fix empty refid
- if (!isset($GLOBALS['refback_refid'][$GLOBALS['refback_level']-1])) {
- $GLOBALS['refback_refid'][$GLOBALS['refback_level']-1] = '0';
- } // END - if
- /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',refback_level=' . $GLOBALS['refback_level'] . ',ref=' . $GLOBALS['refback_refid'][$GLOBALS['refback_level']-1] . ' - EXIT!');
-}
-