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!
FAP CUSTOMIZATION - Member Galleries Pics Count
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
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
Subject: Re: Member Galleries Pics Count
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!
Quote:
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!
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?
thank you for your help
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?
$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";
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
Page 1 of 1
You cannot post new topicsYou 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