{

$config[$row['config_name']] = $row['config_value'];

}

}

else

{

'i_close' => '</span>',

'u_open' => '<span style="text-decoration: underline">',

'u_close' => '</span>',

'img' => '<img src="$1" border="0" />',

'size' => '<span style="font-size: $1px; line-height: normal">$2</span>',

'color' => '<span style="color: $1">$2</span>',

switch (SQL_LAYER)

{

case 'mysql':

$sql .= (($sql != '') ? ', ' : '') . '(' . $user->data['user_id'] . ", $forum_id, $current_time)";

$sql = 'VALUES ' . $sql;

break;

case 'mssql':

case 'sqlite':

$sql .= (($sql != '') ? ' UNION ALL ' : '') . ' SELECT ' . $user->data['user_id'] . ", $forum_id, $current_time";

$url = str_replace('&amp;', '&', $url);

// Local redirect? If not, prepend the boards url

// Redirect via an HTML form for PITA webservers

if (@preg_match('#Microsoft|WebSTAR|Xitami#', getenv('SERVER_SOFTWARE')))

'L_INDEX' => $user->lang['FORUM_INDEX'],

'L_ONLINE_EXPLAIN' => $l_online_time,

'U_RETURN_INBOX' => "{$phpbb_root_path}ucp.$phpEx$SID&i=pm&folder=inbox",

'U_POPUP_PM' => "{$phpbb_root_path}ucp.$phpEx$SID&i=pm&mode=popup",

'U_MEMBERLIST' => "{$phpbb_root_path}memberlist.$phpEx$SID",

'T_THEME_PATH' => "{$phpbb_root_path}styles/" . $user->theme['primary']['theme_path'] . '/theme',

'T_TEMPLATE_PATH' => "{$phpbb_root_path}styles/" . $user->theme['primary']['template_path'] . '/template',

'T_IMAGESET_PATH' => "{$phpbb_root_path}styles/" . $user->theme['primary']['imageset_path'] . '/imageset',

'T_STYLESHEET_LINK' => (!$user->theme['primary']['theme_storedb']) ? "{$phpbb_root_path}styles/" . $user->theme['primary']['theme_path'] . '/theme/stylesheet.css' : "{$phpbb_root_path}style.$phpEx?sid=$user->session_id&amp;id=" . $user->theme['primary']['theme_id'],

'T_STYLESHEET_NAME' => $user->theme['primary']['theme_name'],

'T_THEME_DATA' => (!$user->theme['primary']['theme_storedb']) ? '' : $user->theme['primary']['theme_data'])

'#<!\-\- e \-\-><a href="mailto:(.*?)">.*?</a><!\-\- e \-\->#',

'#<!\-\- m \-\-><a href="(.*?)" target="_blank">.*?</a><!\-\- m \-\->#',

'#<!\-\- w \-\-><a href="http:\/\/(.*?)" target="_blank">.*?</a><!\-\- w \-\->#',

'#<!\-\- s(.*?) \-\-><img src="\{SMILE_PATH\}\/.*? \/><!\-\- s\1 \-\->#',

'#<!\-\- h \-\-><(.*?)><!\-\- h \-\->#',

'#<.*?>#s'

switch (SQL_LAYER)

{

case 'mysql':

$sql .= (($sql != '') ? ', ' : '') . "($ban_entry, $current_time, $ban_end, $ban_exclude, '$ban_reason')";

break;

case 'mssql':

case 'sqlite':

$sql .= (($sql != '') ? ' UNION ALL ' : '') . " SELECT $ban_entry, $current_time, $ban_end, $ban_exclude, '$ban_reason'";

switch (SQL_LAYER)

{

case 'mysql':

$sql = 'INSERT INTO ' . USER_GROUP_TABLE . " (user_id, group_id, group_leader)

VALUES " . implode(', ', preg_replace('#^([0-9]+)$#', "(\\1, $group_id, $leader)", $add_id_ary));

$db->sql_query($sql);

break;

case 'mssql':

case 'sqlite':

$sql = 'INSERT INTO ' . USER_GROUP_TABLE . " (user_id, group_id, group_leader)

" . implode(' UNION ALL ', preg_replace('#^([0-9]+)$#', "(\\1, $group_id, $leader)", $add_id_ary));

'#<!\-\- e \-\-><a href="mailto:(.*?)">.*?</a><!\-\- e \-\->#',

'#<!\-\- m \-\-><a href="(.*?)" target="_blank">.*?</a><!\-\- m \-\->#',

'#<!\-\- w \-\-><a href="http:\/\/(.*?)" target="_blank">.*?</a><!\-\- w \-\->#',

'#<!\-\- s(.*?) \-\-><img src="\{SMILE_PATH\}\/.*? \/><!\-\- s\1 \-\->#',

'#<!\-\- h \-\-><(.*?)><!\-\- h \-\->#',

);

// relative urls for this board

$match[] = '#(^|[\n ]|\()(' . preg_quote($server_protocol . trim($server_name) . $server_port . preg_replace('/^\/?(.*?)(\/)?$/', '$1', trim($script_path)), '#') . ')/(.*?([^ \t\n\r<"\'\)]*)?)#i';

// matches a xxxx://aaaaa.bbb.cccc. ...

$match[] = '#(^|[\n ]|\()([\w]+?://.*?([^ \t\n\r<"\'\)]*)?)#ie';

switch (SQL_LAYER)

{

case 'mysql':

$sql = 'INSERT INTO ' . SEARCH_WORD_TABLE . ' (word_text)

VALUES ' . implode(', ', preg_replace('#^(.*)$#', '(\'$1\')', $new_words));

$db->sql_query($sql);

break;

case 'mssql':

case 'sqlite':

$sql = 'INSERT INTO ' . SEARCH_WORD_TABLE . ' (word_text) ' . implode(' UNION ALL ', preg_replace('#^(.*)$#', "SELECT '\$1'", $new_words));

break;

case 'options':

get_folder($user->data['user_id'], $folder);

include($phpbb_root_path . 'includes/ucp/ucp_pm_options.'.$phpEx);

case 'unread':

case 'view_messages':

if ($folder_specified)

{

$folder_id = $folder_specified;

$rule_lang = $action_lang = $check_lang = array();

// Build all three language arrays

/*

Rule Ordering:

switch (SQL_LAYER)

{

case 'mysql':

$sql = 'INSERT INTO ' . ZEBRA_TABLE . " (user_id, zebra_id, $sql_mode)

VALUES " . implode(', ', preg_replace('#^([0-9]+)$#', '(' . $user->data['user_id'] . ", \\1, 1)", $user_id_ary));

$db->sql_query($sql);

break;

case 'mssql':

case 'sqlite':

$sql = 'INSERT INTO ' . ZEBRA_TABLE . " (user_id, zebra_id, $sql_mode)

" . implode(' UNION ALL ', preg_replace('#^([0-9]+)$#', '(' . $user->data['user_id'] . ", \\1, 1)", $user_id_ary));

# MSSQL IDENTITY phpbb_styles_template ON #

# -- phpbb_styles_template

# MSSQL IDENTITY phpbb_styles_template OFF #

'DRAFTS_EXPLAIN' => 'Here you can view, edit and delete your saved drafts.',

'DRAFT_UPDATED' => 'Draft successfully updated.',

'EMAIL_INVALID_EMAIL' => 'The email address you entered is invalid.',

'EMAIL_REMIND' => 'This must be the email address you supplied when registering.',

'EMAIL_PM' => 'Email PM',

$topic_id = (int) $topic_id;

$post_id = (int) $post_id;

$post_edit_locked = (isset($post_edit_locked)) ? (int) $post_edit_locked : 0;

$user->setup(array('posting', 'mcp', 'viewtopic'), $forum_style);

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

{

$refresh = true;

$template->assign_var('S_DRAFT_LOADED', true);

}

}

$sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id'])) ? ', user_posts = user_posts + 1' : '');

{

}

break;

case 'reply':

$sql_data[TOPICS_TABLE]['stat'][] = 'topic_replies_real = topic_replies_real + 1, topic_bumped = 0, topic_bumper = 0' . ((!$auth->acl_get('f_moderate', $data['forum_id'])) ? ', topic_replies = topic_replies + 1' : '');

$sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id'])) ? ', user_posts = user_posts + 1' : '');

{

$sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts + 1';

}