<?php
include 'config/db.php';
include 'libraries/events.php';
include 'libraries/general.php';
$device_id = mysqli_real_escape_string($conn, $_GET['device_id']);
if (ctype_digit($device_id) && !empty($device_id)) {
$sql = "DELETE FROM `devices` WHERE `device_id`='{$device_id}'";
if ($conn->query($sql) === TRUE) {
//set success message
$device_label = get_device_label_from_id($device_id);
$event_type = "Device Removed";
$event_message = "Device {$device_label} was removed";
$event_status = "Complete";
add_event($event_type, $event_message, $event_status);
$_SESSION['success'] = "Success, device removed.";
} else {
//set error message
$_SESSION['error'] = "Error, device not removed.";
}
//redirect back to where we came from
$referrer = $_SESSION['referrer'];
unset($_SESSION['referrer']);
//clear session var
header("Location: {$referrer}");
//redirect!
}
<?php
include 'graph_functions.php';
include 'libraries/general.php';
$librenms_api_endpoint = lirenms_api_endpoint();
$librenms_api_key = librenms_api_key();
$device_name = get_device_label_from_id($_GET['device_id']);
$port_name = port_name($_GET['port_number']);
$url = $librenms_api_endpoint . "" . $device_name . "/ports/" . $port_name . "/port_bits";
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_TIMEOUT, '3');
curl_setopt($ch, CURLOPT_HTTPHEADER, array("X-Auth-Token: {$librenms_api_key}"));
$content = trim(curl_exec($ch));
curl_close($ch);
header("Content-Type: image/png");
print $content;
<br>
<form action="update_device_db.php" id="device_parent_form" method="post">
<input type="hidden" class="form-control" name="device_id" value="<?php
echo $device_id;
?>
">
<label>Server</label>
<small><i>Select the server this disk is currently inserted into - if any</i></small>
<?php
include 'config/db.php';
$sql = "SELECT * FROM `devices` WHERE `device_type`='server'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo "<select class='form-control' name='device_parent'>";
// output data of each row
echo "<option value='{$device_parent}'>" . get_device_label_from_id($device_parent) . "</option>";
echo "<option value='0'>None</option>";
while ($row = $result->fetch_assoc()) {
$device_label = $row["device_label"];
if ($row["device_id"] != $device_parent) {
echo "<option value=" . $row["device_id"] . ">{$device_label}</option>";
}
}
echo "</select>";
} else {
echo "0 results";
}
?>
<hr>
<center><input type="submit" form="device_parent_form" value="Update" class="btn btn-primary"></center>
</form>
echo "<th><center>Manage</center></th>";
echo "</tr>";
echo "</thead>";
while ($row = $result->fetch_assoc()) {
$device_id = $row["device_id"];
if ($row["device_parent"] != 0 || $row["device_inuse"] == 1) {
echo "<tr class='info'>";
} else {
echo "<tr>";
}
echo "<td>" . get_rack_name($row['rackid']) . "</td>";
echo "<td>" . $row["device_brand"] . "</td>";
echo "<td>" . $row["device_type"] . "</td>";
echo "<td>" . $row["device_label"] . "</td>";
echo "<td>" . $row["device_capacity"] . "</td>";
echo "<td>" . get_device_label_from_id($row["device_parent"]) . "</td>";
echo "<td>" . $row["device_serial"] . "</td>";
echo "<td><center><a href='manage_disk.php?device_id={$device_id}'>Manage</a></center></td>";
echo "</tr>";
}
echo "</table>";
} else {
echo "0 results";
}
$conn->close();
?>
<div class="pull-right">
<small><i>Blue indicates the drive in use, Red indicates a failed drive</i></small>
</div>
</div>
<!-- Add HDD Modal -->
