Hook location help

[MoMan]

Looks like that would be around

PHP Code:

($hook = vBulletinHook::fetch_hook('showthread_query')) ? eval($hook) : false; 


--------------- Added [DATE]1230969042[/DATE] at [TIME]1230969042[/TIME] ---------------

Update:

After placing that query after showthread_query, I get a DB error:

Database error in vBulletin 3.7.4:

Invalid SQL:
SELECT COUNT(DISTINCT(userid)) AS usercount, COUNT(*) AS usercountall, rating 
											FROM _vbitrader 
											WHERE rateduserid =  
											GROUP BY rating;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY rating' at line 4
Error Number  : 1064
Request Date  : Saturday, January 3rd 2009 @ 01:47:53 AM
Error Date    : Saturday, January 3rd 2009 @ 01:47:54 AM
Classname     : vB_Database
MySQL Version : 5.0.22

The exact code I'm running is:

PHP Code:

// ###################### Generates iTrader Score Info #######################


    // This is the first column's data, but also can be used to update a user's score

    $userinfo['tradepos'] = 0;
    $userinfo['tradeneu'] = 0;
    $userinfo['tradeneg'] = 0;
    $userinfo['tradeposall'] = 0;

    $itraders = $vbulletin->db->query_read("SELECT COUNT(" . ($vbulletin->options['itrader_ratestyle'] ? 'DISTINCT(userid)' : 'userid') . ") AS usercount, COUNT(*) AS usercountall, rating 
                                            FROM " . TABLE_PREFIX . "itrader 
                                            WHERE rateduserid = " . $userinfo['userid'] . " 
                                            GROUP BY rating
                                        ");

    while ($itrader = $vbulletin->db->fetch_array($itraders)) {
        switch ($itrader['rating']) {
        case 1:
           $userinfo['tradepos'] = $itrader['usercount'];
           $userinfo['tradeposall'] = $itrader['usercountall'];
           break;
        case 0:
           $userinfo['tradeneu'] = $itrader['usercount'];
           break;
        case -1:
           $userinfo['tradeneg'] = $itrader['usercount'];
           break;
        }
    }

    $dbupdate['itrader_total'] = $userinfo['tradescore'] = $userinfo['tradepos'] - $userinfo['tradeneg'];

    $userinfo['tradescore'] = vb_number_format($userinfo['tradescore']);

    $tradeall = $userinfo['tradepos'] + $userinfo['tradeneu'] + $userinfo['tradeneg'];

    if($tradeall) {
        @$userinfo['tradepcnt'] = (1 - ($userinfo['tradeneg'] / $tradeall) ) * 100;
        $dbupdate['itrader_pcnt'] = round($userinfo['tradepcnt'],0);
        $userinfo['tradepcnt'] = vb_number_format($userinfo['tradepcnt'],1);
    } else {
        $userinfo['tradepcnt'] = 0.0;
        $dbupdate['itrader_pcnt'] = round($userinfo['tradepcnt'],0);
    }

    return;


// ###################################################################### 


I'd appreciate your help in sniffing out the problem, as my expertise in php doesn't got as far as I'd like it to.