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?
$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
Lone Star State
