Forum Subject: User table bridge

Posted on: 02/21/05 02:13pm
By: fellon

Hi,
Im looking to setup multiple geeklog installs, but I want to bridge the user DB. Just the users, not the rest. Any pointers?

User table bridge

Posted on: 02/21/05 02:27pm
By: Dirk

See here[*1] . Still haven't heard back from anyone actually trying it out, though ...

bye, Dirk

User table bridge

Posted on: 02/21/05 02:58pm
By: fellon

Thanks for the fast reply, but after looking things over by myself I came up with the solution of changing some prefixs for the parts of the dbase I wanted to bridge. All good.

User table bridge

Posted on: 02/21/05 03:07pm
By: Dirk

[QUOTE BY= fellon] Thanks for the fast reply, but after looking things over by myself I came up with the solution of changing some prefixs for the parts of the dbase I wanted to bridge. All good.[/QUOTE]
Isn't that exactly what was discussed in the thread I pointed you to? Make sure to share all the user / group / permission related tables or you'll run into all sorts of weird problems.

bye, Dirk

User table bridge

Posted on: 02/21/05 03:31pm
By: fellon

I added.

config.php

$_DB_table_prefix_user = 'gl_';   // User prefix

lib-database.php

$_TABLES['access']              = $_DB_table_prefix_user . 'access'; // user prefix
$_TABLES['article_images']      = $_DB_table_prefix . 'article_images';
$_TABLES['blocks']              = $_DB_table_prefix . 'blocks';
$_TABLES['commentcodes']        = $_DB_table_prefix . 'commentcodes';
$_TABLES['commentmodes']        = $_DB_table_prefix . 'commentmodes';
$_TABLES['comments']            = $_DB_table_prefix . 'comments';
$_TABLES['cookiecodes']         = $_DB_table_prefix . 'cookiecodes';
$_TABLES['dateformats']         = $_DB_table_prefix . 'dateformats';
$_TABLES['events']              = $_DB_table_prefix . 'events';
$_TABLES['eventsubmission']     = $_DB_table_prefix . 'eventsubmission';
$_TABLES['featurecodes']        = $_DB_table_prefix . 'featurecodes';
$_TABLES['features']            = $_DB_table_prefix_user . 'features'; // user prefix
$_TABLES['frontpagecodes']      = $_DB_table_prefix . 'frontpagecodes';
$_TABLES['group_assignments']   = $_DB_table_prefix_user . 'group_assignments'; // user prefix
$_TABLES['groups']              = $_DB_table_prefix_user . 'groups'; // user prefix
$_TABLES['links']               = $_DB_table_prefix . 'links';
$_TABLES['linksubmission']      = $_DB_table_prefix . 'linksubmission';
$_TABLES['maillist']            = $_DB_table_prefix . 'maillist';
$_TABLES['personal_events']     = $_DB_table_prefix . 'personal_events';
$_TABLES['plugins']             = $_DB_table_prefix . 'plugins';
$_TABLES['pollanswers']         = $_DB_table_prefix . 'pollanswers';
$_TABLES['pollquestions']       = $_DB_table_prefix . 'pollquestions';
$_TABLES['pollvoters']          = $_DB_table_prefix . 'pollvoters';
$_TABLES['postmodes']           = $_DB_table_prefix . 'postmodes';
$_TABLES['sessions']            = $_DB_table_prefix . 'sessions';
$_TABLES['sortcodes']           = $_DB_table_prefix . 'sortcodes';
$_TABLES['speedlimit']          = $_DB_table_prefix . 'speedlimit';
$_TABLES['statuscodes']         = $_DB_table_prefix . 'statuscodes';
$_TABLES['stories']             = $_DB_table_prefix . 'stories';
$_TABLES['storysubmission']     = $_DB_table_prefix . 'storysubmission';
$_TABLES['syndication']         = $_DB_table_prefix . 'syndication';
$_TABLES['topics']              = $_DB_table_prefix . 'topics';
$_TABLES['tzcodes']             = $_DB_table_prefix . 'tzcodes';
$_TABLES['usercomment']         = $_DB_table_prefix_user . 'usercomment'; // user prefix
$_TABLES['userindex']           = $_DB_table_prefix_user . 'userindex'; // user prefix
$_TABLES['userinfo']            = $_DB_table_prefix_user . 'userinfo'; // user prefix
$_TABLES['userprefs']           = $_DB_table_prefix_user . 'userprefs'; // user prefix
$_TABLES['users']               = $_DB_table_prefix_user . 'users'; // user prefix
$_TABLES['vars']                = $_DB_table_prefix . 'vars';

User table bridge

Posted on: 02/21/05 03:49pm
By: fellon

Also added the new prefix to the sessions table to people to see each other across the different installs.

Would that cause a problem?

User table bridge

Posted on: 02/21/05 03:57pm
By: fellon

Apperently adding in the session call does create a bit of a problam as it pulls over some of the variables from the other install.

Re: User table bridge

Posted on: 12/18/07 11:03am
By: Anonymous (Tenshu)

Fellon, would you please fix your mud ?