[shardex]

I am trying to convert the original hack to 3.5 and am having trouble with this code in the forumdisplay.php:

PHP Code:

$sql_threads = "SELECT $votequery $previewfield    thread.threadid, thread.title AS threadtitle, ".
         "thread.forumid, pollid, open, replycount, postusername, postuserid, ".
         "thread.iconid AS threadiconid, $lastpost_info, thread.dateline, ".
         "IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, ".
         "sticky, votetotal, thread.attach,    hiddencount ".
         iif($displaythumbs == true, ", MIN(attachment.attachmentid) AS attachmentid ").
         iif($vbulletin->options['threadsubscribed'] AND $vbulletin->userinfo['userid'], ", NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed").
         iif($deljoin, ", deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason").
         iif($vbulletin->options['threadmarking'] AND $vbulletin->userinfo['userid'], ', threadread.readtime AS threadread'). 
            "$hook_query_fields ".
            "FROM " . TABLE_PREFIX . "thread AS thread ".
            "$deljoin ".            
        iif($vbulletin->options['threadsubscribed'] AND $vbulletin->userinfo['userid'], " LEFT JOIN " . TABLE_PREFIX . "subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = " . $vbulletin->userinfo['userid'] . ")").
            iif($vbulletin->options['threadmarking'] AND $vbulletin->userinfo['userid'], " LEFT JOIN " . TABLE_PREFIX . "threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = " . $vbulletin->userinfo['userid'] . ")").
            "$previewjoin ".
            "$tachyjoin ".
            "$hook_query_joins ".
        iif($displaythumbs == true, "LEFT JOIN ".TABLE_PREFIX."attachment as attachment ON(attachment.postid = thread.firstpostid) ").
        "WHERE thread.threadid IN (0$ids) $hook_query_where ".
        "ORDER BY sticky DESC, $sqlsortfield $sqlsortorder ";
    $threads = $db->query_read($sql_threads);
    unset($limitothers, $delthreadlimit, $deljoin,$datecut, $votequery, $sqlsortfield, $sqlsortorder, $threadids); 


I am basically trying to follow the original format but adapt it for 3.5 since there is a bit if a difference in the $sql_threads variable. I figure you have overcome this and so I was wondering if you could help me out?

Cheers,