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

[Xenon]

it'll add one extra query per post as i see.
you should optimize it, so it'll cache values it has already

[g-force2k2]

Xenon could you explain to me what you mean... i kinda have an idea... but i want to learn... after all thats why im hacking

g-force2k2

[kmfdm_kid2000]

Hey, this is good, my members have been asking for this. Works great, easy install. I only use the Thread count variable, not the replies as well. It's interesting to see people's stats though...

[FFMania]

Nice Hack...but I already have too much things in my postbit so...not for me XD

[Xenon]

@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

[Ice Man_00]

Great hack, but i`m keep getting a parse error in line 188 in that file

(Using vbb 2.2.7 - Works here ??)

Thx

[Chris M]

I thought I had a solution, but then I found :

Fatal error: Call to a member function on a non-object in /home/virtual/site26/fst/var/www/html/forums/admin/functions.php on line 198

Satan

[Ice Man_00]

Thx for helping out anyway

[g-force2k2]

you can just use my original coding on post#15... Xenon made the first coding and im not sure whats up with it... but i'll test it later and find out whats up... regards...

g-force2k2

[Chris M]

Thanks g-force

Satan