|
= '{$CONFIG['min_votes_for_rating']}' $META_ALBUM_SET ORDER BY pic_rating DESC, votes DESC, pid DESC LIMIT $sliderlimit";
}
// request string for meta album most viewed
else if ($SLIDERSET['slider_album'] == "topn") {
$slider_query = "SELECT * FROM {$CONFIG['TABLE_PICTURES']} AS p WHERE filename like '%.jpg' AND filename not like 'youtube_%' $slider_FORBIDDEN_SET AND hits > 0 $META_ALBUM_SET ORDER BY hits DESC, filename LIMIT $sliderlimit";
}
// request string for meta album last uploads
else if ($SLIDERSET['slider_album'] == "lastup") {
$slider_query = "SELECT * FROM {$CONFIG['TABLE_PICTURES']} AS p WHERE filename like '%.jpg' AND filename not like 'youtube_%' $slider_FORBIDDEN_SET $META_ALBUM_SET ORDER BY pid DESC LIMIT $sliderlimit";
}
// request string for meta album random pics
else {
$slider_query = "SELECT * FROM {$CONFIG['TABLE_PICTURES']} AS p WHERE filename like '%.jpg' AND filename not like 'youtube_%' $slider_FORBIDDEN_SET $META_ALBUM_SET ORDER BY RAND() LIMIT $sliderlimit";
}
// For reading result
$slider_rowset = array();
// Index of tab
$i = 0;
// max height : will be 75px or 100px
$max_height = 0;
// For each pic.....building javascript in php
if ($SLIDERSET['slider_autowidth']) $slider_minpics = 15;
else $slider_minpics = 10;
// result of request
$slider_result = cpg_db_query($slider_query);
while ($slider_row = cpg_db_fetch_assoc($slider_result)) {
if (!$SLIDERSET['slider_skipportrait'] || ($slider_row['pwidth']>$slider_row['pheight'])) {
// reading pid of pic
$slider_key = $slider_row['pid'];
// reading height of pic
$slider_image_size = compute_img_size($slider_row['pwidth'], $slider_row['pheight'], $CONFIG['thumb_width']);
// Calcul de la hauteur maxi de la zone déroulante (par défaut = 75px)
if ($slider_image_size['height'] > $max_height) {
$max_height = $slider_image_size['height'];
}
// path of pic
$slider_file = $CONFIG['ecards_more_pic_target'].get_pic_url($slider_row,'thumb');
$slider_imgfile = get_pic_url($slider_row,$SLIDERSET['slider_pictype']);
if ($slider_imgfile == 'images/thumbs/thumb_nopic.png') $slider_imgfile = get_pic_url($slider_row, 'fullsize');
$slider_pictitle = $slider_row['title'];
// link of pic
$slider_lien =" ;height:;overflow:hidden;white-space:nowrap;">
;height:;">
|