Forums / Developer / Subsites with one Database

Subsites with one Database

Author Message

SathishKumar Subramanian

Monday 20 October 2003 4:01:24 am

How can I create different subsites with different structures and they should use the same database? These subsites are avail below the root site. How can I achieve sharing articles between the sites? Help me to get the solution for this.

Eirik Alfstad Johansen

Monday 20 October 2003 4:10:12 am

Hi,

What do you mean when you say "different structure"?

Sincerely,

Eirik Johansen
Netmaking AS

http://www.netmaking.no/

Sincerely,

Eirik Alfstad Johansen
http://www.netmaking.no/

SathishKumar Subramanian

Monday 20 October 2003 9:11:50 am

Hi Eirik,

In subsites "Different Strunctures" are different Site-Designs. Each subsite should have its own website design. But they should refer the common database which is used by the root site or main site.

thx in advance. :)

Sathish

Eirik Alfstad Johansen

Tuesday 21 October 2003 12:23:01 am

Hi Sathish,

Put the following in the site.ini.append file of each of the siteaccesses you want a specific design for.

[DesignSettings]
SiteDesign=desired_design

Good luck !

Sincerely,

Eirik Johansen
Netmaking AS

http://www.netmaking.no/

Sincerely,

Eirik Alfstad Johansen
http://www.netmaking.no/

SathishKumar Subramanian

Tuesday 21 October 2003 2:11:13 am

Hi,
Thanx Eirik, But still I need some other details for subsites like,
how can I create different subsites and they should use the same database?
These subsites should be avail below the root site.
Also how can I achieve sharing articles between the sites?

Sathish.

Eirik Alfstad Johansen

Tuesday 21 October 2003 6:05:53 am

Hi again,

If you specify the separate design for each site like in my example and nothing else, the sites should fetch data from the same database by default. Also, I'm not sure if I know what you mean by the subsites being below the root site. What do you consider to be a root site?

- Eirik

Sincerely,

Eirik Alfstad Johansen
http://www.netmaking.no/

Balazs Halasy

Tuesday 21 October 2003 7:49:59 am

I believe you want something like this:

mit.university.com
berkeley.university.com
stanford.university.com
yale.university.com
...etc..

..where you have 4 sites (don't mind the hostnames, they do not have to be subdomains - this is just an example) and each site has a different look. In other words, each site has its own custom _design_. However, each and every site uses the exact same database to display the same information. Right? If so: this can easily be achieved using the _site access subsystem_ that is a part of eZ publish. What you do is this (simplified explanation):

1. Make a site that uses a database.

2. Create several _site accesses_ that trigger on different URLs and thus use different _designs_.

3. Make sure that each and every site access that you create uses the same database.

Check out the site access doc. page: http://ez.no/developer/ez_publish_3/documentation/configuration/configuration/site_access

Balazs

SathishKumar Subramanian

Wednesday 22 October 2003 4:33:43 am

Hi Guys,

Thanx a lot. Its working fine now with my actual requirement. I have implemented the way you have given.

Sathish

 

eZ debug

Timing: Jan 31 2025 03:49:13
Script start
Timing: Jan 31 2025 03:49:13
Module start 'content'
Timing: Jan 31 2025 03:49:13
Module end 'content'
Timing: Jan 31 2025 03:49:13
Script end

Main resources:

Total runtime0.1716 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0067 593.5625180.8359
Module start 'content' 0.00670.0056 774.3984101.8672
Module end 'content' 0.01230.1592 876.2656529.8984
Script end 0.1716  1,406.1641 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00321.8633200.0002
Check MTime0.00130.7586200.0001
Mysql Total
Database connection0.00070.431010.0007
Mysqli_queries0.127974.53641410.0009
Looping result0.00120.69911390.0000
Template Total0.158992.610.1589
Template load0.00070.435210.0007
Template processing0.158292.149310.1582
Override
Cache load0.00050.293710.0005
Sytem overhead
Fetch class attribute can translate value0.00090.500510.0009
XML
Image XML parsing0.00030.160710.0003
General
dbfile0.00734.2287200.0004
String conversion0.00000.002930.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0002 secs