Add link to menu

Posted: Wed May 03, 2017 2:50 pm

Sometimes I log into the website and see that I have a PM so I read it and exit out forgetting that I have not looked at the forums yet. I have searched these forums but can't seem to find anything about this...

I am trying to add a Forum link similar to "New Forum Posts" that will search for, and then list "Today's Posts".

Where would I look for a solution for this?

Site Admin Joined: Aug 22, 2007 Posts: 1772

That is not really easy because the queries in the Forums module are heavy created based on the restrictions between users, moderators, admins and visitors. I tried it but without luck. It needs a comparison between the post_time, which is stored as UNIX timestamp in the _bbpost db-tale and the current UNIX timestamp, filtered with day-month-year.

I added $search_id == 'today' in the search.php of the Forums module and added this in the related if-statements. I built a query for PHPmyAdmin to get the post_ids from today, which is working as direct MYSQL input but its not working in the search.php.

sql Code:

SELECT post_id FROM nuke_bbposts WHERE DATE_FORMAT(post_time,'%Y%m%d')=DATE_FORMAT(NOW(),'%Y%m%d')

Maybe somone here has more experience with the Forums module to complete it.

Posted: Sun May 07, 2017 5:26 pm

OK, thanks. I thought it might not be an easy solution.

Posted: Sat May 13, 2017 11:50 pm

I found a mod for phpbb2 which is supposed to get posts from the last 24 hours, but it returns an empty search everytime.