Thread... Post... and Reply Count...

It's really a quick hack but i thought i'd release it because maybe some members would find interest in it... requested by Barret... it requires only a file edit and template edit... yes a smaller hack i usually try to stay away from them because i like challenges...

open admin/functions.php

find:

PHP Code:

$post[joindate]=vbdate($registereddateformat,$post[joindate]); 


above it add:

PHP Code:

global $DB_site;
$threads = $DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE postuserid='$post[userid]'");
    $post[threads] = $threads['threads'];
    $post[replies] = $post[posts] - $post[threads]; 


the open the postbit template and place $post[threads] and/or $post[replies] wherever you like... hopefully it'll be useful to some member...

Enjoy

g-force2k2

[Exo]

Why use this Hack so much queries? The normal post counter does that not!

[Bison]

08-21-02 at 12:26 PM Xenon said this in Post #15
@g-force:
you should replace this:

PHP Code:

$threads = $DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE postuserid='$post[userid]'");
    $post[threads] = $threads['threads'];
    $post[replies] = $post[posts] - $post[threads]; 


with something like this:

PHP Code:

if(!isset($threads[$post[userid]])) {
$threads[$post[userid]] = $DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE postuserid='$post[userid]'");
}
    $post[threads] = $threads[$post[userid]]['threads'];
    $post[replies] = $post[posts] - $post[threads]; 


this should reduce the querys if the same user has two or more posts in one thread on the displaying page

Could you revise your code to limit the amount of queries this hack produces?

Thanks in advance Xenon!

[Xenon]

well the code should work i'd say