libpreludedb/master: Whitespace police

[email protected] Fri, 29 Jan 2010 18:00:43 +0100 (CET)
Newsgroups gmane.comp.security.ids.prelude.cvs
Message-ID <[email protected]>
commit 3cd795ae63fee8a95b05f8f925200aab42e9d26c
Author: Yoann Vandoorselaere <[email protected]>
Date:   Thu Jan 21 09:26:01 2010 +0100

    Whitespace police


========================================

 plugins/format/classic/classic-delete.c |  152 +-
 plugins/format/classic/classic-get.c    | 3192 +++++++++++++++---------------
 src/preludedb-error.c                   |   36 +-
 3 files changed, 1690 insertions(+), 1690 deletions(-)

========================================

diff --git a/plugins/format/classic/classic-delete.c b/plugins/format/classic/classic-delete.c
index 9d41434..646f3db 100644
--- a/plugins/format/classic/classic-delete.c
+++ b/plugins/format/classic/classic-delete.c
@@ -41,28 +41,28 @@
 
 static int delete_message(preludedb_sql_t *sql, unsigned int count, const char **queries, const char *idents)
 {
-	int i;
-	int ret;
-	int tmp;
-
-	ret = preludedb_sql_transaction_start(sql);
-	if ( ret < 0 )
-		return ret;
-        
-	for ( i = 0; i < count; i++ ) {
-                
+        int i;
+        int ret;
+        int tmp;
+
+        ret = preludedb_sql_transaction_start(sql);
+        if ( ret < 0 )
+                return ret;
+
+        for ( i = 0; i < count; i++ ) {
+
                 ret = preludedb_sql_query_sprintf(sql, NULL, queries[i], idents);
-		if ( ret < 0 )
-			goto error;
-	}
+                if ( ret < 0 )
+                        goto error;
+        }
 
-	return preludedb_sql_transaction_end(sql);
+        return preludedb_sql_transaction_end(sql);
 
  error:
-	tmp = preludedb_sql_transaction_abort(sql);
+        tmp = preludedb_sql_transaction_abort(sql);
+
+        return (tmp < 0) ? tmp : ret;
 
-	return (tmp < 0) ? tmp : ret;
-	
 }
 
 
@@ -70,42 +70,42 @@ static int do_delete_alert(preludedb_sql_t *sql, const char *idents)
 {
         static const char *queries[] = {
                 "DELETE FROM Prelude_Action WHERE _message_ident %s",
-		"DELETE FROM Prelude_AdditionalData WHERE _message_ident %s AND _parent_type = 'A'",
-		"DELETE FROM Prelude_Address WHERE _message_ident %s AND _parent_type != 'H'",
-		"DELETE FROM Prelude_Alert WHERE _ident %s",
-		"DELETE FROM Prelude_Alertident WHERE _message_ident %s",
-		"DELETE FROM Prelude_Analyzer WHERE _message_ident %s AND _parent_type = 'A'",
-		"DELETE FROM Prelude_AnalyzerTime WHERE _message_ident %s AND _parent_type = 'A'",
-		"DELETE FROM Prelude_Assessment WHERE _message_ident %s",
-		"DELETE FROM Prelude_Classification WHERE _message_ident %s",
-		"DELETE FROM Prelude_Reference WHERE _message_ident %s",
-		"DELETE FROM Prelude_Confidence WHERE _message_ident %s",
-		"DELETE FROM Prelude_CorrelationAlert WHERE _message_ident %s",
-		"DELETE FROM Prelude_CreateTime WHERE _message_ident %s AND _parent_type = 'A'",
-		"DELETE FROM Prelude_DetectTime WHERE _message_ident %s",
-		"DELETE FROM Prelude_File WHERE _message_ident %s",
-		"DELETE FROM Prelude_FileAccess WHERE _message_ident %s",
-		"DELETE FROM Prelude_FileAccess_Permission WHERE _message_ident %s",
-		"DELETE FROM Prelude_Impact WHERE _message_ident %s",
-		"DELETE FROM Prelude_Inode WHERE _message_ident %s",
-		"DELETE FROM Prelude_Checksum WHERE _message_ident %s",
-		"DELETE FROM Prelude_Linkage WHERE _message_ident %s",
-		"DELETE FROM Prelude_Node WHERE _message_ident %s AND _parent_type != 'H'",
-		"DELETE FROM Prelude_OverflowAlert WHERE _message_ident %s",
-		"DELETE FROM Prelude_Process WHERE _message_ident %s AND _parent_type != 'H'",
-		"DELETE FROM Prelude_ProcessArg WHERE _message_ident %s AND _parent_type != 'H'",
-		"DELETE FROM Prelude_ProcessEnv WHERE _message_ident %s AND _parent_type != 'H'",
-		"DELETE FROM Prelude_SnmpService WHERE _message_ident %s",
-		"DELETE FROM Prelude_Service WHERE _message_ident %s",
-		"DELETE FROM Prelude_Source WHERE _message_ident %s",
-		"DELETE FROM Prelude_Target WHERE _message_ident %s",
-		"DELETE FROM Prelude_ToolAlert WHERE _message_ident %s",
-		"DELETE FROM Prelude_User WHERE _message_ident %s",
-		"DELETE FROM Prelude_UserId WHERE _message_ident %s",
-		"DELETE FROM Prelude_WebService WHERE _message_ident %s",
-		"DELETE FROM Prelude_WebServiceArg WHERE _message_ident %s"
-	};
-        
+                "DELETE FROM Prelude_AdditionalData WHERE _message_ident %s AND _parent_type = 'A'",
+                "DELETE FROM Prelude_Address WHERE _message_ident %s AND _parent_type != 'H'",
+                "DELETE FROM Prelude_Alert WHERE _ident %s",
+                "DELETE FROM Prelude_Alertident WHERE _message_ident %s",
+                "DELETE FROM Prelude_Analyzer WHERE _message_ident %s AND _parent_type = 'A'",
+                "DELETE FROM Prelude_AnalyzerTime WHERE _message_ident %s AND _parent_type = 'A'",
+                "DELETE FROM Prelude_Assessment WHERE _message_ident %s",
+                "DELETE FROM Prelude_Classification WHERE _message_ident %s",
+                "DELETE FROM Prelude_Reference WHERE _message_ident %s",
+                "DELETE FROM Prelude_Confidence WHERE _message_ident %s",
+                "DELETE FROM Prelude_CorrelationAlert WHERE _message_ident %s",
+                "DELETE FROM Prelude_CreateTime WHERE _message_ident %s AND _parent_type = 'A'",
+                "DELETE FROM Prelude_DetectTime WHERE _message_ident %s",
+                "DELETE FROM Prelude_File WHERE _message_ident %s",
+                "DELETE FROM Prelude_FileAccess WHERE _message_ident %s",
+                "DELETE FROM Prelude_FileAccess_Permission WHERE _message_ident %s",
+                "DELETE FROM Prelude_Impact WHERE _message_ident %s",
+                "DELETE FROM Prelude_Inode WHERE _message_ident %s",
+                "DELETE FROM Prelude_Checksum WHERE _message_ident %s",
+                "DELETE FROM Prelude_Linkage WHERE _message_ident %s",
+                "DELETE FROM Prelude_Node WHERE _message_ident %s AND _parent_type != 'H'",
+                "DELETE FROM Prelude_OverflowAlert WHERE _message_ident %s",
+                "DELETE FROM Prelude_Process WHERE _message_ident %s AND _parent_type != 'H'",
+                "DELETE FROM Prelude_ProcessArg WHERE _message_ident %s AND _parent_type != 'H'",
+                "DELETE FROM Prelude_ProcessEnv WHERE _message_ident %s AND _parent_type != 'H'",
+                "DELETE FROM Prelude_SnmpService WHERE _message_ident %s",
+                "DELETE FROM Prelude_Service WHERE _message_ident %s",
+                "DELETE FROM Prelude_Source WHERE _message_ident %s",
+                "DELETE FROM Prelude_Target WHERE _message_ident %s",
+                "DELETE FROM Prelude_ToolAlert WHERE _message_ident %s",
+                "DELETE FROM Prelude_User WHERE _message_ident %s",
+                "DELETE FROM Prelude_UserId WHERE _message_ident %s",
+                "DELETE FROM Prelude_WebService WHERE _message_ident %s",
+                "DELETE FROM Prelude_WebServiceArg WHERE _message_ident %s"
+        };
+
         return delete_message(sql, sizeof(queries) / sizeof(*queries), queries, idents);
 }
 
@@ -113,20 +113,20 @@ static int do_delete_alert(preludedb_sql_t *sql, const char *idents)
 
 static int do_delete_heartbeat(preludedb_sql_t *sql, const char *idents)
 {
-	static const char *queries[] = {
-		"DELETE FROM Prelude_AdditionalData WHERE _parent_type = 'H' AND _message_ident %s",
-		"DELETE FROM Prelude_Address WHERE _parent_type = 'H' AND _message_ident %s",
-		"DELETE FROM Prelude_Analyzer WHERE _parent_type = 'H' AND _message_ident %s",
-		"DELETE FROM Prelude_AnalyzerTime WHERE _parent_type = 'H' AND _message_ident %s",
-		"DELETE FROM Prelude_CreateTime WHERE _parent_type = 'H' AND _message_ident %s",
-		"DELETE FROM Prelude_Node WHERE _parent_type = 'H' AND _message_ident %s",
-		"DELETE FROM Prelude_Process WHERE _parent_type = 'H' AND _message_ident %s",
-		"DELETE FROM Prelude_ProcessArg WHERE _parent_type = 'H' AND _message_ident %s",
-		"DELETE FROM Prelude_ProcessEnv WHERE _parent_type = 'H' AND _message_ident %s",
-		"DELETE FROM Prelude_Heartbeat WHERE _ident %s",
-	};
-
-	return delete_message(sql, sizeof(queries) / sizeof(*queries), queries, idents);
+        static const char *queries[] = {
+                "DELETE FROM Prelude_AdditionalData WHERE _parent_type = 'H' AND _message_ident %s",
+                "DELETE FROM Prelude_Address WHERE _parent_type = 'H' AND _message_ident %s",
+                "DELETE FROM Prelude_Analyzer WHERE _parent_type = 'H' AND _message_ident %s",
+                "DELETE FROM Prelude_AnalyzerTime WHERE _parent_type = 'H' AND _message_ident %s",
+                "DELETE FROM Prelude_CreateTime WHERE _parent_type = 'H' AND _message_ident %s",
+                "DELETE FROM Prelude_Node WHERE _parent_type = 'H' AND _message_ident %s",
+                "DELETE FROM Prelude_Process WHERE _parent_type = 'H' AND _message_ident %s",
+                "DELETE FROM Prelude_ProcessArg WHERE _parent_type = 'H' AND _message_ident %s",
+                "DELETE FROM Prelude_ProcessEnv WHERE _parent_type = 'H' AND _message_ident %s",
+                "DELETE FROM Prelude_Heartbeat WHERE _ident %s",
+        };
+
+        return delete_message(sql, sizeof(queries) / sizeof(*queries), queries, idents);
 }
 
 
@@ -135,7 +135,7 @@ static ssize_t get_string_from_ident_list(prelude_string_t **out, uint64_t *iden
         int ret;
         size_t i;
         prelude_bool_t need_sep = FALSE;
-        
+
         ret = prelude_string_new(out);
         if ( ret < 0 )
                 return ret;
@@ -145,20 +145,20 @@ static ssize_t get_string_from_ident_list(prelude_string_t **out, uint64_t *iden
                 goto err;
 
         for ( i = 0; i < size; i++ ) {
-                
+
                 ret = prelude_string_sprintf(*out, "%s%" PRELUDE_PRIu64, (need_sep) ? ", " : "", ident[i]);
                 if ( ret < 0 )
                         goto err;
 
                 need_sep = TRUE;
         }
-        
+
         ret = prelude_string_cat(*out, ")");
         if ( ret < 0 )
                 goto err;
 
         return i;
-        
+
  err:
         prelude_string_destroy(*out);
         return ret;
@@ -172,7 +172,7 @@ static ssize_t get_string_from_result_ident(prelude_string_t **out, preludedb_re
         size_t i = 0;
         uint64_t ident;
         prelude_bool_t need_sep = FALSE;
-        
+
         ret = prelude_string_new(out);
         if ( ret < 0 )
                 return ret;
@@ -195,13 +195,13 @@ static ssize_t get_string_from_result_ident(prelude_string_t **out, preludedb_re
                 ret = 0;
                 goto err;
         }
-        
+
         ret = prelude_string_cat(*out, ")");
         if ( ret < 0 )
                 goto err;
 
         return i;
-        
+
  err:
         prelude_string_destroy(*out);
         return ret;
@@ -237,7 +237,7 @@ ssize_t classic_delete_alert_from_result_idents(preludedb_sql_t *sql, preludedb_
         ssize_t count;
         prelude_string_t *buf;
 
-        count = get_string_from_result_ident(&buf, results);        
+        count = get_string_from_result_ident(&buf, results);
         if ( count <= 0 )
                 return count;
 
@@ -260,7 +260,7 @@ ssize_t classic_delete_alert_from_list(preludedb_sql_t *sql, uint64_t *ident, si
 
         ret = do_delete_alert(sql, prelude_string_get_string(buf));
         prelude_string_destroy(buf);
-        
+
         return (ret < 0) ? ret : count;
 }
 
diff --git a/plugins/format/classic/classic-get.c b/plugins/format/classic/classic-get.c
index 944459e..b71de37 100644
--- a/plugins/format/classic/classic-get.c
+++ b/plugins/format/classic/classic-get.c
@@ -42,24 +42,24 @@
 #define db_log(sql) prelude_log(PRELUDE_LOG_ERR, "%s\n", prelude_sql_error(sql))
 #define log_memory_exhausted() prelude_log(PRELUDE_LOG_ERR, "memory exhausted !\n")
 
-#define get_(type, name)									\
-static int _get_ ## name (preludedb_sql_t *sql, preludedb_sql_row_t *row,			\
-			 int index,								\
-			 void *parent, int (*parent_new_child)(void *parent, type **child))	\
-{												\
-	preludedb_sql_field_t *field;								\
-	type *value;										\
-	int ret;										\
-												\
-	ret = preludedb_sql_row_fetch_field(row, index, &field);				\
-	if ( ret <= 0 )										\
-		return ret;									\
-												\
-	ret = parent_new_child(parent, &value);							\
-	if ( ret < 0 )										\
-		return ret;									\
-												\
-	return preludedb_sql_field_to_ ## name (field, value);					\
+#define get_(type, name)                                                                        \
+static int _get_ ## name (preludedb_sql_t *sql, preludedb_sql_row_t *row,                       \
+                         int index,                                                             \
+                         void *parent, int (*parent_new_child)(void *parent, type **child))     \
+{                                                                                               \
+        preludedb_sql_field_t *field;                                                           \
+        type *value;                                                                            \
+        int ret;                                                                                \
+                                                                                                \
+        ret = preludedb_sql_row_fetch_field(row, index, &field);                                \
+        if ( ret <= 0 )                                                                         \
+                return ret;                                                                     \
+                                                                                                \
+        ret = parent_new_child(parent, &value);                                                 \
+        if ( ret < 0 )                                                                          \
+                return ret;                                                                     \
+                                                                                                \
+        return preludedb_sql_field_to_ ## name (field, value);                                  \
 }
 
 get_(uint8_t, uint8)
@@ -68,41 +68,41 @@ get_(uint32_t, uint32)
 get_(float, float)
 
 #define get_uint8(sql, row, index, parent, parent_new_child) \
-	_get_uint8(sql, row, index, parent, (int (*)(void *, uint8_t **)) parent_new_child)
+        _get_uint8(sql, row, index, parent, (int (*)(void *, uint8_t **)) parent_new_child)
 
 #define get_uint16(sql, row, index, parent, parent_new_child) \
-	_get_uint16(sql, row, index, parent, (int (*)(void *, uint16_t **)) parent_new_child)
+        _get_uint16(sql, row, index, parent, (int (*)(void *, uint16_t **)) parent_new_child)
 
 #define get_uint32(sql, row, index, parent, parent_new_child) \
-	_get_uint32(sql, row, index, parent, (int (*)(void *, uint32_t **)) parent_new_child)
+        _get_uint32(sql, row, index, parent, (int (*)(void *, uint32_t **)) parent_new_child)
 
 #define get_float(sql, row, index, parent, parent_new_child) \
-	_get_float(sql, row, index, parent, (int (*)(void *, float **)) parent_new_child)
+        _get_float(sql, row, index, parent, (int (*)(void *, float **)) parent_new_child)
 
 
 
 
 static int _get_string(preludedb_sql_t *sql, preludedb_sql_row_t *row,
-		       int index,
-		       void *parent, int (*parent_new_child)(void *parent, prelude_string_t **child))
+                       int index,
+                       void *parent, int (*parent_new_child)(void *parent, prelude_string_t **child))
 {
-	preludedb_sql_field_t *field;
-	prelude_string_t *string;
-	int ret;
-
-	ret = preludedb_sql_row_fetch_field(row, index, &field);
-	if ( ret <= 0 )
-		return ret;
-
-	ret = parent_new_child(parent, &string);
-	if ( ret < 0 )
-		return ret;
-
-	ret = prelude_string_set_dup_fast(string,
-					  preludedb_sql_field_get_value(field),
-					  preludedb_sql_field_get_len(field));
-	
-	return (ret < 0) ? ret : 1;
+        preludedb_sql_field_t *field;
+        prelude_string_t *string;
+        int ret;
+
+        ret = preludedb_sql_row_fetch_field(row, index, &field);
+        if ( ret <= 0 )
+                return ret;
+
+        ret = parent_new_child(parent, &string);
+        if ( ret < 0 )
+                return ret;
+
+        ret = prelude_string_set_dup_fast(string,
+                                          preludedb_sql_field_get_value(field),
+                                          preludedb_sql_field_get_len(field));
+
+        return (ret < 0) ? ret : 1;
 }
 
 
@@ -110,220 +110,220 @@ static int _get_string_listed(preludedb_sql_t *sql, preludedb_sql_row_t *row,
                               int index,
                               void *parent, int (*parent_new_child)(void *parent, prelude_string_t **child, int pos))
 {
-	preludedb_sql_field_t *field;
-	prelude_string_t *string;
-	int ret;
-
-	ret = preludedb_sql_row_fetch_field(row, index, &field);
-	if ( ret <= 0 )
-		return ret;
-
-	ret = parent_new_child(parent, &string, IDMEF_LIST_APPEND);
-	if ( ret < 0 )
-		return ret;
-
-	ret = prelude_string_set_dup_fast(string,
-					  preludedb_sql_field_get_value(field),
-					  preludedb_sql_field_get_len(field));
-	
-	return (ret < 0) ? ret : 1;
+        preludedb_sql_field_t *field;
+        prelude_string_t *string;
+        int ret;
+
+        ret = preludedb_sql_row_fetch_field(row, index, &field);
+        if ( ret <= 0 )
+                return ret;
+
+        ret = parent_new_child(parent, &string, IDMEF_LIST_APPEND);
+        if ( ret < 0 )
+                return ret;
+
+        ret = prelude_string_set_dup_fast(string,
+                                          preludedb_sql_field_get_value(field),
+                                          preludedb_sql_field_get_len(field));
+
+        return (ret < 0) ? ret : 1;
 }
 
 
 
-static int _get_enum(preludedb_sql_t *sql, preludedb_sql_row_t *row, 
-		     int index,
-		     void *parent, int (*parent_new_child)(void *parent, int **child), int (*convert_enum)(const char *))
+static int _get_enum(preludedb_sql_t *sql, preludedb_sql_row_t *row,
+                     int index,
+                     void *parent, int (*parent_new_child)(void *parent, int **child), int (*convert_enum)(const char *))
 {
-	preludedb_sql_field_t *field;
-	int *enum_val;
-	int ret;
+        preludedb_sql_field_t *field;
+        int *enum_val;
+        int ret;
 
-	ret = preludedb_sql_row_fetch_field(row, index, &field);
-	if ( ret <= 0 )
-		return ret;
+        ret = preludedb_sql_row_fetch_field(row, index, &field);
+        if ( ret <= 0 )
+                return ret;
 
-	ret = parent_new_child(parent, &enum_val);
-	if ( ret < 0 )
-		return ret;
+        ret = parent_new_child(parent, &enum_val);
+        if ( ret < 0 )
+                return ret;
 
-	*enum_val = convert_enum(preludedb_sql_field_get_value(field));
+        *enum_val = convert_enum(preludedb_sql_field_get_value(field));
 
-	return 1;
+        return 1;
 }
 
 
 
 static int _get_timestamp(preludedb_sql_t *sql, preludedb_sql_row_t *row,
-			  int time_index, int gmtoff_index, int usec_index,
-			  void *parent, int (*parent_new_child)(void *parent, idmef_time_t **child))
+                          int time_index, int gmtoff_index, int usec_index,
+                          void *parent, int (*parent_new_child)(void *parent, idmef_time_t **child))
 {
-	preludedb_sql_field_t *time_field, *gmtoff_field, *usec_field = NULL;
-	const char *tmp;
-	int32_t gmtoff;
-	uint32_t usec = 0;
-	idmef_time_t *time;
-	int ret;
-
-	ret = preludedb_sql_row_fetch_field(row, time_index, &time_field);
-	if ( ret <= 0 )
-		return ret;
-
-	ret = preludedb_sql_row_fetch_field(row, gmtoff_index, &gmtoff_field);
-	if ( ret <= 0 )
-		return (ret < 0) ? ret : -1;
-
-	if ( usec_index != -1 ) {
-		ret = preludedb_sql_row_fetch_field(row, usec_index, &usec_field);
-		if ( ret <= 0 )
-			return (ret < 0) ? ret : -1;
-
-		ret = preludedb_sql_field_to_uint32(usec_field, &usec);
-		if ( ret < 0 )
-			return ret;
-	}
-
-	tmp = preludedb_sql_field_get_value(time_field);
-
-	ret = preludedb_sql_field_to_int32(gmtoff_field, &gmtoff);
-	if ( ret < 0 )
-		return ret;
-	
-	ret = parent_new_child(parent, &time);
-	if ( ret < 0 )
-		return ret;
-
-	return preludedb_sql_time_from_timestamp(time, tmp, gmtoff, usec);
+        preludedb_sql_field_t *time_field, *gmtoff_field, *usec_field = NULL;
+        const char *tmp;
+        int32_t gmtoff;
+        uint32_t usec = 0;
+        idmef_time_t *time;
+        int ret;
+
+        ret = preludedb_sql_row_fetch_field(row, time_index, &time_field);
+        if ( ret <= 0 )
+                return ret;
+
+        ret = preludedb_sql_row_fetch_field(row, gmtoff_index, &gmtoff_field);
+        if ( ret <= 0 )
+                return (ret < 0) ? ret : -1;
+
+        if ( usec_index != -1 ) {
+                ret = preludedb_sql_row_fetch_field(row, usec_index, &usec_field);
+                if ( ret <= 0 )
+                        return (ret < 0) ? ret : -1;
+
+                ret = preludedb_sql_field_to_uint32(usec_field, &usec);
+                if ( ret < 0 )
+                        return ret;
+        }
+
+        tmp = preludedb_sql_field_get_value(time_field);
+
+        ret = preludedb_sql_field_to_int32(gmtoff_field, &gmtoff);
+        if ( ret < 0 )
+                return ret;
+
+        ret = parent_new_child(parent, &time);
+        if ( ret < 0 )
+                return ret;
+
+        return preludedb_sql_time_from_timestamp(time, tmp, gmtoff, usec);
 }
 
 #define get_string(sql, row, index, parent, parent_new_child) \
-	_get_string(sql, row, index, parent, (int (*)(void *, prelude_string_t **)) parent_new_child)
+        _get_string(sql, row, index, parent, (int (*)(void *, prelude_string_t **)) parent_new_child)
 
 #define get_string_listed(sql, row, index, parent, parent_new_child) \
-	_get_string_listed(sql, row, index, parent, (int (*)(void *, prelude_string_t **, int)) parent_new_child)
+        _get_string_listed(sql, row, index, parent, (int (*)(void *, prelude_string_t **, int)) parent_new_child)
 
 #define get_enum(sql, row, index, parent, parent_new_child, convert_enum) \
-	_get_enum(sql, row, index, parent, (int (*)(void *, int **)) parent_new_child, convert_enum)
+        _get_enum(sql, row, index, parent, (int (*)(void *, int **)) parent_new_child, convert_enum)
 
 #define get_timestamp(sql, row, time_index, gmtoff_index, usec_index, parent, parent_new_child) \
-	_get_timestamp(sql, row, time_index, gmtoff_index, usec_index, parent, (int (*)(void *, idmef_time_t **)) parent_new_child)
+        _get_timestamp(sql, row, time_index, gmtoff_index, usec_index, parent, (int (*)(void *, idmef_time_t **)) parent_new_child)
 
 
 
 static int get_analyzer_time(preludedb_sql_t *sql,
-			     uint64_t message_ident,
-			     char parent_type,
-			     void *parent,
-			     int (*parent_new_child)(void *parent, idmef_time_t **child))
+                             uint64_t message_ident,
+                             char parent_type,
+                             void *parent,
+                             int (*parent_new_child)(void *parent, idmef_time_t **child))
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	int ret;
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        int ret;
 
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT time, gmtoff, usec "
-					  "FROM Prelude_AnalyzerTime "
-					  "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 "",
-					  parent_type, message_ident);
-	if ( ret <= 0 )
-		return ret;
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT time, gmtoff, usec "
+                                          "FROM Prelude_AnalyzerTime "
+                                          "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 "",
+                                          parent_type, message_ident);
+        if ( ret <= 0 )
+                return ret;
 
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
 
-	ret = get_timestamp(sql, row, 0, 1, 2, parent, parent_new_child);
+        ret = get_timestamp(sql, row, 0, 1, 2, parent, parent_new_child);
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_detect_time(preludedb_sql_t *sql,
-			   uint64_t message_ident,
-			   idmef_alert_t *alert)
+                           uint64_t message_ident,
+                           idmef_alert_t *alert)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT time, gmtoff, usec "
-					  "FROM Prelude_DetectTime "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64 "",
-					  message_ident);
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT time, gmtoff, usec "
+                                          "FROM Prelude_DetectTime "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64 "",
+                                          message_ident);
 
-	if ( ret <= 0 )
-		return ret;
+        if ( ret <= 0 )
+                return ret;
 
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
 
-	ret = get_timestamp(sql, row, 0, 1, 2, alert, idmef_alert_new_detect_time);
+        ret = get_timestamp(sql, row, 0, 1, 2, alert, idmef_alert_new_detect_time);
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_create_time(preludedb_sql_t *sql,
-			   uint64_t message_ident,
-			   char parent_type,
-			   void *parent,
-			   int (*parent_new_child)(void *parent, idmef_time_t **time))
+                           uint64_t message_ident,
+                           char parent_type,
+                           void *parent,
+                           int (*parent_new_child)(void *parent, idmef_time_t **time))
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	int ret;
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        int ret;
 
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					 "SELECT time, gmtoff, usec "
-					 "FROM Prelude_CreateTime "
-					 "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 "",
-					 parent_type, message_ident);
-	if ( ret <= 0 )
-		return ret;
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                         "SELECT time, gmtoff, usec "
+                                         "FROM Prelude_CreateTime "
+                                         "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 "",
+                                         parent_type, message_ident);
+        if ( ret <= 0 )
+                return ret;
 
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
 
-	ret = get_timestamp(sql, row, 0, 1, 2, parent, parent_new_child);
+        ret = get_timestamp(sql, row, 0, 1, 2, parent, parent_new_child);
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_user_id(preludedb_sql_t *sql,
-		       uint64_t message_ident,
-		       char parent_type,
-		       int parent_index,
-		       int file_index,
-		       int file_access_index,
-		       void *parent, prelude_bool_t listed,
-		       int (*_parent_new_child)(void *, idmef_user_id_t **child))
+                       uint64_t message_ident,
+                       char parent_type,
+                       int parent_index,
+                       int file_index,
+                       int file_access_index,
+                       void *parent, prelude_bool_t listed,
+                       int (*_parent_new_child)(void *, idmef_user_id_t **child))
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_user_id_t *user_id;
-	int ret;
-        
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT ident, type, name, number, tty "
-					  "FROM Prelude_UserId "
-					  "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND "
-					  "_parent0_index = %d AND _parent1_index = %d AND _parent2_index = %d AND _index != -1 "
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_user_id_t *user_id;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT ident, type, name, number, tty "
+                                          "FROM Prelude_UserId "
+                                          "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND "
+                                          "_parent0_index = %d AND _parent1_index = %d AND _parent2_index = %d AND _index != -1 "
                                           "ORDER BY _index ASC",
-					  parent_type, message_ident, parent_index, file_index, file_access_index);
-	if ( ret <= 0 )
-		return ret;
+                                          parent_type, message_ident, parent_index, file_index, file_access_index);
+        if ( ret <= 0 )
+                return ret;
 
-	while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
+        while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
 
                 if ( listed ) {
                         int (*parent_new_child)(void *parent, idmef_user_id_t **, int) =
@@ -333,1844 +333,1844 @@ static int get_user_id(preludedb_sql_t *sql,
                         int (*parent_new_child)(void *parent, idmef_user_id_t **) = _parent_new_child;
                         ret = parent_new_child(parent, &user_id);
                 }
-                
-                if ( ret < 0 )
-			goto error;
-
-		ret = get_string(sql, row, 0, user_id, idmef_user_id_new_ident);
-		if ( ret < 0 )
-			goto error;
-
-		ret = get_enum(sql, row, 1, user_id, idmef_user_id_new_type, idmef_user_id_type_to_numeric);
-		if ( ret < 0 )
-			goto error;
-
-		ret = get_string(sql, row, 2, user_id, idmef_user_id_new_name);
-		if ( ret < 0 )
-			goto error;
-                
-		ret = get_uint32(sql, row, 3, user_id, idmef_user_id_new_number);
-		if ( ret < 0 )
-			goto error;
-                
+
+                if ( ret < 0 )
+                        goto error;
+
+                ret = get_string(sql, row, 0, user_id, idmef_user_id_new_ident);
+                if ( ret < 0 )
+                        goto error;
+
+                ret = get_enum(sql, row, 1, user_id, idmef_user_id_new_type, idmef_user_id_type_to_numeric);
+                if ( ret < 0 )
+                        goto error;
+
+                ret = get_string(sql, row, 2, user_id, idmef_user_id_new_name);
+                if ( ret < 0 )
+                        goto error;
+
+                ret = get_uint32(sql, row, 3, user_id, idmef_user_id_new_number);
+                if ( ret < 0 )
+                        goto error;
+
                 ret = get_string(sql, row, 4, user_id, idmef_user_id_new_tty);
-		if ( ret < 0 )
-			goto error;
-	}
+                if ( ret < 0 )
+                        goto error;
+        }
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_user(preludedb_sql_t *sql,
-		    uint64_t message_ident,
-		    char parent_type,
-		    int parent_index,
-		    void *parent,
-		    int (*parent_new_child)(void *parent, idmef_user_t **child))
+                    uint64_t message_ident,
+                    char parent_type,
+                    int parent_index,
+                    void *parent,
+                    int (*parent_new_child)(void *parent, idmef_user_t **child))
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_user_t *user;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT ident, category "
-					  "FROM Prelude_User "
-					  "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d",
-					  parent_type, message_ident, parent_index);
-	if ( ret <= 0 )
-		return ret;
-
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
-
-	ret = parent_new_child(parent, &user);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 0, user, idmef_user_new_ident);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_enum(sql, row, 1, user, idmef_user_new_category, idmef_user_category_to_numeric);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_user_id(sql, message_ident, parent_type, parent_index, 0, 0, user,
-			  TRUE, (int (*)(void *, idmef_user_id_t **)) idmef_user_new_user_id);
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_user_t *user;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT ident, category "
+                                          "FROM Prelude_User "
+                                          "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d",
+                                          parent_type, message_ident, parent_index);
+        if ( ret <= 0 )
+                return ret;
+
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
+
+        ret = parent_new_child(parent, &user);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 0, user, idmef_user_new_ident);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_enum(sql, row, 1, user, idmef_user_new_category, idmef_user_category_to_numeric);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_user_id(sql, message_ident, parent_type, parent_index, 0, 0, user,
+                          TRUE, (int (*)(void *, idmef_user_id_t **)) idmef_user_new_user_id);
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_process_arg(preludedb_sql_t *sql,
-			   uint64_t message_ident,
-			   char parent_type,
-			   char parent_index,
-			   void *parent,
-			   int (*parent_new_child)(void *parent, prelude_string_t **child, int pos))
+                           uint64_t message_ident,
+                           char parent_type,
+                           char parent_index,
+                           void *parent,
+                           int (*parent_new_child)(void *parent, prelude_string_t **child, int pos))
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT arg "
-					  "FROM Prelude_ProcessArg "
-					  "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT arg "
+                                          "FROM Prelude_ProcessArg "
+                                          "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64
                                           " AND _parent0_index = %d AND _index != -1 ORDER BY _index ASC",
-					  parent_type, message_ident, parent_index);
-	if ( ret <= 0 )
-		return ret;
+                                          parent_type, message_ident, parent_index);
+        if ( ret <= 0 )
+                return ret;
 
-	while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
+        while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
 
-		ret = get_string_listed(sql, row, 0, parent, parent_new_child);
-		if ( ret < 0 )
-			goto error;
-	}
+                ret = get_string_listed(sql, row, 0, parent, parent_new_child);
+                if ( ret < 0 )
+                        goto error;
+        }
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_process_env(preludedb_sql_t *sql,
-			   uint64_t message_ident,
-			   char parent_type,
-			   int parent_index,
-			   void *parent,
-			   int (*parent_new_child)(void *parent, prelude_string_t **child, int pos))
+                           uint64_t message_ident,
+                           char parent_type,
+                           int parent_index,
+                           void *parent,
+                           int (*parent_new_child)(void *parent, prelude_string_t **child, int pos))
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT env "
-					  "FROM Prelude_ProcessEnv "
-					  "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT env "
+                                          "FROM Prelude_ProcessEnv "
+                                          "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64
                                           " AND _parent0_index = %d AND _index != -1 ORDER BY _index ASC",
-					  parent_type, message_ident, parent_index);
-	if ( ret <= 0 )
-		return ret;
+                                          parent_type, message_ident, parent_index);
+        if ( ret <= 0 )
+                return ret;
 
-	while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
+        while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
 
-		ret = get_string_listed(sql, row, 0, parent, parent_new_child);
-		if ( ret < 0 )
-			goto error;
-	}
+                ret = get_string_listed(sql, row, 0, parent, parent_new_child);
+                if ( ret < 0 )
+                        goto error;
+        }
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_process(preludedb_sql_t *sql,
-		       uint64_t message_ident,
-		       char parent_type,
-		       int parent_index,
-		       void *parent,
-		       int (*parent_new_child)(void *parent, idmef_process_t **child))
+                       uint64_t message_ident,
+                       char parent_type,
+                       int parent_index,
+                       void *parent,
+                       int (*parent_new_child)(void *parent, idmef_process_t **child))
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_process_t *process;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT ident, name, pid, path "
-					  "FROM Prelude_Process "
-					  "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d",
-					  parent_type, message_ident, parent_index);
-	if ( ret <= 0 )
-		return ret;
-
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
-
-	ret = parent_new_child(parent, &process);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 0, process, idmef_process_new_ident);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 1, process, idmef_process_new_name);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_uint32(sql, row, 2, process, idmef_process_new_pid);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 3, process, idmef_process_new_path);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_process_arg(sql, message_ident, parent_type, parent_index, process,
-			      (int (*)(void *, prelude_string_t **, int)) idmef_process_new_arg);
-	if ( ret < 0 )
-		goto error;
-	
-	ret = get_process_env(sql, message_ident, parent_type, parent_index, process,
-			      (int (*)(void *, prelude_string_t **, int)) idmef_process_new_env);
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_process_t *process;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT ident, name, pid, path "
+                                          "FROM Prelude_Process "
+                                          "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d",
+                                          parent_type, message_ident, parent_index);
+        if ( ret <= 0 )
+                return ret;
+
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
+
+        ret = parent_new_child(parent, &process);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 0, process, idmef_process_new_ident);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 1, process, idmef_process_new_name);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_uint32(sql, row, 2, process, idmef_process_new_pid);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 3, process, idmef_process_new_path);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_process_arg(sql, message_ident, parent_type, parent_index, process,
+                              (int (*)(void *, prelude_string_t **, int)) idmef_process_new_arg);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_process_env(sql, message_ident, parent_type, parent_index, process,
+                              (int (*)(void *, prelude_string_t **, int)) idmef_process_new_env);
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_web_service_arg(preludedb_sql_t *sql,
-			       uint64_t message_ident,
-			       char parent_type,
-			       int parent_index,
-			       idmef_web_service_t *web_service)
+                               uint64_t message_ident,
+                               char parent_type,
+                               int parent_index,
+                               idmef_web_service_t *web_service)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT arg "
-					  "FROM Prelude_WebServiceArg "
-					  "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT arg "
+                                          "FROM Prelude_WebServiceArg "
+                                          "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64
                                           " AND _parent0_index = %d AND _index != -1 ORDER BY _index ASC",
-					  parent_type, message_ident, parent_index);
-	if ( ret <= 0 )
-		return ret;
+                                          parent_type, message_ident, parent_index);
+        if ( ret <= 0 )
+                return ret;
 
-	while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
+        while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
 
-		ret = get_string_listed(sql, row, 0, web_service, idmef_web_service_new_arg);
-		if ( ret < 0 )
-			goto error;
-	}
+                ret = get_string_listed(sql, row, 0, web_service, idmef_web_service_new_arg);
+                if ( ret < 0 )
+                        goto error;
+        }
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_web_service(preludedb_sql_t *sql,
-			   uint64_t message_ident,
-			   char parent_type,
-			   int parent_index,
-			   idmef_service_t *service)
+                           uint64_t message_ident,
+                           char parent_type,
+                           int parent_index,
+                           idmef_service_t *service)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_web_service_t *web_service;
-	int ret;
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_web_service_t *web_service;
+        int ret;
 
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT url, cgi, http_method "
-					  "FROM Prelude_WebService "
-					  "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d",
-					  parent_type, message_ident, parent_index);
-	if ( ret <= 0 )
-		return ret;
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT url, cgi, http_method "
+                                          "FROM Prelude_WebService "
+                                          "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d",
+                                          parent_type, message_ident, parent_index);
+        if ( ret <= 0 )
+                return ret;
 
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
 
-	ret = idmef_service_new_web_service(service, &web_service);
-	if ( ret < 0 )
-		goto error;
+        ret = idmef_service_new_web_service(service, &web_service);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_string(sql, row, 0, web_service, idmef_web_service_new_url);
-	if ( ret < 0 )
-		goto error;
+        ret = get_string(sql, row, 0, web_service, idmef_web_service_new_url);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_string(sql, row, 1, web_service, idmef_web_service_new_cgi);
-	if ( ret < 0 )
-		goto error;
+        ret = get_string(sql, row, 1, web_service, idmef_web_service_new_cgi);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_string(sql, row, 2, web_service, idmef_web_service_new_http_method);
-	if ( ret < 0 )
-		goto error;
+        ret = get_string(sql, row, 2, web_service, idmef_web_service_new_http_method);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_web_service_arg(sql, message_ident, parent_type, parent_index, web_service);
+        ret = get_web_service_arg(sql, message_ident, parent_type, parent_index, web_service);
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_snmp_service(preludedb_sql_t *sql,
-			    uint64_t message_ident,
-			    char parent_type,
-			    int parent_index,
-			    idmef_service_t *service)
+                            uint64_t message_ident,
+                            char parent_type,
+                            int parent_index,
+                            idmef_service_t *service)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_snmp_service_t *snmp_service;
-	int ret;
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_snmp_service_t *snmp_service;
+        int ret;
 
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT snmp_oid, message_processing_model, security_model, security_name, "
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT snmp_oid, message_processing_model, security_model, security_name, "
                                           "security_level, context_name, context_engine_id, command "
-					  "FROM Prelude_SnmpService "
-					  "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d",
-					  parent_type, message_ident, parent_index);
-	if ( ret <= 0 )
-		return ret;
+                                          "FROM Prelude_SnmpService "
+                                          "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d",
+                                          parent_type, message_ident, parent_index);
+        if ( ret <= 0 )
+                return ret;
 
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
 
-	ret = idmef_service_new_snmp_service(service, &snmp_service);
-	if ( ret < 0 )
-		goto error;
+        ret = idmef_service_new_snmp_service(service, &snmp_service);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_string(sql, row, 0, snmp_service, idmef_snmp_service_new_oid);
-	if ( ret < 0 )
-		goto error;
+        ret = get_string(sql, row, 0, snmp_service, idmef_snmp_service_new_oid);
+        if ( ret < 0 )
+                goto error;
 
         ret = get_uint32(sql, row, 1, snmp_service, idmef_snmp_service_new_message_processing_model);
-	if ( ret < 0 )
-		goto error;
+        if ( ret < 0 )
+                goto error;
 
         ret = get_uint32(sql, row, 2, snmp_service, idmef_snmp_service_new_security_model);
-	if ( ret < 0 )
-		goto error;
-        
-	ret = get_string(sql, row, 3, snmp_service, idmef_snmp_service_new_security_name);
-	if ( ret < 0 )
-		goto error;
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 3, snmp_service, idmef_snmp_service_new_security_name);
+        if ( ret < 0 )
+                goto error;
 
         ret = get_uint32(sql, row, 4, snmp_service, idmef_snmp_service_new_security_level);
-	if ( ret < 0 )
-		goto error;
-        
-	ret = get_string(sql, row, 5, snmp_service, idmef_snmp_service_new_context_name);
-	if ( ret < 0 )
-		goto error;
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_string(sql, row, 6, snmp_service, idmef_snmp_service_new_context_engine_id);
-	if ( ret < 0 )
-		goto error;
+        ret = get_string(sql, row, 5, snmp_service, idmef_snmp_service_new_context_name);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_string(sql, row, 7, snmp_service, idmef_snmp_service_new_command);
+        ret = get_string(sql, row, 6, snmp_service, idmef_snmp_service_new_context_engine_id);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 7, snmp_service, idmef_snmp_service_new_command);
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_service(preludedb_sql_t *sql,
-		       uint64_t message_ident,
-		       char parent_type,
-		       int parent_index,
-		       void *parent,
-		       int (*parent_new_child)(void *parent, idmef_service_t **child))
+                       uint64_t message_ident,
+                       char parent_type,
+                       int parent_index,
+                       void *parent,
+                       int (*parent_new_child)(void *parent, idmef_service_t **child))
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_service_t *service;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT ident, ip_version, name, port, iana_protocol_number, iana_protocol_name, portlist, protocol "
-					  "FROM Prelude_Service "
-					  "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d",
-					  parent_type, message_ident, parent_index);
-	if ( ret <= 0 )
-		return 0;
-
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
-
-	ret = parent_new_child(parent, &service);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 0, service, idmef_service_new_ident);
-	if ( ret < 0 )
-		goto error;
-        
-	ret = get_uint8(sql, row, 1, service, idmef_service_new_ip_version);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 2, service, idmef_service_new_name);
-	if ( ret < 0 )	     
-		goto error;
-
-	ret = get_uint16(sql, row, 3, service, idmef_service_new_port);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_uint8(sql, row, 4, service, idmef_service_new_iana_protocol_number);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 5, service, idmef_service_new_iana_protocol_name);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 6, service, idmef_service_new_portlist);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 7, service, idmef_service_new_protocol);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_web_service(sql, message_ident, parent_type, parent_index, service);
-	if ( ret < 0 )	     
-		goto error;
-
-	ret = get_snmp_service(sql, message_ident, parent_type, parent_index, service);
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_service_t *service;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT ident, ip_version, name, port, iana_protocol_number, iana_protocol_name, portlist, protocol "
+                                          "FROM Prelude_Service "
+                                          "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d",
+                                          parent_type, message_ident, parent_index);
+        if ( ret <= 0 )
+                return 0;
+
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
+
+        ret = parent_new_child(parent, &service);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 0, service, idmef_service_new_ident);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_uint8(sql, row, 1, service, idmef_service_new_ip_version);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 2, service, idmef_service_new_name);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_uint16(sql, row, 3, service, idmef_service_new_port);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_uint8(sql, row, 4, service, idmef_service_new_iana_protocol_number);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 5, service, idmef_service_new_iana_protocol_name);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 6, service, idmef_service_new_portlist);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 7, service, idmef_service_new_protocol);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_web_service(sql, message_ident, parent_type, parent_index, service);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_snmp_service(sql, message_ident, parent_type, parent_index, service);
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_address(preludedb_sql_t *sql,
-		       uint64_t message_ident,
-		       char parent_type,
-		       int parent_index,
-		       void *parent,
-		       int (*parent_new_child)(void *parent, idmef_address_t **child, int pos))
+                       uint64_t message_ident,
+                       char parent_type,
+                       int parent_index,
+                       void *parent,
+                       int (*parent_new_child)(void *parent, idmef_address_t **child, int pos))
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_address_t *idmef_address;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT ident, category, vlan_name, vlan_num, address, netmask "
-					  "FROM Prelude_Address "
-					  "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_address_t *idmef_address;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT ident, category, vlan_name, vlan_num, address, netmask "
+                                          "FROM Prelude_Address "
+                                          "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64
                                           " AND _parent0_index = %d AND _index != -1 ORDER BY _index ASC",
-					  parent_type, message_ident, parent_index);
-	if ( ret <= 0 )
-		return ret;
+                                          parent_type, message_ident, parent_index);
+        if ( ret <= 0 )
+                return ret;
 
-	while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
+        while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
 
-		ret = parent_new_child(parent, &idmef_address, IDMEF_LIST_APPEND);
-		if ( ret < 0 )
-			goto error;
+                ret = parent_new_child(parent, &idmef_address, IDMEF_LIST_APPEND);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 0, idmef_address, idmef_address_new_ident);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 0, idmef_address, idmef_address_new_ident);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_enum(sql, row, 1, idmef_address, idmef_address_new_category, idmef_address_category_to_numeric);
-		if ( ret < 0 )
-			goto error;
+                ret = get_enum(sql, row, 1, idmef_address, idmef_address_new_category, idmef_address_category_to_numeric);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 2, idmef_address, idmef_address_new_vlan_name);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 2, idmef_address, idmef_address_new_vlan_name);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_uint32(sql, row, 3, idmef_address, idmef_address_new_vlan_num);
-		if ( ret < 0 )
-			goto error;
+                ret = get_uint32(sql, row, 3, idmef_address, idmef_address_new_vlan_num);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 4, idmef_address, idmef_address_new_address);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 4, idmef_address, idmef_address_new_address);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 5, idmef_address, idmef_address_new_netmask);
-		if ( ret < 0 )
-			goto error;
-	}
+                ret = get_string(sql, row, 5, idmef_address, idmef_address_new_netmask);
+                if ( ret < 0 )
+                        goto error;
+        }
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_node(preludedb_sql_t *sql,
-		    uint64_t message_ident,
-		    char parent_type,
-		    int parent_index,
-		    void *parent,
-		    int (*parent_new_child)(void *parent, idmef_node_t **node))
+                    uint64_t message_ident,
+                    char parent_type,
+                    int parent_index,
+                    void *parent,
+                    int (*parent_new_child)(void *parent, idmef_node_t **node))
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_node_t *node;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT ident, category, location, name "
-					  "FROM Prelude_Node "
-					  "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d",
-					  parent_type, message_ident, parent_index);
-	if ( ret <= 0 )
-		return ret;
-
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
-
-	ret = parent_new_child(parent, &node);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 0, node, idmef_node_new_ident);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_enum(sql, row, 1, node, idmef_node_new_category, idmef_node_category_to_numeric);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 2, node, idmef_node_new_location);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 3, node, idmef_node_new_name);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_address(sql, message_ident, parent_type, parent_index, node,
-			  (int (*)(void *, idmef_address_t **, int)) idmef_node_new_address);
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_node_t *node;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT ident, category, location, name "
+                                          "FROM Prelude_Node "
+                                          "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d",
+                                          parent_type, message_ident, parent_index);
+        if ( ret <= 0 )
+                return ret;
+
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
+
+        ret = parent_new_child(parent, &node);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 0, node, idmef_node_new_ident);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_enum(sql, row, 1, node, idmef_node_new_category, idmef_node_category_to_numeric);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 2, node, idmef_node_new_location);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 3, node, idmef_node_new_name);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_address(sql, message_ident, parent_type, parent_index, node,
+                          (int (*)(void *, idmef_address_t **, int)) idmef_node_new_address);
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_analyzer(preludedb_sql_t *sql,
-			uint64_t message_ident,
-			char parent_type,
-			void *parent,
-			int (*parent_new_child)(void *parent, idmef_analyzer_t **child, int pos))
+                        uint64_t message_ident,
+                        char parent_type,
+                        void *parent,
+                        int (*parent_new_child)(void *parent, idmef_analyzer_t **child, int pos))
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_analyzer_t *analyzer;
-	int ret;
-	int index;
-	
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT analyzerid, name, manufacturer, model, version, class, ostype, osversion "
-					  "FROM Prelude_Analyzer "
-					  "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND _index != -1 "
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_analyzer_t *analyzer;
+        int ret;
+        int index;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT analyzerid, name, manufacturer, model, version, class, ostype, osversion "
+                                          "FROM Prelude_Analyzer "
+                                          "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND _index != -1 "
                                           "ORDER BY _index ASC",
-					  parent_type, message_ident);
-	if ( ret <= 0 )
-		return ret;
+                                          parent_type, message_ident);
+        if ( ret <= 0 )
+                return ret;
 
-	index = 0;
-	while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
-		ret = parent_new_child(parent, &analyzer, IDMEF_LIST_APPEND);
-		if ( ret < 0 )
-			goto error;
+        index = 0;
+        while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
+                ret = parent_new_child(parent, &analyzer, IDMEF_LIST_APPEND);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 0, analyzer, idmef_analyzer_new_analyzerid);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 0, analyzer, idmef_analyzer_new_analyzerid);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 1, analyzer, idmef_analyzer_new_name);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 1, analyzer, idmef_analyzer_new_name);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 2, analyzer, idmef_analyzer_new_manufacturer);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 2, analyzer, idmef_analyzer_new_manufacturer);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 3, analyzer, idmef_analyzer_new_model);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 3, analyzer, idmef_analyzer_new_model);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 4, analyzer, idmef_analyzer_new_version);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 4, analyzer, idmef_analyzer_new_version);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 5, analyzer, idmef_analyzer_new_class);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 5, analyzer, idmef_analyzer_new_class);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 6, analyzer, idmef_analyzer_new_ostype);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 6, analyzer, idmef_analyzer_new_ostype);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 7, analyzer, idmef_analyzer_new_osversion);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 7, analyzer, idmef_analyzer_new_osversion);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_node(sql, message_ident, parent_type, index, analyzer,
-			       (int (*)(void *, idmef_node_t **)) idmef_analyzer_new_node);
-		if ( ret < 0 )
-			goto error;
+                ret = get_node(sql, message_ident, parent_type, index, analyzer,
+                               (int (*)(void *, idmef_node_t **)) idmef_analyzer_new_node);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_process(sql, message_ident, parent_type, index, analyzer,
-				  (int (*)(void *, idmef_process_t **)) idmef_analyzer_new_process);
-		if ( ret < 0 )
-			goto error;
+                ret = get_process(sql, message_ident, parent_type, index, analyzer,
+                                  (int (*)(void *, idmef_process_t **)) idmef_analyzer_new_process);
+                if ( ret < 0 )
+                        goto error;
 
-		index++;
-	}
+                index++;
+        }
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_action(preludedb_sql_t *sql,
-		      uint64_t message_ident,
-		      idmef_assessment_t *assessment)
+                      uint64_t message_ident,
+                      idmef_assessment_t *assessment)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_action_t *action;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT category, description "
-					  "FROM Prelude_Action "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64 " AND _index != -1 "
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_action_t *action;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT category, description "
+                                          "FROM Prelude_Action "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64 " AND _index != -1 "
                                           "ORDER BY _index ASC",
-					  message_ident);
-	if ( ret <= 0 )
-		return ret;
+                                          message_ident);
+        if ( ret <= 0 )
+                return ret;
 
-	while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
+        while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
 
-		ret = idmef_assessment_new_action(assessment, &action, IDMEF_LIST_APPEND);
-		if ( ret < 0 )
-			return ret;
+                ret = idmef_assessment_new_action(assessment, &action, IDMEF_LIST_APPEND);
+                if ( ret < 0 )
+                        return ret;
 
-		ret = get_enum(sql, row, 0, action, idmef_action_new_category, idmef_action_category_to_numeric);
-		if ( ret < 0 )
-			goto error;
+                ret = get_enum(sql, row, 0, action, idmef_action_new_category, idmef_action_category_to_numeric);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 1, action, idmef_action_new_description);
-		if ( ret < 0 )
-			goto error;
-	}
+                ret = get_string(sql, row, 1, action, idmef_action_new_description);
+                if ( ret < 0 )
+                        goto error;
+        }
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;	
+        return ret;
 }
 
 static int get_confidence(preludedb_sql_t *sql,
-			  uint64_t message_ident,
-			  idmef_assessment_t *assessment)
+                          uint64_t message_ident,
+                          idmef_assessment_t *assessment)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_confidence_t *confidence;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT rating, confidence "
-					  "FROM Prelude_Confidence "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64 "",
-					  message_ident);
-	if ( ret <= 0 )
-		return ret;
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_confidence_t *confidence;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT rating, confidence "
+                                          "FROM Prelude_Confidence "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64 "",
+                                          message_ident);
+        if ( ret <= 0 )
+                return ret;
 
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
 
-	ret = idmef_assessment_new_confidence(assessment, &confidence);
-	if ( ret < 0 )
-		goto error;
+        ret = idmef_assessment_new_confidence(assessment, &confidence);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_enum(sql, row, 0, confidence, idmef_confidence_new_rating, idmef_confidence_rating_to_numeric);
-	if ( ret < 0 )
-		goto error;
+        ret = get_enum(sql, row, 0, confidence, idmef_confidence_new_rating, idmef_confidence_rating_to_numeric);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_float(sql, row, 1, confidence, idmef_confidence_new_confidence);
+        ret = get_float(sql, row, 1, confidence, idmef_confidence_new_confidence);
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
-static int get_impact(preludedb_sql_t *sql, 
-		      uint64_t message_ident, 
-		      idmef_assessment_t *assessment)
+static int get_impact(preludedb_sql_t *sql,
+                      uint64_t message_ident,
+                      idmef_assessment_t *assessment)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_impact_t *impact;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT severity, completion, type, description "
-					  "FROM Prelude_Impact "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64 "",
-					  message_ident);
-	if ( ret <= 0 )
-		return ret;
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_impact_t *impact;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT severity, completion, type, description "
+                                          "FROM Prelude_Impact "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64 "",
+                                          message_ident);
+        if ( ret <= 0 )
+                return ret;
 
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
 
-	ret = idmef_assessment_new_impact(assessment, &impact);
-	if ( ret < 0 )
-		goto error;
+        ret = idmef_assessment_new_impact(assessment, &impact);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_enum(sql, row, 0, impact, idmef_impact_new_severity, idmef_impact_severity_to_numeric);
-	if ( ret < 0 )
-		goto error;
+        ret = get_enum(sql, row, 0, impact, idmef_impact_new_severity, idmef_impact_severity_to_numeric);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_enum(sql, row, 1, impact, idmef_impact_new_completion, idmef_impact_completion_to_numeric);
-	if ( ret < 0 )
-		goto error;
+        ret = get_enum(sql, row, 1, impact, idmef_impact_new_completion, idmef_impact_completion_to_numeric);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_enum(sql, row, 2, impact, idmef_impact_new_type, idmef_impact_type_to_numeric);
-	if ( ret < 0 )
-		goto error;
+        ret = get_enum(sql, row, 2, impact, idmef_impact_new_type, idmef_impact_type_to_numeric);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_string(sql, row, 3, impact, idmef_impact_new_description);
+        ret = get_string(sql, row, 3, impact, idmef_impact_new_description);
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
-static int get_assessment(preludedb_sql_t *sql, 
-			  uint64_t message_ident,
-			  idmef_alert_t *alert)
+static int get_assessment(preludedb_sql_t *sql,
+                          uint64_t message_ident,
+                          idmef_alert_t *alert)
 {
-	preludedb_sql_table_t *table;
-	idmef_assessment_t *assessment;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT _message_ident "
-					  "FROM Prelude_Assessment "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64 "",
-					  message_ident);
-	if ( ret <= 0 )
-		return ret;
+        preludedb_sql_table_t *table;
+        idmef_assessment_t *assessment;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT _message_ident "
+                                          "FROM Prelude_Assessment "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64 "",
+                                          message_ident);
+        if ( ret <= 0 )
+                return ret;
 
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	ret = idmef_alert_new_assessment(alert, &assessment);
-	if ( ret < 0 )
-		goto error;
+        ret = idmef_alert_new_assessment(alert, &assessment);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_impact(sql, message_ident, assessment);
-	if ( ret < 0 )
-		goto error;
+        ret = get_impact(sql, message_ident, assessment);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_confidence(sql, message_ident, assessment);
-	if ( ret < 0 )
-		goto error;
+        ret = get_confidence(sql, message_ident, assessment);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_action(sql, message_ident, assessment);
-	if ( ret < 0 )
-		goto error;
+        ret = get_action(sql, message_ident, assessment);
+        if ( ret < 0 )
+                goto error;
 
  error:
-	return ret;
+        return ret;
 }
 
 static int get_file_access_permission(preludedb_sql_t *sql,
-				      uint64_t message_ident,
-				      int target_index,
-				      int file_index,
-				      int file_access_index,
-				      idmef_file_access_t *parent)
+                                      uint64_t message_ident,
+                                      int target_index,
+                                      int file_index,
+                                      int file_access_index,
+                                      idmef_file_access_t *parent)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT permission "
-					  "FROM Prelude_FileAccess_Permission "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d AND "
-					  "_parent1_index = %d AND _parent2_index = %d AND _index != -1 "
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT permission "
+                                          "FROM Prelude_FileAccess_Permission "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d AND "
+                                          "_parent1_index = %d AND _parent2_index = %d AND _index != -1 "
                                           "ORDER BY _index ASC",
-					  message_ident, target_index, file_index, file_access_index);
-	if ( ret <= 0 )
-		return ret;
+                                          message_ident, target_index, file_index, file_access_index);
+        if ( ret <= 0 )
+                return ret;
 
-	while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
+        while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
 
-		ret = get_string_listed(sql, row, 0, parent, idmef_file_access_new_permission);
-		if ( ret < 0 )
-			goto error;
-	}
+                ret = get_string_listed(sql, row, 0, parent, idmef_file_access_new_permission);
+                if ( ret < 0 )
+                        goto error;
+        }
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_file_access(preludedb_sql_t *sql,
-			   uint64_t message_ident,
-			   int target_index,
-			   int file_index,
-			   idmef_file_t *file)
+                           uint64_t message_ident,
+                           int target_index,
+                           int file_index,
+                           idmef_file_t *file)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	preludedb_sql_field_t *field;
-	idmef_file_access_t *file_access;
-	uint32_t file_access_count;
-	int cnt;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT COUNT(*) "
-					  "FROM Prelude_FileAccess "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        preludedb_sql_field_t *field;
+        idmef_file_access_t *file_access;
+        uint32_t file_access_count;
+        int cnt;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT COUNT(*) "
+                                          "FROM Prelude_FileAccess "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64
                                           " AND _parent0_index = %d AND _parent1_index = %d AND _index != -1",
                                           message_ident, target_index, file_index);
-	if ( ret <= 0 )
-		return ret;
+        if ( ret <= 0 )
+                return ret;
 
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
 
-	ret = preludedb_sql_row_fetch_field(row, 0, &field);
-	if ( ret <= 0 )
-		goto error;
+        ret = preludedb_sql_row_fetch_field(row, 0, &field);
+        if ( ret <= 0 )
+                goto error;
 
-	ret = preludedb_sql_field_to_uint32(field, &file_access_count);
-	if ( ret < 0 )
-		goto error;
+        ret = preludedb_sql_field_to_uint32(field, &file_access_count);
+        if ( ret < 0 )
+                goto error;
 
-	for ( cnt = 0; cnt < file_access_count; cnt++ ) {
+        for ( cnt = 0; cnt < file_access_count; cnt++ ) {
 
-		ret = idmef_file_new_file_access(file, &file_access, IDMEF_LIST_APPEND);
-		if ( ret < 0 )
-			goto error;
+                ret = idmef_file_new_file_access(file, &file_access, IDMEF_LIST_APPEND);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_user_id(sql, message_ident, 'F', target_index, file_index, cnt,
-				  file_access, FALSE, (int (*)(void *, idmef_user_id_t **)) idmef_file_access_new_user_id);
-		if ( ret < 0 )
-			goto error;
+                ret = get_user_id(sql, message_ident, 'F', target_index, file_index, cnt,
+                                  file_access, FALSE, (int (*)(void *, idmef_user_id_t **)) idmef_file_access_new_user_id);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_file_access_permission(sql, message_ident, target_index, file_index, cnt, file_access);
-		if ( ret < 0 )
-			goto error;
-	}
+                ret = get_file_access_permission(sql, message_ident, target_index, file_index, cnt, file_access);
+                if ( ret < 0 )
+                        goto error;
+        }
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_linkage(preludedb_sql_t *sql,
-		       uint64_t message_ident,
-		       int target_index,
-		       int file_index,
-		       idmef_file_t *file)
+                       uint64_t message_ident,
+                       int target_index,
+                       int file_index,
+                       idmef_file_t *file)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_linkage_t *linkage;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT category, name, path "
-					  "FROM Prelude_Linkage "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_linkage_t *linkage;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT category, name, path "
+                                          "FROM Prelude_Linkage "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64
                                           " AND _parent0_index = %d AND _parent1_index = %d AND _index != -1 "
                                           "ORDER BY _index ASC",
-					  message_ident, target_index, file_index);
-	if ( ret <= 0 )
-		return ret;
+                                          message_ident, target_index, file_index);
+        if ( ret <= 0 )
+                return ret;
 
-	while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
+        while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
 
-		ret = idmef_file_new_linkage(file, &linkage, IDMEF_LIST_APPEND);
-		if ( ret < 0 )
-			goto error;
+                ret = idmef_file_new_linkage(file, &linkage, IDMEF_LIST_APPEND);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_enum(sql, row, 0, linkage, idmef_linkage_new_category, idmef_linkage_category_to_numeric);
-		if ( ret < 0 )
-			goto error;
+                ret = get_enum(sql, row, 0, linkage, idmef_linkage_new_category, idmef_linkage_category_to_numeric);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 1, linkage, idmef_linkage_new_name);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 1, linkage, idmef_linkage_new_name);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 2, linkage, idmef_linkage_new_path);
-		if ( ret < 0 )
-			goto error;
-	}
+                ret = get_string(sql, row, 2, linkage, idmef_linkage_new_path);
+                if ( ret < 0 )
+                        goto error;
+        }
 
-	/* FIXME: file in linkage is not currently supported  */
+        /* FIXME: file in linkage is not currently supported  */
 
  error:
-	preludedb_sql_table_destroy(table);
-	
-	return ret;
+        preludedb_sql_table_destroy(table);
+
+        return ret;
 }
 
 static int get_inode(preludedb_sql_t *sql,
-		     uint64_t message_ident,
-		     int target_index,
-		     int file_index,
-		     idmef_file_t *file)
+                     uint64_t message_ident,
+                     int target_index,
+                     int file_index,
+                     idmef_file_t *file)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_inode_t *inode;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT change_time, change_time_gmtoff, number, major_device, minor_device, "
-					  "c_major_device, c_minor_device "
-					  "FROM Prelude_Inode "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d AND _parent1_index = %d",
-					  message_ident, target_index, file_index);
-	if ( ret <= 0 )
-		return ret;
-
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
-
-	ret = idmef_file_new_inode(file, &inode);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_timestamp(sql, row, 0, 1, -1, inode, idmef_inode_new_change_time);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_uint32(sql, row, 2, inode, idmef_inode_new_number);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_uint32(sql, row, 3, inode, idmef_inode_new_major_device);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_uint32(sql, row, 4, inode, idmef_inode_new_minor_device);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_uint32(sql, row, 5, inode, idmef_inode_new_c_major_device);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_uint32(sql, row, 6, inode, idmef_inode_new_c_minor_device);
-	if ( ret < 0 )
-		goto error;
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_inode_t *inode;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT change_time, change_time_gmtoff, number, major_device, minor_device, "
+                                          "c_major_device, c_minor_device "
+                                          "FROM Prelude_Inode "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d AND _parent1_index = %d",
+                                          message_ident, target_index, file_index);
+        if ( ret <= 0 )
+                return ret;
+
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
+
+        ret = idmef_file_new_inode(file, &inode);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_timestamp(sql, row, 0, 1, -1, inode, idmef_inode_new_change_time);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_uint32(sql, row, 2, inode, idmef_inode_new_number);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_uint32(sql, row, 3, inode, idmef_inode_new_major_device);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_uint32(sql, row, 4, inode, idmef_inode_new_minor_device);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_uint32(sql, row, 5, inode, idmef_inode_new_c_major_device);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_uint32(sql, row, 6, inode, idmef_inode_new_c_minor_device);
+        if ( ret < 0 )
+                goto error;
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 
 static int get_checksum(preludedb_sql_t *sql,
-			uint64_t message_ident,
-			int target_index,
-			int file_index,
-			idmef_file_t *file)
+                        uint64_t message_ident,
+                        int target_index,
+                        int file_index,
+                        idmef_file_t *file)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_checksum_t *checksum;
-	int ret;
-	
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT value, checksum_key, algorithm "
-					  "FROM Prelude_Checksum "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_checksum_t *checksum;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT value, checksum_key, algorithm "
+                                          "FROM Prelude_Checksum "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64
                                           " AND _parent0_index = %d AND _parent1_index = %d AND _index != -1 "
                                           "ORDER BY _index ASC",
-					  message_ident, target_index, file_index);
-	if ( ret <= 0 )
-		return ret;
+                                          message_ident, target_index, file_index);
+        if ( ret <= 0 )
+                return ret;
 
-	while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
+        while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
 
-		ret = idmef_file_new_checksum(file, &checksum, IDMEF_LIST_APPEND);
-		if ( ret < 0 )
-			goto error;
+                ret = idmef_file_new_checksum(file, &checksum, IDMEF_LIST_APPEND);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 0, checksum, idmef_checksum_new_value);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 0, checksum, idmef_checksum_new_value);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 1, checksum, idmef_checksum_new_key);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 1, checksum, idmef_checksum_new_key);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_enum(sql, row, 2, checksum, idmef_checksum_new_algorithm, idmef_checksum_algorithm_to_numeric);
-		if ( ret < 0 )
-			goto error;
-	}
+                ret = get_enum(sql, row, 2, checksum, idmef_checksum_new_algorithm, idmef_checksum_algorithm_to_numeric);
+                if ( ret < 0 )
+                        goto error;
+        }
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 
 static int get_file(preludedb_sql_t *sql,
-		    uint64_t message_ident,
-		    int target_index,
-		    idmef_target_t *target)
+                    uint64_t message_ident,
+                    int target_index,
+                    idmef_target_t *target)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_file_t *file = NULL;
-	int cnt;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT ident, category, name, path, create_time, create_time_gmtoff, "
-					  "modify_time, modify_time_gmtoff, access_time, "
-					  "access_time_gmtoff, data_size, disk_size, fstype, file_type "
-					  "FROM Prelude_File "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d AND _index != -1 "
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_file_t *file = NULL;
+        int cnt;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT ident, category, name, path, create_time, create_time_gmtoff, "
+                                          "modify_time, modify_time_gmtoff, access_time, "
+                                          "access_time_gmtoff, data_size, disk_size, fstype, file_type "
+                                          "FROM Prelude_File "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64 " AND _parent0_index = %d AND _index != -1 "
                                           "ORDER BY _index ASC",
-					  message_ident, target_index);
-	if ( ret <= 0 )
-		return ret;
+                                          message_ident, target_index);
+        if ( ret <= 0 )
+                return ret;
 
-	while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
+        while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
 
-		ret = idmef_target_new_file(target, &file, IDMEF_LIST_APPEND);
-		if ( ret < 0 )
-			goto error;
+                ret = idmef_target_new_file(target, &file, IDMEF_LIST_APPEND);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 0, file, idmef_file_new_ident);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 0, file, idmef_file_new_ident);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_enum(sql, row, 1, file, idmef_file_new_category, idmef_file_category_to_numeric);
-		if ( ret < 0 )
-			goto error;
+                ret = get_enum(sql, row, 1, file, idmef_file_new_category, idmef_file_category_to_numeric);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 2, file, idmef_file_new_name);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 2, file, idmef_file_new_name);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 3, file, idmef_file_new_path);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 3, file, idmef_file_new_path);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_timestamp(sql, row, 4, 5, -1, file, idmef_file_new_create_time);
-		if ( ret < 0 )
-			goto error;
+                ret = get_timestamp(sql, row, 4, 5, -1, file, idmef_file_new_create_time);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_timestamp(sql, row, 6, 7, -1, file, idmef_file_new_modify_time);
-		if ( ret < 0 )
-			goto error;
+                ret = get_timestamp(sql, row, 6, 7, -1, file, idmef_file_new_modify_time);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_timestamp(sql, row, 8, 9, -1, file, idmef_file_new_access_time);
-		if ( ret < 0 )
-			goto error;
+                ret = get_timestamp(sql, row, 8, 9, -1, file, idmef_file_new_access_time);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_uint32(sql, row, 10, file, idmef_file_new_data_size);
-		if ( ret < 0 )
-			goto error;
+                ret = get_uint32(sql, row, 10, file, idmef_file_new_data_size);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_uint32(sql, row, 11, file, idmef_file_new_disk_size);
-		if ( ret < 0 )
-			goto error;
+                ret = get_uint32(sql, row, 11, file, idmef_file_new_disk_size);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_enum(sql, row, 12, file, idmef_file_new_fstype, idmef_file_fstype_to_numeric);
-		if ( ret < 0 )
-			goto error;
+                ret = get_enum(sql, row, 12, file, idmef_file_new_fstype, idmef_file_fstype_to_numeric);
+                if ( ret < 0 )
+                        goto error;
 
                 ret = get_string(sql, row, 13, file, idmef_file_new_file_type);
                 if ( ret < 0 )
                         goto error;
-	}
+        }
 
-	file = NULL;
-	cnt = 0;
-	while ( (file = idmef_target_get_next_file(target, file)) ) {
+        file = NULL;
+        cnt = 0;
+        while ( (file = idmef_target_get_next_file(target, file)) ) {
 
-		ret = get_file_access(sql, message_ident, target_index, cnt, file);
-		if ( ret < 0 )
-			goto error;
+                ret = get_file_access(sql, message_ident, target_index, cnt, file);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_linkage(sql, message_ident, target_index, cnt, file);
-		if ( ret < 0 )
-			goto error;
+                ret = get_linkage(sql, message_ident, target_index, cnt, file);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_inode(sql, message_ident, target_index, cnt, file);
-		if ( ret < 0 )
-			goto error;
+                ret = get_inode(sql, message_ident, target_index, cnt, file);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_checksum(sql, message_ident, target_index, cnt, file);
-		if ( ret < 0 )
-			goto error;
+                ret = get_checksum(sql, message_ident, target_index, cnt, file);
+                if ( ret < 0 )
+                        goto error;
+
+                cnt++;
+        }
 
-		cnt++;
-	}
-	
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_source(preludedb_sql_t *sql,
-		      uint64_t message_ident,
-		      idmef_alert_t *alert)
+                      uint64_t message_ident,
+                      idmef_alert_t *alert)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_source_t *source;
-	int cnt;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT ident, spoofed, interface "
-					  "FROM Prelude_Source "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64 " AND _index != -1 "
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_source_t *source;
+        int cnt;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT ident, spoofed, interface "
+                                          "FROM Prelude_Source "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64 " AND _index != -1 "
                                           "ORDER BY _index ASC",
-					  message_ident);
-	if ( ret <= 0 )
-		return ret;
+                                          message_ident);
+        if ( ret <= 0 )
+                return ret;
 
-	while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
+        while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
 
-		ret = idmef_alert_new_source(alert, &source, IDMEF_LIST_APPEND);
-		if ( ret < 0 )
-			goto error;
+                ret = idmef_alert_new_source(alert, &source, IDMEF_LIST_APPEND);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 0, source, idmef_source_new_ident);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 0, source, idmef_source_new_ident);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_enum(sql, row, 1, source, idmef_source_new_spoofed, idmef_source_spoofed_to_numeric);
-		if ( ret < 0 )
-			goto error;
+                ret = get_enum(sql, row, 1, source, idmef_source_new_spoofed, idmef_source_spoofed_to_numeric);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 2, source, idmef_source_new_interface);
-		if ( ret < 0 )
-			goto error;
-	}
+                ret = get_string(sql, row, 2, source, idmef_source_new_interface);
+                if ( ret < 0 )
+                        goto error;
+        }
 
-	source = NULL;
-	cnt = 0;
-	while ( (source = idmef_alert_get_next_source(alert, source)) ) {
+        source = NULL;
+        cnt = 0;
+        while ( (source = idmef_alert_get_next_source(alert, source)) ) {
 
-		ret = get_node(sql, message_ident, 'S', cnt, source, (int (*)(void *, idmef_node_t **)) idmef_source_new_node);
-		if ( ret < 0 )
-			goto error;
+                ret = get_node(sql, message_ident, 'S', cnt, source, (int (*)(void *, idmef_node_t **)) idmef_source_new_node);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_user(sql, message_ident, 'S', cnt, source, (int (*)(void *, idmef_user_t **)) idmef_source_new_user);
-		if ( ret < 0 )
-			goto error;
+                ret = get_user(sql, message_ident, 'S', cnt, source, (int (*)(void *, idmef_user_t **)) idmef_source_new_user);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_process(sql, message_ident, 'S', cnt, source, (int (*)(void *, idmef_process_t **)) idmef_source_new_process);
-		if ( ret < 0 )
-			goto error;
+                ret = get_process(sql, message_ident, 'S', cnt, source, (int (*)(void *, idmef_process_t **)) idmef_source_new_process);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_service(sql, message_ident, 'S', cnt, source, (int (*)(void *, idmef_service_t **)) idmef_source_new_service);
-		if ( ret < 0 )
-			goto error;
+                ret = get_service(sql, message_ident, 'S', cnt, source, (int (*)(void *, idmef_service_t **)) idmef_source_new_service);
+                if ( ret < 0 )
+                        goto error;
 
-		cnt++;
-	}
+                cnt++;
+        }
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_target(preludedb_sql_t *sql,
-		      uint64_t message_ident,
-		      idmef_alert_t *alert)
+                      uint64_t message_ident,
+                      idmef_alert_t *alert)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_target_t *target;
-	int cnt;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT ident, decoy, interface "
-					  "FROM Prelude_Target "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64 " AND _index != -1 "
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_target_t *target;
+        int cnt;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT ident, decoy, interface "
+                                          "FROM Prelude_Target "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64 " AND _index != -1 "
                                           "ORDER BY _index ASC",
-					  message_ident);
-	if ( ret <= 0 )
-		return ret;
+                                          message_ident);
+        if ( ret <= 0 )
+                return ret;
 
-	while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
+        while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
 
-		ret = idmef_alert_new_target(alert, &target, IDMEF_LIST_APPEND);
-		if ( ret < 0 )
-			goto error;
+                ret = idmef_alert_new_target(alert, &target, IDMEF_LIST_APPEND);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 0, target, idmef_target_new_ident);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 0, target, idmef_target_new_ident);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_enum(sql, row, 1, target, idmef_target_new_decoy, idmef_target_decoy_to_numeric);
-		if ( ret < 0 )
-			goto error;
+                ret = get_enum(sql, row, 1, target, idmef_target_new_decoy, idmef_target_decoy_to_numeric);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 2, target, idmef_target_new_interface);
-		if ( ret < 0 )
-			goto error;
-	}
+                ret = get_string(sql, row, 2, target, idmef_target_new_interface);
+                if ( ret < 0 )
+                        goto error;
+        }
 
-	target = NULL;
-	cnt = 0;
-	while ( (target = idmef_alert_get_next_target(alert, target)) ) {
+        target = NULL;
+        cnt = 0;
+        while ( (target = idmef_alert_get_next_target(alert, target)) ) {
 
-		ret = get_node(sql, message_ident, 'T', cnt, target, (int (*)(void *, idmef_node_t **)) idmef_target_new_node);
-		if ( ret < 0 )		     
-			goto error;
+                ret = get_node(sql, message_ident, 'T', cnt, target, (int (*)(void *, idmef_node_t **)) idmef_target_new_node);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_user(sql, message_ident, 'T', cnt, target, (int (*)(void *, idmef_user_t **)) idmef_target_new_user);
-		if ( ret < 0 )
-			goto error;
+                ret = get_user(sql, message_ident, 'T', cnt, target, (int (*)(void *, idmef_user_t **)) idmef_target_new_user);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_process(sql, message_ident, 'T', cnt, target, (int (*)(void *, idmef_process_t **)) idmef_target_new_process);
-		if ( ret < 0 )
-			goto error;
+                ret = get_process(sql, message_ident, 'T', cnt, target, (int (*)(void *, idmef_process_t **)) idmef_target_new_process);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_service(sql, message_ident, 'T', cnt, target, (int (*)(void *, idmef_service_t **)) idmef_target_new_service);
-		if ( ret < 0 )
-			goto error;
+                ret = get_service(sql, message_ident, 'T', cnt, target, (int (*)(void *, idmef_service_t **)) idmef_target_new_service);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_file(sql, message_ident, cnt, target);
-		if ( ret < 0 )
-			goto error;
+                ret = get_file(sql, message_ident, cnt, target);
+                if ( ret < 0 )
+                        goto error;
 
-		cnt++;
-	}
+                cnt++;
+        }
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_additional_data(preludedb_sql_t *sql,
-			       uint64_t message_ident,
-			       char parent_type,
-			       void *parent,
-			       int (*parent_new_child)(void *, idmef_additional_data_t **, int pos))
+                               uint64_t message_ident,
+                               char parent_type,
+                               void *parent,
+                               int (*parent_new_child)(void *, idmef_additional_data_t **, int pos))
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_additional_data_t *additional_data;
-	idmef_data_t *data;
-	preludedb_sql_field_t *field;
-	int ret = 0;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT type, meaning, data "
-					  "FROM Prelude_AdditionalData "
-					  "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND _index != -1 "
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_additional_data_t *additional_data;
+        idmef_data_t *data;
+        preludedb_sql_field_t *field;
+        int ret = 0;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT type, meaning, data "
+                                          "FROM Prelude_AdditionalData "
+                                          "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64 " AND _index != -1 "
                                           "ORDER BY _index ASC",
-					  parent_type, message_ident);
-	if ( ret <= 0 )
-		return ret;
-
-	while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
-
-		ret = parent_new_child(parent, &additional_data, IDMEF_LIST_APPEND);
-		if ( ret < 0 )
-			goto error;
-
-		ret = get_enum(sql, row, 0, additional_data, idmef_additional_data_new_type,
-			       idmef_additional_data_type_to_numeric);
-		if ( ret < 0 )
-			goto error;
-
-		ret = get_string(sql, row, 1, additional_data, idmef_additional_data_new_meaning);
-		if ( ret < 0 )
-			goto error;
-
-		ret = preludedb_sql_row_fetch_field(row, 2, &field);
-		if ( ret <= 0 )
-			goto error;
-
-		ret = idmef_additional_data_new_data(additional_data, &data);
-		if ( ret < 0 )
-			goto error;
-
-		switch ( idmef_additional_data_get_type(additional_data) ) {
-		case IDMEF_ADDITIONAL_DATA_TYPE_BOOLEAN: case IDMEF_ADDITIONAL_DATA_TYPE_BYTE: {
-			uint8_t value;
-
-			ret = preludedb_sql_field_to_uint8(field, &value);
-			if ( ret < 0 )
-				ret = idmef_data_set_char_string_dup(data, preludedb_sql_field_get_value(field));
-			else
-				idmef_data_set_byte(data, value);
-			
-			break;
-		}
-
-		case IDMEF_ADDITIONAL_DATA_TYPE_CHARACTER: {
-			uint8_t value;
-
-			ret = preludedb_sql_field_to_uint8(field, &value);
-			if ( ret < 0 )
-				ret = idmef_data_set_char_string_dup(data, preludedb_sql_field_get_value(field));
-			else
-				idmef_data_set_char(data, (char) value);
-			
-			break;
-		}
-
-		case IDMEF_ADDITIONAL_DATA_TYPE_DATE_TIME:
-		case IDMEF_ADDITIONAL_DATA_TYPE_PORTLIST:
-		case IDMEF_ADDITIONAL_DATA_TYPE_STRING:
-		case IDMEF_ADDITIONAL_DATA_TYPE_XML:
-			ret = idmef_data_set_char_string_dup(data, preludedb_sql_field_get_value(field));
-			break;
-
-		case IDMEF_ADDITIONAL_DATA_TYPE_REAL: {
-			float value;
-
-			ret = preludedb_sql_field_to_float(field, &value);
-			if ( ret < 0 )
-				ret = idmef_data_set_char_string_dup(data, preludedb_sql_field_get_value(field));
-			else
-				idmef_data_set_float(data, value);
-
-			break;
-		}
-
-		case IDMEF_ADDITIONAL_DATA_TYPE_INTEGER: {
-			uint32_t value;
-
-			ret = preludedb_sql_field_to_uint32(field, &value);
-			if ( ret < 0 )
-				ret = idmef_data_set_char_string_dup(data, preludedb_sql_field_get_value(field));
-			else
-				idmef_data_set_uint32(data, value);
-			
-			break;
-		}
-
-		case IDMEF_ADDITIONAL_DATA_TYPE_BYTE_STRING: {
-			unsigned char *value;
-			size_t value_size;
-
-			ret = preludedb_sql_unescape_binary(sql,
-							    preludedb_sql_field_get_value(field),
-							    preludedb_sql_field_get_len(field),
-							    &value, &value_size);
-			if ( ret < 0 )
-				break;
-
-			ret = idmef_data_set_byte_string_nodup(data, value, value_size);
-
-			break;
-		}
-
-		case IDMEF_ADDITIONAL_DATA_TYPE_NTPSTAMP: {
-			uint64_t value;
-
-			ret = preludedb_sql_field_to_uint64(field, &value);
-			if ( ret < 0 )
-				ret = idmef_data_set_char_string_dup(data, preludedb_sql_field_get_value(field));
-			else
-				idmef_data_set_uint64(data, value);
-
-			break;
-		}
-			
-		case IDMEF_ADDITIONAL_DATA_TYPE_ERROR:
-			ret = -1;
-		}
-
-		if ( ret < 0 )
-			goto error;
-
-	}
+                                          parent_type, message_ident);
+        if ( ret <= 0 )
+                return ret;
+
+        while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
+
+                ret = parent_new_child(parent, &additional_data, IDMEF_LIST_APPEND);
+                if ( ret < 0 )
+                        goto error;
+
+                ret = get_enum(sql, row, 0, additional_data, idmef_additional_data_new_type,
+                               idmef_additional_data_type_to_numeric);
+                if ( ret < 0 )
+                        goto error;
+
+                ret = get_string(sql, row, 1, additional_data, idmef_additional_data_new_meaning);
+                if ( ret < 0 )
+                        goto error;
+
+                ret = preludedb_sql_row_fetch_field(row, 2, &field);
+                if ( ret <= 0 )
+                        goto error;
+
+                ret = idmef_additional_data_new_data(additional_data, &data);
+                if ( ret < 0 )
+                        goto error;
+
+                switch ( idmef_additional_data_get_type(additional_data) ) {
+                case IDMEF_ADDITIONAL_DATA_TYPE_BOOLEAN: case IDMEF_ADDITIONAL_DATA_TYPE_BYTE: {
+                        uint8_t value;
+
+                        ret = preludedb_sql_field_to_uint8(field, &value);
+                        if ( ret < 0 )
+                                ret = idmef_data_set_char_string_dup(data, preludedb_sql_field_get_value(field));
+                        else
+                                idmef_data_set_byte(data, value);
+
+                        break;
+                }
+
+                case IDMEF_ADDITIONAL_DATA_TYPE_CHARACTER: {
+                        uint8_t value;
+
+                        ret = preludedb_sql_field_to_uint8(field, &value);
+                        if ( ret < 0 )
+                                ret = idmef_data_set_char_string_dup(data, preludedb_sql_field_get_value(field));
+                        else
+                                idmef_data_set_char(data, (char) value);
+
+                        break;
+                }
+
+                case IDMEF_ADDITIONAL_DATA_TYPE_DATE_TIME:
+                case IDMEF_ADDITIONAL_DATA_TYPE_PORTLIST:
+                case IDMEF_ADDITIONAL_DATA_TYPE_STRING:
+                case IDMEF_ADDITIONAL_DATA_TYPE_XML:
+                        ret = idmef_data_set_char_string_dup(data, preludedb_sql_field_get_value(field));
+                        break;
+
+                case IDMEF_ADDITIONAL_DATA_TYPE_REAL: {
+                        float value;
+
+                        ret = preludedb_sql_field_to_float(field, &value);
+                        if ( ret < 0 )
+                                ret = idmef_data_set_char_string_dup(data, preludedb_sql_field_get_value(field));
+                        else
+                                idmef_data_set_float(data, value);
+
+                        break;
+                }
+
+                case IDMEF_ADDITIONAL_DATA_TYPE_INTEGER: {
+                        uint32_t value;
+
+                        ret = preludedb_sql_field_to_uint32(field, &value);
+                        if ( ret < 0 )
+                                ret = idmef_data_set_char_string_dup(data, preludedb_sql_field_get_value(field));
+                        else
+                                idmef_data_set_uint32(data, value);
+
+                        break;
+                }
+
+                case IDMEF_ADDITIONAL_DATA_TYPE_BYTE_STRING: {
+                        unsigned char *value;
+                        size_t value_size;
+
+                        ret = preludedb_sql_unescape_binary(sql,
+                                                            preludedb_sql_field_get_value(field),
+                                                            preludedb_sql_field_get_len(field),
+                                                            &value, &value_size);
+                        if ( ret < 0 )
+                                break;
+
+                        ret = idmef_data_set_byte_string_nodup(data, value, value_size);
+
+                        break;
+                }
+
+                case IDMEF_ADDITIONAL_DATA_TYPE_NTPSTAMP: {
+                        uint64_t value;
+
+                        ret = preludedb_sql_field_to_uint64(field, &value);
+                        if ( ret < 0 )
+                                ret = idmef_data_set_char_string_dup(data, preludedb_sql_field_get_value(field));
+                        else
+                                idmef_data_set_uint64(data, value);
+
+                        break;
+                }
+
+                case IDMEF_ADDITIONAL_DATA_TYPE_ERROR:
+                        ret = -1;
+                }
+
+                if ( ret < 0 )
+                        goto error;
+
+        }
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_reference(preludedb_sql_t *sql,
-			 uint64_t message_ident,
-			 idmef_classification_t *classification)
+                         uint64_t message_ident,
+                         idmef_classification_t *classification)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_reference_t *reference;
-	int ret;
-	
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT origin, name, url, meaning "
-					  "FROM Prelude_Reference "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64 " AND _index != -1 "
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_reference_t *reference;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT origin, name, url, meaning "
+                                          "FROM Prelude_Reference "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64 " AND _index != -1 "
                                           "ORDER BY _index ASC",
                                           message_ident);
-	if ( ret <= 0 )
-		return ret;
+        if ( ret <= 0 )
+                return ret;
 
-	while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
+        while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
 
-		ret = idmef_classification_new_reference(classification, &reference, IDMEF_LIST_APPEND);
-		if ( ret < 0 )
-			goto error;
+                ret = idmef_classification_new_reference(classification, &reference, IDMEF_LIST_APPEND);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_enum(sql, row, 0, reference, idmef_reference_new_origin,
-			       idmef_reference_origin_to_numeric);
-		if ( ret < 0 )
-			goto error;
+                ret = get_enum(sql, row, 0, reference, idmef_reference_new_origin,
+                               idmef_reference_origin_to_numeric);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 1, reference, idmef_reference_new_name);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 1, reference, idmef_reference_new_name);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 2, reference, idmef_reference_new_url);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 2, reference, idmef_reference_new_url);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 3, reference, idmef_reference_new_meaning);
-		if ( ret < 0 )
-			goto error;
-	}
+                ret = get_string(sql, row, 3, reference, idmef_reference_new_meaning);
+                if ( ret < 0 )
+                        goto error;
+        }
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_classification(preludedb_sql_t *sql,
-			      uint64_t message_ident,
-			      idmef_alert_t *alert)
+                              uint64_t message_ident,
+                              idmef_alert_t *alert)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_classification_t *classification;
-	int ret;
-	
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT ident, text "
-					  "FROM Prelude_Classification "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64 "",
-					  message_ident);
-	if ( ret <= 0 )
-		return ret;
-
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
-
-	ret = idmef_alert_new_classification(alert, &classification);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 0, classification, idmef_classification_new_ident);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 1, classification, idmef_classification_new_text);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_reference(sql, message_ident, classification);
-	if ( ret < 0 )
-		goto error;
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_classification_t *classification;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT ident, text "
+                                          "FROM Prelude_Classification "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64 "",
+                                          message_ident);
+        if ( ret <= 0 )
+                return ret;
+
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
+
+        ret = idmef_alert_new_classification(alert, &classification);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 0, classification, idmef_classification_new_ident);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 1, classification, idmef_classification_new_text);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_reference(sql, message_ident, classification);
+        if ( ret < 0 )
+                goto error;
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_alertident(preludedb_sql_t *sql,
-			  uint64_t message_ident,
-			  char parent_type,
-			  void *parent,
-			  int (*parent_new_child)(void *parent, idmef_alertident_t **child, int pos))
+                          uint64_t message_ident,
+                          char parent_type,
+                          void *parent,
+                          int (*parent_new_child)(void *parent, idmef_alertident_t **child, int pos))
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_alertident_t *alertident = NULL;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT alertident, analyzerid "
-					  "FROM Prelude_Alertident "
-					  "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64" AND _index != -1 "
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_alertident_t *alertident = NULL;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT alertident, analyzerid "
+                                          "FROM Prelude_Alertident "
+                                          "WHERE _parent_type = '%c' AND _message_ident = %" PRELUDE_PRIu64" AND _index != -1 "
                                           "ORDER BY _index ASC",
-					  parent_type, message_ident);
-	if ( ret <= 0 )
-		return ret;
+                                          parent_type, message_ident);
+        if ( ret <= 0 )
+                return ret;
 
-	while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
+        while ( (ret = preludedb_sql_table_fetch_row(table, &row)) > 0 ) {
 
-		ret = parent_new_child(parent, &alertident, IDMEF_LIST_APPEND);
-		if ( ret < 0 )
-			goto error;
+                ret = parent_new_child(parent, &alertident, IDMEF_LIST_APPEND);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 0, alertident, idmef_alertident_new_alertident);
-		if ( ret < 0 )
-			goto error;
+                ret = get_string(sql, row, 0, alertident, idmef_alertident_new_alertident);
+                if ( ret < 0 )
+                        goto error;
 
-		ret = get_string(sql, row, 1, alertident, idmef_alertident_new_analyzerid);
-		if ( ret < 0 )
-			goto error;
-	}
+                ret = get_string(sql, row, 1, alertident, idmef_alertident_new_analyzerid);
+                if ( ret < 0 )
+                        goto error;
+        }
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_tool_alert(preludedb_sql_t *sql,
-			  uint64_t message_ident,
-			  idmef_alert_t *alert)
+                          uint64_t message_ident,
+                          idmef_alert_t *alert)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_tool_alert_t *tool_alert;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT name, command "
-					  "FROM Prelude_ToolAlert "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64 "",
-					  message_ident);
-	if ( ret <= 0 )
-		return ret;
-
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
-
-	ret = idmef_alert_new_tool_alert(alert, &tool_alert);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 0, tool_alert, idmef_tool_alert_new_name);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 1, tool_alert, idmef_tool_alert_new_command);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_alertident(sql, message_ident, 'T', tool_alert,
-			     (int (*)(void *, idmef_alertident_t **, int)) idmef_tool_alert_new_alertident);
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_tool_alert_t *tool_alert;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT name, command "
+                                          "FROM Prelude_ToolAlert "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64 "",
+                                          message_ident);
+        if ( ret <= 0 )
+                return ret;
+
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
+
+        ret = idmef_alert_new_tool_alert(alert, &tool_alert);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 0, tool_alert, idmef_tool_alert_new_name);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 1, tool_alert, idmef_tool_alert_new_command);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_alertident(sql, message_ident, 'T', tool_alert,
+                             (int (*)(void *, idmef_alertident_t **, int)) idmef_tool_alert_new_alertident);
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 static int get_correlation_alert(preludedb_sql_t *sql,
-				 uint64_t message_ident,
-				 idmef_alert_t *alert)
+                                 uint64_t message_ident,
+                                 idmef_alert_t *alert)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_correlation_alert_t *correlation_alert;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT name "
-					  "FROM Prelude_CorrelationAlert "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64 "",
-					  message_ident);
-	if ( ret <= 0 )
-		return ret;
-
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
-
-	ret = idmef_alert_new_correlation_alert(alert, &correlation_alert);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 0, correlation_alert, idmef_correlation_alert_new_name);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_alertident(sql, message_ident, 'C', correlation_alert,
-			     (int (*)(void *, idmef_alertident_t **, int)) idmef_correlation_alert_new_alertident);
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_correlation_alert_t *correlation_alert;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT name "
+                                          "FROM Prelude_CorrelationAlert "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64 "",
+                                          message_ident);
+        if ( ret <= 0 )
+                return ret;
+
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
+
+        ret = idmef_alert_new_correlation_alert(alert, &correlation_alert);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 0, correlation_alert, idmef_correlation_alert_new_name);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_alertident(sql, message_ident, 'C', correlation_alert,
+                             (int (*)(void *, idmef_alertident_t **, int)) idmef_correlation_alert_new_alertident);
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 
 static int get_overflow_alert(preludedb_sql_t *sql,
-			      uint64_t message_ident,
-			      idmef_alert_t *alert)
+                              uint64_t message_ident,
+                              idmef_alert_t *alert)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	idmef_overflow_alert_t *overflow_alert;
-	preludedb_sql_field_t *field;
-	idmef_data_t *buffer;
-	unsigned char *data;
-	size_t data_size;
-	int ret;
-
-	ret = preludedb_sql_query_sprintf(sql, &table,
-					  "SELECT program, size, buffer "
-					  "FROM Prelude_OverflowAlert "
-					  "WHERE _message_ident = %" PRELUDE_PRIu64 "",
-					  message_ident);
-	if ( ret <= 0 )
-		return ret;
-
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret <= 0 )
-		goto error;
-
-	ret = idmef_alert_new_overflow_alert(alert, &overflow_alert);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_string(sql, row, 0, overflow_alert, idmef_overflow_alert_new_program);
-	if ( ret < 0 )
-		goto error;
-
-	ret = get_uint32(sql, row, 1, overflow_alert, idmef_overflow_alert_new_size);
-	if ( ret < 0 )
-		goto error;
-
-	ret = preludedb_sql_row_fetch_field(row, 2, &field);
-	if ( ret < 0 )
-		goto error;
-
-	ret = idmef_overflow_alert_new_buffer(overflow_alert, &buffer);
-	if ( ret < 0 )
-		goto error;
-
-	ret = preludedb_sql_unescape_binary(sql,
-					    preludedb_sql_field_get_value(field),
-					    preludedb_sql_field_get_len(field),
-					    &data, &data_size);
-
-	if ( ret < 0 )
-		goto error;
-
-	ret = idmef_data_set_byte_string_nodup(buffer, data, data_size);
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        idmef_overflow_alert_t *overflow_alert;
+        preludedb_sql_field_t *field;
+        idmef_data_t *buffer;
+        unsigned char *data;
+        size_t data_size;
+        int ret;
+
+        ret = preludedb_sql_query_sprintf(sql, &table,
+                                          "SELECT program, size, buffer "
+                                          "FROM Prelude_OverflowAlert "
+                                          "WHERE _message_ident = %" PRELUDE_PRIu64 "",
+                                          message_ident);
+        if ( ret <= 0 )
+                return ret;
+
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret <= 0 )
+                goto error;
+
+        ret = idmef_alert_new_overflow_alert(alert, &overflow_alert);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_string(sql, row, 0, overflow_alert, idmef_overflow_alert_new_program);
+        if ( ret < 0 )
+                goto error;
+
+        ret = get_uint32(sql, row, 1, overflow_alert, idmef_overflow_alert_new_size);
+        if ( ret < 0 )
+                goto error;
+
+        ret = preludedb_sql_row_fetch_field(row, 2, &field);
+        if ( ret < 0 )
+                goto error;
+
+        ret = idmef_overflow_alert_new_buffer(overflow_alert, &buffer);
+        if ( ret < 0 )
+                goto error;
+
+        ret = preludedb_sql_unescape_binary(sql,
+                                            preludedb_sql_field_get_value(field),
+                                            preludedb_sql_field_get_len(field),
+                                            &data, &data_size);
+
+        if ( ret < 0 )
+                goto error;
+
+        ret = idmef_data_set_byte_string_nodup(buffer, data, data_size);
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return ret;
+        return ret;
 }
 
 
 static int get_alert_messageid(preludedb_sql_t *sql, uint64_t ident, idmef_alert_t *alert)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	int ret;
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        int ret;
 
-	ret = preludedb_sql_query_sprintf(sql, &table, "SELECT messageid FROM Prelude_Alert WHERE _ident = %" PRELUDE_PRIu64 "", ident);
-	if ( ret < 0 )
-		return ret;
+        ret = preludedb_sql_query_sprintf(sql, &table, "SELECT messageid FROM Prelude_Alert WHERE _ident = %" PRELUDE_PRIu64 "", ident);
+        if ( ret < 0 )
+                return ret;
 
-	if ( ret == 0 )
-		return preludedb_error(PRELUDEDB_ERROR_INVALID_MESSAGE_IDENT);
+        if ( ret == 0 )
+                return preludedb_error(PRELUDEDB_ERROR_INVALID_MESSAGE_IDENT);
 
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret < 0 )
-		goto error;
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_string(sql, row, 0, alert, idmef_alert_new_messageid);
+        ret = get_string(sql, row, 0, alert, idmef_alert_new_messageid);
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return (ret < 0) ? ret : 1;
+        return (ret < 0) ? ret : 1;
 }
 
 
 int classic_get_alert(preludedb_sql_t *sql, uint64_t ident, idmef_message_t **message)
 {
-	idmef_alert_t *alert;
-	int ret;
+        idmef_alert_t *alert;
+        int ret;
+
+        ret = idmef_message_new(message);
+        if ( ret < 0 )
+                return ret;
 
-	ret = idmef_message_new(message);
-	if ( ret < 0 )
-		return ret;
+        ret = idmef_message_new_alert(*message, &alert);
+        if ( ret < 0 )
+                goto error;
 
-	ret = idmef_message_new_alert(*message, &alert);
-	if ( ret < 0 )
-		goto error;
+        ret = get_alert_messageid(sql, ident, alert);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_alert_messageid(sql, ident, alert);
-	if ( ret < 0 )
-		goto error;
-        
-	ret = get_assessment(sql, ident, alert);
-	if ( ret < 0 )
-		goto error;
+        ret = get_assessment(sql, ident, alert);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_analyzer(sql, ident, 'A', alert, (int (*)(void *, idmef_analyzer_t **, int)) idmef_alert_new_analyzer);
-	if ( ret < 0 )
-		goto error;
+        ret = get_analyzer(sql, ident, 'A', alert, (int (*)(void *, idmef_analyzer_t **, int)) idmef_alert_new_analyzer);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_create_time(sql, ident, 'A', alert, (int (*)(void *, idmef_time_t **)) idmef_alert_new_create_time);
-	if ( ret < 0 )
-		goto error;
+        ret = get_create_time(sql, ident, 'A', alert, (int (*)(void *, idmef_time_t **)) idmef_alert_new_create_time);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_detect_time(sql, ident, alert);
-	if ( ret < 0 )
-		goto error;
+        ret = get_detect_time(sql, ident, alert);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_analyzer_time(sql, ident, 'A', alert, (int (*)(void *, idmef_time_t **)) idmef_alert_new_analyzer_time);
-	if ( ret < 0 )
-		goto error;
+        ret = get_analyzer_time(sql, ident, 'A', alert, (int (*)(void *, idmef_time_t **)) idmef_alert_new_analyzer_time);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_source(sql, ident, alert);
-	if ( ret < 0 )
-		goto error;
+        ret = get_source(sql, ident, alert);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_target(sql, ident, alert);
-	if ( ret < 0 )
-		goto error;
+        ret = get_target(sql, ident, alert);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_classification(sql, ident, alert);
-	if ( ret < 0 )
-		goto error;
+        ret = get_classification(sql, ident, alert);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_additional_data(sql, ident, 'A', alert, 
-				  (int (*)(void *, idmef_additional_data_t **, int)) idmef_alert_new_additional_data);
-	if ( ret < 0 )
-		goto error;
+        ret = get_additional_data(sql, ident, 'A', alert,
+                                  (int (*)(void *, idmef_additional_data_t **, int)) idmef_alert_new_additional_data);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_tool_alert(sql, ident, alert);
-	if ( ret < 0 )
-		goto error;
+        ret = get_tool_alert(sql, ident, alert);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_correlation_alert(sql, ident, alert);
-	if ( ret < 0 )
-		goto error;
+        ret = get_correlation_alert(sql, ident, alert);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_overflow_alert(sql, ident, alert);
-	if ( ret < 0 )
-		goto error;
+        ret = get_overflow_alert(sql, ident, alert);
+        if ( ret < 0 )
+                goto error;
 
-	return 0;
+        return 0;
 
  error:
-	idmef_message_destroy(*message);
+        idmef_message_destroy(*message);
 
-	return ret;
+        return ret;
 }
 
 
 
 static int _get_heartbeat(preludedb_sql_t *sql, uint64_t ident, idmef_heartbeat_t *heartbeat)
 {
-	preludedb_sql_table_t *table;
-	preludedb_sql_row_t *row;
-	int ret;
+        preludedb_sql_table_t *table;
+        preludedb_sql_row_t *row;
+        int ret;
 
-	ret = preludedb_sql_query_sprintf(sql, &table, "SELECT messageid, heartbeat_interval FROM Prelude_Heartbeat WHERE _ident = %" PRELUDE_PRIu64 "", ident);
-	if ( ret < 0 )
-		return ret;
+        ret = preludedb_sql_query_sprintf(sql, &table, "SELECT messageid, heartbeat_interval FROM Prelude_Heartbeat WHERE _ident = %" PRELUDE_PRIu64 "", ident);
+        if ( ret < 0 )
+                return ret;
 
-	if ( ret == 0 )
-		return preludedb_error(PRELUDEDB_ERROR_INVALID_MESSAGE_IDENT);
+        if ( ret == 0 )
+                return preludedb_error(PRELUDEDB_ERROR_INVALID_MESSAGE_IDENT);
 
-	ret = preludedb_sql_table_fetch_row(table, &row);
-	if ( ret < 0 )
-		goto error;
+        ret = preludedb_sql_table_fetch_row(table, &row);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_string(sql, row, 0, heartbeat, idmef_heartbeat_new_messageid);
-	if ( ret < 0 )
-		goto error;
+        ret = get_string(sql, row, 0, heartbeat, idmef_heartbeat_new_messageid);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_uint32(sql, row, 1, heartbeat, idmef_heartbeat_new_heartbeat_interval);	
+        ret = get_uint32(sql, row, 1, heartbeat, idmef_heartbeat_new_heartbeat_interval);
 
  error:
-	preludedb_sql_table_destroy(table);
+        preludedb_sql_table_destroy(table);
 
-	return (ret < 0) ? ret : 1;
+        return (ret < 0) ? ret : 1;
 }
 
 
 
 int classic_get_heartbeat(preludedb_sql_t *sql, uint64_t ident, idmef_message_t **message)
 {
-	idmef_heartbeat_t *heartbeat;
-	int ret;
+        idmef_heartbeat_t *heartbeat;
+        int ret;
 
-	ret = idmef_message_new(message);
-	if ( ret < 0 ) 
-		return ret;
+        ret = idmef_message_new(message);
+        if ( ret < 0 )
+                return ret;
 
-	ret = idmef_message_new_heartbeat(*message, &heartbeat);
-	if ( ret < 0 )
-		goto error;
+        ret = idmef_message_new_heartbeat(*message, &heartbeat);
+        if ( ret < 0 )
+                goto error;
 
-	ret = _get_heartbeat(sql, ident, heartbeat);
-	if ( ret <= 0 )
-		goto error;
+        ret = _get_heartbeat(sql, ident, heartbeat);
+        if ( ret <= 0 )
+                goto error;
 
-	ret = get_analyzer(sql, ident, 'H', heartbeat, (int (*)(void *, idmef_analyzer_t **, int)) idmef_heartbeat_new_analyzer);
-	if ( ret < 0 )
-		goto error;
+        ret = get_analyzer(sql, ident, 'H', heartbeat, (int (*)(void *, idmef_analyzer_t **, int)) idmef_heartbeat_new_analyzer);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_create_time(sql, ident, 'H', heartbeat, (int (*)(void *, idmef_time_t **)) idmef_heartbeat_new_create_time);
-	if ( ret < 0 )
-		goto error;
+        ret = get_create_time(sql, ident, 'H', heartbeat, (int (*)(void *, idmef_time_t **)) idmef_heartbeat_new_create_time);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_analyzer_time(sql, ident, 'H', heartbeat, (int (*)(void *, idmef_time_t **)) idmef_heartbeat_new_analyzer_time);
-	if ( ret < 0 )
-		goto error;
+        ret = get_analyzer_time(sql, ident, 'H', heartbeat, (int (*)(void *, idmef_time_t **)) idmef_heartbeat_new_analyzer_time);
+        if ( ret < 0 )
+                goto error;
 
-	ret = get_additional_data(sql, ident, 'H', heartbeat,
-				  (int (*)(void *, idmef_additional_data_t **, int)) idmef_heartbeat_new_additional_data);
-	if ( ret < 0 )
-		goto error;
+        ret = get_additional_data(sql, ident, 'H', heartbeat,
+                                  (int (*)(void *, idmef_additional_data_t **, int)) idmef_heartbeat_new_additional_data);
+        if ( ret < 0 )
+                goto error;
 
-	return 0;
+        return 0;
 
  error:
-	idmef_message_destroy(*message);
+        idmef_message_destroy(*message);
 
-	return ret;
+        return ret;
 }
diff --git a/src/preludedb-error.c b/src/preludedb-error.c
index 7767fb9..ae771ac 100644
--- a/src/preludedb-error.c
+++ b/src/preludedb-error.c
@@ -29,7 +29,7 @@
 
 const char *preludedb_strerror(preludedb_error_t error)
 {
-	static const char *error_strings[] = {
+        static const char *error_strings[] = {
                 "Successful",
                 "Unknown generic error",
                 "Invalid SQL settings string",
@@ -43,28 +43,28 @@ const char *preludedb_strerror(preludedb_error_t error)
                 "Unknown format plugin",
                 "Already in transaction",
                 "Not in transaction",
-		"Invalid message ident",
-		"Invalid selected path string",
-		"Invalid path selection",
-		"Database schema version too old",
-		"Database schema version too recent",
-		"Database schema version invalid",
-		"Cannot load sql plugin",
-		"Cannot load format plugin"
+                "Invalid message ident",
+                "Invalid selected path string",
+                "Invalid path selection",
+                "Database schema version too old",
+                "Database schema version too recent",
+                "Database schema version invalid",
+                "Cannot load sql plugin",
+                "Cannot load format plugin"
         };
 
         if ( prelude_error_is_verbose(error) )
                 return _prelude_thread_get_error();
-               
-	if ( prelude_error_get_source(error) == PRELUDE_ERROR_SOURCE_PRELUDEDB ) {
-		preludedb_error_code_t code;
 
-		code = prelude_error_get_code(error);
-		if ( code < 0 || code >= sizeof(error_strings) / sizeof(*error_strings) )
-			return NULL;
+        if ( prelude_error_get_source(error) == PRELUDE_ERROR_SOURCE_PRELUDEDB ) {
+                preludedb_error_code_t code;
 
-		return error_strings[code];
-	}
+                code = prelude_error_get_code(error);
+                if ( code < 0 || code >= sizeof(error_strings) / sizeof(*error_strings) )
+                        return NULL;
 
-	return prelude_strerror(error);
+                return error_strings[code];
+        }
+
+        return prelude_strerror(error);
 }
_______________________________________________
Prelude-cvslog site list
[email protected]
http://lists.prelude-ids.org/mailman/listinfo/prelude-cvslog