Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 12:58 pm EDT

Geeklog Forums

4 sites sharing user database and forum


Status: offline

TechSys

Forum User
Regular Poster
Registered: 12/02/03
Posts: 90
O.k. let's see if I can get what I am wanting to do in words. I want my current website to be the main are of the complete setup. A user logs in and can go to each "other" site without having to relog in.
They log into tech-systems.vze.com, and do not have to relog in when going to beretta.tech-systems.vze.com, cavalier.tech-systems.vze.com, or corsica.tech-systems.vze.com. All three other sites will carry differant information so I can share the same database for articles and such.
I also want one forum to be shared throughout the whole setup.

Is this possible at all or am I just dreaming?
http://70.145.174.180/
 Quote

Status: offline

samstone

Forum User
Full Member
Registered: 09/29/02
Posts: 820
I haven't tried this, but can offer some idea.

First, all 4 sites have to use the same database.
Second, each site uses different prefix.
Third, open lib-database.php and add three lines under the following line:
$_TABLES['users'] = $_DB_table_prefix . 'users';
$_TABLES['users'] = 'x2_users';
$_TABLES['users'] = 'x3_users';
$_TABLES['users'] = 'x4_users';

replace x2, x3, x4 with the prefixes from other three sites.

You might also have to do the same thing with 'userinfo' 'userprefs'.

Another way is, instead of adding three lines, just change the original line of all sites to the main sites prefix, 'x1_users' (when x1 is the prefix of the mainsite.) This way might involve a need to change other files that has the phrase $_DB_table_prefix . 'users'.

Hope this will give you some clue. This will let you share user database, but will not let you automatically login. For that, you have to deal with cookies and I am not sure it is easy to make the all the sites share the same cookies.

As for sharing the forum, I was told by Blaine that it would need extensive code change. He might be able to do it for you for a fee.

Happy New Year!

Sam
 Quote

Status: offline

DTrumbower

Forum User
Moderator
Registered: 01/08/03
Posts: 507
Have you looked at the FAQ ?
 Quote

Status: offline

TechSys

Forum User
Regular Poster
Registered: 12/02/03
Posts: 90
yea, I looked at the faq, greek to me though. I think I have figured out how to do what I need, but not using GL for 3 parts of the site. I just need to figure out how to wrap it in GL.
What I am going to try to do is use the PHITE framework, wrapped in GL. I doubt I can do it, since I'm a php newbie, but I am going to give it a try.
http://70.145.174.180/
 Quote

All times are EDT. The time is now 12:58 pm.

  • 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