<?php

$temp_html = "<p>\r<b>События</b></p>\r<br>\r";

$result = query("SELECT `actions`.*, `firms_types`.`human_id`, `firms_types`.`human_subid` FROM `actions` LEFT JOIN `firms_types` ON `actions`.`type`=`firms_types`.`id` ORDER BY `id`;");

while($data = mysql_fetch_array($result)) {
	$temp_html .= "&bull;&nbsp;<a href=\"/".$data['human_id']."/".$data['human_subid']."/".$data['id']."/\">".$data['title']."</a> (<a href=\"/".$data['human_id']."/".$data['human_subid']."/".$data['id']."/opinions/\">отзывы</a>)<br>\r";
}

$temp_html .= "<p><b>Заведения</b></p>\r<br>\r";

$result = query("SELECT `firms`.*, `firms_types`.`human_id`, `firms_types`.`human_subid` FROM `firms` LEFT JOIN `firms_types` ON `firms`.`type`=`firms_types`.`id` ORDER BY `id`;");

while($data = mysql_fetch_array($result)) {
	$temp_html .= "&bull;&nbsp;<a href=\"/".$data['human_id']."/".$data['id']."/\">".$data['title']."</a> (<a href=\"/".$data['human_id']."/".$data['id']."/opinions/\">отзывы</a>)<br>\r";
}

$first = query("SELECT * FROM `shedule` WHERE `datetime`!='0000-00-00 00:00:00' ORDER BY `datetime` LIMIT 1;");

if(mysql_num_rows($first)==1) {		
	$first = mysql_fetch_array($first);
	if($first['datetime']!="0000-00-00 00:00:00")	{
	
	$temp_html .= "<p><b>Календарь</b></p><br>\r";
	

	list($first_date,$first_time)=explode(" ",$first['datetime']);
	list($year,$mon,$day)=explode("-",$first_date);
	list($hour,$min,$sec)=explode(":",$first_time);
	
	$start_date = mktime($hour-1,$min,$sec,$mon,$day,$year);
	
	//////////////////////////////////
	$cur_mon = "";
        for ($i=$start_date;$i<=time();$i+=86400)
             {
             if($cur_mon!=date("m",$i)) {
             	$cur_mon = date("m",$i);
             	
             switch($cur_mon)
                    {
                    case "01": $mon_title = "Январь"; break;
                    case "02": $mon_title = "Февраль"; break;
                    case "03": $mon_title = "Март"; break;
                    case "04": $mon_title = "Апрель"; break;
                    case "05": $mon_title = "Май"; break;
                    case "06": $mon_title = "Июнь"; break;
                    case "07": $mon_title = "Июль"; break;
                    case "08": $mon_title = "Август"; break;
                    case "09": $mon_title = "Сентябрь"; break;
                    case "10": $mon_title = "Октябрь"; break;
                    case "11": $mon_title = "Ноябрь"; break;
                    case "12": $mon_title = "Декабрь"; break;
                    }             	
             	
                //$temp_html = substr($temp_html,0,strrpos($temp_html,", "));
                    
             	$temp_html .= "<br>\r&bull;&nbsp;".$mon_title."&nbsp;".date("Y",$i).": ";             	
             }
             $day = date("j",$i);
             
                     $result = mysql_fetch_array(query("SELECT COUNT(`id`) FROM `shedule` WHERE `datetime`>'".date("Y-m-d H:i:s",$i)."' AND `datetime`<'".date("Y-m-d H:i:s",$i+86400)."';"));


                 if ($result[0]>0)
                     {
                     $temp_html .= "<a href=\"/".date("d-m-Y",$i)."/"."\">".$day."</a>, ";
                     }
             }
    /////////////////////////////////////	
	
	
}
}

$p = $global_vars['page'];

$t = "";
$n = 0;
$total = 0;

$pp = explode("\r",$temp_html);

$f = array();

if(sizeof($pp)>1) {
	foreach($pp as $pp_one) {
		
		if(($n + substr_count($pp_one,"<a"))<150) {
			$t .= $pp_one."\r";
			$n += substr_count($pp_one,"<a");
		}
		else {
			
			$f[] = $t;
			$total += $n;
			$n = substr_count($pp_one,"<a");
			$t = $pp_one."\r";
		}
	}
	
}

if(strlen($t)>0) {
	$f[] = $t;
	$total += $n;
}

$temp_html = $f[$p-1];

$skin_span = skin_span(140,$global_vars['page'],$total,$url."services/sitemap/");

$temp_html = preg_replace("/{%(\w+)%}/ee", "$\\1",_html("services_sitemap.htm",0));

_html_design($temp_html);

?>