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

[MauriceReed]

just installed this one mate, but as a total n00b, how do i create the 2 .php files??

monthly.php and weekly.php??

any help would be appreciated.
btw..install went fine....all SQL queries went ok, and displays on forum index fine......just with 2 blank columns tho, due to the 2 .php files not being installed.

[MauriceReed]

anyone??

[shabbirbhimani]

Originally Posted by MauriceReed

just installed this one mate, but as a total n00b, how do i create the 2 .php files??

monthly.php and weekly.php??

any help would be appreciated.
btw..install went fine....all SQL queries went ok, and displays on forum index fine......just with 2 blank columns tho, due to the 2 .php files not being installed.

Sorry but I was outstation.

The 2 php files can be created in any Editor like Notepad or VI.

Thanks
Shabbir Bhimani

[taffy056]

Hi,

I was getting the same error message as post number 14, but after I put the query in the following post I get this error on the forumhome, can you suggest a fix to this.

Thanks

PHP Code:

Database error in vBulletin 3.0.7:
Invalid SQL: SELECT userid, username, count(username) as posts FROM post as post where dateline >  group by username ORDER BY posts DESC
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by username ORDER BY posts DESC' at line 1

mysql error number: 1064 


[shabbirbhimani]

Originally Posted by taffy056

Hi,

I was getting the same error message as post number 14, but after I put the query in the following post I get this error on the forumhome, can you suggest a fix to this.

Thanks

PHP Code:

Database error in vBulletin 3.0.7:
Invalid SQL: SELECT userid, username, count(username) as posts FROM post as post where dateline >  group by username ORDER BY posts DESC
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by username ORDER BY posts DESC' at line 1

mysql error number: 1064 


possible reason for your error can be the prefix that you have given when installing the vB. Use that prefix in all the tables but here in post table you are not prefixing it. I hope this should solve the problem but if not you can post again.

Also if you want much faster response you can use my site also.. url in sig.

[Startinfresh]

Got a question

Is there any way that you can make it so that only Admin and Super Mods can view this?

Another question, timestamp table has me stumped. Anyone care to help out

[Startinfresh]

is timestamp table the same as a template???

[Startinfresh]

Ok, I got the timestamp table

[JagFan]

Installed. Thanks!