#include <infodrom.style>
#include "lt.style"
#include "functions.inc"

<postgresconnect>
<spokendate>

<ltpage title="Project Management -- Projects">

<h3>Projects</h3>

<p>These projects have applied for a booth at the upcoming
LinuxTag exhibition and conference.
The public list is <a href="http://www.infodrom.org/Debian/events/LinuxTag2005/projects">here</a>.</p>

<p>
<?
  $query  = "SELECT name "
	  . "FROM project,appendix "
	  . "WHERE project = name "
	  . "AND ( description <> '' OR description_en <> '' ) "
	  . "AND project IN "
	      ."(SELECT DISTINCT project FROM junction "
	          . "WHERE project <> 'Sleeper' AND project <> 'Supporter' AND project <> 'Speaker') "
	   ."ORDER BY upper(name)";

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

  if (pg_NumRows ($sth) > 0) {
    echo ("<ol>");
    for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
      $row = pg_fetch_array ($sth, $nr);

      printf ("<li><a href=\"index.php3?project=%s\">%s</a>", urlencode($row['name']), $row['name']);
    }
    if (is_also_supporter()) {
      echo ("<li><a href=\"index.php3?project=Supporter\">Supporter</a>");
    }
    echo ("</ol>");
  }
?>

</ltpage>

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