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]

did you changed your template to another template ?
I cant see an problem if you follow the instructions
if you want, contact me on ICQ (please remember I am from Germany so choose easy words)

[Ajnabi]

ok... it worked on a test forum.... but when i tried it on the real thing i got this error

Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE forum ADD showlasttitle CHAR (3) not null 
mysql error: Duplicate column name 'showlasttitle' 
mysql error number: 1060

Any suggestions?

[Afterburner]

the error: "Duplicate column name" means you have installed the hack before (means opened already the lasttitlehack.php) and the "showlasttitle" entry is already in your database. You can see this if you go to your mysql database and look into the forum table. There must be the entrys:

showlasttitle and lasttitle

if there are both entrys you have only to mofidy the code in the files and the templates and not to run the lasttitlehack.php file

[Ajnabi]

alright... i'll try that... thx for all the help!

does it work with vbb 2.0.3?

[Afterburner]

yes

[LuBi]

Read it works on 2.0.3, yet I'm at the part in my instructions to edit the index.php and cannot find the proper code that needs to be replaced that it says can be found around Line 264. How can I edit this to work properly?

[LuBi]

Really Need Some Help on This one...In the middle of my hacking, and am now stuck with no forum and no hack.

[Afterburner]

line 264 is correct, there starts the code:

// dates
if ($forum['lastpost']>0) {
$forum['lastpostdate']=vbdate($dateformat,$forum['lastpost']);
$forum['lastposttime']=vbdate($timeformat,$forum['lastpost']);
eval("\$forum['lastpostinfo'] = \"".gettemplate('forumhome_lastpostby')."\";");
} else {
$forum['lastpostinfo']='Never';
}

[LuBi]

I'm using 2.0.3, I don;t have that paragraph in my index.php