GMWeb/www/blog/common/rightpanel.php

<div id="right_column">
    <div id="archive" class="section desktop">
        <h3 class="section_title"><?=$lng["blog_archive"]?></h3>
        <div class='entry'>
<?php
            $q_year = mysqli_query($con, "SELECT year(dtime) AS year FROM post WHERE visible = 1 GROUP BY year(dtime) ORDER BY year DESC;");
            while($r_year = mysqli_fetch_array($q_year)){
?>
                <div class='year pointer' onClick='toggleElement("year_<?=$r_year["year"]?>");'>
                    <img class='slid' id='slid_year_<?=$r_year["year"]?>' src='<?=$server?>/img/misc/slid-right.png' alt='<?=$r_year["year"]?>'/>
                    <span class='fake_a'><?=$r_year["year"]?></span>
                </div>
                <div class='list_year pointer' id='list_year_<?=$r_year["year"]?>'>
<?php
                    $q_month = mysqli_query($con, "SELECT month(dtime) AS month FROM post WHERE visible = 1 AND year(dtime) = $r_year[year] GROUP BY month(dtime) ORDER BY month DESC;");
                    while($r_month = mysqli_fetch_array($q_month)){
?>
                        <div class='month pointer' onClick='toggleElement("month_<?=$r_year["year"]?>_<?=$r_month["month"]?>");'>
                            <img class='slid' id='slid_month_<?=$r_year["year"]?>_<?=$r_month["month"]?>' src='<?=$server?>/img/misc/slid-right.png' alt='<?=$r_month["month"]?>'/>
                            <span class='fake_a'><?=$lng["months"][$r_month["month"] - 1]?></span>
                        </div>
                        <ul id='list_month_<?=$r_year["year"]?>_<?=$r_month["month"]?>' class='post_list'>
<?php
                            $q_title = mysqli_query($con, "SELECT id, permalink, title_$lang AS title FROM post WHERE visible = 1 AND year(dtime) = $r_year[year] AND month(dtime) = '$r_month[month]' ORDER BY dtime DESC;");
                            while($r_title = mysqli_fetch_array($q_title)){
?>
                                <li>
                                    <a href='$proto$http_host/blog/<?=$r_title["permalink"]?>'><?=$r_title["title"]?></a>
                                </li>
<?php
                            }
?>
                        </ul>
<?php
                    }
?>
                </div> <!-- #list_year_<?=$r_year["year"]?> -->
<?php
            } //while($r_year = mysqli_fetch_array($q_year))
?>
        </div> <!-- .entry -->
    </div> <!-- #archive -->
</div> <!-- #right_column-->