<?php

$link = pg_connect("dbname=endrov user=endrov password=RejcemFijIp8 host=localhost");

/*
pg_exec(
"CREATE TABLE endrovusers".
"(".
"	regtime bigint,\n".
"	javaversion text not null,\n".
"	arch text not null,\n".
"	OS text not null,".
"	localaddr text not null,".
"	extaddr text not null,".
"	endrovversion text not null,".
"	name text,".
"	institution text,".
"	email text,".
"	primary key(regtime, extaddr)".
");");
*/

$firsttime="true";
if(array_key_exists("firsttime",$_REQUEST))
	{
	$firsttime=$_REQUEST["firsttime"];
	}

$result = pg_prepare($link, "my_query", 'INSERT INTO endrovusers values ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11);');
pg_execute($link, "my_query", array(
time(),
$_REQUEST["javaversion"],
$_REQUEST["arch"],
$_REQUEST["OS"],
$_REQUEST["localaddr"],
$_SERVER["REMOTE_ADDR"],
$_REQUEST["endrovversion"],
$_REQUEST["name"],
$_REQUEST["institution"],
$_REQUEST["email"],
$firsttime
));

pg_close($link);

echo($result)

?>
