• Hi!
    Could not find a plugin function that allows you to display all registered users in the site map.

    A temporary solution changed the sql query:

    $sql = "SELECT DISTINCT
    							u.ID,
    							u.user_nicename,
    							MAX(p.post_modified_gmt) AS last_post
    						FROM
    							{$wpdb->users} u,
    							{$wpdb->posts} p
    						WHERE
    							p.post_author = u.ID
    							AND p.post_status = 'publish'
    							AND p.post_type = 'post'
    							AND p.post_password = ''
    							" . (floatval($wp_version) < 2.1?"AND p.post_date_gmt <= '" . gmdate('Y-m-d H:i:59') . "'":"") . "
    						GROUP BY
    							u.ID,
    							u.user_nicename";

    this

    $sql = "
    SELECT
    	ID,
    	user_nicename,
    	user_registered AS last_post
    FROM
    	wp_users
    ";

    it works, but when you update the plugin code will fly. Please add the plugin can display all users.

    Thank you.

  • The topic ‘All users in the site map’ is closed to new replies.