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

Trick two GLinks Installations to use same category table

Quote Reply
Trick two GLinks Installations to use same category table
Hi there Smile

Is there a way to trick two GLinks applications into using the same physical category table.
For example, lets say I have a Videos and Photos installation, the prefixes for the tables would typically be
"video_" and "photo_".

Is there a way to trick the Photos installation into using "video_Category" as if it is "photo_Category"?

Thanks


Sacrifice is not about what you lose,
it is about what you gain in the process.
Quote Reply
Re: [EZFrag] Trick two GLinks Installations to use same category table In reply to
Found it!!!Laugh

First I drop the "photo_Category" table. Then I create a view called "photo_Category" from the "video_Category" table.
"photo_Category" automatically "updates"(It seems that views work from queries, and don't have a physical table
structure like normal tables) when video_Category is modified.

I tested it with two dummy installs, but what other side-effects is there, if any....?


Sacrifice is not about what you lose,
it is about what you gain in the process.