Support » Plugin: Clobber spam users » No resullts

Viewing 1 replies (of 1 total)
  • Plugin Author Corey Salzano


    Thanks for trying my plugin. I pulled the database query out of the plugin to post it here, and you could run this on your database if your table prefixes are the default wp_.

    SELECT wp_users.ID, wp_posts.ID AS post_ID
    FROM wp_users
    LEFT JOIN wp_posts ON wp_users.ID = wp_posts.post_author
    WHERE wp_posts.post_title <> 'Auto Draft'
    AND wp_posts.post_type = 'post'
    ORDER BY post_date DESC
    LIMIT 30

    This finds all the recent posts with the exception of Auto Drafts. This will include posts that are not spam. The plugin does not detect spam, it simply spits out the authors of the latest posts or drafts and allows you to choose which ones are spam.

    If you see nothing in the list, I wonder how your installation is different from mine. Are your posts being created with a post_type of post? Are the submitters of items to your site real users that are in the wp_users table?

Viewing 1 replies (of 1 total)
  • The topic ‘No resullts’ is closed to new replies.