+ 'pm_edit_time' => array('lang' => 'PM_EDIT_TIME', 'type' => 'text:3:3', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

+ 'edit_time' => array('lang' => 'EDIT_TIME', 'type' => 'text:3:3', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

+ 'S_EDIT' => true,

+

+ ORDER BY role_order ASC";

+ // Display assigned items?

+ $display_item = request_var('display_item', 0);

+

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

+ $db->sql_freeresult($result);

+ // Re-assign permissions

+ // Trace has other vars

+ if ($mode == 'trace')

+ {

+ $user_id = request_var('u', 0);

+ $forum_id = request_var('f', 0);

+ $permission = request_var('auth', '');

+

+ $this->tpl_name = 'permission_trace';

+

+ if ($user_id && isset($auth_admin->option_ids[$permission]) && $auth->acl_get('a_viewauth'))

+ {

+ $this->page_title = sprintf($user->lang['TRACE_PERMISSION'], $user->lang['acl_' . $permission]['lang']);

+ $this->permission_trace($user_id, $forum_id, $permission);

+ return;

+ }

+

+ trigger_error('NO_MODE');

+ }

+

+

+ /**

+ * Display a complete trace tree for the selected permission to determine where settings are set/unset

+ */

+ function permission_trace($user_id, $forum_id, $permission)

+ {

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

+

+ $sql = 'SELECT username

+ FROM ' . USERS_TABLE . '

+ WHERE user_id = ' . $user_id;

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

+ $username = (string) $db->sql_fetchfield('username');

+ $db->sql_freeresult($result);

+

+ if (!$username)

+ {

+ trigger_error('NO_USERS');

+ }

+

+ $template->assign_vars(array(

+ 'PERMISSION' => $user->lang['acl_' . $permission]['lang'],

+ 'PERMISSION_USERNAME' => $username)

+ );

+

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

+ 'WHO' => $user->lang['DEFAULT'],

+ 'INFORMATION' => $user->lang['TRACE_DEFAULT'],

+

+ 'S_SETTING_UNSET' => true,

+ 'S_TOTAL_UNSET' => true)

+ );

+

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

+ FROM ' . GROUPS_TABLE . ' g

+ LEFT JOIN ' . USER_GROUP_TABLE . ' ug ON (ug.group_id = g.group_id)

+ WHERE ug.user_id = ' . $user_id . '

+ ORDER BY g.group_type DESC, g.group_id DESC';

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

+

+ $groups = array();

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

+ {

+ $groups[$row['group_id']] = array(

+ 'auth_setting' => ACL_UNSET,

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

+ );

+ }

+ $db->sql_freeresult($result);

+

+ if (sizeof($groups))

+ {

+ // Get group auth settings

+ $hold_ary = $auth->acl_group_raw_data(array_keys($groups), $permission, $forum_id);

+

+ foreach ($hold_ary as $group_id => $forum_ary)

+ {

+ $groups[$group_id]['auth_setting'] = $hold_ary[$group_id][$forum_id][$permission];

+ }

+ unset($hold_ary);

+

+ $total = ACL_UNSET;

+ foreach ($groups as $id => $row)

+ {

+ switch ($row['auth_setting'])

+ {

+ case ACL_UNSET:

+ $information = $user->lang['TRACE_GROUP_UNSET'];

+ break;

+

+ case ACL_YES:

+ $information = ($total == ACL_YES) ? $user->lang['TRACE_GROUP_YES_TOTAL_YES'] : (($total == ACL_NO) ? $user->lang['TRACE_GROUP_YES_TOTAL_NO'] : $user->lang['TRACE_GROUP_YES_TOTAL_UNSET']);

+ $total = ($total == ACL_UNSET) ? ACL_YES : $total;

+ break;

+

+ case ACL_NO:

+ $information = ($total == ACL_YES) ? $user->lang['TRACE_GROUP_NO_TOTAL_YES'] : (($total == ACL_NO) ? $user->lang['TRACE_GROUP_NO_TOTAL_NO'] : $user->lang['TRACE_GROUP_NO_TOTAL_UNSET']);

+ $total = ACL_NO;

+ break;

+ }

+

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

+ 'WHO' => $row['group_name'],

+ 'INFORMATION' => $information,

+

+ 'S_SETTING_UNSET' => ($row['auth_setting'] == ACL_UNSET) ? true : false,

+ 'S_SETTING_YES' => ($row['auth_setting'] == ACL_YES) ? true : false,

+ 'S_SETTING_NO' => ($row['auth_setting'] == ACL_NO) ? true : false,

+ 'S_TOTAL_UNSET' => ($total == ACL_UNSET) ? true : false,

+ 'S_TOTAL_YES' => ($total == ACL_YES) ? true : false,

+ 'S_TOTAL_NO' => ($total == ACL_NO) ? true : false)

+ );

+ }

+ }

+

+ // Get user specific permission...

+ $hold_ary = $auth->acl_user_raw_data($user_id, $permission, $forum_id);

+ $auth_setting = (!sizeof($hold_ary)) ? ACL_UNSET : $hold_ary[$user_id][$forum_id][$permission];

+

+ switch ($auth_setting)

+ {

+ case ACL_UNSET:

+ $information = ($total == ACL_UNSET) ? $user->lang['TRACE_USER_UNSET_TOTAL_UNSET'] : $user->lang['TRACE_USER_KEPT'];

+ $total = ($total == ACL_UNSET) ? ACL_NO : $total;

+ break;

+

+ case ACL_YES:

+ $information = ($total == ACL_YES) ? $user->lang['TRACE_USER_YES_TOTAL_YES'] : (($total == ACL_NO) ? $user->lang['TRACE_USER_YES_TOTAL_NO'] : $user->lang['TRACE_USER_YES_TOTAL_UNSET']);

+ $total = ($total == ACL_UNSET) ? ACL_YES : $total;

+ break;

+

+ case ACL_NO:

+ $information = ($total == ACL_YES) ? $user->lang['TRACE_USER_NO_TOTAL_YES'] : (($total == ACL_NO) ? $user->lang['TRACE_USER_NO_TOTAL_NO'] : $user->lang['TRACE_USER_NO_TOTAL_UNSET']);

+ $total = ACL_NO;

+ break;

+ }

+

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

+ 'WHO' => $username,

+ 'INFORMATION' => $information,

+

+ 'S_SETTING_UNSET' => ($auth_setting == ACL_UNSET) ? true : false,

+ 'S_SETTING_YES' => ($auth_setting == ACL_YES) ? true : false,

+ 'S_SETTING_NO' => ($auth_setting == ACL_NO) ? true : false,

+ 'S_TOTAL_UNSET' => ($total == ACL_UNSET) ? true : false,

+ 'S_TOTAL_YES' => ($total == ACL_YES) ? true : false,

+ 'S_TOTAL_NO' => ($total == ACL_NO) ? true : false)

+ );

+ }

+ /**

+ * @todo Adjust for every database

+ */

+

+ $sql .= ' VARCHAR(255) ';

+ $sql .= 'VARCHAR(10) ';

+ $sql .= "TEXT";

+// ADD {$field_ident}_bbcode_uid VARCHAR(5) NOT NULL,

+// ADD {$field_ident}_bbcode_bitfield INT(11) UNSIGNED";

+ $sql .= 'TINYINT(2) ';

+ $sql .= 'MEDIUMINT(8) ';

+ $sql .= 'BIGINT(20) ';

+ if (isset($_REQUEST['action']) && is_array($_REQUEST['action']))

+ {

+ $action = request_var('action', array('' => false));

+ $action = key($action);

+ }

+ else

+ {

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

+ }

+

+ // Allow trace for viewing permissions and in user mode

+ $show_trace = ($mode == 'view' && $user_mode == 'user') ? true : false;

+

+ $title = ($role_row['role_description']) ? ' title="' . nl2br($role_row['role_description']) . '"' : '';

+ $s_role_options .= '<option value="' . $role_id . '"' . (($role_id == $current_role_id) ? ' selected="selected"' : '') . $title . '>' . $role_row['role_name'] . '</option>';

+ $s_role_options = '<option value="0"' . ((!$current_role_id) ? ' selected="selected"' : '') . '>' . $user->lang['NO_ROLE_ASSIGNED'] . '</option>' . $s_role_options;

+ $this->assign_cat_array($ug_array, $tpl_pmask . '.' . $tpl_fmask . '.' . $tpl_category, $tpl_mask, $ug_id, $forum_id, $show_trace);

+ $title = ($role_row['role_description']) ? ' title="' . nl2br($role_row['role_description']) . '"' : '';

+ $s_role_options .= '<option value="' . $role_id . '"' . (($role_id == $current_role_id) ? ' selected="selected"' : '') . $title . '>' . $role_row['role_name'] . '</option>';

+ if (!$forum_id)

+ {

+ $folder_image = '';

+ }

+ else

+ {

+ if ($forum_names_ary[$forum_id]['forum_status'] == ITEM_LOCKED)

+ {

+ $folder_image = '<img src="images/icon_folder_lock_small.gif" width="19" height="18" alt="' . $user->lang['FORUM_LOCKED'] . '" />';

+ }

+ else

+ {

+ switch ($forum_names_ary[$forum_id]['forum_type'])

+ {

+ case FORUM_LINK:

+ $folder_image = '<img src="images/icon_folder_link_small.gif" width="22" height="18" alt="' . $user->lang['FORUM_LINK'] . '" />';

+ break;

+

+ default:

+ $folder_image = ($forum_names_ary[$forum_id]['left_id'] + 1 != $forum_names_ary[$forum_id]['right_id']) ? '<img src="images/icon_folder_sub_small.gif" width="22" height="18" alt="' . $user->lang['SUBFORUM'] . '" />' : '<img src="images/icon_folder_small.gif" width="19" height="18" alt="' . $user->lang['FOLDER'] . '" />';

+ }

+ }

+ }

+

+ 'FOLDER_IMAGE' => $folder_image,

+ $this->assign_cat_array($forum_array, $tpl_pmask . '.' . $tpl_fmask . '.' . $tpl_category, $tpl_mask, $ug_id, $forum_id, $show_trace);

+ reset($auth);

+ reset($auth);

+ function assign_cat_array(&$category_array, $tpl_cat, $tpl_mask, $ug_id, $forum_id, $show_trace = false)

+ global $template, $user, $phpbb_admin_path, $phpEx, $SID;

+

+ 'U_TRACE' => ($show_trace) ? "{$phpbb_admin_path}index.$phpEx$SID&amp;i=permissions&amp;mode=trace&amp;u=$ug_id&amp;f=$forum_id&amp;auth=$permission" : '',

+

+ 'trace' => array('title' => 'ACP_PERMISSION_TRACE', 'auth' => 'acl_a_viewauth', 'display' => false),

+ ORDER BY r.role_order ASC";

+ LEFT JOIN ' . ACL_ROLES_DATA_TABLE . ' r ON (a.auth_role_id = r.role_id)

+ if ($auth->acl_get('a_') || defined('IN_INSTALL'))

+function watch_topic_forum($mode, &$s_watching, &$s_watching_img, $user_id, $forum_id, $topic_id, $notify_status = 'unset', $start = 0)

+ $match_id = ($mode == 'forum') ? $forum_id : $topic_id;

+

+ $u_url = ($mode == 'forum') ? 'f' : 'f=' . $forum_id . '&amp;t';

+

+ // Do not display the users password

+ if (strpos($trace['function'], 'login') !== false)

+ {

+ if (isset($args[1]))

+ {

+ $args[1] = "'***'";

+ }

+ }

+

+ $sql = 'SELECT forum_id, parent_id, forum_name, forum_type, forum_status, left_id, right_id

+ // Include some more informations...

+ $mimetype = '';

+

+ // Some browsers choke on a mimetype of application/octet-stream

+ if (!$mimetype || $mimetype == 'application/octet-stream')

+ if ($$which_ary && !is_array($$which_ary))

+ $edit_comment = request_var('edit_comment', array(0 => ''));

+ $edit_comment = key($edit_comment);

+ if ($load = @file_get_contents('/proc/loadavg'))

+ $this->load = floatval(array_slice(explode(' ', $load), 0, 1));

+ if ($config['limit_load'] && $this->load > floatval($config['limit_load']))

+

+ 'S_DELETED_TOPIC' => (!$row['topic_id']) ? true : false,

+ 'S_GLOBAL_TOPIC' => (!$forum_id) ? true : false,

+