Re: Personal Gallery Pictures Block On Index
kris*, try this code change in the personal pic block mod.
OPEN
album_mod/album_hierarchy_sql.php
FIND
$sql = "SELECT p.*, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments
FROM ". ALBUM_TABLE ." AS p
LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id
LEFT JOIN ". ALBUM_CAT_TABLE ." AS ct ON p.pic_cat_id = ct.cat_id
LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id
LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id
WHERE ct.cat_user_id > 0 AND p.pic_approval = 1 " .$view_level. "
GROUP BY p.pic_id
ORDER BY pic_time DESC
LIMIT $limit_sql";
REPLACE WITH
$sql = "SELECT p.*, u.user_id, u.username, r.rate_pic_id, ct.cat_title, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments
FROM ". ALBUM_TABLE ." AS p
LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id
LEFT JOIN ". ALBUM_CAT_TABLE ." AS ct ON p.pic_cat_id = ct.cat_id
LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id
LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id
WHERE ct.cat_user_id > 0 AND p.pic_approval = 1 " .$view_level. " AND ct.cat_title <> '".AUTO_CREATE_SUB_CAT_TITLE."'
GROUP BY p.pic_id
ORDER BY pic_time DESC
LIMIT $limit_sql";
just realized there's an option to do this in the ACP
Lone Star State
