Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: albmgr.php new feature : jump down into the subcategories and back  (Read 2461 times)

0 Members and 1 Guest are viewing this topic.

olafbecker

  • Coppermine newbie
  • Offline Offline
  • Posts: 2

Everything which is bold marked is modified now so that it is more userfriendly than befor.You did not get overloaded anymore with unused data.
this modification release your database selects and request.
Now it is much easier to administrate the album because I have already more than 5000 categories in my database and it grows fast.
www.aviationphotos.info is the place where I use under photos this Database of Coppermine in the 1.4.2 stable Version.
With the field *No category* you can jump back to the top level. And it refresh automaticly so that you can jump into subcategories and back to the top.
So feel free to use this modifications now.

Olaf Becker

if you need any help sent me an email to : obecker@teranet.de

I am still working on it and try


here is the snipout of the albmgr.php which needs to be modified so that you can use this new function.

<?php
/*************************
  Coppermine Photo Gallery
  ************************
  Copyright (c) 2003-2005 Coppermine Dev Team
  v1.1 originaly written by Gregory DEMAR
 
  This program is free software; you can redistribute it and/or modify
  it under the terms of the GNU General Public License as published by
  the Free Software Foundation; either version 2 of the License, or
  (at your option) any later version.
  ********************************************
  Coppermine version: 1.4.2
  $Source: /cvsroot/coppermine/devel/albmgr.php,v $
  $Revision: 1.18 $
  $Author: gaugau $
  $Date: 2005/10/25 01:15:41 $
**********************************************/
 
.
.
.
...

// modified by Olaf Becker for beeing sorted alphabetic.
// added description and description02 to the printout as well.  The description02 was added manualy into the SQL structure.
// so be carefull with SQL Database modifications !!


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, description02 " . " 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) {
            $spacer01 = '';
            $spacer02 = '';
            if ($subcat['description'] != ''){
              $spacer01 = " - ";
            }
            if ($subcat['description02'] != ''){
              $spacer02 = " - ";
            }
               
            $CAT_LIST[] = array($subcat['cid'], $ident . '&nbsp;&nbsp;&nbsp;' . $subcat['name'] . $spacer01 . $subcat['description'] . $spacer02  . $subcat['description02'] );

// is not needed anymore (removed by Olaf Becker) because you can brows now into the subcategories
//            alb_get_subcat_data($subcat['cid'], $ident . '&nbsp;&nbsp;&nbsp;');

        }
    }
}

.
.
.
.
......

?>
        <form name="album_menu" method="post" action="delete.php?what=albmgr" onSubmit="return CheckAlbumForm(this);">
        <input type="hidden" name="delete_album" value="" />
        <input type="hidden" name="sort_order" value="<?php echo $sort_order ?>" />
        <td class="tableb" valign="top" align="center">
                <br />
                <table width="300" border="0" cellspacing="0" cellpadding="0">
<?php
if (GALLERY_ADMIN_MODE) {
    $CAT_LIST = array();
    $CAT_LIST[] = array(FIRST_USER_CAT + USER_ID, $lang_albmgr_php['my_gallery']);
    $CAT_LIST[] = array(0, $lang_albmgr_php['no_category']);
    alb_get_subcat_data($cat, '');
 
    echo <<<EOT
                <tr>
                        <td>
                                <b>{$lang_albmgr_php['select_category']}</b>
                                <select onChange="if(this.options[this.selectedIndex].value) window.location.href='{$_SERVER['PHP_SELF']}?cat='+this.options[this.selectedIndex].value;"  name="cat" class="listbox">
EOT;
    foreach($CAT_LIST as $category) {
        echo '                                <option value="' . $category[0] . '"' . ($cat == $category[0] ? ' selected': '') . ">" . $category[1] . "</option>\n";
    }
    echo <<<EOT
                                </select>
                                <br /><br />
                        </td>
                </tr>
 
EOT;
}
 
?>
 
................

Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: albmgr.php new feature : jump down into the subcategories and back
« Reply #1 on: July 04, 2006, 07:50:50 am »

Please use the code button (the one with the hash sign) and describe in detail what your mod does.
Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 19 queries.