From 107bde9cfd9a0392d18544b5a433552ce6f2f0a6 Mon Sep 17 00:00:00 2001 From: thomascube Date: Wed, 30 Aug 2006 17:41:21 +0000 Subject: Added MSSQL support --- program/steps/addressbook/save.inc | 6 +++--- program/steps/mail/addcontact.inc | 2 +- 2 files changed, 4 insertions(+), 4 deletions(-) (limited to 'program/steps') diff --git a/program/steps/addressbook/save.inc b/program/steps/addressbook/save.inc index f6b8b3cc2..abea316e5 100644 --- a/program/steps/addressbook/save.inc +++ b/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/program/steps/mail/addcontact.inc b/program/steps/mail/addcontact.inc index a0e1e9394..b040581aa 100644 --- a/program/steps/mail/addcontact.inc +++ b/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