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/membership/

Edit File: demand_note_sms.php

<?php
require_once "Mail.php"; // PEAR Mail package
require_once ('Mail/mime.php'); // PEAR Mail_Mime packge
die();
//ini_set("max_execution_time", "120");

$con = mysqli_connect("localhost","niqsorgn_portal","@Xchange69!");
$db = mysqli_select_db($con, "niqsorgn_pota1969");

$sql=mysqli_query($con, "SELECT * FROM members a, dues b WHERE a.memberNo = b.memberNo AND a.sent != 4 AND a.memberPhone!='' AND (b.outstanding + b.annualSub + b.upgradeCharge + b.annualSub2017 + b.devtLevy1 + b.annualSub2018 + b.devtLevy2+ b.annualSub2019 + b.annualSub2020 + b.annualSub2021 + b.annualSub2022) >  '500' ORDER BY a.memberID DESC LIMIT 200");

/*
$sql=mysql_query("SELECT * FROM members a, dues b WHERE a.memberNo = b.memberNo AND a.memberPhone!='' AND (b.outstanding + b.annualSub + b.upgradeCharge + b.annualSub2017 + b.devtLevy1) > 500 AND a.memberNo = '00721'") or die(mysql_error());
*/

while ($row=mysqli_fetch_array($sql)){
	$memNo=$row['memberNo'];
	$name=$row['memberSurname'];
	$date=date('Y-m-d');
	
	$phonecheck= "09022374097"; 
	//$phone2 = "08184949695";   //My DES
	//$phone3= "08033491567";    //Treasurer
	//$phone4 = "08023332518";   //SG
	$phone= $row['memberPhone'];
	$phone2 = $row['memberPhone2'];
	$outstanding =number_format($row['outstanding'],2);
	$annualSub = $row['annualSub'];
	$advance = $row['advance'];
	$upgradeCharge = number_format($row['upgradeCharge'],2);
	$an2016 = number_format($row['annualSub'],2);
        $an2017 = number_format($row['annualSub2017'],2);
        $devt = number_format($row['devtLevy1'],2);
        $an2018 = number_format($row['annualSub2018'],2);
        $devt2 = number_format($row['devtLevy2'],2);
        $an2019 = number_format($row['annualSub2019'],2);
        $an2020 = number_format($row['annualSub2020'],2);
        $an2021 = number_format($row['annualSub2021'],2);
        $an2022 = number_format($row['annualSub2022'],2);

//$total=number_format($row['outstanding']+$annualSub+$advance+$upgradeCharge,2);

$total=$row['outstanding']+$row['annualSub']+$row['annualSub2017']+$row['annualSub2018']+$row['annualSub2019']+$row['annualSub2020']+$row['annualSub2021']+$row['upgradeCharge']+$row['devtLevy1']+$row['devtLevy2']+$row['advance']+$row['annualSub2022'];
 	$total = number_format($total,2);

//$sms = "Dear ".$name." ".$memNo.",\n\nPlease find below your financial position with the Institute:\n\nPrevious Outstanding: ".$outstanding."\n\n2016  Annual Subscription: ".$an2016."\n\nUpgrade Charges: ".$upgradeCharge."\n\n2017 Annual Subscription: ".$an2017."\nHead Office Development Levy: ".$devt."\n\n2018 Annual Subscription: ".$an2018."\n\n2019 Annual Subscription: ".$an2019.""\n\n2020 Annual Subscription: ".$an2020."\nHead Office Development Levy (2nd Installment): ".$devt2."\n\nTotal: ".$total."\n\nKindly pay to any of our bank accounts below:\n\nSkye Bank No.: 1150000015\n\nGTBank No.: 0010899819\nand scan your teller to niqsenquiry@gmail.com for prompt update.\n\nRegards.\n\nQS Osaretin Okoro, FNIQS\n08167593807";

$sms = "Dear $name $memNo,\n\nThe Institute is in the process of compiling a Directory of Members and Practicing Firms which shall include only those who are FINANCIALLY UP TO DATE AS AT 31st March, 2021.\n\nKindly pay your outstanding balance of Subscription/Levies totalling N$total to:\nNIQS (in full), \n\nPolaris Bank No.: 1150000015\nOr\nGT Bank No.: 0010899819\n\nand scan your teller to finance@niqs.org.ng\nfor prompt update.\n\n\nTreasurer\n08167593807";

if($phone != ""){ 
	  @sendSMS($phone,$sms); 
	  //@sendSMS($phonecheck,$sms); 
	  	  
	}

if($phone2 != ""){ 
	  @sendSMS($phone2,$sms); 
	  	  
	}
	
	/*if($phone3 != ""){ 
	  @sendSMS($phone3,$sms); 
	  	  
	}
	
	if($phone4 != ""){ 
	  @sendSMS($phone4,$sms); 
	  	  
	} */
//echo "progress".$phone."<br>";
//if (sendSMS($phone,$sms)){

mysqli_query($con, "UPDATE members SET sent=4 WHERE memberNo='$memNo'");
//}

}

function sendSMS($phone,$sms){
$owneremail="info@niqs.org.ng";
$username="niqs";
$pwd="qsoffice1969";

$sender="NIQS"; 
//$msg="testing ";
$url = "https://netbulksms.com/index.php?option=com_spc&comm=spc_api"
. "&username=" . UrlEncode($username)
. "&password=" . UrlEncode($pwd)
. "&sender=" . UrlEncode($sender)
. "&recipient=" . UrlEncode($phone)
. "&message=".UrlEncode($sms);
	
	if ($f = @fopen($url, "r"))
{
$answer = fgets($f, 255);

echo $answer;
if (substr($answer, 0, 1) == "+")
{
return 1;
}
else
{
    return 2;
//echo "an error has occurred: [$answer].";
}
}
else
{
    return 0;
//echo "Error: URL could not be opened.";
}
	 
 }

function formatPhoneNumber($phonenum){

$phonenum = trim($phonenum);

$phonenum = str_replace(" ","",$phonenum);

$phonenum = str_replace("-","",$phonenum);//remove -

$sign_position = strpos($phonenum,"+");

if(substr($phonenum, 0,3) == "080" or substr($phonenum, 0,3) == "081" or substr($phonenum, 0,3) == "070" or substr($phonenum, 0,3) == "090"){

$myphone_num = substr($phonenum,1);

$myphone_num = "234".$myphone_num;

//echo "is $myphone_num";

}

elseif(substr($phonenum, 0,1) == "+"){

$myphone_num = substr($phonenum,1);//remove the + sign

$myphone_num = str_replace("(0)","",$myphone_num);

}else{

$myphone_num = "234".$phonenum;

}

$count_num = $myphone_num.".";

$last = strpos($count_num,".");

if($last < 14)

{

return $myphone_num;

}

?>