<?php
	$galleryId = $_REQUEST['galleryid'];
	$id = $_REQUEST['id'];
	$team = $_REQUEST['team'];
	$age = $_REQUEST['age'];
	$date = $_REQUEST['date'];
	$hour = $_REQUEST['hour'];
	$minute = $_REQUEST['minute'];
	$photoStart = $_REQUEST['photoStart'];
	$photoEnd = $_REQUEST['photoEnd'];
	$photoNumber = $_REQUEST['photoNumber'];
	$photoSilly = $_REQUEST['photoSilly']; 
	$place = $_REQUEST['place'];
	$status = "";
	
	include("TexStarVSS-dbconnect.php");
	
    $sql = sprintf("SELECT Team FROM Teamphoto WHERE GalleryId = %s AND Team = '%s' AND Age = '%s' AND Place = '%s'", $galleryId, mysql_real_escape_string($team), mysql_real_escape_string($age), mysql_real_escape_string($place));
	$result=mysql_query($sql);
	$numrows=mysql_numrows($result);
	if (!$numrows) {
		$queryInsert = sprintf("INSERT INTO Teamphoto (GalleryId, Team, Age, Date, Hour, Minute, PhotoNumber, PhotoSilly, PhotoStart, PhotoEnd, Place) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')",
				$galleryId,
				mysql_real_escape_string($team),
				mysql_real_escape_string($age),
				mysql_real_escape_string($date),
				mysql_real_escape_string($hour),
				mysql_real_escape_string($minute),
				mysql_real_escape_string($photoNumber),
				mysql_real_escape_string($photoSilly),
				mysql_real_escape_string($photoStart),
				mysql_real_escape_string($photoEnd),
				mysql_real_escape_string($place));
		echo $queryInsert;
		$status = mysql_query($queryInsert) or die('Error, insert query failed');
		$id = mysql_query("SELECT LAST_INSERT_ID()");
	}
	else {
		$queryUpdate = sprintf("UPDATE Teamphoto SET Date='%s', PhotoNumber='%s', PhotoSilly='%s', PhotoStart='%s', PhotoEnd='%s', Place='%s', Team='%s', Age='%s' WHERE GalleryId=%s AND Team='%s' AND Age='%s' AND Place='%s'",
			mysql_real_escape_string($date),
			mysql_real_escape_string($photoNumber),
			mysql_real_escape_string($photoSilly),
			mysql_real_escape_string($photoStart),
			mysql_real_escape_string($photoEnd),
			mysql_real_escape_string($place),
			mysql_real_escape_string($team),
   			mysql_real_escape_string($age),
			$galleryId,
			mysql_real_escape_string($team),
			mysql_real_escape_string($age),
			mysql_real_escape_string($place));
		echo $queryUpdate;
		$status = mysql_query($queryUpdate) or die('Error, update query failed');
	}
			
	include("TexStarVSS-dbdisconnect.php");

	echo $id;
?>