wyświetla nam, pięć ostatnio wpisanych komentarzy na stronie startowej galerii.
Instalacja: ...
Czas: ...........
/*
MOD LAST COMMENTS
START INSERT
*/
//Settings
$num = 5; //how many comments to show
$thumb_size = 55; //max dim of thumbnails in pixels
$text_len = 200; //max lenght of the text to show (bbcode and html are counted too)
//End settings
$last_comments = "";
$sql = "SELECT c.image_id, c.comment_id, c.user_id as comment_user_id, c.user_name as guest_user_name, c.comment_headline, c.comment_text, c.comment_date, i.cat_id, i.user_id, i.image_name, i.image_media_file, i.image_thumb_file".get_user_table_field(", u.", "user_name")." as user_name".get_user_table_field(", s.", "user_name")." as comment_user_name
FROM ".COMMENTS_TABLE." c
LEFT JOIN ".IMAGES_TABLE." i ON i.image_id = c.image_id
LEFT JOIN ".USERS_TABLE." u ON ".get_user_table_field("u.", "user_id")." = i.user_id
LEFT JOIN ".USERS_TABLE." s ON ".get_user_table_field("s.", "user_id")." = c.user_id
WHERE i.image_active = 1 AND i.image_allow_comments = 1 AND i.cat_id NOT IN (".get_auth_cat_sql('auth_readcomment', 'NOTIN').") AND i.cat_id NOT IN (".get_auth_cat_sql('auth_viewcat', 'NOTIN').") AND i.cat_id NOT IN (".get_auth_cat_sql('auth_viewimage', 'NOTIN').")
ORDER BY c.comment_date DESC
LIMIT ".$num;
$result = $site_db->query($sql);
$bgcounter = 1;
while ($row = $site_db->fetch_array($result))
{
$row_bg_number = ($bgcounter++ % 2 == 0) ? 1 : 2;
if (empty($row['image_thumb_file']))
{
$thumb_file = ICON_PATH."/".get_file_extension($row['image_media_file']).".gif";
}
else
{
$thumb_file = (is_remote($row['image_thumb_file'])) ? $row['image_thumb_file'] : ROOT_PATH.THUMB_DIR."/".$row['cat_id']."/".$row['image_thumb_file'];
}
$thumb_info = @getimagesize($thumb_file);
$width = ($thumb_info[0]) ? $thumb_info[0] : $thumb_size;
$height = ($thumb_info[1]) ? $thumb_info[1] : $thumb_size;
if ($width > $thumb_size && $height > $thumb_size)
{
$ratio = $width / $height;
if ($ratio > 1) {
$new_width = $thumb_size;
$new_height = round(($thumb_size/$width) * $height);
}else {
$new_width = round(($thumb_size/$height) * $width);
$new_height = $thumb_size;
}
}
else
{
$new_width = $width;
$new_height = $height;
}
$view_image = true;
$thumb = "<img src=\"".$thumb_file."\" border=\"".$config['image_border']."\" width=\"".$new_width."\" height=\"".$new_height."\" alt=\"".$row['image_name']."\" />";
/*
$view_image = check_permission('auth_viewcat', $row['cat_id']);
$thumb = "<img src=\"".$thumb_file."\"".(($view_image) ? "" : " onClick=\"alert('".(($lang['auth_alert'][$cat_id]) ? $lang['auth_alert'][$cat_id] : $lang['auth_alert']['default'])."');\"")." border=\"".$config['image_border']."\" width=\"".$new_width."\" height=\"".$new_height."\" alt=\"".$row['image_name']."\" />";
*/
$image_user_name = ($row['user_id'] != GUEST) ? $row['user_name'] : $lang['userlevel_guest'];
$image_user_link = ($row['user_id'] != GUEST) ? $site_sess->url(ROOT_PATH."member.php?action=showprofile&user_id=".$row['user_id']) : "";
$comment_user_name = ($row['comment_user_id'] == GUEST) ? ((empty($row['guest_user_name'])) ? $lang['userlevel_guest'] : $row['guest_user_name']) : $row['comment_user_name'];
$comment_user_link = ($row['comment_user_id'] != GUEST) ? $site_sess->url(ROOT_PATH."member.php?action=showprofile&user_id=".$row['comment_user_id']) : "";
$text = $row['comment_text'];
if (strlen($text) > $text_len) {
$text = substr($text, 0, $text_len)." ...";
}
$site_template->register_vars(array(
"last_comments_more" => "<a href=\"".$site_sess->url(ROOT_PATH."member.php?action=showcomments", "&")."\">".$lang['last_comments_more']."</a>",
"comment_image" => ($view_image) ? "<a href=\"".$site_sess->url(ROOT_PATH."details.php?image_id=".$row['image_id'])."\">".$thumb."</a>" : $thumb,
"comment_guest" => ($row['comment_user_id'] == GUEST && !empty($row['guest_user_name'])) ? $lang['userlevel_guest'] : "",
"comment_image_name" => ($view_image) ? "<a href=\"".$site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$row['image_id'])."\">".stripslashes($row['image_name'])."</a>" : stripslashes($row['image_name']),
"image_cat_name" => (check_permission('auth_viewcat', $row['cat_id'])) ? "<a href=\"".$site_sess->url(ROOT_PATH."categories.php?".URL_CAT_ID."=".$row['cat_id'])."\">".$cat_cache[$row['cat_id']]['cat_name']."</a>" : $cat_cache[$row['cat_id']]['cat_name'],
"image_user_name" => ($image_user_link) ? "<a href=\"".$image_user_link."\">".$image_user_name."</a>" : $image_user_name,
"comment_user_name" => ($comment_user_link) ? "<a href=\"".$comment_user_link."\">".$comment_user_name."</a>" : $comment_user_name,
"comment_user_id" => $row['comment_user_id'],
"comment_headline" => format_text($row['comment_headline'], 0, $config['wordwrap_comments'], $config['bb_comments'], 0, 1),
"comment_text" => format_text($text, $config['html_comments'], $config['wordwrap_comments'], $config['bb_comments'], $config['bb_img_comments'], 1, 0),
"comment_date" => format_date($config['date_format']." ".$config['time_format'], $row['comment_date']),
"row_bg_number" => $row_bg_number
));
$last_comments .= $site_template->parse_template("last_comment_bit");
}
/*
if (empty($last_comments))
{
$last_comments = $lang['no_comments'];
}
*/
$site_template->register_vars(array(
"lang_last_comments" => $lang['last_comments'],
"last_comments" => $last_comments
));
/*
MOD LAST COMMENTS
START INSERT
*/
jest tylko przykładem i można go dopasować w inny sposób do własnej strony, wykorzystując dodając zmienne poniżej.
Pierwszy szablon udostępniony publicznie. 
Autor
