/** * List Event records * * Given filter array, return list of event records * * @param array $filter_array filter array, field => value elements * @return array event records */ function event_list ($filter_array) { $sql_where = ''; /* validation and setup for the WHERE clause */ if ((is_array($filter_array)) && (sizeof($filter_array) > 0)) { /* validate each field against the known master field list */ $field_errors = event_validate(sql_filter_array_to_field_array($filter_array)); /* if a field input error has occured, register the error in the session and return */ if (sizeof($field_errors) > 0) { field_register_error($field_errors); return false; /* otherwise, form an SQL WHERE string using the filter fields */ }else{ $sql_where = sql_filter_array_to_where_string($filter_array, event_list_form(), true); } } return db_fetch_assoc("SELECT * FROM event_queue_control $sql_where ORDER BY id"); }
function event_validate (&$_fields_event, $event_field_name_format = "|field|") { if (sizeof($_fields_event) == 0) { return array(); } /* array containing errored fields */ $error_fields = array(); /* get a complete field list */ $fields_event = event_list_form(); /* base fields */ while (list($_field_name, $_field_array) = each($fields_event)) { if ((isset($_fields_event[$_field_name])) && (isset($_field_array["validate_regexp"])) && (isset($_field_array["validate_empty"]))) { $form_field_name = str_replace("|field|", $_field_name, $event_field_name_format); if (!form_input_validate($_fields_event[$_field_name], $form_field_name, $_field_array["validate_regexp"], $_field_array["validate_empty"])) { $error_fields[] = $form_field_name; } } } return $error_fields; }