Mark Pengelly | 1 Apr 12:17 2011

Re: UK BST DST Issue

Thanks for your helpful reply Campbell. Can I just clarify that this will deal OK with series (repeat) bookings that span beyond BST into GMT? That's the purpose of the second part right?

revmarkp

On 31 March 2011 10:03, Campbell Morrison <campbell.morrison <at> gmail.com> wrote:

Yes – you should set $timezone to “Europe/London”.   It won’t solve the problem of your existing entries, but will ensure that future bookings don’t suffer the same problem.   To correct the existing bookings, *backup your database first* and then run a script such as:

 

UPDATE mrbs_entry SET start_time = start_time - 3600, end_time = end_time - 3600 where WHERE timestamp < '2011-03-27 02:00:00' AND start_time > UNIX_TIMESTAMP('2011-03-27 02:00:00') AND start_time < UNIX_TIMESTAMP('2011-10-30 02:00:00');

 

UPDATE mrbs_repeat SET start_time = start_time - 3600, end_time = end_time -3600 where WHERE timestamp < '2011-03-27 02:00:00' AND start_time > UNIX_TIMESTAMP('2011-03-27 02:00:00') AND start_time < UNIX_TIMESTAMP('2011-10-30 02:00:00');

 

Tailor the script to meet your requirements.   This one will correct all bookings made before the change that were made for this summer.   Obviously if you’ve got bookings for next summer or beyond you’ll need to run another script.

 

There are known issues with 1.2.1 and DST changes – not sure why you’ve only just come across them.    1.4.6 should be free of DST issues (apart from one minor problem to do with making bookings for the day of DST changes, which has been fixed in the trunk and the fix will appear in 1.4.7).

 

Campbell

 

 

 

From: Mark Pengelly [mailto:markshop <at> pengelly.info]
Sent: 31 March 2011 09:22
To: mrbs-general <at> lists.sourceforge.net
Subject: [MRBS-general] UK BST DST Issue

 

I am UK based. We make a DST change from GMT to BST (British Summer Time, spring and autumn...)

After change to BST last saturday night (26-03-11) bookings within the BST period *showed* as one hour later (ie a 9.00am start time showed as 10.00am).
I upgraded MRBS upgraded as a result (v 1.2.1 is from 2003, I am a longtime happy user!).

1.4.6 has a php variable for getting Daylight Saving Time correct. $timezone = "Europe/London"; didn't appear to work; it results in the BST entries still being an hour out. (GMT, winter ones unnafected).

However $timezone = "GMT"; *appears* to solve the issue.

Sent this Q to my webhost: Is there anything I should know about the way time is configured on your servers that would confirm that this is an appropriate solution?

Obviously I am concerned about things running smoothly with future DST time changes...

Is it possible that our BST times are not really set right? If so we should consider using the correct timezone and running a script to correct the BST entries perhaps? Not sure why this would have been highlighted now though, it certainly hasn't been an issue each DST change??

Thanks for any insights, revmarkp

thecrossing.co.uk/bookings




------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself;
WebMatrix provides all the features you need to develop and
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf

_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe




--
Mark Pengelly
Worksop
Notts.



------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself; 
WebMatrix provides all the features you need to develop and 
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
Campbell Morrison | 1 Apr 12:21 2011
Picon

Re: UK BST DST Issue

Yes, it will deal OK with series.    What it won’t do is deal with anything (individual entry or series) that goes beyond 2011/12 GMT and into 2012 BST.   If you’ve got any of those you’ll need to expand the query.

 

Campbell

 

 

 

From: Mark Pengelly [mailto:markshop <at> pengelly.info]
Sent: 01 April 2011 11:17
To: mail <at> campbellmorrison.co.uk; General purpose list (support/developers/users)
Subject: Re: [MRBS-general] UK BST DST Issue

 

Thanks for your helpful reply Campbell. Can I just clarify that this will deal OK with series (repeat) bookings that span beyond BST into GMT? That's the purpose of the second part right?

revmarkp

On 31 March 2011 10:03, Campbell Morrison <campbell.morrison <at> gmail.com> wrote:

Yes – you should set $timezone to “Europe/London”.   It won’t solve the problem of your existing entries, but will ensure that future bookings don’t suffer the same problem.   To correct the existing bookings, *backup your database first* and then run a script such as:

 

UPDATE mrbs_entry SET start_time = start_time - 3600, end_time = end_time - 3600 where WHERE timestamp < '2011-03-27 02:00:00' AND start_time > UNIX_TIMESTAMP('2011-03-27 02:00:00') AND start_time < UNIX_TIMESTAMP('2011-10-30 02:00:00');

 

UPDATE mrbs_repeat SET start_time = start_time - 3600, end_time = end_time -3600 where WHERE timestamp < '2011-03-27 02:00:00' AND start_time > UNIX_TIMESTAMP('2011-03-27 02:00:00') AND start_time < UNIX_TIMESTAMP('2011-10-30 02:00:00');

 

Tailor the script to meet your requirements.   This one will correct all bookings made before the change that were made for this summer.   Obviously if you’ve got bookings for next summer or beyond you’ll need to run another script.

 

There are known issues with 1.2.1 and DST changes – not sure why you’ve only just come across them.    1.4.6 should be free of DST issues (apart from one minor problem to do with making bookings for the day of DST changes, which has been fixed in the trunk and the fix will appear in 1.4.7).

 

Campbell

 

 

 

From: Mark Pengelly [mailto:markshop <at> pengelly.info]
Sent: 31 March 2011 09:22
To: mrbs-general <at> lists.sourceforge.net
Subject: [MRBS-general] UK BST DST Issue

 

I am UK based. We make a DST change from GMT to BST (British Summer Time, spring and autumn...)

After change to BST last saturday night (26-03-11) bookings within the BST period *showed* as one hour later (ie a 9.00am start time showed as 10.00am).
I upgraded MRBS upgraded as a result (v 1.2.1 is from 2003, I am a longtime happy user!).

1.4.6 has a php variable for getting Daylight Saving Time correct. $timezone = "Europe/London"; didn't appear to work; it results in the BST entries still being an hour out. (GMT, winter ones unnafected).

However $timezone = "GMT"; *appears* to solve the issue.

Sent this Q to my webhost: Is there anything I should know about the way time is configured on your servers that would confirm that this is an appropriate solution?

Obviously I am concerned about things running smoothly with future DST time changes...

Is it possible that our BST times are not really set right? If so we should consider using the correct timezone and running a script to correct the BST entries perhaps? Not sure why this would have been highlighted now though, it certainly hasn't been an issue each DST change??

Thanks for any insights, revmarkp

thecrossing.co.uk/bookings



------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself;
WebMatrix provides all the features you need to develop and
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf

_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe




--
Mark Pengelly
Worksop
Notts.


------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself; 
WebMatrix provides all the features you need to develop and 
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
Mark Pengelly | 1 Apr 12:29 2011

Re: UK BST DST Issue

That's all very clear. Many thanks.

I'll post back here when I've finished 'spring cleaning' (how appropriate) from my upgrade, to indicate how it all went...

revmarkp




On 1 April 2011 11:21, Campbell Morrison <campbell.morrison <at> gmail.com> wrote:

Yes, it will deal OK with series.    What it won’t do is deal with anything (individual entry or series) that goes beyond 2011/12 GMT and into 2012 BST.   If you’ve got any of those you’ll need to expand the query.

 

Campbell

 

 

 

From: Mark Pengelly [mailto:markshop <at> pengelly.info]
Sent: 01 April 2011 11:17
To: mail <at> campbellmorrison.co.uk; General purpose list (support/developers/users)
Subject: Re: [MRBS-general] UK BST DST Issue

 

Thanks for your helpful reply Campbell. Can I just clarify that this will deal OK with series (repeat) bookings that span beyond BST into GMT? That's the purpose of the second part right?

revmarkp

On 31 March 2011 10:03, Campbell Morrison <campbell.morrison <at> gmail.com> wrote:

Yes – you should set $timezone to “Europe/London”.   It won’t solve the problem of your existing entries, but will ensure that future bookings don’t suffer the same problem.   To correct the existing bookings, *backup your database first* and then run a script such as:

 

UPDATE mrbs_entry SET start_time = start_time - 3600, end_time = end_time - 3600 where WHERE timestamp < '2011-03-27 02:00:00' AND start_time > UNIX_TIMESTAMP('2011-03-27 02:00:00') AND start_time < UNIX_TIMESTAMP('2011-10-30 02:00:00');

 

UPDATE mrbs_repeat SET start_time = start_time - 3600, end_time = end_time -3600 where WHERE timestamp < '2011-03-27 02:00:00' AND start_time > UNIX_TIMESTAMP('2011-03-27 02:00:00') AND start_time < UNIX_TIMESTAMP('2011-10-30 02:00:00');

 

Tailor the script to meet your requirements.   This one will correct all bookings made before the change that were made for this summer.   Obviously if you’ve got bookings for next summer or beyond you’ll need to run another script.

 

There are known issues with 1.2.1 and DST changes – not sure why you’ve only just come across them.    1.4.6 should be free of DST issues (apart from one minor problem to do with making bookings for the day of DST changes, which has been fixed in the trunk and the fix will appear in 1.4.7).

 

Campbell

 

 

 

From: Mark Pengelly [mailto:markshop <at> pengelly.info]
Sent: 31 March 2011 09:22
To: mrbs-general <at> lists.sourceforge.net
Subject: [MRBS-general] UK BST DST Issue

 

I am UK based. We make a DST change from GMT to BST (British Summer Time, spring and autumn...)

After change to BST last saturday night (26-03-11) bookings within the BST period *showed* as one hour later (ie a 9.00am start time showed as 10.00am).
I upgraded MRBS upgraded as a result (v 1.2.1 is from 2003, I am a longtime happy user!).

1.4.6 has a php variable for getting Daylight Saving Time correct. $timezone = "Europe/London"; didn't appear to work; it results in the BST entries still being an hour out. (GMT, winter ones unnafected).

However $timezone = "GMT"; *appears* to solve the issue.

Sent this Q to my webhost: Is there anything I should know about the way time is configured on your servers that would confirm that this is an appropriate solution?

Obviously I am concerned about things running smoothly with future DST time changes...

Is it possible that our BST times are not really set right? If so we should consider using the correct timezone and running a script to correct the BST entries perhaps? Not sure why this would have been highlighted now though, it certainly hasn't been an issue each DST change??

Thanks for any insights, revmarkp

thecrossing.co.uk/bookings



------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself;
WebMatrix provides all the features you need to develop and
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf

_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe




--
Mark Pengelly
Worksop
Notts.



------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself;
WebMatrix provides all the features you need to develop and
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf

_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe




--
Mark Pengelly
Worksop
Notts.



------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself; 
WebMatrix provides all the features you need to develop and 
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
Carlos Sánchez | 1 Apr 13:00 2011
Picon

Re: UK BST DST Issue

Hello,


How can I do to start the weeks of the calendars on Monday? Now are starting on Sunday.
Thanks.
------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself; 
WebMatrix provides all the features you need to develop and 
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
Mark Pengelly | 1 Apr 13:18 2011

Re: UK BST DST Issue

Carlos I think you need to copy this section from the systemdefaults.inc.php file  into the config.inc.php file:


/******************
 * Display settings
 ******************/

// Start of week: 0 for Sunday, 1 for Monday, etc.
$weekstarts = 0;

Sounds like you want to change the 0 to a 1

Ideally a Q like this should start it's own thread!

revmarkp



2011/4/1 Carlos Sánchez <karlitos2005 <at> gmail.com>
Hello,

How can I do to start the weeks of the calendars on Monday? Now are starting on Sunday.
Thanks.

------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself;
WebMatrix provides all the features you need to develop and
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf

_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe




--
Mark Pengelly
Worksop
Notts.



------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself; 
WebMatrix provides all the features you need to develop and 
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
Colm.McGettrick | 2 Apr 11:41 2011
Picon

config.inc.php refresh ?

Hi

 

I was looking through the mrbs-general mailing list archives for something about the config.ic.php file as I have a curious issue, when I first configured and set up this system over a year ago on one long weekend they system has been stable ever since, well done guys. But it looks like time to revisit my interface and I was just editing some of the column headings where I needed to change i.e. 9.30 to read 9.00, I have other changed to make but this defines the issue I need to solve.

 

Step 1 Not  related to MRBS but am including in case you think it is the issue

Via cpanel I edited the config.inc.php file but the change could not save, so I then went to reset the permissions on this to 777 ( overkill) but it would not allow me, so I copied the file to config2.inc.php and edited that instead ,and then renamed the original to configold.inc.php and the renamed the edited file to the original file name config.inc.php and now any further edits to config.inc.php are save
This files was edited using the character encoding us-ascii ??

 

Step 2:

After editing the config.inc.php file I noticed that the edits were not showing up on the interface so I then rebooted the server gracefully (overkill) but still the edits did not show up in the interface. Mmmmm

 

·         Slots section i.e.

·        

 

 

$enable_periods = TRUE;

 

unset($periods);    // Include this line when copying to config.inc.php

$periods[] = "9.00- 9.30 => &nbsp;-&nbsp;Returns ";

$periods[] = "Morning&nbsp;10:00&nbsp;-&nbsp;12.30";

$periods[] = "Afternoon&nbsp;1-4.00pm";

$periods[] = "Evening 4.30pm ==>";

 

 

Step 3: & Question

How do I get the system to take another look at the config.inc.php,

The file I am editing is located just inside the web folder

 

I have just reset the permissions back to 400 to protect this files from other eyes

 

I realise I need to go back and spend some time here again later and upgrade my version of mrbs

 

The first line of my config.ic.php reads

 

// $Id: config.inc.php 1240 2009-11-04 16:01:21Z cimorrison $

 

Which I hope will tell you the version number I am using as I don’t see the version number written elsewhere

 

I hope this is not too basic a questions for you to answer, this weekend I am trying to sort out a video suite set up

For which is the booking system and know I will need to spend next weekend reviewing this  system but would be good

If I can get to update the just some text via the config.inc.php file

 

Conclusion

This is maybe nothing to do with mrbs but more so caching somewhere of php,  but I expected that rebooting the server would resolve this issue

Any ideas appreciated

 

Regards


Colm

 

 

Colm McGettrick

 

ER1-002,

University of Limerick

Ireland

 

Email: colm.mcgettrick <at> ul.ie

 

------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself; 
WebMatrix provides all the features you need to develop and 
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
Mark Pengelly | 3 Apr 15:29 2011

Re: UK BST DST Issue

Campbell if you or anyone were able to check the script you offered me I'd be grateful? I'm getting this error if i run either or both lines:

Error

SQL query:

UPDATE mrbs_entry SET start_time = start_time -3600,
end_time = end_time -3600 WHERE WHERE timestamp < '2011-03-27 02:00:00' AND start_time > UNIX_TIMESTAMP( '2011-03-27 02:00:00' ) AND start_time < UNIX_TIMESTAMP( '2011-10-30 02:00:00' )

MySQL said:

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE timestamp < '2011-03-27 02:00:00' AND start_time > UNIX_T



Error

SQL query:

UPDATE mrbs_repeat SET start_time = start_time -3600,
end_time = end_time -3600 WHERE WHERE timestamp < '2011-03-27 02:00:00' AND start_time > UNIX_TIMESTAMP( '2011-03-27 02:00:00' ) AND start_time < UNIX_TIMESTAMP( '2011-10-30 02:00:00' )

MySQL said:

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE timestamp < '2011-03-27 02:00:00' AND start_time > UNIX_T



Is it because of 2 x 'Where' ? OK so I remove one. Then the scripts runs, but 0 records are altered.

I don't have field called UNIX_TIMESTAMP ? Or is that just a user frioendly way of referring to the time in TIMESTAMP ??

Thanks revmarkp





On 1 April 2011 12:18, Mark Pengelly <markshop <at> pengelly.info> wrote:
Carlos I think you need to copy this section from the systemdefaults.inc.php file  into the config.inc.php file:


/******************
 * Display settings
 ******************/

// Start of week: 0 for Sunday, 1 for Monday, etc.
$weekstarts = 0;

Sounds like you want to change the 0 to a 1

Ideally a Q like this should start it's own thread!

revmarkp



2011/4/1 Carlos Sánchez <karlitos2005 <at> gmail.com>
Hello,

How can I do to start the weeks of the calendars on Monday? Now are starting on Sunday.
Thanks.

------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself;
WebMatrix provides all the features you need to develop and
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf

_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe




--
Mark Pengelly
Worksop
Notts.






--
Mark Pengelly
Worksop
Notts.



------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself; 
WebMatrix provides all the features you need to develop and 
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
Campbell Morrison | 3 Apr 23:15 2011
Picon

Re: UK BST DST Issue

Looks like the problem is that there are two WHERE’s.   Just delete one of them.

 

Campbell

 

 

 

From: Mark Pengelly [mailto:markshop <at> pengelly.info]
Sent: 03 April 2011 14:29
To: General purpose list (support/developers/users)
Subject: Re: [MRBS-general] UK BST DST Issue

 

Campbell if you or anyone were able to check the script you offered me I'd be grateful? I'm getting this error if i run either or both lines:

Error

SQL query:

UPDATE mrbs_entry SET start_time = start_time -3600,
end_time = end_time -3600 WHERE WHERE timestamp < '2011-03-27 02:00:00' AND start_time > UNIX_TIMESTAMP( '2011-03-27 02:00:00' ) AND start_time < UNIX_TIMESTAMP( '2011-10-30 02:00:00' )

MySQL said:

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE timestamp < '2011-03-27 02:00:00' AND start_time > UNIX_T


Error

SQL query:

UPDATE mrbs_repeat SET start_time = start_time -3600,
end_time = end_time -3600 WHERE WHERE timestamp < '2011-03-27 02:00:00' AND start_time > UNIX_TIMESTAMP( '2011-03-27 02:00:00' ) AND start_time < UNIX_TIMESTAMP( '2011-10-30 02:00:00' )

MySQL said:

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE timestamp < '2011-03-27 02:00:00' AND start_time > UNIX_T



Is it because of 2 x 'Where' ? OK so I remove one. Then the scripts runs, but 0 records are altered.

I don't have field called UNIX_TIMESTAMP ? Or is that just a user frioendly way of referring to the time in TIMESTAMP ??

Thanks revmarkp




On 1 April 2011 12:18, Mark Pengelly <markshop <at> pengelly.info> wrote:

Carlos I think you need to copy this section from the systemdefaults.inc.php file  into the config.inc.php file:


/******************
 * Display settings
 ******************/

// Start of week: 0 for Sunday, 1 for Monday, etc.
$weekstarts = 0;

Sounds like you want to change the 0 to a 1

Ideally a Q like this should start it's own thread!

revmarkp


2011/4/1 Carlos Sánchez <karlitos2005 <at> gmail.com>

Hello,

 

How can I do to start the weeks of the calendars on Monday? Now are starting on Sunday.

Thanks.

 

------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself;
WebMatrix provides all the features you need to develop and
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf

_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe




--
Mark Pengelly
Worksop
Notts.





--
Mark Pengelly
Worksop
Notts.


------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself; 
WebMatrix provides all the features you need to develop and 
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
Campbell Morrison | 4 Apr 08:48 2011
Picon

Re: config.inc.php refresh ?

It sounds like you’re not editing the right file.   MRBS won’t run at all if there’s no config file and there’s no caching of the config file that takes place.   The config file should be at the same level in the filesystem as the index.php, day.php files.    For example if you type www.ul.ie/book to make a booking, the config file it uses will be book/config.inc.php

 

Campbell

 

 

 

From: Colm.McGettrick [mailto:Colm.McGettrick <at> ul.ie]
Sent: 02 April 2011 10:42
To: mrbs-general <at> lists.sourceforge.net
Subject: [MRBS-general] config.inc.php refresh ?

 

Hi

 

I was looking through the mrbs-general mailing list archives for something about the config.ic.php file as I have a curious issue, when I first configured and set up this system over a year ago on one long weekend they system has been stable ever since, well done guys. But it looks like time to revisit my interface and I was just editing some of the column headings where I needed to change i.e. 9.30 to read 9.00, I have other changed to make but this defines the issue I need to solve.

 

Step 1 Not  related to MRBS but am including in case you think it is the issue

Via cpanel I edited the config.inc.php file but the change could not save, so I then went to reset the permissions on this to 777 ( overkill) but it would not allow me, so I copied the file to config2.inc.php and edited that instead ,and then renamed the original to configold.inc.php and the renamed the edited file to the original file name config.inc.php and now any further edits to config.inc.php are save
This files was edited using the character encoding us-ascii ??

 

Step 2:

After editing the config.inc.php file I noticed that the edits were not showing up on the interface so I then rebooted the server gracefully (overkill) but still the edits did not show up in the interface. Mmmmm

 

·         Slots section i.e.

·        

 

 

$enable_periods = TRUE;

 

unset($periods);    // Include this line when copying to config.inc.php

$periods[] = "9.00- 9.30 => &nbsp;-&nbsp;Returns ";

$periods[] = "Morning&nbsp;10:00&nbsp;-&nbsp;12.30";

$periods[] = "Afternoon&nbsp;1-4.00pm";

$periods[] = "Evening 4.30pm ==>";

 

 

Step 3: & Question

How do I get the system to take another look at the config.inc.php,

The file I am editing is located just inside the web folder

 

I have just reset the permissions back to 400 to protect this files from other eyes

 

I realise I need to go back and spend some time here again later and upgrade my version of mrbs

 

The first line of my config.ic.php reads

 

// $Id: config.inc.php 1240 2009-11-04 16:01:21Z cimorrison $

 

Which I hope will tell you the version number I am using as I don’t see the version number written elsewhere

 

I hope this is not too basic a questions for you to answer, this weekend I am trying to sort out a video suite set up

For which is the booking system and know I will need to spend next weekend reviewing this  system but would be good

If I can get to update the just some text via the config.inc.php file

 

Conclusion

This is maybe nothing to do with mrbs but more so caching somewhere of php,  but I expected that rebooting the server would resolve this issue

Any ideas appreciated

 

Regards


Colm

 

 

Colm McGettrick

 

ER1-002,

University of Limerick

Ireland

 

Email: colm.mcgettrick <at> ul.ie

 

------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself; 
WebMatrix provides all the features you need to develop and 
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
Bryan Hepworth | 4 Apr 13:52 2011
Picon
Picon

Re: restrict delete to admin

>-----Original Message-----
>From: Campbell Morrison [mailto:campbell.morrison <at> gmail.com]
>Sent: 27 March 2011 19:05
>To: 'General purpose list (support/developers/users)'
>Subject: Re: [MRBS-general] restrict delete to admin
>
>Yes, the code's in del_entry.php.   You can restrict this to admin use only
>simply by changing the permitted level for del_entry.php from 1 to 2 in
>mrbs_auth.inc.   You probably also want to stop ordinary users getting that
>far in the first place by not displaying the links for Delete Entry and
>Delete Series in view_entry.php.
>
>The other thing that you could do - which may be sufficient, depending on
>your requirements - is to stop ordinary users deleting bookings in the past
>by setting the min_book_ahead value.    For example if you set it to zero,
>they can't delete bookings in the past.   If you set it to, say, 1 day, then
>they can't delete bookings which are less than a day away.
>
>Campbell
>
Hi

I've had a play around with these options but still seem to be able to delete bookings less than 24 hours away.

These are the settings from the config file: -

// DEFAULT VALUES FOR NEW AREAS
$min_book_ahead_enabled = TRUE;    // set to TRUE to enforce a minimum advance booking time
$max_book_ahead_enabled = TRUE;    // set to TRUE to enforce a maximum advance booking time

// The advance booking limits are measured in seconds and are set by the two variables below.
// The relevant time for determining whether a booking is allowed is the start time of the
// booking.  Values may be negative: for example setting $min_book_ahead_secs = -300 means
// that users cannot book more than 5 minutes in the past.

// DEFAULT VALUES FOR NEW AREAS
$min_book_ahead_secs = 86400;           // (seconds) cannot book in the past
$max_book_ahead_secs = 60*60*24*7;  // (seconds) no more than one week ahead

Bryan

------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself; 
WebMatrix provides all the features you need to develop and 
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe


Gmane