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

<postgresconnect>

<ltpage title="Project Management">

<?

# Only an admin is allowed to view this page

if (!(is_admin())) { die ("Sorry, you are not allowed to use this page"); }

# OK, fetch the data

$query = sprintf("SELECT url, boothnr, boothsize, computer, comment FROM project WHERE name = '%s' ",
		 addslashes($LINUXTAG_AUTH['project']));

$sth = pg_exec($dbh, $query) or die ("Sorry, cannot execute query");

if (pg_NumRows($sth) > 0)
{
	$data = pg_fetch_array($sth, 0);

	$query = sprintf ("SELECT boothtitle,description,description_en FROM appendix WHERE project = '%s' ",
			  addslashes($LINUXTAG_AUTH['project']));
	$sth = pg_exec($dbh, $query) or die ("Sorry, cannot execute query");
	if (pg_NumRows($sth) > 0) {
	    $row = pg_fetch_array($sth, 0);
	    $data['boothtitle'] = $row['boothtitle'];
	    $data['description'] = $row['description'];
	    $data['description_en'] = $row['description_en'];
	}

} else {
	die ("Cannot fetch any row");
}

?>

# Generate the html-page

<p><b>Edit project information</b><br><br>
<form method=post action=update.php3>
<input type=hidden name=type value=project>

<center><table cellpadding=0 cellspacing=1>

<row_info	name=project
		title="<b>Project</b>"
		value="<? echo $LINUXTAG_AUTH['project']; ?>"
		>

<row_input	name=boothtitle
		title="<b>Booth title</b>"
		maxlength=35
		value="<? echo $data['boothtitle']; ?>"
		>

<row_input	name=url
		title="<b>URL</b>"
		value="<? echo $data['url']; ?>"
		>

<row_input	name=computer
		title="<b>Nr. computers</b>"
		value="<? echo $data['computer']!=0?$data['computer']:''; ?>"
		>

<? if (strlen ($data['boothnr']) > 0) { ?>
<row_info	name=boothnr
		title="<b>Boothnr</b>"
		value="<? echo $data['boothnr']; ?>"
		>
<? } ?>

<? if ($data['boothsize'] > 0) { ?>
<row_info	name=boothsize
		title="<b>Boothsize</b>"
		value="<? echo $data['boothsize']; ?>"
		>
<? } ?>

<row_input	name=comment
		title="<b>Comment</b>"
		value="<? echo $data['comment']; ?>"
		>

<row_textarea	name=description
		title="<b>Short description (DE) (max 1000 letters)</b>"
		value="<? echo $data['description']; ?>"
		rows=4
		>
<row_textarea	name=description_en
		title="<b>Short description (EN) (max 1000 letters)</b>"
		value="<? echo $data['description_en']; ?>"
		rows=4
		>

<row_submit>
</table></center>
</form>

</ltpage>

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