<?php
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
require "MONITORINGDB.php";
set_include_path("./Bean");
spl_autoload_register();
require 'User.php';
$User = new User();
$User->setUsername($_POST["uname"]);
$User->setUsertoken($_POST["userToken"]);
$User->setIpAddress($_POST["ipAddress"]);
$User->setMacAddress($_POST["macAddress"]);
$User->setUsertype($_POST["userType"]);
$User->setUserid($_POST["userid"]);
$sql = "INSERT INTO MonitoringDeviceAccounts (userId,username,usertype,usertoken,ipAddress,macAddress)\nVALUES ('" . $User->getUserid() . "','" . $User->getUsername() . "','" . $User->getUsertype() . "','" . $User->getUsertoken() . "',\n '" . $User->getIpAddress() . "','" . $User->getMacAddress() . "')";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
*/
require "NACDB.php";
set_include_path('./Bean');
spl_autoload_register();
require 'User.php';
$file_handle = fopen("MDMConfig.txt", "r");
while (!feof($file_handle)) {
$line = fgets($file_handle);
$ip = substr($line, 3);
echo $ip;
}
fclose($file_handle);
$User = new User();
$User->setUsername($_POST["uname"]);
$User->setPassword($_POST["pass"]);
$User->setUsertoken(uniqid());
$User->setIpAddress($_POST["ipAddress"]);
$User->setMacAddress($_POST["macAddress"]);
$sql = "select * from User_Accounts where username= '******' and password = '******'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo "Access-Granted ";
echo "userToken=";
echo $User->getUsertoken();
echo "!endOfToken ";
//insert to userlogs
$row = $result->fetch_row();
$User->setUserid($row[0]);
$User->setUsertype($row[5]);
$sql = "INSERT INTO UserLogs (userid,ipAddress,macAddress,userToken,lastLogin) VALUES('" . $User->getUserid() . "','" . $User->getIpAddress() . "','" . $User->getMacAddress() . "','" . $User->getUsertoken() . "',NOW())";
if ($conn->query($sql) === TRUE) {
