0) { // Remove index temporaly SQL_QUERY("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_QUERY("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); // ?>