function get_yesno_selectlist($name, $sel = NULL, $empty = FALSE, $tags = array())
{
global $sql_strings;
$arr = array('Yes' => $sql_strings['Yes'], 'No' => $sql_strings['No']);
$html = get_indexed_selectlist($name, $arr, $sel, $empty, $tags);
return $html;
}
function csv_format_options_table($export)
{
global $dt_strings;
return '
<table class="table table-bordered">
<tr>
<th align="left" colspan="2">' . $dt_strings['CsvOpts'] . '</th>
</tr>
<tr>
<td>
<table class="table table-bordered">
<tr>
<td>
' . $dt_strings['FTerm'] . '
</td>
<td>
' . get_textfield('dt_export_csv_fterm', 2, 5, $export['csv']['fterm']) . '
</td>
</tr>
<tr>
<td>
' . $dt_strings['FEncl'] . '
</td>
<td>
' . get_textfield('dt_export_csv_fencl', 2, 5, $export['csv']['fencl']) . '
</td>
</tr>
<tr>
<td>
' . $dt_strings['FTEncl'] . '
</td>
<td>
' . get_indexed_selectlist('dt_export_csv_ftencl', array('all' => $dt_strings['All'], 'nonnum' => $dt_strings['NonNum']), $export['csv']['ftencl']) . '
</td>
</tr>
<tr>
<td>
' . $dt_strings['FEsc'] . '
</td>
<td>
' . get_textfield('dt_export_csv_fesc', 2, 5, $export['csv']['fesc']) . '
</td>
</tr>
<tr>
<td>
' . $dt_strings['LTerm'] . '
</td>
<td>
' . get_textfield('dt_export_csv_lterm', 2, 5, $export['csv']['lterm']) . '
</td>
</tr>
<tr>
<td>
' . $dt_strings['FNamesF'] . '
</td>
<td>
' . get_checkbox('dt_export_csv_fnamesf', '1', $export['csv']['fnamesf']) . '
</td>
</tr>
</table>
</td>
</tr>
</table>';
}
echo get_table_selectlist('dt_export_source_dbtables[]', array('select'), $s_export['source']['dbtables'], FALSE, array('multiple' => 'multiple'), 4);
?>
</span>
</td>
</tr>
</table>
</td>
<td valign="top">
<table class="table table-bordered">
<tr>
<th align="left" colspan="2">Target</th>
</tr>
<tr>
<td>
<?php
echo get_indexed_selectlist('dt_export_target', get_export_targets(), $s_export['target']['option'], FALSE, array('onChange' => "if (this.value=='screen') hide('dt_export_filename_span'); else display('dt_export_filename_span'); setExportTarget(this.value);"));
?>
</td>
<td>
<span id="dt_export_filename_span" style="display:<?php
$s_export['target']['option'] == 'file' ? print 'block' : (print 'none');
?>
;">
<?php
echo get_textfield('dt_export_target_filename', 30, 255, $s_export['target']['filename'], 'text', array('id' => 'dt_export_target_filename'));
?>
<?php
echo $dt_strings['EntName'];
?>
</span>
</td>
protected function _renderField($field, $idx, $value)
{
global $sql_strings, $dt_strings;
if (is_string($value)) {
$value = htmlentities($value);
}
$element_name = $this->_name('field') . '_' . $idx;
$html = " <tr>\n" . ' <td valign="top"><b>' . $field['name'] . "</b></td>\n" . " <td>\n";
if ($field['type'] == 'BLOB') {
if ($this->job == 'edit' && $value !== NULL) {
$size = 32;
$cname = $this->_name('drop_blob') . '_' . $idx;
$url = url_session('showblob.php?where=' . urlencode('WHERE ' . $this->condition) . '&table=' . $this->table . '&col=' . $field['name']);
$blobdrop_str = ' <i><a href="' . $url . '" target="_blank"><b>BLOB</b></a> </i>' . "\n" . ' | <input type="checkbox" name="' . $cname . '" id="' . $cname . '"> <label for="' . $cname . '">' . $dt_strings['Drop'] . "</label><br>\n";
} else {
$size = 50;
$blobdrop_str = '';
}
$html .= $blobdrop_str . ' <input type="file" size="50" name="' . $this->_name('file') . '_' . $idx . "\">\n";
if ($field['stype'] == 1 || $GLOBALS['s_wt']['blob_as'][$field['name']] == 'text') {
$html .= " <br>\n" . ' <textarea name="' . $element_name . '" cols="42" rows="3">' . $value . "</textarea>\n";
}
} elseif (isset($field['comp'])) {
$html .= ' ' . $value . "\n";
} elseif (isset($this->fk_data[$field['name']])) {
$html .= " <table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n" . " <tr>\n" . " <td>\n" . ' ' . get_indexed_selectlist($element_name, $this->fk_data[$field['name']]['data'], $value, TRUE) . " </td>\n" . " <td align=\"right\">\n" . " <a href=\"javascript:requestColumnConfigForm('" . $this->fk_data[$field['name']]['table'] . "', '" . $this->table . "', '" . $field['name'] . "', '" . $this->_name('config') . "');\" class=\"act\">[" . $sql_strings['Config'] . "]</a>\n" . " </td>\n" . " </tr>\n" . " </table>\n";
} else {
if (!isset($field['size'])) {
$size = $maxlen = 20;
} else {
$maxlen = $field['size'];
$size = $field['size'] + 1 > DATA_MAXWIDTH ? DATA_MAXWIDTH : $field['size'] + 1;
}
$html .= ' <input type="text" size="' . $size . '" maxlength="' . $maxlen . '" name="' . $element_name . '" value="' . $value . "\">\n";
}
$html .= " </td>\n" . " </tr>\n";
return $html;
}
// Author Lutz Brueckner <*****@*****.**>
// Copyright (c) 2000, 2001, 2002, 2003, 2004, 2005 by Lutz Brueckner,
// published under the terms of the GNU General Public Licence v.2,
// see file LICENCE for details
if ($s_connected) {
?>
<form method="post" action="<?php
echo url_session($_SERVER['PHP_SELF']);
?>
" name="db_stat_form">
<table class="table table-bordered">
<tr>
<td>
<?php
echo '<b>' . $adm_strings['Analyze'] . "</b><br>\n";
echo get_indexed_selectlist('db_stat_option', database_statistic_options(), $s_dbstat_option);
?>
</td>
<td valign="bottom">
<input type="submit" class="btn btn-default" name="db_stat_select" value="<?php
echo $button_strings['Select'];
?>
">
</td>
</tr>
</table>
</form>
<div class="if">
<iframe src="<?php
echo url_session('./iframe_content.php?key=' . $iframekey_dbstat);
?>
