AAC Conver

[bok]

I needed to convert this script to Gesior 2012 is showing the error:

Fatal error: Call to a member function fetch()

            $v = $SQL->query("SELECT (SELECT COUNT(`death_id`) FROM `killers` k LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id` LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id` WHERE `k`.`unjustified` >= 0 AND `player_id` = '" . $player->getID() . "'), COUNT(`player_id`) FROM `player_deaths` WHERE `player_id` = '".$player->getID()."'")->fetch();

Complete script:

$bgcolor = (($number_of_rows++ % 2 == 1) ?  $config['site']['darkborder'] : $config['site']['lightborder']);
            $v = $SQL->query("SELECT (SELECT COUNT(`death_id`) FROM `killers` k LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id` LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id` WHERE `k`.`unjustified` >= 0 AND `player_id` = '" . $player->getID() . "'), COUNT(`player_id`) FROM `player_deaths` WHERE `player_id` = '".$player->getID()."'")->fetch();
            $main_content .= '<tr bgcolor='.$bgcolor.'><td>Kills and Deaths:</td><td>' . htmlspecialchars($v[0]) . ' kills and ' . htmlspecialchars($v[1]) . ' deaths</td></tr>';