prefix for your database tables

General

This hack has been created using a vB 2.2.5 but I think it should be working with any vB 2.x.x. This hack is BETA, I'm sure you will get some database errors on your board. Please do NOT use it on production boards.

What this hack does

This hack allows you to add a prefix to your table names (example: if you use the prefix "vb_" your table "user" would be named "vb_user". This is important if you want to install multiple vBulletins on one database.

How does it work

If $dbprefix is set in the config.php, the table names are changed in every query. This works as the following: if the table {prefix}{tablename} exists, it will be changed to {prefix}{tablename}, if not, it will be left as {tablename}. This will make it possible to have some tables changed to vb_* and others not. This is for the possibility you want to use some tables (for example the user related tables) in multiple boards.

(okay, this is a bit confusing, but my english isn't very well )

How to install (there will be a better manual for the final release)

#####
# in ./global.php, ./admin/global.php and ./mod/global.php:

Replace

$DB_site->password=$dbpassword;

with

$DB_site->password=$dbpassword;
$DB_site->prefix=$dbprefix;

#####
# in ./admin/db_mysql.php:

Find

  function query($query_string) {
    global $query_count,$showqueries,$explain,$querytime;
    // do query

and below it, add

    if ($this->prefix != "") {
      $query_string = $this->addprefix($query_string);
    }

Find

  function fetch_array($query_id=-1,$query_string="") {

and above it, add

  function addprefix($query) {
    static $tablenames;
    if (!is_array($tablenames)) {
      $tablenames = array();
      $len = strlen($this->prefix);
      $q = mysql_list_tables($this->database,$this->link_id);
      while(list($table) = mysql_fetch_array($q)) {
        if (strstr($table,$this->prefix)) {
          $short = substr($table,$len);
          $tablenames["$short"] = $table;
        }
      }
    }
    reset($tablenames);
    $query = str_replace("\n"," ",$query);
    $query = str_replace("\t"," ",$query);
    while (list($short,$new) = each($tablenames)) {
      while(preg_match("/SELECT(.*)([ ,(]+)$short([\.]+)(.*)FROM /i",$query)) {
        $query = preg_replace("/SELECT(.*)([ ,(]+)$short([\.]+)(.*)FROM /i","SELECT\\1\\2$new\\3\\4FROM ",$query);
      }
      while(preg_match("/UPDATE(.*)([ ,]+)$short([ ,]+)SET/i",$query)) {
        $query = preg_replace("/UPDATE(.*)([ ,]+)$short([ ,]+)SET/i","UPDATE\\1\\2$new\\3\\4SET",$query);
      }
      while(preg_match("/INTO(.*)([ ,]+)$short([ (]+)/i",$query)) {
        $query = preg_replace("/INTO(.*)([ ,]+)$short([ (]+)/i","INTO\\1\\2$new\\3\\4",$query);
      }
      while(preg_match("/ FROM(.*)([ ,=(]+)$short([ ,\.]+)/i",$query)) {
        $query = preg_replace("/ FROM(.*)([ ,=(]+)$short([ ,\.]+)/i"," FROM\\1\\2$new\\3",$query);
      }
      while(preg_match("/ FROM(.*)([ ,=(]+)$short$/i",$query)) {
        $query = preg_replace("/ FROM(.*)([ ,=(]+)$short$/i"," FROM\\1\\2$new",$query);
      }
    }
    return $query;
  }

#####
# in ./admin/config.php

Somewhere, add

// tablename prefix
$dbprefix='vb_';

That should be all file changes. Now you can rename the tables you want to have using the prefix to "vb_*".

That's all... post bug reports, questions etc. here, do not pm, email or icq me about this hack - you will be ignored. Thanks.

[GameCrash]

That would be great, thank you

[snyx]

Originally posted by xiphoid
YES< I only have once license, but this is on my second system behind the router, in the network, and not public. URI can't be reached through internet.

lol, chill man its okay to run a vb for test purposes

[Admin]

I was thinking about this yesterday... wouldn't it be easier to just preg_replace() the whole query with the array of tables?

[GameCrash]

Well... I have never used preg_replace with arrays... let me think about it

[GameCrash]

Originally posted by xiphoid
I have set up a test board yesterday on my winxp system here :P apache/mysql/php, so this would be nice to test! I will install several instances and try to run multiple with the same userbase and some other equal sections and see which errors i will run into.

Did you test it yet?

[Link14716]

well, I see this hack, but I am wondering how to rename my tables?

[Link14716]

Nevermind about that, I figured it out, but now, when I go to the board, I am greeted with this error (note, that I renamed index.php to index1.php)

Database error in vBulletin 2.2.6:

Invalid SQL: INSERT INTO vggmmb_v5_session (\4sessionhash,userid,host,useragent,lastactivity,location) VALUES ('54197df039674b2245709c015eb9657f','2','24.240.147.243','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;','1026008749','/index1.php')
mysql error: You have an error in your SQL syntax near '\4sessionhash,userid,host,useragent,lastactivity,location) VALUES ('54197df03967' at line 1

mysql error number: 1064

Date: Sunday 07th of July 2002 03:25:50 AM
Script: http://mb.vggmn.com//index1.php
Referer:

Any suggestions?

Same thing also happens anywhere.....

[GameCrash]

Your prefix is 'vggmmb_v5_'?

What PHP version do you use?

[agamer]

i installed this and am getting little errors e-mailed to me, as well as on the board.

PHP Code:

Database error in vBulletin :

Invalid SQL: SELECT template FROM template WHERE title='options'
mysql error: Table 'template' doesn't exist

mysql error number: 1146 


i have it as vb_template, why is it not working correctly?

I have edited the files, and double checked them, and triple checked them today, i have followed the instructions down to the letter.

I can't figure it out.

I'm running 2.2.6.


-agamer

[GameCrash]

I'm really wondering about this because this is a very simple SQL Query that shouldn't make probmels... What page is this error on? Are you sure you have added $DB_site->prefix=$dbprefix; to all three global.php files?