A way to have expired reservations deleted?

[Andrew]

Is there a way to have reservations deleted from the database when they expire?

Thanks,
Andrew

[Nick]

That wasn't built in because most people wanted to keep old reservations around for statistics and billing.

This is very easy to do, though and I can likely get this into the 1.2 release.

[Andrew]

I would really like that functionality - any chase that it would be a simple thing or will it require a major re-write?

Thanks,
Andrew

[Nick]

It's a very simple thing.  This actually used to be part of the application, but it was removed by request.

[Andrew]

Can you tell me what I need to put back to get this to work?

Thanks,
Andrew

[Nick]

If you want the rude and crude one, just make a new page that executes a db query:

Code:

select resid from reservations where end_date < mktime(0,0,0);

Then create a ResDB object  

Code:

$db = new ResDB();

and loop through all reservation ids, calling

Code:

$db->delRes($id, null, false, 0);

I can't really provide all the code to create the page and DB connection, but you can copy that from the existing code.

[Andrew]

Thanks - a little over my head so I guess I'll wait to see if this feature makes it into the next release...

Thanks,
Andrew

[Andrew]

Got it working with a very crude PHP page and a cronjob running wget on it.

Thanks for the help!
Andrew

[Nick]

No problem.  I'm going to try to put this in the 1.2 release if I have time.