Most Active User Hack

Hello All

The hack is about who is most active user of the Week, Month, It counts the no of post by the user from a given time which can be updated in the admin panel. The use of this is for who are starting with forums and can give some awards to the most active user. I give a free banner though. I dont know if anything like this is available but would like to share this hack.

Read Install.txt as how to install the hack.

Also please remember
Its better if you keep the files that are replaced and everyone
should follow the thumb rule -
"If anything can go wrong it will go wrong".

Thanks
Shabbir Bhimani

[shabbirbhimani]

hmmmm i have followed the instructions but now i get a db error

Can you tell me what error you are getting and where. If you can explain a bit more I can help you out.

Thanks
Shabbir Bhimani

[bigM]

I can't find the "monthly.php and weekly.php"

Can you tell me, where I can find the templates and php files?

Thanks
bigM

[shabbirbhimani]

I can't find the "monthly.php and weekly.php"

I havent provided them as they are not part of the hack. This files are on my server which just list what I offer for most active user monthly/Weekly.

http://www.go4expert.com/weekly.php
http://www.go4expert.com/monthly.php

They are just plain html files names as php.

Thanks
Shabbir Bhimani

[bigM]

Thanks, but now I have a new problem:

Datenbankfehler in vBulletin 3.0.3:

Ungueltige SQL-Abfrage: SELECT weekly from timestamp where weekly < 1101295899
mysql error: Table 'usr_web40_1.timestamp' doesn't exist

mysql error number: 1146

I get this MySQL Error, when I go to index.php...

[shabbirbhimani]

You have created the table as expert_timestamp but you dont have any prefix for your forums so you need to create the table as
CREATE TABLE timestamp
(weekly int(10) unsigned,
monthly int(10) unsigned);

Thanks and I am updating the install files too.
Shabbir Bhimani

[shabbirbhimani]

I have uploaded the latest with a note below create table ...

I think this should solve the problem.

[bigM]

Now it works. Thanks a lot!

great hack

[shabbirbhimani]

Originally Posted by bigM

Now it works. Thanks a lot!

great hack

My pleasure and
I see the hack installed on http://www.comedy-foren.de/

[MikaK]

How does this hack adjust the timespan for weekly and montly views? Can I add additional time interwalls like quarterly, semiannually and yearly?

How about excluding specific members or perhaps entire member groups?

Best regards,
-Mika

[shabbirbhimani]

How does this hack adjust the timespan for weekly and montly views?

it does that by keeping the unix timespan in the table that has been created.

Can I add additional time interwalls like quarterly, semiannually and yearly?

You can always edit the table to add the time span. I have two time span weekly/monthly you can add or use them for monthly/yearly.

How about excluding specific members or perhaps entire member groups?

I havent done this as I was interested in manually giving a banner so I did not have any need as this.