'hot_threshold' => array('lang' => 'HOT_THRESHOLD', 'validate' => 'int:0', 'type' => 'text:3:4', 'explain' => true),

'max_poll_options' => array('lang' => 'MAX_POLL_OPTIONS', 'validate' => 'int:2:127', 'type' => 'text:4:4', 'explain' => false),

'max_post_chars' => array('lang' => 'CHAR_LIMIT', 'validate' => 'int:0', 'type' => 'text:4:6', 'explain' => true),

'max_post_smilies' => array('lang' => 'SMILIES_LIMIT', 'validate' => 'int:0', 'type' => 'text:4:4', 'explain' => true),

'max_post_urls' => array('lang' => 'MAX_POST_URLS', 'validate' => 'int:0', 'type' => 'text:5:4', 'explain' => true),

'max_post_font_size' => array('lang' => 'MAX_POST_FONT_SIZE', 'validate' => 'int:0', 'type' => 'text:5:4', 'explain' => true, 'append' => ' %'),

$i = $j = 0;

$email_list = array();

$old_lang = $row['user_lang'];

$old_notify_type = $row['user_notify_type'];

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

// redirect directly to permission settings screen if authed

if ($action == 'add' && !$copied_permissions && $auth->acl_get('a_fauth'))

{

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

}

'RANK_TITLE' => (isset($ranks['rank_title'])) ? $ranks['rank_title'] : '',

'S_FILENAME_LIST' => $filename_list,

'RANK_IMAGE' => ($edit_img) ? $phpbb_root_path . $config['ranks_path'] . '/' . $edit_img : $phpbb_admin_path . 'images/spacer.gif',

'MIN_POSTS' => (isset($ranks['rank_min']) && !$ranks['rank_special']) ? $ranks['rank_min'] : 0)

);

$errstr = '';

$errno = 0;

if ($info === false)

{

// Which updates do we need to do?

$update_username = ($user_row['username'] != $data['username']) ? $data['username'] : false;

$update_email = ($data['email'] != $user_row['user_email']) ? $data['email'] : false;

if (!sizeof($error))

if (!$row)

{

return array(

'status' => LOGIN_ERROR_USERNAME,

'error_msg' => 'LOGIN_ERROR_USERNAME',

);

}

}

/**

* Check if table exists

*

*

}

/**

*

*

*/

{

switch ($this->sql_layer)

{

case 'mysql_40':

case 'mysql_41':

$sql = "SHOW COLUMNS FROM $table";

break;

// PostgreSQL has a way of doing this in a much simpler way but would

WHERE c.relname = '{$table}'

AND a.attnum > 0

AND a.attrelid = c.oid";

break;

// same deal with PostgreSQL, we must perform more complex operations than

FROM syscolumns c

LEFT JOIN sysobjects o ON c.id = o.id

WHERE o.name = '{$table}'";

break;

case 'oracle':

$sql = "SELECT column_name

FROM user_tab_columns

WHERE LOWER(table_name) = '" . strtolower($table) . "'";

break;

case 'firebird':

$sql = "SELECT RDB\$FIELD_NAME as FNAME

FROM RDB\$RELATION_FIELDS

WHERE RDB\$RELATION_NAME = '" . strtoupper($table) . "'";

break;

case 'sqlite':

$sql = "SELECT sql

FROM sqlite_master

WHERE type = 'table'

AND name = '{$table}'";

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

if (!$result)

continue;

}

}

break;

}

}

/**

case 'mysql_40':

case 'mysql_41':

break;

case 'mssql':

}

// no break

case 'mysql_41':

break;

case 'mssql':

return $cache->sql_fetchrow($query_id);

}

}

/**

/**

* Retrieve contents from remotely stored file

*/

{

global $user;

@fputs($fsock, "HOST: $host\r\n");

@fputs($fsock, "Connection: close\r\n\r\n");

$file_info = '';

$get_info = false;

return false;

}

}

}

@fclose($fsock);

}

'S_NO_CAT' => $catless && !$last_catless,

'S_IS_LINK' => ($row['forum_type'] == FORUM_LINK) ? true : false,

'S_UNREAD_FORUM' => $forum_unread,

'S_LOCKED_FORUM' => ($row['forum_status'] == ITEM_LOCKED) ? true : false,

'S_LIST_SUBFORUMS' => ($row['display_subforum_list']) ? true : false,

'S_SUBFORUMS' => (sizeof($subforums_list)) ? true : false,

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

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

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

// Is user watching this thread?

if ($user_id != ANONYMOUS)

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

$token = request_var('hash', '');

{

{

$redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&start=$start");

$message = $user->lang['ERR_UNWATCHING'] . '<br /><br />' . sprintf($user->lang['RETURN_' . strtoupper($mode)], '<a href="' . $redirect_url . '">', '</a>');

$db->sql_query($sql);

$redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");

meta_refresh(3, $redirect_url);

trigger_error($message);

}

$s_hidden_fields['t'] = $topic_id;

}

confirm_box(false, $confirm_box_message, build_hidden_fields($s_hidden_fields));

}

}

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

$token = request_var('hash', '');

{

{

$redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");

$message = $user->lang['ERR_WATCHING'] . '<br /><br />' . sprintf($user->lang['RETURN_' . strtoupper($mode)], '<a href="' . $redirect_url . '">', '</a>');

/**

* Get tables of a database

*/

{

{

}

}

/**

{

global $auth, $user, $db, $phpEx, $phpbb_root_path;

switch ($action)

{

case 'make_announce':

default:

$new_topic_type = POST_NORMAL;

$l_new_type = (sizeof($topic_ids) == 1) ? 'MCP_MAKE_NORMAL' : 'MCP_MAKE_NORMALS';

break;

}

$redirect = request_var('redirect', build_url(array('action', 'quickmod')));

$s_hidden_fields = array(

}

// Get Reports

{

$sql = 'SELECT r.*, re.*, u.user_id, u.username

FROM ' . REPORTS_TABLE . ' r, ' . USERS_TABLE . ' u, ' . REPORTS_REASONS_TABLE . " re

'MINI_POST_IMG' => ($post_unread) ? $user->img('icon_post_target_unread', 'UNREAD_POST') : $user->img('icon_post_target', 'POST'),

'S_CHECKED' => (($submitted_id_list && !in_array(intval($row['post_id']), $submitted_id_list)) || in_array(intval($row['post_id']), $checked_ids)) ? true : false,

'S_HAS_ATTACHMENTS' => (!empty($attachments[$row['post_id']])) ? true : false,

unset($input);

}

{

/**

* @ignore

if ($group_row[$group_id]['group_type'] == GROUP_FREE)

{

group_user_add($group_id, $user->data['user_id']);

}

else

{

group_user_add($group_id, $user->data['user_id'], false, false, false, 0, 1);

}

add_log('user', $user->data['user_id'], 'LOG_USER_GROUP_JOIN' . (($group_row[$group_id]['group_type'] == GROUP_FREE) ? '' : '_PENDING'), $group_row[$group_id]['group_name']);