Re: Consistant Pic_detail Forum Wide
Give this a try.
OPEN
templates/YOUR TEMPLATE/album_memberlist_body.tpl
FIND
{L_PIC_ID}: {picrow.pic_detail.PIC_ID}<br />
AFTER ADD
{L_POSTER}: {picrow.pic_detail.POSTER}<br />
OPEN
album_allpics.php
FIND
$list_sql = "SELECT DISTINCT(p.pic_id), ct.cat_user_id, ct.cat_id, ct.cat_title, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_time, p.pic_view_count, p.pic_lock, p.pic_filename, p.pic_thumbnail, r.rate_pic_id,
AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments, MAX(c.comment_id) as new_comment
FROM ".ALBUM_TABLE. " AS p
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
LEFT JOIN ".ALBUM_CAT_TABLE." AS ct ON p.pic_cat_id = ct.cat_id
WHERE ct.cat_id IN ($allowed_cat)
GROUP BY p.pic_id
ORDER BY $sort_method $sort_order
LIMIT $limit_sql";
REPLACE WITH
$list_sql = "SELECT DISTINCT(p.pic_id), ct.cat_user_id, ct.cat_id, ct.cat_title, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_time, p.pic_view_count, p.pic_lock, p.pic_filename, p.pic_thumbnail, r.rate_pic_id,
AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments, MAX(c.comment_id) as new_comment, u.username AS username
FROM ".ALBUM_TABLE. " AS p
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
LEFT JOIN ".ALBUM_CAT_TABLE." AS ct ON p.pic_cat_id = ct.cat_id
LEFT JOIN ".USERS_TABLE." AS u ON p.pic_user_id = u.user_id
WHERE ct.cat_id IN ($allowed_cat)
GROUP BY p.pic_id
ORDER BY $sort_method $sort_order
LIMIT $limit_sql";
FIND
$image_cat_url = append_sid(album_append_uid($album_page_url . '?cat_id=' . $picrow[$j]['cat_id'] . '&user_id=' . $picrow[$j]['cat_user_id']));
AFTER ADD
if( ($picrow[$j]['pic_user_id'] == ALBUM_GUEST) || ($picrow[$j]['username'] == '') )
{
$pic_poster = ($picrow[$j]['pic_username'] == '') ? $lang['Guest'] : $picrow[$j]['pic_username'];
}
else
{
$pic_poster = '<a href="'. append_sid(PROFILE_MG . '?mode=viewprofile&' . POST_USERS_URL .'='. $picrow[$j]['pic_user_id']) .'">'. $picrow[$j]['username'] .'</a>';
}
FIND
'TITLE' => $picrow[$j]['pic_title'],
AFTER ADD
FIND
'L_PICTURES_OF_USER' => $list_title,
AFTER ADD
'L_POSTER' => $lang['Pic_Poster'],
also uses this same tpl file (for all pics of user)...I suspect it is very similar to album_allpics.php, but I did not check....so if you want the poster name here, you will need to modify it as well
Lone Star State
