SimpleSi Posted January 20, 2006 Posted January 20, 2006 One of my primary schools has an e-learning centre so that Year6/7 children can come and use the school ICT facilites after school for homework. Booking these facilities by phone is causing some problems and he'd like an online resource booking system. E.g parents logon the previous evening or during the day and book their child in for that day. Does anyone use any such system or know of one that could be used for this purpose. I think our LEA can provide us with PHP/SQL facilities ( I just know these buzzwords - I don't know what they are and Dos-box is always telling me just to ask and I will receive ) so it wouldn't cost us anything to host something. regards Simon
Ric_ Posted January 20, 2006 Posted January 20, 2006 @SimpleSi: MRBS could probably be used with a couple of very basic tweaks. I assume that you book the individual computers out so you could replace the word Room with Computer and authenticate against either a basic database or simply set up the logins in the config file. There's a few of us that use MRBS for booking out computer suites so we can help with any probs.
wesleyw Posted January 20, 2006 Posted January 20, 2006 Yeah we use it here I set it up for this September and it's been a big hit! The only trouble is the bloody way our timetable works on a 2 week rota and which week it will be after each half or full term lol. But MRBS is excellent! Wes
Ric_ Posted January 20, 2006 Posted January 20, 2006 @wesleyw: Should not effect Si since it will simply be 1 block for each PC after school each day.
plexer Posted January 20, 2006 Posted January 20, 2006 wesleyw: We have the exact same issue. 2 Week timetable then a holiday throws the whole thing out so I do the bookings for half a term at a time and then you get the clever dick teacher who books more in advance. Will have to see if I can restrict that would be great to be able to insert holidays etc... and have it automatically move the bookings forward Ben
ChrisH Posted January 20, 2006 Posted January 20, 2006 I posted some code in the scripts forum a while ago to let you limit the days ahead people could book on MRBS. That could solve one of your issues.
wesleyw Posted January 20, 2006 Posted January 20, 2006 I changed part of the code because it booked until 2010, I know someone would book a year in advance if they could! lol I'll have to look out for that then Chris. Thanks Wes
ChrisH Posted January 20, 2006 Posted January 20, 2006 Post is here: http://edugeek.net/index.php?name=Forums&file=viewtopic&t=357 Ive not had any issues with it so far since August.
SimpleSi Posted January 23, 2006 Author Posted January 23, 2006 Thanks for info - the webmaster at Lancs is setting up a database for me - so I;ll be back shortly asking the really stupid questions - like how do you switch it on regards Simon
u8dmtm Posted February 1, 2006 Posted February 1, 2006 It may be too late to post this but here goes anyway. We use a home-grown ASP/SQL solution which suits us. However another school in our LEA uses OARBS - which is a free online booking system: http://www.oarbs.com/
webman Posted February 1, 2006 Posted February 1, 2006 We use OARBS as well, you may notice that my place of employment is also mentioned on the OARBS front page (not me )
SimpleSi Posted February 2, 2006 Author Posted February 2, 2006 @webman This looks great for the simple task we need it for- but why/how is it free = what's your involvement? regards Simon
Grommit Posted September 28, 2008 Posted September 28, 2008 It may be too late to post this but here goes anyway. We use a home-grown ASP/SQL solution which suits us. However another school in our LEA uses OARBS - which is a free online booking system: Welcome to OARBS Software Corporation: Resource Management Systems and Print Auditing Software Can't seem to find a download link for this ?
Grommit Posted September 28, 2008 Posted September 28, 2008 Where is the installation documentation for MRBS as it doesn't work on my XP PC... ?
Marci Posted October 29, 2008 Posted October 29, 2008 (edited) The only trouble is the bloody way our timetable works on a 2 week rota and which week it will be after each half or full term lol.Should be able to nudge all entries + or - 7 days to move it into line after holidays with a MySQL query... add 604800 to start and end times (and end date for repeat table) to move it forward 7 days. subtract to move it back 7 days on both the entry and repeat tables. Should be able to script it with php somewhere to do it at push of a button. Haven't done it meself yet but it's on my list of things to do as they've decided to collapse timetable for an intensive study week first week back after half term, and am unsure where it lands us in terms of week1 or week2 when things get back to normal. EDIT: change mrbs_entry and mrbs_repeat to match your table names. UPDATE mrbs_entry SET `start_time`=`start_time`+604800,`end_time`=`end_time`+604800 UPDATE mrbs_repeat SET `start_time`=`start_time`+604800,`end_time`=`end_time`+604800,`end_date`=`end_date`+604800 Run those on your MySQL database to shift everything forward one week. UPDATE mrbs_entry SET `start_time`=`start_time`-604800,`end_time`=`end_time`-604800 UPDATE mrbs_repeat SET `start_time`=`start_time`-604800,`end_time`=`end_time`-604800,`end_date`=`end_date`-604800 Run those to shift everything back a week. Edited October 29, 2008 by Marci
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now