X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmysql-manager.php;h=186b1d43e1c678457ef27ae9e0f24ac82e7a75c6;hb=3cac3f2c96d0f9737a9df56b5236f379c4c75a44;hp=717865cbaaec5e2767ff6afeb1b349cff605c481;hpb=811c2a74188a97591fb05ed1dd3d1929b8bc23aa;p=mailer.git diff --git a/inc/mysql-manager.php b/inc/mysql-manager.php index 717865cbaa..186b1d43e1 100644 --- a/inc/mysql-manager.php +++ b/inc/mysql-manager.php @@ -168,7 +168,7 @@ function CHECK_MODULE($mod) { } // Everthing is fine? - if (SQL_AFFECTEDROWS() == 0) { + if (SQL_AFFECTEDROWS() < 1) { // Something bad happend! return "major"; } // END - if @@ -286,7 +286,7 @@ function ADD_DESCR($ACC_LVL, $file, $return = false, $output = true) { $DEPTH="0"; // Handle failed logins here if not in guest - //* DEBUG: */ echo __FUNCTION__.":type={$type},action={$GLOBALS['action']},what={$GLOBALS['what']},lvl={$ACC_LVL}
\n"; + //* DEBUG: */ print __FUNCTION__."(".__LINE__."):type={$type},action={$GLOBALS['action']},what={$GLOBALS['what']},lvl={$ACC_LVL}
\n"; if ((($type == "what") || ($type == "action") && ((!isset($GLOBALS['what'])) || ($GLOBALS['what'] == "overview") || ($GLOBALS['what'] == $_CONFIG['index_home']))) && ($ACC_LVL != "guest") && ((GET_EXT_VERSION("sql_patches") >= "0.4.7") || (GET_EXT_VERSION("admins") >= "0.7.0"))) { // Handle failture $OUT .= HANDLE_LOGIN_FAILTURES($ACC_LVL); @@ -476,7 +476,7 @@ function IS_ADMIN($admin="") if (!empty($valPass)) { // Check if password is valid - //* DEBUG: */ echo __FUNCTION__."*".$valPass."/".$passCookie."*
\n"; + //* DEBUG: */ print __FUNCTION__."*".$valPass."/".$passCookie."*
\n"; $ret = (($valPass == $passCookie) || ((strlen($valPass) == 32) && ($valPass == md5($passCookie))) || (($valPass == "*FAILED*") && (!EXT_IS_ACTIVE("cache")))); } @@ -623,15 +623,15 @@ function IS_MEMBER() //* DEBUG: */ echo __LINE__."!!!
"; 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__."***
"; - // Remove array elements to prevent errors - unset($GLOBALS['userid']); + // Reset userid + $GLOBALS['userid'] = 0; } // Free memory @@ -641,8 +641,8 @@ function IS_MEMBER() //* DEBUG: */ echo __LINE__."///
"; destroy_user_session(); - // Remove array elements to prevent errors - unset($GLOBALS['userid']); + // Reset userid + $GLOBALS['userid'] = 0; } // Cache status @@ -1060,8 +1060,7 @@ function REMOVE_RECEIVER(&$ARRAY, $key, $uid, $pool_id, $stats_id="", $bonus=fal 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 @@ -1075,16 +1074,53 @@ function GET_TOTAL_DATA($search, $tableName, $lookFor, $whereStatement="userid", // Load row list($ret) = SQL_FETCHROW($result); - //* DEBUG: */ echo __LINE__."*".$DATA."/".$search."/".$tableName."/".$ret."*
\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; } /** * @@ -1093,29 +1129,27 @@ function GET_TOTAL_DATA($search, $tableName, $lookFor, $whereStatement="userid", * uid = Referral ID wich should receive... * points = ... xxx points * send_notify = shall I send the referral an email or not? - * rid = inc/modules/guest/what-confirm.php need this + * rid = inc/modules/guest/what-confirm.php need this (DEPRECATED???) * locked = Shall I pay it to normal (false) or locked (true) points ammount? * add_mode = Add points only to $uid or also refs? (WARNING! Changing "ref" to "direct" * 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; + //* DEBUG: */ print "----------------------- ".__FUNCTION__." - ENTRY ----------------------------------------------- ".__FUNCTION__." - EXIT ------------------------
\n"; } // -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: */ print __FUNCTION__."(".__LINE__."):uid={$uid},level={$cacheArray['ref_level'][$uid]}
\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__); + 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: */ print __FUNCTION__."(".__LINE__."):updated=".SQL_AFFECTEDROWS()."
\n"; + if (SQL_AFFECTEDROWS() < 1) { // 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: */ print __FUNCTION__."(".__LINE__."):uid={$uid}
\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: */ print __FUNCTION__."(".__LINE__."):uid={$uid},ref={$ref}
\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: */ print __FUNCTION__."(".__LINE__."):ref={$ref} - ADVANCE!
\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: */ print __FUNCTION__."(".__LINE__."):ref={$ref} - CACHE!
\n"; if ($cacheInstance->cache_file("refsystem", true)) $cacheInstance->cache_destroy(); } + + // "Walk" back here + $cacheArray['ref_level'][$uid]--; + + // Handle refback here if extension is installed + if (EXT_IS_ACTIVE("refback")) { + UPDATE_REFBACK_TABLE($uid); + } // END - if } // Updates/extends the online list function UPDATE_ONLINE_LIST($SID, $mod, $act, $wht) { @@ -1298,7 +1334,7 @@ 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 @@ -1589,7 +1625,7 @@ WHERE p.userid=%s", array(bigintval($uid)), __FILE__, __LINE__); // Remove from rallye if found if (EXT_IS_ACTIVE("rallye")) { - $result = SQL_QUERY("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_users WHERE userid=%s", + $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_users WHERE userid=%s", array(bigintval($uid)), __FILE__, __LINE__); } @@ -1732,7 +1768,7 @@ function MODULE_HAS_MENU($mod, $forceDb = false) // All is false by default $ret = false; - //* DEBUG: */ echo __FUNCTION__.":mod={$mod},cache=".GET_EXT_VERSION("cache")."
\n"; + //* DEBUG: */ print __FUNCTION__."(".__LINE__."):mod={$mod},cache=".GET_EXT_VERSION("cache")."
\n"; if (GET_EXT_VERSION("cache") >= "0.1.2") { // Cache version is okay, so let's check the cache! if (isset($cacheArray['modules']['has_menu'][$mod])) { @@ -1819,7 +1855,7 @@ function UPDATE_CONFIG ($entries, $values, $updateMode="") { // Get affected rows $affectedRows = SQL_AFFECTEDROWS(); - //* DEBUG: */ echo __FUNCTION__.":entries={$entries},affectedRows={$affectedRows}
\n"; + //* DEBUG: */ print __FUNCTION__."(".__LINE__."):entries={$entries},affectedRows={$affectedRows}
\n"; // Rebuild cache REBUILD_CACHE("config", "config"); @@ -1874,6 +1910,5 @@ VALUES (%s,0,'NEW','EXTENSION','%s','%s',UNIX_TIMESTAMP())", // Free memory SQL_FREERESULT($result); } - // ?>