/** * With this you make a reservartion * * @param - int $reservation_id The id off the reservation */ function add_subscription_timepicker($reservation_id, $user_id, $start_date, $end_date, $accepted, $min, $max) { $start_date = Database::escape_string($start_date); $end_date = Database::escape_string($end_date); if (Rsys::check_date_subscription($reservation_id, $start_date, $end_date) != 0) { return 1; } if (!($min == 0 && $max == 0)) { if (Rsys::mysql_datetime_to_timestamp($end_date) - Rsys::mysql_datetime_to_timestamp($start_date) < $min * 60) { return 2; } if (Rsys::mysql_datetime_to_timestamp($end_date) - Rsys::mysql_datetime_to_timestamp($start_date) > $max * 60) { return 3; } } $sql = "INSERT INTO " . Rsys::getTable("subscription") . " (user_id,reservation_id,accepted,start_at,end_at) VALUES ('" . Database::escape_string($user_id) . "','" . Database::escape_string($reservation_id) . "','" . ($accepted ? '1' : '0') . "','" . $start_date . "','" . $end_date . "')"; Database::query($sql); return 0; }