PHP full_page_generation函数代码示例

            }
            $template->assign_block_vars('shouts', array('ID' => $id, 'SHOUTER' => $shouter_html, 'MESSAGE' => $message, 'DELETE_IMG' => $delpost_img, 'DATE' => $time));
        }
        // Gets the chat_rooms for display
        $archive_link = '?mode=archive';
        if ($user->data['user_level'] == ADMIN) {
            $template->assign_block_vars('rooms', array('NAME' => $lang['Admin_rooms'], 'LIST' => '', 'STYLED_LIST' => '', 'CLASS' => !empty($chat_room_all) ? ' class="active"' : '', 'LINK' => append_sid('ajax_chat.' . PHP_EXT . $archive_link . '&admin=1&all_rooms=1')));
            $admin_mode = request_var('admin', '');
            if (!empty($admin_mode)) {
                $admin_mode = true;
                $archive_link .= '&admin=1';
            } else {
                $admin_mode = false;
            }
        }
        $room_filter = $admin_mode == true ? "shout_room != ''" : "shout_room LIKE '%|" . $user->data['user_id'] . "|%'";
        $sql = "SELECT DISTINCT shout_room\n\t\t\t\tFROM " . AJAX_SHOUTBOX_TABLE . "\n\t\t\t\tWHERE " . $room_filter . "\n\t\t\t\tORDER BY shout_id DESC";
        $results = $db->sql_query($sql);
        $rooms = $db->sql_fetchrowset($results);
        $room_users = get_chat_room_users($rooms, $chat_room, $archive_link);
        $chatroom_title = $room_users['title'];
        $chatroom_userlist = $room_users['userlist'];
        $rooms = $room_users['rooms'];
        foreach ($rooms as $room) {
            $template->assign_block_vars('rooms', $room);
        }
    }
    $template->assign_vars(array('L_SHOUTBOX_EMPTY' => $lang['Shoutbox_empty'], 'L_SHOUT_ROOMS' => $lang['Shout_rooms'], 'L_SHOUT_ROOM_TITLE' => $chatroom_title, 'L_SHOUT_ROOM_LIST' => $chatroom_userlist));
}
full_page_generation($template_to_parse, $template_to_parse == 'ajax_chat_body.tpl' ? $lang['Ajax_Chat'] : $lang['Ajax_Archive'], '', '');

					AND p.user_id = " . $user_id . "
				ORDER BY p.view_stamp DESC
				LIMIT " . $start . ", " . $config['posts_per_page'];
$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))
{
	$viewer = $row['viewer_id'];
	$viewer_avatar = user_get_avatar($row['viewer_id'], $row['user_level'], $row['user_avatar'], $row['user_avatar_type'], $row['user_allowavatar']);
	$template->assign_block_vars('row', array(
		'AVATAR' => $viewer_avatar,
		'VIEW_BY' => colorize_username($viewer, $row['username'], $row['user_color'], $row['user_active']),
		'NUMBER' => $row['counter'],
		'STAMP' => create_date_ip($user->data['user_dateformat'], $row['view_stamp'], $user->data['user_timezone'])
		)
	);
}

$template->assign_vars(array(
	'PAGINATION' => generate_pagination('profile_view_user.' . PHP_EXT . '?' . POST_USERS_URL . '=' . $user_id, $total, $config['posts_per_page'], $start),
	'PROFILE' => '<a href="' . append_sid(CMS_PAGE_PROFILE . '?mode=viewprofile&amp;' . POST_USERS_URL . '=' . $user_id) . '" class="nav-current">' . $profile['username'] . '</a>',
	'L_VIEW_TITLE' => $meta_content['page_title'],
	'L_VIEWER' => $lang['Username'],
	'L_NUMBER' => $lang['Views'],
	'L_STAMP' => $lang['Last_updated']
	)
);

full_page_generation('profile_view_user_body.tpl', $lang['Profile'] . ' - ' . $lang['Views'], '', '');

?>

			'U_AIM' => $aim_url,
			'U_ICQ' => $icq_url,
			'U_MSN' => $msn_url,
			'U_SKYPE' => $skype_url,
			'U_YIM' => $yahoo_url,
			'L_POSTER_ONLINE_STATUS' => $online_status_lang,
			'POSTER_ONLINE_STATUS_CLASS' => $online_status_class,
			'U_POSTER_ONLINE_STATUS' => $online_status_url,
			)
		);
		$k++;
	}
}

$template->assign_vars(array(
	'L_USERNAME' => $lang['Username'],
	'L_FORUMS' => $lang['Staff_forums'],
	'L_STATS' => $lang['Staff_stats'],
	'L_POSTS' => $lang['Posts'],
	'L_TOPICS' => $lang['Topics'],
	'L_LAST_POST' => $lang['Last_Post'],
	'L_JOINED' => $lang['Joined'],
	'L_CONTACT' => $lang['Staff_contact'],
	'L_MESSENGER' => $lang['Staff_messenger'],
	'L_WWW' => $lang['Website'],
	)
);

full_page_generation('staff_body.tpl', $lang['Staff'], '', '');

?>

*/

/**
*
* @Icy Phoenix is based on phpBB
* @copyright (c) 2008 phpBB Group
*
*/

define('IN_ICYPHOENIX', true);
if (!defined('IP_ROOT_PATH')) define('IP_ROOT_PATH', './');
if (!defined('PHP_EXT')) define('PHP_EXT', substr(strrchr(__FILE__, '.'), 1));
include(IP_ROOT_PATH . 'common.' . PHP_EXT);

// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();
// End session management

$cms_page['page_id'] = 'privacy_policy';
$cms_page['page_nav'] = (!empty($cms_config_layouts[$cms_page['page_id']]['page_nav']) ? true : false);
$cms_page['global_blocks'] = (!empty($cms_config_layouts[$cms_page['page_id']]['global_blocks']) ? true : false);
$cms_auth_level = (isset($cms_config_layouts[$cms_page['page_id']]['view']) ? $cms_config_layouts[$cms_page['page_id']]['view'] : AUTH_ALL);
check_page_auth($cms_page['page_id'], $cms_auth_level);

setup_extra_lang(array('lang_policies'));

full_page_generation('privacy_policy_body.tpl', $lang['PRIVACY_POLICY_TITLE'], '', '');

?>

    if (CanRate($pic_id, $user->data['user_id'])) {
        $template->assign_block_vars('hon_rating', array());
        for ($i = 0; $i < $album_config['rate_scale']; $i++) {
            $template->assign_block_vars('hon_rating.hon_row', array('VALUE' => $i + 1));
        }
    } else {
        $template->assign_block_vars('hon_rating_cant', array());
    }
    $template->assign_vars(array('L_PLEASE_RATE_IT' => $lang['Please_Rate_It'], 'L_ALREADY_RATED' => $lang['Already_rated'], 'L_PIC_ID' => $lang['Pic_ID'], 'L_RATING' => $lang['Rating'], 'L_PIC_TITLE' => $lang['Pic_Title'] . $album_config['clown_rateType'], 'L_PIC_DESC' => $lang['Pic_Desc'], 'L_POSTER' => $lang['Pic_Poster'], 'L_POSTED' => $lang['Posted'], 'L_VIEW' => $lang['View'], 'L_COMMENTS' => $lang['Comments'], 'CAT_TITLE' => $thiscat['cat_title'], 'U_VIEW_CAT' => append_sid(album_append_uid('album_cat.' . PHP_EXT . '?cat_id=' . $cat_id)), 'U_PIC' => append_sid(album_append_uid('album_pic.' . PHP_EXT . '?pic_id=' . $pic_id)), 'U_COMMENT' => append_sid(album_append_uid('album_showpage.' . PHP_EXT . '?pic_id=' . $pic_id)), 'S_ACTION' => append_sid(album_append_uid('album_hotornot.' . PHP_EXT)), 'PIC_TITLE' => $thispic['pic_title'], 'PIC_DESC' => nl2br($thispic['pic_desc']), 'POSTER' => $poster, 'PIC_TIME' => create_date($config['default_dateformat'], $thispic['pic_time'], $config['board_timezone']), 'PIC_VIEW' => $thispic['pic_view_count'], 'PIC_RATING' => $image_rating, 'PIC_COMMENTS' => $thispic['comments'], 'PIC_ID' => $pic_id, 'PICTURE_ID' => $pic_id));
    if ($album_config['rate']) {
        $template->assign_block_vars('rate_switch', array());
    }
    if ($album_config['comment']) {
        $template->assign_block_vars('comment_switch', array());
    }
    full_page_generation('album_hon.tpl', $lang['Album'], '', '');
} else {
    if (!$user->data['session_logged_in']) {
        message_die(GENERAL_MESSAGE, $lang['Not_Auth_View']);
    }
    $rate_user_id = $user->data['user_id'];
    $rate_user_ip = $user->data['session_ip'];
    $pic_id = request_var('pic_id', 0);
    if ($pic_id <= 0) {
        message_die(GENERAL_ERROR, 'Wrong Pic ID');
    }
    if ($album_config['hon_rate_sep'] == true) {
        $rating_field = 'rate_hon_point';
    } else {
        $rating_field = 'rate_point';
    }

	'L_ONLINE_STATUS' => $lang['Online_status'],
	'L_USER_WWW' => $lang['Website'],
	'L_USER_EMAIL' => $lang['Send_Email'],
	'L_USER_PROFILE' => $lang['Profile'],

	'L_VIEWS_COUNT' => $lang['Topic_count'],
	'L_LAST_VIEWED' => !empty($like) ? $lang['LIKE_TIME'] : $lang['Topic_time'],
	'L_FROM' => $lang['Location'],
	'L_JOINED' => $lang['Joined'],

	'S_POSTS_LIKES' => !empty($like) ? true : false,
	'S_MODE_SELECT' => $select_sort_mode,
	'S_ORDER_SELECT' => $select_sort_order,
	'S_MODE_ACTION' => append_sid($base_url),

	'CLOSE_WINDOW' => $lang['Close_window'],

	'PAGINATION' => $pagination,
	'PAGE_NUMBER' => sprintf($lang['Page_of'], (floor($start / $config['topics_per_page']) + 1), ceil($total_members / $config['topics_per_page'])),
	'L_GOTO_PAGE' => $lang['Goto_page']
	)
);

if (!empty($like))
{
	$gen_simple_header = true;
	$template->assign_var('S_POPUP', true);
}
full_page_generation('whoviewed_body.tpl', $page_title, '', '');

?>

            $template->assign_vars(array('L_NO_LOGINS' => $lang['No_logins']));
            $template->assign_block_vars('switch_display_ips.switch_no_logins', array());
        }
        $template->assign_vars(array('L_USERNAME' => $lang['Username'], 'L_LOGINS' => $lang['Logins'], 'L_IP' => $lang['IP'], 'L_BROWSER' => $lang['Browser'], 'L_TIME' => $lang['Time']));
    }
}
// End Advanced IP Tools Pack MOD
//Start Quick Administrator User Options and Information MOD
if ($user->data['user_level'] == ADMIN) {
    $template->assign_block_vars('switch_user_admin', array());
}
$sql = "SELECT * FROM " . BANLIST_TABLE . " WHERE ban_userid = " . $profiledata['user_id'] . " OR ban_email = '" . $db->sql_escape($profiledata['user_email']) . "'";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
    $banned_username = $row['ban_userid'];
    $banned_email = $row['ban_email'];
}
$db->sql_freeresult($result);
$template->assign_vars(array('L_QUICK_ADMIN_OPTIONS' => $lang['Quick_admin_options'], 'L_ADMIN_EDIT_PROFILE' => $lang['Admin_edit_profile'], 'L_ADMIN_EDIT_PERMISSIONS' => $lang['Admin_edit_permissions'], 'L_USER_ACTIVE_INACTIVE' => $profiledata['user_active'] == 1 ? $lang['User_active'] : $lang['User_not_active'], 'L_BANNED_USERNAME' => $banned_username == '' ? $lang['Username_not_banned'] : $lang['Username_banned'], 'L_BANNED_EMAIL' => $banned_email == '' ? $lang['User_email_not_banned'] : htmlspecialchars(sprintf($lang['User_email_banned'], $profiledata['user_email'])), 'L_USER_BAN_UNBAN' => $banned_username == '' ? $lang['USER_BAN'] : $lang['USER_UNBAN'], 'U_USER_BAN_UNBAN' => IP_ROOT_PATH . 'card.' . PHP_EXT . '?mode=' . ($banned_username == '' ? 'ban' : 'unban') . '&' . POST_USERS_URL . '=' . $profiledata['user_id'] . '&sid=' . $user->data['session_id'], 'U_ADMIN_EDIT_PROFILE' => ADM . '/admin_users.' . PHP_EXT . '?sid=' . $user->data['session_id'] . '&' . POST_USERS_URL . '=' . $profiledata['user_id'] . '&mode=edit&redirect=yes', 'U_ADMIN_EDIT_PERMISSIONS' => ADM . '/admin_ug_auth.' . PHP_EXT . '?sid=' . $user->data['session_id'] . '&' . POST_USERS_URL . '=' . $profiledata['user_id'] . '&mode=user'));
//End Quick Administrator User Options and Information MOD
include IP_ROOT_PATH . 'includes/bb_usage_stats.' . PHP_EXT;
// We need to keep this here... to make sure also $view_bb_usage_allowed is assigned
$extra_stats_auth = !empty($view_bb_usage_allowed) || !empty($ip_display_auth) ? true : false;
$template->assign_vars(array('L_EXTRA_STATS' => !empty($show_extra_stats) ? $lang['EXTRA_STATS_HIDE'] : $lang['EXTRA_STATS_SHOW'], 'U_EXTRA_STATS' => append_sid(IP_ROOT_PATH . CMS_PAGE_PROFILE . '?mode=viewprofile&' . POST_USERS_URL . '=' . $profiledata['user_id'] . (!empty($show_extra_stats) ? '' : '&stats=1')), 'S_EXTRA_STATS_AUTH' => !empty($extra_stats_auth) ? true : false, 'S_EXTRA_STATS' => !empty($show_extra_stats) ? true : false));
// MG Cash MOD For IP - BEGIN
if (!empty($config['plugins']['cash']['enabled'])) {
    $cm_viewprofile->post_vars($template, $profiledata, $user->data);
}
// MG Cash MOD For IP - END
full_page_generation('profile_view_body.tpl', htmlspecialchars($profiledata['username']), '', '');

include IP_ROOT_PATH . 'common.' . PHP_EXT;
// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();
// End session management
include IP_ROOT_PATH . 'includes/functions_credits.' . PHP_EXT;
$mode = request_var('mode', '', true);
/*
* Parse for modes...
*/
setup_hacks_list_array();
scan_hl_files();
switch ($mode) {
    default:
        $sql = 'SELECT * FROM ' . HACKS_LIST_TABLE . "\n\t\t\t\tWHERE hack_hide = 'No'\n\t\t\t\tORDER BY hack_name ASC";
        $result = $db->sql_query($sql, 0, 'credits_');
        $row_class = '';
        $i = 0;
        while ($row = $db->sql_fetchrow($result)) {
            $row_class = ip_zebra_rows($row_class);
            $template->assign_block_vars('listrow', array('ROW_CLASS' => $row_class, 'HACK_ID' => $row['hack_id'], 'HACK_AUTHOR' => $row['hack_author_email'] != '' ? USE_CRYPTIC_EMAIL ? $row['hack_author'] . '<br />' . cryptize_hl_email($row['hack_author_email']) : '<a href="mailto:' . $row['hack_author_email'] . '">' . $row['hack_author'] . '</a>' : $row['hack_author'], 'HACK_WEBSITE' => $row['hack_author_website'] != '' ? '<a target="blank" href="' . $row['hack_author_website'] . '">' . $row['hack_author_website'] . '</a>' : $lang['No_Website'], 'HACK_NAME' => $row['hack_download_url'] != '' ? '<a target="blank" href="' . $row['hack_download_url'] . '">' . $row['hack_name'] . '</a>' : $row['hack_name'], 'HACK_DESC' => $row['hack_desc'], 'HACK_VERSION' => $row['hack_version'] != '' ? $row['hack_version'] : ''));
        }
        if (empty($i)) {
            $template->assign_block_vars('empty_switch', array());
            $template->assign_var('L_NO_HACKS', $lang['No_Hacks']);
        }
}
$template->assign_vars(array('L_PAGE_NAME' => $meta_content['page_title'], 'S_MODE_ACTION' => append_sid(basename(__FILE__)), 'L_VERSION' => $lang['Version'], 'L_AUTHOR' => $lang['Author'], 'L_DESCRIPTION' => $lang['Description'], 'L_HACK_NAME' => $lang['Hack_Name'], 'L_WEBSITE' => $lang['Website']));
full_page_generation('credits_display.tpl', $lang['Hacks_List'], '', '');

			'L_STATUS' => $lang['Login_Status'],
			'L_HIDDEN' => $lang['Login_Hidden'],
			'L_VISIBLE' => $lang['Login_Visible'],
			'L_DEFAULT' => $lang['Login_Default'],

			'U_SEND_PASSWORD' => append_sid(CMS_PAGE_PROFILE . '?mode=sendpassword'),
			'U_RESEND_ACTIVATION_EMAIL' => append_sid(CMS_PAGE_PROFILE . '?mode=resend'),

			'S_HIDDEN_FIELDS' => $s_hidden_fields
			)
		);

		if (!isset($_GET['admin']) && ($config['require_activation'] == USER_ACTIVATION_SELF))
		{
			$template->assign_var('S_SWITCH_RESEND_ACTIVATION_EMAIL', true);
		}

		if (!isset($_GET['admin']))
		{
			$template->assign_block_vars('switch_login_type', array());
		}

		full_page_generation('login_body.tpl', $lang['Login'], '', '');
	}
	else
	{
		redirect(append_sid(CMS_PAGE_FORUM, true));
	}
}

?>

* @copyright (c) 2008 Icy Phoenix
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

define('IN_ICYPHOENIX', true);
if (!defined('IP_ROOT_PATH')) define('IP_ROOT_PATH', './');
if (!defined('PHP_EXT')) define('PHP_EXT', substr(strrchr(__FILE__, '.'), 1));
include(IP_ROOT_PATH . 'common.' . PHP_EXT);
include_once(IP_ROOT_PATH . 'includes/functions_groups.' . PHP_EXT);

// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();
// End session management

if (!$user->data['session_logged_in'])
{
	redirect(append_sid(CMS_PAGE_LOGIN . '?redirect=profile_main.' . PHP_EXT, true));
	exit;
}

//Start Output of Page
$link_name = '';
$nav_server_url = create_server_url();
$breadcrumbs['address'] = $lang['Nav_Separator'] . '<a href="' . $nav_server_url . append_sid(CMS_PAGE_PROFILE_MAIN) . '"' . (!empty($link_name) ? '' : ' class="nav-current"') . '>' . $lang['Profile'] . '</a>' . (!empty($link_name) ? ($lang['Nav_Separator'] . '<a class="nav-current" href="#">' . $link_name . '</a>') : '');

full_page_generation('profile_main_body.tpl', $lang['Profile'], '', '');

?>

<?php

/**
*
* @package Icy Phoenix
* @version $Id$
* @copyright (c) 2008 Icy Phoenix
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/
define('IN_ICYPHOENIX', true);
if (!defined('IP_ROOT_PATH')) {
    define('IP_ROOT_PATH', './');
}
if (!defined('PHP_EXT')) {
    define('PHP_EXT', substr(strrchr(__FILE__, '.'), 1));
}
include IP_ROOT_PATH . 'common.' . PHP_EXT;
// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();
// End session management
$gen_simple_header = true;
full_page_generation('bbcb_mg_colorpicker.tpl', $lang['bbcb_mg_colorpicker'], '', '');

            $sql_d = "SELECT f.*\n\t\t\t\tFROM " . FORUMS_TABLE . " f\n\t\t\t\tWHERE f.forum_id = '" . $draft_row[$i]['forum_id'] . "'\n\t\t\t\tLIMIT 1";
            $result_d = $db->sql_query($sql_d);
            $draft_row_data = $db->sql_fetchrow($result_d);
            $db->sql_freeresult($result_d);
            $draft_image = '<img src="' . $images['topic_nor_unread'] . '" alt="" />';
            $draft_type = $lang['Drafts_NT'];
            $draft_load = 'loadn';
            $draft_cat_link = append_sid(IP_ROOT_PATH . CMS_PAGE_VIEWFORUM . '?' . POST_FORUM_URL . '=' . $draft_row_data['forum_id']);
            $draft_title_link = append_sid(IP_ROOT_PATH . 'drafts.' . PHP_EXT . '?mode=' . $draft_load . '&amp;d=' . $draft_row[$i]['draft_id']);
            $draft_row[$i]['draft_cat'] = '<a href="' . $draft_cat_link . '">' . $draft_row_data['forum_name'] . '</a>';
            $draft_row[$i]['draft_title'] = '<a href="' . $draft_title_link . '">' . $draft_row[$i]['draft_subject'] . '</a>';
        } else {
            $draft_image = '<img src="' . $images['topic_nor_read'] . '" alt="" />';
            $draft_type = $lang['Drafts_NPM'];
            $draft_load = 'loadp';
            $draft_cat_link = append_sid(IP_ROOT_PATH . CMS_PAGE_PRIVMSG);
            $draft_title_link = append_sid(IP_ROOT_PATH . 'drafts.' . PHP_EXT . '?mode=' . $draft_load . '&amp;d=' . $draft_row[$i]['draft_id']);
            $draft_subject = $draft_row[$i]['draft_subject'] ? $draft_row[$i]['draft_subject'] : '...';
            // Missing subject produces an empty link
            $draft_row[$i]['draft_cat'] = '<a href="' . $draft_cat_link . '">' . $lang['Drafts_NPM'] . '</a>';
            $draft_row[$i]['draft_title'] = '<a href="' . $draft_title_link . '">' . $draft_subject . '</a>';
        }
        $row_class = ip_zebra_rows($row_class);
        $template->assign_block_vars('draft_row', array('ROW_CLASS' => $row_class, 'S_DRAFT_ID' => $draft_row[$i]['draft_id'], 'DRAFT_IMG' => $draft_image, 'DRAFT_TYPE' => $draft_type, 'DRAFT_CAT_LINK' => $draft_cat_link, 'DRAFT_CAT' => $draft_row[$i]['draft_cat'], 'DRAFT_TITLE_LINK' => $draft_title_link, 'DRAFT_TITLE' => $draft_row[$i]['draft_title'], 'DRAFT_TIME' => create_date_ip($config['default_dateformat'], $draft_row[$i]['save_time'], $config['board_timezone']), 'U_DRAFT_LOAD' => append_sid(IP_ROOT_PATH . 'drafts.' . PHP_EXT . '?mode=' . $draft_load . '&amp;d=' . $draft_row[$i]['draft_id']), 'U_DRAFT_DELETE' => append_sid(IP_ROOT_PATH . 'drafts.' . PHP_EXT . '?mode=delete&amp;d=' . $draft_row[$i]['draft_id'])));
    }
    $template->assign_vars(array('PAGINATION' => generate_pagination('drafts.' . PHP_EXT . '?mode=list', $drafts_count, $config['topics_per_page'], $start), 'PAGE_NUMBER' => sprintf($lang['Page_of'], floor($start / $config['topics_per_page']) + 1, ceil($drafts_count / $config['topics_per_page'])), 'L_GOTO_PAGE' => $lang['Goto_page']));
} else {
    $template->assign_block_vars('switch_no_drafts', array());
}
full_page_generation('drafts_body.tpl', $lang['Drafts'], '', '');

        $order_by = "pics {$sort_order} LIMIT {$start}, " . $config['topics_per_page'];
        break;
    case 'last_pic':
        $order_by = "last_pic {$sort_order} LIMIT {$start}, " . $config['topics_per_page'];
        break;
    default:
        $order_by = "user_regdate {$sort_order} LIMIT {$start}, " . $config['topics_per_page'];
        break;
}
$sql = "SELECT u.username, u.user_id, u.user_active, u.user_color, u.user_regdate, COUNT(p.pic_id) AS pics, MAX(p.pic_id) AS last_pic, COUNT(c.cat_user_id) AS cats\n\t\tFROM " . USERS_TABLE . " AS u, " . ALBUM_TABLE . " AS p, " . ALBUM_CAT_TABLE . " AS c\n\t\tWHERE u.user_id <> " . ANONYMOUS . "\n\t\t\tAND c.cat_user_id = u.user_id\n\t\t\tAND c.cat_id = p.pic_cat_id\n\t\tGROUP BY user_id\n\t\tORDER BY {$order_by}";
$result = $db->sql_query($sql);
$memberrow = array();
while ($row = $db->sql_fetchrow($result)) {
    $memberrow[] = $row;
}
$row_class = '';
for ($i = 0; $i < sizeof($memberrow); $i++) {
    $username = colorize_username($memberrow[$i]['user_id'], $memberrow[$i]['username'], $memberrow[$i]['user_color'], $memberrow[$i]['user_active'], true, false, false, false);
    $row_class = ip_zebra_rows($row_class);
    $template->assign_block_vars('memberrow', array('ROW_CLASS' => $row_class, 'USERNAME' => $username, 'U_VIEWGALLERY' => append_sid(album_append_uid('album.' . PHP_EXT . '?user_id=' . $memberrow[$i]['user_id'])), 'JOINED' => create_date($lang['DATE_FORMAT'], $memberrow[$i]['user_regdate'], $config['board_timezone']), 'PICS' => $memberrow[$i]['pics']));
}
$sql = "SELECT COUNT(DISTINCT u.user_id) AS total\n\t\tFROM " . USERS_TABLE . " AS u, " . ALBUM_TABLE . " AS p, " . ALBUM_CAT_TABLE . " AS c\n\t\tWHERE u.user_id <> " . ANONYMOUS . "\n\t\t\tAND c.cat_user_id = u.user_id\n\t\t\tAND c.cat_id = p.pic_cat_id";
$result = $db->sql_query($sql);
$pagination = '&nbsp;';
if ($total = $db->sql_fetchrow($result)) {
    $total_galleries = $total['total'];
    $pagination = generate_pagination('album_personal_index.' . PHP_EXT . '?mode=' . $mode . '&amp;order=' . $sort_order, $total_galleries, $config['topics_per_page'], $start);
}
$template->assign_vars(array('PAGINATION' => $pagination, 'PAGE_NUMBER' => sprintf($lang['Page_of'], floor($start / $config['topics_per_page']) + 1, ceil($total_galleries / $config['topics_per_page']))));
full_page_generation('album_personal_index_body.tpl', $lang['Album'], '', '');

    $cms_page['global_blocks'] = $layout_row['global_blocks'] == 0 ? false : true;
    $cms_page['page_nav'] = $layout_row['page_nav'] == 0 ? false : true;
}
if (!$cms_default_page) {
    $meta_content['page_title'] = !empty($layout_name) ? $layout_name : $config['sitename'];
    $breadcrumbs['address'] = $lang['Nav_Separator'] . '<a class="nav-current" href="#">' . $meta_content['page_title'] . '</a>';
}
// Let's remove $auth->acl_get('a_') until I finish coding permissions properly... and also add/remove 'a_' when users are added/removed from administrators in ACP
//$is_admin = (($user->data['user_level'] == ADMIN) || $auth->acl_get('a_')) ? true : false;
$is_admin = $user->data['user_level'] == ADMIN ? true : false;
$cms_acp_url = '';
if ($is_admin || $auth->acl_get('cms_admin') || !empty($user->data['user_cms_auth']['cmsl_admin'][$layout])) {
    $cms_acp_url = '<br /><br /><div style="text-align: center;">';
    $cms_acp_url .= '<a href="' . append_sid('cms.' . PHP_EXT . '?mode=blocks&amp;l_id=' . $layout . (!empty($user->session_id) ? '&amp;sid=' . $user->session_id : '')) . '">' . $lang['CMS_ACP'] . '</a>';
    $cms_acp_url .= '</div>';
}
$layout_name_add = '';
$query = $_SERVER['QUERY_STRING'];
if (preg_match("/news=categories/", $query)) {
    $layout_name_add = $lang['LINK_NEWS_CAT'];
} elseif (preg_match("/news=archives/", $query)) {
    $layout_name_add = $lang['LINK_NEWS_ARC'];
}
if (!empty($layout_name_add)) {
    $layout_name = (empty($layout_name) ? '' : $layout_name . ' - ') . $layout_name_add;
}
$template->assign_vars(array('CMS_PAGE_TITLE' => !empty($layout_name) ? $layout_name : $config['sitename'], 'S_PAGE_NAV' => $cms_page['page_nav'], 'S_GLOBAL_BLOCKS' => $cms_page['global_blocks']));
// Start Blocks
$ip_cms->cms_parse_blocks($layout, false, false, '');
full_page_generation('layout/' . $layout_template, $meta_content['page_title'], $meta_content['description'], $meta_content['keywords']);

        update_user_color($user->data['user_id'], $config['active_users_color'], 0);
        update_user_posts_details($user->data['user_id'], '', '', false, false);
        */
        $redirect_url = append_sid(CMS_PAGE_FORUM);
        meta_refresh(3, $redirect_url);
        $message = $lang['Unsub_success'] . '<br /><br />' . sprintf($lang['Click_return_group'], '<a href="' . append_sid(CMS_PAGE_GROUP_CP . '?' . POST_GROUPS_URL . '=' . $group_id) . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid(CMS_PAGE_FORUM) . '">', '</a>');
        $db->clear_cache();
        message_die(GENERAL_MESSAGE, $message);
    } else {
        $unsub_msg = isset($_POST['unsub']) ? $lang['Confirm_unsub'] : $lang['Confirm_unsub_pending'];
        $s_hidden_fields = '<input type="hidden" name="' . POST_GROUPS_URL . '" value="' . $group_id . '" /><input type="hidden" name="unsub" value="1" />';
        $s_hidden_fields .= '<input type="hidden" name="sid" value="' . $user->data['session_id'] . '" />';
        $nav_server_url = create_server_url();
        $breadcrumbs['address'] = $lang['Nav_Separator'] . '<a href="' . $nav_server_url . append_sid(CMS_PAGE_GROUP_CP) . '" class="nav-current">' . $lang['Group_Control_Panel'] . '</a>';
        $template->assign_vars(array('MESSAGE_TITLE' => $lang['Confirm'], 'MESSAGE_TEXT' => $unsub_msg, 'L_YES' => $lang['Yes'], 'L_NO' => $lang['No'], 'S_CONFIRM_ACTION' => append_sid(CMS_PAGE_GROUP_CP), 'S_HIDDEN_FIELDS' => $s_hidden_fields));
        full_page_generation('confirm_body.tpl', $lang['Group_Control_Panel'], '', '');
    }
} elseif ($group_id) {
    // Did the group moderator get here through an email?
    // If so, check to see if they are logged in.
    if (isset($_GET['validate'])) {
        if (!$user->data['session_logged_in']) {
            redirect(append_sid(CMS_PAGE_LOGIN . '?redirect=groupcp.' . PHP_EXT . '&' . POST_GROUPS_URL . '=' . $group_id, true));
        }
    }
    // For security, get the ID of the group moderator.
    $sql = "SELECT g.group_moderator, g.group_type, g.group_rank, g.group_color, aa.auth_mod\n\t\tFROM (" . GROUPS_TABLE . " g\n\t\tLEFT JOIN " . AUTH_ACCESS_TABLE . " aa ON aa.group_id = g.group_id)\n\t\tWHERE g.group_id = '" . $group_id . "'\n\t\tORDER BY auth_mod DESC";
    $result = $db->sql_query($sql);
    if ($group_info = $db->sql_fetchrow($result)) {
        $group_moderator = $group_info['group_moderator'];
        $group_rank = $group_info['group_rank'];