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

<postgresconnect>
<spokendate>

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

<h3>Comments</h3>

<p>
<?
  $query = sprintf ("SELECT oid,date,who,email,body FROM comments WHERE project = '%s' ORDER BY date",
		    empty ($project)?$LINUXTAG_AUTH['project']:$project);
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  if (pg_NumRows ($sth) > 0) {

    $edit_permitted = false;
    if (empty ($project) && is_admin ()) {
      $edit_permitted = true;
    }

    if ($edit_permitted) {
      for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
	$row = pg_fetch_array ($sth, $nr);

	$date = explode (" ", $row['date']);
	$date = spokendate ($date[0]);

	printf ("<hr><strong><a href=\"edit_comment.php3?oid=%d\">%s by %s <font size=\"-1\">&lt;%s&gt;</font></a></strong><p>%s",
	  $row['oid'], $date, $row['who'], $row['email'], $row['body']);
      }
    } else {
      for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
	$row = pg_fetch_array ($sth, $nr);

	$date = explode (" ", $row['date']);
	$date = spokendate ($date[0]);

	printf ("<hr><strong>%s by %s <font size=\"-1\">&lt;%s&gt;</font></strong><p>%s",
	  $date, $row['who'], $row['email'], $row['body']);
      }
    }
  }

####### This code is temporaly disabled

## If the user is viewing his own project, we will update person.lastcomments
#if (empty($project))
#{
#	$query = sprintf("UPDATE person set lastcomments = current_timestamp where email = '%s'",
#			 addslashes($LINUXTAG_AUTH['email']));
#	pg_exec($dbh, $query) or die ("Datenbank-Fehler");
#}
?>

</ltpage>

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