Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
css	[ DIR ]	drwxr-xr-x
html_modules	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
plugins	[ DIR ]	drwxr-xr-x
src	[ DIR ]	drwxr-xr-x
MainPage.html	7.6 KB	-rwxr-xr-x
MainPage2.html	15.28 KB	-rwxr-xr-x
Thumbs.db	2.5 KB	-rwxr-xr-x
background.jpg	42.45 KB	-rwxr-xr-x
cManualMailer.php	3.69 KB	-rwxr-xr-x
cronjob_sendsms.php	1.77 KB	-rwxr-xr-x
database.php	377 B	-rwxr-xr-x
forgot-password.html	5.51 KB	-rwxr-xr-x
forgot-password.php	2.19 KB	-rwxr-xr-x
forgotPassword.html	4.85 KB	-rwxr-xr-x
getLocation.php	429 B	-rwxr-xr-x
getstatesanduniv.php	419 B	-rwxr-xr-x
helpdesk.html	2.2 KB	-rwxr-xr-x
index.html	5.16 KB	-rwxr-xr-x
index2.html	9.49 KB	-rwxr-xr-x
instruction.html	4.46 KB	-rwxr-xr-x
lastdate.html	3.14 KB	-rwxr-xr-x
pgResponse.php	4.3 KB	-rwxr-xr-x
registration.html	7.25 KB	-rwxr-xr-x
registration.php	543 B	-rwxr-xr-x
resetpassword.php	696 B	-rwxr-xr-x
sendGridMail.php	1.2 KB	-rwxr-xr-x
sendMobEmailOTP.php	3.44 KB	-rwxr-xr-x
sendsmsapi.php	434 B	-rwxr-xr-x
sendsmsbulk.php	791 B	-rwxr-xr-x
sign-up.html	12.02 KB	-rwxr-xr-x
signin.php	1.43 KB	-rwxr-xr-x
signup.php	830 B	-rwxr-xr-x
smspush.php	6.61 KB	-rwxr-xr-x
smspush_bkp.php	2.85 KB	-rwxr-xr-x
validateInfo.php	1.69 KB	-rwxr-xr-x
validateRegno.php	562 B	-rwxr-xr-x

Code Editor : smspush_bkp.php

<?php

include 'database.php';
	ini_set('max_execution_time', 300);
	$sql = "select fdbname from logisys3_comexam.dbname where ifnull(fdeleted,'') <> 'T'"; 
	$result = mysqli_query($conn,$sql);
	
	if($result)
	{		
		while($row = mysqli_fetch_array($result, MYSQLI_ASSOC))
		{
			$db = $row['fdbname'];

$sql = "INSERT IGNORE INTO logisys3_comexam.sendsms			
			select  {$db}.control.funivcode,{$db}.marks.FREGNO,logisys3_comexam.masuser.FMOBILENO,'IA',
			'Dear Student, Your IA Marks has been announced please check at http://studentportal.logisys.org' ,'F','F'
			from  {$db}.marks inner join logisys3_comexam.masuser on 
			logisys3_comexam.masuser.FREGNO = {$db}.marks.FREGNO 
			inner join {$db}.control on 
			{$db}.control.funivcode = logisys3_comexam.masuser.FUNIVCODE
			inner join {$db}.collexam on {$db}.marks.FDEGREE = {$db}.collexam.FDEGREE and {$db}.marks.FCOLLCODE = {$db}.collexam.FCOLLCODE
			where DATE_FORMAT(NOW(),'%Y-%m-%d') between DATE_SUB(collexam.fiato, INTERVAL 3 DAY)
			AND DATE_ADD(collexam.fiato,INTERVAL 60 DAY)";
		//	var_dump($sql);
			
			$result1 = mysqli_query($conn,$sql);

$sql1 = "INSERT IGNORE INTO logisys3_comexam.sendsms			
			select  {$db}.control.funivcode,{$db}.candsum.FREGNO,logisys3_comexam.masuser.FMOBILENO,'HT',
			'Dear Student, Your Hall Ticket is Available at http://studentportal.logisys.org for Download' ,'F','F'
			from  {$db}.candsum inner join logisys3_comexam.masuser on 
			logisys3_comexam.masuser.FREGNO = {$db}.candsum.FREGNO 
			inner join {$db}.control on 
			{$db}.control.funivcode = logisys3_comexam.masuser.FUNIVCODE
			inner join {$db}.collexam on {$db}.candsum.FDEGREE = {$db}.collexam.FDEGREE and {$db}.candsum.FCOLLCODE = {$db}.collexam.FCOLLCODE
			where DATE_FORMAT(NOW(),'%Y-%m-%d') between collexam.fhtfrom
			AND collexam.fhtto and ifnull({$db}.candsum.frecptdate,'') <> ''";
		//	var_dump($sql1);
			
			$result2 = mysqli_query($conn,$sql1);

$sql2 = "INSERT IGNORE INTO logisys3_comexam.sendsms			
			select  {$db}.control.funivcode,{$db}.attend.FREGNO,logisys3_comexam.masuser.FMOBILENO,'AT',
			'Dear Student, Your Attendance has been announced please check at http://studentportal.logisys.org' ,'F','F'
			from  {$db}.attend inner join logisys3_comexam.masuser on 
			logisys3_comexam.masuser.FREGNO = {$db}.attend.FREGNO 
			inner join {$db}.control on 
			{$db}.control.funivcode = logisys3_comexam.masuser.FUNIVCODE
			inner join {$db}.collexam on {$db}.attend.FDEGREE = {$db}.collexam.FDEGREE and {$db}.attend.FCOLLCODE = {$db}.collexam.FCOLLCODE
			where DATE_FORMAT(NOW(),'%Y-%m-%d') between DATE_SUB(collexam.fiato, INTERVAL 3 DAY)
			AND DATE_ADD(collexam.fiato,INTERVAL 60 DAY)";
		//	var_dump($sql2);	
			$result3 = mysqli_query($conn,$sql2);
			
		}
	}	 
	if($result1)
	{	
		$arr = "Updated Successfully";
		echo json_encode($arr);	
	
	}else
	{	
		$arr = "Updation Failed";
		echo json_encode($arr);
	}
?>

${this.title}

Code Editor : smspush_bkp.php