battle hack needs to be fixed

[Simmons]

i have a battle system given to me that was coded on a vb board with no table prefix. My vb is set up with table prefix: vb_ so the code breaks when i try to install it

is there anyone able to rewrite the code with the table prefix?

I can send you all the files for it so you have something to work with

[borbole]

Append this code to the table name/s in your script:

" . TABLE_PREFIX . "

[Simmons]

in what script?

[borbole]

in what script?

At the custom script that it gives you the error. Find the queries with the db tables and append tot hem the code I posted. That should fix it as it covers all the custom prefixes a db might have.

[Simmons]

oh thanks i'll try that

--------------- Added 1284490180 at 1284490180 ---------------

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/forums/admincp/plugin.php?do=productimport
Referrer : http://lyricalbattlegroundz.net/forums/admincp/plugin.php?do=productadd
IP Address : 207.6.236.65
Username : Simz'
Classname : vB_Database
MySQL Version : 5.0.91-community

[borbole]

oh thanks i'll try that

--------------- Added 1284490180 at 1284490180 ---------------

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/forums/admincp/plugin.php?do=productimport
Referrer : http://lyricalbattlegroundz.net/forums/admincp/plugin.php?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`)
);

[borbole]

Hi Simmons. I am following up on this. Did you manage to resolve the issue now?

[Diasick]

dont help this guy out, this was my battle hack he stole from my server, and expected you all to help him finish it.

all he had to do was install the database for it, as I didnt have it ready for installation.

I know this post is nearly 5 years old, so I hope he wasnt able to get help lol.