in der Album.php sind bei mir zwei Blöcke, einer davon zeigt die Bilder mit den meisten Kommentaren.
Nun möchte ich dort aber die Bilder mit den neuesten Kommentaren anzeigen lassen.
Hab schon im Forum hier und auf der Smartor-Site gesucht....hab aber nix gefunden.
Weiß jemand wie´s geht?
THX
/*
+----------------------------------------------------------
| commented Pics
| by yabba
+----------------------------------------------------------
*/
if ($allowed_cat != '')
{
$sql = "SELECT p.pic_id, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_username, p.pic_time, p.pic_cat_id, p.pic_view_count, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments
FROM ". ALBUM_TABLE ." AS p
LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id
LEFT JOIN ". ALBUM_CAT_TABLE ." AS ct ON p.pic_cat_id = ct.cat_id
LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id
LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id
WHERE p.pic_cat_id IN ($allowed_cat) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 )
GROUP BY p.pic_id
ORDER BY comments DESC
LIMIT ". $album_config['cols_per_page'];
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query com rated pics information', '', __LINE__, __FILE__, $sql);
}
$comrow = array();
while( $row = $db->sql_fetchrow($result) )
{
$comrow[] = $row;
}
if (count($comrow) > 0)
{
for ($i = 0; $i < count($comrow); $i += $album_config['cols_per_page'])
{
$template->assign_block_vars('com_pics', array());
for ($j = $i; $j < ($i + $album_config['cols_per_page']); $j++)
{
if( $j >= count($comrow) )
{
break;
}
if(!$comrow[$j]['rating'])
{
$comrow[$j]['rating'] = $lang['Not_rated'];
}
else
{
$comrow[$j]['rating'] = round($comrow[$j]['rating'], 2);
}
$template->assign_block_vars('com_pics.com_col', array(
'U_PIC' => ($album_config['fullpic_popup']) ? append_sid("album_pic.$phpEx?pic_id=". $comrow[$j]['pic_id']) : append_sid("album_page.$phpEx?pic_id=". $comrow[$j]['pic_id']),
'THUMBNAIL' => append_sid("album_thumbnail.$phpEx?pic_id=". $comrow[$j]['pic_id']),
'DESC' => $comrow[$j]['pic_desc']
)
);
if( ($comrow[$j]['user_id'] == ALBUM_GUEST) or ($comrow[$j]['username'] == '') )
{
$com_poster = ($comrow[$j]['pic_username'] == '') ? $lang['Guest'] : $comrow[$j]['pic_username'];
}
else
{
$com_poster = '<a href="'. append_sid("profile.$phpEx?mode=viewprofile&". POST_USERS_URL .'='. $comrow[$j]['user_id']) .'">'. $comrow[$j]['username'] .'</a>';
}
$template->assign_block_vars('com_pics.com_detail', array(
'c_TITLE' => $comrow[$j]['pic_title'],
'c_POSTER' => $com_poster,
'c_TIME' => create_date($board_config['default_dateformat'], $comrow[$j]['pic_time'], $board_config['board_timezone']),
'c_VIEW' => $comrow[$j]['pic_view_count'],
'c_RATING' => ($album_config['rate'] == 1) ? ( '<a href="'. append_sid("album_rate.$phpEx?pic_id=". $comrow[$j]['pic_id']) . '">' . $lang['Rating'] . '</a>: ' . $comrow[$j]['rating'] . '<br />') : '',
'c_COMMENTS' => ($album_config['comment'] == 1) ? ( '<a href="'. append_sid("album_comment.$phpEx?pic_id=". $comrow[$j]['pic_id']) . '">' . $lang['Comments'] . '</a>: ' . $comrow[$j]['comments'] . '<br />') : '',
'c_IP' => ($userdata['user_level'] == ADMIN) ? $lang['IP_Address'] . ': <a href="http://www.nic.com/cgi-bin/whois.cgi?query=' . decode_ip($comrow[$j]['pic_user_ip']) . '" target="_blank">' . decode_ip($comrow[$j]['pic_user_ip']) .'</a><br />' : ''
)
);
}
}
}
else
{
//
// No Pics Found
//
$template->assign_block_vars('no_pics', array());
}
}
else
{
// No Cats Found
//
$template->assign_block_vars('no_pics', array());
}
