| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/HostingSpaces/admin/247sms.com/wwwroot/dashboard/ |
Upload File : |
<?php error_reporting(0); ?>
<?php
ini_set('max_execution_time', 300); //300 seconds = 5 minutes
session_start();
if ($_SESSION['clientlogin'] == "" ){
header('Location: ../login.php?err=3');
die();
}
$domain ="247sms.com";
$subdomain ="247sms";
$sender ="SWIFTALLI";
$mfrom ="no-reply@247sms.com";
$mfromname=" Support 247sms.com";
date_default_timezone_set('Africa/Lagos');
function Checkfreesms( $musername,$domain)
{
$cnt ="";
include "connect.php";
$query ="select league from userlogin where username='$musername' and domain='$domain'";
//echo $query;
//exit();
if(!$result= mysqli_query($con,$query))
{
//echo mysqli_error($con);
var_dump( mysqli_error($con));
//echo "nosa";
mysqli_close($con);
//exit();
//return "-1";
die();
}
$cnt= "0";
while($row = mysqli_fetch_array($result))
{
//$cnt = $row['balairtime'];
$cnt=$row[0];
}
//echo $cnt."nosa2";
//exit();
mysqli_close($con);
return $cnt;
die();
}
function Checkfreesmsvas( $musername,$domain)
{
$cnt ="";
include "connect.php";
$query ="select vas from userlogin where username='$musername' and domain='$domain'";
//echo $query;
//exit();
if(!$result= mysqli_query($con,$query))
{
//echo mysqli_error($con);
var_dump( mysqli_error($con));
//echo "nosa";
mysqli_close($con);
//exit();
//return "-1";
die();
}
$cnt= "0";
while($row = mysqli_fetch_array($result))
{
//$cnt = $row['balairtime'];
$cnt=$row[0];
}
//echo $cnt."nosa2";
//exit();
mysqli_close($con);
return $cnt;
die();
}
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 addressbook247sms 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("Ymds");
$rand = strtoupper(substr(uniqid(sha1(time())),0,4));
$rand = str_replace("A","1",$rand);
$rand = str_replace("B","2",$rand);
$rand = str_replace("C","3",$rand);
$rand = str_replace("D","4",$rand);
$rand = str_replace("E","5",$rand);
$rand = str_replace("F","6",$rand);
$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);
//$mstring = str_replace("\n","",$mstring);
// $mstring = str_replace("\r","",$mstring);
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 sendSMSfree( $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 = "update userlogin set vas ='0' where username ='$username' and domain ='$domain'";
$result= mysqli_query($con,$query);
$query="insert messagesentsinglefree(transid,username,phonenumber,message,sender,status,domain) values ('".$transid."','".$username."','".$phonenumber. "','". $mess. "','". $sender. "','0','". $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 "-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,2347062012965,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,2347062012965,2348029995545','Test message and billing on new platform','Test','0','247sms.com','1','2014/12/08 00:30','2014/12/07');
$mess= removePosion($mess);
$sender= removePosion($sender);
$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 getUsernamevas( $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 vas 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= "";
while($row = mysqli_fetch_array($result))
{
//$cnt = $row['username'];
//return $cnt;
$cnt = "yes";
}
//echo $cnt;
mysqli_close($con);
return $cnt;
}
function getUsernamevasphone( $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 vas where username='". $musername ."' and domain='".$domain."' limit 1";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
//echo mysqli_error($con);
return "Database error please try again";
mysqli_close($con);
exit();
}
$cnt= "";
while($row = mysqli_fetch_array($result))
{
$cnt = $row['phonenumber'];
//return $cnt;
//$cnt = "yes";
}
//echo $cnt;
mysqli_close($con);
return $cnt;
}
function getVasService( $musername,$domain,$servicetype)
{
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 vas where username='". $musername ."' and domain='".$domain."' and servicetype ='". $servicetype . "' and optin ='1'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
//echo mysqli_error($con);
return "Database error please try again";
mysqli_close($con);
exit();
}
$cnt= "";
while($row = mysqli_fetch_array($result))
{
//$cnt = $row['username'];
//return $cnt;
$cnt = "yes";
}
//echo $cnt;
mysqli_close($con);
return $cnt;
}
function getVasService2( $musername,$domain,$servicetype)
{
include "connect.php";
$cnt ="0";
// $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 vas where username='". $musername ."' and domain='".$domain."' and servicetype ='". $servicetype . "'";
echo $query;
if(!$result= mysqli_query($con,$query))
{
//echo mysqli_error($con);
return "Database error please try again";
mysqli_close($con);
exit();
}
$cnt= "0";
while($row = mysqli_fetch_array($result))
{
//$cnt = $row['username'];
//return $cnt;
$cnt = "1";
}
//echo $cnt;
mysqli_close($con);
return $cnt;
}
function clearVasService( $musername,$domain)
{
include "connect.php";
$cnt ="0";
$query ="update vas set optin ='0' 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= "1";
//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 getBalance2( $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;
//exit();
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;
}
?>