Delayed Dates for Calendar?

haisan

I am trying to create an events calendar for the city I live in. At the moment am using a modified Gigpress. It is a simple events calendar, where you enter an event, and it is placed into an "upcoming" section, until the day of the event, when it is moved into a "past event" category.

The trouble is, the database is updated at 12:01am each day, moving each day's events automatically from "upcoming" to "past events." But it would be a lot more useful for current events to stay in the "upcoming" category until the end of the day, or even a day or two later.

So, I would like to modify the date check so that the database is not updated until a day or two after an event happens, instead of on the day. Any advice on how best to do this?

NogDog

I can't provide any specific answer without the seeing the specific code in question. I would guess that the differentiation between upcoming and past events is simply a function of a database query which compares the event's date/time to the current date/time. If so, then a slight modification of that query to add or delete time from the current time should be sufficient to make the desired change.

haisan

NogDog wrote:
I can't provide any specific answer without the seeing the specific code in question. I would guess that the differentiation between upcoming and past events is simply a function of a database query which compares the event's date/time to the current date/time. If so, then a slight modification of that query to add or delete time from the current time should be sufficient to make the desired change.

Thank you for the response. Yes, there is a basic database query at the start of the template, which initiates the database update. My problem is, I have not been able to find way to change when the date triggers that database change.

		// Update each one's show_expire with its show_date
		if($getshows) {
			foreach($getshows as $show) {
				$setdates = $wpdb->query("
					UPDATE ".$gigpress['gigs_table']." SET show_expire = '".$show->show_date."' WHERE show_id = ".$show->show_id."
				");	
			}
		};

I'm sure there is some (simple) way of setting the date so the database update is triggered two days after the real date, but I cannot find any explanation of how to do so.

NogDog

Assuming MySQL (I'm not sure how portable the DATE_ADD() function is):

$setdates = $wpdb->query("
   UPDATE ".$gigpress['gigs_table']." SET show_expire = DATE_ADD('".$show->show_date."', INTERVAL 1 DAY) WHERE show_id = ".$show->show_id."

This would set the expire date to 1 day after the show date. Just adjust the "1" of the "INTERVAL 1 DAY" for the actual desired adjustment.