- Code: Alles auswählen
#
#-----[ OPEN ]-----
#
admin/admin_db_maintenance.php
#
#-----[ FIND ]-----
#
// Check for forums with invalid categories
echo("<p class=\"gen\"><b>" . $lang['Checking_invalid_forums'] . "</b></p>\n");
$SQL = "SELECT f.forum_id, f.forum_name
FROM " . FORUMS_TABLE . " f
LEFT JOIN " . CATEGORIES_TABLE . " c ON f.cat_id = c.cat_id
WHERE c.cat_id IS NULL";
#
#-----[ IN-LINE FIND ]-----
#
WHERE c.cat_id IS NULL";
#
#-----[ IN-LINE REPLACE WITH ]-----
#
WHERE c.cat_id IS NULL
AND main_type = 'c'";
#
#-----[ SAVE/CLOSE ALL FILES ]-----
#
# EoM
Quelle: www.phpbb.de