The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
query
what query would i need to run to find out the number of members who have posted more than 100 times in the post 30 days but excluding mods, admins and supermods
|
#2
|
||||
|
||||
Untested, but try:
[SQL] SELECT * FROM `user` ORDER BY `posts` AND `lastpost` DESC LIMIT 0 , 30 [/SQL] |
#3
|
||||
|
||||
Actually I am thinking the only way to get the right number you would have to do a query on all posts, Have it sort them by members id then date.
Hmmm the only way I can think of is to much work |
#4
|
||||
|
||||
thanks, will test it and let you know how it goes
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|