Software: Apache/2.2.3 (CentOS). PHP/5.1.6 uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44 uid=48(apache) gid=48(apache) groups=48(apache) Safe-mode: OFF (not secure) /var/www/html/report/person/ drwxr-xr-x |
Viewing file: detailperfi.php (13.41 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) | 0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_in<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } //จำนวนชั่วโมงวิชาชีพ(พัฒนาภายใน) if($case==2){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_in<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_in<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } //จำนวนชั่วโมงคุณธรรมจริยธรรม(พัฒนาภายใน) if($case==3){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_in<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_in<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } //จำนวนชั่วโมงวิชาการ(พัฒนาภายนอก) ใช้งบ if($case==4){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_outbudget<>0 AND ac_money<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_outbudget<>0 AND ac_money<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } //จำนวนชั่วโมงวิชาชีพ(พัฒนาภายนอก) ใช้งบ if($case==5){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_outbudget<>0 AND pr_money<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_outbudget<>0 AND pr_money<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } //จำนวนชั่วโมงคุณธรรมจริยธรรม(พัฒนาภายนอก) ใช้งบ if($case==6){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_outbudget<>0 AND moral_money<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_outbudget<>0 AND moral_money<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } //จำนวนชั่วโมงวิชาการ(พัฒนาภายนอกไม่ใช้งบ) if($case==7){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_out<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_out<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } //จำนวนชั่วโมงวิชาชีพ(พัฒนาภายนอกไม่ใช้งบ) if($case==8){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_out<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_out<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } //จำนวนชั่วโมงคุณธรรมจริยธรรม(พัฒนาภายนอกไม่ใช้งบ) if($case==9){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_out<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_out<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } $query2 = "SELECT * FROM persontb WHERE personCode=$id "; $result2 = $conn->query($query2); while($values = $result2->fetch_assoc()){$name=$values['name']." ".$values['surName'];} ?>
bool(false) |
:: Command execute :: | |
:: Shadow's tricks :D :: | |
Useful Commands
|
:: Preddy's tricks :D :: | |
Php Safe-Mode Bypass (Read Files)
|
--[ c999shell v. 1.0 pre-release build #16 Modded by Shadow & Preddy | RootShell Security Group | r57 c99 shell | Generation time: 0.0053 ]-- |