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
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.