https://www.icyphoenix.com/viewtopic.php?f=26&t=2212&p=16039#p16039
-----------------------------------
sympatico
Tue 05 Jun, 2007 02:44

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

thank you for your help