function album_build_column_vars(&$result, $data, $page_params = '')
{
global $config, $user, $lang, $album_config;
$thumbnail_file = append_sid(album_append_uid('album_thumbnail.' . PHP_EXT . '?pic_id=' . $data['pic_id']));
// album_hierarchy_functions
if ($album_config['thumbnail_cache'] == true && $album_config['quick_thumbs'] == true) {
$thumbnail_file = picture_quick_thumb($data['pic_filename'], $data['pic_thumbnail'], $thumbnail_file);
}
$pic_sp_link = append_sid(album_append_uid('album_showpage.' . PHP_EXT . '?pic_id=' . $data['pic_id'] . $page_params));
$pic_dl_link = append_sid(album_append_uid('album_pic.' . PHP_EXT . '?pic_id=' . $data['pic_id']));
$result['U_PIC'] = $album_config['fullpic_popup'] ? $pic_dl_link : $pic_sp_link;
$result['U_PIC_SP'] = $pic_sp_link;
$result['U_PIC_DL'] = $pic_dl_link;
$result['THUMBNAIL'] = $thumbnail_file;
$result['PIC_TITLE'] = htmlspecialchars($data['pic_title']);
$result['DESC'] = htmlspecialchars($data['pic_desc']);
}
function cms_block_album()
{
global $db, $cache, $config, $template, $theme, $images, $user, $lang, $table_prefix, $block_id, $cms_config_vars, $cms_config_layouts, $cms_page, $album_config;
$cms_page_id_tmp = 'album';
$cms_auth_level_tmp = isset($cms_config_layouts[$cms_page_id_tmp]['view']) ? $cms_config_layouts[$cms_page_id_tmp]['view'] : AUTH_ALL;
$process_block = check_page_auth($cms_page_id_tmp, $cms_auth_level_tmp, true);
if (!$process_block) {
return;
}
if (!defined('IMG_THUMB')) {
define('IMG_THUMB', true);
}
$template->_tpldata['recent_pics.'] = array();
$template->_tpldata['recent_details.'] = array();
$template->_tpldata['no_pics'] = array();
/*
echo($cms_config_vars['md_pics_all'][$block_id] . '<br />');
echo($cms_config_vars[$block_id . '_' . 'md_pics_all']);
exit;
*/
include_once ALBUM_MOD_PATH . 'album_common.' . PHP_EXT;
global $album_config;
$sql = "SELECT c.*, COUNT(p.pic_id) AS count\n\t\t\t\tFROM " . ALBUM_CAT_TABLE . " AS c\n\t\t\t\t\tLEFT JOIN " . ALBUM_TABLE . " AS p ON c.cat_id = p.pic_cat_id\n\t\t\t\t" . ($cms_config_vars['md_pics_all'][$block_id] == '1' ? '' : 'WHERE cat_user_id = 0') . "\n\t\t\t\tGROUP BY cat_id\n\t\t\t\tORDER BY cat_order ASC";
$result = $db->sql_query($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;
}
}
$db->sql_freeresult($result);
if ($cms_config_vars['md_pics_all'][$block_id] == '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 < sizeof($catrows); $i++) {
// Build allowed category-list (for recent pics after here)
$allowed_cat .= $allowed_cat == '' ? $catrows[$i]['cat_id'] : ',' . $catrows[$i]['cat_id'];
// Get Last Pic of this Category
if ($catrows[$i]['count'] == 0) {
//
// Oh, this category is empty
//
$last_pic_info = $lang['No_Pics'];
$u_last_pic = '';
$last_pic_title = '';
} else {
// 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
}
}
}
if ($cms_config_vars['md_pics_all'][$block_id] == '1') {
$pics_allowed = '0';
} else {
$pics_allowed = '';
}
$no_pics = false;
if ($allowed_cat != $pics_allowed) {
$category_id = $cms_config_vars['md_cat_id'][$block_id];
if ($cms_config_vars['md_pics_sort'][$block_id] == '1') {
if ($category_id != 0) {
$sql = "SELECT p.*, u.user_id, u.username, u.user_active, u.user_color, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments\n\t\t\t\t\t\tFROM " . ALBUM_TABLE . " AS p\n\t\t\t\t\t\t\tLEFT JOIN " . USERS_TABLE . " AS u ON p.pic_user_id = u.user_id\n\t\t\t\t\t\t\tLEFT JOIN " . ALBUM_CAT_TABLE . " AS ct ON p.pic_cat_id = ct.cat_id\n\t\t\t\t\t\t\tLEFT JOIN " . ALBUM_RATE_TABLE . " AS r ON p.pic_id = r.rate_pic_id\n\t\t\t\t\t\t\tLEFT JOIN " . ALBUM_COMMENT_TABLE . " AS c ON p.pic_id = c.comment_pic_id\n\t\t\t\t\t\tWHERE p.pic_cat_id IN ({$allowed_cat}) AND (p.pic_approval = 1 OR ct.cat_approval = 0) AND pic_cat_id IN ({$category_id})\n\t\t\t\t\t\tGROUP BY p.pic_id\n\t\t\t\t\t\tORDER BY RAND()\n\t\t\t\t\t\tLIMIT " . $cms_config_vars['md_pics_number'][$block_id];
} else {
$sql = "SELECT p.*, u.user_id, u.username, u.user_active, u.user_color, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments\n\t\t\t\t\t\tFROM " . ALBUM_TABLE . " AS p\n\t\t\t\t\t\t\tLEFT JOIN " . USERS_TABLE . " AS u ON p.pic_user_id = u.user_id\n\t\t\t\t\t\t\tLEFT JOIN " . ALBUM_CAT_TABLE . " AS ct ON p.pic_cat_id = ct.cat_id\n\t\t\t\t\t\t\tLEFT JOIN " . ALBUM_RATE_TABLE . " AS r ON p.pic_id = r.rate_pic_id\n\t\t\t\t\t\t\tLEFT JOIN " . ALBUM_COMMENT_TABLE . " AS c ON p.pic_id = c.comment_pic_id\n\t\t\t\t\t\tWHERE p.pic_cat_id IN ({$allowed_cat}) AND (p.pic_approval = 1 OR ct.cat_approval = 0)\n\t\t\t\t\t\tGROUP BY p.pic_id\n\t\t\t\t\t\tORDER BY RAND()\n\t\t\t\t\t\tLIMIT " . $cms_config_vars['md_pics_number'][$block_id];
}
} elseif ($cms_config_vars['md_pics_sort'][$block_id] == '0') {
if ($category_id != 0) {
$sql = "SELECT p.*, u.user_id, u.username, u.user_active, u.user_color, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments\n\t\t\t\t\t\tFROM " . ALBUM_TABLE . " AS p\n\t\t\t\t\t\t\tLEFT JOIN " . USERS_TABLE . " AS u ON p.pic_user_id = u.user_id\n\t\t\t\t\t\t\tLEFT JOIN " . ALBUM_CAT_TABLE . " AS ct ON p.pic_cat_id = ct.cat_id\n\t\t\t\t\t\t\tLEFT JOIN " . ALBUM_RATE_TABLE . " AS r ON p.pic_id = r.rate_pic_id\n\t\t\t\t\t\t\tLEFT JOIN " . ALBUM_COMMENT_TABLE . " AS c ON p.pic_id = c.comment_pic_id\n\t\t\t\t\t\tWHERE p.pic_cat_id IN ({$allowed_cat}) AND (p.pic_approval = 1 OR ct.cat_approval = 0) AND pic_cat_id IN ({$category_id})\n\t\t\t\t\t\tGROUP BY p.pic_id\n\t\t\t\t\t\tORDER BY pic_time DESC\n\t\t\t\t\t\tLIMIT " . $cms_config_vars['md_pics_number'][$block_id];
} else {
$sql = "SELECT p.*, u.user_id, u.username, u.user_active, u.user_color, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments\n\t\t\t\t\t\tFROM " . ALBUM_TABLE . " AS p\n\t\t\t\t\t\t\tLEFT JOIN " . USERS_TABLE . " AS u ON p.pic_user_id = u.user_id\n\t\t\t\t\t\t\tLEFT JOIN " . ALBUM_CAT_TABLE . " AS ct ON p.pic_cat_id = ct.cat_id\n\t\t\t\t\t\t\tLEFT JOIN " . ALBUM_RATE_TABLE . " AS r ON p.pic_id = r.rate_pic_id\n\t\t\t\t\t\t\tLEFT JOIN " . ALBUM_COMMENT_TABLE . " AS c ON p.pic_id = c.comment_pic_id\n\t\t\t\t\t\tWHERE p.pic_cat_id IN ({$allowed_cat}) AND (p.pic_approval = 1 OR ct.cat_approval = 0)\n\t\t\t\t\t\tGROUP BY p.pic_id\n\t\t\t\t\t\tORDER BY pic_time DESC\n\t\t\t\t\t\tLIMIT " . $cms_config_vars['md_pics_number'][$block_id];
}
}
$result = $db->sql_query($sql);
$recentrow = array();
while ($row = $db->sql_fetchrow($result)) {
$recentrow[] = $row;
}
$db->sql_freeresult($result);
$total_pics = sizeof($recentrow);
if ($total_pics > 0) {
$total_rows = ceil($total_pics / $cms_config_vars['md_pics_rows_number'][$block_id]);
$total_cols = ceil($total_pics / $cms_config_vars['md_pics_cols_number'][$block_id]);
$image_counter = 0;
while ($image_counter < $total_pics) {
for ($i = 0; $i < $cms_config_vars['md_pics_rows_number'][$block_id]; $i++) {
$template->assign_block_vars('recent_pics', array());
for ($j = 0; $j < $cms_config_vars['md_pics_cols_number'][$block_id]; $j++) {
if ($image_counter >= $total_pics) {
$template->assign_block_vars('recent_pics.recent_no_detail', array());
} else {
if (!$recentrow[$image_counter]['rating']) {
$recentrow[$image_counter]['rating'] = $lang['Not_rated'];
} else {
$recentrow[$image_counter]['rating'] = round($recentrow[$image_counter]['rating'], 2);
}
if ($recentrow[$image_counter]['user_id'] == ALBUM_GUEST || $recentrow[$image_counter]['username'] == '') {
$recent_poster = $recentrow[$image_counter]['pic_username'] == '' ? $lang['Guest'] : $recentrow[$image_counter]['pic_username'];
} else {
$recent_poster = colorize_username($recentrow[$image_counter]['user_id'], $recentrow[$image_counter]['username'], $recentrow[$image_counter]['user_color'], $recentrow[$image_counter]['user_active']);
}
$thumbnail_file = append_sid(album_append_uid('album_thumbnail.' . PHP_EXT . '?pic_id=' . $recentrow[$image_counter]['pic_id']));
if ($album_config['thumbnail_cache'] == true && $album_config['quick_thumbs'] == true) {
$thumbnail_file = picture_quick_thumb($recentrow[$image_counter]['pic_filename'], $recentrow[$image_counter]['pic_thumbnail'], $thumbnail_file);
}
$pic_sp_link = append_sid(album_append_uid('album_showpage.' . PHP_EXT . '?pic_id=' . $recentrow[$image_counter]['pic_id']));
$pic_dl_link = append_sid(album_append_uid('album_pic.' . PHP_EXT . '?pic_id=' . $recentrow[$image_counter]['pic_id']));
$template->assign_block_vars('recent_pics.recent_detail', array('U_PIC' => $album_config['fullpic_popup'] ? $pic_dl_link : $pic_sp_link, 'U_PIC_SP' => $pic_sp_link, 'U_PIC_DL' => $pic_dl_link, 'IS_FIRST_PIC' => $image_counter == 0 ? true : false, 'THUMBNAIL' => $thumbnail_file, 'DESC' => $recentrow[$image_counter]['pic_desc'], 'TITLE' => $recentrow[$image_counter]['pic_title'], 'POSTER' => $recent_poster, 'TIME' => create_date_ip($config['default_dateformat'], $recentrow[$image_counter]['pic_time'], $config['board_timezone']), 'VIEW' => $recentrow[$image_counter]['pic_view_count'], 'RATING' => $album_config['rate'] == 1 ? $lang['Rating'] . ': ' . $recentrow[$image_counter]['rating'] . '<br />' : '', 'COMMENTS' => $album_config['comment'] == 1 ? $lang['Comments'] . ': ' . $recentrow[$image_counter]['comments'] . '<br />' : ''));
if ($image_counter == 0) {
$template->assign_vars(array('HS_GALLERY_ID' => 'hs_gallery_id_' . $recentrow[$image_counter]['pic_id'], 'HS_PIC_ID' => 'hs_pic_id_' . $recentrow[$image_counter]['pic_id'], 'HS_PIC_TITLE' => $recentrow[$image_counter]['pic_title'], 'HS_PIC_FULL' => $pic_dl_link, 'HS_PIC_THUMB' => $thumbnail_file));
}
}
$image_counter++;
}
}
}
} else {
// No Pics Found
$template->assign_block_vars('no_pics', array());
$no_pics = true;
}
} else {
// No Cats Found
$template->assign_block_vars('no_pics', array());
$no_pics = true;
}
$template->assign_vars(array('S_COL_WIDTH' => 100 / ($cms_config_vars['md_pics_cols_number'][$block_id] == 0 ? 4 : $cms_config_vars['md_pics_cols_number'][$block_id]) . '%', 'S_THUMBNAIL_SIZE' => $album_config['thumbnail_size'], 'TARGET_BLANK' => $album_config['fullpic_popup'] ? 'target="_blank"' : '', 'S_HIGHSLIDE' => !empty($config['thumbnail_highslide']) ? true : false, 'S_HIGHSLIDER' => !empty($cms_config_vars['md_pics_slider'][$block_id]) ? true : false, 'S_JQ_NIVO_SLIDER' => !empty($cms_config_vars['md_pics_slider'][$block_id]) ? true : false, 'S_SLIDER_ID' => 'cms_slider_' . $block_id, 'S_NO_PICS' => !empty($no_pics) ? true : false, 'L_NO_PICS' => $lang['No_Pics'], 'L_PIC_TITLE' => $lang['Pic_Title'], 'L_VIEW' => $lang['View'], 'L_POSTER' => $lang['Poster'], 'L_POSTED' => $lang['Posted'], 'U_ALBUM' => append_sid('album.' . PHP_EXT), 'L_ALBUM' => $lang['Album']));
}
$pic_width = $pic_size[0];
$pic_height = $pic_size[1];
$pic_filesize = @filesize($pic_fullpath);
// Mighty Gorgon - Pic Size - END
if ($album_config['show_exif'] == 1 && function_exists('exif_read_data')) {
//echo(function_exists(exif_read_data));
$xif = @exif_read_data($pic_fullpath, 0, true);
if (!empty($xif[IFD0]) || !empty($xif[EXIF])) {
$template->assign_block_vars('switch_exif_enabled', array());
include_once ALBUM_MOD_PATH . 'album_exif_info.' . PHP_EXT;
}
}
$server_url = create_server_url();
$thumbnail_file = append_sid(album_append_uid('album_thumbnail.' . PHP_EXT . '?pic_id=' . $pic_id));
if ($album_config['thumbnail_cache'] == true && $album_config['quick_thumbs'] == true) {
$thumbnail_file = picture_quick_thumb($thispic[$i]['pic_filename'], $thispic[$i]['pic_thumbnail'], $thumbnail_file);
}
$edit_link_content = $lang['Edit_pic'];
$delete_link_content = $lang['Delete_pic'];
$lock_link_content = $thispic['pic_lock'] == 0 ? $lang['Lock'] : $lang['Unlock'];
$move_link_content = $lang['Move'];
$copy_link_content = $lang['Copy'];
$style_used = explode('/', $template->files['body']);
$allowed_styles = array('floreal', 'icy_phoenix', 'mg_themes', 'pearl');
if (in_array($style_used[2], $allowed_styles) && !empty($template->xs_version)) {
$edit_link_content = '<img src="' . $images['icon_edit'] . '" alt="' . $lang['Edit_pic'] . '" title="' . $lang['Edit_pic'] . '" />';
$delete_link_content = '<img src="' . $images['topic_mod_delete'] . '" alt="' . $lang['Delete_pic'] . '" title="' . $lang['Delete_pic'] . '" />';
$lock_link_content = $thispic['pic_lock'] == 0 ? '<img src="' . $images['topic_mod_lock'] . '" alt="' . $lang['Lock'] . '" title="' . $lang['Lock'] . '" />' : '<img src="' . $images['topic_mod_unlock'] . '" alt="' . $lang['Unlock'] . '" title="' . $lang['Unlock'] . '" />';
$move_link_content = '<img src="' . $images['topic_mod_move'] . '" alt="' . $lang['Move'] . '" title="' . $lang['Move'] . '" />';
$copy_link_content = '<img src="' . $images['topic_mod_copy'] . '" alt="' . $lang['Copy'] . '" title="' . $lang['Copy'] . '" />';
}
