<?php
require "authentication.inc";
require "db.inc";

session_start();
session_authenticate();

$connection = db_connect();

$query = "select * from occupation, users where ".
"user_id=users.id and occupation.id=$_GET[bid];";
$result = db_query($query, $connection);
$row = mysql_fetch_array($result);

$query = "select * from occupation where room_id = $_GET[roomid] ".
"and start < '$row[end]' and end > '$row[start]';";
$result = db_query($query, $connection);
if (mysql_num_rows($result) > 0) {
    $_SESSION[errorMessage] = "There is an overlap. Booking not possible";
    header("Location: error.php");
    exit;
}

$query = "update occupation set room_id=$_GET[roomid] where id=$_GET[bid];";
db_query($query, $connection);

header("Location: booking.php");

include("header.php.inc");
?>


<?php
include("footer.php.inc");
?>