$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];