get_lastcommentmodified( string $timezone = 'server' )

The date the last comment was modified.


Description Description


Parameters Parameters

$timezone

(string) (Optional) Which timezone to use in reference to 'gmt', 'blog', or 'server' locations.

Default value: 'server'


Top ↑

Return Return

(string|false) Last comment modified date on success, false on failure.


Top ↑

Source Source

File: wp-includes/comment.php

321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
function get_lastcommentmodified( $timezone = 'server' ) {
    global $wpdb;
 
    $timezone = strtolower( $timezone );
    $key      = "lastcommentmodified:$timezone";
 
    $comment_modified_date = wp_cache_get( $key, 'timeinfo' );
    if ( false !== $comment_modified_date ) {
        return $comment_modified_date;
    }
 
    switch ( $timezone ) {
        case 'gmt':
            $comment_modified_date = $wpdb->get_var( "SELECT comment_date_gmt FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1" );
            break;
        case 'blog':
            $comment_modified_date = $wpdb->get_var( "SELECT comment_date FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1" );
            break;
        case 'server':
            $add_seconds_server = date( 'Z' );
 
            $comment_modified_date = $wpdb->get_var( $wpdb->prepare( "SELECT DATE_ADD(comment_date_gmt, INTERVAL %s SECOND) FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1", $add_seconds_server ) );
            break;
    }
 
    if ( $comment_modified_date ) {
        wp_cache_set( $key, $comment_modified_date, 'timeinfo' );
 
        return $comment_modified_date;
    }
 
    return false;
}

Top ↑

Changelog Changelog

Changelog
Version Description
4.7.0 Replaced caching the modified date in a local static variable with the Object Cache API.
1.5.0 Introduced.


Top ↑

User Contributed Notes User Contributed Notes

You must log in before being able to contribute a note or feedback.