Forum Views Counter - Track the number of forum views
 

This hack will allow you to track how many views each forum has. This is useful to help you see in which areas you need to focus time on your site. Since you will know where the members are hovering.

To upgrade from 1.0.0 reinstall the product file. Since it had an error in the query for installing it that made it unusable.

Demo: http://www.extremewebtech.com/forums/

This will work on 3.5 if you remove the executionorder="5" from the product file.

Enjoy this hack you guys.

And as always if you enjoy this free hack and would like to see them keep coming please donate.

Donations can be sent via paypal to: tim@extremechatforums.com

Support will be given here: http://extremewebtech.com/forums/showthread.php?t=94

Reserved

First, I think it's wrong to post a "hack" for all here on VB.org and then require "support" to be on your forum where you have to sign in to do this. I belong to enough forums. To me that's like making a hack and posting it here--which is cool--but then siphoning traffic.

I think it's fine when folks like Visionscripts post there free hacks and support them on this forum. Everyone can have links in their signatures, shouldn't that be acceptable for traffic? Just my thoughts, and some advice, printed words sound harsher than spoken words, so don't take my comments in a bad manner, take them as constructive criticism.

Now my quesetion, which I want answered here where the hack was introduced, again, I'm no programmer/coder, is where does you hack start counting views, is it from the day installed? Just curious, thanks, rg sends!

The day installed. The reason i support on my site is for one reason and that is the Time Element of how much time is required per day to support my hacks. Its hard to support them in multiple locations since they are released on more then one site. I just dont have time to read thro threads of the same questions at 2+ different sites.

Just to help clarify the support issue.......I believe you will find that if you do go to his support forum, that is all it is, support tech........there really isn't anything else on the extremewebtech, other then that........his regular site is extremechat, where he isn't sending people.......

I too understand what you are saying and felt the same way at first, but the extremewebtech, seem's to give him time to relook at issue's without wasting alot of bandwidth here.....

Just my .02.

exactly. :)

especially since i release the hacks on multiple sites it really helps to lighten my work load. :)

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, fviews
, forumread.readtime AS forumread
FROM forum AS forum
LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1);

MySQL Error : Unknown column 'fviews' in 'field list'
Error Number : 1054
Date : Monday, October 9th 2006 @ 08:57:19 PM

:(

Same.

Again, not trying to be an arse here, but as a father of five kids, running two boards, one on line since 1999 and huge, professional photographer, lecturer, speaker, instructor, author, writer and on the road, it's very difficult for me too to have to go to upteen different VB forums. I guess we're both saying the same thing--we both have the prioritization of time issues. Not trying to diss you, just thought the whole idea of a place like VB.org is to centralize hacks and mods and all that evolves around them--now that saves time for everyone.

You could do what some other folks do at other sites, post links back here to their mods/hack from other sites, again, to centralize so everyone can see the latest and greatest on a hack.

On the other hand, I can understand support forums on other locations for paid mods sold at other sites, that is understandable to support the product. Just my thoughts, wishing you the best, rg sends!

yea theres an error in the query of the product file.

Updated

I have installed the new product with the instructions in the txt and i get this:

I would recommend that nobody else installs this untill it is fixed.

I will take a look again but im not sure why its not adding the field for you since others seem to be having no trouble with it.

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, fviews
, forumread.readtime AS forumread
FROM forum AS forum
LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1);

MySQL Error : Unknown column 'fviews' in 'field list'
Error Number : 1054
Date : Tuesday, October 10th 2006 @ 02:30:06 PM
Script : http://www.gsmciler.com/forum/index.php
Referrer : http://www.gsmciler.com/forum/admincp/index.php?do=head
IP Address : 555555555
Username : xxxxxxxxxxxx
Classname : vb_database


what is the problem :surprised:

There should be fixed now. anybody who has this hack already installed please uninstall the product if its not working and then install the updated one. Do not just try to overwrite the product as that will not fix the issue.

Wheres is it on your fourms at http://www.extremewebtech.com/forums?
I dont' see it

the views column in the forumbit.

Have you had any luck fixing it Tim?

James

i released an update yesterday and provided upgrade steps that should have fixed it.

I have installed the newest version and I take many Sql errors.

ima kick this damn thing lol

Try this one: Should fix the query problem........

im just wondering why there is a problem when im not noticing one. lol

Good question.........I wasn't able to install this version do to some other mods i built into my site. The alter table should work just fine........

Ill be updating this in the next few days and creating an addon hack possible ;)

is this unique visits or every visit?

Any update on this hack??? Btw, your support link is dead.

Thanks, that totally fixed it.

...seems the author forgot to include creating the field in the forum table that his code was looking to read.

No my query appears to have an error is all lol. Ill update the package shortly for this.

Any news on this mod?? :D

it works on the latest version but you have to manually add the query

So i just run that query through mysql, correct?

Hmmm.. i was testing this out and it works. But when i look at a forum section and go back to the index, instead of adding +1 view it adds like +15. Why is it doing that?