Coroner, very happy with this so far, great work.
Two things:
I have set up a public gallery and set permissions for guests to view images. It shows the main category (inc the thumbnail on the index) but cannot seem to view images in sub categories?
The permisions look ok that have been set but on the sub category, the option for unregistered and guests cannot be checked on the radio button? Any ideas?
Also, Ecards are disallowed but with permissions it still shows the option and on clicking it, it gives this error:
Code:
Invalid SQL:
SELECT
media.*,user.username,COUNT(comment.comid) AS ccount,
ca.userid AS gallery,ca.title AS cattitle,ca.description AS catdescription,ca.rateit,ca.comments,ca.modcomm,cat.permission,
ca.buddies,ca.friends,ca.timestamp,ca.password,ca.real_pass,ca.parentid
FROM umg_media AS media
LEFT JOIN umg_category AS ca ON (ca.catid=media.catid)
LEFT JOIN user AS user ON (user.userid=media.userid)
LEFT JOIN umg_comment AS comment ON (comment.mediaid=media.mediaid
AND comment.moderate=0 OR
IF(ca.userid=0,
(comment.moderate=1 AND
(comment.mediaid=media.mediaid AND (1 OR 1) OR
(comment.mediaid=media.mediaid AND comment.userid=25) OR
(comment.mediaid=media.mediaid AND comment.userid=25 AND (64 OR 128 AND 25))
)
),
(comment.moderate=1 AND
(comment.mediaid=media.mediaid AND (1 OR 1) OR
(comment.mediaid=media.mediaid AND comment.userid=25) OR
(comment.mediaid=media.mediaid AND comment.userid=25 AND (64 OR 128 AND 25)) OR
(comment.mediaid=media.mediaid AND 25 AND 256)
)
)
)
)
WHERE media.mediaid=55
GROUP BY media.mediaid;
Not so much a big deal as I guess normal reg users cannot see the ecard option, but thought I would bring it to your attention.