Geeklog Forums

<?php

// PHP for MediaGallery to return albums to include in Archive.
// This creates a simple list of albums to include.

// +---------------------------------------------------------------------------+
// | MediaGallery                                                              |
// +---------------------------------------------------------------------------+

/**
* Returns the plugin name
*/

function archive_mediagallery_name()
{
    global $LANG_MG00;
    return $LANG_MG00['menulabel'];
}

/**
* Returns a list of all MediaGallery albums
*/

function archive_make_mediagallery_list()
{
    global $_CONF, $_TABLES, $LANG_AR;
    $retval = '<select name="relatedid">';
    // Get staticpage title from DB
    $perms = COM_getPermSql();
    $result = DB_query ("SELECT album_id,album_title FROM ".$_TABLES['mg_albums'] . " " .$perms);
    $nrows  = DB_numRows ($result);
    if ($nrows > 0) {
        for ($i = 1; $i <= $nrows; $i++) {
            $A = DB_fetchArray ($result);
            $retval .= '<option value="'.$A['album_id'].'">'.$A['album_title'].'</option>';
        }
    }
    $retval .= "</select>";
    return $retval;
}

/**
* Returns array of title and link to a MediaGallery given id
*/

function archive_mediagallery_item ($id)
{
    global $_CONF, $_TABLES, $LANG_AR;
    $retval = '';
    // Get staticpage title from DB
    $perms = COM_getPermSql('AND');
    $result = DB_query ("SELECT album_title FROM {$_TABLES['mg_albums']} WHERE (album_id='{$id}') ". $perms);
    $nrows  = DB_numRows ($result);
    if ($nrows > 0) {
        $A = DB_fetchArray ($result);
        $retval['title'] = $A['album_title'];
        $link = $_CONF['site_url'] . "/mediagallery/album.php?aid=".$id;
        $retval['link'] = $link;
    } else {
        $retval['title'] = "No such item";
        $retval['link'] = "";
    }
   return $retval;
}

?>