Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
ExcelWriterXML	[ DIR ]	drwxr-xr-x
Excel_Writer	[ DIR ]	drwxr-xr-x
Excel_reader	[ DIR ]	drwxr-xr-x
JQGrid3.5	[ DIR ]	drwxr-xr-x
JQGrid4.4	[ DIR ]	drwxrwxrwx
PHPExcel	[ DIR ]	drwxr-xr-x
Report_details	[ DIR ]	drwxr-xr-x
adm	[ DIR ]	drwxr-xr-x
admupload	[ DIR ]	drwxr-xr-x
backup	[ DIR ]	drwxrwxrwx
certificates	[ DIR ]	drwxrwxrwx
css	[ DIR ]	drwxr-xr-x
custom_js	[ DIR ]	drwxr-xr-x
custom_src	[ DIR ]	drwxr-xr-x
docs	[ DIR ]	drwxr-xr-x
easy_zip	[ DIR ]	drwxr-xr-x
grid_display_files	[ DIR ]	drwxr-xr-x
halltickets	[ DIR ]	drwxrwxrwx
html_modules	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
imported_files	[ DIR ]	drwxrwxrwx
js	[ DIR ]	drwxr-xr-x
libs	[ DIR ]	drwxr-xr-x
maya-pdf	[ DIR ]	drwxr-xr-x
misc_files	[ DIR ]	drwxrwxrwx
ntht	[ DIR ]	drwxrwxr-x
omr_2020_2	[ DIR ]	drwxrwxr-x
photocopy	[ DIR ]	drwxr-xr-x
schema	[ DIR ]	drwxr-xr-x
src	[ DIR ]	drwxr-xr-x
student_photos	[ DIR ]	drwxrwxrwx
study_material	[ DIR ]	drwxr-xr-x
tarka_pdf	[ DIR ]	drwxr-xr-x
tarka_pdf_latest	[ DIR ]	drwxr-xr-x
tcpdf	[ DIR ]	drwxr-xr-x
teacher_photos	[ DIR ]	drwxrwxrwx
upload	[ DIR ]	drwxrwxrwx
user_images	[ DIR ]	drwxr-xr-x
valcenter	[ DIR ]	drwxr-xr-x
valdet	[ DIR ]	drwxrwxr-x
validation_files	[ DIR ]	drwxr-xr-x
12th_convocation_circular_18.0...	752.47 KB	-rw-rw-r--
12th_convocation_circular_28.0...	911.33 KB	-rw-rw-r--
12th_convocation_notification_...	379.62 KB	-rw-rw-r--
2023_2_exam_notification_bped_...	2.75 MB	-rw-rw-r--
2023_2_exam_notification_pg 06...	2.02 MB	-rw-rw-r--
2023_2_exam_notification_ug_16...	3.23 MB	-rw-rw-r--
2024_1_exam_notification_bed_1...	2.68 MB	-rw-rw-r--
MainPage.html	16.41 KB	-rwxr-xr-x
MainPage13.03.2019.html	12.4 KB	-rwxr-xr-x
MainPage_2209.html	11.19 KB	-rwxr-xr-x
MainPage_ru.html	15.79 KB	-rw-rw-r--
MainPagepopup.html	7.05 KB	-rwxr-xr-x
admin.html	9.63 KB	-rwxr-xr-x
app.php	416 B	-rwxr-xr-x
appearing_list_kus.php	2.12 KB	-rwxr-xr-x
cconfig.php	931 B	-rwxr-xr-x
cconfig_old.php	1.13 KB	-rwxr-xr-x
collegeInfoPopup.html	4.24 KB	-rwxr-xr-x
flash.html	2.15 KB	-rwxr-xr-x
getQPdet1.php	7.62 KB	-rw-rw-r--
getQPdet191122.php	8.63 KB	-rw-rw-r--
getQPdet30.09.2020.php	7.05 KB	-rwxr-xr-x
getQPdet_old_05122019.php	4.66 KB	-rwxr-xr-x
getQPdet_old_30062022.php	5.48 KB	-rwxr-xr-x
getqpdet.php	9.42 KB	-rw-rw-r--
homepage.html	3.35 KB	-rwxr-xr-x
index.html	6.61 KB	-rwxr-xr-x
index23.07.2020.html	5.68 KB	-rwxr-xr-x
index_03.01.2014.html	5.14 KB	-rwxr-xr-x
index_https.html	5.4 KB	-rwxr-xr-x
indexlatest.html	5.16 KB	-rwxr-xr-x
indexlogin.html	5.5 KB	-rwxr-xr-x
indexlogin08.html	5.96 KB	-rwxr-xr-x
indexlogin_23.07.2020.html	5.76 KB	-rwxr-xr-x
indexold.html	5.19 KB	-rwxr-xr-x
mainpage.htm	31.7 KB	-rwxr-xr-x
manual_oasis_rcub.pdf	1.63 MB	-rwxr-xr-x
manual_student_portal_rcub.pdf	616.97 KB	-rwxr-xr-x
phpinfo.php	26 B	-rw-rw-r--
re_cronjob_sendsms_rcu.php	4.96 KB	-rwxr-xr-x
result_improvement_app_rcub_v_...	150.36 KB	-rw-rw-r--
result_sms_push.php	3.64 KB	-rw-rw-r--
result_sms_push_rcu.php	4.96 KB	-rwxr-xr-x
uploadteachattend.php	1.33 KB	-rw-r--r--
uploadteachlist.php	1.33 KB	-rw-r--r--
valdet.css	197.06 KB	-rw-rw-r--
valdet.php	325 B	-rw-rw-r--
valdet30.09.2020.php	9.95 KB	-rwxr-xr-x
valdet_get.php	9.42 KB	-rw-rw-r--
valdetx.php	15.92 KB	-rwxr-xr-x
valuation.html	2.49 KB	-rwxr-xr-x

Name

Size

Permission

Action

ExcelWriterXML

[ DIR ]

drwxr-xr-x

Excel_Writer

[ DIR ]

drwxr-xr-x

Excel_reader

[ DIR ]

drwxr-xr-x

JQGrid3.5

[ DIR ]

drwxr-xr-x

JQGrid4.4

[ DIR ]

drwxrwxrwx

PHPExcel

[ DIR ]

drwxr-xr-x

Report_details

[ DIR ]

drwxr-xr-x

adm

[ DIR ]

drwxr-xr-x

admupload

[ DIR ]

drwxr-xr-x

backup

[ DIR ]

drwxrwxrwx

certificates

[ DIR ]

drwxrwxrwx

css

[ DIR ]

drwxr-xr-x

custom_js

[ DIR ]

drwxr-xr-x

custom_src

[ DIR ]

drwxr-xr-x

docs

[ DIR ]

drwxr-xr-x

easy_zip

[ DIR ]

drwxr-xr-x

grid_display_files

[ DIR ]

drwxr-xr-x

halltickets

[ DIR ]

drwxrwxrwx

html_modules

[ DIR ]

drwxr-xr-x

images

[ DIR ]

drwxr-xr-x

img

[ DIR ]

drwxr-xr-x

imported_files

[ DIR ]

drwxrwxrwx

[ DIR ]

drwxr-xr-x

libs

[ DIR ]

drwxr-xr-x

maya-pdf

[ DIR ]

drwxr-xr-x

misc_files

[ DIR ]

drwxrwxrwx

ntht

[ DIR ]

drwxrwxr-x

omr_2020_2

[ DIR ]

drwxrwxr-x

photocopy

[ DIR ]

drwxr-xr-x

schema

[ DIR ]

drwxr-xr-x

src

[ DIR ]

drwxr-xr-x

student_photos

[ DIR ]

drwxrwxrwx

study_material

[ DIR ]

drwxr-xr-x

tarka_pdf

[ DIR ]

drwxr-xr-x

tarka_pdf_latest

[ DIR ]

drwxr-xr-x

tcpdf

[ DIR ]

drwxr-xr-x

teacher_photos

[ DIR ]

drwxrwxrwx

upload

[ DIR ]

drwxrwxrwx

user_images

[ DIR ]

drwxr-xr-x

valcenter

[ DIR ]

drwxr-xr-x

valdet

[ DIR ]

drwxrwxr-x

validation_files

[ DIR ]

drwxr-xr-x

12th_convocation_circular_18.0...

752.47 KB

-rw-rw-r--

12th_convocation_circular_28.0...

911.33 KB

-rw-rw-r--

12th_convocation_notification_...

379.62 KB

-rw-rw-r--

2023_2_exam_notification_bped_...

2.75 MB

-rw-rw-r--

2023_2_exam_notification_pg 06...

2.02 MB

-rw-rw-r--

2023_2_exam_notification_ug_16...

3.23 MB

-rw-rw-r--

2024_1_exam_notification_bed_1...

2.68 MB

-rw-rw-r--

MainPage.html

16.41 KB

-rwxr-xr-x

MainPage13.03.2019.html

12.4 KB

-rwxr-xr-x

MainPage_2209.html

11.19 KB

-rwxr-xr-x

MainPage_ru.html

15.79 KB

-rw-rw-r--

MainPagepopup.html

7.05 KB

-rwxr-xr-x

admin.html

9.63 KB

-rwxr-xr-x

app.php

416 B

-rwxr-xr-x

appearing_list_kus.php

2.12 KB

-rwxr-xr-x

cconfig.php

931 B

-rwxr-xr-x

cconfig_old.php

1.13 KB

-rwxr-xr-x

collegeInfoPopup.html

4.24 KB

-rwxr-xr-x

flash.html

2.15 KB

-rwxr-xr-x

getQPdet1.php

7.62 KB

-rw-rw-r--

getQPdet191122.php

8.63 KB

-rw-rw-r--

getQPdet30.09.2020.php

7.05 KB

-rwxr-xr-x

getQPdet_old_05122019.php

4.66 KB

-rwxr-xr-x

getQPdet_old_30062022.php

5.48 KB

-rwxr-xr-x

getqpdet.php

9.42 KB

-rw-rw-r--

homepage.html

3.35 KB

-rwxr-xr-x

index.html

6.61 KB

-rwxr-xr-x

index23.07.2020.html

5.68 KB

-rwxr-xr-x

index_03.01.2014.html

5.14 KB

-rwxr-xr-x

index_https.html

5.4 KB

-rwxr-xr-x

indexlatest.html

5.16 KB

-rwxr-xr-x

indexlogin.html

5.5 KB

-rwxr-xr-x

indexlogin08.html

5.96 KB

-rwxr-xr-x

indexlogin_23.07.2020.html

5.76 KB

-rwxr-xr-x

indexold.html

5.19 KB

-rwxr-xr-x

mainpage.htm

31.7 KB

-rwxr-xr-x

manual_oasis_rcub.pdf

1.63 MB

-rwxr-xr-x

manual_student_portal_rcub.pdf

616.97 KB

-rwxr-xr-x

phpinfo.php

26 B

-rw-rw-r--

re_cronjob_sendsms_rcu.php

4.96 KB

-rwxr-xr-x

result_improvement_app_rcub_v_...

150.36 KB

-rw-rw-r--

result_sms_push.php

3.64 KB

-rw-rw-r--

result_sms_push_rcu.php

4.96 KB

-rwxr-xr-x

uploadteachattend.php

1.33 KB

-rw-r--r--

uploadteachlist.php

1.33 KB

-rw-r--r--

valdet.css

197.06 KB

-rw-rw-r--

valdet.php

325 B

-rw-rw-r--

valdet30.09.2020.php

9.95 KB

-rwxr-xr-x

valdet_get.php

9.42 KB

-rw-rw-r--

valdetx.php

15.92 KB

-rwxr-xr-x

valuation.html

2.49 KB

-rwxr-xr-x

Code Editor : result_sms_push.php

<?php
/*
* Api For sending result sms through web export after uploading the result
*

url == http://studentportal.logisys.org/result_sms_push.php
post data == funivcode=003&fdbname=logisys3_kus

*
*/
ini_set('memory_limit','900M');
ini_set('max_execution_time',0);
//include 'database.php';
include("/var/www/config.php");
//connect to database
$servername = "logisys.cluster-cv9maxyrxjgg.ap-south-1.rds.amazonaws.com";
$username   = "admin";
$password  = "T0g3th3r@all";

// $servername = SERVERNAME;
// $username   = USERNAME;
// $password  = PASSWORD;

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

$commondb = "logisys3_comexam";

// Will be sent by mohan sir through web export
//var_dump($commondb);
//die();
$unicode = $_GET['univcode'];

if($unicode == '')
{
	echo "Univ Code Empty";
	die();
}

if($unicode == '027')
{
	$db = 'logisys3_rcu';
	$ffolder = 'RCUB';
	$univcode = '027';
}else if($unicode == '041')
{
	$db = 'logisys3_bcu';
	$ffolder = 'BCU';
	$univcode = '041';
}
else if($unicode == '003')
{
	$db = 'logisys3_kus';
	$ffolder = 'KUS';
	$univcode = '003';
}
else if($unicode == '042')
{
	$db = 'logisys3_bnu';
	$ffolder = 'BNU';
	$univcode = '042';
}
else if($unicode == '023')
{
	$db = 'logisys3_dud';
	$ffolder = 'dud';
	$univcode = '023';
}
else if($unicode == '003D')
{
	$db = 'logisys3_kusd';
	$ffolder = 'KUSDDE';
	$univcode = '003D';
}else if($unicode == '043')
{
	$db = 'logisys3_gfgcg';
	$ffolder = 'GFGCG';
	$univcode = '043';
}else if($unicode == '046')
{
	$db = 'logisys3_gach';
	$ffolder = 'GACH';
	$univcode = '046';
}else if($unicode == '037')
{
	$db = 'logisys3_gsh';
	$ffolder = 'GSH';
	$univcode = '037';
}
else if($unicode == '035')
{
	$db = 'logisys3_gcc';
	$ffolder = 'GCC';
	$univcode = '035';
}
else if($unicode == '033')
{
	$db = 'logisys3_gcg';
	$ffolder = 'GCG';
	$univcode = '033';
}
//Re
//Result Push data to common databse

if( $db != '' && $univcode != '')
{
	$sql1 = "insert ignore into {$commondb}.sendsms(funivcode, fregno,fmobileno, fenttype, fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype,fupdate)
	select distinct '{$univcode}', x.fregno,m.fmobileno, 'RE', x.fexamno, 
	concat('From {$ffolder}: Dear Student (',x.fregno ,')',', Your result for ',d.fexamname, ' ', 
    de.fexamdate, ' exam has been announced. Result: ',
    y.fclass,'. Visit student portal for details - Uniclare') as fmessage, 'F', 'F', x.fyear, x.fexamtype, now() 
	from {$db}.res_fee x
	inner join {$db}.resmarks y
	on  x.fdegree = y.fdegree
	and x.fexamno = y.fexamno
	and x.fregno = y.fregno
	inner join {$db}.degree d
	on x.fdegree = d.fdegree and x.fexamno = d.fexamno
	inner join degexam de on y.fdegree = de.fdegree and de.fexamno = y.fexamno
	and y.fyear = de.fyear and y.fexamtype = de.fexamtype
	inner join {$db}.student st 
    on x.fregno = st.fregno 
	inner join logisys3_comexam.masuser m on x.fregno = m.fregno 
	and m.funivcode = '{$univcode}'
	where x.fresultdate = date_format(now(),'%Y-%m-%d')";
//	var_dump($sql1);
	//3.25	
//die();
	$result1 = mysqli_query($conn, $sql1);

if($result1)
	{
		// $sql1 = "update {$commondb}.sendsms x, {$commondb}.masuser y set x.fmobileno = y.fmobileno
		// where x.funivcode = y.funivcode and x.fregno = y.fregno and
        // ifnull(x.fmobileno,'') = ''
        // and x.funivcode = '{$univcode}' and y.funivcode = '{$univcode}' and x.fenttype = 'RE'";
		
		// $result2 = mysqli_query($conn, $sql1);

$sql1 = "update {$db}.res_fee x set x.frespush = 'T'
		where x.fresultdate = date_format(now(),'%Y-%m-%d')
		and ifnull(x.frespush,'') <> 'T'";
		
		$result3 = mysqli_query($conn, $sql1);

echo "success";
	}
	else
	{	
		echo "failure";
	}	
}

${this.title}

Code Editor : result_sms_push.php