How can I delete all my existing trackbacks?
To make this more WP-ish: function wpse_delete_trackbacks() { global $wpdb; $wpdb->query( $wpdb->prepare( ” DELETE FROM %s WHERE `comment_type` = ‘trackback’ “, “{$wpdb->prefix}comments” ) ); }
spam
Bots posting comments on pages
In order to add a new comment you really only need a couple of fields and a POST method. In a typical comment form, requests are submitted to http://www.example.com/wp-comments-post.php which parses the $_POST data and sends it off to wp_handle_comment_submission. A POST method varies from a GET request in that params are usually sent in … Read more
How to bulk delete all WordPress subscribers?
I ended up deleting all users who had not made a post using the following two queries: First: DELETE FROM wp_users WHERE ID NOT IN (SELECT post_author FROM wp_posts) Second: DELETE FROM wp_usermeta WHERE user_id NOT IN (SELECT ID FROM wp_users)
How to disable WordPress trackbacks?
This can be solved using the Bulk Edit WordPress functionality. and Change the number of items to be shown in Screen Options, so you can select all posts/pages at once. Two things worth noting in the Q&A pointed by @BartKarp: There is the option to turn off trackbacks/pingbacks under Settings > Discussion. it has a … Read more
wp_redirection_404 table has grown to 7GB
That table is from the redirection plugin, and isn’t a part of WordPress Core. Deleting it should have no ill effects as long as you disable the plugin too. If you wish to continue using that plugin though, I recommend using the plugin authors support at https://wordpress.org/support/plugin/redirection/
Report spam button
There a a few plugins that allow visitors to report comments AJAX Report Comments Safe Report Comments
New users must comment when requesting username
You can use a captcha plugin that requires users to type a short phrase or random letters in order to register on your site. An example of one of these plugins is the WP-reCAPTCHA, found at: http://wordpress.org/extend/plugins/wp-recaptcha/ Or you can use a plugin such as CIMY User Extra Fields to add fields to a user … Read more
Buddypress Fake (non-bot) Users [closed]
Fake registerion to buddypress is a real pain in the !@$ (pardon my french). I’ve tried math question, captch, sabre and other plugins but none of them seem to work. So far, only WangGuard did the trick. It won’t give you full protection against those registrations but it’s the most efficient tool I’ve found against … Read more
How to expire all wordpress user passwords instantly?
Some underlying functionality borrowed from http://wordpress.org/extend/plugins/auto-expire-passwords/ , and tweaked. Untested, but along the lines of what you are looking for, so YMMV. function custom_forced_password_reset( $user ) { update_user_meta( $user->ID, ‘password_was_force_reset’, true ); } add_action( ‘password_reset’, ‘custom_forced_password_reset’ ); // Ensure all new register users have the flag set function custom_forced_password_user_register($user_id){ update_user_meta( $user_id, ‘password_was_force_reset’, true ); } … Read more
Remove default user registration, login and subscriber profiles
I realised this is probably better dealt by the server, I ended up putting the following in a .htaccess: # Block regular login/registration and profile pages <Files wp-login.php> Order Deny,Allow Deny from All </Files> <Files profile.php> Order Deny,Allow Deny from All </Files> This prevents any requests to those pages and forces users to use my … Read more