Instead of a JOIN, you can use a IN with a subquery, to prevent duplicate results because of the join: SELECT ID, display_name FROM wp_users WHERE ID IN (SELECT post_author FROM wp_posts) This will not look at capabilities. If you also want that you can add them like a join, but move the meta_key clause … Read more
I think this is what you are looking for: http://codex.wordpress.org/Function_Reference/update_user_meta Here is a example of how this can be achieved: http://inchoo.net/wordpress/programatically-add-metadata-to-user-accounts-in-wordpress/
There are plugins that will let you do this. http://wordpress.org/extend/plugins/user-files/ http://wordpress.org/extend/plugins/wp-filebase/ Whatever you decide though keep in mind security when doing things like this. You don’t want people going crazy and uploading huge files either, so check the plugins have built in restrictions on what can be uploaded and that they are in active development.
There are ways to trick WP into pre-populating the username field, but I’m pretty sure it would involve using POST and also tricking it into thinking there were errors in a previous submission. My advice would be to just use Javascript (or jQuery, as I’ve done below). It’s still ‘hacky’, but at least it gets … Read more
The elegant way to get posts out of the database is to use wp_query. It has all the filters you need: function wpse70323_count_user_posts_by_type( $userid, $post_type, $year, $month, $day ) { $query = new WP_Query( array( ‘author’ => $userid, ‘post_type’ => $post_type, ‘date_query’ => array( array( ‘year’ => $year, ‘month’ => $month, ‘day’ => $day, ), … Read more
You’ll want to use the ‘meta_query’ argument of WP_Query ( http://codex.wordpress.org/Class_Reference/WP_Query ) Here’s a snippet that uses two separate meta key comparisons: $query_args = array( ‘post_type’ => ‘event’, ‘order’ => ‘ASC’, ‘orderby’ => ‘meta_value_num’, ‘meta_key’ => ‘_start_date’, ‘meta_query’ => array ( array( ‘key’ => ‘_start_date’, ‘value’ => $_start_of_month, ‘compare’ => ‘>’, ), array( ‘key’ => … Read more
You need to make sure the new ID of the user in the user table matches the foreign key in the usermeta. Also a word of caution regarding your comment on Active Directory integration. For public facing websites be extremely careful, you could inadvertantly expose you domain controller information to the web. You might want … Read more
function is_user_a_member_of_this_group($user_id, $group_id) //return: bool return groups_is_user_member( $user_id, $group_id ); }
Might be overkill, but you might want to take a look at BuddyPress – it’s an actively developed project that extends WordPress with social networking features.
you can Disable users activation email: https://buddypress.org/support/topic/resolved-disable-users-activation-email/ and there is plugin to do its: https://timersys.com/free-plugins/bp-disable-activation-reloaded/