Thread Start date/time

Inspired in wluke's hack:

open forumdisplay.php

find code:

$threads=$DB_site->query("
SELECT $dotuserid $votequery ".iif($foruminfo[allowicons],'icon.title as icontitle,icon.iconpath,','')."
thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postus erid,
lastposter,thread.dateline,

replace it with:

$threads=$DB_site->query("
SELECT $dotuserid $votequery ".iif($foruminfo[allowicons],'icon.title as icontitle,icon.iconpath,','')."
thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postus erid,
lastposter,thread.dateline AS threadstart,

find code:(2x)

$thread[lastreplydate]=vbdate($dateformat,$thread[lastpost]);
$thread[lastreplytime]=vbdate($timeformat,$thread[lastpost]);

insert after it:

$thread[threadstartdate]=vbdate($dateformat,$thread[threadstart]);
$thread[threadstarttime]=vbdate($timeformat,$thread[threadstart]);

save and close forumdisplay.php

edit forumdisplaybit template

find:

<td bgcolor="{secondaltcolor}" width="30%" nowrap><normalfont>$thread[postedby]

replace it with:

<td bgcolor="{secondaltcolor}" width="30%" nowrap><smallfont>$thread[threadstartdate] <font color="{timecolor}">$thread[threadstarttime]</font><br> by $thread[postedby]</smallfont></td>

save it

done

[RobAC]

What does this hack do and where can we see an example of it?

[h4p3]

It displays you when the thread was started.

For example:
thread starter
nuno
on 05-26-2001 05:28 PM

[nuno]

Nice hack man !!! its working great ! easy to install, i had it working in 3 minutes. nice !!!

My members are very happy now, tnx again.

RoseValleY

[BluSmurf]

Great hack , install it with ease!

[JJR512]

Odd. I've been doing the same thing all along, only my version is much simpler.

Here are my instructions for the same thing:

Find this code in forumdisplay.php: (NOTE: it appears TWICE. You are looking ONLY for the SECOND instance of this code!)

PHP Code:

$thread[lastreplydate]=vbdate($dateformat,$thread[lastpost]); 
$thread[lastreplytime]=vbdate($timeformat,$thread[lastpost]); 

...and after the SECOND instance of the above code, add:

PHP Code:

$thread[firstpostdate]=vbdate($dateformat,$thread[dateline]);
$thread[firstposttime]=vbdate($timeformat,$thread[dateline]); 

Save and upload the file.

Next, edit the forumdisplaybit template. Look for:

PHP Code:

<normalfont>$thread[postedby]</normalfont> 

...and replace it with this:

PHP Code:

<smallfont>$thread[firstpostdate] $thread[firstposttime]<br>by <b>$thread[postedby]</b></smallfont> 

ALSO, in the opening <td> tag that this bit is in, you should add this:

align="right"

This alignment, along with the formatting in the replacement code, will give the thread start time and started by username the same appearance as in the column for the last reply time and last reply user. But you can feel free, of course, to give it your own desired style.

***
So you can see the differences between my version and nuno's version is that I get the thread start time and date from the dateline directly: "$timeformat,$thread[dateline]", whereas in nuno's version you have to edit a select query earlier in the code, and get the start time and date from the query results. It's just simpler this way, although obviously either way works.

Example: http://www.jjr512.com/forums/forumdi...p?s=&forumid=1

[JJR512]

I'd also like to add that in the forumdisplay_threadslist template, I changed Thread Starter to Thread Started, because with the new information in that column, the word "started" is more accurate. It follows more naturally: "Thread Started date by username", rather than "Thread Starter date by username".

[webhost]

Thanks For the hack, worked great!

Joey

[ethank]

One issue that I can't figure out is why the username link is underlined in the "Thread Started" column, but not in the Last Post column. I followed the instructions to the letter!

Ethan