[mostafa megahed]

Originally Posted by Lynne

I don't know what you mean by Number of Topics. If you mean number of threads, I think there is a modification to do that.

As for number of albums, you will probably have to add a plugin to join in the query and do a count(album.albumid) of the albums for the user joining on album.userid. The above way of doing it for the gifts adds one query per postbit which is not the best way to go. It's probably better to join in the query when the post information for the user is obtained (but don't ask me if it's a left join or right join or any of that cuz I don't know).

Thank U ...

yes i mean number of threads !! but i didn't found this modification ...

and i can't do what you say about the albums count ... so my request is for this :

1- count of user's albums .
2- count of user's friends . [Done]
3- count of user's threads .
4- count of user's referrals .

Any Help ...