File: /var/www/ilya/data/www/afisha38.ru/modules/afisha/index.inc
<?php
#————————————————————> CMS Termit <———————————————————————#
# #
# Author: Ilya Rudomilov #
# #
# E-mail: ilya@rudomilov.ru #
# URL: http://www.rudomilov.ru/ #
# ICQ: 203015 #
# #
#——————————————> Grafix Design — (c) 2006 <———————————————#
$sel_date = explode("-",$global_vars['request'][0]);
$temp_html = "";
if (count($sel_date)==3)
if (checkdate($sel_date[1],$sel_date[0],$sel_date[2]))
$sel_date = mktime(5,0,0,$sel_date[1],$sel_date[0],$sel_date[2]);
else
$sel_date = mktime(5,0,0,date("m",TIME),date("d",TIME),date("Y",TIME));
else
$sel_date = mktime(5,0,0,date("m",TIME),date("d",TIME),date("Y",TIME));
$global_vars['blocks'] = skin_calendar($sel_date,$sel_date,"");
if(date("Y-m-d",$sel_date)==date("Y-m-d",TIME))
$cache_expire = 600;
elseif($sel_date<TIME)
$cache_expire = 604800;
else
$cache_expire = 3600;
if (cache_check(array('afisha',date("Y",$sel_date),date("m",$sel_date)),date("d",$sel_date).".html",$cache_expire))
$temp_html = cache_read(array('afisha',date("Y",$sel_date),date("m",$sel_date)),date("d",$sel_date).".html");
else {
$cur_date = date("Y-m-d H:i:s",$sel_date);
$actions_date = date("j",$sel_date)." ".skin_date_humanmon(date("m",$sel_date))." ".date("Y",$sel_date)." г.";
$result = query("SELECT `actions`.`type` FROM `shedule` LEFT JOIN `actions` ON `shedule`.`aid`=`actions`.`id` WHERE `shedule`.`datetime`>='".$cur_date."' AND `shedule`.`datetime`<DATE_ADD('".$cur_date."', INTERVAL 1 DAY) GROUP BY `actions`.`type` ORDER BY `actions`.`type`;");
while($data = mysql_fetch_array($result))
{
$result2 = query("SELECT `shedule`.`aid` FROM `shedule` LEFT JOIN `actions` ON `shedule`.`aid`=`actions`.`id` WHERE `shedule`.`datetime`>='".$cur_date."' AND `shedule`.`datetime`<DATE_ADD('".$cur_date."', INTERVAL 1 DAY) AND `actions`.`type`=".$data['type']." GROUP BY `shedule`.`aid` ORDER BY `shedule`.`aid` DESC");
$actions_type = mysql_fetch_array(query("SELECT `type_subtitle` FROM `firms_types` WHERE `id`=".$data['type'].";"));
$actions_type = $actions_type[0];
$afisha = array();
$i = 0;
$actions = "";
while($data2 = mysql_fetch_array($result2))
{
$afisha[$i] = array(0,"");
$result3 = query("SELECT `fid` FROM `shedule` WHERE `datetime`>='".$cur_date."' AND `datetime`<DATE_ADD('".$cur_date."', INTERVAL 1 DAY) AND `aid`=".$data2['aid']." GROUP BY `fid` ORDER BY `fid`,`datetime`");
$action_title = mysql_fetch_array(query("SELECT `actions`.*, `firms_types`.`human_subid`, `firms_types`.`human_id` FROM `actions` LEFT JOIN `firms_types` ON `firms_types`.`id`=`actions`.`type` WHERE `actions`.`id`=".$data2['aid']." LIMIT 1;"));
if ($action_title['type']==1)
{
$action_prime = mysql_fetch_array(query("SELECT COUNT(`id`) FROM `shedule` WHERE `aid`=".$data2['aid']." AND `datetime`<'".$cur_date."'"));
if ($action_prime[0]>0)
$action_prime = 0;
else
$action_prime = 1;
}
else
{
$action_prime = mysql_fetch_array(query("SELECT `is_prime` FROM `shedule` WHERE `aid`=".$data2['aid']." AND `shedule`.`datetime`>='".$cur_date."' AND `shedule`.`datetime`<DATE_ADD('".$cur_date."', INTERVAL 1 DAY);"));
$action_prime = $action_prime[0];
}
if($action_prime==1)
$afisha[$i][0] = $afisha[$i][0]+1000; // Премьерам +1000
$opinions_ratelist = array('','очень плохо','плохо','довольно плохо','удовлетворительно','весьма неплохо','нормально','весьма хорошо','хорошо','очень хорошо','отлично');
$action_opinions = mysql_fetch_array(query("SELECT COUNT(`id`) AS `count`, SUM(`rate`)/COUNT(`id`) AS `rating` FROM `opinions` WHERE `aid`=".$data2['aid'].";"));
$action_opinions_rating = round($action_opinions['rating']);
$action_opinions_num = $action_opinions['count'];
$afisha[$i][0] = $afisha[$i][0]+1*$action_opinions_num; // За каждое заведение 20 баллов
$action_producer = $action_title['producer'];
$action_actors = $action_title['actors'];
$action_genre = $action_title['genre'];
$action_url = "./".$action_title['human_id']."/".$action_title['human_subid']."/".$data2['aid']."/";
$action_title = $action_title['title'];
$action_img = "";
$image_files = get_images('images/b/actions/');
foreach ($image_files as $file) {
if (($file != ".") && ($file != "..") && strstr($file,$data2['aid']."_") && (substr($file,0,strpos($file,$data2['aid']."_"))==""))
{
$action_img = $file; break;
}
}
$firms = "";
while($data3 = mysql_fetch_array($result3))
{
$result4 = query("SELECT * FROM `shedule` WHERE `datetime`>='".$cur_date."' AND `datetime`<DATE_ADD('".$cur_date."', INTERVAL 1 DAY) AND `fid`=".$data3['fid']." AND `aid`=".$data2['aid']." ORDER BY `datetime`");
$firms_title = query("SELECT `firms`.`title`, `firms_types`.`human_id` FROM `firms` LEFT JOIN `firms_types` ON `firms`.`type`=`firms_types`.`id` WHERE `firms`.`id`=".$data3['fid'].";");
$firms_title = mysql_fetch_array($firms_title);
$firms_url = $firms_title[1]."/".$data3['fid']."/";
$firms_title = $firms_title[0];
$timetable_list = "";
while($data4 = mysql_fetch_array($result4))
{
$timetable_list .= substr($data4['datetime'],11,5).", ";
$afisha[$i][0] = $afisha[$i][0]+5; // За сеанс каждый 5 баллов
}
$timetable_list = substr($timetable_list,0,strlen($timetable_list)-2);
$afisha[$i][0] = $afisha[$i][0]+20; // За каждое заведение 30 баллов
$firms .= preg_replace("/{%(\w+)%}/ee", "$\\1",_html("afisha_row_firm.htm",0));
}
$action_rating = $afisha[$i][0];
$actions_row = preg_replace("/{%(\w+)%}/ee", "$\\1",_html("afisha_row.htm",0));
if ($action_img=='')
$actions_row = preg_replace("'<!-- img -->.*?<!-- /img -->'si","",$actions_row);
if ($action_actors=='')
$actions_row = preg_replace("'<!-- actors -->.*?<!-- /actors -->'si","",$actions_row);
if ($action_producer=='')
$actions_row = preg_replace("'<!-- producer -->.*?<!-- /producer -->'si","",$actions_row);
if ($action_genre=='')
$actions_row = preg_replace("'<!-- genre -->.*?<!-- /genre -->'si","",$actions_row);
if ($action_prime==0)
$actions_row = preg_replace("'<!-- prime -->.*?<!-- /prime -->'si","",$actions_row);
if ($action_opinions_num==0)
$actions_row = preg_replace("'<!-- opinions -->.*?<!-- /opinions -->'si","нет.",$actions_row);
$actions_row = preg_replace("'<!--.*?-->'si","",$actions_row);
$afisha[$i][1] = $actions_row;
//$actions .= $actions_row;
$i++;
}
$i=1;
while($i<sizeof($afisha)) {
if($afisha[$i][0]>$afisha[$i-1][0]) {
$tmp = $afisha[$i-1];
$afisha[$i-1] = $afisha[$i];
$afisha[$i] = $tmp;
$i=1;
}
else
$i++;
}
foreach($afisha as $afisha_row) {
$actions .= $afisha_row[1];
}
$temp_html .= preg_replace("/{%(\w+)%}/ee", "$\\1",_html("afisha_type.htm",0));
}
if (mysql_num_rows($result)==0)
$temp_html = preg_replace("/{%(\w+)%}/ee", "$\\1",_html("afisha_none.htm",0));
cache_write(array('afisha',date("Y",$sel_date),date("m",$sel_date)),date("d",$sel_date).".html",$temp_html);
}
//if(!cache_check(array('afisha',date("Y",$sel_date),date("m",$sel_date)),date("d",$sel_date).".html"))
// cache_write(array('afisha',date("Y",$sel_date),date("m",$sel_date)),date("d",$sel_date).".html",$temp_html);
_html_design($temp_html);
?>