battle hack needs to be fixed

[borbole]

Originally Posted by Simmons

oh thanks i'll try that

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

this is what happens when i try to install the product

Database error in vBulletin 3.8.6:

Invalid SQL:
CREATE TABLE IF NOT EXISTS vb_`dbh_victims` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 50 ) NOT NULL ,
`beat` VARCHAR( 50 ) NOT NULL ,
`cscore` INT( 10 ) NOT NULL ,
`oscore` INT( 10 ) NOT NULL,
UNIQUE (`id`)
);

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 '`dbh_victims` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 5' at line 1
Error Number : 1064
Request Date : Tuesday, September 14th 2010 @ 02:48:13 PM
Error Date : Tuesday, September 14th 2010 @ 02:48:13 PM
Script : http://lyricalbattlegroundz.net/foru...=productimport
Referrer : http://lyricalbattlegroundz.net/foru...?do=productadd
IP Address : 207.6.236.65
Username : Simz'
Classname : vB_Database
MySQL Version : 5.0.91-community

From the code you posted it looks like the quotes are not entered right at the db name.

This part here:

CREATE TABLE IF NOT EXISTS vb_`dbh_victims` (

If you see the quote, it is after the prefix. It should be before to include it as well. Like this:

CREATE TABLE IF NOT EXISTS `vb_dbh_victims`(

If you want to cover all prefixes, use this code:

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . "dbh_victims`  (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 50 ) NOT NULL ,
`beat` VARCHAR( 50 ) NOT NULL ,
`cscore` INT( 10 ) NOT NULL ,
`oscore` INT( 10 ) NOT NULL,
UNIQUE (`id`)
);