Here's what I did to get it to work properly:
OPEN includes/usercp_viewprofile.php
Find:
Code: [Download] [Hide]
- $sql = "SELECT * FROM " . ALBUM_TABLE . " AS p, " . ALBUM_CAT_TABLE . " AS c
- WHERE c.cat_user_id = " . $profiledata['user_id'] . "
- AND p.pic_cat_id = c.cat_id
- AND p.pic_approval = 1
- " . $search_pg . "
- ORDER BY pic_time DESC";
Replace with:
Code: [Download] [Hide]
- $sql = "SELECT * FROM " . ALBUM_TABLE . " AS p, " . ALBUM_CAT_TABLE . " AS c
- WHERE p.pic_user_id = " . $profiledata['user_id'] . "
- AND c.cat_user_id = 0
- AND p.pic_cat_id = c.cat_id
- AND p.pic_approval = 1
- " . $search_pg . "
- ORDER BY pic_time DESC";
