function get_trigger_definition($title)
{
global $s_triggerdefs, $acc_strings, $s_cust;
$trigger_source = htmlspecialchars($s_triggerdefs['source']);
$html = "<table border cellpadding=\"3\" cellspacing=\"0\">\n" . " <tr>\n" . ' <th colspan="6" align="left">' . $title . "</th>\n" . " </tr>\n" . " <tr>\n" . ' <td valign="top"><b>' . $acc_strings['Name'] . "</b><br>\n" . ' <input type="text" size="20" maxlength="31" name="def_trigger_name" value="' . ifsetor($s_triggerdefs['name']) . "\">\n" . " </td>\n" . " <td valign=\"top\">\n" . ' <b>' . $acc_strings['Table'] . "</b><br>\n" . ' ' . get_table_selectlist('def_trigger_table', array('owner'), $s_triggerdefs['table'], TRUE) . " </td>\n" . " <td valign=\"top\">\n" . ' <b>' . $acc_strings['Phase'] . "</b><br>\n" . ' ' . get_selectlist('def_trigger_phase', array('before', 'after'), $s_triggerdefs['phase'], TRUE) . " </td>\n" . " <td>\n" . ' <b>' . $acc_strings['Type'] . "</b><br>\n" . ' ' . get_triggertype_selectlist('def_trigger_type', $s_triggerdefs['type'], TRUE) . " </td>\n" . " <td valign=\"top\">\n" . ' <b>' . $acc_strings['Position'] . "</b><br>\n" . ' <input type="text" size="2" maxlength="2" name="def_trigger_pos" value="' . ifsetor($s_triggerdefs['pos']) . "\">\n" . " </td>\n" . " <td valign=\"top\">\n" . ' <b>' . $acc_strings['Status'] . "</b><br>\n" . ' ' . get_selectlist('def_trigger_status', array('Active', 'Inactive'), $s_triggerdefs['status'], FALSE) . " </td>\n" . " </tr>\n" . " <tr>\n" . " <td colspan=\"6\">\n" . ' <b>' . $acc_strings['Source'] . "</b><br>\n" . ' <textarea name="def_trigger_source" rows="' . $s_cust['textarea']['rows'] . '" cols="' . $s_cust['textarea']['cols'] . '" wrap="virtual">' . $trigger_source . "</textarea>\n" . " </td>\n" . " </tr>\n" . "</table>\n";
return $html;
}
function get_column_constraint_definition($coldefs, $idx)
{
global $fk_actions, $tb_strings;
$fk_name = isset($coldefs['fk_name']) ? $coldefs['fk_name'] : '';
$fk_table = isset($coldefs['fk_table']) ? $coldefs['fk_table'] : '';
$fk_column = isset($coldefs['fk_column']) ? $coldefs['fk_column'] : '';
$on_update = isset($coldefs['on_update']) ? $coldefs['on_update'] : '';
$on_delete = isset($coldefs['on_delete']) ? $coldefs['on_delete'] : '';
$table_element = get_table_selectlist('cd_def_fk_table_' . $idx, array('no_views', 'references'), $fk_table, TRUE, array('onChange' => "requestTableColumns(selectedElement(this), 'cd_def_fk_col_" . $idx . "', 'fk');"));
$drop_element = '';
if ($idx == 'mod' && (isset($coldefs['primary']) && $coldefs['primary_cols'] == 1 || isset($coldefs['unique']) && $coldefs['unique_cols'] == 1 || isset($coldefs['foreign']) && $coldefs['foreign_cols'] == 1)) {
$checked_str = $coldefs['fk_del'] == TRUE ? ' checked' : '';
$drop_element = " <tr>\n" . " <td colspan=\"7\">\n" . " <table style=\"border-bottom: 1px solid black;\" width=\"100%\">\n" . " <tr>\n";
if (isset($coldefs['primary']) && $coldefs['primary_cols'] == 1) {
$checked_str = $coldefs['pk_del'] == TRUE ? ' checked' : '';
$drop_element .= " <td>\n" . ' <input type="checkbox" name="cd_def_pk_del_' . $idx . '"' . $checked_str . '> <b>' . $tb_strings['DropPK'] . "</b>\n" . " </td>\n";
}
if (isset($coldefs['unique']) && $coldefs['unique_cols'] == 1) {
$checked_str = $coldefs['uq_del'] == TRUE ? ' checked' : '';
$drop_element .= " <td>\n" . ' <input type="checkbox" name="cd_def_uq_del_' . $idx . '"' . $checked_str . '> <b>' . $tb_strings['DropUq'] . "</b>\n" . " </td>\n";
}
if (isset($coldefs['foreign']) && $coldefs['foreign_cols'] == 1) {
$checked_str = $coldefs['fk_del'] == TRUE ? ' checked' : '';
$drop_element .= " <td>\n" . ' <input type="checkbox" name="cd_def_fk_del_' . $idx . '"' . $checked_str . '> <b>' . $tb_strings['DropFK'] . "</b>\n" . " </td>\n";
}
$drop_element .= " </tr>\n" . " </table>\n" . " <td>\n" . " </tr>\n";
}
$html = " <tr>\n" . " <td colspan=\"8\">\n" . " <table class=\"table table-bordered\">\n" . $drop_element . " <tr>\n" . " <td colspan=\"7\">\n" . ' <b>' . $tb_strings['FKName'] . "</b><br>\n" . ' <input type="text" size="27" maxlength="31" name="cd_def_fk_name_' . $idx . '" value="' . $fk_name . "\">\n" . " </td>\n" . " </tr>\n" . " <tr>\n" . " <td>\n" . ' <b>' . $tb_strings['Table1'] . "</b><br>\n" . ' ' . $table_element . "\n" . " </td>\n" . " <td> </td>\n" . " <td>\n" . ' <b>' . $tb_strings['Column1'] . "</b><br>\n" . ' <span id="cd_def_fk_col_' . $idx . "\">\n" . ' <input type="text" size="20" maxlength="31" name="cd_def_fk_col_' . $idx . '" value="' . $fk_column . "\">\n" . " </span>\n" . " </td>\n" . " <td> </td>\n" . " <td>\n" . ' <b>' . $tb_strings['OnUpdate'] . "</b><br>\n" . " " . get_selectlist('cd_def_ou_' . $idx, $fk_actions, $on_update, TRUE) . "\n" . " </td>\n" . " <td> </td>\n" . " <td>\n" . ' <b>' . $tb_strings['OnDelete'] . "</b><br>\n" . " " . get_selectlist('cd_def_od_' . $idx, $fk_actions, $on_delete, TRUE) . "\n" . " </td>\n" . " </tr>\n" . " </table>\n" . " </td>\n" . " </tr>\n";
return $html;
}
</td>
<td align="left">
<input type="submit" name="acc_view_mod" value="<?php
echo $button_strings['Modify'];
?>
">
</td>
</tr>
<tr>
<td>
<b><?php
echo $acc_strings['SelViewDel'];
?>
</b>
</td>
<td>
<?php
echo get_table_selectlist('acc_delview_name', array('owner', 'views'), NULL, TRUE);
?>
</td>
<td align="left">
<input type="submit" name="acc_view_del" value="<?php
echo $button_strings['Delete'];
?>
">
</td>
</tr>
</table>
</form>
<?php
}
// Author Lutz Brueckner <*****@*****.**>
// Copyright (c) 2000, 2001, 2002, 2003, 2004 by Lutz Brueckner,
// published under the terms of the GNU General Public Licence v.2,
// see file LICENCE for details
if (isset($s_confirmations['table'])) {
$subject = 'table';
include './panels/confirm.php';
} elseif ($s_connected) {
?>
<form method="post" action="<?php
url_session($_SERVER['PHP_SELF']);
?>
" name="tb_delete_form">
<table class="table table-bordered">
<tr>
<td colspan="2">
<?php
echo '<b>' . $tb_strings['SelTbDel'] . "</b><br>\n" . get_table_selectlist('tb_delete_name', array('owner', 'noviews'), NULL, TRUE);
?>
</td>
<td valign="bottom">
<input type="submit" class="btn btn-danger" name="tb_delete_doit" value="<?php
echo $button_strings['Delete'];
?>
">
</td>
</tr>
</table>
</form>
<?php
}
<table class="table table-bordered">
<tr>
<th><?php
echo $dt_strings['SelTable'];
?>
</th>
<th><?php
echo $dt_strings['FileName'];
?>
</th>
<th> </th>
<tr>
<tr>
<td>
<?php
echo get_table_selectlist('dt_import_table', array('insert'), NULL, TRUE);
?>
</td>
<td>
<input type="file" size="30" name="dt_import_file">
</td>
<td>
<input type="submit" class="btn btn-default" name="dt_import_doit" value="<?php
echo $button_strings['Import'];
?>
">
</td>
</tr>
</table>
<input type="checkbox" name="dt_import_null" value="yes"<?php
if ($s_csv['import_null']) {
// published under the terms of the GNU General Public Licence v.2,
// see file LICENCE for details
if ($s_connected == TRUE && $s_enter_name == '') {
?>
<form method="post" action="<?php
echo url_session($_SERVER['PHP_SELF']);
?>
" name="dt_enter_form">
<table class="table table-bordered">
<tr>
<td colspan="2"><b><?php
echo $dt_strings['SelTable'];
?>
</b><br>
<?php
echo get_table_selectlist('dt_enter_name', array('noviews', 'insert'), NULL, TRUE);
?>
</td>
<td valign="bottom">
<input type="submit" class="btn btn-default" name="dt_enter_select" value="<?php
echo $button_strings['Select'];
?>
">
</td>
</tr>
</table>
</form>
<?php
} elseif ($s_connected == TRUE) {
$js_stack .= js_giveFocus('dt_enter_form', 'dt_enter_field_0');
$df = new DataFormEnter($s_enter_name, $s_fields[$s_enter_name], $s_enter_values);
</td>
<td>
<span id="dt_export_source_table_span" style="display:<?php
$s_export['source']['option'] == 'table' ? print 'block' : (print 'none');
?>
;">
<?php
echo get_table_selectlist('dt_export_source_table', array('select'), $s_export['source']['table'], TRUE);
?>
</span>
<span id="dt_export_source_dbtables_span" style="display:<?php
$s_export['source']['option'] == 'db' ? print 'block' : (print 'none');
?>
;">
<?php
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);"));
// Purpose html sequence for the table-watch-panel in sql.php and data.php
// 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 (!isset($tb_watch_cfg_flag) && $s_connected) {
?>
<form method="post" action="<?php
echo url_session($_SERVER['PHP_SELF']);
?>
" name="tb_watch_form">
<table class="table table-bordered">
<tr>
<td colspan="1">
<?php
echo '<b>' . $sql_strings['SelTable'] . "</b><br>\n" . get_table_selectlist('tb_watch_table', array('select'), $s_wt['table'], TRUE);
?>
<input type="submit" class="btn btn-default" name="tb_watch_select" value="<?php
echo $button_strings['Select'];
?>
">
</td>
<?php
if (isset($s_wt['table']) && $s_wt['table'] != '') {
echo "<td width=\"100\"> </td>\n";
$url = url_session($_SERVER['PHP_SELF'] . '?wcfg=true');
echo '<td><a href="' . $url . '" class="act">[' . $sql_strings['Config'] . "]</a></td>\n";
}
?>
</tr>
</table>
$subject = 'column';
include './panels/confirm.php';
} elseif ($s_connected && $s_modify_name == '') {
?>
<form method="post" action="<?php
echo url_session($_SERVER['PHP_SELF']);
?>
" name="tb_modify_form">
<table class="table table-bordered">
<tr>
<td colspan="2"><b><?php
echo $tb_strings['SelTbMod'];
?>
</b><br>
<?php
echo get_table_selectlist('tb_modify_name', array('owner', 'noviews'), NULL, TRUE);
?>
</td>
<td valign="bottom">
<input type="submit" class="btn btn-default" name="tb_modify_doit" value="<?php
echo $button_strings['Modify'];
?>
">
</td>
</tr>
</table>
</form>
<?php
} elseif (isset($col_add_flag)) {
js_checkColConstraint();
?>
function index_definition($indexname, $title)
{
global $indices, $acc_strings;
if ($indexname != NULL && !isset($_POST['acc_modind_doit'])) {
$name = $indexname;
$table = $indices[$indexname]['table'];
$dir = $indices[$indexname]['dir'];
$uniq = $indices[$indexname]['uniq'];
$active = $indices[$indexname]['active'];
$segs = implode(',', $indices[$indexname]['seg']);
} else {
$name = isset($_POST['def_index_name']) ? $_POST['def_index_name'] : '';
$table = isset($_POST['def_index_table']) ? $_POST['def_index_table'] : '';
$dir = isset($_POST['def_index_dir']) ? $_POST['def_index_dir'] : 'ASC';
$uniq = isset($_POST['def_index_uniq']) ? TRUE : FALSE;
$active = isset($_POST['def_index_activ']) ? TRUE : FALSE;
$segs = isset($_POST['def_index_segs']) ? $_POST['def_index_segs'] : '';
}
?>
<table>
<tr>
<th colspan="6" align="left"><?php
echo $title;
?>
</th>
</tr>
<tr>
<td valign="top"><b><?php
echo $acc_strings['Name'];
?>
</b><br>
<input type="text" size="20" maxlength="31" name="def_index_name" value="<?php
echo $name;
?>
">
</td>
<td valign="top"><b><?php
echo $acc_strings['Table'];
?>
</b><br>
<?php
echo get_table_selectlist('def_index_table', array('noviews', 'owner'), $table, TRUE);
?>
</td>
<td align="center" valign="top"><b><?php
echo $acc_strings['Active'];
?>
</b><br>
<input type="checkbox" name="def_index_activ" <?php
if ($active) {
echo 'checked';
}
?>
>
</td>
<td align="center" valign="top"><b><?php
echo $acc_strings['Unique'];
?>
</b><br>
<input type="checkbox" name="def_index_uniq" <?php
if ($uniq) {
echo 'checked';
}
?>
>
</td>
<td align="center" valign="top"><b><?php
echo $acc_strings['Sort'];
?>
</b><br>
<select name="def_index_dir">
<option<?php
if ($dir == 'ASC') {
echo ' selected';
}
?>
> ASC
<option<?php
if ($dir == 'DESC') {
echo ' selected';
}
?>
> DESC
</select>
</td>
<td valign="top"><b><?php
echo $acc_strings['ColExpl'];
?>
</b><br>
<input type="text" size="30" maxlength="128" name="def_index_segs" value="<?php
echo $segs;
?>
">
</td>
</tr>
</table>
<?php
}