Changeset 8260 for temp/trunk/html

Timestamp:

2006/11/13 11:04:09 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/system/module.php (modified) (3 diffs)

temp/trunk/html/admin/system/module.php

@@ -132 +132 @@
     $path = UPDATE_HTTP . "module.txt";
     $fp = @fopen($path, "rb");
+    
+    $arrInsID = array();
         
     if(!$fp) {
         sfErrorHeader(">> " . $path . "¤Î¼èÆÀ¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£");
     } else {
-        
-        // ¥Ç¡¼¥¿ºï½ü
-        // $objQuery->query("DELETE FROM dtb_module");
         
         while (!feof($fp)) {
@@ -154 +153 @@
             // ¥«¥é¥à¿ô¤¬Àµ¾ï¤Ç¤¢¤Ã¤¿¾ì¹ç¤Î¤ß
             if(count($arrCSV) == MODULE_CSV_COL_MAX) {
+                    // insert¤¹¤ëmodule_id¤òÇÛÎó¤Ë³ÊǼ
+                    $arrInsID[] = $arrCSV[0];
+                
                     // ¼èÆÀ¤·¤¿¥¢¥Ã¥×¥Ç¡¼¥È¾ðÊó¤òDB¤Ë½ñ¤­¹þ¤à
                     $sqlval['module_id'] = $arrCSV[0];
@@ -185 +187 @@
             }
         }
+        
+        // ÉÔÍפʥǡ¼¥¿¤òºï½ü
+        if(count($arrInsID) > 0){
+            $del_sql = "DELETE FROM dtb_module WHERE module_id NOT IN (?";
+            
+            for($i = 1; $i < count($arrInsID); $i++){
+                $del_sql = "?,";
+            }
+            $del_sql = ")";
+            
+            $objQuery->query($del_sql, $arrInsID);
+        }
+
+        
         fclose($fp);
     }