• Archives

  • October 2009
  • January 2009
  • November 2008
  • October 2008
  • August 2008

• Quick Comments

  All

  Latest on Sat, 12:29

  szyzafwolv: The chorion is holden to patch rich and multicentric

  guhhdbfwds: enclosed wasps to gander inequalities for their heaves

  wmypcnioik: The Lacunae

  https://sexonanet.net: _. Abundância Acabado bem como Outros Poemas. https://sexonanet.net/enchendo-a-buceta-de-coroa-casada-de-porra/

  Paulo Gustavo: Não se esqueça de Clicar no: GOSTOU? https://sexonanet.net/mature-wilma-seduces-young-guy/

  » Leave a reply

  Name
  

  Comment
  
  
  

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:

after:
$file = '/comments.php'

Example:

No mods to these areas:

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

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

Then on ~lines 654, 656 and 658 add:

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' ) )

$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'

$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' ) )

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

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

/** @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!

• Pages

  • Busch Gardens News
  • The Facts
    • The Purchase
    • Hostile Takeover?
    • Theme Parks Fate
    • Anheuser Beer List
    • Top 50 Breweries
    • InBev Products
  • Guestbook

Warning: Parameter 2 to M_DataMapper::set_custom_wp_query_where() expected to be a reference, value given in /home/freebeer/public_html/wp-includes/class-wp-hook.php on line 298

Warning: Parameter 2 to M_DataMapper::set_custom_wp_query_groupby() expected to be a reference, value given in /home/freebeer/public_html/wp-includes/class-wp-hook.php on line 298

Warning: Parameter 2 to M_DataMapper::set_custom_wp_query_fields() expected to be a reference, value given in /home/freebeer/public_html/wp-includes/class-wp-hook.php on line 298

Warning: Parameter 2 to M_DataMapper::set_custom_wp_query() expected to be a reference, value given in /home/freebeer/public_html/wp-includes/class-wp-hook.php on line 298


• Recent Posts

  • InBev sells all parks for 2.7 Billion
  • STOP DRINKING CORPORATE PISS
  • Hospitality House of Blues
  • No More Free Beer
  • Ban InBev products

• Categories

  • Save Busch Gardens