Conversion from a standalone web application in php4 for orders visualization to a xoops 2.0 module in php5. Authentication is provided by xoops, the standalone authentication must be abandoned, if the user is registered the module is accessible. The database of orders is separated from xoops db, but an php5 object for connection is provided, it extends Zend_DB from Zend Framework. The orders application is composed by 6 pages, best practise is to convert pages in Zend Controller method and build an underlying object to perform all db operations. Xoops uses smarty for templates.
Attached you will find an example table -ordini - with related status table -status - and an example page.
More info may be provided if asked.