";
}
$tablespace = 0;
$alternate = "2";
include ("include/guess.inc.php");
function Birthday2vCal($date, $age) {
global $id, $firstname, $middlename, $lastname, $email, $email2, $email3, $home, $mobile, $work, $byear;
echo "BEGIN:VEVENT\r\n";
echo "UID:".date('Y', $date).$id."@php-addressbook.sourceforge.net\r\n";
echo "DTSTART;VALUE=DATE:".date("Ymd", $date)."\r\n";
echo "DTEND;VALUE=DATE:".date("Ymd", $date+(24*3600))."\r\n";
echo "DTSTAMP:".date("Ymd\THi00\Z")."\r\n";
echo "CREATED:".date("Ymd\THi00\Z")."\r\n";
echo "LAST-MODIFIED:".date("Ymd\THi00\Z")."\r\n";
echo "LOCATION:\r\n";
echo "STATUS:CONFIRMED\r\n";
if($age == -1) {
$age = "";
} else {
$age = "(".$age.")";
}
echo "SUMMARY:".ucfmsg("BIRTHDAY")." ".trim($firstname.(isset($middlename) ? " ".$middlename:"")." ".$lastname)
." ".$age."\r\n";
echo "DESCRIPTION:Mail:\\n- ".$email
."\\n- ".$email2
."\\n- ".$email3
."\\n\\n".ucfmsg("TELEPHONE")
.($home != "" ? "\\n- ".$home : "")
.($mobile != "" ? "\\n- ".$mobile : "")
.($work != "" ? "\\n- ".$work : "")
."\r\n";
echo "CLASS:PRIVATE\r\n";
echo "END:VEVENT\r\n";
}
$lastmonth = '';
$sql="
SELECT DISTINCT $table.*, $month_lookup.* ,
IF ($month_lookup.bmonth_num < MONTH( CURDATE( ) )
OR $month_lookup.bmonth_num = MONTH( CURDATE( ) )
AND $table.bday < DAYOFMONTH( CURDATE( ) ) , CONCAT( ' ', YEAR( CURDATE( ) ) +1 ) , ''
) display_year,
IF (
$month_lookup.bmonth_num < MONTH( CURDATE( ) )
OR $month_lookup.bmonth_num = MONTH( CURDATE( ) )
AND $table.bday < DAYOFMONTH( CURDATE( ) ) , $month_lookup.bmonth_num+12, $month_lookup.bmonth_num
)*32+bday prio
FROM $month_lookup,
$base_from_where AND $table.bmonth = $month_lookup.bmonth AND $table.bday > 0
ORDER BY prio ASC;";
$result = mysqli_query($db,$sql);
$resultsnumber = mysqli_num_rows($result);
while ($myrow = mysqli_fetch_array($result))
{
$firstname = $myrow["firstname"];
$id = $myrow["id"];
$lastname = $myrow["lastname"];
$middlename = $myrow["middlename"];
$email = ($myrow["email"] != "" ? $myrow["email"] : ($myrow["email2"] != "" ? $myrow["email2"] : ""));
$email2 = $myrow["email2"];
$home = $myrow["home"];
$mobile = $myrow["mobile"];
$work = $myrow["work"];
$homepage = $myrow["homepage"];
// Phone order home->mobile->work
$phone = ($myrow["home"] != "" ? $myrow["home"]
: ($myrow["mobile"] != "" ? $myrow["mobile"]
: $myrow["work"]));
$phone = str_replace("'", "",
str_replace('/', "",
str_replace(" ", "",
str_replace(".", "", $phone))));
$bday = $myrow["bday"];
$bmonth = $myrow["bmonth"];
$bmonth_num = $myrow["bmonth_num"];
$byear = $myrow["byear"];
$display_year = $myrow["display_year"];
// Current year
$addr = new Address($myrow);
if($use_ics) {
// Last year
//* -- commented to reduce traffic
$date = gmmktime(0,0,0,$bmonth_num,$bday,date('Y')-1,0);
Birthday2vCal($date, $addr->getBirthday()->getAge());
//*/
$date = gmmktime(0,0,0,$bmonth_num,$bday,date('Y'),0);
Birthday2vCal($date, $addr->getBirthday()->getAge(1));
// Next year
$date = gmmktime(0,0,0,$bmonth_num,$bday,date('Y')+1);
Birthday2vCal($date, $addr->getBirthday()->getAge(2));
} else {
if($lastmonth != $bmonth) {
$lastmonth = $bmonth;
if ($tablespace >=1) {
echo "
|
";
} else {}
echo "".ucfmsg(strtoupper($myrow["bmonth"])).$myrow["display_year"]." |
";
$alternate = "0";
}
if ($alternate == "1") {
$color = "even";
$alternate = "2";
} else {
$color = "odd";
$alternate = "1";
}
echo "";
echo "$bday. | ";
if (!empty($middlename)) {
echo "$middlename $lastname | ";
} else {
echo "$lastname | ";
}
echo "$firstname | ";
$age = $addr->getBirthday()->getAge(1);
echo "$age | ";
echo "$email | ";
echo "$phone | ";
echo " | ";
if(! $read_only)
echo " | ";
echo " | ";
if( substr($phone, 0, 1) == "0" || substr($phone, 0, 3) == "+41")
{
$country = "Switzerland";
}
else $country = "";
if($map_guess) {
if($myrow["address"] != "")
echo "
| ";
else echo " | ";
}
if($homepage != "") {
$homepage = (strcasecmp(substr($homepage, 0, strlen("http")),"http")== 0
? $homepage
: "http://".$homepage);
echo " | ";
} elseif(($homepage = guessHomepage($email, $email2)) != "") {
echo " | ";
} else {
echo " | ";
}
echo "
\n";
$tablespace++;
}
}
if($use_ics) {
echo "END:VCALENDAR\r\n";
} else {
echo "";
include ("include/footer.inc.php");
}
?>