[Boofo]

Yesterday at 05:36 PM Tigga said this in Post #4
Yea, that's exactly what it's coming from... It seems though if you reverse the query (pull from the thread and left join the poll) it works much better. Here's what I changed if anyone would like to try it out...
In admin/thread.php find:

PHP Code:

    $polls = $DB_site->query("
        SELECT poll.pollid, poll.question, thread.title
        FROM poll
        LEFT JOIN thread USING(pollid)
        ORDER BY thread.dateline DESC
    "); 


Replace that with:

PHP Code:

    $polls = $DB_site->query("
        SELECT thread.title, poll.pollid, poll.question 
        FROM thread
        LEFT JOIN poll ON (thread.pollid=poll.pollid)
        WHERE thread.open<>10 AND thread.pollid!='0'
        ORDER BY thread.dateline DESC
    "); 


Just that simple change seemed to do the trick. When I checked the time it took to load the page before hand it was 168 seconds. Afterwards it was pretty much instant. If anyone else has noticed that problem and the fix helps them as well please let me know and I'll go ahead and release it.

Will this also list polls in threads that are closed?