https://www.icyphoenix.com/viewtopic.php?f=26&t=909&p=7402#p7402 ----------------------------------- krisbfunk Sun 14 Jan, 2007 09:09 FAP CUSTOMIZATION - Image Blocks In Page Header ----------------------------------- Hey, Got this code from Ricky on Smartor's site.. wondering how to convert it to FAP, I tried replacing album_page with album_showpage (in pageheader modification) and lang_main_album to lang_album_main and lang_admin_album to lang_album_admin in admin_header_album_block, but it still doesn't show a thumbnail.. any idea? I'm looking to get a single random block and a single personal gallery block in my header. [b]install file:[/b] [code]############################################################## ## MOD Title: Photo Album Block Add-on ## MOD Author: Kooky (n/a) http://perso.edeign.com/kooky/ ## MOD Description: This mod will show last or random pics on your portal (or index) ## It uses album's permissions, approval options (and many more). ## You can choose to add one or some pics and allow only one category ## to be displayed on portal (no multi-cats support) with an Admin Panel. ## MOD Version: 1.0.0 ## Compatibility: 2.0.3 - 2.0.10 ## ## MOD Require: Photo Album Addon v2.0.53 ## Smartor (Hoang Ngoc Tu) http://smartor.is-root.com ## ## Installation Level: Easy ## Installation Time: 5 minutes ## Files to Edit: 3 ## /includes/page_header.php ## language/lang_english/lang_admin.php ## templates/subSilver/overall_header.tpl ## Included Files: 2 ## admin_header_album_block.php ## album_header_block_body.tpl ## ############################################################## ############################################################## ## This MOD is released under the GPL License. ## Intellectual Property is retained by the MOD Author(s) listed above ############################################################## ############################################################## ## Author Notes: ## ## 1. Copyright and special thanks! ## ----------- ## 2. Other than a few minor changes this is still Kooky's block, ## all I did was make it work with the block for the portal so ## both could be used at the same time. Later Ricky_Racer :) ## ############################################################## ## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD ############################################################## # #-----[ SQL ]------------------------------------------ # INSERT INTO phpbb_album_config (config_name, config_value) VALUES ('header_cat_id', '0'); INSERT INTO phpbb_album_config (config_name, config_value) VALUES ('header_pics_all', '0'); INSERT INTO phpbb_album_config (config_name, config_value) VALUES ('header_pics_number', '1'); INSERT INTO phpbb_album_config (config_name, config_value) VALUES ('header_pics_sort', '0'); # #-----[ COPY ]------------------------------------------ # copy root/admin/admin_album_block.php to admin/admin_header_album_block.php copy root/templates/admin/album_block_body.tpl to templates/admin/album_header_block_body.tpl # #-----[ OPEN ]------------------------------------------ # /includes/page_header.php # #-----[ FIND ]------------------------------------------ # // Format Timezone. We are unable to use array_pop here, because of PHP3 compatibility $l_timezone = explode('.', $board_config['board_timezone']); # #-----[ BEFORE, ADD ]----------------------------------- # // Start add - Photo Album Block $album_root_path = $phpbb_root_path . 'album_mod/'; include_once($album_root_path . 'album_common.'.$phpEx); // Build Categories Index $sql = "SELECT c.* 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; } } if ( $album_config['header_pics_all'] == '1' ) { $allowed_cat = '0'; // For Recent Public Pics below } else { $allowed_cat = ''; } // $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']; // Check Pic Approval if ( ($catrows[$i]['cat_approval'] == ALBUM_ADMIN) || ($catrows[$i]['cat_approval'] == ALBUM_MOD) ) { $pic_approval_sql = 'AND p.pic_approval = 1'; // Pic Approval ON } else { $pic_approval_sql = ''; // Pic Approval OFF } } // Recent Public Pics if ( $album_config['header_pics_all'] == '1' ) { $pics_allowed = '0'; } else { $pics_allowed = ''; } if ( $allowed_cat != $pics_allowed ) { $category_id = $album_config['header_cat_id']; if ( $album_config['header_pics_sort'] == '1' ) { if ( $category_id != 0 ) { $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, u.user_level, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments, p.pic_filename AS picfilename 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 ) AND pic_cat_id = ($category_id) GROUP BY p.pic_id ORDER BY RAND() LIMIT ". $album_config['header_pics_number']; } else { $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, u.user_level, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments, p.pic_filename AS picfilename 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 RAND() LIMIT ". $album_config['header_pics_number']; } } else if ( $album_config['header_pics_sort'] == '0' ) { if ( $category_id != 0 ) { $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, u.user_level, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments, p.pic_filename AS picfilename 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 ) AND pic_cat_id = ($category_id) GROUP BY p.pic_id ORDER BY pic_time DESC LIMIT ". $album_config['header_pics_number']; } else { $sql = "SELECT u.user_level, 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, u.user_level, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments, p.pic_filename AS picfilename 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['header_pics_number']; } } 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_header_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); } // Display pics horizontally $template->assign_block_vars('recent_header_pics.recent_col', array( 'U_PIC' => ($album_config['fullpic_popup']) ? append_sid("album_pic.$phpEx?pic_id=". $recentrow[$j]['pic_id']) : append_sid("album_page.$phpEx?pic_id=". $recentrow[$j]['pic_id']), '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 { // Start add - Username Color Mod switch ( $recentrow[$j]['user_level'] ) { case ADMIN: $poster_name = '' . $recentrow[$j]['username'] . ''; $style_color = ' style="color:#' . $theme['fontcolor3'] . '"'; break; case MOD: $poster_name = '' . $recentrow[$j]['username'] . ''; $style_color = ' style="color:#' . $theme['fontcolor2'] . '"'; break; default: $poster_name = $recentrow[$j]['username']; $style_color = ''; break; } // End add - Username Color Mod $recent_poster = '' . $poster_name . ''; } // Start add - Pics Dimension/Size Add-on $pic_dimension = getimagesize(ALBUM_UPLOAD_PATH . $recentrow[$j]['picfilename']); $pic_width = $pic_dimension[0]; $pic_height = $pic_dimension[1]; $pic_size = round(((filesize(ALBUM_UPLOAD_PATH . $recentrow[$j]['picfilename'])) / 1024), 2) . ' ' . $lang['Kb']; // End add - Pics Dimension/Size Add-on // Display pics vertically $template->assign_block_vars('recent_header_pics.recent_detail', array( 'U_PIC' => ($album_config['fullpic_popup']) ? append_sid("album_pic.$phpEx?pic_id=". $recentrow[$j]['pic_id']) : append_sid("album_page.$phpEx?pic_id=". $recentrow[$j]['pic_id']), 'THUMBNAIL' => append_sid("album_thumbnail.$phpEx?pic_id=". $recentrow[$j]['pic_id']), 'DESC' => $recentrow[$j]['pic_desc'], 'TITLE' => $recentrow[$j]['pic_title'], 'POSTER' => $recent_poster, 'TIME' => create_date($board_config['default_dateformat'], $recentrow[$j]['pic_time'], $board_config['board_timezone']), // New entries - Pics Dimension/Size Add-on 'DIMENSION' => $pic_width . ' x ' . $pic_height, 'SIZE' => $pic_size, 'VIEW' => $recentrow[$j]['pic_view_count'], 'RATING' => ($album_config['rate'] == 1) ? ( $lang['Rating'] . ': ' . $recentrow[$j]['rating'] . '
') : '', 'COMMENTS' => ($album_config['comment'] == 1) ? ( $lang['Comments'] . ': ' . $recentrow[$j]['comments'] . '') : '') ); } } } else { // No Pics Found $template->assign_block_vars('no_header_pics', array()); } } else { // No Cats Found $template->assign_block_vars('no_header_pics', array()); } // End add - Photo Album Block # #-----[ FIND ]------------------------------------------ # 'NAV_LINKS' => $nav_links_html) ); # #-----[ BEFORE, ADD ]----------------------------------- # // Start add - Photo Album Block 'S_COLS' => $album_config['cols_per_page'], 'S_COL_WIDTH' => ( 100/$album_config['cols_per_page'] ) . '%', 'TARGET_BLANK' => ( $album_config['fullpic_popup'] ) ? ' target="_blank"' : '', 'U_ALBUM' => append_sid('album.'.$phpEx), 'L_ALBUM' => $lang['Album'], 'L_NEWEST_PICS' => ( $album_config['pics_sort'] == '0' ) ? $lang['Newest_pics'] : $lang['Random_pics'], 'L_NO_PICS' => $lang['No_Pics'], 'L_PIC_TITLE' => $lang['Pic_Title'], 'L_POSTER' => $lang['Poster'], 'L_POSTED' => $lang['Posted'], 'L_DIMENSION' => $lang['Dimension'], 'L_SIZE' => $lang['Size'], 'L_VIEW' => $lang['View'], // End add - Photo Album Block # #-----[ OPEN ]------------------------------------------ # language/lang_english/lang_admin.php # #-----[ FIND ]------------------------------------------ # ?> # #-----[ BEFORE, ADD ]----------------------------------- # // Start add - Photo Album Block Header $lang['header_photo_block'] = 'Header Photo Album Block'; $lang['header_album_block_config'] = 'Header Photo Album Block Configuration'; $lang['header_album_block_config_explain'] = 'Here, you can change the general settings of your Header Photo Album Block.'; $lang['Click_return_header_album_block_config'] = 'Click %sHere%s to return to the Header Photo Album Block Configuration'; $lang['Pics_header_cat_id'] = 'Pics category'; $lang['Pics_header_cat_id_explain'] = 'ID from a category of the Photo Album.
Multi-categories are not supported, 0 means all categories were used.'; $lang['Pics_header_number'] = 'Number of pics'; $lang['Pics_header_number_explain'] = 'Show the number of pics you want to view in the header.'; $lang['Pics_header_all'] = 'Enable personal gallery viewing'; $lang['Pics_header_sort'] = 'Show randomly your pics'; // End add - Photo Album Block Header # #-----[ OPEN ]------------------------------------------ # templates/subSilver/overall_header.tpl # #-----[ FIND ]------------------------------------------ #
# #-----[ AFTER, ADD ]------------------------------------ #
{L_NEWEST_PICS}
{L_NO_PICS}
{recent_header_pics.recent_col.DESC}
{L_PIC_TITLE}: {recent_header_pics.recent_detail.TITLE}
{L_POSTER}: {recent_header_pics.recent_detail.POSTER}
{L_POSTED}: {recent_header_pics.recent_detail.TIME}
{L_DIMENSION}: {recent_header_pics.recent_detail.DIMENSION}
{L_SIZE}: {recent_header_pics.recent_detail.SIZE}
{L_VIEW}: {recent_header_pics.recent_detail.VIEW}
{recent_header_pics.recent_detail.RATING}{recent_header_pics.recent_detail.COMMENTS}
[ {L_ALBUM} ]

# #-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ # # END[/code] [b]admin_header_album_block.php[/b] [code] sql_query($sql)) { message_die(CRITICAL_ERROR, "Could not query Album config information", "", __LINE__, __FILE__, $sql); } else { while( $row = $db->sql_fetchrow($result) ) { $config_name = $row['config_name']; $config_value = $row['config_value']; $default_config[$config_name] = $config_value; $new[$config_name] = ( isset($HTTP_POST_VARS[$config_name]) ) ? $HTTP_POST_VARS[$config_name] : $default_config[$config_name]; if( isset($HTTP_POST_VARS['submit']) ) { $sql = "UPDATE " . ALBUM_CONFIG_TABLE . " SET config_value = '" . str_replace("'", "''", $new[$config_name]) . "' WHERE config_name = '$config_name'"; if( !$db->sql_query($sql) ) { message_die(GENERAL_ERROR, "Failed to update Album configuration for $config_name", "", __LINE__, __FILE__, $sql); } } } if( isset($HTTP_POST_VARS['submit']) ) { $message = $lang['Album_config_updated']; $message .= '

' . sprintf($lang['Click_return_header_album_block_config'], '', ''); $message .= '

' . sprintf($lang['Click_return_album_config'], '', '') . '

' . sprintf($lang['Click_return_admin_index'], '', ''); message_die(GENERAL_MESSAGE, $message); } } // Allow all pics $header_pics_all_yes = ( $new['header_pics_all'] ) ? ' checked="checked"' : ''; $header_pics_all_no = ( !$new['header_pics_all'] ) ? ' checked="checked"' : ''; // Sort pics $header_pics_sort_yes = ( $new['header_pics_sort'] ) ? ' checked="checked"' : ''; $header_pics_sort_no = ( !$new['header_pics_sort'] ) ? ' checked="checked"' : ''; $template->set_filenames(array( "body" => "admin/album_header_block_body.tpl") ); $template->assign_vars(array( 'L_ALBUM_HEADER_BLOCK_CONFIG' => $lang['header_album_block_config'], 'L_ALBUM_HEADER_BLOCK_CONFIG_EXPLAIN' => $lang['header_album_block_config_explain'], 'S_ALBUM_HEADER_BLOCK_CONFIG_ACTION' => append_sid('admin_header_album_block.'.$phpEx), 'HEADER_PICS_CAT_ID' => $new['header_cat_id'], 'HEADER_PICS_NUMBER' => $new['header_pics_number'], 'HEADER_PICS_ALL_YES' => $header_pics_all_yes, 'HEADER_PICS_ALL_NO' => $header_pics_all_no, 'HEADER_PICS_SORT_YES' => $header_pics_sort_yes, 'HEADER_PICS_SORT_NO' => $header_pics_sort_no, 'L_PICS_HEADER_CAT_ID' => $lang['Pics_header_cat_id'], 'L_PICS_HEADER_CAT_ID_EXPLAIN' => $lang['Pics_header_cat_id_explain'], 'L_HEADER_PICS_NUMBER' => $lang['Pics_header_number'], 'L_HEADER_PICS_NUMBER_EXPLAIN' => $lang['Pics_header_number_explain'], 'L_HEADER_PICS_ALL' => $lang['Pics_header_all'], 'L_HEADER_PICS_SORT' => $lang['Pics_header_sort'], 'L_DISABLED' => $lang['Disabled'], 'L_ENABLED' => $lang['Enabled'], 'L_YES' => $lang['Yes'], 'L_NO' => $lang['No'], 'L_SUBMIT' => $lang['Submit'], 'L_RESET' => $lang['Reset']) ); $template->pparse("body"); include('./page_footer_admin.'.$phpEx); ?>[/code] [b]admin_header_block_body.tpl[/b] [code]

{L_ALBUM_HEADER_BLOCK_CONFIG}

{L_ALBUM_HEADER_BLOCK_CONFIG_EXPLAIN}

{L_ALBUM_HEADER_BLOCK_CONFIG}
{L_PICS_HEADER_CAT_ID}
{L_PICS_HEADER_CAT_ID_EXPLAIN}
{L_HEADER_PICS_NUMBER}
{L_HEADER_PICS_NUMBER_EXPLAIN}
{L_HEADER_PICS_ALL} {L_YES}   {L_NO}
{L_HEADER_PICS_SORT} {L_YES}   {L_NO}
{S_HIDDEN_FIELDS}   

[/code]