<ul> <?php loader_import('siteblog.Filters'); $res = db_shift_array('select extract(YEAR_MONTH FROM created) as d from siteblog_post group by d order by d desc limit 10'); $months = array('01' => intl_get('January'), '02' => intl_get('February'), '03' => intl_get('March'), '04' => intl_get('April'), '05' => intl_get('May'), '06' => intl_get('June'), '07' => intl_get('July'), '08' => intl_get('August'), '09' => intl_get('September'), '10' => intl_get('October'), '11' => intl_get('November'), '12' => intl_get('December')); foreach ($res as $d) { echo '<li><a href="' . site_prefix() . '/index/siteblog-archive-action/d.' . $d . '">' . siteblog_filter_archive_date($d) . '</a></li>'; } ?> </ul>
<?php loader_import('siteblog.Filters'); if (!$parameters['d']) { $parameters['d'] = date('Ym'); } $y = substr($parameters['d'], 0, 4); $m = substr($parameters['d'], 4, 2); page_title(siteblog_filter_archive_date($parameters['d'])); if (!session_admin()) { $res = db_fetch_array('select * from siteblog_post where extract(YEAR_MONTH FROM created) = ? and status = "visible" order by created desc', $parameters['d']); } else { $res = db_fetch_array('select * from siteblog_post where extract(YEAR_MONTH FROM created) = ? order by created desc', $parameters['d']); } $toc = array(); foreach (array_keys($res) as $k) { $toc[$res[$k]->id] = $res[$k]->subject; $res[$k]->comments = db_shift('select count(id) from siteblog_comment where child_of_post = ?', $res[$k]->id); $res[$k]->comments_on = true; $res[$k]->category_name = siteblog_filter_category($res[$k]->category); if ($res[$k]->status == 'visible') { $res[$k]->sitellite_status = 'approved'; } else { $res[$k]->sitellite_status = 'draft'; } } $next = db_shift('select extract(YEAR_MONTH FROM created) as d from siteblog_post where extract(YEAR_MONTH FROM created) > ? group by d order by d asc limit 1', $parameters['d']); $prev = db_shift('select extract(YEAR_MONTH FROM created) as d from siteblog_post where extract(YEAR_MONTH FROM created) < ? group by d order by d desc limit 1', $parameters['d']); page_add_style(site_prefix() . '/inc/app/siteblog/html/post.css'); echo template_simple('archive.spt', array('post' => $res, 'toc' => $toc, 'next' => $next, 'prev' => $prev));