The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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?
|
#2
|
||||
|
||||
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. |
#3
|
|||
|
|||
how would i increment that whenever a user recieves or sends a pm?
|
#4
|
||||
|
||||
Quote:
|
#5
|
||||
|
||||
Not per post - per user
You're right, I wouldn't do that either. |
#6
|
|||
|
|||
of course, i got that much. my question is>
Quote:
sorry i'm practically eliterate with this kind of stuff. |
#7
|
|||
|
|||
anybody out there?
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|