{whos_online}
<table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td class="head1"> <table width="100%" border="0" cellspacing="0" cellpadding="4"> <tr> <td class="head1" valign="top">Top images last week</td> </tr> </table> </td> </tr> <tr> <td class="head1">{last_week}</td> </tr> </table> <br>
$num_new_images = $config['image_cells'];
function getDaysInWeek($week="",$year=""){ $year = ($year) ? $year : date("Y"); $week = ($week) ? $week : date("W"); $time = strtotime($year.'0104+'.($week - 1).'weeks'); $mondayTime = strtotime('-'.(date('w',$time)-1).'days',$time); $dayTimes = array(); for ($i = 0; $i < 7;++$i){ $dayTimes[] = strtotime('+'.$i.'days', $mondayTime); //$dayTimes[] = date("d.m.Y",strtotime('+'.$i.'days', $mondayTime)); } return $dayTimes; }$lastweek = date("W") -1;$weekday = getDaysInWeek($lastweek);$num_new_images = $config['image_cells'];$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name")." FROM (".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c) LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id NOT IN (".get_auth_cat_sql("auth_viewcat", "NOTIN").") AND i.image_date BETWEEN ".$weekday[0]." AND ".($weekday[6] + 86399)." ORDER BY i.image_rating DESC LIMIT $num_new_images ";$result = $site_db->query($sql);$num_rows = $site_db->get_numrows($result);if (!$num_rows) { $last_week = "<table width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\"><tr class=\"imagerow1\"><td>"; $last_week .= "No Images last week !"; $last_week .= "</td></tr></table>";}else { $last_week = "<table width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\">"; $count = 0; $bgcounter = 0; while ($image_row = $site_db->fetch_array($result)){ if ($count == 0) { $row_bg_number = ($bgcounter++ % 2 == 0) ? 1 : 2; $last_week .= "<tr class=\"imagerow".$row_bg_number."\">\n"; } $last_week .= "<td width=\"".$imgtable_width."\" valign=\"top\">\n"; show_image($image_row); $last_week .= $site_template->parse_template("thumbnail_bit"); $last_week .= "\n</td>\n"; $count++; if ($count == $config['image_cells']) { $last_week .= "</tr>\n"; $count = 0; } } // end while if ($count > 0) { $leftover = ($config['image_cells'] - $count); if ($leftover >= 1) { for ($f = 0; $f < $leftover; $f++) { $last_week .= "<td width=\"".$imgtable_width."\">\n \n</td>\n"; } $last_week .= "</tr>\n"; } } $last_week .= "</table>\n";} // end else$site_template->register_vars("last_week", $last_week);unset($last_week);
unset($last_week)
unset($last_week);
$start_yesterday = mktime(00,00,00,date("m"),date("d")-1,date("Y")); $end_yesterday = mktime(23,59,59,date("m"),date("d")-1,date("Y"));
WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id NOT IN (".get_auth_cat_sql("auth_viewcat", "NOTIN").") AND i.image_date BETWEEN ".$weekday[3]." AND ".($weekday[4] + 86399)."
WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id NOT IN (".get_auth_cat_sql("auth_viewcat", "NOTIN").") AND i.image_date BETWEEN ".$start_yesterday." AND ".$end_yesterday."
ORDER BY i.image_rating DESC
ORDER BY i.image_hits DESC
$startTime = mktime(0, 0, 0, date("m")-1, 1, date("Y"));$endTime = mktime(0, 0, 0, date("m"), 0, date("Y"));$num_new_images = $config['image_cells'];$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name")." FROM (".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c) LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id NOT IN (".get_auth_cat_sql("auth_viewcat", "NOTIN").") AND i.image_date BETWEEN ".$startTime." AND ".$endTime." ORDER BY i.image_rating DESC LIMIT $num_new_images ";$result = $site_db->query($sql);$num_rows = $site_db->get_numrows($result);if (!$num_rows) { $last_month = "<table width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\"><tr class=\"imagerow1\"><td>"; $last_month .= "No Images last week !"; $last_month .= "</td></tr></table>";}else { $last_month = "<table width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\">"; $count = 0; $bgcounter = 0; while ($image_row = $site_db->fetch_array($result)){ if ($count == 0) { $row_bg_number = ($bgcounter++ % 2 == 0) ? 1 : 2; $last_month .= "<tr class=\"imagerow".$row_bg_number."\">\n"; } $last_month .= "<td width=\"".$imgtable_width."\" valign=\"top\">\n"; show_image($image_row); $last_month .= $site_template->parse_template("thumbnail_bit"); $last_month .= "\n</td>\n"; $count++; if ($count == $config['image_cells']) { $last_month .= "</tr>\n"; $count = 0; } } // end while if ($count > 0) { $leftover = ($config['image_cells'] - $count); if ($leftover >= 1) { for ($f = 0; $f < $leftover; $f++) { $last_month .= "<td width=\"".$imgtable_width."\">\n \n</td>\n"; } $last_month .= "</tr>\n"; } } $last_month .= "</table>\n";} // end else$site_template->register_vars("last_month", $last_month);unset($last_month);