0) { // Upgrade refsystem, ref-level 0 is silly here SQL_QUERY("UPDATE "._MYSQL_PREFIX."_refsystem SET level=level+1", __FILE__, __LINE__); } // 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); // ?>