#include <infodrom.style>
#include "calendar.inc"

<page func="Infodrom Oldenburg" title="Events">

<?

  $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
	       or die("Unable to connect to SQL server");

  pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");

  $query = "SELECT $event_cols FROM events WHERE start+delta < 'now' ORDER BY start,name";

  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  $color = "<coln>";
  for ($i=0; $i < pg_NumRows ($sth); $i++) {
    $row = pg_fetch_array ($sth, $i);

    $date = explode (" ", $row['start']);
    $date = explode ("-", $date[0]);
    $end = explode (" ", $row[3]);
    $end = explode ("-", $end[0]);
    $thisyear = $date[0];

    $date = format_date ($date, $end);

    if ($thisyear != $year) {
      if ($year > 0) {
        echo ($event_table_end);
      }
      $color = "<coln>";
      printf ("<h3 class=\"bar\">Past events in %s</h3>", $thisyear);
      echo ($event_table_start);
      $year = $thisyear;
    }

    $row['name'] = ereg_replace (" ", "&nbsp;", $row['name']);
    $row['city'] = ereg_replace (" ", "&nbsp;", $row['city']);
    $row['country'] = ereg_replace (" ", "&nbsp;", $row['country']);

    $color = $color == "<cold>"?"<coln>" : "<cold>";
    printf ($event_row, $color, $row['oid'], $row['name'], $row['cancelled'] == 1?" *cancelled*":"",
	    $row['city'], $row['country'], $date);
  }
  echo ($event_table_end);
?>

</page>

# Local variables:
# mode: text
# mode: auto-fill
# end: