[EventCalendar] Date issues

[Dr. Peter Troxler]

On 21-nov-2007, at 10:12, Josh Shand wrote:

> Hi Pete,
>
> It isn't a bad solution, however the guy who has to update it is  
> *whinging*
> already about manually changing them after they've occurred.  What  
> would be
> involved in writing a cleanup script?

find all events with an event date that has passed and replace the  
post date in the database with that date ... i *think it would have  
to be one simple sql query, using an update statement with an inner  
join ... here is a nice example <http://www.bennadel.com/blog/938- 
Using-A-SQL-JOIN-In-A-SQL-UPDATE-Statement-Thanks-John-Eric-.htm>

/ pt


>
> Thanks
>
> -----Original Message-----
> From: eventcalendar-bounces at firetree.net
> [mailto:eventcalendar-bounces at firetree.net] On Behalf Of Dr. Peter  
> Troxler
> Sent: Wednesday, 21 November 2007 10:06 p.m.
> To: Support for EventCalendar plugin
> Subject: Re: [EventCalendar] Date issues
>
> you could manually change the post date when the event is over or
> whenever you do the first maintenance action on the item.  or you
> write a script that cleans up your database accordingly and gets
> triggered daily
>
> / pt
>
> On 21-nov-2007, at 0:45, Josh Shand wrote:
>
>> Hi there,
>>
>>
>>
>> Just wondering if there is a work around for a problem we are having.
>>
>> Currently the event is posted on a certain date (which is fine) and
>> an event date is set.
>>
>> Once the event is pas its date however, we like to keep the events
>> up as often results for the events are posted in them.  For the
>> archive of these dates though, they all show up as the date that
>> they were posted and not on the event date that we set.  Is there a
>> way to show them purely as the event date that it was set for?
>>
>>
>>
>> Cheers
>>
>>
>>
>> _______________________________________________
>> Blog: http://wpcal.firetree.net/
>> EventCalendar at firetree.net mailing list
>> Unsubscribe: http://penguin.firetree.net/eventcalendar
>
>
> _______________________________________________
> Blog: http://wpcal.firetree.net/
> EventCalendar at firetree.net mailing list
> Unsubscribe: http://penguin.firetree.net/eventcalendar
>
>
> _______________________________________________
> Blog: http://wpcal.firetree.net/
> EventCalendar at firetree.net mailing list
> Unsubscribe: http://penguin.firetree.net/eventcalendar