$dbconn = $db->dbConnect($defined['dbhost'], $defined['username'], $defined['password'], $defined['dbname']);
// provide count of online users
$online = "SELECT * FROM `admin_sessions`";
$ret = $db->dbQuery($val->ValidateSQL($online, $dbconn), $dbconn);
$usersoline = $db->dbNumRows($ret);
// begin our validation on submitted data
if (!empty($_POST)) {
// re-assign vars for processing and template assignment
$file_name = $_FILES['file_name']['name'];
$uploaded = $_FILES['file_name']['tmp_name'];
$type = $_FILES['file_name']['type'];
$size = $_FILES['file_name']['size'];
// check each post element
if (!empty($file_name)) {
// begin validation of uploaded file
if ($val->ValidateUploadedFile($file_name, $uploaded, $type, $size, "xml|csv", "application/octet-stream", "1024") === 0) {
// copy file to directory and process further
$upload_path = "conf/uploads/" . basename($file_name);
if (@move_uploaded_file($uploaded, $upload_path)) {
// check for csv extension
if (eregi(".*\\.[csv]", $upload_path)) {
// open file and begin processing
$handle = fopen($upload_path, "r");
while (($data = fgetcsv($handle, 1024, ",")) !== FALSE) {
// begin counting
$row++;
// assign to a temporary array for processing and validation
$tmp[$row]['hostname'] = $data[0];
$tmp[$row]['ip_address'] = $data[1];
$tmp[$row]['mac_address'] = $data[2];
$tmp[$row]['subnet'] = $data[3];
// provide count of online users
$online = "SELECT * FROM `admin_sessions`";
$ret = $db->dbQuery($val->ValidateSQL($online, $dbconn), $dbconn);
$usersoline = $db->dbNumRows($ret);
// begin our validation on submitted data
if (!empty($_POST)) {
// process file if present
if (!empty($_FILES)) {
// re-assign vars for processing and template assignment
$file_name = $_FILES['file_name']['name'];
$uploaded = $_FILES['file_name']['tmp_name'];
$type = $_FILES['file_name']['type'];
$size = $_FILES['file_name']['size'];
if (!empty($file_name) && !empty($uploaded) && !empty($type) && !empty($size)) {
// begin validation of uploaded file
if ($val->ValidateUploadedFile($file_name, $uploaded, $type, $size, "csv", "text/csv", "928694") === 0) {
// copy file to directory and process further
$upload_path = "conf/uploads/" . basename($file_name);
if (@move_uploaded_file($uploaded, $upload_path)) {
// check for csv extension
if (eregi(".*\\.[csv]", $upload_path)) {
// open file and begin processing
$handle = fopen($upload_path, "r");
while (($data = fgetcsv($handle, 1024, ",")) !== FALSE) {
// begin counting
$row++;
// assign to a temporary array for processing and validation
$tmp[$row]['hostname'] = $data[0];
$tmp[$row]['ip_address'] = $data[2];
$tmp[$row]['mac_address'] = $data[1];
$tmp[$row]['subnet'] = $data[3];
