Changeset 28302
- Timestamp:
- 01/03/08 01:15:30 (6 months ago)
- Files:
-
- a-year-before/trunk/ayb_posts.php (modified) (1 diff)
- a-year-before/trunk/readme.txt (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
a-year-before/trunk/ayb_posts.php
r28301 r28302 96 96 $dyear=1; 97 97 } 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)); 98 $ayb_tz=ayb_sgn(get_option('gmt_offset')*(-1)).get_option('gmt_offset')." hour"; 100 99 101 100 $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 101 $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 />";104 echo "r2: $range_date2<br />";105 echo "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 />";109 echo "r2: $range_date2<br />";110 */111 102 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";113 103 $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"; 114 /*echo date("d.m.Y G:i")."<br>";115 echo $q;*/116 104 $result = $wpdb->get_results($q, OBJECT); 117 //print_r($result);118 105 119 106 //Ausgabe für's Widget a-year-before/trunk/readme.txt
r26968 r28302 76 76 == Changelog == 77 77 78 0.7beta3 79 80 * using the wordpress timezone-offset 81 78 82 0.7beta2 79 83
