Changeset 7998

Show
Ignore:
Timestamp:
02/17/07 15:22:26 (1 year ago)
Author:
GamerZ
Message:

Missing WHERE

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • wp-stats/trunk/readme.html

    r7971 r7998  
    288288                              <b>Version 2.11 (01-05-2007)</b> 
    289289                              <ul> 
     290                                    <li>FIXED: Missing WHERE in get_authorsstats()</li> 
    290291                                    <li>FIXED: Password Protected Post Comments Viewable On Comment Author Stats</li> 
    291292                              </ul> 

  • wp-stats/trunk/stats/stats.php

    r7971 r7998  
    228228            $where = '1=1'; 
    229229      } 
    230       $posts = $wpdb->get_results("SELECT COUNT($wpdb->posts.ID) AS 'posts_total', $wpdb->users.display_name,  $wpdb->users.user_nicename FROM $wpdb->posts LEFT JOIN $wpdb->users ON $wpdb->users.ID = $wpdb->posts.post_author AND user_activation_key = '' AND $where AND post_status = 'publish' GROUP BY $wpdb->posts.post_author"); 
     230      $posts = $wpdb->get_results("SELECT COUNT($wpdb->posts.ID) AS 'posts_total', $wpdb->users.display_name,  $wpdb->users.user_nicename FROM $wpdb->posts LEFT JOIN $wpdb->users ON $wpdb->users.ID = $wpdb->posts.post_author WHERE user_activation_key = '' AND $where AND post_status = 'publish' GROUP BY $wpdb->posts.post_author"); 
    231231      if($posts) { 
    232232            $using_permalink = get_option('permalink_structure'); 

  • wp-stats/trunk/stats/wp-stats.pot

    r7971 r7998  
    33"Project-Id-Version: WP-Stats 2.11\n" 
    44"POT-Creation-Date: \n" 
    5 "PO-Revision-Date: 2007-02-14 23:53+0800\n" 
     5"PO-Revision-Date: 2007-02-17 23:22+0800\n" 
    66"Last-Translator: Lester 'GaMerZ' Chan <gamerz84@hotmail.com>\n" 
    77"Language-Team: Lester Chan <gamerz84@homtail.com>\n"