-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-/**

-* @package acp

-*/

- var $u_action;

- var $new_config;

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

- $l_legend_cat_images = $user->lang['SETTINGS_CAT_IMAGES'] . ' [' . $user->lang['ASSIGNED_GROUP'] . ': ' . ((!empty($s_assigned_groups[ATTACHMENT_CATEGORY_IMAGE])) ? implode(', ', $s_assigned_groups[ATTACHMENT_CATEGORY_IMAGE]) : $user->lang['NO_EXT_GROUP']) . ']';

- 'max_attachments' => array('lang' => 'MAX_ATTACHMENTS', 'validate' => 'int', 'type' => 'text:3:3', 'explain' => false),

- 'max_attachments_pm' => array('lang' => 'MAX_ATTACHMENTS_PM', 'validate' => 'int', 'type' => 'text:3:3', 'explain' => false),

-

- 'img_max_thumb_width' => array('lang' => 'MAX_THUMB_WIDTH', 'validate' => 'int', 'type' => 'text:7:15', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

- 'img_min_thumb_filesize' => array('lang' => 'MIN_THUMB_FILESIZE', 'validate' => 'int', 'type' => 'text:7:15', 'explain' => true, 'append' => ' ' . $user->lang['BYTES']),

- 'img_max' => array('lang' => 'MAX_IMAGE_SIZE', 'validate' => 'int', 'type' => 'dimension:3:4', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

- 'img_link' => array('lang' => 'IMAGE_LINK_SIZE', 'validate' => 'int', 'type' => 'dimension:3:4', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

- 'PHPBB_ROOT_PATH' => $phpbb_root_path,

- $notify[] = sprintf($user->lang['LOG_ATTACH_ORPHAN_DEL'], implode(', ', $delete_files));

- $ip_exclude = (!empty($_POST['ipexclude'])) ? 1 : 0;

- return '<input type="text" id="' . $key . '" size="8" maxlength="15" name="config[' . $key . ']" value="' . $value . '" /> <select name="' . $key . '">' . size_select_options($size_var) . '</select>';

-

-?> \ No newline at end of file

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-/**

-* @package acp

-*/

- global $config, $db, $user, $auth, $template, $cache;

- global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix;

- $bansubmit = (isset($_POST['bansubmit'])) ? true : false;

- $unbansubmit = (isset($_POST['unbansubmit'])) ? true : false;

- $current_time = time();

- $ban = utf8_normalize_nfc(request_var('ban', '', true));

- $ban_len = request_var('banlength', 0);

- $ban_len_other = request_var('banlengthother', '');

- $ban_exclude = request_var('banexclude', 0);

- $ban_reason = utf8_normalize_nfc(request_var('banreason', '', true));

- $ban_give_reason = utf8_normalize_nfc(request_var('bangivereason', '', true));

- user_ban($mode, $ban, $ban_len, $ban_len_other, $ban_exclude, $ban_reason, $ban_give_reason);

- $ban = request_var('unban', array(''));

- $this->display_ban_options($mode);

-

- function display_ban_options($mode)

- $ban_length = $ban_reasons = $ban_give_reasons = array();

-

- $ban_length[$row['ban_id']] = $user->lang['PERMANENT'];

- $ban_length[$row['ban_id']] = sprintf($user->lang['BANNED_UNTIL_DURATION'], $ban_end_text[$time_length], $user->format_date($row['ban_end'], false, true));

- $ban_length[$row['ban_id']] = sprintf($user->lang['BANNED_UNTIL_DATE'], $user->format_date($row['ban_end'], false, true));

- $ban_reasons[$row['ban_id']] = $row['ban_reason'];

- $ban_give_reasons[$row['ban_id']] = $row['ban_give_reason'];

- if (sizeof($ban_length))

- {

- foreach ($ban_length as $ban_id => $length)

- {

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

- 'BAN_ID' => (int) $ban_id,

- 'LENGTH' => $length,

- 'A_LENGTH' => addslashes($length),

- ));

- }

- }

-

- if (sizeof($ban_reasons))

- {

- foreach ($ban_reasons as $ban_id => $reason)

- {

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

- 'BAN_ID' => $ban_id,

- 'REASON' => $reason,

- 'A_REASON' => addslashes($reason),

- ));

- }

- }

-

- if (sizeof($ban_give_reasons))

- {

- foreach ($ban_give_reasons as $ban_id => $reason)

- {

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

- 'BAN_ID' => $ban_id,

- 'REASON' => $reason,

- 'A_REASON' => addslashes($reason),

- ));

- }

- }

-

-

-?> \ No newline at end of file

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-/**

-* @package acp

-*/

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

- $template->assign_vars(array(

- 'DISPLAY_ON_POSTING' => $display_on_posting)

- foreach ($user->lang['tokens'] as $token => $token_explain)

- 'EXPLAIN' => ($token === 'LOCAL_URL') ? sprintf($token_explain, generate_board_url() . '/') : $token_explain,

-

- $sql_ary = array(

- );

- confirm_box(false, $user->lang['BBCODE_DANGER'], build_hidden_fields(array(

- ))

- $template->assign_vars(array(

- 'U_ACTION' => $this->u_action . '&amp;action=add')

- $sql = 'SELECT *

- FROM ' . BBCODES_TABLE . '

- ORDER BY bbcode_tag';

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

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

- 'U_EDIT' => $this->u_action . '&amp;action=edit&amp;bbcode=' . $row['bbcode_id'],

- 'U_DELETE' => $this->u_action . '&amp;action=delete&amp;bbcode=' . $row['bbcode_id'])

- $utf8 = strpos($bbcode_match, 'INTTEXT') !== false;

- // make sure we have utf8 support

- $utf8_pcre_properties = false;

- if (version_compare(PHP_VERSION, '5.1.0', '>=') || (version_compare(PHP_VERSION, '5.0.0-dev', '<=') && version_compare(PHP_VERSION, '4.4.0', '>=')))

- {

- // While this is the proper range of PHP versions, PHP may not be linked with the bundled PCRE lib and instead with an older version

- if (@preg_match('/\p{L}/u', 'a') !== false)

- {

- $utf8_pcre_properties = true;

- }

- }

-

-?> \ No newline at end of file

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-/**

-* @package acp

-*/

- global $cache;

- 'board_timezone' => array('lang' => 'SYSTEM_TIMEZONE', 'validate' => 'string', 'type' => 'select', 'function' => 'tz_select', 'params' => array('{CONFIG_VALUE}', 1), 'explain' => true),

- 'board_dst' => array('lang' => 'SYSTEM_DST', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

- 'default_style' => array('lang' => 'DEFAULT_STYLE', 'validate' => 'int', 'type' => 'select', 'function' => 'style_select', 'params' => array('{CONFIG_VALUE}', false), 'explain' => false),

- 'legend2' => 'WARNINGS',

- 'warnings_expire_days' => array('lang' => 'WARNINGS_EXPIRE', 'validate' => 'int', 'type' => 'text:3:4', 'explain' => true, 'append' => ' ' . $user->lang['DAYS']),

- 'legend3' => 'ACP_SUBMIT_CHANGES',

- 'avatar_min_width' => array('lang' => 'MIN_AVATAR_SIZE', 'validate' => 'int:0', 'type' => false, 'method' => false, 'explain' => false,),

- 'avatar_min_height' => array('lang' => 'MIN_AVATAR_SIZE', 'validate' => 'int:0', 'type' => false, 'method' => false, 'explain' => false,),

- 'avatar_max_width' => array('lang' => 'MAX_AVATAR_SIZE', 'validate' => 'int:0', 'type' => false, 'method' => false, 'explain' => false,),

- 'avatar_max_height' => array('lang' => 'MAX_AVATAR_SIZE', 'validate' => 'int:0', 'type' => false, 'method' => false, 'explain' => false,),

- 'allow_avatar_local' => array('lang' => 'ALLOW_LOCAL', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

- 'allow_avatar_remote' => array('lang' => 'ALLOW_REMOTE', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

- 'allow_avatar_upload' => array('lang' => 'ALLOW_UPLOAD', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

- 'allow_avatar_remote_upload'=> array('lang' => 'ALLOW_REMOTE_UPLOAD', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

- 'avatar_filesize' => array('lang' => 'MAX_FILESIZE', 'validate' => 'int:0', 'type' => 'text:4:10', 'explain' => true, 'append' => ' ' . $user->lang['BYTES']),

- 'avatar_min' => array('lang' => 'MIN_AVATAR_SIZE', 'validate' => 'int:0', 'type' => 'dimension:3:4', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

- 'avatar_max' => array('lang' => 'MAX_AVATAR_SIZE', 'validate' => 'int:0', 'type' => 'dimension:3:4', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

- 'avatar_path' => array('lang' => 'AVATAR_STORAGE_PATH', 'validate' => 'rpath', 'type' => 'text:20:255', 'explain' => true),

- 'avatar_gallery_path' => array('lang' => 'AVATAR_GALLERY_PATH', 'validate' => 'rpath', 'type' => 'text:20:255', 'explain' => true)

- 'pm_max_boxes' => array('lang' => 'BOXES_MAX', 'validate' => 'int:0', 'type' => 'text:4:4', 'explain' => true),

- 'pm_max_msgs' => array('lang' => 'BOXES_LIMIT', 'validate' => 'int:0', 'type' => 'text:4:4', 'explain' => true),

- 'pm_edit_time' => array('lang' => 'PM_EDIT_TIME', 'validate' => 'int:0', 'type' => 'text:5:5', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

- 'pm_max_recipients' => array('lang' => 'PM_MAX_RECIPIENTS', 'validate' => 'int:0', 'type' => 'text:5:5', 'explain' => true),

- 'edit_time' => array('lang' => 'EDIT_TIME', 'validate' => 'int:0', 'type' => 'text:5:5', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

- 'delete_time' => array('lang' => 'DELETE_TIME', 'validate' => 'int:0', 'type' => 'text:5:5', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

- 'flood_interval' => array('lang' => 'FLOOD_INTERVAL', 'validate' => 'int:0', 'type' => 'text:3:10', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

- 'topics_per_page' => array('lang' => 'TOPICS_PER_PAGE', 'validate' => 'int:1', 'type' => 'text:3:4', 'explain' => false),

- 'posts_per_page' => array('lang' => 'POSTS_PER_PAGE', 'validate' => 'int:1', 'type' => 'text:3:4', 'explain' => false),

- 'smilies_per_page' => array('lang' => 'SMILIES_PER_PAGE', 'validate' => 'int:1', 'type' => 'text:3:4', 'explain' => false),

- '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),

- 'min_post_chars' => array('lang' => 'MIN_CHAR_LIMIT', 'validate' => 'int:1', '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' => ' %'),

- 'max_quote_depth' => array('lang' => 'QUOTE_DEPTH_LIMIT', 'validate' => 'int:0', 'type' => 'text:4:4', 'explain' => true),

- 'max_post_img_width' => array('lang' => 'MAX_POST_IMG_WIDTH', 'validate' => 'int:0', 'type' => 'text:5:4', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

- 'max_post_img_height' => array('lang' => 'MAX_POST_IMG_HEIGHT', 'validate' => 'int:0', 'type' => 'text:5:4', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

- 'max_sig_chars' => array('lang' => 'MAX_SIG_LENGTH', 'validate' => 'int:0', 'type' => 'text:5:4', 'explain' => true),

- 'max_sig_urls' => array('lang' => 'MAX_SIG_URLS', 'validate' => 'int:0', 'type' => 'text:5:4', 'explain' => true),

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

- 'max_sig_smilies' => array('lang' => 'MAX_SIG_SMILIES', 'validate' => 'int:0', 'type' => 'text:5:4', 'explain' => true),

- 'max_sig_img_width' => array('lang' => 'MAX_SIG_IMG_WIDTH', 'validate' => 'int:0', 'type' => 'text:5:4', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

- 'max_sig_img_height' => array('lang' => 'MAX_SIG_IMG_HEIGHT', 'validate' => 'int:0', 'type' => 'text:5:4', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

- 'new_member_post_limit' => array('lang' => 'NEW_MEMBER_POST_LIMIT', 'validate' => 'int:0:255', 'type' => 'text:4:4', 'explain' => true, 'append' => ' ' . $user->lang['POSTS']),

- 'chg_passforce' => array('lang' => 'FORCE_PASS_CHANGE', 'validate' => 'int:0', 'type' => 'text:3:3', 'explain' => true, 'append' => ' ' . $user->lang['DAYS']),

- 'max_login_attempts' => array('lang' => 'MAX_LOGIN_ATTEMPTS', 'validate' => 'int:0', 'type' => 'text:3:3', 'explain' => true),

- 'max_reg_attempts' => array('lang' => 'REG_LIMIT', 'validate' => 'int:0', 'type' => 'text:4:4', 'explain' => true),

- 'feed_limit_post' => array('lang' => 'ACP_FEED_LIMIT', 'validate' => 'int:5', 'type' => 'text:3:4', 'explain' => true),

- 'feed_limit_topic' => array('lang' => 'ACP_FEED_LIMIT', 'validate' => 'int:5', 'type' => 'text:3:4', 'explain' => true),

- 'cookie_secure' => array('lang' => 'COOKIE_SECURE', 'validate' => 'bool', 'type' => 'radio:disabled_enabled', 'explain' => true)

- 'limit_load' => array('lang' => 'LIMIT_LOAD', 'validate' => 'string', 'type' => 'text:4:4', 'explain' => true),

- 'session_length' => array('lang' => 'SESSION_LENGTH', 'validate' => 'int:60', 'type' => 'text:5:10', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

- 'active_sessions' => array('lang' => 'LIMIT_SESSIONS', 'validate' => 'int:0', 'type' => 'text:4:4', 'explain' => true),

- 'load_online_time' => array('lang' => 'ONLINE_LENGTH', 'validate' => 'int:0', 'type' => 'text:4:3', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

- 'load_tplcompile' => array('lang' => 'RECOMPILE_STYLES', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

- 'auth_method' => array('lang' => 'AUTH_METHOD', 'validate' => 'string', 'type' => 'select', 'method' => 'select_auth_method', 'explain' => false)

- 'server_port' => array('lang' => 'SERVER_PORT', 'validate' => 'int:0', 'type' => 'text:5:5', 'explain' => true),

- 'max_autologin_time' => array('lang' => 'AUTOLOGIN_LENGTH', 'validate' => 'int:0', 'type' => 'text:5:5', 'explain' => true, 'append' => ' ' . $user->lang['DAYS']),

- 'referer_validation' => array('lang' => 'REFERER_VALID', 'validate' => 'int:0:3','type' => 'custom', 'method' => 'select_ref_check', 'explain' => true),

- 'chg_passforce' => array('lang' => 'FORCE_PASS_CHANGE', 'validate' => 'int:0', 'type' => 'text:3:3', 'explain' => true, 'append' => ' ' . $user->lang['DAYS']),

- 'max_login_attempts' => array('lang' => 'MAX_LOGIN_ATTEMPTS', 'validate' => 'int:0', 'type' => 'text:3:3', 'explain' => true),

- 'ip_login_limit_max' => array('lang' => 'IP_LOGIN_LIMIT_MAX', 'validate' => 'int:0', 'type' => 'text:3:3', 'explain' => true),

- 'ip_login_limit_time' => array('lang' => 'IP_LOGIN_LIMIT_TIME', 'validate' => 'int:0', 'type' => 'text:5:5', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

- 'form_token_lifetime' => array('lang' => 'FORM_TIME_MAX', 'validate' => 'int:-1', 'type' => 'text:5:5', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

- 'email_package_size' => array('lang' => 'EMAIL_PACKAGE_SIZE', 'validate' => 'int:0', 'type' => 'text:5:5', 'explain' => true),

- 'board_contact' => array('lang' => 'CONTACT_EMAIL', 'validate' => 'email', 'type' => 'text:25:100', 'explain' => true),

- 'board_email' => array('lang' => 'ADMIN_EMAIL', 'validate' => 'email', 'type' => 'text:25:100', 'explain' => true),

- 'smtp_port' => array('lang' => 'SMTP_PORT', 'validate' => 'int:0', 'type' => 'text:4:5', 'explain' => true),

- // We validate the complete config if whished

- $auth_plugins = array();

-

- $dp = @opendir($phpbb_root_path . 'includes/auth');

- if ($dp)

- while (($file = readdir($dp)) !== false)

- if (preg_match('#^auth_(.*?)\.' . $phpEx . '$#', $file))

- $auth_plugins[] = basename(preg_replace('#^auth_(.*?)\.' . $phpEx . '$#', '\1', $file));

- }

- }

- closedir($dp);

- sort($auth_plugins);

- }

- $updated_auth_settings = false;

- $old_auth_config = array();

- foreach ($auth_plugins as $method)

- {

- if ($method && file_exists($phpbb_root_path . 'includes/auth/auth_' . $method . '.' . $phpEx))

- {

- include_once($phpbb_root_path . 'includes/auth/auth_' . $method . '.' . $phpEx);

- $method = 'acp_' . $method;

- if (function_exists($method))

- {

- if ($fields = $method($this->new_config))

- // Check if we need to create config fields for this plugin and save config when submit was pressed

- foreach ($fields['config'] as $field)

- {

- if (!isset($config[$field]))

- {

- set_config($field, '');

- }

-

- if (!isset($cfg_array[$field]) || strpos($field, 'legend') !== false)

- {

- continue;

- }

-

- $old_auth_config[$field] = $this->new_config[$field];

- $config_value = $cfg_array[$field];

- $this->new_config[$field] = $config_value;

-

- if ($submit)

- {

- $updated_auth_settings = true;

- set_config($field, $config_value);

- }

- }

- unset($fields);

- if ($method && in_array($method, $auth_plugins))

- include_once($phpbb_root_path . 'includes/auth/auth_' . $method . '.' . $phpEx);

-

- $method = 'init_' . $method;

- if (function_exists($method))

- if ($error = $method())

- foreach ($old_auth_config as $config_name => $config_value)

- {

- set_config($config_name, $config_value);

- }

- trigger_error($error . adm_back_link($this->u_action), E_USER_WARNING);

- trigger_error($user->lang['CONFIG_UPDATED'] . adm_back_link($this->u_action));

- foreach ($auth_plugins as $method)

- if ($method && file_exists($phpbb_root_path . 'includes/auth/auth_' . $method . '.' . $phpEx))

- $method = 'acp_' . $method;

- if (function_exists($method))

- $fields = $method($this->new_config);

-

- if ($fields['tpl'])

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

- 'TPL' => $fields['tpl'])

- );

- unset($fields);

- global $phpbb_root_path, $phpEx;

- $dp = @opendir($phpbb_root_path . 'includes/auth');

-

- if (!$dp)

- return '';

- }

-

- while (($file = readdir($dp)) !== false)

- {

- if (preg_match('#^auth_(.*?)\.' . $phpEx . '$#', $file))

- $auth_plugins[] = preg_replace('#^auth_(.*?)\.' . $phpEx . '$#', '\1', $file);

- closedir($dp);

- $auth_select .= '<option value="' . $method . '"' . $selected . '>' . ucfirst($method) . '</option>';

- 'ACC_DISABLE' => USER_ACTIVATION_DISABLE,

- 'ACC_NONE' => USER_ACTIVATION_NONE,

- if ($config['email_enable'])

- {

- $act_ary['ACC_USER'] = USER_ACTIVATION_SELF;

- $act_ary['ACC_ADMIN'] = USER_ACTIVATION_ADMIN;

- }

- $act_options = '';

- foreach ($act_ary as $key => $value)

- $act_options .= '<option value="' . $value . '"' . $selected . '>' . $user->lang[$key] . '</option>';

- return '<input id="' . $key . '" type="text" size="3" maxlength="3" name="config[min_name_chars]" value="' . $value . '" /> ' . $user->lang['MIN_CHARS'] . '&nbsp;&nbsp;<input type="text" size="3" maxlength="3" name="config[max_name_chars]" value="' . $this->new_config['max_name_chars'] . '" /> ' . $user->lang['MAX_CHARS'];

- return '<input id="' . $key . '" type="text" size="3" maxlength="3" name="config[min_pass_chars]" value="' . $value . '" /> ' . $user->lang['MIN_CHARS'] . '&nbsp;&nbsp;<input type="text" size="3" maxlength="3" name="config[max_pass_chars]" value="' . $this->new_config['max_pass_chars'] . '" /> ' . $user->lang['MAX_CHARS'];

- $old_dst = $user->dst;

-

- $user->timezone = $config['board_timezone'] * 3600;

- $user->dst = $config['board_dst'] * 3600;

- $user->dst = $old_dst;

-}

-?> \ No newline at end of file

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-/**

-* @package acp

-*/

- global $config, $db, $user, $auth, $template, $cache;

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-?> \ No newline at end of file

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-/**

-* @package acp

-*/

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

- include($phpbb_root_path . 'includes/captcha/captcha_factory.' . $phpEx);

- $captchas = phpbb_captcha_factory::get_captcha_types();

-

- $config_captcha =& phpbb_captcha_factory::get_instance($selected);

- $old_captcha =& phpbb_captcha_factory::get_instance($config['captcha_plugin']);

- $new_captcha =& phpbb_captcha_factory::get_instance($config['captcha_plugin']);

- $captcha_select .= '<option value="' . $value . '"' . $current . '>' . $user->lang[$title] . '</option>';

- $captcha_select .= '<option value="' . $value . '"' . $current . ' class="disabled-option">' . $user->lang[$title] . '</option>';

- $demo_captcha =& phpbb_captcha_factory::get_instance($selected);

- global $db, $user, $config;

- $captcha =& phpbb_captcha_factory::get_instance($selected);

-

-?> \ No newline at end of file

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-/**

-* @package acp

-*/

- if (!class_exists('phpbb_db_tools'))

- {

- require($phpbb_root_path . 'includes/db/db_tools.' . $phpEx);

- }

- $this->db_tools = new phpbb_db_tools($db);

- switch ($db->sql_layer)

- $extractor = new mysql_extractor($download, $store, $format, $filename, $time);

- $extractor = new sqlite_extractor($download, $store, $format, $filename, $time);

- $extractor = new postgres_extractor($download, $store, $format, $filename, $time);

- $extractor = new oracle_extractor($download, $store, $format, $filename, $time);

- $extractor = new mssql_extractor($download, $store, $format, $filename, $time);

- break;

-

- case 'firebird':

- $extractor = new firebird_extractor($download, $store, $format, $filename, $time);

- switch ($db->sql_layer)

- case 'firebird':

- header('Pragma: no-cache');

- switch ($db->sql_layer)

- case 'firebird':

- $delim = ";\n";

- while (($sql = $fgetd($fp, $delim, $read, $seek, $eof)) !== false)

- {

- $query = trim($sql);

- if (substr($query, 0, 8) === 'SET TERM')

- {

- $delim = $query[9] . "\n";

- continue;

- }

- $db->sql_query($query);

- }

- break;

-

- pg_put_line($db->db_connect_id, $sub . "\n");

- pg_put_line($db->db_connect_id, "\\.\n");

- pg_end_copy($db->db_connect_id);

-/**

-* @package acp

-*/

- function base_extractor($download = false, $store = false, $format, $filename, $time)

- header('Pragma: no-cache');

- if ((isset($_SERVER['HTTP_ACCEPT_ENCODING']) && strpos($_SERVER['HTTP_ACCEPT_ENCODING'], 'gzip') !== false) && strpos(strtolower($_SERVER['HTTP_USER_AGENT']), 'msie') === false)

-/**

-* @package acp

-*/

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

- if ($db->sql_layer === 'mysqli')

- $result = mysqli_query($db->db_connect_id, $sql, MYSQLI_USE_RESULT);

- $result = mysql_unbuffered_query($sql, $db->db_connect_id);

-/**

-* @package acp

-*/

- static $proper;

- if (is_null($proper))

- {

- $proper = version_compare(PHP_VERSION, '5.1.3', '>=');

- }

- if ($proper)

- $col_types = sqlite_fetch_column_types($db->db_connect_id, $table_name);

- else

- {

- $sql = "SELECT sql

- FROM sqlite_master

- WHERE type = 'table'

- AND name = '" . $table_name . "'";

- $table_data = sqlite_single_query($db->db_connect_id, $sql);

- $table_data = preg_replace('#CREATE\s+TABLE\s+"?' . $table_name . '"?#i', '', $table_data);

- $table_data = trim($table_data);

- preg_match('#\((.*)\)#s', $table_data, $matches);

- $table_cols = explode(',', trim($matches[1]));

- foreach ($table_cols as $declaration)

- $entities = preg_split('#\s+#', trim($declaration));

- $column_name = preg_replace('/"?([^"]+)"?/', '\1', $entities[0]);

- // Hit a primary key, those are not what we need :D

- if (empty($entities[1]) || (strtolower($entities[0]) === 'primary' && strtolower($entities[1]) === 'key'))

- {

- continue;

- }

- $col_types[$column_name] = $entities[1];

- $result = sqlite_unbuffered_query($db->db_connect_id, $sql);

- $rows = sqlite_fetch_all($result, SQLITE_ASSOC);

- $sql_insert = 'INSERT INTO ' . $table_name . ' (' . implode(', ', array_keys($col_types)) . ') VALUES (';

- foreach ($rows as $row)

- else if ($column_data == '')

- else if (strpos($col_types[$column_name], 'text') !== false || strpos($col_types[$column_name], 'char') !== false || strpos($col_types[$column_name], 'blob') !== false)

-/**

-* @package acp

-*/

-

-

-/**

-* @package acp

-*/

- if ($db->sql_layer === 'mssql')

- else if($db->sql_layer === 'mssqlnative')

-

- $sql = "SELECT * FROM $table_name";

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

- $row = new result_mssqlnative($result_fields);

- $i_num_fields = $row->num_fields();

-

- for ($i = 0; $i < $i_num_fields; $i++)

- $ary_type[$i] = $row->field_type($i);

- $ary_name[$i] = $row->field_name($i);

-

- }

-

-/**

-* @package acp

-*/

-/**

-* @package acp

-*/

-class firebird_extractor extends base_extractor

-{

- function write_start($prefix)

- {

- $sql_data = "--\n";

- $sql_data .= "-- phpBB Backup Script\n";

- $sql_data .= "-- Dump of tables for $prefix\n";

- $sql_data .= "-- DATE : " . gmdate("d-m-Y H:i:s", $this->time) . " GMT\n";

- $sql_data .= "--\n";

- $this->flush($sql_data);

- }

-

- function write_data($table_name)

- {

- global $db;

- $ary_type = $ary_name = array();

-

- // Grab all of the data from current table.

- $sql = "SELECT *

- FROM $table_name";

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

-

- $i_num_fields = ibase_num_fields($result);

-

- for ($i = 0; $i < $i_num_fields; $i++)

- {

- $info = ibase_field_info($result, $i);

- $ary_type[$i] = $info['type'];

- $ary_name[$i] = $info['name'];

- }

-

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

- {

- $schema_vals = $schema_fields = array();

-

- // Build the SQL statement to recreate the data.

- for ($i = 0; $i < $i_num_fields; $i++)

- {

- $str_val = $row[strtolower($ary_name[$i])];

-

- if (preg_match('#char|text|bool|varbinary|blob#i', $ary_type[$i]))

- {

- $str_quote = '';

- $str_empty = "''";

- $str_val = sanitize_data_generic(str_replace("'", "''", $str_val));

- }

- else if (preg_match('#date|timestamp#i', $ary_type[$i]))

- {

- if (empty($str_val))

- {

- $str_quote = '';

- }

- else

- {

- $str_quote = "'";

- }

- }

- else

- {

- $str_quote = '';

- $str_empty = 'NULL';

- }

-

- if (empty($str_val) && $str_val !== '0')

- {

- $str_val = $str_empty;

- }

-

- $schema_vals[$i] = $str_quote . $str_val . $str_quote;

- $schema_fields[$i] = '"' . $ary_name[$i] . '"';

- }

-

- // Take the ordered fields and their associated data and build it

- // into a valid sql statement to recreate that field in the data.

- $sql_data = "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES (' . implode(', ', $schema_vals) . ");\n";

-

- $this->flush($sql_data);

- }

- $db->sql_freeresult($result);

- }

-

- function write_table($table_name)

- {

- global $db;

-

- $sql_data = '-- Table: ' . $table_name . "\n";

- $sql_data .= "DROP TABLE $table_name;\n";

-

- $data_types = array(7 => 'SMALLINT', 8 => 'INTEGER', 10 => 'FLOAT', 12 => 'DATE', 13 => 'TIME', 14 => 'CHARACTER', 27 => 'DOUBLE PRECISION', 35 => 'TIMESTAMP', 37 => 'VARCHAR', 40 => 'CSTRING', 261 => 'BLOB', 701 => 'DECIMAL', 702 => 'NUMERIC');

-

- $sql_data .= "\nCREATE TABLE $table_name (\n";

-

- $sql = 'SELECT DISTINCT R.RDB$FIELD_NAME as FNAME, R.RDB$NULL_FLAG as NFLAG, R.RDB$DEFAULT_SOURCE as DSOURCE, F.RDB$FIELD_TYPE as FTYPE, F.RDB$FIELD_SUB_TYPE as STYPE, F.RDB$FIELD_LENGTH as FLEN

- FROM RDB$RELATION_FIELDS R

- JOIN RDB$FIELDS F ON R.RDB$FIELD_SOURCE=F.RDB$FIELD_NAME

- LEFT JOIN RDB$FIELD_DIMENSIONS D ON R.RDB$FIELD_SOURCE = D.RDB$FIELD_NAME

- WHERE F.RDB$SYSTEM_FLAG = 0

- AND R.RDB$RELATION_NAME = \''. $table_name . '\'

- ORDER BY R.RDB$FIELD_POSITION';

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

-

- $rows = array();

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

- {

- $line = "\t" . '"' . $row['fname'] . '" ' . $data_types[$row['ftype']];

-

- if ($row['ftype'] == 261 && $row['stype'] == 1)

- {

- $line .= ' SUB_TYPE TEXT';

- }

-

- if ($row['ftype'] == 37 || $row['ftype'] == 14)

- {

- $line .= ' (' . $row['flen'] . ')';

- }

-

- if (!empty($row['dsource']))

- {

- $line .= ' ' . $row['dsource'];

- }

-

- if (!empty($row['nflag']))

- {

- $line .= ' NOT NULL';

- }

- $rows[] = $line;

- }

- $db->sql_freeresult($result);

-

- $sql_data .= implode(",\n", $rows);

- $sql_data .= "\n);\n";

- $keys = array();

-

- $sql = 'SELECT I.RDB$FIELD_NAME as NAME

- FROM RDB$RELATION_CONSTRAINTS RC, RDB$INDEX_SEGMENTS I, RDB$INDICES IDX

- WHERE (I.RDB$INDEX_NAME = RC.RDB$INDEX_NAME)

- AND (IDX.RDB$INDEX_NAME = RC.RDB$INDEX_NAME)

- AND (RC.RDB$RELATION_NAME = \''. $table_name . '\')

- ORDER BY I.RDB$FIELD_POSITION';

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

-

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

- {

- $keys[] = $row['name'];

- }

-

- if (sizeof($keys))

- {

- $sql_data .= "\nALTER TABLE $table_name ADD PRIMARY KEY (" . implode(', ', $keys) . ');';

- }

-

- $db->sql_freeresult($result);

-

- $sql = 'SELECT I.RDB$INDEX_NAME as INAME, I.RDB$UNIQUE_FLAG as UFLAG, S.RDB$FIELD_NAME as FNAME

- FROM RDB$INDICES I JOIN RDB$INDEX_SEGMENTS S ON S.RDB$INDEX_NAME=I.RDB$INDEX_NAME

- WHERE (I.RDB$SYSTEM_FLAG IS NULL OR I.RDB$SYSTEM_FLAG=0)

- AND I.RDB$FOREIGN_KEY IS NULL

- AND I.RDB$RELATION_NAME = \''. $table_name . '\'

- AND I.RDB$INDEX_NAME NOT STARTING WITH \'RDB$\'

- ORDER BY S.RDB$FIELD_POSITION';

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

-

- $index = array();

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

- {

- $index[$row['iname']]['unique'] = !empty($row['uflag']);

- $index[$row['iname']]['values'][] = $row['fname'];

- }

-

- foreach ($index as $index_name => $data)

- {

- $sql_data .= "\nCREATE ";

- if ($data['unique'])

- {

- $sql_data .= 'UNIQUE ';

- }

- $sql_data .= "INDEX $index_name ON $table_name(" . implode(', ', $data['values']) . ");";

- }

- $sql_data .= "\n";

-

- $db->sql_freeresult($result);

-

- $sql = 'SELECT D1.RDB$DEPENDENT_NAME as DNAME, D1.RDB$FIELD_NAME as FNAME, D1.RDB$DEPENDENT_TYPE, R1.RDB$RELATION_NAME

- FROM RDB$DEPENDENCIES D1

- LEFT JOIN RDB$RELATIONS R1 ON ((D1.RDB$DEPENDENT_NAME = R1.RDB$RELATION_NAME) AND (NOT (R1.RDB$VIEW_BLR IS NULL)))

- WHERE (D1.RDB$DEPENDED_ON_TYPE = 0)

- AND (D1.RDB$DEPENDENT_TYPE <> 3)

- AND (D1.RDB$DEPENDED_ON_NAME = \'' . $table_name . '\')

- UNION SELECT DISTINCT F2.RDB$RELATION_NAME, D2.RDB$FIELD_NAME, D2.RDB$DEPENDENT_TYPE, R2.RDB$RELATION_NAME FROM RDB$DEPENDENCIES D2, RDB$RELATION_FIELDS F2

- LEFT JOIN RDB$RELATIONS R2 ON ((F2.RDB$RELATION_NAME = R2.RDB$RELATION_NAME) AND (NOT (R2.RDB$VIEW_BLR IS NULL)))

- WHERE (D2.RDB$DEPENDENT_TYPE = 3)

- AND (D2.RDB$DEPENDENT_NAME = F2.RDB$FIELD_SOURCE)

- AND (D2.RDB$DEPENDED_ON_NAME = \'' . $table_name . '\')

- ORDER BY 1, 2';

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

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

- {

- $sql = 'SELECT T1.RDB$DEPENDED_ON_NAME as GEN, T1.RDB$FIELD_NAME, T1.RDB$DEPENDED_ON_TYPE

- FROM RDB$DEPENDENCIES T1

- WHERE (T1.RDB$DEPENDENT_NAME = \'' . $row['dname'] . '\')

- AND (T1.RDB$DEPENDENT_TYPE = 2 AND T1.RDB$DEPENDED_ON_TYPE = 14)

- UNION ALL SELECT DISTINCT D.RDB$DEPENDED_ON_NAME, D.RDB$FIELD_NAME, D.RDB$DEPENDED_ON_TYPE

- FROM RDB$DEPENDENCIES D, RDB$RELATION_FIELDS F

- WHERE (D.RDB$DEPENDENT_TYPE = 3)

- AND (D.RDB$DEPENDENT_NAME = F.RDB$FIELD_SOURCE)

- AND (F.RDB$RELATION_NAME = \'' . $row['dname'] . '\')

- ORDER BY 1,2';

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

- $row2 = $db->sql_fetchrow($result2);

- $db->sql_freeresult($result2);

- $gen_name = $row2['gen'];

-

- $sql_data .= "\nDROP GENERATOR " . $gen_name . ";";

- $sql_data .= "\nSET TERM ^ ;";

- $sql_data .= "\nCREATE GENERATOR " . $gen_name . "^";

- $sql_data .= "\nSET GENERATOR " . $gen_name . " TO 0^\n";

- $sql_data .= "\nCREATE TRIGGER {$row['dname']} FOR $table_name";

- $sql_data .= "\nBEFORE INSERT\nAS\nBEGIN";

- $sql_data .= "\n NEW.{$row['fname']} = GEN_ID(" . $gen_name . ", 1);";

- $sql_data .= "\nEND^\n";

- $sql_data .= "\nSET TERM ; ^\n";

- }

-

- $this->flush($sql_data);

-

- $db->sql_freeresult($result);

- }

-}

-

-

-?> \ No newline at end of file

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-/**

-* @package acp

-*/

-

-?> \ No newline at end of file

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-/**

-* @package acp

-*/

- global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix;

- if ($usernames)

- $sql = 'SELECT username, user_email, user_jabber, user_notify_type, user_lang

- FROM ' . USERS_TABLE . '

- WHERE ' . $db->sql_in_set('username_clean', array_map('utf8_clean_string', explode("\n", $usernames))) . '

- AND user_allow_massemail = 1

- ORDER BY user_lang, user_notify_type'; // , SUBSTRING(user_email FROM INSTR(user_email, '@'))

- $sql = $db->sql_build_query('SELECT', $sql_ary);

- $messenger->template('admin_send_email', $used_lang);

- $messenger->assign_vars(array(

- 'CONTACT_EMAIL' => $config['board_contact'],

- 'MESSAGE' => htmlspecialchars_decode($message))

- );

- if ($usernames)

- {

- $usernames = explode("\n", $usernames);

- add_log('admin', 'LOG_MASS_EMAIL', implode(', ', utf8_normalize_nfc($usernames)));

- }

- else

- if ($group_id)

- $group_name = get_group_name($group_id);

- // Not great but the logging routine doesn't cope well with localising on the fly

- $group_name = $user->lang['ALL_USERS'];

- }

- add_log('admin', 'LOG_MASS_EMAIL', $group_name);

- $template->assign_vars(array(

- 'USERNAMES' => $usernames,

- 'S_PRIORITY_OPTIONS' => $s_priority_options)

-

-?> \ No newline at end of file

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-/**

-* @package acp

-*/

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

- cache_moderators();

- $sql = 'SELECT forum_name, forum_topics_real

- if ($row['forum_topics_real'])

- sync('topic_approved', 'range', 'topic_id BETWEEN ' . $start . ' AND ' . $end, true, false);

- $url = $this->u_action . "&amp;parent_id={$this->parent_id}&amp;f=$forum_id&amp;action=sync&amp;start=$start&amp;topics_done=$topics_done&amp;total={$row['forum_topics_real']}";

- 'U_PROGRESS_BAR' => $this->u_action . "&amp;action=progress_bar&amp;start=$topics_done&amp;total={$row['forum_topics_real']}",

- 'UA_PROGRESS_BAR' => addslashes($this->u_action . "&amp;action=progress_bar&amp;start=$topics_done&amp;total={$row['forum_topics_real']}"),

- 'L_PROGRESS_EXPLAIN' => sprintf($user->lang['SYNC_IN_PROGRESS_EXPLAIN'], $topics_done, $row['forum_topics_real']))

- 'L_PROGRESS_EXPLAIN' => sprintf($user->lang['SYNC_IN_PROGRESS_EXPLAIN'], 0, $row['forum_topics_real']))

- $template->assign_vars(array(

- ));

- cache_moderators();

- 'FORUM_TOPICS' => $row['forum_topics'],

- 'FORUM_POSTS' => $row['forum_posts'],

- global $db, $user, $cache, $phpbb_root_path;

- $forum_data_sql['forum_password'] = phpbb_hash($forum_data_sql['forum_password']);

- if (!isset($forum_data_sql['forum_id']))

- $forum_data_sql['forum_posts'] = $forum_data_sql['forum_topics'] = $forum_data_sql['forum_topics_real'] = $forum_data_sql['forum_last_post_id'] = $forum_data_sql['forum_last_poster_id'] = $forum_data_sql['forum_last_post_time'] = 0;

- $forum_data_sql['forum_posts'] = 0;

- $forum_data_sql['forum_topics'] = 0;

- $forum_data_sql['forum_topics_real'] = 0;

- global $db, $user;

- return $errors;

- global $db;

- AND post_approved = 1';

- switch ($db->sql_layer)

- WHERE post_approved = 1';

- WHERE topic_approved = 1';

-

-?> \ No newline at end of file

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-/**

-* @package acp

-*/

-

- $can_upload = (file_exists($phpbb_root_path . $config['avatar_path']) && phpbb_is_writable($phpbb_root_path . $config['avatar_path']) && $file_uploads) ? true : false;

- $sql = 'SELECT *

- FROM ' . GROUPS_TABLE . "

- WHERE group_id = $group_id";

- group_user_attributes('default', $group_id, $mark_ary, false, $group_name, $group_row);

- $avatar_select = basename(request_var('avatar_select', ''));

- $category = basename(request_var('category', ''));

- $data['uploadurl'] = request_var('uploadurl', '');

- $data['remotelink'] = request_var('remotelink', '');

- $data['width'] = request_var('width', '');

- $data['height'] = request_var('height', '');

- $delete = request_var('delete', '');

-

- if (!empty($_FILES['uploadfile']['tmp_name']) || $data['uploadurl'] || $data['remotelink'])

- // Avatar stuff

- $var_ary = array(

- 'uploadurl' => array('string', true, 5, 255),

- 'remotelink' => array('string', true, 5, 255),

- 'width' => array('string', true, 1, 3),

- 'height' => array('string', true, 1, 3),

- );

-

- if (!($error = validate_data($data, $var_ary)))

- {

- $data['user_id'] = "g$group_id";

- if ((!empty($_FILES['uploadfile']['tmp_name']) || $data['uploadurl']) && $can_upload)

- {

- list($submit_ary['avatar_type'], $submit_ary['avatar'], $submit_ary['avatar_width'], $submit_ary['avatar_height']) = avatar_upload($data, $error);

- }

- else if ($data['remotelink'])

- {

- list($submit_ary['avatar_type'], $submit_ary['avatar'], $submit_ary['avatar_width'], $submit_ary['avatar_height']) = avatar_remote($data, $error);

- }

- }

- }

- else if ($avatar_select && $config['allow_avatar_local'])

- {

- // check avatar gallery

- if (is_dir($phpbb_root_path . $config['avatar_gallery_path'] . '/' . $category))

- $submit_ary['avatar_type'] = AVATAR_GALLERY;

- list($submit_ary['avatar_width'], $submit_ary['avatar_height']) = getimagesize($phpbb_root_path . $config['avatar_gallery_path'] . '/' . $category . '/' . $avatar_select);

- $submit_ary['avatar'] = $category . '/' . $avatar_select;

- }

- }

- else if ($delete)

- {

- $submit_ary['avatar'] = '';

- $submit_ary['avatar_type'] = $submit_ary['avatar_width'] = $submit_ary['avatar_height'] = 0;

- }

- else if ($data['width'] && $data['height'])

- {

- // Only update the dimensions?

- if ($config['avatar_max_width'] || $config['avatar_max_height'])

- {

- if ($data['width'] > $config['avatar_max_width'] || $data['height'] > $config['avatar_max_height'])

- $error[] = sprintf($user->lang['AVATAR_WRONG_SIZE'], $config['avatar_min_width'], $config['avatar_min_height'], $config['avatar_max_width'], $config['avatar_max_height'], $data['width'], $data['height']);

-

- if (!sizeof($error))

- if ($config['avatar_min_width'] || $config['avatar_min_height'])

- if ($data['width'] < $config['avatar_min_width'] || $data['height'] < $config['avatar_min_height'])

- {

- $error[] = sprintf($user->lang['AVATAR_WRONG_SIZE'], $config['avatar_min_width'], $config['avatar_min_height'], $config['avatar_max_width'], $config['avatar_max_height'], $data['width'], $data['height']);

- }

- }

- if (!sizeof($error))

- {

- $submit_ary['avatar_width'] = $data['width'];

- $submit_ary['avatar_height'] = $data['height'];

- }

- if ((isset($submit_ary['avatar']) && $submit_ary['avatar'] && (!isset($group_row['group_avatar']))) || $delete)

- {

- if (isset($group_row['group_avatar']) && $group_row['group_avatar'])

- {

- avatar_delete('group', $group_row, true);

- }

- 'avatar_type' => 'int',

- if (isset($submit_ary[$test]) && ($action == 'add' || $group_row['group_' . $test] != $submit_ary[$test]))

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

- $avatar_img = (!empty($group_row['group_avatar'])) ? get_user_avatar($group_row['group_avatar'], $group_row['group_avatar_type'], $group_row['group_avatar_width'], $group_row['group_avatar_height'], 'GROUP_AVATAR') : '<img src="' . $phpbb_admin_path . 'images/no_avatar.gif" alt="" />';

- $display_gallery = (isset($_POST['display_gallery'])) ? true : false;

- if ($config['allow_avatar_local'] && $display_gallery)

- avatar_gallery($category, $avatar_select, 4);

- 'S_CAN_UPLOAD' => $can_upload,

- 'S_DISPLAY_GALLERY' => ($config['allow_avatar_local'] && !$display_gallery) ? true : false,

- 'S_IN_GALLERY' => ($config['allow_avatar_local'] && $display_gallery) ? true : false,

- 'AVATAR' => $avatar_img,

- 'AVATAR_IMAGE' => $avatar_img,

- 'U_SWATCH' => append_sid("{$phpbb_admin_path}swatch.$phpEx", 'form=settings&amp;name=group_colour'),

- 'L_AVATAR_EXPLAIN' => sprintf($user->lang['AVATAR_EXPLAIN'], $config['avatar_max_width'], $config['avatar_max_height'], round($config['avatar_filesize'] / 1024)),

- 'S_ON_PAGE' => on_page($total_members, $config['topics_per_page'], $start),

- 'PAGINATION' => generate_pagination($this->u_action . "&amp;action=$action&amp;g=$group_id", $total_members, $config['topics_per_page'], $start, true),

-}

-?>

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-* @package acp

-

- 'PHPBB_ROOT_PATH' => $phpbb_root_path,

- if (!empty($_POST['add_additional_code']))

- if (!empty($_POST['add_display_on_posting']))

- trigger_error(sprintf($user->lang['TOO_MANY_SMILIES'], SMILEY_LIMIT) . adm_back_link($this->u_action), E_USER_WARNING);

- }

- $level = E_USER_NOTICE;

- switch ($icons_updated)

- {

- case 0:

- $suc_lang = "{$lang}_NONE";

- $level = E_USER_WARNING;

- break;

-

- case 1:

- $suc_lang = "{$lang}_ONE";

- break;

-

- default:

- $suc_lang = $lang;

- }

- trigger_error($user->lang[$suc_lang . '_EDITED'] . $errormsgs . adm_back_link($this->u_action), $level);

- trigger_error($user->lang[$suc_lang . '_ADDED'] . $errormsgs . adm_back_link($this->u_action), $level);

- switch ($db->sql_layer)

- case 'firebird':

- trigger_error(sprintf($user->lang['TOO_MANY_SMILIES'], SMILEY_LIMIT) . adm_back_link($this->u_action), E_USER_WARNING);

- header('Pragma: public');

- if ($db->sql_affectedrows())

- $template->assign_var('PAGINATION',

- generate_pagination($this->u_action, $item_count, $config['smilies_per_page'], $pagination_start, true)

- );

-

-?> \ No newline at end of file

-* @package acp

-* @version $Id$

-* @copyright (c) 2006 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-/**

-* @package acp

-*/

- global $config, $db, $user, $auth, $template;

- $messenger->to($row['user_email'], $row['username']);

- foreach ($mark as $user_id)

- {

- user_delete('retain', $user_id, $user_affected[$user_id]);

- }

- $messenger->to($row['user_email'], $row['username']);

- $messenger->im($row['user_jabber'], $row['username']);

- unset($usernames);

- 'S_ON_PAGE' => on_page($inactive_count, $per_page, $start),

- 'PAGINATION' => generate_pagination($this->u_action . "&amp;$u_sort_param&amp;users_per_page=$per_page", $inactive_count, $per_page, $start, true),

-

-?> \ No newline at end of file

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-/**

-* @package acp

-*/

- $jab_enable = request_var('jab_enable', (bool) $config['jab_enable']);

- $jab_host = request_var('jab_host', (string) $config['jab_host']);

- $jab_port = request_var('jab_port', (int) $config['jab_port']);

- $jab_username = request_var('jab_username', (string) $config['jab_username']);

- $jab_password = request_var('jab_password', (string) $config['jab_password']);

- $jab_package_size = request_var('jab_package_size', (int) $config['jab_package_size']);

- $jab_use_ssl = request_var('jab_use_ssl', (bool) $config['jab_use_ssl']);

-

-?> \ No newline at end of file

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-/**

-* @package acp

-*/

- global $config, $db, $user, $auth, $template, $cache;

- global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix;

- global $safe_mode, $file_uploads;

- $this->default_variables();

-

-

- $action = (isset($_POST['download_file'])) ? 'download_file' : $action;

- $action = (isset($_POST['upload_file'])) ? 'upload_file' : $action;

- $action = (isset($_POST['upload_data'])) ? 'upload_data' : $action;

- $action = (isset($_POST['submit_file'])) ? 'submit_file' : $action;

- if (isset($_POST['missing_file']))

- {

- $missing_file = request_var('missing_file', array('' => 0));

- list($_REQUEST['language_file'], ) = array_keys($missing_file);

- }

- if ($submit && $action == 'upload_data' && request_var('test_connection', ''))

- {

- $test_connection = false;

- $action = 'upload_file';

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

-

- include_once($phpbb_root_path . 'includes/functions_transfer.' . $phpEx);

-

- switch ($method)

- {

- case 'ftp':

- $transfer = new ftp(request_var('host', ''), request_var('username', ''), request_var('password', ''), request_var('root_path', ''), request_var('port', ''), request_var('timeout', ''));

- break;

-

- case 'ftp_fsock':

- $transfer = new ftp_fsock(request_var('host', ''), request_var('username', ''), request_var('password', ''), request_var('root_path', ''), request_var('port', ''), request_var('timeout', ''));

- break;

-

- default:

- trigger_error($user->lang['INVALID_UPLOAD_METHOD'], E_USER_ERROR);

- break;

- }

-

- $test_connection = $transfer->open_session();

- $transfer->close_session();

- }

-

- case 'upload_file':

-

- include_once($phpbb_root_path . 'includes/functions_transfer.' . $phpEx);

-

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

-

- if (!class_exists($method))

- {

- trigger_error('Method does not exist.', E_USER_ERROR);

- }

-

- $requested_data = call_user_func(array($method, 'data'));

- foreach ($requested_data as $data => $default)

- {

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

- 'DATA' => $data,

- 'NAME' => $user->lang[strtoupper($method . '_' . $data)],

- 'EXPLAIN' => $user->lang[strtoupper($method . '_' . $data) . '_EXPLAIN'],

- 'DEFAULT' => (!empty($_REQUEST[$data])) ? request_var($data, '') : $default

- ));

- }

-

- $hidden_data = build_hidden_fields(array(

- 'file' => $this->language_file,

- 'dir' => $this->language_directory,

- 'language_file' => $selected_lang_file,

- 'method' => $method)

- );

-

- $hidden_data .= build_hidden_fields(array('entry' => $_POST['entry']), true, STRIP);

-

- $template->assign_vars(array(

- 'S_UPLOAD' => true,

- 'NAME' => $method,

- 'U_ACTION' => $this->u_action . "&amp;id=$lang_id&amp;action=upload_data",

- 'U_BACK' => $this->u_action . "&amp;id=$lang_id&amp;action=details&amp;language_file=" . urlencode($selected_lang_file),

- 'HIDDEN' => $hidden_data,

-

- 'S_CONNECTION_SUCCESS' => (request_var('test_connection', '') && $test_connection === true) ? true : false,

- 'S_CONNECTION_FAILED' => (request_var('test_connection', '') && $test_connection !== true) ? true : false

- ));

- break;

-

- case 'submit_file':

- case 'download_file':

- case 'upload_data':

-

- if (!$submit || !check_form_key($form_name))

- {

- trigger_error($user->lang['FORM_INVALID']. adm_back_link($this->u_action), E_USER_WARNING);

- }

-

- if (!$lang_id || empty($_POST['entry']))

- {

- trigger_error($user->lang['NO_LANG_ID'] . adm_back_link($this->u_action), E_USER_WARNING);

- }

-

- if ($this->language_directory != 'email' && !is_array($_POST['entry']))

- {

- trigger_error($user->lang['NO_LANG_ID'] . adm_back_link($this->u_action), E_USER_WARNING);

- }

-

- if (!$this->language_file || (!$this->language_directory && !in_array($this->language_file, $this->main_files)))

- {

- trigger_error($user->lang['NO_FILE_SELECTED'] . adm_back_link($this->u_action), E_USER_WARNING);

- }

-

- $sql = 'SELECT *

- FROM ' . LANG_TABLE . "

- WHERE lang_id = $lang_id";

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

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

- $db->sql_freeresult($result);

-

- if (!$row)

- {

- trigger_error($user->lang['NO_LANG_ID'] . adm_back_link($this->u_action), E_USER_WARNING);

- }

-

- // Before we attempt to write anything let's check if the admin really chose a correct filename

- switch ($this->language_directory)

- {

- case 'email':

- // Get email templates

- $email_files = filelist($phpbb_root_path . 'language/' . $row['lang_iso'], 'email', 'txt');

- $email_files = $email_files['email/'];

-

- if (!in_array($this->language_file, $email_files))

- {

- trigger_error($user->lang['WRONG_LANGUAGE_FILE'] . adm_back_link($this->u_action . '&amp;action=details&amp;id=' . $lang_id), E_USER_WARNING);

- }

- break;

-

- case 'acp':

- // Get acp files

- $acp_files = filelist($phpbb_root_path . 'language/' . $row['lang_iso'], 'acp', $phpEx);

- $acp_files = $acp_files['acp/'];

-

- if (!in_array($this->language_file, $acp_files))

- {

- trigger_error($user->lang['WRONG_LANGUAGE_FILE'] . adm_back_link($this->u_action . '&amp;action=details&amp;id=' . $lang_id), E_USER_WARNING);

- }

- break;

-

- case 'mods':

- // Get mod files

- $mods_files = filelist($phpbb_root_path . 'language/' . $row['lang_iso'], 'mods', $phpEx);

- $mods_files = (isset($mods_files['mods/'])) ? $mods_files['mods/'] : array();

-

- if (!in_array($this->language_file, $mods_files))

- {

- trigger_error($user->lang['WRONG_LANGUAGE_FILE'] . adm_back_link($this->u_action . '&amp;action=details&amp;id=' . $lang_id), E_USER_WARNING);

- }

- break;

-

- default:

- if (!in_array($this->language_file, $this->main_files))

- {

- trigger_error($user->lang['WRONG_LANGUAGE_FILE'] . adm_back_link($this->u_action . '&amp;action=details&amp;id=' . $lang_id), E_USER_WARNING);

- }

- break;

- }

-

- if (!$safe_mode)

- {

- $mkdir_ary = array('language', 'language/' . $row['lang_iso']);

-

- if ($this->language_directory)

- {

- $mkdir_ary[] = 'language/' . $row['lang_iso'] . '/' . $this->language_directory;

- }

-

- foreach ($mkdir_ary as $dir)

- {

- $dir = $phpbb_root_path . 'store/' . $dir;

-

- if (!is_dir($dir))

- {

- if (!@mkdir($dir, 0777))

- {

- trigger_error("Could not create directory $dir", E_USER_ERROR);

- }

- @chmod($dir, 0777);

- }

- }

- }

-

- // Get target filename for storage folder

- $filename = $this->get_filename($row['lang_iso'], $this->language_directory, $this->language_file, true, true);

- $fp = @fopen($phpbb_root_path . $filename, 'wb');

-

- if (!$fp)

- {

- trigger_error(sprintf($user->lang['UNABLE_TO_WRITE_FILE'], $filename) . adm_back_link($this->u_action . '&amp;id=' . $lang_id . '&amp;action=details&amp;language_file=' . urlencode($selected_lang_file)), E_USER_WARNING);

- }

-

- if ($this->language_directory == 'email')

- {

- // Email Template

- $entry = $this->prepare_lang_entry($_POST['entry'], false);

- fwrite($fp, $entry);

- }

- else

- {

- $name = (($this->language_directory) ? $this->language_directory . '_' : '') . $this->language_file;

- $header = str_replace(array('{FILENAME}', '{LANG_NAME}', '{CHANGED}', '{AUTHOR}'), array($name, $row['lang_english_name'], date('Y-m-d', time()), $row['lang_author']), $this->language_file_header);

-

- if (strpos($this->language_file, 'help_') === 0)

- {

- // Help File

- $header .= '$help = array(' . "\n";

- fwrite($fp, $header);

-

- foreach ($_POST['entry'] as $key => $value)

- {

- if (!is_array($value))

- {

- continue;

- }

-

- $entry = "\tarray(\n";

-

- foreach ($value as $_key => $_value)

- {

- $entry .= "\t\t" . (int) $_key . "\t=> '" . $this->prepare_lang_entry($_value) . "',\n";

- }

-

- $entry .= "\t),\n";

- fwrite($fp, $entry);

- }

-

- $footer = ");\n\n?>";

- fwrite($fp, $footer);

- }

- else

- {

- // Language File

- $header .= $this->lang_header;

- fwrite($fp, $header);

-

- foreach ($_POST['entry'] as $key => $value)

- {

- $entry = $this->format_lang_array($key, $value);

- fwrite($fp, $entry);

- }

-

- $footer = "));\n\n?>";

- fwrite($fp, $footer);

- }

- }

-

- fclose($fp);

-

- if ($action == 'download_file')

- {

- header('Pragma: no-cache');

- header('Content-Type: application/octetstream; name="' . $this->language_file . '"');

- header('Content-disposition: attachment; filename=' . $this->language_file);

-

- $fp = @fopen($phpbb_root_path . $filename, 'rb');

- while ($buffer = fread($fp, 1024))

- {

- echo $buffer;

- }

- fclose($fp);

-

- add_log('admin', 'LOG_LANGUAGE_FILE_SUBMITTED', $this->language_file);

-

- exit;

- }

- else if ($action == 'upload_data')

- {

- $sql = 'SELECT lang_iso

- FROM ' . LANG_TABLE . "

- WHERE lang_id = $lang_id";

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

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

- $db->sql_freeresult($result);

-

- $file = request_var('file', '');

- $dir = request_var('dir', '');

-

- $selected_lang_file = $dir . '|' . $file;

-

- $old_file = '/' . $this->get_filename($row['lang_iso'], $dir, $file, false, true);

- $lang_path = 'language/' . $row['lang_iso'] . '/' . (($dir) ? $dir . '/' : '');

-

- include_once($phpbb_root_path . 'includes/functions_transfer.' . $phpEx);

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

-

- if ($method != 'ftp' && $method != 'ftp_fsock')

- {

- trigger_error($user->lang['INVALID_UPLOAD_METHOD'], E_USER_ERROR);

- }

-

- $transfer = new $method(request_var('host', ''), request_var('username', ''), request_var('password', ''), request_var('root_path', ''), request_var('port', ''), request_var('timeout', ''));

-

- if (($result = $transfer->open_session()) !== true)

- {

- trigger_error($user->lang[$result] . adm_back_link($this->u_action . '&amp;action=details&amp;id=' . $lang_id . '&amp;language_file=' . urlencode($selected_lang_file)), E_USER_WARNING);

- }

-

- $transfer->rename($lang_path . $file, $lang_path . $file . '.bak');

- $result = $transfer->copy_file('store/' . $lang_path . $file, $lang_path . $file);

-

- if ($result === false)

- {

- // If failed, try to rename again and print error out...

- $transfer->delete_file($lang_path . $file);

- $transfer->rename($lang_path . $file . '.bak', $lang_path . $file);

-

- trigger_error($user->lang['UPLOAD_FAILED'] . adm_back_link($this->u_action . '&amp;action=details&amp;id=' . $lang_id . '&amp;language_file=' . urlencode($selected_lang_file)), E_USER_WARNING);

- }

-

- $transfer->close_session();

-

- // Remove from storage folder

- if (file_exists($phpbb_root_path . 'store/' . $lang_path . $file))

- {

- @unlink($phpbb_root_path . 'store/' . $lang_path . $file);

- }

-

- add_log('admin', 'LOG_LANGUAGE_FILE_REPLACED', $file);

-

- trigger_error($user->lang['UPLOAD_COMPLETED'] . adm_back_link($this->u_action . '&amp;action=details&amp;id=' . $lang_id . '&amp;language_file=' . urlencode($selected_lang_file)));

- }

-

- add_log('admin', 'LOG_LANGUAGE_FILE_SUBMITTED', $this->language_file);

- $action = 'details';

-

- // no break;

-

- $lang_iso = $lang_entries['lang_iso'];

- $missing_vars = $missing_files = array();

-

- // Get email templates

- $email_files = filelist($phpbb_root_path . 'language/' . $config['default_lang'], 'email', 'txt');

- $email_files = $email_files['email/'];

-

- // Get acp files

- $acp_files = filelist($phpbb_root_path . 'language/' . $config['default_lang'], 'acp', $phpEx);

- $acp_files = $acp_files['acp/'];

-

- // Get mod files

- $mods_files = filelist($phpbb_root_path . 'language/' . $config['default_lang'], 'mods', $phpEx);

- $mods_files = (isset($mods_files['mods/'])) ? $mods_files['mods/'] : array();

-

- // Check if our current filename matches the files

- switch ($this->language_directory)

- case 'email':

- if (!in_array($this->language_file, $email_files))

- {

- trigger_error($user->lang['WRONG_LANGUAGE_FILE'] . adm_back_link($this->u_action . '&amp;action=details&amp;id=' . $lang_id), E_USER_WARNING);

- }

- break;

-

- case 'acp':

- if (!in_array($this->language_file, $acp_files))

- {

- trigger_error($user->lang['WRONG_LANGUAGE_FILE'] . adm_back_link($this->u_action . '&amp;action=details&amp;id=' . $lang_id), E_USER_WARNING);

- }

- break;

-

- case 'mods':

- if (!in_array($this->language_file, $mods_files))

- {

- trigger_error($user->lang['WRONG_LANGUAGE_FILE'] . adm_back_link($this->u_action . '&amp;action=details&amp;id=' . $lang_id), E_USER_WARNING);

- }

- break;

-

- default:

- if (!in_array($this->language_file, $this->main_files))

- {

- trigger_error($user->lang['WRONG_LANGUAGE_FILE'] . adm_back_link($this->u_action . '&amp;action=details&amp;id=' . $lang_id), E_USER_WARNING);

- }

- }

-

- if (isset($_POST['remove_store']))

- {

- $store_filename = $this->get_filename($lang_iso, $this->language_directory, $this->language_file, true, true);

-

- if (file_exists($phpbb_root_path . $store_filename))

- {

- @unlink($phpbb_root_path . $store_filename);

- }

- include_once($phpbb_root_path . 'includes/functions_transfer.' . $phpEx);

-

- $methods = transfer::methods();

-

- foreach ($methods as $method)

- {

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

- 'VALUE' => $method

- ));

- }

- 'LANG_ISO' => $lang_entries['lang_iso'],

- 'ALLOW_UPLOAD' => sizeof($methods)

- )

- );

- // If current lang is different from the default lang, then first try to grab missing/additional vars

- $is_missing_var = false;

-

- foreach ($this->main_files as $file)

- if (file_exists($phpbb_root_path . $this->get_filename($lang_iso, '', $file)))

- {

- $missing_vars[$file] = $this->compare_language_files($config['default_lang'], $lang_iso, '', $file);

-

- if (sizeof($missing_vars[$file]))

- {

- $is_missing_var = true;

- }

- }

- else

- {

- $missing_files[] = $this->get_filename($lang_iso, '', $file);

- }

-

- // Now go through acp/mods directories

- foreach ($acp_files as $file)

- if (file_exists($phpbb_root_path . $this->get_filename($lang_iso, 'acp', $file)))

- {

- $missing_vars['acp/' . $file] = $this->compare_language_files($config['default_lang'], $lang_iso, 'acp', $file);

-

- if (sizeof($missing_vars['acp/' . $file]))

- {

- $is_missing_var = true;

- }

- }

- else

- {

- $missing_files[] = $this->get_filename($lang_iso, 'acp', $file);

- }

- if (sizeof($mods_files))

- foreach ($mods_files as $file)

- if (file_exists($phpbb_root_path . $this->get_filename($lang_iso, 'mods', $file)))

- $missing_vars['mods/' . $file] = $this->compare_language_files($config['default_lang'], $lang_iso, 'mods', $file);

- if (sizeof($missing_vars['mods/' . $file]))

- $is_missing_var = true;

- else

- {

- $missing_files[] = $this->get_filename($lang_iso, 'mods', $file);

- }

- }

- }

-

- // More missing files... for example email templates?

- foreach ($email_files as $file)

- {

- if (!file_exists($phpbb_root_path . $this->get_filename($lang_iso, 'email', $file)))

- {

- $missing_files[] = $this->get_filename($lang_iso, 'email', $file);

- }

-

- if (sizeof($missing_files))

- {

- $template->assign_vars(array(

- 'S_MISSING_FILES' => true,

- 'L_MISSING_FILES' => sprintf($user->lang['THOSE_MISSING_LANG_FILES'], $lang_entries['lang_local_name']),

- 'MISSING_FILES' => implode('<br />', $missing_files))

- );

- }

-

- if ($is_missing_var)

- {

- $template->assign_vars(array(

- 'S_MISSING_VARS' => true,

- 'L_MISSING_VARS_EXPLAIN' => sprintf($user->lang['THOSE_MISSING_LANG_VARIABLES'], $lang_entries['lang_local_name']),

- 'U_MISSING_ACTION' => $this->u_action . "&amp;action=$action&amp;id=$lang_id")

- );

-

- foreach ($missing_vars as $file => $vars)

- {

- if (!sizeof($vars))

- {

- continue;

- }

-

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

- 'FILE' => $file,

- 'TPL' => $this->print_language_entries($vars, '', false),

- 'KEY' => (strpos($file, '/') === false) ? '|' . $file : str_replace('/', '|', $file))

- );

- }

- }

- }

-

- // Main language files

- $s_lang_options = '<option value="|common.' . $phpEx . '" class="sep">' . $user->lang['LANGUAGE_FILES'] . '</option>';

- foreach ($this->main_files as $file)

- {

- if (strpos($file, 'help_') === 0)

- {

- continue;

- }

-

- $prefix = (file_exists($phpbb_root_path . $this->get_filename($lang_iso, '', $file, true, true))) ? '* ' : '';

-

- $selected = (!$this->language_directory && $this->language_file == $file) ? ' selected="selected"' : '';

- $s_lang_options .= '<option value="|' . $file . '"' . $selected . '>' . $prefix . $file . '</option>';

- }

-

- // Help Files

- $s_lang_options .= '<option value="|common.' . $phpEx . '" class="sep">' . $user->lang['HELP_FILES'] . '</option>';

- foreach ($this->main_files as $file)

- {

- if (strpos($file, 'help_') !== 0)

- {

- continue;

- }

-

- $prefix = (file_exists($phpbb_root_path . $this->get_filename($lang_iso, '', $file, true, true))) ? '* ' : '';

-

- $selected = (!$this->language_directory && $this->language_file == $file) ? ' selected="selected"' : '';

- $s_lang_options .= '<option value="|' . $file . '"' . $selected . '>' . $prefix . $file . '</option>';

- }

-

- // Now every other language directory

- $check_files = array('email', 'acp', 'mods');

-

- foreach ($check_files as $check)

- {

- if (!sizeof(${$check . '_files'}))

- {

- continue;

- }

-

- $s_lang_options .= '<option value="|common.' . $phpEx . '" class="sep">' . $user->lang[strtoupper($check) . '_FILES'] . '</option>';

-

- foreach (${$check . '_files'} as $file)

- {

- $prefix = (file_exists($phpbb_root_path . $this->get_filename($lang_iso, $check, $file, true, true))) ? '* ' : '';

-

- $selected = ($this->language_directory == $check && $this->language_file == $file) ? ' selected="selected"' : '';

- $s_lang_options .= '<option value="' . $check . '|' . $file . '"' . $selected . '>' . $prefix . $file . '</option>';

- }

- }

-

- // Get Language Entries - if saved within store folder, we take this one (with the option to remove it)

- $lang = array();

-

- $is_email_file = ($this->language_directory == 'email') ? true : false;

- $is_help_file = (strpos($this->language_file, 'help_') === 0) ? true : false;

-

- $file_from_store = (file_exists($phpbb_root_path . $this->get_filename($lang_iso, $this->language_directory, $this->language_file, true, true))) ? true : false;

- $no_store_filename = $this->get_filename($lang_iso, $this->language_directory, $this->language_file);

-

- if (!$file_from_store && !file_exists($phpbb_root_path . $no_store_filename))

- {

- $print_message = sprintf($user->lang['MISSING_LANGUAGE_FILE'], $no_store_filename);

- }

- else

- {

- if ($is_email_file)

- {

- $lang = file_get_contents($phpbb_root_path . $this->get_filename($lang_iso, $this->language_directory, $this->language_file, $file_from_store));

- }

- else

- {

- $help = array();

- include($phpbb_root_path . $this->get_filename($lang_iso, $this->language_directory, $this->language_file, $file_from_store));

-

- if ($is_help_file)

- $lang = $help;

- unset($help);

-

- $print_message = (($this->language_directory) ? $this->language_directory . '/' : '') . $this->language_file;

- }

-

- // Normal language pack entries

- $template->assign_vars(array(

- 'U_ENTRY_ACTION' => $this->u_action . "&amp;action=details&amp;id=$lang_id#entries",

- 'S_EMAIL_FILE' => $is_email_file,

- 'S_FROM_STORE' => $file_from_store,

- 'S_LANG_OPTIONS' => $s_lang_options,

- 'PRINT_MESSAGE' => $print_message,

- )

- );

-

- if (!$is_email_file)

- {

- $tpl = '';

- $name = (($this->language_directory) ? $this->language_directory . '/' : '') . $this->language_file;

-

- if (isset($missing_vars[$name]) && sizeof($missing_vars[$name]))

- {

- $tpl .= $this->print_language_entries($missing_vars[$name], '* ');

- }

-

- $tpl .= $this->print_language_entries($lang);

-

- $template->assign_var('TPL', $tpl);

- unset($tpl);

- else

- {

- $template->assign_vars(array(

- 'LANG' => $lang)

- );

-

- unset($lang);

- }

-

-

- $sql = 'DELETE FROM ' . STYLES_IMAGESET_DATA_TABLE . " WHERE image_lang = '" . $db->sql_escape($row['lang_iso']) . "'";

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

-

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

-

- confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields($s_hidden_fields));

- $valid_localized = array(

- 'icon_back_top', 'icon_contact_aim', 'icon_contact_email', 'icon_contact_icq', 'icon_contact_jabber', 'icon_contact_msnm', 'icon_contact_pm', 'icon_contact_yahoo', 'icon_contact_www', 'icon_post_delete', 'icon_post_edit', 'icon_post_info', 'icon_post_quote', 'icon_post_report', 'icon_user_online', 'icon_user_offline', 'icon_user_profile', 'icon_user_search', 'icon_user_warn', 'button_pm_forward', 'button_pm_new', 'button_pm_reply', 'button_topic_locked', 'button_topic_new', 'button_topic_reply',

- );

-

- $sql_ary = array();

-

- $sql = 'SELECT *

- FROM ' . STYLES_IMAGESET_TABLE;

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

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

- {

- if (@file_exists("{$phpbb_root_path}styles/{$imageset_row['imageset_path']}/imageset/{$lang_pack['iso']}/imageset.cfg"))

- {

- $cfg_data_imageset_data = parse_cfg_file("{$phpbb_root_path}styles/{$imageset_row['imageset_path']}/imageset/{$lang_pack['iso']}/imageset.cfg");

- foreach ($cfg_data_imageset_data as $image_name => $value)

- {

- if (strpos($value, '*') !== false)

- {

- if (substr($value, -1, 1) === '*')

- {

- list($image_filename, $image_height) = explode('*', $value);

- $image_width = 0;

- }

- else

- {

- list($image_filename, $image_height, $image_width) = explode('*', $value);

- }

- }

- else

- {

- $image_filename = $value;

- $image_height = $image_width = 0;

- }

-

- if (strpos($image_name, 'img_') === 0 && $image_filename)

- {

- $image_name = substr($image_name, 4);

- if (in_array($image_name, $valid_localized))

- {

- $sql_ary[] = array(

- 'image_name' => (string) $image_name,

- 'image_filename' => (string) $image_filename,

- 'image_height' => (int) $image_height,

- 'image_width' => (int) $image_width,

- 'imageset_id' => (int) $imageset_row['imageset_id'],

- 'image_lang' => (string) $lang_pack['iso'],

- );

- }

- }

- }

- }

- }

- $db->sql_freeresult($result);

-

- if (sizeof($sql_ary))

- {

- $db->sql_multi_insert(STYLES_IMAGESET_DATA_TABLE, $sql_ary);

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

- }

-

-

- case 'download':

-

- if (!$lang_id)

- {

- trigger_error($user->lang['NO_LANG_ID'] . adm_back_link($this->u_action), E_USER_WARNING);

- }

-

- $sql = 'SELECT *

- FROM ' . LANG_TABLE . '

- WHERE lang_id = ' . $lang_id;

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

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

- $db->sql_freeresult($result);

-

- $use_method = request_var('use_method', '');

- $methods = array('.tar');

-

- $available_methods = array('.tar.gz' => 'zlib', '.tar.bz2' => 'bz2', '.zip' => 'zlib');

- foreach ($available_methods as $type => $module)

- {

- if (!@extension_loaded($module))

- {

- continue;

- }

-

- $methods[] = $type;

- }

-

- // Let the user decide in which format he wants to have the pack

- if (!$use_method)

- {

- $this->page_title = 'SELECT_DOWNLOAD_FORMAT';

-

- $radio_buttons = '';

- foreach ($methods as $method)

- {

- $radio_buttons .= '<label><input type="radio"' . ((!$radio_buttons) ? ' id="use_method"' : '') . ' class="radio" value="' . $method . '" name="use_method" /> ' . $method . '</label>';

- }

-

- $template->assign_vars(array(

- 'S_SELECT_METHOD' => true,

- 'U_BACK' => $this->u_action,

- 'U_ACTION' => $this->u_action . "&amp;action=$action&amp;id=$lang_id",

- 'RADIO_BUTTONS' => $radio_buttons)

- );

-

- return;

- }

-

- if (!in_array($use_method, $methods))

- {

- $use_method = '.tar';

- }

-

- include_once($phpbb_root_path . 'includes/functions_compress.' . $phpEx);

-

- if ($use_method == '.zip')

- {

- $compress = new compress_zip('w', $phpbb_root_path . 'store/lang_' . $row['lang_iso'] . $use_method);

- }

- else

- {

- $compress = new compress_tar('w', $phpbb_root_path . 'store/lang_' . $row['lang_iso'] . $use_method, $use_method);

- }

-

- // Get email templates

- $email_templates = filelist($phpbb_root_path . 'language/' . $row['lang_iso'], 'email', 'txt');

- $email_templates = $email_templates['email/'];

-

- // Get acp files

- $acp_files = filelist($phpbb_root_path . 'language/' . $row['lang_iso'], 'acp', $phpEx);

- $acp_files = $acp_files['acp/'];

-

- // Get mod files

- $mod_files = filelist($phpbb_root_path . 'language/' . $row['lang_iso'], 'mods', $phpEx);

- $mod_files = (isset($mod_files['mods/'])) ? $mod_files['mods/'] : array();

-

- // Add main files

- $this->add_to_archive($compress, $this->main_files, $row['lang_iso']);

-

- // Add search files if they exist...

- if (file_exists($phpbb_root_path . 'language/' . $row['lang_iso'] . '/search_ignore_words.' . $phpEx))

- {

- $this->add_to_archive($compress, array("search_ignore_words.$phpEx"), $row['lang_iso']);

- }

-

- if (file_exists($phpbb_root_path . 'language/' . $row['lang_iso'] . '/search_synonyms.' . $phpEx))

- {

- $this->add_to_archive($compress, array("search_synonyms.$phpEx"), $row['lang_iso']);

- }

-

- // Write files in folders

- $this->add_to_archive($compress, $email_templates, $row['lang_iso'], 'email');

- $this->add_to_archive($compress, $acp_files, $row['lang_iso'], 'acp');

- $this->add_to_archive($compress, $mod_files, $row['lang_iso'], 'mods');

-

- // Write ISO File

- $iso_src = htmlspecialchars_decode($row['lang_english_name']) . "\n";

- $iso_src .= htmlspecialchars_decode($row['lang_local_name']) . "\n";

- $iso_src .= htmlspecialchars_decode($row['lang_author']);

- $compress->add_data($iso_src, 'language/' . $row['lang_iso'] . '/iso.txt');

-

- // index.htm files

- $compress->add_data('', 'language/' . $row['lang_iso'] . '/index.htm');

- $compress->add_data('', 'language/' . $row['lang_iso'] . '/email/index.htm');

- $compress->add_data('', 'language/' . $row['lang_iso'] . '/acp/index.htm');

-

- if (sizeof($mod_files))

- {

- $compress->add_data('', 'language/' . $row['lang_iso'] . '/mods/index.htm');

- }

-

- $compress->close();

-

- $compress->download('lang_' . $row['lang_iso']);

- @unlink($phpbb_root_path . 'store/lang_' . $row['lang_iso'] . $use_method);

-

- exit;

-

- break;

-

- /**

- * Set default language variables/header

- */

- function default_variables()

- {

- global $phpEx;

-

- $this->language_file_header = '<?php

-/**

-*

-* {FILENAME} [{LANG_NAME}]

-*

-* @package language

-* @version $' . 'Id: ' . '$

-* @copyright (c) ' . date('Y') . ' phpBB Group

-* @author {CHANGED} - {AUTHOR}

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-*

-*/

-

-/**

-* DO NOT CHANGE

-*/

-if (!defined(\'IN_PHPBB\'))

-{

- exit;

-}

-

-if (empty($lang) || !is_array($lang))

-{

- $lang = array();

-}

-

-// DEVELOPERS PLEASE NOTE

-//

-// All language files should use UTF-8 as their encoding and the files must not contain a BOM.

-//

-// Placeholders can now contain order information, e.g. instead of

-// \'Page %s of %s\' you can (and should) write \'Page %1$s of %2$s\', this allows

-// translators to re-order the output of data while ensuring it remains correct

-//

-// You do not need this where single placeholders are used, e.g. \'Message %d\' is fine

-// equally where a string contains only two placeholders which are used to wrap text

-// in a url you again do not need to specify an order e.g., \'Click %sHERE%s\' is fine

-';

-

- $this->lang_header = '

-$lang = array_merge($lang, array(

-';

-

- // Language files in language root directory

- $this->main_files = array("captcha_qa.$phpEx", "captcha_recaptcha.$phpEx", "common.$phpEx", "groups.$phpEx", "install.$phpEx", "mcp.$phpEx", "memberlist.$phpEx", "posting.$phpEx", "search.$phpEx", "ucp.$phpEx", "viewforum.$phpEx", "viewtopic.$phpEx", "help_bbcode.$phpEx", "help_faq.$phpEx");

- }

-

- * Get filename/location of language file

- */

- function get_filename($lang_iso, $directory, $filename, $check_store = false, $only_return_filename = false)

- {

- global $phpbb_root_path, $safe_mode;

-

- $check_filename = "language/$lang_iso/" . (($directory) ? $directory . '/' : '') . $filename;

-

- if ($check_store)

- {

- $check_store_filename = ($safe_mode) ? "store/langfile_{$lang_iso}" . (($directory) ? '_' . $directory : '') . "_{$filename}" : "store/language/$lang_iso/" . (($directory) ? $directory . '/' : '') . $filename;

-

- if (!$only_return_filename && file_exists($phpbb_root_path . $check_store_filename))

- {

- return $check_store_filename;

- }

- else if ($only_return_filename)

- {

- return $check_store_filename;

- }

- }

-

- return $check_filename;

- }

-

- /**

- * Add files to archive

- function add_to_archive(&$compress, $filelist, $lang_iso, $directory = '')

- foreach ($filelist as $file)

- {

- // Get source filename

- $source = $this->get_filename($lang_iso, $directory, $file, true);

- $destination = 'language/' . $lang_iso . '/' . (($directory) ? $directory . '/' : '') . $file;

-

- // Add file to archive

- $compress->add_custom_file($phpbb_root_path . $source, $destination);

- }

- }

-

- /**

- * Little helper to add some hardcoded template bits

- */

- function add_input_field()

- {

- $keys = func_get_args();

-

- $non_static = array_shift($keys);

- $value = utf8_normalize_nfc(array_shift($keys));

- if (!$non_static)

- return '<strong>' . htmlspecialchars($value, ENT_COMPAT, 'UTF-8') . '</strong>';

- }

-

- // If more then 270 characters, then we present a textarea, else an input field

- $textarea = (utf8_strlen($value) > 270) ? true : false;

- $tpl = '';

-

- $tpl .= ($textarea) ? '<textarea name="' : '<input type="text" name="';

- $tpl .= 'entry[' . implode('][', array_map('utf8_htmlspecialchars', $keys)) . ']"';

-

- $tpl .= ($textarea) ? ' cols="80" rows="5" class="langvalue">' : ' class="langvalue" value="';

- $tpl .= htmlspecialchars($value, ENT_COMPAT, 'UTF-8');

- $tpl .= ($textarea) ? '</textarea>' : '" />';

-

- return $tpl;

- }

-

- /**

- * Print language entries

- */

- function print_language_entries(&$lang_ary, $key_prefix = '', $input_field = true)

- {

- $tpl = '';

-

- foreach ($lang_ary as $key => $value)

- {

- if (is_array($value))

- {

- // Write key

- $tpl .= '

- <tr>

- <td class="row3" colspan="2">' . htmlspecialchars($key_prefix, ENT_COMPAT, 'UTF-8') . '<strong>' . htmlspecialchars($key, ENT_COMPAT, 'UTF-8') . '</strong></td>

- </tr>';

-

- foreach ($value as $_key => $_value)

- {

- if (is_array($_value))

- {

- // Write key

- $tpl .= '

- <tr>

- <td class="row3" colspan="2">' . htmlspecialchars($key_prefix, ENT_COMPAT, 'UTF-8') . '&nbsp; &nbsp;<strong>' . htmlspecialchars($_key, ENT_COMPAT, 'UTF-8') . '</strong></td>

- </tr>';

-

- foreach ($_value as $__key => $__value)

- {

- // Write key

- $tpl .= '

- <tr>

- <td class="row1" style="white-space: nowrap;">' . htmlspecialchars($key_prefix, ENT_COMPAT, 'UTF-8') . '<strong>' . htmlspecialchars($__key, ENT_COMPAT, 'UTF-8') . '</strong></td>

- <td class="row2">';

-

- $tpl .= $this->add_input_field($input_field, $__value, $key, $_key, $__key);

-

- $tpl .= '</td>

- </tr>';

- }

- }

- else

- {

- // Write key

- $tpl .= '

- <tr>

- <td class="row1" style="white-space: nowrap;">' . htmlspecialchars($key_prefix, ENT_COMPAT, 'UTF-8') . '<strong>' . htmlspecialchars($_key, ENT_COMPAT, 'UTF-8') . '</strong></td>

- <td class="row2">';

-

- $tpl .= $this->add_input_field($input_field, $_value, $key, $_key);

-

- $tpl .= '</td>

- </tr>';

- }

- }

-

- $tpl .= '

- <tr>

- <td class="spacer" colspan="2">&nbsp;</td>

- </tr>';

- }

- else

- {

- // Write key

- $tpl .= '

- <tr>

- <td class="row1" style="white-space: nowrap;">' . htmlspecialchars($key_prefix, ENT_COMPAT, 'UTF-8') . '<strong>' . htmlspecialchars($key, ENT_COMPAT, 'UTF-8') . '</strong></td>

- <td class="row2">';

-

- $tpl .= $this->add_input_field($input_field, $value, $key);

-

- $tpl .= '</td>

- </tr>';

- }

- return $tpl;

- }

-

- /**

- * Compare two language files

- */

- function compare_language_files($source_lang, $dest_lang, $directory, $file)

- {

- global $phpbb_root_path, $phpEx;

-

- $return_ary = array();

-

- include("{$phpbb_root_path}language/{$source_lang}/" . (($directory) ? $directory . '/' : '') . $file);

-

- if (!file_exists($phpbb_root_path . $this->get_filename($dest_lang, $directory, $file, true)))

- {

- return array();

- }

-

- include($phpbb_root_path . $this->get_filename($dest_lang, $directory, $file, true));

-

- $diff_array_keys = array_diff(array_keys($lang_entry_src), array_keys($lang_entry_dst));

- unset($lang_entry_dst);

-

- foreach ($diff_array_keys as $key)

- {

- $return_ary[$key] = $lang_entry_src[$key];

- }

-

- unset($lang_entry_src);

-

- return $return_ary;

- }

-

- /**

- * Return language string value for storage

- */

- function prepare_lang_entry($text, $store = true)

- {

- $text = (STRIP) ? stripslashes($text) : $text;

-

- // Adjust for storage...

- if ($store)

- {

- $text = str_replace("'", "\\'", str_replace('\\', '\\\\', $text));

- }

-

- return $text;

- }

-

- /**

- * Format language array for storage

- */

- function format_lang_array($key, $value, $tabs = "\t")

- {

- $entry = '';

-

- if (!is_array($value))

- {

- $entry .= "{$tabs}'" . $this->prepare_lang_entry($key) . "'\t=> '" . $this->prepare_lang_entry($value) . "',\n";

- }

- else

- {

- $_tabs = $tabs . "\t";

- $entry .= "\n{$tabs}'" . $this->prepare_lang_entry($key) . "'\t=> array(\n";

-

- foreach ($value as $_key => $_value)

- {

- $entry .= $this->format_lang_array($_key, $_value, $_tabs);

- }

-

- $entry .= "{$tabs}),\n\n";

- }

-

- return $entry;

-

-?> \ No newline at end of file

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-/**

-* @package acp

-*/

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

- $deletemark = (!empty($_POST['delmarked'])) ? true : false;

- $deleteall = (!empty($_POST['delall'])) ? true : false;

- $where_sql = '';

- $sql_in = array();

- foreach ($marked as $mark)

- {

- $sql_in[] = $mark;

- }

- $where_sql = ' AND ' . $db->sql_in_set('log_id', $sql_in);

- unset($sql_in);

- if ($where_sql || $deleteall)

- $sql = 'DELETE FROM ' . LOG_TABLE . "

- WHERE log_type = {$this->log_type}

- $where_sql";

- $db->sql_query($sql);

- add_log('admin', 'LOG_CLEAR_' . strtoupper($mode));

-

- 'S_ON_PAGE' => on_page($log_count, $config['topics_per_page'], $start),

- 'PAGINATION' => generate_pagination($this->u_action . "&amp;$u_sort_param$keywords_param", $log_count, $config['topics_per_page'], $start, true),

-

-

-

-?> \ No newline at end of file

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-/**

-* @package acp

-*/

- global $config, $db, $user, $auth, $template;

- global $phpbb_root_path, $phpbb_admin_path, $phpEx;

- $perm_from = '<strong' . (($user_row['user_colour']) ? ' style="color: #' . $user_row['user_colour'] . '">' : '>');

- $perm_from .= ($user_row['user_id'] != ANONYMOUS) ? '<a href="' . append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&amp;u=' . $user_row['user_id']) . '">' : '';

- $perm_from .= $user_row['username'];

- $perm_from .= ($user_row['user_id'] != ANONYMOUS) ? '</a>' : '';

- $perm_from .= '</strong>';

- $redirect_url = append_sid("{$phpbb_root_path}index.$phpEx");

- meta_refresh(3, $redirect_url);

- trigger_error($user->lang['ADM_LOGGED_OUT'] . '<br /><br />' . sprintf($user->lang['RETURN_INDEX'], '<a href="' . $redirect_url . '">', '</a>'));

- WHERE post_approved = 1';

- WHERE topic_approved = 1';

- AND post_postcount = 1 AND post_approved = 1

- switch ($db->sql_layer)

- case 'firebird':