LastTitleHack

Deutsch:

Dieser Hack zeigt in der Spalte Letzter Beitrag unter dem Datum und den Usernamen des letzten Posters auch den Titel des Topics an.

um euch den hack anzusehen klickt hier:

www.the-afterburner.de

English:

This hack shows in the row "last post" on the mainpage below the date and the username of the last posting also the title of the last posting.

to see the hack in action click here:

www.the-afterburner.de

UPDATE: 8. September 2001 to Version 2
New:

You can set the length of the title in your CP
If a word is loger than your settings there are ... at the end
works also in subcategories
Link to the last posting

[Afterburner]

here is a screenshot:

[NanoEntity]

Nice hack, dose this limit how long the topic can be?

like to 25 characters then it breaks it with a seperator like >

[Afterburner]

the text can contain only 20 letters but you can change this in your MySQL Database.

forum
--> lasttitle

and set it to a higher one

[NanoEntity]

I see, thanks, very nice!

I've done everything,but it does not change,why?

[Znaper]

Open yout lasttitlehack.php and change the line

$DB_site->query("ALTER TABLE forum ADD lasttitle VARCHAR (20) not null");

to

$DB_site->query("ALTER TABLE forum ADD lasttitle VARCHAR (25) not null");

[maverick1236]

ive done everything word for word-but it all looks the same

any more suggestions?

[mojotim]

Checked and triple checked, still no go for me.
Getting no data in the lasttitle column in the database on new posts.

[Afterburner]

sorry I forgot a little bit, I think it was to late yesterday.


If you have already installed this hack and nothing is shown on the manpage please download the hack again or follow this instructions:


download the "newthread.php" into ASCII Mode and backup this file.


look for this code (ca. line 230):

PHP Code:

      // update forum stuff
      if ($visible==1) {
        $DB_site->query("UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1,lastpost='".time()."',lastposter='".addslashes($postusername)."' WHERE forumid IN ($foruminfo[parentlist])");
      } 


replace it with:

PHP Code:

      // update forum stuff 
      if ($visible==1) {
        $DB_site->query("UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1,lastpost='".time()."',lastposter='".addslashes($postusername)."', lasttitle='".addslashes(htmlspecialchars($subject))."' WHERE forumid IN ($foruminfo[parentlist])");
      } 


save the "newthread.php" and upload it into ASCII Mode.


download the "newreply.php" into ASCII Mode and backup this file.


look for this code (ca. line 278):

PHP Code:

      // update forum stuff
      if ($visible==1) {
        $DB_site->query("UPDATE forum SET replycount=replycount+1,lastpost='".time()."',lastposter='".addslashes($postusername)."' WHERE forumid IN ($foruminfo[parentlist])");
      } 


replace it with:

PHP Code:

      // update forum stuff neuster beitrag auf der startseite
      if ($visible==1) {
        $DB_site->query("UPDATE forum SET replycount=replycount+1,lastpost='".time()."',lastposter='".addslashes($postusername)."', lasttitle='".addslashes(htmlspecialchars($threadinfo[title]))."' WHERE forumid IN ($foruminfo[parentlist])");
      } 


save the "newreply.php" and upload it into ASCII Mode.