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

News:

CPG Release 1.6.28
added submissions from {406man}
cleaned up a few PHP (8.4) deprecations
fixed PHP deprecation in calendar
removed security vulnerability
(please upgrade when possible)

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.