[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