getTableData();
$sql = "SELECT * FROM ".$tabledata[eventstable]." WHERE ".$tabledata[field_IdCalendar]."=".$_GET["id"];
$objTbd->connectAndExec($sql);
while ($objTbd->nextRecordWithTitles()) {
echo "
";
echo "
".$objTbd->fieldName($tabledata[field_Title])."
";
if (($objTbd->fieldName($tabledata[field_EndDate])!=0) && ($objTbd->fieldName($tabledata[field_EndDate]) != $objTbd->fieldName($tabledata[field_BeginDate]))) $ladate="From ".changedate_to_normal($objTbd->fieldName($tabledata[field_BeginDate]))." to ".changedate_to_normal($objTbd->fieldName($tabledata[field_EndDate]));
else $ladate=changedate_to_normal($objTbd->fieldName($tabledata[field_BeginDate]));
echo "
".$ladate;
if ((strlen($objTbd->fieldName($tabledata[field_Hour]))>0) && ($objTbd->fieldName($tabledata[field_Hour])>0))
echo "
".substr($objTbd->fieldName($tabledata[field_Hour]),0,5);
if ((strlen($objTbd->fieldName($tabledata[field_EndHour]))>0) && ($objTbd->fieldName($tabledata[field_EndHour])>0))
echo "-".substr($objTbd->fieldName($tabledata[field_EndHour]),0,5);
echo "
";
echo "
".$objTbd->fieldName($tabledata[field_Content])."
";
echo "
";
}
echo "
Back to description page";
$objTbd->disconnect();
}
//NEW CODE NEW CODE NEW CODE NEW CODE NEW CODE NEW CODE NEW CODE NEW CODE NEW CODE NEW CODE NEW CODE
else if (isset($_GET["month"])){
function changedate_to_normal2($date){
ereg( "([0-9]{2,4})-([0-9]{1,2})-([0-9]{1,2})", $date, $midate);
$ladate=strftime("%d-%m-%Y",strtotime($midate[2]."/".$midate[3]."/".$midate[1]));
return $ladate;
}
require_once("TBD.php");
$objTbd= new Tbd();
$tabledata=$objTbd->getTableData();
$elyear=$_GET["year"];
$elmonth=($_GET["month"]<10) ? "0".$_GET["month"] : $_GET["month"];
$ladatein=$elyear."-".$elmonth."-01";
$elmonth=$_GET["month"]+1;
if ($elmonth==13) { $elmonth=1; $elyear++; }
$elmonth=($elmonth<10) ? "0".$elmonth : $elmonth;
$ladatefi=$elyear."-".$elmonth."-01";
$sql = "SELECT ".$tabledata[field_Title].",".$tabledata[field_IdCalendar].",".$tabledata[field_BeginDate].",".$tabledata[field_EndDate]." FROM ".$tabledata[eventstable]." WHERE ";
$sql.= "(((".$tabledata[field_BeginDate]." >= '".$ladatein."') AND (".$tabledata[field_BeginDate]." < '".$ladatefi."'))";
$sql.= " OR ((".$tabledata[field_BeginDate]." < '".$ladatein."') AND (".$tabledata[field_EndDate]." >= '".$ladatein."') AND (".$tabledata[field_EndDate]." IS NOT NULL) AND (".$tabledata[field_EndDate]." <> 0)))";
$sql.= " ORDER BY ".$tabledata[field_BeginDate]." desc";
$objTbd->connectAndExec($sql);
echo "
";
echo "
";
echo "
Events for ".strftime("%B, %Y",strtotime($_GET["month"]."/01/".$_GET["year"]))."
";
$contador=0;
while ($objTbd->nextRecordWithTitles()) {
echo "
";
if (($objTbd->fieldName($tabledata[field_EndDate])!=0) && ($objTbd->fieldName($tabledata[field_EndDate]) != $objTbd->fieldName($tabledata[field_BeginDate]))) $ladate="From ".changedate_to_normal2($objTbd->fieldName($tabledata[field_BeginDate]))." to ".changedate_to_normal2($objTbd->fieldName($tabledata[field_EndDate]));
else $ladate=changedate_to_normal2($objTbd->fieldName($tabledata[field_BeginDate]));
echo $ladate.":
".$objTbd->fieldName($tabledata[field_Title])."";
$contador++;
}
echo "
";
if ($contador==0) echo "There's no events to show
";
else echo "
Print this list";
echo "
";
echo "
Back to description page";
$objTbd->disconnect();
}
//END NEW CODE END NEW CODE END NEW CODE END NEW CODE END NEW CODE END NEW CODE END NEW CODE
else { ?>
