Edit File by line

$return[] = "SECOND( $column ) $compare $value";

[1000] Fix | Delete

}

[1001] Fix | Delete

[1002] Fix | Delete

return implode( ' AND ', $return );

[1003] Fix | Delete

}

[1004] Fix | Delete

[1005] Fix | Delete

// Cases where just one unit is set.

[1006] Fix | Delete

if ( isset( $hour ) && ! isset( $minute ) && ! isset( $second ) ) {

[1007] Fix | Delete

$value = $this->build_value( $compare, $hour );

[1008] Fix | Delete

if ( false !== $value ) {

[1009] Fix | Delete

return "HOUR( $column ) $compare $value";

[1010] Fix | Delete

}

[1011] Fix | Delete

} elseif ( ! isset( $hour ) && isset( $minute ) && ! isset( $second ) ) {

[1012] Fix | Delete

$value = $this->build_value( $compare, $minute );

[1013] Fix | Delete

if ( false !== $value ) {

[1014] Fix | Delete

return "MINUTE( $column ) $compare $value";

[1015] Fix | Delete

}

[1016] Fix | Delete

} elseif ( ! isset( $hour ) && ! isset( $minute ) && isset( $second ) ) {

[1017] Fix | Delete

$value = $this->build_value( $compare, $second );

[1018] Fix | Delete

if ( false !== $value ) {

[1019] Fix | Delete

return "SECOND( $column ) $compare $value";

[1020] Fix | Delete

}

[1021] Fix | Delete

}

[1022] Fix | Delete

[1023] Fix | Delete

// Single units were already handled. Since hour & second isn't allowed, minute must to be set.

[1024] Fix | Delete

if ( ! isset( $minute ) ) {

[1025] Fix | Delete

return false;

[1026] Fix | Delete

}

[1027] Fix | Delete

[1028] Fix | Delete

$format = '';

[1029] Fix | Delete

$time = '';

[1030] Fix | Delete

[1031] Fix | Delete

// Hour.

[1032] Fix | Delete

if ( null !== $hour ) {

[1033] Fix | Delete

$format .= '%H.';

[1034] Fix | Delete

$time .= sprintf( '%02d', $hour ) . '.';

[1035] Fix | Delete

} else {

[1036] Fix | Delete

$format .= '0.';

[1037] Fix | Delete

$time .= '0.';

[1038] Fix | Delete

}

[1039] Fix | Delete

[1040] Fix | Delete

// Minute.

[1041] Fix | Delete

$format .= '%i';

[1042] Fix | Delete

$time .= sprintf( '%02d', $minute );

[1043] Fix | Delete

[1044] Fix | Delete

if ( isset( $second ) ) {

[1045] Fix | Delete

$format .= '%s';

[1046] Fix | Delete

$time .= sprintf( '%02d', $second );

[1047] Fix | Delete

}

[1048] Fix | Delete

[1049] Fix | Delete

return $wpdb->prepare( "DATE_FORMAT( $column, %s ) $compare %f", $format, $time );

[1050] Fix | Delete

}

[1051] Fix | Delete

[1052] Fix | Delete

/**

[1053] Fix | Delete

* Sanitizes a 'relation' operator.

[1054] Fix | Delete

[1055] Fix | Delete

* @since 6.0.3

[1056] Fix | Delete

[1057] Fix | Delete

* @param string $relation Raw relation key from the query argument.

[1058] Fix | Delete

* @return string Sanitized relation. Either 'AND' or 'OR'.

[1059] Fix | Delete

[1060] Fix | Delete

public function sanitize_relation( $relation ) {

[1061] Fix | Delete

if ( 'OR' === strtoupper( $relation ) ) {

[1062] Fix | Delete

return 'OR';

[1063] Fix | Delete

} else {

[1064] Fix | Delete

return 'AND';

[1065] Fix | Delete

}

[1066] Fix | Delete

}

[1067] Fix | Delete

}

[1068] Fix | Delete

[1069] Fix | Delete

1 23