1 # Important tools for our events calendar
6 # light yellow for underlying currently happening events
8 $event_cols = "name,start,start+delta,city,country,conference,exhibition,url,deburl,localurl";
10 $event_table_start = '<center><table class="blackborder smallfont" cellpadding=1 cellspacing=0 width=100%>'
13 .'<th align=left>Name</th>'
14 .'<th align=left>City</th>'
15 .'<th align=left>Country</th>'
19 $event_table_end = '</table></center>';
21 $event_trow = '<tr class="t%d">'
26 .'<td align="center">%s</td>'
27 .'<td align="center">%s</td>'
30 $event_month = array ("","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
32 # Return a properly formatted name, maybe with a link
33 # Only Debian gets localurl and deburl if available
35 function encode_name ($row, $type)
37 if ($type == "debian") {
38 if ($row['localurl']) {
39 $name = sprintf ("<a href=\"%s\">%s</a>", $row['localurl'], $row['name']);
40 } elseif ($row['deburl']) {
41 $name = sprintf ("<a href=\"%s\">%s</a>", $row['deburl'], $row['name']);
42 } elseif ($row['url']) {
43 $name = sprintf ("<a href=\"%s\">%s</a>", $row['url'], $row['name']);
47 } elseif ($type == "infodrom") {
49 $name = sprintf ("<a href=\"%s\">%s</a>", $row['url'], $row['name']);
59 # Properly decode start time and duration of an event
61 function format_date ($date, $end)
65 $mi = sprintf ("%d", $date[1]);
66 if ($date[1] == $end[1]) {
67 if ($date[2] == $end[2]) {
68 $date = sprintf ("%s %d", $event_month[$mi], $date[2]);
70 $date = sprintf ("%s %d-%d", $event_month[$mi], $date[2], $end[2]);
73 $mii = sprintf ("%d", $end[1]);
74 $date = sprintf ("%s %d-%s %d", $event_month[$mi], $date[2], $event_month[$mii], $end[2]);
79 # Connect to the database and return the handler
81 function event_connect ()
83 $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
84 or die("Unable to connect to SQL server");
86 pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");