Changeset 788 for trunk

Timestamp:

Mar 20, 2023 8:21:06 PM (14 months ago)

Author:

anonymous

Message:

 

File:

• trunk/lib/Utilities.inc.php (modified) (1 diff)

trunk/lib/Utilities.inc.php

@@ -1136 +1136 @@
     require_once dirname(__FILE__) . '/DB.inc.php';
     $db =& DB::getInstance();
-
+    $pdo =& \Strangecode\Codebase\PDO::getInstance();
+
+    // Mysql version >= 5.7.4 stopped allowing a "zero" date of 0000-00-00.
+    // https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_no_zero_date
     if ($db->isConnected() && mb_strpos($db->getParam('zero_date'), '-') !== false) {
-        // Mysql version >= 5.7.4 stopped allowing a "zero" date of 0000-00-00.
-        // https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_no_zero_date
         $zero_date_parts = explode('-', $db->getParam('zero_date'));
+        $zero_y = $zero_date_parts[0];
+        $zero_m = $zero_date_parts[1];
+        $zero_d = $zero_date_parts[2];
+    } else if ($pdo->isConnected() && mb_strpos($pdo->getParam('zero_date'), '-') !== false) {
+        $zero_date_parts = explode('-', $pdo->getParam('zero_date'));
         $zero_y = $zero_date_parts[0];
         $zero_m = $zero_date_parts[1];