function toggle_all_procedures($procedures, $status) { foreach (array_keys($procedures) as $name) { $procedures[$name]['status'] = $status; if ($status == 'open' && empty($procedures[$name]['source'])) { $procedures[$name]['source'] = get_procedure_source($name); list($in, $out) = get_procedure_parameters($name); $procedures[$name]['in'] = $in; $procedures[$name]['out'] = $out; } } return $procedures; }
$pname = $_POST['acc_proc_mod_name']; if ($s_procedures[$pname]['status'] == 'close') { $s_procedures[$pname]['source'] = get_procedure_source($pname); list($in, $out) = get_procedure_parameters($pname); $s_procedures[$pname]['in'] = $in; $s_procedures[$pname]['out'] = $out; } $s_proceduredefs = array('name' => $pname, 'source' => procedure_modify_source($s_procedures[$pname])); $proc_mod_flag = TRUE; } // modify the procedure if (isset($_POST['acc_proc_mod_doit'])) { $s_proceduredefs['source'] = get_request_data('def_proc_source'); if (create_procedure($s_proceduredefs) == TRUE) { $pname = $s_proceduredefs['name']; list($in, $out) = get_procedure_parameters($pname); $s_procedures[$pname]['in'] = $in; $s_procedures[$pname]['out'] = $out; $s_procedures[$pname]['source'] = get_procedure_source($pname); $s_proceduredefs = array(); $s_procedures_valid = FALSE; } else { $proc_mod_flag = TRUE; } } // creating or modifying a procedure was canceled if (isset($_POST['acc_proc_create_cancel']) || isset($_POST['acc_proc_mod_cancel'])) { $s_proceduredefs = array(); } // the Drop button on the procedures panel was pushed if (isset($_POST['acc_proc_del']) && $_POST['acc_proc_del_name'] != '') {
function detail_view($type, $name, $title) { $url = fold_detail_url($type, 'open', $name, $title); $comment_url = "javascript:requestCommentArea('" . $type . "', '" . $name . "');"; $comment_div = detail_div_prefix($type) . 'c_' . $name; switch ($type) { case 'table': if ($GLOBALS['s_tables_def'] == TRUE) { $GLOBALS['s_fields'] = get_table_defaults_sources($name, $GLOBALS['s_fields']); } $html = get_opened_table($name, $title, $url, $comment_url, $comment_div); $GLOBALS['s_tables'][$name]['status'] = 'open'; break; case 'view': include '../inc/views.inc.php'; $html = get_opened_view($name, $title, $url); $GLOBALS['s_tables'][$name]['status'] = 'open'; break; case 'trigger': include '../inc/triggers.inc.php'; if (empty($GLOBALS['s_triggers'][$name]['source'])) { $GLOBALS['s_triggers'][$name]['source'] = get_trigger_source($name); } $html = get_opened_trigger($name, $GLOBALS['s_triggers'][$name], $url); $GLOBALS['s_triggers'][$name]['display'] = 'open'; break; case 'procedure': include '../inc/procedures.inc.php'; include '../inc/firebird.inc.php'; if (empty($GLOBALS['s_procedures'][$name]['source'])) { $GLOBALS['s_procedures'][$name]['source'] = get_procedure_source($name); list($in, $out) = get_procedure_parameters($name); $GLOBALS['s_procedures'][$name]['in'] = $in; $GLOBALS['s_procedures'][$name]['out'] = $out; } $html = get_opened_procedure($name, $GLOBALS['s_procedures'][$name], $url); $GLOBALS['s_procedures'][$name]['status'] = 'open'; break; } header('Content-Type: text/html;charset=' . $GLOBALS['charset']); echo $html; }