Whilst on the subject of different databases some of you may be interested in a port to MS SQL Server that I have made.
The attached zip contains four files:
mssql.initial.sql
This is the TSQL code for creating the DB objects
insert_id.txt
This modifies the insert_id function in the rcube_db.inc file to allow for retrieval of the last identity value (@@IDENTITY) made to the database.
unixtimestamp.txt
This modifies the unixtimestamp function in the rcube_db.inc file
now_function.txt
This is a new function that is required to place the now() mysql function or getdate() mssql function in SQL query strings. For this to work all occurrences of the string "now()" in the project have to be replaced with a call to this function.
Please let me know whether any of you can make use this port.
John Woods