// Build the report search field order $report_presentation_fields = array('output', 'output_format', 'sortby', 'sumby'); foreach ($report_presentation_fields as $field) { if (!in_array($field, $report_presentation_field_order)) { $report_presentation_field_order[] = $field; } } // Build the report search field order $report_search_fields = array('report_start', 'report_end', 'areamatch', 'roommatch', 'typematch', 'namematch', 'descrmatch', 'creatormatch', 'match_private', 'match_confirmed', 'match_approved'); foreach ($report_search_fields as $field) { if (!in_array($field, $report_search_field_order)) { $report_search_field_order[] = $field; } } // Get information about custom fields $fields = sql_field_info($tbl_entry); $custom_fields = array(); $field_natures = array(); $field_lengths = array(); foreach ($fields as $field) { $key = $field['name']; if (!in_array($key, $standard_fields['entry'])) { $custom_fields[$key] = ''; // Add the field to the end of the report search field order, if it's // not already present if (!in_array($key, $report_search_field_order)) { $report_search_field_order[] = $key; } } $field_natures[$key] = $field['nature']; $field_lengths[$key] = $field['length'];
$area_confirmation_enabled = get_form_var('area_confirmation_enabled', 'string'); $area_confirmed_default = get_form_var('area_confirmed_default', 'string'); $custom_html = get_form_var('custom_html', 'string'); // Used for both area and room, but you only ever have one or the other $change_done = get_form_var('change_done', 'string'); $change_room = get_form_var('change_room', 'string'); $change_area = get_form_var('change_area', 'string'); // Get the max_per_interval form variables foreach ($interval_types as $interval_type) { $var = "area_max_per_{$interval_type}"; ${$var} = get_form_var($var, 'int'); $var = "area_max_per_{$interval_type}_enabled"; ${$var} = get_form_var($var, 'string'); } // Get the information about the fields in the room table $fields = sql_field_info($tbl_room); // Get any user defined form variables foreach ($fields as $field) { switch ($field['nature']) { case 'character': $type = 'string'; break; case 'integer': $type = 'int'; break; // We can only really deal with the types above at the moment // We can only really deal with the types above at the moment default: $type = 'string'; break; }
// Truncate the name field to the maximum length as a precaution. $name = substr($name, 0, $maxlength['area.area_name']); $area_name_q = addslashes($name); // Acquire a mutex to lock out others who might be editing the area if (!sql_mutex_lock("{$tbl_area}")) { fatal_error(TRUE, get_vocab("failed_to_acquire")); } // Check that the area name is unique if (sql_query1("SELECT COUNT(*) FROM {$tbl_area} WHERE area_name='{$area_name_q}' LIMIT 1") > 0) { $error = "invalid_area_name"; } else { // Build arrays of data to be inserted into the table $sql_col = array(); $sql_val = array(); // Get the information about the fields in the room table $fields = sql_field_info($tbl_area); // Loop through the fields and build up the arrays foreach ($fields as $field) { $key = $field['name']; switch ($key) { case 'area_name': $sql_col[] = $key; $sql_val[] = "'{$area_name_q}'"; break; default: if (array_key_exists($key, $area_defaults)) { $sql_col[] = $key; if (in_array($key, $boolean_fields['area'])) { $sql_val[] = $area_defaults[$key] ? 1 : 0; } elseif ($field['nature'] == 'integer') { $sql_val[] = $area_defaults[$key];
if (is_string(${$var})) { ${$var} = trim(${$var}); } } // BACK: we didn't really want to be here - send them to the returl if (!empty($back_button)) { if (empty($returl)) { $returl = "index.php"; } header("Location: {$returl}"); exit; } // Get custom form variables $custom_fields = array(); // Get the information about the fields in the entry table $fields = sql_field_info(times); foreach ($fields as $field) { echo $field; if (!in_array($field['name'], $standard_fields['entry'])) { switch ($field['nature']) { case 'character': $f_type = 'string'; break; case 'integer': $f_type = 'int'; break; // We can only really deal with the types above at the moment // We can only really deal with the types above at the moment default: $f_type = 'string'; break;
$json_data['aaData'][] = $values; } else { echo "<tr>\n<td>\n"; echo implode("</td>\n<td>", $values); echo "</td>\n</tr>\n"; } } // Set up for Ajax. We need to know whether we're capable of dealing with Ajax // requests, which will only be if (a) the browser is using DataTables and (b) // we can do JSON encoding. We also need to initialise the JSON data array. $ajax_capable = $datatable && function_exists('json_encode'); if ($ajax) { $json_data['aaData'] = array(); } // Get the information about the fields in the users table $fields = sql_field_info($tbl_users); $nusers = sql_query1("SELECT COUNT(*) FROM {$tbl_users}"); /*---------------------------------------------------------------------------*\ | Authenticate the current user | \*---------------------------------------------------------------------------*/ $initial_user_creation = 0; if ($nusers > 0) { $user = getUserName(); $level = authGetUserLevel($user); // Check the user is authorised for this page checkAuthorised(); } else { $initial_user_creation = 1; if (!isset($Action)) { $Action = "Add"; $Id = -1;
echo " " . get_vocab("in") . " " . htmlspecialchars($area_name); }*/ echo "</h2>\n"; echo "<div id=\"room_form\">\n"; $area = 1; if (isset($area)) { $res = sql_query("SELECT * FROM codes ORDER BY code"); if (!$res) { trigger_error(sql_error(), E_USER_WARNING); fatal_error(FALSE, get_vocab("fatal_db_error")); } if (sql_count($res) == 0) { echo "<p>" . get_vocab("norooms") . "</p>\n"; } else { // Get the information about the fields in the room table $fields = sql_field_info('codes'); // Build an array with the room info and also see if there are going // to be any rooms to display (in other words rooms if you are not an // admin whether any rooms are enabled) $rooms = array(); $n_displayable_rooms = 0; for ($i = 0; $row = sql_mysqli_row_keyed($res, $i); $i++) { $rooms[] = $row; if ($is_admin || !$row['disabled']) { $n_displayable_rooms++; } } if ($n_displayable_rooms == 0) { echo "<p>" . get_vocab("norooms_enabled") . "</p>\n"; } else { echo "<div id=\"room_info\" class=\"datatable_container\">\n";