View file wap/latest.php

<?php
 echo "<marquee behavior=\"scroll\" direction=\"left\">";
$sql = "SELECT id, name FROM mx_topics ORDER BY
lastpost DESC LIMIT 0,1";
$items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {

$tlnm = htmlspecialchars($item[1]);

$tpclnk = "<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);

      $vulnk = "By <a href=\"index.php?show=viewuser&amp;hits=$hits&amp;who=$tluid\">$tlnick</a>";
echo "Latest Post: $tpclnk $vulnk ";

}
}
  $sql = "SELECT id, bname, bowner FROM mx_blogs ORDER by bgdate DESC LIMIT 0,1";
$items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {
      $bname = htmlspecialchars($item[1]);

      $bonick = getnick_uid($item[2]);
        
        $byview = "<a href=\"index.php?show=viewuser&amp;hits=$hits&amp;who=$item[2]\">$bonick</a>";

      $lnk = "<a href=\"index.php?show=viewblog&amp;bid=$item[0]&amp;hits=$hits\">$bname</a>";
echo "Latest Blog: $lnk By $byview ";

}
}

 $sql = "SELECT id, filename, uid FROM mx_uploads ORDER BY date DESC LIMIT 0,1";
$items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {
 $ext = getext($item[1]);
 $ime = getextimg($ext);

 $lnk = "Latest File Share: <a href=\"lists.php?show=fview&amp;hits=$hits&amp;file=$item[0]\">".htmlspecialchars($item[1])."</a>";

 $unick = getnick_uid($item[2]);

 $ulnk = "By <a href=\"index.php?show=viewuser&amp;hits=$hits&amp;who=$item[2]\">$unick</a>";
 echo "$lnk $ulnk";
 }
 }
 echo "</marquee>";
?>