# Datenbank-Konstanten
# <dbconnstring>       Connect-String für die Datenbank in diesen Bereich
#

<ifeq "$(WML_GEN_HOSTNAME)" "finlandia" "
   <define-tag dbconnstring>host=kuolema port=5432 dbname=web</define-tag>
">
<ifeq "$(WML_GEN_HOSTNAME)" "luonnotar" "
   <define-tag dbconnstring>dbname=debian</define-tag>
">

<:
  if (substr ("<dbconnstring>", 0, 1) eq "<") {
    print  STDERR "Unknown build host, fix party.style.\n";
  }
:>

<define-tag auth>
<?
  function reauth()
  {
      header("WWW-Authenticate: Basic realm=\"Debian Birthday Party\"");
      header("HTTP/1.0 401 Unauthorized");
      echo "Wrong Username or Password\n";
      exit;
  }

  # This will do the actual login authentication
  # Thanks to Erik Tews from LinuxTag Supporters
  #
  unset ($DEBIAN_AUTH);
  if (empty ($PHP_AUTH_USER) || empty ($PHP_AUTH_PW)) {
    reauth();
  } else {
    $dbh = pg_pconnect ("<dbconnstring>")
	       or die("Unable to connect to SQL server");

    $query = sprintf ("SELECT id,name,email,admin FROM party_person WHERE login = '%s' AND passwd = '%s'",
                      addslashes ($PHP_AUTH_USER), md5($PHP_AUTH_PW));
    $sth = pg_exec ($dbh, $query) or die("Can't authenticate");

    if (pg_NumRows ($sth) == 1) {
      $row = pg_fetch_array($sth, 0);
      $DEBIAN_AUTH['id'] = $row['id'];
      $DEBIAN_AUTH['name'] = $row['name'];
      $DEBIAN_AUTH['email'] = $row['email'];
      $DEBIAN_AUTH['admin'] = $row['admin'];
    } else {
      reauth();
    }
  }
?>
</define-tag>

<define-tag optauth>
<?
  # This will do the actual login authentication
  # Thanks to Erik Tews from LinuxTag Supporters
  #
  unset ($DEBIAN_AUTH);
  if (!empty ($PHP_AUTH_USER) && !empty ($PHP_AUTH_PW)) {
    $dbh = pg_pconnect ("<dbconnstring>")
	       or die("Unable to connect to SQL server");

    $query = sprintf ("SELECT id,name,email,admin FROM party_person WHERE login = '%s' AND passwd = '%s'",
                      addslashes ($PHP_AUTH_USER), md5($PHP_AUTH_PW));
    $sth = pg_exec ($dbh, $query) or die("Can't authenticate");

    if (pg_NumRows ($sth) == 1) {
      $row = pg_fetch_array($sth, 0);
      $DEBIAN_AUTH['id'] = $row['id'];
      $DEBIAN_AUTH['name'] = $row['name'];
      $DEBIAN_AUTH['email'] = $row['email'];
      $DEBIAN_AUTH['admin'] = $row['admin'];
    } else {
      reauth();
    }
  }
?>
</define-tag>

<define-tag fetch_days>
<?
  function fetch_days ($dbh, $id)
  {
    $days = array();
    $query = sprintf ("SELECT day FROM party_attend WHERE person = %d", $id);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
    for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
      $row = pg_fetch_array ($sth, $nr);
      $days[$row['day']] = 1;
    }
    return $days;
  }
?>
</define-tag>

<define-tag nrpeople>
<?
  $query = "SELECT count(*) FROM party_person";
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
  if (pg_NumRows ($sth) > 0) {
    $row = pg_fetch_array ($sth, 0);
    if ($row[0] == 1) {
      printf ("<p>%d attendant so far.</p>", $row[0]);
    } else {
      printf ("<p>%d attendants so far.</p>", $row[0]);
    }
  }
?>
</define-tag>