#5 UNIX_TIMESTAMP is a MySQL-only non-standard function.

[Mario A. Valdez-Ramirez]

In the file class_webdav.php, at line 448 or so, the
SQL statement reads:

SELECT UNIX_TIMESTAMP(datum)...

unix_timestamp is non-standard, and other SQL engines
don't understand it (or have different function names).

The datum field stores the file time/date upload time
in a yyyymmddhhmmss format, just like a mysql timestamp
column. However, you cannot rely on mysql functions to
manage this if the addon is going to support all SQL
backends of Phprojekt.

A solution is to extract the datum field as is, and
then convert it in the PHP space. For example, the SQL
statement would be:

SELECT datum, typ, filesize, tempname, ID, pw...

and then convert the datum field to epoch time and
store it in a variable:

$unix_timestamp = mktime(substr($row[0],8,2),
substr($row[0],10,2), substr($row[0],12,2),
substr($row[0],4,2), substr($row[0],6,2),
substr($row[0],0,4));

and then store the values in the return array:

return array('mdate' => date ('U', $unix_timestamp),
'cdate' => date ('U', $unix_timestamp)...

(maybe the date function is redundant).

Regards,

Mario A. Valdez-Ramírez.