<?php
include('dbconnect.php');
 
set_time_limit (120);
?>

<?php
//check login
$username = $_SESSION['username'];
/*
if($username)
{
	////$dtcode=$username;
}
else
{
////echo "Please Login ";
////echo '<a href="index.php">Click Here</a>';
////exit();
//header("Location:index.html");

}
*/

if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
	
	$skatertype=$_POST["skatertype"];
	$skatertypersfi=$_POST["skatertypersfi"];
	$gender=$_POST["gender"];
	$age=$_POST["age"];
//echo "Stype ".$skatertypersfi;


	$dispres="check";

if($skatertypersfi==$skatertype)
{
	$dispres="OK";
}

if(($skatertypersfi=="Inline-Alpine" || $skatertypersfi=="Inline-Downhill") && ($skatertype=="Inline-Alpine" || $skatertype=="Inline-Downhill" || $skatertype=="Alpine-Downhill"))
	{
	$dispres="OK";
}


//echo $dispres;
//return;
if($dispres=="OK")
{

// @mysqli_close();
// @mysqli_connect("localhost", "indiaska_regn", "df34@#@#fsadfq#$%^") or die ('I cant connect');
// 	$databaseQuery = 'use 59thnationals';
// 	$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
// 	session_start();
	//
	//include('dbconnect.php');
}
else
{
	if($username!="secretary" )
{
	// if($age>12)
	// {
	// echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"NOT SAVED. DISCIPLINE CHANGE NOT ALLOWED.'.$skatertypersfi.$skatertype.'"}';
	// return;	
	// }
	
}
}

if($username!="secretary" )
{

	//if(	$skatertype=="Artistic" || $skatertype=="Inline Freestyle")
	//{
//echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"NOT SAVED. REGISTRATION CLOSED."}';
 //return;
	//}

$repdistrict=$_POST["repdistrict"];


if($repdistrict=="Chengalpattu" ||$repdistrict=="Kallakurichi"  ||$repdistrict=="Mayiladuthurai" ||$repdistrict=="Ranipet" ||$repdistrict=="Tenkasi" ||$repdistrict=="Tirupathur" || $repdistrict=="SELECT DISTRICT"  )
	{


		echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"NOT SAVED. PLEASE SELECT CORRECT DISTRICT"}';
 		return;
	}

// if($repdistrict=="Coimbatore" && $skatertype!="Roller-Hockey" && $skatertype!="Inline-Hockey")
// 	{
// 		echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"NOT SAVED. ENTRY CLOSED."}';
//  		return;
// 	}
if($skatertype=="Roller-Derby" && $gender=="Male" && $age<12)
	{

		echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.$age.'","message":"NOT SAVED. EVENT NOT APPLICABLE.'.$age.'"}';
 		return;
	}


// if($repdistrict=="Madurai" && $skatertype!="Roller-Derby" && $skatertype!="Inline-Hockey" && $skatertype!="Roller-Hockey" )
// 	{
// 		echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"NOT SAVED. REGISTRATION CLOSED FOR YOUR DISTRICT."}';
//  		return;
// 	}
// if($repdistrict=="Dindigul" && $skatertype=="Artistic" )
// 	{
// 		echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"NOT SAVED. REGISTRATION CLOSED FOR YOUR DISTRICT."}';
//  		return;
// 	}

	$databaseQuery = 'SELECT * FROM `championships` WHERE `district`="'.$con->real_escape_string($repdistrict).'"';

	$result3 = mysqli_query($con,$databaseQuery) or die('Query failed 1: ' . mysqli_error());
		while($row = mysqli_fetch_array($result3))
  {
	   $stat=trim($row["status"]);

	  if($stat=="Closed" && $_SESSION["usertype"]!="District" && $_SESSION["usertype"]!="Admin")
	   {
	  	echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"NOT SAVED. REGISTRATION IS CLOSED."}';
 		return;
	   }
	   else if($stat=="NotOpen" || $stat==NULL)
	   {
	   	echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"NOT SAVED. REGISTRATION IS NOT OPEN FOR YOUR DISTRICT. PLEASE CONTACT YOUR DISTRICT UNIT OR CLUB."}';
 		return;
	   }

	   }


}


$mode=$_POST["mode"];


$rsfiidno=$_POST["rsfiappno"];

	// $databaseQuery = 'SELECT * FROM `applications` WHERE `skaterid`="'.$con->real_escape_string($rsfiidno).'" and status <> "Delete" and order_status="Success"';

	// $result3 = mysqli_query($con,$databaseQuery) or die('Query failed 2: ' . mysqli_error());

// if($mode!="edit")
// {
// 	if($_SESSION["usertype"]!="District" && $_SESSION["usertype"]!="Admin" )
// 	{
		

// 	}
// }
 $stypes="";
// while($row = mysqli_fetch_array($result3))
//   {
//   	  $stypes=trim($row["skatertype"]);

//   	  // if(($stypes=="Speed-Quad" || $stypes=="Speed-Inline"  || $stypes=="Roller-Hockey"  || $stypes=="Inline-Hockey")  && $mode!="edit")
//   	  // {
//   	  // 			echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"NOT SAVED. SKATER ALREADY REGISTERED IN '.$stypes.' CONTACT YOUR DISTRICT FOR ANY CORRECTIONS or REPRINT OF APPLICATION."}';
//   	  // 			return;
//   	  // }

//   	  // if(($stypes=="Inline-Alpine" || $stypes!="Inline-Downhill" || $stypes!="Inline-Freestyle" || $stypes!="Skateboarding" || $stypes!="Roller-Freestyle" ||  $stypes!="Roller-Scooter" ||  $stypes!="Roller-Derby" ) && ($skatertype=="Speed-Quad" || $skatertype=="Speed-Inline"  || $skatertype=="Roller-Hockey"  || $skatertype=="Inline-Hockey")   && $mode!="edit")
//   	  // {
//   	  // 		echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"NOT SAVED. SKATER ALREADY REGISTERED IN '.$stypes.' CONTACT YOUR DISTRICT FOR ANY CORRECTIONS or REPRINT OF APPLICATION."}';
//   	  // 			return;
//   	  // }

//   	  if(mysqli_num_rows($result3) >0 && $mode!="edit")
// {
// 	echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"NOT SAVED. SKATER ALREADY REGISTERED IN '.$stypes.' "}';
//  		return;
// }

// // if(mysqli_num_rows($result3) >0 && $mode!="edit" && $age<12)
// // {
// // 	echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"NOT SAVED. SKATER ALREADY REGISTERED. CONTACT YOUR DISTRICT FOR ANY CORRECTIONS or REPRINT OF APPLICATION."}';
// //  		return;
// // }

//   }


// if(mysqli_num_rows($result3) >1 && $mode!="edit" && ($skatertype!="Inline-Alpine" && $skatertype!="Inline-Downhill" && $skatertype!="Inline-Freestyle" && $skatertype!="Skateboarding" && $skatertype!="Roller-Freestyle" &&  $skatertype!="Roller-Scooter" &&  $skatertype!="Roller-Derby" ) && ($stypes=="Speed-Quad" || $stypes=="Speed-Inline"  || $stypes=="Roller-Hockey"  || $stypes=="Inline-Hockey") && $age>12)
// 		{
// 			echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"NOT SAVED. SKATER ALREADY REGISTERED IN '.$stypes.' CONTACT YOUR DISTRICT FOR ANY CORRECTIONS or REPRINT OF APPLICATION."}';
//  		return;
// 		}


	// if(mysqli_num_rows($result3) >0 && $username!="secretary" && $_SESSION["usertype"]!="District" && $mode!="edit" )
	// {

		
	// }


//var_dump($_POST);
//print_r($_FILES);

//echo $_SERVER['CONTENT_LENGTH'];


	//echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"UNDER MAINTENANCE. PLEASE CHECK AFTER 1Hr."}';
	//return;

$appno=$_POST["applno"];


$sname=$_POST["sname"];
$skaterid=$_POST["rsfiappno"]; //old stateref
$dob=$_POST["dob"];
//$dob=substr($dob,8,2)."-".substr($dob,5,2)."-".substr($dob,0,4);
 $dob=$_POST["dobdate"]."-".$_POST["dobmonth"]."-".$_POST["dobyear"];

$age=$_POST["age"];
$ag=$_POST["ag"];
$agorder=$_POST["agorder"];


$gender=$_POST["gender"];
//$club=$username;
//$club=$_POST["clubname"];

$club=$_POST["repdistrict"];


if($club=="")
{
	echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"Please select Team / District."}';
	return;
}

//echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"Please select Team / District."}';
//	return;

$fathername=$_POST["fathername"];
$address=$_POST["address"];
$address2=$_POST["address2"];
$city=$_POST["city"];
$pin=$_POST["pin"];
$phone=$_POST["phone"];
$email=$_POST["email"];
$blood=$_POST["blood"];

$skatertype=$_POST["skatertype"];

$school=$_POST["school"];
$syllabus=$_POST["syllabus"];

$clubname=$_POST["clubname"];
$occupation=$_POST["occupation"];

$parentoccupation=$_POST["parentoccupation"];

$photodata=$_POST["photo-data"];
$dobdata=$_POST["dob-data"];
$otdata=$_POST["ot-data"];

$residingstate=$_POST["residingstate"];
$residingdistrict=$_POST["residingdistrict"];
$repstate=$_POST["repstate"];
$repdistrict=$_POST["repdistrict"];

$setpassword=$_POST["newpassword"];

$aadhaarpass=$_POST["aadhaarpass"];

$target_dir = "uploads/";
$target_file = $target_dir .time().basename($_FILES["dobfile"]["name"]);
$uploadOk = 0;
$dobFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));

$fee=0;

// Check if image file is a actual image or fake image

// while(file_exists($target_file))
// {
// 	$target_file = $target_dir .time().basename($_FILES["dobfile"]["name"]);
// }


// if($target_file) {
   
//     if($dobFileType == "pdf" || $dobFileType == "jpg" || $dobFileType == "jpeg") {
//        // echo "File is an image - " . $check["mime"] . ".";
// 	 if(move_uploaded_file($_FILES['dobfile']['tmp_name'], $target_file))
//  {
//         $uploadOk = 1;
//  }
//  else
//  {
// 	  $uploadOk = 0;
//  }
//     } else {
//       //  echo "File is not an image.";
//         $uploadOk = 0;
//     }
// }

// if($uploadOk==0)
// {
// 	//error
	
// 	if($mode!="edit" && $mode!="new1")
// 	{
// 		echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"DOB Proof upload failed. Try Again."}';

// 			return;
// 	}

// }
// $dobdata=$target_file;

$dobdata="";

/*($dobdata=="")
{
	echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"Please select DOB Proof."}';
	return;
}

if($otdata=="")
{
	echo '{"status":"error","appno":"'.$appno.'","name":"'.$sname.'","message":"Please select Oath Form."}';
	return;
}
*/


//echo $dobdata;

/*$nodob=$_POST["nodob"];
if($nodob!="true")
{
$doburl="dobproof/dob-".$appno.".jpg";
}
else
{
	$doburl="NA";
}*/

$adjrink1=$_POST["tenrace1"];
$adjrink2=$_POST["tenrace2"];
$adjrink3=$_POST["adjrink3"];

$u8race1q=$_POST["u8race1q"];
$u8race2q=$_POST["u8race2q"];

$u8race1i=$_POST["u8race1i"];
$u8race2i=$_POST["u8race2i"];


$rink1=$_POST["rink1"];
$rink2=$_POST["rink2"];

$road1=$_POST["road1"];
$road2=$_POST["road2"];

$rink3=$_POST["rink3"];
$rink4=$_POST["rink4"];

$rink5=$_POST["rink5"];
$rink6=$_POST["rink6"];
$rink7=$_POST["rink7"];

$p2p=$_POST["p2p"];
$elim=$_POST["elim"];

$road3=$_POST["road3"];
$road4=$_POST["road4"];
$road5=$_POST["road5"];

$p2prd=$_POST["p2prd"];
$elimrd=$_POST["elimrd"];

$relay=$_POST["relay"];
$mixedrelay="";
$mixedrelay=$_POST["mixedrelay"];


$marathon=$_POST["marathon"];


$figure=$_POST["figure"];
$free=$_POST["free"];
$combined=$_POST["combined"];

$pair=$_POST["pair"];
$pairpartnername=$_POST["pairpartnername"];
$pairpartnerag=$_POST["pairpartnerag"];


$inlinefree=$_POST["inlinefree"];
$solodance=$_POST["solodance"];

$coupledance=$_POST["coupledance"];
$coupledancepartnername=$_POST["coupledancepartnername"];
$coupledancepartnerag=$_POST["coupledancepartnerag"];

$quartet=$_POST["quartet"];


$quadhockey=$_POST["rollerhockey1"];
$inlinehockey=$_POST["inlinehockey1"];
$mixedrollerhockey="";
$mixedrollerhockey=$_POST["mixedrollerhockey"];

$hockeyplayertype=$_POST["hockeyplayertype"];
$jerseyno=$_POST["jerseyno"];

$classicslalom=$_POST["classicslalom"];
$speedslalom=$_POST["speedslalom"];
$pairslalom="";
$pairslalom=$_POST["pairslalom"];


$alpine=$_POST["alpine"];
$downhill=$_POST["downhill"];
$rollerderby=$_POST["rollerderby"];
$rollerfreestyle=$_POST["rollerfreestyle"];
$skateboarding=$_POST["skateboarding"];
$precisionskating=$_POST["precision"];
$showgroup=$_POST["showgroup"];

$scooter="";
$skatecross="";

$regstatus=$_POST["regstatus"];

$otherdiscipline="";

/*if($quadhockey=="on" || $inlinehockey=="on")
{
	echo "Not Saved. Registration closed for HOCKEY. ";
	goto end;
}*/

if($skatertype=="Inline-Alpine")
{
	$alpine="P";
}

if($skatertype=="Inline-Downhill")
{
	$downhill="P";
}

if($skatertype=="Alpine-Downhill")
{
		$alpine="P";
	$downhill="P";
}


if($skatertype=="Roller-Derby")
{
	$rollerderby="P";
}
if($skatertype=="Roller-Freestyle")
{
	$rollerfreestyle="P";
}
if($skatertype=="Skateboarding")
{
	$skateboarding="P";
}
if($skatertype=="Roller-Scooter")
{
	$scooter="P";
}
if($skatertype=="Skatecross")
{
	$scooter="P";
}

if($skatertype=="Adjustable-Quad")
{
	$adjrink1="P";
}

if($skatertype=="Adjustable-Inline")
{
	$adjrink2="P";
}

//fee calculation
if($skatertype=="Speed-Quad" || $skatertype=="Speed-Inline" )
{
	$fee=700;
	if($relay=="P")
	{
		$fee=$fee+700;
	}

	if($mixedrelay=="P")
	{
		$fee=$fee+700;
	}

}
else if($skatertype=="Artistic")
{
$fee=700;
if($inlinefree=="P")
	{
		$fee=$fee+700;
	}

	if($pair=="P")
	{
		$fee=$fee+700;
	}

	if($coupledance=="P")
	{
		$fee=$fee+700;
	}
	if($quartet=="P")
	{
		$fee=$fee+700;
	}
	if($quartet=="P")
	{
		$fee=$fee+700;
	}
		if($precisionskating=="P")
	{
		$fee=$fee+700;
	}
		if($showgroup=="P")
	{
		$fee=$fee+700;
	}
}
else if($skatertype=="Roller-Hockey" || $skatertype=="Inline-Hockey")
{
	$fee=700;
}
else if($skatertype=="Inline-Freestyle")
{
	$fee=0;
	if($speedslalom=="P")
	{
	$fee=$fee+700;
	}
	if($classicslalom=="P")
	{
	$fee=$fee+700;
	}
	if($pairslalom=="P")
	{
	$fee=$fee+700;
	}
}
else if($skatertype=="Skateboarding")
{
	$fee=700;
}
else if($skatertype=="Roller-Freestyle" || $skatertype=="Inline-Alpine"||  $skatertype=="Roller-Scooter" || $skatertype=="Inline-Downhill"|| $skatertype=="Inline-Freestyle" || $skatertype=="Roller-Derby" || $skatertype=="Adjustable-Quad" || $skatertype=="Adjustable-Inline")
{
	$fee=700;
}
else if($skatertype=="Alpine-Downhill")
{
	$fee=1400;
}

if($alpine=="P" || $downhill=="P" || $rollerderby=="P" || $rollerfreestyle=="P"|| $skateboarding=="P" || $scooter=="P" )
{
	$otherdiscipline="P";
	if($skatertype=="")
	{
		$skatertype="OtherDiscipline";
	}
}


$photourl=$_POST["photourl"];

/*if($photodata!=null)
{
//$photourl = $_POST["skaterid"];
	
$photourl="photos/".$sname.$dob.".png";
	//if( file_exists($photourl) )
	//	unlink($photourl);
	
	$fp = fopen($photourl, 'w');
	
	//fwrite($fp, base64_decode($photodata) );
	
	// $decoded = urldecode($photodata);
	 
	 $exp = explode(',', $photodata);

    //we just get the last element with array_pop
    $base64 = array_pop($exp);

    //decode the image and finally save it
    $data = base64_decode($base64);
	//echo '<html><img src="'.$photodata.'"/></html>';
	fwrite($fp,$data);
	fclose($fp);
//echo "photo saved";

}

if($dobdata!=null && $nodob!="true")
{
//$photourl = $_POST["skaterid"];
	

	if( file_exists($dobourl) )
		unlink($doburl);
	
	$fp = fopen($doburl, 'w');
	
	fwrite($fp, base64_decode($dobdata) );
	fclose($fp);
//echo "dob saved";

} */


$databaseQuery ="";
if($mode=="edit")
{
//$databaseQuery = 'UPDATE applications SET sname="'.$con->real_escape_string($sname).'", dob="'.$con->real_escape_string($dob).'", age="'.$con->real_escape_string($age).'", agegroup="'.$con->real_escape_string($ag).'", gender="'.$con->real_escape_string($gender).'", club="'.$con->real_escape_string($club).'", fathername="'.$con->real_escape_string($fathername).'", address="'.$con->real_escape_string($address).'", city="'.$con->real_escape_string($city).'", pin="'.$con->real_escape_string($pin).'", phone="'.$con->real_escape_string($phone).'", email="'.$con->real_escape_string($email).'", bloodgroup="'.$con->real_escape_string($blood).'", photourl="'.$con->real_escape_string($photodata).'", doburl="'.$con->real_escape_string($dobdata).'",rink1="'.$con->real_escape_string($rink1).'", rink2="'.$con->real_escape_string($rink2).'", rink3="'.$con->real_escape_string($rink3).'", road1="'.$con->real_escape_string($road1).'", rink4="'.$con->real_escape_string($rink4).'", rink5="'.$con->real_escape_string($rink5).'", rink6="'.$con->real_escape_string($rink6).'", road2="'.$con->real_escape_string($road2).'", p2p="'.$con->real_escape_string($p2p).'", elim="'.$con->real_escape_string($elim).'",elimrd="'.$con->real_escape_string($elimrd).'", relay="'.$con->real_escape_string($relay).'",marathon="'.$con->real_escape_string($marathon).'", figure="'.$con->real_escape_string($figure).'", free="'.$con->real_escape_string($free).'", combined="'.$con->real_escape_string($combined).'", pair="'.$con->real_escape_string($pair).'", inlinefree="'.$con->real_escape_string($inlinefree).'", solodance="'.$con->real_escape_string($solodance).'", pairdance="'.$con->real_escape_string($pairdance).'", quadhockey="'.$con->real_escape_string($quadhockey).'", inlinehockey="'.$con->real_escape_string($inlinehockey).'", classicslalom="'.$con->real_escape_string($classicslalom).'", speedslalom="'.$con->real_escape_string($speedslalom).'",school="'.$con->real_escape_string($school).'",parentoccupation="'.$con->real_escape_string($parentoccupation).'",adjrink1="'.$con->real_escape_string($adjrink1).'",adjrink2="'.$con->real_escape_string($adjrink2).'",adjrink3="'.$con->real_escape_string($adjrink3).'",clubname="'.$con->real_escape_string($clubname).'",skatertype="'.$con->real_escape_string($skatertype).'",agorder="'.$con->real_escape_string($agorder).'",race100="'.$con->real_escape_string($race100).'",u8race1="'.$con->real_escape_string($u8race1).'",u8race2="'.$con->real_escape_string($u8race2).'",alpine="'.$con->real_escape_string($alpine).'",downhill="'.$con->real_escape_string($downhill).'",rollerderby="'.$con->real_escape_string($rollerderby).'",rollerfreestyle="'.$con->real_escape_string($rollerfreestyle).'",skateboarding="'.$con->real_escape_string($skateboarding).'",otherdiscipline="'.$con->real_escape_string($otherdiscipline).'" where appno="'.$appno.'"';


$databaseQuery = 'UPDATE applications SET skaterid="'.$con->real_escape_string($skaterid).'",sname="'.$con->real_escape_string($sname).'",dob="'.$con->real_escape_string($dob).'",age="'.$con->real_escape_string($age).'",agegroup="'.$con->real_escape_string($ag).'",gender="'.$con->real_escape_string($gender).'",club="'.$con->real_escape_string($club).'",fathername="'.$con->real_escape_string($fathername).'",address="'.$con->real_escape_string($address).'",city="'.$con->real_escape_string($city).'",pin="'.$con->real_escape_string($pin).'",phone="'.$con->real_escape_string($phone).'",email="'.$con->real_escape_string($email).'",bloodgroup="'.$con->real_escape_string($blood).'",photourl="'.$con->real_escape_string($photodata).'",doburl="'.$con->real_escape_string($dobdata).'",rink1="'.$con->real_escape_string($rink1).'",rink2="'.$con->real_escape_string($rink2).'",road1="'.$con->real_escape_string($road1).'",road2="'.$con->real_escape_string($road2).'",rink3="'.$con->real_escape_string($rink3).'",rink4="'.$con->real_escape_string($rink4).'",rink5="'.$con->real_escape_string($rink5).'",rink6="'.$con->real_escape_string($rink6).'",rink7="'.$con->real_escape_string($rink7).'",p2p="'.$con->real_escape_string($p2p).'",elim="'.$con->real_escape_string($elim).'",relay="'.$con->real_escape_string($relay).'",mixedrelay="'.$con->real_escape_string($mixedrelay).'",road3="'.$con->real_escape_string($road3).'",road4="'.$con->real_escape_string($road4).'",road5="'.$con->real_escape_string($road5).'",p2prd="'.$con->real_escape_string($p2prd).'",elimrd="'.$con->real_escape_string($elimrd).'",marathon="'.$con->real_escape_string($marathon).'",figure="'.$con->real_escape_string($figure).'",free="'.$con->real_escape_string($free).'",pair="'.$con->real_escape_string($pair).'",pairpartnername="'.$con->real_escape_string($pairpartnername).'",pairpartnerag="'.$con->real_escape_string($pairpartnerag).'",inlinefree="'.$con->real_escape_string($inlinefree).'",quartet="'.$con->real_escape_string($quartet).'",solodance="'.$con->real_escape_string($solodance).'",pairdance="'.$con->real_escape_string($coupledance).'",coupledancepartnername="'.$con->real_escape_string($coupledancepartnername).'",coupledancepartnerag="'.$con->real_escape_string($coupledancepartnerag).'",quadhockey="'.$con->real_escape_string($quadhockey).'",mixedrollerhockey="'.$con->real_escape_string($mixedrollerhockey).'",inlinehockey="'.$con->real_escape_string($inlinehockey).'",hockeyplayertype="'.$con->real_escape_string($hockeyplayertype).'",jerseyno="'.$con->real_escape_string($jerseyno).'",classicslalom="'.$con->real_escape_string($classicslalom).'",speedslalom="'.$con->real_escape_string($speedslalom).'",pairslalom="'.$con->real_escape_string($pairslalom).'",status="'.$con->real_escape_string($status).'",comments="'.$con->real_escape_string($comments).'",school="'.$con->real_escape_string($school).'",syllabus="'.$con->real_escape_string($syllabus).'",parentoccupation="'.$con->real_escape_string($parentoccupation).'",adjrink1="'.$con->real_escape_string($adjrink1).'",adjrink2="'.$con->real_escape_string($adjrink2).'",adjrink3="'.$con->real_escape_string($adjrink3).'",clubname="'.$con->real_escape_string($clubname).'",skatertype="'.$con->real_escape_string($skatertype).'",agorder="'.$con->real_escape_string($agorder).'",u8race1q="'.$con->real_escape_string($u8race1q).'",u8race2q="'.$con->real_escape_string($u8race2q).'",u8race1i="'.$con->real_escape_string($u8race1i).'",u8race2i="'.$con->real_escape_string($u8race2i).'",otherdiscipline="'.$con->real_escape_string($otherdiscipline).'",alpine="'.$con->real_escape_string($alpine).'",downhill="'.$con->real_escape_string($downhill).'",rollerderby="'.$con->real_escape_string($rollerderby).'",rollerfreestylepark="'.$con->real_escape_string($rollerfreestyle).'",rollerfreestylestreet="'.$con->real_escape_string($rollerfreestyle).'",skateboardingpark="'.$con->real_escape_string($skateboarding).'",skateboardingstreet="'.$con->real_escape_string($skateboarding).'",scooterpark="'.$con->real_escape_string($scooter).'",scooterstreet="'.$con->real_escape_string($scooter).'",precisionskating="'.$con->real_escape_string($precisionskating).'",showgroup="'.$con->real_escape_string($showgroup).'",regstatus="'.$con->real_escape_string($regstatus).'",oturl="'.$con->real_escape_string($otdata).'",address2="'.$con->real_escape_string($address2).'",residingstate="'.$con->real_escape_string($residingstate).'",residingdistrict="'.$con->real_escape_string($residingdistrict).'",repstate="'.$con->real_escape_string($repstate).'",repdistrict="'.$con->real_escape_string($repdistrict).'",setpassword="'.$con->real_escape_string($setpassword).'",aadhaarpass="'.$con->real_escape_string($aadhaarpass).'",fees="'.$con->real_escape_string($fee).'" where appno="'.$appno.'"';
}
else
{
	

 $databaseQuery = 'INSERT INTO applications(skaterid, sname, dob, age, agegroup, gender, club, fathername, address,address2,residingstate,residingdistrict,repstate,repdistrict, city, pin, phone, email, bloodgroup, photourl, doburl, rink1, rink2, road1, road2, rink3, rink4, rink5, rink6,rink7, p2p, elim, relay,mixedrelay, road3, road4,road5, p2prd, elimrd, marathon,figure, free, pair, pairpartnername, pairpartnerag, inlinefree, solodance, pairdance, coupledancepartnername, coupledancepartnerag, quadhockey, mixedrollerhockey, inlinehockey, hockeyplayertype, jerseyno, classicslalom, speedslalom,pairslalom, status, comments, school, syllabus, parentoccupation, adjrink1, adjrink2, adjrink3, clubname, skatertype, agorder, u8race1q, u8race2q, u8race1i, u8race2i, otherdiscipline, alpine, downhill, rollerderby, rollerfreestylepark,rollerfreestylestreet, skateboardingpark, skateboardingstreet, scooterpark, scooterstreet, precisionskating, showgroup, quartet, regstatus,oturl,setpassword,aadhaarpass,fees,hashcode,order_status) 
 VALUES ("'.$con->real_escape_string($skaterid).'","'.$con->real_escape_string($sname).'","'.$con->real_escape_string($dob).'","'.$con->real_escape_string($age).'","'.$con->real_escape_string($ag).'","'.$con->real_escape_string($gender).'","'.$con->real_escape_string($club).'","'.$con->real_escape_string($fathername).'","'.$con->real_escape_string($address).'","'.$con->real_escape_string($address2).'","'.$con->real_escape_string($residingstate).'","'.$con->real_escape_string($residingdistrict).'","'.$con->real_escape_string($repstate).'","'.$con->real_escape_string($repdistrict).'","'.$con->real_escape_string($city).'","'.$con->real_escape_string($pin).'","'.$con->real_escape_string($phone).'","'.$con->real_escape_string($email).'","'.$con->real_escape_string($blood).'","'.$con->real_escape_string($photodata).'","'.$con->real_escape_string($dobdata).'","'.$con->real_escape_string($rink1).'","'.$con->real_escape_string($rink2).'","'.$con->real_escape_string($road1).'","'.$con->real_escape_string($road2).'","'.$con->real_escape_string($rink3).'","'.$con->real_escape_string($rink4).'","'.$con->real_escape_string($rink5).'","'.$con->real_escape_string($rink6).'","'.$con->real_escape_string($rink7).'","'.$con->real_escape_string($p2p).'","'.$con->real_escape_string($elim).'","'.$con->real_escape_string($relay).'","'.$con->real_escape_string($mixedrelay).'","'.$con->real_escape_string($road3).'","'.$con->real_escape_string($road4).'","'.$con->real_escape_string($road5).'","'.$con->real_escape_string($p2prd).'","' .$con->real_escape_string($elimrd).'","'.$con->real_escape_string($marathon).'","'.$con->real_escape_string($figure).'","'.$con->real_escape_string($free).'","'.$con->real_escape_string($pair).'","' .$con->real_escape_string($pairpartnername).'","'.$con->real_escape_string($pairpartnerag).'","'.$con->real_escape_string($inlinefree).'","'.$con->real_escape_string($solodance).'","' .$con->real_escape_string($coupledance).'","'.$con->real_escape_string($coupledancepartnername).'","'.$con->real_escape_string($coupledancepartnerag).'","'.$con->real_escape_string($quadhockey).'","'.$con->real_escape_string($mixedrollerhockey).'","'.$con->real_escape_string($inlinehockey).'","'.$con->real_escape_string($hockeyplayertype).'","'.$con->real_escape_string($jerseyno).'","'.$con->real_escape_string($classicslalom).'","'.$con->real_escape_string($speedslalom).'","'.$con->real_escape_string($pairslalom).'","'.$con->real_escape_string($status).'","' .$con->real_escape_string($comments).'","' .$con->real_escape_string($school).'","'.$con->real_escape_string($syllabus).'","' .$con->real_escape_string($parentoccupation).'","'.$con->real_escape_string($adjrink1).'","' .$con->real_escape_string($adjrink2).'","' .$con->real_escape_string($adjrink3).'","'.$con->real_escape_string($clubname).'","'.$con->real_escape_string($skatertype).'","'.$con->real_escape_string($agorder).'","'.$con->real_escape_string($u8race1q).'","'.$con->real_escape_string($u8race2q).'","'.$con->real_escape_string($u8race1i).'","'  .$con->real_escape_string($u8race2i).'","'.$con->real_escape_string($otherdiscipline).'","'.$con->real_escape_string($alpine).'","'.$con->real_escape_string($downhill).'","'.$con->real_escape_string($rollerderby).'","'.$con->real_escape_string($rollerfreestyle).'","'.$con->real_escape_string($rollerfreestyle).'","'.$con->real_escape_string($skateboarding).'","'.$con->real_escape_string($skateboarding).'","'.$con->real_escape_string($scooter).'","'.$con->real_escape_string($scooter).'","'.$con->real_escape_string($precisionskating).'","'.$con->real_escape_string($showgroup).'","'.$con->real_escape_string($quartet).'","'.$con->real_escape_string($regstatus).'","'.$con->real_escape_string($otdata).'","'.$con->real_escape_string($setpassword).'","'.$con->real_escape_string($aadhaarpass).'","'.$fee.'","'.md5(time()).'","Success")';


}
//echo $databaseQuery;
//exit();
$result = mysqli_query($con,$databaseQuery) or die('Query failed 3: ' . mysqli_error());
  if($result)
  { 

if($mode!="edit")
{
	$appno=mysqli_insert_id($con);
}

///$payurl="http://".'indiaskate.com/online/checkout/?add-to-cart=174&billing_first_name='.$sname.'&billing_last_name='.$appno.'&billing_address_1='.$address.'&billing_address_2='.$address2.'&billing_city='.$city.'&billing_postcode='.$pin.'&billing_email='.$email.'&order_comments=App No.'.$appno.'&billing_phone='.$phone.'&billing_state='.$residingstate;


	    $bankacno="";

			     $bankifsc="";
			      $bankacname="";
			       $bankname="";

$databaseQuery1 = 'SELECT * FROM championships where district="'.$repdistrict.'"';
	$result3 = mysqli_query($con,$databaseQuery1) or die('Query failed 4: ' . mysqli_error());
		while($row = mysqli_fetch_array($result3))
  {


	    $bankacno=trim($row["bankacno"]);

			     $bankifsc=trim($row["bankifsc"]);
			      $bankacname=trim($row["bankacname"]);
			       $bankname=trim($row["bankname"]);
  	}


$feeamt=$fee;
// $payurl=rawurlencode("upi://pay?pa=".$bankacno."@".$bankifsc.".ifsc.npci&pn=".$bankacname."&am=".$feeamt."&tn=".$appno.$sname."&cu=INR");
// $upiurl="upi://pay?pa=".$bankacno."@".$bankifsc.".ifsc.npci&pn=".$bankacname."&am=".$feeamt."&tn=".$appno.$sname."&cu=INR";
 //header("Location: application.php?appno=".$appno);
// header("Location: ".$payurl);
 
 //echo 'Application Submitter Successfully.';

//echo '{"status":"success","appno":"'.$appno.'","name":"'.$sname.'","bankacno":"'.$bankacno.'","bankifsc":"'.$bankifsc.'","bankacname":"'.$bankacname.'","bankname":"'.$bankname.'","message":"has been saved successfully.<br/>","redirurl":"'.$payurl.'","upiurl":"'.$upiurl.'"}';
if($mode=="edit")
{
echo '{"status":"success","mode":"edit","appno":"'.$appno.'","fee":"'.$fee.'","name":"'.$sname.'","address":"'.$address ." ".$address2.'","city":"'.$city.'","pin":"'.$pin.'","phone":"'.$phone.'","email":"'.$email.'","state":"'.$residingstate.'","message":"has been updated successfully."}';
}
else
{
	echo '{"status":"success","mode":"new","appno":"'.$appno.'","fee":"'.$fee.'","name":"'.$sname.'","address":"'.$address ." ".$address2.'","city":"'.$city.'","pin":"'.$pin.'","phone":"'.$phone.'","email":"'.$email.'","state":"'.$residingstate.'","message":"has been saved successfully. <br/>"}';
}


//echo ' <meta HTTP-EQUIV="REFRESH" content="2; url='.$payurl.'">';
//echo '<a href="application.php?appno='.$appno.'">Click Here to Print Application</a>';
// echo ' <meta HTTP-EQUIV="REFRESH" content="5; url=Registration.php">';
 //echo '<br/><a href="Registration.php"><span style="background-color:lightblue; height:20px;" > Add New Entry</span></a> <br/>';
 // echo '<br/><a href="dashboard.php"><span style="background-color:lightblue; height:20px;" > Goto Dashboard</span></a> <br/>';
  }
  else
  {
   echo 'database error';
//	  goto ende;
  }


end:

echo $status;

/*
echo '<?xml version="1.0" encoding="iso-8859-1"?> ';
echo "<ret>";
echo "<result>";
echo "<appno>";
echo $appno;
echo "</appno>";
echo "<status>";
echo $status;
echo "</status>";
echo "</result>";
echo "</ret>";
*/

}
?>