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.

[Bro_Joey_Gowdy]

Hmmmm..... Im not doing something right, take a lok at the errors... anythoughts?

Warning: Cannot add header information - headers already sent by (output started at /www.joeygowdy.com/gundamarmada/admin/db_mysql.php:163) in /www.joeygowdy.com/gundamarmada/admin/functions.php on line 1652

Warning: Variable passed to reset() is not an array or object in /www.joeygowdy.com/gundamarmada/admin/db_mysql.php on line 163

Warning: Variable passed to each() is not an array or object in /www.joeygowdy.com/gundamarmada/admin/db_mysql.php on line 166

Line 163 is reset ( $ tablenames ) ;

and Line 166 is while ( list ( $ short , $ new ) = each( $ tablenames ) ) {

Also, would useing phpmyadmin help ?

[GameCrash]

Hmm... this would happen if you don't have any table with the prefix... try changing

    if (!is_array($tablenames)) {
      $len = strlen($this->prefix);

to

    if (!is_array($tablenames)) {
      $tablenames = array();
      $len = strlen($this->prefix);

- I will add this to the instructions if it works...

[Bro_Joey_Gowdy]

Thanks, Its looking good now - will keep ya informed on any other problems - also im useing vb2.3.0

[gmarik]

Could you put the hack in a .txt file? Uhh?

[GameCrash]

Why? If you own a license you can see the codes in the first post. If not, you can't download any text file

[Peakin]

hmm, new user to vb here, applied this hack to vb 2.3.2 all well and good, works a charm, but, now when posting a msg, a word is the same as a table name eg "access" its replacing it with prefix_access..

this only happens in mid sentence, eg:

access

is ok, but in sentence:

blablbablah vb_access blah

anyway to stop this?

please help.

ps. i should add that i am using a front end for vb (auto account creation in vb) and just had to heavily mod it to work with vb 2.3.2, so i wont be able to use vb3 for some time, so thats not an option...

[GameCrash]

Hm, I'll have a look at it... should be possible to do something here...

[Peakin]

Thanks man, I'd appreciate that =)

[geekylucas]

Originally Posted by Peakin

hmm, new user to vb here, applied this hack to vb 2.3.2 all well and good, works a charm, but, now when posting a msg, a word is the same as a table name eg "access" its replacing it with prefix_access..

Did anyone manage to figure out a way to prevent this happening (aside from upgrading to vbulletin 3)? I'm having the same problem. =(