// to find a loop here... *sigh*
$result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_mod_reg
(module, locked, hidden, mem_only, admin_only, has_menu) VALUES
-('%s', 'Y', 'N', 'N', 'N', 'N')", array($mod_chk), __FILE__, __LINE__);
+('%s','Y','N','N','N','N')", array($mod_chk), __FILE__, __LINE__);
} else {
// Wrong/missing sql_patches!
$result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_mod_reg
(module, locked, hidden, mem_only, admin_only) VALUES
-('%s', 'Y', 'N', 'N', 'N')", array($mod_chk), __FILE__, __LINE__);
+('%s','Y','N','N','N')", array($mod_chk), __FILE__, __LINE__);
}
// Everthing is fine?
} // END - if
// Fix "deleted" cookies first
- FIX_DELETED_COOKIES(array('userid', 'u_hash', 'lifetime'));
+ FIX_DELETED_COOKIES(array('userid','u_hash','lifetime'));
// Are cookies set?
if ((!empty($GLOBALS['userid'])) && (isSessionVariableSet('u_hash')) && (isSessionVariableSet('lifetime')) && (defined('COOKIE_PATH')))
//* DEBUG: */ echo __LINE__."!!!<br />";
destroy_user_session();
- // Remove array elements to prevent errors
- unset($GLOBALS['userid']);
+ // Reset userid
+ $GLOBALS['userid'] = 0;
}
} else {
// Cookie data is invalid!
//* DEBUG: */ echo __LINE__."***<br />";
- // Remove array elements to prevent errors
- unset($GLOBALS['userid']);
+ // Reset userid
+ $GLOBALS['userid'] = 0;
}
// Free memory
//* DEBUG: */ echo __LINE__."///<br />";
destroy_user_session();
- // Remove array elements to prevent errors
- unset($GLOBALS['userid']);
+ // Reset userid
+ $GLOBALS['userid'] = 0;
}
// Cache status
if (SQL_NUMROWS($result) == 0)
{
// No, so we add one!
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_links (%s, userid, link_type) VALUES ('%s', '%s', '%s')",
+ $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_links (%s, userid, link_type) VALUES ('%s','%s','%s')",
array($rowName, $stats_id, bigintval($uid), $type), __FILE__, __LINE__);
$ret = "done";
}
return $ret;
}
//
-function GET_TOTAL_DATA($search, $tableName, $lookFor, $whereStatement="userid", $onlyRows=false)
-{
+function GET_TOTAL_DATA($search, $tableName, $lookFor, $whereStatement="userid", $onlyRows=false) {
$ret = 0;
if ($onlyRows) {
// Count rows
// Load row
list($ret) = SQL_FETCHROW($result);
- //* DEBUG: */ echo __LINE__."*".$DATA."/".$search."/".$tableName."/".$ret."*<br />\n";
+
+ // Free result
SQL_FREERESULT($result);
- if (empty($ret)) {
- if (($lookFor == "counter") || ($lookFor == "id")) {
- $ret = 0;
- } else {
- $ret = "0.00000";
+
+ // Fix empty values
+ if ((empty($ret)) && ($lookFor != "counter") && ($lookFor != "id") && ($lookFor != "userid")) {
+ $ret = "0.00000";
+ } // END - if
+
+ // Return value
+ return $ret;
+}
+// "Getter fro ref level percents
+function GET_REF_LEVEL_PERCENTS ($level) {
+ global $cacheInstance, $_CONFIG, $cacheArray;
+
+ // Default is zero
+ $per = 0;
+
+ // Do we have cache?
+ if ((isset($cacheArray['ref_depths']['level'])) && (EXT_IS_ACTIVE("cache"))) {
+ // First look for level
+ $key = array_search($level, $cacheArray['ref_depths']['level']);
+ if ($key !== false) {
+ // Entry found!
+ $per = $cacheArray['ref_depths']['percents'][$key];
+
+ // Count cache hit
+ $_CONFIG['cache_hits']++;
}
+ } else {
+ // Get referal data
+ $result_lvl = SQL_QUERY_ESC("SELECT percents FROM "._MYSQL_PREFIX."_refdepths WHERE level=%s LIMIT 1",
+ array(bigintval($level)), __FILE__, __LINE__);
+
+ // Entry found?
+ if (SQL_NUMROWS($result_lvl) == 1) {
+ // Get percents
+ list($per) = SQL_FETCHROW($result_lvl);
+ } // END - if
+
+ // Free result
+ SQL_FREERESULT($result_lvl);
}
- return $ret;
+
+ // Return percent
+ return $per;
}
/**
*
* for default value will cause no referral will get points ever!!!)
*/
function ADD_POINTS_REFSYSTEM($uid, $points, $send_notify=false, $rid="0", $locked=false, $add_mode="ref") {
- global $DEPTH, $_CONFIG, $DATA;
+ global $DEPTH, $_CONFIG, $DATA, $cacheArray;
// Convert mode to lower-case
$add_mode = strtolower($add_mode);
}
// Count up referral depth
- if (empty($DEPTH)) {
+ if (!isset($DEPTH)) {
// Initialialize referral system
$DEPTH = 0;
} else {
$DEPTH++;
}
- // Percents and table
- $percents = "percents"; if (isset($_CONFIG['db_percents'])) $percents = $_CONFIG['db_percents'];
- $table = "refdepths"; if (isset($_CONFIG['db_table'])) $table = $_CONFIG['db_table'];
-
// Default is "normal" points
$data = "points";
//* DEBUG */ echo "+".SQL_NUMROWS($result_user).":".$points."+<br />\n";
if (SQL_NUMROWS($result_user) == 1) {
// This is the user and his ref
- list ($ref, $email) = SQL_FETCHROW($result_user);
+ list($ref, $email) = SQL_FETCHROW($result_user);
+ $cacheArray['add_uid'][$ref] = $uid;
// Debug message
//DEBUG_LOG(__FUNCTION__.": ref={$ref},email={$email},DEPTH={$DEPTH}");
- // Get referal data
- $result_lvl = SQL_QUERY_ESC("SELECT %s FROM "._MYSQL_PREFIX."_%s WHERE level='%s' LIMIT 1",
- array($percents, $table, bigintval($DEPTH)), __FILE__, __LINE__);
- //* DEBUG */ echo "DEPTH:".$DEPTH."<br />\n";
- if (SQL_NUMROWS($result_lvl) == 1) {
- // Get percents
- list($per) = SQL_FETCHROW($result_lvl);
+ // Get percents
+ $per = GET_REF_LEVEL_PERCENTS($DEPTH);
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},points={$points},depth={$DEPTH},per={$per},mode={$add_mode}<br />\n";
+ // Some percents found?
+ if ($per > 0) {
// Calculate new points
$ref_points = $points * $per / 100;
+ // Pay refback here if level > 0 and in ref-mode
+ if (($DEPTH > 0) && ($per < 100) && ($add_mode == "ref")) {
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},data={$cacheArray['add_uid'][$uid]},ref_points={$ref_points},depth={$DEPTH} - BEFORE!<br />\n";
+ $ref_points = ADD_REFBACK_POINTS($cacheArray['add_uid'][$uid], $uid, $ref_points, $DEPTH);
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},data={$cacheArray['add_uid'][$uid]},ref_points={$ref_points},depth={$DEPTH} - AFTER!<br />\n";
+ } // END - if
+
// Debug message
//DEBUG_LOG(__FUNCTION__.": percent={$per},ref_points={$ref_points}");
// Update points...
+ //* DEBUG: */ echo __FUNCTION__.":data={$data},ref_points={$ref_points},uid={$uid},depth={$DEPTH} - UPDATE!<br />\n";
SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET %s=%s+%s WHERE userid=%s AND ref_depth=%d LIMIT 1",
array($data, $data, $ref_points, bigintval($uid), bigintval($DEPTH)), __FILE__, __LINE__);
if (($ref > 0) && ($points > 0) && ($ref != $uid) && ($add_mode == "ref")) {
// Then let's credit him here...
ADD_POINTS_REFSYSTEM($ref, $points, $send_notify, $ref, $locked);
- }
- }
+ } // END - if
+ } // END - if
+ } // END - if
- // Free result
- SQL_FREERESULT($result_lvl);
+ // Free result
+ SQL_FREERESULT($result_user);
+}
+// Payback refback for refid and reduce it for current user
+function ADD_REFBACK_POINTS ($uid, $ref, $points) {
+ global $DEPTH, $cacheArray;
+
+ // Init points
+ $return = $points;
+
+ // "Walk through all refids
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},ref={$ref},points={$points}<br />\n";
+ foreach (GET_REFBACK_USERID_ARRAY($uid) as $refid) {
+ // Skip level zero or if both are the same
+ if ($uid == $refid) continue;
+
+ // Get refback percents
+ $percents = GET_REFBACK_PERCENTS($uid, $refid);
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},ref={$ref},refid={$refid},points={$points},percents={$percents}<br />\n";
+
+ // Some percents given?
+ if ($percents > 0) {
+ // Get points for refback
+ $refback = $points * $percents / 100;
+
+ // Add points again, but only directly
+ //* DEBUG: */ echo __FUNCTION__.":refback={$refback},depth={$DEPTH}<br />\n";
+ $cacheArray['depth'][$uid][$ref] = $DEPTH; $DEPTH = -1;
+ ADD_POINTS_REFSYSTEM($uid, $refback, false, "0", false, "direct");
+ $DEPTH = $cacheArray['depth'][$uid][$ref];
+ //* DEBUG: */ echo __FUNCTION__.":depth={$DEPTH} - RESTORE!<br />\n";
+
+ // Reduce points if refid is found
+ if ($refid == $ref) {
+ // Reduce points here!
+ $return = $points - $refback;
+ //* DEBUG: */ echo __FUNCTION__.":points={$return} - REDUCED<br />\n";
+ } // END - if
+ } // END - if
+ } // END foreach
+
+ // Return them
+ return $return;
+}
+// "Getter" for refback percents
+function GET_REFBACK_PERCENTS ($uid, $ref) {
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},ref={$ref}<br />\n";
+ // Skip identical ids
+ if ($uid == $ref) return 0;
+
+ // Default is zero
+ $percents = 0;
+
+ // Get percents from database
+ $result = SQL_QUERY_ESC("SELECT refback FROM "._MYSQL_PREFIX."_user_refs WHERE userid=%s AND refid=%s LIMIT 1",
+ array($ref, $uid), __FILE__, __LINE__);
+
+ // Entry found? (Should be!)
+ if (SQL_NUMROWS($result) == 1) {
+ // Fetch percents
+ list($percents) = SQL_FETCHROW($result);
+ } else {
+ // Debug log
+ DEBUG_LOG(__FUNCTION__.": uid={$uid},ref={$ref} - No entry found! :-(");
}
// Free result
- SQL_FREERESULT($result_user);
+ SQL_FREERESULT($result);
+
+ // Return percents
+ return $percents;
+}
+// "Getter" for userid array
+function GET_REFBACK_USERID_ARRAY ($rid) {
+ //* DEBUG: */ echo __FUNCTION__.":rid={$rid}<br />\n";
+ // Init userids
+ $userIds = array();
+
+ // Look for all
+ $result = SQL_QUERY_ESC("SELECT userid
+FROM "._MYSQL_PREFIX."_user_refs
+WHERE refid=%s
+GROUP BY level
+ORDER BY userid ASC",
+ array($rid), __FILE__, __LINE__);
+
+ // Entries found?
+ if (SQL_NUMROWS($result) > 0) {
+ // Add all
+ while (list($userid) = SQL_FETCHROW($result)) {
+ //* DEBUG: */ echo __FUNCTION__.":rid={$rid},userid={$userid}<br />\n";
+ $userIds[] = $userid;
+ } // END - while
+ } // END - if
+
+ // Free result
+ SQL_FREERESULT($result);
+
+ // Return array
+ //* DEBUG: */ echo __FUNCTION__.":rid={$rid},count()=".count($userIds)."<br />\n";
+ return $userIds;
}
//
-function UPDATE_REF_COUNTER($uid)
-{
- global $REF_LVL, $cacheInstance;
+function UPDATE_REF_COUNTER ($uid) {
+ global $cacheArray, $cacheInstance;
// Make it sure referral level zero (member him-/herself) is at least selected
- if (empty($REF_LVL)) $REF_LVL = 0;
+ if (empty($cacheArray['ref_level'][$uid])) $cacheArray['ref_level'][$uid] = 1;
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},level={$cacheArray['ref_level'][$uid]}<br />\n";
// Update counter
- $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_refsystem SET counter=counter+1 WHERE userid=%s AND level='%s' LIMIT 1",
- array(bigintval($uid), $REF_LVL), __FILE__, __LINE__);
+ $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_refsystem SET counter=counter+1 WHERE userid=%s AND level=%s LIMIT 1",
+ array(bigintval($uid), $cacheArray['ref_level'][$uid]), __FILE__, __LINE__);
// When no entry was updated then we have to create it here
- if (SQL_AFFECTEDROWS() == 0)
- {
+ //* DEBUG: */ echo __FUNCTION__.":updated=".SQL_AFFECTEDROWS()."<br />\n";
+ if (SQL_AFFECTEDROWS() == 0) {
// First count!
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_refsystem (userid, level, counter) VALUES ('%s', '%s', '1')",
- array(bigintval($uid), $REF_LVL), __FILE__, __LINE__);
- }
+ $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_refsystem (userid, level, counter) VALUES (%s,%s,1)",
+ array(bigintval($uid), $cacheArray['ref_level'][$uid]), __FILE__, __LINE__);
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid}<br />\n";
+ } // END - if
// Check for his referral
$result = SQL_QUERY_ESC("SELECT refid FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1",
- array(bigintval($uid)), __FILE__, __LINE__);
+ array(bigintval($uid)), __FILE__, __LINE__);
+
+ // Load refid
list($ref) = SQL_FETCHROW($result);
// Free memory
SQL_FREERESULT($result);
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},ref={$ref}<br />\n";
// When he has a referral...
- if (($ref > 0) && ($ref != $uid))
- {
+ if (($ref > 0) && ($ref != $uid)) {
// Move to next referral level and count his counter one up!
- $REF_LVL++; UPDATE_REF_COUNTER($ref);
- }
- elseif ((($ref == $uid) || ($ref == 0)) && (GET_EXT_VERSION("cache") >= "0.1.2"))
- {
+ //* DEBUG: */ echo __FUNCTION__.":ref={$ref} - ADVANCE!<br />\n";
+ $cacheArray['ref_level'][$uid]++; UPDATE_REF_COUNTER($ref);
+ } elseif ((($ref == $uid) || ($ref == 0)) && (GET_EXT_VERSION("cache") >= "0.1.2")) {
// Remove cache here
+ //* DEBUG: */ echo __FUNCTION__.":ref={$ref} - CACHE!<br />\n";
if ($cacheInstance->cache_file("refsystem", true)) $cacheInstance->cache_destroy();
}
+
+ // "Walk" back here
+ $cacheArray['ref_level'][$uid]--;
+
+ // Handle refback here
+ UPDATE_REFBACK_TABLE($uid);
+}
+// Update "refback table"
+function UPDATE_REFBACK_TABLE($uid)
+{
+ global $cacheArray, $cacheInstance;
+
+ // Make it sure referral level zero (member him-/herself) is at least selected
+ if (empty($cacheArray['back_level'])) $cacheArray['back_level'] = 1;
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},level={$cacheArray['back_level']}<br />\n";
+
+ // Init refid
+ $cacheArray['up_refid'][$cacheArray['back_level']] = 0;
+ $old = 0; $minus = 0;
+
+ // Check for his referral
+ $result_refid = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE refid=%s ORDER BY userid ASC",
+ array(bigintval($uid)), __FILE__, __LINE__);
+
+ // When no entry was updated then we have to create it here
+ //* DEBUG: */ echo __FUNCTION__.":found=".SQL_NUMROWS($result_refid)."<br />\n";
+ if (SQL_NUMROWS($result_refid) > 0) {
+ // Load all refids
+ while(list($cacheArray['up_refid'][$cacheArray['back_level']]) = SQL_FETCHROW($result_refid)) {
+ // Remmber userid
+ $cacheArray['up_userid'][$cacheArray['up_refid'][$cacheArray['back_level']]] = $uid;
+
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},ref={$cacheArray['up_refid'][$cacheArray['back_level']]}<br />\n";
+ // Refid set?
+ if (($cacheArray['up_refid'][$cacheArray['back_level']] > 0) && ($cacheArray['up_refid'][$cacheArray['back_level']] != $uid) && (!empty($cacheArray['up_refid'][$cacheArray['back_level']]))) {
+ // New userid?
+ if ((isset($cacheArray['up_refid'][$cacheArray['back_level']-1])) && (isset($cacheArray['up_userid'][$cacheArray['up_refid'][$cacheArray['back_level']-1]]))) {
+ // New userid!
+ $old = $uid;
+ $uid = $cacheArray['up_userid'][$cacheArray['up_refid'][$cacheArray['back_level']-1]];
+ $minus = 1;
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},old={$old},level={$cacheArray['back_level']},ref={$cacheArray['up_refid'][$cacheArray['back_level']]} - NEW UID!<br />\n";
+ } // END - if
+
+ // Check existence
+ $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_user_refs WHERE userid=%s AND level=%s AND refid=%s LIMIT 1",
+ array(bigintval($uid), $cacheArray['back_level'], bigintval($cacheArray['up_refid'][$cacheArray['back_level']])), __FILE__, __LINE__);
+
+ // Do we have no entry?
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},level={$cacheArray['back_level']},ref={$cacheArray['up_refid'][$cacheArray['back_level']]},minus={$minus},numRows=".SQL_NUMROWS($result)." - FOUND!<br />\n";
+ if (SQL_NUMROWS($result) == 0) {
+ // Insert this level
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},level={$cacheArray['back_level']},ref={$cacheArray['up_refid'][$cacheArray['back_level']]} - ADD!<br />\n";
+ $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_refs (userid, level, refid) VALUES (%s,%s,%s)",
+ array(bigintval($uid), $cacheArray['back_level'], bigintval($cacheArray['up_refid'][$cacheArray['back_level']])), __FILE__, __LINE__);
+
+ // Move to next referral level and count his counter one up!
+ $cacheArray['back_level']++; UPDATE_REFBACK_TABLE($cacheArray['up_refid'][($cacheArray['back_level'] - 1)]);
+ } // END - if
+
+ // Do we have another level here?
+ if ((($cacheArray['back_level']-$minus) > 0) && ($old > 0)) {
+ // Restore old one
+ $uid = $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($uid), ($cacheArray['back_level']-$minus), bigintval($cacheArray['up_refid'][$cacheArray['back_level']])), __FILE__, __LINE__);
+
+ // Do we have no entry?
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},level=".($cacheArray['back_level']-$minus).",ref={$cacheArray['up_refid'][$cacheArray['back_level']]},numRows=".SQL_NUMROWS($result)." - BACK!<br />\n";
+ if (SQL_NUMROWS($result) == 0) {
+ // Insert this level
+ $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_refs (userid, level, refid) VALUES (%s,%s,%s)",
+ array(bigintval($uid), ($cacheArray['back_level']-$minus), bigintval($cacheArray['up_refid'][$cacheArray['back_level']])), __FILE__, __LINE__);
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},level=".($cacheArray['back_level']-$minus).",ref={$cacheArray['up_refid'][$cacheArray['back_level']]} - RETURNED!<br />\n";
+ } // END - if
+ } // END - if
+ } // END - if
+ } // END - while
+
+ // Free memory
+ SQL_FREERESULT($result_refid);
+ } // END - if
+
+ // When he has a referral...
+ if ((($cacheArray['up_refid'][$cacheArray['back_level']] == $uid) || ($cacheArray['up_refid'][$cacheArray['back_level']] == 0)) && (GET_EXT_VERSION("cache") >= "0.1.2") && (!isset($cacheArray['back_cached']))) {
+ // Remove cache here
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},ref={$cacheArray['up_refid'][$cacheArray['back_level']]} - CACHE!<br />\n";
+ if ($cacheInstance->cache_file("refback", true)) $cacheInstance->cache_destroy();
+ $cacheArray['back_cached'] = 1;
+ } // END - if
+
+ // "Walk" back here
+ $cacheArray['back_level']--;
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},level={$cacheArray['back_level']} - LEVEL!<br />\n";
+
+ // Fix empty refid
+ if (!isset($cacheArray['up_refid'][$cacheArray['back_level']-1])) $cacheArray['up_refid'][$cacheArray['back_level']-1] = 0;
+ //* DEBUG: */ echo __FUNCTION__.":uid={$uid},level={$cacheArray['back_level']},ref={$cacheArray['up_refid'][$cacheArray['back_level']-1]} - BACK!<br />\n";
}
// Updates/extends the online list
function UPDATE_ONLINE_LIST($SID, $mod, $act, $wht) {
$ADMIN = "Y";
} // END - if
- if (isSessionVariableSet('refid')) {
+ if (isSessionVariableSet('up_refid')) {
// Check cookie
if (get_session('refid') > 0) $rid = bigintval($GLOBALS['refid']);
} // END - if
);
} 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($mod, $act, $wht, $uid, $rid, $MEM, $ADMIN, $SID, getenv('REMOTE_ADDR')), __FILE__, __LINE__
);
}
}
// Get ID number from administrator's login name
function GET_ADMIN_ID($login) {
- global $cacheArray;
+ global $cacheArray, $_CONFIG;
$ret = "-1";
if (!empty($cacheArray['admins']['aid'][$login])) {
// Check cache
$ret = $cacheArray['admins']['aid'][$login];
- if (empty($ret)) $ret = "-1";
- } else {
+
+ // Update cache hits
+ $_CONFIG['cache_hits']++;
+ } elseif (!EXT_IS_ACTIVE("cache")) {
// Load from database
$result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_admins WHERE login='%s' LIMIT 1",
array($login), __FILE__, __LINE__);
// Get password hash from administrator's login name
function GET_ADMIN_HASH($login)
{
- global $cacheArray;
+ global $cacheArray, $_CONFIG;
$ret = "-1";
- if (!empty($cacheArray['admins']['password'][$login]))
- {
+ if (!empty($cacheArray['admins']['password'][$login])) {
// Check cache
$ret = $cacheArray['admins']['password'][$login];
- if (empty($ret)) $ret = "-1";
- }
- else
- {
+
+ // Update cache hits
+ $_CONFIG['cache_hits']++;
+ } elseif (!EXT_IS_ACTIVE("cache")) {
// Load from database
$result = SQL_QUERY_ESC("SELECT password FROM "._MYSQL_PREFIX."_admins WHERE login='%s' LIMIT 1",
array($login), __FILE__, __LINE__);
- if (SQL_NUMROWS($result) == 1)
- {
+ if (SQL_NUMROWS($result) == 1) {
+ // Fetch data
list($ret) = SQL_FETCHROW($result);
- SQL_FREERESULT($result);
+
+ // Set cache
+ $cacheArray['admins']['password'][$login] = $ret;
}
+
+ // Free result
+ SQL_FREERESULT($result);
}
return $ret;
}
//
function GET_ADMIN_LOGIN ($aid) {
- global $cacheArray;
+ global $cacheArray, $_CONFIG;
$ret = "***";
- if (!empty($cacheArray['admins']['login'])) {
- // Check cache
- if (!empty($cacheArray['admins']['login'][$aid])) {
- $ret = $cacheArray['admins']['login'][$aid];
- } // END - if
- if (empty($ret)) $ret = "***";
- } else {
+ if (!empty($cacheArray['admins']['login'][$aid])) {
+ // Get cache
+ $ret = $cacheArray['admins']['login'][$aid];
+
+ // Update cache hits
+ $_CONFIG['cache_hits']++;
+ } elseif (!EXT_IS_ACTIVE("cache")) {
// Load from database
$result = SQL_QUERY_ESC("SELECT login FROM "._MYSQL_PREFIX."_admins WHERE id=%s LIMIT 1",
- array(bigintval($aid)), __FILE__, __LINE__);
+ array(bigintval($aid)), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// Fetch data
list($ret) = SQL_FETCHROW($result);
// Set cache
$cacheArray['admins']['login'][$aid] = $ret;
- }
+ } // END - if
// Free memory
SQL_FREERESULT($result);
}
return $ret;
}
+// Get email address of admin id
+function GET_ADMIN_EMAIL ($aid) {
+ global $cacheArray, $_CONFIG;
+
+ $ret = "***";
+ if (!empty($cacheArray['admins']['email'])) {
+ // Get cache
+ $ret = $cacheArray['admins']['email'][$aid];
+
+ // Update cache hits
+ $_CONFIG['cache_hits']++;
+ } elseif (!EXT_IS_ACTIVE("cache")) {
+ // Load from database
+ $result_aid = SQL_QUERY_ESC("SELECT email FROM "._MYSQL_PREFIX."_admins WHERE id=%s LIMIT 1",
+ array(bigintval($ret)), __FILE__, __LINE__);
+ if (SQL_NUMROWS($result) == 1) {
+ // Get data
+ list($ret) = SQL_FETCHROW($result_aid);
+
+ // Set cache
+ $cacheArray['admins']['email'][$aid] = $ret;
+ } // END - if
+
+ // Free result
+ SQL_FREERESULT($result_aid);
+ }
+
+ // Return email
+ return $ret;
+}
+// Get default ACL of admin id
+function GET_ADMIN_DEFAULT_ACL ($aid) {
+ global $cacheArray, $_CONFIG;
+
+ $ret = "***";
+ if (!empty($cacheArray['admins']['def_acl'])) {
+ // Use cache
+ $ret = $cacheArray['admins']['def_acl'][$aid];
+
+ // Update cache hits
+ $_CONFIG['cache_hits']++;
+ } else {
+ // Load from database
+ $result_aid = SQL_QUERY_ESC("SELECT default_acl FROM "._MYSQL_PREFIX."_admins WHERE id=%s LIMIT 1",
+ array(bigintval($ret)), __FILE__, __LINE__);
+ if (SQL_NUMROWS($result) == 1) {
+ // Fetch data
+ list($ret) = SQL_FETCHROW($result_aid);
+
+ // Set cache
+ $cacheArray['admins']['def_acl'][$aid] = $ret;
+ }
+
+ // Free result
+ SQL_FREERESULT($result_aid);
+ }
+
+ // Return email
+ return $ret;
+}
//
function ADD_OPTION_LINES($table, $id, $name, $default="",$special="",$where="") {
$ret = "";
$ret .= "<OPTION value=\"".$value."\"";
if ($default == $value) $ret .= " selected checked";
$ret .= ">".$name[$idx]."</OPTION>\n";
- }
- }
+ } // END - foreach
+ } // END - if
} else {
// Data from database
$SPEC = ", ".$id;
if ($default == $value) $ret .= " selected checked";
if (!empty($add)) $add = " (".$add.")";
$ret .= ">".$title.$add."</OPTION>\n";
- }
+ } // END - while
// Free memory
SQL_FREERESULT($result);
// Return - hopefully - the requested data
return $ret;
}
-// Aiut
+// Activate exchange (DEPERECATED???)
function activateExchange() {
global $_CONFIG;
$result = SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE status='CONFIRMED' AND max_mails > 0", __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 0)
{
// Create line
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_jackpot (ok, points) VALUES ('ok', '%s')", array($points), __FILE__, __LINE__);
+ $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_jackpot (ok, points) VALUES ('ok','%s')", array($points), __FILE__, __LINE__);
}
else
{
array($subject), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 0) {
// Task not created so it's a brand-new extension which we need to register and create a task for!
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_task_system (assigned_admin, userid, status, task_type, subject, text, task_created) VALUES ('%s', '0', 'NEW', 'EXTENSION_UPDATE', '%s', '%s', UNIX_TIMESTAMP())",
+ $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_task_system (assigned_admin, userid, status, task_type, subject, text, task_created) VALUES ('%s','0','NEW','EXTENSION_UPDATE','%s','%s', UNIX_TIMESTAMP())",
array($admin_id, $subject, $notes), __FILE__, __LINE__);
} // END - if
// Task not created so it's a brand-new extension which we need to register and create a task for!
$result_insert = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_task_system (assigned_admin, userid, status, task_type, subject, text, task_created)
-VALUES (%s, 0, 'NEW', 'EXTENSION', '%s', '%s', UNIX_TIMESTAMP())",
+VALUES (%s,0,'NEW','EXTENSION','%s','%s',UNIX_TIMESTAMP())",
array(
$admin_id,
$subject,