/**
 * Adds albums to the menu set. Returns the next sort order base
 * @param string $menuset current menu set
 * @param string $base starting "sort order"
 * @return int
 */
function addalbumsToDatabase($menuset, $base = NULL)
{
    global $_zp_gallery;
    if (is_null($base)) {
        $albumbase = db_count('menu', 'WHERE menuset=' . db_quote($menuset));
        $sortbase = '';
    } else {
        $albumbase = array_pop($base);
        $sortbase = '';
        for ($i = 0; $i < count($base); $i++) {
            $sortbase .= sprintf('%03u', $base[$i]) . '-';
        }
    }
    $result = $albumbase;
    $albums = $_zp_gallery->getAlbums();
    foreach ($albums as $key => $link) {
        addSubalbumMenus($menuset, 'NULL', $link, $sortbase . sprintf('%03u', $result = $key + $albumbase));
    }
    return $result;
}
/**
 * Adds albums to the menu set. Returns the next sort order base
 * @param string $menuset current menu set
 * @param string $base starting "sort order"
 * @return int
 */
function addalbumsToDatabase($menuset, $base = NULL)
{
    if (is_null($base)) {
        $sql = "SELECT COUNT(id) FROM " . prefix('menu') . ' WHERE menuset=' . db_quote($menuset);
        $result = query($sql);
        $albumbase = db_result($result, 0);
        $sortbase = '';
    } else {
        $albumbase = array_pop($base);
        $sortbase = '';
        for ($i = 0; $i < count($base); $i++) {
            $sortbase .= sprintf('%03u', $base[$i]) . '-';
        }
    }
    $result = $albumbase;
    $gallery = new Gallery();
    $albums = $gallery->getAlbums();
    foreach ($albums as $key => $link) {
        addSubalbumMenus($menuset, $gallery, 0, $link, $sortbase . sprintf('%03u', $result = $key + $albumbase));
    }
    return $result;
}