+define('MODULES_TABLE', $table_prefix . 'modules');

+define('ZEBRA_TABLE', $table_prefix.'zebra');

+ $sql_in = ($which_ary == 'user_id_ary') ? array_map('intval', $$which_ary) : preg_replace('#^[\s]*?(.*?)[\s]*?$#e', "\"'\" . \$db->sql_escape('\\1') . \"'\"", $$which_ary);

+ case 'mssql-odbc':

+class ucp_activate extends module

+class ucp_confirm extends module

+ function ucp_confirm($id, $mode)

+class ucp_main extends module

+ function ucp_main($id, $mode)

+ switch ($mode)

+ $sql = 'SELECT COUNT(p.post_id) AS num_posts

+ FROM ' . POSTS_TABLE . ' p, ' . FORUMS_TABLE . ' f

+ WHERE p.poster_id = ' . $user->data['user_id'] . "

+ $sql = 'SELECT f.forum_id, f.forum_name, COUNT(post_id) AS num_posts

+ FROM ' . POSTS_TABLE . ' p, ' . FORUMS_TABLE . ' f

+ WHERE p.poster_id = ' . $user->data['user_id'] . "

+ $sql = 'SELECT t.topic_id, t.topic_title, COUNT(p.post_id) AS num_posts

+ FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t, ' . FORUMS_TABLE . ' f

+ WHERE p.poster_id = ' . $user->data['user_id'] . "

+ $memberdays = max(1, round((time() - $user->data['user_regdate']) / 86400));

+ $posts_per_day = $user->data['user_posts'] / $memberdays;

+ $active_f_pct = ($active_f_count / $user->data['user_posts']) * 100;

+ $active_t_pct = ($active_t_count / $user->data['user_posts']) * 100;

+ 'KARMA' => $user->lang['KARMA'][$user->data['user_karma']],

+ 'POSTS' => ($user->data['user_posts']) ? $user->data['user_posts'] : 0,

+ 'KARMA_IMG' => '<img src="images/karma' . $user->data['user_karma'] . '.gif" alt="' . $user->lang['KARMA_LEVEL'] . ': ' . $user->lang['KARMA'][$user->data['user_karma']] . '" title="' . $user->lang['KARMA_LEVEL'] . ': ' . $user->lang['KARMA'][$user->data['user_karma']] . '" />',

+

+ 'U_SEARCH_USER' => ($auth->acl_get('u_search')) ? "search.$phpEx$SID&amp;search_author=" . urlencode($user->data['username']) . "&amp;show_results=posts" : '',

+ case 'subscribed':

+ $message = $user->lang['DRAFTS_DELETED'] . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], "<a href=\"ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode\">", '</a>');

+ meta_refresh(3, "ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode");

+ $message = $user->lang['DRAFT_UPDATED'] . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], "<a href=\"ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode\">", '</a>');

+ meta_refresh(3, "ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode");

+ 'U_VIEW_EDIT' => "ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode&amp;edit=" . $draft['draft_id'],

+ 'L_TITLE' => $user->lang['UCP_' . strtoupper($mode)],

+ 'S_DISPLAY_MARK_ALL' => ($mode == 'watched' || ($mode == 'drafts' && !isset($_GET['edit']))) ? true : false,

+ 'S_UCP_ACTION' => "ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode")

+ $this->display($user->lang['UCP_MAIN'], 'ucp_main_' . $mode . '.html');

+ }

+

+ function install()

+ {

+ }

+

+ function uninstall()

+ {

+ }

+

+ function module()

+ {

+ $details = array(

+ 'name' => 'UCP - Main',

+ 'description' => 'Front end for User Control Panel',

+ 'filename' => 'main',

+ 'version' => '1.0.0',

+ 'phpbbversion' => '2.2.0'

+ );

+ return $details;

+class ucp_prefs extends module

+ function ucp_prefs($id, $mode)

+ switch($mode)

+ meta_refresh(3, "ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode");

+ $message = $user->lang['PREFERENCES_UPDATED'] . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], "<a href=\"ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode\">", '</a>');

+ meta_refresh(3, "ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode");

+ $message = $user->lang['PREFERENCES_UPDATED'] . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], "<a href=\"ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode\">", '</a>');

+ meta_refresh(3, "ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode");

+ $message = $user->lang['PREFERENCES_UPDATED'] . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], "<a href=\"ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode\">", '</a>');

+ 'L_TITLE' => $user->lang['UCP_' . strtoupper($mode)],

+ 'S_DISPLAY_' . strtoupper($mode) => true,

+ 'S_UCP_ACTION' => "ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode")

+class ucp_profile extends module

+ function ucp_profile($id, $mode)

+ $preview = (!empty($_POST['preview'])) ? true : false;

+ $submit = (!empty($_POST['submit'])) ? true : false;

+ $delete = (!empty($_POST['delete'])) ? true : false;

+ switch ($mode)

+ meta_refresh(3, "ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode");

+ $message = $user->lang['PROFILE_UPDATED'] . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], "<a href=\"ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode\">", '</a>');

+ meta_refresh(3, "ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode");

+ $message = $user->lang['PROFILE_UPDATED'] . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], "<a href=\"ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode\">", '</a>');

+ $message = $user->lang['PROFILE_UPDATED'] . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], "<a href=\"ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode\">", '</a>');

+ meta_refresh(3, "ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode");

+ $message = $user->lang['PROFILE_UPDATED'] . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], "<a href=\"ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode\">", '</a>');

+ 'L_TITLE' => $user->lang['UCP_' . strtoupper($mode)],

+ 'S_DISPLAY_' . strtoupper($mode) => true,

+ 'S_UCP_ACTION' => "ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode")

+class ucp_register extends module

+ function ucp_register($id, $mode)

+class ucp_remind extends module

+ function ucp_remind($id, $mode)

+// -------------------------------------------------------------

+//

+// $Id$

+//

+// FILENAME : ucp_zebra.php

+// STARTED : Sun Sep 28, 2003

+// COPYRIGHT : © 2001, 2003 phpBB Group

+// WWW : http://www.phpbb.com/

+// LICENCE : GPL vs2.0 [ see /docs/COPYING ]

+//

+// -------------------------------------------------------------

+

+class ucp_zebra extends module

+ function ucp_zebra($id, $mode)

+ global $censors, $config, $db, $user, $auth, $SID, $template, $phpbb_root_path, $phpEx;

+

+ $submit = (!empty($_POST['submit'])) ? true : false;

+

+ if ($submit)

+ {

+ $var_ary = array(

+ 'usernames' => 0,

+ 'add' => '',

+ );

+

+ foreach ($var_ary as $var => $default)

+ {

+ $data[$var] = request_var($var, $default);

+ }

+

+ $var_ary = array(

+ 'add' => array('string', false)

+ );

+

+ $error = validate_data($data, $var_ary);

+ extract($data);

+ unset($data);

+

+ if ($add)

+ {

+ $add = explode("\n", $add);

+

+ // Do these name/s exist on a list already? If so, ignore ... we could be

+ // 'nice' and automatically handle names added to one list present on

+ // the other (by removing the existing one) ... but I have a feeling this

+ // may lead to complaints

+ $sql = 'SELECT z.*, u.username

+ FROM ' . ZEBRA_TABLE . ' z, ' . USERS_TABLE . ' u

+ WHERE z.user_id = ' . $user->data['user_id'] . "

+ AND u.user_id = z.zebra_id";

+ $result = $db->sql_query($sql);

+

+ $friends = $foes = array();

+ while ($row = $db->sql_fetchrow($result))

+ {

+ if ($row['friend'])

+ {

+ $friends[] = $row['username'];

+ }

+ else

+ {

+ $foes[] = $row['username'];

+ }

+ }

+ $db->sql_freeresult($result);

+

+ $add = array_diff($add, $friends, $foes, array($user->data['user_id']));

+ unset($friends);

+ unset($foes);

+

+ $add = implode(', ', preg_replace('#^[\s]*?(.*?)[\s]*?$#e', "\"'\" . \$db->sql_escape('\\1') . \"'\"", $add));

+

+ $sql = 'SELECT user_id, user_permissions, user_founder

+ FROM ' . USERS_TABLE . '

+ WHERE username IN (' . $add . ')';

+ $result = $db->sql_query($sql);

+

+ if ($row = $db->sql_fetchrow($result))

+ {

+ $user_id_ary = array();

+ do

+ {

+ $user_id_ary[] = $row['user_id'];

+ }

+ while ($row = $db->sql_fetchrow($result));

+

+ // Remove users from foe list if they are admins or moderators

+ if ($mode == 'foes')

+ {

+ // This isn't right ...

+ $user_id_ary = array_diff($user_id_ary, array_keys(discover_auth($user_id_ary, array('a_', 'm_'))));

+ }

+

+ if (sizeof($user_id_ary))

+ {

+ $sql_mode = ($mode == 'friends') ? 'friend' : 'foe';

+

+ switch (SQL_LAYER)

+ {

+ case 'mysql':

+ case 'mysql4':

+ $sql = 'INSERT INTO ' . ZEBRA_TABLE . " (user_id, zebra_id, $sql_mode)

+ VALUES " . implode(', ', preg_replace('#^([0-9]+)$#', '(' . $user->data['user_id'] . ", \\1, 1)", $user_id_ary));

+ $db->sql_query($sql);

+ break;

+

+ case 'mssql':

+ case 'mssql-odbc':

+ case 'sqlite':

+ $sql = 'INSERT INTO ' . ZEBRA_TABLE . " (user_id, zebra_id, $sql_mode)

+ " . implode(' UNION ALL ', preg_replace('#^([0-9]+)$#', '(' . $user->data['user_id'] . ", \\1, 1)", $user_id_ary));

+ $db->sql_query($sql);

+ break;

+

+ default:

+ foreach ($user_id_ary as $zebra_id)

+ {

+ $sql = 'INSERT INTO ' . ZEBRA_TABLE . " (user_id, zebra_id, $sql_mode)

+ VALUES (" . $user->data['user_id'] . ", $zebra_id, 1)";

+ $db->sql_query($sql);

+ }

+ break;

+ }

+ }

+ unset($user_id_ary);

+ }

+ $db->sql_freeresult($result);

+ }

+ else if ($usernames)

+ {

+ // Force integer values

+ $usernames = array_map('intval', $usernames);

+

+ $sql = 'DELETE FROM ' . ZEBRA_TABLE . '

+ WHERE user_id = ' . $user->data['user_id'] . '

+ AND zebra_id IN (' . implode(', ', $usernames) . ')';

+ $db->sql_query($sql);

+ }

+

+ meta_refresh(3, "ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode");

+ $message = $user->lang[strtoupper($mode) . '_UPDATED'] . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], "<a href=\"ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode\">", '</a>');

+ trigger_error($message);

+ }

+

+ $sql_and = ($mode == 'friends') ? 'z.friend = 1' : 'z.foe = 1';

+ $sql = 'SELECT z.*, u.username

+ FROM ' . ZEBRA_TABLE . ' z, ' . USERS_TABLE . ' u

+ WHERE z.user_id = ' . $user->data['user_id'] . "

+ AND $sql_and

+ AND u.user_id = z.zebra_id";

+ $result = $db->sql_query($sql);

+

+ $s_username_options = '';

+ while ($row = $db->sql_fetchrow($result))

+ {

+ $s_username_options .= '<option value="' . $row['zebra_id'] . '">' . $row['username'] . '</option>';

+ }

+ $db->sql_freeresult($result);

+

+ $template->assign_vars(array(

+ 'L_TITLE' => $user->lang['UCP_' . strtoupper($mode)],

+

+ 'U_SEARCH_USER' => "memberlist.$phpEx$SID&amp;mode=searchuser&amp;form=ucp&amp;field=add",

+

+ 'S_USERNAME_OPTIONS' => $s_username_options,

+ 'S_HIDDEN_FIELDS' => $s_hidden_fields,

+ 'S_UCP_ACTION' => "ucp.$phpEx$SID&amp;i=$id&amp;mode=$mode")

+ );

+

+ $this->display($user->lang['UCP_ZEBRA'], 'ucp_zebra_' . $mode . '.html');

+

+

+ 'POST_BY_FOE' => 'This post was made by <b>%1$s</b> who is currently on your ignore list. To display this post click %2$sHERE%3$s.',

+ 'UCP' => 'User Control Panel',

+ 'UCP_OPTIONS' => 'Options',

+ 'FRIENDS' => 'Friends',

+ 'FRIENDS_ONLINE' => 'Online',

+ 'FRIENDS_OFFLINE' => 'Offline',

+ 'NO_FRIENDS_ONLINE' => 'No friends online',

+ 'NO_FRIENDS_OFFLINE'=> 'No friends offline',

+ 'TOTAL_PMS' => '$d private messages in total',

+ 'YOUR_KARMA' => 'Your Karma level',

+ 'YOUR_WARNINGS' => 'Your Warning level',

+ 'SEARCH_YOUR_POSTS' => 'Show your posts',

+// ucp_prefs

+$lang += array(

+ 'UCP_PREFS' => 'Preferences',

+

+ 'UCP_PERSONAL' => 'Personal Settings',

+ 'HIDE_ONLINE' => 'Hide my online status',

+ 'NOTIFY_ON_PM' => 'Email me on new private messages',

+ 'POPUP_ON_PM' => 'Pop up window on new private message',

+ 'SHOW_EMAIL' => 'Users can contact me by email',

+ 'ADMIN_EMAIL' => 'Administrators can email me information',

+ 'BOARD_STYLE' => 'My board style',

+ 'BOARD_LANGUAGE' => 'My language',

+ 'BOARD_TIMEZONE' => 'My timezone',

+ 'BOARD_DST' => 'Daylight Saving Time is in effect',

+ 'BOARD_DATE_FORMAT' => 'My date format',

+ 'BOARD_DATE_FORMAT_EXPLAIN' => 'The syntax used is identical to the PHP <a href=\"http://www.php.net/date\" target=\"_other\">date()</a> function',

+

+ 'UCP_VIEW' => 'Viewing Posts',

+ 'VIEW_IMAGES' => 'Display Images within posts',

+ 'VIEW_FLASH' => 'Display Flash animations',

+ 'VIEW_SMILIES' => 'Display Smileys as images',

+ 'VIEW_SIGS' => 'Display Signatures',

+ 'VIEW_AVATARS' => 'Display Avatars',

+ 'DISABLE_CENSORS' => 'Enable Word censoring',

+ 'MINIMUM_KARMA' => 'Minimum User Karma',

+ 'MINIMUM_KARMA_EXPLAIN'=> 'Posts by users with Karma less than this will be ignored.',

+ 'VIEW_TOPICS_DAYS' => 'Display topics from previous days',

+ 'VIEW_TOPICS_KEY' => 'Display topics ordering by',

+ 'VIEW_TOPICS_DIR' => 'Display topic order direction',

+

+ 'UCP_POST' => 'Posting Messages',

+ 'DEFAULT_SMILE' => 'Enable smilies by default',

+ 'DEFAULT_HTML' => 'Enable HTML by default',

+ 'DEFAULT_BBCODE' => 'Enable BBCode by default',

+ 'DEFAULT_ADD_SIG' => 'Attach my signature by default',

+ 'DEFAULT_NOTIFY' => 'Notify me upon replies by default',

+

+ 'PREFS_UPDATED' => 'Your preferences have been updated.',

+);

+

+// ucp_zebra

+$lang += array(

+ 'UCP_ZEBRA' => 'Friends and Foes',

+ 'UCP_FRIENDS' => 'Friends',

+ 'UCP_FOES' => 'Foes',

+

+ 'FRIENDS_EXPLAIN' => 'Friends enable you quick access to members you communicate with frequently. If the template has relevant support any posts made by a friend may be highlighted.',

+ 'YOUR_FRIENDS' => 'Your friends',

+ 'YOUR_FRIENDS_EXPLAIN' => 'To remove usernames select them and click submit',

+ 'ADD_FRIENDS' => 'Add new friends',

+ 'ADD_FRIENDS_EXPLAIN' => 'You may enter several usernames each on a different line',

+ 'NO_FRIENDS' => 'No friends currently defined',

+

+ 'FOES_EXPLAIN' => 'Foes are users which will be ignored by default. Posts by these users will not be fully visible and personal messages will not be permitted. Please note that you cannot ignore moderators or administrators.',

+ 'YOUR_FOES' => 'Your foes',

+ 'YOUR_FOES_EXPLAIN' => 'To remove usernames select them and click submit',

+ 'ADD_FOES' => 'Add new foes',

+ 'ADD_FOES_EXPLAIN' => 'You may enter several usernames each on a different line',

+ 'NO_FOES' => 'No foes currently defined',

+

+ 'FRIENDS_UPDATED' => 'Your friends list has been updated successfully',

+ 'FOES_UPDATED' => 'Your foes list has been updated successfully',

+);

+

+// ucp_pm

+class module

+ var $id = 0;

+ var $type;

+ var $name;

+ var $mode;

+ // Private methods, should not be overwritten

+ function create($module_type, $module_url, $selected_mod = false, $selected_submod = false)

+ global $template, $auth, $db, $user;

+

+ $sql = 'SELECT module_id, module_title, module_filename, module_subs, module_acl

+ FROM ' . MODULES_TABLE . "

+ WHERE module_type = '{$module_type}'

+ AND module_enabled = 1

+ ORDER BY module_order ASC";

+ $result = $db->sql_query($sql);

+

+ while ($row = $db->sql_fetchrow($result))

+ // Authorisation is required for the basic module

+ if ($row['module_acl'])

+ {

+ $is_auth = FALSE;

+ foreach (explode(',', $row['module_acl']) as $auth_option)

+ {

+ if ($auth->acl_get($auth_option))

+ {

+ $is_auth = TRUE;

+ break;

+ }

+ }

+

+ // The user is not authorised to use this module, skip it

+ if (!$is_auth)

+ {

+ continue;

+ }

+ }

+ $selected = ($row['module_filename'] == $selected_mod || $row['module_id'] == $selected_mod || (!$selected_mod && !$i)) ? true : false;

+

+ // Get the localised lang string if available, or make up our own otherwise

+ $template->assign_block_vars($module_type . '_section', array(

+ 'L_TITLE' => (isset($user->lang[strtoupper($module_type) . '_' . $row['module_title']])) ? $user->lang[strtoupper($module_type) . '_' . $row['module_title']] : ucfirst(str_replace('_', ' ', strtolower($row['module_title']))),

+ 'S_SELECTED' => $selected,

+ 'U_TITLE' => $module_url . '&amp;i=' . $row['module_id'])

+ );

+ if ($selected)

+ $module_id = $row['module_id'];

+ $module_name = $row['module_filename'];

+

+ if ($row['module_subs'])

+ {

+ $j = 0;

+ $submodules_ary = explode("\n", $row['module_subs']);

+ foreach ($submodules_ary as $submodule)

+ {

+ $submodule = explode(',', trim($submodule));

+ $submodule_title = array_shift($submodule);

+

+ $is_auth = true;

+ foreach ($submodule as $auth_option)

+ {

+ if (!$auth->acl_get($auth_option))

+ {

+ $is_auth = false;

+ }

+ }

+

+ if (!$is_auth)

+ {

+ continue;

+ }

+

+ $selected = ($submodule_title == $selected_submod || (!$selected_submod && !$j)) ? true : false;

+

+ // Get the localised lang string if available, or make up our own otherwise

+ $template->assign_block_vars("{$module_type}_section.{$module_type}_subsection", array(

+ 'L_TITLE' => (isset($user->lang[strtoupper($module_type) . '_' . strtoupper($submodule_title)])) ? $user->lang[strtoupper($module_type) . '_' . strtoupper($submodule_title)] : ucfirst(str_replace('_', ' ', strtolower($submodule_title))),

+ 'S_SELECTED' => $selected,

+ 'U_TITLE' => $module_url . '&amp;i=' . $module_id . '&amp;mode=' . $submodule_title

+ ));

+

+ if ($selected)

+ {

+ $this->mode = $submodule_title;

+ }

+

+ $j++;

+ }

+ }

+

+ $i++;

+ $db->sql_freeresult($result);

+ if (!$module_id)

+ {

+ trigger_error('MODULE_NOT_EXIST');

+ }

+

+ $this->type = $module_type;

+ $this->id = $module_id;

+ $this->name = $module_name;

+ function load($type = false, $name = false, $mode = false, $run = true)

+ global $phpbb_root_path, $phpEx;

+ if ($type)

+ $this->type = $type;

+ }

+ if ($name)

+ {

+ $this->name = $name;

+ }

+ if (!class_exists($this->type . '_' . $this->name))

+ {

+ require_once($phpbb_root_path . "includes/{$this->type}/{$this->type}_{$this->name}.$phpEx");

+ if ($run)

+ eval("\$this->module = new {$this->type}_{$this->name}(\$this->id, \$this->mode);");

+ if (method_exists($this->module, 'init'))

+ $this->module->init();

+ function display($page_title, $tpl_name)

+ global $template;

+

+ // Public methods to be overwritten by modules

+ function module()

+ {

+ // Module name

+ // Module filename

+ // Module description

+ // Module version

+ // Module compatibility

+ return false;

+ }

+

+ function init()

+ {

+ return false;

+ }

+

+ function install()

+ {

+ return false;

+ }

+

+ function uninstall()

+ {

+ return false;

+ }

+$ucp = new module();

+// Basic parameter data

+$mode = (!empty($_REQUEST['mode'])) ? htmlspecialchars($_REQUEST['mode']) : false;

+$module = (!empty($_REQUEST['i'])) ? intval($_REQUEST['i']) : false;

+ $ucp->load('ucp', 'activate');

+ $ucp->module->ucp_activate();

+ $ucp->load('ucp', 'remind');

+ $ucp->module->ucp_remind();

+ $ucp->load('ucp', 'register');

+ $ucp->module->ucp_register();

+ $ucp->load('ucp', 'confirm');

+ $ucp->module->ucp_confirm();

+// Output listing of friends online

+$sql = 'SELECT DISTINCT u.user_id, u.username, MAX(s.session_time) as online_time, MIN(s.session_allow_viewonline) AS viewonline

+ FROM ((' . ZEBRA_TABLE . ' z

+ LEFT JOIN ' . SESSIONS_TABLE . ' s ON s.session_user_id = z.zebra_id), ' . USERS_TABLE . ' u)

+ WHERE z.user_id = ' . $user->data['user_id'] . '

+ AND z.friend = 1

+ AND u.user_id = z.zebra_id

+ GROUP BY z.zebra_id';

+$update_time = $config['load_online_time'] * 60;

+ $which = (time() - $update_time < $row['online_time']) ? 'online' : 'offline';

+ $template->assign_block_vars("friends_{$which}", array(

+ 'U_PROFILE' => "memberlist.$phpEx$SID&amp;mode=viewprofile&amp;u=" . $row['user_id'],

+ 'USERNAME' => $row['username'])

+

+// Instantiate module system and generate list of available modules

+$ucp->create('ucp', "ucp.$phpEx$SID", $module, $mode);

+

+// Load and execute the relevant module

+$ucp->load();

+if (!$auth->acl_get('f_read', $forum_id))

+ // Obtain announcements ... removed sort ordering, sort by time in all cases

+ AND t.topic_type IN (" . POST_ANNOUNCE . ', ' . POST_GLOBAL . ')

+ ORDER BY t.topic_time DESC';

+ // Select the sort order

+ $sql_sort_order = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'ASC' : 'DESC');

+ // Select the sort order

+ $sql_sort_order = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');

+ $sql_rownum = (SQL_LAYER != 'oracle') ? '' : ', ROWNUM rnum ';

+ $sql = "SELECT t.* $sql_select$sql_rownum

+ $topic_list = ($store_reverse) ? array_merge($announcement_list, array_reverse($topic_list)) : array_merge($announcement_list, $topic_list);

+// Fill extension informations, if this topic has attachments

+$extensions = array();

+if ($topic_attachment)

+{

+ obtain_attach_extensions($extensions);

+}

+

+// Are we watching this topic?

+$s_watching_topic = $s_watching_topic_img = '';

+if ($config['email_enable'] && $config['allow_topic_notify'])

+{

+ watch_topic_forum('topic', $s_watching_topic, $s_watching_topic_img, $user->data['user_id'], $topic_id, $notify_status);

+}

+$pagination_url = "viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id&amp;sk=$sort_key&amp;st=$sort_days&amp;sd=$sort_dir" . (($highlight_match) ? "&amp;hilit=$highlight" : '');

+ $sort_order = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'ASC' : 'DESC');

+else

+{

+ // Select the sort order

+ $sort_order = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');

+}

+

+// Container for user details, only process once

+$user_cache = $id_cache = $attachments = $attach_list = $rowset = $update_count = array();

+$has_attachments = $display_notice = FALSE;

+$force_encoding = '';

+$bbcode_bitfield = $i = $i_total = 0;

+$sql = 'SELECT u.username, u.user_id, u.user_colour, u.user_posts, u.user_from, u.user_karma, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_jabber, u.user_regdate, u.user_msnm, u.user_allow_viewemail, u.user_allow_viewonline, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_sig_bbcode_bitfield, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height, z.friend, z.foe, p.*

+ FROM ((' . POSTS_TABLE . ' p

+ LEFT JOIN ' . ZEBRA_TABLE . ' z ON (z.user_id = ' . $user->data['user_id'] . ' AND z.zebra_id = p.poster_id)), ' . USERS_TABLE . " u)

+ if (!$view || $view != 'show' || $post_id != $row['post_id'])

+ if ($row['user_karma'] < $user->data['user_min_karma'])

+ {

+ $rowset[] = array(

+ 'below_karma' => TRUE,

+ 'post_id' => $row['post_id'],

+ 'poster' => $poster,

+ 'user_karma' => $row['user_karma']

+ );

+ continue;

+ }

+ else if ($row['foe'])

+ {

+ $rowset[] = array(

+ 'foe' => TRUE,

+ 'post_id' => $row['post_id'],

+ 'poster' => $poster,

+ );

+

+ continue;

+ }

+ 'enable_sig' => $row['enable_sig'],

+ 'friend' => $row['friend'],

+ 'enable_sig' => $row['enable_sig'],

+ 'friend' => $row['friend'],

+ 'L_IGNORE_POST' => sprintf($user->lang['POST_BELOW_KARMA'], $row['poster'], $row['user_karma'], "<a href=\"viewtopic.$phpEx$SID&amp;f=$forum_id&amp;p=" . $row['post_id'] . '&amp;view=show#' . $row['post_id'] . '">', '</a>'))

+ );

+

+ continue;

+ }

+ else if ($row['foe'])

+ {

+ $template->assign_block_vars('postrow', array(

+ 'S_IGNORE_POST' => true,

+ 'S_ROW_COUNT' => $i,

+

+ 'L_IGNORE_POST' => sprintf($user->lang['POST_BY_FOE'], $row['poster'], "<a href=\"viewtopic.$phpEx$SID&amp;f=$forum_id&amp;p=" . $row['post_id'] . '&amp;view=show#' . $row['post_id'] . '">', '</a>'))

+ 'S_DISPLAY_NOTICE' => $display_notice && $row['post_attachment'],

+ 'S_FRIEND' => ($row['friend']) ? true : false)