How to get the most viewed thread of the month

[prosperous]

Hi,

I am new to forum. i've setup a new forum and i want to encourage people to post in the forum by awarding member who create the most viewed thread of the month. The problem is how can i get the most viewed thread of the month? do i have to get it using sql query? how?

Thank you very much for your help.

Best regards,
prosperous

[Triky]

Try this: https://vborg.vbsupport.ru/showthread.php?t=107711.
I don't know if it will work for the newer vBulletin version.

[prosperous]

Hi Triky,

Thanks a lot for your reply.

Actually that's not quite what I want. I want to be be able to get the list of threads created since the beginning of the month and the number of views for each of them. I want to be able to get the information anytime. I plan to create a thread that I'll update daily with the information.

I think this should be doable using SQL query, right? Can anyone tell me how to make a readonly query to the vbulletion database?

Thank you very much.

Best regards,
prosperous