function get_reservation($id)
{
$id = Database::escape_string($id);
$sql = "SELECT *\n FROM " . Rsys::getTable('reservation') . " r\n INNER JOIN " . Rsys::getTable('item') . " i ON r.item_id=i.id\n LEFT JOIN " . Rsys::getTable('item_rights') . " ir ON ir.item_id=i.id\n LEFT JOIN " . Database::get_main_table(TABLE_MAIN_CLASS) . " c ON ir.class_id=c.id AND ir.item_id = i.id\n LEFT JOIN " . Database::get_main_table(TABLE_MAIN_CLASS_USER) . " cu ON cu.class_id = c.id\n WHERE (cu.user_id='" . api_get_user_id() . "' OR 1=" . (api_is_platform_admin() ? 1 : 0) . " OR 1=" . (Rsys::is_owner_item("{$id}") ? 1 : 0) . ") AND r.id='" . $id . "'";
$result = Database::query($sql);
while ($array = Database::fetch_array($result, 'NUM')) {
$arr[] = $array;
}
return $arr;
}
