- $banned_options = '';

- $banned_options .= '<option' . (($row['ban_exclude']) ? ' class="sep"' : '') . ' value="' . $row['ban_id'] . '">' . $row[$field] . '</option>';

- 'S_BANNED_OPTIONS' => ($banned_options) ? true : false,

- 'BANNED_OPTIONS' => $banned_options)

- );

- $utf8_pcre_properties = pcre_utf8_support();

- 'min_post_chars' => array('lang' => 'MIN_CHAR_LIMIT', 'validate' => 'int:0', 'type' => 'text:4:6', 'explain' => true),

- $radio_ary = array(USER_ACTIVATION_DISABLE => 'ACC_DISABLE', USER_ACTIVATION_NONE => 'ACC_NONE');

- $radio_ary += array(USER_ACTIVATION_SELF => 'ACC_USER', USER_ACTIVATION_ADMIN => 'ACC_ADMIN');

- return h_radio('config[require_activation]', $radio_ary, $value, $key);

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

- else

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

-

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

-

-

-

- }

-

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

- FROM ' . USERS_TABLE . ' u, ' . USER_GROUP_TABLE . ' ug

- WHERE ug.group_id = ' . $group_id . '

- AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')

- ORDER BY u.user_lang, u.user_notify_type';

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

- FROM ' . USERS_TABLE . '

- WHERE user_allow_massemail = 1

- AND user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')

- ORDER BY user_lang, user_notify_type';

- // Send with BCC, no more than 50 recipients for one mail (to not exceed the limit)

- $max_chunk_size = 50;

- // Redirect to permissions

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

- {

- $message .= '<br /><br />' . sprintf($user->lang['REDIRECT_ACL'], '<a href="' . append_sid("{$phpbb_admin_path}index.$phpEx", 'i=permissions' . $acl_url) . '">', '</a>');

- }

-

- if (!$forum_data['forum_name'])

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

- set_config('teampage_multiple', request_var('teampage_multiple', 0));

- 'S_GROUP_SELECT_LEGEND' => $s_group_select_legend,

- 'S_GROUP_SELECT_TEAMPAGE' => $s_group_select_teampage,

- 'DISPLAY_FORUMS' => ($config['teampage_forums']) ? true : false,

- 'DISPLAY_MULTIPLE' => ($config['teampage_multiple']) ? true : false,

- 'LEGEND_SORT_GROUPNAME' => ($config['legend_sort_groupname']) ? true : false,

- 'U_ACTION' => $this->u_action . '&amp;start=' . $start,

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

- }

-

- trigger_error(sprintf($user->lang['LANGUAGE_PACK_INSTALLED'], $lang_pack['name']) . adm_back_link($this->u_action));

- view_log($mode, $log_data, $log_count, $config['topics_per_page'], $start, $forum_id, 0, 0, $sql_where, $sql_sort, $keywords);

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

- $latest_version = str_replace('rc', 'RC', strtolower(trim($latest_version_info[0])));

- $current_version = str_replace('rc', 'RC', strtolower($config['version']));

-

- 'S_VERSION_UP_TO_DATE' => version_compare($current_version, $latest_version, '<') ? false : true,

- 'U_VERSIONCHECK_FORCE' => append_sid("{$phpbb_admin_path}index.$phpEx", 'i=1&amp;versioncheck_force=1'),

-

-

-

-

-

-

- $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 . ']">';

-

-

-

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

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

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

- if (!class_exists($class))

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

- if (class_exists($class))

- $c_class = new $class();

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

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

-

-

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

- 'S_SPECIAL_RANK' => (!isset($ranks['rank_special']) || $ranks['rank_special']) ? true : false,

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

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

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

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

- $db->sql_freeresult($result);

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

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

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

-

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

- var $imageset_cfg;

- var $imageset_keys;

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

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

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

- ),

- );

-

- case 'imageset':

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

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

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

- }

-

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

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

-

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

-

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

-

- case 'imageset':

- $sql_from = STYLES_IMAGESET_TABLE;

- break;

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

- $sql = 'SELECT template_storedb, template_path, template_name

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

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

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

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

- }

- }

-

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

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

- );

- unset($filemtime);

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

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

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

- }

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

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

- }

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

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

- break;

- }

- }

-

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

- ));

- }

- }

- else

- {

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

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

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

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

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

- * Remove template/theme/imageset entry from the database

- if ($component == 'imageset')

- {

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

- WHERE imageset_id = $component_id";

- $db->sql_query($sql);

- }

-

-

- case 'imageset':

- $sql_from = STYLES_IMAGESET_TABLE;;

- break;

- * Display the options which can be used to replace a style/template/theme/imageset

-

- case 'imageset':

- $sql_from = STYLES_IMAGESET_TABLE;

- break;

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

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

- if ($update && ($inc_template + $inc_theme + $inc_imageset) < 1)

- $sql_select .= ($inc_imageset) ? ', i.*' : ', i.imageset_name';

- $sql_from = STYLES_TABLE . ' s, ' . STYLES_TEMPLATE_TABLE . ' t, ' . STYLES_THEME_TABLE . ' c, ' . STYLES_IMAGESET_TABLE . ' i';

- $sql_where = "s.style_id = $style_id AND t.template_id = s.template_id AND c.theme_id = s.theme_id AND i.imageset_id = s.imageset_id";

-

- case 'imageset':

- $name = 'imageset_name';

-

- $sql_select = '*';

- $sql_from = STYLES_IMAGESET_TABLE;

- $sql_where = "imageset_id = $style_id";

-

- $l_prefix = 'IMAGESET';

- break;

- $var_ary = array('style_id', 'style_name', 'style_copyright', 'template_id', 'template_name', 'template_path', 'template_copyright', 'template_storedb', 'template_inherits_id', 'bbcode_bitfield', 'theme_id', 'theme_name', 'theme_path', 'theme_copyright', 'theme_storedb', 'theme_mtime', 'theme_data', 'imageset_id', 'imageset_name', 'imageset_path', 'imageset_copyright');

- $style_cfg .= (!$inc_imageset) ? "\nrequired_imageset = {$style_row['imageset_name']}" : '';

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

- {

- $files[] = array(

- 'src' => "styles/{$style_row['template_path']}/template/",

- 'prefix-' => "styles/{$style_row['template_path']}/",

- 'prefix+' => false,

- 'exclude' => 'template.cfg'

- );

- }

- else

- {

- $sql = 'SELECT template_filename, template_data

- FROM ' . STYLES_TEMPLATE_DATA_TABLE . "

- WHERE template_id = {$style_row['template_id']}";

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

-

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

- {

- $data[] = array(

- 'src' => $row['template_data'],

- 'prefix' => 'template/' . $row['template_filename']

- );

- }

- $db->sql_freeresult($result);

- }

- if (!isset($items['parse_css_file']))

- {

- $items['parse_css_file'] = 'off';

- }

-

- $theme_cfg = str_replace(array('{PARSE_CSS_FILE}'), array($items['parse_css_file']), $theme_cfg);

-

- 'exclude' => ($style_row['theme_storedb']) ? 'stylesheet.css,theme.cfg' : 'theme.cfg'

- 'prefix' => 'theme/theme.cfg'

- if ($style_row['theme_storedb'])

- {

- $data[] = array(

- 'src' => $style_row['theme_data'],

- 'prefix' => 'theme/stylesheet.css'

- );

- }

-

- // Export imageset core code

- if ($mode == 'imageset' || $inc_imageset)

- {

- $imageset_cfg = str_replace(array('{MODE}', '{NAME}', '{COPYRIGHT}', '{VERSION}'), array($mode, $style_row['imageset_name'], $style_row['imageset_copyright'], $config['version']), $this->imageset_cfg);

-

- $imageset_main = array();

-

- $sql = 'SELECT image_filename, image_name, image_height, image_width

- FROM ' . STYLES_IMAGESET_DATA_TABLE . "

- WHERE imageset_id = $style_id

- AND image_lang = ''";

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

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

- {

- $imageset_main[$row['image_name']] = $row['image_filename'] . ($row['image_height'] ? '*' . $row['image_height']: '') . ($row['image_width'] ? '*' . $row['image_width']: '');

- }

- $db->sql_freeresult($result);

-

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

- {

- foreach ($key_array as $key)

- {

- if (isset($imageset_main[$key]))

- {

- $imageset_cfg .= "\nimg_" . $key . ' = ' . str_replace("styles/{$style_row['imageset_path']}/imageset/", '{PATH}', $imageset_main[$key]);

- }

- }

- }

-

- $files[] = array(

- 'src' => "styles/{$style_row['imageset_path']}/imageset/",

- 'prefix-' => "styles/{$style_row['imageset_path']}/",

- 'prefix+' => false,

- 'exclude' => 'imageset.cfg'

- );

-

- $data[] = array(

- 'src' => trim($imageset_cfg),

- 'prefix' => 'imageset/imageset.cfg'

- );

-

- end($data);

-

- $imageset_root = "{$phpbb_root_path}styles/{$style_row['imageset_path']}/imageset/";

-

- if ($dh = @opendir($imageset_root))

- {

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

- {

- if ($fname[0] != '.' && $fname != 'CVS' && is_dir("$imageset_root$fname"))

- {

- $files[key($files)]['exclude'] .= ',' . $fname . '/imageset.cfg';

- }

- }

- closedir($dh);

- }

-

- $imageset_lang = array();

-

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

- FROM ' . STYLES_IMAGESET_DATA_TABLE . "

- WHERE imageset_id = $style_id

- AND image_lang <> ''";

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

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

- {

- $imageset_lang[$row['image_lang']][$row['image_name']] = $row['image_filename'] . ($row['image_height'] ? '*' . $row['image_height']: '') . ($row['image_width'] ? '*' . $row['image_width']: '');

- }

- $db->sql_freeresult($result);

-

- foreach ($imageset_lang as $lang => $imageset_localized)

- {

- $imageset_cfg = str_replace(array('{MODE}', '{NAME}', '{COPYRIGHT}', '{VERSION}'), array($mode, $style_row['imageset_name'], $style_row['imageset_copyright'], $config['version']), $this->imageset_cfg);

-

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

- {

- foreach ($key_array as $key)

- {

- if (isset($imageset_localized[$key]))

- {

- $imageset_cfg .= "\nimg_" . $key . ' = ' . str_replace("styles/{$style_row['imageset_path']}/imageset/", '{PATH}', $imageset_localized[$key]);

- }

- }

- }

-

- $data[] = array(

- 'src' => trim($imageset_cfg),

- 'prefix' => 'imageset/' . $lang . '/imageset.cfg'

- );

- }

-

- unset($imageset_cfg);

- }

-

- $element_ary = array('template' => STYLES_TEMPLATE_TABLE, 'theme' => STYLES_THEME_TABLE, 'imageset' => STYLES_IMAGESET_TABLE);

-

- case 'imageset':

- $sql_from = STYLES_IMAGESET_TABLE;

- break;

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

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

- if ($mode == 'style' && (!$template_id || !$theme_id || !$imageset_id))

- if ($mode === 'theme' || $mode === 'template')

- {

- // a rather elaborate check we have to do here once to avoid trouble later

- $check = "{$phpbb_root_path}styles/" . $style_row["{$mode}_path"] . (($mode === 'theme') ? '/theme/stylesheet.css' : '/template');

- if (($style_row["{$mode}_storedb"] != $store_db) && !$store_db && ($safe_mode || !phpbb_is_writable($check)))

- {

- $error[] = $user->lang['EDIT_' . strtoupper($mode) . '_STORED_DB'];

- $store_db = 1;

- }

-

- // themes which have to be parsed have to go into db

- if ($mode == 'theme')

- {

- $cfg = parse_cfg_file("{$phpbb_root_path}styles/" . $style_row["{$mode}_path"] . "/theme/theme.cfg");

-

- if (isset($cfg['parse_css_file']) && $cfg['parse_css_file'] && !$store_db)

- {

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

- $store_db = 1;

- }

- }

- }

-

- 'imageset_id' => $imageset_id,

- $mode . '_storedb' => $store_db,

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

- case 'imageset':

- break;

-

-

- if ($style_row['theme_storedb'] != $store_db)

- {

- $theme_data = '';

-

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

- {

- $theme_data = $this->db_theme_data($style_row);

- }

- else if (!$store_db && !$safe_mode && phpbb_is_writable("{$phpbb_root_path}styles/{$style_row['theme_path']}/theme/stylesheet.css"))

- {

- $store_db = 1;

- $theme_data = $style_row['theme_data'];

-

- if ($fp = @fopen("{$phpbb_root_path}styles/{$style_row['theme_path']}/theme/stylesheet.css", 'wb'))

- {

- $store_db = (@fwrite($fp, str_replace("styles/{$style_row['theme_path']}/theme/", './', $theme_data))) ? 0 : 1;

- }

- fclose($fp);

- }

-

- $sql_ary += array(

- 'theme_mtime' => ($store_db) ? filemtime("{$phpbb_root_path}styles/{$style_row['theme_path']}/theme/stylesheet.css") : 0,

- 'theme_storedb' => $store_db,

- 'theme_data' => ($store_db) ? $theme_data : '',

- );

- }

-

- if ($style_row['template_storedb'] != $store_db)

- {

- if ($super = $this->get_super($mode, $style_row['template_id']))

- {

- $error[] = (sprintf($user->lang["{$l_type}_INHERITS"], $super['template_name']));

- $sql_ary = array();

- }

- else

- {

- if (!$store_db && !$safe_mode && phpbb_is_writable("{$phpbb_root_path}styles/{$style_row['template_path']}/template"))

- {

- $err = $this->store_in_fs('template', $style_row['template_id']);

- if ($err)

- {

- $error += $err;

- }

- }

- else if ($store_db)

- {

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

- }

- else

- {

- // We no longer store within the db, but are also not able to update the file structure

- // Since the admin want to switch this, we adhere to his decision. But we also need to remove the cache

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

- WHERE template_id = $style_id";

- $db->sql_query($sql);

- }

-

- $sql_ary += array(

- 'template_storedb' => $store_db,

- );

- }

- }

- 'S_IMAGESET' => ($mode == 'imageset') ? true : false,

- 'S_STORE_DB' => (isset($style_row[$mode . '_storedb'])) ? $style_row[$mode . '_storedb'] : 0,

- 'S_STORE_DB_DISABLED' => (isset($style_row[$mode . '_inherits_id'])) ? $style_row[$mode . '_inherits_id'] : 0,

- 'S_IMAGESET_OPTIONS' => ($mode == 'style') ? $imageset_options : '',

- 'L_LOCATION' => ($mode == 'template' || $mode == 'theme') ? $user->lang[$l_type . '_LOCATION'] : '',

- 'L_LOCATION_EXPLAIN' => ($mode == 'template' || $mode == 'theme') ? $user->lang[$l_type . '_LOCATION_EXPLAIN'] : '',

- * Store template files into db

- */

- function store_templates($mode, $style_id, $template_path, $filelist)

- {

- global $phpbb_root_path, $phpEx, $db;

-

- $template_path = $template_path . '/template/';

- $includes = array();

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

- {

- foreach ($file_ary as $file)

- {

- if (!($fp = @fopen("{$phpbb_root_path}styles/$template_path$pathfile$file", 'r')))

- {

- trigger_error("Could not open {$phpbb_root_path}styles/$template_path$pathfile$file", E_USER_ERROR);

- }

-

- $filesize = filesize("{$phpbb_root_path}styles/$template_path$pathfile$file");

-

- if ($filesize)

- {

- $template_data = fread($fp, $filesize);

- }

-

- fclose($fp);

-

- if (!$filesize)

- {

- // File is empty

- continue;

- }

-

- if (preg_match_all('#<!-- INCLUDE (.*?\.html) -->#is', $template_data, $matches))

- {

- foreach ($matches[1] as $match)

- {

- $includes[trim($match)][] = $file;

- }

- }

- }

- }

-

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

- {

- foreach ($file_ary as $file)

- {

- // Skip index.

- if (strpos($file, 'index.') === 0)

- {

- continue;

- }

-

- // We could do this using extended inserts ... but that could be one

- // heck of a lot of data ...

- $sql_ary = array(

- 'template_id' => (int) $style_id,

- 'template_filename' => "$pathfile$file",

- 'template_included' => (isset($includes[$file])) ? implode(':', $includes[$file]) . ':' : '',

- 'template_mtime' => (int) filemtime("{$phpbb_root_path}styles/$template_path$pathfile$file"),

- 'template_data' => (string) file_get_contents("{$phpbb_root_path}styles/$template_path$pathfile$file"),

- );

-

- if ($mode == 'insert')

- {

- $sql = 'INSERT INTO ' . STYLES_TEMPLATE_DATA_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);

- }

- else

- {

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

- WHERE template_id = $style_id

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

- }

- $db->sql_query($sql);

- }

- }

- }

-

- /**

- * Install Style/Template/Theme/Imageset

- $element_ary = array('template' => STYLES_TEMPLATE_TABLE, 'theme' => STYLES_THEME_TABLE, 'imageset' => STYLES_IMAGESET_TABLE);

- $reqd_imageset = (isset($installcfg['required_imageset'])) ? $installcfg['required_imageset'] : false;

- foreach (array('inherit_from', 'parse_css_file') as $key)

-

- case 'imageset':

- $this->test_installed('imageset', $error, $root_path, false, $style_row['imageset_id'], $style_row['imageset_name'], $style_row['imageset_copyright']);

- break;

- $style_row['store_db'] = request_var('store_db', 0);

- $this->install_style($error, 'install', $root_path, $style_row['style_id'], $style_row['style_name'], $install_path, $style_row['style_copyright'], $style_row['style_active'], $style_row['style_default'], $style_row, $template_root_path, $template_path, $theme_root_path, $theme_path, $imageset_root_path, $imageset_path);

- $style_row['store_db'] = $this->install_element($mode, $error, 'install', $root_path, $style_row[$mode . '_id'], $style_row[$mode . '_name'], $install_path, $style_row[$mode . '_copyright'], $style_row['store_db']);

- $message = ($style_row['store_db']) ? '_ADDED_DB' : '_ADDED';

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

- 'S_STORE_DB' => (isset($style_row[$mode . '_storedb'])) ? $style_row[$mode . '_storedb'] : 0,

- 'L_LOCATION' => ($mode == 'template' || $mode == 'theme') ? $user->lang[$l_type . '_LOCATION'] : '',

- 'L_LOCATION_EXPLAIN' => ($mode == 'template' || $mode == 'theme') ? $user->lang[$l_type . '_LOCATION_EXPLAIN'] : '',

- 'THEME_NAME' => ($mode == 'style') ? $style_row['theme_name'] : '',

- 'IMAGESET_NAME' => ($mode == 'style') ? $style_row['imageset_name'] : '')

- $element_ary = array('template' => STYLES_TEMPLATE_TABLE, 'theme' => STYLES_THEME_TABLE, 'imageset' => STYLES_IMAGESET_TABLE);

- 'imageset_id' => 0,

- 'store_db' => request_var('store_db', 0),

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

-

- case 'imageset':

- $sql_select = 'imageset_id';

- $sql_from = STYLES_IMAGESET_TABLE;

- break;

- $style_row['imageset_id'] = (isset($row['imageset_id'])) ? $row['imageset_id'] : $style_row['imageset_id'];

- $style_row['imageset_id'] = request_var('imageset_id', $style_row['imageset_id']);

- if ($mode == 'style' && (!$style_row['template_id'] || !$style_row['theme_id'] || !$style_row['imageset_id']))

- $message = ($style_row['store_db']) ? '_ADDED_DB' : '_ADDED';

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

- 'S_STORE_DB' => (isset($style_row['storedb'])) ? $style_row['storedb'] : 0,

- 'S_IMAGESET_OPTIONS' => ($mode == 'style') ? $imageset_options : '',

- 'L_LOCATION' => ($mode == 'template' || $mode == 'theme') ? $user->lang[$l_type . '_LOCATION'] : '',

- 'L_LOCATION_EXPLAIN' => ($mode == 'template' || $mode == 'theme') ? $user->lang[$l_type . '_LOCATION_EXPLAIN'] : '',

- $reqd_imageset = (isset($installcfg['required_imageset'])) ? $installcfg['required_imageset'] : false;

-

- case 'imageset':

- $sql_from = STYLES_IMAGESET_TABLE;

- break;

- function install_style(&$error, $action, $root_path, &$id, $name, $path, $copyright, $active, $default, &$style_row, $template_root_path = false, $template_path = false, $theme_root_path = false, $theme_path = false, $imageset_root_path = false, $imageset_path = false)

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

- if (!$style_row['template_id'] || !$style_row['theme_id'] || !$style_row['imageset_id'])

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

- function install_element($mode, &$error, $action, $root_path, &$id, $name, $path, $copyright, $store_db = 0)

-

- case 'imageset':

- $sql_from = STYLES_IMAGESET_TABLE;

- break;

- $sql = "SELECT {$mode}_id, {$mode}_name, {$mode}_path, {$mode}_storedb $select_bf

- $cfg_data['store_db'] = $row["{$mode}_storedb"];

- $store_db = $row["{$mode}_storedb"];

- $sql_ary['bbcode_bitfield'] = TEMPLATE_BITFIELD;

- // We set a pre-defined bitfield here which we may use further in 3.2

- $sql_ary += array(

- 'template_storedb' => $store_db,

- );

- // We are only interested in the theme configuration for now

-

- if (isset($cfg_data['parse_css_file']) && $cfg_data['parse_css_file'])

- {

- $store_db = 1;

- }

-

- $sql_ary += array(

- 'theme_storedb' => $store_db,

- 'theme_data' => ($store_db) ? $this->db_theme_data($sql_ary, false, $root_path) : '',

- 'theme_mtime' => (int) filemtime("{$phpbb_root_path}styles/$path/theme/stylesheet.css")

- );

- break;

-

- // all the heavy lifting is done later

- case 'imageset':

- if ($mode == 'template' && $store_db)

- {

- $filelist = filelist("{$root_path}template", '', 'html');

- $this->store_templates('insert', $id, $path, $filelist);

- }

- else if ($mode == 'imageset')

- {

- $cfg_data = parse_cfg_file("$root_path$mode/imageset.cfg");

-

- $imageset_definitions = array();

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

- {

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

- }

-

- foreach ($cfg_data as $key => $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($key, 'img_') === 0 && $image_filename)

- {

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

- if (in_array($key, $imageset_definitions))

- {

- $sql_ary = array(

- 'image_name' => $key,

- 'image_filename' => str_replace('{PATH}', "styles/$path/imageset/", trim($image_filename)),

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

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

- 'imageset_id' => (int) $id,

- 'image_lang' => '',

- );

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

- }

- }

- }

- unset($cfg_data);

-

- $sql = 'SELECT lang_dir

- FROM ' . LANG_TABLE;

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

-

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

- {

- if (@file_exists("$root_path$mode/{$row['lang_dir']}/imageset.cfg"))

- {

- $cfg_data_imageset_data = parse_cfg_file("$root_path$mode/{$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' => $image_name,

- 'image_filename' => $image_filename,

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

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

- 'imageset_id' => (int) $id,

- 'image_lang' => $row['lang_dir'],

- );

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

- }

- }

- }

- unset($cfg_data_imageset_data);

- }

- }

- $db->sql_freeresult($result);

- }

-

- $log = ($store_db) ? 'LOG_' . $l_type . '_ADD_DB' : 'LOG_' . $l_type . '_ADD_FS';

- add_log('admin', $log, $name);

-

- // Return store_db in case it had to be altered

- return $store_db;

-

- case 'imageset':

- $sql_from = STYLES_IMAGESET_TABLE;

- break;

-

- case 'imageset':

- $sql_from = STYLES_IMAGESET_TABLE;

- break;

-

- /**

- * Moves a template set and its subtemplates to the database

- *

- * @access public

- * @param string $mode The component to move - only template is supported

- * @param int $id The template id

- */

- function store_in_db($mode, $id)

- {

- global $db, $user;

-

- $error = array();

- $l_type = strtoupper($mode);

- if ($super = $this->get_super($mode, $id))

- {

- $error[] = (sprintf($user->lang["{$l_type}_INHERITS"], $super['template_name']));

- return $error;

- }

-

- $sql = "SELECT {$mode}_id, {$mode}_name, {$mode}_path

- FROM " . STYLES_TEMPLATE_TABLE . '

- WHERE template_id = ' . (int) $id;

-

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

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

- {

- $db->sql_freeresult($result);

- $subs = $this->check_inheritance($mode, $id);

-

- $this->_store_in_db($mode, $id, $row["{$mode}_path"]);

- if ($subs && sizeof($subs))

- {

- foreach ($subs as $sub_id => $sub)

- {

- if ($err = $this->_store_in_db($mode, $sub["{$mode}_id"], $sub["{$mode}_path"]))

- {

- $error[] = $err;

- }

- }

- }

- }

- if (sizeof($error))

- {

- return $error;

- }

-

- return false;

- }

-

- /**

- * Moves a template set to the database

- *

- * @access private

- * @param string $mode The component to move - only template is supported

- * @param int $id The template id

- * @param string $path TThe path to the template files

- */

- function _store_in_db($mode, $id, $path)

- {

- global $phpbb_root_path, $db;

-

- $filelist = filelist("{$phpbb_root_path}styles/{$path}/template", '', 'html');

- $this->store_templates('insert', $id, $path, $filelist);

-

- // Okay, we do the query here -shouldn't be triggered often.

- $sql = 'UPDATE ' . STYLES_TEMPLATE_TABLE . '

- SET template_storedb = 1

- WHERE template_id = ' . $id;

- $db->sql_query($sql);

- }

-

- /**

- * Moves a template set and its subtemplates to the filesystem

- *

- * @access public

- * @param string $mode The component to move - only template is supported

- * @param int $id The template id

- */

- function store_in_fs($mode, $id)

- {

- global $db, $user;

-

- $error = array();

- $l_type = strtoupper($mode);

- if ($super = $this->get_super($mode, $id))

- {

- $error[] = (sprintf($user->lang["{$l_type}_INHERITS"], $super['template_name']));

- return($error);

- }

-

- $sql = "SELECT {$mode}_id, {$mode}_name, {$mode}_path

- FROM " . STYLES_TEMPLATE_TABLE . '

- WHERE template_id = ' . (int) $id;

-

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

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

- {

- $db->sql_freeresult($result);

- if (!sizeof($error))

- {

- $subs = $this->check_inheritance($mode, $id);

-

- $this->_store_in_fs($mode, $id, $row["{$mode}_path"]);

-

- if ($subs && sizeof($subs))

- {

- foreach ($subs as $sub_id => $sub)

- {

- $this->_store_in_fs($mode, $sub["{$mode}_id"], $sub["{$mode}_path"]);

- }

- }

- }

- if (sizeof($error))

- {

- $this->store_in_db($id, $mode);

- return $error;

- }

- }

- return false;

- }

-

- /**

- * Moves a template set to the filesystem

- *

- * @access private

- * @param string $mode The component to move - only template is supported

- * @param int $id The template id

- * @param string $path The path to the template

- */

- function _store_in_fs($mode, $id, $path)

- {

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

-

- $store_db = 0;

- $error = array();

- if (!$safe_mode && phpbb_is_writable("{$phpbb_root_path}styles/{$path}/template"))

- {

- $sql = 'SELECT *

- FROM ' . STYLES_TEMPLATE_DATA_TABLE . "

- WHERE template_id = $id";

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

-

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

- {

- if (!($fp = @fopen("{$phpbb_root_path}styles/{$path}/template/" . $row['template_filename'], 'wb')))

- {

- $store_db = 1;

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

- break;

- }

-

- fwrite($fp, $row['template_data']);

- fclose($fp);

- }

- $db->sql_freeresult($result);

-

- if (!$store_db)

- {

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

- WHERE template_id = $id";

- $db->sql_query($sql);

- }

- }

- if (sizeof($error))

- {

- return $error;

- }

- $sql = 'UPDATE ' . STYLES_TEMPLATE_TABLE . '

- SET template_storedb = 0

- WHERE template_id = ' . $id;

- $db->sql_query($sql);

-

- return false;

- }

-

- $info = obtain_latest_version_info(request_var('versioncheck_force', false), true);

- $up_to_date_automatic = (version_compare(str_replace('rc', 'RC', strtolower($current_version)), str_replace('rc', 'RC', strtolower($latest_version)), '<')) ? false : true;

- $up_to_date = (version_compare(str_replace('rc', 'RC', strtolower($config['version'])), str_replace('rc', 'RC', strtolower($latest_version)), '<')) ? false : true;

-

- 'S_UP_TO_DATE' => $up_to_date,

- 'S_UP_TO_DATE_AUTO' => $up_to_date_automatic,

- $update_password = ($data['new_password'] && !phpbb_check_hash($user_row['user_password'], $data['new_password'])) ? true : false;

- view_log('user', $log_data, $log_count, $config['topics_per_page'], $start, 0, 0, $user_id, $sql_where, $sql_sort);

- 'orphan' => array('title' => 'ACP_ORPHAN_ATTACHMENTS', 'auth' => 'acl_a_attach', 'cat' => array('ACP_ATTACHMENTS'))

- 'imageset' => array('title' => 'ACP_IMAGESETS', 'auth' => 'acl_a_styles', 'cat' => array('ACP_STYLE_COMPONENTS')),