/** 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"; } }
function Draw_Page($Page_Type) { // Read only pages - these pages don't strictly require user authentication. // Therefore, to enable permit-all page viewing, comment out the call // to rejectIfNotAuthenticated() in the relevant case block. Note, some of // these pages will replace sensitive info such as telephone/email with // the string 'PROTECTED' // ************************************************************************ switch ($Page_Type) { case "default": //rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/start_page.php'; startPage(); break; case "View_Service_Endpoint": //rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service/view_service_endpoint.php'; view_endpoint(); break; case "Service_Groups": //rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service_group/view_all.php'; showAllServiceGroups(); break; case "Service_Group": //rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service_group/view_sgroup.php'; showServiceGroup(); break; case "Site": //rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/site/view_site.php'; view_site(); break; case "NGI": //rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/ngi/view_ngi.php'; view_ngi(); break; case "Service": //rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service/view_service.php'; view_se(); break; case "Services": //rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service/view_all.php'; drawSEs(); break; case "NGIs": //rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/ngi/view_ngis.php'; view_ngis(); break; case "Sites": //rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/site/view_all.php'; showAllSites(); break; case "Projects": //rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/project/view_all.php'; show_all_projects(); break; case "Project": //rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/project/view_project.php'; show_project(); break; case "Scope_Help": //rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/scope_help.php'; show_help(); break; case "Site_Geo_xml": //rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/sitesForGoogleMapXML.php'; show_xml(); break; case "Error_Redirect": //rejectIfNotAuthenticated(); show_view('error.php', $_REQUEST['error']); break; case "Static_HTML": //rejectIfNotAuthenticated(); Draw_Static_HTML(); break; case "Search": //rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/search.php'; search(); break; // CrUD Pages - These pages MUST have authentication enabled so // the calls to rejectIfNotAuthenticated() must be used. // ********************************************************************* // CrUD Pages - These pages MUST have authentication enabled so // the calls to rejectIfNotAuthenticated() must be used. // ********************************************************************* case "Revoke_Role": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/political_role/revoke_request.php'; view_revoke_request(); break; case "Accept_Role_Request": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/political_role/accept_request.php'; view_accept_request(); break; case "Deny_Role_Request": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/political_role/deny_request.php'; view_deny_request(); break; case "Role_Requests": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/political_role/view_requests.php'; view_requests(); break; case "Request_Role": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/political_role/request_role.php'; request_role(); break; case "Edit_Site": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/site/edit_site.php'; edit_site(); break; case "Edit_Service": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service/edit_service.php'; edit_service(); break; case "SE_Downtimes": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service/se_downtimes.php'; se_downtimes(); break; case "Add_Service": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service/add_service.php'; add_service(); break; case "Add_Service_Endpoint": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service/add_service_endpoint.php'; add_service_endpoint(); break; case "Delete_Service": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service/delete_service.php'; delete(); break; case "Edit_User": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/user/edit_user.php'; edit_user(); break; case "User": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/user/view_user.php'; view_user(); break; case "Downtime": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/downtime/view_downtime.php'; view(); break; case "My_Sites": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/my_sites.php'; my_sites(); break; case "Edit_NGI": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/ngi/edit_ngi.php'; edit_ngi(); break; case "Edit_Service_Group": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service_group/edit_service_group.php'; edit_service_group(); break; case "Add_Service_Group_SEs": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service_group/add_ses.php'; add_ses(); break; case "Search_SEs": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service_group/search_ses.php'; search_ses(); break; case "Remove_Service_Group_SEs": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service_group/remove_ses.php'; remove_ses(); break; case "Add_Site": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/site/add_site.php'; add_site(); break; case "SGroup_Downtimes": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service_group/view_sgroup_downtimes.php'; view_sgroup_downtimes(); break; case "Add_Service_Group": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service_group/add_service_group.php'; add_service_group(); break; case "Site_Downtimes": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/site/site_downtimes.php'; site_downtimes(); break; case "Register": rejectIfNotAuthenticated('Access denied - ' . 'you need to be pre-authenticated before you can register a new account'); require_once __DIR__ . '/controllers/user/register.php'; register(); break; case "Add_Downtime": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/downtime/add_downtime.php'; //require_once __DIR__.'/controllers/downtime/add_downtime_old.php'; add(); break; case "Edit_Downtime": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/downtime/edit_downtime.php'; //require_once __DIR__.'/controllers/downtime/edit_downtime_old.php'; edit(); break; case "End_Downtime": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/downtime/end_downtime.php'; endDt(); break; case "Downtime_view_endpoint_tree": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/downtime/view_endpoint_tree.php'; getServiceandEndpointList(); break; case "Edit_Downtime_view_endpoint_tree": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/downtime/view_endpoint_tree.php'; editDowntimePopulateEndpointTree(); break; case "Downtime_View_Services": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/downtime/view_services.php'; getSitesServices(); break; case "Delete_Site": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/site/delete_site.php'; delete(); break; case "Delete_Downtime": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/downtime/delete_downtime.php'; delete(); break; case "Downtimes_Overview": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/downtime/downtimes_overview.php'; view(); break; case "Delete_Service_Group": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service_group/delete_service_group.php'; delete(); break; case "Delete_User": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/user/delete_user.php'; delete(); break; case "Edit_Certification_Status": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/site/edit_cert_status.php'; edit(); break; case "Retrieve_Account": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/user/retrieve_account.php'; retrieve(); break; case "Remove_Project_NGIs": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/project/remove_ngis.php'; remove_ngis_project(); break; case "Add_Project_NGIs": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/project/add_ngis.php'; add_ngis_to_project(); break; case "Edit_Project": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/project/edit_project.php'; edit_project(); break; case "Delete_Project": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/project/delete_project.php'; delete_project(); break; case "Admin_Move_Site": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/move_site.php'; move_site(); break; case "Admin_Move_SEP": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/move_service_end_point.php'; move_service_end_point(); break; case "Admin_Service_Types": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/view_service_types.php'; show_all(); break; case "Admin_Service_Type": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/view_service_type.php'; view_service_type(); break; case "Admin_Edit_Service_Type": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/edit_service_type.php'; edit_type(); break; case "Admin_Add_Service_Type": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/add_service_type.php'; add_type(); break; case "Admin_Delete_Service_Type": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/delete_service_type.php'; delete_service_type(); break; case "Admin_Delete_Service_Type_Denied": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/delete_service_type_denied.php'; deny_delete_type(); break; case "Admin_Add_NGI": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/add_ngi.php'; add_ngi(); break; case "Admin_Users": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/users.php'; show_users(); break; case "Admin_Edit_User_DN": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/edit_user_dn.php'; edit_dn(); break; // case "Admin_Change_User_Admin_Status": // rejectIfNotAuthenticated(); // require_once __DIR__.'/controllers/admin/edit_user_isadmin.php'; // make_admin(); // break; // case "Admin_Change_User_Admin_Status": // rejectIfNotAuthenticated(); // require_once __DIR__.'/controllers/admin/edit_user_isadmin.php'; // make_admin(); // break; case "Admin_Add_Project": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/add_project.php'; add_project(); break; case "Admin_Scopes": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/scopes.php'; show_scopes(); break; case "Admin_Remove_Scope": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/delete_scope.php'; remove_scope(); break; case "Admin_Add_Scope": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/add_scope.php'; add_scope(); break; case "Admin_Scope": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/scope.php'; view_scope(); break; case "Admin_Edit_Scope": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/edit_scope.php'; edit_scope(); break; case "Admin_Delete_NGI": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/admin/delete_ngi.php'; delete_ngi(); break; case "User_Validate_DN_Change": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/user/retrieve_account_user_validate.php'; validate_dn_change(); break; case "Add_Site_Property": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/site/add_site_property.php'; add_site_property(); break; case "Add_Service_Property": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service/add_service_property.php'; add_service_property(); break; case "Add_Endpoint_Property": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service/add_endpoint_property.php'; add_endpoint_property(); break; case "Delete_Site_Property": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/site/delete_site_property.php'; delete(); break; case "Delete_Service_Property": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service/delete_service_property.php'; delete(); break; case "Delete_Endpoint_Property": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service/delete_endpoint_property.php'; delete(); break; case "Edit_Site_Property": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/site/edit_site_property.php'; edit_property(); break; case "Edit_Service_Property": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service/edit_service_property.php'; edit_property(); break; case "Edit_Endpoint_Property": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service/edit_endpoint_property.php'; edit_property(); break; case "Add_Service_Group_Property": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service_group/add_service_group_property.php'; add_service_group_property(); break; case "Edit_Service_Group_Property": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service_group/edit_service_group_property.php'; edit_property(); break; case "Delete_Service_Group_Property": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service_group/delete_service_group_property.php'; delete(); break; case "Delete_Service_Endpoint": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service/delete_service_endpoint.php'; delete_endpoint(); break; case "Edit_Service_Endpoint": rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/service/edit_service_endpoint.php'; edit_endpoint(); break; default: // require auth by default rejectIfNotAuthenticated(); require_once __DIR__ . '/controllers/start_page.php'; startPage(); break; } }
function edit_fields($fields, $collations, $type = "TABLE") { global $inout; ?> <thead><tr> <?php if ($type == "PROCEDURE") { ?> <td><?php echo lang('IN-OUT'); ?> </td><?php } ?> <th><?php echo $type == "TABLE" ? lang('Column name') : lang('Parameter name'); ?> </th> <td><?php echo lang('Type'); ?> </td> <td><?php echo lang('Length'); ?> </td> <td><?php echo lang('Options'); ?> </td> <?php if ($type == "TABLE") { ?> <td><?php echo lang('NULL'); ?> </td> <td><input type="radio" name="auto_increment_col" value="" /><?php echo lang('Auto Increment'); ?> </td> <td><?php echo lang('Comment'); ?> </td> <?php } ?> <td><input type="image" name="add[0]" src="<?php echo preg_replace("~\\?.*~", "", $_SERVER["REQUEST_URI"]) . "?file=plus.gif"; ?> " title="<?php echo lang('Add next'); ?> " /></td> </tr></thead> <?php $column_comments = false; foreach ($fields as $i => $field) { $i++; $display = $_POST["add"][$i - 1] || isset($field["field"]) && !$_POST["drop_col"][$i]; ?> <tr<?php echo $display ? "" : " style='display: none;'"; ?> > <?php if ($type == "PROCEDURE") { ?> <td><select name="fields[<?php echo $i; ?> ][inout]"><?php echo optionlist($inout, $field["inout"]); ?> </select></td><?php } ?> <th><?php if ($display) { ?> <input name="fields[<?php echo $i; ?> ][field]" value="<?php echo htmlspecialchars($field["field"]); ?> " maxlength="64" /><?php } ?> <input type="hidden" name="fields[<?php echo $i; ?> ][orig]" value="<?php echo htmlspecialchars($field[$_POST ? "orig" : "field"]); ?> " /></th> <?php edit_type("fields[{$i}]", $field, $collations); if ($type == "TABLE") { ?> <td><input type="checkbox" name="fields[<?php echo $i; ?> ][null]" value="1"<?php if ($field["null"]) { ?> checked="checked"<?php } ?> /></td> <td><input type="radio" name="auto_increment_col" value="<?php echo $i; ?> "<?php if ($field["auto_increment"]) { ?> checked="checked"<?php } ?> /></td> <td><input name="fields[<?php echo $i; ?> ][comment]" value="<?php echo htmlspecialchars($field["comment"]); ?> " maxlength="255" /></td> <?php } ?> <td style="white-space: nowrap;"> <input type="image" name="add[<?php echo $i; ?> ]" src="<?php echo preg_replace("~\\?.*~", "", $_SERVER["REQUEST_URI"]) . "?file=plus.gif"; ?> " title="<?php echo lang('Add next'); ?> " onclick="return !add_row(this);" /> <input type="image" name="drop_col[<?php echo $i; ?> ]" src="<?php echo preg_replace("~\\?.*~", "", $_SERVER["REQUEST_URI"]) . "?file=minus.gif"; ?> " title="<?php echo lang('Remove'); ?> " onclick="return !remove_row(this);" /> <input type="image" name="up[<?php echo $i; ?> ]" src="<?php echo preg_replace("~\\?.*~", "", $_SERVER["REQUEST_URI"]) . "?file=up.gif"; ?> " title="<?php echo lang('Move up'); ?> " /> <input type="image" name="down[<?php echo $i; ?> ]" src="<?php echo preg_replace("~\\?.*~", "", $_SERVER["REQUEST_URI"]) . "?file=down.gif"; ?> " title="<?php echo lang('Move down'); ?> " /> </td> </tr> <?php if (strlen($field["comment"])) { $column_comments = true; } } return $column_comments; }
echo h($row["name"]); ?> " maxlength="64" autocapitalize="off"> <?php echo $routine_languages ? lang('Language') . ": " . html_select("language", $routine_languages, $row["language"]) : ""; ?> <input type="submit" value="<?php echo lang('Save'); ?> "> <table cellspacing="0" class="nowrap"> <?php edit_fields($row["fields"], $collations, $routine); if (isset($_GET["function"])) { echo "<tr><td>" . lang('Return type'); edit_type("returns", $row["returns"], $collations); } ?> </table> <p><?php textarea("definition", $row["definition"]); ?> <p> <input type="submit" value="<?php echo lang('Save'); ?> "> <?php if ($PROCEDURE != "") { ?> <input type="submit" name="drop" value="<?php