The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
SQL query to count unread PMs?
I'm wondering if anyone has written a SQL query/PHP function to grab the number of unread PMs based on nickname/userid?
Looking to display this information outside of the vb template environment. Any help? |
#2
|
||||
|
||||
Here a quick function I wrote.
PHP Code:
PHP Code:
|
#3
|
||||
|
||||
It's stored in the user table ;
Code:
SELECT pmunread FROM user WHERE userid = 123 |
#4
|
||||
|
||||
Lol, dammit.
|
#5
|
|||
|
|||
do you know how to select thread titles with letter beginning exam: A ???
|
#6
|
||||
|
||||
Use LIKE 'A%'
|
#7
|
|||
|
|||
thank you administrator Paul
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|