FAP CUSTOMIZATION - [MOD] User's Recent Public Pics To Show In Profile »  Show posts from    to     

Icy Phoenix


Archived phpBB Topics (Styles, Mods, Support) - FAP CUSTOMIZATION - [MOD] User's Recent Public Pics To Show In Profile



jeffy777 [ Thu 04 Oct, 2007 19:53 ]
Post subject: 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: [Hide]
  1. $sql = "SELECT * FROM " . ALBUM_TABLE . " AS p, " . ALBUM_CAT_TABLE . " AS c  
  2. WHERE c.cat_user_id = " . $profiledata['user_id'] . "  
  3. AND p.pic_cat_id = c.cat_id  
  4. AND p.pic_approval = 1  
  5. " . $search_pg . "  
  6. ORDER BY pic_time DESC"; 


Replace with:

Code: [Hide]
  1. $sql = "SELECT * FROM " . ALBUM_TABLE . " AS p, " . ALBUM_CAT_TABLE . " AS c  
  2. WHERE p.pic_user_id = " . $profiledata['user_id'] . "  
  3. AND c.cat_user_id = 0  
  4. AND p.pic_cat_id = c.cat_id  
  5. AND p.pic_approval = 1  
  6. " . $search_pg . "  
  7. ORDER BY pic_time DESC"; 






Powered by Icy Phoenix