FAP CUSTOMIZATION - Member Galleries Pics Count


Subject: FAP CUSTOMIZATION - Member Galleries Pics Count
hi,

in the members personal galleries index page i would like a little change in the pics count.

i would like to display the total number of pics a member has across all categories, not only the ones in the personal gallery.

i beleive the code for that is in album_personal_index.php but i need some help to change the right code.

thank you for your help!

Profile PM  
Subject: Re: Member Galleries Pics Count
I don't understand why you would want this, but it's your album.
You are talking about the Pics column in the table that contains the list of all personal galleries, right ?

Topic moved to proper forum - FAP General Discussions And Customizations

Profile PM  
Subject: Re: Member Galleries Pics Count
Quote:
You are talking about the Pics column in the table that contains the list of all personal galleries, right ?


yes exactly right!

i want this because i made some modifications to my album; i found it very important to be able to display all pictures from a specific user from all categories the user may have posted in.
so the best way i found to achieve this is to change the user link on the "all personal galleries" to "all pics from usex x" so now i need to display the overall pic count on that page...

so thank you for your help!

Profile PM  
Subject: Re: Member Galleries Pics Count
The Search by username does not work for you ?

Profile PM  
Subject: Re: Member Galleries Pics Count
well it would but i find it more convenient to have a members listing with a direct link to show all of that users pictures. as it is originally, it's only available from viewprofile in phpbb.

that's why i would like to change the pics count on personal galleries page.

can you give me directions?

i beleive it's somewhere over here, or is it?
Code: [Download] [Hide] [Select]
$sql = "SELECT u.username, u.user_id, u.user_regdate, COUNT(p.pic_id) AS pics, MAX(p.pic_id) AS last_pic, COUNT(c.cat_user_id) AS cats
FROM ". USERS_TABLE ." AS u, " . ALBUM_TABLE . " AS p, " . ALBUM_CAT_TABLE . " AS c
WHERE u.user_id <> ". ANONYMOUS ."
AND c.cat_user_id = u.user_id
AND c.cat_id = p.pic_cat_id
GROUP BY user_id
ORDER BY $order_by";


thank you for your help

Profile PM  

Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 1.3685s (PHP: 2% SQL: 98%)
SQL queries: 10 - Debug Off - GZIP Enabled