You're still missing a closing parenthesis (from right after the dbhVictims), and you may also want to get rid of the ` symbol. In Perl the `operator performs a system command and PHP is supposed to be Perl embedded in HTML (but I'm unclear as to the status of the ` operator in PHP).
Try this instead...
PHP Code:
$vbulletin->db->query_write(
"CREATE TABLE IF NOT EXISTS ".TABLE_PREFIX."dbhVictims (
id INT( 4 ) NOT NULL AUTO_INCREMENT,
username VARCHAR( 45 ) NOT NULL,
beat VARCHAR( 45 ) NOT NULL,
cscore INT( 1 ) NOT NULL DEFAULT 0,
oscore INT( 1 ) NOT NULL DEFAULT 0,
PRIMARY KEY(id)
)"
);
Doing it this way (with the staggered indents) makes errors more obvious to see in the future.