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?
Main problem with having same joomla installation and creating multiple user groups is that, I want to have separate forums for each user group etc. So, If I use same installation, This could not be achieved.
Also please tell how to add custom fields to basic joomla user-fields like address, d.o.b etc into basic tables used by joomla……
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.