Two errors in the Photoplog Categories setup:
In the PHP file, this:
Code:
$count_select = "
SELECT COUNT('fileid') AS fotos
FROM " . $db_prefix . "fileuploads
WHERE userid = $userid AND moderate = 1" . $where_add . "
";
Should read:
Code:
$count_select = "
SELECT COUNT(*) AS fotos
FROM " . $db_prefix . "fileuploads
WHERE userid = $userid AND moderate = 0" . $where_add . "
and this:
Code:
$images_select = "
SELECT fileid, userid, filename, catid
FROM " . $db_prefix . "fileuploads
WHERE userid = $userid AND moderate = 1" . $where_add . "
ORDER BY dateline DESC
";
should read:
Code:
$images_select = "
SELECT fileid, userid, filename, catid
FROM " . $db_prefix . "fileuploads
WHERE userid = $userid AND moderate = 0" . $where_add . "
ORDER BY dateline DESC
";
The count seemed wrong, and the moderate = 1 flag would only show those items that are under moderation.