function display_add_field($recordid = 0) { global $CFG, $DB, $OUTPUT; $text = ''; $format = 0; if ($recordid) { if ($content = $DB->get_record('data_content', array('fieldid' => $this->field->id, 'recordid' => $recordid))) { $text = $content->content; $format = $content->content1; } } $str = '<div title="' . $this->field->description . '">'; if (can_use_html_editor()) { // Show a rich text html editor. $str .= $this->gen_textarea(true, $text); $str .= $OUTPUT->help_icon(moodle_help_icon::make("richtext2", get_string("helprichtext"), 'moodle', true)); $str .= '<input type="hidden" name="field_' . $this->field->id . '_content1' . '" value="' . FORMAT_HTML . '" />'; } else { // Show a normal textarea. Also let the user specify the format to be used. $str .= $this->gen_textarea(false, $text); // Get the available text formats for this field. $formatsForField = format_text_menu(); $str .= '<br />'; $select = html_select($formatsForField, 'field_' . $this->field->id . '_content1', $format); $select->nothingvalue = ''; $str .= $OUTPUT->select($select); $str .= $OUTPUT->help_icon(moodle_help_icon::make('textformat', get_string('helpformatting'), 'moodle')); } $str .= '</div>'; return $str; }
function switch_lang() { global $LANG, $langs; echo "<form action=''>\n<div id='lang'>"; hidden_fields($_GET, array('lang')); echo lang('Language') . ": " . html_select("lang", $langs, $LANG, "var loc = location.search.replace(/[?&]lang=[^&]*/, ''); location.search = loc + (loc ? '&' : '') + 'lang=' + this.value;"); echo " <input type='submit' value='" . lang('Use') . "' class='hidden'>\n"; echo "</div>\n</form>\n"; }
function switch_lang() { global $LANG, $langs, $token; echo "<form action='' method='post'>\n<div id='lang'>"; echo lang('Language') . ": " . html_select("lang", $langs, $LANG, "this.form.submit();"); echo " <input type='submit' value='" . lang('Use') . "' class='hidden'>\n"; echo "<input type='hidden' name='token' value='{$token}'>\n"; echo "</div>\n</form>\n"; }
function switch_lang() { //Presenta la lista de seleccion de idiomas global $LANG, $langs; echo "<form action='' method='post'>\n\n\t\t<div id='lang'>\n\t\t\t<div class='input-group'>\n\t\t\t\t<span class='input-group-addon'>\n\t\t\t\t\t<i class='fa fa-language'></i> "; echo lang('Language') . "\n\t\t\t\t</span>\n\t\t\t" . html_select("lang", $langs, $LANG, "this.form.submit();", "btn-default btn-xs"); echo " <input type='submit' value='" . lang('Use') . "' class='hidden'>\n"; echo "<input type='hidden' name='token' value='" . get_token() . "'>\n"; // $token may be empty in auth.inc.php echo "</div>\n\n\t\t</div>\n\t\t</form>\n"; }
public function getFilterInput($value) { $items = $this->getListItems(); if (!$this->getOption('filter_multiple')) { $items = array('' => '') + $items; // array_pad($items, (sizeof($items)+1)*-1, ''); return html_select($this->name, $items, $value); } else { $value = is_array($value) ? $value : array(); return html_select_multiple($this->name, $items, $value); } }
function selectEmailPrint($emailFields, $columns) { if ($emailFields) { print_fieldset("email", 'E-mail'); echo "<div onkeydown=\"eventStop(event); return bodyKeydown(event, 'email');\">\n"; echo "<p>" . 'From' . ": <input name='email_from' value='" . h($_POST ? $_POST["email_from"] : $_COOKIE["adminer_email"]) . "'>\n"; echo 'Subject' . ": <select name='email_id'><option>" . optionlist(get_key_vals("SELECT {$this->id}, {$this->title} FROM {$this->table} ORDER BY {$this->title}"), $_POST["email_id"], true) . "</select>\n"; echo "<p>" . 'Attachments' . ": <input type='file' name='email_files[]' onchange=\"this.onchange = function () { }; var el = this.cloneNode(true); el.value = ''; this.parentNode.appendChild(el);\">"; echo "<p>" . (count($emailFields) == 1 ? '<input type="hidden" name="email_field" value="' . h(key($emailFields)) . '">' : html_select("email_field", $emailFields)); echo "<input type='submit' name='email' value='" . 'Send' . "' onclick=\"return this.form['delete'].onclick();\">\n"; echo "</div>\n"; echo "</div></fieldset>\n"; return true; } }
function dataERP($params) { global $sugar_config, $mod_strings; require $sugar_config['path_parametros'] . "param_criterio_cotizacion.php"; require_once "custom/opalo/lib/ERP/Utils.php"; require_once "custom/opalo/lib/Utils.php"; $account_field = isset($params['account_field']) ? $params['account_field'] : "account_id"; //Campo para obtener el id del cliente $parametros = array(array('etiqueta' => 'LBL_REFERENCIA', 'html' => inputHtml('referencia', '', 'form-control')), array('etiqueta' => 'LBL_DESCRIPCION', 'html' => inputHtml('descripcion', '', 'form-control'))); $js_params = array('referencia', 'descripcion'); foreach ($criterio_cotizacion as $id_plan => $etiqueta) { $parametros[] = array('etiqueta' => $etiqueta, 'html' => html_select("criterios[{$id_plan}]", getCriterios($id_plan), '', false, 'form-control', true)); $js_params[] = "criterios\\[{$id_plan}\\]"; } $num_col = 6; $css = array("custom/opalo/Vendor/datatables/css/jquery.dataTables.css"); $html .= ""; foreach ($css as $incluir) { $html .= '<link rel="stylesheet" type="text/css" href="' . $incluir . '" />'; } $html .= "<div class='panel panel-primary'>"; $html .= "<div class='panel-heading'>\n <h3 class='panel-title'>\n Items ERP <a data-toggle='collapse' href='#wp_erp' class='btn_switch_panel'><span class='caret'></span></a> \n <button type='button' class='close' aria-hidden='true'>×</button>\n </h3>\n </div>"; $html .= "<div class='panel-body'>"; $html .= "<div id='wp_erp' class='collapse text-center'>"; $html .= "<div class='wp_filters row'>"; while (count($parametros) > 0) { for ($contador = 0; $contador < $num_col; $contador++) { $porc = 100 / ($num_col * 2); $data = array_shift($parametros); $label = $data['etiqueta']; if (isset($mod_strings[$data['etiqueta']])) { $label = $mod_strings[$data['etiqueta']]; } $html .= "<div class='col-md-3 form-group'><label>" . $label . "</label>" . $data['html'] . "</div>"; } } $html .= "</div><br/>"; $html .= "<a href='#' class='btn btn-primary btn-lg' onclick='post_to_html(" . json_encode($js_params) . ",\"resultados_items\",\"{$account_field}\",\"ajax_items_erp\"); return false;'>Filtrar</a><br/><br/>"; $html .= "<div id='resultados_items'></div>"; $html .= "</div>"; //.wp_erp $html .= "</div>"; //.content $html .= "</div>"; //.panel $html .= "<script type='text/javascript'>\n post_to_html(" . json_encode($js_params) . ",\"resultados_items\",\"{$account_field}\",\"ajax_items_erp\")\n </script>"; return $html; }
public function loginForm() { $drivers = array('server' => 'MySQL'); ?> <table cellspacing="0"> <tr><th>Systém<td><?php echo html_select("driver", $drivers, DRIVER); ?> <tr><th>Uživatel<td><input type="text" name="username" id="username" value="<?php echo h($_GET["username"]); ?> "> <tr><th>Heslo<td><input type="password" name="password" id="password"> </table> <input name="server" type="hidden" value="localhost"> <script type="text/javascript"> document.getElementById('username').focus(); </script> <p><input type="submit" value="Přihlásit"> <?php echo checkbox("permanent", 1, $_COOKIE["adminer_permanent"], 'Trvalé přihlášení') . "\n"; }
html_n('</td></tr></form>'); if (!empty($_POST['path'])) { html_n('<tr><td>找到文件:<br><br>'); if (isset($_POST['pass'])) { $bool = true; } else { $bool = false; } do_passreturn($_POST['path'], $_POST['code'], $_POST['return'], $bool); } break; case "scanphp": html_n('<tr><td>原理是根据特征码定义的,请查看代码判断后再进行删除.<form method="POST"><br>'); html_input("text", "path", root_dir, "查找范围", "40"); html_input("checkbox", "pass", "", "使用目录遍历<br><br>脚本类型", "", true); html_select(array("php" => "PHP", "asp" => "ASP", "aspx" => "ASPX", "jsp" => "JSP")); html_input("submit", "passreturn", "查找", "<br><br>"); html_n('</td></tr></form>'); if (!empty($_POST['path'])) { html_n('<tr><td>找到文件:<br><br>'); if (isset($_POST['pass'])) { $bool = true; } else { $bool = false; } do_passreturn($_POST['path'], $_POST['class'], "scanphp", $bool); } break; case "port": $Port_ip = isset($_POST['ip']) ? $_POST['ip'] : '127.0.0.1'; $Port_port = isset($_POST['port']) ? $_POST['port'] : '21|23|25|80|110|135|139|445|1433|3306|3389|43958|5631';
: formChecked(this, /check/)) + ')');"> </div></fieldset> <?php } $format = $adminer->dumpFormat(); if ($format) { print_fieldset("export", lang('Export')); $output = $adminer->dumpOutput(); echo $output ? html_select("output", $output, $adminer_import["output"]) . " " : ""; echo html_select("format", $format, $adminer_import["format"]); echo " <input type='submit' name='export' value='" . lang('Export') . "'>\n"; echo "</div></fieldset>\n"; } } if ($adminer->selectImportPrint()) { print_fieldset("import", lang('Import'), !$rows); echo "<input type='file' name='csv_file'> "; echo html_select("separator", array("csv" => "CSV,", "csv;" => "CSV;", "tsv" => "TSV"), $adminer_import["format"], 1); // 1 - select echo " <input type='submit' name='import' value='" . lang('Import') . "'>"; echo "<input type='hidden' name='token' value='{$token}'>\n"; echo "</div></fieldset>\n"; } $adminer->selectEmailPrint(array_filter($email_fields, 'strlen'), $columns); echo "</form>\n"; } } if (is_ajax()) { ob_end_clean(); exit; }
$result = $connection->store_result(); $time = " <span class='time'>(" . format_time($start) . ")</span>" . (strlen($q) < 1000 ? " <a href='" . h(ME) . "sql=" . urlencode(trim($q)) . "'>" . lang('Edit') . "</a>" : ""); if ($connection->error) { echo $_POST["only_errors"] ? $print : ""; echo "<p class='error'>" . lang('Error in query') . ($connection->errno ? " ({$connection->errno})" : "") . ": " . error() . "\n"; $errors[] = " <a href='#sql-{$commands}'>{$commands}</a>"; if ($_POST["error_stops"]) { break 2; } } elseif (is_object($result)) { $orgtables = select($result, $connection2); if (!$_POST["only_errors"]) { echo "<form action='' method='post'>\n"; echo "<p>" . ($result->num_rows ? lang('%d row(s)', $result->num_rows) : "") . $time; $id = "export-{$commands}"; $export = ", <a href='#{$id}' onclick=\"return !toggle('{$id}');\">" . lang('Export') . "</a><span id='{$id}' class='hidden'>: " . html_select("output", $adminer->dumpOutput(), $adminer_export["output"]) . " " . html_select("format", $dump_format, $adminer_export["format"]) . "<input type='hidden' name='query' value='" . h($q) . "'>" . " <input type='submit' name='export' value='" . lang('Export') . "'><input type='hidden' name='token' value='{$token}'></span>\n"; if ($connection2 && preg_match("~^({$space}|\\()*SELECT\\b~isU", $q) && ($explain = explain($connection2, $q))) { $id = "explain-{$commands}"; echo ", <a href='#{$id}' onclick=\"return !toggle('{$id}');\">EXPLAIN</a>{$export}"; echo "<div id='{$id}' class='hidden'>\n"; select($explain, $connection2, $orgtables); echo "</div>\n"; } else { echo $export; } echo "</form>\n"; } } else { if (preg_match("~^{$space}*(CREATE|DROP|ALTER){$space}+(DATABASE|SCHEMA)\\b~isU", $q)) { restart_session(); set_session("dbs", null);
<td class="center"> <?php if ($rule['type'] == 'flag') { ?> <?php echo html_checkbox("value[{$rule['id']}][{$subject['name']}]", $default); ?> <?php } ?> <?php if ($rule['type'] == 'list') { ?> <?php echo html_select("value[{$rule['id']}][{$subject['name']}]", $rule['options'], $default); ?> <?php } ?> <?php if ($rule['type'] == 'number') { ?> <?php echo html_input('text', "value[{$rule['id']}][{$subject['name']}]", $default, array('class' => 'input-number')); ?> <?php } ?> </td>
echo lang('Time'); ?> <td><?php echo html_select("Timing", $trigger_options["Timing"], $row["Timing"], "if (/^" . preg_quote($TABLE, "/") . "_[ba][iud]\$/.test(this.form['Trigger'].value)) this.form['Trigger'].value = '" . js_escape($TABLE) . "_' + selectValue(this).charAt(0).toLowerCase() + selectValue(this.form['Event']).charAt(0).toLowerCase();"); ?> <tr><th><?php echo lang('Event'); ?> <td><?php echo html_select("Event", $trigger_event, $row["Event"], "this.form['Timing'].onchange();"); ?> <tr><th><?php echo lang('Type'); ?> <td><?php echo html_select("Type", $trigger_options["Type"], $row["Type"]); ?> </table> <p><?php echo lang('Name'); ?> : <input name="Trigger" value="<?php echo h($row["Trigger"]); ?> " maxlength="64"> <p><?php textarea("Statement", $row["Statement"]); ?> <p> <input type="submit" value="<?php echo lang('Save');
?> </h1> <div id="search_form"> <form action="<?php echo href_to('search'); ?> " method="get"> <?php echo html_input('text', 'q', $query, array('placeholder' => LANG_SEARCH_QUERY_INPUT)); ?> <?php echo html_select('type', array('words' => LANG_SEARCH_TYPE_WORDS, 'exact' => LANG_SEARCH_TYPE_EXACT), $type); ?> <?php echo html_select('date', array('all' => LANG_SEARCH_DATES_ALL, 'w' => LANG_SEARCH_DATES_W, 'm' => LANG_SEARCH_DATES_M, 'y' => LANG_SEARCH_DATES_Y), $date); ?> <?php echo html_submit(LANG_FIND); ?> </form> </div> <?php if ($query && empty($search_data)) { ?> <p id="search_no_results"><?php echo LANG_SEARCH_NO_RESULTS; ?> </p> <?php
echo "<tr><td> <th>" . lang('%d in total', count($tables_list)); echo "<td>" . nbsp($jush == "sql" ? $connection->result("SELECT @@storage_engine") : ""); echo "<td>" . nbsp(db_collation(DB, collations())); foreach (array("Data_length", "Index_length", "Data_free") as $key) { echo "<td align='right' id='sum-{$key}'> "; } echo "</table>\n"; if (!information_schema(DB)) { $vacuum = "<input type='submit' value='" . lang('Vacuum') . "'" . on_help("'VACUUM'") . "> "; $optimize = "<input type='submit' name='optimize' value='" . lang('Optimize') . "'" . on_help($jush == "sql" ? "'OPTIMIZE TABLE'" : "'VACUUM OPTIMIZE'") . "> "; echo "<fieldset><legend>" . lang('Selected') . " <span id='selected'></span></legend><div>" . ($jush == "sqlite" ? $vacuum : ($jush == "pgsql" ? $vacuum . $optimize : ($jush == "sql" ? "<input type='submit' value='" . lang('Analyze') . "'" . on_help("'ANALYZE TABLE'") . "> " . $optimize . "<input type='submit' name='check' value='" . lang('Check') . "'" . on_help("'CHECK TABLE'") . "> " . "<input type='submit' name='repair' value='" . lang('Repair') . "'" . on_help("'REPAIR TABLE'") . "> " : ""))) . "<input type='submit' name='truncate' value='" . lang('Truncate') . "'" . confirm() . on_help($jush == "sqlite" ? "'DELETE'" : "'TRUNCATE" . ($jush == "pgsql" ? "'" : " TABLE'")) . "> " . "<input type='submit' name='drop' value='" . lang('Drop') . "'" . confirm() . on_help("'DROP TABLE'") . ">\n"; $databases = support("scheme") ? $adminer->schemas() : $adminer->databases(); if (count($databases) != 1 && $jush != "sqlite") { $db = isset($_POST["target"]) ? $_POST["target"] : (support("scheme") ? $_GET["ns"] : DB); echo "<p>" . lang('Move to other database') . ": "; echo $databases ? html_select("target", $databases, $db) : '<input name="target" value="' . h($db) . '" autocapitalize="off">'; echo " <input type='submit' name='move' value='" . lang('Move') . "'>"; echo support("copy") ? " <input type='submit' name='copy' value='" . lang('Copy') . "'>" : ""; echo "\n"; } echo "<input type='hidden' name='all' value='' onclick=\"selectCount('selected', formChecked(this, /^(tables|views)\\[/));" . (support("table") ? " selectCount('selected2', formChecked(this, /^tables\\[/) || {$tables});" : "") . "\">\n"; // used by trCheck() echo "<input type='hidden' name='token' value='{$token}'>\n"; echo "</div></fieldset>\n"; } echo "</form>\n"; echo "<script type='text/javascript'>tableCheck();</script>\n"; } echo '<p class="links"><a href="' . h(ME) . 'create=">' . lang('Create table') . "</a>\n"; echo support("view") ? '<a href="' . h(ME) . 'view=">' . lang('Create view') . "</a>\n" : ""; echo support("materializedview") ? '<a href="' . h(ME) . 'view=&materialized=1">' . lang('Create materialized view') . "</a>\n" : "";
?> <th><?php echo lang('Column (length)'); ?> <th><?php echo lang('Name'); ?> </thead> <?php $j = 1; foreach ($row["indexes"] as $index) { echo "<tr><td>" . html_select("indexes[{$j}][type]", array(-1 => "") + $index_types, $index["type"], $j == count($row["indexes"]) ? "indexesAddRow(this);" : 1) . "<td>"; ksort($index["columns"]); $i = 1; foreach ($index["columns"] as $key => $column) { echo "<span>" . html_select("indexes[{$j}][columns][{$i}]", array(-1 => "") + $fields, $column, ($i == count($index["columns"]) ? "indexesAddColumn" : "indexesChangeColumn") . "(this, '" . js_adminer_escape($jush == "sql" ? "" : $_GET["indexes"] . "_") . "');"); echo "<input name='indexes[{$j}][lengths][{$i}]' size='2' value='" . h($index["lengths"][$key]) . "'> </span>"; //! hide for non-MySQL drivers, add ASC|DESC $i++; } echo "<td><input name='indexes[{$j}][name]' value='" . h($index["name"]) . "'>\n"; $j++; } ?> </table> <p> <input type="submit" value="<?php echo lang('Save'); ?> "> <noscript><p><input type="submit" name="add" value="<?php
echo $_POST["only_errors"] ? $print : ""; echo "<p class='error'>" . lang('Error in query') . ($connection->errno ? " ({$connection->errno})" : "") . ": " . error() . "\n"; $errors[] = " <a href='#sql-{$commands}'>{$commands}</a>"; if ($_POST["error_stops"]) { break 2; } } elseif (is_object($result)) { $limit = $_POST["limit"]; $orgtables = select($result, $connection2, array(), $limit); if (!$_POST["only_errors"]) { echo "<form action='' method='post'>\n"; $num_rows = $result->num_rows; echo "<p>" . ($num_rows ? ($limit && $num_rows > $limit ? lang('%d / ', $limit) : "") . lang('%d row(s)', $num_rows) : ""); echo $time; $id = "export-{$commands}"; $export = ", <a href='#{$id}' onclick=\"return !toggle('{$id}');\">" . lang('Export') . "</a><span id='{$id}' class='hidden'>: " . html_select("output", $adminer->dumpOutput(), $adminer_export["output"], "alterClass(document.getElementById('filename'), 'hidden', !(this.value=='file'||this.value=='gz'))") . " " . "<input type='text' name='filename' id='filename' class='hidden'> " . html_select("format", $dump_format, $adminer_export["format"]) . "<input type='hidden' name='query' value='" . h($q) . "'>" . " <input type='submit' name='export' value='" . lang('Export') . "'><input type='hidden' name='token' value='{$token}'></span>\n"; if ($connection2 && preg_match("~^({$space}|\\()*SELECT\\b~isU", $q) && ($explain = explain($connection2, $q))) { $id = "explain-{$commands}"; echo ", <a href='#{$id}' onclick=\"return !toggle('{$id}');\">EXPLAIN</a>{$export}"; echo "<div id='{$id}' class='hidden'>\n"; select($explain, $connection2, $orgtables); echo "</div>\n"; } else { echo $export; } echo "</form>\n"; } } else { if (preg_match("~^{$space}*(CREATE|DROP|ALTER){$space}+(DATABASE|SCHEMA)\\b~isU", $q)) { restart_session(); set_session("dbs", null);
?> <div class="content_moderation_notice icon-info"> <?php echo LANG_MODERATION_NOTICE; ?> </div> <?php } ?> <?php if ($is_multi_cats) { ?> <div class="content_multi_cats_data"> <?php echo html_select('add_cats[]', array(), '', array('multiple' => true)); ?> </div> <?php } ?> <?php if ($props || $is_multi_cats) { ?> <script> <?php if ($is_multi_cats) { ?> <?php echo $this->getLangJS('LANG_LIST_EMPTY', 'LANG_SELECT', 'LANG_CONTENT_SELECT_CATEGORIES');
/** Print search box in select * @param array result of selectSearchProcess() * @param array selectable columns * @param array * @return null */ function selectSearchPrint($where, $columns, $indexes) { print_fieldset("search", lang('Search'), $where); foreach ($indexes as $i => $index) { if ($index["type"] == "FULLTEXT") { echo "(<i>" . implode("</i>, <i>", array_map('h', $index["columns"])) . "</i>) AGAINST"; echo " <input type='search' name='fulltext[{$i}]' value='" . h($_GET["fulltext"][$i]) . "' onchange='selectFieldChange(this.form);'>"; echo checkbox("boolean[{$i}]", 1, isset($_GET["boolean"][$i]), "BOOL"); echo "<br>\n"; } } $_GET["where"] = (array) $_GET["where"]; reset($_GET["where"]); $change_next = "this.nextSibling.onchange();"; for ($i = 0; $i <= count($_GET["where"]); $i++) { list(, $val) = each($_GET["where"]); if (!$val || "{$val['col']}{$val['val']}" != "" && in_array($val["op"], $this->operators)) { echo "<div>" . select_input(" name='where[{$i}][col]' onchange='{$change_next}'", $columns, $val["col"], "(" . lang('anywhere') . ")"); echo html_select("where[{$i}][op]", $this->operators, $val["op"], $change_next); echo "<input type='search' name='where[{$i}][val]' value='" . h($val["val"]) . "' onchange='" . ($val ? "selectFieldChange(this.form)" : "selectAddRow(this)") . ";' onkeydown='selectSearchKeydown(this, event);' onsearch='selectSearchSearch(this);'></div>\n"; } } echo "</div></fieldset>\n"; }
$j++; } ?> </table> <p> <?php echo lang('ON DELETE'); ?> : <?php echo html_select("on_delete", array(-1 => "") + explode("|", $on_actions), $row["on_delete"]); ?> <?php echo lang('ON UPDATE'); ?> : <?php echo html_select("on_update", array(-1 => "") + explode("|", $on_actions), $row["on_update"]); ?> <p> <input type="submit" value="<?php echo lang('Save'); ?> "> <noscript><p><input type="submit" name="add" value="<?php echo lang('Add column'); ?> "></noscript> <?php } if ($_GET["name"] != "") { ?> <input type="submit" name="drop" value="<?php
function html_select_range($name, $start, $end, $step, $add_lead_zero = false, $selected = '', $attributes = array()) { $items = array(); for ($i = $start; $i <= $end; $i += $step) { if ($add_lead_zero) { $i = $i > 9 ? $i : "0{$i}"; } $items[$i] = $i; } return html_select($name, $items, $selected, $attributes); }
$row["collation"] = db_collation(DB, $collations); } elseif ($jush == "sql") { // propose database name with limited privileges foreach (get_vals("SHOW GRANTS") as $grant) { if (preg_match('~ ON (`(([^\\\\`]|``|\\\\.)*)%`\\.\\*)?~', $grant, $match) && $match[1]) { $name = stripcslashes(idf_unescape("`{$match['2']}`")); break; } } } ?> <form action="" method="post"> <p> <?php echo ($_POST["add_x"] || strpos($name, "\n") ? '<textarea id="name" name="name" rows="10" cols="40">' . h($name) . '</textarea><br>' : '<input name="name" id="name" value="' . h($name) . '" maxlength="64" autocapitalize="off">') . "\n" . ($collations ? html_select("collation", array("" => "(" . lang('collation') . ")") + $collations, $row["collation"]) . doc_link(array('sql' => "charset-charsets.html", 'mssql' => "ms187963.aspx")) : ""); ?> <script type='text/javascript'>focus(document.getElementById('name'));</script> <input type="submit" value="<?php echo lang('Save'); ?> "> <?php if (DB != "") { echo "<input type='submit' name='drop' value='" . lang('Drop') . "'" . confirm() . ">\n"; } elseif (!$_POST["add_x"] && $_GET["db"] == "") { echo "<input type='image' class='icon' name='add' src='../adminer/static/plus.gif' alt='+' title='" . lang('Add next') . "'>\n"; } ?> <input type="hidden" name="token" value="<?php echo $token;
private function user_data($username = '', $im = '', $im_id = '', $user_active = '', $im_active = '') { return array(array('label' => 'Username', 'input' => html_input('text', array('name="username"', 'value="' . $username . '"', 'class="span3"'))), array('label' => 'Pilih IM', 'input' => html_select('im_type', ' Pilih IM ', $im)), array('label' => 'ID IM', 'input' => html_input('text', array('name="im_id"', 'value="' . $im_id . '"', 'class="span3"'))), array('label' => 'Aktifkan user', 'input' => $user_active), array('label' => 'Aktifkan IM', 'input' => $im_active), array('label' => 'Kata sandi', 'input' => html_input('password', array('name="password"', 'id="password"'))), array('label' => 'Ulangi kata sandi', 'input' => html_input('password', array('name="re_password"', 'id="re_password"')))); }
<?php echo html_submit('+'); ?> <label id="is_childs"> <?php echo html_checkbox('is_childs', true); ?> <?php echo LANG_CP_PROPS_BIND_RECURSIVE; ?> </label> </div> </form> <div style="display:none"> <?php echo html_select('props_list', array_collection_to_list($props, 'id', 'title')); ?> </div> <?php } ?> <div class="buttons"> <?php echo html_button(LANG_SAVE_ORDER, 'save_button', "icms.datagrid.submit('{$this->href_to('ctypes', array('props_reorder', $ctype['name']))}')"); ?> </div> </td> </tr> </table>
parse_str($_COOKIE["adminer_export"], $row); if (!$row) { $row = array("output" => "text", "format" => "sql", "db_style" => DB != "" ? "" : "CREATE", "table_style" => "DROP+CREATE", "data_style" => "INSERT"); } if (!isset($row["events"])) { // backwards compatibility $row["routines"] = $row["events"] = $_GET["dump"] == ""; $row["triggers"] = $row["table_style"]; } echo "<tr><th>" . lang('Output') . "<td>" . html_select("output", $adminer->dumpOutput(), $row["output"], 0) . "\n"; // 0 - radio echo "<tr><th>" . lang('Format') . "<td>" . html_select("format", $adminer->dumpFormat(), $row["format"], 0) . "\n"; // 0 - radio echo $jush == "sqlite" ? "" : "<tr><th>" . lang('Database') . "<td>" . html_select('db_style', $db_style, $row["db_style"]) . (support("routine") ? adminer_checkbox("routines", 1, $row["routines"], lang('Routines')) : "") . (support("event") ? adminer_checkbox("events", 1, $row["events"], lang('Events')) : ""); echo "<tr><th>" . lang('Tables') . "<td>" . html_select('table_style', $table_style, $row["table_style"]) . adminer_checkbox("auto_increment", 1, $row["auto_increment"], lang('Auto Increment')) . (support("trigger") ? adminer_checkbox("triggers", 1, $row["triggers"], lang('Triggers')) : ""); echo "<tr><th>" . lang('Data') . "<td>" . html_select('data_style', $data_style, $row["data_style"]); ?> </table> <p><input type="submit" value="<?php echo lang('Export'); ?> "> <input type="hidden" name="token" value="<?php echo $token; ?> "> <table cellspacing="0"> <?php $prefixes = array(); if (DB != "") {
if (support("columns") || $TABLE == "") { echo lang('Table name'); ?> : <input name="name" maxlength="64" value="<?php echo h($row["name"]); ?> " autocapitalize="off"> <?php if ($TABLE == "" && !$_POST) { ?> <script type='text/javascript'>focus(document.getElementById('form')['name']);</script><?php } echo $engines ? "<select name='Engine' onchange='helpClose();'" . on_help("getTarget(event).value", 1) . ">" . optionlist(array("" => "(" . lang('engine') . ")") + $engines, $row["Engine"]) . "</select>" : ""; ?> <?php echo $collations && !preg_match("~sqlite|mssql~", $jush) ? html_select("Collation", array("" => "(" . lang('collation') . ")") + $collations, $row["Collation"]) : ""; ?> <input type="submit" value="<?php echo lang('Save'); ?> "> <?php } ?> <?php if (support("columns")) { ?> <table cellspacing="0" id="edit-fields" class="nowrap"> <?php $comments = $_POST ? $_POST["comments"] : $row["Comment"] != "";
function select_timebase($name, $default = 0) { $items = array('--' => 0, '5m' => 5, '10m' => 10, '15m' => 15, '30m' => 30, '1h' => 60, '2h' => 120, '3h' => 180, '8h' => 480, '24h' => 1440); html_select($name, $items, $default); }
/** Print table interior for fields editing * @param array * @param array * @param string TABLE or PROCEDURE * @param array returned by referencable_primary() * @param bool display comments column * @return null */ function edit_fields($fields, $collations, $type = "TABLE", $foreign_keys = array(), $comments = false) { global $connection, $inout; $fields = array_values($fields); ?> <thead><tr class="wrap"> <?php if ($type == "PROCEDURE") { ?> <td> <?php } ?> <th><?php echo $type == "TABLE" ? lang('Column name') : lang('Parameter name'); ?> <td><?php echo lang('Type'); ?> <textarea id="enum-edit" rows="4" cols="12" wrap="off" style="display: none;" onblur="editingLengthBlur(this);"></textarea> <td><?php echo lang('Length'); ?> <td><?php echo lang('Options'); if ($type == "TABLE") { ?> <td>NULL <td><input type="radio" name="auto_increment_col" value=""><acronym title="<?php echo lang('Auto Increment'); ?> ">AI</acronym><?php echo doc_link(array('sql' => "example-auto-increment.html", 'sqlite' => "autoinc.html", 'pgsql' => "datatype.html#DATATYPE-SERIAL", 'mssql' => "ms186775.aspx")); ?> <td><?php echo lang('Default value'); echo support("comment") ? "<td" . ($comments ? "" : " class='hidden'") . ">" . lang('Comment') : ""; } ?> <td><?php echo "<input type='image' class='icon' name='add[" . (support("move_col") ? 0 : count($fields)) . "]' src='../adminer/static/plus.gif' alt='+' title='" . lang('Add next') . "'>"; ?> <script type="text/javascript">row_count = <?php echo count($fields); ?> ;</script> </thead> <tbody onkeydown="return editingKeydown(event);"> <?php foreach ($fields as $i => $field) { $i++; $orig = $field[$_POST ? "orig" : "field"]; $display = (isset($_POST["add"][$i - 1]) || isset($field["field"]) && !$_POST["drop_col"][$i]) && (support("drop_col") || $orig == ""); ?> <tr<?php echo $display ? "" : " style='display: none;'"; ?> > <?php echo $type == "PROCEDURE" ? "<td>" . html_select("fields[{$i}][inout]", explode("|", $inout), $field["inout"]) : ""; ?> <th><?php if ($display) { ?> <input name="fields[<?php echo $i; ?> ][field]" value="<?php echo h($field["field"]); ?> " onchange="editingNameChange(this);<?php echo $field["field"] != "" || count($fields) > 1 ? '' : ' editingAddRow(this);" onkeyup="if (this.value) editingAddRow(this);'; ?> " maxlength="64" autocapitalize="off"><?php } ?> <input type="hidden" name="fields[<?php echo $i; ?> ][orig]" value="<?php echo h($orig); ?> "> <?php edit_type("fields[{$i}]", $field, $collations, $foreign_keys); if ($type == "TABLE") { ?> <td><?php echo checkbox("fields[{$i}][null]", 1, $field["null"], "", "", "block"); ?> <td><label class="block"><input type="radio" name="auto_increment_col" value="<?php echo $i; ?> "<?php if ($field["auto_increment"]) { ?> checked<?php } ?> onclick="var field = this.form['fields[' + this.value + '][field]']; if (!field.value) { field.value = 'id'; field.onchange(); }"></label><td><?php echo checkbox("fields[{$i}][has_default]", 1, $field["has_default"]); ?> <input name="fields[<?php echo $i; ?> ][default]" value="<?php echo h($field["default"]); ?> " onkeyup="keyupChange.call(this);" onchange="this.previousSibling.checked = true;"> <?php echo support("comment") ? "<td" . ($comments ? "" : " class='hidden'") . "><input name='fields[{$i}][comment]' value='" . h($field["comment"]) . "' maxlength='" . ($connection->server_info >= 5.5 ? 1024 : 255) . "'>" : ""; } echo "<td>"; echo support("move_col") ? "<input type='image' class='icon' name='add[{$i}]' src='../adminer/static/plus.gif' alt='+' title='" . lang('Add next') . "' onclick='return !editingAddRow(this, 1);'> " . "<input type='image' class='icon' name='up[{$i}]' src='../adminer/static/up.gif' alt='^' title='" . lang('Move up') . "'> " . "<input type='image' class='icon' name='down[{$i}]' src='../adminer/static/down.gif' alt='v' title='" . lang('Move down') . "'> " : ""; echo $orig == "" || support("drop_col") ? "<input type='image' class='icon' name='drop_col[{$i}]' src='../adminer/static/cross.gif' alt='x' title='" . lang('Remove') . "' onclick=\"return !editingRemoveRow(this, 'fields\$1[field]');\">" : ""; echo "\n"; } }
?> '></noscript> </thead> <?php if ($primary) { echo "<tr><td>PRIMARY<td>"; foreach ($primary["columns"] as $key => $column) { echo select_input(" disabled", $fields, $column); echo "<label><input disabled type='checkbox'>" . lang('descending') . "</label> "; } echo "<td><td>\n"; } $j = 1; foreach ($row["indexes"] as $index) { if (!$_POST["drop_col"] || $j != key($_POST["drop_col"])) { echo "<tr><td>" . html_select("indexes[{$j}][type]", array(-1 => "") + $index_types, $index["type"], $j == count($row["indexes"]) ? "indexesAddRow(this);" : 1); echo "<td>"; ksort($index["columns"]); $i = 1; foreach ($index["columns"] as $key => $column) { echo "<span>" . select_input(" name='indexes[{$j}][columns][{$i}]' onchange=\"" . ($i == count($index["columns"]) ? "indexesAddColumn" : "indexesChangeColumn") . "(this, '" . js_escape($jush == "sql" ? "" : $_GET["indexes"] . "_") . "');\"", $fields ? array_combine($fields, $fields) : $fields, $column); echo $jush == "sql" || $jush == "mssql" ? "<input type='number' name='indexes[{$j}][lengths][{$i}]' class='size' value='" . h($index["lengths"][$key]) . "'>" : ""; echo $jush != "sql" ? checkbox("indexes[{$j}][descs][{$i}]", 1, $index["descs"][$key], lang('descending')) : ""; echo " </span>"; $i++; } echo "<td><input name='indexes[{$j}][name]' value='" . h($index["name"]) . "' autocapitalize='off'>\n"; echo "<td><input class='btn btn-xs btn-danger' type='submit' name='drop_col[{$j}]' data-toggle='tooltip' data-placement='top' value='X' title='" . lang('Remove') . "' onclick=\"return !editingRemoveRow(this, 'indexes\$1[type]');\">\n"; } $j++; }
/** Print edit data form * @param string * @param array * @param mixed * @param bool * @return null */ function edit_form($TABLE, $fields, $row, $update) { global $adminer, $jush, $token, $error; $table_name = $adminer->tableName(table_status1($TABLE, true)); page_header($update ? lang('Edit') : lang('Insert'), $error, array("select" => array($TABLE, $table_name)), $table_name); if ($row === false) { echo "<p class='error'>" . lang('No rows.') . "\n"; } ?> <form action="" method="post" enctype="multipart/form-data" id="form"> <?php if (!$fields) { echo "<p class='error'>" . lang('You have no privileges to update this table.') . "\n"; } else { echo "<table cellspacing='0' onkeydown='return editingKeydown(event);'>\n"; foreach ($fields as $name => $field) { echo "<tr><th>" . $adminer->fieldName($field); $default = $_GET["set"][bracket_escape($name)]; if ($default === null) { $default = $field["default"]; if ($field["type"] == "bit" && preg_match("~^b'([01]*)'\$~", $default, $regs)) { $default = $regs[1]; } } $value = $row !== null ? $row[$name] != "" && $jush == "sql" && preg_match("~enum|set~", $field["type"]) ? is_array($row[$name]) ? array_sum($row[$name]) : +$row[$name] : $row[$name] : (!$update && $field["auto_increment"] ? "" : (isset($_GET["select"]) ? false : $default)); if (!$_POST["save"] && is_string($value)) { $value = $adminer->editVal($value, $field); } $function = $_POST["save"] ? (string) $_POST["function"][$name] : ($update && $field["on_update"] == "CURRENT_TIMESTAMP" ? "now" : ($value === false ? null : ($value !== null ? '' : 'NULL'))); if (preg_match("~time~", $field["type"]) && $value == "CURRENT_TIMESTAMP") { $value = ""; $function = "now"; } input($field, $value, $function); echo "\n"; } if (!support("table")) { echo "<tr>" . "<th><input name='field_keys[]' onkeyup='keyupChange.call(this);' onchange='fieldChange(this);' value=''>" . "<td class='function'>" . html_select("field_funs[]", $adminer->editFunctions(array("null" => isset($_GET["select"])))) . "<td><input name='field_vals[]'>" . "\n"; } echo "</table>\n"; } echo "<p>\n"; if ($fields) { echo "<input type='submit' value='" . lang('Save') . "'>\n"; if (!isset($_GET["select"])) { echo "<input type='submit' name='insert' value='" . ($update ? lang('Save and continue edit') . "' onclick='return !ajaxForm(this.form, \"" . lang('Saving') . '...", this)' : lang('Save and insert next')) . "' title='Ctrl+Shift+Enter'>\n"; } } echo $update ? "<input type='submit' name='delete' value='" . lang('Delete') . "'" . confirm() . ">\n" : ($_POST || !$fields ? "" : "<script type='text/javascript'>focus(document.getElementById('form').getElementsByTagName('td')[1].firstChild);</script>\n"); if (isset($_GET["select"])) { hidden_fields(array("check" => (array) $_POST["check"], "clone" => $_POST["clone"], "all" => $_POST["all"])); } ?> <input type="hidden" name="referer" value="<?php echo h(isset($_POST["referer"]) ? $_POST["referer"] : $_SERVER["HTTP_REFERER"]); ?> "> <input type="hidden" name="save" value="1"> <input type="hidden" name="token" value="<?php echo $token; ?> "> </form> <?php }