How To Integrate Many Joomla Installations In One Site?
February 25, 2010 under FAQ
I want to make a website which has 5 different joomla installations on the same server. Each need to have all users in common but with different fields in table.
For example:
If I call the installations as joom1, joom2, joom3, joom4, and joom5, then users who register from any of these installations have say 10 fields in common like username, password, first name, last name etc. and a hidden numeric fiels whose value will be equal to either of 1, 2, 3, 4 or 5 to signify from which installation they signed up.
This numeric field will be used to assign them in groups say joom1 for 1, joom2 for 2 etc.
Also there will be content restriction on the site, i.e, joom1 users will have full access to contents at joom1 but can access only limited content on other installations.
Now members of joom1 need to have some other fields in the database like joom1_field1, joom1_field2 etc.
members of joom2 need to have some other fields in the database like joom2_field1, joom2_field2 etc.
and so on…….
But the main problem is I want to use only single database for this or maximum of two to maintain simplicity in cases when a query needs to be executed from joom5 installation based on users in joom1 installation etc.
The directory structure for joomla installations is as follows:
joom5 is installed at site’s root.
Then each of joom1 to joom4 are installed within joom5 directory, i.e, root/joom5 for joom5
root/joom5/joom1 for joom1
root/joom5/joom2 for joom2
etc.
What I am using is 1 database ‘users’ with separate table prefixes for each installation like joom1_, joom2_ etc
Then a separate table for each group to have ‘additional fields’ like user_joom1 for joom1 users to hold joom1field1 etc, user_joom2 for joom2 users to hold joom2field1 etc along with the username field.
Now my problem is I’m good in SQL etc but I’m new to joomla.
So I don’t know how to create custom user fields in joomla and how to link all installations in one database.
So, please tell me how to do it….
Can you post some sample php scripts to do this and also some tutorials where I can understand the way joomla make its database and query it using php and how it classifies the fields in the database so that I can modify joomla for my personal use.
Please help me, This is very important for me.
Are there any free components/plugins using which I can achieve my target?
Search more about How To Integrate Many Joomla Installations In One Site?:
It’s one of common problem with joomla users. Joomla is more on ready made template with ready made configuration on its own. Unless you can find all the necessary line of code in configuration.php.
Using single MySql database for multiple Joomla installation is impossible. Joomla has a pre-defined database name and its path configuration for eath joomla folder (ex. joom1, joom2). So, whenever you run each joomla site, it will look for its own database file saved on its own joomla directory.
Each time you access a database from different joomla environment even if it is saved in one folder, it will return errors because it may not be properly configured for that.
one possible solution is to clone a joomla folder, put them all in the www root directory, name it joom1, joom2 and so on.
so your directory tree would look like this:
www
->joom1
->joom2
->joom3
if you could find code of line in your configuration.php like this:
$mosConfig_absolute_path = ‘C:/wampp/www/joom1′;
and
$mosConfig_db = ‘joomla’;
the other configuration.php on joom2 and joom3 should be edited like that.
You can try this stand alone ApacheLite server. i think it can adopt to any joomla directory and use its default database
Get it here: http://myonline.voxnetours.com/downloadp…
It makes far more sense, rather than creating multiple Joomla installs, to create user groups that can see the content you would have otherwise broken off into different Web sites, and assign the relevant users to each group.
In other words, create user groups joom1, joom2, etc. Assign persons to those groups.
Then, whenever you create content, give the appropriate group permissions to that content.
The only limitation to groups is that it would be difficult to assign an administrator for each pseudosite; however, authors, editors and users are very easy to control.