Has this hack been mentioned?

2 Boards: 1 User Table.

I have bought 2 VBulletin boards and I would like to have one constant user table for both... is this possible?

If you register on either board you can still post on both boards...

Has this been brought up before?

Thanks.

I've done this before for a client and it's in use right now. It works fine, and if I recall correctly the database.table.column syntax is part of the SQL 92 standard -- all versions of MySQL should support it. Just give it a try!!

For FanHome I decided that 5 sets of identical PHP files was a waste so I cooked up my own version of co-branding and I'm using that (e.g. template / replacement var sets) on FanHome.

All finished... I think.

I created a new user on forum2 and it was able to post and replay successfully on BOTH forums.

memberlists work on both forums...

private messages are seperate for each forum.

So id say it worked out great.

The only problem I saw was the most recent post when you are viewing a persons profile. If a more recent post was made on a different form it would show the time of that post but link it to the last post on the current forum where the memberlist is located because its taking out of different thread tables.

Woooooowww that was fun.. hehe it basically works.

The only problem arises is with the usergroup table in vB 1.X (not sure how it's handled in 2.0) -- if you add a moderator to one forum and they try and log in to the other you get a permission denied error since usergroupID XX doesn't exist in the other forum.

This shouldnt be a problem because im using the usergroup table from form1 i changed all instances of usergroup to forum1.usergroup.

That would give moderator status to a moderator on both forums with the same ID, no?

The user will have the same group permissions on forum1 and forum2.

Yes, yes they will. If you have identical forums I guess it won't be a problem.

forgot to tell ya...

I hade to add the following modifications to forum2 functions.php


added:

PHP Code:

if ($idname=='user') {
$idnameold = 'user';      
$idname = 'forum1.user';
} else {
$idnameold = $idname;
} 

if ($idname=='avatar') {
$idnameold = 'avatar';      
$idname = 'forum1.avatar';
} 


after:

PHP Code:

if (!isset($id) or $id==0 or $id=="") {
    if ($alert) {  // show alert?
      eval("standarderror(\"".gettemplate('error_noid')."\");");
      exit;
    }
  } else {
    $id=intval($id);
    if ($selall==1) {
      $selid = '*';
    } else {
      $selid = $idname.'id';
    } 


then changed

PHP Code:

if ($idname=='thread' and $threadcache["$id"]) {
      if ($selall!=1) {
        return $threadcache["$id"]["$selid"];
      } else {
        return $threadcache["$id"];
      }
    } else if ($idname=='forum' and isset($forumcache["$id"]) and $forumcache["$id"][forumid]==$id) {
      if ($selall!=1) {
        return $forumcache["$id"][forumid];
      } else {
        return $forumcache["$id"];
      }
    } else if (!$check=$DB_site->query_first("SELECT $selid FROM $idname WHERE $idname"."id=$id")) {
      if ($alert) { // show alert?
        eval("standarderror(\"".gettemplate('error_invalidid')."\");");
        exit;
      } 


to:

PHP Code:

if ($idnameold=='thread' and $threadcache["$id"]) {
      if ($selall!=1) {
        return $threadcache["$id"]["$selid"];
      } else {
        return $threadcache["$id"];
      }
    } else if ($idnameold=='forum' and isset($forumcache["$id"]) and $forumcache["$id"][forumid]==$id) {
      if ($selall!=1) {
        return $forumcache["$id"][forumid];
      } else {
        return $forumcache["$id"];
      }
    } else if (!$check=$DB_site->query_first("SELECT $selid FROM $idname WHERE $idnameold"."id=$id")) {
      if ($alert) { // show alert?
        eval("standarderror(\"".gettemplate('error_invalidid')."\");");
        exit;
      } 


Can someone translate this this for a newbie?

Could someone please redo the code for RC1?