I had something similar...I had a program running with its own MySQL database and using PHP.
It wasn't until recently that I switch over to Xoops. So in order to incorporate the program, I created a module out of it.
I'm probably going to get blasted for this, but being a complete noob on creating XOOPS modules, I was able to poke around and find enough info to create the module. Plus I wanted to keep the php (well mostly) and the db separate so I didn't have to do much rework.
For each php file add:
<?php
include("../../mainfile.php");
include(XOOPS_ROOT_PATH."/header.php");
$xoopsOption['show_rblock'] = 1;
at the header and:
include(XOOPS_ROOT_PATH."/footer.php");
?>
at the footer.
Then create a xoops_version.php file that should contain something like the following:
<?php
$modversion['name'] = "Name of module here";//name of module
$modversion['version'] = 1.0;
$modversion['description'] = "Description";
$modversion['author'] = "author";
$modversion['credits'] = "";
$modversion['help'] = "";
$modversion['license'] = "GPL see LICENSE";
$modversion['official'] = 0;
$modversion['image'] = "images/logo.jpg";//this is the location of the module logo
$modversion['dirname'] = "dir";//name of directory on server
// Admin things
$modversion['hasAdmin'] = 0;
$modversion['adminpath'] = "";
// Menu/Sub Menu
$modversion['hasMain'] = 1;//make 0 to not have this appear in main menu
//$modversion['sub'][2]['name'] = _MI_MYPAGE_SMNAME2;
//$modversion['sub'][2]['url'] = "../../modules/weblog/";
?>
Then just upload it like any other module and activate it...
Hope I didn't make it more confusing...
You can see the 'Divsions' module at
Mobile Fantasy Football LeagueIt uses the php and MySQL I had before I switched to Xoops.
The site is still a work in progress (just switched to XOOPS a couple of weeks ago), I'm trying to get it ready for the 2005 season.
Beagle