Suggestion: Most Visited Statistic

[Akiba]

I thought that it'd be interesting to have a statistic on each user's profile that indicates what forum or fora the user visits or posts in the most.

It would be a good way for people to know one's interests and activities. It would probably also be helpful for selecting moderators :)

Just a thought.

The SQL query for the top three fora would look something like this:

Spoiler:

SELECT forum, COUNT(forum) AS frequency
WHERE user = insert user here
FROM post
GROUP BY forum
ORDER BY frequency DESC
LIMIT 3;

I'm not sure how vBulletin works its databases, but that should be more or less it.

 

[El Héroe Oscuro]

For now, you should probably use this to gather those kind of info: snip. It contains a list of forums you've posted in, all sorted by activity. :] Just replace "336158" with your ID, and you're all set. I like your suggestion, though; it'd be very convenient if we could have statistics like that right in our own profile.

Just going off of this, there actually is something in your profile that "supposedly" allows you to see your own activity. If you go the Statistics portion of your profile, right in the box for Total Posts there is a line that says "Activity By Forum." Unfortunately though, that's just basic text and doesn't link to anything in particular.

If possible, we should code it so that when you click on Activity By Forum it will bring you right to the spread sheet that you just posted, Peitharchia. It will knock down two birds with one stone, in all honesty.