Post count in one forum?

[NTLDR]

In functions.php find:

PHP Code:

// global options
    global $showdeficon,$displayemails,$enablepms,$allowsignatures,$wordwrap,$dateformat,$timeformat,$logip,$replacewords,$postsperday,$avatarenabled,$registereddateformat,$viewattachedimages; 


And replace with;

PHP Code:

// global options
    global $showdeficon,$displayemails,$enablepms,$allowsignatures,$wordwrap,$dateformat,$timeformat,$logip,$replacewords,$postsperday,$avatarenabled,$registereddateformat,$viewattachedimages,$DB_site; 


Then find:

PHP Code:

$post[postdate]=vbdate($dateformat,$post[dateline]);
    $post[posttime]=vbdate($timeformat,$post[dateline]); 


Add after:

PHP Code:

$singleforum=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post WHERE forumid=X AND postuserid=$post[userid]');
$post[sfcount]=number_format($singleforum['posts']); 


Remember to change X to the forumid with the posts in you want to count and add $post[sfcount] in the postbit template.

This ISN'T the best way to do this, as it adds 1 query for each post in the thread, I expect someone can come up with a more efficent way.

[Neo-Storm]

can i aslo add for x more than 1 forum? so 1,2,3,4 etc.?

[Neo-Storm]

*bump* please look at it NTLDR

[Neo-Storm]

*bump* again :P

[Chris M]

Ok...Multiple forums?

Find: (from the code above)

PHP Code:

$singleforum=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post WHERE forumid=X AND postuserid=$post[userid]'); 


Change to:

PHP Code:

$singleforum=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post WHERE forumid=X AND forumid=Y AND forumid =Z AND postuserid=$post[userid]'); 


Change X, Y & Z to the forumids...

To add more, just include :

AND forumid=theforumid

Satan

[Neo-Storm]

thx hellsatan

[Chris M]

Np

Satan