<?<br /><br />if ( $LastCacheTime == 0 || !$CurrentThreadsData ) {<br /> $boardq2 = str_replace("B_", "p.B_", $boardquery);<br /> <br /> $query = "<br /> SELECT p.B_Number,p.B_Posted,p.B_Last_Post,p.B_Subject,p.B_Main,p.B_Replies,p.B_Counter,p.B_Board,u.U_UserName,b.Bo_Title<br /> FROM {$config['tbprefix']}Posts AS p<br /> LEFT JOIN {$config['tbprefix']}Boards AS b ON b.Bo_Keyword = p.B_Board<br /> LEFT JOIN {$config['tbprefix']}Users AS u ON u.U_Number = p.B_LastPosterId<br /> WHERE p.B_Number = p.B_Main<br /> AND (p.B_Sticky = 0 OR p.B_Sticky IS NULL)<br /> $boardq2<br /> ORDER BY p.B_Last_Post DESC<br /> LIMIT $totalcurrentthreads<br /> ";<br /><br /> $sth = $dbh -> do_query($query);<br /><br /> $c = 0;<br /> $curtime = $html -> get_date(); <br /> <br /> $myString = "$tbopen<tr><td align=\"center\" class=\"tdheader\">{$pal_CurrentThreads[0]}</td></tr><tr><td align=\"left\" valign=\"top\" class=\"lighttable\"><table width=\"100%\">";<br /> while ( list($palNumber,$palPosted,$palLast,$palSubject,$palMain,$palReplies,$palCounter,$palKeyword,$palPoster,$palBoTitle) = $dbh -> fetch_array($sth)) {<br /> $c++;<br /> $timepast = round(($curtime - $palLast)/60);<br /> if ( $timepast > 1 ) $timepast = "$timepast minutes ago";<br /> elseif ( $timepast == 1 ) $timepast = "$timepast minute ago";<br /> else $timepast = "just now";<br /> <br /> if ( !empty($palPoster) ) $palPoster = " by $palPoster"; <br /> if ( strlen($palSubject) > 30 ) $palSubject = substr($palSubject,0,30) . "...";<br /> <br /> $myString .= "<tr><td align=\"left\" valign=\"top\" class=\"lighttable\">$spacer</td><td align=\"left\" valign=\"top\" class=\"lighttable\"><font class=\"small\">$palBoTitle: <a href=\"{$config['phpurl']}/showflat.php/Cat/$Cat/Board/$palKeyword/Number/$palNumber\">$palSubject</a>$palPoster ($timepast)</font></td></tr>";<br /> }<br /> if ($c < 1) {$myString .= "<tr><td class=\"lighttable\">{$pal_CurrentThreads[1]}</td></tr>";}<br /> <br /> $myString .= "</table></td></tr>$tbclose<br />";<br /> $CurrentThreadsStorageString = $myString;<br /> $dbh -> finish_sth($sth);<br />}<br />else {<br /> $myString = $CurrentThreadsData;<br /> $CurrentThreadsStorageString = $CurrentThreadsData;<br />}<br /><br />echo $myString;<br />?>