{

if ($last_load !== false && $last_load >= $stamp)

{

// seems that we need those too ... browsers

header('Pragma: public');

header('Expires: ' . gmdate('D, d M Y H:i:s \G\M\T', time() + 31536000));

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

$cache->destroy('sql', FORUMS_TABLE);

// Copy permissions?

if ($forum_perm_from && $forum_perm_from != $forum_data['forum_id'] &&

($action != 'edit' || empty($forum_id) || ($auth->acl_get('a_fauth') && $auth->acl_get('a_authusers') && $auth->acl_get('a_authgroups') && $auth->acl_get('a_mauth'))))

{

copy_forum_permissions($forum_perm_from, $forum_data['forum_id'], ($action == 'edit') ? true : false);

cache_moderators();

}

/* Commented out because of questionable UI workflow - re-visit for 3.0.7

else if (!$this->parent_id && $action != 'edit' && $auth->acl_get('a_fauth') && $auth->acl_get('a_authusers') && $auth->acl_get('a_authgroups') && $auth->acl_get('a_mauth'))

$message = ($action == 'add') ? $user->lang['FORUM_CREATED'] : $user->lang['FORUM_UPDATED'];

// Redirect to permissions

{

$message .= '<br /><br />' . sprintf($user->lang['REDIRECT_ACL'], '<a href="' . append_sid("{$phpbb_admin_path}index.$phpEx", 'i=permissions' . $acl_url) . '">', '</a>');

}

// redirect directly to permission settings screen if authed

{

meta_refresh(4, append_sid("{$phpbb_admin_path}index.$phpEx", 'i=permissions' . $acl_url));

}

'mode' => $mode,

'prune' => 1,

'email' => request_var('email', ''),

'joined_select' => request_var('joined_select', ''),

'joined' => request_var('joined', ''),

{

global $user, $db;

if ($users)

{

}

else

{

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

$joined_select = request_var('joined_select', 'lt');

if ($search === false)

{

}

$result = @ldap_get_entries($ldap, $search);

define('NOTIFY_YES', 0);

define('NOTIFY_NO', 1);

// Email Priority Settings

define('MAIL_LOW_PRIORITY', 4);

define('MAIL_NORMAL_PRIORITY', 3);

return $url;

}

//Form validation

$user->setup();

}

{

}

$msg_text = (!empty($user->lang[$msg_text])) ? $user->lang[$msg_text] : $msg_text;

{

$topic_type_array = array_merge(array(0 => array(

'VALUE' => POST_NORMAL,

'L_TOPIC_TYPE' => $user->lang['POST_NORMAL'])),

$topic_type_array

if ($config['new_member_group_default'])

{

group_user_add($add_group_id, $user_id, false, false, true);

}

else

{

'ATTACH_ICON_IMG' => ($auth->acl_get('u_pm_download') && $row['message_attachment'] && $config['allow_pm_attach']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',

'S_PM_DELETED' => ($row['pm_deleted']) ? true : false,

'S_AUTHOR_DELETED' => ($row['author_id'] == ANONYMOUS) ? true : false,

'U_VIEW_PM' => ($row['pm_deleted']) ? '' : $view_message_url,

'U_REMOVE_PM' => ($row['pm_deleted']) ? $remove_message_url : '',

'RECIPIENTS' => ($folder_id == PRIVMSGS_OUTBOX || $folder_id == PRIVMSGS_SENTBOX) ? implode(', ', $address_list[$message_id]) : '')

);

}

'S_SHOW_RECIPIENTS' => ($folder_id == PRIVMSGS_OUTBOX || $folder_id == PRIVMSGS_SENTBOX) ? true : false,

'S_SHOW_COLOUR_LEGEND' => true,

'S_PM_ICONS' => ($config['enable_pm_icons']) ? true : false)

);

}

$sql_sort_order = $sort_by_sql[$sort_key] . ' ' . $direction;

}

FROM ' . PRIVMSGS_TO_TABLE . ' t, ' . PRIVMSGS_TABLE . ' p, ' . USERS_TABLE . " u

WHERE t.user_id = $user_id

AND p.author_id = u.user_id

ORDER BY $sql_sort_order";

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

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

{

$rowset[$row['msg_id']] = $row;

$pm_list[] = $row['msg_id'];

}

$db->sql_freeresult($result);

$pm_list = ($store_reverse) ? array_reverse($pm_list) : $pm_list;

return array(

'LAST_VISIT' => 'Last visit',

'LDAP_NO_LDAP_EXTENSION' => 'LDAP extension not available.',

'LDAP_NO_SERVER_CONNECTION' => 'Could not connect to LDAP server.',

'LEGEND' => 'Legend',

'LOCATION' => 'Location',

'LOCK_POST' => 'Lock post',

'PIXEL' => 'px',

'PLAY_QUICKTIME_FILE' => 'Play Quicktime file',

'PM' => 'PM',

'POSTING_MESSAGE' => 'Posting message in %s',

'POSTING_PRIVATE_MESSAGE' => 'Composing private message',

'POST' => 'Post',

<br /><em class="small">{L_PM_FROM_REMOVED_AUTHOR}</em>

<!-- ENDIF -->

<!-- IF S_SHOW_RECIPIENTS -->{L_MESSAGE_TO} {messagerow.RECIPIENTS}<!-- ELSE -->{L_MESSAGE_BY_AUTHOR} {messagerow.MESSAGE_AUTHOR_FULL} &raquo; {messagerow.SENT_TIME}<!-- ENDIF -->

</dt>

<!-- IF S_SHOW_RECIPIENTS --><dd class="info"><span>{L_SENT_AT}: {messagerow.SENT_TIME}</span></dd><!-- ENDIF -->

<!-- ENDIF -->

<!-- IF topicrow.S_FIRST_ROW or not topicrow.S_TOPIC_TYPE_SWITCH -->

<div class="inner"><span class="corners-top"><span></span></span>

<ul class="topiclist">

<li class="header">

<dl class="icon">

<dd class="posts">{L_REPLIES}</dd>

<dd class="views">{L_VIEWS}</dd>

<dd class="lastpost"><span>{L_LAST_POST}</span></dd>

<ul class="topiclist topics">

<!-- ENDIF -->

<dl class="icon" style="background-image: url({topicrow.TOPIC_FOLDER_IMG_SRC}); background-repeat: no-repeat;">

<dt<!-- IF topicrow.TOPIC_ICON_IMG and S_TOPIC_ICONS --> style="background-image: url({T_ICONS_PATH}{topicrow.TOPIC_ICON_IMG}); background-repeat: no-repeat;"<!-- ENDIF --> title="{topicrow.TOPIC_FOLDER_IMG_ALT}"><!-- IF topicrow.S_UNREAD_TOPIC --><a href="{topicrow.U_NEWEST_POST}">{NEWEST_POST_IMG}</a> <!-- ENDIF --><a href="{topicrow.U_VIEW_TOPIC}" class="topictitle">{topicrow.TOPIC_TITLE}</a>

<!-- IF topicrow.S_TOPIC_UNAPPROVED or topicrow.S_POSTS_UNAPPROVED --><a href="{topicrow.U_MCP_QUEUE}">{topicrow.UNAPPROVED_IMG}</a> <!-- ENDIF -->

margin-bottom: 3px;

}

/* Specific layout 2 */

fieldset.fields2 dt {

width: 15em;

<span class="gensmall">

<!-- IF U_PRINT_PM --><a href="{U_PRINT_PM}" title="{L_PRINT_PM}">{L_PRINT_PM}</a><!-- IF U_FORWARD_PM --> | <!-- ENDIF --><!-- ENDIF -->

<!-- IF U_FORWARD_PM --><a href="{U_FORWARD_PM}" title="{L_FORWARD_PM}">{L_FORWARD_PM}</a><!-- ENDIF -->

</span>

<!-- ENDIF -->

</td>

<!-- ELSE -->

<a href="{messagerow.U_VIEW_PM}">{messagerow.SUBJECT}</a>

<!-- ENDIF -->

<!-- IF messagerow.S_AUTHOR_DELETED -->

<br /><em class="gensmall">{L_PM_FROM_REMOVED_AUTHOR}</em>

<!-- ENDIF -->

{

return array(

array('phpbb_users', "username_clean = 'bertie'", array(array('username_clean' => 'bertie'))),

array('phpbb_users', 'username_clean syntax_error', false),

);

}

return array(

array('', array('barfoo', 'foobar', 'bertie')),

array('user_id = 2', array('foobar')),

);

}

array(0, 1, array(array('username_clean' => 'foobar'),

array('username_clean' => 'bertie'))),

array(1, 0, array(array('username_clean' => 'barfoo'))),

array(1, 2, array(array('username_clean' => 'bertie'))),

array(2, 0, array(array('username_clean' => 'barfoo'),

array('username_clean' => 'foobar'))),

array('bar*', array(array('username_clean' => 'barfoo'))),

array('*bar*', array(array('username_clean' => 'barfoo'),

array('username_clean' => 'foobar'))),

array('b*r', array()),

array('b*e', array(array('username_clean' => 'bertie'))),

array('#b*e', array()),

array('username_clean' => 'foobar'))),

array('user_id', 3, true, true, array(array('username_clean' => 'barfoo'),

array('username_clean' => 'foobar'))),

array('username_clean' => 'foobar'))),

array('username_clean' => 'foobar'))),

array('user_id', array(3), false, false, array(array('username_clean' => 'bertie'))),

array('user_id', array(3), false, true, array(array('username_clean' => 'bertie'))),

array('username_clean' => 'bertie'))),

array('user_id', array(1, 3), true, false, array(array('username_clean' => 'foobar'))),

array('user_id', array(1, 3), true, true, array(array('username_clean' => 'foobar'))),

array('username_clean' => 'foobar'),

array('username_clean' => 'bertie'))),

array('username_clean' => 'foobar'),

array('username_clean' => 'bertie'))),

array('user_id', array(), false, true, array()),

$db->sql_return_on_error(true);

}

FROM phpbb_users

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

if ($catch_error)

{

$db->sql_freeresult($result);

}