diff options
author | Philip Häusler <msquare@notrademark.de> | 2011-06-13 18:05:51 +0200 |
---|---|---|
committer | Philip Häusler <msquare@notrademark.de> | 2011-06-13 18:05:51 +0200 |
commit | 04973d1fa148381978b1251d10118e6bab86f435 (patch) | |
tree | 39f5a304342054e9da8c0452866b4f6eb69f87af /www-ssl_old/nonpublic/myschichtplan_ical.php | |
parent | 89fd736f36dc89becacc30dc250d7a3e93e9569f (diff) |
moved public files to public, old and yet untouched files to directories ending with _old
Diffstat (limited to 'www-ssl_old/nonpublic/myschichtplan_ical.php')
-rw-r--r-- | www-ssl_old/nonpublic/myschichtplan_ical.php | 51 |
1 files changed, 51 insertions, 0 deletions
diff --git a/www-ssl_old/nonpublic/myschichtplan_ical.php b/www-ssl_old/nonpublic/myschichtplan_ical.php new file mode 100644 index 00000000..ff74fef0 --- /dev/null +++ b/www-ssl_old/nonpublic/myschichtplan_ical.php @@ -0,0 +1,51 @@ +<?php +require_once ('../bootstrap.php'); + +include ("includes/header_start.php"); + +include ("includes/funktion_schichtplan_aray.php"); + +$SQL = "SELECT *, `ShiftEntry`.`Comment`, `ShiftEntry`.`TID` FROM `Shifts` " . +"INNER JOIN `ShiftEntry` " . +"ON `Shifts`.`SID`=`ShiftEntry`.`SID` " . +"WHERE `ShiftEntry`.`UID`='" . $_SESSION['UID'] . "' " . +"ORDER BY `DateS`"; +$erg = mysql_query($SQL, $con); + +//HEADER +header("Content-Type: text/x-vCalendar"); +header("Content-Disposition: attachment; filename=\"Schichtplan.ics\""); + +//DATA +echo "BEGIN:VCALENDAR\n"; +echo "PRODID:-//Engelsystem//DE-EN\n"; +echo "VERSION:2.0\n"; +echo "PRODID:" . md5('icalschichtplan:' . $_SESSION['UID']) . "\n"; +echo "METHOD:PUBLISH\n"; +echo "CALSCALE:GREGORIAN\n"; +echo "METHOD:PUBLISH\n"; +echo "X-WR-CALNAME;VALUE=TEXT:" . "Himmel - Schichtplan\n"; + +for ($i = 0; $i < mysql_num_rows($erg); $i++) { + echo "BEGIN:VEVENT\n"; + echo "UID:" . md5(mysql_result($erg, $i, "Man") . mysql_result($erg, $i, "DateS")) . "\n"; + echo "METHOD:PUBLISH\n"; + echo "DTSTART;TZID=Europe/Berlin:" . date('Ymd\THis', strtotime(mysql_result($erg, $i, "DateS"))) . "\n"; + echo "DTEND;TZID=Europe/Berlin:" . date('Ymd\THis', strtotime(mysql_result($erg, $i, "DateE"))) . "\n"; + echo "SUMMARY:" . str_replace(',', '\\,', mysql_result($erg, $i, "Man")) . "\n"; + echo "CLASS:PUBLIC\n"; + echo "STATUS:CONFIRMED\n"; + echo "URL:" . $url . $ENGEL_ROOT . "nonpublic/myschichtplan.php\n"; + echo "LOCATION:" . $RoomID[mysql_result($erg, $i, "RID")] . "\n"; + echo "BEGIN:VALARM\n"; + echo "TRIGGER;VALUE=DURATION:-PT5M\n"; + echo "DESCRIPTION:" . str_replace(',', '\\,', mysql_result($erg, $i, "Man")) . "\n"; + echo "ACTION:DISPLAY\n"; + echo "END:VALARM\n"; + echo "END:VEVENT\n"; +} +echo "END:VCALENDAR\n"; + +include ("includes/funktion_counter.php"); +?> + |