<commit_before><ul>
    <li>
        <a href="index.php">
            Blog
        </a>
    </li>
    <li>
        <a href="about.php">
            About The Blog & Author
        </a>
    </li>
</ul>
<h2>Popular Posts</h2>


<ul>
    <?php
    $stmt = $db->query('SELECT postTitle, postID FROM blog_posts_seo WHERE published = 1 ORDER BY views DESC LIMIT 5');
    while($row = $stmt->fetch()){
        echo '<li><a href="'.$row['postID'].'">'.$row['postTitle'].'</a></li>';
    }
    ?>
</ul>

<h2>Catgories</h2>


<ul>
    <?php
    $stmt = $db->query('SELECT catTitle, catSlug FROM blog_cats ORDER BY catTitle DESC');
    while($row = $stmt->fetch()){
        echo '<li><a href="c-'.$row['catSlug'].'">'.$row['catTitle'].'</a></li>';
    }
    ?>
</ul>

<h2>Archives</h2>


<ul>
    <?php
    $stmt = $db->query("SELECT Month(postDate) as Month, Year(postDate) as Year FROM blog_posts_seo GROUP BY Month(postDate), Year(postDate) ORDER BY postDate DESC");
    while($row = $stmt->fetch()){
        $monthName = date("F", mktime(0, 0, 0, $row['Month'], 10));
        $slug = 'a-'.$row['Month'].'-'.$row['Year'];
        echo "<li><a href='$slug'>$monthName " . $row['Year'] . "</a></li>";
    }
    ?>
</ul>

<h2>Useful Links</h2>

<ul>
    <?php
    if(isset($_SESSION['uid']) && $_SESSION['uid'] > 0)
    {
?><commit_msg>Lets actually have the categories go in the right direction!<commit_after><ul>
    <li>
        <a href="index.php">
            Blog
        </a>
    </li>
    <li>
        <a href="about.php">
            About The Blog & Author
        </a>
    </li>
</ul>
<h2>Popular Posts</h2>


<ul>
    <?php
    $stmt = $db->query('SELECT postTitle, postID FROM blog_posts_seo WHERE published = 1 ORDER BY views DESC LIMIT 5');
    while($row = $stmt->fetch()){
        echo '<li><a href="'.$row['postID'].'">'.$row['postTitle'].'</a></li>';
    }
    ?>
</ul>

<h2>Catgories</h2>


<ul>
    <?php
    $stmt = $db->query('SELECT catTitle, catSlug FROM blog_cats ORDER BY catTitle ASC');
    while($row = $stmt->fetch()){
        echo '<li><a href="c-'.$row['catSlug'].'">'.$row['catTitle'].'</a></li>';
    }
    ?>
</ul>

<h2>Archives</h2>


<ul>
    <?php
    $stmt = $db->query("SELECT Month(postDate) as Month, Year(postDate) as Year FROM blog_posts_seo GROUP BY Month(postDate), Year(postDate) ORDER BY postDate DESC");
    while($row = $stmt->fetch()){
        $monthName = date("F", mktime(0, 0, 0, $row['Month'], 10));
        $slug = 'a-'.$row['Month'].'-'.$row['Year'];
        echo "<li><a href='$slug'>$monthName " . $row['Year'] . "</a></li>";
    }
    ?>
</ul>

<h2>Useful Links</h2>

<ul>
    <?php
    if(isset($_SESSION['uid']) && $_SESSION['uid'] > 0)
    {
?>
{'fraction_non_alphanumeric': 0.23850148367952523, 'fraction_numerical': 0.011869436201780416, 'mean_word_length': 2.654471544715447, 'pattern_counts': {'":': 0, '<': 85, '<?xml version=': 0, '>': 99, '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': '3159654', 'n_tokens_mistral': 1048, 'n_tokens_neox': 1022, 'n_words': 221}