• Resolved pimschaaf

    (@pimschaaf)


    For WPML support, filters need to be applied on the query that gets the results (as is done in wp_get_archives()). I found the following to be working:

    /**
     * Filter the SQL WHERE clause for retrieving archives.
     */
    $where = apply_filters( 'getarchives_where', "WHERE post_type = 'post' AND post_status = 'publish'" );
    
    /**
     * Filter the SQL JOIN clause for retrieving archives.
     */
    $join = apply_filters( 'getarchives_join', '' );
    
    //the following is the query from widget-archives.php:59 with added $jon and $where
    if ( $months = $wpdb->get_results( "SELECT YEAR(post_date) AS <code>year</code>, MONTH(post_date) AS <code>num_month</code>, DATE_FORMAT(post_date, '%M') AS <code>month</code>, count(ID) as <code>post_count</code> FROM $wpdb->posts $join $where GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date" ) ) {
    
    // rest of the code follows

    https://www.ads-software.com/plugins/better-archives-widget/

Viewing 5 replies - 1 through 5 (of 5 total)
Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘WPML support’ is closed to new replies.