WordPress comment sort order

Webmasters! Check out these money makers!!!!

Banned from Google? Check out this post!

Sort comment display order (ascending) ASC or (descending) DESC in WordPress 2.6.

I found this information on the web that was written about a year ago. Kudos to whomever hypOr is!

After searching through wp-includes/comment-template.php I found where to implement the mod. Works with my WP v2.6 no problem. However, when it comes time to upgrade your 2.6, you will have to do this again provided the future versions don’t change this one particular function. Future versions may even include this in the admin area. I hope. 😉

Around line 642 in wp-includes/comment-template.php you need to add:

, $order = 'DESC'

after:
$file = '/comments.php'

Example:

function comments_template( $file = '/comments.php', $order = 'DESC' )

No mods to these areas:

{
global $wp_query, $withcomments, $post, $wpdb, $id, $comment, $user_login, $user_ID, $user_identity;

if ( ! (is_single() || is_page() || $withcomments) )
return;

$req = get_option('require_name_email');
$commenter = wp_get_current_commenter();
extract($commenter, EXTR_SKIP);

/** @todo Use API instead of SELECTs. */
if ( $user_ID) {

Then on ~lines 654, 656 and 658 add:

$order

after:
ORDER BY comment_date

Example:

$comments = $wpdb->get_results($wpdb->prepare("SELECT * FROM $wpdb->comments WHERE comment_post_ID = %d AND (comment_approved = '1' OR ( user_id = %d AND comment_approved = '0' ) )

ORDER BY comment_date $order",

$post->ID, $user_ID));
} else if ( empty($comment_author) ) {
$comments = $wpdb->get_results($wpdb->prepare("SELECT * FROM $wpdb->comments WHERE comment_post_ID = %d AND comment_approved = '1'

ORDER BY comment_date $order",

$post->ID));
} else {
$comments = $wpdb->get_results($wpdb->prepare("SELECT * FROM $wpdb->comments WHERE comment_post_ID = %d AND ( comment_approved = '1' OR ( comment_author = %s AND comment_author_email = %s AND comment_approved = '0' ) )

ORDER BY comment_date $order",

$post->ID, $comment_author, $comment_author_email));
}

Or you can just replace the whole section if you want. Look carefully but, this should start at line 642 and end at line 659

function comments_template( $file = '/comments.php', $order = 'DESC' ) {
global $wp_query, $withcomments, $post, $wpdb, $id, $comment, $user_login, $user_ID, $user_identity;

if ( ! (is_single() || is_page() || $withcomments) )
return;

$req = get_option('require_name_email');
$commenter = wp_get_current_commenter();
extract($commenter, EXTR_SKIP);

/** @todo Use API instead of SELECTs. */
if ( $user_ID) {
$comments = $wpdb->get_results($wpdb->prepare("SELECT * FROM $wpdb->comments WHERE comment_post_ID = %d AND (comment_approved = '1' OR ( user_id = %d AND comment_approved = '0' ) ) ORDER BY comment_date $order", $post->ID, $user_ID));
} else if ( empty($comment_author) ) {
$comments = $wpdb->get_results($wpdb->prepare("SELECT * FROM $wpdb->comments WHERE comment_post_ID = %d AND comment_approved = '1' ORDER BY comment_date $order", $post->ID));
} else {
$comments = $wpdb->get_results($wpdb->prepare("SELECT * FROM $wpdb->comments WHERE comment_post_ID = %d AND ( comment_approved = '1' OR ( comment_author = %s AND comment_author_email = %s AND comment_approved = '0' ) ) ORDER BY comment_date $order", $post->ID, $comment_author, $comment_author_email));
}

That’s it! Works for me…

Here is the link to where I found this.

After all that I found THIS. But, I have not tried it.

Webmasters! Check out these money makers!!!!

Banned from Google? Check out this post!

This is so amazing I had to put it here.
Get the kit HERE!
water-for-gas.jpg

21 Responses to “WordPress comment sort order”

  1. Greetings….. | Zentode on August 16th, 2008 8:46 am

    […] through mine here you may want to check out these money makers!!!! You will also find a handy WordPress comment sort order tweak there too. All at […]

  2. Gerro on September 22nd, 2008 10:04 pm

    This could work, but if you just want the sort to work for a specific theme, I suggest sticking to the comments.php.

    I’ve found a quick fix that requires only a single line of code to be added on the comments.php to work.

    I posted in my blog a short article on the solution to the worpdress comment sort.

  3. Zentode on September 23rd, 2008 8:08 am

    Excellent solution. Thanks. I will have to try this. Way better than having to refer to notes on what to change with every PHPWS upgrade. Thanks for the post.

  4. kasperidian.tumblr.com on May 11th, 2019 12:16 am

    Most vape tanks come with a spare glass tank.

  5. Pandora promo codice on May 12th, 2019 5:59 pm

    Someone essentially help to makoe serijously articles
    I might state. That is the very first time I frequented your websige page and so far?
    I amazed with thee research you made to create this particular publish amazing.
    Magnificent process!

  6. ルイ?ヴィトン ダミエ ショルダーバッグ on May 13th, 2019 8:11 pm

    hello!,I love your writing so a lot! percentage we be in contact more approximately your post on AOL?
    I require a specialist on this area to solve my problem.
    Maybe that’s you! Taking a look forward to see you.

  7. watch manyvids for free on May 18th, 2019 1:03 pm

    I think this is one of the so much significant info
    for me. And i am satisfied studying your article.

    But should remark on some common things,
    The web site taste is perfect, the articles is really great :
    D. Excellent process, cheers

  8. Chariotsoffire Sports activities Weblog | Live War on May 19th, 2019 2:42 pm

    […] you to have a superb time on the market, they need it to be a protected experience for each you and Pandora promo codice the […]

  9. Bruno on May 20th, 2019 6:16 am

    Excellent way of telling, and nice paragraph to obtain data about my presentation subject
    matter, which i am going to present in academy.

  10. Susannah on May 20th, 2019 6:46 pm

    Super wpis, w sumie się z Tobą zgadzam, choć w niektórych aspektach bym polemizowała.
    Na pewno ten blog zasługuje na uznanie. Jestem
    pewna, że tu jeszcze wpadnę.

  11. Creative Branding Indonesia on May 21st, 2019 1:18 am

    Thanks , I’ve recently been loooking ffor information approximately this topic foor a long time and yours is the greatest I have found out so far.
    But, what concerning the conclusion? Are you certain concerning the source?

    Feeel free too visit myy website :: Creative Branding Indonesia

  12. click here on May 26th, 2019 7:02 pm

    I feel that is among the most vital information for me.
    And i’m happy reading your article. However want to observation on few basic issues, The site taste is great, the articles is truly nice : D.
    Excellent task, cheers

  13. link on June 11th, 2019 3:13 pm

    This is a really good tip especially to those fresh to the blogosphere.
    Short but very precise information… Thank you for sharing this one.
    A must read post!

  14. forex on June 24th, 2019 6:07 pm

    What a information of un-ambiguity and preserveness of valuable knowledge on the topic
    of unexpected feelings.

  15. Lynwood on July 1st, 2019 8:12 am

    An impressive share! I have just forwarded this onto a coworker who had been conducting a little homework on this.
    And he actually ordered me dinner because I stumbled upon it for him…
    lol. So allow me to reword this…. Thank YOU for the meal!!
    But yeah, thanks for spending some time to talk about this matter here on your web
    page.

  16. athensgalawncare.blogspot.com on July 17th, 2019 11:21 am

    Thank you, I’ve just been searching for info about this suibject for ages andd yours is the greatest I’ve discovered so far.

    However, wjat in regards to the bottom line?
    Are you poswitive in regards to the supply?

  17. Nike Tienda Oficial on January 27th, 2020 5:51 pm

    I am realy delighted to read this weblog posts hich consists of plenty off helpful facts, thanks for providing such
    statistics.

  18. Adidas Baratas on July 16th, 2020 5:32 pm

    Thanks for finally talking about > WordPress comment sort order display order
    ascending or descending 2.6 < Loved it!

  19. taobao english on September 12th, 2020 2:40 am

    Today, I went tto the beach with my children. I
    found a sea shell and gave it to my 4 year old daughyter and said “You can hear the ocean if you put this to your ear.”
    She placed the shell to her ear and screamed. There was a hermit ccrab inside and it
    pinched her ear. She never wants to goo back! LoL I know thiis
    is completely off topic but I haad tto tell someone!

  20. 캣알바 on March 6th, 2021 1:38 pm

    Remarkable! Its actually awesome piece of writing, I have got much
    clear idea about from this paragraph.

  21. Musicale on April 7th, 2021 4:28 am

    If some oone needs expert view about blogging aftdr that i advise him/her
    to go to see this web site, Keep upp the nice work.

Feel free to leave a comment...
and oh, if you want a pic to show with your comment, go get a gravatar!






Hosted by the creator. Want one? $100 a year! Contact Me   Activism Blogs - BlogCatalog Blog Directory