From 328de18b9cc149a84feb09b0f95eef6d9c3a2dee Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Anton=20=C5=A0ijanec?= <sijanecantonluka@gmail.com>
Date: Sat, 1 Jun 2019 17:52:38 +0200
Subject: updated

yes
---
 server-status-logger.php | 61 +++++++++++-------------------------------------
 1 file changed, 14 insertions(+), 47 deletions(-)

(limited to 'server-status-logger.php')

diff --git a/server-status-logger.php b/server-status-logger.php
index 3663f3c..74c97f1 100644
--- a/server-status-logger.php
+++ b/server-status-logger.php
@@ -1,8 +1,9 @@
 #!/usr/bin/env php
-#file updated from http://razor.arnes.si/~asija3/files/server-status-logger.php at 29. may 2019 at 22:14
+#file updated from http://razor.arnes.si/~asija3/files/server-status-logger.php at 1. June 2019 at 17:53
+#!/usr/bin/env php
 <?php
 if(empty($argv[1])) {
-	exit("server-status-logger.php v0.1 2019 Anton Ĺ ijanec astiril/server-status-logger\n
+	exit("server-status-logger.php v0.1 2019 Anton Šijanec astiril/server-status-logger\n
 	$argv[0] server-status-url [dbfile]\n");
 }
 if(empty($argv[2])) {
@@ -74,74 +75,40 @@ function tablefromhtml($urltoget) {
 	"request" TEXT
 	)');
    
-   // var_dump($table); // debug
-   // exit(); // debug
    
 $countTable = $dbConnect->querySingle("SELECT COUNT(*) as count FROM ".$tablename."");
 $countTable = true;
-while($countTable) { // while true basically
+while($countTable) { // if table is ok while true basically
 	echo "r";
 	$table = tablefromhtml($url);
-	// var_dump($table); // debug
 	end($table);
 	$lastkey = key($table);
 	for($i=1;$i <= $lastkey;$i++) {
-		// echo $table[$i]["Client"] . " ";
 		$unique = false;
 		$smt = $dbConnect->prepare("SELECT `client`, `request` FROM ".$tablename." WHERE `worker` = :worker ORDER BY `timestamp` DESC LIMIT 1");
 		$smt->bindValue(':worker', explode('-', $table[$i]["Srv"]), SQLITE3_TEXT)[0];
-		@$query = $smt->execute(); // string>array notice ?!?!?!!?!?
+		@$query = $smt->execute(); // string>array notice
 		$row = $query->fetchArray(SQLITE3_ASSOC);
-		// var_dump($row); // debug
 		if(!is_array($row) || empty(array_diff($row, array($table[$i]["Client"], $table[$i]["Request"])))) {
 			$unique = true;
 		}
-		if($table[$i]["Client"] != "::1" && $unique) { // ::1 because localhost is always querying for some reason via IPv6
+		if($table[$i]["Client"] != "::1" && $unique) { // ::1 because localhost is always querying for some reason via IPv6 on my target server
 			$smt = $dbConnect->prepare("INSERT INTO ".$tablename." (timestamp, worker, client, vhost, request) VALUES ( :timestamp, :worker, :client, :vhost, :request )");
 			$smt->bindValue(':timestamp', date("U"), SQLITE3_TEXT);
 			$smt->bindValue(':worker', explode('-', $table[$i]["Srv"])[0], SQLITE3_TEXT);
 			$smt->bindValue(':client', $table[$i]["Client"], SQLITE3_TEXT);
 			$smt->bindValue(':vhost', $table[$i]["VHost"], SQLITE3_TEXT);
 			$smt->bindValue(':request', $table[$i]["Request"], SQLITE3_TEXT);
-			$query = $smt->execute();
-			if($query) {
-				echo ".";
-			} else {
-				echo "x";
+			$query = false;
+			while(!$query) {
+				$query = @$smt->execute();
+				if($query) {
+					echo ".";
+				} else {
+					echo "x";
+				}
 			}
 		}
 	}
 }
-
-// echo build_table($table); // debug
-// header("Content-type: text/plain"); // debug
-// var_dump($table); // debug
-
-
-
-function build_table($array){
-    // start table
-    $html = '<table>';
-    // header row
-    $html .= '<tr>';
-    foreach($array[0] as $key=>$value){
-            $html .= '<th>' . htmlspecialchars($key) . '</th>';
-        }
-    $html .= '</tr>';
-
-    // data rows
-    foreach( $array as $key=>$value){
-        $html .= '<tr>';
-        foreach($value as $key2=>$value2){
-            $html .= '<td>' . htmlspecialchars($value2) . '</td>';
-        }
-        $html .= '</tr>';
-    }
-
-    // finish table and return it
-
-    $html .= '</table>';
-    return $html;
-}
-
 ?>
-- 
cgit v1.2.3