[Erwin]

First of all, you can reduce your queries by 12 by including adding the following templates to your showthread.php $templatesused="" section.

Open showthread.php -

Find:

PHP Code:

if ($action=="showpost") {

    $templatesused = ' 


Replace with:

PHP Code:

if ($action=="showpost") {

    $templatesused = 'postbit_editedreason,postbit_plusimg,postbit_minusimg,warn_seelink,warn_viewlink,warn_warnlink,postbit_donation,postbit_deletepost,postbit_first,showthread_replyopen,showthread_searchthread,showthread_hideposts, 


That's 12 queries that you save by caching these templates. You must not have installed them properly because the hack instructions tell you to do this in the first place - I know that my Search This Thread hack has instructions to do this.

Secondly, what is this?

PHP Code:

SELECT COUNT(*) AS postsc FROM post WHERE post.threadid='12267' AND userid='37' 


This is repeated many times - it is a loop query. What is this counting?