Pulling thread title from query

What I'm trying to do with the code below is pull both the post title (if there is one) and the thread title from the getlastposts query. What I want it to do is is show "Re: threadtitle" is there is no post title. Can someone please tell me what I am doing wrong?

PHP Code:

$totalposts=$userinfo[posts];
  if ($totalposts!=0 or $userinfo[lastpost]!=0) {
    $getlastposts=$DB_site->query("SELECT thread.title,thread.threadid,thread.forumid,post.title,postid,post.dateline FROM post,thread WHERE thread.threadid=post.threadid AND post.userid=$userinfo[userid] AND post.visible=1 ORDER BY post.dateline DESC");
    $postctr=0;
    $latestposts="";
    while ($getlastpost=$DB_site->fetch_array($getlastposts)) {
      $getperms=getpermissions($getlastpost[forumid],$bbuserinfo[userid],$bbuserinfo[usergroupid]);
      if ($getperms[canview]==1) {
        $postdate=vbdate($dateformat,$getlastpost[dateline]);
        $posttime=vbdate($timeformat,$getlastpost[dateline]);
        $posttitle=$getlastpost[title];
        $posttitle=censortext($posttitle);
        $posttitle=htmlspecialchars($posttitle);
        $posttitle=preg_replace("/(\[)(you)(])/siU", $bbuserinfo[username], $posttitle);
        $threadtitle=$getlastpost[title];
        $threadtitle=censortext($threadtitle);
        $threadtitle=htmlspecialchars($threadtitle);
        $threadtitle=preg_replace("/(\[)(you)(])/siU", $bbuserinfo[username], $threadtitle);
        $posturl="showthread.php?postid=$getlastpost[postid]#post$getlastpost[postid]";
        $postctr++;
        if ($postctr==1){
          $lastpostdate=$postdate;
          $lastposttime=$posttime;
          $lastposttitle=$posttitle;
          $lastposturl=$posturl;
        }
        eval("\$latestposts .= \"".gettemplate("getinfo_latestposts")."\";"); 


[Boofo]

Originally posted by mr e
so you want the post's title AND the thread's title?

LOL We keep cross-posting here.

Yes, I want to get them both.

[mr e]

LOL, ya we are cross posting

ok try this, it's late so it might not be perfect and if it's not i'll fix it tomorrow cuz my bed's calling me

PHP Code:

$totalposts=$userinfo[posts];
  if ($totalposts!=0 or $userinfo[lastpost]!=0) {
    $getlastposts=$DB_site->query("SELECT thread.title AS threadtitle,thread.threadid,thread.forumid,post.title AS posttitle,post.postid,post.dateline,post.userid,post.visible FROM thread,post WHERE thread.threadid=post.threadid AND post.userid=$userinfo[userid] AND post.visible=1 ORDER BY post.dateline DESC");
    $postctr=0;
    $latestposts="";
    while ($getlastpost=$DB_site->fetch_array($getlastposts)) {
      $getperms=getpermissions($getlastpost[forumid],$bbuserinfo[userid],$bbuserinfo[usergroupid]);
      if ($getperms[canview]==1) {
        $postdate=vbdate($dateformat,$getlastpost[dateline]);
        $posttime=vbdate($timeformat,$getlastpost[dateline]);

        $posttitle=$getlastpost[posttitle]."(Thread: ".$threadtitle.")";
        $posttitle=censortext($posttitle);
        $posttitle=htmlspecialchars($posttitle);
        $posttitle=preg_replace("/(\[)(you)(])/siU", $bbuserinfo[username], $posttitle);
        $posturl="showthread.php?postid=$getlastpost[postid]#post$getlastpost[postid]"; ///////// <- Not sure what this is supposed to be, what's with the # sign?

        $postctr++;
        if ($postctr==1){
          $lastpostdate=$postdate;
          $lastposttime=$posttime;
          $lastposttitle=$posttitle;
          $lastposturl=$posturl;
        }
        eval("\$latestposts .= \"".gettemplate("getinfo_latestposts")."\";");
        if ($postctr==$showposts) {
         break;
        }
      }
    }
  } else {
  eval("\$latestposts .= \"".gettemplate("getinfo_latestpostsnone")."\";"); 


[Boofo]

Thank you, sir. Works great. With just a few tweaks I got it running smooth. I owe you one.

[mr e]

oh cool i guess i can code when im asleep

[Falkware]

How do you then get this into postbit template to display the RE: threadtitle on all replies after the initial threadpost? I've been looking for something like this as well to avoid an empty field in my postbit.

[Boofo]

In newreply.php, find:

PHP Code:

// ############################### start post reply ###############################
if ($HTTP_POST_VARS['action']=="postreply") {

  // check for subject and message
  $message=trim($message);
  if ($message=="") {
    eval("standarderror(\"".gettemplate("error_nosubject")."\");");
    exit;
  } 


BELOW it add:

PHP Code:

    if ($postinfo[title]!="") {
    $title="Re: ".htmlspecialchars($postinfo[title]);
    }
    $title = str_replace("Re: Re: ", "Re: ", $title); 


Still in newreply.php, find:

PHP Code:

    $title=censortext($title);
    $message=censortext($message); 


ABOVE it add:

PHP Code:

    if ($title=="") {
    $title="Re: ".$thread[title];
    } else {
    $title=$title;
    }
    $title = str_replace("Re: Re: ", "Re: ", $title); 


If you have the multiple quotes hack installed, there is a couple more places you will need it, too. Let me know if you need that also.

[Falkware]

Thank you..got it working now. Also made it put it in using the quick reply box.

Appreciate the help.

[Boofo]

Yesterday at 08:28 PM Falkware said this in Post #17
Thank you..got it working now. Also made it put it in using the quick reply box.

Appreciate the help.

How did you do that?