D:\host\scoreman.in\kleague2026\autoapprove.php
<?php
include('dbconnect.php');
$username = $_SESSION['username'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Application Update</title>
</head>
<body>
<div style="z-index: 9999;top: 125;position: fixed;background-color:pink;">
<form action="autoapprove.php" method="POST">
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
echo 'App No : <input type="text" value="'.$_POST["appnos"].'" name="appnos"/>';
}
else if($_SERVER['REQUEST_METHOD'] == 'GET')
{
echo 'App No : <input type="text" value="'.$_GET["appno"].'" name="appnos"/>';
}
else
{
echo 'App No : <input type="text" name="appnos"/>';
}
?>
<input type="submit" value="Get Info" name="Get"/>
Comments : <input type="text" value="" size="40" name="comment"/>
<?php
$username = $_SESSION['username'];
if($username=="secretary-pu")
{
echo '<input type="submit" value="Approve" name="Approve"/>';
}
?>
<input type="submit" value="Submit For Correction" name="Hold"/>
<input type="submit" value="Delete" name="Delete"/>
</form>
</div>
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST' || $_SERVER['REQUEST_METHOD'] == 'GET')
{
$clubcode="%".$username."%";
if($username=="secretary")
{
$clubcode="%";
}
//echo "<br/><br/><br/>DT:".$clubcode;
$appno=$_POST["appnos"];
$comments=$_POST["comment"];
if($_POST["Approve"])
{
if($username=="secretary")
{
$databaseQuery = 'UPDATE applications SET status="Approved",comments="'.$con->real_escape_string($comments).'" where (appno= "'.$con->real_escape_string($appno).'") and (club like "'.$con->real_escape_string($clubcode).'")';
$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
if($result && mysqli_affected_rows()==1)
{
echo "<br/>App No ".$appno." Approved";
}
}
}
else if($_POST["Hold"])
{
$databaseQuery = 'UPDATE applications SET status="Held",comments="'.$con->real_escape_string($comments).'" where (appno= "'.$con->real_escape_string($appno).'") and (club like "'.$con->real_escape_string($clubcode).'")';
// echo $databaseQuery;
$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
if($result && mysqli_affected_rows()==1)
{
echo "<br/>App No ".$appno." set Hold";
}
}
else if($_POST["Delete"])
{
$databaseQuery = 'UPDATE applications SET status="Delete",comments="'.$con->real_escape_string($comments).'" where (appno= "'.$con->real_escape_string($appno).'") and (club like "'.$con->real_escape_string($clubcode).'")';
$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
if($result && mysqli_affected_rows()==1)
{
echo "<br/>App No ".$appno." Marked for Deletion";
}
}
if($_GET["appno"])
{
$appno=$_GET["appno"];
}
if($_GET["Received"])
{
echo $_GET["Received"];
if($username=="secretary-pu")
{
$databaseQuery = 'UPDATE applications SET status="Received",comments="'.$con->real_escape_string($comments).'" where (appno= "'.$con->real_escape_string($appno).'") and (club like "'.$con->real_escape_string($clubcode).'")';
$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
if($result && mysqli_affected_rows()==1)
{
echo "<br/>App No ".$appno." Received";
}
}
}
if($appno!=null && $appno!="")
{
$databaseQuery = 'SELECT * FROM applications where (appno= "'.$con->real_escape_string($appno).'")';
$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
if(mysqli_num_rows($result)>0)
{
$row = mysqli_fetch_array($result);
if($_SESSION['username'] !="secretary-pu")
{
if(trim($row["club"]) != $_SESSION['username'])
{
echo "<br/><br/>Please dont try to open other distirct participant details.";
exit();
}
}
echo "<br/><br/>App No ".$appno." Loaded";
echo "<br/>Status ".$row["status"];
echo "<br/>Comments ".$row["comments"];
//echo '<input type="hidden" value="'.$row["club"].'" name="clubcode"/>';
$appno=trim($row["appno"]);
$sname=trim($row["sname"]);
$tnrsaid=trim($row["tnrsaid"]);
$dob=trim($row["dob"]);
$age=trim($row["age"]);
$ag=trim($row["agegroup"]);
$gender=trim($row["gender"]);
$club=trim($row["club"]);
$fathername=trim($row["fathername"]);
$address=trim($row["address"]);
$city=trim($row["city"]);
$pin=trim($row["pin"]);
$phone=trim($row["phone"]);
$email=trim($row["email"]);
$blood=trim($row["bloodgroup"]);
$photourl=trim($row["photourl"]);
$nodob="";
$doburl=trim($row["doburl"]);
if($doburl=='NA')
{
$nodob="true";
}
$rink1=trim($row["rink1"]);
$rink2=trim($row["rink2"]);
$rink2a=trim($row["rink2a"]);
$road1=trim($row["road1"]);
$rink3=trim($row["rink3"]);
$rink4=trim($row["rink4"]);
$rink5=trim($row["rink5"]);
$road2=trim($row["road2"]);
$p2p=trim($row["p2p"]);
$elim=trim($row["elim"]);
$relay=trim($row["relay"]);
$marathon=trim($row["marathon"]);
$figure=trim($row["figure"]);
$free=trim($row["free"]);
$combined=trim($row["combined"]);
$pair=trim($row["pair"]);
$inlinefree=trim($row["inlinefree"]);
$solodance=trim($row["solodance"]);
$pairdance=trim($row["pairdance"]);
$quadhockey=trim($row["quadhockey"]);
$inlinehockey=trim($row["inlinehockey"]);
$freestyle=trim($row["freestyle"]);
echo '<center>';
echo '<table width="680px" border="1" cellspacing="0" cellpadding="0" style="text-align:left; font-family:verdana;font-size:14px; border:1px solid black;">';
?>
<tr>
<td colspan="3" style="font-size:18px; text-align:center;"></td></tr>
<?php
echo '<tr><td width="120px">Application No :</td> <td width="422px;"><strong>'.$appno.'</strong></td><td rowspan="10"><center>
<a href="'.$photourl.'">View Photo </a></center></td></tr>';
echo '<tr><td>Name :</td> <td style="text-align:left; font-family:verdana;font-size:16px;" ><strong>'.$sname.'</strong></td></tr>';
if($tnrsaid)
{
echo '<tr><td>TNRSA ID :</td> <td>'.$tnrsaid.'</td></tr>';
}
else
{
echo '<tr><td>TNRSA ID :</td> <td>NA</td></tr>';
}
echo '<tr><td>Date of Birth :</td> <td><strong>'.$dob.'</strong></td></tr>';
echo '<tr><td>Age : '.$age.' </td> <td>Age Group : '.$ag.' (as on 01-01-2014)</td></tr>';
echo '<tr><td>Gender :</td> <td>'.$gender.'</td></tr>';
echo '<tr><td>District</td> <td><strong>'.$club.'</strong></td></tr>';
echo '<tr><td>Blood Group :</td> <td>'.$blood.'</td></tr>';
echo '<tr><td>Father Name :</td> <td>'.$fathername.'</td></tr>';
echo '<tr><td>Phone & Email :</td> <td>'.$phone.' '.$email.'</td></tr>';
echo '<tr><td>Address :</td><td colspan="3">'.$address.' '.$city.' '.$pin.'</td></tr>';
echo '<tr><td colspan="3"><strong>Participation Details</strong> </td></tr>';
echo '<tr><td><strong>Speed-Quad</strong> </td><td colspan="2">';
//echo $rink1;
if($rink1=='true')
{
echo ' Rink I, ';
}
if($rink2=='true')
{
echo ' Rink II, ';
}
if($rink2a=='true')
{
echo ' Rink II A, ';
}
if($road1=='true')
{
echo ' Road I ';
}
if($rink1!='true' && $rink2!='true' && $rink2a!='true' && $road1!='true')
{
echo 'NA';
}
echo '</td></tr>';
echo '<tr><td><strong>Speed-Inline</strong> </td><td colspan="2">';
if($rink3=='true')
{
echo ' Rink III, ';
}
if($rink4=='true')
{
echo ' Rink IV, ';
}
if($rink5=='true')
{
echo ' Rink V, ';
}
if($road2=='true')
{
echo ' Road II, ';
}
if($p2p=='true')
{
echo ' Point to Point, ';
}
if($elim=='true')
{
echo ' Elimination, ';
}
if($relay=='true')
{
echo ' Relay ';
}
if($marathon=='true')
{
echo ' Marathon ';
}
if($rink3!='true' && $rink4!='true' && $rink5!='true' && $road2!='true' && $p2p!='true' && $elim!='true' && $relay!='true')
{
echo ' NA ';
}
echo '</td></tr>';
echo '<tr><td><strong>Artistic</strong> </td><td colspan="2">';
if($figure=='true')
{
echo ' Figure, ';
}
if($free=='true')
{
echo ' Free, ';
}
if($combined=='true')
{
echo ' Combined, ';
}
if($pair=='true')
{
echo ' Pair, ';
}
if($inlinefree=='true')
{
echo ' InlineFree, ';
}
if($solodance=='true')
{
echo ' SoloDance, ';
}
if($pairdance=='true')
{
echo ' PairDance ';
}
if($figure!='true' && $free!='true' && $combined!='true' && $pair!='true' && $inlinefree!='true' && $solodance!='true' && $pairdance!='true')
{
echo ' NA ';
}
echo '</td></tr>';
echo '<tr><td><strong>FreeStyle</strong> </td><td colspan="2">';
if($freestyle=='true')
{
echo ' FreeStyle ';
}
else
{
echo ' NA ';
}
echo '</td></tr>';
echo '<tr><td><strong>Hockey</strong> </td><td colspan="2">';
if($quadhockey=='true')
{
echo ' Quad Hockey ,';
}
if($inlinehockey=='true')
{
echo ' Inline Hockey ';
}
if($quadhockey!='true' && $inlinehockey!='true')
{
echo ' NA ';
}
echo '</td></tr>';
echo '<tr><td colspan="3">';
?>
<p style="font-size:10px; text-align:justify;">
<?php
echo '</td></tr>';
echo '</table>';
echo '<br/>';
//echo $doburl;
if($doburl!='NA')
{
//echo '<img style="width:620px; " src="'.$doburl.'"/>';
echo '<a href="'.$doburl.'" target="_blank"> View DOB Proof </a>';
}
else
{
echo 'DOB not available';
}
echo '</center>';
}
else
{
echo "<br/><br/>App No ".$appno." Not Found";
}
}
else
{
echo "<br/><br/>Please Enter Correct App No";
}
}
?>
</body>
</html>