SQL synax problem

[TigerC10]

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.