<dd><input type="radio" class="radio" name="popuppm" value="1"<!-- IF POPUP_PM --> id="popuppm" checked="checked"<!-- ENDIF --> />&nbsp; {L_YES} &nbsp;<input type="radio" class="radio" name="popuppm" value="0"<!-- IF not POPUP_PM --> id="popuppm" checked="checked"<!-- ENDIF --> />{L_NO}</dd>

</dl>

<dl>

<dt><label for="lang">{L_BOARD_LANGUAGE}:</label></dt>

<dd><select id="lang" name="lang">{S_LANG_OPTIONS}</select></dd>

</dl>

}

$db->sql_freeresult($result);

$extension_id_list = (isset($_POST['extension_id_list'])) ? array_map('intval', $_POST['extension_id_list']) : array();

if (sizeof($extension_id_list))

}

}

$add_extension = strtolower(request_var('add_extension', ''));

$add_extension_group = request_var('add_group_select', 0);

$add = (isset($_POST['add_extension_check'])) ? true : false;

$exe = ((defined('PHP_OS')) && (preg_match('#win#i', PHP_OS))) ? '.exe' : '';

{

$locations = array('C:/WINDOWS/', 'C:/WINNT/', 'C:/WINDOWS/SYSTEM/', 'C:/WINNT/SYSTEM/', 'C:/WINDOWS/SYSTEM32/', 'C:/WINNT/SYSTEM32/', '/usr/bin/', '/usr/sbin/', '/usr/local/bin/', '/usr/local/sbin/', '/opt/', '/usr/imagemagick/', '/usr/bin/imagemagick/');

$locations = array_merge($path_locations, $locations);

}

else

{

}

return $imagick;

'allow_pm_attach' => array('lang' => 'ALLOW_PM_ATTACHMENTS', 'type' => 'radio:yes_no', 'explain' => false),

'auth_download_pm' => array('lang' => 'ALLOW_DOWNLOAD_PM', 'type' => 'radio:yes_no', 'explain' => false),

'allow_sig_pm' => array('lang' => 'ALLOW_SIG_PM', 'type' => 'radio:yes_no', 'explain' => false),

'auth_quote_pm' => array('lang' => 'ALLOW_QUOTE_PM', 'type' => 'radio:yes_no', 'explain' => false),

'print_pm' => array('lang' => 'ALLOW_PRINT_PM', 'type' => 'radio:yes_no', 'explain' => false),

'email_pm' => array('lang' => 'ALLOW_EMAIL_PM', 'type' => 'radio:yes_no', 'explain' => false),

{

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

'CAT_NAME' => $user->lang['permission_cat'][$cat],

);

foreach ($cat_array['permissions'] as $permission => $allowed)

'notifypm' => true,

'popuppm' => false,

'allowpm' => true,

'topic_sk' => (string) 't',

'topic_sd' => (string) 'd',

if (!sizeof($error))

{

$this->optionset($user_row, 'popuppm', $data['popuppm']);

$this->optionset($user_row, 'viewimg', $data['view_images']);

$this->optionset($user_row, 'viewflash', $data['view_flash']);

$this->optionset($user_row, 'viewsmilies', $data['view_smilies']);

'NOTIFY_BOTH' => ($notify_method == NOTIFY_BOTH) ? true : false,

'NOTIFY_PM' => (isset($data['notifypm'])) ? $data['notifypm'] : $user_row['user_notify_pm'],

'POPUP_PM' => (isset($data['popuppm'])) ? $data['popuppm'] : $this->optionget($user_row, 'popuppm'),

'DST' => (isset($data['dst'])) ? $data['dst'] : $user_row['user_dst'],

'BBCODE' => (isset($data['bbcode'])) ? $data['bbcode'] : $this->optionget($user_row, 'bbcode'),

'SMILIES' => (isset($data['smilies'])) ? $data['smilies'] : $this->optionget($user_row, 'smilies'),

$s_role_js_array = array();

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

{

if (!isset($s_role_js_array[$row['role_id']]))

{

$s_role_js_array[$row['role_id']] = "\n" . 'role_options[' . $row['role_id'] . '] = new Array();' . "\n";

list(, $flag) = each(array_keys($auth));

$flag = substr($flag, 0, strpos($flag, '_') + 1);

$any_option_id = (int) $this->option_ids[$flag];

// Remove any-flag from auth ary

AND auth_option_id IN ($any_option_id, " . implode(', ', $auth_option_ids) . ')';

$db->sql_query($sql);

$sql_ary = array();

foreach ($forum_id as $forum)

{

$sql_ary[] = array(

$id_field => (int) $id,

'forum_id' => (int) $forum,

'auth_setting' => 0,

'auth_role_id' => $role_id

);

{

global $db;

// Remove current auth options...

$sql = 'DELETE FROM ' . ACL_ROLES_DATA_TABLE . '

WHERE role_id = ' . $role_id;

// First of all, lets grab the items having roles with the specified auth options assigned

$sql = "SELECT auth_role_id, $id_field, forum_id

WHERE auth_role_id <> 0

AND " . implode(' AND ', $where_sql) . '

ORDER BY auth_role_id';

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

// If one option is allowed, the global permission for this option has to be allowed too

// example: if the user has the a_ permission this means he has one or more a_* permissions

{

}

}

else

{

$setting = ($row['auth_role_id']) ? $row['role_auth_setting'] : $row['auth_setting'];

$hold_ary[$row['user_id']][$row['forum_id']][$row['auth_option']] = $setting;

}

}

$db->sql_freeresult($result);

{

$login = $method($username, $password);

{

}

}

}

{

global $db, $config;

FROM ' . USERS_TABLE . "

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

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

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

$db->sql_freeresult($result);

{

{

}

}

}

?> \ No newline at end of file

define('ACL_YES', 1);

define('ACL_UNSET', -1);

// Group settings

define('GROUP_OPEN', 0);

define('GROUP_CLOSED', 1);

define('PRIVMSGS_SENTBOX', -1);

define('PRIVMSGS_INBOX', 0);

// Full Folder Actions

define('FULL_FOLDER_NONE', -3);

define('FULL_FOLDER_DELETE', -2);

define('FULL_FOLDER_HOLD', -1);

// Download Modes - Attachments

define('INLINE_LINK', 1);

define('PHYSICAL_LINK', 2);

// Categories - Attachments

define('ATTACHMENT_CATEGORY_NONE', 0);

define('ATTACHMENT_CATEGORY_IMAGE', 1); // Inline Images

* Return unique id

* @param $extra additional entropy for call to mt_srand

*/

{

list($usec, $sec) = explode(' ', microtime());

mt_srand((float) $extra + (float) $sec + ((float) $usec * 100000));

}

if (!function_exists('array_combine'))

$admin = ($admin) ? 1 : 0;

// If authentication is successful we redirect user to previous page

{

// If admin authentication

if ($admin)

}

else

{

add_log('admin', 'LOG_ADMIN_AUTH_FAIL');

}

}

trigger_error($message);

}

if ($admin)

{

add_log('admin', 'LOG_ADMIN_AUTH_FAIL');

}

{

}

}

if (!$redirect)

{

$forum_ids[] = $row['forum_id'];

sync('topic', 'topic_id', $topic_ids, true);

sync('forum', 'forum_id', $forum_ids, true);

}

if ($auto_sync)

{

sync('topic', 'topic_id', $topic_ids, true);

sync('forum', 'forum_id', $forum_ids, true);

}

// $totaltime = $mtime[0] + $mtime[1] - $starttime;

}

?> \ No newline at end of file

$headers .= 'Return-Path: <' . $config['board_email'] . ">\n";

$headers .= 'Sender: <' . $config['board_email'] . ">\n";

$headers .= "MIME-Version: 1.0\n";

$headers .= 'Date: ' . gmdate('D, d M Y H:i:s T', time()) . "\n";

$headers .= "Content-type: text/plain; charset={$this->encoding}\n";

$headers .= "Content-transfer-encoding: 8bit\n";

define('RULE_IS_GROUP', 10); // Is In Usergroup

define('RULE_ANSWERED', 11); // Answered

define('RULE_FORWARDED', 12); // Forwarded

define('RULE_TO_GROUP', 14); // Usergroup

define('RULE_TO_ME', 15); // Me

CHECK_STATUS => array(

RULE_ANSWERED => array('check0' => 'replied', 'function' => '{CHECK0} == 1'),

RULE_FORWARDED => array('check0' => 'forwarded', 'function' => '{CHECK0} == 1'),

CHECK_TO => array(

RULE_TO_GROUP => array('check0' => 'to', 'check1' => 'bcc', 'check2' => 'user_in_group', 'function' => 'in_array("g_" . {CHECK2}, {CHECK0}) || in_array("g_" . {CHECK2}, {CHECK1})'),

switch ($mode)

{

case 'real':

// Replace any chars which may cause us problems with _

$bad_chars = array("'", "\\", ' ', '/', ':', '*', '?', '"', '<', '>', '|');

unset($url_ary);

$tmp_path = (!@ini_get('safe_mode')) ? false : $phpbb_root_path . 'cache';

if (!($fp = @fopen($filename, 'wb')))

{

'version' => '1.0.0',

'modes' => array(

'forum_view' => array('title' => 'MCP_MAIN_FORUM_VIEW', 'auth' => 'acl_m_,$id'),

'post_details' => array('title' => 'MCP_MAIN_POST_DETAILS', 'auth' => 'acl_m_,$id'),

'topic_view' => array('title' => 'MCP_MAIN_TOPIC_VIEW', 'auth' => 'acl_m_,$id'),

),

do

{

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

'REPORT_ID' => $row['report_id'],

'REPORTER' => ($row['user_id'] != ANONYMOUS) ? $row['username'] : $user->lang['GUEST'],

'U_REPORTER' => ($row['user_id'] != ANONYMOUS) ? "{$phpbb_root_path}memberlist.$phpEx$SID&amp;mode=viewprofile&amp;u={$row['user_id']}" : '',

'USER_NOTIFY' => ($row['user_notify']) ? true : false,

if ($reason_id)

{

FROM ' . REASONS_TABLE . "

WHERE reason_id = $reason_id";

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

{

$additional_msg = 'Please give an appropiate reason for disapproval';

unset($_POST['confirm']);

}

else

{

$disapprove_reason .= ($reason) ? "\n\n" . $_REQUEST['reason'] : '';

unset($reason);

}

}

if (confirm_box(true))

}

else

{

$template->assign_vars(array(

'S_NOTIFY_POSTER' => true,

var $img_lang;

// Able to add new option (id 7)

var $keyvalues = array();

function setup($lang_set = false, $style = false)

// Now we add the block that we're actually assigning to.

// We're adding a new iteration to this block with the given

// variable assignments.

}

else

{

// Add a new iteration to this block with the variable assignments

// we were given.

}

return true;

* Some Examples:

* <code>

*

* alter_block_array('loop', $vararray, 2); // Insert vararray at position 2

* alter_block_array('loop', $vararray, array('KEY' => 'value')); // Insert vararray at the position where the key 'KEY' has the value of 'value'

* alter_block_array('loop', $vararray, false); // Insert vararray at first position

// Insert vararray at given position

$vararray['S_ROW_COUNT'] = $key;

return true;

}

$key--;

}

return true;

}

}

// Do we have an id? No, then just exit

$confirm_id = request_var('id', '');

{

exit;

}

$sql = 'SELECT code

FROM ' . CONFIRM_TABLE . "

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

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

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

$db->sql_freeresult($result);

$icons = array();

$cache->obtain_icons($icons);

foreach ($color_rows as $var)

{

'PM_IMG' => ($row_indicator) ? $user->img('pm_' . $row_indicator, '') : '',

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

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

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

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

);

}

unset($folder_info['rowset']);

'POST_IMG' => (!$auth->acl_get('u_sendpm')) ? $user->img('btn_locked', 'PM_LOCKED') : $user->img('btn_post_pm', 'POST_PM'),

'L_NO_MESSAGES' => (!$auth->acl_get('u_sendpm')) ? $user->lang['POST_PM_LOCKED'] : $user->lang['NO_MESSAGES'],

'S_SELECT_SORT_DIR' => $s_sort_dir,

$sql_start = $start;

}

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

WHERE t.user_id = $user_id

AND p.author_id = u.user_id

'S_ONLINE' => (!$config['load_onlinetrack']) ? false : ((isset($user_info['online']) && $user_info['online']) ? true : false),

'DELETE_IMG' => $user->img('btn_delete', $user->lang['DELETE_MESSAGE']),

'INFO_IMG' => $user->img('btn_info', $user->lang['VIEW_PM_INFO']),

'PROFILE_IMG' => $user->img('btn_profile', $user->lang['READ_PROFILE']),

'EMAIL_IMG' => $user->img('btn_email', $user->lang['SEND_EMAIL']),

'QUOTE_IMG' => $user->img('btn_quote', $user->lang['POST_QUOTE_PM']),

'SIGNATURE' => ($message_row['enable_sig']) ? $signature : '',

'EDITED_MESSAGE' => $l_edited_by,

'U_DELETE' => ($auth->acl_get('u_pm_delete')) ? "$url&amp;mode=compose&amp;action=delete&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] : '',

'U_AUTHOR_PROFILE' => "{$phpbb_root_path}memberlist.$phpEx$SID&amp;mode=viewprofile&amp;u=" . $author_id,

'U_EMAIL' => $user_info['email'],

'U_PREVIOUS_PM' => "$url&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] . "&amp;view=previous",

'U_NEXT_PM' => "$url&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] . "&amp;view=next",

'S_HAS_ATTACHMENTS' => (sizeof($attachments)) ? true : false,

'S_DISPLAY_NOTICE' => $display_notice && $message_row['message_attachment'],

'notifypm' => true,

'popuppm' => false,

'allowpm' => true,

);

foreach ($var_ary as $var => $default)

if (!sizeof($error))

{

$user->optionset('popuppm', $popuppm);

$sql_ary = array(

'user_allow_pm' => $allowpm,

$popuppm = (isset($popuppm)) ? $popuppm : $user->optionget('popuppm');

$popup_pm_yes = ($popuppm) ? ' checked="checked"' : '';

$popup_pm_no = (!$popuppm) ? ' checked="checked"' : '';

$dst = (isset($dst)) ? $dst : $user->data['user_dst'];

$dst_yes = ($dst) ? ' checked="checked"' : '';

$dst_no = (!$dst) ? ' checked="checked"' : '';

'NOTIFY_PM_NO' => $notify_pm_no,

'POPUP_PM_YES' => $popup_pm_yes,

'POPUP_PM_NO' => $popup_pm_no,

'DST_YES' => $dst_yes,

'DST_NO' => $dst_no,

'NOTIFY_EMAIL' => ($notifymethod == NOTIFY_EMAIL) ? 'checked="checked"' : '',

$sql = 'SELECT code

FROM ' . CONFIRM_TABLE . "

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

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

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

{

$sql = 'DELETE FROM ' . CONFIRM_TABLE . "

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

$db->sql_query($sql);

}

}

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

$sql = 'DELETE FROM ' . CONFIRM_TABLE . '

$db->sql_query($sql);

}

$db->sql_freeresult($result);

$sql = 'SELECT COUNT(session_id) AS attempts

FROM ' . CONFIRM_TABLE . "

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

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

$db->sql_freeresult($result);

$code = gen_rand_string(mt_rand(5, 8));

$sql = 'INSERT INTO ' . CONFIRM_TABLE . ' ' . $db->sql_build_array('INSERT', array(

'confirm_id' => (string) $confirm_id,

'session_id' => (string) $user->session_id,

'code' => (string) $code)

);

$db->sql_query($sql);

}

$s_hidden_fields .= '<input type="hidden" name="confirm_id" value="' . $confirm_id . '" />';

}

'S_LOGIN_ACTION' => "{$phpbb_root_path}ucp.$phpEx$SID&amp;mode=login",

'S_DISPLAY_BIRTHDAY_LIST' => ($config['load_birthdays']) ? true : false,

);

// Output page

// Imagemagick are you there? Give me a sign or a path ...

$img_imagick = '';

{

$locations = array('C:/WINDOWS/', 'C:/WINNT/', 'C:/WINDOWS/SYSTEM/', 'C:/WINNT/SYSTEM/', 'C:/WINDOWS/SYSTEM32/', 'C:/WINNT/SYSTEM32/', '/usr/bin/', '/usr/sbin/', '/usr/local/bin/', '/usr/local/sbin/', '/opt/', '/usr/imagemagick/', '/usr/bin/imagemagick/');

$locations = array_merge($path_locations, $locations);

foreach ($locations as $location)

}

else

{

}

?>

// Write out a temp file ... if safe mode is on we'll write it to our

// local cache/tmp directory

$tmp_path = (!@ini_get('safe_mode')) ? false : $phpbb_root_path . 'cache/tmp';

$fp = @fopen($filename, 'w');

@fwrite($fp, $config_data);

# Firebird Schema for phpBB 3.x - (c) phpBB Group, 2005

#

# $Id$

# phpbb_attachments

CREATE TABLE phpbb_attachments (

CREATE TABLE phpbb_confirm (

confirm_id VARCHAR(32) NOT NULL,

session_id VARCHAR(32) NOT NULL,

code VARCHAR(8) NOT NULL

);;

icon_id INTEGER DEFAULT 1 NOT NULL,

author_ip VARCHAR(40) NOT NULL,

message_time INTEGER DEFAULT 0 NOT NULL,

enable_bbcode INTEGER DEFAULT 1 NOT NULL,

enable_smilies INTEGER DEFAULT 1 NOT NULL,

enable_magic_url INTEGER DEFAULT 1 NOT NULL,

report_id INTEGER NOT NULL,

reason_id INTEGER DEFAULT 0 NOT NULL,

post_id INTEGER DEFAULT 0 NOT NULL,

user_id INTEGER DEFAULT 0 NOT NULL,

user_notify INTEGER DEFAULT 0 NOT NULL,

report_time INTEGER DEFAULT 0 NOT NULL,

report_text BLOB SUB_TYPE TEXT NOT NULL

);;

# phpbb_reports_reasons

CREATE TABLE phpbb_reports_reasons (

reason_id INTEGER NOT NULL,

);;

# phpbb_search_results

user_lastpage VARCHAR(100) NOT NULL,

user_last_confirm_key VARCHAR(10) NOT NULL,

user_warnings INTEGER DEFAULT 0 NOT NULL,

user_posts INTEGER DEFAULT 0 NOT NULL,

user_lang VARCHAR(30) NOT NULL,

user_timezone DOUBLE PRECISION DEFAULT 0 NOT NULL,

MSSQL Schema for phpBB 3.x - (c) phpBB Group, 2005

$Id$

*/

CREATE TABLE [phpbb_confirm] (

[confirm_id] [varchar] (32) NOT NULL ,

[session_id] [varchar] (32) NOT NULL ,

[code] [varchar] (8) NOT NULL

) ON [PRIMARY]

GO

[icon_id] [int] NOT NULL ,

[author_ip] [varchar] (40) NOT NULL ,

[message_time] [int] NOT NULL ,

[enable_bbcode] [int] NOT NULL ,

[enable_smilies] [int] NOT NULL ,

[enable_magic_url] [int] NOT NULL ,

[report_id] [int] IDENTITY (1, 1) NOT NULL ,

[reason_id] [int] NOT NULL ,

[post_id] [int] NOT NULL ,

[user_id] [int] NOT NULL ,

[user_notify] [int] NOT NULL ,

[report_time] [int] NOT NULL ,

[report_text] [text] NOT NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

CREATE TABLE [phpbb_reports_reasons] (

[reason_id] [int] IDENTITY (1, 1) NOT NULL ,

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

[user_lastpage] [varchar] (100) NOT NULL ,

[user_last_confirm_key] [varchar] (10) NOT NULL ,

[user_warnings] [int] NOT NULL ,

[user_posts] [int] NOT NULL ,

[user_lang] [varchar] (30) NOT NULL ,

[user_timezone] [float] NOT NULL ,

CONSTRAINT [DF_config_is_dynamic] DEFAULT (0) FOR [is_dynamic]

GO

ALTER TABLE [phpbb_drafts] WITH NOCHECK ADD

CONSTRAINT [DF_drafts_user_id] DEFAULT (0) FOR [user_id],

CONSTRAINT [DF_drafts_topic_id] DEFAULT (0) FOR [topic_id],

CONSTRAINT [DF_privms_author_id] DEFAULT (0) FOR [author_id],

CONSTRAINT [DF_privms_icon_id] DEFAULT (1) FOR [icon_id],

CONSTRAINT [DF_privms_message_time] DEFAULT (0) FOR [message_time],

CONSTRAINT [DF_privms_enable_bbcode] DEFAULT (1) FOR [enable_bbcode],

CONSTRAINT [DF_privms_enable_smilies] DEFAULT (1) FOR [enable_smilies],

CONSTRAINT [DF_privms_enable_magic_url] DEFAULT (1) FOR [enable_magic_url],

ALTER TABLE [phpbb_reports] WITH NOCHECK ADD

CONSTRAINT [DF_report_reason_id] DEFAULT (0) FOR [reason_id],

CONSTRAINT [DF_report_post_id] DEFAULT (0) FOR [post_id],

CONSTRAINT [DF_report_user_id] DEFAULT (0) FOR [user_id],

CONSTRAINT [DF_report_user_notify] DEFAULT (0) FOR [user_notify],

CONSTRAINT [DF_report_report_time] DEFAULT (0) FOR [report_time]

GO

ALTER TABLE [phpbb_reports_reasons] WITH NOCHECK ADD

GO

ALTER TABLE [phpbb_search_results] WITH NOCHECK ADD

CONSTRAINT [DF_users__user_lastmark] DEFAULT (0) FOR [user_lastmark],

CONSTRAINT [DF_users__user_lastpost_time] DEFAULT (0) FOR [user_lastpost_time],

CONSTRAINT [DF_users__user_warnings] DEFAULT (0) FOR [user_warnings],

CONSTRAINT [DF_users__user_posts] DEFAULT (0) FOR [user_posts],

CONSTRAINT [DF_users__user_timezone] DEFAULT (0) FOR [user_timezone],

CONSTRAINT [DF_users__user_dst] DEFAULT (0) FOR [user_dst],

CREATE TABLE phpbb_confirm (

confirm_id char(32) DEFAULT '' NOT NULL,

session_id char(32) DEFAULT '' NOT NULL,

code char(8) DEFAULT '' NOT NULL,

PRIMARY KEY (session_id,confirm_id)

);

icon_id tinyint(4) UNSIGNED DEFAULT '1' NOT NULL,

author_ip varchar(40) DEFAULT '' NOT NULL,

message_time int(11) DEFAULT '0' NOT NULL,

enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,

enable_smilies tinyint(1) DEFAULT '1' NOT NULL,

enable_magic_url tinyint(1) DEFAULT '1' NOT NULL,

);

# Table: 'phpbb_reports'

);

# Table: 'phpbb_reports_reasons'

CREATE TABLE phpbb_reports_reasons (

reason_id smallint(6) NOT NULL auto_increment,

reason_description text NOT NULL,

PRIMARY KEY (reason_id)

);

# Table: 'phpbb_search_results'

CREATE TABLE phpbb_search_results (

search_key varchar(32) DEFAULT '' NOT NULL,

user_last_confirm_key varchar(10) DEFAULT '' NOT NULL,

user_warnings tinyint(4) DEFAULT '0' NOT NULL,

user_last_warning int(11) DEFAULT '0' NOT NULL,

user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

user_lang varchar(30) DEFAULT '' NOT NULL,

user_timezone decimal(5,2) DEFAULT '0.0' NOT NULL,

Oracle Schema for phpBB 3.x - (c) phpBB Group, 2005

$Id$

*/

/*

CREATE TABLE phpbb_confirm (

confirm_id varchar2(32) DEFAULT '',

session_id varchar2(32) DEFAULT '',

code varchar2(8) DEFAULT '',

CONSTRAINT pk_phpbb_confirm PRIMARY KEY (session_id, confirm_id)

)

icon_id number(4) DEFAULT '1' NOT NULL,

author_ip varchar2(40) DEFAULT '',

message_time number(11) DEFAULT '0' NOT NULL,

enable_bbcode number(1) DEFAULT '1' NOT NULL,

enable_smilies number(1) DEFAULT '1' NOT NULL,

enable_magic_url number(1) DEFAULT '1' NOT NULL,

*/

CREATE TABLE phpbb_reports_reasons (

reason_id number(6) NOT NULL,

reason_description clob,

CONSTRAINT pk_phpbb_reports_reasons PRIMARY KEY (reason_id)

)

/

report_id number(5) NOT NULL,

reason_id number(5) DEFAULT '0' NOT NULL,

post_id number(8) DEFAULT '0' NOT NULL,

user_id number(8) DEFAULT '0' NOT NULL,

user_notify number(1) DEFAULT '0' NOT NULL,

report_time number(10) DEFAULT '0' NOT NULL,

report_text clob,

CONSTRAINT pk_phpbb_reports PRIMARY KEY (report_id)

user_lastpage varchar2(100) DEFAULT '',

user_last_confirm_key varchar2(10) DEFAULT '',

user_warnings number(4) DEFAULT '0' NOT NULL,

user_posts number(8) DEFAULT '0' NOT NULL,

user_lang varchar2(30) DEFAULT '',

user_timezone number(5, 2) DEFAULT '1' NOT NULL,

PostgreSQL Schema for phpBB 3.x - (c) phpBB Group, 2005

$Id$

*/

BEGIN;

CREATE TABLE phpbb_confirm (

confirm_id varchar(32) DEFAULT '' NOT NULL,

session_id varchar(32) DEFAULT '' NOT NULL,

code varchar(8) DEFAULT '' NOT NULL,

PRIMARY KEY (session_id,confirm_id)

);

icon_id INT2 DEFAULT '1' NOT NULL,

author_ip varchar(40) DEFAULT '' NOT NULL,

message_time INT4 DEFAULT '0' NOT NULL,

enable_bbcode INT2 DEFAULT '1' NOT NULL,

enable_smilies INT2 DEFAULT '1' NOT NULL,

enable_magic_url INT2 DEFAULT '1' NOT NULL,

CREATE TABLE phpbb_reports_reasons (

reason_id INT2 DEFAULT nextval('phpbb_reports_reasons_reason'),

reason_description TEXT DEFAULT '' NOT NULL,

PRIMARY KEY (reason_id)

);

report_id INT2 DEFAULT nextval('phpbb_reports_report_id_seq'),

reason_id INT2 DEFAULT '0' NOT NULL,

post_id INT4 DEFAULT '0' NOT NULL,

user_id INT4 DEFAULT '0' NOT NULL,

user_notify INT2 DEFAULT '0' NOT NULL,

report_time INT4 DEFAULT '0' NOT NULL,

report_text TEXT DEFAULT '' NOT NULL,

PRIMARY KEY (report_id),

CHECK (reason_id>=0),

CHECK (post_id>=0),

CHECK (user_id>=0),

CHECK (report_time>=0)

);

user_lastpage varchar(100) DEFAULT '' NOT NULL,

user_last_confirm_key varchar(10) DEFAULT '' NOT NULL,

user_warnings INT2 DEFAULT '0' NOT NULL,

user_posts INT4 DEFAULT '0' NOT NULL,

user_lang varchar(30) DEFAULT '' NOT NULL,

user_timezone decimal(5,2) DEFAULT '0.0' NOT NULL,

INSERT INTO phpbb_config (config_name, config_value) VALUES ('auth_img_pm', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('auth_method', 'db');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('auth_quote_pm', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('auth_smilies_pm', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize', '6144');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path', 'images/avatars/gallery');

INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_profile', 1);

INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_prune', 1);

INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_ranks', 1);

INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_roles', 1);

INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_server', 1);

INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('a_styles', 1);

INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_pm_bbcode', 1);

INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_pm_smilies', 1);

INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_pm_download', 1);

INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_pm_edit', 1);

INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_pm_printpm', 1);

INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_pm_emailpm', 1);

INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (90, 1, 'pm', 'ucp', 0, 27, 98, 99, 'UCP_PM_POPUP_TITLE', 'popup', 'cfg_allow_privmsg');

# ACP

# MCP

INSERT INTO phpbb_modules (module_id, module_enabled, module_display, module_name, module_class, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (124, 1, 1, '', 'mcp', 0, 37, 46, 'MCP_MAIN', '', '');

INSERT INTO phpbb_modules (module_id, module_enabled, module_display, module_name, module_class, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (125, 1, 1, '', 'mcp', 0, 47, 52, 'MCP_NOTES', '', '');

INSERT INTO phpbb_modules (module_id, module_enabled, module_display, module_name, module_class, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (126, 1, 1, '', 'mcp', 0, 53, 62, 'MCP_QUEUE', '', '');

INSERT INTO phpbb_modules (module_id, module_enabled, module_display, module_name, module_class, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (127, 1, 1, '', 'mcp', 0, 63, 72, 'MCP_WARN', '', '');

INSERT INTO phpbb_modules (module_id, module_enabled, module_display, module_name, module_class, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (129, 1, 1, 'main', 'mcp', 124, 40, 41, 'MCP_MAIN_FORUM_VIEW', 'forum_view', 'acl_m_,$id');

INSERT INTO phpbb_modules (module_id, module_enabled, module_display, module_name, module_class, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (130, 1, 1, 'main', 'mcp', 124, 42, 43, 'MCP_MAIN_TOPIC_VIEW', 'topic_view', 'acl_m_,$id');

INSERT INTO phpbb_modules (module_id, module_enabled, module_display, module_name, module_class, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (131, 1, 1, 'main', 'mcp', 124, 44, 45, 'MCP_MAIN_POST_DETAILS', 'post_details', 'acl_m_,$id');

# SQLite Schema for phpBB 3.x - (c) phpBB Group, 2005

#

# $Id$

#

BEGIN TRANSACTION;

CREATE TABLE phpbb_confirm (

confirm_id char(32) NOT NULL DEFAULT '',

session_id char(32) NOT NULL DEFAULT '',

code char(8) NOT NULL DEFAULT '',

PRIMARY KEY (session_id, confirm_id)

);

icon_id tinyint(4) NOT NULL DEFAULT '1',

author_ip varchar(40) NOT NULL DEFAULT '',

message_time int(11) NOT NULL DEFAULT '0',

enable_bbcode tinyint(1) NOT NULL DEFAULT '1',

enable_smilies tinyint(1) NOT NULL DEFAULT '1',

enable_magic_url tinyint(1) NOT NULL DEFAULT '1',

# Table: phpbb_reports_reasons

CREATE TABLE phpbb_reports_reasons (

reason_id INTEGER PRIMARY KEY NOT NULL,

);

# Table: phpbb_reports

report_id INTEGER PRIMARY KEY NOT NULL,

reason_id smallint(5) NOT NULL DEFAULT '0',

post_id mediumint(8) NOT NULL DEFAULT '0',

user_id mediumint(8) NOT NULL DEFAULT '0',

user_notify tinyint(1) NOT NULL DEFAULT '0',

report_time int(10) NOT NULL DEFAULT '0',

report_text text(65535) NOT NULL

);

user_lastpage varchar(100) NOT NULL DEFAULT '',

user_last_confirm_key varchar(10) NOT NULL DEFAULT '',

user_warnings tinyint(4) NOT NULL DEFAULT '0',

user_posts mediumint(8) NOT NULL DEFAULT '0',

user_lang varchar(30) NOT NULL DEFAULT '',

user_timezone decimal(5,2) NOT NULL DEFAULT '0.0',

'ALLOW_BBCODE_PM' => 'Allow BBCode in private messages',

'ALLOW_SMILIES_PM' => 'Allow smilies in private messages',

'ALLOW_DOWNLOAD_PM' => 'Allow downloading of attachments in private messages',

'ALLOW_FORWARD_PM' => 'Allow forwarding of private messages',

'ALLOW_PRINT_PM' => 'Allow print view in private messaging',

'ALLOW_EMAIL_PM' => 'Allow emailing private messages',

'ACP_MANAGE_EXTENSIONS' => 'Manage Extensions',

'ACP_MANAGE_FORUMS' => 'Manage Forums',

'ACP_MANAGE_RANKS' => 'Manage Ranks',

'ACP_MANAGE_USERS' => 'Manage Users',

'ACP_MASS_EMAIL' => 'Mass Email',

'ACP_MESSAGES' => 'Messages',

'ACP_PRUNING' => 'Pruning',

'ACP_RANKS' => 'Ranks',

'ACP_SERVER_CONFIGURATION' => 'Server Configuration',

'ACP_SERVER_SETTINGS' => 'Server Settings',

'LOG_PRUNE_USER_DEL_DEL' => '<b>Users pruned and posts deleted</b><br />&#187; %s',

'LOG_PRUNE_USER_DEL_ANON' => '<b>Users pruned and posts retained</b><br />&#187; %s',

'LOG_RESET_DATE' => '<b>Board start date reset</b>',

'LOG_RESET_ONLINE' => '<b>Most users online reset</b>',

'LOG_RESYNC_POSTCOUNTS' => '<b>User postcounts synced</b>',

'acl_u_readpm' => array('lang' => 'Can read private messages', 'cat' => 'pm'),

'acl_u_pm_edit' => array('lang' => 'Can edit own private messages', 'cat' => 'pm'),

'acl_u_pm_delete' => array('lang' => 'Can remove private messages from own folder', 'cat' => 'pm'),

'acl_u_pm_forward' => array('lang' => 'Can forward private messages', 'cat' => 'pm'),

'acl_u_pm_emailpm' => array('lang' => 'Can email private messages', 'cat' => 'pm'),

'acl_u_pm_printpm' => array('lang' => 'Can print private messages', 'cat' => 'pm'),

'acl_a_language' => array('lang' => 'Can manage language packs', 'cat' => 'misc'),

'acl_a_email' => array('lang' => 'Can send mass email', 'cat' => 'misc'),

'acl_a_bots' => array('lang' => 'Can manage bots', 'cat' => 'misc'),

# 'acl_a_backup' => array('lang' => 'Can backup database', 'cat' => 'misc'),

# 'acl_a_restore' => array('lang' => 'Can restore database', 'cat' => 'misc'),

# 'acl_a_search' => array('lang' => 'Can re-index search tables', 'cat' => 'misc'),

'NO_DISALLOWED' => 'No Disallowed Usernames',

));

?> \ No newline at end of file

'CHANGE' => 'Change',

'CLICK_VIEW_PRIVMSG' => 'Click %sHere%s to visit your Inbox',

'CONFIRM' => 'Confirm',

'CONGRATULATIONS' => 'Congratulations to',

'CONNECTION_FAILED' => 'Connection failed',

'CONNECTION_SUCCESS' => 'Connection was successful!',

'LOCK_TOPIC' => 'Lock Topic',

'LOGIN' => 'Login',

'LOGIN_CHECK_PM' => 'Log in to check your private messages',

'LOGIN_FORUM' => 'To view or post in this forum you must enter a password.',

'LOGIN_INFO' => 'In order to login you must be registered. Registering takes only a few seconds but gives you increased capabilies. The board administrator may also grant additional permissions to registered users. Before you login please ensure you are familiar with our terms of use and related policies. Please ensure you read any forum rules as you navigate around the board.',

'LOGIN_VIEWFORUM' => 'The board administrator requires you to be registered and logged in to view this forum.',

'IP_INFO' => 'IP Information',

'LATEST_LOGS' => 'Latest 5 logged actions',

'LATEST_REPORTED' => 'Latest 5 reports',

'LATEST_UNAPPROVED' => 'Latest 5 posts awaiting for approval',

'MERGE_POSTS_CONFIRM' => 'Are you sure you want to merge the selected posts?',

'MERGE_TOPIC_EXPLAIN' => 'Using the form below you can merge selected posts into another topic. These posts will not be reordered and will appear as if the users posted them to the new topic.<br />Please enter the destination topic id or click on the "Select" button to search for one',

'MERGE_TOPIC_ID' => 'Destination topic id',

'MOD_OPTIONS' => 'Moderator Options',

'MORE_INFO' => 'Further information',

'MOVE_TOPIC_CONFIRM' => 'Are you sure you want to move the topic into a new forum?',

'READ_USERNOTES' => 'User notes',

'READ_WARNINGS' => 'User warnings',

'REPORTER' => 'Reporter',

'REPORT_TIME' => 'Report time',

'REPORTS_TOTAL' => 'In total there are <b>%d</b> reports to review',

'REPORTS_ZERO_TOTAL' => 'There are no reports to review',

'CHANGE_PASSWORD_EXPLAIN' => 'Must be between %1$d and %2$d characters.',

'CLICK_RETURN_FOLDER' => 'Click %1$sHere%2$s to return to your "%3$s" Folder',

'CONFIRMATION' => 'Confirmation of registration',

'CONFIRM_EMAIL' => 'Confirm email address',

'CONFIRM_EMAIL_EXPLAIN' => 'You only need to specify this if you are changing your email address.',

'CONFIRM_EXPLAIN' => 'To prevent automated registrations the board administrator requires you to enter a confirmation code. The code is displayed in the image you should see below. If you are visually impaired or cannot otherwise read this code please contact the %sBoard Administrator%s.',

'MESSAGE_DELETED' => 'Message successfully deleted',

'MESSAGE_HISTORY' => 'Message History',

'MESSAGE_REMOVED_FROM_OUTBOX' => 'This message has been removed by it\'s author before it was delivered',

'MESSAGE_STORED' => 'The message has been send successfully',

'MESSAGES_DELETED' => 'Messages successfully deleted',

'MOVE_DELETED_MESSAGES_TO' => 'Move messages from removed folder to',

'RENAME' => 'Rename',

'RENAME_FOLDER' => 'Rename folder',

'REPLIED_MESSAGE' => 'Replied to Message',

'RETURN_FOLDER' => 'Click %1$sHere%2$s to return to folder',

'RETURN_UCP' => 'Click %sHere%s to return to the User Control Panel',

'RULE_ADDED' => 'Rule successfully added',

case 'reports':

$limit_days = array(0 => $user->lang['ALL_REPORTS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 364 => $user->lang['1_YEAR']);

$sort_by_text = array('p' => $user->lang['REPORT_PRIORITY'], 'r' => $user->lang['REPORTER'], 't' => $user->lang['REPORT_TIME']);

break;

case 'logs':

$auth->acl($user->data);

$user->setup('mcp');

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

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

{

trigger_error('INVALID_MODE');

}

// Has the report been cancelled?

if (isset($_POST['cancel']))

}

// Grab all relevant data

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

{

}

{

{

}

}

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

{

}

if (isset($_POST['submit']) && $reason_id)

{

FROM ' . REASONS_TABLE . "

WHERE reason_id = $reason_id";

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

{

trigger_error('EMPTY_REPORT');

}

$sql_ary = array(

'reason_id' => (int) $reason_id,

'user_id' => (int) $user->data['user_id'],

'user_notify' => (int) $user_notify,

'report_time' => (int) time(),

'report_text' => (string) $report_text

);

{

$db->sql_query($sql);

}

{

}

meta_refresh(3, $redirect_url);

trigger_error($message);

}

$template->assign_vars(array(

'REPORT_TEXT' => $report_text,

);

// Start output of page

$template->set_filenames(array(

'body' => 'report_body.html')

page_footer();

?> \ No newline at end of file

<!-- $Id$ -->

<table class="tablebg" cellspacing="1" width="100%">

<tr>

<td class="cat" colspan="5" align="right"><a class="nav" href="{U_MARK_FORUMS}">{L_MARK_FORUMS_READ}</a>&nbsp;</td>

<p class="genmed" align="center"><a href="{U_TERMS_USE}">{L_TERMS_USE}</a> | <a href="{U_PRIVACY}">{L_PRIVACY}</a></p>

</td>

<td class="row2"><table cellspacing="1" cellpadding="4">

<!-- IF LOGIN_ERROR -->

<tr>

<td class="gensmall" colspan="2" align="center"><span class="error">{LOGIN_ERROR}</span></td>

<!-- ENDIF -->

</table></td>

</tr>

<tr>

<td class="cat" colspan="2" align="center">{S_HIDDEN_FIELDS}<input type="submit" name="login" class="btnmain" value="{L_LOGIN}" tabindex="3" /></td>

</tr>

<!-- $Id$ -->

<table class="tablebg" width="100%" cellspacing="1">

<tr>

</tr>

<tr>

</tr>

<tr>

<td class="row1" width="22%"><b class="gen">{L_REASON}:</b></td>

</tr>

<!-- IF S_CAN_NOTIFY -->

<tr>

<td class="row1"><span class="gen"><b>{L_REPORT_NOTIFY}:</b></span><br /><span class="gensmall">{L_REPORT_NOTIFY_EXPLAIN}</span></td>

</tr>

<!-- ENDIF -->

<tr>

<td class="row1" valign="top"><span class="gen"><b>{L_MORE_INFO}:</b></span><br /><span class="gensmall">{L_CAN_LEAVE_BLANK}</span></td>

</tr>

<tr>

<td class="cat" colspan="2" align="center"><input type="submit" name="submit" class="btnmain" value="{L_SUBMIT}" />&nbsp;<input type="submit" name="cancel" class="btnlite" value="{L_CANCEL}"></td>

<td class="row1" width="25" align="center">{messagerow.PM_ICON_IMG}</td>

<!-- ENDIF -->

<!-- IF messagerow.S_PM_DELETED --><td class="row3"><!-- ELSE --><td class="row1"><!-- ENDIF -->

<!-- IF not messagerow.PM_IMG and messagerow.PM_CLASS -->

<span class="{messagerow.PM_CLASS}"><img src="images/spacer.gif" width="10" height="10" alt="" border="0" /></span>&nbsp;

<!-- ELSEIF messagerow.PM_IMG -->

<tr>

<td>

<div class="postbody">{MESSAGE}</div>

<!-- IF S_HAS_ATTACHMENTS -->

<table width="100%" cellspacing="0">

<tr valign="middle">

</tr>

</table>

<td class="row2"><input type="radio" name="popuppm" value="1"{POPUP_PM_YES} /><span class="genmed">{L_YES}</span>&nbsp;&nbsp;<input type="radio" name="popuppm" value="0"{POPUP_PM_NO} /><span class="genmed">{L_NO}</span></td>

</tr>

<tr>

<td class="row1" width="50%"><b class="genmed">{L_BOARD_LANGUAGE}:</b></td>

<td class="row2"><select name="lang">{S_LANG_OPTIONS}</select></td>

</tr>

/* Private messages

------------------ */

.pm_marked_colour {

background-color: #000000;

}

'U_YIM' => $user_cache[$poster_id]['yim'],

'U_JABBER' => $user_cache[$poster_id]['jabber'],

'U_MCP_REPORT' => ($auth->acl_gets('m_', 'a_', 'f_report', $forum_id)) ? "{$phpbb_root_path}mcp.$phpEx$SID&amp;i=main&amp;mode=post_details&amp;p=" . $row['post_id'] : '',

'U_MCP_APPROVE' => ($auth->acl_get('m_approve', $forum_id)) ? "{$phpbb_root_path}mcp.$phpEx$SID&amp;i=queue&amp;mode=unapproved_posts&amp;action=approve&amp;post_id_list[]=" . $row['post_id'] : '',

'U_MINI_POST' => "{$phpbb_root_path}viewtopic.$phpEx$SID&amp;p=" . $row['post_id'] . '#p' . $row['post_id'],