Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.pgetadm.php	3.61 KB	-rw-r--r--
PrintAdmissionOrderstudent.php	9.83 KB	-rwxrwxrwx
Seat_Allotment_Details.php	11.36 KB	-rw-r--r--
add-course.php	5.63 KB	-rwxrwxrwx
admfee.php	9.25 KB	-rw-rw-r--
admissionorderPGReport.php	15.91 KB	-rwxrwxrwx
admissionordertest.php	356 B	-rwxrwxrwx
admorder_bnu.php	14.93 KB	-rw-r--r--
app-status.php	2.39 KB	-rwxrwxrwx
applicationFormPGReport.php	43.11 KB	-rwxrwxrwx
bcuapplicationFormPGReport.php	35.13 KB	-rwxrwxrwx
bnuapplicationFormPGReport.php	35.47 KB	-rwxrwxrwx
category.php	2.52 KB	-rwxrwxrwx
data.json	1.98 KB	-rwxrwxrwx
degree.php	12.38 KB	-rwxrwxrwx
feestr.php	5.92 KB	-rwxrwxrwx
forgot-password.php	2.77 KB	-rw-rw-r--
forgot-password_old.php	2.31 KB	-rwxrwxrwx
getSavedData.php	8.49 KB	-rwxrwxrwx
getSavedData_old_12102019.php	5 KB	-rwxrwxrwx
hallticket.php	7.61 KB	-rwxrwxrwx
login.php	947 B	-rwxrwxrwx
logout.php	44 B	-rwxrwxrwx
option-entry.php	4.34 KB	-rwxrwxrwx
option-entryPrint.php	9.29 KB	-rwxrwxrwx
printadmissionorder.php	616 B	-rwxrwxrwx
reprint.php	707 B	-rwxrwxrwx
resetpassword.php	700 B	-rwxrwxrwx
saveApplication.php	25.7 KB	-rwxrwxrwx
saveApplication051120.php	23.67 KB	-rwxrwxrwx
saveApplication_old_12102019.p...	14.67 KB	-rwxrwxrwx
seat-allot.php	1008 B	-rwxrwxrwx
sendGridMail.php	1.28 KB	-rwxrwxrwx
sendMobEmailOTP.php	1.41 KB	-rwxrwxrwx
sendsmsapi.php	760 B	-rwxrwxrwx
signin.php	996 B	-rwxrwxrwx
signup.php	1.01 KB	-rwxrwxrwx
validateRegno.php	1.94 KB	-rwxrwxrwx
vkuapplicationFormPGReport cop...	36.61 KB	-rwxrwxrwx
vkuapplicationFormPGReport.php	37.97 KB	-rwxrwxrwx

Code Editor : forgot-password.php

<?php
include ("../database.php");
include("../../sms/sendsmsapiv1.php");
include("sendGridMail.php");
error_reporting(E_ALL);
ini_set('display_errors', 'on');

//$regno = $_POST['regno'];
$mob = trim($_POST['mobile']);

$query = "SELECT femail,funivcode from collstud 
			where fmobileno = '{$mob}' and ifnull(factive,'') = 'T'";

$result = mysqli_query($conn,$query);
$count = mysqli_num_rows($result);
if($count >0)
{
	$row = mysqli_fetch_assoc($result);
	$email = $row['femail'];
	$univcode = $row['funivcode'];
	
	$otp = rand(100000, 900000);
	//$smsotp = "Dear User, Your mobile OTP for reseting password is $otp";

$FFOLDER = "BCU";
	$query1 = "select ffolder from logisys3_comexam.dbname where funivcode = '{$univcode}'";
	//var_dump($query1);
		$result1 = mysqli_query($conn,$query1);
		$row1 = $result1->fetch_assoc();
		$FFOLDER = $row1['ffolder'];

date_default_timezone_set('Asia/Kolkata');
	$time =  date("h:i A");
	//$otp = rand(1000, 9000);
	$smsotp = "From $FFOLDER: Dear Student, OTP for reseting is $otp. sent at {$time} - Uniclare";
	// $username = 'logisyhttp';
	// $password = 'Logis986';
	// $from = 'LOGINF';
	// $to = $mob;
	// $text = $smsotp;
	// $category = '';

// $smsresp = sendsmaapi($username,$password,$from,$to,$text,$category);
	$sms = new SMS('026', 'OTP');
	$sms->sendIndvidualSms($mob, $smsotp, '900', 'PGET');

$message="<html>";
	$message.="<body>";
	$message.="<style>";		
	$message.=".mail_tbl td{text-align:left; padding:2px; font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif;}";	
	$message.="</style>";
	$message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>Dear Student,</p></br>";
	$message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>OTP for reseting your password is $otp<br/></p></br>";
			
	$message.="</br>";
	$message.="</body>";
	$message.="</html>";
	$subject="Admission Portal : Forgot Password"; 
	if($email != '' )
	{
		$resp = sendGridMail($email,$subject,$message,'');

$data = json_decode($resp, true);
	}
	//$data = send_manual_mail($email,$subject,$message,$replay_to=null,$cc=null,'techsupport@logisys.net.in');

$query = "update collstud set fresetotp = '{$otp}', fresetotptime = now(),
	fresetotpcount = fresetotpcount+1 where fmobileno = '{$mob}'";
	$result = mysqli_query($conn,$query);

if($result == 1)
	{
		$response['femail'] = $email;
		$response['status'] = 'success';
		$response['msg'] = 'OTP sent to your registered mobile: '.$mob.' and email :'.$email;
		echo json_encode($response);
	}
	else
	{
		$response['status'] = 'error';
		$response['msg'] = 'Something went wrong';
		echo json_encode($response);
	}

}
else
{
	$response['status'] = 'error';
	$response['msg'] = 'Try with registered mobile number';
	echo json_encode($response);
}

mysqli_close($conn);

${this.title}

Code Editor : forgot-password.php