[RELEASE 1.0 beta] LAST THREAD NAME

Deutsch
Diese Hack zeigt auf der index.php unter dem username der das letzte posting gemacht hat auch den titel des threads auf dem dieser das reply geschrieben hat!

English
This hack showes the thread title in the "Last Post" col.

Information
[Version nummer] maybe 1.0 beta
[Files to change] index.php and forumhome_lastpostby template

Installation

== in index.php ==
find:

PHP Code:

        // prepare template vars
        if (!$showforumdescription) {
          $forum['description']='';
        } 


below that add:

PHP Code:

       $lastposttitle = $DB_site->query("SELECT title FROM thread WHERE forumid='$forum[forumid]' ORDER BY lastpost DESC");
       $lastposttitle = $DB_site->fetch_array($lastposttitle);
       $lastposttitle = $lastposttitle[title];
       if (strlen($lastposttitle) > 20) {
           $lastposttitle = substr($lastposttitle,0,18);
    $lastposttitle .= "..";
       } 


== in forumhome_lastpostby template ==
find:

PHP Code:

<a href="member.php3?s=$session[sessionhash]&action=getinfo&find=lastposter&forumid=$forum[forumid]"><b>$forum[lastposter]</b></a> 


und this add:

PHP Code:

<br><a href="showthread.php3?s=$session[sessionhash]&goto=lastpost&forumid=$forum[forumid]"><b>$lastposttitle</b></a></a></smallfont></td> 


thats all folk

have phun!

[webhost]

Has anyone figured out how to have the last title also show up on sub-forums? I have 3 to 4 levels deep on some and this would really help.

[webhost]

Ok I have installed this on my board I used the instuctions from the first thread in this post by somnium
Here is what I have and the problems or bugs I have with it.

First I had a main forum with sub forums under it. The main forum of this was not open for threads but all subforums under it was. With this setup and by using the script changes by somnium nothing showed up in the last post column showing the last thread of the this forum and subforums. So I went back and made the main forum of this set along with all subforums under it open for posts. By doing this it resolved the problem now the last post shows up. Now this is what I get when I open my board and look at this forum with sub-forums and you see the last post for example say yesterday's news you click on it and it opens say example the thread called todays news . you look at the 2 threads and yesterdays news is in the main forum and todays news is in a subforum,since todays news is newer it is the last thread but since it is in a subforum the title does not show up but yesterday's news does because it is in the main forum. Any fix for this? llok in my signature and go to my board and go forums at the bottom and click on last post and you will see the problem. Thanks any help would be appreciated.

Joey

[webhost]

[B]EXCHANGE[B/]

Can you help with this the subforms are driving me crazy. I read the thread over and over and I see where you mentioned something about this below.

Originally posted by dwh
My icons are coming out wrong. for example icon7.gif points to icon14.gif??

Also why the need to add any code to forumdisplay.php??

All main forums work great it is just the subforms can you someone pleasehelp me with this?

[dwh]

kinda busy now but to give you a clue in his code he just pointed to the iconidnumber .gif instead of using iconpath. Using phpmyadmin browse the table icon, you'll see there's a whole path there, you need to get the path info from the sql select statement then point to that instead of the iconidnumber.

[webhost]

this is all I have done
Installation

== in index.php ==
find:

PHP Code:

// prepare template vars
        if (!$showforumdescription) {
          $forum['description']='';
        } 


below that add:

PHP Code:

$lastposttitle = $DB_site->query("SELECT title FROM thread WHERE forumid='$forum[forumid]' ORDER BY lastpost DESC");
       $lastposttitle = $DB_site->fetch_array($lastposttitle);
       $lastposttitle = $lastposttitle[title];
       if (strlen($lastposttitle) > 20) {
           $lastposttitle = substr($lastposttitle,0,18);
    $lastposttitle .= "..";
       } 


== in forumhome_lastpostby template ==
find:

PHP Code:

<a href="member.php3?s=$session[sessionhash]&action=getinfo&find=lastposter&forumid=$forum[forumid]"><b>$forum[lastposter]</b></a> 


und this add:

PHP Code:

<br><a href="showthread.php3?s=$session[sessionhash]&goto=lastpost&forumid=$forum[forumid]"><b>$lastposttitle</b></a></a></smallfont></td> 


[dwh]

Oh, I thought you had icon problems didn't read thru everything. I don't use subforums. I think they're too complicated somehow and confusing which template matches what and it messes me up no matter how much I fiddle so I gave up for now. If I knew the table structure for them I'd try to help you but not sure how the table structure looks so impossible to answer you. Maybe somone who uses it will come in and help;

[webhost]

dwh

Think we might have the fix, we are having to change around
the way you use a subform. Forum verus Cateorgy, I think it will
work we have 3 working already.

Thanks for responding

Be sure to use that updated forumhome_lastpostby template he posted [and I copied with one small change for English]. It is important.

[EXCHANGE]

So here is another fix. Now the link of the last thread name brings you to the post ist belongs to (error came with subforums). Also titles of moderated and not yet approved posts are not shown anymore.

[LuBi]

How can I move my icon over off the text a bit? Below is my forumhome_lastpostby:

<table cellpadding="0" cellspacing="0" border="0" width="100%" id="ltlink">
<tr align="right">
<td nowrap rowspan="2">$icon</td>
<td nowrap><smallfont><a href="showthread.php?s=$session[sessionhash]&goto=lastpost&forumid=$forum[forumid]"><b>$lastposttitle</b></a> (<a href="member.php?s=$session[sessionhash]&action=getinfo&find=lastposter&forumid=$forum[forumid]"><b>$forum[lastposter]</b></a>)</smallfont></td>
</tr>
<tr align="right">
<td nowrap><smallfont>$forum[lastpostdate] <font color="#666686">$forum[lastposttime]</font></td>
</tr>
</table>

Here is a link to my forums index so you can view my problem.