<commit_before><div id="sidebar">
	<span class="heading">Recent Postings</span>
	<div id="recent">
	<?php
	$recent = 5;
    $link = getDbConnection();
	$all = $link->query("SELECT * FROM posts WHERE visible = '1'");
	$total = $all->num_rows;
	$query = $link->query("SELECT * FROM posts WHERE visible = '1' ORDER BY time DESC");
	$numrows = $query->num_rows;
	if ($numrows > 0){
		echo "<ul id='recent-list'>";
        $i = 0;
		while ($post = $query->fetch_array()) {
            if ($i++ == $recent) {
                echo "<span id=\"all-recent\">";
            }
			echo "<li><a href='/post.php?id=".$post['id']."'>".$post['title']."</a></li>";
        }
		if ($total > $recent) {
            echo "</span>";
        }
		echo "</ul>";
		if ($total > $recent) {
			echo "<a id='show-hide-recent' href='javascript:showAllRecent()' data-addl='".($total - $recent)."'>+".($total - $recent)." more…</a>";
        }
	}
	$link->close();
	?>
	</div>
	<div id="archives">
	<span class="heading">Archives</span>
	<?php
    $link = getDbConnection();
	$query = $link->query("SELECT * FROM posts WHERE visible = '1' ORDER BY time DESC");
	while ($post = $query->fetch_array()){
		$year = date("Y", $post['time']);
		$month = date("F", $post['time']);
		$day = date("j", $post['time']);
		$y = false;
		if ($year != $lastyear){
			if (isset($lastyear))
				echo "</ul></ul>";
			$lastyear = $year;
			echo "<ul><li>".$year."</li>";
			$y = true;
		}
		if ($month != $lastmonth){
			if (isset($lastmonth) && !$y)
				echo "</ul>";
			$lastmonth = $month;
			echo "<ul><li>".$month."</li>";
		}
		if ($day != $lastday){
			$lastday = $day;
		}
		echo "<ul><li><a href='/post.php?id=".$post['id']."'>".$month." ".$day."</a></li></ul>";
	}
	echo "</ul></ul></ul>";
	$link->close();
	?>
	</div>
	<?php
	if ($userid == 1 && $username == "mproncace"){
		echo "<div id='create'>
		<span class='heading'>Create</span>
		<ul><li><a href='create.php'>Get Blogging!</a></li></ul>
		</div>";
	}
	?>
	<div id="login">
	<?php
	if ($username && $userid)
		echo '<span class="heading">Login</span><ul><li>Signed in as '.$username.'</li><li><a href="./logout.php?url='.$_SERVER['REQUEST_URI'].'">Logout</a></li></ul>';
	else
		echo '<span class="heading">Login</span><ul><li><a href="./login.php?url='.$_SERVER['REQUEST_URI'].'">Sign In</a></li><li><a href="./register.php">Register an account</a></li></ul>';
	?>
	</div>
	<div id="programs">
	<span class="heading">Links and Stuff</span>
	<ul>
	<li><a href="https://caseif.net/">Landing Page</a></li>
	<li><a href="https://github.com/caseif">GitHub</a></li>
	</ul>
	</div>
</div>
<div id="footer">
	<footer style="text-align: center">
	<br>
	<hr class="divider">
	<br>
	&#169;2013-2017	<NAME>
	<span style="display:inline-block;width:28px"></span>
	<a href="mailto:<EMAIL>">Email me!</a>
	<br>
	<br><commit_msg>Happy new year<commit_after><div id="sidebar">
	<span class="heading">Recent Postings</span>
	<div id="recent">
	<?php
	$recent = 5;
    $link = getDbConnection();
	$all = $link->query("SELECT * FROM posts WHERE visible = '1'");
	$total = $all->num_rows;
	$query = $link->query("SELECT * FROM posts WHERE visible = '1' ORDER BY time DESC");
	$numrows = $query->num_rows;
	if ($numrows > 0){
		echo "<ul id='recent-list'>";
        $i = 0;
		while ($post = $query->fetch_array()) {
            if ($i++ == $recent) {
                echo "<span id=\"all-recent\">";
            }
			echo "<li><a href='/post.php?id=".$post['id']."'>".$post['title']."</a></li>";
        }
		if ($total > $recent) {
            echo "</span>";
        }
		echo "</ul>";
		if ($total > $recent) {
			echo "<a id='show-hide-recent' href='javascript:showAllRecent()' data-addl='".($total - $recent)."'>+".($total - $recent)." more…</a>";
        }
	}
	$link->close();
	?>
	</div>
	<div id="archives">
	<span class="heading">Archives</span>
	<?php
    $link = getDbConnection();
	$query = $link->query("SELECT * FROM posts WHERE visible = '1' ORDER BY time DESC");
	while ($post = $query->fetch_array()){
		$year = date("Y", $post['time']);
		$month = date("F", $post['time']);
		$day = date("j", $post['time']);
		$y = false;
		if ($year != $lastyear){
			if (isset($lastyear))
				echo "</ul></ul>";
			$lastyear = $year;
			echo "<ul><li>".$year."</li>";
			$y = true;
		}
		if ($month != $lastmonth){
			if (isset($lastmonth) && !$y)
				echo "</ul>";
			$lastmonth = $month;
			echo "<ul><li>".$month."</li>";
		}
		if ($day != $lastday){
			$lastday = $day;
		}
		echo "<ul><li><a href='/post.php?id=".$post['id']."'>".$month." ".$day."</a></li></ul>";
	}
	echo "</ul></ul></ul>";
	$link->close();
	?>
	</div>
	<?php
	if ($userid == 1 && $username == "mproncace"){
		echo "<div id='create'>
		<span class='heading'>Create</span>
		<ul><li><a href='create.php'>Get Blogging!</a></li></ul>
		</div>";
	}
	?>
	<div id="login">
	<?php
	if ($username && $userid)
		echo '<span class="heading">Login</span><ul><li>Signed in as '.$username.'</li><li><a href="./logout.php?url='.$_SERVER['REQUEST_URI'].'">Logout</a></li></ul>';
	else
		echo '<span class="heading">Login</span><ul><li><a href="./login.php?url='.$_SERVER['REQUEST_URI'].'">Sign In</a></li><li><a href="./register.php">Register an account</a></li></ul>';
	?>
	</div>
	<div id="programs">
	<span class="heading">Links and Stuff</span>
	<ul>
	<li><a href="https://caseif.net/">Landing Page</a></li>
	<li><a href="https://github.com/caseif">GitHub</a></li>
	</ul>
	</div>
</div>
<div id="footer">
	<footer style="text-align: center">
	<br>
	<hr class="divider">
	<br>
	&#169;2013-2018	<NAME>
	<span style="display:inline-block;width:28px"></span>
	<a href="mailto:<EMAIL>">Email me!</a>
	<br>
	<br>
{'fraction_non_alphanumeric': 0.2797671547010055, 'fraction_numerical': 0.007055918151349445, 'mean_word_length': 3.6513535684987697, 'pattern_counts': {'":': 0, '<': 209, '<?xml version=': 0, '>': 233, 'https://': 4, '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': '4186688', 'n_tokens_mistral': 2351, 'n_tokens_neox': 2189, 'n_words': 431}