+ $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');

+

+