range(1,2),
"B" => range(1,3),
"C" => range(1,4),
"D" => range(1,5),
"E" => range(1,6),
"F" => range(1,7),
"G" => range(1,8),
"H" => range(1,9),
"I" => range(1,10),
"J" => range(1,9),
"K" => range(1,4),
);
if (isset($_REQUEST["action"])) {
$container = $_REQUEST["container"];
$rack = $_REQUEST["rack"];
$box = $_REQUEST["box"];
if ($_REQUEST["action"] == "add_box_to_db") {
$where_clause = "container='$container' AND rack='$rack' AND box='$box'";
if (FALSE) {
$qry = "UPDATE cl_storage SET cl_passages=NULL WHERE $where_clause";
$result = mysql_query($qry, $connexion);
} else {
$error = FALSE;
$qry = "SELECT COUNT(*) FROM cl_storage WHERE $where_clause";
$result = mysql_query($qry);
$row = mysql_fetch_row($result);
$count = $row[0];
if ($count > 0) {
$error = TRUE;
echo "ERROR! Container $container rack $rack box $box ever exists!
";
}
if ($session->mode != "super") {
echo "ERROR! You must be in superuser mode to add a Liquid N2 box.
";
}
if (!$error & $session->mode == "super") {
$qry_part = array();
foreach ($box_map as $field_y => $fields) {
foreach($fields as $field_x) {
array_push($qry_part, "(NULL,'$container','$rack','$box','$field_y','$field_x',NULL)");
}
}
$box_values = implode(",", $qry_part);
$qry = "INSERT INTO `cl_storage` VALUES $box_values";
$result = mysql_query($qry, $connexion);
if ($result) {
echo "CONGRATULATION! You succesfully add container $container rack $rack box $box.
";
}
}
}
}
}
$output = "";
$output .= "You want to add a new Liquid N2 box in your database.
";
$output .= "";
echo $output;
// session_start ();
require("footers.php");
?>