Code: Alles auswählen
if ($sortby == "last_pic") {
$sql .= " ORDER BY pic_time DESC LIMIT 0,1";
}
if ($sortby == "good_rate") {
$sql .= " ORDER BY rating DESC LIMIT 0,1";
}
if ($sortby == "time_rate") {
$sql .= " ORDER BY rating DESC,pic_time DESC LIMIT 0,1";
}
Code: Alles auswählen
$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 " . phpbb_album . " AS p
LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_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 pic_approval = 1
GROUP BY p.pic_id DESC LIMIT 3";
//if ($sortby == "last_pic") {
//$sql .= " ORDER BY pic_time DESC LIMIT 0,1";
//}
//if ($sortby == "good_rate") {
//$sql .= " ORDER BY rating DESC LIMIT 0,1";
//}
//if ($sortby == "time_rate") {
//$sql .= " ORDER BY rating DESC,pic_time DESC LIMIT 0,1";
//}Code: Alles auswählen
FROM " . phpbb_album . "Code: Alles auswählen
// Get Newest Pic
$sql = "SELECT * FROM ". ALBUM_CONFIG_TABLE;
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, "Could not query album config information.", "", __LINE__, __FILE__, $sql);
}
while( $row = $db->sql_fetchrow($result) )
{
$album_config_name = $row['config_name'];
$album_config_value = $row['config_value'];
$album_config[$album_config_name] = $album_config_value;
}
$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_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 pic_approval = 1
GROUP BY p.pic_id ORDER BY pic_time DESC LIMIT 3";
if (!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not query album information.', '', __LINE__, __FILE__, $sql);
}
while ( $picrow = $db->sql_fetchrow($result) )
{
if(!$picrow['rating'])
{
$picrow['rating'] = $lang['Not_rated'];
}
else
{
$picrow['rating'] = round($picrow['rating'], 2);
}
$pic_poster = '<a href="'. append_sid("profile.$phpEx?mode=viewprofile&". POST_USERS_URL .'='. $picrow['pic_user_id']) .'">'. $picrow['pic_username'] .'</a>';
$template->assign_block_vars('albumrow', array(
'L_NEWEST_PIC' => $lang['Newest_pic'],
'PIC_IMAGE' => append_sid('album_thumbnail.'. $phpEx . '?pic_id=' . $picrow['pic_id']),
'U_PIC_LINK' => append_sid('album_page.' . $phpEx . '?pic_id=' . $picrow['pic_id']),
'L_PIC_TITLE' => $lang['Pic_Title'],
'L_VIEW' => $lang['View'],
'L_POSTER' => $lang['Poster'],
'L_POSTED' => $lang['Posted'],
'L_RATING' => $lang['Rating'],
'TITLE' => stripslashes($picrow['pic_title']),
'POSTER' => $picrow['username'],
'PIC_POSTER' => $pic_poster,
'TIME' => create_date($board_config['default_dateformat'], $picrow['pic_time'], $board_config['board_timezone']),
'VIEW' => $picrow['pic_view_count'],
'RATING' => ($album_config['rate'] == 1) ? ( '<a href="'. append_sid("album_rate.$phpEx?pic_id=". $picrow['pic_id']) . '">' . $lang['Rating'] . '</a> : ' . $picrow['rating'] . '<br />') : '',
'COMMENTS' => ($album_config['comment'] == 1) ? ( '<a href="'. append_sid("album_comment.$phpEx?pic_id=". $picrow['pic_id']) . '">' . $lang['Comments'] . '</a> : ' . $picrow['comments'] . '<br />') : '',
));
}
// END - Get Newest Pic
Code: Alles auswählen
<table border="0" align="center" cellspacing="1" cellpadding="1" class="forumline" width="100%">
<tr>
<!-- BEGIN albumrow -->
<td align="left" valign="top" class="row2">
<table border="0" align="center" cellspacing="1" cellpadding="1">
<tr>
<td><span class="gensmall" style="line-height:150%"><a href="{albumrow.U_PIC_LINK}"><img src="{albumrow.PIC_IMAGE}" border="0"></a></span></td>
<td><span class="gensmall">
{albumrow.L_PIC_TITLE}: {albumrow.TITLE}<br />
{albumrow.L_POSTER}: <b>{albumrow.PIC_POSTER}</b><br />
{albumrow.L_POSTED}: {albumrow.TIME}<br />
{albumrow.L_RATING}{albumrow.RATING}
{albumrow.L_VIEW}: {albumrow.VIEW}</span></td>
</tr>
<tr>
<td align="center" colspan="2"><span class="gensmall">{albumrow.COMMENTS}</span></td>
</tr>
</table></td>
<!-- END albumrow -->
</tr>
<tr>
<td align="center" class="row1" colspan="4"><span class="gensmall">[ <a href="{U_ALBUM}">{L_ALBUM}</a> ] </span></td>
</tr>
</table>