Sort my pictures - Page 2 Sort my pictures - Page 2
 

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

Main Menu

Sort my pictures

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

Previous topic - Next topic

0 Members and 2 Guests 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.