Changeset 6463 for trunk/include/dblayer

Timestamp:

Jun 4, 2010, 9:36:56 PM (14 years ago)

Author:

nikrou

Message:

Fix bug 1717 : SQLite: access failure on Admin > Tools > History
hour function doesn't exists

Location:

trunk/include/dblayer

Files:

• functions_pdo-sqlite.inc.php (modified) (2 diffs)
• functions_sqlite.inc.php (modified) (2 diffs)

trunk/include/dblayer/functions_pdo-sqlite.inc.php

@@ -47 +47 @@
 
   $link->sqliteCreateFunction('now', 'pwg_now', 0);
+  $link->sqliteCreateFunction('hour', 'pwg_hour', 1);
   $link->sqliteCreateFunction('unix_timestamp', 'pwg_unix_timestamp', 0);
   $link->sqliteCreateFunction('md5', 'md5', 1);
@@ -571 +572 @@
 }
 
+function pwg_hour($datetime)
+{
+  return strftime('%H', $datetime);
+}
+
 function pwg_unix_timestamp()
 {

trunk/include/dblayer/functions_sqlite.inc.php

@@ -56 +56 @@
 
   $link->createFunction('now', 'pwg_now', 0);
+  $link->createFunction('hour', 'pwg_hour', 1);
   $link->createFunction('unix_timestamp', 'pwg_unix_timestamp', 0);
   $link->createFunction('md5', 'md5', 1);
@@ -583 +584 @@
 }
 
+function pwg_hour($datetime)
+{
+  return strftime('%H', $datetime);
+}
+
 function pwg_unix_timestamp()
 {