define(array('main_content'=>"main/see.tpl")); //$tpl->define(array('where_short_row'=>"rows/where_short_row.tpl"); require_once("common.php"); require_once("functions.php"); ///////////////////////////////////////////////////////////////////////////// function SendInfo(){ $day=date('w'); // $day1=1; // $day2=4; $day1=1; $day2=4; $cur_date=date("YmdHis"); $daysA=array($day1=>'2,3,4',$day2=>'5,6,0,1'); if($day==$day1||$day==$day2){ global $HTTP_GET_VARS; $query="select subscr_oid ,sendinfo from t_subscr where active=1"; $result=mysql_query($query); if(!$result) my_error(mysql_error()); $num=mysql_num_rows($result); if($num){ while($row=mysql_fetch_array($result)){ if(empty($row[sendinfo]))$row[sendinfo]='imprezy'; show($row[sendinfo]); $inforA=array("Repertuar kin"=>"seanse","Repertuar teatrów"=>"spektakle","Koncerty"=>"koncerty","Wystawy"=>"wystawy","Imprezy"=>"imprezy","Festiwale"=>"festiwale","Wizytówki firm"=>"wizytowki"); $event_typeA=array("seanse"=>588,"spektakle"=>401,"koncerty"=>229,"wystawy"=>246,"imprezy"=>244,"festiwale"=>226); $sendInfoA=explode(',',$row[sendinfo]); $event_what_sqlA=array(588,401); foreach($sendInfoA as $name){ if(in_array($name,$inforA)){ if($name=='wizytowki'){ $event_type='wiz'; break 1; }else{ $event_type=$event_typeA[$name]; } //-------------- if(in_array($event_type,$event_what_sqlA)){ $SELECT=" CASE WHEN t_event.event_pl_name='' THEN what_pl_name ELSE event_pl_name END as event_pl_name "; $FROM=" t_event LEFT OUTER JOIN t_event_what ON t_event_what.event_oid=t_event.event_oid LEFT OUTER JOIN t_what ON t_what.what_oid=t_event_what.what_oid "; }else{ $SELECT=" t_event.event_pl_name "; $FROM="t_event"; } $WHERE=" d_begin>='$date' and '$date'<=d_end and t_event.web_oid=6 "; $event_query=" SELECT distinct $SELECT ,date_format(d_begin,'Ymd') as day ,t_event.event_oid ,d_begin ,d_end ,unix_timestamp(t_event.d_begin) as begin ,unix_timestamp(t_event.d_end) as end FROM $FROM WHERE $WHERE and t_event.event_type=$event_type GROUP BY day ORDER BY t_event.important,t_event.d_begin LIMIT 0,10 "; show($event_query); $event_results=mysql_query($event_query,$GLOBALS[dbh]); $num=mysql_num_rows($event_results); if(!$event_results) my_error("Nie udało się wykonać zapytania(EVENTS3) (".mysql_error().")"); $OUT.=''; //else $PODKATALOG.=''; } $OUT.='

'; while($row=mysql_fetch_array($event_results)){ //$OUT.= //echo " $row[event_oid],$row[event_pl_name],".FormatPeriod($row[begin],$row[end])." "; //if($event_type==588) $PODKATALOG.='
	'.$event_row[event_pl_name].'	'.date("d.m",$event_row[d_begin]).'
	'.$event_row[event_pl_name].'	'.date("d.m",$event_row[d_begin]).'

'; //exit; //-------------- $HTTP_GET_VARS[etype]=$event_type //$HTTP_GET_VARS[begin]=date("Ym25"); //$HTTP_GET_VARS[end]=date("Ym25"); include("seanse.inc"); $cont.=$T_document.'

'; //-------------- //show(' - '.$name.'='.$etype); } } } //echo $OUT; } } //show('actives='.$num.', day_nr='.date('w')); } //SendInfo(); // //$event_type_id=588; // //$HTTP_GET_VARS[begin]=date("Ym25"); // //$HTTP_GET_VARS[end]=date("Ym25"); // require_once("seanse.inc"); // $cont=$T_document; ///////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////// $tpl->assign('ROWS',''.$cont.''); ///////////////////////////////////////////////////////////////////////////// $title='Subskrypcja'; $head=$title; //******************* VARIABLES ASSIGNMENT ********************************** $tpl->assign('ONLOAD',$ONLOAD); $tpl->assign("TITLE",$title); $tpl->assign("HEAD",$head); $tpl->assign('BR_OR',$br_or); $tpl->assign('HEADER',$header); $tpl->assign('FOOTER',$footer); //******************* TEMPLATES PARSING ********************************** $tpl->parse('MAIN_CONTENT',"main_content"); //$tpl->assign('MAIN_CONTENT',"main_content"); require ("common_templates_parse.php"); //************ common footer ********************** require ("common_footer.php"); //(case ((d_end>=now())and(to_days(d_begin)-to_days(d_end))>0 then (d_begin>=now())) else () end) ?>