Changeset 5187

Timestamp:

2006/09/19 22:10:44 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html

Files:

• admin/contents/csv.php (modified) (2 diffs)
• admin/contents/csv_sql.php (modified) (1 diff)
• install/insert_data.sql (modified) (previous)

temp/trunk/html/admin/contents/csv.php

@@ -96 +96 @@
 
     // ¤Ò¤È¤Þ¤º¡¢Á´Éô»ÈÍѤ·¤Ê¤¤¤Ç¹¹¿·¤¹¤ë
-    $upd_sql = "UPDATE dtb_csv SET status = 2, rank = NULl WHERE csv_id = ?";
+    $upd_sql = "UPDATE dtb_csv SET status = 2, rank = NULL, update_date = now() WHERE csv_id = ?";
     $objQuery->query($upd_sql, array($csv_id));
 
@@ -102 +102 @@
     if (is_array($arrData)) {
         foreach($arrData as $key => $val){
-            $upd_sql = "UPDATE dtb_csv SET status = 1, rank = ? , update_date = now() WHERE csv_id = ? AND col = ? ";
+            $upd_sql = "UPDATE dtb_csv SET status = 1, rank = ? WHERE csv_id = ? AND col = ? ";
             $objQuery->query($upd_sql, array($key+1, $csv_id,$val));
         }

temp/trunk/html/admin/contents/csv_sql.php

@@ -335 +335 @@
             // ¥Ç¡¼¥¿¤Î¿·µ¬ºîÀ®
             $sql_id = "";
-            $sql = "INSERT INTO dtb_csv_sql (name, sql) values (?, ?) ";
+            $sql = "INSERT INTO dtb_csv_sql (name, sql, create_date, update_date) values (?, ?, now(), now()) ";
             $arrVal= array($arrData['name'], $arrData['sql']);