form.php

<?php
 echo time();
//declaration of zone variables that allow me to restructure strings
$team = "";
$match = "";
$highg1 = "";
$highgt1 = "";
$shortg1 = "";
$shortgt1 = "";
$trussg1 = "";
$trusst1 = "";
$shortg1 = "";
$shortgt1 = "";
$trusshpa1 = "";
$trusshpb1 = "";
$hloady1 = "";
$hloadn1 = "";
$dblock1 = "";
$dhit1 = "";
$assist1 = "";
$autohighg1 = "";
$autohighgt1 = "";
$autoshortg1 = "";
$autoshortgt1 = "";
$automove1 = "";

$team = "0";
$match = "0";
$highg1 = "0";
$highgt1 = "0";
$shortg1 = "0";
$shortgt1 = "0";
$trussg1 = "0";
$trusst1 = "0";
$shortg1 = "0";
$shortgt1 = "0";
$trusshpa1 = "0";
$trusshpb1 = "0";
$hloady1 = "0";
$hloadn1 = "0";
$dblock1 = "0";
$dhit1 = "0";
$assist1 = "0";
$autohighg1 = "0";
$autohighgt1 = "0";
$autoshortg1 = "0";
$autoshortgt1 = "0";
$automove1 = "0";

$highg2 = "";
$highgt2 = "";
$shortg2 = "";
$shortgt2 = "";
$trussg2 = "";
$trusst2 = "";
$shortg2 = "";
$shortgt2 = "";
$trusshpa2 = "";
$trusshpb2 = "";
$hloady2 = "";
$hloadn2 = "";
$dblock2 = "";
$dhit2 = "";
$assist2 = "";
$autohighg2 = "";
$autohighgt2 = "";
$autoshortg2 = "";
$autoshortgt2 = "";
$automove2 = "";

$highg2 = "0";
$highgt2 = "0";
$shortg2 = "0";
$shortgt2 = "0";
$trussg2 = "0";
$trusst2 = "0";
$shortg2 = "0";
$shortgt2 = "0";
$trusshpa2 = "0";
$trusshpb2 = "0";
$hloady2 = "0";
$hloadn2 = "0";
$dblock2 = "0";
$dhit2 = "0";
$assist2 = "0";
$autohighg2 = "0";
$autohighgt2 = "0";
$autoshortg2 = "0";
$autoshortgt2 = "";
$automove2 = "";

$highg3 = "";
$highgt3 = "";
$shortg3 = "";
$shortgt3 = "";
$trussg3 = "";
$trusst3 = "";
$shortg3 = "";
$shortgt3 = "";
$trusshpa3 = "";
$trusshpb3 = "";
$hloady3 = "";
$hloadn3 = "";
$dblock3 = "";
$dhit3 = "";
$assist3 = "";
$autohighg3 = "";
$autohighgt3 = "";
$autoshortg3 = "";
$autoshortgt3 = "";
$automove3 = "";

$team = "0";
$match = "0";
$highg3 = "0";
$highgt3 = "0";
$shortg3 = "0";
$shortgt3 = "0";
$trussg3 = "0";
$trusst3 = "0";
$shortg3 = "0";
$shortgt3 = "0";
$trusshpa3 = "0";
$trusshpb3 = "0";
$hloady3 = "0";
$hloadn3 = "0";
$dblock3 = "0";
$dhit3 = "0";
$assist3 = "0";
$autohighg3 = "0";
$autohighgt3 = "0";
$autoshortg3 = "0";
$shortgt3 = "0";
$automove3 = "0";
$autoshortgt2 = "0";
$automove2 = "0";

$highg4 = "";
$highgt4 = "";
$shortg4 = "";
$shortgt4 = "";
$trussg4 = "";
$trusst4 = "";
$shortg4 = "";
$shortgt4 = "";
$trusshpa4 = "";
$trusshpb4 = "";
$hloady4 = "";
$hloadn4 = "";
$dblock4 = "";
$dhit4 = "";
$assist4 = "";
$autohighg4 = "";
$autohighgt4 = "";
$autoshortg4 = "";
$autoshortgt4 = "";
$automove4 = "";

$team = "0";
$match = "0";
$highg4 = "0";
$highgt4 = "0";
$shortg4 = "0";
$shortgt4 = "0";
$trussg4 = "0";
$trusst4 = "0";
$shortg4 = "0";
$shortgt4 = "0";
$trusshpa4 = "0";
$trusshpb4 = "0";
$hloady4 = "0";
$hloadn4 = "0";
$dblock4 = "0";
$dhit4 = "0";
$assist4 = "0";
$autohighg4 = "0";
$autohighgt4 = "0";
$autoshortg4 = "0";
$autoshortgt4 = "0";
$automove4 = "0";

$highg5 = "";
$highgt5 = "";
$shortg5 = "";
$shortgt5 = "";
$trussg5 = "";
$trusst5 = "";
$shortg5 = "";
$shortgt5 = "";
$trusshpa5 = "";
$trusshpb5 = "";
$hloady5 = "";
$hloadn5 = "";
$dblock5 = "";
$dhit5 = "";
$assist5 = "";
$autohighg5 = "";
$autohighgt5 = "";
$autoshortg5 = "";
$autoshortgt5 = "";
$automove5 = "";

$team = "0";
$match = "0";
$highg5 = "0";
$highgt5 = "0";
$shortg5 = "0";
$shortgt5 = "0";
$trussg5 = "0";
$trusst5 = "0";
$shortg5 = "0";
$shortgt5 = "0";
$trusshpa5 = "0";
$trusshpb5 = "0";
$hloady5 = "0";
$hloadn5 = "0";
$dblock5 = "0";
$dhit5 = "0";
$assist5 = "0";
$autohighg5 = "0";
$autohighgt5 = "0";
$autoshortg5 = "0";
$autoshortgt5 = "0";
$automove5 = "0";

$highg6 = "";
$highgt6 = "";
$shortg6 = "";
$shortgt6 = "";
$trussg6 = "";
$trusst6 = "";
$shortg6 = "";
$shortgt6 = "";
$trusshpa6 = "";
$trusshpb6 = "";
$hloady6 = "";
$hloadn6 = "";
$dblock6 = "";
$dhit6 = "";
$assist6 = "";
$autohighg6 = "";
$autohighgt6 = "";
$autoshortg6 = "";
$autoshortgt6 = "";
$automove6 = "";

$team = "0";
$match = "0";
$highg6 = "0";
$highgt6 = "0";
$shortg6 = "0";
$shortgt6 = "0";
$trussg6 = "0";
$trusst6 = "0";
$shortg6 = "0";
$shortgt6 = "0";
$trusshpa6 = "0";
$trusshpb6 = "0";
$hloady6 = "0";
$hloadn6 = "0";
$dblock6 = "0";
$dhit6 = "0";
$assist6 = "0";
$autohighg6 = "0";
$autohighgt6 = "0";
$autoshortg6 = "0";
$autoshortgt6 = "0";
$automove6 = "0";

$highg7 = "";
$highgt7 = "";
$shortg7 = "";
$shortgt7 = "";
$trussg7 = "";
$trusst7 = "";
$shortg7 = "";
$shortgt7 = "";
$trusshpa7 = "";
$trusshpb7 = "";
$hloady7 = "";
$hloadn7 = "";
$dblock7 = "";
$dhit7 = "";
$assist7 = "";
$autohighg7 = "";
$autohighgt7 = "";
$autoshortg7 = "";
$autoshortgt7 = "";
$automove7 = "";

$team = "0";
$match = "0";
$highg7 = "0";
$highgt7 = "0";
$shortg7 = "0";
$shortgt7 = "0";
$trussg7 = "0";
$trusst7 = "0";
$shortg7 = "0";
$shortgt7 = "0";
$trusshpa7 = "0";
$trusshpb7 = "0";
$hloady7 = "0";
$hloadn7 = "0";
$dblock7 = "0";
$dhit7 = "0";
$assist7 = "0";
$autohighg7 = "0";
$autohighgt7 = "0";
$autoshortg7 = "0";
$autoshortgt7 = "0";
$automove7 = "0";

$highg8 = "";
$highgt8 = "";
$shortg8 = "";
$shortgt8 = "";
$trussg8 = "";
$trusst8 = "";
$shortg8 = "";
$shortgt8 = "";
$trusshpa8 = "";
$trusshpb8 = "";
$hloady8 = "";
$hloadn8 = "";
$dblock8 = "";
$dhit8 = "";
$assist8 = "";
$autohighg8 = "";
$autohighgt8 = "";
$autoshortg8 = "";
$autoshortgt8 = "";
$automove8 = "";

$team = "0";
$match = "0";
$highg8 = "0";
$highgt8 = "0";
$shortg8 = "0";
$shortgt8 = "0";
$trussg8 = "0";
$trusst8 = "0";
$shortg8 = "0";
$shortgt8 = "0";
$trusshpa8 = "0";
$trusshpb8 = "0";
$hloady8 = "0";
$hloadn8 = "0";
$dblock8 = "0";
$dhit8 = "0";
$assist8 = "0";
$autohighg8 = "0";
$autohighgt8 = "0";
$autoshortg8 = "0";
$autoshortgt8 = "0";
$automove8 = "0";

$highg9 = "";
$highgt9 = "";
$shortg9 = "";
$shortgt9 = "";
$trussg9 = "";
$trusst9 = "";
$shortg9 = "";
$shortgt9 = "";
$trusshpa9 = "";
$trusshpb9 = "";
$hloady9 = "";
$hloadn9 = "";
$dblock9 = "";
$dhit9 = "";
$assist9 = "";
$autohighg9 = "";
$autohighgt9 = "";
$autoshortg9 = "";
$autoshortgt9 = "";
$automove9 = "";

$team = "0";
$match = "0";
$highg9 = "0";
$highgt9 = "0";
$shortg9 = "0";
$shortgt9 = "0";
$trussg9 = "0";
$trusst9 = "0";
$shortg9 = "0";
$shortgt9 = "0";
$trusshpa9 = "0";
$trusshpb9 = "0";
$hloady9 = "0";
$hloadn9 = "0";
$dblock9 = "0";
$dhit9 = "0";
$assist9 = "0";
$autohighg9 = "0";
$autohighgt9 = "0";
$autoshortg9 = "0";
$autoshortgt9 = "0";
$automove9 = "0";

$highg10 = "";
$highgt10 = "";
$shortg10 = "";
$shortgt10 = "";
$trussg10 = "";
$trusst10 = "";
$shortg10 = "";
$shortgt10 = "";
$trusshpa10 = "";
$trusshpb10 = "";
$hloady10 = "";
$hloadn10 = "";
$dblock10 = "";
$dhit10 = "";
$assist10 = "";
$autohighg10 = "";
$autohighgt10 = "";
$autoshortg10 = "";
$autoshortgt10 = "";
$automove10 = "";

$team = "0";
$match = "0";
$highg10 = "0";
$highgt10 = "0";
$shortg10 = "0";
$shortgt10 = "0";
$trussg10 = "0";
$trusst10 = "0";
$shortg10 = "0";
$shortgt10 = "0";
$trusshpa10 = "0";
$trusshpb10 = "0";
$hloady10 = "0";
$hloadn10 = "0";
$dblock10 = "0";
$dhit10 = "0";
$assist10 = "0";
$autohighg10 = "0";
$autohighgt10 = "0";
$autoshortg10 = "0";
$autoshortgt10 = "0";
$automove10 = "0";

$highg11 = "";
$highgt11 = "";
$shortg11 = "";
$shortgt11 = "";
$trussg11 = "";
$trusst11 = "";
$shortg11 = "";
$shortgt11 = "";
$trusshpa11 = "";
$trusshpb11 = "";
$hloady11 = "";
$hloadn11 = "";
$dblock11 = "";
$dhit11 = "";
$assist11 = "";
$autohighg11 = "";
$autohighgt11 = "";
$autoshortg11 = "";
$autoshortgt11 = "";
$automove11 = "";

$team = "0";
$match = "0";
$highg11 = "0";
$highgt11 = "0";
$shortg11 = "0";
$shortgt11 = "0";
$trussg11 = "0";
$trusst11 = "0";
$shortg11 = "0";
$shortgt11 = "0";
$trusshpa11 = "0";
$trusshpb11 = "0";
$hloady11 = "0";
$hloadn11 = "0";
$dblock11 = "0";
$dhit11 = "0";
$assist11 = "0";
$autohighg11 = "0";
$autohighgt11 = "0";
$autoshortg11 = "0";
$autoshortgt11 = "0";
$automove11 = "0";

$highg12 = "";
$highgt12 = "";
$shortg12 = "";
$shortgt12 = "";
$trussg12 = "";
$trusst12 = "";
$shortg12 = "";
$shortgt12 = "";
$trusshpa12 = "";
$trusshpb12 = "";
$hloady12 = "";
$hloadn12 = "";
$dblock12 = "";
$dhit12 = "";
$assist12 = "";
$autohighg12 = "";
$autohighgt12 = "";
$autoshortg12 = "";
$autoshortgt12 = "";
$automove12 = "";

$team = "0";
$match = "0";
$highg12 = "0";
$highgt12 = "0";
$shortg12 = "0";
$shortgt12 = "0";
$trussg12 = "0";
$trusst12 = "0";
$shortg12 = "0";
$shortgt12 = "0";
$trusshpa12 = "0";
$trusshpb12 = "0";
$hloady12 = "0";
$hloadn12 = "0";
$dblock12 = "0";
$dhit12 = "0";
$assist12 = "0";
$autohighg12 = "0";
$autohighgt12 = "0";
$autoshortg12 = "0";
$autoshortgt12 = "0";
$automove12 = "0";

$highg13 = "";
$highgt13 = "";
$shortg13 = "";
$shortgt13 = "";
$trussg13 = "";
$trusst13 = "";
$shortg13 = "";
$shortgt13 = "";
$trusshpa13 = "";
$trusshpb13 = "";
$hloady13 = "";
$hloadn13 = "";
$dblock13 = "";
$dhit13 = "";
$assist13 = "";
$autohighg13 = "";
$autohighgt13 = "";
$autoshortg13 = "";
$autoshortgt13 = "";
$automove13 = "";

$team = "0";
$match = "0";
$highg13 = "0";
$highgt13 = "0";
$shortg13 = "0";
$shortgt13 = "0";
$trussg13 = "0";
$trusst13 = "0";
$shortg13 = "0";
$shortgt13 = "0";
$trusshpa13 = "0";
$trusshpb13 = "0";
$hloady13 = "0";
$hloadn13 = "0";
$dblock13 = "0";
$dhit13 = "0";
$assist13 = "0";
$autohighg13 = "0";
$autohighgt13 = "0";
$autoshortg13 = "0";
$autoshortgt13 = "0";
$automove13 = "0";

$highg14 = "";
$highgt14 = "";
$shortg14 = "";
$shortgt14 = "";
$trussg14 = "";
$trusst14 = "";
$shortg14 = "";
$shortgt14 = "";
$trusshpa14 = "";
$trusshpb14 = "";
$hloady14 = "";
$hloadn14 = "";
$dblock14 = "";
$dhit14 = "";
$assist14 = "";
$autohighg14 = "";
$autohighgt14 = "";
$autoshortg14 = "";
$autoshortgt14 = "";
$automove14 = "";

$team = "0";
$match = "0";
$highg14 = "0";
$highgt14 = "0";
$shortg14 = "0";
$shortgt14 = "0";
$trussg14 = "0";
$trusst14 = "0";
$shortg14 = "0";
$shortgt14 = "0";
$trusshpa14 = "0";
$trusshpb14 = "0";
$hloady14 = "0";
$hloadn14 = "0";
$dblock14 = "0";
$dhit14 = "0";
$assist14 = "0";
$autohighg14 = "0";
$autohighgt14 = "0";
$autoshortg14 = "0";
$autoshortgt14 = "0";
$automove14 = "0";

$highg15 = "";
$highgt15 = "";
$shortg15 = "";
$shortgt15 = "";
$trussg15 = "";
$trusst15 = "";
$shortg15 = "";
$shortgt15 = "";
$trusshpa15 = "";
$trusshpb15 = "";
$hloady15 = "";
$hloadn15 = "";
$dblock15 = "";
$dhit15 = "";
$assist15 = "";
$autohighg15 = "";
$autohighgt15 = "";
$autoshortg15 = "";
$autoshortgt15 = "";
$automove15 = "";

$team = "0";
$match = "0";
$highg15 = "0";
$highgt15 = "0";
$shortg15 = "0";
$shortgt15 = "0";
$trussg15 = "0";
$trusst15 = "0";
$shortg15 = "0";
$shortgt15 = "0";
$trusshpa15 = "0";
$trusshpb15 = "0";
$hloady15 = "0";
$hloadn15 = "0";
$dblock15 = "0";
$dhit15 = "0";
$assist15 = "0";
$autohighg15 = "0";
$autohighgt15 = "0";
$autoshortg15 = "0";
$autoshortgt15 = "0";
$automove15 = "0";

$writes = "0";
$response1 = "";
$response2 = "";
$response3 = "";
$response4 = "";
$response5 = "";
$response6 = "";
$response7 = "";
$response8 = "";
$response9 = "";
$response10 = "";
$response11 = "";
$response12 = "";
$response13 = "";
$response14 = "";
$response15 = "";
	$team = "";
	$test = "";
	

// Create connection
$con=mysqli_connect("localhost","testuser","testuser","test1"); //changed the db to test1 from testuser

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to mysqli: " . mysqli_connect_error();
  }
	
	if (!mysqli_connect_errno())
  {
  echo "Connection successful or something" . mysqli_connect_error();
  }

	
	foreach ($_POST as $key => $value){
    if ($key == 'team')
		{
		//echo "$value";
		$team = $value;
		}

// i plan on putting the comments handling right here

//comments vars		bookmark1
$comments = "";

if ($key == 'comments')
		{
		//echo "$value";
		$comments = $value;
		}

if ($key == 'match')
		{
		//echo "$value";
		$match = $value;
		}



		}
	
//comments files 		bookmark2
$filename = "";
$filename = "-" . $team . ".txt";
$header = "";
$header = "\n" . "Match:" . $match . "\n";
$comments .= "\n";
file_put_contents($filename,$header, FILE_APPEND);	
file_put_contents($filename,$comments, FILE_APPEND);	


	
	
		// Create the damn table
//$sql="CREATE TABLE scouting(team CHAR(30) ,match CHAR(30) ,zone CHAR(30) ,highg CHAR(30) ,highgt CHAR(30) ,shortg CHAR(30) ,shortgt CHAR(30) ,trussg CHAR(30) ,trusst CHAR(30) ,trusshpa CHAR(30) ,trusshpb CHAR(30) ,hloady CHAR(30) ,hloadn CHAR(30) ,dblock CHAR(30) ,dhit CHAR(30) ,assist CHAR(30) ,autohighg CHAR(30) ,autohighgt CHAR(30) ,autoshortg CHAR(30) ,autoshortgt CHAR(30) ,automove CHAR(30))";
$sql="CREATE TABLE _$team(type CHAR(30), data CHAR(30))";
 //Execute query
if (mysqli_query($con,$sql))
  {
  echo "Table scouting created successfully";
  }
else
  {
  echo "Error creating table: " . mysqli_error($con);
  }
	$sql = "CREATE TABLE scouting 
(
PID INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(PID),

)";

	 


	
foreach ($_POST as $key => $value){
    
		if ($key == 'team')
		{
		//echo "$value";
		$team = $value;
		}
		
		
		
		
		
		if ($key == 'match')
		{
		$match = $value;
		}
		
		
		if ($key == 'highg1_1'){$highg1 = $value;}
		if ($key == 'highgt1_1'){$highgt1 = $value;}
		if ($key == 'shortg1_1'){$shortg1 = $value;}
		if ($key == 'shortgt1_1'){$shortgt1 = $value;}
		if ($key == 'trussg1_1'){$trussg1 = $value;}
		if ($key == 'trussb1_1'){$trusst1 = $value;}
		if ($key == 'trusshpa1_1'){$trusshpa1 = $value;}
		if ($key == 'trusshpb1_1'){$trusshpb1 = $value;}
		if ($key == 'hloady1_1'){$hloady1 = $value;}
		if ($key == 'hloadn1_1'){$hloadn1 = $value;}
		if ($key == 'dblock1_1'){$dblock1 = $value;}
		if ($key == 'dhit1_1'){$dhit1 = $value;}
		if ($key == 'autohighg1_1'){$autohighg1 = $value;}
		if ($key == 'autohighgt1_1'){$autohighgt1 = $value;}
		if ($key == 'autoshortg1_1'){$autoshortg1 = $value;}
		if ($key == 'autoshortgt1_1'){$autoshortgt1 = $value;}
		if ($key == 'automove1_1'){$automove1 = $value;}
		if ($key == 'assist1_1'){$assist1 = $value;}
		
		if ($key == 'highg1_2'){$highg2 = $value;}
		if ($key == 'highgt1_2'){$highgt2 = $value;}
		if ($key == 'shortg1_2'){$shortg2 = $value;}
		if ($key == 'shortgt1_2'){$shortgt2 = $value;}
		if ($key == 'trussg1_2'){$trussg2 = $value;}
		if ($key == 'trussb1_2'){$trusst2 = $value;}
		if ($key == 'trusshpa1_2'){$trusshpa2 = $value;}
		if ($key == 'trusshpb1_2'){$trusshpb2 = $value;}
		if ($key == 'hloady1_2'){$hloady2 = $value;}
		if ($key == 'hloadn1_2'){$hloadn2 = $value;}
		if ($key == 'dblock1_2'){$dblock2 = $value;}
		if ($key == 'dhit1_2'){$dhit2 = $value;}
		if ($key == 'autohighg1_2'){$autohighg2 = $value;}
		if ($key == 'autohighgt1_2'){$autohighgt2 = $value;}
		if ($key == 'autoshortg1_2'){$autoshortg2 = $value;}
		if ($key == 'autoshortgt1_2'){$autoshortgt2 = $value;}
		if ($key == 'automove1_2'){$automove2 = $value;}
		if ($key == 'assist1_2'){$assist2 = $value;}
		
		if ($key == 'highg1_3'){$highg3 = $value;}
		if ($key == 'highgt1_3'){$highgt3 = $value;}
		if ($key == 'shortg1_3'){$shortg3 = $value;}
		if ($key == 'shortgt1_3'){$shortgt3 = $value;}
		if ($key == 'trussg1_3'){$trussg3 = $value;}
		if ($key == 'trussb1_3'){$trusst3 = $value;}
		if ($key == 'trusshpa1_3'){$trusshpa3 = $value;}
		if ($key == 'trusshpb1_3'){$trusshpb3 = $value;}
		if ($key == 'hloady1_3'){$hloady3 = $value;}
		if ($key == 'hloadn1_3'){$hloadn3 = $value;}
		if ($key == 'dblock1_3'){$dblock3 = $value;}
		if ($key == 'dhit1_3'){$dhit3 = $value;}
		if ($key == 'autohighg1_3'){$autohighg3 = $value;}
		if ($key == 'autohighgt1_3'){$autohighgt3 = $value;}
		if ($key == 'autoshortg1_3'){$autoshortg3 = $value;}
		if ($key == 'autoshortgt1_3'){$autoshortgt3 = $value;}
		if ($key == 'automove1_3'){$automove3 = $value;}
		if ($key == 'assist1_3'){$assist3 = $value;}
		
		if ($key == 'highg1_4'){$highg4 = $value;}
		if ($key == 'highgt1_4'){$highgt4 = $value;}
		if ($key == 'shortg1_4'){$shortg4 = $value;}
		if ($key == 'shortgt1_4'){$shortgt4 = $value;}
		if ($key == 'trussg1_4'){$trussg4 = $value;}
		if ($key == 'trussb1_4'){$trusst4 = $value;}
		if ($key == 'trusshpa1_4'){$trusshpa4 = $value;}
		if ($key == 'trusshpb1_4'){$trusshpb4 = $value;}
		if ($key == 'hloady1_4'){$hloady4 = $value;}
		if ($key == 'hloadn1_4'){$hloadn4 = $value;}
		if ($key == 'dblock1_4'){$dblock4 = $value;}
		if ($key == 'dhit1_4'){$dhit4 = $value;}
		if ($key == 'autohighg1_4'){$autohighg4 = $value;}
		if ($key == 'autohighgt1_4'){$autohighgt4 = $value;}
		if ($key == 'autoshortg1_4'){$autoshortg4 = $value;}
		if ($key == 'autoshortgt1_4'){$autoshortgt4 = $value;}
		if ($key == 'automove1_4'){$automove4 = $value;}
		if ($key == 'assist1_4'){$assist4 = $value;}
		
		if ($key == 'highg1_5'){$highg5 = $value;}
		if ($key == 'highgt1_5'){$highgt5 = $value;}
		if ($key == 'shortg1_5'){$shortg5 = $value;}
		if ($key == 'shortgt1_5'){$shortgt5 = $value;}
		if ($key == 'trussg1_5'){$trussg5 = $value;}
		if ($key == 'trussb1_5'){$trusst5 = $value;}
		if ($key == 'trusshpa1_5'){$trusshpa5 = $value;}
		if ($key == 'trusshpb1_5'){$trusshpb5 = $value;}
		if ($key == 'hloady1_5'){$hloady5 = $value;}
		if ($key == 'hloadn1_5'){$hloadn5 = $value;}
		if ($key == 'dblock1_5'){$dblock5 = $value;}
		if ($key == 'dhit1_5'){$dhit5 = $value;}
		if ($key == 'autohighg1_5'){$autohighg5 = $value;}
		if ($key == 'autohighgt1_5'){$autohighgt5 = $value;}
		if ($key == 'autoshortg1_5'){$autoshortg5 = $value;}
		if ($key == 'autoshortgt1_5'){$autoshortgt5 = $value;}
		if ($key == 'automove1_5'){$automove5 = $value;}
		if ($key == 'assist1_5'){$assist5 = $value;}
		
		if ($key == 'highg2_1'){$highg6 = $value;}
		if ($key == 'highgt2_1'){$highgt6 = $value;}
		if ($key == 'shortg2_1'){$shortg6 = $value;}
		if ($key == 'shortgt2_1'){$shortgt6 = $value;}
		if ($key == 'trussg2_1'){$trussg6 = $value;}
		if ($key == 'trussb2_1'){$trusst6 = $value;}
		if ($key == 'trusshpa2_1'){$trusshpa6 = $value;}
		if ($key == 'trusshpb2_1'){$trusshpb6 = $value;}
		if ($key == 'hloady2_1'){$hloady6 = $value;}
		if ($key == 'hloadn2_1'){$hloadn6 = $value;}
		if ($key == 'dblock2_1'){$dblock6 = $value;}
		if ($key == 'dhit2_1'){$dhit6 = $value;}
		if ($key == 'autohighg2_1'){$autohighg6 = $value;}
		if ($key == 'autohighgt2_1'){$autohighgt6 = $value;}
		if ($key == 'autoshortg2_1'){$autoshortg6 = $value;}
		if ($key == 'autoshortgt2_1'){$autoshortgt6 = $value;}
		if ($key == 'automove2_1'){$automove6 = $value;}
		if ($key == 'assist2_1'){$assist6 = $value;}
		
		if ($key == 'highg2_2'){$highg7 = $value;}
		if ($key == 'highgt2_2'){$highgt7 = $value;}
		if ($key == 'shortg2_2'){$shortg7 = $value;}
		if ($key == 'shortgt2_2'){$shortgt7 = $value;}
		if ($key == 'trussg2_2'){$trussg7 = $value;}
		if ($key == 'trussb2_2'){$trusst7 = $value;}
		if ($key == 'trusshpa2_2'){$trusshpa7 = $value;}
		if ($key == 'trusshpb2_2'){$trusshpb7 = $value;}
		if ($key == 'hloady2_2'){$hloady7 = $value;}
		if ($key == 'hloadn2_2'){$hloadn7 = $value;}
		if ($key == 'dblock2_2'){$dblock7 = $value;}
		if ($key == 'dhit2_2'){$dhit7 = $value;}
		if ($key == 'autohighg2_2'){$autohighg7 = $value;}
		if ($key == 'autohighgt2_2'){$autohighgt7 = $value;}
		if ($key == 'autoshortg2_2'){$autoshortg7 = $value;}
		if ($key == 'autoshortgt2_2'){$autoshortgt7 = $value;}
		if ($key == 'automove2_2'){$automove7 = $value;}
		if ($key == 'assist2_2'){$assist7 = $value;}
		
		if ($key == 'highg2_3'){$highg8 = $value;}
		if ($key == 'highgt2_3'){$highgt8 = $value;}
		if ($key == 'shortg2_3'){$shortg8 = $value;}
		if ($key == 'shortgt2_3'){$shortgt8 = $value;}
		if ($key == 'trussg2_3'){$trussg8 = $value;}
		if ($key == 'trussb2_3'){$trusst8 = $value;}
		if ($key == 'trusshpa2_3'){$trusshpa8 = $value;}
		if ($key == 'trusshpb2_3'){$trusshpb8 = $value;}
		if ($key == 'hloady2_3'){$hloady8 = $value;}
		if ($key == 'hloadn2_3'){$hloadn8 = $value;}
		if ($key == 'dblock2_3'){$dblock8 = $value;}
		if ($key == 'dhit2_3'){$dhit8 = $value;}
		if ($key == 'autohighg2_3'){$autohighg8 = $value;}
		if ($key == 'autohighgt2_3'){$autohighgt8 = $value;}
		if ($key == 'autoshortg2_3'){$autoshortg8 = $value;}
		if ($key == 'autoshortgt2_3'){$autoshortgt8 = $value;}
		if ($key == 'automove2_3'){$automove8 = $value;}
		if ($key == 'assist2_3'){$assist8 = $value;}
		
		if ($key == 'highg2_4'){$highg9 = $value;}
		if ($key == 'highgt2_4'){$highgt9 = $value;}
		if ($key == 'shortg2_4'){$shortg9 = $value;}
		if ($key == 'shortgt2_4'){$shortgt9 = $value;}
		if ($key == 'trussg2_4'){$trussg9 = $value;}
		if ($key == 'trussb2_4'){$trusst9 = $value;}
		if ($key == 'trusshpa2_4'){$trusshpa9 = $value;}
		if ($key == 'trusshpb2_4'){$trusshpb9 = $value;}
		if ($key == 'hloady2_4'){$hloady9 = $value;}
		if ($key == 'hloadn2_4'){$hloadn9 = $value;}
		if ($key == 'dblock2_4'){$dblock9 = $value;}
		if ($key == 'dhit2_4'){$dhit9 = $value;}
		if ($key == 'autohighg2_4'){$autohighg9 = $value;}
		if ($key == 'autohighgt2_4'){$autohighgt9 = $value;}
		if ($key == 'autoshortg2_4'){$autoshortg9 = $value;}
		if ($key == 'autoshortgt2_4'){$autoshortgt9 = $value;}
		if ($key == 'automove2_4'){$automove9 = $value;}
		if ($key == 'assist2_4'){$assist9 = $value;}
		
		if ($key == 'highg2_5'){$highg10 = $value;}
		if ($key == 'highgt2_5'){$highgt10 = $value;}
		if ($key == 'shortg2_5'){$shortg10 = $value;}
		if ($key == 'shortgt2_5'){$shortgt10 = $value;}
		if ($key == 'trussg2_5'){$trussg10 = $value;}
		if ($key == 'trussb2_5'){$trusst10 = $value;}
		if ($key == 'trusshpa2_5'){$trusshpa10 = $value;}
		if ($key == 'trusshpb2_5'){$trusshpb10 = $value;}
		if ($key == 'hloady2_5'){$hloady10 = $value;}
		if ($key == 'hloadn2_5'){$hloadn10 = $value;}
		if ($key == 'dblock2_5'){$dblock10 = $value;}
		if ($key == 'dhit2_5'){$dhit10 = $value;}
		if ($key == 'autohighg2_5'){$autohighg10 = $value;}
		if ($key == 'autohighgt2_5'){$autohighgt10 = $value;}
		if ($key == 'autoshortg2_5'){$autoshortg10 = $value;}
		if ($key == 'autoshortgt2_5'){$autoshortgt10 = $value;}
		if ($key == 'automove2_5'){$automove10 = $value;}
		if ($key == 'assist2_5'){$assist10 = $value;}
		
		if ($key == 'highg3_1'){$highg11 = $value;}
		if ($key == 'highgt3_1'){$highgt11 = $value;}
		if ($key == 'shortg3_1'){$shortg11 = $value;}
		if ($key == 'shortgt3_1'){$shortgt11 = $value;}
		if ($key == 'trussg3_1'){$trussg11 = $value;}
		if ($key == 'trussb3_1'){$trusst11 = $value;}
		if ($key == 'trusshpa3_1'){$trusshpa11 = $value;}
		if ($key == 'trusshpb3_1'){$trusshpb11 = $value;}
		if ($key == 'hloady3_1'){$hloady11 = $value;}
		if ($key == 'hloadn3_1'){$hloadn11 = $value;}
		if ($key == 'dblock3_1'){$dblock11 = $value;}
		if ($key == 'dhit3_1'){$dhit11 = $value;}
		if ($key == 'autohighg3_1'){$autohighg11 = $value;}
		if ($key == 'autohighgt3_1'){$autohighgt11 = $value;}
		if ($key == 'autoshortg3_1'){$autoshortg11 = $value;}
		if ($key == 'autoshortgt3_1'){$autoshortgt11 = $value;}
		if ($key == 'automove3_1'){$automove11 = $value;}
		if ($key == 'assist3_1'){$assist11 = $value;}
		
		if ($key == 'highg3_2'){$highg12 = $value;}
		if ($key == 'highgt3_2'){$highgt12 = $value;}
		if ($key == 'shortg3_2'){$shortg12 = $value;}
		if ($key == 'shortgt3_2'){$shortgt12 = $value;}
		if ($key == 'trussg3_2'){$trussg12 = $value;}
		if ($key == 'trussb3_2'){$trusst12 = $value;}
		if ($key == 'trusshpa3_2'){$trusshpa12 = $value;}
		if ($key == 'trusshpb3_2'){$trusshpb12 = $value;}
		if ($key == 'hloady3_2'){$hloady12 = $value;}
		if ($key == 'hloadn3_2'){$hloadn12 = $value;}
		if ($key == 'dblock3_2'){$dblock12 = $value;}
		if ($key == 'dhit3_2'){$dhit12 = $value;}
		if ($key == 'autohighg3_2'){$autohighg12 = $value;}
		if ($key == 'autohighgt3_2'){$autohighgt12 = $value;}
		if ($key == 'autoshortg3_2'){$autoshortg12 = $value;}
		if ($key == 'autoshortgt3_2'){$autoshortgt12 = $value;}
		if ($key == 'automove3_2'){$automove12 = $value;}
		if ($key == 'assist3_2'){$assist12 = $value;}
		
		if ($key == 'highg3_3'){$highg13 = $value;}
		if ($key == 'highgt3_3'){$highgt13 = $value;}
		if ($key == 'shortg3_3'){$shortg13 = $value;}
		if ($key == 'shortgt3_3'){$shortgt13 = $value;}
		if ($key == 'trussg3_3'){$trussg13 = $value;}
		if ($key == 'trussb3_3'){$trusst13 = $value;}
		if ($key == 'trusshpa3_3'){$trusshpa13 = $value;}
		if ($key == 'trusshpb3_3'){$trusshpb13 = $value;}
		if ($key == 'hloady3_3'){$hloady13 = $value;}
		if ($key == 'hloadn3_3'){$hloadn13 = $value;}
		if ($key == 'dblock3_3'){$dblock13 = $value;}
		if ($key == 'dhit3_3'){$dhit13 = $value;}
		if ($key == 'autohighg3_3'){$autohighg13 = $value;}
		if ($key == 'autohighgt3_3'){$autohighgt13 = $value;}
		if ($key == 'autoshortg3_3'){$autoshortg13 = $value;}
		if ($key == 'autoshortgt3_3'){$autoshortgt13 = $value;}
		if ($key == 'automove3_3'){$automove13 = $value;}
		if ($key == 'assist3_3'){$assist13 = $value;}
		
		if ($key == 'highg3_4'){$highg14 = $value;}
		if ($key == 'highgt3_4'){$highgt14 = $value;}
		if ($key == 'shortg3_4'){$shortg14 = $value;}
		if ($key == 'shortgt3_4'){$shortgt14 = $value;}
		if ($key == 'trussg3_4'){$trussg14 = $value;}
		if ($key == 'trussb3_4'){$trusst14 = $value;}
		if ($key == 'trusshpa3_4'){$trusshpa14 = $value;}
		if ($key == 'trusshpb3_4'){$trusshpb14 = $value;}
		if ($key == 'hloady3_4'){$hloady14 = $value;}
		if ($key == 'hloadn3_4'){$hloadn14 = $value;}
		if ($key == 'dblock3_4'){$dblock14 = $value;}
		if ($key == 'dhit3_4'){$dhit14 = $value;}
		if ($key == 'autohighg3_4'){$autohighg14 = $value;}
		if ($key == 'autohighgt3_4'){$autohighgt14 = $value;}
		if ($key == 'autoshortg3_4'){$autoshortg14 = $value;}
		if ($key == 'autoshortgt3_4'){$autoshortgt14 = $value;}
		if ($key == 'automove3_4'){$automove14 = $value;}
		if ($key == 'assist3_4'){$assist14 = $value;}
		
		if ($key == 'highg3_5'){$highg15 = $value;}
		if ($key == 'highgt3_5'){$highgt15 = $value;}
		if ($key == 'shortg3_5'){$shortg15 = $value;}
		if ($key == 'shortgt3_5'){$shortgt15 = $value;}
		if ($key == 'trussg3_5'){$trussg15 = $value;}
		if ($key == 'trussb3_5'){$trusst15 = $value;}
		if ($key == 'trusshpa3_5'){$trusshpa15 = $value;}
		if ($key == 'trusshpb3_5'){$trusshpb15 = $value;}
		if ($key == 'hloady3_5'){$hloady15 = $value;}
		if ($key == 'hloadn3_5'){$hloadn15 = $value;}
		if ($key == 'dblock3_5'){$dblock15 = $value;}
		if ($key == 'dhit3_5'){$dhit15 = $value;}
		if ($key == 'autohighg3_5'){$autohighg15 = $value;}
		if ($key == 'autohighgt3_5'){$autohighgt15 = $value;}
		if ($key == 'autoshortg3_5'){$autoshortg15 = $value;}
		if ($key == 'autoshortgt3_5'){$autoshortgt15 = $value;}
		if ($key == 'automove3_5'){$automove15 = $value;}
		if ($key == 'assist3_5'){$assist15 = $value;}
		
		
		
	
	if ($key == 'automove3_5')
	{
	

/*	old system that had auto zone tracked
$response1 .= $team . "," . $match . "," . "1" . "," . $highg1 . "," . $highgt1 . "," . $shortg1 . "," . $shortgt1 . "," . $trussg1 . "," . $trusst1 . "," . $trusshpa1 . "," . $trusshpb1 . "," . $hloady1 . "," . $hloadn1 . "," . $dblock1 . "," . $dhit1 . "," . $assist1 . "," . $autohighg1 . "," . $autohighgt1 . "," . $autoshortg1 . "," . $autoshortgt1 . "," . $automove1 . "\n";
$response2 .= $team . "," . $match . "," . "2" . "," . $highg2 . "," . $highgt2 . "," . $shortg2 . "," . $shortgt2 . "," . $trussg2 . "," . $trusst2 . "," . $trusshpa2 . "," . $trusshpb2 . "," . $hloady2 . "," . $hloadn2 . "," . $dblock2 . "," . $dhit2 . "," . $assist2 . "," . $autohighg2 . "," . $autohighgt2 . "," . $autoshortg2 . "," . $autoshortgt2 . "," . $automove2 . "\n";
$response3 .= $team . "," . $match . "," . "3" . "," . $highg3 . "," . $highgt3 . "," . $shortg3 . "," . $shortgt3 . "," . $trussg3 . "," . $trusst3 . "," . $trusshpa3 . "," . $trusshpb3 . "," . $hloady3 . "," . $hloadn3 . "," . $dblock3 . "," . $dhit3 . "," . $assist3 . "," . $autohighg3 . "," . $autohighgt3 . "," . $autoshortg3 . "," . $autoshortgt3 . "," . $automove3 . "\n";
$response4 .= $team . "," . $match . "," . "4" . "," . $highg4 . "," . $highgt4 . "," . $shortg4 . "," . $shortgt4 . "," . $trussg4 . "," . $trusst4 . "," . $trusshpa4 . "," . $trusshpb4 . "," . $hloady4 . "," . $hloadn4 . "," . $dblock4 . "," . $dhit4 . "," . $assist4 . "," . $autohighg4 . "," . $autohighgt4 . "," . $autoshortg4 . "," . $autoshortgt4 . "," . $automove4 . "\n";
$response5 .= $team . "," . $match . "," . "5" . "," . $highg5 . "," . $highgt5 . "," . $shortg5 . "," . $shortgt5 . "," . $trussg5 . "," . $trusst5 . "," . $trusshpa5 . "," . $trusshpb5 . "," . $hloady5 . "," . $hloadn5 . "," . $dblock5 . "," . $dhit5 . "," . $assist5 . "," . $autohighg5 . "," . $autohighgt5 . "," . $autoshortg5 . "," . $autoshortgt5 . "," . $automove5 . "\n";
$response6 .= $team . "," . $match . "," . "6" . "," . $highg6 . "," . $highgt6 . "," . $shortg6 . "," . $shortgt6 . "," . $trussg6 . "," . $trusst6 . "," . $trusshpa6 . "," . $trusshpb6 . "," . $hloady6 . "," . $hloadn6 . "," . $dblock6 . "," . $dhit6 . "," . $assist6 . "," . $autohighg6 . "," . $autohighgt6 . "," . $autoshortg6 . "," . $autoshortgt6 . "," . $automove6 . "\n";
$response7 .= $team . "," . $match . "," . "7" . "," . $highg7 . "," . $highgt7 . "," . $shortg7 . "," . $shortgt7 . "," . $trussg7 . "," . $trusst7 . "," . $trusshpa7 . "," . $trusshpb7 . "," . $hloady7 . "," . $hloadn7 . "," . $dblock7 . "," . $dhit7 . "," . $assist7 . "," . $autohighg7 . "," . $autohighgt7 . "," . $autoshortg7 . "," . $autoshortgt7 . "," . $automove7 . "\n";
$response8 .= $team . "," . $match . "," . "8" . "," . $highg8 . "," . $highgt8 . "," . $shortg8 . "," . $shortgt8 . "," . $trussg8 . "," . $trusst8 . "," . $trusshpa8 . "," . $trusshpb8 . "," . $hloady8 . "," . $hloadn8 . "," . $dblock8 . "," . $dhit8 . "," . $assist8 . "," . $autohighg8 . "," . $autohighgt8 . "," . $autoshortg8 . "," . $autoshortgt8 . "," . $automove8 . "\n";
$response9 .= $team . "," . $match . "," . "9" . "," . $highg9 . "," . $highgt9 . "," . $shortg9 . "," . $shortgt9 . "," . $trussg9 . "," . $trusst9 . "," . $trusshpa9 . "," . $trusshpb9 . "," . $hloady9 . "," . $hloadn9 . "," . $dblock9 . "," . $dhit9 . "," . $assist9 . "," . $autohighg9 . "," . $autohighgt9 . "," . $autoshortg9 . "," . $autoshortgt9 . "," . $automove9 . "\n";
$response10 .= $team . "," . $match . "," . "10" . "," . $highg10 . "," . $highgt10 . "," . $shortg10 . "," . $shortgt10 . "," . $trussg10 . "," . $trusst10 . "," . $trusshpa10 . "," . $trusshpb10 . "," . $hloady10 . "," . $hloadn10 . "," . $dblock10 . "," . $dhit10 . "," . $assist10 . "," . $autohighg10 . "," . $autohighgt10 . "," . $autoshortg10 . "," . $autoshortgt10 . "," . $automove10 . "\n";
$response11 .= $team . "," . $match . "," . "11" . "," . $highg11 . "," . $highgt11 . "," . $shortg11 . "," . $shortgt11 . "," . $trussg11 . "," . $trusst11 . "," . $trusshpa11 . "," . $trusshpb11 . "," . $hloady11 . "," . $hloadn11 . "," . $dblock11 . "," . $dhit11 . "," . $assist11 . "," . $autohighg11 . "," . $autohighgt11 . "," . $autoshortg11 . "," . $autoshortgt11 . "," . $automove11 . "\n";
$response12 .= $team . "," . $match . "," . "12" . "," . $highg12 . "," . $highgt12 . "," . $shortg12 . "," . $shortgt12 . "," . $trussg12 . "," . $trusst12 . "," . $trusshpa12 . "," . $trusshpb12 . "," . $hloady12 . "," . $hloadn12 . "," . $dblock12 . "," . $dhit12 . "," . $assist12 . "," . $autohighg12 . "," . $autohighgt12 . "," . $autoshortg12 . "," . $autoshortgt12 . "," . $automove12 . "\n";
$response13 .= $team . "," . $match . "," . "13" . "," . $highg13 . "," . $highgt13 . "," . $shortg13 . "," . $shortgt13 . "," . $trussg13 . "," . $trusst13 . "," . $trusshpa13 . "," . $trusshpb13 . "," . $hloady13 . "," . $hloadn13 . "," . $dblock13 . "," . $dhit13 . "," . $assist13 . "," . $autohighg13 . "," . $autohighgt13 . "," . $autoshortg13 . "," . $autoshortgt13 . "," . $automove13 . "\n";
$response14 .= $team . "," . $match . "," . "14" . "," . $highg14 . "," . $highgt14 . "," . $shortg14 . "," . $shortgt14 . "," . $trussg14 . "," . $trusst14 . "," . $trusshpa14 . "," . $trusshpb14 . "," . $hloady14 . "," . $hloadn14 . "," . $dblock14 . "," . $dhit14 . "," . $assist14 . "," . $autohighg14 . "," . $autohighgt14 . "," . $autoshortg14 . "," . $autoshortgt14 . "," . $automove14 . "\n";
$response15 .= $team . "," . $match . "," . "15" . "," . $highg15 . "," . $highgt15 . "," . $shortg15 . "," . $shortgt15 . "," . $trussg15 . "," . $trusst15 . "," . $trusshpa15 . "," . $trusshpb15 . "," . $hloady15 . "," . $hloadn15 . "," . $dblock15 . "," . $dhit15 . "," . $assist15 . "," . $autohighg15 . "," . $autohighgt15 . "," . $autoshortg15 . "," . $autoshortgt15 . "," . $automove15 . "\n";



	
	file_put_contents('scouting.csv',$response1, FILE_APPEND);
file_put_contents('scouting.csv',$response2, FILE_APPEND);
file_put_contents('scouting.csv',$response3, FILE_APPEND);
file_put_contents('scouting.csv',$response4, FILE_APPEND);
file_put_contents('scouting.csv',$response5, FILE_APPEND);
file_put_contents('scouting.csv',$response6, FILE_APPEND);
file_put_contents('scouting.csv',$response7, FILE_APPEND);
file_put_contents('scouting.csv',$response8, FILE_APPEND);
file_put_contents('scouting.csv',$response9, FILE_APPEND);
file_put_contents('scouting.csv',$response10, FILE_APPEND);
file_put_contents('scouting.csv',$response11, FILE_APPEND);
file_put_contents('scouting.csv',$response12, FILE_APPEND);
file_put_contents('scouting.csv',$response13, FILE_APPEND);
file_put_contents('scouting.csv',$response14, FILE_APPEND);
file_put_contents('scouting.csv',$response15, FILE_APPEND);


	*/


//new system for writing to the csv

// new strings to handle the auto as zone
$response21 = "";
$autohighg21 = ($autohighg1 + $autohighg2 + $autohighg3 + $autohighg4 + $autohighg5 + $autohighg6 + $autohighg7 + $autohighg8 + $autohighg9 + $autohighg10 + $autohighg11 + $autohighg12 + $autohighg13 + $autohighg14 + $autohighg15);
$autohighgt21 = ($autohighgt1 + $autohighgt2 + $autohighgt3 + $autohighgt4 + $autohighgt5 + $autohighgt6 + $autohighgt7 + $autohighgt8 + $autohighgt9 + $autohighgt10 + $autohighgt11 + $autohighgt12 + $autohighgt13 + $autohighgt14 + $autohighgt15);
$autoshortg21 = ($autoshortg1 + $autoshortg2 + $autoshortg3 + $autoshortg4 + $autoshortg5 + $autoshortg6 + $autoshortg7 + $autoshortg8 + $autoshortg9 + $autoshortg10 + $autoshortg11 + $autoshortg12 + $autoshortg13 + $autoshortg14 + $autoshortg15);
$autoshortgt21 = ($autoshortgt1 + $autoshortgt2 + $autoshortgt3 + $autoshortgt4 + $autoshortgt5 + $autoshortgt6 + $autoshortgt7 + $autoshortgt8 + $autoshortgt9 + $autoshortgt10 + $autoshortgt11 + $autoshortgt12 + $autoshortgt13 + $autoshortgt14 + $autoshortgt15);
$automove21 = ($automove1 + $automove2 + $automove3 + $automove4 + $automove5 + $automove6 + $automove7 + $automove8 + $automove9 + $automove10 + $automove11 + $automove12 + $automove13 + $automove14 + $automove15);

//formation of strings to write to csv file
$response1 .= $team . "," . $match . "," . "1" . "," . $highg1 . "," . $highgt1 . "," . $shortg1 . "," . $shortgt1 . "," . $trussg1 . "," . $trusst1 . "," . $trusshpa1 . "," . $trusshpb1 . "," . $hloady1 . "," . $hloadn1 . "," . $dblock1 . "," . $dhit1 . "," . $assist1 . "," . "\n";
$response2 .= $team . "," . $match . "," . "2" . "," . $highg2 . "," . $highgt2 . "," . $shortg2 . "," . $shortgt2 . "," . $trussg2 . "," . $trusst2 . "," . $trusshpa2 . "," . $trusshpb2 . "," . $hloady2 . "," . $hloadn2 . "," . $dblock2 . "," . $dhit2 . "," . $assist2 . "," . "\n";
$response3 .= $team . "," . $match . "," . "3" . "," . $highg3 . "," . $highgt3 . "," . $shortg3 . "," . $shortgt3 . "," . $trussg3 . "," . $trusst3 . "," . $trusshpa3 . "," . $trusshpb3 . "," . $hloady3 . "," . $hloadn3 . "," . $dblock3 . "," . $dhit3 . "," . $assist3 . "," . "\n";
$response4 .= $team . "," . $match . "," . "4" . "," . $highg4 . "," . $highgt4 . "," . $shortg4 . "," . $shortgt4 . "," . $trussg4 . "," . $trusst4 . "," . $trusshpa4 . "," . $trusshpb4 . "," . $hloady4 . "," . $hloadn4 . "," . $dblock4 . "," . $dhit4 . "," . $assist4 . "," . "\n";
$response5 .= $team . "," . $match . "," . "5" . "," . $highg5 . "," . $highgt5 . "," . $shortg5 . "," . $shortgt5 . "," . $trussg5 . "," . $trusst5 . "," . $trusshpa5 . "," . $trusshpb5 . "," . $hloady5 . "," . $hloadn5 . "," . $dblock5 . "," . $dhit5 . "," . $assist5 . "," . "\n";
$response6 .= $team . "," . $match . "," . "6" . "," . $highg6 . "," . $highgt6 . "," . $shortg6 . "," . $shortgt6 . "," . $trussg6 . "," . $trusst6 . "," . $trusshpa6 . "," . $trusshpb6 . "," . $hloady6 . "," . $hloadn6 . "," . $dblock6 . "," . $dhit6 . "," . $assist6 . "," . "\n";
$response7 .= $team . "," . $match . "," . "7" . "," . $highg7 . "," . $highgt7 . "," . $shortg7 . "," . $shortgt7 . "," . $trussg7 . "," . $trusst7 . "," . $trusshpa7 . "," . $trusshpb7 . "," . $hloady7 . "," . $hloadn7 . "," . $dblock7 . "," . $dhit7 . "," . $assist7 . "," . "\n";
$response8 .= $team . "," . $match . "," . "8" . "," . $highg8 . "," . $highgt8 . "," . $shortg8 . "," . $shortgt8 . "," . $trussg8 . "," . $trusst8 . "," . $trusshpa8 . "," . $trusshpb8 . "," . $hloady8 . "," . $hloadn8 . "," . $dblock8 . "," . $dhit8 . "," . $assist8 . "," . "\n";
$response9 .= $team . "," . $match . "," . "9" . "," . $highg9 . "," . $highgt9 . "," . $shortg9 . "," . $shortgt9 . "," . $trussg9 . "," . $trusst9 . "," . $trusshpa9 . "," . $trusshpb9 . "," . $hloady9 . "," . $hloadn9 . "," . $dblock9 . "," . $dhit9 . "," . $assist9 . "," . "\n";
$response10 .= $team . "," . $match . "," . "10" . "," . $highg10 . "," . $highgt10 . "," . $shortg10 . "," . $shortgt10 . "," . $trussg10 . "," . $trusst10 . "," . $trusshpa10 . "," . $trusshpb10 . "," . $hloady10 . "," . $hloadn10 . "," . $dblock10 . "," . $dhit10 . "," . $assist10 . "," . "\n";
$response11 .= $team . "," . $match . "," . "11" . "," . $highg11 . "," . $highgt11 . "," . $shortg11 . "," . $shortgt11 . "," . $trussg11 . "," . $trusst11 . "," . $trusshpa11 . "," . $trusshpb11 . "," . $hloady11 . "," . $hloadn11 . "," . $dblock11 . "," . $dhit11 . "," . $assist11 . "," . "\n";
$response12 .= $team . "," . $match . "," . "12" . "," . $highg12 . "," . $highgt12 . "," . $shortg12 . "," . $shortgt12 . "," . $trussg12 . "," . $trusst12 . "," . $trusshpa12 . "," . $trusshpb12 . "," . $hloady12 . "," . $hloadn12 . "," . $dblock12 . "," . $dhit12 . "," . $assist12 . "," . "\n";
$response13 .= $team . "," . $match . "," . "13" . "," . $highg13 . "," . $highgt13 . "," . $shortg13 . "," . $shortgt13 . "," . $trussg13 . "," . $trusst13 . "," . $trusshpa13 . "," . $trusshpb13 . "," . $hloady13 . "," . $hloadn13 . "," . $dblock13 . "," . $dhit13 . "," . $assist13 . "," . "\n";
$response14 .= $team . "," . $match . "," . "14" . "," . $highg14 . "," . $highgt14 . "," . $shortg14 . "," . $shortgt14 . "," . $trussg14 . "," . $trusst14 . "," . $trusshpa14 . "," . $trusshpb14 . "," . $hloady14 . "," . $hloadn14 . "," . $dblock14 . "," . $dhit14 . "," . $assist14 . "," . "\n";
$response15 .= $team . "," . $match . "," . "15" . "," . $highg15 . "," . $highgt15 . "," . $shortg15 . "," . $shortgt15 . "," . $trussg15 . "," . $trusst15 . "," . $trusshpa15 . "," . $trusshpb15 . "," . $hloady15 . "," . $hloadn15 . "," . $dblock15 . "," . $dhit15 . "," . $assist15 . "," . "\n";
$response21 .= $team . "," . $match . "," . "21" . "," . $autohighg21 . "," . $autohighgt21 . "," . $autoshortg21 . "," . $autoshortgt21 . "," . $automove21 . "\n";



	
	file_put_contents('scouting.csv',$response1, FILE_APPEND);
file_put_contents('scouting.csv',$response2, FILE_APPEND);
file_put_contents('scouting.csv',$response3, FILE_APPEND);
file_put_contents('scouting.csv',$response4, FILE_APPEND);
file_put_contents('scouting.csv',$response5, FILE_APPEND);
file_put_contents('scouting.csv',$response6, FILE_APPEND);
file_put_contents('scouting.csv',$response7, FILE_APPEND);
file_put_contents('scouting.csv',$response8, FILE_APPEND);
file_put_contents('scouting.csv',$response9, FILE_APPEND);
file_put_contents('scouting.csv',$response10, FILE_APPEND);
file_put_contents('scouting.csv',$response11, FILE_APPEND);
file_put_contents('scouting.csv',$response12, FILE_APPEND);
file_put_contents('scouting.csv',$response13, FILE_APPEND);
file_put_contents('scouting.csv',$response14, FILE_APPEND);
file_put_contents('scouting.csv',$response15, FILE_APPEND);
file_put_contents('scouting.csv',$response21, FILE_APPEND);

// I wont be changing the way it inserts to the database yet and i will focus on the csv files.
// I have decided that when i add in support for database i will just make a new table and insert both ways.
	//echo "$response1";
	//echo "$response2";
	//echo "$response3";
	//echo "$response4";
	//echo "$response5";
	//echo "$response6";
	//echo "$response7";
	//echo "$response8";
	//echo "$response9";
	//echo "$response10";
	//echo "$response11";
	//echo "$response12";
	//echo "$response13";
	//echo "$response14";
	//echo "$response15";
	
	//mysqli_query($con,"INSERT INTO scouting (team, match, zone, highg, hight, shortg, shortgt, trussg, trussb, trusshpa, trusshpb, hloady, hloadn, dblock, dhit, assist, autohighg, autohighgt, autoshortg, autoshortgt, automove)
	//VALUES ('$team' , '$match' , '1' , '$highg1' , '$highgt1' , '$shortg1' , '$shortgt1' , '$trussg1' , '$trusst1' , '$trusshpa1' , '$trusshpb1' , '$hloady1' , '$hloadn1' , '$dblock1' , '$dhit1' , '$assist1' , '$autohighg1' , '$autohighgt1' , '$autoshortg1' , '$autoshortgt1' , '$automove1')");
	//mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`,, `trusst` `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) VALUES ($team,$match,1,$highg1,$highgt1,$shortg1,$shortgt1,$trussg1,$trusst1,$trusshpa1,$trusshpb1,$hloady1,$hloadn1,$dblock1,$dhit1,$assist1,$autohighg1,$autohighgt1,$autoshortg1,$autoshortgt1,$automove1)");
	
	  //old inserts
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,1,$highg1,$highgt1,$shortg1,$shortgt1,$trussg1,$trusst1,$trusshpa1,$trusshpb1,$hloady1,$hloadn1,$dblock1,$dhit1,$assist1,$autohighg1,$autohighgt1,$autoshortg1,$autoshortgt1,$automove1)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,2,$highg2,$highgt2,$shortg2,$shortgt2,$trussg2,$trusst2,$trusshpa2,$trusshpb2,$hloady2,$hloadn2,$dblock2,$dhit2,$assist2,$autohighg2,$autohighgt2,$autoshortg2,$autoshortgt2,$automove2)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,3,$highg3,$highgt3,$shortg3,$shortgt3,$trussg3,$trusst3,$trusshpa3,$trusshpb3,$hloady3,$hloadn3,$dblock3,$dhit3,$assist3,$autohighg3,$autohighgt3,$autoshortg3,$autoshortgt3,$automove3)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,4,$highg4,$highgt4,$shortg4,$shortgt4,$trussg4,$trusst4,$trusshpa4,$trusshpb4,$hloady4,$hloadn4,$dblock4,$dhit4,$assist4,$autohighg4,$autohighgt4,$autoshortg4,$autoshortgt4,$automove4)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,5,$highg5,$highgt5,$shortg5,$shortgt5,$trussg5,$trusst5,$trusshpa5,$trusshpb5,$hloady5,$hloadn5,$dblock5,$dhit5,$assist5,$autohighg5,$autohighgt5,$autoshortg5,$autoshortgt5,$automove5)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,6,$highg6,$highgt6,$shortg6,$shortgt6,$trussg6,$trusst6,$trusshpa6,$trusshpb6,$hloady6,$hloadn6,$dblock6,$dhit6,$assist6,$autohighg6,$autohighgt6,$autoshortg6,$autoshortgt6,$automove6)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,7,$highg7,$highgt7,$shortg7,$shortgt7,$trussg7,$trusst7,$trusshpa7,$trusshpb7,$hloady7,$hloadn7,$dblock7,$dhit7,$assist7,$autohighg7,$autohighgt7,$autoshortg7,$autoshortgt7,$automove7)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,8,$highg8,$highgt8,$shortg8,$shortgt8,$trussg8,$trusst8,$trusshpa8,$trusshpb8,$hloady8,$hloadn8,$dblock8,$dhit8,$assist8,$autohighg8,$autohighgt8,$autoshortg8,$autoshortgt8,$automove8)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,9,$highg9,$highgt9,$shortg9,$shortgt9,$trussg9,$trusst9,$trusshpa9,$trusshpb9,$hloady9,$hloadn9,$dblock9,$dhit9,$assist9,$autohighg9,$autohighgt9,$autoshortg9,$autoshortgt9,$automove9)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,10,$highg10,$highgt10,$shortg10,$shortgt10,$trussg10,$trusst10,$trusshpa10,$trusshpb10,$hloady10,$hloadn10,$dblock10,$dhit10,$assist10,$autohighg10,$autohighgt10,$autoshortg10,$autoshortgt10,$automove10)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,11,$highg11,$highgt11,$shortg11,$shortgt11,$trussg11,$trusst11,$trusshpa11,$trusshpb11,$hloady11,$hloadn11,$dblock11,$dhit11,$assist11,$autohighg11,$autohighgt11,$autoshortg11,$autoshortgt11,$automove11)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,12,$highg12,$highgt12,$shortg12,$shortgt12,$trussg12,$trusst12,$trusshpa12,$trusshpb12,$hloady12,$hloadn12,$dblock12,$dhit12,$assist12,$autohighg12,$autohighgt12,$autoshortg12,$autoshortgt12,$automove12)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,13,$highg13,$highgt13,$shortg13,$shortgt13,$trussg13,$trusst13,$trusshpa13,$trusshpb13,$hloady13,$hloadn13,$dblock13,$dhit13,$assist13,$autohighg13,$autohighgt13,$autoshortg13,$autoshortgt13,$automove13)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,14,$highg14,$highgt14,$shortg14,$shortgt14,$trussg14,$trusst14,$trusshpa14,$trusshpb14,$hloady14,$hloadn14,$dblock14,$dhit14,$assist14,$autohighg14,$autohighgt14,$autoshortg14,$autoshortgt14,$automove14)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,15,$highg15,$highgt15,$shortg15,$shortgt15,$trussg15,$trusst15,$trusshpa15,$trusshpb15,$hloady15,$hloadn15,$dblock15,$dhit15,$assist15,$autohighg15,$autohighgt15,$autoshortg15,$autoshortgt15,$automove15)");
	

	
/* // not working

// my insert code for the updated scheme for the auto as a goal.

// need a filler for the empty spaces.
$filler = "null";



mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,1,$highg1,$highgt1,$shortg1,$shortgt1,$trussg1,$trusst1,$trusshpa1,$trusshpb1,$hloady1,$hloadn1,$dblock1,$dhit1,$assist1,$filler,$filler,$filler,$filler,$filler)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,2,$highg2,$highgt2,$shortg2,$shortgt2,$trussg2,$trusst2,$trusshpa2,$trusshpb2,$hloady2,$hloadn2,$dblock2,$dhit2,$assist2,$filler,$filler,$filler,$filler,$filler)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,3,$highg3,$highgt3,$shortg3,$shortgt3,$trussg3,$trusst3,$trusshpa3,$trusshpb3,$hloady3,$hloadn3,$dblock3,$dhit3,$assist3,$filler,$filler,$filler,$filler,$filler)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,4,$highg4,$highgt4,$shortg4,$shortgt4,$trussg4,$trusst4,$trusshpa4,$trusshpb4,$hloady4,$hloadn4,$dblock4,$dhit4,$assist4,$filler,$filler,$filler,$filler,$filler)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,5,$highg5,$highgt5,$shortg5,$shortgt5,$trussg5,$trusst5,$trusshpa5,$trusshpb5,$hloady5,$hloadn5,$dblock5,$dhit5,$assist5,$filler,$filler,$filler,$filler,$filler)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,6,$highg6,$highgt6,$shortg6,$shortgt6,$trussg6,$trusst6,$trusshpa6,$trusshpb6,$hloady6,$hloadn6,$dblock6,$dhit6,$assist6,$filler,$filler,$filler,$filler,$filler)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,7,$highg7,$highgt7,$shortg7,$shortgt7,$trussg7,$trusst7,$trusshpa7,$trusshpb7,$hloady7,$hloadn7,$dblock7,$dhit7,$assist7,$filler,$filler,$filler,$filler,$filler)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,8,$highg8,$highgt8,$shortg8,$shortgt8,$trussg8,$trusst8,$trusshpa8,$trusshpb8,$hloady8,$hloadn8,$dblock8,$dhit8,$assist8,$filler,$filler,$filler,$filler,$filler)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,9,$highg9,$highgt9,$shortg9,$shortgt9,$trussg9,$trusst9,$trusshpa9,$trusshpb9,$hloady9,$hloadn9,$dblock9,$dhit9,$assist9,$filler,$filler,$filler,$filler,$filler)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,10,$highg10,$highgt10,$shortg10,$shortgt10,$trussg10,$trusst10,$trusshpa10,$trusshpb10,$hloady10,$hloadn10,$dblock10,$dhit10,$assist10,$filler,$filler,$filler,$filler,$filler)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,11,$highg11,$highgt11,$shortg11,$shortgt11,$trussg11,$trusst11,$trusshpa11,$trusshpb11,$hloady11,$hloadn11,$dblock11,$dhit11,$assist11,$filler,$filler,$filler,$filler,$filler)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,12,$highg12,$highgt12,$shortg12,$shortgt12,$trussg12,$trusst12,$trusshpa12,$trusshpb12,$hloady12,$hloadn12,$dblock12,$dhit12,$assist12,$filler,$filler,$filler,$filler,$filler)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,13,$highg13,$highgt13,$shortg13,$shortgt13,$trussg13,$trusst13,$trusshpa13,$trusshpb13,$hloady13,$hloadn13,$dblock13,$dhit13,$assist13,$filler,$filler,$filler,$filler,$filler)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,14,$highg14,$highgt14,$shortg14,$shortgt14,$trussg14,$trusst14,$trusshpa14,$trusshpb14,$hloady14,$hloadn14,$dblock14,$dhit14,$assist14,$filler,$filler,$filler,$filler,$filler)");
	
	mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,15,$highg15,$highgt15,$shortg15,$shortgt15,$trussg15,$trusst15,$trusshpa15,$trusshpb15,$hloady15,$hloadn15,$dblock15,$dhit15,$assist15,$filler,$filler,$filler,$filler,$filler)");



mysqli_query($con,"INSERT INTO `scouting`(`team`, `match`, `zone`, `highg`, `highgt`, `shortg`, `shortgt`, `trussg`, `trusst`, `trusshpa`, `trusshpb`, `hloady`, `hloadn`, `dblock`, `dhit`, `assist`, `autohighg`, `autohighgt`, `autoshortg`, `autoshortgt`, `automove`) 
	VALUES ($team,$match,21,$autohighg21,$autohighgt21,$autoshortg21,$autoshortgt21,$automove21,$filler,$filler,$filler,$filler,$filler,$filler,$filler,$filler,$filler,$filler,$filler,$filler,$filler)");
*/

	
	$db="";
	$db="testuser";
	//mysqli_select_db($db , $con) or die("Select Error: ".mysql_error());
	//mysqli_query("ALTER TABLE `data` ADD `column`  INT(10)");
	//mysqli_query($con,"ALTER TABLE `persons` ADD `test` CHAR(30)") or die("Alter Error: ".mysqli_error());
//mysqli_close($con);
	
	
	if ($match == "1"){
	$match = "01";
	}
	
	if ($match == "2"){
	$match = "02";
	}
	if ($match == "3"){
	$match = "03";
	}
	if ($match == "4"){
	$match = "04";
	}
	if ($match == "5"){
	$match = "05";
	}
	if ($match == "6"){
	$match = "06";
	}
	if ($match == "7"){
	$match = "07";
	}
	if ($match == "8"){
	$match = "08";
	}
	
	if ($match == "9"){
	$match = "09";
	}
	
	
	
	
	
	
	//zone 1
	mysqli_query($con," INSERT INTO `_$team`(`type`, `data`) VALUES ('01 01 $match',$highg1),
	('01 02 $match',$highgt1),
	('01 03 $match',$shortg1),
	('01 04 $match',$shortgt1),
	('01 05 $match',$trussg1),
	('01 06 $match',$trusst1),
	('01 07 $match',$trusshpa1),
	('01 08 $match',$trusshpb1),
	('01 09 $match',$hloady1),
	('01 10 $match',$hloadn1),
	('01 11 $match',$dblock1),
	('01 12 $match',$dhit1),
	('01 13 $match',$assist1),
	('01 14 $match',$autohighg1),
	('01 15 $match',$autohighgt1),
	('01 16 $match',$autoshortg1),
	('01 17 $match',$autoshortgt1),
	('01 18 $match',$automove1),
	
	
	
	('02 01 $match',$highg2),
	('02 02 $match',$highgt2),
	('02 03 $match',$shortg2),
	('02 04 $match',$shortgt2),
	('02 05 $match',$trussg2),
	('02 06 $match',$trusst2),
	('02 07 $match',$trusshpa2),
	('02 08 $match',$trusshpb2),
	('02 09 $match',$hloady2),
	('02 10 $match',$hloadn2),
	('02 11 $match',$dblock2),
	('02 12 $match',$dhit2),
	('02 13 $match',$assist2),
	('02 14 $match',$autohighg2),
	('02 15 $match',$autohighgt2),
	('02 16 $match',$autoshortg2),
	('02 17 $match',$autoshortgt2),
	('02 18 $match',$automove2),
	
	
	
	('03 01 $match',$highg3),
	('03 02 $match',$highgt3),
	('03 03 $match',$shortg3),
	('03 04 $match',$shortgt3),
	('03 05 $match',$trussg3),
	('03 06 $match',$trusst3),
	('03 07 $match',$trusshpa3),
	('03 08 $match',$trusshpb3),
	('03 09 $match',$hloady3),
	('03 10 $match',$hloadn3),
	('03 11 $match',$dblock3),
	('03 12 $match',$dhit3),
	('03 13 $match',$assist3),
	('03 14 $match',$autohighg3),
	('03 15 $match',$autohighgt3),
	('03 16 $match',$autoshortg3),
	('03 17 $match',$autoshortgt3),
	('03 18 $match',$automove3),
	
	
	
	('04 01 $match',$highg4),
	('04 02 $match',$highgt4),
	('04 03 $match',$shortg4),
	('04 04 $match',$shortgt4),
	('04 05 $match',$trussg4),
	('04 06 $match',$trusst4),
	('04 07 $match',$trusshpa4),
	('04 08 $match',$trusshpb4),
	('04 09 $match',$hloady4),
	('04 10 $match',$hloadn4),
	('04 11 $match',$dblock4),
	('04 12 $match',$dhit4),
	('04 13 $match',$assist4),
	('04 14 $match',$autohighg4),
	('04 15 $match',$autohighgt4),
	('04 16 $match',$autoshortg4),
	('04 17 $match',$autoshortgt4),
	('04 18 $match',$automove4),
	
	
	
	('05 01 $match',$highg5),
	('05 02 $match',$highgt5),
	('05 03 $match',$shortg5),
	('05 04 $match',$shortgt5),
	('05 05 $match',$trussg5),
	('05 06 $match',$trusst5),
	('05 07 $match',$trusshpa5),
	('05 08 $match',$trusshpb5),
	('05 09 $match',$hloady5),
	('05 11 $match',$hloadn5),
	('05 11 $match',$dblock5),
	('05 12 $match',$dhit5),
	('05 13 $match',$assist5),
	('05 14 $match',$autohighg5),
	('05 15 $match',$autohighgt5),
	('05 16 $match',$autoshortg5),
	('05 17 $match',$autoshortgt5),
	('05 18 $match',$automove5),
	
	

	('06 01 $match',$highg6),
	('06 02 $match',$highgt6),
	('06 03 $match',$shortg6),
	('06 04 $match',$shortgt6),
	('06 05 $match',$trussg6),
	('06 06 $match',$trusst6),
	('06 07 $match',$trusshpa6),
	('06 08 $match',$trusshpb6),
	('06 09 $match',$hloady6),
	('06 10 $match',$hloadn6),
	('06 11 $match',$dblock6),
	('06 12 $match',$dhit6),
	('06 13 $match',$assist6),
	('06 14 $match',$autohighg6),
	('06 15 $match',$autohighgt6),
	('06 16 $match',$autoshortg6),
	('06 17 $match',$autoshortgt6),
	('06 18 $match',$automove6),
	
	

	('07 01 $match',$highg7),
	('07 02 $match',$highgt7),
	('07 03 $match',$shortg7),
	('07 04 $match',$shortgt7),
	('07 05 $match',$trussg7),
	('07 06 $match',$trusst7),
	('07 07 $match',$trusshpa7),
	('07 08 $match',$trusshpb7),
	('07 09 $match',$hloady7),
	('07 10 $match',$hloadn7),
	('07 11 $match',$dblock7),
	('07 12 $match',$dhit7),
	('07 13 $match',$assist7),
	('07 14 $match',$autohighg7),
	('07 15 $match',$autohighgt7),
	('07 16 $match',$autoshortg7),
	('07 17 $match',$autoshortgt7),
	('07 18 $match',$automove7),
	
	

	('08 01 $match',$highg8),
	('08 02 $match',$highgt8),
	('08 03 $match',$shortg8),
	('08 04 $match',$shortgt8),
	('08 05 $match',$trussg8),
	('08 06 $match',$trusst8),
	('08 07 $match',$trusshpa8),
	('08 08 $match',$trusshpb8),
	('08 09 $match',$hloady8),
	('08 10 $match',$hloadn8),
	('08 11 $match',$dblock8),
	('08 12 $match',$dhit8),
	('08 13 $match',$assist8),
	('08 14 $match',$autohighg8),
	('08 15 $match',$autohighgt8),
	('08 16 $match',$autoshortg8),
	('08 17 $match',$autoshortgt8),
	('08 18 $match',$automove8),
	
	

	('09 01 $match',$highg9),
	('09 02 $match',$highgt9),
	('09 03 $match',$shortg9),
	('09 04 $match',$shortgt9),
	('09 05 $match',$trussg9),
	('09 06 $match',$trusst9),
	('09 07 $match',$trusshpa9),
	('09 08 $match',$trusshpb9),
	('09 09 $match',$hloady9),
	('09 10 $match',$hloadn9),
	('09 11 $match',$dblock9),
	('09 12 $match',$dhit9),
	('09 13 $match',$assist9),
	('09 14 $match',$autohighg9),
	('09 15 $match',$autohighgt9),
	('09 16 $match',$autoshortg9),
	('09 17 $match',$autoshortgt9),
	('09 18 $match',$automove9),
	
	

	('10 01 $match',$highg10),
	('10 02 $match',$highgt10),
	('10 03 $match',$shortg10),
	('10 04 $match',$shortgt10),
	('10 05 $match',$trussg10),
	('10 06 $match',$trusst10),
	('10 07 $match',$trusshpa10),
	('10 08 $match',$trusshpb10),
	('10 09 $match',$hloady10),
	('10 10 $match',$hloadn10),
	('10 11 $match',$dblock10),
	('10 12 $match',$dhit10),
	('10 13 $match',$assist10),
	('10 14 $match',$autohighg10),
	('10 15 $match',$autohighgt10),
	('10 16 $match',$autoshortg10),
	('10 17 $match',$autoshortgt10),
	('10 18 $match',$automove10),
	
	

	('11 01 $match',$highg11),
	('11 02 $match',$highgt11),
	('11 03 $match',$shortg11),
	('11 04 $match',$shortgt11),
	('11 05 $match',$trussg11),
	('11 06 $match',$trusst11),
	('11 07 $match',$trusshpa11),
	('11 08 $match',$trusshpb11),
	('11 09 $match',$hloady11),
	('11 10 $match',$hloadn11),
	('11 11 $match',$dblock11),
	('11 12 $match',$dhit11),
	('11 13 $match',$assist11),
	('11 14 $match',$autohighg11),
	('11 15 $match',$autohighgt11),
	('11 16 $match',$autoshortg11),
	('11 17 $match',$autoshortgt11),
	('11 18 $match',$automove11),
	
	

	('12 01 $match',$highg12),
	('12 02 $match',$highgt12),
	('12 03 $match',$shortg12),
	('12 04 $match',$shortgt12),
	('12 05 $match',$trussg12),
	('12 06 $match',$trusst12),
	('12 07 $match',$trusshpa12),
	('12 08 $match',$trusshpb12),
	('12 09 $match',$hloady12),
	('12 10 $match',$hloadn12),
	('12 11 $match',$dblock12),
	('12 12 $match',$dhit12),
	('12 13 $match',$assist12),
	('12 14 $match',$autohighg12),
	('12 15 $match',$autohighgt12),
	('12 16 $match',$autoshortg12),
	('12 17 $match',$autoshortgt12),
	('12 18 $match',$automove12),
	
	

	('13 01 $match',$highg13),
	('13 02 $match',$highgt13),
	('13 03 $match',$shortg13),
	('13 04 $match',$shortgt13),
	('13 05 $match',$trussg13),
	('13 06 $match',$trusst13),
	('13 07 $match',$trusshpa13),
	('13 08 $match',$trusshpb13),
	('13 09 $match',$hloady13),
	('13 10 $match',$hloadn13),
	('13 11 $match',$dblock13),
	('13 12 $match',$dhit13),
	('13 13 $match',$assist13),
	('13 14 $match',$autohighg13),
	('13 15 $match',$autohighgt13),
	('13 16 $match',$autoshortg13),
	('13 17 $match',$autoshortgt13),
	('13 18 $match',$automove13),
	
	

	('14 01 $match',$highg14),
	('14 02 $match',$highgt14),
	('14 03 $match',$shortg14),
	('14 04 $match',$shortgt14),
	('14 05 $match',$trussg14),
	('14 06 $match',$trusst14),
	('14 07 $match',$trusshpa14),
	('14 08 $match',$trusshpb14),
	('14 09 $match',$hloady14),
	('14 10 $match',$hloadn14),
	('14 11 $match',$dblock14),
	('14 12 $match',$dhit14),
	('14 13 $match',$assist14),
	('14 14 $match',$autohighg14),
	('14 15 $match',$autohighgt14),
	('14 16 $match',$autoshortg14),
	('14 17 $match',$autoshortgt14),
	('14 18 $match',$automove14),
	
	

	('15 01 $match',$highg15),
	('15 02 $match',$highgt15),
	('15 03 $match',$shortg15),
	('15 04 $match',$shortgt15),
	('15 05 $match',$trussg15),
	('15 06 $match',$trusst15),
	('15 07 $match',$trusshpa15),
	('15 08 $match',$trusshpb15),
	('15 09 $match',$hloady15),
	('15 10 $match',$hloadn15),
	('15 11 $match',$dblock15),
	('15 12 $match',$dhit15),
	('15 13 $match',$assist15),
	('15 14 $match',$autohighg15),
	('15 15 $match',$autohighgt15),
	('15 16 $match',$autoshortg15),
	('15 17 $match',$autoshortgt15),
	('15 18 $match',$automove15)") /*or die(mysql_error())*/;
	
	echo "<br />";
echo time();
echo "15";
	
	
	}
}
//foreach ($_POST as $key => $value){
    
		//mysqli_query($con,"INSERT INTO Data (team, id, number)
		//VALUES ('$team','$key', $value)");
		

		$sql = "SELECT data FROM _$team";
$result = mysqli_query($con, $sql) /* or die(mysql_error())*/;

//$type = $data = array();
$column = "";
while($row = mysqli_fetch_assoc($result)) {
    //$type[] = $row['type'];
    //$data[] = $row['data'];
    $column .= $row['data'] . ",";
		//echo($row['data']);
		
}												// echo "$column";
		//echoarray "$result";
		//vardump(mysqli_fetch_assoc($result))
		//foreach($result as $value) {
    //echo $row['data'];
				// }
//}


	


echo "<br />";
echo time();
echo "end";

// auto go back to scouting interface
//header('Location: ' . $_SERVER['HTTP_REFERER']);
exit;