<commit_before><html>
<head>
	<style type="text/css">
		tr td:first-child {
			text-align: right;
		}
		td {
			padding: 0 20px;
			margin: 0;
			border: 0;
			border-bottom: thin #CCC solid;
		}
		tr {
			border-bottom: thin #000 solid;
		}
		tr:hover {
			background-color: #AFA;
		}
	</style>
</head>
<body style="font-family: 'Lucida Console', Monaco, monospace">
<table>
	<thead><tr><td>ID</td><td>Comment</td></tr></thead>
	<tbody>
<?php
	$db = new mysqli('localhost', 'bender0', 'B4pHUX3fC8x5RfXK', 'bender0');
	$result = $db->query('SELECT * FROM SarsaState');
	while ($row = $result->fetch_array(MYSQLI_NUM)) {
		if (is_null($row[1]))
			continue;
		echo '<tr><td>' . $row[0] . '</td><td>' . nl2br(str_replace(' ', '&nbsp;', $row[1])) . '</td></tr>' . "\n";
	}
	$result->free();
	$db->close();
?>
	</tbody>
</table>
</body>
</html><commit_msg>Update State-Analyzer php. Shows- and sorts by q-Values.<commit_after><html>
<head>
	<style type="text/css">
		tr td:first-child {
			text-align: right;
		}
		td {
			padding: 0 20px;
			margin: 0;
			border: 0;
			border-bottom: thin #CCC solid;
		}
		tr {
			border-bottom: thin #000 solid;
		}
		tr:hover {
			background-color: #AFA;
		}
	</style>
</head>
<body style="font-family: 'Lucida Console', Monaco, monospace">
<table>
	<thead><tr><td>ID</td><td>Comment</td><td>Actions.</td></tr></thead>
	<tbody>
<?php
	function numberToDirection($num) {
		switch ($num) {
			case 1: return 'WEST';
			case 2: return 'EAST';
			case 3: return 'NORT';
			case 4: return 'SOUT';
		}
	}
	
	$db = new mysqli('localhost', 'bender0', 'B4pHUX3fC8x5RfXK', 'bender0');
	$result = $db->query('SELECT gStateId, gStateComment FROM `SarsaState` s LEFT JOIN `SarsaStateAction` a ON s.gStateId = a.state GROUP BY gStateId, gStateComment ORDER BY MAX(ABS(a.qValue)) DESC ');
	while ($row = $result->fetch_array(MYSQLI_NUM)) {
		if (is_null($row[1]))
			continue;
		$inResult = $db->query('SELECT action, qValue FROM SarsaStateAction WHERE state = ' . $row[0]);
		echo '<tr><td>' . $row[0] . '</td><td>' . nl2br(str_replace(' ', '&nbsp;', $row[1])) . '</td><td>';
		while ($inRow = $inResult->fetch_array(MYSQLI_NUM)) {
			echo numberToDirection($inRow[0]) . ' ' . $inRow[1] . '<br />';
		}
		echo '</td></tr>' . "\n";
	}
	$result->free();
	$db->close();
?>
	</tbody>
</table>
</body>
</html>
{'fraction_non_alphanumeric': 0.22375215146299485, 'fraction_numerical': 0.018502581755593803, 'mean_word_length': 3.813664596273292, 'pattern_counts': {'":': 0, '<': 62, '<?xml version=': 0, '>': 72, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5850005', 'n_tokens_mistral': 1058, 'n_tokens_neox': 953, 'n_words': 204}