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 : create_use_qtn_name.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']; require_once "modules/questionnaire/time_inc.php"; //ส่วนหัว echo "<br />"; if(!(($index==1) or ($index==2) or ($index==5))){ echo "<table width='100%' border='0' align='center'>"; echo "<tr align='center'><td><font color='#006666' size='3'><strong>แบบสอบถาม</strong></font></td></tr>"; echo "</table>"; echo "<br />"; } //ส่วนฟอร์มรับข้อมูล if($index==1){ echo "<br>"; echo "<form id='frm1' name='frm1'>"; echo "<Center>"; echo "<Font color='#006666' Size=3><B>เพิ่มแบบสอบถาม</Font>"; echo "</Cener>"; echo "<Br><Br>"; echo "<Table width='70%' Border='0'>"; echo "<Tr><Td align='right'>ชื่อแบบสอบถาม </Td>"; echo "<td><INPUT TYPE='text' name='qtn_use_name' Size='40'></td></tr>"; echo "<Tr><Td align='right'>เลือกชุดคำถาม </Td>"; echo "<TD align='left'><select name='qtn_id'>"; echo "<option value=''>เลือก</option>"; $sql= "select * from questionnaire_qtn order by qtn_id desc"; $dbquery = mysqli_query($connect,$sql); While ($result = mysqli_fetch_array($dbquery)){ echo "<option value='$result[qtn_id]'>$result[qtn_name]</option>"; } echo "</select>" ; echo "</TD></TR>"; echo "<Tr><Td align='right'>คำชี้แจงการตอบแบบสอบถาม </Td>"; echo "<td><TEXTAREA NAME='qtn_desc' ROWS='5' COLS='60'></TEXTAREA></td></tr>"; echo "<Tr><Td align='right'>การใช้แบบสอบถาม </Td>"; echo "<td><input type='radio' name='type' value='0' checked>โรงเรียนละ 1 ฉบับ<br> <input type='radio' name='type' value='1'> คนละ 1 ฉบับ<br></td></tr>"; echo "<tr><td> </td><td> </td></tr>"; echo "<tr><td align='right'></td>"; echo "<td align='left'><INPUT TYPE='button' name='smb' value='ตกลง' onclick='goto_url(1)'> <INPUT TYPE='button' name='back' value='ย้อนกลับ' onclick='goto_url(0)'></td></tr>"; echo "</Table>"; echo "</form>"; } //ส่วนยืนยันการลบข้อมูล if($index==2) { echo "<table width='500' border='0' align='center'>"; echo "<tr><td align='center'><font color='#990000' size='4'>โปรดยืนยันความต้องการลบข้อมูลอีกครั้ง</font><br></td></tr>"; echo "<tr><td align=center>"; echo "<INPUT TYPE='button' name='smb' value='ยืนยัน' onclick='location.href=\"?option=questionnaire&task=main/create_use_qtn_name&index=3&id=$_GET[id]&page=$_REQUEST[page]\"'> <INPUT TYPE='button' name='back' value='ยกเลิก' onclick='location.href=\"?option=questionnaire&task=main/create_use_qtn_name&page=$_REQUEST[page]\"'"; echo "</td></tr></table>"; } //ส่วนลบข้อมูล if($index==3){ $sql = "delete from questionnaire_use_qtn_name where qtn_use_id=$_GET[id]"; $dbquery = mysqli_query($connect,$sql); } //ส่วนบันทึกข้อมูล if($index==4){ $rec_date = date("Y-m-d"); $sql = "insert into questionnaire_use_qtn_name(qtn_id,qtn_use_name,qtn_desc,type,officer,rec_date) values ('$_POST[qtn_id]','$_POST[qtn_use_name]','$_POST[qtn_desc]','$_POST[type]','$officer','$rec_date')"; $dbquery = mysqli_query($connect,$sql); } //ส่วนฟอร์มแก้ไขข้อมูล if ($index==5){ echo "<form id='frm1' name='frm1'>"; echo "<Center>"; echo "<Font color='#006666' Size=3><B>แก้ไขแบบสอบถาม</B></Font>"; echo "</Cener>"; echo "<Br><Br>"; $sql = "select * from questionnaire_use_qtn_name where qtn_use_id='$_GET[id]'"; $dbquery = mysqli_query($connect,$sql); $ref_result = mysqli_fetch_array($dbquery); echo "<Table width='50%' Border= '0'>"; echo "<Tr><Td align='right'>ชื่อแบบสอบถาม </Td>"; echo "<td><INPUT TYPE='text' name='qtn_use_name' Size='40' value='$ref_result[qtn_use_name]'></td></tr>"; echo "<Tr><Td align='right'>เลือกชุดคำถาม </Td>"; echo "<TD align='left'><select name='qtn_id'>"; echo "<option value=''>เลือก</option>"; $sql= "select * from questionnaire_qtn order by qtn_id desc"; $dbquery = mysqli_query($connect,$sql); While ($result = mysqli_fetch_array($dbquery)){ if($ref_result['qtn_id']==$result['qtn_id']){ echo "<option value='$result[qtn_id]' selected>$result[qtn_name]</option>"; } else{ echo "<option value='$result[qtn_id]'>$result[qtn_name]</option>"; } } echo "</select>" ; echo "</TD></TR>"; echo "<Tr><Td align='right'>คำชี้แแจง </Td>"; echo "<td><TEXTAREA NAME='qtn_desc' ROWS='5' COLS='60'>$ref_result[qtn_desc]</TEXTAREA></td></tr>"; echo "<Tr><Td align='right'>การใช้แบบสอบถาม </Td>"; if($ref_result['type']==1){ $check0=""; $check1="checked"; } else{ $check0="checked"; $check1=""; } echo "<td><input type='radio' name='type' value='0' $check0>โรงเรียนละ 1 ฉบับ<br> <input type='radio' name='type' value='1' $check1> คนละ 1 ฉบับ<br></td></tr>"; echo "<tr><td> </td><td> </td></tr>"; echo "<tr><td align='right'></td>"; echo "<td align='left'><INPUT TYPE='button' name='smb' value='ตกลง' onclick='goto_url_update(1)'> <INPUT TYPE='button' name='back' value='ย้อนกลับ' onclick='goto_url_update(0)'></td></tr>"; echo "</Table>"; echo "<Br>"; echo "<Input Type=Hidden Name='id' Value='$_GET[id]'>"; echo "<Input Type=Hidden Name='page' Value='$_GET[page]'>"; echo "</form>"; } //ส่วนปรับปรุงข้อมูล if ($index==6){ $sql = "update questionnaire_use_qtn_name set qtn_use_name='$_POST[qtn_use_name]',qtn_id='$_POST[qtn_id]',qtn_desc='$_POST[qtn_desc]',type='$_POST[type]' where qtn_use_id='$_POST[id]'"; $dbquery = mysqli_query($connect,$sql); } if($index==7){ $qtn_use_id=$_GET['qtn_use_id']; $sql="select * from questionnaire_use_qtn_name where qtn_use_id='$qtn_use_id' limit 0,1"; $dbquery = mysqli_query($connect,$sql); $row=mysqli_fetch_array($dbquery); $qtn_use_name=$row['qtn_use_name']; $qtn_id=$row['qtn_id']; $qtn_desc=$row['qtn_desc']; echo "<form id='frm1' name='frm1'>"; echo "<table border='0' width='75%' align='center'><tr><td align='right'>"; echo "<INPUT TYPE='button' name='smb2' value='<<กลับหน้าก่อน' onclick='goto_url(2)'>"; echo "</td></tr></table>"; echo "<Input Type='Hidden' Name='page' Value='$_GET[page]'>"; echo "</form>"; ?> <!-- *************************************** เก็บค่าตัวแปร --> <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']; echo " $qtn_name</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; } $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&page=$_GET[page]><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){ echo " <INPUT TYPE='text' NAME='ch$i' onKeyDown='DigitOnly();' onKeyUp='Setval(this)'> $qtn_qq_m_num"; } else if($qtn_op_id==2){ echo " <INPUT TYPE='text' NAME='ch$i'>"; }else if($qtn_op_id==3){ echo " <TEXTAREA NAME='ch$i' ROWS='7' COLS='50'></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); $k=0; while($row4=mysqli_fetch_row($result4)){ /////////////////////////// ชื่อ Radio echo " <INPUT TYPE='$row4[3]' NAME='ch$i$j'>$row4[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 } //ส่วนแสดงผล if(!(($index==1) or ($index==2) or ($index==5) or ($index==7))){ //ส่วนของการแยกหน้า $pagelen=20; // 1_กำหนดแถวต่อหน้า $url_link="option=questionnaire&task=main/create_use_qtn_name"; $sql = "select qtn_use_id from questionnaire_use_qtn_name"; $dbquery = mysqli_query($connect,$sql); $num_rows = mysqli_num_rows($dbquery ); $totalpages=ceil($num_rows/$pagelen); if(!(isset($_REQUEST['page']))){ $_REQUEST['page']=""; } if($_REQUEST['page']==""){ $page=$totalpages; if($page<2){ $page=1; } } else{ if($totalpages<$_REQUEST['page']){ $page=$totalpages; if($page<1){ $page=1; } } else{ $page=$_REQUEST['page']; } } $start=($page-1)*$pagelen; if(($totalpages>1) and ($totalpages<16)){ echo "<div align=center>"; echo "หน้า "; for($i=1; $i<=$totalpages; $i++) { if($i==$page){ echo "[<b><font size=+1 color=#990000>$i</font></b>]"; } else { echo "<a href=$PHP_SELF?$url_link&page=$i>[$i]</a>"; } } echo "</div>"; } if($totalpages>15){ if($page <=8){ $e_page=15; $s_page=1; } if($page>8){ if($totalpages-$page>=7){ $e_page=$page+7; $s_page=$page-7; } else{ $e_page=$totalpages; $s_page=$totalpages-15; } } echo "<div align=center>"; if($page!=1){ $f_page1=$page-1; echo "<<a href=$PHP_SELF?$url_link&page=1>หน้าแรก </a>"; echo "<<<a href=$PHP_SELF?$url_link&page=$f_page1>หน้าก่อน </a>"; } else { echo "หน้า "; } for($i=$s_page; $i<=$e_page; $i++){ if($i==$page){ echo "[<b><font size=+1 color=#990000>$i</font></b>]"; } else { echo "<a href=$PHP_SELF?$url_link&page=$i>[$i]</a>"; } } if($page<$totalpages) { $f_page2=$page+1; echo "<a href=$PHP_SELF?$url_link&page=$f_page2> หน้าถัดไป</a>>>"; echo "<a href=$PHP_SELF?$url_link&page=$totalpages> หน้าสุดท้าย</a>>"; } echo "</div>"; } //จบแยกหน้า $sql = "select *,questionnaire_use_qtn_name.qtn_use_id,questionnaire_use_qtn_name.rec_date,questionnaire_use_qtn_name.officer from questionnaire_use_qtn_name left join person_main on questionnaire_use_qtn_name.officer=person_main.person_id left join questionnaire_qtn on questionnaire_use_qtn_name.qtn_id=questionnaire_qtn.qtn_id order by questionnaire_use_qtn_name.qtn_use_id limit $start,$pagelen"; $dbquery = mysqli_query($connect,$sql); echo "<table width='95%' border='0' align='center'>"; echo "<Tr><Td colspan='5' align='left'><INPUT TYPE='button' name='smb' value='เพิ่มแบบสอบถาม' onclick='location.href=\"?option=questionnaire&task=main/create_use_qtn_name&index=1\"'></Td></Tr>"; echo "</table>"; echo "<table width='95%' border='1' align='center' style='border-collapse: collapse'>"; echo "<Tr bgcolor='#E6E6E6'><Td align='center' width='50'>ที่</Td><Td align='center'>ชื่อแบบสอบถาม</Td><Td align='center'>ชื่อชุดคำถาม</Td><Td align='center'>คำชี้แจงการตอบแบบสอบถาม</Td><Td align='center'>การใช้งาน</Td><Td align='center'>วันที่สร้าง</Td><Td align='center' width='150'>ผู้สร้าง</Td><Td align='center' width='50'>ลบ</Td><Td align='center' width='50'>แก้ไข</Td><Td align='center' width='70'>กำหนด<br>รายละเอียด</Td><Td align='center' width='50'>แสดง</Td></Tr>"; $N=(($page-1)*$pagelen)+1; //*เกี่ยวข้องกับการแยกหน้า $M=1; While ($result = mysqli_fetch_array($dbquery)) { $id = $result['qtn_use_id']; $prename = $result['prename']; $name = $result['name']; $surname = $result['surname']; if(($M%2) == 0) $color="#FFFFC"; else $color="#FFFFFF"; echo "<Tr bgcolor=$color><Td align='center'>$N</Td>"; echo "<Td align='left'>$result[qtn_use_name]</Td>"; echo "<Td align='left'>$result[qtn_name]</Td>"; echo "<Td align='left'>$result[qtn_desc]</Td>"; echo "<Td align='left'>"; if($result['type']==1){ echo "คนละ 1 ฉบับ"; } else{ echo "โรงเรียนละ 1 ฉบับ"; } echo "</Td>"; echo "<Td align='center'>"; echo thai_date_3($result['rec_date']); echo "</Td>"; echo "<Td align='left'>$prename$name $surname</Td>"; if($result['officer']==$officer){ echo "<Td align='center'><a href=?option=questionnaire&task=main/create_use_qtn_name&index=2&id=$id&page=$page><img src=images/drop.png border='0' alt='ลบ'></a></Td> <Td align='center'><a href=?option=questionnaire&task=main/create_use_qtn_name&index=5&id=$id&page=$page><img src=images/edit.png border='0' alt='แก้ไข'></a></Td>"; echo "<Td align='center'><a href=?option=questionnaire&task=main/create_use_qtn_detail&qtn_use_id=$id&index=4><img src=images/edit.png border='0'></a></Td>"; } else{ echo "<td></td><td></td><td></td>"; } echo "<Td align='center'><a href=?option=questionnaire&task=main/create_use_qtn_name&qtn_use_id=$id&index=7&page=$page><img src=images/b_browse.png border='0'></a></Td>"; echo "</Tr>"; $M++; $N++; //*เกี่ยวข้องกับการแยกหน้า } echo "</Table>"; } ?> <script> function goto_url(val){ if(val==0){ callfrm("?option=questionnaire&task=main/create_use_qtn_name"); // page ย้อนกลับ }else if(val==1){ if(frm1.qtn_use_name.value == ""){ alert("กรุณากรอกชื่อแบบสอบถาม"); }else if(frm1.qtn_id.value == ""){ alert("กรุณาเลือกชุดคำถาม"); }else if(frm1.qtn_desc.value == ""){ alert("กรุณากรอกคำชี้แจงการตอบแบบสอบถาม"); }else{ callfrm("?option=questionnaire&task=main/create_use_qtn_name&index=4"); //page ประมวลผล } } else if(val==2){ callfrm("?option=questionnaire&task=main/create_use_qtn_name"); //page ประมวลผล } } function goto_url_update(val){ if(val==0){ callfrm("?option=questionnaire&task=main/create_use_qtn_name"); // page ย้อนกลับ }else if(val==1){ if(frm1.qtn_use_name.value == ""){ alert("กรุณากรอกชื่อแบบสอบถาม"); }else if(frm1.qtn_id.value == ""){ alert("กรุณาเลือกแบบสอบต้นฉบับที่จะใช้"); }else if(frm1.qtn_desc.value == ""){ alert("กรุณากรอกคำชี้แจงการตอบแบบสอบถาม"); }else{ callfrm("?option=questionnaire&task=main/create_use_qtn_name&index=6"); //page ประมวลผล } } } </script>
Close
