Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RavenNuke(tm) v2.5x
Author Message
Doulos
Life Cycles Becoming CPU Cycles



Joined: Jun 06, 2005
Posts: 732

PostPosted: Wed May 03, 2017 2:50 pm Reply with quote

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?


Last edited by Doulos on Sun Sep 24, 2017 10:52 pm; edited 1 time in total 
View user's profile Send private message
neralex
Site Admin



Joined: Aug 22, 2007
Posts: 1774

PostPosted: Sun May 07, 2017 4:44 pm Reply with quote

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.
 
View user's profile Send private message
Doulos







PostPosted: Sun May 07, 2017 5:26 pm Reply with quote

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







PostPosted: Sat May 13, 2017 11:50 pm Reply with quote

I found a mod for phpbb2 which is supposed to get posts from the last 24 hours, but it returns an empty search everytime.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RavenNuke(tm) v2.5x

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©