Results 1 to 9 of 9

Thread: Running multiple domains from 1 database

  1. #1
    Join Date
    Nov 2004
    Posts
    36

    Default Running multiple domains from 1 database

    What would be the best way to go about running multiple sites from 1 indexu database. For example lets say your directory contains categories like xbox, playstation, xbox360, etc and you wanna make a site that is focused only on xbox , how could I turn that particular category of content into another site just using a different template

  2. #2
    Join Date
    Jul 2002
    Location
    California
    Posts
    57

    Default

    When you find out if it's possiable be sure to first purchase multiple licenses.

  3. #3
    Join Date
    Aug 2002
    Location
    Germany
    Posts
    1,180

    Default

    Not needed...
    Frank

  4. #4
    Join Date
    Apr 2003
    Location
    Atlanta GA
    Posts
    3,395

    Default

    with a single database, the only way I could think to do it would be to have a field in the appropriate tables ( idx_link, idx_category, etc ) so that you could modify the SQL query to add a WHERE clause using that field.

    No small task.



    .
    esm
    "The older I get, the more I admire competence, just simple competence, in any field from adultery to zoology."

    .

  5. #5
    Join Date
    Aug 2002
    Location
    Germany
    Posts
    1,180

    Default

    If you want to use a single database you can do several installatiuons all with the same database, but if you want to show only some categories here and others there I don't understand the need for one database ?
    If you want this you have to cut all functions with global functions like index, hot, new and so on or you must change the sql request of each to a new defintion field you can set in each installation.
    Search may be easier because you can modify the drop down to your needings.

    If you ask me, forget the idea and do more installations...

    Frank

  6. #6
    Join Date
    Nov 2004
    Posts
    36

    Default

    Esm

    I had thought about making a sites table and then having a field in the link and category table that determined which sites the link or cat would show on.

    Main thing I wanna do is take a category and only have that category and its data appear on the domain

  7. #7
    Join Date
    Jul 2005
    Posts
    87

    Default

    on the 2nd install don't make any change to the database as this will effect your 1st install. Maunaly insert the category and links associated with it into index.html and delete the php tags that would call the other cats.

  8. #8
    Join Date
    Nov 2004
    Posts
    36

    Default

    Well what I did was make a field in the links table to determine which sites the link shows on and a table called sites to store the details on all the sites I setup. I went ahead and split the link table up as well so instead of 1 table storing links it stores them in different tables based on category so I dont endup with 50,000 links in idx_link slowing my site down. I added all the configuration in application.php such as site id etc and now all I have to do is upload the main .php files to each site and it all works perfect. Everything I need to edit a site is in a theme folder all on 1 install so very little work to maintain as many sites as i want

  9. #9
    Join Date
    Jul 2005
    Posts
    87

    Default

    Quote Originally Posted by player77
    Well what I did was make a field in the links table to determine which sites the link shows on and a table called sites to store the details on all the sites I setup. I went ahead and split the link table up as well so instead of 1 table storing links it stores them in different tables based on category so I dont endup with 50,000 links in idx_link slowing my site down. I added all the configuration in application.php such as site id etc and now all I have to do is upload the main .php files to each site and it all works perfect. Everything I need to edit a site is in a theme folder all on 1 install so very little work to maintain as many sites as i want


    cool! Sounds like a good way to do it!

Similar Threads

  1. Database access problem
    By motoman in forum v5.x
    Replies: 2
    Last Post: 04-05-2005, 12:40 PM
  2. yet another unable to select a database
    By lindrix in forum v5.x
    Replies: 6
    Last Post: 03-21-2005, 01:06 PM
  3. Running indexu 3.1 under Apache/MacOSX
    By Mackey in forum v5.x
    Replies: 8
    Last Post: 08-05-2004, 10:25 AM
  4. Unable to select database
    By derekaross in forum v5.x
    Replies: 1
    Last Post: 04-28-2004, 07:22 PM
  5. Replies: 8
    Last Post: 06-05-2002, 10:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •