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

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

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.