X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fgen_refback.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hp=16dbc51d1dc539d80f71d29570b9ec18f4846cac;hb=0fada672e2066043b76ed5d57f852f451a49a3a3;hpb=62b16291efe168636f5eda2c8644f6770382fb1e diff --git a/inc/gen_refback.php b/inc/gen_refback.php index 16dbc51d1d..f551ef47b7 100644 --- a/inc/gen_refback.php +++ b/inc/gen_refback.php @@ -1,90 +1,3 @@ 0) { - // Remove index temporaly - SQL_ALTER_TABLE("ALTER TABLE `"._MYSQL_PREFIX."_refsystem` DROP INDEX `userid_level`", __FILE__, __LINE__); - - // Upgrade refsystem, ref-level 0 is silly here - SQL_QUERY("UPDATE "._MYSQL_PREFIX."_refsystem SET level=level+1", __FILE__, __LINE__); - - // Add it again - SQL_ALTER_TABLE("ALTER TABLE `"._MYSQL_PREFIX."_refsystem` ADD UNIQUE `userid_level` ( `userid` , `level` )", __FILE__, __LINE__); - - // Rebuild cache - REBUILD_CACHE("refsystem", "refsystem"); -} // END - if - -// Free result -SQL_FREERESULT($result); - -// Reset the table -SQL_QUERY("TRUNCATE TABLE "._MYSQL_PREFIX."_user_refs", __FILE__, __LINE__); - -// Begin with all users in level one -$result_direct = SQL_QUERY("SELECT u.userid -FROM `"._MYSQL_PREFIX."_user_data` AS u -WHERE u.refid=0 -ORDER BY u.userid ASC", __FILE__, __LINE__); - -// Do we have entries? -if (SQL_NUMROWS($result_direct) > 0) { - global $cacheArray; - - // When "walk" through all users - while (list($uid) = SQL_FETCHROW($result_direct)) { - // Init level - $cacheArray['back_level'] = 1; - - // Update refback table - //* DEBUG: */ echo "uid={$uid}
\n"; - UPDATE_REFBACK_TABLE($uid); - } // END - while -} // END - if - -// Free result -SQL_FREERESULT($result_direct); - -// +// @DEPRECATED ?>