# Day/Month/Year Ago Today #
by Cyberian75

Source: http://board.michaelpark.net/viewtopic.php?t=25

Basically, it put up links to the posts you've made nth days, months and/or years ago today. 

Put the following at the end of the b2template.functions.php file right before the "?>"
closing tag...
  
[code]
<?php
function agotoday($num=3, $type='month', $linkmsg='months ago today...') {
   global $tableposts, $querycount, $siteurl;
   
   $query = "SELECT YEAR(post_date) AS year, MONTH(post_date) AS month, DAYOFMONTH(post_date) AS day FROM $tableposts " .
               "WHERE DATE_FORMAT(post_date, '%m-%d-%Y') = DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL '$num' $type), '%m-%d-%Y') " .
               "ORDER BY post_date DESC LIMIT 1";
   
   $result = mysql_query($query) or die(mysql_error());
   $exist = mysql_num_rows($result);
   
   $querycount++;
   
   if ($exist) {
       $row = mysql_fetch_object($result);

       $year = $row->year;
       $month = zeroise($row->month,2);
       $day = zeroise($row->day,2);
           
       echo '<a href="'.$siteurl.'/?m='.$year.$month.$day.'">'.$num.' '.$linkmsg.'</a>';
   } else {
       echo $num.' '.$linkmsg;
   }
}
?>
[/code]

And call it with the following from where you want to put those links...
  
[code]
<?php agotoday(7, 'day', 'days ago today...'); ?><br>
<?php agotoday(1, 'month', 'month ago today...'); ?><br>
<?php agotoday(6, 'month', 'months ago today...'); ?><br>
<?php agotoday(1, 'year', 'year ago today...'); ?><br>
<?php agotoday(2, 'year', 'years ago today...'); ?> 
[/code]

All there is to it!

Source: http://board.michaelpark.net/viewtopic.php?t=25