forum.coppermine-gallery.net
Dev Board => cpg1.4 Testing/Bugs => cpg1.4 Testing/Bugs: FIXED/CLOSED => Topic started by: donnoman on November 25, 2005, 12:52:37 am
-
Ambiguous order of operations in an sql clause were allowing non-admin-approved images to be shown in albums that had a keyword set.
Problem SQL example:
SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, keywords, title, caption,hits,owner_id,owner_name from cpg140_pictures WHERE (aid='3' ) OR (keywords like '%Everybody%' ) AND approved='YES' ORDER BY filename ASC LIMIT 0 ,12
Fixed SQL example:
SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, keywords, title, caption,hits,owner_id,owner_name from cpg140_pictures WHERE ((aid='3' ) OR (keywords like '%Everybody%' )) AND approved='YES' ORDER BY filename ASC LIMIT 0 ,12
fix committed.
-
This is certainly related : the picture count in the categories list and the overal stats includes non-admin-approved images. While it's shown correctly on the album's picture count.