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.
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.
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.
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.
Thanks so much Eric! One question though. The last part of your explanation reads the same in two sections. I think the second part should have a different "Find" and "Replace" shouldn't it?
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.
Ok, almost everything is working as it should. The login.php and userindex.php no longer work however for both sub folders. The way I have it set up now is I have one main install in the root folder and then two separate installs within two separate sub folders. They were each installed using the same database but with different Prefixes. The two sub folders are now set to the main class_users as per your instructions. I can log in to all 3 admin sections and see the users are shared throughout each which is perfect. I can set up separate categories, ad packages and template for each and the changes reflect accordingly. But when on either one of the sub folder sites the login.php link draws a blank page. If I manually navigate to userindex.php it too draws a blank. At first I thought I should just redirect the sub folders login.php to the main login.php but of course any ads created there will not reflect within the sub folder. How do I keep everything as is but add the functionality of both the login.php and userindex.php to each sub folder install?
Something sounds odd there. Is it possible to submit a ticket with your ftp details and I will check? Or activate the debug module on one of these and it should display some type of errors.
Sorry Eric, please disregard my last post. The issue was 100% my error and I got it all sorted now. Thanks once again for all your help, it now works exactly the way I want it to.
Could you post what the issue and resolution was, so that others that may try to do this can benefit from it? Thanks.
I am very interested in this. I have a total of 18 sites with 18 databases for 18 countries all linked together. I would like for users to be able to come and go from site to site w/o having to create new accounts. Would there be a way to do it? I use notepad++. have navicat for mySQL (just in case it helps). please let me know.
Thank you, I also want to create the possibilities for users from one site to pm users on the other site, So i replaced the " PREFIX " with the other table, But it still doesnt find the users (I changed them in the file includes/classes/kernel/private.php) Anyone has an idea where the private getts the user list from?