-* @version $Id$

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

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

- $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

-* @version $Id$

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

- $this->display_ban_options($mode);

- function display_ban_options($mode)

-

-?> \ No newline at end of file

-* @version $Id$

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

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

- // 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

-* @version $Id$

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

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

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

- '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' => 'rwpath', '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']),

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

- 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);

- }

- 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

-* @version $Id$

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

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

-

-?> \ No newline at end of file

-* @version $Id$

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

- $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);

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

-

-?> \ No newline at end of file

-* @version $Id$

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

- if (!class_exists('phpbb_db_tools'))

- {

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

- }

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

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

- 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];

- }

- }

-

-

-

- }

-

-

-?> \ No newline at end of file

-* @version $Id$

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

-

-?> \ No newline at end of file

-* @version $Id$

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

-

-?> \ No newline at end of file

-* @version $Id$

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

- 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;

- 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';

- WHERE post_approved = 1';

- WHERE topic_approved = 1';

-

-?> \ No newline at end of file

-* @version $Id$

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

- $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";

- $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,

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

-}

-?>

-* @version $Id$

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

- 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);

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

- $template->assign_var('PAGINATION',

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

- );

-

-?> \ No newline at end of file

-* @version $Id$

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

- $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

-* @version $Id$

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

-

-?> \ No newline at end of file

-* @version $Id$

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

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

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

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

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

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

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

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

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

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

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

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

- else

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

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

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

- $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);

-

- $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);

- }

-

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

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

-

-?> \ No newline at end of file

-* @version $Id$

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

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

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

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

-* @version $Id$

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

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

- $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

- break;

- case 'purge_cache':

- if ((int) $user->data['user_type'] !== USER_FOUNDER)

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

- cache_moderators();

-

-?> \ No newline at end of file

-* @version $Id$

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

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

-

-

-

-

-

-

- $s_name_options .= '<option value="' . $option . '"' . (($option == $module_data['module_basename']) ? ' selected="selected"' : '') . '>' . $this->lang_name($values['title']) . ' [' . $this->module_class . '_' . $option . ']</option>';

-

-

-

- $s_install_options .= '<optgroup label="' . $this->lang_name($values['title']) . ' [' . $this->module_class . '_' . $option . ']">';

-

-

- function get_module_infos($module = '', $module_class = false)

- global $phpbb_root_path, $phpEx;

-

- if (!$module)

- {

- $dh = @opendir($directory);

- if (!$dh)

- return $fileinfo;

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

- {

- // Is module?

- if (preg_match('/^' . $module_class . '_.+\.' . $phpEx . '$/', $file))

- {

- $class = str_replace(".$phpEx", '', $file) . '_info';

- if (!class_exists($class))

- {

- include($directory . $file);

- }

- // Get module title tag

- if (class_exists($class))

- {

- $c_class = new $class();

- $module_info = $c_class->module();

- $fileinfo[str_replace($module_class . '_', '', $module_info['filename'])] = $module_info;

- }

- }

- closedir($dh);

-

- ksort($fileinfo);

- }

- else

- {

- $filename = $module_class . '_' . basename($module);

- $class = $module_class . '_' . basename($module) . '_info';

-

- if (!class_exists($class))

- include($directory . $filename . '.' . $phpEx);

- // Get module title tag

- if (class_exists($class))

- $c_class = new $class();

- $module_info = $c_class->module();

- $fileinfo[str_replace($module_class . '_', '', $module_info['filename'])] = $module_info;

-

- global $cache;

-

- $cache->destroy('_modules_' . $p_class);

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

-

-?> \ No newline at end of file

-* @version $Id$

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

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

- $auth_admin = new auth_admin();

- $auth_admin->acl_set_role($role_id, $auth_settings);

- 'L_ACL_TYPE' => $user->lang['ACL_TYPE_' . strtoupper($permission_type)],

- )

- );

- $hold_ary = $auth_admin->get_role_mask($role_id);

- $auth_admin->display_role_mask($hold_ary);

- $hold_ary = $auth_admin->get_role_mask($display_item);

- $auth_admin->display_role_mask($hold_ary);

- global $template, $user;

- auth_admin::build_permission_array($auth_options, $content_array, $categories, $key_sort_array);

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

- 'PERMISSION' => $user->lang['acl_' . $permission]['lang'])

- );

- $auth_admin = new auth_admin();

-

- $hold_ary = $auth_admin->get_role_mask($role_id);

- $auth_admin->acl_set('user', $forum_id, $forum_ary['users'], $auth_settings, 0, false);

- $auth_admin->acl_set('group', $forum_id, $forum_ary['groups'], $auth_settings, 0, false);

- $auth_admin->acl_clear_prefetch();

-

-?> \ No newline at end of file

-* @version $Id$

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

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

- $this->page_title = sprintf($user->lang['TRACE_PERMISSION'], $user->lang['acl_' . $permission]['lang']);

- 'FORUM_NAMES' => implode(', ', $forum_names))

- 'L_PERMISSION_TYPE' => $user->lang['ACL_TYPE_' . strtoupper($permission_type)],

- global $user, $auth;

- $l_setting = (isset($user->lang['permission_type'][$permission_scope][$setting])) ? $user->lang['permission_type'][$permission_scope][$setting] : $user->lang['permission_type'][$setting];

- global $user, $auth;

- if (empty($_POST['setting']) || empty($_POST['setting'][$ug_id]) || empty($_POST['setting'][$ug_id][$forum_id]) || !is_array($_POST['setting'][$ug_id][$forum_id]))

- // We obtain and check $_POST['setting'][$ug_id][$forum_id] directly and not using request_var() because request_var()

- // currently does not support the amount of dimensions required. ;)

- // $auth_settings = request_var('setting', array(0 => array(0 => array('' => 0))));

- $auth_settings = array_map('intval', $_POST['setting'][$ug_id][$forum_id]);

- $assigned_role = (isset($_POST['role'][$ug_id][$forum_id])) ? (int) $_POST['role'][$ug_id][$forum_id] : 0;

- cache_moderators();

- update_foes($group_id, $user_id);

- global $user, $auth;

- $auth_settings = (isset($_POST['setting'])) ? $_POST['setting'] : array();

- $auth_roles = (isset($_POST['role'])) ? $_POST['role'] : array();

- cache_moderators();

- update_foes($group_id, $user_id);

- global $user, $db, $auth;

- cache_moderators();

- $sql = 'SELECT user_id, username, user_permissions, user_type

- FROM ' . USERS_TABLE . '

- WHERE user_id = ' . $user_id;

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

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

- $db->sql_freeresult($result);

- 'PERMISSION' => $user->lang['acl_' . $permission]['lang'],

- $auth2 = new auth();

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

- cache_moderators();

-

-?> \ No newline at end of file

-* @version $Id$

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

-

-?> \ No newline at end of file

-* @version $Id$

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

- 1 => array('field_ident', 'lang_name', 'lang_explain', 'field_option_none', 'field_show_on_reg', 'field_show_on_vt', 'field_required', 'field_show_novalue', 'field_hide', 'field_show_profile', 'field_no_view'),

- $var = $_POST['field_default_value'] = 'now';

- $var = $_POST['field_default_value'] = sprintf('%2d-%2d-%4d', $cp->vars['field_default_value_day'], $cp->vars['field_default_value_month'], $cp->vars['field_default_value_year']);

- $_new_key_ary[$key] = (is_array($_REQUEST[$key])) ? utf8_normalize_nfc(request_var($key, array(''), true)) : utf8_normalize_nfc(request_var($key, '', true));

-

-?>

-* @version $Id$

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

- $this->get_prune_users($user_ids, $usernames);

- foreach ($user_ids as $user_id)

- {

- user_delete('remove', $user_id);

- }

- foreach ($user_ids as $user_id)

- {

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

- }

- 'users' => utf8_normalize_nfc(request_var('users', '', true)),

- 'username' => utf8_normalize_nfc(request_var('username', '', true)),

- 'email' => request_var('email', ''),

- 'joined_select' => request_var('joined_select', ''),

- 'joined' => request_var('joined', ''),

- 'active_select' => request_var('active_select', ''),

- 'active' => request_var('active', ''),

- 'count_select' => request_var('count_select', ''),

- 'count' => request_var('count', ''),

-

- $s_find_join_time = '';

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

- {

- $s_find_join_time .= '<option value="' . $key . '">' . $value . '</option>';

- }

-

- 'S_JOINED_OPTIONS' => $s_find_join_time,

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

-

- if ($users)

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

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

- $joined_select = request_var('joined_select', 'lt');

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

- $joined = ($joined) ? explode('-', $joined) : array();

- if ((sizeof($active) && sizeof($active) != 3) || (sizeof($joined) && sizeof($joined) != 3))

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

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

- $where_sql .= (sizeof($joined)) ? " AND user_regdate " . $key_match[$joined_select] . ' ' . gmmktime(0, 0, 0, (int) $joined[1], (int) $joined[2], (int) $joined[0]) : '';

- $where_sql .= ($count !== '') ? " AND user_posts " . $key_match[$count_select] . ' ' . (int) $count . ' ' : '';

- $where_sql = '';

-

-?> \ No newline at end of file

-* @version $Id$

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

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

-

-

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

-

-

- );

-

-?> \ No newline at end of file

-* @version $Id$

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

-

-

- 'S_AVAILABLE_TITLES' => implode(', ', array_map('htmlspecialchars', array_keys($user->lang['report_reasons']['TITLE']))),

-

-

-?> \ No newline at end of file

-* @version $Id$

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

- $name = ucfirst(strtolower(str_replace('_', ' ', $type)));

- if (isset($_REQUEST['action']) && is_array($_REQUEST['action']))

- {

- $action = request_var('action', array('' => false));

- $action = key($action);

- }

- else

- {

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

- }

- $name = ucfirst(strtolower(str_replace('_', ' ', $this->state[0])));

- trigger_error(sprintf($user->lang['SEARCH_INDEX_DELETE_REDIRECT'], $post_counter, $row_count, $rows_per_second));

- // Indexing enabled for this forum or global announcement?

- // Global announcements get indexed by default.

- if (!$row['forum_id'] || (isset($forums[$row['forum_id']]) && $forums[$row['forum_id']]))

- trigger_error(sprintf($user->lang['SEARCH_INDEX_CREATE_REDIRECT'], $post_counter, $row_count, $rows_per_second));

- $name = ucfirst(strtolower(str_replace('_', ' ', $type)));

- global $phpbb_root_path, $phpEx;

-

- $search_types = array();

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

- if ($dp)

- {

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

- {

- if ((preg_match('#\.' . $phpEx . '$#', $file)) && ($file != "search.$phpEx"))

- {

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

- }

- }

- closedir($dp);

-

- sort($search_types);

- }

-

- return $search_types;

- global $phpbb_root_path, $phpEx, $user;

-

- if (!preg_match('#^\w+$#', $type) || !file_exists("{$phpbb_root_path}includes/search/$type.$phpEx"))

- {

- $error = $user->lang['NO_SUCH_SEARCH_MODULE'];

- return $error;

- }

- include_once("{$phpbb_root_path}includes/search/$type.$phpEx");

-

- if (!class_exists($type))

- $search = new $type($error);

-

-?> \ No newline at end of file

-* @version $Id$

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

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

-

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

-

-?> \ No newline at end of file

-* @version $Id$

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

- var $u_action;

-

- var $style_cfg;

- var $template_cfg;

- var $theme_cfg;

- var $imageset_cfg;

- var $imageset_keys;

-

- function main($id, $mode)

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

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

-

- // Hardcoded template bitfield to add for new templates

- $bitfield = new bitfield();

- $bitfield->set(0);

- $bitfield->set(1);

- $bitfield->set(2);

- $bitfield->set(3);

- $bitfield->set(4);

- $bitfield->set(8);

- $bitfield->set(9);

- $bitfield->set(11);

- $bitfield->set(12);

- define('TEMPLATE_BITFIELD', $bitfield->get_base64());

- unset($bitfield);

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

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

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

- $style_id = request_var('id', 0);

-

- // Fill the configuration variables

- $this->style_cfg = $this->template_cfg = $this->theme_cfg = $this->imageset_cfg = '

-#

-# phpBB {MODE} configuration file

-#

-# @package phpBB3

-# @copyright (c) 2005 phpBB Group

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

-#

-#

-# At the left is the name, please do not change this

-# At the right the value is entered

-# For on/off options the valid values are on, off, 1, 0, true and false

-#

-# Values get trimmed, if you want to add a space in front or at the end of

-# the value, then enclose the value with single or double quotes.

-# Single and double quotes do not need to be escaped.

-#

-#

-

-# General Information about this {MODE}

-name = {NAME}

-copyright = {COPYRIGHT}

-version = {VERSION}

-';

-

- $this->theme_cfg .= '

-# Some configuration options

-

-#

-# You have to turn this option on if you want to use the

-# path template variables ({T_IMAGESET_PATH} for example) within

-# your css file.

-# This is mostly the case if you want to use language specific

-# images within your css file.

-#

-parse_css_file = {PARSE_CSS_FILE}

-';

-

- $this->template_cfg .= '

-# Some configuration options

-

-# Template inheritance

-# See http://blog.phpbb.com/2008/07/31/templating-just-got-easier/

-# Set value to empty or this template name to ignore template inheritance.

-inherit_from = {INHERIT_FROM}

-';

-

- $this->imageset_keys = array(

- 'logos' => array(

- 'site_logo',

- ),

- 'buttons' => 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',

- ),

- 'icons' => array(

- 'icon_post_target', 'icon_post_target_unread', 'icon_topic_attach', 'icon_topic_latest', 'icon_topic_newest', 'icon_topic_reported', 'icon_topic_unapproved', 'icon_friend', 'icon_foe',

- ),

- 'forums' => array(

- 'forum_link', 'forum_read', 'forum_read_locked', 'forum_read_subforum', 'forum_unread', 'forum_unread_locked', 'forum_unread_subforum', 'subforum_read', 'subforum_unread'

- ),

- 'folders' => array(

- 'topic_moved', 'topic_read', 'topic_read_mine', 'topic_read_hot', 'topic_read_hot_mine', 'topic_read_locked', 'topic_read_locked_mine', 'topic_unread', 'topic_unread_mine', 'topic_unread_hot', 'topic_unread_hot_mine', 'topic_unread_locked', 'topic_unread_locked_mine', 'sticky_read', 'sticky_read_mine', 'sticky_read_locked', 'sticky_read_locked_mine', 'sticky_unread', 'sticky_unread_mine', 'sticky_unread_locked', 'sticky_unread_locked_mine', 'announce_read', 'announce_read_mine', 'announce_read_locked', 'announce_read_locked_mine', 'announce_unread', 'announce_unread_mine', 'announce_unread_locked', 'announce_unread_locked_mine', 'global_read', 'global_read_mine', 'global_read_locked', 'global_read_locked_mine', 'global_unread', 'global_unread_mine', 'global_unread_locked', 'global_unread_locked_mine', 'pm_read', 'pm_unread',

- ),

- 'polls' => array(

- 'poll_left', 'poll_center', 'poll_right',

- ),

- 'ui' => array(

- 'upload_bar',

- ),

- 'user' => array(

- 'user_icon1', 'user_icon2', 'user_icon3', 'user_icon4', 'user_icon5', 'user_icon6', 'user_icon7', 'user_icon8', 'user_icon9', 'user_icon10',

- ),

- );

-

- // Execute overall actions

- switch ($action)

- {

- case 'delete':

- if ($style_id)

- {

- $this->remove($mode, $style_id);

- return;

- }

- break;

-

- case 'export':

- if ($style_id)

- {

- $this->export($mode, $style_id);

- return;

- }

- break;

-

- case 'install':

- $this->install($mode);

- return;

- break;

-

- case 'add':

- $this->add($mode);

- return;

- break;

-

- case 'details':

- if ($style_id)

- {

- $this->details($mode, $style_id);

- return;

- }

- break;

-

- case 'edit':

- if ($style_id)

- {

- switch ($mode)

- {

- case 'imageset':

- return $this->edit_imageset($style_id);

- case 'template':

- return $this->edit_template($style_id);

- case 'theme':

- return $this->edit_theme($style_id);

- }

- }

- break;

-

- case 'cache':

- if ($style_id)

- {

- switch ($mode)

- {

- case 'template':

- return $this->template_cache($style_id);

- }

- }

- break;

- }

-

- switch ($mode)

- {

- case 'style':

-

- switch ($action)

- {

- case 'activate':

- case 'deactivate':

-

- if ($style_id == $config['default_style'])

- {

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

- }

-

- if (($action == 'deactivate' && confirm_box(true)) || $action == 'activate')

- {

- $sql = 'UPDATE ' . STYLES_TABLE . '

- SET style_active = ' . (($action == 'activate') ? 1 : 0) . '

- WHERE style_id = ' . $style_id;

- $db->sql_query($sql);

-

- // Set style to default for any member using deactivated style

- if ($action == 'deactivate')

- {

- $sql = 'UPDATE ' . USERS_TABLE . '

- SET user_style = ' . $config['default_style'] . "

- WHERE user_style = $style_id";

- $db->sql_query($sql);

-

- $sql = 'UPDATE ' . FORUMS_TABLE . '

- SET forum_style = 0

- WHERE forum_style = ' . $style_id;

- $db->sql_query($sql);

- }

- }

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

- {

- $s_hidden_fields = array(

- 'i' => $id,

- 'mode' => $mode,

- 'action' => $action,

- 'style_id' => $style_id,

- );

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

- }

- break;

- }

-

- $this->frontend('style', array('details'), array('export', 'delete'));

- break;

-

- case 'template':

-

- switch ($action)

- {

- // Refresh template data stored in db and clear cache

- case 'refresh':

-

- $sql = 'SELECT *

- FROM ' . STYLES_TEMPLATE_TABLE . "

- WHERE template_id = $style_id";

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

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

- $db->sql_freeresult($result);

-

- if (!$template_row)

- {

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

- }

-

- if (confirm_box(true))

- {

- $template_refreshed = '';

-

- // Only refresh database if the template is stored in the database

- if ($template_row['template_storedb'] && file_exists("{$phpbb_root_path}styles/{$template_row['template_path']}/template/"))

- {

- $filelist = array('' => array());

-

- $sql = 'SELECT template_filename, template_mtime

- FROM ' . STYLES_TEMPLATE_DATA_TABLE . "

- WHERE template_id = $style_id";

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

-

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

- {

-// if (@filemtime("{$phpbb_root_path}styles/{$template_row['template_path']}/template/" . $row['template_filename']) > $row['template_mtime'])

-// {

- // get folder info from the filename

- if (($slash_pos = strrpos($row['template_filename'], '/')) === false)

- {

- $filelist[''][] = $row['template_filename'];

- }

- else

- {

- $filelist[substr($row['template_filename'], 0, $slash_pos + 1)][] = substr($row['template_filename'], $slash_pos + 1, strlen($row['template_filename']) - $slash_pos - 1);

- }

-// }

- }

- $db->sql_freeresult($result);

-

- $this->store_templates('update', $style_id, $template_row['template_path'], $filelist);

- unset($filelist);

-

- $template_refreshed = $user->lang['TEMPLATE_REFRESHED'] . '<br />';

- add_log('admin', 'LOG_TEMPLATE_REFRESHED', $template_row['template_name']);

- }

-

- $this->clear_template_cache($template_row);

-

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

- }

- else

- {

- confirm_box(false, ($template_row['template_storedb']) ? $user->lang['CONFIRM_TEMPLATE_REFRESH'] : $user->lang['CONFIRM_TEMPLATE_CLEAR_CACHE'], build_hidden_fields(array(

- 'i' => $id,

- 'mode' => $mode,

- 'action' => $action,

- 'id' => $style_id

- )));

- }

-

- break;

- }

-

- $this->frontend('template', array('edit', 'cache', 'details'), array('refresh', 'export', 'delete'));

- break;

-

- case 'theme':

-

- switch ($action)

- {

- // Refresh theme data stored in the database

- case 'refresh':

-

- $sql = 'SELECT *

- FROM ' . STYLES_THEME_TABLE . "

- WHERE theme_id = $style_id";

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

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

- $db->sql_freeresult($result);

- if (!$theme_row)

- {

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

- }

-

- if (!$theme_row['theme_storedb'])

- {

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

- }

-

- if (confirm_box(true))

- {

- if ($theme_row['theme_storedb'] && file_exists("{$phpbb_root_path}styles/{$theme_row['theme_path']}/theme/stylesheet.css"))

- {

- // Save CSS contents

- $sql_ary = array(

- 'theme_mtime' => (int) filemtime("{$phpbb_root_path}styles/{$theme_row['theme_path']}/theme/stylesheet.css"),

- 'theme_data' => $this->db_theme_data($theme_row)

- );

-

- $sql = 'UPDATE ' . STYLES_THEME_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . "

- WHERE theme_id = $style_id";

- $db->sql_query($sql);

-

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

-

- add_log('admin', 'LOG_THEME_REFRESHED', $theme_row['theme_name']);

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

- }

- }

- else

- {

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

- 'i' => $id,

- 'mode' => $mode,

- 'action' => $action,

- 'id' => $style_id

- )));

- }

- break;

- }

-

- $this->frontend('theme', array('edit', 'details'), array('refresh', 'export', 'delete'));

- break;

-

- case 'imageset':

-

- switch ($action)

- {

- case 'refresh':

-

- $sql = 'SELECT *

- FROM ' . STYLES_IMAGESET_TABLE . "

- WHERE imageset_id = $style_id";

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

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

- $db->sql_freeresult($result);

-

- if (!$imageset_row)

- {

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

- }

-

- if (confirm_box(true))

- {

- $sql_ary = array();

-

- $imageset_definitions = array();

- foreach ($this->imageset_keys as $topic => $key_array)

- {

- $imageset_definitions = array_merge($imageset_definitions, $key_array);

- }

-

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

-

- $db->sql_transaction('begin');

-

- $sql = 'DELETE FROM ' . STYLES_IMAGESET_DATA_TABLE . '

- WHERE imageset_id = ' . $style_id;

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

-

- foreach ($cfg_data_imageset 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, $imageset_definitions))

- {

- $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) $style_id,

- 'image_lang' => '',

- );

- }

- }

- }

-

- $sql = 'SELECT lang_dir

- FROM ' . LANG_TABLE;

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

-

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

- {

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

- {

- $cfg_data_imageset_data = parse_cfg_file("{$phpbb_root_path}styles/{$imageset_row['imageset_path']}/imageset/{$row['lang_dir']}/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, $imageset_definitions))

- {

- $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) $style_id,

- 'image_lang' => (string) $row['lang_dir'],

- );

- }

- }

- }

- }

- }

- $db->sql_freeresult($result);

-

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

-

- $db->sql_transaction('commit');

-

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

- $cache->destroy('imageset_site_logo_md5');

-

- add_log('admin', 'LOG_IMAGESET_REFRESHED', $imageset_row['imageset_name']);

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

- }

- else

- {

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

- 'i' => $id,

- 'mode' => $mode,

- 'action' => $action,

- 'id' => $style_id

- )));

- }

- break;

- }

-

- $this->frontend('imageset', array('edit', 'details'), array('refresh', 'export', 'delete'));

- break;

- }

- }

-

- /**

- * Build Frontend with supplied options

- */

- function frontend($mode, $options, $actions)

- {

- global $user, $template, $db, $config, $phpbb_root_path, $phpEx;

-

- $sql_from = '';

- $sql_sort = 'LOWER(' . $mode . '_name)';

- $style_count = array();

-

- switch ($mode)

- case 'style':

- $sql_from = STYLES_TABLE;

- $sql_sort = 'style_active DESC, ' . $sql_sort;

-

- $sql = 'SELECT user_style, COUNT(user_style) AS style_count

- FROM ' . USERS_TABLE . '

- GROUP BY user_style';

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

-

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

- {

- $style_count[$row['user_style']] = $row['style_count'];

- }

- $db->sql_freeresult($result);

-

- break;

-

- case 'template':

- $sql_from = STYLES_TEMPLATE_TABLE;

- break;

-

- case 'theme':

- $sql_from = STYLES_THEME_TABLE;

- break;

-

- case 'imageset':

- $sql_from = STYLES_IMAGESET_TABLE;

- break;

-

- default:

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

- $l_prefix = strtoupper($mode);

-

- $this->page_title = 'ACP_' . $l_prefix . 'S';

-

- $template->assign_vars(array(

- 'S_FRONTEND' => true,

- 'S_STYLE' => ($mode == 'style') ? true : false,

-

- 'L_TITLE' => $user->lang[$this->page_title],

- 'L_EXPLAIN' => $user->lang[$this->page_title . '_EXPLAIN'],

- 'L_NAME' => $user->lang[$l_prefix . '_NAME'],

- 'L_INSTALLED' => $user->lang['INSTALLED_' . $l_prefix],

- 'L_UNINSTALLED' => $user->lang['UNINSTALLED_' . $l_prefix],

- 'L_NO_UNINSTALLED' => $user->lang['NO_UNINSTALLED_' . $l_prefix],

- 'L_CREATE' => $user->lang['CREATE_' . $l_prefix],

-

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

- )

- );

-

- $sql = "SELECT *

- FROM $sql_from

- ORDER BY $sql_sort ASC";

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

-

- $installed = array();

-

- $basis_options = '<option class="sep" value="">' . $user->lang['OPTIONAL_BASIS'] . '</option>';

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

- $installed[] = $row[$mode . '_name'];

- $basis_options .= '<option value="' . $row[$mode . '_id'] . '">' . $row[$mode . '_name'] . '</option>';

-

- $stylevis = ($mode == 'style' && !$row['style_active']) ? 'activate' : 'deactivate';

-

- $s_options = array();

- foreach ($options as $option)

- {

- $s_options[] = '<a href="' . $this->u_action . "&amp;action=$option&amp;id=" . $row[$mode . '_id'] . '">' . $user->lang[strtoupper($option)] . '</a>';

- }

-

- $s_actions = array();

- foreach ($actions as $option)

- $s_actions[] = '<a href="' . $this->u_action . "&amp;action=$option&amp;id=" . $row[$mode . '_id'] . '">' . $user->lang[strtoupper($option)] . '</a>';

-

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

- 'S_DEFAULT_STYLE' => ($mode == 'style' && $row['style_id'] == $config['default_style']) ? true : false,

- 'U_EDIT' => $this->u_action . '&amp;action=' . (($mode == 'style') ? 'details' : 'edit') . '&amp;id=' . $row[$mode . '_id'],

- 'U_STYLE_ACT_DEACT' => $this->u_action . '&amp;action=' . $stylevis . '&amp;id=' . $row[$mode . '_id'],

- 'L_STYLE_ACT_DEACT' => $user->lang['STYLE_' . strtoupper($stylevis)],

- 'S_OPTIONS' => implode(' | ', $s_options),

- 'S_ACTIONS' => implode(' | ', $s_actions),

- 'U_PREVIEW' => ($mode == 'style') ? append_sid("{$phpbb_root_path}index.$phpEx", "$mode=" . $row[$mode . '_id']) : '',

-

- 'NAME' => $row[$mode . '_name'],

- 'STYLE_COUNT' => ($mode == 'style' && isset($style_count[$row['style_id']])) ? $style_count[$row['style_id']] : 0,

-

- 'S_INACTIVE' => ($mode == 'style' && !$row['style_active']) ? true : false,

- )

- );

- $db->sql_freeresult($result);

- // Grab uninstalled items

- $new_ary = $cfg = array();

-

- $dp = @opendir("{$phpbb_root_path}styles");

-

- if ($dp)

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

- {

- if ($file[0] == '.' || !is_dir($phpbb_root_path . 'styles/' . $file))

- {

- continue;

- }

-

- $subpath = ($mode != 'style') ? "$mode/" : '';

- if (file_exists("{$phpbb_root_path}styles/$file/$subpath$mode.cfg"))

- {

- if ($cfg = file("{$phpbb_root_path}styles/$file/$subpath$mode.cfg"))

- {

- $items = parse_cfg_file('', $cfg);

- $name = (isset($items['name'])) ? trim($items['name']) : false;

-

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

- {

- // The array key is used for sorting later on.

- // $file is appended because $name doesn't have to be unique.

- $new_ary[$name . $file] = array(

- 'path' => $file,

- 'name' => $name,

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

- );

- }

- }

- }

- }

- closedir($dp);

- unset($installed);

- if (sizeof($new_ary))

- ksort($new_ary);

-

- foreach ($new_ary as $cfg)

- {

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

- 'NAME' => $cfg['name'],

- 'COPYRIGHT' => $cfg['copyright'],

- 'U_INSTALL' => $this->u_action . '&amp;action=install&amp;path=' . urlencode($cfg['path']))

- );

- }

- unset($new_ary);

-

- $template->assign_vars(array(

- 'S_BASIS_OPTIONS' => $basis_options)

- );

-

- * Provides a template editor which allows saving changes to template files on the filesystem or in the database.

- *

- * @param int $template_id specifies which template set is being edited

- function edit_template($template_id)

- global $phpbb_root_path, $phpEx, $config, $db, $cache, $user, $template, $safe_mode;

-

- if (defined('PHPBB_DISABLE_ACP_EDITOR'))

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

- $this->page_title = 'EDIT_TEMPLATE';

- $filelist = $filelist_cats = array();

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

- $template_data = htmlspecialchars_decode($template_data);

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

- $text_rows = max(5, min(999, request_var('text_rows', 20)));

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

- // make sure template_file path doesn't go upwards

- $template_file = preg_replace('#\.{2,}#', '.', $template_file);

- // Retrieve some information about the template

- $sql = 'SELECT template_storedb, template_path, template_name

- FROM ' . STYLES_TEMPLATE_TABLE . "

- WHERE template_id = $template_id";

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

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

- $db->sql_freeresult($result);

- if (!$template_info)

- {

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

- }

- if ($save_changes && !check_form_key('acp_styles'))

- {

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

- }

- else if (!$save_changes)

- {

- add_form_key('acp_styles');

- }

- // save changes to the template if the user submitted any

- if ($save_changes && $template_file)

- // Get the filesystem location of the current file

- $file = "{$phpbb_root_path}styles/{$template_info['template_path']}/template/$template_file";

- $additional = '';

-

- // If the template is stored on the filesystem try to write the file else store it in the database

- if (!$safe_mode && !$template_info['template_storedb'] && file_exists($file) && phpbb_is_writable($file))

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

- // File exists and is writeable, but still not able to be written to

- trigger_error(sprintf($user->lang['TEMPLATE_FILE_NOT_WRITABLE'], htmlspecialchars($template_file)) . adm_back_link($this->u_action), E_USER_WARNING);

- fwrite($fp, $template_data);

- fclose($fp);

- else

- $db->sql_transaction('begin');

-

- // If it's not stored in the db yet, then update the template setting and store all template files in the db

- if (!$template_info['template_storedb'])

- {

- if ($super = $this->get_super('template', $template_id))

- {

- $this->store_in_db('template', $super['template_id']);

- }

- else

- {

- $this->store_in_db('template', $template_id);

- }

-

- add_log('admin', 'LOG_TEMPLATE_EDIT_DETAILS', $template_info['template_name']);

- $additional .= '<br />' . $user->lang['EDIT_TEMPLATE_STORED_DB'];

- }

-

- // Update the template_data table entry for this template file

- $sql = 'UPDATE ' . STYLES_TEMPLATE_DATA_TABLE . "

- SET template_data = '" . $db->sql_escape($template_data) . "', template_mtime = " . time() . "

- WHERE template_id = $template_id

- AND template_filename = '" . $db->sql_escape($template_file) . "'";

- $db->sql_query($sql);

-

- $db->sql_transaction('commit');

-

- // destroy the cached version of the template (filename without extension)

- $this->clear_template_cache($template_info, array(substr($template_file, 0, -5)));

-

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

-

- add_log('admin', 'LOG_TEMPLATE_EDIT', $template_info['template_name'], $template_file);

- trigger_error($user->lang['TEMPLATE_FILE_UPDATED'] . $additional . adm_back_link($this->u_action . "&amp;action=edit&amp;id=$template_id&amp;text_rows=$text_rows&amp;template_file=$template_file"));

- // Generate a category array containing template filenames

- if (!$template_info['template_storedb'])

- $template_path = "{$phpbb_root_path}styles/{$template_info['template_path']}/template";

-

- $filelist = filelist($template_path, '', 'html');

- $filelist[''] = array_diff($filelist[''], array('bbcode.html'));

-

- if ($template_file)

- {

- if (!file_exists($template_path . "/$template_file") || !($template_data = file_get_contents($template_path . "/$template_file")))

- {

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

- }

- }

- }

- else

- {

- $sql = 'SELECT *

- FROM ' . STYLES_TEMPLATE_DATA_TABLE . "

- WHERE template_id = $template_id";

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

-

- $filelist = array('' => array());

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

- {

- $file_info = pathinfo($row['template_filename']);

-

- if (($file_info['basename'] != 'bbcode') && ($file_info['extension'] == 'html'))

- {

- if (($file_info['dirname'] == '.') || empty($file_info['dirname']))

- {

- $filelist[''][] = $row['template_filename'];

- }

- else

- {

- $filelist[$file_info['dirname'] . '/'][] = $file_info['basename'];

- }

- }

-

- if ($row['template_filename'] == $template_file)

- {

- $template_data = $row['template_data'];

- }

- }

- $db->sql_freeresult($result);

- unset($file_info);

- if (empty($filelist['']))

- {

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

- }

- // Now create the categories

- $filelist_cats[''] = array();

- foreach ($filelist as $pathfile => $file_ary)

- // Use the directory name as category name

- if (!empty($pathfile))

- {

- $filelist_cats[$pathfile] = array();

- foreach ($file_ary as $file)

- {

- $filelist_cats[$pathfile][$pathfile . $file] = $file;

- }

- }

- // or if it's in the main category use the word before the first underscore to group files

- else

- {

- $cats = array();

- foreach ($file_ary as $file)

- {

- $cats[] = substr($file, 0, strpos($file, '_'));

- $filelist_cats[substr($file, 0, strpos($file, '_'))][$file] = $file;

- }

-

- $cats = array_values(array_unique($cats));

-

- // we don't need any single element categories so put them into the misc '' category

- for ($i = 0, $n = sizeof($cats); $i < $n; $i++)

- {

- if (sizeof($filelist_cats[$cats[$i]]) == 1 && $cats[$i] !== '')

- {

- $filelist_cats[''][key($filelist_cats[$cats[$i]])] = current($filelist_cats[$cats[$i]]);

- unset($filelist_cats[$cats[$i]]);

- }

- }

- unset($cats);

- }

- unset($filelist);

-

- // Generate list of categorised template files

- $tpl_options = '';

- ksort($filelist_cats);

- foreach ($filelist_cats as $category => $tpl_ary)

- {

- ksort($tpl_ary);

-

- if (!empty($category))

- {

- $tpl_options .= '<option class="sep" value="">' . $category . '</option>';

- }

- foreach ($tpl_ary as $filename => $file)

- {

- $selected = ($template_file == $filename) ? ' selected="selected"' : '';

- $tpl_options .= '<option value="' . $filename . '"' . $selected . '>' . $file . '</option>';

- }

- }

- $template->assign_vars(array(

- 'S_EDIT_TEMPLATE' => true,

- 'S_HIDDEN_FIELDS' => build_hidden_fields(array('template_file' => $template_file)),

- 'S_TEMPLATES' => $tpl_options,

-

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

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

-

- 'L_EDIT' => $user->lang['EDIT_TEMPLATE'],

- 'L_EDIT_EXPLAIN' => $user->lang['EDIT_TEMPLATE_EXPLAIN'],

- 'L_EDITOR' => $user->lang['TEMPLATE_EDITOR'],

- 'L_EDITOR_HEIGHT' => $user->lang['TEMPLATE_EDITOR_HEIGHT'],

- 'L_FILE' => $user->lang['TEMPLATE_FILE'],

- 'L_SELECT' => $user->lang['SELECT_TEMPLATE'],

- 'L_SELECTED' => $user->lang['SELECTED_TEMPLATE'],

- 'L_SELECTED_FILE' => $user->lang['SELECTED_TEMPLATE_FILE'],

-

- 'SELECTED_TEMPLATE' => $template_info['template_name'],

- 'TEMPLATE_FILE' => $template_file,

- 'TEMPLATE_DATA' => utf8_htmlspecialchars($template_data),

- 'TEXT_ROWS' => $text_rows)

- );

- * Allows the admin to view cached versions of template files and clear single template cache files

- * @param int $template_id specifies which template's cache is shown

- function template_cache($template_id)

- global $phpbb_root_path, $phpEx, $config, $db, $cache, $user, $template;

- $source = str_replace('/', '.', request_var('source', ''));

- $file_ary = array_diff(request_var('delete', array('')), array(''));

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

-

- $sql = 'SELECT *

- FROM ' . STYLES_TEMPLATE_TABLE . "

- WHERE template_id = $template_id";

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

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

- $db->sql_freeresult($result);

-

- if (!$template_row)

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

- }

-

- // User wants to delete one or more files ...

- if ($submit && $file_ary)

- {

- $this->clear_template_cache($template_row, $file_ary);

- trigger_error($user->lang['TEMPLATE_CACHE_CLEARED'] . adm_back_link($this->u_action . "&amp;action=cache&amp;id=$template_id"));

- }

-

- $cache_prefix = 'tpl_' . str_replace('_', '-', $template_row['template_path']);

-

- // Someone wants to see the cached source ... so we'll highlight it,

- // add line numbers and indent it appropriately. This could be nasty

- // on larger source files ...

- if ($source && file_exists("{$phpbb_root_path}cache/{$cache_prefix}_$source.html.$phpEx"))

- {

- adm_page_header($user->lang['TEMPLATE_CACHE']);

-

- $template->set_filenames(array(

- 'body' => 'viewsource.html')

- );

-

- $template->assign_vars(array(

- 'FILENAME' => str_replace('.', '/', $source) . '.html')

- );

-

- $code = str_replace(array("\r\n", "\r"), array("\n", "\n"), file_get_contents("{$phpbb_root_path}cache/{$cache_prefix}_$source.html.$phpEx"));

-

- $conf = array('highlight.bg', 'highlight.comment', 'highlight.default', 'highlight.html', 'highlight.keyword', 'highlight.string');

- foreach ($conf as $ini_var)

- @ini_set($ini_var, str_replace('highlight.', 'syntax', $ini_var));

-

- $marker = 'MARKER' . time();

- $code = highlight_string(str_replace("\n", $marker, $code), true);

- $code = str_replace($marker, "\n", $code);

- $str_from = array('<span style="color: ', '<font color="syntax', '</font>', '<code>', '</code>','[', ']', '.', ':');

- $str_to = array('<span class="', '<span class="syntax', '</span>', '', '', '&#91;', '&#93;', '&#46;', '&#58;');

-

- $code = str_replace($str_from, $str_to, $code);

- $code = preg_replace('#^(<span class="[a-z_]+">)\n?(.*?)\n?(</span>)$#ism', '$1$2$3', $code);

- $code = substr($code, strlen('<span class="syntaxhtml">'));

- $code = substr($code, 0, -1 * strlen('</ span>'));

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

-

- foreach ($code as $key => $line)

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

- 'LINENUM' => $key + 1,

- 'LINE' => preg_replace('#([^ ;])&nbsp;([^ &])#', '$1 $2', $line))

- );

- unset($code[$key]);

-

- adm_page_footer();

- $filemtime = array();

- if ($template_row['template_storedb'])

- {

- $ids = array();

- if (isset($template_row['template_inherits_id']) && $template_row['template_inherits_id'])

- {

- $ids[] = $template_row['template_inherits_id'];

- }

- $ids[] = $template_row['template_id'];

-

- $filemtime = array();

- $file_template_db = array();

-

- foreach ($ids as $id)

- {

- $sql = 'SELECT template_filename, template_mtime

- FROM ' . STYLES_TEMPLATE_DATA_TABLE . "

- WHERE template_id = $id";

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

-

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

- {

- $filemtime[$row['template_filename']] = $row['template_mtime'];

- $file_template_db[$row['template_filename']] = $id;

- }

- $db->sql_freeresult($result);

- }

- }

- // Get a list of cached template files and then retrieve additional information about them

- $file_ary = $this->template_cache_filelist($template_row['template_path']);

- foreach ($file_ary as $file)

- $file = str_replace('/', '.', $file);

-

- // perform some dirty guessing to get the path right.

- // We assume that three dots in a row were '../'

- $tpl_file = str_replace('.', '/', $file);

- $tpl_file = str_replace('///', '../', $tpl_file);

-

- $filename = "{$cache_prefix}_$file.html.$phpEx";

- if (!file_exists("{$phpbb_root_path}cache/$filename"))

- $file_tpl = "{$phpbb_root_path}styles/{$template_row['template_path']}/template/$tpl_file.html";

- $inherited = false;

-

- if (isset($template_row['template_inherits_id']) && $template_row['template_inherits_id'])

- {

- if (!$template_row['template_storedb'])

- {

- if (!file_exists($file_tpl))

- {

- $file_tpl = "{$phpbb_root_path}styles/{$template_row['template_inherit_path']}/template/$tpl_file.html";

- $inherited = true;

- }

- }

- else

- {

- if ($file_template_db[$file . '.html'] == $template_row['template_inherits_id'])

- {

- $file_tpl = "{$phpbb_root_path}styles/{$template_row['template_inherit_path']}/template/$tpl_file.html";

- $inherited = true;

- }

- }

- }

-

- // Correct the filename if it is stored in database and the file is in a subfolder.

- if ($template_row['template_storedb'])

- $file = str_replace('.', '/', $file);

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

- 'U_VIEWSOURCE' => $this->u_action . "&amp;action=cache&amp;id=$template_id&amp;source=$file",

- 'CACHED' => $user->format_date(filemtime("{$phpbb_root_path}cache/$filename")),

- 'FILENAME' => $file,

- 'FILENAME_PATH' => $file_tpl,

- 'FILESIZE' => get_formatted_filesize(filesize("{$phpbb_root_path}cache/$filename")),

- 'MODIFIED' => $user->format_date((!$template_row['template_storedb']) ? filemtime($file_tpl) : $filemtime[$file . '.html']))

- );

- unset($filemtime);

- $template->assign_vars(array(

- 'S_CACHE' => true,

- 'S_TEMPLATE' => true,

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

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

- );

- * Provides a css editor and a basic easier to use stylesheet editing tool for less experienced (or lazy) users

- *

- * @param int $theme_id specifies which theme is being edited

- function edit_theme($theme_id)

- global $phpbb_root_path, $phpEx, $config, $db, $cache, $user, $template, $safe_mode;

-

- $this->page_title = 'EDIT_THEME';

-

- $filelist = $filelist_cats = array();

-

- $theme_data = utf8_normalize_nfc(request_var('template_data', '', true));

- $theme_data = htmlspecialchars_decode($theme_data);

- $theme_file = utf8_normalize_nfc(request_var('template_file', '', true));

- $text_rows = max(5, min(999, request_var('text_rows', 20)));

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

-

- // make sure theme_file path doesn't go upwards

- $theme_file = str_replace('..', '.', $theme_file);

-

- // Retrieve some information about the theme

- $sql = 'SELECT theme_storedb, theme_path, theme_name, theme_data

- FROM ' . STYLES_THEME_TABLE . "

- WHERE theme_id = $theme_id";

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

-

- if (!($theme_info = $db->sql_fetchrow($result)))

- {

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

- }

- $db->sql_freeresult($result);

-

- // save changes to the theme if the user submitted any

- if ($save_changes)

- {

- // Get the filesystem location of the current file

- $file = "{$phpbb_root_path}styles/{$theme_info['theme_path']}/theme/$theme_file";

- $additional = '';

- $message = $user->lang['THEME_UPDATED'];

-

- // If the theme is stored on the filesystem try to write the file else store it in the database

- if (!$safe_mode && !$theme_info['theme_storedb'] && file_exists($file) && phpbb_is_writable($file))

- {

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

- {

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

- }

- fwrite($fp, $theme_data);

- fclose($fp);

- }

- else

- {

- // Write stylesheet to db

- $sql_ary = array(

- 'theme_mtime' => time(),

- 'theme_storedb' => 1,

- 'theme_data' => $this->db_theme_data($theme_info, $theme_data),

- );

- $sql = 'UPDATE ' . STYLES_THEME_TABLE . '

- SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '

- WHERE theme_id = ' . $theme_id;

- $db->sql_query($sql);

-

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

- // notify the user if the theme was not stored in the db before his modification

- if (!$theme_info['theme_storedb'])

- {

- add_log('admin', 'LOG_THEME_EDIT_DETAILS', $theme_info['theme_name']);

- $message .= '<br />' . $user->lang['EDIT_THEME_STORED_DB'];

- }

- }

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

- add_log('admin', (!$theme_info['theme_storedb']) ? 'LOG_THEME_EDIT_FILE' : 'LOG_THEME_EDIT', $theme_info['theme_name'], (!$theme_info['theme_storedb']) ? $theme_file : '');

-

- trigger_error($message . adm_back_link($this->u_action . "&amp;action=edit&amp;id=$theme_id&amp;template_file=$theme_file&amp;text_rows=$text_rows"));

- }

- // Generate a category array containing theme filenames

- if (!$theme_info['theme_storedb'])

- {

- $theme_path = "{$phpbb_root_path}styles/{$theme_info['theme_path']}/theme";

- $filelist = filelist($theme_path, '', 'css');

- if ($theme_file)

- {

- if (!file_exists($theme_path . "/$theme_file") || !($theme_data = file_get_contents($theme_path . "/$theme_file")))

- {

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

- }

- }

- }

- else

- {

- $theme_data = &$theme_info['theme_data'];

- }

- // Now create the categories

- $filelist_cats[''] = array();

- foreach ($filelist as $pathfile => $file_ary)

- // Use the directory name as category name

- if (!empty($pathfile))

- $filelist_cats[$pathfile] = array();

- foreach ($file_ary as $file)

- {

- $filelist_cats[$pathfile][$pathfile . $file] = $file;

- }

- }

- // or if it's in the main category use the word before the first underscore to group files

- else

- {

- $cats = array();

- foreach ($file_ary as $file)

- {

- $cats[] = substr($file, 0, strpos($file, '_'));

- $filelist_cats[substr($file, 0, strpos($file, '_'))][$file] = $file;

- }

-

- $cats = array_values(array_unique($cats));

-

- // we don't need any single element categories so put them into the misc '' category

- for ($i = 0, $n = sizeof($cats); $i < $n; $i++)

- {

- if (sizeof($filelist_cats[$cats[$i]]) == 1 && $cats[$i] !== '')

- {

- $filelist_cats[''][key($filelist_cats[$cats[$i]])] = current($filelist_cats[$cats[$i]]);

- unset($filelist_cats[$cats[$i]]);

- }

- }

- unset($cats);

- unset($filelist);

- // Generate list of categorised theme files

- $tpl_options = '';

- ksort($filelist_cats);

- foreach ($filelist_cats as $category => $tpl_ary)

- {

- ksort($tpl_ary);

- if (!empty($category))

- {

- $tpl_options .= '<option class="sep" value="">' . $category . '</option>';

- }

- foreach ($tpl_ary as $filename => $file)

- {

- $selected = ($theme_file == $filename) ? ' selected="selected"' : '';

- $tpl_options .= '<option value="' . $filename . '"' . $selected . '>' . $file . '</option>';

- }

- }

- $template->assign_vars(array(

- 'S_EDIT_THEME' => true,

- 'S_HIDDEN_FIELDS' => build_hidden_fields(array('template_file' => $theme_file)),

- 'S_THEME_IN_DB' => $theme_info['theme_storedb'],

- 'S_TEMPLATES' => $tpl_options,

-

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

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

-

- 'L_EDIT' => $user->lang['EDIT_THEME'],

- 'L_EDIT_EXPLAIN' => $user->lang['EDIT_THEME_EXPLAIN'],

- 'L_EDITOR' => $user->lang['THEME_EDITOR'],

- 'L_EDITOR_HEIGHT' => $user->lang['THEME_EDITOR_HEIGHT'],

- 'L_FILE' => $user->lang['THEME_FILE'],

- 'L_SELECT' => $user->lang['SELECT_THEME'],

- 'L_SELECTED' => $user->lang['SELECTED_THEME'],

- 'L_SELECTED_FILE' => $user->lang['SELECTED_THEME_FILE'],

-

- 'SELECTED_TEMPLATE' => $theme_info['theme_name'],

- 'TEMPLATE_FILE' => $theme_file,

- 'TEMPLATE_DATA' => utf8_htmlspecialchars($theme_data),

- 'TEXT_ROWS' => $text_rows)

- );

- * Edit imagesets

- *

- * @param int $imageset_id specifies which imageset is being edited

- function edit_imageset($imageset_id)

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

-

- $this->page_title = 'EDIT_IMAGESET';

-

- if (!$imageset_id)

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

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

-

- $imgname = request_var('imgname', 'site_logo');

- $imgname = preg_replace('#[^a-z0-9\-+_]#i', '', $imgname);

- $sql_extra = $imgnamelang = '';

-

- $sql = 'SELECT imageset_path, imageset_name

- FROM ' . STYLES_IMAGESET_TABLE . "

- WHERE imageset_id = $imageset_id";

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

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

- $db->sql_freeresult($result);

-

- if (!$imageset_row)

- {

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

- }

-

- $imageset_path = $imageset_row['imageset_path'];

- $imageset_name = $imageset_row['imageset_name'];

-

- if (strpos($imgname, '-') !== false)

- {

- list($imgname, $imgnamelang) = explode('-', $imgname);

- $sql_extra = " AND image_lang IN ('" . $db->sql_escape($imgnamelang) . "', '')";

- }

- $sql = 'SELECT image_filename, image_width, image_height, image_lang, image_id

- FROM ' . STYLES_IMAGESET_DATA_TABLE . "

- WHERE imageset_id = $imageset_id

- AND image_name = '" . $db->sql_escape($imgname) . "'$sql_extra";

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

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

- $db->sql_freeresult($result);

-

- $image_filename = $imageset_data_row['image_filename'];

- $image_width = $imageset_data_row['image_width'];

- $image_height = $imageset_data_row['image_height'];

- $image_lang = $imageset_data_row['image_lang'];

- $image_id = $imageset_data_row['image_id'];

- $imgsize = ($imageset_data_row['image_width'] && $imageset_data_row['image_height']) ? 1 : 0;

-

- // Check to see whether the selected image exists in the table

- $valid_name = ($update) ? false : true;

-

- foreach ($this->imageset_keys as $category => $img_ary)

- if (in_array($imgname, $img_ary))

- $valid_name = true;

- if ($update && isset($_POST['imgpath']) && $valid_name)

- // If imgwidth and imgheight are non-zero grab the actual size

- // from the image itself ... we ignore width settings for the poll center image

- $imgwidth = request_var('imgwidth', 0);

- $imgheight = request_var('imgheight', 0);

- $imgsize = request_var('imgsize', 0);

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

- $imgpath = str_replace('..', '.', $imgpath);

-

- // If no dimensions selected, we reset width and height to 0 ;)

- if (!$imgsize)

- {

- $imgwidth = $imgheight = 0;

- }

-

- $imglang = '';

- if ($imgpath && !file_exists("{$phpbb_root_path}styles/$imageset_path/imageset/$imgpath"))

- {

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

- }

- // Determine width/height. If dimensions included and no width/height given, we detect them automatically...

- if ($imgsize && $imgpath)

- {

- if (!$imgwidth || !$imgheight)

- {

- list($imgwidth_file, $imgheight_file) = getimagesize("{$phpbb_root_path}styles/$imageset_path/imageset/$imgpath");

- $imgwidth = ($imgwidth) ? $imgwidth : $imgwidth_file;

- $imgheight = ($imgheight) ? $imgheight : $imgheight_file;

- }

- $imgwidth = ($imgname != 'poll_center') ? (int) $imgwidth : 0;

- $imgheight = (int) $imgheight;

- }

- if (strpos($imgpath, '/') !== false)

- {

- list($imglang, $imgfilename) = explode('/', $imgpath);

- }

- else

- $imgfilename = $imgpath;

- $sql_ary = array(

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

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

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

- 'image_lang' => (string) $imglang,

- // already exists

- if ($imageset_data_row)

- {

- $sql = 'UPDATE ' . STYLES_IMAGESET_DATA_TABLE . '

- SET ' . $db->sql_build_array('UPDATE', $sql_ary) . "

- WHERE image_id = $image_id";

- $db->sql_query($sql);

- }

- // does not exist

- else if (!$imageset_data_row)

- {

- $sql_ary['image_name'] = $imgname;

- $sql_ary['imageset_id'] = (int) $imageset_id;

- $db->sql_query('INSERT INTO ' . STYLES_IMAGESET_DATA_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary));

- }

-

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

-

- add_log('admin', 'LOG_IMAGESET_EDIT', $imageset_name);

-

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

-

- $image_filename = $imgfilename;

- $image_width = $imgwidth;

- $image_height = $imgheight;

- $image_lang = $imglang;

- }

-

- $imglang = '';

- $imagesetlist = array('nolang' => array(), 'lang' => array());

- $langs = array();

-

- $dir = "{$phpbb_root_path}styles/$imageset_path/imageset";

- $dp = @opendir($dir);

-

- if ($dp)

- {

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

- if ($file[0] != '.' && strtoupper($file) != 'CVS' && !is_file($dir . '/' . $file) && !is_link($dir . '/' . $file))

- $langs[] = $file;

- else if (preg_match('#\.(?:gif|jpg|png)$#', $file))

- $imagesetlist['nolang'][] = $file;

-

- if ($sql_extra)

- $dp2 = @opendir("$dir/$imgnamelang");

- if ($dp2)

- while (($file2 = readdir($dp2)) !== false)

- if (preg_match('#\.(?:gif|jpg|png)$#', $file2))

- $imagesetlist['lang'][] = "$imgnamelang/$file2";

- closedir($dp2);

- }

- }

- closedir($dp);

- }

-

- // Generate list of image options

- $img_options = '';

- foreach ($this->imageset_keys as $category => $img_ary)

- {

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

- 'NAME' => $user->lang['IMG_CAT_' . strtoupper($category)]

- ));

-

- foreach ($img_ary as $img)

- {

- if ($category == 'buttons')

- {

- foreach ($langs as $language)

- $template->assign_block_vars('category.images', array(

- 'SELECTED' => ($img == $imgname && $language == $imgnamelang),

- 'VALUE' => $img . '-' . $language,

- 'TEXT' => $user->lang['IMG_' . strtoupper($img)] . ' [ ' . $language . ' ]'

- ));

- $template->assign_block_vars('category.images', array(

- 'SELECTED' => ($img == $imgname),

- 'VALUE' => $img,

- 'TEXT' => (($category == 'custom') ? $img : $user->lang['IMG_' . strtoupper($img)])

- ));

- }

-

- // Make sure the list of possible images is sorted alphabetically

- sort($imagesetlist['lang']);

- sort($imagesetlist['nolang']);

-

- $image_found = false;

- $img_val = '';

- foreach ($imagesetlist as $type => $img_ary)

- {

- if ($type !== 'lang' || $sql_extra)

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

- 'TYPE' => ($type == 'lang')

- ));

- foreach ($img_ary as $img)

- $imgtext = preg_replace('/^([^\/]+\/)/', '', $img);

- $selected = (!empty($imgname) && strpos($image_filename, $imgtext) !== false);

- if ($selected)

- $image_found = true;

- $img_val = htmlspecialchars($img);

- $template->assign_block_vars('imagesetlist.images', array(

- 'SELECTED' => $selected,

- 'TEXT' => $imgtext,

- 'VALUE' => htmlspecialchars($img)

- ));

- }

-

- $imgsize_bool = (!empty($imgname) && $image_width && $image_height) ? true : false;

- $image_request = '../styles/' . $imageset_path . '/imageset/' . ($image_lang ? $imgnamelang . '/' : '') . $image_filename;

-

- $template->assign_vars(array(

- 'S_EDIT_IMAGESET' => true,

- 'L_TITLE' => $user->lang[$this->page_title],

- 'L_EXPLAIN' => $user->lang[$this->page_title . '_EXPLAIN'],

- 'IMAGE_OPTIONS' => $img_options,

- 'IMAGE_SIZE' => $image_width,

- 'IMAGE_HEIGHT' => $image_height,

- 'IMAGE_REQUEST' => (empty($image_filename)) ? 'images/no_image.png' : $image_request,

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

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

- 'NAME' => $imageset_name,

- 'A_NAME' => addslashes($imageset_name),

- 'PATH' => $imageset_path,

- 'A_PATH' => addslashes($imageset_path),

- 'ERROR' => !$valid_name,

- 'IMG_SRC' => ($image_found) ? '../styles/' . $imageset_path . '/imageset/' . $img_val : 'images/no_image.png',

- 'IMAGE_SELECT' => $image_found

- ));

- }

-

- /**

- * Remove style/template/theme/imageset

- */

- function remove($mode, $style_id)

- {

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

-

- $new_id = request_var('new_id', 0);

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

- $sql_where = '';

-

- switch ($mode)

- {

- case 'style':

- $sql_from = STYLES_TABLE;

- $sql_select = 'style_id, style_name, template_id, theme_id, imageset_id';

- $sql_where = 'AND style_active = 1';

- break;

-

- case 'template':

- $sql_from = STYLES_TEMPLATE_TABLE;

- $sql_select = 'template_id, template_name, template_path, template_storedb';

- break;

-

- case 'theme':

- $sql_from = STYLES_THEME_TABLE;

- $sql_select = 'theme_id, theme_name, theme_path, theme_storedb';

- break;

-

- case 'imageset':

- $sql_from = STYLES_IMAGESET_TABLE;

- $sql_select = 'imageset_id, imageset_name, imageset_path';

- break;

- }

-

- if ($mode === 'template' && ($conflicts = $this->check_inheritance($mode, $style_id)))

- {

- $l_type = strtoupper($mode);

- $msg = $user->lang[$l_type . '_DELETE_DEPENDENT'];

- foreach ($conflicts as $id => $values)

- $msg .= '<br />' . $values['template_name'];

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

- }

-

- $l_prefix = strtoupper($mode);

-

- $sql = "SELECT $sql_select

- FROM $sql_from

- WHERE {$mode}_id = $style_id";

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

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

- $db->sql_freeresult($result);

-

- if (!$style_row)

- {

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

- }

-

- $s_only_component = $this->display_component_options($mode, $style_row[$mode . '_id'], $style_row);

-

- if ($s_only_component)

- {

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

- }

-

- if ($update)

- {

- if ($mode == 'style')

- $sql = "DELETE FROM $sql_from

- WHERE {$mode}_id = $style_id";

- $db->sql_query($sql);

- $sql = 'UPDATE ' . USERS_TABLE . "

- SET user_style = $new_id

- WHERE user_style = $style_id";

- $db->sql_query($sql);

- $sql = 'UPDATE ' . FORUMS_TABLE . "

- SET forum_style = $new_id

- WHERE forum_style = $style_id";

- $db->sql_query($sql);

-

- if ($style_id == $config['default_style'])

- set_config('default_style', $new_id);

- // Remove the components

- $components = array('template', 'theme', 'imageset');

- foreach ($components as $component)

- $new_id = request_var('new_' . $component . '_id', 0);

- $component_id = $style_row[$component . '_id'];

- $this->remove_component($component, $component_id, $new_id, $style_id);

- }

- else

- {

- $this->remove_component($mode, $style_id, $new_id);

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

-

- add_log('admin', 'LOG_' . $l_prefix . '_DELETE', $style_row[$mode . '_name']);

- $message = ($mode != 'style') ? $l_prefix . '_DELETED_FS' : $l_prefix . '_DELETED';

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

- $this->page_title = 'DELETE_' . $l_prefix;

-

- $template->assign_vars(array(

- 'S_DELETE' => true,

-

- 'L_TITLE' => $user->lang[$this->page_title],

- 'L_EXPLAIN' => $user->lang[$this->page_title . '_EXPLAIN'],

- 'L_NAME' => $user->lang[$l_prefix . '_NAME'],

- 'L_REPLACE' => $user->lang['REPLACE_' . $l_prefix],

- 'L_REPLACE_EXPLAIN' => $user->lang['REPLACE_' . $l_prefix . '_EXPLAIN'],

-

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

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

- 'NAME' => $style_row[$mode . '_name'],