<?php // php pages made with phpMyBuilder <http://kyber.dk/phpMyBuilder> ?> <?php // (C) Copyright 2001 // Murray Jensen <Murray.Jensen@csiro.au> // CSIRO Manufacturing Science and Technology, Preston Lab // doedit page (hymod_bddb / boards) require("defs.php"); pg_head("$bddb_label - Edit Board Results"); if (!isset($_REQUEST['serno']) || $_REQUEST['serno'] == '') die("the board serial number was not specified"); $serno=intval($_REQUEST['serno']); $query="update boards set"; if (isset($_REQUEST['ethaddr'])) { $ethaddr=$_REQUEST['ethaddr']; if (!eth_addr_is_valid($ethaddr)) die("ethaddr is invalid ('$ethaddr')"); $query.=" ethaddr='$ethaddr',"; } if (isset($_REQUEST['date'])) { $date=$_REQUEST['date']; list($y, $m, $d) = split("-", $date); if (!checkdate($m, $d, $y) || $y < 1999) die("date is invalid (input '$date', " . "yyyy-mm-dd '$y-$m-$d')"); $query.=" date='$date'"; } if (isset($_REQUEST['batch'])) { $batch=$_REQUEST['batch']; if (strlen($batch) > 32) die("batch field too long (>32)"); $query.=", batch='$batch'"; } if (isset($_REQUEST['type'])) { $type=$_REQUEST['type']; if (!in_array($type, $type_vals)) die("Invalid type ($type) specified"); $query.=", type='$type'"; } if (isset($_REQUEST['rev'])) { $rev=$_REQUEST['rev']; if (($rev = intval($rev)) <= 0 || $rev > 255) die("Revision number is invalid ($rev)"); $query.=sprintf(", rev=%d", $rev); } if (isset($_REQUEST['location'])) { $location=$_REQUEST['location']; if (strlen($location) > 64) die("location field too long (>64)"); $query.=", location='$location'"; } if (isset($_REQUEST['comments'])) $comments=$_REQUEST['comments']; $query.=", comments='" . rawurlencode($comments) . "'"; $query.=gather_enum_multi_query("sdram", 4); $query.=gather_enum_multi_query("flash", 4); $query.=gather_enum_multi_query("zbt", 16); $query.=gather_enum_multi_query("xlxtyp", 4); $nxlx = count_enum_multi("xlxtyp", 4); $query.=gather_enum_multi_query("xlxspd", 4); if (count_enum_multi("xlxspd", 4) != $nxlx) die("number of xilinx speeds not same as number of types"); $query.=gather_enum_multi_query("xlxtmp", 4); if (count_enum_multi("xlxtmp", 4) != $nxlx) die("number of xilinx temps. not same as number of types"); $query.=gather_enum_multi_query("xlxgrd", 4); if (count_enum_multi("xlxgrd", 4) != $nxlx) die("number of xilinx grades not same as number of types"); if (isset($_REQUEST['cputyp'])) { $cputyp=$_REQUEST['cputyp']; $query.=", cputyp='$cputyp'"; if (!isset($_REQUEST['cpuspd']) || $_REQUEST['cpuspd'] == '') die("must specify cpu speed if cpu type is defined"); $cpuspd=$_REQUEST['cpuspd']; $query.=", cpuspd='$cpuspd'"; if (!isset($_REQUEST['cpmspd']) || $_REQUEST['cpmspd'] == '') die("must specify cpm speed if cpu type is defined"); $cpmspd=$_REQUEST['cpmspd']; $query.=", cpmspd='$cpmspd'"; if (!isset($_REQUEST['busspd']) || $_REQUEST['busspd'] == '') die("must specify bus speed if cpu type is defined"); $busspd=$_REQUEST['busspd']; $query.=", busspd='$busspd'"; } else { if (isset($_REQUEST['cpuspd'])) die("can't specify cpu speed if there is no cpu"); if (isset($_REQUEST['cpmspd'])) die("can't specify cpm speed if there is no cpu"); if (isset($_REQUEST['busspd'])) die("can't specify bus speed if there is no cpu"); } if (isset($_REQUEST['hschin'])) { $hschin=$_REQUEST['hschin']; if (($hschin = intval($hschin)) < 0 || $hschin > 4) die("Invalid number of hs input chans ($hschin)"); } else $hschin = 0; if (isset($_REQUEST['hschout'])) { $hschout=$_REQUEST['hschout']; if (($hschout = intval($hschout)) < 0 || $hschout > 4) die("Invalid number of hs output chans ($hschout)"); } else $hschout = 0; if (isset($_REQUEST['hstype'])) { $hstype=$_REQUEST['hstype']; $query.=", hstype='$hstype'"; } else { if ($_REQUEST['hschin'] != 0) die("number of high-speed input channels must be zero" . " if high-speed chip is not present"); if ($_REQUEST['hschout'] != 0) die("number of high-speed output channels must be zero" . " if high-speed chip is not present"); } $query.=", hschin='$hschin'"; $query.=", hschout='$hschout'"; $query.=" where serno=$serno"; mysql_query($query); if(mysql_errno()) { $errstr = mysql_error(); echo "\t<font size=+4>\n"; echo "\t\t<p>\n"; echo "\t\t\tThe following error was encountered:\n"; echo "\t\t</p>\n"; echo "\t\t<center>\n"; printf("\t\t\t<b>%s</b>\n", $errstr); echo "\t\t</center>\n"; echo "\t</font>\n"; } else { $sernos = array($serno); $nsernos = 1; write_eeprom_cfg_file(); echo "\t<font size=+2>\n"; echo "\t\t<p>\n"; echo "\t\t\tThe board with serial number <b>$serno</b> was" . " successfully updated"; if ($numerrs > 0) { $errstr = $cfgerrs[0]; echo "<br>\n\t\t\t"; echo "(but the cfg file update failed: $errstr)"; } echo "\n"; echo "\t\t</p>\n"; echo "\t</font>\n"; } ?> <p> <table align=center width="100%"> <tr> <td align=center><a href="browse.php">Back to Browse</a></td> <td align=center><a href="index.php">Back to Start</a></td> </tr> </table> <?php pg_foot(); ?>