The secure CMS.

Welcome to Geeklog, Anonymous Tuesday, April 30 2024 @ 08:24 am EDT

Geeklog Forums

User table bridge

 New Topic  Post Reply
 02/21/05 02:13pm (Read 2,624 times)  
Status: offline

fellon

Forum User
Newbie
Registered: 02/21/05
Posts: 5
Location:Chico, CA
Hi,
Im looking to setup multiple geeklog installs, but I want to bridge the user DB. Just the users, not the rest. Any pointers?
DAMN OVERPRICED PENGUINS!
 Quote
 02/21/05 02:27pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
See here. Still haven't heard back from anyone actually trying it out, though ...

bye, Dirk
 Quote
 02/21/05 02:58pm  
Status: offline

fellon

Forum User
Newbie
Registered: 02/21/05
Posts: 5
Location:Chico, CA
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.
DAMN OVERPRICED PENGUINS!
 Quote
 02/21/05 03:07pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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.

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
 Quote
 02/21/05 03:31pm  
Status: offline

fellon

Forum User
Newbie
Registered: 02/21/05
Posts: 5
Location:Chico, CA
I added.

config.php
Text Formatted Code

$_DB_table_prefix_user = 'gl_';   // User prefix

 


lib-database.php
Text Formatted Code

$_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';

 


DAMN OVERPRICED PENGUINS!
 Quote
 02/21/05 03:49pm  
Status: offline

fellon

Forum User
Newbie
Registered: 02/21/05
Posts: 5
Location:Chico, CA
Also added the new prefix to the sessions table to people to see each other across the different installs.

Would that cause a problem?
DAMN OVERPRICED PENGUINS!
 Quote
 02/21/05 03:57pm  
Status: offline

fellon

Forum User
Newbie
Registered: 02/21/05
Posts: 5
Location:Chico, CA
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.
DAMN OVERPRICED PENGUINS!
 Quote
 12/18/07 11:03am  

Tenshu

Anonymous
angry
Fellon, would you please fix your mud ?
 Quote
 New Topic  Post Reply
All times are EDT. The time is now 08:24 am.
  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content