Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.git	[ DIR ]	drwxr-xr-x
PHPExcel	[ DIR ]	drwxr-xr-x
PaymentReports	[ DIR ]	drwxr-xr-x
Paytm	[ DIR ]	drwxr-xr-x
Reports	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
html_modules	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
libs	[ DIR ]	drwxr-xr-x
maya-pdf	[ DIR ]	drwxr-xr-x
photocopy	[ DIR ]	drwxr-xr-x
plugins	[ DIR ]	drwxr-xr-x
src	[ DIR ]	drwxr-xr-x
src_12	[ DIR ]	drwxr-xr-x
tarka_pdf_latest	[ DIR ]	drwxr-xr-x
tcpdf	[ DIR ]	drwxr-xr-x
uapp	[ DIR ]	drwxr-xr-x
unilite	[ DIR ]	drwxr-xr-x
upload	[ DIR ]	drwxrwxrwx
.gitignore	42 B	-rwxr-xr-x
DbConnect.php	478 B	-rwxr-xr-x
MENU_BNU.php	2.52 KB	-rwxr-xr-x
admin-Copy.html	5.68 KB	-rwxr-xr-x
admin.html	9.87 KB	-rwxr-xr-x
app.php	416 B	-rwxr-xr-x
appNotification.php	1.76 KB	-rwxr-xr-x
appdownlaodsum.php	5.53 KB	-rwxr-xr-x
barcode_test.php	2.99 KB	-rwxr-xr-x
bnu-menu.php	2.52 KB	-rwxr-xr-x
cconfig.php	1.51 KB	-rwxr-xr-x
cron_sendnotif.php	1.8 KB	-rwxr-xr-x
cronjob_sendnotif.php	2.25 KB	-rwxr-xr-x
cronjob_sendnotif_bcu.php	2.11 KB	-rwxr-xr-x
cronjob_sendnotif_bnu.php	2.11 KB	-rwxr-xr-x
cronjob_sendnotif_dud.php	1.74 KB	-rwxr-xr-x
cronjob_sendnotif_kus.php	2.11 KB	-rwxr-xr-x
cronjob_sendnotif_rcu.php	2.11 KB	-rwxr-xr-x
database.php	444 B	-rwxr-xr-x
downloadbkp.php	527 B	-rwxr-xr-x
index.html	3.87 KB	-rwxr-xr-x
jpgtobase64.php	173 B	-rwxr-xr-x
menu.php	3.85 KB	-rwxr-xr-x
phpinfo.php	21 B	-rwxr-xr-x
rcub_cronjob_sendsms.php	554 B	-rwxr-xr-x
rcub_smspush.php	4.43 KB	-rwxr-xr-x
rcub_smspush_ra.php	2.14 KB	-rwxr-xr-x
re_cronjob_sendsms_rcu.php	5.24 KB	-rwxr-xr-x
result_sms_push_kus.php	4.68 KB	-rwxr-xr-x
rv_sendnotif_bcu.php	1.76 KB	-rwxr-xr-x
saveBarcodeDeatils.php	2.56 KB	-rwxr-xr-x
sendGridMail.php	1.29 KB	-rwxr-xr-x
send_result_kus.php	358 B	-rwxr-xr-x
sendnotif.php	1.25 KB	-rwxr-xr-x
sendnotif_dud.php	1.76 KB	-rwxr-xr-x
sendsms_05092020.php	4.34 KB	-rwxr-xr-x
sendsmsapi.php	814 B	-rwxr-xr-x
sendsmsbulk.php	845 B	-rwxr-xr-x
sendsmsmanual.php	367 B	-rwxr-xr-x
sendsmsroot.php	634 B	-rwxr-xr-x
signin.php	1.71 KB	-rwxr-xr-x
test.php	23 B	-rwxr-xr-x
upload-message-attachments.php	1.79 KB	-rwxr-xr-x
upload_file.php	1.11 KB	-rwxr-xr-x
upload_mc.php	1.62 KB	-rwxr-xr-x
upload_pc.php	3.39 KB	-rwxr-xr-x

Code Editor : rcub_smspush.php

<?php

//include 'database.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";
	ini_set('max_execution_time', 300);
	$sql = "select fdbname, funivcode from {$commondb}.dbname where 
	ifnull(fdeleted,'') <> 'T' and ifnull(FEGOV,'') = 'T'
	and funivcode in('027')"; 
	$result = mysqli_query($conn,$sql);

$result1 = 0;
	if($result)
	{		
		while($row = mysqli_fetch_array($result, MYSQLI_ASSOC))
		{
			$db = $row['fdbname'];
			$univcode = $row['funivcode'];

$enttype = 'AB';

$sql1 = "insert ignore into {$commondb}.sendsms(funivcode, fregno,fmobileno,fusertype,fenttype, fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype, fupdate,fexamdate)
			select distinct '{$univcode}', x.fregno,m.fmobileno,'S','AB', y.fqpcode,
			concat('Dear Student, you are absent for the QP Code ', 
			concat(x.fqpcode, ' - ',left(y.fsubname,30)),' examination held on ',
			date_format(x.fdoe,'%d/%m/%Y')) as fmessage,
			'F', 'F', x.fyear, x.fexamtype, now(),d.fexamdate
			from {$db}.absent x inner join {$db}.subject y
			on x.fqpcode = y.fqpcode and x.fdoe = y.fdoe 
			inner join {$db}.degree d on y.fdegree = d.fdegree and y.fexamno = d.fexamno
			inner join {$commondb}.masuser m on x.fregno = m.fregno 
			and m.funivcode = '{$univcode}'
			where ifnull(x.fabstype,-1) = 'QpA' and ifnull(x.fabsms,'F') <> 'T'";
			$result1 = mysqli_query($conn, $sql1);
			
			if($result1)
			{
				$query = "update {$db}.absent x, {$db}.subject y set x.fabsms = 'T' 
				where x.fqpcode = y.fqpcode and x.fdoe = y.fdoe 
				and ifnull(x.fabstype,-1) = 'QpA'";
				$result4 = mysqli_query($conn, $query);
			}
			
			//Malpractice 
			
			$enttype = 'MP';

$sql1 = "insert ignore into {$commondb}.sendsms(funivcode, fregno,fmobileno,fusertype,fenttype, fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype, fupdate,fexamdate)
			select distinct '{$univcode}', x.fregno,m.fmobileno,'S','MP', y.fqpcode,
			concat('Dear Student, you have been registered under malpratice for the QP Code ', 
			concat(x.fqpcode, ' - ',left(y.fsubname,30)),' examination held on ',
			date_format(x.fdoe,'%d/%m/%Y')) as fmessage,
			'F', 'F', x.fyear, x.fexamtype, now(),d.fexamdate
			from {$db}.absent x inner join {$db}.subject y
			on x.fqpcode = y.fqpcode and x.fdoe = y.fdoe 
			inner join {$db}.degree d on y.fdegree = d.fdegree and y.fexamno = d.fexamno
			inner join {$commondb}.masuser m on x.fregno = m.fregno 
			and m.funivcode = '{$univcode}'
			where ifnull(x.fabstype,-1) = 'QpM' and ifnull(x.fabsms,'F') <> 'T'";
			$result2 = mysqli_query($conn, $sql1);
		
			if($result2)
			{
				$query = "update {$db}.absent x, {$db}.subject y set x.fabsms = 'T' 
				where x.fqpcode = y.fqpcode and x.fdoe = y.fdoe 
				and ifnull(x.fabstype,-1) = 'QpM'";
				$result3 = mysqli_query($conn, $query);
			}
			
			//Room Allotment

$sql1 = "insert ignore into {$commondb}.sendsms(funivcode, fregno,fmobileno, fusertype,fenttype, fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype, fupdate,fexamdate)
			select distinct '{$univcode}', x.fregno,m.fmobileno,'S','RA', y.fqpcode ,  
			concat('Dear Student, you have been alloted to room no. : ',
			if(ifnull(z.froomname,'') = '',
			ifnull(x.FHALLNO,''),ifnull(z.froomname,'')), ' for the QP Code ',
			concat(y.fqpcode,' - ',left(y.fsubname,30)),' on ',
			date_format(y.fdoe,'%d/%m/%Y'),' (',w.FDESCPN,').') as fmessage,
			'F', 'F', x.fyear, x.fexamtype,now(),d.fexamdate
			from {$db}.canddet x inner join {$db}.subject y
			on  x.fdegree = y.fdegree and x.fexamno = y.fexamno and x.fsubcode = y.fsubcode 
			inner join {$db}.degree d on x.fdegree = d.fdegree and x.fexamno = d.fexamno
			inner join {$db}.candsum cs on cs.fcollcode = x.fcollcode
			and cs.fdegree = x.fdegree and cs.fregno = x.fregno
			and ifnull(cs.frecptdate,'')<>''
			inner join {$commondb}.masuser m on m.fregno = cs.fregno 
			and m.funivcode = '{$univcode}'	
			left join {$db}.masroom z on cs.fcntrcode = z.fcollcode 
			and x.FHALLNO = z.froomno
			left join {$db}.reason w on y.FSESSION = w.FREASONCD
			where ifnull(x.fpresent,'') = 'p' and ifnull(x.fpassmth,'') = ''
			and date_format(now(),'%Y-%m-%d') = date_format(y.fdoe,'%Y-%m-%d')
			and ifnull(y.FSESSION,'') like 'M%' and ifnull(x.fhallno,'') <> ''";
			$result1 = mysqli_query($conn, $sql1);

}
	}
		
?>

${this.title}

Code Editor : rcub_smspush.php