<?php
  include '../lib/common.php';
  include '../lib/db.php';
  
  define('CRLF', "\r\n");
  
  // retrieve all events
  $query\; =\; sprintf(\text{'}SELECT\; EVENT\_NAME,\; UNIX\_TIMESTAMP(EVENT\_TSTAMP)\; AS\; \text{'}\; .\; \text{'}EVENT\_TSTAMP,\; NOTIFY\; FROM$\%sCALENDAR ORDER BY EVENT_TSTAMP ASC, ' . 
      'EVENT_NAME ASC',
      DB_TBL_PREFIX);
  result = mysql_query($query,$GLOBALS['DB']);
  
  // generate iCalendar
  ob_start();
  echo 'BEGIN:VCALENDAR' . CRLF;
  echo 'PRODID:-//Wrox//PHP Reuse//EN' . CRLF;
  echo 'VERSION:2.0' . CRLF;
  
  while ($row\; =\; mysql\_fetch\_assoc($result))
  {
      echo 'BEGIN:VEVENT' . CRLF;
      echo 'DTSTART:' . date('Ymd\THis', $row[\text{'}EVENT\_TSTAMP\text{'}])\; .\; CRLF;\; echo\; \text{'}DTEND:\text{'}\; .\; date(\text{'}Ymd\backslash THis\text{'},\; strtotime(\text{'}+30\; minutes\text{'},$row['EVENT_TSTAMP'])) . CRLF;
      echo 'SUMMARY:' . htmlspecialchars($row[\text{'}EVENT\_NAME\text{'}])\; .\; CRLF;\; if\; ($row['NOTIFY'])
      {
          echo 'BEGIN:VALARM' . CRLF;
          echo 'ACTION:DISPLAY' . CRLF;
          echo 'SUMMARY:' . date('m/d/Y H:i A - ', $row[\text{'}EVENT\_TSTAMP\text{'}])\; .\; htmlspecialchars($row['EVENT_NAME']) . CRLF;
          echo 'TRIGGER:-PT60M' . CRLF;
          echo 'END:VALARM' . CRLF;
      }
      echo 'END:VEVENT' . CRLF;
  }
  mysql_free_result($result);\; echo\; \text{'}END:VCALENDAR\text{'}\; .\; CRLF;$ics = ob_get_clean();
  // send iCalendar file to browser
  header('Content-Type: text/calendar');
  header('Content-Disposition: attachment; filename="export.ics";');
  header('Content-Transfer-Encoding: binary');
  header('Content-Length: ' . strlen($ics));\; echo$ics;
  
  mysql_close($GLOBALS[\text{'}DB\text{'}]);\; ?>$