Geeklog Forums

/*
  *
  * API function provides the content of our "What's New" feed.
  * This will return album names and the number of new media items in that album
*/
function plugin_getwhatsnew_inmemoriam(){
    global $INM_TABLES, $_CONF, $LANG_INM01, $INM_CONF;

    $sql = "SELECT aid, COUNT(*) as count FROM {$INM_TABLES['media']} WHERE date >= DATE_SUB(NOW(), INTERVAL {$INM_CONF['whatsnewperioddays']} DAY ) AND status='0'" . COM_getPermSQL('and') . " GROUP BY aid ORDER BY Date DESC LIMIT 15";
    $result = DB_query($sql);
    $nrows = DB_numRows($result);
    if( $nrows == 0 ) {
        $items = $LANG_INM01[35] . '' . LB;
    } else {
        $items = array();
        for( $i = 0; $i < $nrows; $i++ ) {
            list($id, $count) = DB_fetchArray( $result );
            if (inm_hasAlbumAccess($id) >= 2){
                $name = DB_getItem($INM_TABLES['albums'], 'name', $id);
                $str = "<a href=\"{$_CONF['site_url']}/inmemoriam/browse.php?id=$id\">";
                if(!empty($name)){
                    $str .= stripslashes(substr($name,0,$INM_CONF['whatsnewnamelength']));
                } else {
                    $str .= 'album #' . $id;
                }
                $str .= '</a> (' . $count . ')';
                $items[] = $str;
            }
        }
    }
    return $items;
}

 

                    $name = DB_getItem($INM_TABLES['albums'], 'name', "id='$id'");