| | |
| | | | program/include/rcube_sqlite.inc | |
| | | | | |
| | | | This file is part of the RoundCube Webmail client | |
| | | | Copyright (C) 2005-2007, RoundCube Dev. - Switzerland | |
| | | | Copyright (C) 2005-2010, RoundCube Dev. - Switzerland | |
| | | | Licensed under the GNU GPL | |
| | | | | |
| | | | PURPOSE: | |
| | |
| | | |
| | | |
| | | function rcube_sqlite_from_unixtime($timestamp) |
| | | { |
| | | $timestamp = trim($timestamp); |
| | | if (!preg_match("/^[0-9]+$/is", $timestamp)) |
| | | $ret = strtotime($timestamp); |
| | | else |
| | | $ret = $timestamp; |
| | | { |
| | | $timestamp = trim($timestamp); |
| | | if (!preg_match('/^[0-9]+$/is', $timestamp)) |
| | | $ret = strtotime($timestamp); |
| | | else |
| | | $ret = $timestamp; |
| | | |
| | | $ret = date("Y-m-d H:i:s", $ret); |
| | | rcube_sqlite_debug("FROM_UNIXTIME ($timestamp) = $ret"); |
| | | return $ret; |
| | | } |
| | | $ret = date('Y-m-d H:i:s', $ret); |
| | | rcube_sqlite_debug("FROM_UNIXTIME ($timestamp) = $ret"); |
| | | return $ret; |
| | | } |
| | | |
| | | |
| | | function rcube_sqlite_unix_timestamp($timestamp="") |
| | | { |
| | | $timestamp = trim($timestamp); |
| | | if (!$timestamp) |
| | | $ret = time(); |
| | | else if (!preg_match("/^[0-9]+$/is", $timestamp)) |
| | | $ret = strtotime($timestamp); |
| | | else |
| | | $ret = $timestamp; |
| | | function rcube_sqlite_unix_timestamp($timestamp='') |
| | | { |
| | | $timestamp = trim($timestamp); |
| | | if (!$timestamp) |
| | | $ret = time(); |
| | | else if (!preg_match('/^[0-9]+$/is', $timestamp)) |
| | | $ret = strtotime($timestamp); |
| | | else |
| | | $ret = $timestamp; |
| | | |
| | | rcube_sqlite_debug("UNIX_TIMESTAMP ($timestamp) = $ret"); |
| | | return $ret; |
| | | } |
| | | rcube_sqlite_debug("UNIX_TIMESTAMP ($timestamp) = $ret"); |
| | | return $ret; |
| | | } |
| | | |
| | | |
| | | function rcube_sqlite_now() |
| | | { |
| | | rcube_sqlite_debug("NOW() = ".date("Y-m-d H:i:s")); |
| | | return date("Y-m-d H:i:s"); |
| | | } |
| | | { |
| | | rcube_sqlite_debug("NOW() = ".date("Y-m-d H:i:s")); |
| | | return date("Y-m-d H:i:s"); |
| | | } |
| | | |
| | | |
| | | function rcube_sqlite_md5($str) |
| | | { |
| | | return md5($str); |
| | | } |
| | | { |
| | | return md5($str); |
| | | } |
| | | |
| | | |
| | | function rcube_sqlite_debug($str) |
| | | { |
| | | //console($str); |
| | | } |
| | | { |
| | | //console($str); |
| | | } |
| | | |
| | | ?> |