Changeset 5169 for temp/trunk/html/admin

Timestamp:

2006/09/19 21:05:28 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/basis/mail.php (modified) (1 diff)

temp/trunk/html/admin/basis/mail.php

@@ -76 +76 @@
     if ( $result ){
         $sql_where = "template_id = ". addslashes($_POST['template_id']);
-        $conn->query("UPDATE dtb_mailtemplate SET template_id = ?, subject = ?,header = ?, footer = ?,creator_id = ?, update_date = ?", $data);
+        $conn->query("UPDATE dtb_mailtemplate SET template_id = ?, subject = ?,header = ?, footer = ?,creator_id = ?, update_date = now()", $data);
     }else{
         $data["create_date"] = "now()";
-        $conn->query("INSERT INTO dtb_mailtemplate (template_id,subject,header,footer,creator_id,update_date,create_date) values ( ?,?,?,?,?,?,? )", $data);
+        $conn->query("INSERT INTO dtb_mailtemplate (template_id,subject,header,footer,creator_id,update_date,create_date) values ( ?,?,?,?,?,now(),now() )", $data);
     }