<?php
 ini_set('max_execution_time', 300); //300 seconds = 5 minutes
 session_start();
 
 if ($_SESSION['clientlogin'] == "" ){
 
  header('Location: ../login.php?err=3');
   die();
 }
 $domain ="airbornesms.com";
 $sender ="airbornesms";
 $mfrom ="no-reply@airbornesms.com";
$mfromname=" Support airbornesms.com";

date_default_timezone_set('Africa/Lagos');
 
 


function getaddressbooktotal( $username,$bookname,$domain)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}

 $cnt ="";
 
$subdomain= $domain;
$subdomain =str_replace(".com","",$subdomain);
   
 $query="select count(*) as tot from addressbook".$subdomain." where username='". $username. "' and domain='". $domain. "' and bookname='". $bookname."';";
  
 //echo $query; 
// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
$cnt= "0";
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return "-1";
  
}
else
{



while($row = mysqli_fetch_array($result))
{
	$cnt = $row['tot'];
	//$cnt="yes";
}
mysqli_close($con);
return $cnt;
}
}
  
  function generateTransID()
   {
      $today = date("Ymd");
      $rand = strtoupper(substr(uniqid(sha1(time())),0,4));
      $unique = $today . $_SESSION['subtransid'] . $rand;
      return $unique;
}



  function splitarray($str1,$datestr)
   {
      $amt =0;
      $strArr = split("#",$str1);
	  foreach ($strArr as $mystring)
	  {
	 
	     $value = split(",",$mystring);
		// foreach ( $innerstrArr as $value)
		 //{
		   //echo $value . "kings". "<br>";
		   if ($value[0] == $datestr)
		      $amt = $value[1];
		 //}
	  }
	  
      return $amt;
}
 
function removePosion($mstr)
{
      $mstring = str_replace("'","^",$mstr);
      return $mstring;
}

 function sendSMS( $username,$phonenumber, $transid, $domain,$mess,$sender,$mtype)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}
$mess= removePosion($mess);
 $sender= removePosion($sender);
 $cnt ="";
 //$con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 //if (mysqli_connect_errno())
   //{
   // echo mysqli_error($con);
   //echo "-1";
  // die();
  // }
   
 $query="insert messagesentsingle(transid,username,phonenumber,message,sender,status,domain,dateused) values ('".$transid."','".$username."','".$phonenumber. "','". $mess. "','". $sender. "','0','". $domain. "','".  date('Y-m-d H:i:s')."')";
  
  
// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return "-1";
  
}
else
{
$cnt= "0";
mysqli_close($con);
return $cnt;
}

}			

//$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$





function sendSMSAddressbook( $username,$addressbook, $transid, $domain,$mess,$sender,$mtype,$flag)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}

 $mess= removePosion($mess);
 $sender= removePosion($sender);
 $cnt ="";
 //$con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 //if (mysqli_connect_errno())
   //{
   // echo mysqli_error($con);
   //echo "-1";
  // die();
  // }
   
 $query="insert messagesentaddressbook(transid,username,bookname,message,sender,status,flag,domain,dateused) values ('".$transid."','".$username."','".$addressbook. "','". $mess. "','". $sender. "','0','".$flag."','". $domain. "','".  date('Y-m-d H:i:s')."')";
  

  
// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return "-1";
  
}
else
{
$cnt= "0";
mysqli_close($con);
return $cnt;
}

}			


 function sendSMSscheduleAddress( $username,$addressbook, $transid, $domain,$mess,$sender,$mtype,$datedue,$flag)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}

 $mess= removePosion($mess);
 $sender= removePosion($sender);
 $cnt ="";
 //$con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 //if (mysqli_connect_errno())
   //{
   // echo mysqli_error($con);
   //echo "-1";
  // die();
  // }

// insert schedule(transid,username,bookname,message,sender,status,domain,messtype,datedue,dateused) values ('38382838','nosa','2348022225545,2348138884002,2348033214031,2348029995545','Test message and billing on new platform','Test','0','247sms.com','1','2014/12/08 00:30','2014/12/07');


 $query="insert schedule(transid,username,bookname,message,sender,status,flag,domain,messtype,datedue,dateused) values ('".$transid."','".$username."','".$addressbook. "','". $mess. "','". $sender. "','0','".$flag."','". $domain. "','2','".$datedue."','".  date('Y-m-d H:i:s')."')";
  
  
// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return "-1";
  
}
else
{
$cnt= "0";
mysqli_close($con);
return $cnt;
}

}			


//$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$





 function editAddressbook( $username,$domain,$sn, $phone, $field1,$field2,$field3,$field4,$field5)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}

 $cnt ="5";

$subdomain= $domain;
$subdomain =str_replace(".com","",$subdomain);

 $query=" Update addressbook".$subdomain." set phonenumber='". $phone. "',field1='".$field1."',field2='".$field2."',field3='".$field3."',field4='".$field4."',field5='".$field5."' where username='". $username ."' and domain='".$domain."' and sn =".$sn;
  
  
// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return "5";
  
}
else
{
$cnt= "0";
mysqli_close($con);
return $cnt;
}

}			









 function changepass( $username,$domain,$newpass)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}

 $cnt ="1";


 $query=" Update userlogin set pass='". $newpass. "' where username='". $username ."' and domain='".$domain."'";
  
  
// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return "6";
  
}
else
{
$cnt= "0";
mysqli_close($con);
return $cnt;
}

}			





 function changephone( $username,$domain,$newphone)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}

 $cnt ="1";


 $query=" Update userlogin set phonenumber='". $newphone. "' where username='". $username ."' and domain='".$domain."'";
  
  
// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return "6";
  
}
else
{
$cnt= "0";
mysqli_close($con);
return $cnt;
}

}			





 function getMessageDelivered($username,$domain,$begindate,$enddate,$mflag)
{
 include "connect.php";

 $cnt8 =0;

if ($mflag =="0")
  $query=  "select sum(mcount) as tot from messagesentbackup where  date(dateused) >= date('".$begindate."') and date(dateused) <= date(
'".$enddate."') and username='".$username."'  and domain='".$domain."' order by sn";
if ($mflag =="1")
    $query=  "select sum(mcount) as tot from messagesent where  date(dateused) >= date('".$begindate."') and date(dateused) <= date(
'".$enddate."') and username='".$username."'  and domain='".$domain."' order by sn";

if ($mflag =="2")
    $query=  "select sum(mcount) as tot from messagesentbackup where  date(dateused) >= date('".$begindate."') and date(dateused) <= date(
'".$enddate."') and username='".$username."'  and domain='".$domain."' and status like 'Deliv%' order by sn";

if ($mflag =="3")
    $query=  "select sum(mcount) as tot from messagesentbackup where  date(dateused) >= date('".$begindate."') and date(dateused) <= date(
'".$enddate."') and username='".$username."'  and domain='".$domain."' and status not like 'Deliv%' order by sn";

if ($mflag =="4")
    $query=  "select sum(amtcharged) as tot from accounthistory where  date(dateused) >= date('".$begindate."') and date(dateused) <= date(
'".$enddate."') and username='".$username."'  and domain='".$domain."' order by sn";

if ($mflag =="5")
    $query=  "select sum(mcount) as tot from messagesentbackup where  date(dateused) >= date('".$begindate."') and date(dateused) <= date(
'".$enddate."') and username='".$username."'  and domain='".$domain."' and status like 'Und%' order by sn";


if ($mflag =="6")
    $query=  "select sum(mcount) as tot from messagesentbackup where  date(dateused) >= date('".$begindate."') and date(dateused) <= date(
'".$enddate."') and username='".$username."'  and domain='".$domain."' and status like 'Expire%' order by sn";



if ($mflag =="7")
    $query=  "select sum(mcount) as tot from messagesentbackup where  date(dateused) >= date('".$begindate."') and date(dateused) <= date(
'".$enddate."') and username='".$username."'  and domain='".$domain."' and status like 'Rejec%' order by sn";

  
// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return "0";
  
}

while($row = mysqli_fetch_array($result))
{
	$cnt8 = $row['tot'];
	//return $cnt;
}

if ($cnt8==NULL)
   $cnt8 =0;
mysqli_close($con);
return $cnt8;


}			





function getOperatorMessage($username,$domain,$begindate,$enddate,$mflag,$operator)
{
 include "connect.php";

 $cnt8 =0;

if ($mflag =="0")
  $query=  "select sum(mcount) as tot from messagesentbackup where  date(dateused) >= date('".$begindate."') and date(dateused) <= date(
'".$enddate."') and username='".$username."'  and domain='".$domain."' and mccmnc='".$operator."' order by sn";
if ($mflag =="1")
    $query=  "select sum(mcount) as tot from messagesent where  date(dateused) >= date('".$begindate."') and date(dateused) <= date(
'".$enddate."') and username='".$username."'  and domain='".$domain."' and mccmnc='".$operator."' order by sn";

if ($mflag =="2")
    $query=  "select sum(mcount) as tot from messagesentbackup where  date(dateused) >= date('".$begindate."') and date(dateused) <= date(
'".$enddate."') and username='".$username."'  and domain='".$domain."' and status like 'Deliv%' and mccmnc='".$operator."' order by sn";

//if ($mflag =="3")
  //  $query=  "select sum(mcount) as tot from messagesentbackup where  date(dateused) >= date('".$begindate."') and date(dateused) <= //date(
//'".$enddate."') and username='".$username."'  and domain='".$domain."' and status not like 'Deliv%' and mccmnc='".$operator."' order by //sn";

// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return "0";
  
}

while($row = mysqli_fetch_array($result))
{
	$cnt8 = $row['tot'];
	//return $cnt;
}

if ($cnt8==NULL)
   $cnt8 =0;
mysqli_close($con);
return $cnt8;


}			



function gettotalmessage($username,$domain,$begindate)
{
 include "connect.php";

    $cnt8 = "0"."#"."0"."#"."0"."#"."0"."#"."0"."#"."0"."#"."0"."#"."0"."#"."0"."#";

  $query=  "select totalsent,totaldelivered,totalawaiting,totalundeliverable,totalExpired,totalRejected,totalnomoney,totalothers,amtcharged from messagestatsdetails where  date(dateused) = date('".$begindate."')  and username='".$username."'  and domain='".$domain."' group  by date_format(dateused,'%Y-%m-%d') order by sn";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return $cnt8;
  
}

while($row = mysqli_fetch_array($result))
{
    $cnt8 = $row['totalsent']."#".$row['totaldelivered']."#".$row['totalawaiting']."#".$row['totalundeliverable']."#".$row['totalExpired']."#".$row['totalRejected']."#".$row['totalnomoney']."#".$row['totalothers']."#".$row['amtcharged']."#";
	
	
}

mysqli_close($con);
return $cnt8;


}			


function gettotalmessageWeek($username,$domain,$begindate)
{
 include "connect.php";

    $cnt8 = "0".","."0".","."0"."#"."0".","."0".","."0"."#"."0".","."0".","."0"."#"."0".","."0".","."0"."#"."0".","."0".","."0"."#"."0".","."0".","."0"."#"."0".","."0".","."0"."#";

  $query=  "select date_format(dateused,'%Y-%m-%d')as dateused, totalsent,totaldelivered from messagestatsdetails where  date(dateused) <= date('".$begindate."')  and username='".$username."'  and domain='".$domain."' group  by date_format(dateused,'%Y-%m-%d') order by sn desc limit 7";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return $cnt8;
  
}
$cnt8 ="";
$cnt9 =0;
while($row = mysqli_fetch_array($result))
{
    $cnt8 = $cnt8. $row['dateused'].",". $row['totalsent'].",".$row['totaldelivered']."#";
	
	$cnt9=1;
}

if($cnt9==0)
      $cnt8 = "0".","."0".","."0"."#"."0".","."0".","."0"."#"."0".","."0".","."0"."#"."0".","."0".","."0"."#"."0".","."0".","."0"."#"."0".","."0".","."0"."#"."0".","."0".","."0"."#";

mysqli_close($con);
return $cnt8;


}			



function gettotalmessageawait($username,$domain,$begindate)
{
 include "connect.php";

 $cnt8 ="";

  $query=  "select date_format(dateused,'%Y-%m-%d') as totdate,sum(mcount) as tot from messagesent where  date(dateused) >= date('".$begindate."')  and username='".$username."'  and domain='".$domain."' group  by date_format(dateused,'%Y-%m-%d') order by dateused limit 7";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return $cnt8;
  
}

$cnt9 =1;
while($row = mysqli_fetch_array($result))
{
    if ($cnt9 ==1)
	 $cnt8 = $cnt8 .$row['totdate'].",".$row['tot'];
	else
	 $cnt8 = $cnt8  ."#".$row['totdate'].",".$row['tot'];
	 $cnt9= $cnt9+1;
	//return $cnt;
}

if ($cnt8==NULL)
   $cnt8 ="";
mysqli_close($con);
return $cnt8;


}			




function getAdminEmail($domain,$flag)
{
 include "connect.php";

 $cnt8 ="";
 

  $query=  "select ".$flag." from admindetails where   domain='".$domain."'";
  //echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return $cnt8;
  
}


while($row = mysqli_fetch_array($result))
{
     
	 $cnt8 = $row['0'];
	//echo "nosa";
}

if ($cnt8==NULL)
   $cnt8 ="";
mysqli_close($con);
return $cnt8;


}			



function gettotalcredit($username,$domain,$begindate)
{
 include "connect.php";

 $cnt8 ="";

  $query=  "select date_format(dateused,'%Y-%m-%d') as totdate,sum(amtcharged) as tot from accounthistory where  date(dateused) >= date('".$begindate."')  and username='".$username."'  and domain='".$domain."' group  by date_format(dateused,'%Y-%m-%d') order by dateused limit 7";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return $cnt8;
  
}

$cnt9 =1;
while($row = mysqli_fetch_array($result))
{
    if ($cnt9 ==1)
	 $cnt8 = $cnt8 .$row['totdate'].",".$row['tot'];
	else
	 $cnt8 = $cnt8  ."#".$row['totdate'].",".$row['tot'];
	 $cnt9= $cnt9+1;
	//return $cnt;
}

if ($cnt8==NULL)
   $cnt8 ="";
mysqli_close($con);
return $cnt8;


}			





 function getMCCMNC($username,$domain,$begindate,$enddate)
{
 include "connect.php";

 $cnt8 ="";


  $query=  "select mccmnc,count(*) as tot from messagesentbackup where  date(dateused) >= date('".$begindate."') and date(dateused) <= date(
'".$enddate."') and username='".$username."'  and domain='".$domain."' group  by mccmnc order by tot desc limit 4";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return $cnt8;
  
}

$cnt9 =1;
while($row = mysqli_fetch_array($result))
{
    if ($cnt9 ==1)
	 $cnt8 = $cnt8 .$row['mccmnc'];
	else
	 $cnt8 = $cnt8 .",".$row['mccmnc'];
	 $cnt9= $cnt9+1;
	//return $cnt;
}

if ($cnt8==NULL)
   $cnt8 ="";
mysqli_close($con);
return $cnt8;


}			





 function getOperator($mccmnc)
{
 include "connect.php";

 $cnt8 ="";


  $query=  "Select distinct operator from globalrouting1 where mccmnc '".$mccmnc."'";
echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return $cnt8;
  
}

$cnt9 =1;
while($row = mysqli_fetch_array($result))
{
   	 $cnt8 = $row['operator'];
	
	//return $cnt;
}

if ($cnt8==NULL)
   $cnt8 ="";
mysqli_close($con);
return $cnt8;


}			




function deleteAddressbookRecord( $username,$domain,$sn)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}

 $cnt ="5";
$subdomain= $domain;
$subdomain =str_replace(".com","",$subdomain);

 $query=" Delete from addressbook".$subdomain."  where username='". $username ."' and domain='".$domain."' and sn =".$sn;
  
  
// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return "5";
  
}
else
{
$cnt= "1";
mysqli_close($con);
return $cnt;
}

}			




function updateschedule( $username,$domain,$sn,$st)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}

 $cnt ="5";

 if ($st == "1")
 $query=" Update schedule  set status ='2' where username='". $username ."' and domain='".$domain."' and sn =".$sn;
 
 if ($st == "2")
 $query=" Update schedule  set status ='0' where username='". $username ."' and domain='".$domain."' and sn =".$sn;
 if ($st == "3") 
   $query=" Update schedule  set status ='3' where username='". $username ."' and domain='".$domain."' and sn =".$sn;
  
// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   //exit();
   return "5";
  
}
else
{
$cnt= "0";
mysqli_close($con);
return $cnt;
}

}			


function deleteAddressbook( $username,$domain,$bookname)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}

 $cnt ="5";

$subdomain= $domain;
$subdomain =str_replace(".com","",$subdomain);

 $query=" Delete from addressbook".$subdomain."  where username='". $username ."' and domain='".$domain."' and bookname ='".$bookname."'";
  
  
// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
//exit();
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
  // exit();
   return "5";
  
}
else
{
$cnt= "2";
mysqli_close($con);
return $cnt;
}

}			


 function sendSMSschedule( $username,$phonenumber, $transid, $domain,$mess,$sender,$mtype,$datedue)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}

 $cnt ="";
 //$con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 //if (mysqli_connect_errno())
   //{
   // echo mysqli_error($con);
   //echo "-1";
  // die();
  // }

// insert schedule(transid,username,bookname,message,sender,status,domain,messtype,datedue,dateused) values ('38382838','nosa','2348022225545,2348138884002,2348033214031,2348029995545','Test message and billing on new platform','Test','0','247sms.com','1','2014/12/08 00:30','2014/12/07');


 $query="insert schedule(transid,username,bookname,message,sender,status,domain,messtype,datedue,dateused) values ('".$transid."','".$username."','".$phonenumber. "','". $mess. "','". $sender. "','0','". $domain. "','1','".$datedue."','".  date('Y-m-d H:i:s')."')";
  
  
// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return "-1";
  
}
else
{
$cnt= "0";
mysqli_close($con);
return $cnt;
}

}			





//***********************************************
function getUsername( $musername,$domain)
{
 include "connect.php";
 $cnt ="";
// $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 //if (mysqli_connect_errno())
   //{
   // echo mysqli_error($con);
   //echo "-1";
  // die();
  // }
 $query ="select * from userlogin where username='". $musername ."' and domain='".$domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  return "Database error please try again";
   mysqli_close($con);
   exit();
}

$cnt= "Username not Found";
while($row = mysqli_fetch_array($result))
{
	$cnt = $row['username'];
	//return $cnt;
}

//echo $cnt;
mysqli_close($con);
return $cnt;
}			



function getBalance( $musername,$domain)
{
 include "connect.php";
 $cnt ="";

 $query ="select subprofile from smsprofile where username='". $musername ."' and domain='".$domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  return "Database error please try again";
   mysqli_close($con);
   exit();
}
$smsprofile ="";
$cnt= "User balance cannot be retrived";
while($row = mysqli_fetch_array($result))
{
	$smsprofile = $row['subprofile'];
	//return $cnt;
}

$query ="select * from smsaccount where username='". $musername ."' and domain='".$domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  return "Database error please try again";
   mysqli_close($con);
   exit();
}

$cnt= "User balance cannot be retrived";
while($row = mysqli_fetch_array($result))
{
   if ($smsprofile =="1") 
	$cnt = $row['balnaira'];
	
	if ($smsprofile =="2") 
	$cnt = $row['baleuro'];
	
	if ($smsprofile =="3") 
	$cnt = $row['baldollar'];
	
	$cnt =number_format($cnt,4,".",",");
	//return $cnt;
}
//echo $cnt;
mysqli_close($con);
return $cnt;
}			




function getProfile($musername,$domain)
{
 include "connect.php";
 $cnt ="";

 $query ="select subprofile from smsprofile where username='". $musername ."' and domain='".$domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  return "Database error please try again";
   mysqli_close($con);
   exit();
}
$smsprofile ="0";
//echo "User balance cannot be retrived";
while($row = mysqli_fetch_array($result))
{
	$smsprofile = $row['subprofile'];
	//return $cnt;
}

return $smsprofile;
}


function verifyuser($musername,$domain)
{
 include "connect.php";
 $cnt ="";

 $query ="select mlock from userlogin where username='". $musername ."' and domain='".$domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  return "Database error please try again";
   mysqli_close($con);
   exit();
}
$smsprofile ="";
//echo "User balance cannot be retrived";
while($row = mysqli_fetch_array($result))
{
	$smsprofile = $row['mlock'];
	//return $cnt;
}

return $smsprofile;
}



function getphonenumber($musername,$domain)
{
 include "connect.php";
 $cnt ="";

 $query ="select phonenumber from userlogin where username='". $musername ."' and domain='".$domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  return "Database error please try again";
   mysqli_close($con);
   exit();
}
$smsprofile ="";
//echo "User balance cannot be retrived";
while($row = mysqli_fetch_array($result))
{
	$smsprofile = $row['phonenumber'];
	//return $cnt;
}

return $smsprofile;
}




function getaddress($musername,$domain)
{
 include "connect.php";
 $cnt ="";

 $query ="select address from userlogin where username='". $musername ."' and domain='".$domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  return "Database error please try again";
   mysqli_close($con);
   exit();
}
$smsprofile ="";
//echo "User balance cannot be retrived";
while($row = mysqli_fetch_array($result))
{
	$smsprofile = $row['address'];
	//return $cnt;
}

return $smsprofile;
}



function getpass($musername,$domain)
{
 include "connect.php";
 $cnt ="";

 $query ="select pass from userlogin where username='". $musername ."' and domain='".$domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  return "Database error please try again";
   mysqli_close($con);
   exit();
}
$smsprofile ="";
//echo "User balance cannot be retrived";
while($row = mysqli_fetch_array($result))
{
	$smsprofile = $row['pass'];
	//return $cnt;
}

return $smsprofile;
}



function getRateProfile($musername,$domain)
{
 include "connect.php";
 $cnt ="";

 $query ="select rateprofile from smsprofile where username='". $musername ."' and domain='".$domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  return "Database error please try again";
   mysqli_close($con);
   exit();
}
$smsprofile ="0";
//echo "User balance cannot be retrived";
while($row = mysqli_fetch_array($result))
{
	$smsprofile = $row['rateprofile'];
	//return $cnt;
}

return $smsprofile;
}

?>