Lavalair Lost Post

[adeii]

Can somebody help me?
I need Last Post code for Home Page of forum.
Like "last post in theme: ***** by user: ****" for Categories, I need general last post (for all forums,themes,clubs).

[rukiya]

Can somebody help me?
I need Last Post code for Home Page of forum.
Like "last post in theme: ***** by user: ****" for Categories, I need general last post (for all forums,themes,clubs).[/b]

try it

$pinfo = mysql_fetch_array(mysql_query("SELECT  uid, tid  FROM ibwf_posts  ORDER BY dtpost DESC LIMIT 0, 1"));
$nick = getnick_uid($pinfo[0]);
$tpclnk = "<a href=\"index.php?action=viewtpc&amp;sid=$sid&amp;tid=$pinfo[1]&amp;go=last\">$tlnm</a>";
      $vulnk = "<a href=\"index.php?action=viewuser&amp;sid=$sid&amp;who=$pinfo[0]\">$nick</a>";

echo "Last post: $tpclnk
Posted by: $vulnk
";

[Dj-marc]

Ive seen this post somewhere here already.... Pls search the forum before creating a new topic ok?

[Dj-marc]

Ive seen this post somewhere here already.... Pls search the forum before creating a new topic ok?

[SpiderWap]

Ive seen this post somewhere here already.... Pls search the forum before creating a new topic ok?[/b]

And please hit the fast/add reply button just once

[metulj]

And please hit the fast/add reply button just once[/b]

ROFL

[hyperlad]

index lastpost included

include("lastpost.php");
  $pic = mysql_fetch_array(mysql_query("SELECT uid, file FROM ibwf_gallery ORDER BY RAND() LIMIT 1"));
  $user = getnick_uid($pic[0]);
  echo "<p align=\"center\">";
  echo "<small><a href=\"index.php?action=viewuser&amp;who=$sql2[0]&amp;sid=$sid\">$unick</a></small><br/>";
$lpt = mysql_fetch_array(mysql_query("SELECT id, name FROM ibwf_topics ORDER BY
lastpost DESC LIMIT 0,1"));
$nops = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts"));
if($nops[0]==0)
{
$pinfo = mysql_fetch_array(mysql_query("SELECT authorid FROM ibwf_topics"));
$tluid = $pinfo[0];
}else{
$pinfo = mysql_fetch_array(mysql_query("SELECT uid FROM ibwf_posts ORDER BY dtpost
DESC LIMIT 0, 1"));
$tluid = $pinfo[0];
}
$tlnm = htmlspecialchars($lpt[1]);
$tlnick = getnick_uid($tluid);
$tpclnk = "<a
href=\"index.php?action=viewtpc&amp;sid=$sid&amp;tid=$lpt[0]&amp;go=last\">$tlnm</a>";
$vulnk = "<a
href=\"index.php?action=viewuser&amp;sid=$sid&amp;who=$tluid\">$tlnick</a>";

hey i have this in my index.php in action=main

[hyperlad]

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


$format_link = ucwords(strtolower($tlnm));
      $tpclnk = "<a href=\"index.php?action=viewtpc&amp;sid=$sid&amp;tid=$lpt[0]&amp;go=last\">$format_link</a>";
      echo "Latest Post Is<br/> $tpclnk<br/><br/>";
?>

name this lastpost.php if you havent already got it and upload to your web folder try this it works on my friends site