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

[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