Connecting Multiple Installations

[Brandin]

Hello,

Another big project of mine I am going to work on!

***YOU CAN SKIP TO MY NEXT STARS IF YOU DON'T WANT TO FULLY UNDERSTAND WHAT'S GOING ON AND TRY TO ANSWER THE QUESTION***

I have a few systems I have designed, all on different subdomains:

-templates.*.com
-search.*.com
-boss.*.com

BOSS is my UserSpice installation I have fully customized to be a tracking solution for our Call Centre. I have finally converted the majority of my scripts to PDO using the UserSpice system, but I am still working on it.

I am starting to redesign the templates.*.com site which is a page of email templates, with information pulled from the

Code:

categories

table to design the tabs, and the

Code:

templates

table to have the templates.

Since I am redesigning it (from ground up) I might as well do the PDO conversion now, rather than recode it, and do it later, and I find PDO to be very easy to us. However, I love the functions built into the UserSpice software, and would like to use that in the templates site too.

***SKIP TO HERE***
I am running into a problem including init and header on a different subdomain, since it is using the abs_root and other applicable things that is relying on the subdomain to be the same as BOSS, but it is not. So, I reverted to doing an extra installation of UserSpice, connected to the same database, but it didn't like this and screwed up the pages system, most likely because there was two page functions running in different domains.

I have since decided to scrap that idea, and have two separate installations of UserSpice, with two different databases, but then I run into this issue:
In BOSS, I have a system called "External Management", this is what I use to control the templates and categories, and I don't want to recode it. I have a Requests Management System, the whole nine yards, if templates and categories tables are going to be in a different database, how am I going to get UserSpice to talk to that one? And I will then have to make custom functions to talk to it, won't I?

Is there any easier solution to my problem that I just can't think of?

Thank you in advance!