WordPress自定义表前缀下批量开启评论及代码放置位置问询

1. Adapting the Code to Your Custom Table Prefix #

Good news—you don’t need to manually tweak any prefix references in the code! WordPress’s $wpdb object automatically pulls the table prefix defined in your wp-config.php file (your wp_svkc_ in this case). When you use $wpdb->posts, it automatically resolves to wp_svkc_posts behind the scenes, so the original code works perfectly with your custom prefix.

That said, we can refine the code to follow WordPress security best practices by properly using $wpdb->prepare with placeholders (the original code doesn’t leverage these, which is a small but important improvement):

function enable_comments_for_all(){ 
    global $wpdb; 
    // Enable comments for all posts
    $wpdb->query( 
        $wpdb->prepare( 
            "UPDATE %s SET comment_status = %s", 
            $wpdb->posts, 
            'open' 
        ) 
    ); 
    // Enable trackbacks/pingbacks
    $wpdb->query( 
        $wpdb->prepare( 
            "UPDATE %s SET ping_status = %s", 
            $wpdb->posts, 
            'open' 
        ) 
    ); 
} 
// Critical: Run this once, then comment or delete the line below to avoid repeated unnecessary database updates!
enable_comments_for_all();

This version keeps automatic prefix compatibility while making the query more secure.

2. Where to Place the Code Without Losing It on Theme Updates #

Adding custom code directly to your Cenote theme’s functions.php is risky—theme updates will overwrite this file, wiping out your custom code. Here’s the safest approach:

Recommended: Use a Child Theme #

This is WordPress’s official best practice for theme customizations:

• Create a child theme for Cenote (you’ll need a new folder in wp-content/themes/ with a style.css header and a blank functions.php file).
• Add your custom function to your child theme’s functions.php file. You can place it anywhere after the opening <?php tag, like at the end of the file. Child themes are never overwritten when the parent theme updates, so your code stays intact permanently.

Temporary Workaround (Not Recommended) #

If you can’t set up a child theme right now:

• Add the code to the very end of your main Cenote theme’s functions.php file, after all existing code. If the file ends with ?>, place it right before that line (many themes omit the closing tag, so just append it to the end).
• Note: You’ll have to re-add this code every time you update the Cenote theme, since the update will replace the original functions.php file.

内容的提问来源于stack exchange，提问作者Lucas Perrett