I have played with the "latest events" modules trying to get it to pull remote calendar information from another account/db on the same hosted server. I can't seem to get the module to query the other DB.. <!-- s:cry: --><img src="{SMILIES_PATH}/icon_cry.gif" alt=":cry:" title="Crying or Very Sad" /><!-- s:cry: -->

I have a client with multiple sites (church) and they all have the JEvents component installed. I'm trying to hack a module to pull the latest events from each DB on the same cPanel server.

Here's what i have done: Anywhere there is a SELECT statement, I inserted the following code.

			$host = 'localhost';

			$user = 'xxxxx';

			$password = 'xxxxx';

			$dbase = 'xxxxx';

			$dbprefix = 'jos_';

			$db = new database( $host, $user, $password, $dbase, $dbprefix );

This should create a new database instance. Any ideas on how this could be accomplished?

I thought the above code might work but I must be missing something.

Regards,
Eric