
<?
session_start();
	 global $scode;
       
		 $linkID = mysql_connect("localhost", "root", "zangtang");
         mysql_select_db("SciPark");
		 $today =  date("Y-m-d"); 



function findexts ($filename) 
{ 
$filename = strtolower($filename) ; 
$exts = split("[/\\.]", $filename) ; 
$n = count($exts)-1; 
$exts = $exts[$n]; 
return $exts; 
} 

//------------------------------------------------------------------------------------------------------------------------------------
//                                  VERIFY FORM FUNCTION
//---------------------------------------------------------------------------------------------------------------------------------------


function VerifyForm(&$values, &$errors)
{

   if (htmlentities($values['EventList']) == "Select")  $errors['EventList'] = "Event Name Required"; 


//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ FILE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
	 $_SESSION['uploads'] = "1";

 $EventCode = htmlentities($values['EventList']); // echo "--->".$EventCode."<---";
 
 if($EventCode != "Select") 
	{
		 $uploaddir = "uploads/PEPhotos/".$EventCode."/"; // echo $newDir;  
		 if (!file_exists($uploaddir) && !is_dir($uploaddir))
			mkdir($uploaddir, 0777, true);	
		 

	}

		$files = glob($uploaddir."/Img*.*");
		$Cnt = count($files); //print_r($Cnt);

//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
	 
	$PEPhoto1File = $_SESSION['PEPhoto1File']; 
	$Code = $_SESSION['Code'] ;  

	 

	if($PEPhoto1File != "Up")
	 {
	
    $extA = findexts ($_FILES['PEPhoto1']['name']); 
    if($extA != "")
	 {    

	   	if($extA != "jpg"  && $extA != "jpeg"  && $extA != "png") { $errors['PEPhoto1'] = "Image : Only Jpg/Jpeg//Png format allowed"; }
		else
		 {
			//echo ($_FILES['PEPhoto1']['size']);
			if(($_FILES['PEPhoto1']['size']) < 8388608)
			{
				
					
				$Cnt++; 
				
		 	    $tnameA = "Img".$Cnt."."; 
				$filenameA  = $tnameA.$extA; $StoreName = $filenameA.",";
			    $uploadfileA = $uploaddir.$filenameA; 

		 
			   if(move_uploaded_file($_FILES['PEPhoto1']['tmp_name'], $uploadfileA)) 
				   {
						chmod($uploadfileA, 0644);
						$_SESSION['PEPhoto1File'] = "Up";
						$_SESSION['PEPhoto1'] = $filenameA; 
						$_SESSION["UpCount"]++; //Total file upload count for images..must be more than 1

				 if($Cntr=="1" ) $query1 = "UPDATE EventsInfo set `Event_Image` = '$StoreName'  where `EventNo` = '$EventCode'"; 
				 else $query1 = "UPDATE EventsInfo set `Event_Image` = CONCAT(Event_Image, '$StoreName')  where `EventNo` = '$EventCode'"; //echo $query1;

				 $result1 = mysql_db_query("SciPark", $query1) or die ("could not query1" . mysql_error());

					}
				else {  $errors['PEPhoto1'] = "There was an error uploading the file, please try again!. File size must limit to 20MB.";  } 
			 } else  {  $errors['PEPhoto1'] = "File Size is more than 8MB"; }
	  } //else close
	 } //Extn Blanck close 
  } //UP close
	
  //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
	$PEPhoto2File = $_SESSION['PEPhoto2File']; 

if($PEPhoto2File != "Up")
   {
    $extB = findexts ($_FILES['PEPhoto2']['name']); 
    if($extB != "")
	 {    

	   	if($extB != "jpg"  && $extB != "jpeg"  && $extB != "png") { $errors['PEPhoto2'] = "Image : Only Jpg/Png format allowed"; }
		else
		 {
			echo ($_FILES['PEPhoto2']['size']);
			if(($_FILES['PEPhoto2']['size']) < 8388608)
			{
				
					
				$Cnt++; 
				
		 	    $tnameB = "Img".$Cnt."."; 
				$filenameB  = $tnameB.$extB; $StoreName = $filenameB.",";
			    $uploadfileB = $uploaddir.$filenameB; 

		 
			   if(move_uploaded_file($_FILES['PEPhoto2']['tmp_name'], $uploadfileB)) 
				   {
						chmod($uploadfileB, 0644);
						$_SESSION['PEPhoto2File'] = "Up";
						$_SESSION['PEPhoto2'] = $filenameB; 
						$_SESSION["UpCount"]++; //Total file upload count for images..must be more than 1

				 if($Cntr=="1" ) $query1 = "UPDATE EventsInfo set `Event_Image` = '$StoreName'  where `EventNo` = '$EventCode'"; 
				 else $query1 = "UPDATE EventsInfo set `Event_Image` = CONCAT(Event_Image, '$StoreName')  where `EventNo` = '$EventCode'"; //echo $query1;

				 $result1 = mysql_db_query("SciPark", $query1) or die ("could not query1" . mysql_error());

					}
				else {  $errors['PEPhoto2'] = "There was an error uploading the file, please try again!. File size must limit to 20MB.";  } 
			 } else  {  $errors['PEPhoto2'] = "File Size is more than 8MB"; }
	  } //else close
	 } //Extn Blanck close 
  } //UP close

//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
$PEPhoto3File = $_SESSION['PEPhoto3File']; 

if($PEPhoto3File != "Up")
   {
    $extC = findexts ($_FILES['PEPhoto3']['name']); 
    if($extC != "")
	 {    

	   	if($extC != "jpg"  && $extC != "jpeg"  &&  $extC != "png") { $errors['PEPhoto3'] = "Image : Only Jpg/Png format allowed"; }
		else
		 {
			//echo ($_FILES['PEPhoto3']['size']);
			if(($_FILES['PEPhoto3']['size']) < 8388608)
			{
				
					
				$Cnt++; 
				
		 	    $tnameC = "Img".$Cnt."."; 
				$filenameC  = $tnameC.$extC; $StoreName = $filenameC.",";
			    $uploadfileC = $uploaddir.$filenameC; 

		 
			   if(move_uploaded_file($_FILES['PEPhoto3']['tmp_name'], $uploadfileC)) 
				   {
						chmod($uploadfileC, 0644);
						$_SESSION['PEPhoto3File'] = "Up";
						$_SESSION['PEPhoto3'] = $filenameC; 
						$_SESSION["UpCount"]++; //Total file upload count for images..must be more than 1

				 if($Cntr=="1" ) $query1 = "UPDATE EventsInfo set `Event_Image` = '$StoreName'  where `EventNo` = '$EventCode'"; 
				 else $query1 = "UPDATE EventsInfo set `Event_Image` = CONCAT(Event_Image, '$StoreName')  where `EventNo` = '$EventCode'"; //echo $query1;

				 $result1 = mysql_db_query("SciPark", $query1) or die ("could not query1" . mysql_error());

					}
				else {  $errors['PEPhoto3'] = "There was an error uploading the file, please try again!. File size must limit to 20MB.";  } 
			 } else  {  $errors['PEPhoto3'] = "File Size is more than 8MB"; }
	  } //else close
	 } //Extn Blanck close 
  } //UP close

//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

if($_SESSION['PEPhoto4File'] != "Up")
   {
    $extD = findexts ($_FILES['PEPhoto4']['name']); 
    if($extD != "")
	 {    

	   	if($extD != "jpg"  && $extD != "jpg"  &&  $extD != "png") { $errors['PEPhoto4'] = "Image : Only Jpg/Png format allowed"; }
		else
		 {
			//echo ($_FILES['PEPhoto3']['size']);
			if(($_FILES['PEPhoto4']['size']) < 8388608)
			{
				
					
				$Cnt++; 
				
		 	    $tnameD = "Img".$Cnt."."; 
				$filenameD  = $tnameD.$extD; $StoreName = $filenameD.",";
			    $uploadfileD = $uploaddir.$filenameD; 

		 
			   if(move_uploaded_file($_FILES['PEPhoto4']['tmp_name'], $uploadfileD)) 
				   {
						chmod($uploadfileD, 0644);
						$_SESSION['PEPhoto4File'] = "Up";
						$_SESSION['PEPhoto4'] = $filenameD; 
						$_SESSION["UpCount"]++; //Total file upload count for images..must be more than 1

				 if($Cntr=="1" ) $query1 = "UPDATE EventsInfo set `Event_Image` = '$StoreName'  where `EventNo` = '$EventCode'"; 
				 else $query1 = "UPDATE EventsInfo set `Event_Image` = CONCAT(Event_Image, '$StoreName')  where `EventNo` = '$EventCode'"; //echo $query1;

				 $result1 = mysql_db_query("SciPark", $query1) or die ("could not query1" . mysql_error());

					}
				else {  $errors['PEPhoto4'] = "There was an error uploading the file, please try again!. File size must limit to 20MB.";  } 
			 } else  {  $errors['PEPhoto4'] = "File Size is more than 8MB"; }
	  } //else close
	 } //Extn Blanck close 
  } //UP close
  //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
$Photo5 = $_SESSION['PEPhoto5File']; 

if($Photo5 != "Up")
   {
    $extE = findexts ($_FILES['PEPhoto5']['name']); 
    if($extE != "")
	 {    

	   	if($extE != "jpg"  && $extE != "jpg"  && $extE != "png") { $errors['PEPhoto5'] = "Image : Only Jpg/Png format allowed"; }
		else
		 {
			//echo ($_FILES['PEPhoto3']['size']);
			if(($_FILES['PEPhoto5']['size']) < 8388608)
			{
				
					
				$Cnt++; 
				
		 	    $tnameE = "Img".$Cnt."."; 
				$filenameE  = $tnameE.$extE; $StoreName = $filenameE.",";
			    $uploadfileE = $uploaddir.$filenameE; 

		 
			   if(move_uploaded_file($_FILES['PEPhoto5']['tmp_name'], $uploadfileE)) 
				   {
						chmod($uploadfileE, 0644);
						$_SESSION['PEPhoto5File'] = "Up";
						$_SESSION['PEPhoto5'] = $filenameE; 
						$_SESSION["UpCount"]++; //Total file upload count for images..must be more than 1

				 if($Cntr=="1" ) $query1 = "UPDATE EventsInfo set `Event_Image` = '$StoreName'  where `EventNo` = '$EventCode'"; 
				 else $query1 = "UPDATE EventsInfo set `Event_Image` = CONCAT(Event_Image, '$StoreName')  where `EventNo` = '$EventCode'"; //echo $query1;

				 $result1 = mysql_db_query("SciPark", $query1) or die ("could not query1" . mysql_error());

					}
				else {  $errors['PEPhoto5'] = "There was an error uploading the file, please try again!. File size must limit to 20MB.";  } 
			 } else  {  $errors['PEPhoto5'] = "File Size is more than 8MB"; }
	  } //else close
	 } //Extn Blanck close 
  } //UP close
 //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  if($_SESSION["UpCount"] == "" OR $_SESSION["UpCount"] == 0) { $errors['PEPhoto1'] = "Atleast One Image file has to be uploaded"; }

//print_r($errors);
return (count($errors) == 0);
}




//---------------------------------------------------------------------------------------------------------------------------------------
//                                                             DISPLAY FORM FUNCTION
//---------------------------------------------------------------------------------------------------------------------------------------

function outputOptionList($list, $selected)
{

	foreach ($list as $item)
		echo "<option value=\"{$item['Value']}\"" . ($item['Value'] === $selected ? " selected=\"selected\"" : '') . ">{$item['Text']}</option>\n";
}


function DisplayForm($values, $errors)
{ 
//	$chars = "abcdefghijkmnopqrstuvwxyz023456789"; $i=0;

	$d=date(d);
	$m=date(F);
	$n=date(n);
	$y=date(Y);
    $today =  date("Y-m-d"); 
	
    ?>
<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>SCIENCE PARK UNIVERSITY OF PUNE</title>
</head>

<body background="images/bg2.jpg" topmargin="0" leftmargin="0">

<div align="center">
	<table border="0" width="100%" height="58" cellspacing="0" cellpadding="0">
		<tr>
			<td width="10%" bgcolor="#FFFFFF">
			<p align="right">
			<img border="0" src="images/logo.png" width="123" height="122"></td>
			<td bgcolor="#FFFFFF">
			<p align="center"><u><b>
			<font face="Verdana" size="6" color="#007575">Admin Panel of Science 
			Park</font></b></u></td>
		</tr><tr><td colspan='2'><hr></td></tr>
	</table>

</div>
<div align="center">
	<p align="left">&nbsp;&nbsp;&nbsp;
	<a href="AdminPage.php"><font face="Verdana" color="Blue"><b><u>Home</font></a></u></p>


	
		<form method="POST" name="AddRLBF" action="" enctype="multipart/form-data">

		<div align="center">
			<table border="0" width="80%" cellspacing="0" cellpadding="0">
				<tr>
					<td align="center" width="33%"><p align="center"><img border="0" src="images/events_Top.png" width="100%" height="81"></td>
					<td align="center" width="34%"><font face="arial" size="5" color="#003E3E"><b>Add Photos to Past Events</b></font></td>
					<td align="center" width="33%"><img border="0" src="images/events_Top.png" width="100%" height="81"></td><td width="4">&nbsp;</td>
					<td width="5">&nbsp;</td>
				</tr>
			</table>



	
			<div align="center">
			<table border="0" width="60%" cellpadding="0" bordercolor="#C0C0C0" cellspacing="0">
			<tr><td width="100%" align="center" colspan="2"><font face="Verdana" style="font-size: 3pt">&nbsp;</font></td></tr>
			<tr><td  width="30%">&nbsp;<b>Event Name : </td><td width="70%">
				
		<select  name="EventList" onchange="this.form.submit()">
		<option value="Select">Select</option>

<?   $EvList = array(); $EvRPList=array(); $EvBFList = array();

        $query = "SELECT * FROM `EventsInfo` WHERE `BatchEndDate` < '$today' AND `Tag`='A' order by `BatchEndDate` DESC"; echo $query;
		$result = mysql_db_query("SciPark", $query) or die ("could not query" . mysql_error());
		$tung=mysql_affected_rows();
		
	    while($r = mysql_fetch_array($result))
		{

				$EventCnt = $r["EventNo"];  $_SESSION['Code'] = $EventCnt; 
				$EventName = $r["EventName"];
				$BatchStartDate = $r["BatchStartDate"]; 
				$BatchEndDate = $r["BatchEndDate"];
				$RPLink = $r["RPLink"]; 
				$BatchFullTag = $r["BatchFullTag"]; 
				
				$EvRPList[$EventCnt] = "$RPLink";  $EvBFList[$EventCnt] = "$BatchFullTag"; $EvList[$EventCnt] = "$EventName"."(".$BatchStartDate.")";  

				$BatchStart = date("M jS, Y", strtotime($BatchStartDate));
				$BatchEnd = date("M jS, Y", strtotime($BatchEndDate));

				
				
				if($BatchStartDate == $BatchEndDate) { $BatchDate = " (".$BatchStart.")"; } 
				else { $BatchDate = " (".$BatchStart." - ".$BatchEnd.")"; }

					?>
				<option value="" <? if(htmlentities($values['EventList']) == $EventCnt)  { echo "selected";}?> ></option>

<?		}             ?> 
		</select><FONT COLOR=#FF0000 Face="Comic Sans MS" size='2'><b>&nbsp;</b></font></td></tr>
	
		<tr><td width="100%" align="center" colspan="2"><font face="Verdana" style="font-size: 3pt">&nbsp;</font></td></tr>

<?  
	$_SESSION["EvList"] = $EvList;
	
    $PEPhoto1File =  $_SESSION['PEPhoto1File'];
    if($PEPhoto1File != "Up")
		 { 
			$Photo1 =  $_SESSION['Photo1'];       			?>

			<tr><td width="30%"  align="left"><b><font face="Verdana" color="#FF0000"> Upload Photo 1 : &nbsp;</font></b></td>
			<td width="70%" >
			<input type="file" name="PEPhoto1" size="30"><font face="Verdana" size="2" color="#FFFF00">
			<span style="background-color: #CF3C15"></b></td></tr>
		<? }
 ?> 
	
	  <tr><td width="100%" align="center" colspan="2"><font face="Verdana" style="font-size: 3pt">&nbsp;</font></td></tr>
	  <?
	  $PEPhoto2File =  $_SESSION['PEPhoto2File'];
	  if($PEPhoto2File != "Up")
		 { 
			$Photo2 =  $_SESSION['Photo2'];       			?>

			<tr><td width="30%"  align="left"><b><font face="Verdana" color="#FF0000"> Upload Photo 2 : &nbsp;</font></b></td>
			<td width="70%" >
			<input type="file" name="PEPhoto2" size="30"><font face="Verdana" size="2" color="#FFFF00">
			<span style="background-color: #CF3C15"></b></td></tr>
		<? } ?>
	

		  <tr><td width="100%" align="center" colspan="2"><font face="Verdana" style="font-size: 3pt">&nbsp;</font></td></tr>

<?    $PEPhoto3File =  $_SESSION['PEPhoto3File'];
	   if($PEPhoto3File != "Up")
		 { 
			$Photo3 =  $_SESSION['Photo3'];       			?>

			<tr><td width="30%"  align="left"><b><font face="Verdana" color="#FF0000"> Upload Photo 3 : &nbsp;</font></b></td>
			<td width="70%" >
			<input type="file" name="PEPhoto3" size="30"><font face="Verdana" size="2" color="#FFFF00">
			<span style="background-color: #CF3C15"></b></td></tr>
		<? } ?> 
	<tr><td width="100%" align="center" colspan="2"><font face="Verdana" style="font-size: 3pt">&nbsp;</font></td></tr>

<?    $PEPhoto4File =  $_SESSION['PEPhoto4File'];
	   if($PEPhoto4File != "Up")
		 { 
			$Photo4 =  $_SESSION['Photo4'];       			?>

			<tr><td width="30%"  align="left"><b><font face="Verdana" color="#FF0000"> Upload Photo 4 : &nbsp;</font></b></td><td width="70%" >
			<input type="file" name="PEPhoto4" size="30"><font face="Verdana" size="2" color="#FFFF00">
			<span style="background-color: #CF3C15"></b></td></tr>
		<? } ?> 
	<tr><td width="100%" align="center" colspan="2"><font face="Verdana" style="font-size: 3pt">&nbsp;</font></td></tr>

	<?    $PEPhoto5File =  $_SESSION['PEPhoto5File'];
	   if($PEPhoto5File != "Up")
		 { 
			$Photo5 =  $_SESSION['Photo5'];       			?>

			<tr><td width="30%"  align="left"><b><font face="Verdana" color="#FF0000"> Upload Photo 5 : &nbsp;</font></b></td><td width="70%" >
			<input type="file" name="PEPhoto5" size="30"><font face="Verdana" size="2" color="#FFFF00">
			<span style="background-color: #CF3C15"></b></td></tr>
		<? } ?> 
	<tr><td width="100%" align="center" colspan="2"><font face="Verdana" style="font-size: 3pt">&nbsp;</font></td></tr>

	<tr><td width="100%" align="center" colspan="4"><input type="submit" value="Submit" name="AddPastPhotos">&nbsp;&nbsp;&nbsp;&nbsp;<input type="reset" value="Reset" name="B2"></td></tr>

 
</form><p>&nbsp;</p>


	
		</body>
		</html>
<?
 }// Display Form 

//---------------------------------------------------------------------------------------------------------------------------------------
//                                                       PROCESS FORM FUNCTION
//---------------------------------------------------------------------------------------------------------------------------------------


function ProcessForm($values)
{ 
	$login = $_SESSION['login'] ; 
	unset($_SESSION["PEPhoto1File"]); 
	unset($_SESSION["PEPhoto2File"]); 
	unset($_SESSION["PEPhoto3File"]);  	
	unset($_SESSION["PEPhoto4File"]); 
	unset($_SESSION["PEPhoto5File"]); 
	unset($_SESSION["uploads"]);

	header( 'Location: EventsPhotoAdded.php' ) ;
    //    $query2 = "UPDATE FormLogin SET ptr = '2' where login='$login' ";
   //	 	$result1 = mysql_db_query("SciPark", $query2) or die ("could not query" . mysql_error());
}
//---------------------------------------------------------------------------------------------------------------------------------------
	$login = $_SESSION['AdminLogin'] ; 

     $linkID = mysql_connect("localhost", "webuser", "zangtang");
     mysql_select_db("SciPark");

	 $query0 = "SELECT * FROM AdminLogin WHERE `AdminLogin`='$login'";
     $result0 = mysql_db_query("SciPark", $query0) or die ("could not query" . mysql_error());
     $tung0=mysql_affected_rows();
     $i=0; $j=0;				 

 if(isset($_SESSION['AdminLogin']))
  { 
    if($tung0)
	  {

		if($_SERVER['REQUEST_METHOD'] == "POST")
		 {
			$formValues = $_POST;
			$formErrors = array();    			//echo "the errors are :".$formValues."--".$Sname;

		 if(isset($_POST["AddPastPhotos"]))
			{ 
			  if(!VerifyForm($formValues, $formErrors)) 	  
				  DisplayForm($formValues, $formErrors); 
			else
			 {  
				$EventNo = $_POST["EventList"]; $_SESSION["EventNo"] = $EventNo;
				$PEPhoto1File =  $_SESSION['PEPhoto1File']; 
				$PEPhoto2File =  $_SESSION['PEPhoto2File']; 
				$PEPhoto3File =  $_SESSION['PEPhoto3File']; 
				$PEPhoto4File =  $_SESSION['PEPhoto4File']; 
				$PEPhoto5File =  $_SESSION['PEPhoto5File']; 
		
			 if(count($formErrors)== 0 && ($PEPhoto1File == "Up" ||  $PEPhoto2File == "Up" || $PEPhoto3File == "Up" || $PEPhoto4File == "Up" ||  $PEPhoto5File == "Up"))
				  {
						//ProcessForm($formValues);
			//			header( 'Location: EventsPhotoAdded.php' ) ;
				  }
				else
				  {
					  echo "<P ALIGN=center> <FONT COLOR=#354422 Face=Tahoma size='4'><B>ERROR. Please Re-Upload the Files. </b></font></p>";
				   }
			ProcessForm($formValues);
	         } //else close
		 } // if 
		 else 
		 { 
		     $formValues = $_POST;	$formErrors = array();
			 DisplayForm($formValues, $formErrors);  
		 }
	 } 
	  else
		{
		  DisplayForm(null, null); //echo "here1"; //
		}
	
 
	  } //tung
	  } //Admin Set
   else 
   {
     header( 'Location: Access_Denied.html' ) ;
    } 
?></pre>