$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) { echo "New record created successfully"; } else { echo "Error: " . $sql . "<br>" . $conn->error; } //send to mdm $fields_string = ''; $url = "http://{$ip}/phpprojects/MDMStore.php"; $fields = array('uname' => urlencode($User->getUsername()), 'userid' => urlencode($User->getUserid()), 'userToken' => urlencode($User->getUsertoken()), 'userType' => urlencode($User->getUsertype()), 'macAddress' => urlencode($User->getMacAddress()), 'ipAddress' => urlencode($User->getIpAddress())); //url-ify the data for the POST foreach ($fields as $key => $value) { $fields_string .= $key . '=' . $value . '&'; } rtrim($fields_string, '&'); //open connection
<?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();
$file_handle = fopen("MonitoringConfig.txt", "r"); while (!feof($file_handle)) { $line = fgets($file_handle); $ip = substr($line, 3); echo $ip; } fclose($file_handle); $User = new User(); $fields_string = ''; $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 MobileDeviceAccounts (userId,username,usertype,usertoken,ipAddress,macAddress,lastActivityTime)\nVALUES ('" . $User->getUserid() . "','" . $User->getUsername() . "','" . $User->getUsertype() . "','" . $User->getUsertoken() . "',\n '" . $User->getIpAddress() . "','" . $User->getMacAddress() . "','NOW()')"; if ($conn->query($sql) === TRUE) { echo "New record created successfully"; } else { echo "Error: " . $sql . "<br>" . $conn->error; } $url = "http://{$ip}/phpprojects/MonitoringStore.php"; $fields = array('uname' => urlencode($User->getUsername()), 'userid' => urlencode($User->getUserid()), 'userToken' => urlencode($User->getUsertoken()), 'userType' => urlencode($User->getUsertype()), 'macAddress' => urlencode($User->getMacAddress()), 'ipAddress' => urlencode($User->getIpAddress())); //url-ify the data for the POST foreach ($fields as $key => $value) { $fields_string .= $key . '=' . $value . '&'; } rtrim($fields_string, '&'); //open connection $ch = curl_init(); //set the url, number of POST vars, POST data