diff options
| -rw-r--r-- | server-status-logger.php | 147 |
1 files changed, 147 insertions, 0 deletions
diff --git a/server-status-logger.php b/server-status-logger.php new file mode 100644 index 0000000..b1fa4e2 --- /dev/null +++ b/server-status-logger.php @@ -0,0 +1,147 @@ +#!/usr/bin/env php +# file updated 20. may 2019, 22:00 from http://razor.arnes.si/~asija3/files/server-status-logger.php +<?php +if(empty($argv[1])) { + 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])) { + $dbfile = 'log.db'; +} else { + $dbfile = $argv[2]; +} +$url = $argv[1]; +function tablefromhtml($urltoget) { + $dom = new DOMDocument(); + //load the html + $html = $dom->loadHTMLFile($urltoget); + //discard white space + $dom->preserveWhiteSpace = false; + //the table by its tag name + $tables = $dom->getElementsByTagName('table'); + //get all rows from the table + $rows = $tables->item(0)->getElementsByTagName('tr'); + // get each column by tag name + $cols = $rows->item(0)->getElementsByTagName('th'); + $row_headers = NULL; + foreach ($cols as $node) { + //print $node->nodeValue."\n"; + $row_headers[] = $node->nodeValue; + } + $table = array(); + //get all rows from the table + $rows = $tables->item(0)->getElementsByTagName('tr'); + foreach ($rows as $row) + { + // get each column by tag name + $cols = $row->getElementsByTagName('td'); + $row = array(); + $i=0; + foreach ($cols as $node) { + # code... + //print $node->nodeValue."\n"; + if($row_headers==NULL) + $row[] = $node->nodeValue; + else + $row[$row_headers[$i]] = $node->nodeValue; + $i++; + } + $table[] = $row; + return $table; + } +} + + class MyDB extends SQLite3 { + function __construct() { + $this->open($dbfile); + } + } + $dbConnect = new MyDB(); + if(!$dbConnect) { + exit($dbConnect->lastErrorMsg()); + } else { + echo "Opened database successfully\n"; + } + $tablename = "dnevnik"; + + $result = $dbConnect->query('CREATE TABLE IF NOT EXISTS '.$tablename.' ( + "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + "timestamp" INTEGER, + "worker" INTEGER, + "client" TEXT, + "vhost" TEXT, + "request" TEXT + )'); + + // var_dump($table); // debug + // exit(); // debug + +$countTable = $dbConnect->querySingle("SELECT COUNT(*) as count FROM ".$tablename.""); +$countTable = true; +while($countTable) { // while true basically + $table = tablefromhtml($url); + 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 ?!?!?!!?!? + $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 + $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"; + } + } else { + echo "whoops?\n"; + $dbConnect->lastErrorMsg(); + } + } +} + +// echo build_table($table); // debug +// header("Content-type: text/plain"); // debug +// var_dump($table); // debug + + + +function build_table($array){ // not needed, maybe for debugging + // 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; +} + +?> |