Last Post: XX Minutes Ago

[JulianD]

Requested by: Unknown553 here (https://vborg.vbsupport.ru/showthread.php?s=&threadid=43499)

Description: Small hack to display the time since the last post in forumdisplay.
I did it pretty fast and there could be some bugs, so please, send some feedback.

Thanks.

[Logician]

LOL..

7 minutes before me congrats.. :)

I thought you might want to take a look at my code too.. :classic:

[JulianD]

Cool hack man! I like your code. :) Thanks!

[Link14716]

Heh, that was quick ;)

I will probably install it with some modifications to work with index.php (to show time since last post period). ;)

[blackice912]

Can I have a screenshot?

[Link14716]

It looks like this, but on a vB.

http://forums.sonymusic.com/forum.jsp?forum=438

[blackice912]

Oh, sweet. I think I'll be installing this. :)

[Unknown553]

Wow, that was fast! Thanks, both of you. Now, which of the two should I use? hehehe...

[kmfdm_kid2000]

I went with logician's version, only b/c I already have a lot of his hacks installed, but both are good, and I love stat hacks of all kinds!! Thank you both for your time and effort ;)

[NTLDR]

Originally posted by Link14716
It looks like this, but on a vB.

http://forums.sonymusic.com/forum.jsp?forum=438

Is it me or does that site only have the date/time stamp like vB has by default? Or am I just blind? :knockedout:

[Velocd]

Very cool small hack
/me installs

[Logician]

Originally posted by NTLDR

Is it me or does that site only have the date/time stamp like vB has by default? Or am I just blind? :knockedout:
Just looking wrong place.. Follow the arrow ;)

[Unknown553]

Ok I went with your hack, Logician, for the same reason as kmfdm_kid2000's. I already have a lot of your hacks installed so I trust you. Hack works 100% for me, so this doesn't belong in Beta Hacks ;)

[Dado]

nice hack but I had to take it off. Not sure why a small hack like this used so much CPU. I have an average of 800 online (4mbit average)and the site slowed way down and the load average went up to 4 instead of the average 1.

[JulianD]

Hi Dado... did you tried the Logician version of this hack? Try it and see how it goes.

[mcyates]

fantastic simple hack, weldone. Thanks

[Alien]

Hey.. How bad is the queries and server load with Logician's hack exactly? :)

-Jason

[Alien]

Anyone? :) I'm almost done with all my new hacks, and would like to get this one in if the load or queries won't be crummy...

-Jason

[Logician]

Both hacks add 1 query to forumdisplay page. No big deal, go with any version you like..

[Alien]

Thanks, Logician. I'll probably give yours a whirl.

-Jason

[Alien]

Logician: When viewing the two hacks, would your queries become lesser if you added your newly added template to the $templatesused line in forumdisplay? Just curious. :)

-Jason

[Logician]

that is right Alien..

[Alien]

Great.. So would this change actually make yours 0 queries? Or still 1? :D

[Alien]

0 I hope? :D

[Logician]

1 :)

[Alien]

Shucks. :P

Okay, installing!

[cnczone]

I installed it on 2.30 and it does nothing. What is wrong?

[WEForums]

If you are sure you followed the steps properly you should probably make sure you don't have multiple styles and didn't add the templates into a style you no longer use. It's a common problem when making new templates.

[cnczone]

I have only one style.

[WEForums]

Then you must redo your steps as you didn't do it properly. Make sure you didn't do the wrong $templatesused part because often they look very similar.

EDIT: Don't install this if you have alarge forum with lots of posts. If you do, your server will become overloaded and, if you're the size of WEForums, that isn't good at all. I only get like 1200 e-mails about it being down...and this hack is the cause.

[WEForums]

Thanks to delux (someone who is involved with the WEForums server), he fixed the problem.

Instead of:

$lastpostsecond = $DB_site->query_first("SELECT MAX(post.dateline) AS dateline
FROM post
LEFT JOIN thread ON thread.threadid=post.threadid
WHERE thread.forumid='$forumid'");
$lastpostseconds=time() - $lastpostsecond['dateline'];

Use:

$lastpostsecond = $DB_site->query_first("SELECT lastpost
FROM forum
WHERE forumid='$forumid'");
$lastpostseconds=time() - $lastpostsecond['lastpost'];

[JulianD]

Thanks, I've updated the file