X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmysql-manager.php;h=3b795a314bd3f3f2d999f4f17664d772aed5bd84;hb=3c2f106c02f6d86a90f529a0564abcbbe716fe71;hp=13023de6f474a755580431277c8d434c19ba6e56;hpb=a947e52bac90c5cbfafc911898bd1c9d965b9fd7;p=mailer.git diff --git a/inc/mysql-manager.php b/inc/mysql-manager.php index 13023de6f4..3b795a314b 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")))); } @@ -629,6 +629,7 @@ function IS_MEMBER() } else { // Cookie data is invalid! //* DEBUG: */ echo __LINE__."***
"; + destroy_user_session(); // Reset userid $GLOBALS['userid'] = 0; @@ -1129,26 +1130,24 @@ function GET_REF_LEVEL_PERCENTS ($level) { * 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") { + //* DEBUG: */ print "----------------------- ".__FUNCTION__." - ENTRY ----------------------------------------------- ".__FUNCTION__." - EXIT ------------------------
\n"; } // function UPDATE_REF_COUNTER ($uid) { @@ -1369,19 +1260,19 @@ function UPDATE_REF_COUNTER ($uid) { // Make it sure referral level zero (member him-/herself) is at least selected if (empty($cacheArray['ref_level'][$uid])) $cacheArray['ref_level'][$uid] = 1; - //* DEBUG: */ echo __FUNCTION__.":uid={$uid},level={$cacheArray['ref_level'][$uid]}
\n"; + //* 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), $cacheArray['ref_level'][$uid]), __FILE__, __LINE__); // When no entry was updated then we have to create it here - //* DEBUG: */ echo __FUNCTION__.":updated=".SQL_AFFECTEDROWS()."
\n"; - 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), $cacheArray['ref_level'][$uid]), __FILE__, __LINE__); - //* DEBUG: */ echo __FUNCTION__.":uid={$uid}
\n"; + //* DEBUG: */ print __FUNCTION__."(".__LINE__."):uid={$uid}
\n"; } // END - if // Check for his referral @@ -1393,118 +1284,26 @@ function UPDATE_REF_COUNTER ($uid) { // Free memory SQL_FREERESULT($result); - //* DEBUG: */ echo __FUNCTION__.":uid={$uid},ref={$ref}
\n"; + //* DEBUG: */ print __FUNCTION__."(".__LINE__."):uid={$uid},ref={$ref}
\n"; // When he has a referral... if (($ref > 0) && ($ref != $uid)) { // Move to next referral level and count his counter one up! - //* DEBUG: */ echo __FUNCTION__.":ref={$ref} - ADVANCE!
\n"; + //* 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: */ echo __FUNCTION__.":ref={$ref} - CACHE!
\n"; + //* 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 - 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']}
\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)."
\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']]}
\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!
\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!
\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!
\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!
\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!
\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!
\n"; - if ($cacheInstance->cache_file("refback", true)) $cacheInstance->cache_destroy(); - $cacheArray['back_cached'] = 1; + // Handle refback here if extension is installed + if (EXT_IS_ACTIVE("refback")) { + UPDATE_REFBACK_TABLE($uid); } // END - if - - // "Walk" back here - $cacheArray['back_level']--; - //* DEBUG: */ echo __FUNCTION__.":uid={$uid},level={$cacheArray['back_level']} - LEVEL!
\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!
\n"; } // Updates/extends the online list function UPDATE_ONLINE_LIST($SID, $mod, $act, $wht) { @@ -1827,7 +1626,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__); } @@ -1970,7 +1769,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])) { @@ -2057,7 +1856,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"); @@ -2112,6 +1911,5 @@ VALUES (%s,0,'NEW','EXTENSION','%s','%s',UNIX_TIMESTAMP())", // Free memory SQL_FREERESULT($result); } - // ?>