Icy Phoenix

Archived phpBB Topics (Styles, Mods, Support) - FAP CUSTOMIZATION - Member Galleries Pics Count

sympatico [ Mon 04 Jun, 2007 19:35 ]
Post 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!

Artie [ Mon 04 Jun, 2007 23:29 ]
Post 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

sympatico [ Mon 04 Jun, 2007 23:37 ]
Post 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!

Artie [ Tue 05 Jun, 2007 01:56 ]
Post subject: Re: Member Galleries Pics Count

The Search by username does not work for you ?

sympatico [ Tue 05 Jun, 2007 02:44 ]
Post 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: [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