squish

Something like

SELECT user_login,user_email from wp_usermeta
LEFT JOIN wp_users on wp_users.ID=wp_usermeta.user_id
WHERE wp_usermeta.meta_key=”newsletter”
AND wp_usermeta.meta_value=”Yes”

you might have to change the case of “newsletter” or “Yes”.

do a “select * from wp_usermeta where user_id=1” and show us the results. I would expect to see nickname being Administrator, wp_user_level being 10.

I think you could do this quite easily. The first step is to modify your theme so that whether you are logged in or not, you get the input fields for all users to identify themselves. The second bit is to change comments-post.php so that where it says // If the user is logged in, it doesn’t populate $comment_author, $comment_author_email and $comment_author_url – best thing to do is just comment out those three lines.

There may be other stuff to do…

Have you tried Userextra? If you create two categories, one called “friends” and one called “family” and then for each of your users you give them access to friends, family or both, that may give you some of what you’re looking for?

You could put your posts in the normal categories you would anyway, and then optionally put them in friends and/or family categories. Then, you use the adjudication style of Userextra to be Unanimous Permit, meaning that to be able to see the post you need to have access to all categories that the post is in.

I think my plug-in might do what you require: https://dev.wp-plugins.org/wiki/Userextra

I’ve tried to add some functionality to Userextra to do this. See version 0.2 at https://dev.wp-plugins.org/wiki/Userextra to download.

The three things I’ve added are:
– There’s now an additional option:
“List of category names users can’t post to by default”
(as before, the per-user category allow/deny rules apply)
– The Write Post window now only has the categories you can post to listed.
– Attempts to post with a restricted category will throw up an error (just incase someone crafts a request by hand)

Let me know if this is any good for you.

(sortof repeat from the other thread about Userextra)

How about:

<p>This post written by <?php the_author(); ?> who lives at <?php $usermeta = new Usermeta(); echo $usermeta->get(get_the_author_ID(), "address", true); ?></p>

Here is an example, with the field “address”. It will work in the Loop for a post:

<pre>Address:
<?php
$usermeta = new Usermeta();
echo $usermeta->get(get_the_author_ID(), "address", true);
?>
</pre>