Classroom booking System

[browsw]

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

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.

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

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?