The MU forums have moved to WordPress.org

Disable pingbacks/trackbacks for all blogs (3 posts)

  1. moose123
    Member
    Posted 14 years ago #

    Hello,

    My apologies for my newbie db skills.

    I would like to globally disable pingbacks/trackbacks for all my blogs via phpMyAdmin, but I can't seem to get the MySQL statement right. The statement below works on a single blog, but how can I write my query to update all "wp_blog#_posts" table across my whole db?

    UPDATE wp_posts SET ping_status = 'closed';

    I haven't had any luck trying to wildcard the blog number inside the wp_posts table name.

    Thanks in advance.

  2. brenthuisman
    Member
    Posted 14 years ago #

    I'd like to disable pingbacks for my entire wpmu too, prefereably thru an option somewhere instead of editting the tables manually.

  3. kgraeme
    Member
    Posted 14 years ago #

    Not sure if you can do wildcards in a table name in a query in mysql.

    A different approach would be to write a plugin that gets a count of blogs, then does a for loop with the increment of the loop being number for the wp_blog#_posts table.

    To change the default for new blogs to not have pingbacks enabled, try the New Blog Defaults plugin.

About this Topic

  • Started 14 years ago by moose123
  • Latest reply from kgraeme