Welcome to Geeklog, Anonymous Sunday, September 01 2024 @ 01:43 am EDT
Geeklog Forums
User table bridge
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!
DAMN OVERPRICED PENGUINS!
4
3
Quote
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
4
5
Quote
Status: offline
fellon
Forum User
Newbie
Registered: 02/21/05
Posts: 5
Location:Chico, CA
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';
DAMN OVERPRICED PENGUINS!
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!
24
3
Quote
Tenshu
Anonymous
![angry angry](https://www.geeklog.net/forum/image_set/moods/angry.gif)
Fellon, would you please fix your mud ?
4
7
Quote
All times are EDT. The time is now 01:43 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