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.
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
else
{
// or doing it once an hour
$DB_site->shutdown_query("
INSERT INTO " . TABLE_PREFIX . "views (forumid)
VALUES (" . intval($foruminfo['forumid']) . ')'
also change to
Code:
else
{
// or doing it once an hour
$DB_site->shutdown_query("
INSERT INTO " . TABLE_PREFIX . "view (forumid)
VALUES (" . intval($foruminfo['forumid']) . ')'
Has anyone updgraded to 3.07 with this hack? I just upgraded to vb 3.07 & can't get the views column to appear - it just doesn't show up - do you know what I could check?
The error you got before means that the 'views' column exist in more then 1 table used in the query. If you don't tell MySQL from which table you want to use that column, it won't have a clue what you are look for.
Solution:
Change 'views' into 'thread.views'
(Assuming that you are looking for the view count on the threads.)
Great hack. Would be nice to have a combined install file and not just the upgrade version. I would release the combined version I made but I made changes to it.