[ABD] Cash Mod 1.0.0 Beta 1

Ladysarajane · Post by **Ladysarajane** » Mon Oct 27, 2008 9:41 pm

shahinavthal wrote:is there any way to view the richest member of the forum ??

Why so mad about this? This isn't available right now unless you go to the database to look it up, but you could request that feature here:http://trac.assembla.com/Handyman/report/3

zeroxxorez · Post by **zeroxxorez** » Tue Oct 28, 2008 4:40 am

I'm having a problem with my memberlist.php its not showing anything in the cash category. they are all just empty spaces...everything else works fine. any ideas?

shahinavthal · Post by **shahinavthal** » Tue Oct 28, 2008 7:36 am

Ladysarajane wrote:
shahinavthal wrote:is there any way to view the richest member of the forum ??
Why so mad about this? This isn't available right now unless you go to the database to look it up, but you could request that feature here:http://trac.assembla.com/Handyman/report/3

Ahhh!!! Sorry Sorry...I dint recheck after posting...It was supposed to be

... clicked the wrong one i guess..

Actually not mad but MAD about the MOD

..its just too good and with all the people integrating with this mod..Its a must have for any forum...

shahinavthal · Post by **shahinavthal** » Tue Oct 28, 2008 7:37 am

zeroxxorez wrote:I'm having a problem with my memberlist.php its not showing anything in the cash category. they are all just empty spaces...everything else works fine. any ideas?

This is a known bug and it is getting fixed(most probably in the next release)

Ladysarajane · Post by **Ladysarajane** » Tue Oct 28, 2008 8:10 pm

shahinavthal wrote:
Ladysarajane wrote:
shahinavthal wrote:is there any way to view the richest member of the forum ??
Why so mad about this? This isn't available right now unless you go to the database to look it up, but you could request that feature here:http://trac.assembla.com/Handyman/report/3
Ahhh!!! Sorry Sorry...I dint recheck after posting...It was supposed to be ... clicked the wrong one i guess..

Actually not mad but MAD about the MOD ..its just too good and with all the people integrating with this mod..Its a must have for any forum...

Ah, Okay

It is a must have.

karine119 · Post by **karine119** » Wed Oct 29, 2008 4:35 am

Ok after going insane reading this post and not finding anything remotely close to this.... I am at this step in the install.

Open: includes/functions_posting.php
Find
Tip: This may be a partial find and not the whole line.

Code: Select all

global $db, $auth, $user, $config, $phpEx, $template, $phpbb_root_path;

Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select all

global $cash;

Maybe mommy brain is kicking in and I am getting distracted, but I just cant seem to find anything even close to that line. Could it be written another way? Anyone know roughly what line it might be located at or near?

MrMontana · Post by **MrMontana** » Wed Oct 29, 2008 9:59 am

karine119 wrote:Ok after going insane reading this post and not finding anything remotely close to this.... I am at this step in the install.

Open: includes/functions_posting.php
Find
Tip: This may be a partial find and not the whole line.
Code: Select all
global $db, $auth, $user, $config, $phpEx, $template, $phpbb_root_path;
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.
Code: Select all
global $cash;
Maybe mommy brain is kicking in and I am getting distracted, but I just cant seem to find anything even close to that line. Could it be written another way? Anyone know roughly what line it might be located at or near?

I found that line in my functions_posting.php
In mine, its on line 1571...

karine119 · Post by **karine119** » Wed Oct 29, 2008 10:09 am

Thanks, I dont know what I was looking at before or why my search didn't find it but I just looked around that line and there it is. I must be losing it.

francebramie · Post by **francebramie** » Wed Oct 29, 2008 8:28 pm

Forum = http://forums.gamebeach.nl/

I have installed a cash modification. (viewtopic.php?f=70&t=547021). But there is a problem in the profile! http://forums.gamebeach.nl/memberlist.p ... rofile&u=2 how can i fixe it?

Memberlist.php:

Code: Select all

    <?php
    /**
    *
    * @package phpBB3
    * @version $Id: memberlist.php 8645 2008-06-10 14:37:38Z acydburn $
    * @copyright (c) 2005 phpBB Group
    * @license http://opensource.org/licenses/gpl-license.php GNU Public License
    *
    */

    /**
    * @ignore
    */
    define('IN_PHPBB', true);
    define('IN_CASHMOD', true);
    define('CM_MEMBERLIST', true);

    $phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
    $phpEx = substr(strrchr(__FILE__, '.'), 1);
    include($phpbb_root_path . 'common.' . $phpEx);
    include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

    // Start session management
    $user->session_begin();
    $auth->acl($user->data);
    $user->setup(array('memberlist', 'groups'));

    // Grab data
    $mode      = request_var('mode', '');
    $action      = request_var('action', '');
    $user_id   = request_var('u', ANONYMOUS);
    $username   = request_var('un', '', true);
    $group_id   = request_var('g', 0);
    $topic_id   = request_var('t', 0);

    // Check our mode...
    if (!in_array($mode, array('', 'group', 'viewprofile', 'email', 'contact', 'searchuser', 'leaders')))
    {
       trigger_error('NO_MODE');
    }

    switch ($mode)
    {
       case 'email':
       break;

       default:
          // Can this user view profiles/memberlist?
          if (!$auth->acl_gets('u_viewprofile', 'a_user', 'a_useradd', 'a_userdel'))
          {
             if ($user->data['user_id'] != ANONYMOUS)
             {
                trigger_error('NO_VIEW_USERS');
             }

             login_box('', ((isset($user->lang['LOGIN_EXPLAIN_' . strtoupper($mode)])) ? $user->lang['LOGIN_EXPLAIN_' . strtoupper($mode)] : $user->lang['LOGIN_EXPLAIN_MEMBERLIST']));
          }
       break;
    }

    $start   = request_var('start', 0);
    $submit = (isset($_POST['submit'])) ? true : false;

    $default_key = 'c';
    $sort_key = request_var('sk', $default_key);
    $sort_dir = request_var('sd', 'a');


    // Grab rank information for later
    $ranks = $cache->obtain_ranks();


    // What do you want to do today? ... oops, I think that line is taken ...
    switch ($mode)
    {
       case 'leaders':
          // Display a listing of board admins, moderators
          include($phpbb_root_path . 'includes/functions_user.' . $phpEx);

          $page_title = $user->lang['THE_TEAM'];
          $template_html = 'memberlist_leaders.html';

          $user_ary = $auth->acl_get_list(false, array('a_', 'm_'), false);

          $admin_id_ary = $global_mod_id_ary = $mod_id_ary = $forum_id_ary = array();
          foreach ($user_ary as $forum_id => $forum_ary)
          {
             foreach ($forum_ary as $auth_option => $id_ary)
             {
                if (!$forum_id)
                {
                   if ($auth_option == 'a_')
                   {
                      $admin_id_ary = array_merge($admin_id_ary, $id_ary);
                   }
                   else
                   {
                      $global_mod_id_ary = array_merge($global_mod_id_ary, $id_ary);
                   }
                   continue;
                }
                else
                {
                   $mod_id_ary = array_merge($mod_id_ary, $id_ary);
                }

                if ($forum_id)
                {
                   foreach ($id_ary as $id)
                   {
                      $forum_id_ary[$id][] = $forum_id;
                   }
                }
             }
          }

          $admin_id_ary = array_unique($admin_id_ary);
          $global_mod_id_ary = array_unique($global_mod_id_ary);

          $mod_id_ary = array_merge($mod_id_ary, $global_mod_id_ary);
          $mod_id_ary = array_unique($mod_id_ary);

          // Admin group id...
          $sql = 'SELECT group_id
             FROM ' . GROUPS_TABLE . "
             WHERE group_name = 'ADMINISTRATORS'";
          $result = $db->sql_query($sql);
          $admin_group_id = (int) $db->sql_fetchfield('group_id');
          $db->sql_freeresult($result);

          // Get group memberships for the admin id ary...
          $admin_memberships = group_memberships($admin_group_id, $admin_id_ary);

          $admin_user_ids = array();
          
          if (!empty($admin_memberships))
          {
             // ok, we only need the user ids...
             foreach ($admin_memberships as $row)
             {
                $admin_user_ids[$row['user_id']] = true;
             }
          }
          unset($admin_memberships);

          $sql = 'SELECT forum_id, forum_name
             FROM ' . FORUMS_TABLE;
          $result = $db->sql_query($sql);

          $forums = array();
          while ($row = $db->sql_fetchrow($result))
          {
             $forums[$row['forum_id']] = $row['forum_name'];
          }
          $db->sql_freeresult($result);

          $sql = $db->sql_build_query('SELECT', array(
             'SELECT'   => 'u.user_id, u.group_id as default_group, u.username, u.username_clean, u.user_colour, u.user_rank, u.user_posts, u.user_allow_pm, g.group_id, g.group_name, g.group_colour, g.group_type, ug.user_id as ug_user_id',

             'FROM'      => array(
                USERS_TABLE      => 'u',
                GROUPS_TABLE   => 'g'
             ),

             'LEFT_JOIN'   => array(
                array(
                   'FROM'   => array(USER_GROUP_TABLE => 'ug'),
                   'ON'   => 'ug.group_id = g.group_id AND ug.user_pending = 0 AND ug.user_id = ' . $user->data['user_id']
                )
             ),

             'WHERE'      => $db->sql_in_set('u.user_id', array_unique(array_merge($admin_id_ary, $mod_id_ary)), false, true) . '
                AND u.group_id = g.group_id',

             'ORDER_BY'   => 'g.group_name ASC, u.username_clean ASC'
          ));
          $result = $db->sql_query($sql);

          while ($row = $db->sql_fetchrow($result))
          {
             $which_row = (in_array($row['user_id'], $admin_id_ary)) ? 'admin' : 'mod';

             // We sort out admins not within the 'Administrators' group.
             // Else, we will list those as admin only having the permission to view logs for example.
             if ($which_row == 'admin' && empty($admin_user_ids[$row['user_id']]))
             {
                // Remove from admin_id_ary, because the user may be a mod instead
                unset($admin_id_ary[array_search($row['user_id'], $admin_id_ary)]);

                if (!in_array($row['user_id'], $mod_id_ary) && !in_array($row['user_id'], $global_mod_id_ary))
                {
                   continue;
                }
                else
                {
                   $which_row = 'mod';
                }
             }

             $s_forum_select = '';
             $undisclosed_forum = false;

             if (isset($forum_id_ary[$row['user_id']]) && !in_array($row['user_id'], $global_mod_id_ary))
             {
                if ($which_row == 'mod' && sizeof(array_diff(array_keys($forums), $forum_id_ary[$row['user_id']])))
                {
                   foreach ($forum_id_ary[$row['user_id']] as $forum_id)
                   {
                      if (isset($forums[$forum_id]))
                      {
                         if ($auth->acl_get('f_list', $forum_id))
                         {
                            $s_forum_select .= '<option value="">' . $forums[$forum_id] . '</option>';
                         }
                         else
                         {
                            $undisclosed_forum = true;
                         }
                      }
                   }
                }
             }

             // If the mod is only moderating non-viewable forums we skip the user. There is no gain in displaying the person then...
             if (!$s_forum_select && $undisclosed_forum)
             {
    //            $s_forum_select = '<option value="">' . $user->lang['FORUM_UNDISCLOSED'] . '</option>';
                continue;
             }

             // The person is moderating several "public" forums, therefore the person should be listed, but not giving the real group name if hidden.
             if ($row['group_type'] == GROUP_HIDDEN && !$auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel') && $row['ug_user_id'] != $user->data['user_id'])
             {
                $group_name = $user->lang['GROUP_UNDISCLOSED'];
                $u_group = '';
             }
             else
             {
                $group_name = ($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name'];
                $u_group = append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group&g=' . $row['group_id']);
             }

             $rank_title = $rank_img = '';
             get_user_rank($row['user_rank'], $row['user_posts'], $rank_title, $rank_img, $rank_img_src);

             $template->assign_block_vars($which_row, array(
                'USER_ID'      => $row['user_id'],
                'FORUMS'      => $s_forum_select,
                'RANK_TITLE'   => $rank_title,
                'GROUP_NAME'   => $group_name,
                'GROUP_COLOR'   => $row['group_colour'],

                'RANK_IMG'      => $rank_img,
                'RANK_IMG_SRC'   => $rank_img_src,

                'U_GROUP'         => $u_group,
                'U_PM'            => ($config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($row['user_allow_pm'] || $auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_'))) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&mode=compose&u=' . $row['user_id']) : '',

                'USERNAME_FULL'      => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),
                'USERNAME'         => get_username_string('username', $row['user_id'], $row['username'], $row['user_colour']),
                'USER_COLOR'      => get_username_string('colour', $row['user_id'], $row['username'], $row['user_colour']),
                'U_VIEW_PROFILE'   => get_username_string('profile', $row['user_id'], $row['username'], $row['user_colour']),
             ));
          }
          $db->sql_freeresult($result);

          $template->assign_vars(array(
             'PM_IMG'      => $user->img('icon_contact_pm', $user->lang['SEND_PRIVATE_MESSAGE']))
          );
       break;

       case 'contact':

          $page_title = $user->lang['IM_USER'];
          $template_html = 'memberlist_im.html';

          if (!$auth->acl_get('u_sendim'))
          {
             trigger_error('NOT_AUTHORISED');
          }

          $presence_img = '';
          switch ($action)
          {
             case 'aim':
                $lang = 'AIM';
                $sql_field = 'user_aim';
                $s_select = 'S_SEND_AIM';
                $s_action = '';
             break;

             case 'msnm':
                $lang = 'MSNM';
                $sql_field = 'user_msnm';
                $s_select = 'S_SEND_MSNM';
                $s_action = '';
             break;

             case 'jabber':
                $lang = 'JABBER';
                $sql_field = 'user_jabber';
                $s_select = (@extension_loaded('xml') && $config['jab_enable']) ? 'S_SEND_JABBER' : 'S_NO_SEND_JABBER';
                $s_action = append_sid("{$phpbb_root_path}memberlist.$phpEx", "mode=contact&action=$action&u=$user_id");
             break;

             default:
                trigger_error('NO_MODE', E_USER_ERROR);
             break;
          }

          // Grab relevant data
          $sql = "SELECT user_id, username, user_email, user_lang, $sql_field
             FROM " . USERS_TABLE . "
             WHERE user_id = $user_id
                AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')';
          $result = $db->sql_query($sql);
          $row = $db->sql_fetchrow($result);
          $db->sql_freeresult($result);

          if (!$row)
          {
             trigger_error('NO_USER');
          }
          else if (empty($row[$sql_field]))
          {
             trigger_error('IM_NO_DATA');
          }

          // Post data grab actions
          switch ($action)
          {
             case 'jabber':
                add_form_key('memberlist_messaging');

                if ($submit && @extension_loaded('xml') && $config['jab_enable'])
                {
                   if (check_form_key('memberlist_messaging'))
                   {

                      include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

                      $subject = sprintf($user->lang['IM_JABBER_SUBJECT'], $user->data['username'], $config['server_name']);
                      $message = utf8_normalize_nfc(request_var('message', '', true));

                      if (empty($message))
                      {
                         trigger_error('EMPTY_MESSAGE_IM');
                      }

                      $messenger = new messenger(false);

                      $messenger->template('profile_send_im', $row['user_lang']);
                      $messenger->subject(htmlspecialchars_decode($subject));

                      $messenger->replyto($user->data['user_email']);
                      $messenger->im($row['user_jabber'], $row['username']);

                      $messenger->assign_vars(array(
                         'BOARD_CONTACT'   => $config['board_contact'],
                         'FROM_USERNAME'   => htmlspecialchars_decode($user->data['username']),
                         'TO_USERNAME'   => htmlspecialchars_decode($row['username']),
                         'MESSAGE'      => htmlspecialchars_decode($message))
                      );

                      $messenger->send(NOTIFY_IM);

                      $s_select = 'S_SENT_JABBER';
                   }
                   else
                   {
                      trigger_error('FORM_INVALID');
                   }
                }
             break;
          }

          // Send vars to the template
          $template->assign_vars(array(
             'IM_CONTACT'   => $row[$sql_field],
             'A_IM_CONTACT'   => addslashes($row[$sql_field]),

             'U_AIM_CONTACT'   => ($action == 'aim') ? 'aim:addbuddy?screenname=' . urlencode($row[$sql_field]) : '',
             'U_AIM_MESSAGE'   => ($action == 'aim') ? 'aim:goim?screenname=' . urlencode($row[$sql_field]) . '&message=' . urlencode($config['sitename']) : '',

             'USERNAME'      => $row['username'],
             'CONTACT_NAME'   => $row[$sql_field],
             'SITENAME'      => $config['sitename'],

             'PRESENCE_IMG'      => $presence_img,

             'L_SEND_IM_EXPLAIN'   => $user->lang['IM_' . $lang],
             'L_IM_SENT_JABBER'   => sprintf($user->lang['IM_SENT_JABBER'], $row['username']),

             $s_select         => true,
             'S_IM_ACTION'      => $s_action)
          );

       break;

       case 'viewprofile':
          // Display a profile
          if ($user_id == ANONYMOUS && !$username)
          {
             trigger_error('NO_USER');
          }

          // Get user...
          $sql = 'SELECT *
             FROM ' . USERS_TABLE . '
             WHERE ' . (($username) ? "username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'" : "user_id = $user_id");
          $result = $db->sql_query($sql);
          $member = $db->sql_fetchrow($result);
          $db->sql_freeresult($result);

          if (!$member)
          {
             trigger_error('NO_USER');
          }

          // a_user admins and founder are able to view inactive users and bots to be able to manage them more easily
          // Normal users are able to see at least users having only changed their profile settings but not yet reactivated.
          if (!$auth->acl_get('a_user') && $user->data['user_type'] != USER_FOUNDER)
          {
             if ($member['user_type'] == USER_IGNORE)
             {
                trigger_error('NO_USER');
             }
             else if ($member['user_type'] == USER_INACTIVE && $member['user_inactive_reason'] != INACTIVE_PROFILE)
             {
                trigger_error('NO_USER');
             }
          }

          $user_id = (int) $member['user_id'];

          // Do the SQL thang
          $sql = 'SELECT g.group_id, g.group_name, g.group_type
             FROM ' . GROUPS_TABLE . ' g, ' . USER_GROUP_TABLE . " ug
             WHERE ug.user_id = $user_id
                AND g.group_id = ug.group_id" . ((!$auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel')) ? ' AND g.group_type <> ' . GROUP_HIDDEN : '') . '
                AND ug.user_pending = 0
             ORDER BY g.group_type, g.group_name';
          $result = $db->sql_query($sql);

          $group_options = '';
          while ($row = $db->sql_fetchrow($result))
          {
             $group_options .= '<option value="' . $row['group_id'] . '"' . (($row['group_id'] == $member['group_id']) ? ' selected="selected"' : '') . '>' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';
          }
          $db->sql_freeresult($result);

          // What colour is the zebra
          $sql = 'SELECT friend, foe
             FROM ' . ZEBRA_TABLE . "
             WHERE zebra_id = $user_id
                AND user_id = {$user->data['user_id']}";

          $result = $db->sql_query($sql);
          $row = $db->sql_fetchrow($result);
          $foe = ($row['foe']) ? true : false;
          $friend = ($row['friend']) ? true : false;
          $db->sql_freeresult($result);

          if ($config['load_onlinetrack'])
          {
             $sql = 'SELECT MAX(session_time) AS session_time, MIN(session_viewonline) AS session_viewonline
                FROM ' . SESSIONS_TABLE . "
                WHERE session_user_id = $user_id";
             $result = $db->sql_query($sql);
             $row = $db->sql_fetchrow($result);
             $db->sql_freeresult($result);

             $member['session_time'] = (isset($row['session_time'])) ? $row['session_time'] : 0;
             $member['session_viewonline'] = (isset($row['session_viewonline'])) ? $row['session_viewonline'] :   0;
             unset($row);
          }

          if ($config['load_user_activity'])
          {
             display_user_activity($member);
          }

          // Do the relevant calculations
          $memberdays = max(1, round((time() - $member['user_regdate']) / 86400));
          $posts_per_day = $member['user_posts'] / $memberdays;
          $percentage = ($config['num_posts']) ? min(100, ($member['user_posts'] / $config['num_posts']) * 100) : 0;


          if ($member['user_sig'])
          {
             $member['user_sig'] = censor_text($member['user_sig']);

             if ($member['user_sig_bbcode_bitfield'])
             {
                include_once($phpbb_root_path . 'includes/bbcode.' . $phpEx);
                $bbcode = new bbcode();
                $bbcode->bbcode_second_pass($member['user_sig'], $member['user_sig_bbcode_uid'], $member['user_sig_bbcode_bitfield']);
             }

             $member['user_sig'] = bbcode_nl2br($member['user_sig']);
             $member['user_sig'] = smiley_text($member['user_sig']);
          }

          $poster_avatar = get_user_avatar($member['user_avatar'], $member['user_avatar_type'], $member['user_avatar_width'], $member['user_avatar_height']);

          $template->assign_vars(show_profile($member));

          // Custom Profile Fields
          $profile_fields = array();
          if ($config['load_cpf_viewprofile'])
          {
             include_once($phpbb_root_path . 'includes/functions_profile_fields.' . $phpEx);
             $cp = new custom_profile();
             $profile_fields = $cp->generate_profile_fields_template('grab', $user_id);
             $profile_fields = (isset($profile_fields[$user_id])) ? $cp->generate_profile_fields_template('show', false, $profile_fields[$user_id]) : array();
          }

          // We need to check if the module 'zebra' is accessible
          $zebra_enabled = false;

          if ($user->data['user_id'] != $user_id && $user->data['is_registered'])
          {
             include_once($phpbb_root_path . 'includes/functions_module.' . $phpEx);
             $module = new p_master();
             $module->list_modules('ucp');
             $module->set_active('zebra');

             $zebra_enabled = ($module->active_module === false) ? false : true;

             unset($module);
          }

          $template->assign_vars(array(
             'POSTS_DAY'         => sprintf($user->lang['POST_DAY'], $posts_per_day),
             'POSTS_PCT'         => sprintf($user->lang['POST_PCT'], $percentage),

             'OCCUPATION'   => (!empty($member['user_occ'])) ? censor_text($member['user_occ']) : '',
             'INTERESTS'      => (!empty($member['user_interests'])) ? censor_text($member['user_interests']) : '',
             'SIGNATURE'      => $member['user_sig'],

             'AVATAR_IMG'   => $poster_avatar,
             'PM_IMG'      => $user->img('icon_contact_pm', $user->lang['SEND_PRIVATE_MESSAGE']),
             'EMAIL_IMG'      => $user->img('icon_contact_email', $user->lang['EMAIL']),
             'WWW_IMG'      => $user->img('icon_contact_www', $user->lang['WWW']),
             'ICQ_IMG'      => $user->img('icon_contact_icq', $user->lang['ICQ']),
             'AIM_IMG'      => $user->img('icon_contact_aim', $user->lang['AIM']),
             'MSN_IMG'      => $user->img('icon_contact_msnm', $user->lang['MSNM']),
             'YIM_IMG'      => $user->img('icon_contact_yahoo', $user->lang['YIM']),
             'JABBER_IMG'   => $user->img('icon_contact_jabber', $user->lang['JABBER']),
             'SEARCH_IMG'   => $user->img('icon_user_search', $user->lang['SEARCH']),

             'S_PROFILE_ACTION'   => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group'),
             'S_GROUP_OPTIONS'   => $group_options,
             'S_CUSTOM_FIELDS'   => (isset($profile_fields['row']) && sizeof($profile_fields['row'])) ? true : false,

             'U_USER_ADMIN'         => ($auth->acl_get('a_user')) ? append_sid("{$phpbb_root_path}adm/index.$phpEx", 'i=users&mode=overview&u=' . $user_id, true, $user->session_id) : '',
             'U_USER_BAN'         => ($auth->acl_get('m_ban')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=ban&mode=user&u=' . $user_id, true, $user->session_id) : '',

             'U_SWITCH_PERMISSIONS'   => ($auth->acl_get('a_switchperm') && $user->data['user_id'] != $user_id) ? append_sid("{$phpbb_root_path}ucp.$phpEx", "mode=switch_perm&u={$user_id}") : '',

             'S_ZEBRA'         => ($user->data['user_id'] != $user_id && $user->data['is_registered'] && $zebra_enabled) ? true : false,
             'U_ADD_FRIEND'      => (!$friend) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=zebra&add=' . urlencode(htmlspecialchars_decode($member['username']))) : '',
             'U_ADD_FOE'         => (!$foe) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=zebra&mode=foes&add=' . urlencode(htmlspecialchars_decode($member['username']))) : '',
             'U_REMOVE_FRIEND'   => ($friend) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=zebra&remove=1&usernames[]=' . $user_id) : '',
             'U_REMOVE_FOE'      => ($foe) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=zebra&remove=1&mode=foes&usernames[]=' . $user_id) : '',
          ));

          if (!empty($profile_fields['row']))
          {
             $template->assign_vars($profile_fields['row']);
          }
    //-- mod: Prime Warnings ----------------------------------------------------//
          if ($member['user_warnings'])
          {
             include($phpbb_root_path . 'includes/prime_warnings.' . $phpEx);
             prime_warnings($member['user_warnings'], 'warnings', $memeber['user_id']);
          }
    //-- end: Prime Warnings ----------------------------------------------------//

          if (!empty($profile_fields['blockrow']))
          {
             foreach ($profile_fields['blockrow'] as $field_data)
             {
                $template->assign_block_vars('custom_fields', $field_data);
             }
          }

          // Inactive reason/account?
          if ($member['user_type'] == USER_INACTIVE)
          {
             $user->add_lang('acp/common');

             $inactive_reason = $user->lang['INACTIVE_REASON_UNKNOWN'];

             switch ($member['user_inactive_reason'])
             {
                case INACTIVE_REGISTER:
                   $inactive_reason = $user->lang['INACTIVE_REASON_REGISTER'];
                break;

                case INACTIVE_PROFILE:
                   $inactive_reason = $user->lang['INACTIVE_REASON_PROFILE'];
                break;

                case INACTIVE_MANUAL:
                   $inactive_reason = $user->lang['INACTIVE_REASON_MANUAL'];
                break;

                case INACTIVE_REMIND:
                   $inactive_reason = $user->lang['INACTIVE_REASON_REMIND'];
                break;
             }

             $template->assign_vars(array(
                'S_USER_INACTIVE'      => true,
                'USER_INACTIVE_REASON'   => $inactive_reason)
             );
          }

          // Now generate page title
          $page_title = sprintf($user->lang['VIEWING_PROFILE'], $member['username']);
          $template_html = 'memberlist_view.html';

       break;

       case 'email':

          // Send an email
          $page_title = $user->lang['SEND_EMAIL'];
          $template_html = 'memberlist_email.html';

          add_form_key('memberlist_email');

          if (!$config['email_enable'])
          {
             trigger_error('EMAIL_DISABLED');
          }

          if (!$auth->acl_get('u_sendemail'))
          {
             trigger_error('NO_EMAIL');
          }

          // Are we trying to abuse the facility?
          if (time() - $user->data['user_emailtime'] < $config['flood_interval'])
          {
             trigger_error('FLOOD_EMAIL_LIMIT');
          }

          // Determine action...
          $user_id = request_var('u', 0);
          $topic_id = request_var('t', 0);

          // Send email to user...
          if ($user_id)
          {
             if ($user_id == ANONYMOUS || !$config['board_email_form'])
             {
                trigger_error('NO_EMAIL');
             }

             // Get the appropriate username, etc.
             $sql = 'SELECT username, user_email, user_allow_viewemail, user_lang, user_jabber, user_notify_type
                FROM ' . USERS_TABLE . "
                WHERE user_id = $user_id
                   AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')';
             $result = $db->sql_query($sql);
             $row = $db->sql_fetchrow($result);
             $db->sql_freeresult($result);

             if (!$row)
             {
                trigger_error('NO_USER');
             }

             // Can we send email to this user?
             if (!$row['user_allow_viewemail'] && !$auth->acl_get('a_user'))
             {
                trigger_error('NO_EMAIL');
             }
          }
          else if ($topic_id)
          {
             // Send topic heads-up to email address
             $sql = 'SELECT forum_id, topic_title
                FROM ' . TOPICS_TABLE . "
                WHERE topic_id = $topic_id";
             $result = $db->sql_query($sql);
             $row = $db->sql_fetchrow($result);
             $db->sql_freeresult($result);

             if (!$row)
             {
                trigger_error('NO_TOPIC');
             }

             if ($row['forum_id'])
             {
                if (!$auth->acl_get('f_read', $row['forum_id']))
                {
                   trigger_error('SORRY_AUTH_READ');
                }

                if (!$auth->acl_get('f_email', $row['forum_id']))
                {
                   trigger_error('NO_EMAIL');
                }
             }
             else
             {
                // If global announcement, we need to check if the user is able to at least read and email in one forum...
                if (!$auth->acl_getf_global('f_read'))
                {
                   trigger_error('SORRY_AUTH_READ');
                }

                if (!$auth->acl_getf_global('f_email'))
                {
                   trigger_error('NO_EMAIL');
                }
             }
          }
          else
          {
             trigger_error('NO_EMAIL');
          }

          $error = array();

          $name      = utf8_normalize_nfc(request_var('name', '', true));
          $email      = request_var('email', '');
          $email_lang = request_var('lang', $config['default_lang']);
          $subject   = utf8_normalize_nfc(request_var('subject', '', true));
          $message   = utf8_normalize_nfc(request_var('message', '', true));
          $cc         = (isset($_POST['cc_email'])) ? true : false;
          $submit      = (isset($_POST['submit'])) ? true : false;

          if ($submit)
          {
             if (!check_form_key('memberlist_email'))
             {
                $error[] = 'FORM_INVALID';
             }
             if ($user_id)
             {
                if (!$subject)
                {
                   $error[] = $user->lang['EMPTY_SUBJECT_EMAIL'];
                }

                if (!$message)
                {
                   $error[] = $user->lang['EMPTY_MESSAGE_EMAIL'];
                }

                $name = $row['username'];
                $email_lang = $row['user_lang'];
                $email = $row['user_email'];
             }
             else
             {
                if (!$email || !preg_match('/^' . get_preg_expression('email') . '$/i', $email))
                {
                   $error[] = $user->lang['EMPTY_ADDRESS_EMAIL'];
                }

                if (!$name)
                {
                   $error[] = $user->lang['EMPTY_NAME_EMAIL'];
                }
             }

             if (!sizeof($error))
             {
                $sql = 'UPDATE ' . USERS_TABLE . '
                   SET user_emailtime = ' . time() . '
                   WHERE user_id = ' . $user->data['user_id'];
                $result = $db->sql_query($sql);

                include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);
                $messenger = new messenger(false);
                $email_tpl = ($user_id) ? 'profile_send_email' : 'email_notify';

                $mail_to_users = array();

                $mail_to_users[] = array(
                   'email_lang'      => $email_lang,
                   'email'            => $email,
                   'name'            => $name,
                   'username'         => ($user_id) ? $row['username'] : '',
                   'to_name'         => $name,
                   'user_jabber'      => ($user_id) ? $row['user_jabber'] : '',
                   'user_notify_type'   => ($user_id) ? $row['user_notify_type'] : NOTIFY_EMAIL,
                   'topic_title'      => (!$user_id) ? $row['topic_title'] : '',
                   'forum_id'         => (!$user_id) ? $row['forum_id'] : 0,
                );

                // Ok, now the same email if CC specified, but without exposing the users email address
                if ($cc)
                {
                   $mail_to_users[] = array(
                      'email_lang'      => $user->data['user_lang'],
                      'email'            => $user->data['user_email'],
                      'name'            => $user->data['username'],
                      'username'         => $user->data['username'],
                      'to_name'         => $name,
                      'user_jabber'      => $user->data['user_jabber'],
                      'user_notify_type'   => ($user_id) ? $user->data['user_notify_type'] : NOTIFY_EMAIL,
                      'topic_title'      => (!$user_id) ? $row['topic_title'] : '',
                      'forum_id'         => (!$user_id) ? $row['forum_id'] : 0,
                   );
                }

                foreach ($mail_to_users as $row)
                {
                   $messenger->template($email_tpl, $row['email_lang']);
                   $messenger->replyto($user->data['user_email']);
                   $messenger->to($row['email'], $row['name']);

                   if ($user_id)
                   {
                      $messenger->subject(htmlspecialchars_decode($subject));
                      $messenger->im($row['user_jabber'], $row['username']);
                      $notify_type = $row['user_notify_type'];
                   }
                   else
                   {
                      $notify_type = NOTIFY_EMAIL;
                   }

                   $messenger->headers('X-AntiAbuse: Board servername - ' . $config['server_name']);
                   $messenger->headers('X-AntiAbuse: User_id - ' . $user->data['user_id']);
                   $messenger->headers('X-AntiAbuse: Username - ' . $user->data['username']);
                   $messenger->headers('X-AntiAbuse: User IP - ' . $user->ip);

                   $messenger->assign_vars(array(
                      'BOARD_CONTACT'   => $config['board_contact'],
                      'TO_USERNAME'   => htmlspecialchars_decode($row['to_name']),
                      'FROM_USERNAME'   => htmlspecialchars_decode($user->data['username']),
                      'MESSAGE'      => htmlspecialchars_decode($message))
                   );

                   if ($topic_id)
                   {
                      $messenger->assign_vars(array(
                         'TOPIC_NAME'   => htmlspecialchars_decode($row['topic_title']),
                         'U_TOPIC'      => generate_board_url() . "/viewtopic.$phpEx?f=" . $row['forum_id'] . "&t=$topic_id")
                      );
                   }

                   $messenger->send($notify_type);
                }

                meta_refresh(3, append_sid("{$phpbb_root_path}index.$phpEx"));
                $message = ($user_id) ? sprintf($user->lang['RETURN_INDEX'], '<a href="' . append_sid("{$phpbb_root_path}index.$phpEx") . '">', '</a>') : sprintf($user->lang['RETURN_TOPIC'],  '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f={$row['forum_id']}&t=$topic_id") . '">', '</a>');
                trigger_error($user->lang['EMAIL_SENT'] . '<br /><br />' . $message);
             }
          }

          if ($user_id)
          {
             $template->assign_vars(array(
                'S_SEND_USER'   => true,
                'USERNAME'      => $row['username'],

                'L_EMAIL_BODY_EXPLAIN'   => $user->lang['EMAIL_BODY_EXPLAIN'],
                'S_POST_ACTION'         => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=email&u=' . $user_id))
             );
          }
          else
          {
             $template->assign_vars(array(
                'EMAIL'            => $email,
                'NAME'            => $name,
                'S_LANG_OPTIONS'   => language_select($email_lang),

                'L_EMAIL_BODY_EXPLAIN'   => $user->lang['EMAIL_TOPIC_EXPLAIN'],
                'S_POST_ACTION'         => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=email&t=' . $topic_id))
             );
          }

          $template->assign_vars(array(
             'ERROR_MESSAGE'      => (sizeof($error)) ? implode('<br />', $error) : '')
          );

       break;

       case 'group':
       default:
          // The basic memberlist
          $page_title = $user->lang['MEMBERLIST'];
          $template_html = 'memberlist_body.html';

          // Sorting
          $sort_key_text = array('a' => $user->lang['SORT_USERNAME'], 'b' => $user->lang['SORT_LOCATION'], 'c' => $user->lang['SORT_JOINED'], 'd' => $user->lang['SORT_POST_COUNT'], 'f' => $user->lang['WEBSITE'], 'g' => $user->lang['ICQ'], 'h' => $user->lang['AIM'], 'i' => $user->lang['MSNM'], 'j' => $user->lang['YIM'], 'k' => $user->lang['JABBER']);
          $sort_key_sql = array('a' => 'u.username_clean', 'b' => 'u.user_from', 'c' => 'u.user_regdate', 'd' => 'u.user_posts', 'f' => 'u.user_website', 'g' => 'u.user_icq', 'h' => 'u.user_aim', 'i' => 'u.user_msnm', 'j' => 'u.user_yim', 'k' => 'u.user_jabber');

          if ($auth->acl_get('a_user'))
          {
             $sort_key_text['e'] = $user->lang['SORT_EMAIL'];
             $sort_key_sql['e'] = 'u.user_email';
          }

          if ($auth->acl_get('u_viewonline'))
          {
             $sort_key_text['l'] = $user->lang['SORT_LAST_ACTIVE'];
             $sort_key_sql['l'] = 'u.user_lastvisit';
          }

          $sort_key_text['m'] = $user->lang['SORT_RANK'];
          $sort_key_sql['m'] = 'u.user_rank';

          $sort_dir_text = array('a' => $user->lang['ASCENDING'], 'd' => $user->lang['DESCENDING']);

          $s_sort_key = '';
          foreach ($sort_key_text as $key => $value)
          {
             $selected = ($sort_key == $key) ? ' selected="selected"' : '';
             $s_sort_key .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>';
          }

          $s_sort_dir = '';
          foreach ($sort_dir_text as $key => $value)
          {
             $selected = ($sort_dir == $key) ? ' selected="selected"' : '';
             $s_sort_dir .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>';
          }

          // Additional sorting options for user search ... if search is enabled, if not
          // then only admins can make use of this (for ACP functionality)
          $sql_select = $sql_where_data = $sql_from = $sql_where = $order_by = '';


          $form         = request_var('form', '');
          $field         = request_var('field', '');
          $select_single    = request_var('select_single', false);

          // We validate form and field here, only id/class allowed
          $form = (!preg_match('/^[a-z0-9_-]+$/i', $form)) ? '' : $form;
          $field = (!preg_match('/^[a-z0-9_-]+$/i', $field)) ? '' : $field;
          if ($mode == 'searchuser' && ($config['load_search'] || $auth->acl_get('a_')))
          {
             $username   = request_var('username', '', true);
             $email      = strtolower(request_var('email', ''));
             $icq      = request_var('icq', '');
             $aim      = request_var('aim', '');
             $yahoo      = request_var('yahoo', '');
             $msn      = request_var('msn', '');
             $jabber      = request_var('jabber', '');
             $search_group_id   = request_var('search_group_id', 0);

             $joined_select   = request_var('joined_select', 'lt');
             $active_select   = request_var('active_select', 'lt');
             $count_select   = request_var('count_select', 'eq');
             $joined         = explode('-', request_var('joined', ''));
             $active         = explode('-', request_var('active', ''));
             $count         = (request_var('count', '') !== '') ? request_var('count', 0) : '';
             $ipdomain      = request_var('ip', '');

             $find_key_match = array('lt' => '<', 'gt' => '>', 'eq' => '=');

             $find_count = array('lt' => $user->lang['LESS_THAN'], 'eq' => $user->lang['EQUAL_TO'], 'gt' => $user->lang['MORE_THAN']);
             $s_find_count = '';
             foreach ($find_count as $key => $value)
             {
                $selected = ($count_select == $key) ? ' selected="selected"' : '';
                $s_find_count .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>';
             }

             $find_time = array('lt' => $user->lang['BEFORE'], 'gt' => $user->lang['AFTER']);
             $s_find_join_time = '';
             foreach ($find_time as $key => $value)
             {
                $selected = ($joined_select == $key) ? ' selected="selected"' : '';
                $s_find_join_time .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>';
             }

             $s_find_active_time = '';
             foreach ($find_time as $key => $value)
             {
                $selected = ($active_select == $key) ? ' selected="selected"' : '';
                $s_find_active_time .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>';
             }

             $sql_where .= ($username) ? ' AND u.username_clean ' . $db->sql_like_expression(str_replace('*', $db->any_char, utf8_clean_string($username))) : '';
             $sql_where .= ($auth->acl_get('a_user') && $email) ? ' AND u.user_email ' . $db->sql_like_expression(str_replace('*', $db->any_char, $email)) . ' ' : '';
             $sql_where .= ($icq) ? ' AND u.user_icq ' . $db->sql_like_expression(str_replace('*', $db->any_char, $icq)) . ' ' : '';
             $sql_where .= ($aim) ? ' AND u.user_aim ' . $db->sql_like_expression(str_replace('*', $db->any_char, $aim)) . ' ' : '';
             $sql_where .= ($yahoo) ? ' AND u.user_yim ' . $db->sql_like_expression(str_replace('*', $db->any_char, $yahoo)) . ' ' : '';
             $sql_where .= ($msn) ? ' AND u.user_msnm ' . $db->sql_like_expression(str_replace('*', $db->any_char, $msn)) . ' ' : '';
             $sql_where .= ($jabber) ? ' AND u.user_jabber ' . $db->sql_like_expression(str_replace('*', $db->any_char, $jabber)) . ' ' : '';
             $sql_where .= (is_numeric($count)) ? ' AND u.user_posts ' . $find_key_match[$count_select] . ' ' . (int) $count . ' ' : '';
             $sql_where .= (sizeof($joined) > 1) ? " AND u.user_regdate " . $find_key_match[$joined_select] . ' ' . gmmktime(0, 0, 0, intval($joined[1]), intval($joined[2]), intval($joined[0])) : '';
             $sql_where .= ($auth->acl_get('u_viewonline') && sizeof($active) > 1) ? " AND u.user_lastvisit " . $find_key_match[$active_select] . ' ' . gmmktime(0, 0, 0, $active[1], intval($active[2]), intval($active[0])) : '';
             $sql_where .= ($search_group_id) ? " AND u.user_id = ug.user_id AND ug.group_id = $search_group_id AND ug.user_pending = 0 " : '';

             if ($search_group_id)
             {
                $sql_from = ', ' . USER_GROUP_TABLE . ' ug ';
             }

             if ($ipdomain && $auth->acl_getf_global('m_info'))
             {
                if (strspn($ipdomain, 'abcdefghijklmnopqrstuvwxyz'))
                {
                   $hostnames = gethostbynamel($ipdomain);

                   if ($hostnames !== false)
                   {
                      $ips = "'" . implode('\', \'', array_map(array($db, 'sql_escape'), preg_replace('#([0-9]{1,3}\.[0-9]{1,3}[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3})#', "\\1", gethostbynamel($ipdomain)))) . "'";
                   }
                   else
                   {
                      $ips = false;
                   }
                }
                else
                {
                   $ips = "'" . str_replace('*', '%', $db->sql_escape($ipdomain)) . "'";
                }

                if ($ips === false)
                {
                   // A minor fudge but it does the job :D
                   $sql_where .= " AND u.user_id = 0";
                }
                else
                {
                   $ip_forums = array_keys($auth->acl_getf('m_info', true));

                   $sql = 'SELECT DISTINCT poster_id
                      FROM ' . POSTS_TABLE . '
                      WHERE poster_ip ' . ((strpos($ips, '%') !== false) ? 'LIKE' : 'IN') . " ($ips)
                         AND forum_id IN (0, " . implode(', ', $ip_forums) . ')';
                   $result = $db->sql_query($sql);

                   if ($row = $db->sql_fetchrow($result))
                   {
                      $ip_sql = array();
                      do
                      {
                         $ip_sql[] = $row['poster_id'];
                      }
                      while ($row = $db->sql_fetchrow($result));

                      $sql_where .= ' AND ' . $db->sql_in_set('u.user_id', $ip_sql);
                   }
                   else
                   {
                      // A minor fudge but it does the job :D
                      $sql_where .= " AND u.user_id = 0";
                   }
                   unset($ip_forums);

                   $db->sql_freeresult($result);
                }
             }
          }

          $first_char = request_var('first_char', '');

          if ($first_char == 'other')
          {
             for ($i = 97; $i < 123; $i++)
             {
                $sql_where .= ' AND u.username_clean NOT ' . $db->sql_like_expression(chr($i) . $db->any_char);
             }
          }
          else if ($first_char)
          {
             $sql_where .= ' AND u.username_clean ' . $db->sql_like_expression(substr($first_char, 0, 1) . $db->any_char);
          }

          // Are we looking at a usergroup? If so, fetch additional info
          // and further restrict the user info query
          if ($mode == 'group')
          {
             // We JOIN here to save a query for determining membership for hidden groups. ;)
             $sql = 'SELECT g.*, ug.user_id
                FROM ' . GROUPS_TABLE . ' g
                LEFT JOIN ' . USER_GROUP_TABLE . ' ug ON (ug.user_pending = 0 AND ug.user_id = ' . $user->data['user_id'] . " AND ug.group_id = $group_id)
                WHERE g.group_id = $group_id";
             $result = $db->sql_query($sql);
             $group_row = $db->sql_fetchrow($result);
             $db->sql_freeresult($result);

             if (!$group_row)
             {
                trigger_error('NO_GROUP');
             }

             switch ($group_row['group_type'])
             {
                case GROUP_OPEN:
                   $group_row['l_group_type'] = 'OPEN';
                break;

                case GROUP_CLOSED:
                   $group_row['l_group_type'] = 'CLOSED';
                break;

                case GROUP_HIDDEN:
                   $group_row['l_group_type'] = 'HIDDEN';

                   // Check for membership or special permissions
                   if (!$auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel') && $group_row['user_id'] != $user->data['user_id'])
                   {
                      trigger_error('NO_GROUP');
                   }
                break;

                case GROUP_SPECIAL:
                   $group_row['l_group_type'] = 'SPECIAL';
                break;

                case GROUP_FREE:
                   $group_row['l_group_type'] = 'FREE';
                break;
             }

             // Misusing the avatar function for displaying group avatars...
             $avatar_img = get_user_avatar($group_row['group_avatar'], $group_row['group_avatar_type'], $group_row['group_avatar_width'], $group_row['group_avatar_height'], 'GROUP_AVATAR');

             $rank_title = $rank_img = $rank_img_src = '';
             if ($group_row['group_rank'])
             {
                if (isset($ranks['special'][$group_row['group_rank']]))
                {
                   $rank_title = $ranks['special'][$group_row['group_rank']]['rank_title'];
                }
                $rank_img = (!empty($ranks['special'][$group_row['group_rank']]['rank_image'])) ? '<img src="' . $config['ranks_path'] . '/' . $ranks['special'][$group_row['group_rank']]['rank_image'] . '" alt="' . $ranks['special'][$group_row['group_rank']]['rank_title'] . '" title="' . $ranks['special'][$group_row['group_rank']]['rank_title'] . '" /><br />' : '';
                $rank_img_src = (!empty($ranks['special'][$group_row['group_rank']]['rank_image'])) ? $config['ranks_path'] . '/' . $ranks['special'][$group_row['group_rank']]['rank_image'] : '';
             }
             else
             {
                $rank_title = '';
                $rank_img = '';
                $rank_img_src = '';
             }

             $template->assign_vars(array(
                'GROUP_DESC'   => generate_text_for_display($group_row['group_desc'], $group_row['group_desc_uid'], $group_row['group_desc_bitfield'], $group_row['group_desc_options']),
                'GROUP_NAME'   => ($group_row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $group_row['group_name']] : $group_row['group_name'],
                'GROUP_COLOR'   => $group_row['group_colour'],
                'GROUP_TYPE'   => $user->lang['GROUP_IS_' . $group_row['l_group_type']],
                'GROUP_RANK'   => $rank_title,

                'AVATAR_IMG'   => $avatar_img,
                'RANK_IMG'      => $rank_img,
                'RANK_IMG_SRC'   => $rank_img_src,

                'U_PM'         => ($auth->acl_get('u_sendpm') && $auth->acl_get('u_masspm') && $group_row['group_receive_pm'] && $config['allow_privmsg'] && $config['allow_mass_pm']) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&mode=compose&g=' . $group_id) : '',)
             );

             $sql_select = ', ug.group_leader';
             $sql_from = ', ' . USER_GROUP_TABLE . ' ug ';
             $order_by = 'ug.group_leader DESC, ';

             $sql_where .= " AND ug.user_pending = 0 AND u.user_id = ug.user_id AND ug.group_id = $group_id";
             $sql_where_data = " AND u.user_id = ug.user_id AND ug.group_id = $group_id";
          }
          
          // Sorting and order
          if (!isset($sort_key_sql[$sort_key]))
          {
             $sort_key = $default_key;
          }

          $order_by .= $sort_key_sql[$sort_key] . ' ' . (($sort_dir == 'a') ? 'ASC' : 'DESC');

          // Unfortunately we must do this here for sorting by rank, else the sort order is applied wrongly
          if ($sort_key == 'm')
          {
             $order_by .= ', u.user_posts DESC';
          }

          // Count the users ...
          if ($sql_where)
          {
             $sql = 'SELECT COUNT(u.user_id) AS total_users
                FROM ' . USERS_TABLE . " u$sql_from
                WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ")
                $sql_where";
             $result = $db->sql_query($sql);
             $total_users = (int) $db->sql_fetchfield('total_users');
             $db->sql_freeresult($result);
          }
          else
          {
             $total_users = $config['num_users'];
          }

          $s_char_options = '<option value=""' . ((!$first_char) ? ' selected="selected"' : '') . '>&nbsp; &nbsp;</option>';
          for ($i = 97; $i < 123; $i++)
          {
             $s_char_options .= '<option value="' . chr($i) . '"' . (($first_char == chr($i)) ? ' selected="selected"' : '') . '>' . chr($i-32) . '</option>';
          }
          $s_char_options .= '<option value="other"' . (($first_char == 'other') ? ' selected="selected"' : '') . '>' . $user->lang['OTHER'] . '</option>';

          // Build a relevant pagination_url
          $params = $sort_params = array();

          // We do not use request_var() here directly to save some calls (not all variables are set)
          $check_params = array(
             'g'            => array('g', 0),
             'sk'         => array('sk', $default_key),
             'sd'         => array('sd', 'a'),
             'form'         => array('form', ''),
             'field'         => array('field', ''),
             'select_single'   => array('select_single', $select_single),
             'username'      => array('username', '', true),
             'email'         => array('email', ''),
             'icq'         => array('icq', ''),
             'aim'         => array('aim', ''),
             'yahoo'         => array('yahoo', ''),
             'msn'         => array('msn', ''),
             'jabber'      => array('jabber', ''),
             'search_group_id'   => array('search_group_id', 0),
             'joined_select'   => array('joined_select', 'lt'),
             'active_select'   => array('active_select', 'lt'),
             'count_select'   => array('count_select', 'eq'),
             'joined'      => array('joined', ''),
             'active'      => array('active', ''),
             'count'         => (request_var('count', '') !== '') ? array('count', 0) : array('count', ''),
             'ipdomain'      => array('ip', ''),
             'first_char'   => array('first_char', ''),
          );

          foreach ($check_params as $key => $call)
          {
             if (!isset($_REQUEST[$key]))
             {
                continue;
             }

             $param = call_user_func_array('request_var', $call);
             $param = urlencode($key) . '=' . ((is_string($param)) ? urlencode($param) : $param);
             $params[] = $param;

             if ($key != 'sk' && $key != 'sd')
             {
                $sort_params[] = $param;
             }
          }

          $u_hide_find_member = append_sid("{$phpbb_root_path}memberlist.$phpEx", implode('&', $params));

          $params[] = "mode=$mode";
          $sort_params[] = "mode=$mode";
          $pagination_url = append_sid("{$phpbb_root_path}memberlist.$phpEx", implode('&', $params));
          $sort_url = append_sid("{$phpbb_root_path}memberlist.$phpEx", implode('&', $sort_params));

          unset($params, $sort_params);

          // Some search user specific data
          if ($mode == 'searchuser' && ($config['load_search'] || $auth->acl_get('a_')))
          {
             $group_selected = request_var('search_group_id', 0);
             $s_group_select = '<option value="0"' . ((!$group_selected) ? ' selected="selected"' : '') . '>&nbsp;</option>';
             $group_ids = array();

             if ($auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel'))
             {
                $sql = 'SELECT group_id, group_name, group_type
                   FROM ' . GROUPS_TABLE . '
                   ORDER BY group_name ASC';
             }
             else
             {
                $sql = 'SELECT g.group_id, g.group_name, g.group_type
                   FROM ' . GROUPS_TABLE . ' g
                   LEFT JOIN ' . USER_GROUP_TABLE . ' ug
                      ON (
                         g.group_id = ug.group_id
                         AND ug.user_id = ' . $user->data['user_id'] . '
                         AND ug.user_pending = 0
                      )
                   WHERE (g.group_type <> ' . GROUP_HIDDEN . ' OR ug.user_id = ' . $user->data['user_id'] . ')
                   ORDER BY g.group_name ASC';
             }
             $result = $db->sql_query($sql);

             while ($row = $db->sql_fetchrow($result))
             {
                $group_ids[] = $row['group_id'];
                $s_group_select .= '<option value="' . $row['group_id'] . '"' . (($group_selected == $row['group_id']) ? ' selected="selected"' : '') . '>' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';
             }
             $db->sql_freeresult($result);

             if ($group_selected !== 0 && !in_array($group_selected, $group_ids))
             {
                trigger_error('NO_GROUP');
             }

             $template->assign_vars(array(
                'USERNAME'   => $username,
                'EMAIL'      => $email,
                'ICQ'      => $icq,
                'AIM'      => $aim,
                'YAHOO'      => $yahoo,
                'MSNM'      => $msn,
                'JABBER'   => $jabber,
                'JOINED'   => implode('-', $joined),
                'ACTIVE'   => implode('-', $active),
                'COUNT'      => $count,
                'IP'      => $ipdomain,

                'S_IP_SEARCH_ALLOWED'   => ($auth->acl_getf_global('m_info')) ? true : false,
                'S_EMAIL_SEARCH_ALLOWED'=> ($auth->acl_get('a_user')) ? true : false,
                'S_IN_SEARCH_POPUP'      => ($form && $field) ? true : false,
                'S_SEARCH_USER'         => true,
                'S_FORM_NAME'         => $form,
                'S_FIELD_NAME'         => $field,
                'S_SELECT_SINGLE'      => $select_single,
                'S_COUNT_OPTIONS'      => $s_find_count,
                'S_SORT_OPTIONS'      => $s_sort_key,
                'S_JOINED_TIME_OPTIONS'   => $s_find_join_time,
                'S_ACTIVE_TIME_OPTIONS'   => $s_find_active_time,
                'S_GROUP_SELECT'      => $s_group_select,
                'S_USER_SEARCH_ACTION'   => append_sid("{$phpbb_root_path}memberlist.$phpEx", "mode=searchuser&form=$form&field=$field"))
             );
          }

          // Get us some users :D
          $sql = "SELECT u.user_id
             FROM " . USERS_TABLE . " u
                $sql_from
             WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ")
                $sql_where
             ORDER BY $order_by";
          $result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);

          $user_list = array();
          while ($row = $db->sql_fetchrow($result))
          {
             $user_list[] = (int) $row['user_id'];
          }
          $db->sql_freeresult($result);

          // So, did we get any users?
          if (sizeof($user_list))
          {
             // Session time?! Session time...
             $sql = 'SELECT session_user_id, MAX(session_time) AS session_time
                FROM ' . SESSIONS_TABLE . '
                WHERE session_time >= ' . (time() - $config['session_length']) . '
                   AND ' . $db->sql_in_set('session_user_id', $user_list) . '
                GROUP BY session_user_id';
             $result = $db->sql_query($sql);

             $session_times = array();
             while ($row = $db->sql_fetchrow($result))
             {
                $session_times[$row['session_user_id']] = $row['session_time'];
             }
             $db->sql_freeresult($result);

             // Do the SQL thang
             if ($mode == 'group')
             {
                $sql = "SELECT u.*
                      $sql_select
                   FROM " . USERS_TABLE . " u
                      $sql_from
                   WHERE " . $db->sql_in_set('u.user_id', $user_list) . "
                      $sql_where_data";
             }
             else
             {
                $sql = 'SELECT *
                   FROM ' . USERS_TABLE . '
                   WHERE ' . $db->sql_in_set('user_id', $user_list);
             }
             $result = $db->sql_query($sql);

             $id_cache = array();
             while ($row = $db->sql_fetchrow($result))
             {
                $row['session_time'] = (!empty($session_times[$row['user_id']])) ? $session_times[$row['user_id']] : 0;
                $row['last_visit'] = (!empty($row['session_time'])) ? $row['session_time'] : $row['user_lastvisit'];

                $id_cache[$row['user_id']] = $row;
             }
             $db->sql_freeresult($result);

             // Load custom profile fields
             if ($config['load_cpf_memberlist'])
             {
                include_once($phpbb_root_path . 'includes/functions_profile_fields.' . $phpEx);
                $cp = new custom_profile();

                // Grab all profile fields from users in id cache for later use - similar to the poster cache
                $profile_fields_cache = $cp->generate_profile_fields_template('grab', $user_list);
             }

             // If we sort by last active date we need to adjust the id cache due to user_lastvisit not being the last active date...
             if ($sort_key == 'l')
             {
                $lesser_than = ($sort_dir == 'a') ? -1 : 1;
    //            uasort($id_cache, create_function('$first, $second', "return (\$first['last_visit'] == \$second['last_visit']) ? 0 : ((\$first['last_visit'] < \$second['last_visit']) ? $lesser_than : ($lesser_than * -1));"));
                usort($user_list, create_function('$first, $second', "global \$id_cache; return (\$id_cache[\$first]['last_visit'] == \$id_cache[\$second]['last_visit']) ? 0 : ((\$id_cache[\$first]['last_visit'] < \$id_cache[\$second]['last_visit']) ? $lesser_than : ($lesser_than * -1));"));
             }

             for ($i = 0, $end = sizeof($user_list); $i < $end; ++$i)
             {
                $user_id = $user_list[$i];
                $row =& $id_cache[$user_id];

                $cp_row = array();
                if ($config['load_cpf_memberlist'])
                {
                   $cp_row = (isset($profile_fields_cache[$user_id])) ? $cp->generate_profile_fields_template('show', false, $profile_fields_cache[$user_id]) : array();
                }

                $memberrow = array_merge(show_profile($row), array(
                   'ROW_NUMBER'      => $i + ($start + 1),

                   'S_CUSTOM_PROFILE'   => (isset($cp_row['row']) && sizeof($cp_row['row'])) ? true : false,
                   'S_GROUP_LEADER'   => (isset($row['group_leader']) && $row['group_leader']) ? true : false,

                   'U_VIEW_PROFILE'   => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&u=' . $user_id))
                );

                if (isset($cp_row['row']) && sizeof($cp_row['row']))
                {
                   $memberrow = array_merge($memberrow, $cp_row['row']);
                }

                $template->assign_block_vars('memberrow', $memberrow);

                if (isset($cp_row['blockrow']) && sizeof($cp_row['blockrow']))
                {
                   foreach ($cp_row['blockrow'] as $field_data)
                   {
                      $template->assign_block_vars('memberrow.custom_fields', $field_data);
                   }
                }

                unset($id_cache[$user_id]);
             }
          }

          // Generate page
          $template->assign_vars(array(
             'PAGINATION'   => generate_pagination($pagination_url, $total_users, $config['topics_per_page'], $start),
             'PAGE_NUMBER'   => on_page($total_users, $config['topics_per_page'], $start),
             'TOTAL_USERS'   => ($total_users == 1) ? $user->lang['LIST_USER'] : sprintf($user->lang['LIST_USERS'], $total_users),

             'PROFILE_IMG'   => $user->img('icon_user_profile', $user->lang['PROFILE']),
             'PM_IMG'      => $user->img('icon_contact_pm', $user->lang['SEND_PRIVATE_MESSAGE']),
             'EMAIL_IMG'      => $user->img('icon_contact_email', $user->lang['EMAIL']),
             'WWW_IMG'      => $user->img('icon_contact_www', $user->lang['WWW']),
             'ICQ_IMG'      => $user->img('icon_contact_icq', $user->lang['ICQ']),
             'AIM_IMG'      => $user->img('icon_contact_aim', $user->lang['AIM']),
             'MSN_IMG'      => $user->img('icon_contact_msnm', $user->lang['MSNM']),
             'YIM_IMG'      => $user->img('icon_contact_yahoo', $user->lang['YIM']),
             'JABBER_IMG'   => $user->img('icon_contact_jabber', $user->lang['JABBER']),
             'SEARCH_IMG'   => $user->img('icon_user_search', $user->lang['SEARCH']),

             'U_FIND_MEMBER'         => ($config['load_search'] || $auth->acl_get('a_')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser') : '',
             'U_HIDE_FIND_MEMBER'   => ($mode == 'searchuser') ? $u_hide_find_member : '',
             'U_SORT_USERNAME'      => $sort_url . '&sk=a&sd=' . (($sort_key == 'a' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_FROM'         => $sort_url . '&sk=b&sd=' . (($sort_key == 'b' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_JOINED'         => $sort_url . '&sk=c&sd=' . (($sort_key == 'c' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_POSTS'         => $sort_url . '&sk=d&sd=' . (($sort_key == 'd' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_EMAIL'         => $sort_url . '&sk=e&sd=' . (($sort_key == 'e' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_WEBSITE'      => $sort_url . '&sk=f&sd=' . (($sort_key == 'f' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_LOCATION'      => $sort_url . '&sk=b&sd=' . (($sort_key == 'b' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_ICQ'         => $sort_url . '&sk=g&sd=' . (($sort_key == 'g' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_AIM'         => $sort_url . '&sk=h&sd=' . (($sort_key == 'h' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_MSN'         => $sort_url . '&sk=i&sd=' . (($sort_key == 'i' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_YIM'         => $sort_url . '&sk=j&sd=' . (($sort_key == 'j' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_ACTIVE'         => ($auth->acl_get('u_viewonline')) ? $sort_url . '&sk=l&sd=' . (($sort_key == 'l' && $sort_dir == 'a') ? 'd' : 'a') : '',
             'U_SORT_RANK'         => $sort_url . '&sk=m&sd=' . (($sort_key == 'm' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_LIST_CHAR'         => $sort_url . '&sk=a&sd=' . (($sort_key == 'l' && $sort_dir == 'a') ? 'd' : 'a'),

             'S_SHOW_GROUP'      => ($mode == 'group') ? true : false,
             'S_VIEWONLINE'      => $auth->acl_get('u_viewonline'),
             'S_MODE_SELECT'      => $s_sort_key,
             'S_ORDER_SELECT'   => $s_sort_dir,
             'S_CHAR_OPTIONS'   => $s_char_options,
             'S_MODE_ACTION'      => $pagination_url)
          );
    }

    // Output the page
    page_header($page_title);

    $template->set_filenames(array(
       'body' => $template_html)
    );
    make_jumpbox(append_sid("{$phpbb_root_path}viewforum.$phpEx"));

    page_footer();

    /**
    * Prepare profile data
    */
    function show_profile($data)
    {
       global $config, $auth, $template, $user, $phpEx, $phpbb_root_path;

       $username = $data['username'];
       $user_id = $data['user_id'];

       $rank_title = $rank_img = $rank_img_src = '';
       get_user_rank($data['user_rank'], $data['user_posts'], $rank_title, $rank_img, $rank_img_src);

       if (!empty($data['user_allow_viewemail']) || $auth->acl_get('a_user'))
       {
          $email = ($config['board_email_form'] && $config['email_enable']) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=email&u=' . $user_id) : (($config['board_hide_emails'] && !$auth->acl_get('a_user')) ? '' : 'mailto:' . $data['user_email']);
       }
       else
       {
          $email = '';
       }

       if ($config['load_onlinetrack'])
       {
          $update_time = $config['load_online_time'] * 60;
          $online = (time() - $update_time < $data['session_time'] && ((isset($data['session_viewonline']) && $data['session_viewonline']) || $auth->acl_get('u_viewonline'))) ? true : false;
       }
       else
       {
          $online = false;
       }

       if ($data['user_allow_viewonline'] || $auth->acl_get('u_viewonline'))
       {
          $last_visit = (!empty($data['session_time'])) ? $data['session_time'] : $data['user_lastvisit'];
       }
       else
       {
          $last_visit = '';
       }

       $age = '';

       if ($config['allow_birthdays'] && $data['user_birthday'])
       {
          list($bday_day, $bday_month, $bday_year) = array_map('intval', explode('-', $data['user_birthday']));

          if ($bday_year)
          {
             $now = getdate(time() + $user->timezone + $user->dst - date('Z'));

             $diff = $now['mon'] - $bday_month;
             if ($diff == 0)
             {
                $diff = ($now['mday'] - $bday_day < 0) ? 1 : 0;
             }
             else
             {
                $diff = ($diff < 0) ? 1 : 0;
             }

             $age = (int) ($now['year'] - $bday_year - $diff);
          }
       }

       // Dump it out to the template
       return array(
          'AGE'         => $age,
          'RANK_TITLE'   => $rank_title,
          'JOINED'      => $user->format_date($data['user_regdate']),
          'VISITED'      => (empty($last_visit)) ? ' - ' : $user->format_date($last_visit),
          'POSTS'         => ($data['user_posts']) ? $data['user_posts'] : 0,
          'WARNINGS'      => isset($data['user_warnings']) ? $data['user_warnings'] : 0,

          'USERNAME_FULL'      => get_username_string('full', $user_id, $username, $data['user_colour']),
          'USERNAME'         => get_username_string('username', $user_id, $username, $data['user_colour']),
          'USER_COLOR'      => get_username_string('colour', $user_id, $username, $data['user_colour']),
          'U_VIEW_PROFILE'   => get_username_string('profile', $user_id, $username, $data['user_colour']),

          'A_USERNAME'      => addslashes(get_username_string('username', $user_id, $username, $data['user_colour'])),

          'AVATAR_IMG'      => get_user_avatar($data['user_avatar'], $data['user_avatar_type'], $data['user_avatar_width'], $data['user_avatar_height']),
          'ONLINE_IMG'      => (!$config['load_onlinetrack']) ? '' : (($online) ? $user->img('icon_user_online', 'ONLINE') : $user->img('icon_user_offline', 'OFFLINE')),
          'S_ONLINE'         => ($config['load_onlinetrack'] && $online) ? true : false,
          'RANK_IMG'         => $rank_img,
          'RANK_IMG_SRC'      => $rank_img_src,
          'ICQ_STATUS_IMG'   => (!empty($data['user_icq'])) ? '<img src="http://web.icq.com/whitepages/online?icq=' . $data['user_icq'] . '&img=5" width="18" height="18" />' : '',
          'S_JABBER_ENABLED'   => ($config['jab_enable']) ? true : false,

          'U_SEARCH_USER'   => ($auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", "author_id=$user_id&sr=posts") : '',
          'U_NOTES'      => $auth->acl_getf_global('m_') ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&mode=user_notes&u=' . $user_id, true, $user->session_id) : '',
          'U_WARN'      => $auth->acl_get('m_warn') ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&mode=warn_user&u=' . $user_id, true, $user->session_id) : '',
          'U_PM'         => ($config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($data['user_allow_pm'] || $auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_'))) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&mode=compose&u=' . $user_id) : '',
          'U_EMAIL'      => $email,
          'U_WWW'         => (!empty($data['user_website'])) ? $data['user_website'] : '',
          'U_ICQ'         => ($data['user_icq']) ? 'http://www.icq.com/people/webmsg.php?to=' . urlencode($data['user_icq']) : '',
          'U_AIM'         => ($data['user_aim'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&action=aim&u=' . $user_id) : '',
          'U_YIM'         => ($data['user_yim']) ? 'http://edit.yahoo.com/config/send_webmesg?.target=' . urlencode($data['user_yim']) . '&.src=pg' : '',
          'U_MSN'         => ($data['user_msnm'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&action=msnm&u=' . $user_id) : '',
          'U_JABBER'      => ($data['user_jabber'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&action=jabber&u=' . $user_id) : '',
          'LOCATION'      => ($data['user_from']) ? $data['user_from'] : '',

          'USER_ICQ'         => $data['user_icq'],
          'USER_AIM'         => $data['user_aim'],
          'USER_YIM'         => $data['user_yim'],
          'USER_MSN'         => $data['user_msnm'],
          'USER_JABBER'      => $data['user_jabber'],
          'USER_JABBER_IMG'   => ($data['user_jabber']) ? $user->img('icon_contact_jabber', $data['user_jabber']) : '',

          'L_VIEWING_PROFILE'   => sprintf($user->lang['VIEWING_PROFILE'], $username),
       );
    }

    ?>

When i want to add a module for the "user" and the "bank" it works but when i open this module, there's nothing. How can i fixe this?

For login:
username: test
password: testtest

Bram
I'm dutch so my english is not verry good, sorry.

ViciousDuck · Post by **ViciousDuck** » Wed Oct 29, 2008 9:46 pm

Hey, I installed this mod awhile ago, and then uninstalled it. When I uninstalled it I deleted the file sin the DB pertaining to it, and deleted all the other files I had edited or uploaded. But still in the UCP there is a tab called UCP_BANK. I tried repairing my database tables via phpmyadmin, and reinstalling phpbb3, to no effect. So I'm pretty sure that at some point some of my DB tables were corrupted, any idea as to what I would need to do to fix it?

John_Locke · Post by **John_Locke** » Thu Oct 30, 2008 9:38 am

Thank you for this nice Mod.
I have a little problem, the Mod is installed ok (i think, no errors).
But i can't turn off the "Donate" Settings, it is still avaiable but in the admin section it's turned off for "cash".
Also the sort for cash in the member-list didn't work for me, so i removed it from member-list and profile page.
Any idea?

Edit: Ahh, the member list error looks like a known bug.... ok, then i wait for a update.
Is the Donate-Prob also a known bug?

fimo · Post by **fimo** » Thu Oct 30, 2008 10:57 am

Hey,

Is it possible to reset/zero all the cash at once for all my users ?

And if yes, how can i do it ?

Use phbb3 + cash mod 1.0.0 beta 1

francebramie · Post by **francebramie** » Thu Oct 30, 2008 5:33 pm

francebramie wrote:Forum = http://forums.gamebeach.nl/

I have installed a cash modification. (viewtopic.php?f=70&t=547021). But there is a problem in the profile! http://forums.gamebeach.nl/memberlist.p ... rofile&u=2 how can i fixe it?

Memberlist.php:

Code: Select all

    <?php
    /**
    *
    * @package phpBB3
    * @version $Id: memberlist.php 8645 2008-06-10 14:37:38Z acydburn $
    * @copyright (c) 2005 phpBB Group
    * @license http://opensource.org/licenses/gpl-license.php GNU Public License
    *
    */

    /**
    * @ignore
    */
    define('IN_PHPBB', true);
    define('IN_CASHMOD', true);
    define('CM_MEMBERLIST', true);

    $phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
    $phpEx = substr(strrchr(__FILE__, '.'), 1);
    include($phpbb_root_path . 'common.' . $phpEx);
    include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

    // Start session management
    $user->session_begin();
    $auth->acl($user->data);
    $user->setup(array('memberlist', 'groups'));

    // Grab data
    $mode      = request_var('mode', '');
    $action      = request_var('action', '');
    $user_id   = request_var('u', ANONYMOUS);
    $username   = request_var('un', '', true);
    $group_id   = request_var('g', 0);
    $topic_id   = request_var('t', 0);

    // Check our mode...
    if (!in_array($mode, array('', 'group', 'viewprofile', 'email', 'contact', 'searchuser', 'leaders')))
    {
       trigger_error('NO_MODE');
    }

    switch ($mode)
    {
       case 'email':
       break;

       default:
          // Can this user view profiles/memberlist?
          if (!$auth->acl_gets('u_viewprofile', 'a_user', 'a_useradd', 'a_userdel'))
          {
             if ($user->data['user_id'] != ANONYMOUS)
             {
                trigger_error('NO_VIEW_USERS');
             }

             login_box('', ((isset($user->lang['LOGIN_EXPLAIN_' . strtoupper($mode)])) ? $user->lang['LOGIN_EXPLAIN_' . strtoupper($mode)] : $user->lang['LOGIN_EXPLAIN_MEMBERLIST']));
          }
       break;
    }

    $start   = request_var('start', 0);
    $submit = (isset($_POST['submit'])) ? true : false;

    $default_key = 'c';
    $sort_key = request_var('sk', $default_key);
    $sort_dir = request_var('sd', 'a');


    // Grab rank information for later
    $ranks = $cache->obtain_ranks();


    // What do you want to do today? ... oops, I think that line is taken ...
    switch ($mode)
    {
       case 'leaders':
          // Display a listing of board admins, moderators
          include($phpbb_root_path . 'includes/functions_user.' . $phpEx);

          $page_title = $user->lang['THE_TEAM'];
          $template_html = 'memberlist_leaders.html';

          $user_ary = $auth->acl_get_list(false, array('a_', 'm_'), false);

          $admin_id_ary = $global_mod_id_ary = $mod_id_ary = $forum_id_ary = array();
          foreach ($user_ary as $forum_id => $forum_ary)
          {
             foreach ($forum_ary as $auth_option => $id_ary)
             {
                if (!$forum_id)
                {
                   if ($auth_option == 'a_')
                   {
                      $admin_id_ary = array_merge($admin_id_ary, $id_ary);
                   }
                   else
                   {
                      $global_mod_id_ary = array_merge($global_mod_id_ary, $id_ary);
                   }
                   continue;
                }
                else
                {
                   $mod_id_ary = array_merge($mod_id_ary, $id_ary);
                }

                if ($forum_id)
                {
                   foreach ($id_ary as $id)
                   {
                      $forum_id_ary[$id][] = $forum_id;
                   }
                }
             }
          }

          $admin_id_ary = array_unique($admin_id_ary);
          $global_mod_id_ary = array_unique($global_mod_id_ary);

          $mod_id_ary = array_merge($mod_id_ary, $global_mod_id_ary);
          $mod_id_ary = array_unique($mod_id_ary);

          // Admin group id...
          $sql = 'SELECT group_id
             FROM ' . GROUPS_TABLE . "
             WHERE group_name = 'ADMINISTRATORS'";
          $result = $db->sql_query($sql);
          $admin_group_id = (int) $db->sql_fetchfield('group_id');
          $db->sql_freeresult($result);

          // Get group memberships for the admin id ary...
          $admin_memberships = group_memberships($admin_group_id, $admin_id_ary);

          $admin_user_ids = array();
          
          if (!empty($admin_memberships))
          {
             // ok, we only need the user ids...
             foreach ($admin_memberships as $row)
             {
                $admin_user_ids[$row['user_id']] = true;
             }
          }
          unset($admin_memberships);

          $sql = 'SELECT forum_id, forum_name
             FROM ' . FORUMS_TABLE;
          $result = $db->sql_query($sql);

          $forums = array();
          while ($row = $db->sql_fetchrow($result))
          {
             $forums[$row['forum_id']] = $row['forum_name'];
          }
          $db->sql_freeresult($result);

          $sql = $db->sql_build_query('SELECT', array(
             'SELECT'   => 'u.user_id, u.group_id as default_group, u.username, u.username_clean, u.user_colour, u.user_rank, u.user_posts, u.user_allow_pm, g.group_id, g.group_name, g.group_colour, g.group_type, ug.user_id as ug_user_id',

             'FROM'      => array(
                USERS_TABLE      => 'u',
                GROUPS_TABLE   => 'g'
             ),

             'LEFT_JOIN'   => array(
                array(
                   'FROM'   => array(USER_GROUP_TABLE => 'ug'),
                   'ON'   => 'ug.group_id = g.group_id AND ug.user_pending = 0 AND ug.user_id = ' . $user->data['user_id']
                )
             ),

             'WHERE'      => $db->sql_in_set('u.user_id', array_unique(array_merge($admin_id_ary, $mod_id_ary)), false, true) . '
                AND u.group_id = g.group_id',

             'ORDER_BY'   => 'g.group_name ASC, u.username_clean ASC'
          ));
          $result = $db->sql_query($sql);

          while ($row = $db->sql_fetchrow($result))
          {
             $which_row = (in_array($row['user_id'], $admin_id_ary)) ? 'admin' : 'mod';

             // We sort out admins not within the 'Administrators' group.
             // Else, we will list those as admin only having the permission to view logs for example.
             if ($which_row == 'admin' && empty($admin_user_ids[$row['user_id']]))
             {
                // Remove from admin_id_ary, because the user may be a mod instead
                unset($admin_id_ary[array_search($row['user_id'], $admin_id_ary)]);

                if (!in_array($row['user_id'], $mod_id_ary) && !in_array($row['user_id'], $global_mod_id_ary))
                {
                   continue;
                }
                else
                {
                   $which_row = 'mod';
                }
             }

             $s_forum_select = '';
             $undisclosed_forum = false;

             if (isset($forum_id_ary[$row['user_id']]) && !in_array($row['user_id'], $global_mod_id_ary))
             {
                if ($which_row == 'mod' && sizeof(array_diff(array_keys($forums), $forum_id_ary[$row['user_id']])))
                {
                   foreach ($forum_id_ary[$row['user_id']] as $forum_id)
                   {
                      if (isset($forums[$forum_id]))
                      {
                         if ($auth->acl_get('f_list', $forum_id))
                         {
                            $s_forum_select .= '<option value="">' . $forums[$forum_id] . '</option>';
                         }
                         else
                         {
                            $undisclosed_forum = true;
                         }
                      }
                   }
                }
             }

             // If the mod is only moderating non-viewable forums we skip the user. There is no gain in displaying the person then...
             if (!$s_forum_select && $undisclosed_forum)
             {
    //            $s_forum_select = '<option value="">' . $user->lang['FORUM_UNDISCLOSED'] . '</option>';
                continue;
             }

             // The person is moderating several "public" forums, therefore the person should be listed, but not giving the real group name if hidden.
             if ($row['group_type'] == GROUP_HIDDEN && !$auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel') && $row['ug_user_id'] != $user->data['user_id'])
             {
                $group_name = $user->lang['GROUP_UNDISCLOSED'];
                $u_group = '';
             }
             else
             {
                $group_name = ($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name'];
                $u_group = append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group&g=' . $row['group_id']);
             }

             $rank_title = $rank_img = '';
             get_user_rank($row['user_rank'], $row['user_posts'], $rank_title, $rank_img, $rank_img_src);

             $template->assign_block_vars($which_row, array(
                'USER_ID'      => $row['user_id'],
                'FORUMS'      => $s_forum_select,
                'RANK_TITLE'   => $rank_title,
                'GROUP_NAME'   => $group_name,
                'GROUP_COLOR'   => $row['group_colour'],

                'RANK_IMG'      => $rank_img,
                'RANK_IMG_SRC'   => $rank_img_src,

                'U_GROUP'         => $u_group,
                'U_PM'            => ($config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($row['user_allow_pm'] || $auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_'))) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&mode=compose&u=' . $row['user_id']) : '',

                'USERNAME_FULL'      => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),
                'USERNAME'         => get_username_string('username', $row['user_id'], $row['username'], $row['user_colour']),
                'USER_COLOR'      => get_username_string('colour', $row['user_id'], $row['username'], $row['user_colour']),
                'U_VIEW_PROFILE'   => get_username_string('profile', $row['user_id'], $row['username'], $row['user_colour']),
             ));
          }
          $db->sql_freeresult($result);

          $template->assign_vars(array(
             'PM_IMG'      => $user->img('icon_contact_pm', $user->lang['SEND_PRIVATE_MESSAGE']))
          );
       break;

       case 'contact':

          $page_title = $user->lang['IM_USER'];
          $template_html = 'memberlist_im.html';

          if (!$auth->acl_get('u_sendim'))
          {
             trigger_error('NOT_AUTHORISED');
          }

          $presence_img = '';
          switch ($action)
          {
             case 'aim':
                $lang = 'AIM';
                $sql_field = 'user_aim';
                $s_select = 'S_SEND_AIM';
                $s_action = '';
             break;

             case 'msnm':
                $lang = 'MSNM';
                $sql_field = 'user_msnm';
                $s_select = 'S_SEND_MSNM';
                $s_action = '';
             break;

             case 'jabber':
                $lang = 'JABBER';
                $sql_field = 'user_jabber';
                $s_select = (@extension_loaded('xml') && $config['jab_enable']) ? 'S_SEND_JABBER' : 'S_NO_SEND_JABBER';
                $s_action = append_sid("{$phpbb_root_path}memberlist.$phpEx", "mode=contact&action=$action&u=$user_id");
             break;

             default:
                trigger_error('NO_MODE', E_USER_ERROR);
             break;
          }

          // Grab relevant data
          $sql = "SELECT user_id, username, user_email, user_lang, $sql_field
             FROM " . USERS_TABLE . "
             WHERE user_id = $user_id
                AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')';
          $result = $db->sql_query($sql);
          $row = $db->sql_fetchrow($result);
          $db->sql_freeresult($result);

          if (!$row)
          {
             trigger_error('NO_USER');
          }
          else if (empty($row[$sql_field]))
          {
             trigger_error('IM_NO_DATA');
          }

          // Post data grab actions
          switch ($action)
          {
             case 'jabber':
                add_form_key('memberlist_messaging');

                if ($submit && @extension_loaded('xml') && $config['jab_enable'])
                {
                   if (check_form_key('memberlist_messaging'))
                   {

                      include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

                      $subject = sprintf($user->lang['IM_JABBER_SUBJECT'], $user->data['username'], $config['server_name']);
                      $message = utf8_normalize_nfc(request_var('message', '', true));

                      if (empty($message))
                      {
                         trigger_error('EMPTY_MESSAGE_IM');
                      }

                      $messenger = new messenger(false);

                      $messenger->template('profile_send_im', $row['user_lang']);
                      $messenger->subject(htmlspecialchars_decode($subject));

                      $messenger->replyto($user->data['user_email']);
                      $messenger->im($row['user_jabber'], $row['username']);

                      $messenger->assign_vars(array(
                         'BOARD_CONTACT'   => $config['board_contact'],
                         'FROM_USERNAME'   => htmlspecialchars_decode($user->data['username']),
                         'TO_USERNAME'   => htmlspecialchars_decode($row['username']),
                         'MESSAGE'      => htmlspecialchars_decode($message))
                      );

                      $messenger->send(NOTIFY_IM);

                      $s_select = 'S_SENT_JABBER';
                   }
                   else
                   {
                      trigger_error('FORM_INVALID');
                   }
                }
             break;
          }

          // Send vars to the template
          $template->assign_vars(array(
             'IM_CONTACT'   => $row[$sql_field],
             'A_IM_CONTACT'   => addslashes($row[$sql_field]),

             'U_AIM_CONTACT'   => ($action == 'aim') ? 'aim:addbuddy?screenname=' . urlencode($row[$sql_field]) : '',
             'U_AIM_MESSAGE'   => ($action == 'aim') ? 'aim:goim?screenname=' . urlencode($row[$sql_field]) . '&message=' . urlencode($config['sitename']) : '',

             'USERNAME'      => $row['username'],
             'CONTACT_NAME'   => $row[$sql_field],
             'SITENAME'      => $config['sitename'],

             'PRESENCE_IMG'      => $presence_img,

             'L_SEND_IM_EXPLAIN'   => $user->lang['IM_' . $lang],
             'L_IM_SENT_JABBER'   => sprintf($user->lang['IM_SENT_JABBER'], $row['username']),

             $s_select         => true,
             'S_IM_ACTION'      => $s_action)
          );

       break;

       case 'viewprofile':
          // Display a profile
          if ($user_id == ANONYMOUS && !$username)
          {
             trigger_error('NO_USER');
          }

          // Get user...
          $sql = 'SELECT *
             FROM ' . USERS_TABLE . '
             WHERE ' . (($username) ? "username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'" : "user_id = $user_id");
          $result = $db->sql_query($sql);
          $member = $db->sql_fetchrow($result);
          $db->sql_freeresult($result);

          if (!$member)
          {
             trigger_error('NO_USER');
          }

          // a_user admins and founder are able to view inactive users and bots to be able to manage them more easily
          // Normal users are able to see at least users having only changed their profile settings but not yet reactivated.
          if (!$auth->acl_get('a_user') && $user->data['user_type'] != USER_FOUNDER)
          {
             if ($member['user_type'] == USER_IGNORE)
             {
                trigger_error('NO_USER');
             }
             else if ($member['user_type'] == USER_INACTIVE && $member['user_inactive_reason'] != INACTIVE_PROFILE)
             {
                trigger_error('NO_USER');
             }
          }

          $user_id = (int) $member['user_id'];

          // Do the SQL thang
          $sql = 'SELECT g.group_id, g.group_name, g.group_type
             FROM ' . GROUPS_TABLE . ' g, ' . USER_GROUP_TABLE . " ug
             WHERE ug.user_id = $user_id
                AND g.group_id = ug.group_id" . ((!$auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel')) ? ' AND g.group_type <> ' . GROUP_HIDDEN : '') . '
                AND ug.user_pending = 0
             ORDER BY g.group_type, g.group_name';
          $result = $db->sql_query($sql);

          $group_options = '';
          while ($row = $db->sql_fetchrow($result))
          {
             $group_options .= '<option value="' . $row['group_id'] . '"' . (($row['group_id'] == $member['group_id']) ? ' selected="selected"' : '') . '>' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';
          }
          $db->sql_freeresult($result);

          // What colour is the zebra
          $sql = 'SELECT friend, foe
             FROM ' . ZEBRA_TABLE . "
             WHERE zebra_id = $user_id
                AND user_id = {$user->data['user_id']}";

          $result = $db->sql_query($sql);
          $row = $db->sql_fetchrow($result);
          $foe = ($row['foe']) ? true : false;
          $friend = ($row['friend']) ? true : false;
          $db->sql_freeresult($result);

          if ($config['load_onlinetrack'])
          {
             $sql = 'SELECT MAX(session_time) AS session_time, MIN(session_viewonline) AS session_viewonline
                FROM ' . SESSIONS_TABLE . "
                WHERE session_user_id = $user_id";
             $result = $db->sql_query($sql);
             $row = $db->sql_fetchrow($result);
             $db->sql_freeresult($result);

             $member['session_time'] = (isset($row['session_time'])) ? $row['session_time'] : 0;
             $member['session_viewonline'] = (isset($row['session_viewonline'])) ? $row['session_viewonline'] :   0;
             unset($row);
          }

          if ($config['load_user_activity'])
          {
             display_user_activity($member);
          }

          // Do the relevant calculations
          $memberdays = max(1, round((time() - $member['user_regdate']) / 86400));
          $posts_per_day = $member['user_posts'] / $memberdays;
          $percentage = ($config['num_posts']) ? min(100, ($member['user_posts'] / $config['num_posts']) * 100) : 0;


          if ($member['user_sig'])
          {
             $member['user_sig'] = censor_text($member['user_sig']);

             if ($member['user_sig_bbcode_bitfield'])
             {
                include_once($phpbb_root_path . 'includes/bbcode.' . $phpEx);
                $bbcode = new bbcode();
                $bbcode->bbcode_second_pass($member['user_sig'], $member['user_sig_bbcode_uid'], $member['user_sig_bbcode_bitfield']);
             }

             $member['user_sig'] = bbcode_nl2br($member['user_sig']);
             $member['user_sig'] = smiley_text($member['user_sig']);
          }

          $poster_avatar = get_user_avatar($member['user_avatar'], $member['user_avatar_type'], $member['user_avatar_width'], $member['user_avatar_height']);

          $template->assign_vars(show_profile($member));

          // Custom Profile Fields
          $profile_fields = array();
          if ($config['load_cpf_viewprofile'])
          {
             include_once($phpbb_root_path . 'includes/functions_profile_fields.' . $phpEx);
             $cp = new custom_profile();
             $profile_fields = $cp->generate_profile_fields_template('grab', $user_id);
             $profile_fields = (isset($profile_fields[$user_id])) ? $cp->generate_profile_fields_template('show', false, $profile_fields[$user_id]) : array();
          }

          // We need to check if the module 'zebra' is accessible
          $zebra_enabled = false;

          if ($user->data['user_id'] != $user_id && $user->data['is_registered'])
          {
             include_once($phpbb_root_path . 'includes/functions_module.' . $phpEx);
             $module = new p_master();
             $module->list_modules('ucp');
             $module->set_active('zebra');

             $zebra_enabled = ($module->active_module === false) ? false : true;

             unset($module);
          }

          $template->assign_vars(array(
             'POSTS_DAY'         => sprintf($user->lang['POST_DAY'], $posts_per_day),
             'POSTS_PCT'         => sprintf($user->lang['POST_PCT'], $percentage),

             'OCCUPATION'   => (!empty($member['user_occ'])) ? censor_text($member['user_occ']) : '',
             'INTERESTS'      => (!empty($member['user_interests'])) ? censor_text($member['user_interests']) : '',
             'SIGNATURE'      => $member['user_sig'],

             'AVATAR_IMG'   => $poster_avatar,
             'PM_IMG'      => $user->img('icon_contact_pm', $user->lang['SEND_PRIVATE_MESSAGE']),
             'EMAIL_IMG'      => $user->img('icon_contact_email', $user->lang['EMAIL']),
             'WWW_IMG'      => $user->img('icon_contact_www', $user->lang['WWW']),
             'ICQ_IMG'      => $user->img('icon_contact_icq', $user->lang['ICQ']),
             'AIM_IMG'      => $user->img('icon_contact_aim', $user->lang['AIM']),
             'MSN_IMG'      => $user->img('icon_contact_msnm', $user->lang['MSNM']),
             'YIM_IMG'      => $user->img('icon_contact_yahoo', $user->lang['YIM']),
             'JABBER_IMG'   => $user->img('icon_contact_jabber', $user->lang['JABBER']),
             'SEARCH_IMG'   => $user->img('icon_user_search', $user->lang['SEARCH']),

             'S_PROFILE_ACTION'   => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group'),
             'S_GROUP_OPTIONS'   => $group_options,
             'S_CUSTOM_FIELDS'   => (isset($profile_fields['row']) && sizeof($profile_fields['row'])) ? true : false,

             'U_USER_ADMIN'         => ($auth->acl_get('a_user')) ? append_sid("{$phpbb_root_path}adm/index.$phpEx", 'i=users&mode=overview&u=' . $user_id, true, $user->session_id) : '',
             'U_USER_BAN'         => ($auth->acl_get('m_ban')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=ban&mode=user&u=' . $user_id, true, $user->session_id) : '',

             'U_SWITCH_PERMISSIONS'   => ($auth->acl_get('a_switchperm') && $user->data['user_id'] != $user_id) ? append_sid("{$phpbb_root_path}ucp.$phpEx", "mode=switch_perm&u={$user_id}") : '',

             'S_ZEBRA'         => ($user->data['user_id'] != $user_id && $user->data['is_registered'] && $zebra_enabled) ? true : false,
             'U_ADD_FRIEND'      => (!$friend) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=zebra&add=' . urlencode(htmlspecialchars_decode($member['username']))) : '',
             'U_ADD_FOE'         => (!$foe) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=zebra&mode=foes&add=' . urlencode(htmlspecialchars_decode($member['username']))) : '',
             'U_REMOVE_FRIEND'   => ($friend) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=zebra&remove=1&usernames[]=' . $user_id) : '',
             'U_REMOVE_FOE'      => ($foe) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=zebra&remove=1&mode=foes&usernames[]=' . $user_id) : '',
          ));

          if (!empty($profile_fields['row']))
          {
             $template->assign_vars($profile_fields['row']);
          }
    //-- mod: Prime Warnings ----------------------------------------------------//
          if ($member['user_warnings'])
          {
             include($phpbb_root_path . 'includes/prime_warnings.' . $phpEx);
             prime_warnings($member['user_warnings'], 'warnings', $memeber['user_id']);
          }
    //-- end: Prime Warnings ----------------------------------------------------//

          if (!empty($profile_fields['blockrow']))
          {
             foreach ($profile_fields['blockrow'] as $field_data)
             {
                $template->assign_block_vars('custom_fields', $field_data);
             }
          }

          // Inactive reason/account?
          if ($member['user_type'] == USER_INACTIVE)
          {
             $user->add_lang('acp/common');

             $inactive_reason = $user->lang['INACTIVE_REASON_UNKNOWN'];

             switch ($member['user_inactive_reason'])
             {
                case INACTIVE_REGISTER:
                   $inactive_reason = $user->lang['INACTIVE_REASON_REGISTER'];
                break;

                case INACTIVE_PROFILE:
                   $inactive_reason = $user->lang['INACTIVE_REASON_PROFILE'];
                break;

                case INACTIVE_MANUAL:
                   $inactive_reason = $user->lang['INACTIVE_REASON_MANUAL'];
                break;

                case INACTIVE_REMIND:
                   $inactive_reason = $user->lang['INACTIVE_REASON_REMIND'];
                break;
             }

             $template->assign_vars(array(
                'S_USER_INACTIVE'      => true,
                'USER_INACTIVE_REASON'   => $inactive_reason)
             );
          }

          // Now generate page title
          $page_title = sprintf($user->lang['VIEWING_PROFILE'], $member['username']);
          $template_html = 'memberlist_view.html';

       break;

       case 'email':

          // Send an email
          $page_title = $user->lang['SEND_EMAIL'];
          $template_html = 'memberlist_email.html';

          add_form_key('memberlist_email');

          if (!$config['email_enable'])
          {
             trigger_error('EMAIL_DISABLED');
          }

          if (!$auth->acl_get('u_sendemail'))
          {
             trigger_error('NO_EMAIL');
          }

          // Are we trying to abuse the facility?
          if (time() - $user->data['user_emailtime'] < $config['flood_interval'])
          {
             trigger_error('FLOOD_EMAIL_LIMIT');
          }

          // Determine action...
          $user_id = request_var('u', 0);
          $topic_id = request_var('t', 0);

          // Send email to user...
          if ($user_id)
          {
             if ($user_id == ANONYMOUS || !$config['board_email_form'])
             {
                trigger_error('NO_EMAIL');
             }

             // Get the appropriate username, etc.
             $sql = 'SELECT username, user_email, user_allow_viewemail, user_lang, user_jabber, user_notify_type
                FROM ' . USERS_TABLE . "
                WHERE user_id = $user_id
                   AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')';
             $result = $db->sql_query($sql);
             $row = $db->sql_fetchrow($result);
             $db->sql_freeresult($result);

             if (!$row)
             {
                trigger_error('NO_USER');
             }

             // Can we send email to this user?
             if (!$row['user_allow_viewemail'] && !$auth->acl_get('a_user'))
             {
                trigger_error('NO_EMAIL');
             }
          }
          else if ($topic_id)
          {
             // Send topic heads-up to email address
             $sql = 'SELECT forum_id, topic_title
                FROM ' . TOPICS_TABLE . "
                WHERE topic_id = $topic_id";
             $result = $db->sql_query($sql);
             $row = $db->sql_fetchrow($result);
             $db->sql_freeresult($result);

             if (!$row)
             {
                trigger_error('NO_TOPIC');
             }

             if ($row['forum_id'])
             {
                if (!$auth->acl_get('f_read', $row['forum_id']))
                {
                   trigger_error('SORRY_AUTH_READ');
                }

                if (!$auth->acl_get('f_email', $row['forum_id']))
                {
                   trigger_error('NO_EMAIL');
                }
             }
             else
             {
                // If global announcement, we need to check if the user is able to at least read and email in one forum...
                if (!$auth->acl_getf_global('f_read'))
                {
                   trigger_error('SORRY_AUTH_READ');
                }

                if (!$auth->acl_getf_global('f_email'))
                {
                   trigger_error('NO_EMAIL');
                }
             }
          }
          else
          {
             trigger_error('NO_EMAIL');
          }

          $error = array();

          $name      = utf8_normalize_nfc(request_var('name', '', true));
          $email      = request_var('email', '');
          $email_lang = request_var('lang', $config['default_lang']);
          $subject   = utf8_normalize_nfc(request_var('subject', '', true));
          $message   = utf8_normalize_nfc(request_var('message', '', true));
          $cc         = (isset($_POST['cc_email'])) ? true : false;
          $submit      = (isset($_POST['submit'])) ? true : false;

          if ($submit)
          {
             if (!check_form_key('memberlist_email'))
             {
                $error[] = 'FORM_INVALID';
             }
             if ($user_id)
             {
                if (!$subject)
                {
                   $error[] = $user->lang['EMPTY_SUBJECT_EMAIL'];
                }

                if (!$message)
                {
                   $error[] = $user->lang['EMPTY_MESSAGE_EMAIL'];
                }

                $name = $row['username'];
                $email_lang = $row['user_lang'];
                $email = $row['user_email'];
             }
             else
             {
                if (!$email || !preg_match('/^' . get_preg_expression('email') . '$/i', $email))
                {
                   $error[] = $user->lang['EMPTY_ADDRESS_EMAIL'];
                }

                if (!$name)
                {
                   $error[] = $user->lang['EMPTY_NAME_EMAIL'];
                }
             }

             if (!sizeof($error))
             {
                $sql = 'UPDATE ' . USERS_TABLE . '
                   SET user_emailtime = ' . time() . '
                   WHERE user_id = ' . $user->data['user_id'];
                $result = $db->sql_query($sql);

                include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);
                $messenger = new messenger(false);
                $email_tpl = ($user_id) ? 'profile_send_email' : 'email_notify';

                $mail_to_users = array();

                $mail_to_users[] = array(
                   'email_lang'      => $email_lang,
                   'email'            => $email,
                   'name'            => $name,
                   'username'         => ($user_id) ? $row['username'] : '',
                   'to_name'         => $name,
                   'user_jabber'      => ($user_id) ? $row['user_jabber'] : '',
                   'user_notify_type'   => ($user_id) ? $row['user_notify_type'] : NOTIFY_EMAIL,
                   'topic_title'      => (!$user_id) ? $row['topic_title'] : '',
                   'forum_id'         => (!$user_id) ? $row['forum_id'] : 0,
                );

                // Ok, now the same email if CC specified, but without exposing the users email address
                if ($cc)
                {
                   $mail_to_users[] = array(
                      'email_lang'      => $user->data['user_lang'],
                      'email'            => $user->data['user_email'],
                      'name'            => $user->data['username'],
                      'username'         => $user->data['username'],
                      'to_name'         => $name,
                      'user_jabber'      => $user->data['user_jabber'],
                      'user_notify_type'   => ($user_id) ? $user->data['user_notify_type'] : NOTIFY_EMAIL,
                      'topic_title'      => (!$user_id) ? $row['topic_title'] : '',
                      'forum_id'         => (!$user_id) ? $row['forum_id'] : 0,
                   );
                }

                foreach ($mail_to_users as $row)
                {
                   $messenger->template($email_tpl, $row['email_lang']);
                   $messenger->replyto($user->data['user_email']);
                   $messenger->to($row['email'], $row['name']);

                   if ($user_id)
                   {
                      $messenger->subject(htmlspecialchars_decode($subject));
                      $messenger->im($row['user_jabber'], $row['username']);
                      $notify_type = $row['user_notify_type'];
                   }
                   else
                   {
                      $notify_type = NOTIFY_EMAIL;
                   }

                   $messenger->headers('X-AntiAbuse: Board servername - ' . $config['server_name']);
                   $messenger->headers('X-AntiAbuse: User_id - ' . $user->data['user_id']);
                   $messenger->headers('X-AntiAbuse: Username - ' . $user->data['username']);
                   $messenger->headers('X-AntiAbuse: User IP - ' . $user->ip);

                   $messenger->assign_vars(array(
                      'BOARD_CONTACT'   => $config['board_contact'],
                      'TO_USERNAME'   => htmlspecialchars_decode($row['to_name']),
                      'FROM_USERNAME'   => htmlspecialchars_decode($user->data['username']),
                      'MESSAGE'      => htmlspecialchars_decode($message))
                   );

                   if ($topic_id)
                   {
                      $messenger->assign_vars(array(
                         'TOPIC_NAME'   => htmlspecialchars_decode($row['topic_title']),
                         'U_TOPIC'      => generate_board_url() . "/viewtopic.$phpEx?f=" . $row['forum_id'] . "&t=$topic_id")
                      );
                   }

                   $messenger->send($notify_type);
                }

                meta_refresh(3, append_sid("{$phpbb_root_path}index.$phpEx"));
                $message = ($user_id) ? sprintf($user->lang['RETURN_INDEX'], '<a href="' . append_sid("{$phpbb_root_path}index.$phpEx") . '">', '</a>') : sprintf($user->lang['RETURN_TOPIC'],  '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f={$row['forum_id']}&t=$topic_id") . '">', '</a>');
                trigger_error($user->lang['EMAIL_SENT'] . '<br /><br />' . $message);
             }
          }

          if ($user_id)
          {
             $template->assign_vars(array(
                'S_SEND_USER'   => true,
                'USERNAME'      => $row['username'],

                'L_EMAIL_BODY_EXPLAIN'   => $user->lang['EMAIL_BODY_EXPLAIN'],
                'S_POST_ACTION'         => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=email&u=' . $user_id))
             );
          }
          else
          {
             $template->assign_vars(array(
                'EMAIL'            => $email,
                'NAME'            => $name,
                'S_LANG_OPTIONS'   => language_select($email_lang),

                'L_EMAIL_BODY_EXPLAIN'   => $user->lang['EMAIL_TOPIC_EXPLAIN'],
                'S_POST_ACTION'         => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=email&t=' . $topic_id))
             );
          }

          $template->assign_vars(array(
             'ERROR_MESSAGE'      => (sizeof($error)) ? implode('<br />', $error) : '')
          );

       break;

       case 'group':
       default:
          // The basic memberlist
          $page_title = $user->lang['MEMBERLIST'];
          $template_html = 'memberlist_body.html';

          // Sorting
          $sort_key_text = array('a' => $user->lang['SORT_USERNAME'], 'b' => $user->lang['SORT_LOCATION'], 'c' => $user->lang['SORT_JOINED'], 'd' => $user->lang['SORT_POST_COUNT'], 'f' => $user->lang['WEBSITE'], 'g' => $user->lang['ICQ'], 'h' => $user->lang['AIM'], 'i' => $user->lang['MSNM'], 'j' => $user->lang['YIM'], 'k' => $user->lang['JABBER']);
          $sort_key_sql = array('a' => 'u.username_clean', 'b' => 'u.user_from', 'c' => 'u.user_regdate', 'd' => 'u.user_posts', 'f' => 'u.user_website', 'g' => 'u.user_icq', 'h' => 'u.user_aim', 'i' => 'u.user_msnm', 'j' => 'u.user_yim', 'k' => 'u.user_jabber');

          if ($auth->acl_get('a_user'))
          {
             $sort_key_text['e'] = $user->lang['SORT_EMAIL'];
             $sort_key_sql['e'] = 'u.user_email';
          }

          if ($auth->acl_get('u_viewonline'))
          {
             $sort_key_text['l'] = $user->lang['SORT_LAST_ACTIVE'];
             $sort_key_sql['l'] = 'u.user_lastvisit';
          }

          $sort_key_text['m'] = $user->lang['SORT_RANK'];
          $sort_key_sql['m'] = 'u.user_rank';

          $sort_dir_text = array('a' => $user->lang['ASCENDING'], 'd' => $user->lang['DESCENDING']);

          $s_sort_key = '';
          foreach ($sort_key_text as $key => $value)
          {
             $selected = ($sort_key == $key) ? ' selected="selected"' : '';
             $s_sort_key .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>';
          }

          $s_sort_dir = '';
          foreach ($sort_dir_text as $key => $value)
          {
             $selected = ($sort_dir == $key) ? ' selected="selected"' : '';
             $s_sort_dir .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>';
          }

          // Additional sorting options for user search ... if search is enabled, if not
          // then only admins can make use of this (for ACP functionality)
          $sql_select = $sql_where_data = $sql_from = $sql_where = $order_by = '';


          $form         = request_var('form', '');
          $field         = request_var('field', '');
          $select_single    = request_var('select_single', false);

          // We validate form and field here, only id/class allowed
          $form = (!preg_match('/^[a-z0-9_-]+$/i', $form)) ? '' : $form;
          $field = (!preg_match('/^[a-z0-9_-]+$/i', $field)) ? '' : $field;
          if ($mode == 'searchuser' && ($config['load_search'] || $auth->acl_get('a_')))
          {
             $username   = request_var('username', '', true);
             $email      = strtolower(request_var('email', ''));
             $icq      = request_var('icq', '');
             $aim      = request_var('aim', '');
             $yahoo      = request_var('yahoo', '');
             $msn      = request_var('msn', '');
             $jabber      = request_var('jabber', '');
             $search_group_id   = request_var('search_group_id', 0);

             $joined_select   = request_var('joined_select', 'lt');
             $active_select   = request_var('active_select', 'lt');
             $count_select   = request_var('count_select', 'eq');
             $joined         = explode('-', request_var('joined', ''));
             $active         = explode('-', request_var('active', ''));
             $count         = (request_var('count', '') !== '') ? request_var('count', 0) : '';
             $ipdomain      = request_var('ip', '');

             $find_key_match = array('lt' => '<', 'gt' => '>', 'eq' => '=');

             $find_count = array('lt' => $user->lang['LESS_THAN'], 'eq' => $user->lang['EQUAL_TO'], 'gt' => $user->lang['MORE_THAN']);
             $s_find_count = '';
             foreach ($find_count as $key => $value)
             {
                $selected = ($count_select == $key) ? ' selected="selected"' : '';
                $s_find_count .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>';
             }

             $find_time = array('lt' => $user->lang['BEFORE'], 'gt' => $user->lang['AFTER']);
             $s_find_join_time = '';
             foreach ($find_time as $key => $value)
             {
                $selected = ($joined_select == $key) ? ' selected="selected"' : '';
                $s_find_join_time .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>';
             }

             $s_find_active_time = '';
             foreach ($find_time as $key => $value)
             {
                $selected = ($active_select == $key) ? ' selected="selected"' : '';
                $s_find_active_time .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>';
             }

             $sql_where .= ($username) ? ' AND u.username_clean ' . $db->sql_like_expression(str_replace('*', $db->any_char, utf8_clean_string($username))) : '';
             $sql_where .= ($auth->acl_get('a_user') && $email) ? ' AND u.user_email ' . $db->sql_like_expression(str_replace('*', $db->any_char, $email)) . ' ' : '';
             $sql_where .= ($icq) ? ' AND u.user_icq ' . $db->sql_like_expression(str_replace('*', $db->any_char, $icq)) . ' ' : '';
             $sql_where .= ($aim) ? ' AND u.user_aim ' . $db->sql_like_expression(str_replace('*', $db->any_char, $aim)) . ' ' : '';
             $sql_where .= ($yahoo) ? ' AND u.user_yim ' . $db->sql_like_expression(str_replace('*', $db->any_char, $yahoo)) . ' ' : '';
             $sql_where .= ($msn) ? ' AND u.user_msnm ' . $db->sql_like_expression(str_replace('*', $db->any_char, $msn)) . ' ' : '';
             $sql_where .= ($jabber) ? ' AND u.user_jabber ' . $db->sql_like_expression(str_replace('*', $db->any_char, $jabber)) . ' ' : '';
             $sql_where .= (is_numeric($count)) ? ' AND u.user_posts ' . $find_key_match[$count_select] . ' ' . (int) $count . ' ' : '';
             $sql_where .= (sizeof($joined) > 1) ? " AND u.user_regdate " . $find_key_match[$joined_select] . ' ' . gmmktime(0, 0, 0, intval($joined[1]), intval($joined[2]), intval($joined[0])) : '';
             $sql_where .= ($auth->acl_get('u_viewonline') && sizeof($active) > 1) ? " AND u.user_lastvisit " . $find_key_match[$active_select] . ' ' . gmmktime(0, 0, 0, $active[1], intval($active[2]), intval($active[0])) : '';
             $sql_where .= ($search_group_id) ? " AND u.user_id = ug.user_id AND ug.group_id = $search_group_id AND ug.user_pending = 0 " : '';

             if ($search_group_id)
             {
                $sql_from = ', ' . USER_GROUP_TABLE . ' ug ';
             }

             if ($ipdomain && $auth->acl_getf_global('m_info'))
             {
                if (strspn($ipdomain, 'abcdefghijklmnopqrstuvwxyz'))
                {
                   $hostnames = gethostbynamel($ipdomain);

                   if ($hostnames !== false)
                   {
                      $ips = "'" . implode('\', \'', array_map(array($db, 'sql_escape'), preg_replace('#([0-9]{1,3}\.[0-9]{1,3}[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3})#', "\\1", gethostbynamel($ipdomain)))) . "'";
                   }
                   else
                   {
                      $ips = false;
                   }
                }
                else
                {
                   $ips = "'" . str_replace('*', '%', $db->sql_escape($ipdomain)) . "'";
                }

                if ($ips === false)
                {
                   // A minor fudge but it does the job :D
                   $sql_where .= " AND u.user_id = 0";
                }
                else
                {
                   $ip_forums = array_keys($auth->acl_getf('m_info', true));

                   $sql = 'SELECT DISTINCT poster_id
                      FROM ' . POSTS_TABLE . '
                      WHERE poster_ip ' . ((strpos($ips, '%') !== false) ? 'LIKE' : 'IN') . " ($ips)
                         AND forum_id IN (0, " . implode(', ', $ip_forums) . ')';
                   $result = $db->sql_query($sql);

                   if ($row = $db->sql_fetchrow($result))
                   {
                      $ip_sql = array();
                      do
                      {
                         $ip_sql[] = $row['poster_id'];
                      }
                      while ($row = $db->sql_fetchrow($result));

                      $sql_where .= ' AND ' . $db->sql_in_set('u.user_id', $ip_sql);
                   }
                   else
                   {
                      // A minor fudge but it does the job :D
                      $sql_where .= " AND u.user_id = 0";
                   }
                   unset($ip_forums);

                   $db->sql_freeresult($result);
                }
             }
          }

          $first_char = request_var('first_char', '');

          if ($first_char == 'other')
          {
             for ($i = 97; $i < 123; $i++)
             {
                $sql_where .= ' AND u.username_clean NOT ' . $db->sql_like_expression(chr($i) . $db->any_char);
             }
          }
          else if ($first_char)
          {
             $sql_where .= ' AND u.username_clean ' . $db->sql_like_expression(substr($first_char, 0, 1) . $db->any_char);
          }

          // Are we looking at a usergroup? If so, fetch additional info
          // and further restrict the user info query
          if ($mode == 'group')
          {
             // We JOIN here to save a query for determining membership for hidden groups. ;)
             $sql = 'SELECT g.*, ug.user_id
                FROM ' . GROUPS_TABLE . ' g
                LEFT JOIN ' . USER_GROUP_TABLE . ' ug ON (ug.user_pending = 0 AND ug.user_id = ' . $user->data['user_id'] . " AND ug.group_id = $group_id)
                WHERE g.group_id = $group_id";
             $result = $db->sql_query($sql);
             $group_row = $db->sql_fetchrow($result);
             $db->sql_freeresult($result);

             if (!$group_row)
             {
                trigger_error('NO_GROUP');
             }

             switch ($group_row['group_type'])
             {
                case GROUP_OPEN:
                   $group_row['l_group_type'] = 'OPEN';
                break;

                case GROUP_CLOSED:
                   $group_row['l_group_type'] = 'CLOSED';
                break;

                case GROUP_HIDDEN:
                   $group_row['l_group_type'] = 'HIDDEN';

                   // Check for membership or special permissions
                   if (!$auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel') && $group_row['user_id'] != $user->data['user_id'])
                   {
                      trigger_error('NO_GROUP');
                   }
                break;

                case GROUP_SPECIAL:
                   $group_row['l_group_type'] = 'SPECIAL';
                break;

                case GROUP_FREE:
                   $group_row['l_group_type'] = 'FREE';
                break;
             }

             // Misusing the avatar function for displaying group avatars...
             $avatar_img = get_user_avatar($group_row['group_avatar'], $group_row['group_avatar_type'], $group_row['group_avatar_width'], $group_row['group_avatar_height'], 'GROUP_AVATAR');

             $rank_title = $rank_img = $rank_img_src = '';
             if ($group_row['group_rank'])
             {
                if (isset($ranks['special'][$group_row['group_rank']]))
                {
                   $rank_title = $ranks['special'][$group_row['group_rank']]['rank_title'];
                }
                $rank_img = (!empty($ranks['special'][$group_row['group_rank']]['rank_image'])) ? '<img src="' . $config['ranks_path'] . '/' . $ranks['special'][$group_row['group_rank']]['rank_image'] . '" alt="' . $ranks['special'][$group_row['group_rank']]['rank_title'] . '" title="' . $ranks['special'][$group_row['group_rank']]['rank_title'] . '" /><br />' : '';
                $rank_img_src = (!empty($ranks['special'][$group_row['group_rank']]['rank_image'])) ? $config['ranks_path'] . '/' . $ranks['special'][$group_row['group_rank']]['rank_image'] : '';
             }
             else
             {
                $rank_title = '';
                $rank_img = '';
                $rank_img_src = '';
             }

             $template->assign_vars(array(
                'GROUP_DESC'   => generate_text_for_display($group_row['group_desc'], $group_row['group_desc_uid'], $group_row['group_desc_bitfield'], $group_row['group_desc_options']),
                'GROUP_NAME'   => ($group_row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $group_row['group_name']] : $group_row['group_name'],
                'GROUP_COLOR'   => $group_row['group_colour'],
                'GROUP_TYPE'   => $user->lang['GROUP_IS_' . $group_row['l_group_type']],
                'GROUP_RANK'   => $rank_title,

                'AVATAR_IMG'   => $avatar_img,
                'RANK_IMG'      => $rank_img,
                'RANK_IMG_SRC'   => $rank_img_src,

                'U_PM'         => ($auth->acl_get('u_sendpm') && $auth->acl_get('u_masspm') && $group_row['group_receive_pm'] && $config['allow_privmsg'] && $config['allow_mass_pm']) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&mode=compose&g=' . $group_id) : '',)
             );

             $sql_select = ', ug.group_leader';
             $sql_from = ', ' . USER_GROUP_TABLE . ' ug ';
             $order_by = 'ug.group_leader DESC, ';

             $sql_where .= " AND ug.user_pending = 0 AND u.user_id = ug.user_id AND ug.group_id = $group_id";
             $sql_where_data = " AND u.user_id = ug.user_id AND ug.group_id = $group_id";
          }
          
          // Sorting and order
          if (!isset($sort_key_sql[$sort_key]))
          {
             $sort_key = $default_key;
          }

          $order_by .= $sort_key_sql[$sort_key] . ' ' . (($sort_dir == 'a') ? 'ASC' : 'DESC');

          // Unfortunately we must do this here for sorting by rank, else the sort order is applied wrongly
          if ($sort_key == 'm')
          {
             $order_by .= ', u.user_posts DESC';
          }

          // Count the users ...
          if ($sql_where)
          {
             $sql = 'SELECT COUNT(u.user_id) AS total_users
                FROM ' . USERS_TABLE . " u$sql_from
                WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ")
                $sql_where";
             $result = $db->sql_query($sql);
             $total_users = (int) $db->sql_fetchfield('total_users');
             $db->sql_freeresult($result);
          }
          else
          {
             $total_users = $config['num_users'];
          }

          $s_char_options = '<option value=""' . ((!$first_char) ? ' selected="selected"' : '') . '>&nbsp; &nbsp;</option>';
          for ($i = 97; $i < 123; $i++)
          {
             $s_char_options .= '<option value="' . chr($i) . '"' . (($first_char == chr($i)) ? ' selected="selected"' : '') . '>' . chr($i-32) . '</option>';
          }
          $s_char_options .= '<option value="other"' . (($first_char == 'other') ? ' selected="selected"' : '') . '>' . $user->lang['OTHER'] . '</option>';

          // Build a relevant pagination_url
          $params = $sort_params = array();

          // We do not use request_var() here directly to save some calls (not all variables are set)
          $check_params = array(
             'g'            => array('g', 0),
             'sk'         => array('sk', $default_key),
             'sd'         => array('sd', 'a'),
             'form'         => array('form', ''),
             'field'         => array('field', ''),
             'select_single'   => array('select_single', $select_single),
             'username'      => array('username', '', true),
             'email'         => array('email', ''),
             'icq'         => array('icq', ''),
             'aim'         => array('aim', ''),
             'yahoo'         => array('yahoo', ''),
             'msn'         => array('msn', ''),
             'jabber'      => array('jabber', ''),
             'search_group_id'   => array('search_group_id', 0),
             'joined_select'   => array('joined_select', 'lt'),
             'active_select'   => array('active_select', 'lt'),
             'count_select'   => array('count_select', 'eq'),
             'joined'      => array('joined', ''),
             'active'      => array('active', ''),
             'count'         => (request_var('count', '') !== '') ? array('count', 0) : array('count', ''),
             'ipdomain'      => array('ip', ''),
             'first_char'   => array('first_char', ''),
          );

          foreach ($check_params as $key => $call)
          {
             if (!isset($_REQUEST[$key]))
             {
                continue;
             }

             $param = call_user_func_array('request_var', $call);
             $param = urlencode($key) . '=' . ((is_string($param)) ? urlencode($param) : $param);
             $params[] = $param;

             if ($key != 'sk' && $key != 'sd')
             {
                $sort_params[] = $param;
             }
          }

          $u_hide_find_member = append_sid("{$phpbb_root_path}memberlist.$phpEx", implode('&', $params));

          $params[] = "mode=$mode";
          $sort_params[] = "mode=$mode";
          $pagination_url = append_sid("{$phpbb_root_path}memberlist.$phpEx", implode('&', $params));
          $sort_url = append_sid("{$phpbb_root_path}memberlist.$phpEx", implode('&', $sort_params));

          unset($params, $sort_params);

          // Some search user specific data
          if ($mode == 'searchuser' && ($config['load_search'] || $auth->acl_get('a_')))
          {
             $group_selected = request_var('search_group_id', 0);
             $s_group_select = '<option value="0"' . ((!$group_selected) ? ' selected="selected"' : '') . '>&nbsp;</option>';
             $group_ids = array();

             if ($auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel'))
             {
                $sql = 'SELECT group_id, group_name, group_type
                   FROM ' . GROUPS_TABLE . '
                   ORDER BY group_name ASC';
             }
             else
             {
                $sql = 'SELECT g.group_id, g.group_name, g.group_type
                   FROM ' . GROUPS_TABLE . ' g
                   LEFT JOIN ' . USER_GROUP_TABLE . ' ug
                      ON (
                         g.group_id = ug.group_id
                         AND ug.user_id = ' . $user->data['user_id'] . '
                         AND ug.user_pending = 0
                      )
                   WHERE (g.group_type <> ' . GROUP_HIDDEN . ' OR ug.user_id = ' . $user->data['user_id'] . ')
                   ORDER BY g.group_name ASC';
             }
             $result = $db->sql_query($sql);

             while ($row = $db->sql_fetchrow($result))
             {
                $group_ids[] = $row['group_id'];
                $s_group_select .= '<option value="' . $row['group_id'] . '"' . (($group_selected == $row['group_id']) ? ' selected="selected"' : '') . '>' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';
             }
             $db->sql_freeresult($result);

             if ($group_selected !== 0 && !in_array($group_selected, $group_ids))
             {
                trigger_error('NO_GROUP');
             }

             $template->assign_vars(array(
                'USERNAME'   => $username,
                'EMAIL'      => $email,
                'ICQ'      => $icq,
                'AIM'      => $aim,
                'YAHOO'      => $yahoo,
                'MSNM'      => $msn,
                'JABBER'   => $jabber,
                'JOINED'   => implode('-', $joined),
                'ACTIVE'   => implode('-', $active),
                'COUNT'      => $count,
                'IP'      => $ipdomain,

                'S_IP_SEARCH_ALLOWED'   => ($auth->acl_getf_global('m_info')) ? true : false,
                'S_EMAIL_SEARCH_ALLOWED'=> ($auth->acl_get('a_user')) ? true : false,
                'S_IN_SEARCH_POPUP'      => ($form && $field) ? true : false,
                'S_SEARCH_USER'         => true,
                'S_FORM_NAME'         => $form,
                'S_FIELD_NAME'         => $field,
                'S_SELECT_SINGLE'      => $select_single,
                'S_COUNT_OPTIONS'      => $s_find_count,
                'S_SORT_OPTIONS'      => $s_sort_key,
                'S_JOINED_TIME_OPTIONS'   => $s_find_join_time,
                'S_ACTIVE_TIME_OPTIONS'   => $s_find_active_time,
                'S_GROUP_SELECT'      => $s_group_select,
                'S_USER_SEARCH_ACTION'   => append_sid("{$phpbb_root_path}memberlist.$phpEx", "mode=searchuser&form=$form&field=$field"))
             );
          }

          // Get us some users :D
          $sql = "SELECT u.user_id
             FROM " . USERS_TABLE . " u
                $sql_from
             WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ")
                $sql_where
             ORDER BY $order_by";
          $result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);

          $user_list = array();
          while ($row = $db->sql_fetchrow($result))
          {
             $user_list[] = (int) $row['user_id'];
          }
          $db->sql_freeresult($result);

          // So, did we get any users?
          if (sizeof($user_list))
          {
             // Session time?! Session time...
             $sql = 'SELECT session_user_id, MAX(session_time) AS session_time
                FROM ' . SESSIONS_TABLE . '
                WHERE session_time >= ' . (time() - $config['session_length']) . '
                   AND ' . $db->sql_in_set('session_user_id', $user_list) . '
                GROUP BY session_user_id';
             $result = $db->sql_query($sql);

             $session_times = array();
             while ($row = $db->sql_fetchrow($result))
             {
                $session_times[$row['session_user_id']] = $row['session_time'];
             }
             $db->sql_freeresult($result);

             // Do the SQL thang
             if ($mode == 'group')
             {
                $sql = "SELECT u.*
                      $sql_select
                   FROM " . USERS_TABLE . " u
                      $sql_from
                   WHERE " . $db->sql_in_set('u.user_id', $user_list) . "
                      $sql_where_data";
             }
             else
             {
                $sql = 'SELECT *
                   FROM ' . USERS_TABLE . '
                   WHERE ' . $db->sql_in_set('user_id', $user_list);
             }
             $result = $db->sql_query($sql);

             $id_cache = array();
             while ($row = $db->sql_fetchrow($result))
             {
                $row['session_time'] = (!empty($session_times[$row['user_id']])) ? $session_times[$row['user_id']] : 0;
                $row['last_visit'] = (!empty($row['session_time'])) ? $row['session_time'] : $row['user_lastvisit'];

                $id_cache[$row['user_id']] = $row;
             }
             $db->sql_freeresult($result);

             // Load custom profile fields
             if ($config['load_cpf_memberlist'])
             {
                include_once($phpbb_root_path . 'includes/functions_profile_fields.' . $phpEx);
                $cp = new custom_profile();

                // Grab all profile fields from users in id cache for later use - similar to the poster cache
                $profile_fields_cache = $cp->generate_profile_fields_template('grab', $user_list);
             }

             // If we sort by last active date we need to adjust the id cache due to user_lastvisit not being the last active date...
             if ($sort_key == 'l')
             {
                $lesser_than = ($sort_dir == 'a') ? -1 : 1;
    //            uasort($id_cache, create_function('$first, $second', "return (\$first['last_visit'] == \$second['last_visit']) ? 0 : ((\$first['last_visit'] < \$second['last_visit']) ? $lesser_than : ($lesser_than * -1));"));
                usort($user_list, create_function('$first, $second', "global \$id_cache; return (\$id_cache[\$first]['last_visit'] == \$id_cache[\$second]['last_visit']) ? 0 : ((\$id_cache[\$first]['last_visit'] < \$id_cache[\$second]['last_visit']) ? $lesser_than : ($lesser_than * -1));"));
             }

             for ($i = 0, $end = sizeof($user_list); $i < $end; ++$i)
             {
                $user_id = $user_list[$i];
                $row =& $id_cache[$user_id];

                $cp_row = array();
                if ($config['load_cpf_memberlist'])
                {
                   $cp_row = (isset($profile_fields_cache[$user_id])) ? $cp->generate_profile_fields_template('show', false, $profile_fields_cache[$user_id]) : array();
                }

                $memberrow = array_merge(show_profile($row), array(
                   'ROW_NUMBER'      => $i + ($start + 1),

                   'S_CUSTOM_PROFILE'   => (isset($cp_row['row']) && sizeof($cp_row['row'])) ? true : false,
                   'S_GROUP_LEADER'   => (isset($row['group_leader']) && $row['group_leader']) ? true : false,

                   'U_VIEW_PROFILE'   => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&u=' . $user_id))
                );

                if (isset($cp_row['row']) && sizeof($cp_row['row']))
                {
                   $memberrow = array_merge($memberrow, $cp_row['row']);
                }

                $template->assign_block_vars('memberrow', $memberrow);

                if (isset($cp_row['blockrow']) && sizeof($cp_row['blockrow']))
                {
                   foreach ($cp_row['blockrow'] as $field_data)
                   {
                      $template->assign_block_vars('memberrow.custom_fields', $field_data);
                   }
                }

                unset($id_cache[$user_id]);
             }
          }

          // Generate page
          $template->assign_vars(array(
             'PAGINATION'   => generate_pagination($pagination_url, $total_users, $config['topics_per_page'], $start),
             'PAGE_NUMBER'   => on_page($total_users, $config['topics_per_page'], $start),
             'TOTAL_USERS'   => ($total_users == 1) ? $user->lang['LIST_USER'] : sprintf($user->lang['LIST_USERS'], $total_users),

             'PROFILE_IMG'   => $user->img('icon_user_profile', $user->lang['PROFILE']),
             'PM_IMG'      => $user->img('icon_contact_pm', $user->lang['SEND_PRIVATE_MESSAGE']),
             'EMAIL_IMG'      => $user->img('icon_contact_email', $user->lang['EMAIL']),
             'WWW_IMG'      => $user->img('icon_contact_www', $user->lang['WWW']),
             'ICQ_IMG'      => $user->img('icon_contact_icq', $user->lang['ICQ']),
             'AIM_IMG'      => $user->img('icon_contact_aim', $user->lang['AIM']),
             'MSN_IMG'      => $user->img('icon_contact_msnm', $user->lang['MSNM']),
             'YIM_IMG'      => $user->img('icon_contact_yahoo', $user->lang['YIM']),
             'JABBER_IMG'   => $user->img('icon_contact_jabber', $user->lang['JABBER']),
             'SEARCH_IMG'   => $user->img('icon_user_search', $user->lang['SEARCH']),

             'U_FIND_MEMBER'         => ($config['load_search'] || $auth->acl_get('a_')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser') : '',
             'U_HIDE_FIND_MEMBER'   => ($mode == 'searchuser') ? $u_hide_find_member : '',
             'U_SORT_USERNAME'      => $sort_url . '&sk=a&sd=' . (($sort_key == 'a' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_FROM'         => $sort_url . '&sk=b&sd=' . (($sort_key == 'b' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_JOINED'         => $sort_url . '&sk=c&sd=' . (($sort_key == 'c' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_POSTS'         => $sort_url . '&sk=d&sd=' . (($sort_key == 'd' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_EMAIL'         => $sort_url . '&sk=e&sd=' . (($sort_key == 'e' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_WEBSITE'      => $sort_url . '&sk=f&sd=' . (($sort_key == 'f' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_LOCATION'      => $sort_url . '&sk=b&sd=' . (($sort_key == 'b' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_ICQ'         => $sort_url . '&sk=g&sd=' . (($sort_key == 'g' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_AIM'         => $sort_url . '&sk=h&sd=' . (($sort_key == 'h' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_MSN'         => $sort_url . '&sk=i&sd=' . (($sort_key == 'i' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_YIM'         => $sort_url . '&sk=j&sd=' . (($sort_key == 'j' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_SORT_ACTIVE'         => ($auth->acl_get('u_viewonline')) ? $sort_url . '&sk=l&sd=' . (($sort_key == 'l' && $sort_dir == 'a') ? 'd' : 'a') : '',
             'U_SORT_RANK'         => $sort_url . '&sk=m&sd=' . (($sort_key == 'm' && $sort_dir == 'a') ? 'd' : 'a'),
             'U_LIST_CHAR'         => $sort_url . '&sk=a&sd=' . (($sort_key == 'l' && $sort_dir == 'a') ? 'd' : 'a'),

             'S_SHOW_GROUP'      => ($mode == 'group') ? true : false,
             'S_VIEWONLINE'      => $auth->acl_get('u_viewonline'),
             'S_MODE_SELECT'      => $s_sort_key,
             'S_ORDER_SELECT'   => $s_sort_dir,
             'S_CHAR_OPTIONS'   => $s_char_options,
             'S_MODE_ACTION'      => $pagination_url)
          );
    }

    // Output the page
    page_header($page_title);

    $template->set_filenames(array(
       'body' => $template_html)
    );
    make_jumpbox(append_sid("{$phpbb_root_path}viewforum.$phpEx"));

    page_footer();

    /**
    * Prepare profile data
    */
    function show_profile($data)
    {
       global $config, $auth, $template, $user, $phpEx, $phpbb_root_path;

       $username = $data['username'];
       $user_id = $data['user_id'];

       $rank_title = $rank_img = $rank_img_src = '';
       get_user_rank($data['user_rank'], $data['user_posts'], $rank_title, $rank_img, $rank_img_src);

       if (!empty($data['user_allow_viewemail']) || $auth->acl_get('a_user'))
       {
          $email = ($config['board_email_form'] && $config['email_enable']) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=email&u=' . $user_id) : (($config['board_hide_emails'] && !$auth->acl_get('a_user')) ? '' : 'mailto:' . $data['user_email']);
       }
       else
       {
          $email = '';
       }

       if ($config['load_onlinetrack'])
       {
          $update_time = $config['load_online_time'] * 60;
          $online = (time() - $update_time < $data['session_time'] && ((isset($data['session_viewonline']) && $data['session_viewonline']) || $auth->acl_get('u_viewonline'))) ? true : false;
       }
       else
       {
          $online = false;
       }

       if ($data['user_allow_viewonline'] || $auth->acl_get('u_viewonline'))
       {
          $last_visit = (!empty($data['session_time'])) ? $data['session_time'] : $data['user_lastvisit'];
       }
       else
       {
          $last_visit = '';
       }

       $age = '';

       if ($config['allow_birthdays'] && $data['user_birthday'])
       {
          list($bday_day, $bday_month, $bday_year) = array_map('intval', explode('-', $data['user_birthday']));

          if ($bday_year)
          {
             $now = getdate(time() + $user->timezone + $user->dst - date('Z'));

             $diff = $now['mon'] - $bday_month;
             if ($diff == 0)
             {
                $diff = ($now['mday'] - $bday_day < 0) ? 1 : 0;
             }
             else
             {
                $diff = ($diff < 0) ? 1 : 0;
             }

             $age = (int) ($now['year'] - $bday_year - $diff);
          }
       }

       // Dump it out to the template
       return array(
          'AGE'         => $age,
          'RANK_TITLE'   => $rank_title,
          'JOINED'      => $user->format_date($data['user_regdate']),
          'VISITED'      => (empty($last_visit)) ? ' - ' : $user->format_date($last_visit),
          'POSTS'         => ($data['user_posts']) ? $data['user_posts'] : 0,
          'WARNINGS'      => isset($data['user_warnings']) ? $data['user_warnings'] : 0,

          'USERNAME_FULL'      => get_username_string('full', $user_id, $username, $data['user_colour']),
          'USERNAME'         => get_username_string('username', $user_id, $username, $data['user_colour']),
          'USER_COLOR'      => get_username_string('colour', $user_id, $username, $data['user_colour']),
          'U_VIEW_PROFILE'   => get_username_string('profile', $user_id, $username, $data['user_colour']),

          'A_USERNAME'      => addslashes(get_username_string('username', $user_id, $username, $data['user_colour'])),

          'AVATAR_IMG'      => get_user_avatar($data['user_avatar'], $data['user_avatar_type'], $data['user_avatar_width'], $data['user_avatar_height']),
          'ONLINE_IMG'      => (!$config['load_onlinetrack']) ? '' : (($online) ? $user->img('icon_user_online', 'ONLINE') : $user->img('icon_user_offline', 'OFFLINE')),
          'S_ONLINE'         => ($config['load_onlinetrack'] && $online) ? true : false,
          'RANK_IMG'         => $rank_img,
          'RANK_IMG_SRC'      => $rank_img_src,
          'ICQ_STATUS_IMG'   => (!empty($data['user_icq'])) ? '<img src="http://web.icq.com/whitepages/online?icq=' . $data['user_icq'] . '&img=5" width="18" height="18" />' : '',
          'S_JABBER_ENABLED'   => ($config['jab_enable']) ? true : false,

          'U_SEARCH_USER'   => ($auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", "author_id=$user_id&sr=posts") : '',
          'U_NOTES'      => $auth->acl_getf_global('m_') ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&mode=user_notes&u=' . $user_id, true, $user->session_id) : '',
          'U_WARN'      => $auth->acl_get('m_warn') ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&mode=warn_user&u=' . $user_id, true, $user->session_id) : '',
          'U_PM'         => ($config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($data['user_allow_pm'] || $auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_'))) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&mode=compose&u=' . $user_id) : '',
          'U_EMAIL'      => $email,
          'U_WWW'         => (!empty($data['user_website'])) ? $data['user_website'] : '',
          'U_ICQ'         => ($data['user_icq']) ? 'http://www.icq.com/people/webmsg.php?to=' . urlencode($data['user_icq']) : '',
          'U_AIM'         => ($data['user_aim'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&action=aim&u=' . $user_id) : '',
          'U_YIM'         => ($data['user_yim']) ? 'http://edit.yahoo.com/config/send_webmesg?.target=' . urlencode($data['user_yim']) . '&.src=pg' : '',
          'U_MSN'         => ($data['user_msnm'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&action=msnm&u=' . $user_id) : '',
          'U_JABBER'      => ($data['user_jabber'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&action=jabber&u=' . $user_id) : '',
          'LOCATION'      => ($data['user_from']) ? $data['user_from'] : '',

          'USER_ICQ'         => $data['user_icq'],
          'USER_AIM'         => $data['user_aim'],
          'USER_YIM'         => $data['user_yim'],
          'USER_MSN'         => $data['user_msnm'],
          'USER_JABBER'      => $data['user_jabber'],
          'USER_JABBER_IMG'   => ($data['user_jabber']) ? $user->img('icon_contact_jabber', $data['user_jabber']) : '',

          'L_VIEWING_PROFILE'   => sprintf($user->lang['VIEWING_PROFILE'], $username),
       );
    }

    ?>

When i want to add a module for the "user" and the "bank" it works but when i open this module, there's nothing. How can i fixe this?

For login:
username: test
password: testtest

Bram
I'm dutch so my english is not verry good, sorry.

somebody?

Ladysarajane · Post by **Ladysarajane** » Fri Oct 31, 2008 3:45 am

@francebramie

Double check your edits. You missed something or edited something wrong. Also it looks like you may have missed a language edit.

The user and Bank MODULES are NOT ACTIVE yet.

@vicious duck and Fimo...how comfortable are you working in phpmyadmin?

francebramie · Post by **francebramie** » Fri Oct 31, 2008 12:02 pm

Ok, i forgot some edits in the memberlist.php. But it isn't fixe look:
http://forums.gamebeach.nl/memberlist.p ... rofile&u=2

The modules are active, and when i look at the module "bank settings" and "user" there is nothing.