My experience is around Mambo, so what I'm about to say might not be completely true for Joomla. Firstly, you _could_ prefix each set of tables for each website with a different prefix, to keep the users from seeing each other. That would give you a real headache trying to stop them accessing each others tables directly through SQL, so you really need to create a new database per instance of Joomla. To create the instance, you will need some kind of frontend PHP admin utility. I've never come across any free software that does this, so you'll probably have to write your own code. You'll need to create a template version of the Joomla site, then have the PHP code copy this template to a new directory, create the new SQL database, and then copy the template SQL data. Remember to set the database permissions to only allow the superadmin and the new user. This is a simplified description, but should give you a starting point. Rob. -----Original Message----- From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of gangadhara prasad Sent: 24 June 2007 04:49 To: hyd-phpug; php-objects Subject: Joomla Multiplesites Hi, I have a website in joomla to which i am a super admin. If new user registered to a site he must get his own website. He will become admin to his website.He need to have his own template,content,components,modules and etc. Super admin has all the rights. If super admin allow admin1 to all components he can have access on them. so admin1 has right whether to display all the components to its website users or not.just like admin1 there will be several admins for several sites. So that if there are 10 admins 10 websites will be there which have different content,users,templates and graphs. There will be no sharing of data between admins and its users. super admin can access all the admins and users. So is there any component to achieve the above said functionalities ? shall i have different databases or a single database is sufficient. please give me a clear picture how can we achieve this. Thanks, Gangadhar. --------------------------------- Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. [Non-text portions of this message have been removed] PHP Data object relational mapping generator http://www.metastorage.net/ Yahoo! Groups Links *********************************************************************************** Any opinions expressed in email are those of the individual and not necessarily those of the company. This email and any files transmitted with it are confidential and solely for the use of the intended recipient or entity to who they are addressed. It may contain material protected by attorney-client privilege. If you are not the intended recipient, or a person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited. Random House Group + 44 (0) 20 7840 8400 http://www.randomhouse.co.uk http://www.booksattransworld.co.uk http://www.kidsatrandomhouse.co.uk Generic email address - enquiries@xxxxxxxxxxxxxxxxx Name & Registered Office: THE RANDOM HOUSE GROUP LIMITED 20 VAUXHALL BRIDGE ROAD LONDON SW1V 2SA Random House Group Ltd is registered in the United Kingdom with company No. 00954009, VAT number 102838980 ***********************************************************************************
