The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
Sql to get the unread thread count for a user
Hi,
We are trying to integrate the vBulletin with our website and we need to show the unread thread numbers of a user in vBulletin. We tried to use below sql to get the unread number: select count(*) from thread where lastpost>(select lastvisit from user where username='admin') But the return value isn't proper sometime and the vBulletin can know which thread is unread, how to get the unread thread of a user throught sql query? Thanks Alex |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|