for ($i = 0; $i < ($totalpicrow < $limit_sql ? $totalpicrow : $limit_sql); $i += $cols_per_page) {
            $template->assign_block_vars('recent_pics_block.recent_pics', array());
            for ($j = $i; $j < $i + $cols_per_page; $j++) {
                if ($j >= $totalpicrow) {
                    break;
                }
                $pic_preview = '';
                $pic_preview_hs = '';
                if ($album_config['lb_preview']) {
                    $slideshow_cat = 'Profile';
                    $slideshow = !empty($slideshow_cat) ? ', { slideshowGroup: \'' . $slideshow_cat . '\' } ' : '';
                    $pic_preview_hs = ' class="highslide" onclick="return hs.expand(this' . $slideshow . ');"';
                    $pic_preview = 'onmouseover="showtrail(\'' . append_sid('album_picm.' . PHP_EXT . '?pic_id=' . $recentrow[$j]['pic_id']) . '\',\'' . addslashes($recentrow[$j]['pic_title']) . '\', ' . $album_config['midthumb_width'] . ', ' . $album_config['midthumb_height'] . ')" onmouseout="hidetrail()"';
                }
                $template_vars = array('PIC_PREVIEW_HS' => $pic_preview_hs, 'PIC_PREVIEW' => $pic_preview);
                album_build_column_vars($template_vars, $recentrow[$j]);
                $template->assign_block_vars('recent_pics_block.recent_pics.recent_col', $template_vars);
                $recent_poster = colorize_username($recentrow[$j]['user_id'], $recentrow[$j]['username'], $recentrow[$j]['user_color'], $recentrow[$j]['user_active']);
                $template_vars = array('POSTER' => $recent_poster, 'PIC_PREVIEW_HS' => $pic_preview_hs, 'PIC_PREVIEW' => $pic_preview, 'GROUP_NAME' => 'profile');
                album_build_detail_vars($template_vars, $recentrow[$j]);
                $template->assign_block_vars('recent_pics_block.recent_pics.recent_detail', $template_vars);
            }
        }
    } else {
        $album_img = '&nbsp;';
        $album = '';
    }
}
// Mighty Gorgon - Full Album Pack - END
$avatar_img = user_get_avatar($profiledata['user_id'], $profiledata['user_level'], $profiledata['user_avatar'], $profiledata['user_avatar_type'], $profiledata['user_allowavatar']);
// Mighty Gorgon - Multiple Ranks - BEGIN
function album_build_detail_vars(&$result, $data, $page_params = '', $auth_rights = false)
{
    global $config, $user, $lang, $album_config;
    album_build_column_vars($result, $data, $page_params);
    $rating = '';
    if ($album_config['rate'] == 1) {
        $image_rating = ImageRating($data['rating']);
        $image_rating_link_class = $image_rating == $lang['Not_rated'] ? '' : 'class="rated"';
        $rating = $lang['Rating'] . ' : <a href="' . append_sid(album_append_uid('album_showpage.' . PHP_EXT . '?pic_id=' . $data['pic_id'] . $page_params)) . '" ' . $image_rating_link_class . '>' . $image_rating . '</a>';
    }
    $comments = '';
    if ($album_config['comment'] == 1) {
        $image_comment = $data['comments'] == 0 ? $lang['Not_commented'] : $data['comments'];
        $image_comment_link_class = $image_comment == $lang['Not_commented'] ? '' : 'class="commented"';
        $comments = $lang['Comments'] . ' : <a href="' . append_sid(album_append_uid('album_showpage.' . PHP_EXT . '?pic_id=' . $data['pic_id'] . $page_params)) . '" ' . $image_comment_link_class . '>' . $image_comment . '</a>';
    }
    $result['PIC_ID'] = $data['pic_id'];
    $result['TITLE'] = '<a href = "' . append_sid(album_append_uid('album_showpage.' . PHP_EXT . '?pic_id=' . $data['pic_id'] . $page_params)) . '">' . htmlspecialchars($data['pic_title']) . '</a>';
    $result['TIME'] = create_date($config['default_dateformat'], $data['pic_time'], $config['board_timezone']);
    $result['VIEW'] = $data['pic_view_count'];
    $result['RATING'] = $rating;
    $result['COMMENTS'] = $comments;
    if (empty($auth_rights)) {
        $auth_rights = array('edit' => true, 'delete' => true, 'admin' => true);
    }
    $can_edit = ($user->data['user_level'] == ADMIN or $user->data['user_id'] == $data['pic_user_id']);
    $result['EDIT'] = $can_edit && $auth_rights['edit'] ? '<a href="' . append_sid(album_append_uid('album_edit.' . PHP_EXT . '?pic_id=' . $data['pic_id'])) . '">' . $lang['Edit_pic'] . '</a>' : '';
    $result['DELETE'] = $can_edit && $auth_rights['delete'] ? '<a href="' . append_sid(album_append_uid('album_delete.' . PHP_EXT . '?pic_id=' . $data['pic_id'])) . '">' . $lang['Delete_pic'] . '</a>' : '';
    $is_admin = $user->data['user_level'] == ADMIN;
    $result['LOCK'] = $is_admin && $auth_rights['admin'] ? '<a href="' . append_sid(album_append_uid('album_modcp.' . PHP_EXT . '?mode=lock&amp;pic_id=' . $data['pic_id'])) . '">' . $lang['Lock'] . '</a>' : '';
    $result['MOVE'] = $is_admin && $auth_rights['admin'] ? '<a href="' . append_sid(album_append_uid('album_modcp.' . PHP_EXT . '?mode=move&amp;pic_id=' . $data['pic_id'])) . '">' . $lang['Move'] . '</a>' : '';
    $result['COPY'] = $is_admin && $auth_rights['admin'] ? '<a href="' . append_sid(album_append_uid('album_modcp.' . PHP_EXT . '?mode=copy&amp;pic_id=' . $data['pic_id'])) . '">' . $lang['Copy'] . '</a>' : '';
    $result['IP'] = $is_admin ? $lang['IP_Address'] . ': <a href="http://whois.sc/' . htmlspecialchars(urlencode($data['pic_user_ip'])) . '" target="_blank">' . htmlspecialchars($data['pic_user_ip']) . '</a>' : '';
}
function album_build_random_pics($cats)
{
    global $db, $config, $template, $lang, $album_config;
    $limit_sql = $album_config['img_cols'] * $album_config['img_rows'];
    $cols_per_page = $album_config['img_cols'];
    if (!empty($cats)) {
        $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\tFROM " . ALBUM_TABLE . " AS p\n\t\t\t\t\tLEFT JOIN " . USERS_TABLE . " AS u ON p.pic_user_id = u.user_id\n\t\t\t\t\tLEFT JOIN " . ALBUM_CAT_TABLE . " AS ct ON p.pic_cat_id = ct.cat_id\n\t\t\t\t\tLEFT JOIN " . ALBUM_RATE_TABLE . " AS r ON p.pic_id = r.rate_pic_id\n\t\t\t\t\tLEFT JOIN " . ALBUM_COMMENT_TABLE . " AS c ON p.pic_id = c.comment_pic_id\n\t\t\t\tWHERE p.pic_cat_id IN ({$cats}) AND (p.pic_approval = 1 OR ct.cat_approval = 0)\n\t\t\t\tGROUP BY p.pic_id\n\t\t\t\tORDER BY RAND()\n\t\t\t\tLIMIT {$limit_sql}";
        $result = $db->sql_query($sql);
        $picrow = array();
        while ($row = $db->sql_fetchrow($result)) {
            $picrow[] = $row;
        }
        $db->sql_freeresult($result);
        $template->assign_block_vars('random_pics_block', array());
        if (sizeof($picrow) > 0) {
            for ($i = 0; $i < sizeof($picrow); $i += $cols_per_page) {
                $template->assign_block_vars('random_pics_block.rand_pics', array());
                for ($j = $i; $j < $i + $cols_per_page; $j++) {
                    if ($j >= sizeof($picrow)) {
                        break;
                    }
                    $pic_preview = '';
                    $pic_preview_hs = '';
                    if ($album_config['lb_preview']) {
                        $slideshow_cat = '';
                        $slideshow = !empty($slideshow_cat) ? ', { slideshowGroup: \'' . $slideshow_cat . '\' } ' : '';
                        $pic_preview_hs = ' class="highslide" onclick="return hs.expand(this' . $slideshow . ');"';
                        $pic_preview = 'onmouseover="showtrail(\'' . append_sid(album_append_uid('album_picm.' . PHP_EXT . '?pic_id=' . $picrow[$j]['pic_id'])) . '\',\'' . addslashes($picrow[$j]['pic_title']) . '\', ' . $album_config['midthumb_width'] . ', ' . $album_config['midthumb_height'] . ')" onmouseout="hidetrail()"';
                    }
                    $template_vars = array('PIC_PREVIEW_HS' => $pic_preview_hs, 'PIC_PREVIEW' => $pic_preview);
                    album_build_column_vars($template_vars, $picrow[$j]);
                    $template->assign_block_vars('random_pics_block.rand_pics.rand_col', $template_vars);
                    if ($picrow[$j]['user_id'] == ALBUM_GUEST || $picrow[$j]['username'] == '') {
                        $rand_poster = $picrow[$j]['pic_username'] == '' ? $lang['Guest'] : $picrow[$j]['pic_username'];
                    } else {
                        $rand_poster = colorize_username($picrow[$j]['user_id'], $picrow[$j]['username'], $picrow[$j]['user_color'], $picrow[$j]['user_active']);
                    }
                    $template_vars = array('POSTER' => $rand_poster, 'PIC_PREVIEW_HS' => $pic_preview_hs, 'PIC_PREVIEW' => $pic_preview, 'GROUP_NAME' => 'random');
                    album_build_detail_vars($template_vars, $picrow[$j]);
                    $template->assign_block_vars('random_pics_block.rand_pics.rand_detail', $template_vars);
                }
            }
        } else {
            // No Pics Found
            $template->assign_block_vars('random_pics_block.no_pics', array());
        }
    }
    if (empty($cats)) {
        // No Cats Found
        $template->assign_block_vars('random_pics_block', array());
        $template->assign_block_vars('random_pics_block.no_pics', array());
    }
}
 for ($i = 0; $i < sizeof($picrow); $i += $album_config['cols_per_page']) {
     $template->assign_block_vars('picrow', array());
     for ($j = $i; $j < $i + $album_config['cols_per_page']; $j++) {
         if ($j >= sizeof($picrow)) {
             break;
         }
         $pic_preview = '';
         $pic_preview_hs = '';
         if ($album_config['lb_preview']) {
             $slideshow_cat = '';
             $slideshow = !empty($slideshow_cat) ? ', { slideshowGroup: \'' . $slideshow_cat . '\' } ' : '';
             $pic_preview_hs = ' class="highslide" onclick="return hs.expand(this' . $slideshow . ');"';
             $pic_preview = 'onmouseover="showtrail(\'' . append_sid(album_append_uid('album_picm.' . PHP_EXT . '?pic_id=' . $picrow[$j]['pic_id'])) . '\',\'' . addslashes($picrow[$j]['pic_title']) . '\', ' . $album_config['midthumb_width'] . ', ' . $album_config['midthumb_height'] . ')" onmouseout="hidetrail()"';
         }
         $template_vars = array('PIC_PREVIEW_HS' => $pic_preview_hs, 'PIC_PREVIEW' => $pic_preview);
         album_build_column_vars($template_vars, $picrow[$j]);
         $template->assign_block_vars('picrow.piccol', $template_vars);
         // is a personal category that the picture belongs to AND
         // is it the main category in the personal gallery ?
         if ($picrow[$j]['cat_user_id'] != 0 && $picrow[$j]['cat_id'] == album_get_personal_root_id($picrow[$j]['cat_user_id'])) {
             $album_page_url = 'album.' . PHP_EXT;
         } else {
             $album_page_url = 'album_cat.' . PHP_EXT;
         }
         $image_cat_url = append_sid(album_append_uid($album_page_url . '?cat_id=' . $picrow[$j]['cat_id'] . '&amp;user_id=' . $picrow[$j]['cat_user_id']));
         $template_vars = array('PIC_PREVIEW_HS' => $pic_preview_hs, 'PIC_PREVIEW' => $pic_preview, 'CATEGORY' => $picrow[$j]['cat_title'], 'U_PIC_CAT' => $image_cat_url, 'GROUP_NAME' => 'memberlist');
         album_build_detail_vars($template_vars, $picrow[$j]);
         // $template_vars['TITLE'] = htmlspecialchars($picrow[$j]['pic_title']);
         $template->assign_block_vars('picrow.pic_detail', $template_vars);
     }
 }
 for ($i = 0; $i < sizeof($picrow); $i += $album_config['cols_per_page']) {
     $template->assign_block_vars('picrow', array());
     for ($j = $i; $j < $i + $album_config['cols_per_page']; $j++) {
         if ($j >= sizeof($picrow)) {
             break;
         }
         $pic_preview = '';
         $pic_preview_hs = '';
         if ($album_config['lb_preview']) {
             $slideshow_cat = '';
             $slideshow = !empty($slideshow_cat) ? ', { slideshowGroup: \'' . $slideshow_cat . '\' } ' : '';
             $pic_preview_hs = ' class="highslide" onclick="return hs.expand(this' . $slideshow . ');"';
             $pic_preview = 'onmouseover="showtrail(\'' . append_sid(album_append_uid('album_picm.' . PHP_EXT . '?pic_id=' . $picrow[$j]['pic_id'])) . '\',\'' . addslashes($picrow[$j]['pic_title']) . '\', ' . $album_config['midthumb_width'] . ', ' . $album_config['midthumb_height'] . ')" onmouseout="hidetrail()"';
         }
         $template_vars = array('PIC_PREVIEW_HS' => $pic_preview_hs, 'PIC_PREVIEW' => $pic_preview);
         album_build_column_vars($template_vars, $picrow[$j], '&amp;sort_order=' . $sort_order . '&amp;sort_method=' . $sort_method);
         $template->assign_block_vars('picrow.piccol', $template_vars);
         // is a personal category that the picture belongs to AND
         // is it the main category in the personal gallery ?
         if ($picrow[$j]['cat_user_id'] != 0 && $picrow[$j]['cat_id'] == album_get_personal_root_id($picrow[$j]['cat_user_id'])) {
             $album_page_url = 'album.' . PHP_EXT;
         } else {
             $album_page_url = 'album_cat.' . PHP_EXT;
         }
         $image_cat_url = append_sid(album_append_uid($album_page_url . '?cat_id=' . $picrow[$j]['cat_id'] . '&amp;user_id=' . $picrow[$j]['cat_user_id']));
         $template_vars = array('PIC_PREVIEW_HS' => $pic_preview_hs, 'PIC_PREVIEW' => $pic_preview, 'CATEGORY' => $picrow[$j]['cat_title'], 'U_PIC_CAT' => $image_cat_url, 'GROUP_NAME' => 'all');
         album_build_detail_vars($template_vars, $picrow[$j], '&amp;sort_order=' . $sort_order . '&amp;sort_method=' . $sort_method);
         $template->assign_block_vars('picrow.pic_detail', $template_vars);
     }
 }
 // --------------------------------