Registration Complete real_escape_string($appno).'" AND sname= "'.$con->real_escape_string($name).'")'; $databaseQuery = 'SELECT * FROM applications where order_status="Success" and (appno= "'.$con->real_escape_string($appno).'") AND (hashcode= "'.$con->real_escape_string($name).'" or sname= "'.$con->real_escape_string($name).'")'; //echo $databaseQuery; $result = mysqli_query($con,$databaseQuery) or die('Query failed 1: ' . mysqli_error()); } if($result) { $rescnt= mysqli_num_rows($result); if($rescnt!=1) { echo '

Name / Application No. Not found. Try Again

'; echo ''; return; } $row = mysqli_fetch_array($result); /* if($_SESSION['username'] !="secretary") { if(trim($row["club"]) != $_SESSION['username']) { echo "

Please dont try to open other distirct participant details."; exit(); } }*/ $appno=trim($row["appno"]); $sname=trim($row["sname"]); $skaterid=trim($row["skaterid"]); $dob=trim($row["dob"]); $age=trim($row["age"]); $ag=trim($row["agegroup"]); $gender=trim($row["gender"]); //$club=trim($row["club"].",".$row["school"]); $school=$row["school"]; $club=trim($row["club"]); $clubname=trim($row["clubname"]); $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"]); $skatertype=trim($row["skatertype"]); $parentoccupation=trim($row["parentoccupation"]); $repdistrict=trim($row["repdistrict"]); $fees=trim($row["fees"]); $photourl=$row["photourl"]; $nodob=""; $doburl=$row["doburl"]; if($doburl=='NA') { $nodob="true"; } $adjrink1=trim($row["adjrink1"]);if($adjrink1=="P"){$adjrink1="Adjustable-Quad, ";}else{$adjrink1=" ";} $adjrink2=trim($row["adjrink2"]);if($adjrink2=="P"){$adjrink2="Adjustable-Inline, ";}else{$adjrink2=" ";} $adjrink3=trim($row["adjrink3"]);if($adjrink3=="P"){$adjrink3="Race-3, ";}else{$adjrink3=" ";} $u8race1q=trim($row["u8race1q"]);if($u8race1q=="P"){$u8race1q="Quad-Race-1, ";}else{$u8race1q=" ";} $u8race2q=trim($row["u8race2q"]);if($u8race2q=="P"){$u8race2q="Quad-Race-2, ";}else{$u8race2q=" ";} $u8race1i=trim($row["u8race1i"]);if($u8race1i=="P"){$u8race1i="Inline-Race-1, ";}else{$u8race1i=" ";} $u8race2i=trim($row["u8race2i"]);if($u8race2i=="P"){$u8race2i="Inline-Race-2, ";}else{$u8race2i=" ";} $under8=trim($u8race1q.$u8race2q.$u8race1i.$u8race2i); if($under8=="") { $under8="NA"; } $rink1=trim($row["rink1"]);if($rink1=="P"){$rink1="Rink - I (1 Lap [200M]), ";}else{$rink1=" ";} $rink2=trim($row["rink2"]);if($rink2=="P"){$rink2="Rink - II (2 Lap / 500+D), ";}else{$rink2=" ";} $rink3=trim($row["rink3"]);if($rink3=="P"){$rink3="Rink - III (3 Lap / 4 Lap / 1000 M), ";}else{$rink3=" ";} $road1=trim($row["road1"]);if($road1=="P"){$road1="Road - I (1 Lap), ";}else{$road1=" ";} $road2=trim($row["road2"]);if($road2=="P"){$road2="Road - II (1500 / 3000 M), ";}else{$road2=" ";} $quad=trim($rink1.$rink2.$rink3.$road1.$road2); if($quad=="") { $quad="NA"; } $rink4=trim($row["rink4"]);if($rink4=="P"){$rink4="Rink - IV (1 Lap [200M]), ";}else{$rink4=" ";} $rink5=trim($row["rink5"]);if($rink5=="P"){$rink5="Rink - V (500+D), ";}else{$rink5=" ";} $rink6=trim($row["rink6"]);if($rink6=="P"){$rink6="Rink - VI (1000 M), ";}else{$rink6=" ";} $rink7=trim($row["rink7"]);if($rink7=="P"){$rink7="Rink - VII DUAL TT(200 M), ";}else{$rink7=" ";} $road3=trim($row["road3"]);if($road3=="P"){$road3="Road - III (100 M), ";}else{$road3=" ";} $road4=trim($row["road4"]);if($road4=="P"){$road4="Road - IV (1 Lap), ";}else{$road4=" ";} $road5=trim($row["road5"]);if($road5=="P"){$road5="Road - V (3000 M), ";}else{$road5=" ";} $p2p=trim($row["p2p"]);if($p2p=="P"){$p2p="Points Track (5000 M), ";}else{$p2p=" ";} $elim=trim($row["elim"]);if($elim=="P"){$elim="Elimination - Rink (10000 M), ";}else{$elim=" ";} $p2prd=trim($row["p2prd"]);if($p2prd=="P"){$p2prd="Point to Point - Road (10000 M), ";}else{$p2prd=" ";} $elimrd=trim($row["elimrd"]);if($elimrd=="P"){$elimrd="Elimination - Road (15000 M), ";}else{$elimrd=" ";} $relay=trim($row["relay"]);if($relay=="P"){$relay="RELAY, ";}else{$relay=" ";} $mixedrelay=trim($row["mixedrelay"]);if($mixedrelay=="P"){$mixedrelay="MIXED RELAY, ";}else{$mixedrelay=" ";} $marathon=trim($row["marathon"]);if($marathon=="P"){$marathon="MARATHON, ";}else{$marathon=" ";} $inline=trim($rink4.$rink5.$rink6.$rink7.$p2p.$elim.$road3.$road4.$road5.$p2prd.$elimrd.$relay.$mixedrelay.$marathon); if($inline=="") { $inline="NA"; } $figure=trim($row["figure"]);if($figure=="P"){$figure="FIGURE, ";}else{$figure=" ";} $free=trim($row["free"]);if($free=="P"){$free="FREE, ";}else{$free=" ";} $combined=trim($row["combined"]);if($combined=="P"){$combined="COMBINED, ";}else{$combined=" ";} $pair=trim($row["pair"]);if($pair=="P"){$pair="PAIR, ";}else{$pair=" ";} $pairpartnername=trim($row["pairpartnername"]); $pairpartnerag=trim($row["pairpartnerag"]); $inlinefree=trim($row["inlinefree"]);if($inlinefree=="P"){$inlinefree="INLINE-FREE, ";}else{$inlinefree=" ";} $solodance=trim($row["solodance"]);if($solodance=="P"){$solodance="SOLODANCE, ";}else{$solodance=" ";} $pairdance=trim($row["pairdance"]);if($pairdance=="P"){$pairdance="COUPLE-DANCE, ";}else{$pairdance=" ";} $coupledancepartnername=trim($row["coupledancepartnername"]); $coupledancepartnerag=trim($row["coupledancepartnerag"]); $quartet=trim($row["quartet"]);if($quartet=="P"){$quartet="QUARTET, ";}else{$quartet=" ";} $precision=trim($row["precisionskating"]);if($precision=="P"){$precision="PRECISION, ";}else{$precision=" ";} $showgroup=trim($row["showgroup"]);if($showgroup=="P"){$showgroup="SHOWGROUP, ";}else{$showgroup=" ";} $artistic=trim($figure.$free.$combined.$pair.$inlinefree.$solodance.$pairdance.$quartet.$precision.$showgroup); if($artistic=="") { $artistic="NA"; } $quadhockey=trim($row["quadhockey"]);if($quadhockey=="P"){$quadhockey="ROLLER-HOCKEY, ";}else{$quadhockey=" ";} $inlinehockey=trim($row["inlinehockey"]);if($inlinehockey=="P"){$inlinehockey="INLINE-HOCKEY, ";}else{$inlinehockey=" ";} $mixedrollerhockey=trim($row["mixedrollerhockey"]);if($mixedrollerhockey=="P"){$mixedrollerhockey="MIXED-ROLLER-HOCKEY, ";}else{$mixedrollerhockey=" ";} $hockey=trim($quadhockey.$mixedrollerhockey.$inlinehockey); if($hockey=="") { $hockey="NA"; } $classicslalom=trim($row["classicslalom"]);if($classicslalom=="P"){$classicslalom="CLASSIC-SLALOM, ";}else{$classicslalom=" ";} $speedslalom=trim($row["speedslalom"]);if($speedslalom=="P"){$speedslalom="SPEED-SLALOM, ";}else{$speedslalom=" ";} $pairslalom=trim($row["pairslalom"]);if($pairslalom=="P"){$pairslalom="PAIR-SLALOM, ";}else{$pairslalom=" ";} $freestyle=trim($classicslalom.$speedslalom.$pairslalom); if($freestyle=="") { $freestyle="NA"; } $alpine=trim($row["alpine"]);if($alpine=="P"){$alpine="ALPINE, ";}else{$alpine=" ";} $downhill=trim($row["downhill"]);if($downhill=="P"){$downhill="DOWNHILL, ";}else{$downhill=" ";} $rollerderby=trim($row["rollerderby"]);if($rollerderby=="P"){$rollerderby="ROLLER-DERBY, ";}else{$rollerderby=" ";} $rollerfreestyle=trim($row["rollerfreestyle"]);if($rollerfreestyle=="P"){$rollerfreestyle="ROLLER-FREESTYLE, ";}else{$rollerfreestyle=" ";} $skateboarding=trim($row["skateboarding"]);if($skateboarding=="P"){$skateboarding="SKATEBOARDING, ";}else{$skateboarding=" ";} $rollerscooter=trim($row["scooter"]);if($rollerscooter=="P"){$rollerscooter="ROLLER-SCOOTER, ";}else{$rollerscooter=" ";} $other=trim($alpine.$downhill.$rollerderby.$rollerfreestyle.$skateboarding.$rollerscooter); if($other=="") { $other="NA"; } $order_status=$row["order_status"]; $order_id=$row["order_id"]; $tracking_id=$row["tracking_id"]; $payment_mode=$row["payment_mode"]; $trans_date=$row["trans_date"]; $amt=$row["fees"]; echo '
'; echo ''; $bankacno=""; $bankifsc=""; $bankacname=""; $bankname=""; $eventtitle=""; $eventdate=""; $contact=""; $databaseQuery = 'SELECT * FROM `championships` WHERE `district`="'.$con->real_escape_string($repdistrict).'"'; $result3 = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error()); while($row = mysqli_fetch_array($result3)) { $stat=trim($row["status"]); $bankacno=trim($row["bankacno"]); $bankifsc=trim($row["bankifsc"]); $bankacname=trim($row["bankacname"]); $bankname=trim($row["bankname"]); $eventtitle=trim($row["championshiptitle"]); $eventdate=trim($row["dates"]); $lastdate=trim($row["lastdate"]); $contact=trim($row["contact"]); } $feeamt=$fees; $payurl=rawurlencode("upi://pay?pa=".$bankacno."@".$bankifsc.".ifsc.npci&pn=".$bankacname."&am=".$feeamt."&tn=".$appno."&cu=INR"); ?> '; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; //echo ''; echo ''; //echo ''; //echo ''; //echo ''; //echo ''; echo ''; echo ''; echo ''; if($adjrink1!="" ||$adjrink2!="") { echo ''; } /*echo '';*/ //echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '

SKATER ENTRY FORM
Application No :'.$appno.'


Fee : Rs.'.$amt.'
Payment Status : '.$order_status.'
Order ID: '.$order_id.'
Tracking ID: '.$tracking_id.'
Mode: '.$payment_mode.'
Date: '.$trans_date.'
'; echo '
RSFI Annual Skater Registration Application No. :'.$skaterid.'
Name :'.$sname.'
Date of Birth :'.$dob.'
Age : '.$age.' '; echo ' , Age Group : '.$ag.' (as on 31-12-2025)
Gender :'.$gender.'
Team / Club :'.$club.' '.$clubname.'
School :'.$school.'
Blood Group :'.$blood.'
Father Name :'.$fathername.'
Phone & Email : '.$phone.' '.$email.'
Address, City, Phone & Email :As Entered Online.
City :'.$city.'
Phone :'.$phone.' '.$email.'
Address :'.$address.' '.$city.' '.$pin.'
Participation Details
'.$adjrink1.$adjrink2.' '; echo '
Adjustable '; //echo $rink1; if($adjrink1=='true') { echo ' Rink I, '; } if($adjrink2=='true') { echo ' Rink II, '; } if($adjrink2a=='true') { echo ' Rink II A, '; } if($adjrink1!='true' && $adjrink2!='true' && $adjrink2a!='true') { echo 'NA'; } echo '
Below 5 - Quad '; //echo $rink1; //echo $under8; //echo '
Speed-Quad '; //echo $rink1; echo $quad; echo '
Speed-Inline '; echo $inline; echo '
Artistic '; echo $artistic; echo '
Hockey '; echo $hockey; echo '
Inline-FreeStyle '; echo $freestyle; echo '
Other '; echo $other; echo '
'; ?>


Signature of Skater                                                                              Signature of Parent/Guardian

Seal & Signature of Secretary of the Club




Note:Copy of Online Entry Form, Copy of Annual Skaters Registration Form, Entry Fee, Annual Skaters Registration Fee & Original Date of Birth Certificate, to be submitted to District Roller Skating Association through club on or before the last date .

'; echo '
'; //echo $doburl; /*if($doburl!='NA') { echo ''; } */ echo '
'; echo'
'; } } ?>