Chaosratt:
This should allow you to host the display_open_tickets.php on another server.
edit display_open_tickets.php
on line 14 add the following:
# configure this area with your database connection information
$dbhost = 'localhost'; // FQDN server name or IP (or localhost for local machine)
$dbname = 'ostickets'; // database name
$dbuser = 'USERNAME'; // database username
$dbpass = 'PASSWORD'; // database password for username (above)
# make the connection to the MySQL server
mysql_connect($dbhost,$dbuser,$dbpass);
<USERMENTION username="mysql_select_db">@mysql_select_db</USERMENTION>($dbname) or die( "DB Error: Unable to select database");
Obviously you want to make sure that you customize dbhost, dbname, dbuser, dbpass to your scenario.
Oh and you can get rid of that warning by replacing line 28-29 with the following:
if($result=mysql_query($query)) {
$num = mysql_numrows($result);
}