Threads Started In Postbit Template

[SgtSling]

I want to add the threads started under the persons post count.. under their avatar in the postbit template. Can someone create a hack for this?

[Scott MacVicar]

open showthread.php

look for
while ($post=$DB_site->fetch_array($posts) and $counter++<$perpage) {
if ($postdone[$post[postid]]) {
$counter--;
continue;
} else {
$postdone[$post[postid]]=1;
}
$postbits .= getpostbit($post);
}

above
$postbits .= getpostbit($post);

add
$threadcount=$DB_site->query_first("SELECT COUNT(threadid) AS amount FROM thread WHERE postuserid='$post[userid]'");

then in your postbit template add $threacount[amount] to show the users thread starting count.

[Admin]

Again, this adds an additional query for each post in a thread, and that won't be a nice thing with 20 posts per page. :o

[eva2000]

Originally posted by FireFly
Again, this adds an additional query for each post in a thread, and that won't be a nice thing with 20 posts per page. :o :eek:

[Scott MacVicar]

hmm the select query for the posts is so big i didn't want to pway with it in fear of breaking, i'll have some "experimentation" then.

[SgtSling]

this would rock if we could get the query's down low!