Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 3.145.16.251
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
student /
sikkim /
css /
copy_to_oasis /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
ack_exam_app_form.php
11.56
KB
-rwxr-xr-x
mregistry.php
50.72
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : ack_exam_app_form.php
<?php class ack_exam_app_form { function __construct($aobj_context) { session_start(); $this->aobj_context=$aobj_context; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $this->user_id=$_SESSION['user_id'] ; $this->collcode=$_SESSION['collcode']; $this->log_name = $_SESSION['usr']; } function AcknowledgeSelectedExamApplications() { $checked_app_nos = ($this->aobj_context->mobj_data["checked_app_nos"]); $exp_arr=explode(",",$checked_app_nos); foreach($exp_arr as $apk) { $update=" update appcandsum set FACKDATE = now(), FACKUSER = '{$this->log_name}' where APPNO = '{$apk}' and FCOLLCODE ='{$this->collcode}' "; $lobj_get_data = $this->aobj_context->mobj_db->Execute($update); $this->UpdateCandSumCandDet($apk); $this->UpdateStudeFee($apk); } $data="Application(s) acknowledged successfully."; echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); } function UpdateStudeFee($apk) { $get_app_stud_fee="SELECT FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FFEECODE, FAMOUNT FROM appstudfee WHERE APPNO='{$apk}' and FCOLLCODE='{$this->collcode}' "; $lobj_get_app_stud_fee = $this->aobj_context->mobj_db->GetAll($get_app_stud_fee); foreach($lobj_get_app_stud_fee as $ak=>$av) { $FCOLLCODE=$av['FCOLLCODE']; $FDEGREE=$av['FDEGREE']; $FEXAMNO=$av['FEXAMNO']; $FREGNO=$av['FREGNO']; $FFEECODE=$av['FFEECODE']; $FAMOUNT=$av['FAMOUNT']; $get_dup_cnt="SELECT count(1) as dup_cnt FROM studfee where FDEGREE='{$FDEGREE}' AND FEXAMNO='{$FEXAMNO}' AND FCOLLCODE='{$FCOLLCODE}' AND FREGNO='{$FREGNO}' AND FFEECODE='{$FFEECODE}' and FCOLLCODE='{$this->collcode}'"; $lobj_get_dup_cnt = $this->aobj_context->mobj_db->GetRow($get_dup_cnt); //echo "<br>".$get_dup_cnt; $dup_cnt=$lobj_get_dup_cnt['dup_cnt']; if($dup_cnt==0) { $insert_into_student_fee="insert into studfee ( FDEGREE,FEXAMNO,FCOLLCODE,FREGNO,FFEECODE,FAMOUNT,FLOGNAME,FLOGDATE ) VALUES ( '{$FDEGREE}', '{$FEXAMNO}', '{$this->collcode}', '{$FREGNO}', '{$FFEECODE}', '{$FAMOUNT}', '{$this->log_name}', NOW() )"; $lobj_insert_into_student_fee = $this->aobj_context->mobj_db->Execute($insert_into_student_fee); //echo $insert_into_student_fee."<br>"; } else { $update=" update studfee set FAMOUNT={$FAMOUNT}, FLOGNAME='{$this->log_name}',FLOGDATE=now() where FDEGREE='{$FDEGREE}' AND FEXAMNO='{$FEXAMNO}' AND FCOLLCODE='{$FCOLLCODE}' AND FREGNO='{$FREGNO}' AND FFEECODE='{$FFEECODE}' and FCOLLCODE='{$this->collcode}'"; $lobj_update = $this->aobj_context->mobj_db->Execute($update); } } } function UpdateCandSumCandDet($apk) { $update_cand_sum="UPDATE appcandsum a,candsum c SET c.FEXAMFEEA=if(ifnull(c.FEXAMFEEA,0) <=0,ifnull(a.FEXAMFEEA,0),ifnull(c.FEXAMFEEA,0)), c.FEXAMFEEB=if(ifnull(c.FEXAMFEEB,0) <=0,ifnull(a.FEXAMFEEB,0),ifnull(c.FEXAMFEEB,0)), c.FEXAMFEEC=if(ifnull(c.FEXAMFEEC,0) <=0,ifnull(a.FEXAMFEEC,0),ifnull(c.FEXAMFEEC,0)), c.FEXAMFEED=if(ifnull(c.FEXAMFEED,0) <=0,ifnull(a.FEXAMFEED,0),ifnull(c.FEXAMFEED,0)), c.FEXAMFEEE=if(ifnull(c.FEXAMFEEE,0) <=0,ifnull(a.FEXAMFEEE,0),ifnull(c.FEXAMFEEE,0)), c.FEXAMFEEF=if(ifnull(c.FEXAMFEEF,0) <=0,ifnull(a.FEXAMFEEF,0),ifnull(c.FEXAMFEEF,0)), c.FEXAMFEEG=if(ifnull(c.FEXAMFEEG,0) <=0,ifnull(a.FEXAMFEEG,0),ifnull(c.FEXAMFEEG,0)), c.FEXAMFEEH=if(ifnull(c.FEXAMFEEH,0) <=0,ifnull(a.FEXAMFEEH,0),ifnull(c.FEXAMFEEH,0)), c.FEXAMFEEI=if(ifnull(c.FEXAMFEEI,0) <=0,ifnull(a.FEXAMFEEI,0),ifnull(c.FEXAMFEEI,0)), c.FEXAMFEEJ=if(ifnull(c.FEXAMFEEJ,0) <=0,ifnull(a.FEXAMFEEJ,0),ifnull(c.FEXAMFEEJ,0)), c.FTOTALFEE=a.FTOTALFEE, c.frecptdate = date(a.FACKDATE) WHERE a.fdegree = c.fdegree and a.fregno = c.FREGNO AND a.APPNO='{$apk}' and a.FCOLLCODE='{$this->collcode}'"; $lobj_update_cand_sum = $this->aobj_context->mobj_db->Execute($update_cand_sum); $get_app_cand_det="SELECT FDEGREE,FEXAMNO,FCOLLCODE,FREGNO,FSUBCODE,FINSERTED,FPRESENT,FYEAR,FEXAMTYPE FROM appcanddet WHERE APPNO='{$apk}'"; $lobj_get_app_cand_det = $this->aobj_context->mobj_db->GetAll($get_app_cand_det); foreach($lobj_get_app_cand_det as $ak=>$av) { $FCOLLCODE=$av['FCOLLCODE']; $FDEGREE=$av['FDEGREE']; $FEXAMNO=$av['FEXAMNO']; $FREGNO=$av['FREGNO']; $FSUBCODE=$av['FSUBCODE']; $FINSERTED=$av['FINSERTED']; $FPRESENT=$av['FPRESENT']; $FYEAR=$av['FYEAR']; $FEXAMTYPE=$av['FEXAMTYPE']; $get_cand_det_cnt="select count(1) as cnt from canddet where FDEGREE='{$FDEGREE}' AND FEXAMNO='{$FEXAMNO}' AND FCOLLCODE='{$FCOLLCODE}' AND FREGNO='{$FREGNO}' AND FSUBCODE='{$FSUBCODE}'"; $lobj_get_cand_det_cnt = $this->aobj_context->mobj_db->GetRow($get_cand_det_cnt); $cnt=$lobj_get_cand_det_cnt['cnt']; if($cnt>0) { $update=" update canddet set FINSERTED='{$FINSERTED}', FPRESENT='{$FPRESENT}' where FDEGREE='{$FDEGREE}' AND FEXAMNO='{$FEXAMNO}' AND FCOLLCODE='{$FCOLLCODE}' AND FREGNO='{$FREGNO}' AND FSUBCODE='{$FSUBCODE}' "; $lobj_update = $this->aobj_context->mobj_db->Execute($update); } else { $insert=" INSERT INTO canddet (FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, FINSERTED, FPRESENT, FYEAR, FEXAMTYPE ) values ( '{$FDEGREE}', '{$FEXAMNO}', '{$FCOLLCODE}', '{$FREGNO}', '{$FSUBCODE}', '{$FINSERTED}', '{$FPRESENT}', '{$FYEAR}', '{$FEXAMTYPE}' )"; $lobj_insert = $this->aobj_context->mobj_db->Execute($insert); } } } function DisplayAllAckExamApplications() { $app_no_from = ($this->aobj_context->mobj_data["app_no_from"]); $app_no_from=str_pad($app_no_from, 10, "0", STR_PAD_LEFT); $app_no_to = ($this->aobj_context->mobj_data["app_no_to"]); $get_data=" SELECT DISTINCT r.APPNO,DATE_FORMAT(r.FDATE,'%d/%m/%Y') AS FAPPDATE,r.FREGNO,s.FNAME,r.FDEGREE,r.FTOTALFEE FROM appcandsum r INNER JOIN student s ON s.FREGNO=r.FREGNO WHERE r.FCOLLCODE='{$this->collcode}' AND (FACKDATE IS NULL OR FACKDATE='') AND LPAD(r.APPNO,10,'0')>='{$app_no_from}' AND LPAD(r.APPNO,10,'0')<='{$app_no_to}' "; $lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data); $str_reval.="<br>"; $str_reval.="<table style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='reval_table_data' width='100%' border='0' cellspacing='0' cellpadding='0'>"; $str_reval.="<tr class='tr_bg1'>"; $str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sl. No.</td>"; $str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Application No</td>"; $str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Date</td>"; $str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Reg. No.</td>"; $str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Student Name</td>"; $str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Degree</td>"; $str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Amount</td>"; $str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Select</td>"; $str_reval.="</tr>"; $k=0; $sl_no=1; foreach($lobj_get_data as $ak=>$av) { $APPNO=$av['APPNO']; $FREGNO=$av['FREGNO']; $FAPPDATE=$av['FAPPDATE']; $FNAME=$av['FNAME']; $FDEGREE=$av['FDEGREE']; $FAMOUNT=$av['FTOTALFEE']; if($k%2==0) $class='tbl_row1'; else $class='tbl_row_alter1'; $str_reval.="<tr>"; $str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' >{$sl_no}</td>"; $str_reval.="<td class='{$class}' style=' font-size:12px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; text-align:center; ' > <a href=# style='color:blue;' onclick='PrintOnlineExamApplicationForm(\"{$APPNO}\")'>{$APPNO}</a></td>"; $str_reval.="<td class='{$class}' style=' font-size:12px; text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; text-align:center; ' >{$FAPPDATE} </td>"; $str_reval.="<td class='{$class}' style=' font-size:12px; text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; text-align:center; ' > {$FREGNO}</td>"; $str_reval.="<td class='{$class}' style=' font-size:12px; text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; text-align:center; ' >{$FNAME}</td>"; $str_reval.="<td class='{$class}' style=' font-size:12px; text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; text-align:center; ' >{$FDEGREE}</td>"; $str_reval.="<td class='{$class}' style=' font-size:12px; text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; text-align:center; ' >{$FAMOUNT}</td>"; $str_reval.="<td class='{$class}' align='center' style=' font-size:12px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-weight:bold;text-align:center;' ><input type='checkbox' {$disabled} id='ack_check_box_{$APPNO}' /></td>"; // $str_reval.="<td class='{$class}' style=' font-size:12px; text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; text-align:center; ' >{$disabled_txt}</td>"; $str_reval.="</tr>"; $sl_no++; $k++; } $str_reval.="</table>"; $str_reval.="<br>"; $arr['html']=$str_reval; echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } } function DisplayAllAckExamApplications($aobj_context) { $class_obj=new ack_exam_app_form($aobj_context); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj->DisplayAllAckExamApplications(); } function AcknowledgeSelectedExamApplications($aobj_context) { $class_obj=new ack_exam_app_form($aobj_context); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj->AcknowledgeSelectedExamApplications(); } ?>
Close
