this should work… <?php global $wpdb; $sql = “SELECT comment_ID FROM “. $wpdb->prefix .”comments WHERE comment_parent = 0 AND comment_ID NOT IN(SELECT comment_parent FROM “. $wpdb->prefix .”comments);”; $results = $wpdb->get_results($sql); ?>
You can prevent some hits by blocking bots before akismet catches them, these plugins can be very effective. Plugins: Bad Behavior plugin: http://wordpress.org/extend/plugins/bad-behavior/ Honeypot Traps: http://wordpress.org/extend/plugins/project-honey-pot-spam-trap/ WP-Hashcash http://wordpress.org/extend/plugins/wp-hashcash/ Zig Trap http://wordpress.org/extend/plugins/zigtrap/ Stop bots with no user agents from posting and directory browsing (this goes in your .htaccess) RewriteEngine On RewriteCond %{REQUEST_METHOD} POST RewriteCond %{HTTP_USER_AGENT} ^$ … Read more
you can do this very easily with jQuery simply wrap your comment form in a div and hide, add a button or a link and on his click event show the comment form so smoothing like this: <a href=”#” ID=”Leave_a_comment”>Leave a Comment</a> <div id=”comment_form_wrapper” style=”display: none;”> <?php comments_template( ”, true ); ?> </div> <script type=”text/javascript”> … Read more
Try the JetPack Plugin from WordPress.com http://wordpress.org/extend/plugins/jetpack/
Use get_comments_link(), it retrieve the link without echoing it. This is the function that is used by comments_link(). See also: http://codex.wordpress.org/Function_Reference/comments_link
When links are broken into pages (via the settings in WordPress) and the link to bring a user to the comments is clicked it doesn’t just scroll users down the page, it brings them to a separate page that is created. Yes; this is standard WordPress functionality. Paginating comments results in paginated posts, with an … Read more
You can copy this code into a plugin and when activated will convert all comments into posts, and delete the comments (so you will not have duplicates) You can also limit what kind of comments will be converted the posts using the parameters for get_comments ( http://codex.wordpress.org/Function_Reference/get_comments ) register_activation_hook( __FILE__, ‘wpse_29474_convert_to_posts’ ); function wpse_29474_convert_to_posts(){ $comments … Read more
I would rarely use ‘echo’ in WordPress template themes because it can cause output to appear before the loops are even executed (aka, at the top of the page). In this instance, I used the get_comments function within a function that hooked onto the content output: add_filter(‘the_content’, ‘includePosts’, 1); Within the function includePosts, I have … Read more
I’ve figured out the solution to my problems. Here’s what I did… Note: This is considering the posts, thus comments, are under the ‘Article‘ post-type, which thus create the permalink such as this: site.com/article/post-name/#comments. Adjustments should be made for other uses. To fix problem #1 & #3: if ( !is_admin() ) add_filter(‘get_comment_link’, ‘my_comment_post_redirect’); function my_comment_post_redirect($location){ … Read more
Try this: Capability Manager http://wordpress.org/extend/plugins/capsman/ and also read (if you have’t already done so) the WordPress roles and capabilities docs: http://codex.wordpress.org/Roles_and_Capabilities