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/
View File Name : assignNo.php

<?php
include "inc/config.php";
$appType=$_GET['appType'];
$studID=$_GET['studID'];

//get last number
$g=mysql_query("SELECT * FROM members WHERE memberGrade='$appType' ORDER BY memberNo DESC LIMIT 0,1");
$r=mysql_fetch_array($g);
$lastNum=$r['memberNo'];

//generate new number
$newNumber=$lastNum+1;
//insert into members table
$query=mysql_query(returnQuery($appType,$studID));
$row=mysql_fetch_array($query);
if($appType==1){
	$memberName=$row['fellSurname']." ".$row['fellOthernames'];
	$memEmail=$row['fellEmail'];
	$memPhone=$row['fellPhone'];
	
	$dues=25000;
	$table='fellReg';
	$fieldID='fellID';
}
elseif($appType==2){
	$memberName=$row['memSurname']." ".$row['memOthernames'];
	$memEmail=$row['memEmail'];
	$memPhone=$row['memPhone'];
	$dues=20000;
	$table='memreg';
	$fieldID='memID';
}
elseif($appType==3){
	$memberName=$row['probSurname']." ".$row['probOthernames'];
	$memEmail=$row['probEmail'];
	$memPhone=$row['probPhone'];
	$dues=15000;
	$table='probReg';
	$fieldID='probID';
}
elseif($appType==4){
	$memberName=$row['techSurname']." ".$row['techOthernames'];
	$memEmail=$row['techEmail'];
	$memPhone=$row['techPhone'];
	$dues=10000;
	$table='techReg';
	$fieldID='techID';
}
elseif($appType==5){
	$memberName=$row['studSurname']." ".$row['studOthernames'];
	$memEmail=$row['studEmail'];
	$memPhone=$row['studPhone'];
	$dues=5000;
	$table='studentReg';
	$fieldID='studID';
}
$officer_id=$_SESSION['officer_id'];
$date=date('Y-m-d');
$insert=mysql_query("INSERT INTO members SET memberNo='$newNumber',  memberName='$memberName',memberGrade='$appType',memberRegDate='$date',memberEmail='$memEmail',memberPhone='$memPhone'");
if(!$insert){ echo mysql_error();}
else{
	//insert into dues;
	$dues=mysql_query("INSERT INTO dues SET memberNo='$newNumber',outstanding='$dues'");
//update clearance
$update=mysql_query("UPDATE clearance SET adminID='$officer_id',clearAssignNo='1' WHERE studID='$studID' AND appTypeID='$appType'");
//update application table with application number
$up=mysql_query("UPDATE $table SET memRegNo='$newNumber' WHERE $fieldID='$studID'");

//send election letter
$subject = 'The Nigerian Institute of Quantity Surveyors Election Letter';

$headers = "From: The Nigerian Institute of Quantity Surveyors ".'applications@niqs.org.ng'  . "\r\n";
//$headers .= "Reply-To: ". strip_tags($_POST['req-email']) . "\r\n";
$headers .= "CC: info@niqs.org.ng\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
$message='Dear $memberName,<br />You have been elected a member of The Nigerian Institute of Structural Engineers after meeting all the set requirements.<br /> Your Membership Number is $newNumber.<br />You are required to pay the sum of $dues.<br />Congratulations. Yours faithfully,<br /> Executive Secretary ';
@mail($to,'The Nigerian Institute of Quantity Surveyors Election Letter',$message,$headers);
echo "Member Moved to Database and Membership Number Assigned";
header('refresh: 2; url=completed.php?appType='.$appType);
}

//insert into dues;
//update clearance
//update application table with application number

//send election letter


function returnQuery($appType,$studID){
	switch($appType){
		case "1":
		$query="SELECT * FROM fellreg WHERE fellID='$studID'";
		break;
		
		case "2":
		$query="SELECT * FROM memreg WHERE memID='$studID'";
		break;
		
		case "3":
		$query="SELECT * FROM probreg WHERE probID='$studID'";
		break;
		
		case "4":
		$query="SELECT * FROM techreg WHERE techID='$studID'";
		break;
		
		case "5":
		$query="SELECT * FROM studentreg WHERE studID='$studID'";
		break;
	}
	return $query;
}