Share Users Across Multiple Subdomain Installs

[Kyan]

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.

[Eric Barnes]

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.

[Kyan]

Thank you Eric. That would be great.

[Kyan]

Hi Eric,

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

[Eric Barnes]

Sorry got busy and forgot about it. By the way what text edit application do you use?

[Kyan]

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.

[Eric Barnes]

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.

[Kyan]

Thanks so much Eric!

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

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?

[Eric Barnes]

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.

[Kyan]

Ah...I did not notice that.