View Full Version : How do I generate a list of members who have galleries?
September 29th, 2012, 08:16 AM
On my vBulletin forum, how can I generate a list of members who have images our photopost gallery?
Is there a way to generate a list of users who have a lot of images as opposed to just a few?
September 29th, 2012, 11:13 AM
You can do anything you wish provided you know how to write code. How you write some plugin all depends The query is quite easy you would need to add your prefix but here it goes
SELECT COUNT( * ) AS totalphotos, user
GROUP BY user
ORDER BY totalphotos DESC
September 30th, 2012, 04:16 PM
Here is a sample on my sidebar here
Reeftalk Forums (http://www.reeftalk.com/forums/forum.php)
You can do something like that on the vb4 sidebar using the sidebar block manager.
Basically you would add a new block type custom php make the name whatever you want and in the code portion use the contents of this text file filling in the proper infor for your install and you will get a sideblock list like this. This same code you could use to create a cms block as well whichever works.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.