Changeset 5170 for temp/trunk/html/admin

Timestamp:

2006/09/19 21:06:01 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/basis/mail.php (modified) (2 diffs)

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

@@ -67 +67 @@
     
     $data['creator_id'] = $_SESSION['member_id'];
-    $data["update_date"] = "now()";
-    
     sfprintr($conn);
     sfprintr($data);
@@ -76 +74 @@
     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 = now()", $data);
+        $conn->query("UPDATE dtb_mailtemplate SET template_id = ?, subject = ?,header = ?, footer = ?,creator_id = ?, update_date = now() WHERE".$sql_where, $data);
     }else{
-        $data["create_date"] = "now()";
         $conn->query("INSERT INTO dtb_mailtemplate (template_id,subject,header,footer,creator_id,update_date,create_date) values ( ?,?,?,?,?,now(),now() )", $data);
     }