Access Log
This script will not run unless it is run from port 8000/8080 to avoid interfering with statistics<!DOCTYPE html>
<meta name="viewport" content="width=device-width, initial-scale=1">
<html><style>
input{color:#22f}*{font-size:18px}h1{font-size:36px}tr:nth-child(2n){background:#fcf;}form{display:inline}table,tr,td,input{border:2px solid #930;border-collapse:collapse;padding:0.3em}body{color:#930;font-family:Arial,sans-serif;margin:2%;padding:2%;background-color:#dfd}.container{max-width:600px;margin:50px auto;background-color:#fff;border-radius:10px;padding:20px;box-shadow:0 0 10px rgba(0,0,0,.1)}.container form{margin-bottom:20px}.container input[type="file"]{margin-bottom:10px}.container h2{margin-bottom:10px}.container ul{list-style:none;padding:0}.container ul li{margin-bottom:5px}
</style><body>
<h1>Access Log</h1>
<?php print("This script will not run unless it is run from port 8000/8080 to avoid interfering with statistics");
show_source('logger.php');exit('</body></html>');
function diff($t){
#This function calculates the difference between filetime and now, using D/H/M/S.
$s = time() - $t;
if($s<60){return 'Not long ago';}
elseif($s<3600){$z = (($s-($s%60))/60).'m';}
elseif($s<86400){$z = (($s-($s%3600))/3600).'h '.((($s-($s%60))/60)%60).'m ';}
elseif(1==1){$z = (($s-($s%86400))/86400)."d ".((($s-($s%3600))/3600)%24).'h';;}
return $z;
}
$db=new SQLite3('/media/peplive/1844AEA344AE82DC/Aera23/Downloads/files/log.db');
# Create sheet table if needed
$db->exec('CREATE TABLE IF NOT EXISTS sheet(
id INTEGER PRIMARY KEY, z BLOB,
a BLOB, b BLOB,c BLOB,
t INTEGER)');
$stmt = $db->prepare('SELECT * FROM sheet');
$result = $stmt->execute();
$view=[];
while($row = $result->fetchArray(SQLITE3_ASSOC)){$view[] = $row;}
#squeeze
function s($a){$b='|';
foreach($a as$k=>$v){$b.=$k.'|'.$v.'|';}
return$b;}
if(1==1){
$stmt = $db->prepare("INSERT INTO sheet (z,a,b,c,t) VALUES(:z,:a,:b,:c, ".intval(time()).");");
$stmt->bindValue(':z', htmlspecialchars(s($_SERVER)??''), SQLITE3_BLOB);
$stmt->bindValue(':a', htmlspecialchars(s($_GET)??''), SQLITE3_BLOB);
$stmt->bindValue(':b', htmlspecialchars(s($_POST)??''), SQLITE3_BLOB);
$stmt->bindValue(':c', htmlspecialchars(s($_COOKIE)??''), SQLITE3_BLOB);
$r=$stmt->execute();
}
?><p>Probe logged, tks for choosing Aera23</p></body></html>