#!/usr/bin/php
<?php
$test = shell_exec('last -10');

$servername = "localhost";
$username = "root";
$password = "passwd43";
$dbname = "users";
$oparray = preg_split('/[\r\n]+/', $test);
$i = 0;
$export;
$status;
$time;
$hour;
$minute;

foreach ($oparray as $array) {
	$test2 = preg_split('/[\s,]+/', $array);
	if($test2[0] == "reboot" || $test2[0] == "" || $test2[0] == "wtmp") {
		continue;
	}
	$export[$i] = $test2[0];
	if($test[9] == "crash") {
		$status[$i] = "ko";
	} else {
		$status[$i] = "ok";
	}
	if($test2[0] == "root"){
		$time = preg_split('/:/', $test2[5]);
	} else {
		$time = preg_split('/:/', $test2[6]);
	}
	$hour[$i] = $time[0];
	$minute[$i] = $time[1];
	$i += 1;
}

$conn = new mysqli($servername, $username, $password, $dbname);

if($conn->connect_error) {
	die("Conneciton failed : " . $conn->connect_error);
}

$sql = "DELETE FROM logs";

if($conn->query($sql) === TRUE) {

} else {
	echo "Error : " . $conn->error;
}
$i = 0;
foreach($export as $exportarray) {
	$date =  new DateTime();
	$date =  $date-> setTime(intval($hour[$i]), intval($minute[$i]));
	$date =  $date->format('Y-m-d H:i:s');
	$sql = "INSERT INTO logs (datetime, user, status)
		VALUES ('$date', '$exportarray', '$status[$i]')";

	if($conn->query($sql) === TRUE) {

	} else {
		echo "Error : " . $sql . "<br/>" . $conn->error;
	}
	$i++;
}
$conn->close();
?>