From 39697e4e08c3143a6ed066c5b1b13f65765d187f Mon Sep 17 00:00:00 2001 From: thomasb Date: Wed, 30 Aug 2006 17:41:21 +0000 Subject: Added MSSQL support git-svn-id: https://svn.roundcube.net/trunk@328 208e9e7b-5314-0410-a742-e7e81cd9613c --- roundcubemail/program/steps/addressbook/save.inc | 6 +++--- roundcubemail/program/steps/mail/addcontact.inc | 2 +- 2 files changed, 4 insertions(+), 4 deletions(-) (limited to 'roundcubemail/program/steps') diff --git a/roundcubemail/program/steps/addressbook/save.inc b/roundcubemail/program/steps/addressbook/save.inc index f6b8b3cc2..abea316e5 100644 --- a/roundcubemail/program/steps/addressbook/save.inc +++ b/roundcubemail/program/steps/addressbook/save.inc @@ -50,7 +50,7 @@ if (!empty($_POST['_cid'])) if (sizeof($a_write_sql)) { $DB->query("UPDATE $contacts_table - SET changed=now(), ".join(', ', $a_write_sql)." + SET changed=".$DB->now().", ".join(', ', $a_write_sql)." WHERE contact_id=? AND user_id=? AND del<>1", @@ -172,8 +172,8 @@ else if (sizeof($a_insert_cols)) { $DB->query("INSERT INTO $contacts_table - (user_id, changed, del, ".join(', ', $a_insert_cols).") - VALUES (?, now(), 0, ".join(', ', $a_insert_values).")", + (user_id, changed, del, ".join(', ', $a_insert_cols).") + VALUES (?, ".$DB->now().", 0, ".join(', ', $a_insert_values).")", $_SESSION['user_id']); $insert_id = $DB->insert_id(get_sequence_name('contacts')); diff --git a/roundcubemail/program/steps/mail/addcontact.inc b/roundcubemail/program/steps/mail/addcontact.inc index a0e1e9394..b040581aa 100644 --- a/roundcubemail/program/steps/mail/addcontact.inc +++ b/roundcubemail/program/steps/mail/addcontact.inc @@ -43,7 +43,7 @@ if (!empty($_GET['_address'])) { $DB->query("INSERT INTO ".get_table_name('contacts')." (user_id, changed, del, name, email) - VALUES (?, now(), 0, ?, ?)", + VALUES (?, ".$DB->now().", 0, ?, ?)", $_SESSION['user_id'], $contact['name'], $contact['mailto']); -- cgit v1.2.3