Changeset 3412 for temp/trunk

Timestamp:

2006/08/31 09:58:27 (20 years ago)

Author:

naka

Message:

* empty log message *

Location:

temp/trunk/html

Files:

• admin/system/update.php (modified) (4 diffs)
• install/create_table.sql (modified) (previous)

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

@@ -143 +143 @@
                 $sqlval['extern_php'] = $arrCSV[6];
                 $sqlval['sql'] = $arrCSV[7];
-                $sqlval['other_files'] = $arrCSV[8];
-                $sqlval['delete'] = $arrCSV[9];
+                $sqlval['uninstall_sql'] = $arrCSV[8];              
+                $sqlval['other_files'] = $arrCSV[9];
+                $sqlval['delete'] = $arrCSV[10];
                 $sqlval['update_date'] = "now()";
-                $sqlval['release_date'] = $arrCSV[12];
+                $sqlval['release_date'] = $arrCSV[13];
                 // ´û¸¥ì¥³¡¼¥É¤Î¥Á¥§¥Ã¥¯
                 $cnt = $objQuery->count("dtb_update", "module_id = ?", array($sqlval['module_id']));
@@ -191 +192 @@
     if($arrRet[0]['sql'] != "") {
         // SQLʸ¼Â¹Ô¡¢¥Ñ¥é¡¼¥á¡¼¥¿¤Ê¤·¡¢¥¨¥é¡¼Ìµ»ë
-        $objQuery->query($arrRet[0]['sql'],"",true);
+        $ret = $objQuery->query($arrRet[0]['sql'],"",true);
+        
+        sfPrintR($ret);
+        
         $objPage->update_mess.=">> ¥Æ¡¼¥Ö¥ë¹½À®¤ÎÊѹ¹¤ò¹Ô¤¤¤Þ¤·¤¿¡£<br>";
     }
@@ -207 +211 @@
     
     $objQuery = new SC_Query();
-    $arrRet = $objQuery->select("module_id, extern_php, other_files, sql, latest_version", "dtb_update", "module_id = ?", array($_POST['module_id']));
+    $arrRet = $objQuery->select("module_id, extern_php, other_files, sql, uninstall_sql, latest_version", "dtb_update", "module_id = ?", array($_POST['module_id']));
     $flg_ok = true; // ½èÍý¤ÎÀ®¸ùȽÄê
     
@@ -227 +231 @@
             }
         }
+        
+        // ɬÍפÊSQLʸ¤Î¼Â¹Ô
+        if($arrRet[0]['uninstall_sql'] != "") {
+            // SQLʸ¼Â¹Ô¡¢¥Ñ¥é¡¼¥á¡¼¥¿¤Ê¤·¡¢¥¨¥é¡¼Ìµ»ë
+            $ret = $objQuery->query($arrRet[0]['uninstall_sql'],"",true);
+            
+            sfPrintR($ret);
+            
+            $objPage->update_mess.=">> ¥Æ¡¼¥Ö¥ë¹½À®¤ÎÊѹ¹¤ò¹Ô¤¤¤Þ¤·¤¿¡£<br>";
+        }
+        
     } else {
         sfErrorHeader(">> Âоݤε¡Ç½¤Ï¡¢ÇÛÉÛ¤ò½ªÎ»¤·¤Æ¤ª¤ê¤Þ¤¹¡£");