OK, me again
I have always claimed the gremlins reside in my forum and it may be true!
Problem:
Everything worked grand immediately after the editing (I did the new gallery update too prior to editing) the lists were showing in category style for members and admins.
TODAY:
got many pm's and answer to my thread at my forum of change and the regular members (which are allowed to post in all but 1 album category due to age restriction and must be manually added)
was informed that sometime later the entire list disappeared totally for them -- leaving only the choice for uploads as their own personal gallery only.
I ran update database numerously and still the listing did not show all albums at all (I have a non admin account to use for checking), admins (with and without showing admin controls) still saw all but not members
I then redid the functions, original file to revert. Got normalcy but then did this to the edits:
from your first link:
original has:
$result = cpg_db_query("SELECT c.cid, c.rgt, c.name FROM {$CONFIG['TABLE_ALBUMS']} AS a RIGHT JOIN {$CONFIG['TABLE_CATEGORIES']} AS c ON a.category = c.cid WHERE c.cid = " . USER_GAL_CAT . " OR a.owner = ". USER_ID . " ORDER BY lft");
your edit:
$result = cpg_db_query("SELECT DISTINCT c.cid, c.rgt, c.name FROM {$CONFIG['TABLE_ALBUMS']} AS a RIGHT JOIN {$CONFIG['TABLE_CATEGORIES']} AS c ON a.category = c.cid WHERE c.cid = " . USER_GAL_CAT . " OR a.owner = ". USER_ID . " ORDER BY lft");
original is lacking the word "DISTINCT"
I reverted it to original then left the other two edits in the file.
so far one of the members has reported that she sees the listings in categorized order (like upload area) so am tentatively awaiting to see what they say.
will keep you informed of the progress but hope that will work now.