Changeset 28301

Show
Ignore:
Timestamp:
01/03/08 01:12:33 (7 months ago)
Author:
wuerzblog
Message:

using the wordpress timezone, gmt-offset

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • a-year-before/trunk/ayb_posts.php

    r26968 r28301  
    22/* 
    33Plugin Name: A Year Before 
    4 Version: 0.7beta2 
     4Version: 0.7beta3 
    55Plugin URI: http://wuerzblog.de/2006/12/27/wordpress-plugin-a-year-before/ 
    66Author: Ralf Thees 
    … …  
    2222       
    2323      function ayb_posts($ayb_para=Array()) { 
     24       
     25            function ayb_sgn($number) { 
     26                  if ($number > 0) return "+"; 
     27                  if ($number < 0) return "-"; 
     28                  if ($number == 0) return ""; 
     29                  }      
     30       
    2431      if ( is_array($ayb_para) && sizeof($ayb_para)>0)  $ayb_posts_is_widget=true; 
    2532 
    … …  
    8996            $dyear=1; 
    9097      } 
    91  
    92       $datum  = getdate(mktime(0, 0, 0, date("m")-$dmonth, date("d")-$dday, date("Y")-$dyear)); 
    93       $range_date1=date("Y-m-d",mktime(0, 0, 0, date("m")-$dmonth, date("d")-$dday, date("Y")-$dyear)).' 00:00:00'; 
    94       $range_date2=date("Y-m-d",mktime(0, 0, 0, date("m")-$dmonth, date("d")-$dday+$range, date("Y")-$dyear)).' 23:59:59'; 
    95  
    96       $q="SELECT ID, post_title, post_date_gmt FROM $wpdb->posts WHERE post_status='publish' AND post_password='' AND YEAR(post_date_gmt)=".$datum['year']." AND MONTH(post_date_gmt)=".$datum['mon']." AND DAYOFMONTH(post_date_gmt)=".$datum['mday']." ORDER BY post_date_gmt"; 
     98$ayb_tz=ayb_sgn(get_option('gmt_offset')*(-1)).get_option('gmt_offset')." hour"; 
     99      //$datum  = getdate(mktime(0, 0, 0, date("m")-$dmonth, date("d")-$dday, date("Y")-$dyear)); 
     100 
     101      $range_date1=date("Y-m-d H:i",strtotime($ayb_tz,mktime(0, 0, 0, date("m")-$dmonth, date("d")-$dday, date("Y")-$dyear))); 
     102      $range_date2=date("Y-m-d H:i",strtotime($ayb_tz,mktime(23,59,59, date("m")-$dmonth, date("d")-$dday+$range, date("Y")-$dyear))); 
     103      /*echo "r1: $range_date1<br />"; 
     104echo "r2: $range_date2<br />"; 
     105echo "tz: $ayb_tz<br />";*/ 
     106      //$range_date1 = date("Y-m-d H:i",strtotime(ayb_sgn(get_option('gmt_offset')).get_option('gmt_offset')." hour", strtotime($range_date1)));       
     107      //$range_date2 = date("Y-m-d H:i",strtotime(ayb_sgn(get_option('gmt_offset')).get_option('gmt_offset')." hour", strtotime($range_date2)));  
     108/*echo "r1: $range_date1<br />"; 
     109echo "r2: $range_date2<br />"; 
     110*/ 
     111 
     112      //$q="SELECT ID, post_title, post_date FROM $wpdb->posts WHERE post_status='publish' AND post_password='' AND YEAR(post_date)=".$datum['year']." AND MONTH(post_date)=".$datum['mon']." AND DAYOFMONTH(post_date)=".$datum['mday']." ORDER BY post_date"; 
    97113      $q="SELECT ID, post_title, post_date FROM $wpdb->posts WHERE post_status='publish' AND post_password='' AND (post_date >= '".$range_date1."' AND post_date <= '".$range_date2."') ORDER BY post_date DESC";  
    98 //echo $q;   
     114/*echo date("d.m.Y G:i")."<br>"; 
     115echo $q;*/   
    99116      $result = $wpdb->get_results($q, OBJECT); 
    100117      //print_r($result);