# Important tools for our events calendar

#include <db.style>

<?
  # light yellow for underlying currently happening events
  #
  $nowcolor = "fffec9";
  $event_cols = "name,start,start+delta,city,country,conference,exhibition,url,deburl,localurl";

  $event_table_start = '<center><table border=0 cellpadding=2 cellspacing=0 width=100%>'
	        .'<tr bgcolor="<colh>">'
		.'<th><ifont>Date</ifont></th>'
		.'<th align=left><ifont>Name</ifont></th>'
		.'<th align=left><ifont>City</ifont></th>'
		.'<th align=left><ifont>Country</ifont></th>'
		.'<th><ifont>Conf</ifont></th>'
		.'<th><ifont>Exhib</ifont></th>'
		.'</tr>';
  $event_table_end = '</table></center>';

  $event_trow = '<tr bgcolor="%s">'
	 .'<td><ifont><font size="-1">%s</font></ifont></td>'
	 .'<td><ifont><font size="-1">%s</font></ifont></td>'
	 .'<td><ifont><font size="-1">%s</font></ifont></td>'
	 .'<td><ifont><font size="-1">%s</font></ifont></td>'
	 .'<td align="center"><ifont><font size="-1">%s</font></ifont></td>'
	 .'<td align="center"><ifont><font size="-1">%s</font></ifont></td>'
	 .'</tr>';

  $event_border_start = '<p><div align=right>'
		 .'<table width=99% border=0 cellpadding=0 cellspacing=0><tr bgcolor=#000000><td>'
		 .'<table width=100% border=0 cellpadding=0 cellspacing=1><tr bgcolor=#<bgcolor>><td>';
  $event_border_end   = '</td></tr></table></td></tr></table></div></p>';

  $event_month = array ("","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");

  # Return a properly formatted name, maybe with a link
  #        Only Debian gets localurl and deburl if available
  #
  function encode_name ($row, $type)
  {
    if ($type == "debian") {
      if ($row['localurl']) {
	$name = sprintf ("<a href="\"%s\"">%s</a>", $row['localurl'], $row['name']);
      } elseif ($row['deburl']) {
	$name = sprintf ("<a href="\"%s\"">%s</a>", $row['deburl'], $row['name']);
      } elseif ($row['url']) {
	$name = sprintf ("<a href="\"%s\"">%s</a>", $row['url'], $row['name']);
      } else {
	$name = $row['name'];
      }
    } elseif ($type == "infodrom") {
      if ($row['url']) {
	$name = sprintf ("<a href="\"%s\"">%s</a>", $row['url'], $row['name']);
      } else {
	$name = $row['name'];
      }
    } else {
      return $row['name'];
    }
    return $name;
  }

  # Properly decode start time and duration of an event
  #
  function format_date ($date, $end)
  {
    global $event_month;

    $mi = sprintf ("%d", $date[1]);
    if ($date[1] == $end[1]) {
      if ($date[2] == $end[2]) {
        $date = sprintf ("%s&nbsp;%d", $event_month[$mi], $date[2]);
      } else {
        $date = sprintf ("%s&nbsp;%d-%d", $event_month[$mi], $date[2], $end[2]);
      }
    } else {
      $mii = sprintf ("%d", $end[1]);
      $date = sprintf ("%s&nbsp;%d-%s&nbsp;%d", $event_month[$mi], $date[2], $event_month[$mii], $end[2]);
    }
    return $date;
  }

  # Connect to the database and return the handler
  #
  function event_connect ()
  {
    $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
	   or die("Unable to connect to SQL server");

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

    return $dbh;
  }

?>

# Local variables:
# mode: html
# mode: auto-fill
# mode: iso-accents
# end: