Changeset 15315

Timestamp:

2007/08/20 18:17:01 (17 years ago)

Author:

adachi

Message:

ログインできない問題の修正

File:

• branches/rel/data/lib/slib.php (modified) (152 diffs)

branches/rel/data/lib/slib.php

@@ -29 +29 @@
         }
     }
-    
+
     $objQuery = new SC_Query($dsn, true, true);
     list($db_type) = split(":", $dsn);
@@ -35 +35 @@
         $val = $objQuery->getOne("select version()");
         $version = "MySQL " . $val;
-    }   
+    }
     if($db_type == 'pgsql') {
         $val = $objQuery->getOne("select version()");
@@ -53 +53 @@
         }
     }
-    
+
     $objQuery = new SC_Query($dsn, true, true);
     // Àµ¾ï¤ËÀܳ¤µ¤ì¤Æ¤¤¤ë¾ì¹ç
@@ -65 +65 @@
                         pg_class
                     WHERE
-                        (relkind = 'r' OR relkind = 'v') AND 
-                        relname = ? 
+                        (relkind = 'r' OR relkind = 'v') AND
+                        relname = ?
                     GROUP BY
                         relname";
@@ -96 +96 @@
     // ¥Æ¡¼¥Ö¥ë¤¬Ìµ¤±¤ì¤Ð¥¨¥é¡¼
     if(!sfTabaleExists($table_name, $dsn)) return false;
-    
+
     $objQuery = new SC_Query($dsn, true, true);
     // Àµ¾ï¤ËÀܳ¤µ¤ì¤Æ¤¤¤ë¾ì¹ç
     if(!$objQuery->isError()) {
         list($db_type) = split(":", $dsn);
-        
+
         // ¥«¥é¥à¥ê¥¹¥È¤ò¼èÆÀ
         $arrRet = sfGetColumnList($table_name, $objQuery, $db_type);
@@ -110 +110 @@
         }
     }
-    
+
     // ¥«¥é¥à¤òÄɲ乤ë
     if($add){
@@ -116 +116 @@
         return true;
     }
-    
+
     return false;
 }
@@ -132 +132 @@
     // ¥Æ¡¼¥Ö¥ë¤¬Ìµ¤±¤ì¤Ð¥¨¥é¡¼
     if(!sfTabaleExists($table_name, $dsn)) return false;
-    
+
     $objQuery = new SC_Query($dsn, true, true);
     // Àµ¾ï¤ËÀܳ¤µ¤ì¤Æ¤¤¤ë¾ì¹ç
     if(!$objQuery->isError()) {
-        list($db_type) = split(":", $dsn);      
+        list($db_type) = split(":", $dsn);
         switch($db_type) {
         case 'pgsql':
@@ -144 +144 @@
         case 'mysql':
             // ¥¤¥ó¥Ç¥Ã¥¯¥¹¤Î¸ºß³Îǧ
-            $arrRet = $objQuery->getAll("SHOW INDEX FROM ? WHERE Key_name = ?", array($table_name, $index_name));           
+            $arrRet = $objQuery->getAll("SHOW INDEX FROM ? WHERE Key_name = ?", array($table_name, $index_name));
             break;
         default:
@@ -154 +154 @@
         }
     }
-    
+
     // ¥¤¥ó¥Ç¥Ã¥¯¥¹¤òºîÀ®¤¹¤ë
     if($add){
@@ -162 +162 @@
             break;
         case 'mysql':
-            $objQuery->query("CREATE INDEX ? ON ? (?(?))", array($index_name, $table_name, $col_name, $length));            
+            $objQuery->query("CREATE INDEX ? ON ? (?(?))", array($index_name, $table_name, $col_name, $length));
             break;
         default:
@@ -168 +168 @@
         }
         return true;
-    }   
+    }
     return false;
 }
@@ -193 +193 @@
         $objQuery->exec($sql);
     }
-    
+
     return $ret;
 }
@@ -201 +201 @@
  * ¥Ç¡¼¥¿¤¬Â¸ºß¤¹¤ë¾ì¹ç¡¢É¬¤º1°Ê¾å¤Î¿ôÃͤ¬ÀßÄꤵ¤ì¤Æ¤¤¤ë¡£
  * 0¤òÊÖ¤·¤¿¾ì¹ç¤Ï¡¢¸Æ¤Ó½Ð¤·¸µ¤ÇÂбþ¤¹¤ë¤³¤È¡£
- * 
+ *
  * @param $control_id ´ÉÍýID
  * @param $dsn DataSource
@@ -232 +232 @@
         $control_flg = $arrSiteControl[0]["control_flg"];
     }
-    
+
     return $control_flg;
 }
@@ -240 +240 @@
     if($objQuery == "") $objQuery = new SC_Query();
     $arrRet = array();
-    
+
     // postgresql¤Èmysql¤È¤Ç½èÍý¤òʬ¤±¤ë
     if ($db_type == "pgsql") {
@@ -268 +268 @@
             sfErrorHeader(">> /install/index.php¤Ï¡¢¥¤¥ó¥¹¥È¡¼¥ë´°Î»¸å¤Ë¥Õ¥¡¥¤¥ë¤òºï½ü¤·¤Æ¤¯¤À¤µ¤¤¡£");
         }
-        
+
         // µì¥Ð¡¼¥¸¥ç¥ó¤Îinstall.php¤Î¥Á¥§¥Ã¥¯
         $path = HTML_PATH . "install.php";
         if(file_exists($path)) {
             sfErrorHeader(">> /install.php¤Ï¥»¥­¥å¥ê¥Æ¥£¡¼¥Û¡¼¥ë¤È¤Ê¤ê¤Þ¤¹¡£ºï½ü¤·¤Æ¤¯¤À¤µ¤¤¡£");
-        }       
+        }
     }
 }
@@ -312 +312 @@
     $GLOBAL_ERR.= " </tr>\n";
     $GLOBAL_ERR.= "</table>\n";
-    
+
     if($print) {
         print($GLOBAL_ERR);
@@ -320 +320 @@
 /* ¥¨¥é¡¼¥Ú¡¼¥¸¤Îɽ¼¨ */
 function sfDispError($type) {
-    
+
     class LC_ErrorPage {
         function LC_ErrorPage() {
@@ -330 +330 @@
     $objPage = new LC_ErrorPage();
     $objView = new SC_AdminView();
-    
+
     switch ($type) {
         case LOGIN_ERROR:
@@ -348 +348 @@
             break;
     }
-    
+
     $objView->assignobj($objPage);
     $objView->display(LOGIN_FRAME);
-    
+
     exit;
 }
@@ -358 +358 @@
 function sfDispSiteError($type, $objSiteSess = "", $return_top = false, $err_msg = "", $is_mobile = false) {
     global $objCampaignSess;
-    
+
     if ($objSiteSess != "") {
         $objSiteSess->setNowPage('error');
     }
-    
+
     class LC_ErrorPage {
         function LC_ErrorPage() {
@@ -370 +370 @@
         }
     }
-    
+
     $objPage = new LC_ErrorPage();
-    
+
     if($is_mobile === true) {
-        $objView = new SC_MobileView();     
+        $objView = new SC_MobileView();
     } else {
         $objView = new SC_SiteView();
     }
-    
+
     switch ($type) {
         case PRODUCT_NOT_FOUND:
@@ -450 +450 @@
             break;
     }
-    
+
     $objPage->return_top = $return_top;
-    
+
     $objView->assignobj($objPage);
-    
+
     if(is_object($objCampaignSess)) {
         // ¥Õ¥ì¡¼¥à¤òÁªÂò(¥­¥ã¥ó¥Ú¡¼¥ó¥Ú¡¼¥¸¤«¤éÁ«°Ü¤Ê¤éÊѹ¹)
@@ -460 +460 @@
     } else {
         $objView->display(SITE_FRAME);
-    }   
+    }
     exit;
 }
@@ -481 +481 @@
         // sfErrorHeader('>> referrer¤¬Ìµ¸ú¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£');
     } else {
-        $domain  = sfIsHTTPS() ? SSL_URL : SITE_URL;
-        $pattern = sprintf('|^%s.*|', $domain);
+        $siteurl = preg_quote(SITE_URL, "/");
+        $sslurl  = preg_quote(SSL_URL, "/");
+
+        $pattern = "/^($siteurl|$sslurl)/";
         $referer = $_SERVER['HTTP_REFERER'];
 
         // ´ÉÍý²èÌ̤«¤é°Ê³°¤ÎÁ«°Ü¤Î¾ì¹ç¤Ï¥¨¥é¡¼²èÌ̤òɽ¼¨
-        if (!preg_match($pattern, $referer)) {
+        if ( !preg_match($pattern, $referer) ) {
             if ($disp_error) sfDispError(INVALID_MOVE_ERRORR);
             return false;
@@ -496 +498 @@
 /**
  * HTTPS¤«¤É¤¦¤«¤òȽÄê
- * 
+ *
  * @return bool
  */
@@ -530 +532 @@
     if($ret != true) {
         // ¥¨¥é¡¼¥Ú¡¼¥¸¤Îɽ¼¨
-        sfDispSiteError(PAGE_ERROR, $objSiteSess, false, "", $is_mobile);           
+        sfDispSiteError(PAGE_ERROR, $objSiteSess, false, "", $is_mobile);
     }
 }
@@ -545 +547 @@
         sfDispSiteError(CANCEL_PURCHASE, $objSiteSess);
     }
-    
+
     // ¥«¡¼¥ÈÆ⤬¶õ¤Ç¤Ê¤¤¤« || ¹ØÆþ¥Ü¥¿¥ó¤ò²¡¤·¤Æ¤«¤éÊѲ½¤¬¤Ê¤¤¤«
     $quantity = $objCartSess->getTotalQuantity();
@@ -559 +561 @@
 /* DBÍÑÆüÉÕʸ»úÎó¼èÆÀ */
 function sfGetTimestamp($year, $month, $day, $last = false) {
-    if($year != "" && $month != "" && $day != "") { 
+    if($year != "" && $month != "" && $day != "") {
         if($last) {
             $time = "23:59:59";
@@ -581 +583 @@
 
 function sfCSVDownload($data, $prefix = ""){
-    
+
     if($prefix == "") {
         $dir_name = sfUpDirName();
@@ -588 +590 @@
         $file_name = $prefix . date("ymdHis") .".csv";
     }
-    
+
     /* HTTP¥Ø¥Ã¥À¤Î½ÐÎÏ */
     Header("Content-disposition: attachment; filename=${file_name}");
@@ -594 +596 @@
     Header("Cache-Control: ");
     Header("Pragma: ");
-    
+
     /* i18n¢· ¤À¤ÈÀµ¾ï¤ËÆ°ºî¤·¤Ê¤¤¤¿¤á¡¢mb¢· ¤ËÊѹ¹
     if (i18n_discover_encoding($data) == CHAR_CODE){
@@ -603 +605 @@
         $data = mb_convert_encoding($data,'SJIS',CHAR_CODE);
     }
-    
+
     /* ¥Ç¡¼¥¿¤ò½ÐÎÏ */
     echo $data;
@@ -623 +625 @@
         $url = ereg_replace(URL_DIR . "$", "", SITE_URL);
     }
-    
+
     if($get != "") {
         header("Location: ". $url . $_SERVER['PHP_SELF'] . "?" . $get);
@@ -671 +673 @@
     // ÂоݹàÌܤΥé¥ó¥¯¤ò¼èÆÀ
     $rank = $objQuery->get($table, "rank", $where, array($id));
-        
+
     // ¥é¥ó¥¯¤¬1(ºÇ¾®ÃÍ)¤è¤ê¤âÂ礭¤¤¾ì¹ç¤Ë¼Â¹Ô¤¹¤ë¡£
     if($rank > 1) {
@@ -693 +695 @@
     $objQuery = new SC_Query();
     $objQuery->begin();
-        
+
     // ¼«¿È¤Î¥é¥ó¥¯¤ò¼èÆÀ¤¹¤ë
-    $rank = $objQuery->get($tableName, "rank", "$keyIdColumn = ?", array($keyId));  
+    $rank = $objQuery->get($tableName, "rank", "$keyIdColumn = ?", array($keyId));
     $max = $objQuery->max($tableName, "rank", $where);
-        
+
     // ÃͤÎÄ´À°¡ÊµÕ½ç¡Ë
     if($pos > $max) {
@@ -706 +708 @@
         $position = $max - $pos + 1;
     }
-    
+
     if( $position > $rank ) $term = "rank - 1"; //Æþ¤ìÂؤ¨Àè¤Î½ç°Ì¤¬Æþ¤ì´¹¤¨¸µ¤Î½ç°Ì¤è¤êÂ礭¤¤¾ì¹ç
     if( $position < $rank ) $term = "rank + 1"; //Æþ¤ìÂؤ¨Àè¤Î½ç°Ì¤¬Æþ¤ì´¹¤¨¸µ¤Î½ç°Ì¤è¤ê¾®¤µ¤¤¾ì¹ç
@@ -715 +717 @@
         $sql.= " AND $where";
     }
-    
+
     if( $position > $rank ) $objQuery->exec( $sql, array( $rank + 1, $position ));
     if( $position < $rank ) $objQuery->exec( $sql, array( $position, $rank - 1 ));
@@ -724 +726 @@
         $sql.= " AND $where";
     }
-    
+
     $objQuery->exec( $sql, array( $position, $keyId ) );
     $objQuery->commit();
@@ -734 +736 @@
     $objQuery = new SC_Query();
     $objQuery->begin();
-    // ºï½ü¥ì¥³¡¼¥É¤Î¥é¥ó¥¯¤ò¼èÆÀ¤¹¤ë¡£     
+    // ºï½ü¥ì¥³¡¼¥É¤Î¥é¥ó¥¯¤ò¼èÆÀ¤¹¤ë¡£
     $where = "$colname = ?";
     if($andwhere != "") {
@@ -750 +752 @@
         $objQuery->delete($table, "$colname = ?", array($id));
     }
-    
+
     // Äɲå쥳¡¼¥É¤Î¥é¥ó¥¯¤è¤ê¾å¤Î¥ì¥³¡¼¥É¤ò°ì¤Ä¤º¤é¤¹¡£
     $where = "rank > ?";
@@ -765 +767 @@
     $objQuery = new SC_Query();
     $arrCol = split("[, ]", $col);
-        
+
     $where = "del_flg = 0";
-    
+
     if($addwhere != "") {
         $where.= " AND $addwhere";
     }
-        
+
     foreach($arrCol as $val) {
         if($val != "") {
@@ -782 +784 @@
     }
     $ret = $objQuery->get($table, $col, $where, $arrval);
-    
+
     if($ret != "") {
         return true;
@@ -806 +808 @@
 function sfMergeCheckBoxes($array, $max) {
     $ret = "";
-    if(is_array($array)) {  
+    if(is_array($array)) {
         foreach($array as $val) {
             $arrTmp[$val] = "1";
         }
     }
-    for($i = 1; $i <= $max; $i++) { 
+    for($i = 1; $i <= $max; $i++) {
         if($arrTmp[$i] == "1") {
             $ret.= "1";
@@ -830 +832 @@
                 $ret.= "-$val";
             } else {
-                $ret = $val;            
+                $ret = $val;
             }
         }
@@ -849 +851 @@
         }
     }
-    for($i = 1; $i <= $max; $i++) { 
+    for($i = 1; $i <= $max; $i++) {
         if($arrTmp[$i] == "1") {
             $ret.= "1";
@@ -856 +858 @@
         }
     }
-    
-    if($ret != "") {    
+
+    if($ret != "") {
         $ret.= "%";
     }
@@ -905 +907 @@
 // ¥­¡¼¤ÈÃͤò¥»¥Ã¥È¤·¤¿ÇÛÎó¤ò¼èÆÀ
 function sfArrKeyValue($arrList, $keyname, $valname, $len_max = "", $keysize = "") {
-    
+
     $max = count($arrList);
-    
+
     if($len_max != "" && $max > $len_max) {
         $max = $len_max;
     }
-    
+
     for($cnt = 0; $cnt < $max; $cnt++) {
         if($keysize != "") {
@@ -919 +921 @@
         }
         $val = $arrList[$cnt][$valname];
-        
+
         if(!isset($arrRet[$key])) {
             $arrRet[$key] = $val;
         }
-        
+
     }
     return $arrRet;
@@ -930 +932 @@
 // ¥­¡¼¤ÈÃͤò¥»¥Ã¥È¤·¤¿ÇÛÎó¤ò¼èÆÀ(Ãͤ¬Ê£¿ô¤Î¾ì¹ç)
 function sfArrKeyValues($arrList, $keyname, $valname, $len_max = "", $keysize = "", $connect = "") {
-    
+
     $max = count($arrList);
-    
+
     if($len_max != "" && $max > $len_max) {
         $max = $len_max;
     }
-    
+
     for($cnt = 0; $cnt < $max; $cnt++) {
         if($keysize != "") {
@@ -944 +946 @@
         }
         $val = $arrList[$cnt][$valname];
-        
+
         if($connect != "") {
             $arrRet[$key].= "$val".$connect;
         } else {
-            $arrRet[$key][] = $val;     
+            $arrRet[$key][] = $val;
         }
     }
@@ -974 +976 @@
         return false;
     }
-    
+
 }
 
@@ -1044 +1046 @@
     if ( ! is_numeric($value)  ){
         return false;
-    } 
-    
+    }
+
     if ( strlen($value) > 9 ) {
         return false;
     }
-    
+
     return true;
 }
@@ -1067 +1069 @@
     $objQuery = new SC_Query();
     $where = "del_flg = 0";
-    
+
     if($addwhere != "") {
         $where.= " AND $addwhere";
     }
-        
+
     $objQuery->setoption("ORDER BY rank DESC");
-    
+
     if($products_check) {
         $col = "T1.category_id, category_name, level";
@@ -1082 +1084 @@
         $from = "dtb_category";
     }
-    
+
     $arrRet = $objQuery->select($col, $from, $where);
-            
+
     $max = count($arrRet);
     for($cnt = 0; $cnt < $max; $cnt++) {
@@ -1111 +1113 @@
     $arrRet = $objQuery->select($col, "dtb_category", $where);
     $max = count($arrRet);
-    
+
     for($cnt = 0; $cnt < $max; $cnt++) {
         if($parent_zero) {
@@ -1117 +1119 @@
                 $arrValue[$cnt] = $arrRet[$cnt]['category_id'];
             } else {
-                $arrValue[$cnt] = ""; 
+                $arrValue[$cnt] = "";
             }
         } else {
             $arrValue[$cnt] = $arrRet[$cnt]['category_id'];
         }
-        
+
         $arrOutput[$cnt] = "";
-        /*          
+        /*
         for($n = 1; $n < $arrRet[$cnt]['level']; $n++) {
             $arrOutput[$cnt].= "¡¡";
@@ -1195 +1197 @@
     $len = count($arrId);
     $where = "";
-    
+
     for($cnt = 0; $cnt < $len; $cnt++) {
         if($where == "") {
@@ -1203 +1205 @@
         }
     }
-    
+
     $objQuery->setorder("level");
     $arrRet = $objQuery->select($col, $table, $where, $arrId);
-    return $arrRet; 
+    return $arrRet;
 }
 
@@ -1221 +1223 @@
     }
     // µì¥«¥Æ¥´¥ê¤Ç¤Î¥é¥ó¥¯ºï½ü½èÍý
-    // °ÜÆ°¥ì¥³¡¼¥É¤Î¥é¥ó¥¯¤ò¼èÆÀ¤¹¤ë¡£     
+    // °ÜÆ°¥ì¥³¡¼¥É¤Î¥é¥ó¥¯¤ò¼èÆÀ¤¹¤ë¡£
     $where = "$id_name = ?";
     $rank = $objQuery->get($table, "rank", $where, array($id));
@@ -1265 +1267 @@
     $real_tax = $tax / 100;
     $ret = $price * (1 + $real_tax);
-    
+
     switch($tax_rule) {
     // »Í¼Î¸ÞÆþ
@@ -1295 +1297 @@
         $ret = (round($value * $adjust)/$adjust);
     }
-    
+
     $ret = round($ret);
 
@@ -1307 +1309 @@
         $where = "now() >= cast(start_date as date) AND ";
         $where .= "now() < cast(end_date as date) AND ";
-        
+
         $where .= "del_flg = 0 AND campaign_id IN (SELECT campaign_id FROM dtb_campaign_detail where product_id = ? )";
         //ÅÐÏ¿(¹¹¿·)ÆüÉÕ½ç
@@ -1357 +1359 @@
     // ¥­¡¼¤ÈÃͤò¥»¥Ã¥È¤·¤¿ÇÛÎó¤ò¼èÆÀ
     $arrRet = sfArrKeyValue($arrList, 'class_id', 'count');
-    
+
     return $arrRet;
 }
@@ -1366 +1368 @@
     $where = "product_id = ? AND classcategory_id1 <> 0 AND classcategory_id1 <> 0";
     $count = $objQuery->count("dtb_products_class", $where,  array($product_id));
-    
+
     // ¤¹¤Ç¤Ëµ¬³ÊÅÐÏ¿¤¬¤Ê¤¤¾ì¹ç
     if($count == 0) {
@@ -1382 +1384 @@
         $sqlval['creator_id'] = $_SESSION['member_id'];
         $sqlval['create_date'] = "now()";
-        
+
         if($_SESSION['member_id'] == "") {
             $sqlval['creator_id'] = '0';
         }
-        
+
         // INSERT¤Î¼Â¹Ô
         $objQuery->insert("dtb_products_class", $sqlval);
@@ -1407 +1409 @@
 /* ¾¦Éʵ¬³Ê¾ðÊó¤Î¼èÆÀ */
 function sfGetProductsClass($arrID) {
-    list($product_id, $classcategory_id1, $classcategory_id2) = $arrID; 
-    
+    list($product_id, $classcategory_id1, $classcategory_id2) = $arrID;
+
     if($classcategory_id1 == "") {
         $classcategory_id1 = '0';
@@ -1415 +1417 @@
         $classcategory_id2 = '0';
     }
-        
+
     // ¾¦Éʵ¬³Ê¼èÆÀ
     $objQuery = new SC_Query();
@@ -1430 +1432 @@
     // ¾¦Éʤιç·×¸Ä¿ô
     $total_quantity = $objCartSess->getTotalQuantity(true);
-    
+
     // ÀǶâ¤Î¼èÆÀ
     $arrData['tax'] = $objPage->tpl_total_tax;
     // ¾®·×¤Î¼èÆÀ
-    $arrData['subtotal'] = $objPage->tpl_total_pretax;  
-    
+    $arrData['subtotal'] = $objPage->tpl_total_pretax;
+
     // ¹ç·×Á÷ÎÁ¤Î¼èÆÀ
     $arrData['deliv_fee'] = 0;
-        
+
     // ¾¦Éʤ´¤È¤ÎÁ÷ÎÁ¤¬Í­¸ú¤Î¾ì¹ç
     if (OPTION_PRODUCT_DELIV_FEE == 1) {
         $arrData['deliv_fee']+= $objCartSess->getAllProductsDelivFee();
     }
-    
+
     // ÇÛÁ÷¶È¼Ô¤ÎÁ÷ÎÁ¤¬Í­¸ú¤Î¾ì¹ç
     if (OPTION_DELIV_FEE == 1) {
@@ -1449 +1451 @@
         $arrData['deliv_fee']+= sfGetDelivFee($arrData['deliv_pref'], $arrData['payment_id']);
     }
-    
+
     // Á÷ÎÁ̵ÎÁ¤Î¹ØÆþ¿ô¤¬ÀßÄꤵ¤ì¤Æ¤¤¤ë¾ì¹ç
     if(DELIV_FREE_AMOUNT > 0) {
         if($total_quantity >= DELIV_FREE_AMOUNT) {
             $arrData['deliv_fee'] = 0;
-        }   
-    }
-        
+        }
+    }
+
     // Á÷ÎÁ̵ÎÁ¾ò·ï¤¬ÀßÄꤵ¤ì¤Æ¤¤¤ë¾ì¹ç
     if($arrInfo['free_rule'] > 0) {
@@ -1473 +1475 @@
     // ²Ã»»¥Ý¥¤¥ó¥È¤Î·×»»
     $arrData['add_point'] = sfGetAddPoint($objPage->tpl_total_point, $arrData['use_point'], $arrInfo);
-    
+
     if($objCustomer != "") {
         // ÃÂÀ¸Æü·î¤Ç¤¢¤Ã¤¿¾ì¹ç
@@ -1481 +1483 @@
         }
     }
-    
+
     if($arrData['add_point'] < 0) {
         $arrData['add_point'] = 0;
     }
-    
+
     return $arrData;
 }
@@ -1495 +1497 @@
     // µ¬³ÊʬÎà̾°ìÍ÷
     $arrClassCatName = sfGetIDValueList("dtb_classcategory", "classcategory_id", "name");
-    
+
     $objPage->tpl_total_pretax = 0;     // ÈñÍѹç·×(Àǹþ¤ß)
     $objPage->tpl_total_tax = 0;        // ¾ÃÈñÀǹç·×
     $objPage->tpl_total_point = 0;      // ¥Ý¥¤¥ó¥È¹ç·×
-    
+
     // ¥«¡¼¥ÈÆâ¾ðÊó¤Î¼èÆÀ
     $arrCart = $objCartSess->getCartList();
@@ -1506 +1508 @@
 
     for ($i = 0; $i < $max; $i++) {
-        // ¾¦Éʵ¬³Ê¾ðÊó¤Î¼èÆÀ   
+        // ¾¦Éʵ¬³Ê¾ðÊó¤Î¼èÆÀ
         $arrData = sfGetProductsClass($arrCart[$i]['id']);
         $limit = "";
         // DB¤Ë¸ºß¤¹¤ë¾¦ÉÊ
         if (count($arrData) > 0) {
-            
-            // ¹ØÆþÀ©¸Â¿ô¤òµá¤á¤ë¡£         
+
+            // ¹ØÆþÀ©¸Â¿ô¤òµá¤á¤ë¡£
             if ($arrData['stock_unlimited'] != '1' && $arrData['sale_unlimited'] != '1') {
                 if($arrData['sale_limit'] < $arrData['stock']) {
@@ -1527 +1529 @@
                 }
             }
-                        
+
             if($limit != "" && $limit < $arrCart[$i]['quantity']) {
                 // ¥«¡¼¥ÈÆ⾦ÉÊ¿ô¤òÀ©¸Â¤Ë¹ç¤ï¤»¤ë
@@ -1536 +1538 @@
                 $quantity = $arrCart[$i]['quantity'];
             }
-            
+
             $objPage->arrProductsClass[$cnt] = $arrData;
             $objPage->arrProductsClass[$cnt]['quantity'] = $quantity;
@@ -1544 +1546 @@
             $objPage->arrProductsClass[$cnt]['classcategory_name1'] = $arrClassCatName[$arrData['classcategory_id1']];
             $objPage->arrProductsClass[$cnt]['classcategory_name2'] = $arrClassCatName[$arrData['classcategory_id2']];
-            
+
             // ²èÁü¥µ¥¤¥º
             list($image_width, $image_height) = getimagesize(IMAGE_SAVE_DIR . basename($objPage->arrProductsClass[$cnt]["main_image"]));
             $objPage->arrProductsClass[$cnt]["tpl_image_width"] = $image_width + 60;
             $objPage->arrProductsClass[$cnt]["tpl_image_height"] = $image_height + 80;
-            
+
             // ²Á³Ê¤ÎÅÐÏ¿
             if ($arrData['price02'] != "") {
@@ -1570 +1572 @@
         }
     }
-    
+
     // Á´¾¦Éʹç·×¶â³Û(Àǹþ¤ß)
     $objPage->tpl_total_pretax = $objCartSess->getAllProductsTotal($arrInfo);
@@ -1577 +1579 @@
     // Á´¾¦Éʹç·×¥Ý¥¤¥ó¥È
     $objPage->tpl_total_point = $objCartSess->getAllProductsPoint();
-    
-    return $objPage;    
+
+    return $objPage;
 }
 
@@ -1589 +1591 @@
             $str = sprintf("%04d/%02d/%02d %02d:%02d", $y, $m, $d, $H, $M);
         } else {
-            $str = sprintf("%04d/%02d/%02d", $y, $m, $d, $H, $M);                       
+            $str = sprintf("%04d/%02d/%02d", $y, $m, $d, $H, $M);
         }
     } else {
@@ -1599 +1601 @@
 function sfGetDelivTime($payment_id = "") {
     $objQuery = new SC_Query();
-    
+
     $deliv_id = "";
-    
+
     if($payment_id != "") {
         $where = "del_flg = 0 AND payment_id = ?";
@@ -1607 +1609 @@
         $deliv_id = $arrRet[0]['deliv_id'];
     }
-    
+
     if($deliv_id != "") {
         $objQuery->setorder("time_id");
@@ -1613 +1615 @@
         $arrRet= $objQuery->select("time_id, deliv_time", "dtb_delivtime", $where, array($deliv_id));
     }
-    
-    return $arrRet; 
+
+    return $arrRet;
 }
 
@@ -1621 +1623 @@
 function sfGetDelivFee($pref, $payment_id = "") {
     $objQuery = new SC_Query();
-    
+
     $deliv_id = "";
-    
+
     // »Ùʧ¤¤ÊýË¡¤¬»ØÄꤵ¤ì¤Æ¤¤¤ë¾ì¹ç¤Ï¡¢Âбþ¤·¤¿ÇÛÁ÷¶È¼Ô¤ò¼èÆÀ¤¹¤ë
     if($payment_id != "") {
@@ -1635 +1637 @@
         $objQuery->setLimitOffset(1);
         $arrRet = $objQuery->select("deliv_id", "dtb_deliv", $where);
-        $deliv_id = $arrRet[0]['deliv_id']; 
-    }
-    
+        $deliv_id = $arrRet[0]['deliv_id'];
+    }
+
     // ÇÛÁ÷¶È¼Ô¤«¤éÇÛÁ÷ÎÁ¤ò¼èÆÀ
     if($deliv_id != "") {
-        
+
         // ÅÔÆ»Éܸ©¤¬»ØÄꤵ¤ì¤Æ¤¤¤Ê¤¤¾ì¹ç¤Ï¡¢ÅìµþÅÔ¤ÎÈÖ¹æ¤ò»ØÄꤷ¤Æ¤ª¤¯
         if($pref == "") {
             $pref = 13;
         }
-        
+
         $objQuery = new SC_Query();
         $where = "deliv_id = ? AND pref = ?";
         $arrRet= $objQuery->select("fee", "dtb_delivfee", $where, array($deliv_id, $pref));
-    }   
-    return $arrRet[0]['fee'];   
+    }
+    return $arrRet[0]['fee'];
 }
 
@@ -1660 +1662 @@
     $objQuery->setorder("fix, rank DESC");
     $arrRet = $objQuery->select("payment_id, payment_method, rule", "dtb_payment", $where);
-    return $arrRet; 
+    return $arrRet;
 }
 
@@ -1689 +1691 @@
     $objPage->tpl_footer = $arrRet[0]['footer'];
     $tmp_subject = $arrRet[0]['subject'];
-    
+
     $objSiteInfo = new SC_SiteInfo();
     $arrInfo = $objSiteInfo->data;
-    
+
     $objMailView = new SC_SiteView();
     // ¥á¡¼¥ëËÜʸ¤Î¼èÆÀ
     $objMailView->assignobj($objPage);
     $body = $objMailView->fetch($arrMAILTPLPATH[$template_id]);
-    
+
     // ¥á¡¼¥ëÁ÷¿®½èÍý
     $objSendMail = new GC_SendMail();
@@ -1711 +1713 @@
 function sfSendOrderMail($order_id, $template_id, $subject = "", $header = "", $footer = "", $send = true) {
     global $arrMAILTPLPATH;
-    
+
     $objPage = new LC_Page();
     $objSiteInfo = new SC_SiteInfo();
     $arrInfo = $objSiteInfo->data;
     $objPage->arrInfo = $arrInfo;
-    
+
     $objQuery = new SC_Query();
-        
+
     if($subject == "" && $header == "" && $footer == "") {
         // ¥á¡¼¥ë¥Æ¥ó¥×¥ì¡¼¥È¾ðÊó¤Î¼èÆÀ
@@ -1731 +1733 @@
         $tmp_subject = $subject;
     }
-    
+
     // ¼õÃí¾ðÊó¤Î¼èÆÀ
     $where = "order_id = ?";
@@ -1737 +1739 @@
     $arrOrder = $arrRet[0];
     $arrOrderDetail = $objQuery->select("*", "dtb_order_detail", $where, array($order_id));
-    
+
     $objPage->Message_tmp = $arrOrder['message'];
-        
+
     // ¸ÜµÒ¾ðÊó¤Î¼èÆÀ
     $customer_id = $arrOrder['customer_id'];
@@ -1751 +1753 @@
     if($arrOrder['memo02'] != "") {
         $arrOther = unserialize($arrOrder['memo02']);
-        
+
         foreach($arrOther as $other_key => $other_val){
             if(sfTrim($other_val["value"]) == ""){
@@ -1757 +1759 @@
             }
         }
-        
+
         $objPage->arrOther = $arrOther;
     }
@@ -1764 +1766 @@
     global $arrPref;
     $objPage->arrOrder['deliv_pref'] = $arrPref[$objPage->arrOrder['deliv_pref']];
-    
+
     $objPage->arrOrderDetail = $arrOrderDetail;
-    
+
     $objCustomer = new SC_Customer();
     $objPage->tpl_user_point = $objCustomer->getValue('point');
-    
+
     $objMailView = new SC_SiteView();
     // ¥á¡¼¥ëËÜʸ¤Î¼èÆÀ
     $objMailView->assignobj($objPage);
     $body = $objMailView->fetch($arrMAILTPLPATH[$template_id]);
-    
+
     // ¥á¡¼¥ëÁ÷¿®½èÍý
     $objSendMail = new GC_SendMail();
@@ -1782 +1784 @@
 
     $tosubject = sfMakeSubject($tmp_subject);
-    
+
     $objSendMail->setItem('', $tosubject, $body, $from, $arrInfo['shop_name'], $from, $error, $error, $bcc);
     $objSendMail->setTo($arrOrder["order_email"], $arrOrder["order_name01"] . " ". $arrOrder["order_name02"] ." ÍÍ");
@@ -1814 +1816 @@
     $error = $arrInfo['email04'];
     $objSendMail->setItem($to, $subject, $body, $from, $arrInfo['shop_name'], $from, $error, $error, $bcc);
-    $objSendMail->sendMail();   
+    $objSendMail->sendMail();
 }
 
@@ -1832 +1834 @@
 //·ï̾¤Ë¥Æ¥ó¥×¥ì¡¼¥È¤òÍѤ¤¤ë
 function sfMakeSubject($subject){
-    
+
     $objQuery = new SC_Query();
     $objMailView = new SC_SiteView();
     $objPage = new LC_Page();
-    
+
     $arrInfo = $objQuery->select("*","dtb_baseinfo");
     $arrInfo = $arrInfo[0];
@@ -1844 +1846 @@
     $mailtitle = $objMailView->fetch('mail_templates/mail_title.tpl');
     $ret = $mailtitle.$subject;
-    return $ret; 
+    return $ret;
 }
 
@@ -1859 +1861 @@
     }
     $sqlval['mail_body'] = $body;
-    
+
     $objQuery = new SC_Query();
     $objQuery->insert("dtb_mail_history", $sqlval);
@@ -1936 +1938 @@
     $now_dir = getcwd();            // require¤¬¤¦¤Þ¤¯¤¤¤«¤Ê¤¤¤Î¤Ç¡¢cgi¼Â¹Ô¥Ç¥£¥ì¥¯¥È¥ê¤Ë°ÜÆ°¤¹¤ë
     chdir($dir);
-    
+
     // ¥Ñ¥¤¥×ÅϤ·¤Ç¥³¥Þ¥ó¥É¥é¥¤¥ó¤«¤écgiµ¯Æ°
     $cmd = "$path card_no=$card_no name01=$name01 name02=$name02 card_exp=$card_exp amount=$amount order_id=$order_id jpo_info=$jpo_info";
 
     $tmpResult = popen($cmd, "r");
-    
+
     // ·ë²Ì¼èÆÀ
     while( ! FEOF ( $tmpResult ) ) {
@@ -1948 +1950 @@
     pclose($tmpResult);             //  ¥Ñ¥¤¥×¤òÊĤ¸¤ë
     chdir($now_dir);                //¡¡¸µ¤Ë¤¤¤¿¥Ç¥£¥ì¥¯¥È¥ê¤Ëµ¢¤ë
-    
+
     // ·ë²Ì¤òÏ¢ÁÛÇÛÎó¤Ø³ÊǼ
     $result = ereg_replace("&$", "", $result);
@@ -1955 +1957 @@
         $return[$key] = $val;
     }
-    
+
     return $return;
 }
@@ -2041 +2043 @@
     // ¹ØÆþ¾¦Éʤιç·×¥Ý¥¤¥ó¥È¤«¤éÍøÍѤ·¤¿¥Ý¥¤¥ó¥È¤Î¥Ý¥¤¥ó¥È´¹»»²ÁÃͤò°ú¤¯Êý¼°
     $add_point = $totalpoint - intval($use_point * ($arrInfo['point_rate'] / 100));
-    
+
     if($add_point < 0) {
         $add_point = '0';
@@ -2061 +2063 @@
     // ´û¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤ëÆâÍƤò¼èÆÀ¤¹¤ë
     $sql = "SELECT name, main_image, main_list_image, price01_min, price01_max, price02_min, price02_max, point_rate,
-             A.product_id, A.comment FROM dtb_best_products as A LEFT JOIN vw_products_allclass AS allcls 
+             A.product_id, A.comment FROM dtb_best_products as A LEFT JOIN vw_products_allclass AS allcls
             USING (product_id) WHERE A.category_id = ? AND A.del_flg = 0 AND status = 1 ORDER BY A.rank";
     $arrItems = $conn->getAll($sql, array($category_id));
@@ -2081 +2083 @@
         return $ret;
     }
-    
+
     // ÇÛÎó¤Î¾ì¹ç
     foreach($data as $val) {
@@ -2142 +2144 @@
     $line = array();
     $ret = "";
-    
+
     while($str[$i] != "") {
         $line[$cnt].=$str[$i];
@@ -2151 +2153 @@
         }
     }
-    
+
     foreach($line as $val) {
         $ret.=$val;
@@ -2171 +2173 @@
     $str = ereg_replace("[/]+", "/", $str);
     $ret = $head . $str;
-    return $ret;    
+    return $ret;
 }
 
 function sfEncodeFile($filepath, $enc_type, $out_dir) {
     $ifp = fopen($filepath, "r");
-    
+
     $basename = basename($filepath);
     $outpath = $out_dir . "enc_" . $basename;
-    
+
     $ofp = fopen($outpath, "w+");
-    
+
     while(!feof($ifp)) {
         $line = fgets($ifp);
@@ -2187 +2189 @@
         fwrite($ofp,  $line);
     }
-    
+
     fclose($ofp);
     fclose($ifp);
-    
+
     return  $outpath;
 }
@@ -2245 +2247 @@
     $end_year = $year;
     $end_month = $month;
-    
+
     // ³«»Ï·î¤¬½ªÎ»·î¤ÈƱ¤¸¤«Èݤ«
     $same_month = false;
-    
+
     // ³ºÅö·î¤ÎËöÆü¤òµá¤á¤ë¡£
     $end_last_day = date("d", mktime(0, 0, 0, $month + 1, 0, $year));
-    
+
     // ·î¤ÎËöÆü¤¬Äù¤áÆü¤è¤ê¾¯¤Ê¤¤¾ì¹ç
     if($end_last_day < $close_day) {
@@ -2259 +2261 @@
         $end_day = $close_day;
     }
-    
+
     // Á°·î¤Î¼èÆÀ
     $tmp_year = date("Y", mktime(0, 0, 0, $month, 0, $year));
@@ -2265 +2267 @@
     // Á°·î¤ÎËöÆü¤òµá¤á¤ë¡£
     $start_last_day = date("d", mktime(0, 0, 0, $month, 0, $year));
-    
+
     // Á°·î¤ÎËöÆü¤¬Äù¤áÆü¤è¤ê¾¯¤Ê¤¤¾ì¹ç
     if ($start_last_day < $close_day) {
@@ -2273 +2275 @@
         $tmp_day = $close_day;
     }
-    
+
     // Àè·î¤ÎËöÆü¤ÎÍâÆü¤ò¼èÆÀ¤¹¤ë
     $start_year = date("Y", mktime(0, 0, 0, $tmp_month, $tmp_day + 1, $tmp_year));
     $start_month = date("m", mktime(0, 0, 0, $tmp_month, $tmp_day + 1, $tmp_year));
     $start_day = date("d", mktime(0, 0, 0, $tmp_month, $tmp_day + 1, $tmp_year));
-    
+
     // ÆüÉդκîÀ®
     $start_date = sprintf("%d/%d/%d 00:00:00", $start_year, $start_month, $start_day);
     $end_date = sprintf("%d/%d/%d 23:59:59", $end_year, $end_month, $end_day);
-    
+
     return array($start_date, $end_date);
 }
@@ -2290 +2292 @@
     $hex = substr($hexrgb, 0, 2);
     $r = hexdec($hex) / 255;
-    
+
     $hex = substr($hexrgb, 2, 2);
     $g = hexdec($hex) / 255;
-    
+
     $hex = substr($hexrgb, 4, 2);
     $b = hexdec($hex) / 255;
-    
-    return array($r, $g, $b);   
+
+    return array($r, $g, $b);
 }
 
@@ -2305 +2307 @@
     $objConn = new SC_DBConn();
     $objPage = new LC_Page();
-    
+
     $random_id = sfGetUniqRandomId();
     $arrRegistMailMagazine["mail_flag"] = $mail_flag;
@@ -2312 +2314 @@
     $arrRegistMailMagazine["end_flag"]='0';
     $arrRegistMailMagazine["update_date"] = 'now()';
-    
+
     //¥á¥ë¥Þ¥¬²¾ÅÐÏ¿Íѥե饰
     $flag = $objQuery->count("dtb_customer_mail_temp", "email=?", array($email));
@@ -2320 +2322 @@
         $objConn->autoExecute("dtb_customer_mail_temp",$arrRegistMailMagazine);
         break;
-    
+
         case '1':
         $objConn->autoExecute("dtb_customer_mail_temp",$arrRegistMailMagazine, "email = '" .addslashes($email). "'");
@@ -2333 +2335 @@
         $objPage->tpl_kindname = "HTML";
         break;
-        
+
         case '2':
         $objPage->tpl_name = "ÅÐÏ¿";
         $objPage->tpl_kindname = "¥Æ¥­¥¹¥È";
         break;
-        
+
         case '3':
         $objPage->tpl_name = "²ò½ü";
@@ -2384 +2386 @@
     } else {
         $path = $_SERVER["REQUEST_URI"];
-    }   
+    }
 
     if($_GET['tpl'] != "") {
@@ -2397 +2399 @@
 
     if($is_mobile === true) {
-        $objView = new SC_MobileView();         
+        $objView = new SC_MobileView();
         $objView->assignobj($objPage);
-        $objView->display(SITE_FRAME);      
+        $objView->display(SITE_FRAME);
     } else if(file_exists($template_path)) {
         $objView = new SC_UserView(TEMPLATE_FTP_DIR, COMPILE_FTP_DIR);
@@ -2414 +2416 @@
 function sfEditCustomerData($array, $arrRegistColumn) {
     $objQuery = new SC_Query();
-    
+
     foreach ($arrRegistColumn as $data) {
         if ($data["column"] != "password") {
@@ -2431 +2433 @@
 
     //-- ¥Ñ¥¹¥ï¡¼¥É¤Î¹¹¿·¤¬¤¢¤ë¾ì¹ç¤Ï°Å¹æ²½¡£¡Ê¹¹¿·¤¬¤Ê¤¤¾ì¹ç¤ÏUPDATEʸ¤ò¹½À®¤·¤Ê¤¤¡Ë
-    if ($array["password"] != DEFAULT_PASSWORD) $arrRegist["password"] = sha1($array["password"] . ":" . AUTH_MAGIC); 
+    if ($array["password"] != DEFAULT_PASSWORD) $arrRegist["password"] = sha1($array["password"] . ":" . AUTH_MAGIC);
     $arrRegist["update_date"] = "NOW()";
-    
+
     //-- ÊÔ½¸ÅÐÏ¿¼Â¹Ô
     if (defined('MOBILE_SITE')) {
@@ -2447 +2449 @@
 function sf_mb_convert_encoding($str, $encode = 'CHAR_CODE') {
     return  mb_convert_encoding($str, $encode);
-}   
+}
 
 // PHP¤Îmktime´Ø¿ô¤òSmarty¤Ç¤â»È¤¨¤ë¤è¤¦¤Ë¤¹¤ë
 function sf_mktime($format, $hour=0, $minute=0, $second=0, $month=1, $day=1, $year=1999) {
     return  date($format,mktime($hour, $minute, $second, $month, $day, $year));
-}   
+}
 
 // PHP¤Îdate´Ø¿ô¤òSmarty¤Ç¤â»È¤¨¤ë¤è¤¦¤Ë¤¹¤ë
@@ -2478 +2480 @@
 function sfCategory_Count($objQuery){
     $sql = "";
-    
+
     //¥Æ¡¼¥Ö¥ëÆâÍƤκï½ü
     $objQuery->query("DELETE FROM dtb_category_count");
     $objQuery->query("DELETE FROM dtb_category_total_count");
-    
+
     //³Æ¥«¥Æ¥´¥êÆâ¤Î¾¦ÉÊ¿ô¤ò¿ô¤¨¤Æ³ÊǼ
     $sql = " INSERT INTO dtb_category_count(category_id, product_count, create_date) ";
@@ -2490 +2492 @@
     $sql .= " GROUP BY T1.category_id, T2.category_id ";
     $objQuery->query($sql);
-    
+
     //»Ò¥«¥Æ¥´¥êÆâ¤Î¾¦ÉÊ¿ô¤ò½¸·×¤¹¤ë
     $arrCat = $objQuery->getAll("SELECT * FROM dtb_category");
-    
+
     $sql = "";
     foreach($arrCat as $key => $val){
-        
+
         // »ÒID°ìÍ÷¤ò¼èÆÀ
-        $arrRet = sfGetChildrenArray('dtb_category', 'parent_category_id', 'category_id', $val['category_id']); 
+        $arrRet = sfGetChildrenArray('dtb_category', 'parent_category_id', 'category_id', $val['category_id']);
         $line = sfGetCommaList($arrRet);
-        
+
         $sql = " INSERT INTO dtb_category_total_count(category_id, product_count, create_date) ";
         $sql .= " SELECT ?, SUM(product_count), now() FROM dtb_category_count ";
         $sql .= " WHERE category_id IN (" . $line . ")";
-                
+
         $objQuery->query($sql, array($val['category_id']));
     }
@@ -2513 +2515 @@
 
     if(count($arrKeys) <= 0 and count($arrValues) <= 0) return array();
-    
+
     $keys = array_values($arrKeys);
-    $vals = array_values($arrValues); 
-    
-    $max = max( count( $keys ), count( $vals ) ); 
-    $combine_ary = array(); 
-    for($i=0; $i<$max; $i++) { 
-        $combine_ary[$keys[$i]] = $vals[$i]; 
-    } 
-    if(is_array($combine_ary)) return $combine_ary; 
-    
-    return false; 
+    $vals = array_values($arrValues);
+
+    $max = max( count( $keys ), count( $vals ) );
+    $combine_ary = array();
+    for($i=0; $i<$max; $i++) {
+        $combine_ary[$keys[$i]] = $vals[$i];
+    }
+    if(is_array($combine_ary)) return $combine_ary;
+
+    return false;
 }
 
@@ -2532 +2534 @@
     $col = $pid_name . "," . $id_name;
     $arrData = $objQuery->select($col, $table);
-    
+
     $arrPID = array();
     $arrPID[] = $id;
     $arrChildren = array();
     $arrChildren[] = $id;
-    
+
     $arrRet = sfGetChildrenArraySub($arrData, $pid_name, $id_name, $arrPID);
-    
+
     while(count($arrRet) > 0) {
         $arrChildren = array_merge($arrChildren, $arrRet);
         $arrRet = sfGetChildrenArraySub($arrData, $pid_name, $id_name, $arrRet);
     }
-    
+
     return $arrChildren;
 }
@@ -2552 +2554 @@
     $arrChildren = array();
     $max = count($arrData);
-    
+
     for($i = 0; $i < $max; $i++) {
         foreach($arrPID as $val) {
@@ -2559 +2561 @@
             }
         }
-    }   
+    }
     return $arrChildren;
 }
@@ -2569 +2571 @@
     $col = $pid_name . "," . $id_name;
     $arrData = $objQuery->select($col, $table);
-    
+
     $arrParents = array();
     $arrParents[] = $id;
     $child = $id;
-    
+
     $ret = sfGetParentsArraySub($arrData, $pid_name, $id_name, $child);
 
@@ -2580 +2582 @@
         $ret = sfGetParentsArraySub($arrData, $pid_name, $id_name, $ret);
     }
-    
+
     $arrParents = array_reverse($arrParents);
-    
+
     return $arrParents;
 }
@@ -2602 +2604 @@
 function sfGetBrothersArray($arrData, $pid_name, $id_name, $arrPID) {
     $max = count($arrData);
-    
+
     $arrBrothers = array();
     foreach($arrPID as $id) {
@@ -2617 +2619 @@
                 $arrBrothers[] = $arrData[$i][$id_name];
             }
-        }                   
+        }
     }
     return $arrBrothers;
@@ -2625 +2627 @@
 function sfGetUnderChildrenArray($arrData, $pid_name, $id_name, $parent) {
     $max = count($arrData);
-    
+
     $arrChildren = array();
     // »ÒID¤ò¸¡º÷¤¹¤ë
@@ -2632 +2634 @@
             $arrChildren[] = $arrData[$i][$id_name];
         }
-    }                   
+    }
     return $arrChildren;
 }
@@ -2650 +2652 @@
     $col .= " cat.update_date,";
     $col .= " cat.del_flg, ";
-    $col .= " ttl.product_count";   
+    $col .= " ttl.product_count";
     $from = "dtb_category as cat left join dtb_category_total_count as ttl on ttl.category_id = cat.category_id";
     // ÅÐÏ¿¾¦ÉÊ¿ô¤Î¥Á¥§¥Ã¥¯
@@ -2660 +2662 @@
     $objQuery->setoption("ORDER BY rank DESC");
     $arrRet = $objQuery->select($col, $from, $where);
-    
+
     $arrParentID = sfGetParents($objQuery, 'dtb_category', 'parent_category_id', 'category_id', $parent_category_id);
-    
+
     foreach($arrRet as $key => $array) {
         foreach($arrParentID as $val) {
@@ -2679 +2681 @@
     // ¾¦Éʤ¬Â°¤¹¤ë¥«¥Æ¥´¥êID¤ò½Ä¤Ë¼èÆÀ
     $objQuery = new SC_Query();
-    $arrCatID = sfGetParents($objQuery, "dtb_category", "parent_category_id", "category_id", $category_id); 
+    $arrCatID = sfGetParents($objQuery, "dtb_category", "parent_category_id", "category_id", $category_id);
     $ConbName = "";
-    
+
     // ¥«¥Æ¥´¥ê¡¼Ì¾¾Î¤ò¼èÆÀ¤¹¤ë
     foreach($arrCatID as $key => $val){
@@ -2691 +2693 @@
     // ºÇ¸å¤Î ¡Ã ¤ò¥«¥Ã¥È¤¹¤ë
     $ConbName = substr_replace($ConbName, "", strlen($ConbName) - 2, 2);
-    
+
     return $ConbName;
 }
@@ -2700 +2702 @@
     $objQuery = new SC_Query();
     $arrRet = array();
-    $arrCatID = sfGetParents($objQuery, "dtb_category", "parent_category_id", "category_id", $category_id); 
+    $arrCatID = sfGetParents($objQuery, "dtb_category", "parent_category_id", "category_id", $category_id);
     $arrRet['id'] = $arrCatID[0];
-    
+
     // ¥«¥Æ¥´¥ê¡¼Ì¾¾Î¤ò¼èÆÀ¤¹¤ë
     $sql = "SELECT category_name FROM dtb_category WHERE category_id = ?";
     $arrVal = array($arrRet['id']);
     $arrRet['name'] = $objQuery->getOne($sql,$arrVal);
-    
+
     return $arrRet;
 }
@@ -2715 +2717 @@
     // ²þ¹Ô¡¢¥¿¥Ö¤ò1¥¹¥Ú¡¼¥¹¤ËÊÑ´¹
     $sql = preg_replace("/[\r\n\t]/"," ",$sql);
-    
+
     $sql = sfChangeView($sql);      // viewɽ¤ò¥¤¥ó¥é¥¤¥ó¥Ó¥å¡¼¤ËÊÑ´¹¤¹¤ë
     $sql = sfChangeILIKE($sql);     // ILIKE¸¡º÷¤òLIKE¸¡º÷¤ËÊÑ´¹¤¹¤ë
@@ -2738 +2740 @@
 // SQL¥·¥ó¥°¥ë¥¯¥©¡¼¥ÈÂбþ
 function sfQuoteSmart($in){
-    
+
     if (is_int($in) || is_double($in)) {
         return $in;
@@ -2749 +2751 @@
     }
 }
-    
+
 // viewɽ¤ò¥¤¥ó¥é¥¤¥ó¥Ó¥å¡¼¤ËÊÑ´¹¤¹¤ë
 function sfChangeView($sql){
     global $arrView;
     global $arrViewWhere;
-    
+
     $arrViewTmp = $arrView;
 
@@ -2761 +2763 @@
         $arrViewTmp[$key] = strtr($arrViewTmp[$key], $arrViewWhere);
     }
-    
+
     // view¤òÊÑ´¹
     $changesql = strtr($sql, $arrViewTmp);
@@ -2799 +2801 @@
     $oldmask = umask(0);
     $mod= stat($src);
-    
+
     // ¥Ç¥£¥ì¥¯¥È¥ê¤¬¤Ê¤±¤ì¤ÐºîÀ®¤¹¤ë
     if(!file_exists($des)) {
@@ -2806 +2808 @@
         }
     }
-    
+
     $fileArray=glob( $src."*" );
     foreach( $fileArray as $key => $data_ ){
@@ -2819 +2821 @@
             break;
         }
-        
+
         mb_ereg("^(.*[\/])(.*)",$data_, $matches);
         $data=$matches[2];
@@ -2853 +2855 @@
             $ret = sfDelFile($del_file);
         }
-        
+
         if(!$ret){
             return $ret;
         }
     }
-    
+
     // ÊĤ¸¤ë
     closedir($dh);
-    
+
     // ¥Õ¥©¥ë¥À¤òºï½ü
     return rmdir($dir);
 }
 
-/* 
+/*
  * ´Ø¿ô̾¡§sfWriteFile
  * °ú¿ô1 ¡§½ñ¤­¹þ¤à¥Ç¡¼¥¿
@@ -2893 +2895 @@
         chmod($path, $permission);
     }
-    
+
     return true;
 }
-    
+
 function sfFlush($output = " ", $sleep = 0){
     // ¼Â¹Ô»þ´Ö¤òÀ©¸Â¤·¤Ê¤¤
@@ -2902 +2904 @@
     // ½ÐÎϤò¥Ð¥Ã¥Õ¥¡¥ê¥ó¥°¤·¤Ê¤¤(==ÆüËܸ켫ưÊÑ´¹¤â¤·¤Ê¤¤)
     ob_end_clean();
-    
+
     // IE¤Î¤¿¤á¤Ë256¥Ð¥¤¥È¶õʸ»ú½ÐÎÏ
     echo str_pad('',256);
-    
+
     // ½ÐÎϤϥ֥é¥ó¥¯¤À¤±¤Ç¤â¤¤¤¤¤È»×¤¦
     echo $output;
     // ½ÐÎϤò¥Õ¥é¥Ã¥·¥å¤¹¤ë
     flush();
-    
+
     ob_end_flush();
-    ob_start(); 
-    
+    ob_start();
+
     // »þ´Ö¤Î¤«¤«¤ë½èÍý
     sleep($sleep);
@@ -2939 +2941 @@
 function sfSendPostData($url, $arrData, $arrOkCode = array()){
     require_once(DATA_PATH . "module/Request.php");
-    
+
     // Á÷¿®¥¤¥ó¥¹¥¿¥ó¥¹À¸À®
     $req = new HTTP_Request($url);
-    
+
     $req->addHeader('User-Agent', 'DoCoMo/2.0¡¡P2101V(c100)');
     $req->setMethod(HTTP_REQUEST_METHOD_POST);
-    
+
     // POST¥Ç¡¼¥¿Á÷¿®
     $req->addPostDataArray($arrData);
-    
+
     // ¥¨¥é¡¼¤¬Ìµ¤±¤ì¤Ð¡¢±þÅú¾ðÊó¤ò¼èÆÀ¤¹¤ë
     if (!PEAR::isError($req->sendRequest())) {
-        
+
         // ¥ì¥¹¥Ý¥ó¥¹¥³¡¼¥É¤¬¥¨¥é¡¼È½Äê¤Ê¤é¡¢¶õ¤òÊÖ¤¹
         $res_code = $req->getResponseCode();
-        
+
         if(!in_array($res_code, $arrOkCode)){
             $response = "";
@@ -2960 +2962 @@
             $response = $req->getResponseBody();
         }
-        
+
     } else {
         $response = "";
     }
-    
+
     // POST¥Ç¡¼¥¿¥¯¥ê¥¢
-    $req->clearPostData();  
-    
+    $req->clearPostData();
+
     return $response;
 }