Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
google-api-php-client	[ DIR ]	drwxr-xr-x
kreait_firebase	[ DIR ]	drwxrwxr-x
admission_sms_push.php	2.3 KB	-rwxr-xr-x
admission_sms_push_bnu.php	2.29 KB	-rwxr-xr-x
admsumsendsms.php	6.12 KB	-rwxr-xr-x
admsumsendsms_bnu_17102018.php	8.06 KB	-rwxr-xr-x
admsumsendsms_bnu_29102018.php	12.17 KB	-rwxr-xr-x
admsumsendsms_bnu_adm_pg.php	18.03 KB	-rwxr-xr-x
admsumsendsms_bnu_wait.php	27.52 KB	-rwxr-xr-x
attDegwiseReport.php	9 KB	-rw-r--r--
cron_send_sms_interana.php	1.18 KB	-rwxr-xr-x
cronjob_sendmail.php	5.81 KB	-rwxr-xr-x
cronjob_sendsms.php	5.35 KB	-rwxr-xr-x
cronjob_sendsms_bcu_mo.php	3.18 KB	-rwxr-xr-x
cronjob_sendsms_bnu.php	3.84 KB	-rwxr-xr-x
cronjob_sendsms_bnu_old.php	2.55 KB	-rwxr-xr-x
cronjob_sendsms_dud.php	2.84 KB	-rwxr-xr-x
cronjob_sendsms_dud_mo.php	3.16 KB	-rwxr-xr-x
cronjob_sendsms_old_smssum.php	3.61 KB	-rwxr-xr-x
google-api-php-client-v2.7.1-P...	13.11 MB	-rwxr-xr-x
import_data.php	3.21 KB	-rwxr-xr-x
mail.php	459 B	-rwxr-xr-x
sendGridMail.php	1.29 KB	-rwxr-xr-x
sendnotifapi.php	5.18 KB	-rwxr-xr-x
sendsmsapi.php	759 B	-rwxr-xr-x
sendsmsapi_adm.php	6.61 KB	-rw-rw-r--
sendsmsapi_new.php	6.06 KB	-rw-r--r--
sendsmsapi_onex.php	6.84 KB	-rw-r--r--
sendsmsapi_onex_new.php	4.59 KB	-rw-r--r--
sendsmsapiv1.php	9.48 KB	-rwxr-xr-x
sendsmsapiv1_07082024.php	9.47 KB	-rwxr-xr-x
sms.php	422 B	-rwxr-xr-x
sms_statistics.php	2.99 KB	-rwxr-xr-x
sms_test.php	1.21 KB	-rw-r--r--
stud_data_push.php	1.43 KB	-rwxr-xr-x
teach_data_push.php	1.47 KB	-rwxr-xr-x
test.txt	1.44 KB	-rwxr-xr-x
test_firebase_service.php	237 B	-rwxr-xr-x
validateRegno.php	2.4 KB	-rwxr-xr-x
vskub_pget_smsstat.php	2.45 KB	-rwxr-xr-x

Code Editor : sms_statistics.php

<?php
//lib16107 lib16103

ini_set('display_errors', 'on');
ini_set('max_execution_time', 300);
include("sendsmsapi.php");
include("sendGridMail.php");

$servername = "logisys.cluster-cv9maxyrxjgg.ap-south-1.rds.amazonaws.com";
$username   = "admin";
$password  = "Logisys2104";

$conn = new  mysqli($servername,$username,$password);
if(!$conn) 
{
    die("Connection failed: " . mysqli_connect_error());
}

$commondb = "logisys3_comexam";

$query = "select FSMSUSER, FSMSPASSWD, FSMSSENDID from {$commondb}.dbname where funivcode = '041'";
$result1 = mysqli_query($conn,$query);
$smsrow = mysqli_fetch_assoc($result1);

$username = $smsrow['FSMSUSER'];
$password = $smsrow['FSMSPASSWD'];
$from = $smsrow['FSMSSENDID'];
$category = 'bulk';

$url = "http://203.212.70.200/smpp/creditstatus.jsp?user={$username}&password={$password}";
$session = curl_init($url);
curl_setopt($session, CURLOPT_HEADER, false);

curl_setopt($session, CURLOPT_RETURNTRANSFER, true);

$response = curl_exec($session);
curl_close($session);
$res = explode(",",$response);

$res1 = explode("=",$res[1]);
$creditused  = $res1[1];

$res2 = explode("=",$res[0]);
$credit  = $res2[1];

$smsremain = (int)($credit-$creditused);

$query = "select x.funivcode, d.funivname, count(x.fmobileno) as sms_cnt, d.FFOLDER
from logisys3_logs.smslog x, logisys3_comexam.dbname d
where x.funivcode = d.funivcode and fackdate > DATE_SUB(CURDATE(), INTERVAL 1 DAY)
group by x.funivcode
order by sms_cnt desc, x.funivcode";
$result3 = mysqli_query($conn,$query);
$count3 = mysqli_num_rows($result3);

if($count3 >0)
{
    $text = "SMS Sent Deatils : ";
    $sum = 0;
	while($row3 = mysqli_fetch_assoc($result3))
	{
				
		$text .= $row3['FFOLDER']." : ".$row3['sms_cnt']."; "; 
		$sum += $row3['sms_cnt'];
		
	}

}
$text .= "Total SMS Sent : ".moneyFormatIndia($sum)."; SMS Remaining : ".moneyFormatIndia($smsremain);
//var_dump($text);
		
$to = "919741089633,918277684424,919845532688,919844020272";
$smsresp = sendsmaapi($username,$password,$from,$to,$text,$category);
echo $smsresp;
// continue;
//die();

${this.title}

Code Editor : sms_statistics.php