Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Re: [Andy] [Is this possible?] : Multiple Site/Directories using One Database

Quote Reply
Re: [Andy] [Is this possible?] : Multiple Site/Directories using One Database In reply to
Hey Andy & Niko,

--------------------------
IT WORKS.....
So far at least, will do further testing in few days on-site with a bigger database & will try to break the system, using site-visitor behavior.
--------------------------


I think just jumping into it & testing it out was much easier & actually less worrisome.. :)

Here are the steps:

1. Main Site: Existing install with sample db of 15 categories & 20 test links. (Link Properties & Category properties have lots of additionally added data-fields)

2. Second Site: On Second install, under:
Admin -> Setup -> SQL Server: I change the database info to that of Main site & selected 'Load table info from an existing set of tables (or resync the def files if you have changed your defs manually).'

Did 'Rebuild Tables' & 'Rebuild Search'. (I kinda did this after every step)

3. Under Database -> Category Properties -> 'Resync Database' & did this for Category, Links, User & Reviews.

4. Plugin -> Installed, Andy's ULTRAGlobals Plugin.

5. I THINK THIS WAS THE STEP THAT WAS BIGGEST CONCERN INITIALLY.
For Second site: Database -> Link Properties -> User Image Field -> Edit

File Save Location:
I HAD to change this, so I used the path of a folder on this domain. (As Andy guessed, GLinks gave me permission error when I used Main Site's path.)

File Save URL:
For this, I actually copied the URL for MAIN SITE. i.e. same value as in Main Site's User Image field.

& now I use Andy's global to call for image on Second Site (for links added in Main Install)

<%if Photo%>
<img src="<%Plugins::ULTRAGlobals::Get_Image_URL($ID,'Photo','Links')%>" />
<%endif%>

& it works :).. i.e image is being displayed..

--------------------------------------------------------

Before I can use this for the live site, I am still going to test this further - however that will be after 3 to 4 weeks, once the site is ready & I can follow steps for user-testing. Will post results on here, once it is done.

Note: I also noticed that if I were to try to modify any listing/category/user from Second Site's GLinks admin interface it would cause a problem with that listing, especially with the image field, but I suppose considering the settings in 'File Save Location:' it was expected.
--------------------------------------------------------

I really love GLinks more and more every day.. even after this many years, we have yet to use GLinks to even half its potential.


Thanks again you guys :)

Vishal
-------------------------------------------------------
Subject Author Views Date
Thread [Is this possible?] : Multiple Site/Directories using One Database VishalT 3624 Apr 2, 2021, 3:54 AM
Thread Re: [VishalT] [Is this possible?] : Multiple Site/Directories using One Database
el noe 3543 Apr 3, 2021, 4:10 AM
Post Re: [el noe] [Is this possible?] : Multiple Site/Directories using One Database
VishalT 3511 Apr 5, 2021, 4:36 AM
Thread Re: [VishalT] [Is this possible?] : Multiple Site/Directories using One Database
Andy 3549 Apr 4, 2021, 11:03 PM
Thread Re: [Andy] [Is this possible?] : Multiple Site/Directories using One Database
VishalT 3528 Apr 5, 2021, 4:41 AM
Thread Re: [VishalT] [Is this possible?] : Multiple Site/Directories using One Database
Andy 3525 Apr 5, 2021, 7:50 AM
Thread Re: [Andy] [Is this possible?] : Multiple Site/Directories using One Database
VishalT 3508 Apr 5, 2021, 3:47 PM
Thread Re: [VishalT] [Is this possible?] : Multiple Site/Directories using One Database
Andy 3503 Apr 5, 2021, 10:59 PM
Thread Re: [Andy] [Is this possible?] : Multiple Site/Directories using One Database
VishalT 3480 Apr 6, 2021, 1:54 PM
Thread Re: [VishalT] [Is this possible?] : Multiple Site/Directories using One Database
el noe 3470 Apr 6, 2021, 10:37 PM
Post Re: [el noe] [Is this possible?] : Multiple Site/Directories using One Database
VishalT 3441 Apr 7, 2021, 11:04 AM
Post Re: [Andy] [Is this possible?] : Multiple Site/Directories using One Database
VishalT 3439 Apr 7, 2021, 11:06 AM