hhinoz | 1 Jun 2007 01:55
Picon

Re: bookings not showing

David Smith wrote:
> We have been using mrbs for the last couple of months with very pleasing 
> results.
> On the weekend all of the bookings disappeared. When looking at the 
> tables all data looks to be there as expected.
> It is running on Linux with mrbs 1.2.3, mysl 5 and php 5.16
> I did note a similar problem when reading some of the other postings but 
> they dont seem to be related. The version of php looks to have been 
> installed over a month ago with no problems apparent. New bookings can 
> be made and function correctly.
> 
> thanks
> 
> David Smith
> Xavier College

I am a little confused as there seems to be a change in the 
thread/subject for this question.  That having been said I am showing 
the "Timezone Settings" from config.inc.php of an installation of MRBS 
which is hosted in Texas (USA) but used for bookings in Melbourne 
(Australia).

###################
# TimeZone settings
###################
# The text after TZ= needs to be a valid timezone on the MRBS server.
putenv('TZ=Australia/Melbourne');

This has worked fine for several years (MRBS 1.2.3)

(Continue reading)

Mona Abdelhady | 3 Jun 2007 14:55
Favicon

Color coding subjects

Hello,

Is there a way to color code the table cells according to the booked subject, meaning defining set of colors each assigned to a subject?


Thanks
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
David Plans Casal | 4 Jun 2007 11:17
Picon
Picon

Blank page after login?

Hello,

Just after setting mrbs up, and giving it details for our imap server, I seem to get a blank page when logging in. No clues as to what's happening from http logs, nothing weird on system log, and no weird messages in slapd log either.

Anyone experience this before?

D

--
David Plans Casal
Digital Technologist
School of Arts
Brunel University

e  : david dot plans at brunel.ac.uk
t   : +44 1895 266 475
m : +44 7803 173 959


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Brandon Hunsicker | 5 Jun 2007 06:53
Picon

MRBS restricting user edits

Hello.

I was wondering if anyone has been able to modify the code to restrict 
basic user access to modifying even their own entry.  I was easily able 
to restrict a user's ability to delete the entry, but when messing 
around with the edit code, I end up disabling the ability to add new 
entries.  The edit and new entry code seem to be fairly intermingled.

Any help or tips would be greatly appreciated.

Brandon.

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
John Beranek | 5 Jun 2007 11:49
Picon
Favicon

Re: MRBS restricting user edits

Brandon Hunsicker wrote:
> Hello.
> 
> I was wondering if anyone has been able to modify the code to restrict 
> basic user access to modifying even their own entry.  I was easily able 
> to restrict a user's ability to delete the entry, but when messing 
> around with the edit code, I end up disabling the ability to add new 
> entries.  The edit and new entry code seem to be fairly intermingled.

They're intermingled because editing an entry and creating an entry are
essentially the same really.

You need to add the following code at line 45 of edit_entry.php, just
after "if (isset($id))

	if(!getAuthorised(2))
	{
        	showAccessDenied($day, $month, $year, $area);
	        exit;
	}

and the following code at line 28 of edit_entry_handler.php:

if(isset($id) && !getAuthorised(2))
{
    showAccessDenied($day, $month, $year, $area);
    exit;
}

> Any help or tips would be greatly appreciated.

John.

--

-- 
John Beranek                         To generalise is to be an idiot.
http://redux.org.uk/                                 -- William Blake

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
yanni | 6 Jun 2007 19:58

Dissallowing $level=0 user access

Greetings,
Is there by chance an easy way to make it so you have to be logged in to
view any pages? We often include contact information for individuals who
use our meeting rooms, and would prefer for that information not to be
available to the general public (to protect our patron's privacy.)
If there's a simple way to disable level 0 access that would be great.
Thanks in advance,
-Yanni Cooper
Blacksburg Branch
Montgomery-Floyd Regional Library System

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
yanni | 6 Jun 2007 20:27

Nevermind Re: Dissallowing $level=0 user access

Sorry, I should have done a more extensive search before posting. I found
my answer
http://sourceforge.net/mailarchive/message.php?msg_id=430C982C.7010509%40redux.org.uk
from a couple of years ago on the list. And in all honesty, it was fairly
easy to implement (just a couple of search and replaces for each .php
file...)
Thanks, and sorry for wasting your time.
-Yanni Cooper
Blacksburg Branch
Montgomery-Floyd Regional Library System

> Greetings,
> Is there by chance an easy way to make it so you have to be logged in to
> view any pages? We often include contact information for individuals who
> use our meeting rooms, and would prefer for that information not to be
> available to the general public (to protect our patron's privacy.)
> If there's a simple way to disable level 0 access that would be great.
> Thanks in advance,
> -Yanni Cooper
> Blacksburg Branch
> Montgomery-Floyd Regional Library System
>

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
David Plans Casal | 7 Jun 2007 15:29
Picon
Picon

Re: Blank page after login?

Hello,

Please message below. I did of course mean 'our ldap server', not 'imap'.

The problem now is that, one I've written ldap server details to config.inc.php, trying to authenticate a user keeps giving me:

"You do not have access rights to modify this item."

But slapd says nothing, httpd logs nothing useful, so I don't know where to look next for debugging info. 

Could anyone give me an idea how to debug what's going on? 

David

On 4 Jun 2007, at 10:17, David Plans Casal wrote:

Just after setting mrbs up, and giving it details for our imap server, I seem to get a blank page when logging in. No clues as to what's happening from http logs, nothing weird on system log, and no weird messages in slapd log either.

Anyone experience this before?

D

--
David Plans Casal
Digital Technologist
School of Arts
Brunel University

e  : david dot plans at brunel.ac.uk
t   : +44 1895 266 475
m : +44 7803 173 959


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
mrbs-general mailing list

--
David Plans Casal
Digital Technologist
School of Arts
Brunel University

e  : david dot plans at brunel.ac.uk
t   : +44 1895 266 475
m : +44 7803 173 959


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Jennifer Pollard | 8 Jun 2007 09:13
Picon
Picon
Favicon

Re: Color coding subjects

Mona Abdelhady wrote:
> Is there a way to color code the table cells according to the booked
> subject, meaning defining set of colors each assigned to a subject?

Hi, Mona :)

I think what you're after is in the config.inc.php file, in the section 
called 'Entry Types'

Ours starts on line 407 and looks like:

$typel["A"] = "Normal Priority";
$typel["B"] = "Needs Billing";
$typel["C"] = "Provisional Booking";
# $typel["D"] = "D";
# $typel["E"] = get_vocab("external");
$typel["F"] = "Medical";
$typel["G"] = "Special Requirements";
$typel["H"] = "Holiday";
# $typel["I"] = get_vocab("internal");
$typel["J"] = "Training";

(There's no particular reason they're split up the way they are and some 
are commented out, except they're for different 'areas'.  We use MRBS 
not only for room bookings, but also as a general calendar for our small 
group of office staff - each member of staff is a 'room'.  It works for 
us. :)

So, the first thing you'd do is define your subjects in the fields above 
(you can add new fields easily, too, as far as I can tell!) and then go 
into mrbs.css and find:

TD.A {background-color:#C0E0FF} /* normal priority */
TD.B {background-color:#00FF00} /*Needs Billing*/
TD.C {background-color:#FFFF99} /*Provisional Booking*/
TD.D {background-color:#FFFF99}
TD.E {background-color:#CCCCCC}
TD.F {background-color:#CCCCCC} /*medical*/
TD.G {background-color:#FF6666} /*special requirements*/
TD.H {background-color:#FF66CC} /*holiday*/
TD.I {background-color:#CCCCCC}
TD.J {background-color:#9999FF} /*training*/

(Ours starts on line 44)

Just set new colours for your bookings here (if you want!) and, if you 
add any more types in the config file, make sure you give them a colour 
here, too.  This changes both what shows up in the 'Type' field while 
booking a room and the key along the bottom of your calendar view.

I hope this helps! :)

-Jen

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
Phil Dunford | 12 Jun 2007 15:10
Picon

Copying a week

 

I have to enter block bookings the term before they apply and we have a week 1 pattern and a week 2 pattern which alternate.

 

Is there a way to copy all entries (for all rooms) from one week to another in one action?

 

i.e. I enter all data for week starting 11th June and then copy that data to week starting 25th June etc.

 

Pardon me if this is a stupid question, but I know very little about the ‘nut and bolts’ of mysql and such a facility would save me a lot of data entry!

 

 

(Have used MRBS in a large UK Secondary school for the last 6 months for booking computer rooms– very successful).

 

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general

Gmane