One Hat Cyber Team

Your IP : 216.73.216.84

Server IP : 50.6.229.107

Server : Linux server.hostburly.com 5.14.0-611.38.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 10 17:21:28 EDT 2026 x86_64

Server Software : Apache

PHP Version : 8.2.30

Buat File | Buat Folder

Dir : ~/home/andjemzt/nportal.andjemztech.com/examAdmin/

Edit File: examlist2014s.php

$cat=$_POST['cat'];
$centre=$_POST['centres'];
$b=$_POST['branch'];

$q='';
if(!empty($cat)){
$q.="AND category='$cat'";	
}
if(!empty($centre)){
$q.="AND centre='$centre'";	
}
if(!empty($b)){
$q.="AND a.branch_id='$b'";	
}

$user_query=mysql_query("SELECT * FROM corp_mem a,corp_reg_pay b,clearance_status c WHERE a.stud_id=b.stud_id AND a.stud_id=c.stud_id AND b.status='Paid' AND c.dean_verify='1' AND c.branch_verify='1' AND c.ad_comm='1' AND c.dean_verify_date > '2014-07-31' $q  ORDER BY a.branch_id ASC,a.surname ASC");
$count=mysql_num_rows($user_query);
if(!$count){
	echo "No records found";
	exit;
	}
else{
?>

<table border="1" cellpadding="5" cellpadding="10" width="100%">
<tr><td>S/NO</td><td>FILE NO</td><td>NAMES</td><td>SEX</td><td>DATE OF BIRTH</td><td>QUALIFICATIONS</td><td>PLACE OF WORK</td><td>CATEGORY</td><td>PROPOSERS</td><td>AMOUNT PAID</td><td>STATUS</td><td>TEL. NO</td><td>EMAIL</td><td>BRANCH</td><td>EXAM CENTRE</td></tr>
<?
$sno=0;
while ($row=mysql_fetch_array($user_query)){
	$sno++;
	$name=ucwords(strtolower($row['othernames']))." ".strtoupper($row['surname']);
	//$name=ucwords($name);
	if($row['sex']=='Male')
	{
		$sex='M';
	}
	elseif($row['sex']=='Female')
	{
		$sex='F';
	}
	$dob=$row['dob'];
	$qualification=$row['qual']."-".GetAny("universities",$row['school'],"id","name").",-".$row['edu_city1']."-".$row['edu_state1'].",-".$row['grad_year'];
	//$position=$row['position'].",-".$row['work']."-".$row['work_city'].",-".GetAny("state",$row['work_state'],"stateid","state_name");
	$category=getCat($row['category']);
	$proposer=$row['proposer1']."-".$row['proposer2'];
	$amount=$row['amount']."-PAID";
	$phone=$row['phone'];
	$email=$row['email'];
	$branch=GetAny("branch",$row['branch_id'],"branchid","branch_name");
	
?>
<tr><td valign="top"><?=$sno?></td><td valign="top"><?=$row['file_no']?></td><td valign="top"><?=$name?></td><td valign="top"><?=$sex?></td><td valign="top"><?=$dob?></td><td valign="top"><?=ucwords(strtolower($row['qual']))?> <?=ucwords(strtolower(GetAny("universities",$row['school'],"id","name")))?>,<?=ucwords(strtolower($row['edu_city1']))?> <?=ucwords(strtolower($row['edu_city1']))?>,<?=ucwords(strtolower(GetAny("state",$row['edu_state1'],"stateid","State_name")))?> <?=$row['grad_year']?></td><td valign="top"><?=ucwords(strtolower($row['position']));?>, <?=ucwords(strtolower($row['work']))?>, <?=ucwords(strtolower($row['work_city']))?>,<?=GetAny("state",$row['work_state'],"stateid","state_name")?></td><td valign="top"><?=$category?></td><td valign="top"><?=$row['proposer1']?> <?=$row['proposer2']?></td><td valign="top"><?=number_format($row['amount'],2)?> </td><td valign="top">PAID</td><td valign="top"><?=$row['phone']?></td><td valign="top"><?=strtolower($row['email'])?></td><td valign="top"><?=$branch?></td><td valign="top"><?php echo GetAny('centres',$row['centre'],'id','name'); ?></td></tr>
<? } ?>
</table>
<? } ?>
<?
function getCat($id){
	switch ($id){
		case "1":
		return "A1";
		break;
		
		case "2":
		return "A2";
		break;
		
		case "3":
		return "B1";
		break;
		
		case "4":
		return "B2";
		break;
		
		case "5":
		return "C1";
		break;
		
		case "6":
		return "C2";
		break;
		
		}
	
	}
	
	function GetAny($table,$value,$field,$output){
		$sql=mysql_query("SELECT * FROM $table WHERE $field='$value'");
		$row=mysql_fetch_array($sql);
		return $row["$output"];
	}

?>