END; $year = (empty($_GET['year']))?date('Y'):$_GET['year']; $month = (empty($_GET['month']))?date('m'):$_GET['month']; $query = dbQuery("SELECT FROM_unixTIME(date,'%e') as `day`,count(*) as `count` FROM `".$GLOBALS['prefix']."article`,`".$GLOBALS['prefix']."article_class` WHERE FROM_unixTIME(date,'%Y/%m') = '".$year."/".$month."' AND `status` = 'published' AND ".$GLOBALS['prefix']."article.class_id = ".$GLOBALS['prefix']."article_class.id AND `in_main_page` = 1 GROUP BY `day`;"); for ($i = 0;$i < mysql_num_rows($query);$i++) { $row = dbArray($query); $calendar[$row['day']] = $row['count']; }
for ($i = 0;$i < date('w',$start);$i++) { $str.= '<td> </td>'; } for($stamp=$start;$stamp<$end;$stamp+=86400) // loop through each day, which is 86400 seconds { $weekday=date('w', $stamp); $day = date('d', $stamp); if(date('Y-m-d', $stamp)==date('Y-m-d')) $style='today'; else if(date('w', $stamp)==0 || date('w', $stamp)==6) $style='weekend';