I am considering using XOOPS for a cricket club. Most of the functionality I need is in place.

There is a substantial database in MySQL that currently records the match scores, reports, and various statistics, so I am looking for ways to use this data in XOOPS pages.

Has anyone tried to do this and are there any examples?

For example a match report comprises scores, some text report and photos. The scores are extracted from the database.

In another example sql is used to extract lists of best batting or bowling and presented in the page.

Could this kind of presentation be created using mods, or is there an alternate method?

Of course I am also looking to provide a method of data input, and I guess, from looking at the current XOOPS structures, that this might best be achieved using a separate web interface.

This website shows a couple of examples:
http://www.energyexiles.org.uk/matchreports/season_current.php?srch=bowling
and
http://www.energyexiles.org.uk/matchreports/match_summary.php?srch=400225

Ideas appreciated
TIA
Mike B