Joomla multisite, single set of files and DB tables

This project will require a creative approach.

We are selling multisites from Joomla.

Our subsites are not subdomains, but subdirectories (mod_rewrite).

So it is [url removed, login to view] to get to username's site.

Sites obfuscate the database from each other, but use the same set of files.

Right now we are selecting a set of DB tables by prefix. This is horrible because it creates hundreds of tables with just a few clients, and makes upgrading a nightmare.

We want to run this solution using only a single set of tables, but still allowing customization per site.

Not all, but most, tables need to have a site_id column added, and somehow all the queries against this table throughout the system need to add a WHERE or otherwise respect site_id.

(If you have an idea that requires all tables to be affected, this is fine, as long as it works as described.)

We are open to other ideas, as long as our end goal is met: we want to run a single set of files, single set of tables, but allow unique content between "sites".

Please say something about how you plan to approach this project, so that we know you understand the requirements. You can say this in private message if you do not wish to share such a valuable secret publicly. If you do not offer some indication as to how it will work, we will assume you have not understood this description.

I do look forward to forming a long term relationship with the party that can get this done, as it will be a display of professional level capabilities.

Tried JMS Multi Sites, this relies on symlinks and additional database tables.
Tried changing the SQL driver - Joomla doesn't seem to use its own SQL driver.

This can be done by changing all the queries to have WHERE or ON clauses. I have used this method to filter the categories table, and this works quite well. However, there are several hundred queries that would have to be changed. If you intend to go this route, you'd best be comfortable with SQL.

I am aware of the troubles a change like this can cause in the future (no upgrading, etc). I still need this done. Joomla 1.5 is the target.

Evner: Joomla, MySQL, PHP

Se mere: open table com, joomla multisite mod_rewrite, creative display, set, set of s, s+db, obfuscate, joomla customization, get files, db, table queries, database forming, joomla display, joomla term, per set, single php, single project, database php joomla, add private message system, prefix set, private content table database, multisite set, database project joomla, goal add message, column added table

Om arbejdsgiveren:
( 1 bedømmelse ) Tampa, United States

Projekt ID: #931084

4 freelancere byder i gennemsnit $206 på dette job


Please check PMB

$100 USD in 0 dage
(27 bedømmelser)

Hi, Please check the PM Thanks Ricky

$250 USD in 10 dage
(1 bedømmelse)

Hello. Please check the PMB.

$250 USD in 10 dage
(0 bedømmelser)

Please check PM...Thank you...

$225 USD in 6 dage
(0 bedømmelser)