<?php

//- Настройки модуля -----------------------------------------------------------
permission("mcp"); // tcp-техники; acp-админы; mcp-модеры; cp-рядовые участники
$skin_pname = "Статистика SMS-афиш";
//------------------------------------------------------------------------------

function mounth2text($mounth) {
	switch ($mounth) {
		case "01" : $mounth_text = "Январь"; break;
		case "02" : $mounth_text = "Февраль"; break;
		case "03" : $mounth_text = "Март"; break;
		case "04" : $mounth_text = "Апрель"; break;
		case "05" : $mounth_text = "Май"; break;
		case "06" : $mounth_text = "Июнь"; break;
		case "07" : $mounth_text = "Июль"; break;
		case "08" : $mounth_text = "Август"; break;
		case "09" : $mounth_text = "Сентябрь"; break;
		case "10" : $mounth_text = "Октябрь"; break;
		case "11" : $mounth_text = "Ноябрь"; break;
		case "12" : $mounth_text = "Декабрь"; break;
	}
	return $mounth_text;
}

$temp_html="";

$result = mysql_query("SELECT * FROM `sms` ORDER BY `datetime`;");

$m_count = 0;
$mounth = 0;
$year = 0;

$temp_html .= "<table>";

while($data = mysql_fetch_array($result)) {
	$c_year = substr($data['datetime'],0,4);
	$c_mounth = substr($data['datetime'],5,2);
	
	if(($mounth!=$c_mounth) || ($year!=$c_year)) {

		if($mounth!=0)
			$temp_html .= "<tr><td>".mounth2text($mounth)." ".$year."</td><td>".$m_count."</td></tr>";		
		
		$mounth=$c_mounth;
		$year=$c_year;
		$m_count = 1;
	}
	else
		$m_count += 1;
}

if(mysql_num_rows($result)>0)
	$temp_html .= "<tr><td>".mounth2text($mounth)." ".$year."</td><td>".$m_count."</td></tr>";

$temp_html .= "</table>";

skin_html_design($temp_html);

?>