Ok, silly me, accidentally removed the WHERE statement because I thoughtlessly left it on the same line as the one I needed removed.
anyways, here's the potential fix (again)...
@Buraq (and anyone else who may be having a slow response time) - try editing the plugin and changing the query...
Find this:
PHP Code:
$gettickers = $db->query_read("
SELECT t.threadid, t.title, t.forumid, t.open, t.dateline, t.visible, t.firstpostid
FROM " . TABLE_PREFIX . "forum f
INNER JOIN " . TABLE_PREFIX . "thread t ON t.forumid = f.forumid AND t.visible = 1 AND " . $desclim . " > ( SELECT count(" . $desclim . ") FROM " . TABLE_PREFIX . "thread WHERE forumid = f.forumid AND visible = 1 AND dateline > t.dateline )
LEFT OUTER JOIN " . TABLE_PREFIX . "post AS post ON post.postid = t.firstpostid WHERE t.forumid IN (" . implode(',', $tickarray) . ")
ORDER BY field(f.forumid," . implode(',', $tickarray) . "), t.dateline desc
");
remove this code:
PHP Code:
LEFT OUTER JOIN " . TABLE_PREFIX . "post AS post ON post.postid = t.firstpostid
which changes it to this:
PHP Code:
$gettickers = $db->query_read("
SELECT t.threadid, t.title, t.forumid, t.open, t.dateline, t.visible, t.firstpostid
FROM " . TABLE_PREFIX . "forum f
INNER JOIN " . TABLE_PREFIX . "thread t ON t.forumid = f.forumid AND t.visible = 1 AND " . $desclim . " > ( SELECT count(" . $desclim . ") FROM " . TABLE_PREFIX . "thread WHERE forumid = f.forumid AND visible = 1 AND dateline > t.dateline )
WHERE t.forumid IN (" . implode(',', $tickarray) . ")
ORDER BY field(f.forumid," . implode(',', $tickarray) . "), t.dateline desc
");
That code served no purpose and may actually be causing the problem. It is only used for allowing a preview of the post/thread and it is something I forgot to take out.
This will be fixed in the next version.