56
« on: September 21, 2005, 08:29:33 PM »
hallo,
ich lasse auf meiner startseite 27 neusten bilder anzeigen.
diese würde ich gerne nach datum unterteilt anzeigen lassen in dieser form:
neue bilder am 21.09.2005
bild bild bild
neue bilder am 20.09.2005
bild bild bild
neue bilder am 19.09.2005
bild bild bild
usw.
also erst soll das datum angezeigt werden und drunter die bilder die an diesem tag gepostet wurden
hab mir bereits die ganzen mod´s angeschaut aber leider nix vergleichbares gefunden
würde mich über hilfe sehr freuen
hier mein schow new images code aus der index.php:
//-----------------------------------------------------
//--- Show New Images ---------------------------------
//-----------------------------------------------------
$imgtable_width = ceil(intval($config['image_table_width']) / $config['image_cells']);
if ((substr($config['image_table_width'], -1)) == "%") {
$imgtable_width .= "%";
}
$additional_sql = "";
if (!empty($additional_image_fields)) {
foreach ($additional_image_fields as $key => $val) {
$additional_sql .= ", i.".$key;
}
}
$max_rows = 9;
$new_cutoff = time() - 60 * 60 * 24 * $config['new_cutoff']; $cells = $config['image_cells'];
$cat_id_sql = get_auth_cat_sql("auth_viewcat");
$sql = "SELECT COUNT(*) AS num_new_images FROM ".IMAGES_TABLE."
WHERE image_active = 1 AND image_date >= $new_cutoff
AND cat_id IN ($cat_id_sql)";
$row = $site_db->query_firstrow($sql);
$num_new_images = $row['num_new_images'];
$num_new_images = (($num_new_images = ((($num_new_images%$cells)==0) ? $num_new_images : ($num_new_images - ($num_new_images%$cells)+$cells))) > ($max_rows*$cells) ? ($max_rows*$cells) : $num_new_images );
$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 IN (".get_auth_cat_sql("auth_viewcat").")
ORDER BY i.image_date DESC
LIMIT $num_new_images";
$result = $site_db->query($sql);
$num_rows = $site_db->get_numrows($result);
if (!$num_rows) {
$new_images = "<table width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\"><tr class=\"imagerow1\"><td>";
$new_images .= $lang['no_new_images'];
$new_images .= "</td></tr></table>";
}
else {
$new_images = "<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;
$new_images .= "<tr class=\"imagerow".$row_bg_number."\">\n";
}
$new_images .= "<td width=\"".$imgtable_width."\" valign=\"top\">\n";
show_image($image_row);
$new_images .= $site_template->parse_template("thumbnail_bit");
$new_images .= "\n</td>\n";
$count++;
if ($count == $config['image_cells']) {
$new_images .= "</tr>\n";
$count = 0;
}
} // end while
if ($count > 0) {
$leftover = ($config['image_cells'] - $count);
if ($leftover >= 1) {
for ($f = 0; $f < $leftover; $f++) {
$new_images .= "<td width=\"".$imgtable_width."\">\n \n</td>\n";
}
$new_images .= "</tr>\n";
}
}
$new_images .= "</table>\n";
} // end else
$site_template->register_vars("new_images", $new_images);
unset($new_images);
Show Posts
