PDA

View Full Version : News Archive issue



Masiello
08-20-2007, 06:24 PM
I have a problem with the form news archive, it show always the date of "yesterday" and the same hour, any fix please?
Below a screenshot.
Thanks in advanced

PS. vB 3.6.8 + vBA 3.0 RC1

Masiello
08-21-2007, 07:32 AM
Now without touch anything and without post it show the date "Today" looks in the screenshot below.
Any solution please.

Our Sponsors
 

Brian
08-21-2007, 05:58 PM
Thank you for pointing this out. If you'll look in your forum/modules/news.php file for this code:

SELECT $ratingsql thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, sticky, thread.attach, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, user.*

And replace with this:

SELECT $ratingsql thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, sticky, thread.attach, thread.lastpostid, thread.lastposter, user.*, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext

Then that should take care of the problem.

Masiello
08-21-2007, 06:31 PM
Thank you so much, that solve the problem :)