[buro9]

Originally Posted by osariase

Can anyone who has installed this hack successfully please help me with the DATABASE WORK i do not understand this part below help please

DATABASE WORK

In phpMyAdmin or from the MySql command line, run the applicable piece of SQL.
NOTE: You must replace TABLE_PREFIX with the prefix that you use on your VB3
installation... OR remove it if you are not using a table_prefix.

FOR A FRESH INSTALL:

CREATE TABLE TABLE_PREFIXsecretadmirer (
userid INT(10) NOT NULL,
admiresuserid INT(10) NOT NULL,
datecreated INT(10) NOT NULL,
PRIMARY KEY (userid, admiresuserid),
KEY admiresuserid_ix (admiresuserid),
KEY userid_ix (userid)
) TYPE = MYISAM;

Simple.

In your ./includes/config.php file you have a setting named $table_prefix.

In the first line of this query is this line:
CREATE TABLE TABLE_PREFIXsecretadmirer (

If your table prefix setting = "vb3_" then you should change that line to:
CREATE TABLE vb3_secretadmirer (

If your table prefix setting = "forum_" then you should change that line to:
CREATE TABLE forum_secretadmirer (

If your table prefix is blank or empty then you should change that line to:
CREATE TABLE secretadmirer (

Once your have made that change then you should run that SQL query in a program like PhpMySql and it will create the table for you