0
votes
1answer
21 views

Query unique author ids with published post of type job

I'm trying to come up with a simple query to return an array of unique author IDs that have a post_status of 'publish' and a post_type of 'job'. I know I can query using: $args = array( 'post_type' ...
1
vote
1answer
78 views

Change media attachment author via mysql query

How does one bulk change the media attachment author via an sql query? I have hundreds of media attachments that need to be moved to another author so the original author can be deleted; but that ...
0
votes
1answer
62 views

Filter posts by author selected in page

I've inherited a Wordpress project, and my client has a new feature request. For a "portfolio" page template, they want to be able to select an author, which I want to add to the $args in my ...
-3
votes
2answers
98 views

Query parsing only author ids

I need array only all author ids from the loop, each one only once if possible and out of all posts in the loop. Any suggestions?
1
vote
2answers
447 views

Order query by post meta value

//Displaying latest post per author on front page function filter_where($where = '') { global $wpdb; $where .= " AND vipwp_posts.id = (select id from {$wpdb->prefix}posts p2 where ...
0
votes
1answer
204 views

List author's posts with SQL

I want display authors'posts with the code below but authors' name aren't showing. What is wrong? <? // query test $qry = $wpdb->get_results( $wpdb->prepare(" SELECT * FROM $wpdb->posts ...
0
votes
2answers
764 views

Exclude some authors from query

This script list users with their last post. How to exclude some authors from guery ? <?php //List of users sorted descending by date of lastest post written by user $uc=array(); ...
1
vote
1answer
972 views

Show only oldest post by author

I am working with a heavily customized install of WP. I've set up a specific post type, taxonomy, and roles that gets to use just that post type. Ideally, I'd like to restrict members of that role ...
0
votes
1answer
779 views

pagination in author.php template returns 404 error

Hi to the community!!! I need some help with pagination in author.php template. I have pagination working in all my loops except in authors.php that i get a 404 error. In my settings/reading i have ...
0
votes
2answers
1k views

Display posts separated by Category in Author's page

I created an author's page using: <?php if(isset($_GET['author_name'])) : $curauth = get_userdatabylogin($author_name); else : $curauth = get_userdata(intval($author)); endif; ?> ...