File: /var/www/ilya/data/www/afish-ka.ru/admin/modules/afisha/delete.inc
<?
//- Настройки модуля -----------------------------------------------------------
permission("mcp"); // tcp-техники; acp-админы; mcp-модеры; cp-рядовые участники
$skin_pname = "Удаление расписания";
$temp_html = "";
//------------------------------------------------------------------------------
if(isset($_POST['begin_day'])) {
if (checkdate($_POST['begin_mon'],$_POST['begin_day'],$_POST['begin_year']) && checkdate($_POST['end_mon'],$_POST['end_day'],$_POST['end_year']) && ($_POST['begin_hour']>=0 && $_POST['begin_hour']<=23 && $_POST['begin_min']>=0 && $_POST['begin_min']<=59 && $_POST['end_hour']>=0 && $_POST['end_hour']<=23 && $_POST['end_min']>=0 && $_POST['end_min']<=59)) {
if(mktime($_POST['begin_hour'],$_POST['begin_min'],0,$_POST['begin_mon'],$_POST['begin_day'],$_POST['begin_year']) >= mktime($_POST['end_hour'],$_POST['end_min'],0,$_POST['end_mon'],$_POST['end_day'],$_POST['end_year'])) {
$temp_html .= "<p>Начало временного отрезка меньше или равно концу.</p>\n";
}
else {
$begin_mark = mktime($_POST['begin_hour'],$_POST['begin_min'],0,$_POST['begin_mon'],$_POST['begin_day'],$_POST['begin_year']);
$end_mark = mktime($_POST['begin_hour'],$_POST['begin_min'],0,$_POST['end_mon'],$_POST['end_day'],$_POST['end_year']);
$current_mark = $begin_mark;
while($current_mark<=$end_mark) {
cache_delete(array("afisha",date("Y",$current_mark),date("m",$current_mark)),date("d",$current_mark).".html");
$current_mark += 86400;
}
query("DELETE FROM `shedule` WHERE `fid`='".$_POST['firm']."' AND `datetime`>='".$_POST['begin_year']."-".$_POST['begin_mon']."-".$_POST['begin_day']." ".$_POST['begin_hour'].":".$_POST['begin_min']."' AND `datetime`<='".$_POST['end_year']."-".$_POST['end_mon']."-".$_POST['end_day']." ".$_POST['end_hour'].":".$_POST['end_min']."';");
$temp_html .= "<p>Удалено <b>".mysqli_affected_rows($global_vars['db_connection'])."</b> записи(-ей).</p>\n";
cache_delete(array("system"),"anons.html");
cache_delete(array("afisha_firms"),$firm.".html");
}
$temp_html .= "<hr>\n";
}
}
$result = query("SELECT * FROM `firms` ORDER BY `title`;");
$firms = "";
$i = 0;
while($data = mysql_fetch_array($result)) {
if ($i==0) {
$firms .= "<option value=\"".$data['id']."\" selected>".$data['title']."\n";
}
else {
$firms .= "<option value=\"".$data['id']."\">".$data['title']."\n";
}
$i++;
}
if(!isset($_POST['begin_hour'])) {
$begin_date = skin_date_select(date("Y"),date("m",TIME),date("d",TIME),"begin_year","begin_mon","begin_day");
$end_date = skin_date_select(date("Y",TIME+86400),date("m",TIME+86400),date("d",TIME+86400),"end_year","end_mon","end_day");
$begin_time = skin_time_select(6,0,"begin_hour","begin_min");
$end_time = skin_time_select(5,0,"end_hour","end_min");
}
else {
$begin_date = skin_date_select($_POST['begin_year'],$_POST['begin_mon'],$_POST['begin_day'],"begin_year","begin_mon","begin_day");
$end_date = skin_date_select($_POST['end_year'],$_POST['end_mon'],$_POST['end_day'],"end_year","end_mon","end_day");
$begin_time = skin_time_select($_POST['begin_hour'],$_POST['begin_min'],"begin_hour","begin_min");
$end_time = skin_time_select($_POST['end_hour'],$_POST['end_min'],"end_hour","end_min");
}
$temp_html .= preg_replace("/{%(\w+)%}/ee", "$\\1",skin_html("afisha_delete.htm",0));
skin_html_design($temp_html);
?>