In my current theme, I use:

to check if there are images in this album. Is getNumAlbums the equivalent to see if the album has subalbums ? If not, is there an equivalent ?

It seems getNumbAlbums returns the total number of albums, without context.

getNumAlbums returns the number of TOPLEVEL albums, I don't know that there are an equivalent for counting the sub albums, is there ?

Check my theme edasque here, and I also have a recent post about counting subalbums.

I display on the main index a count of albums and subalbums total, then in each album (mouse over each album image) it will display a count of how many images in the root album + how many subalbums there are.

Is that close to what you were looking for? If so, I'd happy to post the code.

Yes the counting will be very useful. I'd love to get my hands on "Latest Images", "Latest Subalbums", "Most Popular", "Highest Rated" and rating features as well

Heh. Wondered when someone was going to ask.

The Latest Images and Subalbums are easy. The Most Popular and Highest Rated involve minor database changes, relating to hit counts and star rating systems, both of which have forum posts here. Still interested? The only reason I ask is that some people don't want to modify their DB. I'll have to package them up for you too, because it involves a few files, and then some DB changes, and then some CSS tweaking, and etc....

Here's the counting functions:

`/ SQL Counting Functions /

function show_subalbum_count() {

$sql = "SELECT COUNT(id) FROM ". prefix("albums") ." WHERE parentid  \"NULL\"";

$result = query($sql);

$count = mysql_result($result, 0);

echo $count;

}

function getIDforAlbum() {

if(!in_context(ZP_ALBUM)) return false;

global $_zp_current_album;

return $_zp_current_album->getAlbumID();

}

function show_sub_count_index() {

$id = getIDforAlbum();

$sql = "SELECT COUNT(*) FROM ". prefix("albums") ." WHERE parentid = $id";

$result = query($sql);

$count = mysql_result($result, 0);

echo $count;

}`

Now mind, the latest albums/subalbums and the latest images were not developed by me but by this nice gentleman here, and I tweaked them a bit. But these are the functions. Don't forget the Most Popular and Highest Rated require additional work, so don't call them unless you have the changes in place mentioned above, but basically they are just versions of the latest images.

`/ Show Latest Albums /

/ http://anton.gektoras.lt/zenphoto/zenphoto-latest-albums /

  function show_latest_album($number) {

      $sql = "SELECT * FROM ". prefix("albums") ." ORDER BY id DESC LIMIT $number";

      $result = mysql_query($sql);

      while($r = mysql_fetch_array($result)) {

          if ($r['thumb']==NULL) {

              $image = get_album_image($r['id']);

          } else {

              $image = $r['thumb'];

          }

          echo '[*]';

          if (zp_conf('mod_rewrite') == false) {

              echo '.']';

              echo '[img]'.WEBPATH.'/zen/i.php?a='.$r['folder'].'&i='.$image.'&s=thumb[/img]';

              // echo '.']'.$r['title'].'';

          } else {

              echo '.']';

              echo '[img]'.WEBPATH.'/'.$r['folder'].'/image/thumb/'.$image.'[/img]';

              // echo '.']'.$r['title'].'';

        }

         echo ''; 

      }

  }

  function get_album_image($id) {

      $sql = "SELECT * FROM ". prefix("images") ." WHERE albumid = $id";

      $result = mysql_query($sql);

      while($r = mysql_fetch_array($result)) {

          return $r['filename'];

      }

  }`

`/ Show Latest Images /

/ http://anton.gektoras.lt/zenphoto/zenphoto-latest-images /

  function show_latest_images($number) {

      $images = query_full_array("SELECT images.albumid, images.filename AS filename, images.title AS title, albums.folder AS folder FROM ".prefix('images')." AS images, ".prefix('albums')." AS albums WHERE images.albumid = albums.id AND images.show = 1 ORDER BY images.id DESC LIMIT $number");

      $size = '_'.zp_conf('thumb_size').'_cw'.zp_conf('thumb_crop_width').'_ch'.zp_conf('thumb_crop_height');

      foreach ($images as $image) {

          $filename = $image['filename'];

          $album = $image['folder'];

          $desc = $image['title'];

            echo '[*]';

              if (zp_conf('mod_rewrite') == false) {

                  echo '';

              } else {

                  echo '';

              }

                        /* echo '[img]'.WEBPATH.'/cache/'.$album.'/'.$filename.$size.'.jpg[/img]'; */

          echo '[img]'.WEBPATH.'/zen/i.php?a='.$album.'&i='.$filename.'&s=thumb[/img]';

          echo '';

      }

 }

/ Show Most Popular Images /

/ Modified from show_latest_images from http://anton.gektoras.lt/zenphoto/zenphoto-latest-images /

  function show_most_popular($number) {

      $images = query_full_array("SELECT images.albumid, images.filename AS filename, images.title AS title, images.hit AS hit, albums.folder AS folder FROM ".prefix('images')." AS images, ".prefix('albums')." AS albums WHERE images.albumid = albums.id AND images.show = 1 ORDER BY images.hit DESC LIMIT $number");

      $size = '_'.zp_conf('thumb_size').'_cw'.zp_conf('thumb_crop_width').'_ch'.zp_conf('thumb_crop_height');

      foreach ($images as $image) {

          $filename = $image['filename'];

          $album = $image['folder'];

          $desc = $image['title'];

          $hit = $image['hit'];

            echo '[*]';

              if (zp_conf('mod_rewrite') == false) {

                  echo '';

              } else {

                  echo '';

              }

          echo '[img]'.WEBPATH.'/zen/i.php?a='.$album.'&i='.$filename.'&s=thumb[/img]'; 

          echo '';

      }

 }

/ Show Highest Rated Images /

/ Modified from show_latest_images from http://anton.gektoras.lt/zenphoto/zenphoto-latest-images /

  function show_highest_rated($number) {

      $images = query_full_array("SELECT images.albumid, images.filename AS filename, images.title AS title, images.total_value AS totalvalue, images.total_votes as votes, albums.folder AS folder FROM ".prefix('images')." AS images, ".prefix('albums')." AS albums WHERE images.albumid = albums.id AND images.show = 1 ORDER BY (images.total_value/images.total_votes) DESC LIMIT $number");

      $size = '_'.zp_conf('thumb_size').'_cw'.zp_conf('thumb_crop_width').'_ch'.zp_conf('thumb_crop_height');

      foreach ($images as $image) {

          $filename = $image['filename'];

          $album = $image['folder'];

          $desc = $image['title'];

          $totalvalue = @number_format($image['totalvalue']/$image['votes'],2); 

            echo '[*]';

              if (zp_conf('mod_rewrite') == false) {

                  echo '';

              } else {

                  echo '';

              }

          echo '[img]'.WEBPATH.'/zen/i.php?a='.$album.'&i='.$filename.'&s=thumb[/img]';

          echo '';

      }

 }`

Just FYI, you can technically include this code with your themes without modifying Zenphoto. You just need to have a line like:

include(__FILE__ . "/customfunctions.php")

at the top of your theme pages where you use the functions. That way we don't get into modifying zenphoto's actual code.

I could even come up with a convention, and always include a 'hacks.php' if it's present in the theme, or any name you guys want... It would be nice before we have a plugin system I think.

yes, that's what I am doing. I run a modified version of Effervescence which contains a customfunctions.php I append to.

Excellent :-) Just making sure.

Since I'm using a modified Joshuaink, I use the joshuaink.php to hold all my custom functions, so it's basically what you suggested. A wise course of action, that way your not editing all your base files.

A hacks.php file would be a great thing to include in the base files, so that you can just store your stuff in that file in your theme.

This makes it a lot quicker and cleaner when doing upgrades too.

Can't wait for plugins, then I can get the custom code out of the i.php file, and then none of my mods affect any of the zen core files.

The only other thing to note is about custom DB changes. How would that work? e.g. the rating system and hit count require DB changes, so you'd have to come up with some sort of plugin modification system like Wordpress has to make changes to the DB, which I guess could be done during plugin load (does that make sense?)

Absolutely, new database columns could be made during plugin initialization.