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

Nice job !

Can we have a screenshot ?

From the instruction files:

This ought to be a joke, right? You want us to swap forums/index.php with your own? Have you taken into consideration that 99% of us here have installed hacks? The way to do this thing is to point out the changes to be made in index.php.stats.php and querries.php

:squareeyed:

Agreed: your best bet is to indicate where the changes should be made, and what those changes are, as opposed to suggesting we should just wholesale replace the files with your modified files.

Good job tho' I've been looking for a more extensive version of the "daily" version of this...

// EDIT: Looking over the code: I like it, but it will take some time to integrate, as I'd want to get some data from queries that are already run by other hacks (I definitely don't need *more* queries on FORUMHOME), so I'll remove this, and get back to it when I have time...

Good job tho'

This goes against the vBulletin.org rules and is in breach of your licensing agreement. You cannot distribute full working copies of scripts from vBulletin. You must publish your code separately. You're also shipping your vBulletin license number around.... can't believe this is a good thing either?

I placed the below lines also.

Replacing the above files will inject some additional codes which
you can find between the comment.
// Coded By ....

Daily version can be done if you execute the sql to update timestamp daily.

Deleted the attachment with this and I will attach a seperate files maintaining all the above mentioned guidelines.

I hope as this is my first work its bound to have some mistakes.

Thanks
Shabbir Bhimani

umm... wheres the file at.

Attached

Also I have tried to apply all the guidelines and let me know how the hack is working.

Thanks, quite useful!

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

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

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

Thanks, but now I have a new problem:

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

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

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

I think this should solve the problem.

Now it works. Thanks a lot!

great hack ;)

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

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

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

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.

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

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.;)

anyone??

Sorry but I was outstation.

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

Thanks
Shabbir Bhimani

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

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.

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 ;)

is timestamp table the same as a template???

Ok, I got the timestamp table ;)

Installed. Thanks!