Code: Alles auswählen
<?php
$sql = 'SELECT YEAR(FROM_UNIXTIME(post_time)) as aar, MONTH(FROM_UNIXTIME(post_time)) as mnd, COUNT(*) AS ant
FROM ' . POSTS_TABLE . '
GROUP BY YEAR(FROM_UNIXTIME(post_time)),MONTH(FROM_UNIXTIME(post_time))
ORDER BY post_time';
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Couldn\'t retrieve posts data', '', __LINE__, __FILE__, $sql);
}
$posts_count = $db->sql_numrows($result);
$posts_data = $db->sql_fetchrowset($result);
for ($i = 0; $i < $posts_count; $i=$i+$k)
{
$class = ( !($i+1 % 2) ) ? $theme['td_class2'] : $theme['td_class1'];
$year = $posts_data[$i]['aar'];
$k = 0;
for ($j = 0; $j < 12; $j++)
{
$m[$j+1] = 0;
}
for ($j = 0; $j < 12; $j++)
{
if ($year == $posts_data[$i+$j]['aar'])
{
$month = $posts_data[$i+$j]['mnd'];
$m[$month] = $posts_data[$i+$j]['ant'];
$k = $k + 1;
}
}
$template->assign_block_vars('newposts', array(
'CLASS' => $class,
'YEAR' => $year,
'M01' => $m[1],
'M02' => $m[2],
'M03' => $m[3],
'M04' => $m[4],
'M05' => $m[5],
'M06' => $m[6],
'M07' => $m[7],
'M08' => $m[8],
'M09' => $m[9],
'M10' => $m[10],
'M11' => $m[11],
'M12' => $m[12])
);
}
$template->assign_vars(array(
'L_NEWPOSTSBYMONTH' => $lang['Posts_month'],
'L_YEAR' => $lang['Year'],
'L_MONTH' => $lang['Month'],
'L_NUMBER' => $lang['Number'],
'L_JAN' => $lang['Month_jan'],
'L_FEB' => $lang['Month_feb'],
'L_MAR' => $lang['Month_mar'],
'L_APR' => $lang['Month_apr'],
'L_MAY' => $lang['Month_may'],
'L_JUN' => $lang['Month_jun'],
'L_JUL' => $lang['Month_jul'],
'L_AUG' => $lang['Month_aug'],
'L_SEP' => $lang['Month_sep'],
'L_OCT' => $lang['Month_oct'],
'L_NOV' => $lang['Month_nov'],
'L_DEC' => $lang['Month_dec'])
);
?>Code: Alles auswählen
#
#-----[ ÖFFNEN ]------------------------------------------
#
# z.B. templates/xxx/index_body.tpl
#
#-----[ EINFÜGEN (dort wo die letzten Themen angezeigt werden sollen) ]------------------------
#
<table width="100%" cellpadding="1" cellspacing="1" border="0" align="center" class="forumline">
<tr>
<th colspan="5">{L_RECENT_TITLE}</th>
</tr>
<!-- BEGIN recent -->
<tr>
<td class="{recent.ROW_CLASS}" align="center" valign="middle"><img src="{recent.TOPIC_FOLDER_IMG}" alt="{recent.TOPIC_FOLDER_ALT}" title="{recent.TOPIC_FOLDER_ALT}" /></td>
<td class="{recent.ROW_CLASS}" nowrap="nowrap"><span class="topictitle">{recent.NEWEST_IMG}{recent.TOPIC_TYPE}<a href="{recent.U_VIEW_TOPIC}" class="topictitle">{recent.TOPIC_TITLE}</a></span>
<span class="gensmall">{recent.GOTO_PAGE}<br />{recent.FIRST_TIME}{recent.FIRST_AUTHOR}<br /></span></td>
<td class="{recent.ROW_CLASS}" width="8%" align="left"><span class="postdetails"> {recent.L_REPLIES}: {recent.REPLIES}
<br /> {recent.L_VIEWS}: {recent.VIEWS}</span></td>
<td class="{recent.ROW_CLASS}" width="25%" nowrap="nowrap"> <span class="forumlink"><a href="{recent.U_VIEW_FORUM}" class="forumlink">{recent.FORUM_NAME}</span></td>
<td class="{recent.ROW_CLASS}" width="25%" nowrap="nowrap"><span class="postbody">{recent.POST_TEXT}</span><br />
<span class="gensmall"> {recent.LAST_URL} {recent.LAST_TIME} {recent.LAST_AUTHOR}</span></td>
</tr>