setScriptName($PHP_SELF);
$rubric_class->setRubric();
// echo "
?????????????????????";
$strdate=$ry."-".$rm."-".$rd;
$query_str="SELECT *, DATE_FORMAT(gr_date,'%Y-%m-%d') as date FROM greetings,greeting_paragraphs WHERE gr_id=gp_gr_id";
$query_str.=" and DATE_FORMAT(gr_date,'%Y-%m-%d')<='".$strdate."'";
$query_str.=" and DATE_FORMAT(gr_date_end,'%Y-%m-%d')>='".$strdate."'";
$query_str.=" order by gr_sort desc, gp_sort asc";
// $query_str.=" order by gr_sort desc, gp_sort asc";
// echo "
?????????????????????".$query_str;
$query1->setQueryText($query_str);
/* */
$result1=$query1->execQuery();
// echo "
????????????????????? == ".$connection1->CountTuples($result1);
$k=0;
//echo "
????????????????????".$query_str;
if ($connection1->CountTuples($result1)>0)
{
// echo "
????????????????????? == ".$connection1->CountTuples($result1);
for ($i=0;$i<$connection1->CountTuples($result1);$i++)
{
$grts=$connection1->fetchRow($result1,$i);
$out[$i]=$grts;
if ($grts[gp_file]!=NULL&&file_exists($grt_path.$grts[gp_file]))
{
if (substr(strrchr($grts[gp_file],"."),1)!='swf') {
$out[$i]['img']=$grt_path.$grts[gp_file];
$size=getZoomSizeImg($grt_path.$grts[gp_file],$GallerySetting['DefaultWidth']);
$out[$i]['width']=$size['width'];
$out[$i]['height']=$size['height'];
} else {
$out[$i]['flash']=$grts[gp_code];
}
} else {
$out[$i]['img']=false;
}
$out[$i][header]=false;
// if ($out[$i][gr_id]!=$mem_gr_id)
if ($grts[gp_header]!="")
{
// $out[$i][header]=$grts[gr_header];
$out[$i][header]=$grts[gp_header];
$mem_gr_id=$grts[gr_id];
}
}
}
$value['greetings']=$out;
$value['title']=$title;
$value['IncludePath']=$IncludePath;
$value['rubric']=$rubric;
exttemplate_printfile($IncludePath.$SitesSetting['Tpl'].$tpl,$value);
// require('func_include_down.php');
require('main_down_calendar.php');
?>