Version: 1.00, by shabbirbhimani
Developer Last Online: Aug 2021
Version: 3.0.3
Rating:
Released: 11-15-2004
Last Update: Never
Installs: 17
No support by the author.
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
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
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.
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.
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
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.