0) { // Check if found userid is also found in user_data table $REMOVED = 0; // Nothing is removed for now... ;-) while (list($uid) = SQL_FETCHROW($result)) { $result_user = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1", array(bigintval($uid)), __FILE__, __LINE__); if (SQL_NUMROWS($result_user) == 0) { // Ok, we found something to remove $result_remove = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_cats WHERE userid=%d", array(bigintval($uid)), __FILE__, __LINE__); $REMOVED += SQL_AFFECTEDROWS(); } else { // Free memory SQL_FREERESULT($result_user); } } // Free memory SQL_FREERESULT($result); if ($REMOVED > 0) { // Entries repaired $content = "".ADMIN_REPAIR_ENTRIES_FIXED_1.$REMOVED.ADMIN_REPAIR_ENTRIES_FIXED_2.""; } else { // Nothing repaired $content = "".ADMIN_REPAIR_NOTHING_FIXED.""; } } else { // No category selections found, no members registered? $content = "".ADMIN_REPAIR_CATS_NOTHING.""; } // Load template LOAD_TEMPLATE("admin_settings_saved", false, $content); // ?>