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.140.195.142
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 /
sms /
[ HOME SHELL ]
Name
Size
Permission
Action
google-api-php-client
[ DIR ]
drwxr-xr-x
kreait_firebase
[ DIR ]
drwxrwxr-x
admission_sms_push.php
2.3
KB
-rwxr-xr-x
admission_sms_push_bnu.php
2.29
KB
-rwxr-xr-x
admsumsendsms.php
6.12
KB
-rwxr-xr-x
admsumsendsms_bnu_17102018.php
8.06
KB
-rwxr-xr-x
admsumsendsms_bnu_29102018.php
12.17
KB
-rwxr-xr-x
admsumsendsms_bnu_adm_pg.php
18.03
KB
-rwxr-xr-x
admsumsendsms_bnu_wait.php
27.52
KB
-rwxr-xr-x
attDegwiseReport.php
9
KB
-rw-r--r--
cron_send_sms_interana.php
1.18
KB
-rwxr-xr-x
cronjob_sendmail.php
5.81
KB
-rwxr-xr-x
cronjob_sendsms.php
5.35
KB
-rwxr-xr-x
cronjob_sendsms_bcu_mo.php
3.18
KB
-rwxr-xr-x
cronjob_sendsms_bnu.php
3.84
KB
-rwxr-xr-x
cronjob_sendsms_bnu_old.php
2.55
KB
-rwxr-xr-x
cronjob_sendsms_dud.php
2.84
KB
-rwxr-xr-x
cronjob_sendsms_dud_mo.php
3.16
KB
-rwxr-xr-x
cronjob_sendsms_old_smssum.php
3.61
KB
-rwxr-xr-x
google-api-php-client-v2.7.1-P...
13.11
MB
-rwxr-xr-x
import_data.php
3.21
KB
-rwxr-xr-x
mail.php
459
B
-rwxr-xr-x
sendGridMail.php
1.29
KB
-rwxr-xr-x
sendnotifapi.php
5.18
KB
-rwxr-xr-x
sendsmsapi.php
759
B
-rwxr-xr-x
sendsmsapi_adm.php
6.61
KB
-rw-rw-r--
sendsmsapi_new.php
6.06
KB
-rw-r--r--
sendsmsapi_onex.php
6.84
KB
-rw-r--r--
sendsmsapi_onex_new.php
4.59
KB
-rw-r--r--
sendsmsapiv1.php
9.48
KB
-rwxr-xr-x
sendsmsapiv1_07082024.php
9.47
KB
-rwxr-xr-x
sms.php
422
B
-rwxr-xr-x
sms_statistics.php
2.99
KB
-rwxr-xr-x
sms_test.php
1.21
KB
-rw-r--r--
stud_data_push.php
1.43
KB
-rwxr-xr-x
teach_data_push.php
1.47
KB
-rwxr-xr-x
test.txt
1.44
KB
-rwxr-xr-x
test_firebase_service.php
237
B
-rwxr-xr-x
validateRegno.php
2.4
KB
-rwxr-xr-x
vskub_pget_smsstat.php
2.45
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : attDegwiseReport.php
<?php $main_src = substr($_SERVER['SCRIPT_FILENAME'], 0, strlen($_SERVER['SCRIPT_FILENAME']) - 7); error_reporting(E_ALL); ini_set('display_errors', TRUE); ini_set('display_startup_errors', TRUE); date_default_timezone_set('GMT+5:30'); ini_set('max_execution_time', 300); ini_set('memory_limit', '2G'); if (PHP_SAPI == 'cli') die('This example should only be run from a Web Browser'); /** Include PHPExcel */ $pdf_writer_class = $main_src . '/PHPExcel/Classes/PHPExcel.php'; require_once($pdf_writer_class); function getheaders($objPHPExcel, $fileName) { // To Fit To Page while printing ini_set('max_execution_time', '300'); $objPHPExcel->getActiveSheet()->getPageSetup()->setRowsToRepeatAtTopByStartAndEnd(1); $objPHPExcel->getActiveSheet()->getPageSetup()->setFitToWidth(1); $objPHPExcel->getActiveSheet()->getPageSetup()->setFitToHeight(0); $objPHPExcel->getActiveSheet()->getPageSetup()->setHorizontalCentered(true); $objPHPExcel->getActiveSheet()->getPageSetup()->setVerticalCentered(false); // Redirect output to a client’s web browser (Excel5) header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename=' . $fileName); header('Cache-Control: max-age=0'); // If you're serving to IE 9, then the following may be needed header('Cache-Control: max-age=1'); // If you're serving to IE over SSL, then the following may be needed header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified header('Cache-Control: cache, must-revalidate'); // HTTP/1.1 header('Pragma: public'); // HTTP/1.0 ob_clean(); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); } function attDegwiseReport($aobj_context) { session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $collcode=$_SESSION['collcode']; $funivcode = $_SESSION['FUNIVCODE']; $degree = $aobj_context->mobj_data["degree"]; $degexam = $aobj_context->mobj_data["degexam"]; $yearmode = $aobj_context->mobj_data["yearmode"]; $section = $aobj_context->mobj_data["section"]; $query = "select distinct su.fsubshort from attend_det a inner join subject su on su.fdegree = a.fdegree and su.fexamno = a.fexamno and su.fcsubcode = a.fsubcode where a.fdegree = 'BCI22' and date_format(a.fdate,'%Y-%m-%d') between '2024-03-01' and '2024-03-30' group by su.fsubshort order by su.fsubshort"; $result = $aobj_context->mobj_db->GetAll($query); $string = ""; foreach($result as $val) { $fsubshort = $val['fsubshort']; $string .= "`F$fsubshort` varchar(50) DEFAULT NULL,"; } $query = "create temporary table `attenddetsum_18042024` ( `FREGNO` varchar(20) NOT NULL, `FDEGREE` varchar(5) DEFAULT NULL, `FCOLLCODE` varchar(5) DEFAULT NULL, `FNAME` varchar(200) DEFAULT NULL, $string PRIMARY KEY (`FREGNO`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1"; //var_dump($query); $updateresult = $aobj_context->mobj_db->Execute($query); $query = "insert into attenddetsum_18042024(FREGNO,FNAME,FDEGREE,FCOLLCODE) select distinct a.fregno,st.fname,st.fdegree,st.fcollcode from attend_det a inner join student st on a.fregno = st.fregno where a.fdegree = 'BCI22' and date_format(a.fdate,'%Y-%m-%d') between '2024-03-01' and '2024-03-30' group by a.fregno order by a.fregno"; $updateresult = $aobj_context->mobj_db->Execute($query); $query = "select a.fregno, a.fname, group_concat(a.fsubshort,'*',a.cond,'*',a.fpresent order by a.fsubshort SEPARATOR '|') as subdet from (select distinct a.fregno,st.fname,su.fsubshort,a.fsubcode,sum(a.fnoclass) as cond, sum(if(a.fpresent = 'P',a.fnoclass,0)) as fpresent from attend_det a inner join student st on a.fregno = st.fregno inner join subject su on su.fdegree = a.fdegree and su.fexamno = a.fexamno and su.fcsubcode = a.fsubcode where a.fdegree = 'BCI22' and date_format(a.fdate,'%Y-%m-%d') between '2024-03-01' and '2024-03-30' group by a.fregno,a.fsubcode order by a.fregno) a group by a.fregno"; $result = $aobj_context->mobj_db->GetAll($query); $subarry = []; foreach($result as $val) { $subdet = $val['subdet']; $fregno = $val['fregno']; $subdetarry = explode("|",$subdet); foreach($subdetarry as $val1) { $subdetatt = explode("*",$val1); $subshort = $subdetatt[0]; $subatt = "$subdetatt[1]*$subdetatt[2]"; $upd = "update attenddetsum_18042024 set F$subshort = '{$subatt}' where fregno = '{$fregno}'"; //var_dump($upd); $res = $aobj_context->mobj_db->Execute($upd); } } $qury = "select * from attenddetsum_18042024 where fdegree = 'BCI22' and fcollcode = 'rrit'"; $result = $aobj_context->mobj_db->GetAll($query); var_dump($result); die(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $yearmode = explode("*",$yearmode); $year = $yearmode[0]; $examtye = $yearmode[1]; $main_src_obj=(explode("/",$_SERVER["REQUEST_URI"])); $main_src=$main_src_obj[1]; $pdf_writer_class=$aobj_context->main_src."/maya-pdf/fpdf.php"; $root_pdf_file_download=$aobj_context->main_src."/Report_details/output/report_me_student_list.pdf"; include($pdf_writer_class); if($funivcode=="055"){ $scpa="if(('{$funivcode}' = '041' || '{$funivcode}' = '042'),r.FPREVTOT, IF(r.fcgpa = 0.00, '-', r.fcgpa)) AS fcgpa,"; }else{ $scpa="if(('{$funivcode}' = '041' || '{$funivcode}' = '042'),r.FPREVTOT, r.fcgpa) as fcgpa,"; } $lobj_fee_data = "select distinct r.fregno, s.fname, r.fdegree, r.ftotmarks, r.fmaxmarks, if(r.fpercent = '',' - ',ifnull(r.fpercent,' - ')) as fpercent, fclass, FSCHEME, r.fmcnumber as remarks, $scpa if(('{$funivcode}' = '041' || '{$funivcode}' = '042'),r.FPERCENT, r.fsgpa) as fsgpa from resmarks r inner join student s on r.fdegree = s.fdegree and r.fregno = s.fregno where s.fdegree = '{$degree}' and s.fcollcode = '{$collcode}' and r.fexamno = '{$degexam}' and r.fyear = '{$year}' and r.fexamtype = '{$examtye}'"; $result = $aobj_context->mobj_db->GetAll($lobj_fee_data); // Example: $objPHPExcel = new PHPExcel(); $fileName = 'results_sheet.xls'; // var_dump($subdet);die(); $objPHPExcel->getProperties()->setCreator("Uniclare") ->setLastModifiedBy("Me")->setTitle("My Excel Sheet") ->setSubject("My Excel Sheet")->setDescription("Excel Sheet") ->setKeywords("Excel Sheet")->setCategory("Me"); $objPHPExcel->setActiveSheetIndex(0); // Add column headers and make them bold $styleArray = array( 'borders' => array( 'allborders' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN, 'color' => array('argb' => '000000'), ), ), ); $count = ""; $alpha = ['A', 'B', 'C', 'D', 'E', 'F', 'G']; $j=4; // if($subdet == "CIE"){ $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setSize(12); $objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(25); $objPHPExcel->getActiveSheet()->getRowDimension(2)->setRowHeight(25); $objPHPExcel->getActiveSheet()->getRowDimension(3)->setRowHeight(25); $objPHPExcel->getActiveSheet()->getColumnDimension('A1')->setwidth(30); $objPHPExcel->getActiveSheet()->freezePane('A1'); // $objPHPExcel->getActiveSheet()->freezePane('D1'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Sl No.'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'USN'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Student Name '); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'S.G.P.A'); $objPHPExcel->getActiveSheet()->setCellValue('E1', 'C.G.P.A'); $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Remarks'); $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Withheld Remarks'); $objPHPExcel->getActiveSheet()->getStyle('A1:G1')->applyFromArray($styleArray); $slNo = 2; foreach ($result as $key => $value) { $objPHPExcel->getActiveSheet()->getRowDimension($slNo)->setRowHeight(25); $objPHPExcel->getActiveSheet()->setCellValue('A' . $slNo, $slNo+1)->getColumnDimension('A')->setwidth(8); $objPHPExcel->getActiveSheet()->setCellValue('B' . $slNo, $value['fregno'])->getColumnDimension('B')->setwidth(15); $objPHPExcel->getActiveSheet()->setCellValue('C' . $slNo, $value['fname'])->getColumnDimension('C')->setwidth(35); $objPHPExcel->getActiveSheet()->setCellValue('D' . $slNo,$value['fsgpa'])->getColumnDimension('D3')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('E' . $slNo,$value['fcgpa'])->getColumnDimension('D3')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('F' . $slNo,$value['fclass'])->getColumnDimension('D3')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('G' . $slNo,$value['remarks'])->getColumnDimension('D3')->setwidth(10); $slNo++; } getheaders($objPHPExcel, $fileName); } ?>
Close