Randon picture variable???

[typhooner]

Hello, I am trying to develop a new theme that will incorporate Flash.   I want the flash to be able to pick random pictures to display much in the same way that coppermine will display random images at the bottom of the page.  I need to know how exactly coppermine does this...What file in coppermine does this and what table in the database does coppermine look at.  I know how to do the flash end of it , its just he mysql part that I don't really know where to start.   I need the Flash to be able to select random thumnails and display them in the flash movie...

Any help would be appreciated...

Thanks
J

[Nibbler]

The random pic is grabbed with a simple query from the {prefix}_pictures table (include/functions.inc.php - search for 'order by rand()') There are already mods around that do this sort of thing, check the mods board.