*/

class acp_database

{

var $u_action;

function main($id, $mode)

global $cache, $db, $user, $auth, $template, $table_prefix;

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

$user->add_lang('acp/database');

$this->tpl_name = 'acp_database';

{

case 'download':

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

$format = request_var('method', '');

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

break;

default:

asort($tables);

foreach ($tables as $table_name)

{

// No maximum post id? :o

if (!$max_post_id)

{

FROM ' . POSTS_TABLE;

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

$max_post_id = (int) $db->sql_fetchfield('max_post_id');

$field_row = array_merge($default_values[$field_type], array(

'field_ident' => str_replace(' ', '_', utf8_clean_string(request_var('field_ident', '', true))),

'field_required' => 0,

'field_hide' => 0,

'field_show_profile'=> 0,

'field_no_view' => 0,

// $exclude contains the data we gather in each step

$exclude = array(

2 => array('field_length', 'field_maxlen', 'field_minlen', 'field_validation', 'field_novalue', 'field_default_value'),

3 => array('l_lang_name', 'l_lang_explain', 'l_lang_default_value', 'l_lang_options')

);

// Visibility Options...

$visibility_ary = array(

'field_required',

'field_show_on_reg',

'field_show_on_vt',

'field_show_profile',

$template->assign_vars(array(

'S_STEP_ONE' => true,

'S_FIELD_REQUIRED' => ($cp->vars['field_required']) ? true : false,

'S_SHOW_ON_REG' => ($cp->vars['field_show_on_reg']) ? true : false,

'S_SHOW_ON_VT' => ($cp->vars['field_show_on_vt']) ? true : false,

'S_FIELD_HIDE' => ($cp->vars['field_hide']) ? true : false,

'field_default_value' => $cp->vars['field_default_value'],

'field_validation' => $cp->vars['field_validation'],

'field_required' => $cp->vars['field_required'],

'field_show_on_reg' => $cp->vars['field_show_on_reg'],

'field_show_on_vt' => $cp->vars['field_show_on_vt'],

'field_hide' => $cp->vars['field_hide'],

if ($name && !in_array($name, $installed))

{

'path' => $file,

'name' => $name,

'copyright' => $items['copyright'],

if (sizeof($new_ary))

{

foreach ($new_ary as $cfg)

{

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

$user_row['posts_in_queue'] = (int) $db->sql_fetchfield('posts_in_queue');

$db->sql_freeresult($result);

$template->assign_vars(array(

'L_NAME_CHARS_EXPLAIN' => sprintf($user->lang[$config['allow_name_chars'] . '_EXPLAIN'], $config['min_name_chars'], $config['max_name_chars']),

'L_CHANGE_PASSWORD_EXPLAIN' => sprintf($user->lang[$config['pass_complex'] . '_EXPLAIN'], $config['min_pass_chars'], $config['max_pass_chars']),

'USER_EMAIL' => $user_row['user_email'],

'USER_WARNINGS' => $user_row['user_warnings'],

'USER_POSTS' => $user_row['user_posts'],

'USER_INACTIVE_REASON' => $inactive_reason,

));

{

if (!@ldap_bind($ldap, htmlspecialchars_decode($config['ldap_user']), htmlspecialchars_decode($config['ldap_password'])))

{

}

}

*/

// phpBB Version

// QA-related

// define('PHPBB_QA', 1);

case 'mysql_40':

case 'mysql_41':

break;

case 'mssql':

}

/**

* Fetch field

* if rownum is false, the current row is used, else it is pointing to the row (zero-based)

*/

}

/**

* Run more than one insert statement.

*

* @param string $table table name to run the statements on

}

/**

* Get last inserted id after insert statement

*/

function sql_nextid()

}

/**

* Build LIKE expression

* @access private

*/

}

/**

* Get last inserted id after insert statement

*/

function sql_nextid()

}

/**

* Build LIKE expression

* @access private

*/

$this->server = $sqlserver . (($port) ? $port_delimiter . $port : '');

//connect to database

$this->db_connect_id = sqlsrv_connect($this->server, array(

'Database' => $this->dbname,

'UID' => $this->user,

unset($row['line2'], $row['line3']);

}

}

}

/**

}

/**

* Build LIKE expression

* @access private

*/

}

}

if (!function_exists('htmlspecialchars_decode'))

{

/**

}

else

{

WHERE t.forum_id = ' . $forum_id . '

AND t.topic_last_post_time > ' . $mark_time_forum . '

AND t.topic_moved_id = 0 ' .

$sql_update_unapproved . '

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

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

$db->sql_freeresult($result);

$diff = time() - $creation_time;

// If creation_time and the time() now is zero we can assume it was not a human doing this (the check for if ($diff)...

{

$token_sid = ($user->data['user_id'] == ANONYMOUS && !empty($config['form_token_sid_guests'])) ? $user->session_id : '';

$key = sha1($creation_time . $user->data['user_form_salt'] . $form_name . $token_sid);

case 'email':

// Regex written by James Watts and Francisco Jose Martin Moreno

// http://fightingforalostcause.net/misc/2006/compare-email-regex.php

break;

case 'bbcode_htm':

echo ' </div>';

echo ' </div>';

echo ' <div id="page-footer">';

echo ' </div>';

echo '</div>';

echo '</body>';

$template->assign_vars(array(

'DEBUG_OUTPUT' => (defined('DEBUG')) ? $debug_output : '',

'TRANSLATION_INFO' => (!empty($user->lang['TRANSLATION_INFO'])) ? $user->lang['TRANSLATION_INFO'] : '',

'U_ACP' => ($auth->acl_get('a_') && !empty($user->data['is_registered'])) ? append_sid("{$phpbb_root_path}adm/index.$phpEx", false, true, $user->session_id) : '')

);

}

/**

* Cache moderators, called whenever permissions are changed via admin_permissions. Changes of username

* and group names must be carried through for the moderators table

*/

{

$sql_keywords .= $db->sql_in_set('l.log_operation', $operations) . ' OR ';

}

}

if ($log_count !== false)

'SCHEMA' => 'firebird',

'MODULE' => 'interbase',

'DELIM' => ';;',

'DRIVER' => 'firebird',

'AVAILABLE' => true,

'2.0.x' => false,

'SCHEMA' => 'mysql_41',

'MODULE' => 'mysqli',

'DELIM' => ';',

'DRIVER' => 'mysqli',

'AVAILABLE' => true,

'2.0.x' => true,

'SCHEMA' => 'mysql',

'MODULE' => 'mysql',

'DELIM' => ';',

'DRIVER' => 'mysql',

'AVAILABLE' => true,

'2.0.x' => true,

'SCHEMA' => 'mssql',

'MODULE' => 'mssql',

'DELIM' => 'GO',

'DRIVER' => 'mssql',

'AVAILABLE' => true,

'2.0.x' => true,

'SCHEMA' => 'mssql',

'MODULE' => 'odbc',

'DELIM' => 'GO',

'DRIVER' => 'mssql_odbc',

'AVAILABLE' => true,

'2.0.x' => true,

'SCHEMA' => 'mssql',

'MODULE' => 'sqlsrv',

'DELIM' => 'GO',

'DRIVER' => 'mssqlnative',

'AVAILABLE' => true,

'2.0.x' => false,

'SCHEMA' => 'oracle',

'MODULE' => 'oci8',

'DELIM' => '/',

'DRIVER' => 'oracle',

'AVAILABLE' => true,

'2.0.x' => false,

'SCHEMA' => 'postgres',

'MODULE' => 'pgsql',

'DELIM' => ';',

'DRIVER' => 'postgres',

'AVAILABLE' => true,

'2.0.x' => true,

'SCHEMA' => 'sqlite',

'MODULE' => 'sqlite',

'DELIM' => ';',

'DRIVER' => 'sqlite',

'AVAILABLE' => true,

'2.0.x' => false,

/**

* Removes comments from schema files

*/

{

// Remove # style comments

$sql = preg_replace('/\n{2,}/', "\n", preg_replace('/^#.*$/m', "\n", $sql));

}

/**

}

}

?> \ No newline at end of file

if (sizeof($icons))

{

foreach ($icons as $id => $data)

{

if ($data['display'])

{

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

'ICON_ID' => $id,

'ICON_WIDTH' => $data['width'],

'ICON_HEIGHT' => $data['height'],

/**

* User Notification

*/

{

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

'USERNAME' => htmlspecialchars_decode($addr['name']),

'TOPIC_TITLE' => htmlspecialchars_decode($topic_title),

'FORUM_NAME' => htmlspecialchars_decode($forum_name),

'U_FORUM' => generate_board_url() . "/viewforum.$phpEx?f=$forum_id",

'U_TOPIC' => generate_board_url() . "/viewtopic.$phpEx?f=$forum_id&t=$topic_id",

// Send Notifications

if (($mode == 'reply' || $mode == 'quote' || $mode == 'post') && $post_approval)

{

}

$params = $add_anchor = '';

* - 'topic_last_post_subject'

* - 'topic_last_poster_name'

* - 'topic_last_poster_colour'

* @return string An URL to the bumped topic, example: ./viewtopic.php?forum_id=1&amptopic_id=2&ampp=3#p3

*/

function phpbb_bump_topic($forum_id, $topic_id, $post_data, $bump_time = false)

}

/**

* Rebuild message header

*/

function rebuild_header($check_ary)

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

{

$field = ($data['address_list']['g'][$row['group_id']] == 'to') ? 'to' : 'bcc';

$recipients[$row['user_id']] = $field;

}

case FIELD_BOOL:

$field_value = (bool) $field_value;

if (!$field_value && $field_data['field_required'])

{

return 'FIELD_REQUIRED';

{

return false;

}

$field_value = (int) $field_value;

if ($field_value < $field_data['field_minlen'])

$user_fields = array();

// Go through the fields in correct order

foreach (array_keys($this->profile_cache) as $used_ident)

{

$user_fields[$user_id][$used_ident]['value'] = $row['pf_' . $used_ident];

$user_fields[$user_id][$used_ident]['data'] = $this->profile_cache[$used_ident];

}

}

return $user_fields;

switch ($this->profile_types[$field_type])

{

case 'int':

{

return NULL;

}

case 'string':

case 'text':

{

return NULL;

}

$month = (isset($date[1])) ? (int) $date[1] : 0;

$year = (isset($date[2])) ? (int) $date[2] : 0;

{

return NULL;

}

$this->get_option_lang($field_id, $lang_id, FIELD_DROPDOWN, false);

}

{

return NULL;

}

// User not having a value assigned

if (!isset($this->options_lang[$field_id][$lang_id][$value]))

{

}

return $this->options_lang[$field_id][$lang_id][$value];

$this->get_option_lang($field_id, $lang_id, FIELD_BOOL, false);

}

if ($ident_ary['data']['field_length'] == 1)

{

return (isset($this->options_lang[$field_id][$lang_id][(int) $value])) ? $this->options_lang[$field_id][$lang_id][(int) $value] : NULL;

$filename = $url['path'];

$filesize = 0;

$errno = 0;

$errstr = '';

$block = @fread($fsock, 1024);

$filesize += strlen($block);

{

$file = new fileerror(sprintf($user->lang[$this->error_prefix . 'WRONG_FILESIZE'], $max_filesize['value'], $max_filesize['unit']));

return $file;

{

$length = (int) str_replace('content-length: ', '', strtolower($line));

{

$file = new fileerror(sprintf($user->lang[$this->error_prefix . 'WRONG_FILESIZE'], $max_filesize['value'], $max_filesize['unit']));

return $file;

WHERE session_user_id = ' . $user_id;

$db->sql_query($sql);

{

}

$db->sql_transaction('commit');

}

/**

* Remove avatar

*/

function avatar_delete($mode, $row, $clean_db = false)

include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

}

$avatar_img = get_user_avatar($user_row['user_avatar'], $user_row['user_avatar_type'], $user_row['user_avatar_width'], $user_row['user_avatar_height']);

$template->assign_vars(array(

include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

}

$avatar_img = get_user_avatar($user_row['user_avatar'], $user_row['user_avatar_type'], $user_row['user_avatar_width'], $user_row['user_avatar_height']);

// OK, they didn't submit a warning so lets build the page for them to do so

{

if ($db->sql_layer == 'mysqli' || version_compare($db->sql_server_info(true), '4.1.3', '>='))

{

}

else

{

}

}

{

$sql = 'SELECT u.*, s.*

FROM ' . SESSIONS_TABLE . ' s, ' . USERS_TABLE . " u

'version' => '1.0.0',

'modes' => array(

'profile_info' => array('title' => 'UCP_PROFILE_PROFILE_INFO', 'auth' => '', 'cat' => array('UCP_PROFILE')),

'avatar' => array('title' => 'UCP_PROFILE_AVATAR', 'auth' => 'cfg_allow_avatar && (cfg_allow_avatar_local || cfg_allow_avatar_remote || cfg_allow_avatar_upload || cfg_allow_avatar_remote_upload)', 'cat' => array('UCP_PROFILE')),

'reg_details' => array('title' => 'UCP_PROFILE_REG_DETAILS', 'auth' => '', 'cat' => array('UCP_PROFILE')),

),

$return_box_lang = ($action === 'post' || $action === 'edit') ? 'PM_OUTBOX' : 'PM_INBOX';

$last_click_type = 'CLICK_RETURN_FOLDER';

if ($folder_url)

trigger_error('RULE_ALREADY_DEFINED');

}

$sql = 'INSERT INTO ' . PRIVMSGS_RULES_TABLE . ' ' . $db->sql_build_array('INSERT', $rule_ary);

$db->sql_query($sql);

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_message_rules = 1

WHERE user_id = ' . $user->data['user_id'];

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

$db->sql_freeresult($result);

if (!$row)

{

$sql = 'UPDATE ' . USERS_TABLE . '

if ($submit)

{

$error = validate_data($data, array(

'dateformat' => array('string', false, 1, 30),