<?
include("../config.php");
include("adminlib.php");
$textpart = "reports";
include("../getlang.php");
include("../$mylanguage/admintext.php");
tng_db_connect($database_host,$database_name,$database_username,$database_password) or exit;
include("checklogin.php");
include("../version.php");

if( $assignedtree || !$allow_edit ) {
	$message = "$admtext[norights]";
	header( "Location: login.php?message=" . urlencode($message) );
	exit;
}

$query = "SELECT * FROM $reports_table WHERE reportID = \"$reportID\"";
$result = mysql_query($query) or die ("$admtext[cannotexecutequery]: $query");
$row = mysql_fetch_assoc( $result );
$row[sqlselect] = ereg_replace("\"", "&#34;",$row[sqlselect]);

mysql_free_result($result);

$dontdo = array("ADDR","BIRT","CHR","DEAT","BURI","NAME","NICK","TITL","NSFX");

$dfields = array();
$dfields[personID] = "personid";
$dfields[fullname] = "fullname";
$dfields[lastfirst] = "lastfirst";
$dfields[birthdate] = "birthdate";
$dfields[birthplace] = "birthplace";
$dfields[altbirthdate] = "chrdate";
$dfields[altbirthplace] = "chrplace";
$dfields[marrdate] = "marriagedate";
$dfields[marrplace] = "marriageplace";
$dfields[divdate] = "divdate";
$dfields[divplace] = "divplace";
$dfields[spouseid] = "spouseid";
$dfields[spousename] = "spousename";
$dfields[deathdate] = "deathdate";
$dfields[deathplace] = "deathplace";
$dfields[burialdate] = "burialdate";
$dfields[burialplace] = "burialplace";
$dfields[changedate] = "lastmodified";
$dfields[sex] = "sex";
$dfields[title] = "title";
$dfields[suffix] = "suffix";
$dfields[gedcom] = "tree";
$dfields[baptdate] = "ldsbapldate";
$dfields[baptplace] = "ldsbaplplace";
$dfields[endldate] = "ldsendldate";
$dfields[endlplace] = "ldsendlplace";
$dfields[ssealdate] = "ldssealsdate";
$dfields[ssealplace] = "ldssealsplace";
$dfields[psealdate] = "ldssealpdate";
$dfields[psealplace] = "ldssealpplace";

$cfields = array();
$cfields[personID] = "personid";
$cfields[firstname] = "firstname";
$cfields[lastname] = "lastname";
$cfields[lnprefix] = "lnprefix";
$cfields[monthonly] = "monthonlyfrom";
$cfields[yearonly] = "yearonlyfrom";
$cfields[dayonly] = "dayonlyfrom";
$cfields[desc] = "desc";
$cfields[birthdate] = "birthdate";
$cfields[birthdatetr] = "birthdatetr";
$cfields[birthplace] = "birthplace";
$cfields[altbirthdate] = "chrdate";
$cfields[altbirthdatetr] = "chrdatetr";
$cfields[altbirthplace] = "chrplace";
$cfields[marrdate] = "marriagedate";
$cfields[marrdatetr] = "marriagedatetr";
$cfields[marrplace] = "marriageplace";
$cfields[divdate] = "divdate";
$cfields[divdatetr] = "divdatetr";
$cfields[divplace] = "divplace";
$cfields[deathdate] = "deathdate";
$cfields[deathdatetr] = "deathdatetr";
$cfields[deathplace] = "deathplace";
$cfields[burialdate] = "burialdate";
$cfields[burialdatetr] = "burialdatetr";
$cfields[burialplace] = "burialplace";
$cfields[changedate] = "lastmodified";
$cfields[sex] = "sex";
$cfields[title] = "title";
$cfields[suffix] = "suffix";
$cfields[gedcom] = "tree";
$cfields[baptdate] = "ldsbapldate";
$cfields[baptdatetr] = "ldsbapldatetr";
$cfields[baptplace] = "ldsbaplplace";
$cfields[endldate] = "ldsendldate";
$cfields[endldatetr] = "ldsendldatetr";
$cfields[endlplace] = "ldsendlplace";
$cfields[ssealdate] = "ldssealsdate";
$cfields[ssealdatetr] = "ldssealsdatetr";
$cfields[ssealplace] = "ldssealsplace";
$cfields[psealdate] = "ldssealpdate";
$cfields[psealdatetr] = "ldssealpdatetr";
$cfields[psealplace] = "ldssealpplace";

$ofields = array();
$ofields[contains] = "contains";
$ofields['starts with'] = "startswith";
$ofields['ends with'] = "endswith";
$ofields['OR'] = "text_or";
$ofields['AND'] = "text_and";
$ofields[currmonth] = "currentmonth";
$ofields[currmonthnum] = "currentmonthnum";
$ofields[curryear] = "currentyear";
$ofields[currday] = "currentday";
$ofields[today] = "today";
$ofields[to_days] = "convtodays";

$subtypes = array();
$subtypes[dt] = $admtext[rptdate];
$subtypes[tr] = $admtext[rptdatetr];
$subtypes[pl] = $admtext[place];
$subtypes[fa] = $admtext[fact];

$cetypes = array();
$query = "SELECT eventtypeID, tag, display FROM $eventtypes_table WHERE keep=\"1\" AND type=\"I\" ORDER BY display";
$ceresult = mysql_query($query) or die ("$admtext[cannotexecutequery]: $query");
while( $cerow = mysql_fetch_assoc( $ceresult ) ) {
	if( !in_array( $cerow[tag], $dontdo ) ) {
		$eventtypeID = $cerow[eventtypeID];
		$cetypes[$eventtypeID] = $cerow;
	}
}

$helplang = findhelp("reports_help.html");

tng_adminheader( $admtext[modifyreport], "" );
?>
<script language="JavaScript" src="selectutils.js"></script>
<script language="JavaScript" src="reports.js"></script>
<SCRIPT language="JavaScript" type="text/javascript">
function validateForm( ) {
	var rval = true;
	if( document.form1.reportname.value.length == 0 ) {
		alert("