//

// $Id$

//

// STARTED : Sat Feb 13, 2001

// COPYRIGHT : © 2001, 2003 phpBB Group

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

// -------------------------------------------------------------

// TODO

// Add permission check for IM clients

$phpbb_root_path = './';

$phpEx = substr(strrchr(__FILE__, '.'), 1);

include($phpbb_root_path . 'common.'.$phpEx);

// Start session management

$user->start();

$auth->acl($user->data);

// Grab data

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

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

$user_id = request_var('u', ANONYMOUS);

$topic_id = request_var('t', 0);

switch ($mode)

trigger_error($user->lang['NO_VIEW_USERS']);

}

}

break;

}

switch ($mode)

{

case 'leaders':

// Display a listing of board admins, moderators?

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

}

}

WHERE user_id IN (' . implode(', ', $user_id_ary) . ')';

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

$s_select = 'S_SEND_AIM';

$s_action = '';

break;

case 'msnm':

$lang = 'MSNM';

$sql_field = 'user_msnm';

}

// Grab relevant data

WHERE user_id = $user_id";

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

// Send vars to the template

$template->assign_vars(array(

'SITENAME' => addslashes($config['sitename']),

'S_IM_ACTION' => $s_action)

);

// Display a profile

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

$template_html = 'memberlist_view.html';

if ($user_id == ANONYMOUS)

{

trigger_error($user->lang['NO_USER']);

}

// Do the SQL thang

ORDER BY group_type, group_name';

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

}

// We left join on the session table to see if the user is currently online

WHERE user_id = $user_id";

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

}

$db->sql_freeresult($result);

FROM ' . SESSIONS_TABLE . "

WHERE session_user_id = $user_id";

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

$auth2 = new auth();

$auth2->acl($member);

$f_postcount_ary = $auth2->acl_getf('f_postcount');

$sql_forums = array();

foreach ($f_postcount_ary as $forum_id => $allow)

{

unset($sql_forums, $f_postcount_ary, $auth2);

// Grab all the relevant data

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

$post_count_sql";

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

$post_count_sql = (sizeof($sql_forums)) ? 'AND f.forum_id IN (' . implode(', ', $sql_forums) . ')' : '';

unset($sql_forums, $f_forum_ary);

if ($post_count_sql)

{

$post_count_sql

$result = $db->sql_query_limit($sql, 1);

$active_f_row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

$post_count_sql

ORDER BY num_posts DESC";

$result = $db->sql_query_limit($sql, 1);

$active_f_row = $active_t_row = array();

}

$memberdays = max(1, round((time() - $member['user_regdate']) / 86400));

$posts_per_day = $member['user_posts'] / $memberdays;

$percentage = ($config['num_posts']) ? min(100, ($num_real_posts / $config['num_posts']) * 100) : 0;

$template->assign_vars(array(

'POSTS_DAY' => sprintf($user->lang['POST_DAY'], $posts_per_day),

'POSTS_PCT' => sprintf($user->lang['POST_PCT'], $percentage),

'ACTIVE_TOPIC' => $active_t_name,

'OCCUPATION' => (!empty($member['user_occ'])) ? $member['user_occ'] : '',

'INTERESTS' => (!empty($member['user_interests'])) ? $member['user_interests'] : '',

'AVATAR_IMG' => $poster_avatar,

'PM_IMG' => $user->img('btn_pm', $user->lang['MESSAGE']),

'AIM_IMG' => $user->img('btn_aim', $user->lang['AIM']),

'MSN_IMG' => $user->img('btn_msnm', $user->lang['MSNM']),

'YIM_IMG' => $user->img('btn_yim', $user->lang['YIM']),

'U_ACTIVE_FORUM' => "viewforum.$phpEx$SID&f=$active_f_id",

'U_ACTIVE_TOPIC' => "viewtopic.$phpEx$SID&t=$active_t_id",)

);

if (!$topic_id)

{

// Get the appropriate username, etc.

FROM ' . USERS_TABLE . "

WHERE user_id = $user_id

AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')';

}

else

{

FROM ' . TOPICS_TABLE . "

WHERE topic_id = $topic_id";

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

{

if (!$topic_id)

{

{

$error[] = $user->lang['EMPTY_SUBJECT_EMAIL'];

}

{

$error[] = $user->lang['EMPTY_MESSAGE_EMAIL'];

}

}

else

{

{

$error[] = $user->lang['EMPTY_ADDRESS_EMAIL'];

}

{

$error[] = $user->lang['EMPTY_NAME_EMAIL'];

}

'BOARD_EMAIL' => $config['board_contact'],

'FROM_USERNAME' => $user->data['username'],

'TO_USERNAME' => ($topic_id) ? $name : $row['username'],

'U_TOPIC' => ($topic_id) ? generate_board_url() . "/viewtopic.$phpEx?f=" . $row['forum_id'] . "&t=$topic_id" : '')

);

$messenger->queue->save();

meta_refresh(3, "index.$phpEx$SID");

trigger_error($user->lang['EMAIL_SENT'] . '<br /><br />' . $message);

}

}

if ($topic_id)

{

$template->assign_vars(array(

'S_LANG_OPTIONS'=> ($topic_id) ? language_select($email_lang) : '')

);

}

$template->assign_vars(array(

'S_POST_ACTION' => (!$topic_id) ? "memberlist.$phpEx$SID&amp;mode=email&amp;u=$user_id" : "memberlist.$phpEx$SID&amp;mode=email&amp;f=$forum_id&amp;t=$topic_id",

'S_SEND_USER' => (!$topic_id) ? true : false)

);

break;

default:

// The basic memberlist

$page_title = $user->lang['MEMBERLIST'];

// 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'], 'e' => $user->lang['SORT_EMAIL'], 'f' => $user->lang['WEBSITE'], 'g' => $user->lang['ICQ'], 'h' => $user->lang['AIM'], 'i' => $user->lang['MSNM'], 'j' => $user->lang['YIM'], 'k' => $user->lang['SORT_LAST_ACTIVE'], 'l' => $user->lang['SORT_RANK']);

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

$s_find_active_time .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>';

}

if ($ipdomain)

{

$ips = (preg_match('#[a-z]#', $ipdomain)) ? implode(', ', 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))) : "'" . str_replace('*', '%', $ipdomain) . "'";

WHERE poster_ip ' . ((preg_match('#%#', $ips)) ? 'LIKE' : 'IN') . " ($ips)";

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

}

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

}

else

{

// A minor fudge but it does the job :D

}

}

}

// Sorting and order

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

// Count the users ...

{

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

$total_users = ($row = $db->sql_fetchrow($result)) ? $row['total_users'] : 0;

$total_users = $config['num_users'];

}

// Pagination string

$pagination_url = "memberlist.$phpEx$SID&amp;mode=$mode";

$pagination_url .= '&amp;' . $key . '=' . urlencode(htmlspecialchars($var));

}

// Some search user specific data

if ($mode == 'searchuser' && ($config['load_search'] || $auth->acl_get('a_')))

{

'MSNM' => $msn,

'JOINED' => implode('-', $joined),

'ACTIVE' => implode('-', $active),

'S_SEARCH_USER' => true,

'S_FORM_NAME' => $form,

);

}

WHERE session_time >= ' . (time() - 300) . '

AND session_user_id <> ' . ANONYMOUS . '

GROUP BY session_user_id';

$db->sql_freeresult($result);

// Do the SQL thang

ORDER BY $order_by";

$result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);

$template->assign_block_vars('memberrow', array_merge(show_profile($row), array(

'ROW_NUMBER' => $i + ($start + 1),

'U_VIEWPROFILE' => "memberlist.$phpEx$SID&amp;mode=viewprofile&amp;u=" . $row['user_id']))

);

// Generate page

$template->assign_vars(array(

'PAGINATION' => generate_pagination($pagination_url, $total_users, $config['topics_per_page'], $start),

'PM_IMG' => $user->img('btn_pm', $user->lang['MESSAGE']),

'EMAIL_IMG' => $user->img('btn_email', $user->lang['EMAIL']),

'WWW_IMG' => $user->img('btn_www', $user->lang['WWW']),

'AIM_IMG' => $user->img('btn_aim', $user->lang['AIM']),

'MSN_IMG' => $user->img('btn_msnm', $user->lang['MSNM']),

'YIM_IMG' => $user->img('btn_yim', $user->lang['YIM']),

);

}

// ---------

//

function show_profile($data)

{

$last_visit = (!empty($data['session_time'])) ? $data['session_time'] : $data['user_lastvisit'];

// Dump it out to the template

// Add permission check for IM clients

return array(

'JOINED' => $user->format_date($data['user_regdate'], $user->lang['DATE_FORMAT']),

'VISITED' => (empty($last_visit)) ? ' - ' : $user->format_date($last_visit, $user->lang['DATE_FORMAT']),

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

'RANK_IMG' => $rank_img,

'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" border="0" />' : '',

'U_EMAIL' => $email,

'U_WWW' => (!empty($data['user_website'])) ? $data['user_website'] : '',

'U_ICQ' => ($data['user_icq']) ? "memberlist.$phpEx$SID&amp;mode=contact&amp;action=icq&amp;u=$user_id" : '',

);

}

//

// ---------

?> \ No newline at end of file