News:

CPG Release 1.6.29
During HTML5 upload, keep pseudo blank code 200 messages from triggering error condition
added Russian language
correct failure to use theme menu icons in album manager
minor vulnerabilities mitigation

Main Menu

Sort my pictures

Started by Nibbler, November 28, 2004, 04:19:04 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

donnoman

section modified in picmgr.php
       // albums in user's personal galleries
//        if (defined('UDB_INTEGRATION')) {
           //if (GALLERY_ADMIN_MODE) {
//                $sql = $cpg_udb->get_admin_album_list();
           /*} else {
               $sql = "SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = ".(FIRST_USER_CAT + USER_ID);
           }*/
//       } else {
           if (GALLERY_ADMIN_MODE) {
//                $sql = "SELECT aid, CONCAT('(', user_name, ') ', title) AS title " . "FROM {$CONFIG['TABLE_ALBUMS']} AS a " . "INNER JOIN {$CONFIG['TABLE_USERS']} AS u ON category = (" . FIRST_USER_CAT . " + user_id)";
               $sql = $cpg_udb->get_admin_album_list();  //it's always bridged so we no longer need to check.
           } else {
               $sql = "SELECT aid, title AS title FROM {$CONFIG['TABLE_ALBUMS']}  WHERE category = " . (FIRST_USER_CAT + USER_ID);
           }
//       }
       $result = cpg_db_query($sql);

Nibbler

That fixes the problem, thanks.