connect_error) { die("MySQL connection failed: ". $conn->connect_error); } /** * Metoda uwierzytelnia uzytkownika * i zwraca ID sesji w odpowiedzi **/ if($method == "auth") { if(isset($_GET["uname"]) && isset($_GET["pwd"])) { $username = $_GET["uname"]; $passwd = $_GET["pwd"]; if($username != null && $passwd != null) { $sql = "SELECT `password` FROM `accounts` WHERE username LIKE '".$username."';"; $result = $conn->query($sql); if($result && $result->num_rows > 0) { $row = $result->fetch_assoc(); $dbpass = $row["password"]; $passwd = strtoupper(sha1(sha1($passwd, true))); $passwd = '*' . $passwd; if ($passwd == $dbpass) { $sessionid = uniqid($username); $sql = "UPDATE `accounts` SET lastlogin = now(3), lastsessionid = '".$sessionid."', sessionvalidto = now(3) + interval 10 second WHERE `username` LIKE '".$username."';"; $conn->query($sql); header("HTTP/1.1 202 Accepted"); echo $sessionid; } else { header("HTTP/1.1 401 Unauthorized"); echo 'Invalid password.'; } } else { header("HTTP/1.1 401 Unauthorized"); die("User not found in database!"); } } else { header("HTTP/1.1 406 Not Acceptable"); die("Username and password cannot be empty!"); } } else { header("HTTP/1.1 406 Not Acceptable"); die("Username and password cannot be empty!"); } } if($method == "insert") { if(isset($_GET["auth"])) { $auth = $_GET["auth"]; if($auth != null && $auth != "") { $sql = "SELECT true FROM `lora`.`accounts` WHERE lastsessionid = '".$auth."' AND sessionvalidto > now(3)"; $result = true; if($result) { $sender_ID = $_GET["sender_ID"]; $rec_ID = $_GET["rec_ID"]; $rec_TIME = $_GET["rec_TIME"]; $rec_FRONT = $_GET["rec_FRONT"]; $rec_RIGHT = $_GET["rec_RIGHT"]; $rec_REAR = $_GET["rec_REAR"]; $rec_LEFT = $_GET["rec_LEFT"]; $gps_SAT = $_GET["gps_SAT"]; $gps_HDOP = $_GET["gps_HDOP"]; $gps_LAT = $_GET["gps_LAT"]; $gps_LON = $_GET["gps_LON"]; $gps_FIX = $_GET["gps_FIX"]; $gps_DATE = $_GET["gps_DATE"]; $gps_TIME = $_GET["gps_TIME"]; $gps_ALT = $_GET["gps_ALT"]; $gps_COURSE = $_GET["gps_COURSE"]; $gps_SPEED = $_GET["gps_SPEED"]; $rssi = $_GET["rssi"]; $battery = $_GET["battery"]; $receiver_LAT = $_GET["receiver_LAT"]; $receiver_LON = $_GET["receiver_LON"]; $sql = 'INSERT INTO `lora`.`measurement`'. ' (`timestamp`,`sender_ID`,`rec_ID`,`rec_TIME`,`rec_FRONT`,`rec_RIGHT`,`rec_REAR`,`rec_LEFT`,`gps_SAT`,`gps_HDOP`,`gps_LAT`,`gps_LON`,`gps_FIX`,`gps_DATE`,`gps_TIME`,`gps_ALT`,`gps_COURSE`,`gps_SPEED`,`rssi`,`battery`,`receiver_LAT`,`receiver_LON`)'. ' VALUES (now(3),\''.$sender_ID.'\',\''.$rec_ID.'\',\''.$rec_TIME.'\',\''.$rec_FRONT.'\',\''.$rec_RIGHT.'\',\''.$rec_REAR.'\',\''.$rec_LEFT.'\',\''.$gps_SAT.'\',\''.$gps_HDOP.'\',\''.$gps_LAT.'\',\''.$gps_LON.'\',\''.$gps_FIX.'\',\''.$gps_DATE.'\',\''.$gps_TIME.'\',\''.$gps_ALT.'\',\''.$gps_COURSE.'\',\''.$gps_SPEED.'\',\''.$rssi.'\',\''.$battery.'\',\''.$receiver_LAT.'\',\''.$receiver_LON.'\');'; echo 'Query: '.$sql; if($conn->query($sql) === TRUE) { header("HTTP/1.1 202 Accepted"); echo "Query executed successfully"; } else { header("HTTP/1.1 406 Not Acceptable"); echo "SQL error:
".$conn->error; } } else { header("HTTP/1.1 401 Unauthorized"); die("Session has expired or not exists!"); } } else { header("HTTP/1.1 401 Unauthorized"); die("User not found in database!"); } } else { header("HTTP/1.1 401 Unauthorized"); die("User not found in database!"); } } if($method == "view" || $method == "One record per device" || $method == "All rows (limit 100)") { ?> query($sql); $rowno = 1; if($result->num_rows > 0) { echo ""; echo ""; while($row = $result->fetch_assoc()) { if($rowno == 2) { echo ""; } echo "

id	timestamp	sender_ID	rec_ID	rec_TIME	rec_FRONT	rec_RIGHT	rec_REAR	rec_LEFT	gps_SAT	gps_HDOP	gps_LAT	gps_LON	gps_FIX	gps_DATE	gps_TIME	gps_ALT	gps_COURSE	gps_SPEED	rssi	battery	receiver_LAT	receiver_LON
"; $rowno = 0; } else { echo "
"; } $rowno++; echo $row["id"]; echo "	"; echo$row["timestamp"]; echo "	"; echo$row["sender_ID"]; echo "	"; echo$row["rec_ID"]; echo "	"; echo$row["rec_TIME"]; echo "	"; echo$row["rec_FRONT"]; echo "	"; echo$row["rec_RIGHT"]; echo "	"; echo$row["rec_REAR"]; echo "	"; echo$row["rec_LEFT"]; echo "	"; echo$row["gps_SAT"]; echo "	"; echo$row["gps_HDOP"]; echo "	"; echo$row["gps_LAT"]; echo "	"; echo$row["gps_LON"]; echo "	"; echo$row["gps_FIX"]; echo "	"; echo$row["gps_DATE"]; echo "	"; echo$row["gps_TIME"]; echo "	"; echo$row["gps_ALT"]; echo "	"; echo$row["gps_COURSE"]; echo "	"; echo$row["gps_SPEED"]; echo "	"; echo$row["rssi"]; echo "	"; echo$row["battery"]; echo "	"; echo$row["receiver_LAT"]; echo "	"; echo$row["receiver_LON"]; echo "

"; } else { echo "0 results"; } ?> close(); ?>