Can this optimization work with this hack below?
https://vborg.vbsupport.ru/showthrea...threadid=36416
These lines (that you ask me to replace) are different in my showthread.php:
PHP Code:
$postscount=$DB_site->query_first("SELECT COUNT(*) AS posts FROM post WHERE post.threadid='$threadid' AND post.visible=1$attachment_clause");
&
PHP Code:
$getpostids=$DB_site->query("
SELECT post.postid FROM post
WHERE post.threadid='$threadid' AND post.visible=1$attachment_clause
ORDER BY dateline $postorder LIMIT ".($limitlower-1).",$perpage
");
How would I make this compatible?