Radicore Forum: RADICORE Suggestions

Home » RADICORE » RADICORE Suggestions » Message of the Day

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Message of the Day [message #2043 is a reply to message #2034]

Wed, 06 May 2009 10:12

gpatti
Messages: 283
Registered: August 2008

Senior Member

I've tried running through my debugger to see why I'm not getting todays messages listed, and I think I may have found a bug - please correct me if I'm wrong...

Lines 315 and 316 in std.table.class.inc show:
$search[$start_date] = "<='$date 00:00:00'";
$search[$end_date] = ">='$date 23:59:59'";

If I'm not mistaken the times on these two rows should be reversed, to become:
$search[$start_date] = "<='$date 23:59:59'";
$search[$end_date] = ">='$date 00:00:00'";

The start and end date fields in the mnu_motd table are defined as date fields rather than datetime fields, so I'm not sure why the times may be having an effect - maybe it's to do with different implementations of MySQL.

Regarding point 2 - this isn't something I need at the moment, but thought it might be a useful addition.

Graham

Report message to a moderator

[Message index]

		Message of the Day By: gpatti on Mon, 04 May 2009 12:35
		Re: Message of the Day By: AJM on Mon, 04 May 2009 15:42
		Re: Message of the Day By: gpatti on Mon, 04 May 2009 17:58
		Re: Message of the Day By: AJM on Wed, 06 May 2009 06:50
		Re: Message of the Day By: gpatti on Wed, 06 May 2009 08:48
		Re: Message of the Day By: AJM on Wed, 06 May 2009 09:34
		Re: Message of the Day By: AJM on Wed, 06 May 2009 10:21
		Re: Message of the Day By: gpatti on Wed, 06 May 2009 10:12
		Re: Message of the Day By: AJM on Wed, 06 May 2009 10:35
		Re: Message of the Day By: gpatti on Wed, 06 May 2009 10:41
		Re: Message of the Day By: AJM on Wed, 06 May 2009 11:02
		Re: Message of the Day By: gpatti on Wed, 06 May 2009 11:28
		Re: Message of the Day By: AJM on Wed, 06 May 2009 12:32
		Re: Message of the Day By: gpatti on Thu, 07 May 2009 06:37
		Re: Message of the Day By: gpatti on Thu, 07 May 2009 06:56
		Re: Message of the Day By: AJM on Thu, 07 May 2009 10:05
		Re: Message of the Day By: gpatti on Thu, 07 May 2009 10:23
		Re: Message of the Day By: gpatti on Thu, 07 May 2009 11:49
		Re: Message of the Day By: AJM on Thu, 07 May 2009 12:45
		Re: Message of the Day By: AJM on Thu, 07 May 2009 12:59

Previous Topic:	Auto numerate records in a list view
Next Topic:	PDF facility to produce letters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Nov 27 07:33:15 EST 2024

Total time taken to generate the page: 0.03215 seconds