GoFuckYourself.com - Adult Webmaster Forum - View Single Post - When r u actualy going to update your footer 2012 date?

fris · 01-03-2012, 11:23 PM

if you wannna show the start year, as well as the current year this should do it.

Code:

<?php 

function custom_copyright() { 
    global $wpdb; 
    $copyright_dates = $wpdb->get_results("SELECT YEAR(min(post_date_gmt)) AS firstdate, YEAR(max(post_date_gmt)) AS lastdate FROM $wpdb->posts WHERE post_status = 'publish'"); 
    $output = ''; 
    if($copyright_dates) { 
        $copyright = "&copy; " . $copyright_dates[0]->firstdate; 
        if($copyright_dates[0]->firstdate != $copyright_dates[0]->lastdate) { 
            $copyright .= '-' . $copyright_dates[0]->lastdate; 
        } 
        $output = $copyright; 
    } 
    return $output; 
}