I have been searching the net for a while for a way to sort comments on my blog, and have found the way to do it! We need to edit a core Wordpress file:
wp-includes/comment-functions.php
Remember: Any changes made to this file will need to be redone if you update Wordpress!
On line 16, we will find the following code:
$comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_post_ID = '$post->ID' AND comment_approved = '1' ORDER BY comment_date");
The ORDER BY at the end is what we are concerned with. Wordpress has the following variables we can use:
- comment_ID
- comment_post_ID
- comment_author
- comment_author_email
- comment_author_url
- comment_author_IP
- comment_date
- comment_date_gmt
- comment_content
- comment_karma
- comment_approved
- comment_agent
- comment_type
- comment_parent
- user_id
You can learn more about Wordpress’ Databases on the Codex by clicking here.
In the new 2.5 you will have to look for the file here : wp-includes/comment.php
Around line 94 you will find this function :
function get_approved_comments($post_id) {global $wpdb;
return $wpdb->get_results($wpdb->prepare("SELECT * FROM $wpdb->comments WHERE comment_post_ID = %d AND comment_approved = '1' ORDER BY comment_date", $post_id));
}
Change the comment_date to any of the options above!
Да уж, автор блога на самом деле очень добрый и отзывчивый человек. Спасибо
Очень даже любопытно. В особенности вторая.
Всем привет! Я тут новичок. Примите в компанию?
abilify antipsychotic depression treatment abilify side effects abilify for depression abilify tablets abilify aripiprazole
Wordpress is the best blogging platform ever. It is much better than Typepad and blogspot.;**
i host 5 of my blogs on Blogspot and it is really good for beginners. but if you want something with more features, nothing beats wordpress”`,
Sign: zdbrw Hello!!! wdfxt and 652dsmrxrqrhn and 3368 : Thanks. We look forward to hearing from you again and for your opinions on the world of work.
Thank you for review a valuble article. This useful for me and my friend, I will follow your blog for continue reading your news.
Thnaks for the tip! I was looking to order my comments with a plugin but this is much simpler.
Bookmarked! Thank you for this awesome resource.
CPR Certification TrainingGood site that has a new enhanced way of the word press that will give the updated information and also one can post in an easier way. Good site and really appreciable.
Это сообщение, бесподобно ))), мне нравится
I am curious to find out what blog platform you happen to be utilizing? Im experiencing some minor security issues with my latest site and I would like to find something more safe. Do you have any solutions? Hmm it appears like your blog ate my first comment (it was super long) so I guess Ill just sum it up what I wrote and say, Im thoroughly enjoying your blog. I as well am an aspiring blog blogger but Im still new to everything. Do you have any recommendations for first-time blog writers? Id definitely appreciate it.