Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 03:36 am EST
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/
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/
3
8
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
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
6
7
Quote
Status: offline
DTrumbower
Forum User
Moderator
Registered: 01/08/03
Posts: 507
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/
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/
7
5
Quote
All times are EST. The time is now 03:36 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