View file lastpost.php

<?
     $lpt = mysql_fetch_array(mysql_query("SELECT id, name FROM forumtopics ORDER BY lastpost DESC LIMIT 0,1"));
      $nops = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM forumposts"));
      if($nops[0]==0)
      {
        $pinfo = mysql_fetch_array(mysql_query("SELECT uid FROM forumtopics"));
        $tluid = $pinfo[0];
        
      }else{
        $pinfo = mysql_fetch_array(mysql_query("SELECT  uid  FROM forumposts ORDER BY date DESC LIMIT 0, 1"));
        
        $tluid = $pinfo[0];
      }
      $tlnm = htmlspecialchars($lpt[1]);


$format_link = ucwords(strtolower($tlnm));


$topics=mysql_query("SELECT id, name, closed, views, moved, poll FROM forumtopics WHERE fid='".$fid."' AND pinned='0' ORDER BY lastpost DESC, name, id LIMIT $limit_start, $items_per_page");
$pinned=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM forumtopics WHERE fid='".$fid."' AND pinned='1'"));
if(mysql_num_rows($topics)>0){
while($topic=mysql_fetch_array($topics)){
$nop=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM forumposts WHERE thread='".$topic[0]."'"));
$iml="<img src=\"../images/normal.gif\" alt=\"*\"/>";
if($nop[0]>24){$iml="<img src=\"../images/hot.gif\" alt=\"*\"/>";}
if($topic[4]=='1'){$iml="<img src=\"../images/moved.gif\" alt=\"*\"/>";}
if($topic[2]=='1'){$iml="<img src=\"../images/closed.gif\" alt=\"*\"/>";}
if($topic[5]>0){$iml="<img src=\"../images/poll.gif\" alt=\"*\"/>";}
$atxt="";
if($topic[2]=='1'){$atxt="(X)";}
$tnm=htmlspecialchars($topic[1]);
}}



 
$tpclnk="<a href=\"viewtopic.php?thread=$topic[0]&amp;sid=$sid\">$iml $tnm $nop[0]$atxt</a><br/>\n";



     //$tpclnk = "<a href=\"viewtopic.php?action=viewtpc&amp;sid=$sid&amp;tid=$lpt[0]&amp;go=last\">$format_link</a>";
      $main.= "Latest Post Is<br/> $tpclnk<br/><br/>";
?>