Total Threads Hits At Forum Home

This product is no longer supported!



Total Threads Hits At Forum Home

This is a small lovely prodct that displays the total threads hits at forum home (see the attached screen shot)

Install instructions ::
Very Simple only import this product through your admincp [Add/Import Product]

There is one template modification
it is ::
go to ForumHome template & search inside it about the following code:

$vbphrase[members]: $numbermembers

then put after it directly the following code ::

<if condition="$vbulletin->options['threadstothits']">, $vbphrase[phpkd_total_hits]: $totalhits</if>

26/11/2005 This Fixed
15/1/2006 Updated to version 1.0.1


Changes log:
1.0.0 ==> initial Release
1.0.1 ==>

• adding admincp option for switching On/Off
• Fixed This ( get commas in high numbers )

Upgrading from version 1.0.0 to version 1.0.1:
go to template ForumHome & search for the following code:

,$vbphrase[phpkd_total_hits]: $totalhits

& replace It with the following code:

<if condition="$vbulletin->options['threadstothits']">, $vbphrase[phpkd_total_hits]: $totalhits</if>

Then import the attached product with Allow Overwrite set to yes


Thats all
hope You Like It

[Snake]

Also I get this error after the installation.

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT COUNT(*) ,
SUM(views) AS hits
FROM forum_ thread;

MySQL Error : Table 'amath_forum.forum_' doesn't exist
Error Number : 1146
Date : Thursday, November 24th 2005 @ 07:41:07 PM
Script : http://www.metalgearforum.net/index.php
Referrer : http://www.metalgearforum.net/index.php
IP Address : 193.188.105.22
Username : Aftermath
Classname : vb_database

[Omranic]

rb290 ===> its depend on your vbulletin settings not on my hack

Aftermath ===> this error isn't related to my hack
it related to the existing of thread table or not ( if it exist no error occurs if not error appears) it doesn't need any data base modifications, it only make a very simple mathematical calculation

[MioTraGusa]

Originally Posted by SolidSnake@GTI

Aftermath ===> this error isn't related to my hack
it related to the existing of thread table or not ( if it exist no error occurs if not error appears) it doesn't need any data base modifications, it only make a very simple mathematical calculation

Sorry but in the pluggin Thread's Total Hits at Forum Home :

PHP Code:

// ### SolidSnake@GTI Total Hits Start ###
$totalhits = $vbulletin->db->query_first("
        SELECT COUNT(*) ,
        SUM(views) AS hits
        FROM " . TABLE_PREFIX . " thread");

$totalhits = intval($totalhits['hits']);
// ### SolidSnake@GTI Total Hits End ### 


bad construct with one space extra .. change for:

PHP Code:

// ### SolidSnake@GTI Total Hits Start ###
$totalhits = $vbulletin->db->query_first("
        SELECT COUNT(*) ,
        SUM(views) AS hits
        FROM " . TABLE_PREFIX . "thread");

$totalhits = intval($totalhits['hits']);
// ### SolidSnake@GTI Total Hits End ### 


work fine this :up:

***Installed

Sorry for my english

[Omranic]

Originally Posted by MioTraGusa

bad construct with one space extra .. change for:

Sorry,
I can't notice that extra space you talk about
can you point it plz

[MioTraGusa]

yes ..

[Snake]

Oh he's right. Thanks for the fix.

[Omranic]

Sorry,
you are right
Fixed ...........

but I say that this error doesn't appear @ all forums coz I installed this on many forums & no errors appeared inspite of presence of this extra space

any way now it is fixed

[Snake]

Yeah thanks for that.

Solid Snake, ever thought of making a hack for Total Hits & Total Unique Hits? That would be cool, y'know.

[funinthesun]

*Installed* Thanks

[Omranic]

Originally Posted by Aftermath

Yeah thanks for that.

Solid Snake, ever thought of making a hack for Total Hits & Total Unique Hits? That would be cool, y'know.

can you explain ...