View file wap/lpost.php

<?php

$sql = "SELECT id, name FROM mx_topics ORDER BY
lastpost DESC LIMIT 0,10";
$items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {

$tlnm = htmlspecialchars($item[1]);
      $nop = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM mx_posts WHERE tid='".$item[0]."'"));

      if($nop[0]>30)

      {

        $iml = "<img src=\"images/hot.gif\" alt=\"*\"/>";

      }else{
      $iml = "<img src=\"images/normal.gif\" alt=\"*\"/>";
 }
 $tpclnk = "$iml<a
href=\"index.php?show=viewtpc&amp;hits=$hits&amp;tid=$item[0]&amp;go=last\">$tlnm</a>";
        $pinfo = mysql_fetch_array(mysql_query("SELECT  uid  FROM mx_posts WHERE tid='".$item[0]."' ORDER BY dtpost DESC LIMIT 0, 1"));

        $tluid = $pinfo[0];

       $tlnick = getnick_uid($tluid);
    $online = mysql_fetch_array(mysql_query("SELECT sex, uicon FROM mx_users WHERE id='".$tluid."'"));
 if($online[1]=="")
 {
 if($online[0]=="M")
 {
 $seximg = "<img src=\"images/male.gif\" alt=\"M\"/>";
 }
 else if($online[0]=="F")
 {
 $seximg = "<img src=\"images/female.gif\" alt=\"F\"/>";
 }else{
 $seximg = "";
 }
}else{
 $seximg = "<img src=\"$online[1]\" alt=\"*\"/>";
 }
      $vulnk = "Posted By: $seximg<a href=\"index.php?show=viewuser&amp;hits=$hits&amp;who=$tluid\">$tlnick</a>";
echo "$tpclnk<br/>$vulnk<br/><br/>";

}
}
      
 
?>