Version: 1.00, by AnhTuanCool
Developer Last Online: Sep 2006
Version: 3.0.3
Rating:
Released: 09-28-2004
Last Update: Never
Installs: 25
No support by the author.
vB Forum Counter
Version: 2.1
vBulletin Version: 3.0.3 (should work with 3.0.0)
Developed by AnhTuanCool
Install difficulty Level: Pretty short
Brief of Description:
vB Forum Counter add an option to have Forum views column on FORUMHOME display forum counter.
Feature:
Feature can be turn on/off
Option to update intermediately or after an hour
Forum counter makes a new column on FORUMHOME
Reset Forum Views
Updated:
For vb Advanced users (attachment) Updated from version 1:
Fix bugs - conflict between table in database
The function update after one hour not really works Update to version 2.1:
Add Reset feature
Screenshot:
In attachments...
Install:
Attachment also
Don't forget to click install if you use this hack INSTALL
If you got any problem or questions, just post it right here, I'm willing to help
Note: If you have problem with sql error in vb Advanced CMPS, then check out the txt file in attachment below, show how to fix it
There is no uninstall script so if you want to update then just see the updating instruction.
Enjoy!
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
Run this query:
[sql]ALTER TABLE `forum` CHANGE `views` `view` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL[/sql]
Open file ./includes/functions_forumlist.php
// ############################### Forum counter by AnhTuanCool ###############################
if ($vboptions['forumviewslive'])
{
// doing it as they happen
$DB_site->shutdown_query("
UPDATE " . TABLE_PREFIX . "forum
SET views = views + 1
WHERE forumid = " . intval($foruminfo['forumid'])
);
}
else
{
// or doing it once an hour
$DB_site->shutdown_query("
INSERT INTO " . TABLE_PREFIX . "views (forumid)
VALUES (" . intval($foruminfo['forumid']) . ')'
);
}
Replace with:
PHP Code:
// ############################### Forum counter by AnhTuanCool ###############################
if ($vboptions['forumviewslive'])
{
// doing it as they happen
$DB_site->shutdown_query("
UPDATE " . TABLE_PREFIX . "forum
SET view = view + 1
WHERE forumid = " . intval($foruminfo['forumid'])
);
}
else
{
// or doing it once an hour
$DB_site->shutdown_query("
INSERT INTO " . TABLE_PREFIX . "view (forumid)
VALUES (" . intval($foruminfo['forumid']) . ')'
);
}
If someone has the main forum saved in their favorites, instead of the directory - will it count as a hit? they aren't actually clicking on the link - they are already in the forum.
If someone has the main forum saved in their favorites, instead of the directory - will it count as a hit? they aren't actually clicking on the link - they are already in the forum.
thats the whole point is to keep track on how many views your getting to that particular fourms. it basicly works the sameway with your showthread views counter works.
Since I installed this hack, I get a database error.
_________________________________
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT forum.title AS forumtitle, thread.threadid, thread.title, thread.dateline,
thread.lastpost, pollid, open, thread.replycount, postusername, postuserid,
thread.lastposter, thread.dateline, views
FROM forum AS forum
INNER JOIN thread AS thread USING(forumid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE FIND_IN_SET('16', forum.parentlist) AND
thread.lastpost > 1096689607 AND
thread.visible = 1 AND
deletionlog.primaryid IS NULL
mysql error: Column: 'views' in field list is ambiguous
If it said column views is amibguous then you just change the name of the column and change some other things around so answer me the first question, I'll find out next for ya
If it said column views is amibguous then you just change the name of the column and change some other things around so answer me the first question, I'll find out next for ya
I do not know. it us happening from an unregistered user. It started after I installed this hack.