// All rights reserved. // Redistribution and use in source and binary forms, with or without // modification, are permitted provided that the following conditions // are met: // 1. Redistributions of source code must retain the above copyright // notice, this list of conditions and the following disclaimer. // 2. Redistributions in binary form must reproduce the above copyright // notice, this list of conditions and the following disclaimer in the // documentation and/or other materials provided with the distribution. // THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS'' AND // ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE // IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE // ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS BE LIABLE // FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL // DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS // OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) // HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT // LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY // OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF // SUCH DAMAGE. include_once 'db.inc.php'; include_once 'swreg/swreg.inc.php'; require_once 'Log.php'; require_once 'functions.php'; $dsn = "$db_driver:host=$db_host;dbname=$db_name"; $options = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false, ]; try { $dbh = new PDO($dsn, $db_user, $db_pass, $options); } catch (PDOException $e) { die($e->getMessage()); } $logger = Log::singleton('file', LOGFILE, TOOL_NAME . ' : Add Physical Switch'); if ($logger === false) { die("Failed to open logfile.\n"); } $mask = Log::MAX(LOG_LEVEL); $logger->setMask($mask); $base = get_base($_SERVER['SCRIPT_NAME']); $errors = array(); $ruser = ''; if (isset($_SERVER['REMOTE_USER'])) { $ruser = $_SERVER['REMOTE_USER']; } if (isset($_REQUEST['submit'])) { $sn = $_REQUEST['sn']; $pid = $_REQUEST['pid']; $ports = []; for ($i = 0; $i < count($sn); ++$i) { if ($sn[$i] === null || $sn[$i] == '') { continue; } foreach ($PID_PORTS as $pp => $np) { if ($pid[$i] == $pp) { $ports[$i] = $np; break; } } if ($pid[$i] == '__BOGUS__') { array_push($errors, 'Please select a Product ID on row ' . ($i + 1)); } $sn[$i] = trim($sn[$i]); if (count($errors) == 0) { $sql = 'REPLACE INTO DEVICE_MAP (serial_number, pid, max_ports) VALUES (?, ?, ?)'; try { $sth = $dbh->prepare($sql); $sth->execute(array($sn[$i], $pid[$i], $ports[$i])); $sth->closeCursor(); $logger->info("User {$ruser} added physical switch: serial_number={$sn[$i]} and pid={$pid[$i]}"); } catch (PDOException $e) { array_push($errors, 'Failed to add new physical switch at row ' . ($i + 1) . ": {$e->getMessage()}"); } } } if (count($errors) == 0) { cleanup(); header("Location: $base/index.php"); exit; } } print_header(TOOL_NAME . ': Add Physical Switch'); ?>

Physical Switches

Row No.	Serial Number	Product ID
.

<<<Return to Main Page