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

session_start();
session_authenticate();

$connection = db_connect();

$date = $_POST[datesplit];

$query = "select * from car_request where id=$_POST[rid] ".
"and start < '$date' and end > '$date';";
$result = db_query($query, $connection);

if (mysql_num_rows($result) != 1) {
    $_SESSION[errorMessage] = "The split date $date is not feasible for the requested period.";
    header("Location: error.php");
    exit;
}

$row = mysql_fetch_array($result);

$query = "insert into car_request (user_id, start, end, comment) values ".
"($row[user_id], '$row[start]', '$date', ".
"'$row[comment] - Split by $_SESSION[name].');";
db_query($query, $connection);

$query = "insert into car_request (user_id, start, end, comment) values ".
"($row[user_id], '$date', '$row[end]', ".
"'$row[comment] - Split by $_SESSION[name].');";
db_query($query, $connection);

$query = "update car_request set status='s' where id=$_POST[rid] ".
"and start < '$date' and end > '$date';";
db_query($query, $connection);

header("Location: booking.php");
?>