Hi!
an arbitrary number of files (e.g. jpg,flv) displayed in home.html:
search in index.php:
//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
add before:
//################################# Start Custom Images ###################################################
$file_ext = "flv";// < < < write your file extension here e.g. "jpg" or "mp3"< < <
$num_new_images = "5"; //< < < how many images to be displayed < < <
$custom_sort = "i.image_date"; //< < < how order? e.g. " i.image_rating, i.image_hits, i.image_votes, i.image_downloads,,i.image_date"< < <
$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 image_media_file LIKE '%.$file_ext'
ORDER BY $custom_sort DESC
LIMIT $num_new_images";
$result = $site_db->query($sql);
$num_rows2 = $site_db->get_numrows($result);
if (!$num_rows2) {
$new_images2 = "<table width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\"><tr class=\"imagerow1\"><td>";
$new_images2 .= $lang['no_new_images'];
$new_images2 .= "</td></tr></table>";
}
else {
$new_images2 = "<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_images2 .= "<tr class=\"imagerow".$row_bg_number."\">\n";
}
$new_images2 .= "<td width=\"".$imgtable_width."\" valign=\"top\">\n";
show_image($image_row);
$new_images2 .= $site_template->parse_template("thumbnail_bit");
$new_images2 .= "\n</td>\n";
$count++;
if ($count == $config['image_cells']) {
$new_images2 .= "</tr>\n";
$count = 0;
}
} // end while
if ($count > 0) {
$leftover = ($num_new_images - $count);
if ($leftover >= 1) {
for ($f = 0; $f < $leftover; $f++) {
$new_images2 .= "<td width=\"".$imgtable_width."\">\n \n</td>\n";
}
$new_images2 .= "</tr>\n";
}
}
$new_images2 .= "</table>\n";
} // end else
$site_template->register_vars("custom_images", $new_images2);
unset($new_images2);
//################################# End Custom Images ###################################################
at the top of code put the file extension, how many images to displayed, and how sort by.
write in your home.html {custom_images}
mfg Andi