One Hat Cyber Team

View File Name : fxn.php

<?
/*
function ResponseCode($webpay_response){
if ($webpay_response == "00" && $amt_conf != $amt)
{
	$response = "Sorry, Transaction was not successful. The amount paid is incorrect";
}
elseif ($webpay_response  == "01")
{
	$response = "Please Refer to card issuer.";
}
elseif ($webpay_response  == "02")
{
	$response = "Please Refer to card issuer, special condition.";
}
elseif ($webpay_response  == "03")
{
	$response = "Please Refer to card issuer.";
}
elseif ($webpay_response  == "04")
{
	$response = "Pick-up card.";
}
elseif ($webpay_response  == "05")
{
	$response = "Do Not honor.";
}
elseif ($webpay_response  == "06")
{
	$response = "ERROR.";
}
elseif ($webpay_response  == "07")
{
	$response = "Pick-up card, special condition.";
}
elseif ($webpay_response  == "08")
{
	$response = "Honor with identification.";
}
elseif ($webpay_response  == "09")
{
	$response = "Request in progress.";
}
elseif ($webpay_response  == "10")
{
	$response = "Approved, partial.";
}
elseif ($webpay_response  == "11")
{
	$response = "Approved, VIP.";
}
elseif ($webpay_response  == "12")
{
	$response = "Invalid transaction.";
}
elseif ($webpay_response  == "13")
{
	$response = "Invalid amount.";
}
elseif ($webpay_response  == "14")
{
	$response = "Invalid card number.";
}
elseif ($webpay_response  == "15")
{
	$response = "No such issuer.";
}
elseif ($webpay_response  == "16")
{
	$response = "Approved, update track 3.";
}
elseif ($webpay_response  == "17")
{
	$response = "Customer cancellation.";
}
elseif ($webpay_response  == "18")
{
	$response = "Customer dispute.";
}
elseif ($webpay_response  == "19")
{
	$response = "Re-enter transaction.";
}
elseif ($webpay_response  == "20")
{
	$response = "Invalid response.";
}
elseif ($webpay_response  == "21")
{
	$response = "No action taken.";
}
elseif ($webpay_response  == "22")
{
	$response = "Suspected malfunction.";
}
elseif ($webpay_response  == "23")
{
	$response = "Suspected malfunction.";
}
elseif ($webpay_response  == "24")
{
	$response = "File update not supported.";
}
elseif ($webpay_response  == "25")
{
	$response = "Unable to locate record.";
}
elseif ($webpay_response  == "26")
{
	$response = "Duplicate record.";
}
elseif ($webpay_response  == "27")
{
	$response = "File update field edit error.";
}
elseif ($webpay_response  == "28")
{
	$response = "File update file locked.";
}
elseif ($webpay_response  == "29")
{
	$response = "File update failed.";
}
elseif ($webpay_response  == "30")
{
	$response = "Format error.";
}
elseif ($webpay_response  == "31")
{
	$response = "Bank not supported.";
}
elseif ($webpay_response  == "32")
{
	$response = "Completed partially.";
}
elseif ($webpay_response  == "33")
{
	$response = "Expired card, pick-up.";
}
elseif ($webpay_response  == "34")
{
	$response = "Suspected fraud, pick-up.";
}
elseif ($webpay_response  == "35")
{
	$response = "Contact acquirer, pick-up.";
}
elseif ($webpay_response  == "36")
{
	$response = "Restricted card, pick-up.";
}
elseif ($webpay_response  == "37")
{
	$response = "Call acquirer security, pick-up.";
}
elseif ($webpay_response  == "38")
{
	$response = "PIN tries exceeded, pick-up.";
}
elseif ($webpay_response  == "39")
{
	$response = "No credit account.";
}
elseif ($webpay_response  == "40")
{
	$response = "Function not supported.";
}
elseif ($webpay_response  == "41")
{
	$response = "Lost card, pick-up.";
}
elseif ($webpay_response  == "42")
{
	$response = "No universal account.";
}
elseif ($webpay_response  == "43")
{
	$response = "Stolen card, pick-up.";
}
elseif ($webpay_response  == "44")
{
	$response = "No investment account.";
}
elseif ($webpay_response  == "45")
{
	$response = "Account closed.";
}
elseif ($webpay_response  == "46")
{
	$response = "Identification required.";
}
elseif ($webpay_response  == "47")
{
	$response = "Identification cross-check required.";
}
elseif ($webpay_response  == "51")
{
	$response = "Not sufficient funds.";
}
elseif ($webpay_response  == "52")
{
	$response = "No check account.";
}
elseif ($webpay_response  == "53")
{
	$response = "No savings account.";
}
elseif ($webpay_response  == "54")
{
	$response = "Expired card.";
}
elseif ($webpay_response  == "55")
{
	$response = "Incorrect PIN.";
}
elseif ($webpay_response  == "56")
{
	$response = "No card record.";
}
elseif ($webpay_response  == "57")
{
	$response = "Transaction not permitted to cardholder.";
}
elseif ($webpay_response  == "58")
{
	$response = "Transaction not permitted on terminal.";
}
elseif ($webpay_response  == "59")
{
	$response = "Suspected fraud.";
}
elseif ($webpay_response  == "60")
{
	$response = "Contact acquirer.";
}
elseif ($webpay_response  == "61")
{
	$response = "Exceeds withdrawal limit.";
}
elseif ($webpay_response  == "62")
{
	$response = "Restricted card.";
}
elseif ($webpay_response  == "63")
{
	$response = "Security violation.";
}
elseif ($webpay_response  == "64")
{
	$response = "Original amount incorrect.";
}
elseif ($webpay_response  == "65")
{
	$response = "Exceeds withdrawal frequency.";
}
elseif ($webpay_response  == "66")
{
	$response = "Call acquirer security.";
}
elseif ($webpay_response  == "67")
{
	$response = "Hard capture.";
}
elseif ($webpay_response  == "68")
{
	$response = "Response received too late.";
}
elseif ($webpay_response  == "69")
{
	$response = "Advice received too late.";
}
elseif ($webpay_response  == "75")
{
	$response = "PIN tries exceeded.";
}
elseif ($webpay_response  == "76")
{
	$response = "Reserved for future Postilion use.";
}
elseif ($webpay_response  == "77")
{
	$response = "Intervene, bank approval required.";
}
elseif ($webpay_response  == "78")
{
	$response = "Intervene, bank approval required for partial amount.";
}
elseif ($webpay_response  == "90")
{
	$response = "Cut-off in progress.";
}
elseif ($webpay_response  == "91")
{
	$response = "Issuer or switch inoperative.";
}
elseif ($webpay_response  == "92")
{
	$response = "Routing error.";
}
elseif ($webpay_response  == "93")
{
	$response = "Violation of law.";
}
elseif ($webpay_response  == "94")
{
	$response = "Duplicate transaction.";
}
elseif ($webpay_response  == "95")
{
	$response = "Reconcile error.";
}
elseif ($webpay_response  == "96")
{
	$response = "System malfunction.";
}
elseif ($webpay_response  == "97")
{
	$response = "Reserved for future Postilion use.";
}
elseif ($webpay_response  == "98")
{
	$response = "Exceeds cash limit.";
}
elseif ($webpay_response  == "W06")
{
	$response = "Application Error.";
}
elseif ($webpay_response  == "W09")
{
	$response = "Request In Progress.";
}
elseif ($webpay_response  == "W17")
{
	$response = "Customer Cancellation.";
}
elseif ($webpay_response  == "W56")
{
	$response = "No Transaction Record.";
}
elseif ($webpay_response  == "W57")
{
	$response = "Merchant Deactivation.";
}
elseif ($webpay_response  == "W63")
{
	$response = "Security Violation.";
}
elseif ($webpay_response  == "W94")
{
	$response = "Duplicate Transaction Ref.";
}
elseif ($webpay_response  == "W150")
{
	$response = "Payment Session Expired.";
}
elseif ($webpay_response  == "X00")
{
	$response = "Transaction could not be authorized. Please contact your bank or send an email to webpay.support@interswitchng.com";
}
elseif ($webpay_response  == "X01")
{
	$response = "Transaction could not be authorized. Please contact your bank or send an email to webpay.support@interswitchng.com";
}
elseif ($webpay_response  == "X02")
{
	$response = "Transaction could not be authorized. Please contact your bank or send an email to webpay.support@interswitchng.com";
}
elseif ($webpay_response  == "X03")
{
	$response = "Transaction could not be authorized. Please contact your bank or send an email to webpay.support@interswitchng.com";
}
elseif ($webpay_response  == "X04")
{
	$response = "Transaction could not be authorized. Please contact your bank or send an email to webpay.support@interswitchng.com";
}
elseif ($webpay_response  == "X05")
{
	$response = "Transaction could not be authorized. Please contact your bank or send an email to webpay.support@interswitchng.com";
}
return $response;
}*/

function randomString2($randStringLength)
	{
	$timestring = microtime();
	$secondsSinceEpoch=(integer) substr($timestring, strrpos($timestring, " "), 100);
	$microseconds=(double) $timestring;
	$seed = mt_rand(0,1000000000) + 10000000 * $microseconds + $secondsSinceEpoch;
	mt_srand($seed);
	$randstring = "";
	for($i=0; $i < $randStringLength; $i++)
		{
		$randstring .= chr(ord('a') + mt_rand(0, 25));
		}
	return($randstring);
	}
	
	//displays the welcome message at the front end
	function welcomeMessage(){
	$sql="SELECT * FROM web_pages_content WHERE page_ref_id='11'";
	$result=mysql_query($sql);
	if($result){
	$row=mysql_fetch_array($result);
	$content=$row['page_ref_content'];
	return $content;
}
	}
	//displays content of web page
	function content($id){
	$sql="SELECT * FROM web_pages_content WHERE page_ref_id='$id'";
	$result=mysql_query($sql);
	if($result){
	$row=mysql_fetch_array($result);
	$content=$row['page_ref_content'];
	$content=stripslashes($content);
	return $content;
}
	}
	
	// displays title of write up
	function title($id){
		$sql="SELECT * FROM web_pages_content WHERE page_ref_id='$id'";
		$result=mysql_query($sql);
	if($result){
	$row=mysql_fetch_array($result);
	$title=$row['page_ref_title'];
	return $title;
}
	}
		function adminPendingApp()
		{
			$sql="SELECT clear_id FROM clearance_status WHERE (branch_verify='0' OR dean_verify='0') AND reg_type='3'";
			$result=mysql_query($sql);
			$count=mysql_num_rows($result);
			return $count;
		}
	//no of pending applications for chairmen
	function branchPendingApp($branch_id){
		$sql="SELECT * FROM clearance_status,reg_profile WHERE reg_profile.stud_id=clearance_status.stud_id AND branch_verify='0' AND branch_id='$branch_id'";
		$result=mysql_query($sql);
		$count=mysql_num_rows($result);
		return $count;
	}
	
	//no of pending applicants for Dean
	function pendingApp($branch_id){
		$sql="SELECT * FROM clearance_status,reg_profile WHERE reg_profile.stud_id=clearance_status.stud_id AND dean_verify='0' AND branch_id='$branch_id'";
		$result=mysql_query($sql);
		$count=mysql_num_rows($result);
		return $count;
	}
	//for counting the number of applications by school
	function noOfApplicants($school){
		$sql="SELECT * FROM reg_profile,clearance_status WHERE reg_profile.stud_id=clearance_status.stud_id AND school='$school'";
		$result=mysql_query($sql);
		$count=mysql_num_rows($result);
		return $count;
	}
		
		
		
		
function GetAny ($table, $value, $where, $the_output) {

$query = "SELECT *
	FROM $table
	WHERE $where='$value'
	LIMIT 1";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$num = mysql_num_rows($result);

// $programme_id = $row["programme_id"];
$the_output = $row["$the_output"]; 

$the_output = stripslashes($the_output);

return $the_output;
}

function AddSlashHandle($str){
	//if (!get_magic_quotes_gpc()){
		$str = addslashes($str);	
	//}
	
	return $str ;
}


function getnum($tabl, $field){ 
$stopp = 0 ;
while(!$stopp){
	$str_part = randomString2(2) ;
	$yr_part = sprintf("%'02s",substr(GetApplySession(), 2));		
	$num_part = randomNum(3) ;
	$usernum = $str_part.$num_part.$yr_part ;
	$usernum = strtoupper($usernum) ;
	
	$chk = "SELECT $field FROM $tabl WHERE $field = '$usernum' " ; 
	$res = mysql_query($chk) ;
	if(!mysql_num_rows($res)) $stopp =  1 ;
}
	return $usernum ;
}


function GetApplySession22(){
	$dsql = "SELECT name FROM corp_mem_session WHERE status = '1' ";
	$result=mysql_query($dsql);
	$drow = mysql_fetch_array($dresult);
	$dsy = $drow['name'];
	
	return $dsy ;
	
}

function check_for_refresh($val){
	$sql = "SELECT stud_id FROM corp_mem WHERE refresh_stop = '$val' " ;
	$res = mysql_query($sql) ;
	
	if(mysql_num_rows($res)){
			$row = mysql_fetch_array($res) ;
			return $row['stud_id'] ;
	}else{
			return 0 ;
	}
		
}
function countries(){
	$sql="SELECT * FROM countries";
	$result=mysql_query($sql);
	echo "<select name=\"nat\">";
	echo "<option value=\"156\" selected>Nigeria</option>";
	while ($row=mysql_fetch_array($result)){
			$id=$row['country_id'];
			$name=$row['name'];
			echo "<option value=\"$id\">$name</option>";
		}
		echo "</select>";
}
	

function dispUniversities()
	{
		$sql="SELECT * FROM universities";
		$result=mysql_query($sql);
		echo "<select name=\"uni\">";
		echo "<option value=''>Select Your Institution</option>";
		while ($row=mysql_fetch_array($result)){
			$id=$row['id'];
			$name=$row['name'];
			echo "<option value=\"$id\">$name</option>";
		}
		echo "</select>";
	}
function extract_stud($stud){
//include("config.php");
	$qry = "SELECT * FROM corp_mem WHERE stud_id = '$stud' " ;
	$result = mysql_query($qry) ;
	$rows = mysql_fetch_array($result) ;
	
	return $rows ;
		
}


function have_paid_apply($stud_id){
	//include("config_mem.php");
	$sql = "SELECT * FROM corp_reg_pay WHERE stud_id= '$stud_id' AND status='Paid' AND amount>='20000' " ;
	$sql2 = "SELECT * FROM career_app WHERE p_id = '$stud_id' AND applic_status = 1 " ;
	
	$res = mysql_query($sql) ;
	$res2 = mysql_query($sql2) ;
	
	//if( mysql_num_rows($res) AND mysql_num_rows($res2) ){
		if( mysql_num_rows($res)){
		return 1 ;
	}else{
		return 0 ;
	}

}
function checkAdminVerified($stud_id){
	$sql=mysql_query("SELECT * FROM clearance_status WHERE stud_id='$stud_id' AND dean_verify='1' AND branch_verify='1'");
	$count=mysql_num_rows($sql);
	if($count>=1){
		return 1;
	}
	else{
		return 0;
	}
}
// determine application status
function com_incomp($status){
	if($status=='1'){
		echo "<font color=\"#009900\">Completed</font>";
	}
	else{
		echo "<font color=\"#FF0000\">Incomplete</font>";
	}
}
function overall_app_status($status1,$status2,$status3,$status4){
	if($status1=='1' && $status2=='1' && $status3=='1' && $status4=='1'){
				echo "<font color=\"#009900\">Completed</font>";
	}else{
		echo "<font color=\"#FF0000\">Incomplete</font>";
	}
}
		
//type of form to display
function display_type($stud_id){
	include("config.php");
		$sql ="SELECT * FROM clearance_status WHERE stud_id='$stud_id' AND dean_verify='1'";
		$result=mysql_query($sql); 
		$count=mysql_num_rows($result);
		if($count){
			return 1;
		}
		else
		{
			return 0;
		}
	}
//check if the student is already a member
function checkStudentMember($nseregno,$lastname){
	$sql="SELECT id FROM nsemem WHERE nseregno='$nseregno' AND lastname='$lastname' LIMIT 1";
	$result=mysql_query($sql);
	$count=mysql_num_rows($result);
	return $count;
}

function if_exist_apply($authnum, $surname){

	$sql = "SELECT stud_id FROM corp_mem WHERE auth_num = '$authnum' AND surname = '$surname' " ;
	$res = mysql_query($sql) ;
	
	if(!mysql_num_rows($res)){
		return 0 ;
	}
	else{
	
	return 1;
		$row = mysql_fetch_array($res) ;
		//return $row['stud_id'] ;
	
	}
	
}


function check_try($stud){

	$sql = "SELECT * FROM apply_trans WHERE profile_id = '$stud' " ;
	$res = mysql_query($sql) ;
	if(mysql_num_rows($res) > 1){
			return 1 ;
	}
	else{
			return 0 ;
	
	}
}


function Receipt_Number_Apply($tid){
	// generate receipt number
		
		$rsel = "SELECT MAX(receipt_num) FROM apply_trans";
		$rres = mysql_query($rsel) ;
		$rrow = mysql_fetch_array($rres) ;
		
		$maxnumr = $rrow['MAX(receipt_num)'] ;
		
		$new_maxnumr = $maxnumr + 1 ;
		
		$updater="UPDATE apply_trans SET  receipt_num ='$new_maxnumr'
			WHERE trans_num='$tid'";
		$resultsr = mysql_query($updater);
		
		
		
		
}

function GetTotalNumApply( $dsy ){
	
	$sql = "SELECT COUNT(*) as numb FROM apply_profile WHERE applic_status = 1 AND reg_session = '$dsy' " ;
	
	$res = mysql_query($sql) or die(mysql_error()) ;
	$row = mysql_fetch_array($res) ;
	
	return $row['numb'] ;

}

function GetFacNumApply($dfac, $dsy ){
	
	$sql = "SELECT COUNT(*) as numb FROM `apply_profile` 
LEFT JOIN acad_programme ON `course` = programme_id
LEFT JOIN departments ON dept_id = departments_id
 WHERE fac_id = '$dfac' AND applic_status = 1 AND reg_session = '$dsy' " ;
	
	$res = mysql_query($sql) or die(mysql_error()) ;
	$row = mysql_fetch_array($res) ;
	
	return $row['numb'] ;

}


function GetDeptNumApply($ddept, $dsy ){
	
	$sql = "SELECT COUNT(*) as numb FROM `apply_profile` 
LEFT JOIN acad_programme ON `course` = programme_id
 WHERE dept_id = '$ddept' AND applic_status = 1 AND reg_session = '$dsy' " ;
	
	$res = mysql_query($sql) or die(mysql_error()) ;
	$row = mysql_fetch_array($res) ;
	
	return $row['numb'] ;

}

function GetProgNumApply($dprog, $dsy ){
	
	$sql = "SELECT COUNT(*) as numb FROM `apply_profile` 
 WHERE course = '$dprog' AND applic_status = 1 AND reg_session = '$dsy' " ;
	
	$res = mysql_query($sql) or die(mysql_error()) ;
	$row = mysql_fetch_array($res) ;
	
	return $row['numb'] ;

}
function GetMany ($table, $value, $where) {

$query = "SELECT * FROM $table WHERE $where='$value' LIMIT 1";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$num = mysql_num_rows($result);

return $row;

}

function checkFullPayment($stud_id){
	include("config_mem.php");
	$sql=mysql_query("SELECT SUM(amount) as dtotal FROM stud_reg_pay WHERE stud_id='$stud_id' AND status='Paid'");
	$row=mysql_fetch_array($sql);
	return $row['dtotal'];
}
	
function check_Processing_Fee($stud_id){
	include("config_mem.php");
	$sql=mysql_query("SELECT * FROM stud_reg_pay WHERE stud_id='$stud_id' AND status='Paid' AND purpose LIKE 'Processing Fee'");
	$count=mysql_num_rows($sql);
	if($count>=1){return 1;}else{return 0;}
}

function check_apply_status($inp, $sy){

	$sql1 = "SELECT * FROM apply_profile, apply_trans WHERE p_id = profile_id AND auth_num LIKE '$inp' AND applic_status = 1 AND status = 'Paid' AND reg_session = '$sy' AND process_level = 0" ;
	$res1 =  mysql_query($sql1) ;
	
	if(mysql_num_rows($res1)){
		return 1 ;
	}
	else{
		$sql2 = "SELECT * FROM apply_profile, apply_trans WHERE p_id = profile_id AND auth_num LIKE '$inp' AND applic_status = 1 AND status = 'Paid' " ;
		$res2 =  mysql_query($sql2) ;
		
		
		if(mysql_num_rows($res2)){
		
			$row2 = mysql_fetch_array($res2) ;
			if($row2['reg_session'] != $sy){
				return 2;  // payment was for another year
			}
			elseif($row2['process_level'] >= 1){
				return 3;  // already validated
			}
		}
		else{
		
			$sql3 = "SELECT * FROM apply_profile WHERE auth_num LIKE '$inp' AND reg_session = '$sy' " ;
			$res3 = mysql_query($sql3) ;
			
			if(!mysql_num_rows($res3)){
				return 4; // does not exist
			}
			else{
				$rows3 = mysql_fetch_array($res3) ;
				if($row3['applic_status'] == 0 ){
					return 5 ; // has not paid
				}
			}
		}
	}

}



?>