function form_actions() {
global $colors, $cdef_actions;
/* if we are to save this form, instead of display it */
if (isset($_POST["selected_items"])) {
$selected_items = unserialize(stripslashes($_POST["selected_items"]));
if ($_POST["drp_action"] == "1") { /* delete */
db_execute("delete from cdef where " . array_to_sql_or($selected_items, "id"));
db_execute("delete from cdef_items where " . array_to_sql_or($selected_items, "cdef_id"));
}elseif ($_POST["drp_action"] == "2") { /* duplicate */
for ($i=0;($i<count($selected_items));$i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
/* ==================================================== */
duplicate_cdef($selected_items[$i], $_POST["title_format"]);
}
}
header("Location: cdef.php");
exit;
}
/* setup some variables */
$cdef_list = ""; $i = 0;
/* loop through each of the graphs selected on the previous page and get more info about them */
while (list($var,$val) = each($_POST)) {
if (ereg("^chk_([0-9]+)$", $var, $matches)) {
/* ================= input validation ================= */
input_validate_input_number($matches[1]);
/* ==================================================== */
$cdef_list .= "<li>" . db_fetch_cell("select name from cdef where id=" . $matches[1]) . "<br>";
$cdef_array[$i] = $matches[1];
}
$i++;
}
include_once("./include/top_header.php");
html_start_box("<strong>" . $cdef_actions{$_POST["drp_action"]} . "</strong>", "60%", $colors["header_panel"], "3", "center", "");
print "<form action='cdef.php' method='post'>\n";
if ($_POST["drp_action"] == "1") { /* delete */
print " <tr>
<td class='textArea' bgcolor='#" . $colors["form_alternate1"]. "'>
<p>Are you sure you want to delete the following CDEFs?</p>
<p>$cdef_list</p>
</td>
</tr>\n
";
}elseif ($_POST["drp_action"] == "2") { /* duplicate */
print " <tr>
<td class='textArea' bgcolor='#" . $colors["form_alternate1"]. "'>
<p>When you click save, the following CDEFs will be duplicated. You can
optionally change the title format for the new CDEFs.</p>
<p>$cdef_list</p>
<p><strong>Title Format:</strong><br>"; form_text_box("title_format", "<cdef_title> (1)", "", "255", "30", "text"); print "</p>
</td>
</tr>\n
";
}
if (!isset($cdef_array)) {
print "<tr><td bgcolor='#" . $colors["form_alternate1"]. "'><span class='textError'>You must select at least one CDEF.</span></td></tr>\n";
$save_html = "";
}else{
$save_html = "<input type='image' src='images/button_yes.gif' alt='Save' align='absmiddle'>";
}
print " <tr>
<td align='right' bgcolor='#eaeaea'>
<input type='hidden' name='action' value='actions'>
<input type='hidden' name='selected_items' value='" . (isset($cdef_array) ? serialize($cdef_array) : '') . "'>
<input type='hidden' name='drp_action' value='" . $_POST["drp_action"] . "'>
<a href='cdef.php'><img src='images/button_no.gif' alt='Cancel' align='absmiddle' border='0'></a>
$save_html
</td>
</tr>
";
html_end_box();
include_once("./include/bottom_footer.php");
}
function form_actions() {
global $colors, $cdef_actions;
/* if we are to save this form, instead of display it */
if (isset($_POST["selected_items"])) {
$selected_items = unserialize(stripslashes($_POST["selected_items"]));
if (get_request_var_post("drp_action") === "1") { /* delete */
/* do a referential integrity check */
if (sizeof($selected_items)) {
foreach($selected_items as $cdef_id) {
/* ================= input validation ================= */
input_validate_input_number($cdef_id);
/* ==================================================== */
if (sizeof(db_fetch_assoc("SELECT * FROM graph_templates_item WHERE cdef_id=$cdef_id LIMIT 1"))) {
$bad_ids[] = $cdef_id;
}else{
$cdef_ids[] = $cdef_id;
}
}
}
if (isset($bad_ids)) {
$message = "";
foreach($bad_ids as $cdef_id) {
$message .= (strlen($message) ? "<br>":"") . "<i>CDEF " . $cdef_id . " is in use and can not be removed</i>\n";
}
$_SESSION['sess_message_cdef_ref_int'] = array('message' => "<font size=-2>$message</font>", 'type' => 'info');
raise_message('cdef_ref_int');
}
if (isset($cdef_ids)) {
db_execute("delete from cdef where " . array_to_sql_or($cdef_ids, "id"));
db_execute("delete from cdef_items where " . array_to_sql_or($cdef_ids, "cdef_id"));
}
}elseif (get_request_var_post("drp_action") === "2") { /* duplicate */
for ($i=0;($i<count($selected_items));$i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
/* ==================================================== */
duplicate_cdef($selected_items[$i], get_request_var_post("title_format"));
}
}
header("Location: cdef.php");
exit;
}
/* setup some variables */
$cdef_list = ""; $i = 0;
/* loop through each of the graphs selected on the previous page and get more info about them */
while (list($var,$val) = each($_POST)) {
if (preg_match("/^chk_([0-9]+)$/", $var, $matches)) {
/* ================= input validation ================= */
input_validate_input_number($matches[1]);
/* ==================================================== */
$cdef_list .= "<li>" . db_fetch_cell("select name from cdef where id=" . $matches[1]) . "<br>";
$cdef_array[$i] = $matches[1];
}
$i++;
}
include_once("./include/top_header.php");
html_start_box("<strong>" . $cdef_actions{get_request_var_post("drp_action")} . "</strong>", "60", $colors["header_panel"], "3", "center", "");
print "<form action='cdef.php' method='post'>\n";
if (isset($cdef_array)) {
if (get_request_var_post("drp_action") === ACTION_NONE) { /* NONE */
print " <tr>
<td class='textArea'>
<p>" . __("You did not select a valid action. Please select 'Return' to return to the previous menu.") . "</p>
</td>
</tr>\n";
}elseif (get_request_var_post("drp_action") === "1") { /* delete */
print " <tr>
<td class='textArea' bgcolor='#" . $colors["form_alternate1"]. "'>
<p>" . __("Are you sure you want to delete the following CDEFs?") . "</p>
<p><ul>$cdef_list</ul></p>
</td>
</tr>\n
";
}elseif (get_request_var_post("drp_action") === "2") { /* duplicate */
print " <tr>
<td class='textArea' bgcolor='#" . $colors["form_alternate1"]. "'>
<p>" . __("When you click save, the following CDEFs will be duplicated. You can optionally change the title format for the new CDEFs.") . "</p>
<p><ul>$cdef_list</ul></p>
<p><strong>" . __("Title Format:") . "</strong><br>"; form_text_box("title_format", "<cdef_title> (1)", "", "255", "30", "text"); print "</p>
</td>
</tr>\n
";
}
}else{
print "<tr><td bgcolor='#" . $colors["form_alternate1"]. "'><span class='textError'>" . __("You must select at least one CDEF.") . "</span></td></tr>\n";
}
print "<div><input type='hidden' name='action' value='actions'></div>";
print "<div><input type='hidden' name='selected_items' value='" . (isset($cdef_array) ? serialize($cdef_array) : '') . "'></div>";
print "<div><input type='hidden' name='drp_action' value='" . $_POST["drp_action"] . "'></div>";
if (!isset($cdef_array) || get_request_var_post("drp_action") === ACTION_NONE) {
form_return_button_alt();
}else{
form_yesno_button_alt(serialize($cdef_array), get_request_var_post("drp_action"));
}
html_end_box();
include_once("./include/bottom_footer.php");
}
function form_actions()
{
global $cdef_actions;
/* ================= input validation ================= */
input_validate_input_regex(get_request_var_post('drp_action'), "^([a-zA-Z0-9_]+)\$");
/* ==================================================== */
/* if we are to save this form, instead of display it */
if (isset($_POST["selected_items"])) {
$selected_items = sanitize_unserialize_selected_items($_POST['selected_items']);
if ($selected_items != false) {
if ($_POST["drp_action"] == "1") {
/* delete */
db_execute("delete from cdef where " . array_to_sql_or($selected_items, "id"));
db_execute("delete from cdef_items where " . array_to_sql_or($selected_items, "cdef_id"));
} elseif ($_POST["drp_action"] == "2") {
/* duplicate */
for ($i = 0; $i < count($selected_items); $i++) {
duplicate_cdef($selected_items[$i], $_POST["title_format"]);
}
}
}
header("Location: cdef.php");
exit;
}
/* setup some variables */
$cdef_list = "";
$i = 0;
/* loop through each of the graphs selected on the previous page and get more info about them */
while (list($var, $val) = each($_POST)) {
if (preg_match("/^chk_([0-9]+)\$/", $var, $matches)) {
/* ================= input validation ================= */
input_validate_input_number($matches[1]);
/* ==================================================== */
$cdef_list .= "<li>" . htmlspecialchars(db_fetch_cell("select name from cdef where id=" . $matches[1])) . "</li>";
$cdef_array[$i] = $matches[1];
$i++;
}
}
include_once "./include/top_header.php";
print "<form action='cdef.php' method='post'>\n";
html_start_box("<strong>" . $cdef_actions[$_POST["drp_action"]] . "</strong>", "60%", "", "3", "center", "");
if (isset($cdef_array) && sizeof($cdef_array)) {
if ($_POST["drp_action"] == "1") {
/* delete */
print "\t<tr>\n\t\t\t\t\t<td class='textArea' class='odd'>\n\t\t\t\t\t\t<p>When you click \"Continue\", the folling CDEF(s) will be deleted.</p>\n\t\t\t\t\t\t<p><ul>{$cdef_list}</ul></p>\n\t\t\t\t\t</td>\n\t\t\t\t</tr>\n\n\t\t\t\t";
$save_html = "<input type='button' value='Cancel' onClick='window.history.back()'> <input type='submit' value='Continue' title='Delete CDEF(s)'>";
} elseif ($_POST["drp_action"] == "2") {
/* duplicate */
print "\t<tr>\n\t\t\t\t\t<td class='textArea' class='odd'>\n\t\t\t\t\t\t<p>When you click \"Continue\", the following CDEFs will be duplicated. You can\n\t\t\t\t\t\toptionally change the title format for the new CDEFs.</p>\n\t\t\t\t\t\t<p><ul>{$cdef_list}</ul></p>\n\t\t\t\t\t\t<p><strong>Title Format:</strong><br>";
form_text_box("title_format", "<cdef_title> (1)", "", "255", "30", "text");
print "</p>\n\t\t\t\t\t</td>\n\t\t\t\t</tr>\n\n\t\t\t\t";
$save_html = "<input type='button' value='Cancel' onClick='window.history.back()'> <input type='submit' value='Continue' title='Duplicate CDEF(s)'>";
}
} else {
print "<tr><td class='odd'><span class='textError'>You must select at least one CDEF.</span></td></tr>\n";
$save_html = "<input type='button' value='Return' onClick='window.history.back()'>";
}
print "\t<tr>\n\t\t\t<td align='right' class='saveRow'>\n\t\t\t\t<input type='hidden' name='action' value='actions'>\n\t\t\t\t<input type='hidden' name='selected_items' value='" . (isset($cdef_array) ? serialize($cdef_array) : '') . "'>\n\t\t\t\t<input type='hidden' name='drp_action' value='" . $_POST["drp_action"] . "'>\n\t\t\t\t{$save_html}\n\t\t\t</td>\n\t\t</tr>\n\t\t";
html_end_box();
include_once "./include/bottom_footer.php";
}
function form_actions()
{
global $cdef_actions;
/* ================= input validation ================= */
input_validate_input_regex(get_request_var_post('drp_action'), '^([a-zA-Z0-9_]+)$');
/* ==================================================== */
/* if we are to save this form, instead of display it */
if (isset($_POST['selected_items'])) {
$selected_items = unserialize(stripslashes($_POST['selected_items']));
if ($_POST['drp_action'] == '1') {
/* delete */
db_execute('DELETE FROM cdef WHERE ' . array_to_sql_or($selected_items, 'id'));
db_execute('DELETE FROM cdef_items WHERE ' . array_to_sql_or($selected_items, 'cdef_id'));
} elseif ($_POST['drp_action'] == '2') {
/* duplicate */
for ($i = 0; $i < count($selected_items); $i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
/* ==================================================== */
duplicate_cdef($selected_items[$i], $_POST['title_format']);
}
}
header('Location: cdef.php');
exit;
}
/* setup some variables */
$cdef_list = '';
$i = 0;
/* loop through each of the graphs selected on the previous page and get more info about them */
while (list($var, $val) = each($_POST)) {
if (preg_match('/^chk_([0-9]+)$/', $var, $matches)) {
/* ================= input validation ================= */
input_validate_input_number($matches[1]);
/* ==================================================== */
$cdef_list .= '<li>' . htmlspecialchars(db_fetch_cell_prepared('SELECT name FROM cdef WHERE id = ?', array($matches[1]))) . '</li>';
$cdef_array[$i] = $matches[1];
$i++;
}
}
top_header();
print "<form action='cdef.php' method='post'>\n";
html_start_box('<strong>' . $cdef_actions[$_POST['drp_action']] . '</strong>', '60%', '', '3', 'center', '');
if (isset($cdef_array) && sizeof($cdef_array)) {
if ($_POST['drp_action'] == '1') {
/* delete */
print "\t<tr>\n\t\t\t\t\t<td class='textArea' class='odd'>\n\t\t\t\t\t\t<p>When you click \"Continue\", the folling CDEF(s) will be deleted.</p>\n\t\t\t\t\t\t<p><ul>{$cdef_list}</ul></p>\n\t\t\t\t\t</td>\n\t\t\t\t</tr>\n";
$save_html = "<input type='button' value='Cancel' onClick='window.history.back()'> <input type='submit' value='Continue' title='Delete CDEF(s)'>";
} elseif ($_POST['drp_action'] == '2') {
/* duplicate */
print "\t<tr>\n\t\t\t\t\t<td class='textArea' class='odd'>\n\t\t\t\t\t\t<p>When you click \"Continue\", the following CDEFs will be duplicated. You can\n\t\t\t\t\t\toptionally change the title format for the new CDEFs.</p>\n\t\t\t\t\t\t<p><ul>{$cdef_list}</ul></p>\n\t\t\t\t\t\t<p><strong>Title Format:</strong><br>";
form_text_box('title_format', '<cdef_title> (1)', '', '255', '30', 'text');
print "</p>\n\t\t\t\t\t</td>\n\t\t\t\t</tr>\n";
$save_html = "<input type='button' value='Cancel' onClick='window.history.back()'> <input type='submit' value='Continue' title='Duplicate CDEF(s)'>";
}
} else {
print "<tr><td class='odd'><span class='textError'>You must select at least one CDEF.</span></td></tr>\n";
$save_html = "<input type='button' value='Return' onClick='window.history.back()'>";
}
print "\t<tr>\n\t\t\t<td align='right' class='saveRow'>\n\t\t\t\t<input type='hidden' name='action' value='actions'>\n\t\t\t\t<input type='hidden' name='selected_items' value='" . (isset($cdef_array) ? serialize($cdef_array) : '') . "'>\n\t\t\t\t<input type='hidden' name='drp_action' value='" . $_POST['drp_action'] . "'>\n\t\t\t\t{$save_html}\n\t\t\t</td>\n\t\t</tr>\n";
html_end_box();
bottom_footer();
}
