The simpler media website CMS
/**************************
* CONFIG *
**************************/
$zen_location = "http://www.jacktummers.nl/collectie/"; /* Set this to the exact location of your zenphoto install. */
$zen_thumb_size = 70; /* Set this to the width you wish the thumbnails to be produced to */
/**************************
* END CONFIG *
**************************/
$zen_output = "";
$zen_images = $wpdb->get_results("SELECT zp_images.filename as zp_filename, zp_images.title as zp_title, zp_albums.folder as zp_folder FROM zp_images as zp_images, zp_albums as zp_albums WHERE zp_images.albumid = zp_albums.id AND zp_images.show = 1 ORDER BY zp_images.id DESC LIMIT 0, $max");
foreach ($zen_images as $zen_image){
}
echo $zen_output;
}`
Comments
Note that the code above does not cover any password protection or inheritat publish states. That can only be checked via the object model. Sadly due to WP's theme structure the Zenphoto as a plugin way does not work.
http://www.jacktummers.nl/blog