private messages counter
 

can i get a count for the number of private messages for each individual user? displayed directly underneath the number of posts hes made?

If you just want that for the current PMs it is pretty simple.

For all PMs (sent and received):
[sql]select count(*) from PM where userid=1234[/sql]

For sent PMs
[sql]select count(*) from PM where userid=1234 and folderid=-1[/sql]

For received PMs
[sql]select count(*) from PM where userid=1234 and folderid!=-1[/sql]

If you want a real counter you would have to create a new int field in table user or userfield and increment that whenever the user receives or sends a pm.

how would i increment that whenever a user recieves or sends a pm?

Unless you want to add a query per post, I wouldn't do that.

Not per post - per user ;)
You're right, I wouldn't do that either.

of course, i got that much. my question is>

if i just run the query, that wouldn't include the private messages count anywhere in the profile... would it? i need to include that somewhere in a profile field. how do i do that?

sorry i'm practically eliterate with this kind of stuff.

anybody out there?