Changeset 7099 for trunk/src/includes/core/abstraction.php

Timestamp:

06/04/2020 09:57:59 PM (3 years ago)

Author:

johnjamesjacoby

Message:

Theme Compatibility: Avoid compatibility issues between MySQL versions.

This commit introduces a new function - bbp_get_empty_datetime() - which returns a valid, filterable, "empty" MySQL formatted datetime value.

This new function is used inside the theme compatibility API to ensure that global WP_Post datetime values are not "0" to better support MySQL 8 and higher, which is dropping support for NO_ZERO_DATES.

Props GDragoN.

In trunk, for 2.7.0.

See #3354.

File:

• trunk/src/includes/core/abstraction.php (modified) (1 diff)

trunk/src/includes/core/abstraction.php

@@ -476 +476 @@
         : $filtered;
 }
+
+/** Date/Time *****************************************************************/
+
+/**
+ * Get an empty datetime value.
+ *
+ * @since 2.6.6 bbPress (r7094)
+ *
+ * @return string
+ */
+function bbp_get_empty_datetime() {
+
+    // Get the database version
+    $db_version = bbp_db()->db_version();
+
+    // Default return value
+    $retval = '0000-00-00 00:00:00';
+
+    // Filter & return
+    return (string) apply_filters( 'bbp_get_default_zero_date', $retval, $db_version );
+}