<?php

*

* @package ucp

* @version $Id$

*

*/

/**

* ucp_activate

* User activation

* @package ucp

<?php

*

* @package ucp

* @version $Id$

*

*/

/**

* ucp_attachments

* User attachments

* @package ucp

$db->sql_freeresult($result);

$sql = 'SELECT a.*, t.topic_title, p.message_subject as message_title

LEFT JOIN ' . TOPICS_TABLE . ' t ON (a.topic_id = t.topic_id AND a.in_message = 0)

LEFT JOIN ' . PRIVMSGS_TABLE . ' p ON (a.post_msg_id = p.msg_id AND a.in_message = 1)

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

);

$row_count++;

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

}

$db->sql_freeresult($result);

'PAGE_NUMBER' => on_page($num_attachments, $config['topics_per_page'], $start),

'PAGINATION' => generate_pagination($this->u_action . "&amp;sk=$sort_key&amp;sd=$sort_dir", $num_attachments, $config['topics_per_page'], $start),

'TOTAL_ATTACHMENTS' => $num_attachments,

'L_TITLE' => $user->lang['UCP_ATTACHMENTS'],

'S_DISPLAY_MARK_ALL' => ($num_attachments) ? true : false,

'S_DISPLAY_PAGINATION' => ($num_attachments) ? true : false,

<?php

*

* @package VC

* @version $Id$

*

*/

/**

* ucp_confirm

* Visual confirmation

*

* Note to potential users of this code ...

*

* Remember this is released under the _GPL_ and is subject

* released or distributed in any way under a licence other

* than the GPL. We will be watching ... ;)

*

// Try and grab code for this id and session

$sql = 'SELECT code, seed

AND confirm_id = '" . $db->sql_escape($confirm_id) . "'

AND confirm_type = $type";

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

*/

/**

* ucp_groups

* @package ucp

*/

if ($group_id)

{

WHERE group_id = $group_id";

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

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

{

// Avatar stuff

$var_ary = array(

);

if (!($error = validate_data($data, $var_ary)))

if (!sizeof($error))

{

// Only set the rank, colour, etc. if it's changed or if we're adding a new

// were made.

$group_attributes = array();

$group_rank = $group_row['group_rank'];

}

FROM ' . RANKS_TABLE . '

WHERE rank_special = 1

ORDER BY rank_title';

$start = request_var('start', 0);

// Grab the leaders - always, on every page...

AND u.user_id = ug.user_id

AND ug.group_leader = 1

ORDER BY ug.group_leader DESC, ug.user_pending ASC, u.username_clean";

$db->sql_freeresult($result);

// Total number of group members (non-leaders)

AND group_leader = 0";

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

$total_members = (int) $db->sql_fetchfield('total_members');

$db->sql_freeresult($result);

// Grab the members

AND u.user_id = ug.user_id

AND ug.group_leader = 0

ORDER BY ug.group_leader DESC, ug.user_pending ASC, u.username_clean";

do

{

FROM ' . USER_GROUP_TABLE . "

ORDER BY user_id";

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

<?php

*

* @package ucp

* @version $Id$

*

*/

/**

* ucp_main

* UCP Front Panel

* @package ucp

if ($config['load_db_track'])

{

AND tp.user_id = ' . $user->data['user_id'] . ')';

$sql_select .= ', tp.topic_posted';

}

$forum_ary = array_unique(array_keys($forum_ary));

// Determine first forum the user is able to read into - for global announcement link

FROM ' . FORUMS_TABLE . '

WHERE forum_type = ' . FORUM_POST;

$g_forum_id = (int) $db->sql_fetchfield('forum_id');

$db->sql_freeresult($result);

FROM $sql_from

WHERE t.forum_id = 0

AND t.topic_type = " . POST_GLOBAL . '

display_user_activity($user->data);

}

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

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

$percentage = ($config['num_posts']) ? min(100, ($user->data['user_posts'] / $config['num_posts']) * 100) : 0;

$template->assign_vars(array(

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

'VISITED' => (empty($last_visit)) ? ' - ' : $user->format_date($last_visit),

'WARNINGS' => ($user->data['user_warnings']) ? $user->data['user_warnings'] : 0,

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

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

'U_SEARCH_USER' => ($auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", 'author_id=' . $user->data['user_id'] . '&amp;sr=posts') : '',

));

FORUMS_TABLE => 'f'

),

AND f.forum_id = fw.forum_id

AND ' . $db->sql_in_set('f.forum_id', $forbidden_forums, true, true),

}

$template->assign_block_vars('forumrow', array(

'FORUM_FOLDER_IMG' => $user->img($folder_image, $folder_alt),

'FORUM_FOLDER_IMG_SRC' => $user->img($folder_image, $folder_alt, false, '', 'src'),

'FORUM_IMAGE' => ($row['forum_image']) ? '<img src="' . $phpbb_root_path . $row['forum_image'] . '" alt="' . $user->lang[$folder_alt] . '" />' : '',

'LAST_POST_AUTHOR_FULL' => get_username_string('full', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),

'U_LAST_POST_AUTHOR' => get_username_string('profile', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),

'U_VIEWFORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']))

);

}

'draft_message' => $draft_message

);

WHERE draft_id = $draft_id

AND user_id = " . $user->data['user_id'];

$db->sql_query($sql);

$sql = 'SELECT * FROM ' . DRAFTS_TABLE . '

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

(($edit) ? "AND draft_id = $draft_id" : '') . '

AND topic_id = 0

ORDER BY save_time DESC';

}

}

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

'S_HIDDEN_FIELDS' => (isset($s_hidden_fields)) ? $s_hidden_fields : '',

'S_UCP_ACTION' => $this->u_action,

*

*/

* Private Message Class

*

* $_REQUEST['folder'] display folder with the id used

$sql = 'SELECT folder_id

FROM ' . PRIVMSGS_TO_TABLE . "

WHERE msg_id = $msg_id

AND user_id = ' . $user->data['user_id'];

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

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

*/

/**

* Compose private message

* Called from ucp_pm with mode == 'compose'

*/

<?php

*

* @package ucp

* @version $Id$

*

*/

/**

* Execute message options

*/

function message_options($id, $mode, $global_privmsgs_rules, $global_rule_conditions)

if ($folder_name)

{

FROM ' . PRIVMSGS_FOLDER_TABLE . "

WHERE folder_name = '" . $db->sql_escape($folder_name) . "'

AND user_id = " . $user->data['user_id'];

trigger_error('CANNOT_RENAME_FOLDER');

}

SET folder_name = '" . $db->sql_escape($new_folder_name) . "'

WHERE folder_id = $rename_folder_id

AND user_id = {$user->data['user_id']}";

{

$msg = $user->lang['FORM_INVALID'];

}

$message = $msg . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], '<a href="' . $redirect_url . '">', '</a>');

meta_refresh(3, $redirect_url);

trigger_error($message);

}

if (confirm_box(true))

{

// Gather message ids

FROM ' . PRIVMSGS_TO_TABLE . '

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

AND folder_id = $remove_folder_id";

'rule_folder_id' => $folder_id

);

FROM ' . PRIVMSGS_RULES_TABLE . '

WHERE ' . $db->sql_build_array('SELECT', $rule_ary);

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

$message = $user->lang['RULE_DELETED'];

// Reset user_message_rules if no more assigned

FROM ' . PRIVMSGS_RULES_TABLE . '

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

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

$db->sql_freeresult($result);

$folder[PRIVMSGS_INBOX] = array(

'message_status' => sprintf($user->lang['FOLDER_MESSAGE_STATUS'], $num_messages, $user->data['message_limit'])

);

FROM ' . PRIVMSGS_FOLDER_TABLE . '

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

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

{

$num_user_folder++;

$folder[$row['folder_id']] = array(

'message_status' => sprintf($user->lang['FOLDER_MESSAGE_STATUS'], $row['pm_count'], $user->data['message_limit'])

);

}

{

foreach ($check_lang as $value => $lang)

{

}

}

{

foreach ($check_ary as $value => $_check)

{

}

}

case 'group':

$rule_group_id = request_var('rule_group_id', 0);

$rule_string = utf8_normalize_nfc(request_var('rule_string', '', true));

$sql = 'SELECT g.group_id, g.group_name, g.group_type

FROM ' . GROUPS_TABLE . ' g ';

if (!$auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel'))

{

$sql .= 'LEFT JOIN ' . USER_GROUP_TABLE . ' ug

$rule_string = (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']);

}

$s_selected = ($row['group_id'] == $rule_group_id) ? ' selected="selected"' : '';

$s_group_options .= '<option value="' . $row['group_id'] . '"' . $s_class . $s_selected . '>' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';

<?php

*

* @package ucp

* @version $Id$

*

*/

/**

* View message folder

* Called from ucp_pm with mode == 'view' && action == 'view_folder'

*/

{

if ($ug_type == 'u')

{

FROM ' . USERS_TABLE . '

WHERE ';

}

<?php

*

* @package ucp

* @version $Id$

*

*/

/**

* View private message

*/

function view_message($id, $mode, $folder_id, $msg_id, $folder, $message_row)

<?php

*

* @package ucp

* @version $Id$

*

*/

/**

* ucp_prefs

* Changing user preferences

* @package ucp

*/

/**

* ucp_profile

* Changing profile settings

*

'user_sig_bbcode_bitfield' => $message_parser->bbcode_bitfield

);

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

$db->sql_query($sql);

*/

/**

* ucp_register

* Board registration

* @package ucp

<?php

*

* @package ucp

* @version $Id$

*

*/

/**

* ucp_remind

* Sending password reminders

* @package ucp

<?php

*

* @package ucp

* @version $Id$

*

*/

/**

* ucp_resend

* Resending activation emails

* @package ucp

<?php

*

* @package ucp

* @version $Id$

*

*/

/**

* ucp_zebra

* @package ucp

*/

$data['add'] = array_map('trim', array_map('utf8_clean_string', explode("\n", $data['add'])));

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

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

// may lead to complaints

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

AND u.user_id = z.zebra_id';

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

if (sizeof($data['add']))

{

$sql = 'SELECT user_id, user_type

WHERE ' . $db->sql_in_set('username_clean', $data['add']) . '

AND user_type <> ' . USER_INACTIVE;

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

// Force integer values

$data['usernames'] = array_map('intval', $data['usernames']);

AND ' . $db->sql_in_set('zebra_id', $data['usernames']);

$db->sql_query($sql);

}

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

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

AND u.user_id = z.zebra_id

ORDER BY u.username_clean ASC";

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

}

$db->sql_freeresult($result);

'L_TITLE' => $user->lang['UCP_ZEBRA_' . $l_mode],

'U_FIND_USERNAME' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&amp;form=ucp&amp;field=add'),