forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: olafbecker on June 26, 2006, 10:19:10 am

Title: albmgr.php changes so that the dropdown menu is sorted alphabetic
Post by: olafbecker on June 26, 2006, 10:19:10 am

This is the snip out of the albmgr.php what needs to be changed so that the data is sorted :


/**
 * alb_get_subcat_data()
 *
 * @param integer $parent
 * @param string $ident
 **/

// modified by Olaf Becker for beeing sorted alphabetic.
 
function alb_get_subcat_data($parent, $ident = '')
{
    global $CONFIG, $CAT_LIST;
 
    if ($CONFIG['categories_alpha_sort'] == 1) {
      $sort_query = 'name';
    } else {
      $sort_query = 'pos';
    }
 
    $result = cpg_db_query("SELECT cid, name, description " . " FROM {$CONFIG['TABLE_CATEGORIES']} " . " WHERE parent = '$parent' " . " AND CID != 1  ORDER BY $sort_query ");
 
    if (mysql_num_rows($result) > 0) {
        $rowset = cpg_db_fetch_rowset($result);
        foreach ($rowset as $subcat) {
            $CAT_LIST[] = array($subcat['cid'], $ident . $subcat['name']);
            alb_get_subcat_data($subcat['cid'], $ident . '   ');
        }
    }
}


If you needing any more or other help email me directly at obecker@teranet.de because i modify and reprogramm the hole modules right now to get out more performance and more features out of this product.

Olaf Becker