https://www.icyphoenix.com/viewtopic.php?f=26&t=2898
-----------------------------------
jeffy777
Thu 04 Oct, 2007 19:53

FAP CUSTOMIZATION - [MOD] User's Recent Public Pics To Show In Profile
-----------------------------------
I noticed that the user's recent public pics weren't displaying in the profile view as they should.

Here's what I did to get it to work properly:

OPEN includes/usercp_viewprofile.php

Find:

[code]$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";[/code]

Replace with:

[code]$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";[/code]

:D


