Poszukiwania - [MOD] [Album] Ostatnie zdjęcia w indeksie forum
zz0rg - 10-03-2005, 21:57
Temat postu: [MOD] [Album] Ostatnie zdjęcia w indeksie forum
Witam,
Szukałem na tym forum ale nie znalazłem tego co mnie interesuje. Sam też próbowałem ale sypie się wszystko 
Chodi mi o ostatnio dodane fotki w indeksie forum. Dokładnie tak jak tutaj => http://www.cyberfoto.pl/
Z góry dzięki za podpowiedzi.
They - 10-03-2005, 22:58
usuniete
zz0rg - 10-03-2005, 23:26
no w?a?nie tego próbowałem... posypało się wszystko... jak nie było fotek w galerii to rysowała się pusta tabelka. jak dodałem foty to index się nie renderowa? do końca... ..pokombinuje może jeszcze raz z tym.
[ Dodano: 11-03-2005, 11:28 ]
No ok. Sam sobie pomogłem
Jak by kogo? interesowa?o to poniżej krótki przepis co i jak:
w index.php odszukaj:
| Kod: | $sql = "SELECT user_id
FROM " . JR_ADMIN_TABLE . "
WHERE user_jr_admin <> ''
LIMIT 1";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain junior admins', '', __LINE__, __FILE__, $sql);
}
if ($row = $db->sql_fetchrow($result))
{
$is_some_jr_admin = ($row['user_id']) ? true : false;
} |
i za tym wklej:
| Kod: |
////////////////////////////////////////////////////////////////////////////////////////////////////////
/// Album in index MOD
////////////////////////////////////////////////////////////////////////////////////////////////////////
//
// Get general album information
//
include($album_root_path . 'album_common.'.$phpEx);
/*
+----------------------------------------------------------
| Build Categories Index
+----------------------------------------------------------
*/
$sql = "SELECT c.*, COUNT(p.pic_id) AS count
FROM ". ALBUM_CAT_TABLE ." AS c
LEFT JOIN ". ALBUM_TABLE ." AS p ON c.cat_id = p.pic_cat_id
WHERE cat_id <> 0
GROUP BY cat_id
ORDER BY cat_order ASC";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query categories list', '', __LINE__, __FILE__, $sql);
}
$catrows = array();
while( $row = $db->sql_fetchrow($result) )
{
$album_user_access = album_user_access($row['cat_id'], $row, 1, 0, 0, 0, 0, 0); // VIEW
if ($album_user_access['view'] == 1)
{
$catrows[] = $row;
}
}
$allowed_cat = ''; // For Recent Public Pics below
//
// $catrows now stores all categories which this user can view. Dump them out!
//
for ($i = 0; $i < count($catrows); $i++)
{
// --------------------------------
// Build allowed category-list (for recent pics after here)
// --------------------------------
$allowed_cat .= ($allowed_cat == '') ? $catrows[$i]['cat_id'] : ',' . $catrows[$i]['cat_id'];
}
// END of Categories Index
/*
+----------------------------------------------------------
| Recent Public Pics
+----------------------------------------------------------
*/
if ($allowed_cat != '')
{
$sql = "SELECT p.pic_id, p.pic_filename, 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 pic_time DESC
LIMIT ". $album_config['cols_per_page'];
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query recent pics information', '', __LINE__, __FILE__, $sql);
}
$recentrow = array();
while( $row = $db->sql_fetchrow($result) )
{
$recentrow[] = $row;
}
if (count($recentrow) > 0)
{
for ($i = 0; $i < count($recentrow); $i += $album_config['cols_per_page'])
{
$template->assign_block_vars('recent_pics', array());
for ($j = $i; $j < ($i + $album_config['cols_per_page']); $j++)
{
if( $j >= count($recentrow) )
{
break;
}
if(!$recentrow[$j]['rating'])
{
$recentrow[$j]['rating'] = $lang['Not_rated'];
}
else
{
$recentrow[$j]['rating'] = round($recentrow[$j]['rating'], 2);
}
$pic_size = @getimagesize(ALBUM_UPLOAD_PATH . $recentrow[$j]['pic_filename']);
$pic_width = ($pic_size[0] + 20);
$pic_height = ($pic_size[1] + 25);
if ( $album_config['fullpic_popup'] )
{
$u_pic = append_sid("album_pic.$phpEx?pic_id=". $recentrow[$j]['pic_id']);
if ( $pic_size ) $u_pic = "javascript:displayWindow('$u_pic',$pic_width,$pic_height)";
else if ($album_config['fullpic_popup']) $target_blank = 'target="_blank"';
}
else $u_pic = append_sid("album_page.$phpEx?pic_id=". $recentrow[$j]['pic_id']);
$template->assign_block_vars('recent_pics.recent_col', array(
'U_PIC' => $u_pic,
'THUMBNAIL' => append_sid("album_thumbnail.$phpEx?pic_id=". $recentrow[$j]['pic_id']),
'DESC' => $recentrow[$j]['pic_desc']
)
);
if( ($recentrow[$j]['user_id'] == ALBUM_GUEST) or ($recentrow[$j]['username'] == '') )
{
$recent_poster = ($recentrow[$j]['pic_username'] == '') ? $lang['Guest'] : $recentrow[$j]['pic_username'];
}
else
{
$recent_poster = '<a href="'. append_sid("profile.$phpEx?mode=viewprofile&". POST_USERS_URL .'='. $recentrow[$j]['user_id']) .'">'. $recentrow[$j]['username'] .'</a>';
}
$template->assign_block_vars('recent_pics.recent_detail', array(
'TITLE' => $recentrow[$j]['pic_title'],
'POSTER' => $recent_poster,
)
);
}
}
}
else
{
//
// No Pics Found
//
$template->assign_block_vars('no_pics', array());
}
}
else
{
//
// No Cats Found
//
$template->assign_block_vars('no_pics', array());
}
////////////////////////////////////////////////////////////////////////////////////////////////////////
/// Album in index MOD KONIEC
////////////////////////////////////////////////////////////////////////////////////////////////////////
|
następnie odszukaj:
| Kod: |
'U_MARK_READ' => "index.$phpEx?mark=forums&sid=" . $userdata['session_id']),
|
i dodaj za tym zmieniając powyłsz? lini? też (chodzi o ten nawias na końcu):
| Kod: |
'U_MARK_READ' => "index.$phpEx?mark=forums&sid=" . $userdata['session_id'],
///////////////////// Album in Index MOD ////////////////////////////////////
'S_COLS' => $album_config['cols_per_page'],
'S_COL_WIDTH' => (100/$album_config['cols_per_page']) . '%',
'TARGET_BLANK' => $target_blank,
'L_NO_PICS' => $lang['No_Pics'],
'L_PIC_TITLE' => $lang['Pic_Title'],
'L_POSTER' => $lang['Poster'])
|
Zapisz index.php
Otwórz plik index_body.tpl z katalogu w którym znajduje się aktualnie używana skórka
i dodaj tabelk? w tym miejscu gdzie mają się pokazywa? ostatnie fotki. (np. przed {BOARD_INDEX})
| Kod: |
<table width="100%" cellpadding="1" cellspacing="1" border="0" align="center" class="forumline">
<tr>
<th /><th /><th /><th /><th />
</tr>
<!-- BEGIN no_pics -->
<tr>
<td class="row1" align="center" colspan="{S_COLS}" height="50"><span class="gen">{L_NO_PICS}</span></td>
</tr>
<!-- END no_pics -->
<!-- BEGIN recent_pics -->
<tr>
<!-- BEGIN recent_col -->
<td class="row1" width="{S_COL_WIDTH}" align="center"><a href="{recent_pics.recent_col.U_PIC}" {TARGET_BLANK}><img src="{recent_pics.recent_col.THUMBNAIL}" border="0" alt="{recent_pics.recent_col.DESC}" title="{recent_pics.recent_col.DESC}" vspace="10" /></a></td>
<!-- END recent_col -->
</tr>
<tr>
<!-- BEGIN recent_detail -->
<td class="row2"><span class="gensmall">{L_PIC_TITLE}: <b>{recent_pics.recent_detail.TITLE}</b><br />
{L_POSTER}: {recent_pics.recent_detail.POSTER}</span></td>
<!-- END recent_detail -->
</tr>
<!-- END recent_pics -->
<tr>
<td class="row1" width="{S_COL_WIDTH}">
<span class="gensmall" align="center"></span>
</td>
<td class="row1" width="{S_COL_WIDTH}">
<span class="gensmall" align="center"></span>
</td>
<td class="row1" width="{S_COL_WIDTH}">
<span class="gensmall"><center>[ <a href="album.php?sid=0c35faa14470677d4f940fafef29f522">Album</a> ]</center></span>
</td>
<td class="row1" width="{S_COL_WIDTH}">
<span class="gensmall" align="center"></span>
</td>
<td class="row1" width="{S_COL_WIDTH}">
<span class="gensmall" align="center"></span>
</td>
</tr>
</table>
|
To tyle... powinno działał...
strus - 20-05-2005, 11:14
zz0rg tak dziala, fajne to, z tym ze musialem zmienic z:
| Kod: | | include($album_root_path . 'album_common.'.$phpEx); |
na
| Kod: | | include($album_root_path . album_mod/'album_common.'.$phpEx); |
Ale ogolnie fajne
tomeck - 09-04-2006, 09:40
A jak zrobic "Ostatnie zdjecia" w indexie forum v. 1.12.5 ??
ozzzi - 09-04-2006, 20:56
zajrzyj tutaj http://www.przemo.org/php...pic.php?t=24886
|
|
|
