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 : cronjob_sendsms_bnu.php

<?php
//lib16107 lib16103

ini_set('display_errors', 'on');
include("sendsmsapi.php");
ini_set('memory_limit','900M');
ini_set('max_execution_time',0);

$univcode = trim($_GET['funivcode']);
$univcode = '041';	
if($univcode == '')
{
	die();
}

//connect to database
$servername = "97.74.228.93";
$username   = "logisys3_logu";
$password  = "Logisys@2106";
$conn = new  mysqli($servername,$username,$password);
if(!$conn) 
{
    die("Connection failed: " . mysqli_connect_error());
}

$commondb = "logisys3_comexam";

$query = "select funivcode, fregno, fenttype, fmobileno as mobileno, 
concat(fmessage,' Sent Time: ',time(now())) as fmessage
from {$commondb}.sendsms 
where ifnull(fstatus, 'F') = 'F' and fenttype in('PGCET') and funivcode = '{$univcode}'
and fmobileno is not null";

$result = mysqli_query($conn,$query);
$count = mysqli_num_rows($result);

$username = 'logisyhttp';
$password = 'Logis986';
$from = 'UNISOL';
$category = '';

if($count >0)
{
	$i = 0;
	
	$row = mysqli_fetch_assoc($result);
	$text1 = $row['fmessage'];
	
	while($row = mysqli_fetch_assoc($result))
	{
		$to = $row['mobileno'];
		$text = $row['fmessage'];

$smsresp = sendsmaapi($username,$password,$from,$to,$text,$category);	
		echo $i." - ".$to." - ".$smsresp."<br>";
		$rgInsert[] = "('".$row['funivcode']."','".$row['fregno']."','{$to}','0','{$smsresp}','".$row['fenttype']."','T', DATE_FORMAT(NOW(),'%Y-%m-%d'), DATE_FORMAT(NOW(),'%T'))";
		$rgTrimedMobs[$i] = $to;

//echo $i.$to."<br>";
		
		if($i == 50)
		{
			$strInsertQuery = "insert into {$commondb}.smslog(funivcode, fregno,fmobileno, freasoncode, fguid, fenttype, fstatus,fackdate, facktime) values".implode(',',$rgInsert);
			//var_dump($strInsertQuery);
			$result1 = mysqli_query($conn,$strInsertQuery);

unset($rgTrimedMobs);
			$rgTrimedMobs = array();
			$i = 0;
		}

$i++;
	}

$strInsertQuery = "insert into {$commondb}.smslog(funivcode,fregno,fmobileno, freasoncode, fguid, fenttype, fstatus,fackdate, facktime) values".implode(',',$rgInsert);
	//var_dump($strInsertQuery);
	$result1 = mysqli_query($conn,$strInsertQuery);

$srtImplodedMobs = implode("','",$rgTrimedMobs); 
	$strUpdateQuery = "update {$commondb}.sendsms set fstatus = 'T' where fenttype in('PGCET') and fmobileno in ('{$srtImplodedMobs}')";
	//var_dump($strUpdateQuery);	
	$result2 = mysqli_query($conn,$strUpdateQuery);
	$username = 'logisyhttp';
	$password = 'Logis986';
	$from = 'UNISOL';
	$category = 'bulk';
	
	//north
	//$to = "918277684424,919538219443,919845532688,919844020272,919986554632,919844059406,919741089633,9448454872";
	
	//Central
	//$to = "918277684424,919538219443,919845532688,919844020272,919986554632,919844059406,919741089633,9449259058";
	
	//DUD

$to = "918277684424,919741089633";

$smsresp = sendsmaapi($username,$password,$from,$to,$text1,$category);

echo "SMS Sent";
}

$username = 'logisyhttp';
	$password = 'Logis986';
	$from = 'UNISOL';
	$category = 'bulk';
	
	//north
	//$to = "918277684424,919538219443,919845532688,919844020272,919986554632,919844059406,919741089633,9448454872";
	
	//Central
	//$to = "918277684424,919538219443,919845532688,919844020272,919986554632,919844059406,919741089633,9449259058";
	
	//DUD
	$text1 = "Message from BCU : University regrets to inform that admissions to MA philosophy course has been put off due to insufficient applicants. You are advised to claim refund of the application fee by writing to Registrar, BCU.Sent Time: 17:11:30";

$to = "918277684424,919741089633";

$smsresp = sendsmaapi($username,$password,$from,$to,$text1,$category);

var_dump($smsresp);
	echo "SMS Sent";

${this.title}

Code Editor : cronjob_sendsms_bnu.php