I want hack to show count user thread only per member month

[cairo2day]

I want a product or code to calculate the number of thread only for members
Not all posts In a given month or a certain time
i tried most all posts are all calculated
But I just want to count threads only
any body help me plz?

Regards

[Jhonnyf]

the SQL sencente is

select count(threadid) from thread where postuserid=USER_ID_OF_MEMBER

but doing that it's to many sencentes for each user.....

I think that should be create a new field in user table to save the total create by user (the first time) after that catch when create a new one thread and add 1 to that field


After that, only call this in postbit using $post['my_field']

[cairo2day]

Originally Posted by Jhonnyf

the SQL sencente is

select count(threadid) from thread where postuserid=USER_ID_OF_MEMBER

but doing that it's to many sencentes for each user.....

I think that should be create a new field in user table to save the total create by user (the first time) after that catch when create a new one thread and add 1 to that field


After that, only call this in postbit using $post['my_field']

thanks for reply
but i want full code like that site
http://stats.gamalat.com/
its top poster for thread only per mounth
not all post's

if you help me i will e happy plz