Support Forums

Share Users Across Multiple Subdomain Installs

This is a discussion on Share Users Across Multiple Subdomain Installs within the Customizations forums, part of the Developer Forums category; Hello, I've seen similar posts regarding this topic but I found the explanations to be incomplete, or at least difficult ...


Go Back   68 Classifieds Forums > Developer Forums > Customizations

Reply
 
Thread Tools Display Modes
Old 03-23-2009, 01:00 PM   #1
Junior Member
 
Join Date: Mar 2009
Posts: 25
Rep Power: 10
Kyan is on a distinguished road
Default Share Users Across Multiple Subdomain Installs

Hello,

I've seen similar posts regarding this topic but I found the explanations to be incomplete, or at least difficult to understand and so my efforts have produced zero results.

I have 3 installs under the same domain. Each install uses different categories, extra fields and templates. I would like for a customer to be able to register on 1 install and be able to log into all 3. They do not need to remain logged in from one site to the other, just be able to login without having to register 3 separate times. I don't know which would be better, to have all 3 installs share the same database and then change the template and hide the categories for each install or if it would be better to have 3 databases that pull from the user tables of one database.

I'm hoping someone might be able to advise me on which option would be more suitable and offer up an explanation of how to set this up in as detailed/dumbed down a way as possible.
__________________
Thanks,

v4.2.1 - Developer
Kyan is offline   Reply With Quote
Old 03-23-2009, 01:29 PM   #2
68 Classifieds Staff
 
Eric Barnes's Avatar
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,489
Rep Power: 134
Eric Barnes is just really nice Eric Barnes is just really nice
Default

I would think it would be better to have three installs and just share the users table. If I get some spare time I will see if I can put together a tutorial.
__________________
Eric Barnes
68 Classifieds Developer
Customer Area | Issue Tracker | Documentation | 68C Mods | 68 @ Twitter | My Modules
Eric Barnes is offline   Reply With Quote
Old 03-23-2009, 03:19 PM   #3
Junior Member
 
Join Date: Mar 2009
Posts: 25
Rep Power: 10
Kyan is on a distinguished road
Default

Thank you Eric. That would be great.
__________________
Thanks,

v4.2.1 - Developer
Kyan is offline   Reply With Quote
Old 03-31-2009, 07:32 AM   #4
Junior Member
 
Join Date: Mar 2009
Posts: 25
Rep Power: 10
Kyan is on a distinguished road
Default

Hi Eric,

Don't mean to be a pest, just don't want this offer to disappear.
__________________
Thanks,

v4.2.1 - Developer
Kyan is offline   Reply With Quote
Old 03-31-2009, 03:56 PM   #5
68 Classifieds Staff
 
Eric Barnes's Avatar
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,489
Rep Power: 134
Eric Barnes is just really nice Eric Barnes is just really nice
Default

Sorry got busy and forgot about it. By the way what text edit application do you use?
__________________
Eric Barnes
68 Classifieds Developer
Customer Area | Issue Tracker | Documentation | 68C Mods | 68 @ Twitter | My Modules
Eric Barnes is offline   Reply With Quote
Old 03-31-2009, 05:50 PM   #6
Junior Member
 
Join Date: Mar 2009
Posts: 25
Rep Power: 10
Kyan is on a distinguished road
Default

Text edit? If you mean for web editing I use Dreamweaver 8. If it's just plain text editing you're asking about I use Mac's TextEdit and Word.
__________________
Thanks,

v4.2.1 - Developer
Kyan is offline   Reply With Quote
Old 03-31-2009, 10:05 PM   #7
68 Classifieds Staff
 
Eric Barnes's Avatar
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,489
Rep Power: 134
Eric Barnes is just really nice Eric Barnes is just really nice
Default

Here is how to do it in Dreamweaver.

1. First install the classifieds twice using the same database with two different table prefixes. You will need to remember these and one will be used in step 3.

2. Next on your local computer create a copy of the 68 Classifieds files. Then create a new local site in Dreamweaver pointing to this copy.

3. Now open the Find and Replace window.

Fill in these settings:
Find In: "Entire local site"
Search: "text"
Find: '.PREFIX.'users
Replace: class_users - This is the prefix from step 1. The name of the global users table.

Next follow step 3 above and:
Find: '. PREFIX .'users
Replace: class_users - This is the prefix from step 1. The name of the global users table.

That should be it. Just upload this new set of files to your second folder and then the users table will be shared.
__________________
Eric Barnes
68 Classifieds Developer
Customer Area | Issue Tracker | Documentation | 68C Mods | 68 @ Twitter | My Modules
Eric Barnes is offline   Reply With Quote
Old 04-01-2009, 03:12 PM   #8
Junior Member
 
Join Date: Mar 2009
Posts: 25
Rep Power: 10
Kyan is on a distinguished road
Default

Thanks so much Eric!

One question though. The last part of your explanation reads the same in two sections.

Quote:
Find: '.PREFIX.'users
Replace: class_users - This is the prefix from step 1. The name of the global users table.

Next follow step 3 above and:
Find: '. PREFIX .'users
Replace: class_users - This is the prefix from step 1. The name of the global users table.
I think the second part should have a different "Find" and "Replace" shouldn't it?
__________________
Thanks,

v4.2.1 - Developer
Kyan is offline   Reply With Quote
Old 04-01-2009, 03:14 PM   #9
68 Classifieds Staff
 
Eric Barnes's Avatar
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,489
Rep Power: 134
Eric Barnes is just really nice Eric Barnes is just really nice
Default

Yes but the the prefix portion is different:

In some files it is '.PREFIX.' and others '. PREFIX .'

Notice the spaces after and before the period in the second one.
__________________
Eric Barnes
68 Classifieds Developer
Customer Area | Issue Tracker | Documentation | 68C Mods | 68 @ Twitter | My Modules
Eric Barnes is offline   Reply With Quote
Old 04-01-2009, 03:26 PM   #10
Junior Member
 
Join Date: Mar 2009
Posts: 25
Rep Power: 10
Kyan is on a distinguished road
Default

Ah...I did not notice that.
__________________
Thanks,

v4.2.1 - Developer
Kyan is offline   Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
V4 beta on subdomain midi510 Technical Support 1 04-06-2007 07:25 PM


All times are GMT -4. The time now is 12:32 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2011, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0