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

PHP Code:

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

PHP Code:

  $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.

[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.

[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!