dates and the new year (fyi)

fandelem

I don't know if any of you got burned by the new year and auto cleanup processes that delete database entries based on a date in the past.. but I did.. when the cleanup process ran, it deleted anyone who hadn't logged in before 2003.. which was.. well 99% of everyone.. heh.. I write this only because I got this code from php.net, and used it without really thinking about something like this... oh well, live and learn.. anyways here is the code to fix it:

        $month = (date("m")-3); // Three months ago.
        $day = date("d");
        $year = date("Y");
        $time = date("H:i:s");

    if ( $month < 1 )
    {
       $year -= 1;
       $month = 12 - ( -($month+1) );
    }
    if ( $month < 10 && strlen($month) == 1 )
      $month = "0" . $month;

    $date = $year . '-' . $month . '-' . $day . ' ' . $time;

(and yes, I know there are mysql functions for this, but I needed it for other things as well)

cheers,

ascension

Tried you code but it didn't seem to work for month - 1.....

This also seems to work:

$month = date("m", mktime(0,0,0,date("m")-1, date("01"), date("Y")));
$year  = date("Y", mktime(0,0,0,date("m")-1, date("01"), date("Y")));
$from = $year . "-". $month . "-01 00:00:00";

As you can prob. see I have hard coded day to be 01 but that can easily be changed.

Haven't had time to test it out fully, this place is RAD to the max 🙂