Classroom booking System

[EeEk]

Ive tried a few booking systems but couldnt find something that worked or did what I wanted...so I made my own

 

Demo http://www.el-tek.co.uk/bookings/index.php

use 'admin' and 'password' or 'user' and 'user'

Download http://www.ericsworld.eu/f2/index.php?action=tpmod;dl=0

 

Coded in php/ajax/mysql...for those who don't have php..its time you did

 

Download, unzip to a folder on your webserver, edit dbsettings.php to use your mysql server, point your browser at http://www.thefolder.bla\setup.php. That should install all the datebase table, default settings, some departments, a default room and admin user ready to go...

 

Any feedback good or bad is most welcome...

[Jona]

That looks awesome EeEk, I might be being stupid but I don't seem to be able to find the download link on the download page....

 

Any chance of a direct link?

 

Cheers

Jona

[adurrant]

Hello

 

I have set up this in Deben http://mrbs.sourceforge.net/

 

Its great you can create differnet periods and rooms.

 

The olny downside to this that it can not beconfigured to add multiple books every other week for schools with a 2 week timetable system!

 

I am running this on Lunix with PHP and MySQl

 

Adam

[EeEk]

That looks awesome EeEk, I might be being stupid but I don't seem to be able to find the download link on the download page....

 

My fault...had it in a category that only registered users could see...

 

Id rather not direct link to it because this way I can track the number of downloads...not that that means much other than someone thought it was worth a look

[zag]

Great system EeEk, works fine on our PHP server.

 

One feature request would be to limit the amount of lessons a department can book in a single week. We found some teachers will hog all the lesson times at the expense of others!

 

Also recurring lessons for admin users would be nice

 

Thanks again!

[browsw]

@webman

Any news on the correction of the problem of the booking when in 1room/week view?

[Guest]

Yes, unfortunately I'm suffering from the Great Fasthosts Password Debacle.

 

Download here - Classroombookings 1.0.0, tar.gz, 963kB.

 

Any new versions coming out for your software web man?

 

We have a few issues with the current one, but can't find any help files!

 

1. Reports gives us a 404 error

2. Adding fields to rooms - what does this do... it doesn't appear to create a check box on the actual room booking despite us ticking the relevant box. We want to know what a room is to be used for, and by whom (Which dept)

3. Unable to book "0 days in advance" ... huh?

 

A couple of other "need help" bits, but if you aren't supporting the software, at least on this version, we'll regretfully have to try something else.

[Guest]

Ive tried a few booking systems but couldnt find something that worked or did what I wanted...so I made my own

 

which i appear to have broken....

 

MySQL Error 1064

 

Invalid SQL: SELECT b.booking_id, b.week, b.day, b.period, b.room_id, b.user_id, u.initials, d.dept_name FROM erbs_bookings AS b LEFT JOIN erbs_users AS u ON (u.user_id = b.user_id) LEFT JOIN erbs_depts AS d ON (d.dept_id = b.dept_id) WHERE b.week = 01 AND b.day = 1 AND b.room_id = ORDER BY period

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 'ORDER BY period' at line 6

[webman]

Hi Tx2online

 

1. Reports gives us a 404 error

2. Adding fields to rooms - what does this do... it doesn't appear to create a check box on the actual room booking despite us ticking the relevant box. We want to know what a room is to be used for, and by whom (Which dept)

3. Unable to book "0 days in advance" ... huh?

 

I haven't got round to reports section yet.

 

2. In the bookings view, if you click on the name of a room then it should open up the details (including room fields) in a new window. Although departments table is in, the code to link this with users/rooms is not yet done.

 

3. Yes, for some reason this 0 days in advance setting doesn't actually make it bookable at any time. If you need people to be able to book in advance, make this a large amount of days, 365 for example.

 

I do plan to improve the software but at the moment I don't have a lot of time to dedicate to it due to main job and other projects.

[EeEk]

Ive tried a few booking systems but couldnt find something that worked or did what I wanted...so I made my own

 

which i appear to have broken....

 

Not really broken...It must have 1 room to work...delete all the rooms you get an error, you can still go to admin and set them up again though, I could have added checks but didnt see much point because if you didnt have any rooms to book you wouldnt need it

[Guest]

Ive tried a few booking systems but couldnt find something that worked or did what I wanted...so I made my own

 

which i appear to have broken....

 

Not really broken...It must have 1 room to work...delete all the rooms you get an error, you can still go to admin and set them up again though, I could have added checks but didnt see much point because if you didnt have any rooms to book you wouldnt need it

 

I see..... I can breathe a sigh of relief then

[thursby]

New to this, so apologies if it appears in the wrong place.....

Just installed the ClassroomBookings system on our web site. Installation seemed to go fine.

I can add users, set up the school day, set up departments, edit my profile, add fields to the room database...BUT

When I try to update the school details or add a room to the system I keep getting "the update path does not appear to be valid" message, and nothing saves?

Has anyone come across the same problem...or can anyone suggest corrective action...PLEASE

[webman]

Hi Thursby

 

I think this error appears if the background/room photo/school logo directories aren't writable by the web server (even if you aren't uploading an image).

 

When setting permissions, make sure that they are set recursively (eg. with the -R option if using chmod) or that you assign write permissions to all subdirectories:

 

/webroot/images/bg/
/webroot/images/headers/
/webroot/images/roomphotos/
/webroot/images/roomphotos/160
/webroot/images/roomphotos/320
/webroot/images/roomphotos/640
/webroot/images/roomphotos/temp
/webroot/images/schoolloogo/
/webroot/images/schoolloogo/100
/webroot/images/schoolloogo/200
/webroot/images/schoolloogo/300
/webroot/images/schoolloogo/temp

 

Hope that helps.

[thursby]

Found out we were missing the folders in 'images' alltogether! ...but it is up and working now.

Thanks Webman

[benIT]

Hello,

 

I am having some problems with the Roombooking Software (CRBS One)

 

Just get a HTTP 500 Error! Can't get to install php part

 

Running on Windows 2003, Apache, PHP, MySQL

 

Here is my modified files....

 

Any help welcome!!!

 

Database.php

<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

 

$active_group = "default";

 

$db['default']['hostname'] = 'mm01';

$db['default']['username'] = 'crbs_user';

$db['default']['password'] = 'password';

$db['default']['database'] = 'crbs';

$db['default']['dbdriver'] = 'mysql';

$db['default']['dbprefix'] = '';

$db['default']['active_r'] = TRUE;

$db['default']['pconnect'] = FALSE;

$db['default']['db_debug'] = TRUE;

$db['default']['cache_on'] = FALSE;

 

?>

Config.php

<?php

if (!defined('BASEPATH')) exit('No direct script access allowed');

// Full URL to your installation

$config['base_url'] = 'http://mm01/crbs/';

 

 

// Empty string if using .htaccess

$config['index_page'] = 'index.php';

 

// You shouldn't need to change any of these.

$config['layout'] = 'layout';

$config['language'] = 'english';

$config['uri_protocol'] = 'auto';

$config['url_suffix'] = '';

$config['enable_query_strings'] = FALSE;

$config['controller_trigger'] = 'c';

$config['function_trigger'] = 'm';

$config['time_reference'] = 'local';

$config['log_threshold'] = 0;

$config['log_path'] = '';

$config['log_date_format'] = 'Y-m-d H:i:s';

$config['cache_path'] = '';

$config['encryption_key'] = '';

$config['sess_cookie_name'] = 'ci_session';

$config['sess_expiration'] = 7200;

$config['sess_encrypt_cookie'] = FALSE;

$config['sess_use_database'] = FALSE;

$config['sess_table_name'] = '';

$config['sess_match_ip'] = TRUE;

$config['sess_match_useragent'] = TRUE;

$config['cookie_prefix'] = '';

$config['cookie_domain'] = '';

$config['cookie_path'] = '/';

$config['global_xss_filtering'] = TRUE;

$config['enable_hooks'] = False;

$config['permitted_uri_chars'] = 'a-z 0-9~%.:_-';

$config['compress_output'] = FALSE;

$config['subclass_prefix'] = 'MY_';

$config['rewrite_short_tags'] = FALSE;

 

?>

[benIT]

//\\ Any Ideas //\\

 

Really want to get this working!!

[benIT]

All Sorted now, Missing a setting in the Config Files!!!

 

Anyone know the settings for the Import CSV files, Eg what collumns need

 

eg

 

Username / Password / Password Confrim ETC ETC

[webman]

CSV format is:

 

username, firstname, lastname, email, password

[goodhead]

Webman,

Any news on the intergration of your wonderful booking system into active directory?

 

Dan

[sippo]

I'm sorry to dig up an old thread but I think I'm being a bit thick here. Has anyone got an idiots guide to install classroombookings please?

[webman]

Hi Sippo, there are 2 entries in the wiki for installation on Windows (using WAMP) and Linux: Classroombookings wiki.

[sippo]

If I'm getting a page cannot be displayed message where am I going wrong?!!

[sippo]

Yeah I edit the config files. Where it says 'http://www.website.com/crbs', thats the url of the database? I'm confused.

 

I am using windows 2003 and wamp.

[Shuriken1]

Hi, I feel like an idiot being quite well versed in PHP programming and having unpacked plenty of php packages, but I'm getting the same problem as sippo.

 

Its running on IIS 6.0 with the PHP isapi installed and MySQL running. The setup works fine, as I run plenty of php/mysql apps from it. I've setup the config files as per the instructions and just followed Gibbo's directions to check I had done everything right. Seem to have, yet still get 404 when I try and view index.php.

 

Tried using the correct .htaccess, the original and an empty one, none work. I know IIS doesn't support mod_rewrite but the guide says thats optional. How can I find out what file it is that it cannot find? I've checked the IIS logs but that just shows a request to /crbs/index.php - which I know exists. I've checked the perms on that too and they're fine. 777 in fact, as all of the package seems to be - a bit odd I thought? The whole package seems to be 777 but haven't thought much more of it. Also checked the directory security, got it set to integrated authentication and NO anonymous access, but tried with anon thinking the script might not be able to open another file but still no luck.

 

Would love to get this working as I made a prog last year but my grasp of date/time strings in PHP clearly wasn't sufficient and I'm looking for alternatives.

 

Thanks in advance,

 

Shuriken.

Edited October 9, 2008 by Shuriken1

[webman]

I don't know much about IIS+PHP because I've never had or wanted to use them together. I've had a look on the forum of the framework I used for CRBS and one post suggests adding a question mark after index.php, thus: /crbs/index.php? or with a trailing slash after it. (May need to add this to the config.php file)

 

I would still strongly recommend using WAMP at a minimum if you aren't able to run it on *nix. If you can run it on the same machine as IIS, you can run Apache on a different port; or have Apache (on port 80) proxy requests to IIS running on a different port.