Desperate MYSQL problem MRBS one week behind.

[adminray]

Dear ALL,

 

Ive set up MRBS and the weekly schedule rolls over 2 weeks -week 1 and week 2.

 

We had a week off for half term.

 

Now everything is a week 'behind'. I need to edit MRBS (MYSQL) to push every entry one week forward.

 

I have no idea where to start. I;ve installed PHPMYADMIN and nothing is obvious.

 

Does anyone have any idea how to approach this?

 

Cheers,

 

Ray

[nathanfriend]

Before doing anything, backup your database. e.g mysqldump.

 

The table you want is mrbs_entry. The fields are start time and end time. They are stored in epoch format so you could use a converter

 

Epoch Converter - Unix Timestamp Converter

 

One week is 604800 so you could write a query to add this value to your current value.

 

Cheers,

 

Nathan.

[plexer]

This was always the issue we had I only ever put in a half terms worth.

 

Crbs supports 2 week time tables and we currently use that.

 

Ben