-// the acp template is never stored in the database

-$user->theme['template_storedb'] = false;

-

- <dl>

- <dt><label for="new_imageset_id">{L_DELETE_IMAGESET}:</label><br /><span>{L_REPLACE_IMAGESET_EXPLAIN}</span></dt>

- <dd><select id="new_imageset_id" name="new_imageset_id">{S_REPLACE_IMAGESET_OPTIONS}</select></dd>

- </dl>

-<!-- ELSEIF S_EDIT_IMAGESET -->

-

- <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

-

- <h1>{L_TITLE}</h1>

-

- <p>{L_EXPLAIN}</p>

-

- <!-- IF SUCCESS -->

- <div class="successbox">

- <p>{L_IMAGESET_UPDATED}</p>

- </div>

- <!-- ENDIF -->

-

- <!-- IF ERROR -->

- <div class="errorbox">

- <p>{L_NO_IMAGE}</p>

- </div>

- <!-- ENDIF -->

-

- <script type="text/javascript" defer="defer">

- // <![CDATA[

- function update_image(newimage)

- {

- document.getElementById('newimg').src = (newimage) ? '../styles/{A_PATH}/imageset/' + encodeURI(newimage) : 'images/no_image.png';

- }

- // ]]>

- </script>

- <script type="text/javascript">

- // <![CDATA[

- /**

- * Handle displaying/hiding the dimension fields

- */

- function display_options(value)

- {

- if (value == 0)

- {

- dE('img_dimensions', -1);

- }

- else

- {

- dE('img_dimensions', 1);

- }

- }

-

- /**

- * Init the wanted display functionality if javascript is enabled.

- * If javascript is not available, the user is still able to properly administer.

- */

- onload = function()

- {

- <!-- IF not IMAGE_SIZE -->

- dE('img_dimensions', -1);

- <!-- ENDIF -->

- }

- // ]]>

- </script>

-

- <form method="post" action="{U_ACTION}">

-

- <fieldset class="quick" style="text-align: left;">

- <legend>{L_SELECT_IMAGE}</legend>

- {L_SELECT_IMAGE}: <select name="imgname" onchange="this.form.submit();">

- <!-- BEGIN category -->

- <option class="sep" value="" disabled="disabled">{category.NAME}</option>

- <!-- BEGIN images --><option value="{category.images.VALUE}"<!-- IF category.images.SELECTED--> selected="selected"<!-- ENDIF -->>&nbsp;&nbsp;&nbsp;&nbsp;{category.images.TEXT}</option>

- <!-- END images -->

- <!-- END category -->

- </select>&nbsp; <input class="button1" type="submit" value="{L_SELECT}" tabindex="100" />

- </fieldset>

-

- <fieldset>

- <legend>{L_EDIT_IMAGESET}</legend>

- <dl>

- <dt><label>{L_CURRENT_IMAGE}:</label></dt>

- <dd><img src="<!-- IF IMAGE_REQUEST -->{IMAGE_REQUEST}<!-- ELSE -->images/no_image.png<!-- ENDIF -->" alt="" /></dd>

- </dl>

- <dl>

- <dt><label>{L_SELECTED_IMAGE}:</label></dt>

- <dd><img src="{IMG_SRC}" id="newimg" alt="" /></dd>

- </dl>

- </fieldset>

-

- <fieldset>

- <legend>{L_IMAGE}</legend>

- <dl>

- <dt><label for="imgpath">{L_IMAGE}:</label></dt>

- <dd><select id="imgpath" name="imgpath" onchange="update_image(this.options[selectedIndex].value);"><option value=""<!-- IF not IMAGE_SELECT--> selected="selected"<!-- ENDIF -->>{L_NO_IMAGE}</option>

- <!-- BEGIN imagesetlist -->

- <option class="sep" value=""><!-- IF imagesetlist.TYPE -->{L_LOCALISED_IMAGES}<!-- ELSE -->{L_GLOBAL_IMAGES}<!-- ENDIF --></option>

- <!-- BEGIN images -->

- <option value="{imagesetlist.images.VALUE}"<!-- IF imagesetlist.images.SELECTED--> selected="selected"<!-- ENDIF -->>{imagesetlist.images.TEXT}</option>

- <!-- END images -->

- <!-- END imagesetlist -->

- </select>

- </dd>

- </dl>

- <dl>

- <dt><label for="imgsize">{L_INCLUDE_DIMENSIONS}:</label><br /><span>{L_DIMENSIONS_EXPLAIN}</span></dt>

- <dd><label><input type="radio" class="radio" name="imgsize" id="imgsize" onclick="display_options(1);" value="1"<!-- IF IMAGE_SIZE --> checked="checked"<!-- ENDIF --> /> {L_YES}</label>

- <label><input type="radio" class="radio" name="imgsize" onclick="display_options(0);" value="0"<!-- IF not IMAGE_SIZE --> checked="checked"<!-- ENDIF --> /> {L_NO}</label></dd>

- </dl>

- <div id="img_dimensions">

- <dl>

- <dt><label for="imgwidth">{L_IMAGE_WIDTH}:</label><br /><span>{L_AUTOMATIC_EXPLAIN}</span></dt>

- <dd><input id="imgwidth" type="text" name="imgwidth" value="{IMAGE_SIZE}" /></dd>

- </dl>

- <dl>

- <dt><label for="imgheight">{L_IMAGE_HEIGHT}:</label><br /><span>{L_AUTOMATIC_EXPLAIN}</span></dt>

- <dd><input id="imgheight" type="text" name="imgheight" value="{IMAGE_HEIGHT}" /></dd>

- </dl>

- </div>

- </fieldset>

-

- <fieldset class="submit-buttons">

- <legend>{L_SUBMIT}</legend>

- <input class="button1" type="submit" name="update" value="{L_SUBMIT}" />&nbsp;&nbsp;<input class="button2" type="reset" value="{L_RESET}" />

- {S_FORM_TOKEN}

- </fieldset>

- </form>

-

- <dl>

- <dt><label for="inc_imageset">{L_INCLUDE_IMAGESET}:</label></dt>

- <dd><label><input type="radio" class="radio" id="inc_imageset" name="inc_imageset" value="1" checked="checked" /> {L_YES}</label>

- <label><input type="radio" class="radio" name="inc_imageset" value="0" /> {L_NO}</label></dd>

- </dl>

- <dl>

- <dt><label for="imageset_id">{L_STYLE_IMAGESET}:</label></dt>

- <dd><!-- IF S_INSTALL --><strong id="imageset_id">{IMAGESET_NAME}</strong><!-- ELSE --><select id="imageset_id" name="imageset_id">{S_IMAGESET_OPTIONS}</select><!-- ENDIF --></dd>

- </dl>

- <!-- ENDIF -->

- <!-- IF (S_TEMPLATE or S_THEME) and (S_LOCATION or not S_INSTALL) -->

- <dl>

- <dt><label for="store_db">{L_LOCATION}:</label><br /><span><!-- IF S_STORE_DB_DISABLED -->{L_LOCATION_DISABLED_EXPLAIN}<!-- ELSE -->{L_LOCATION_EXPLAIN}<!-- ENDIF --></span></dt>

- <dd><label><input type="radio" class="radio" name="store_db" value="0"<!-- IF not S_STORE_DB --> id="store_db" checked="checked"<!-- ENDIF --> <!-- IF S_STORE_DB_DISABLED -->disabled="disabled" <!-- ENDIF --> />{L_STORE_FILESYSTEM}</label>

- <label><input type="radio" class="radio" name="store_db" value="1"<!-- IF S_STORE_DB --> id="store_db" checked="checked"<!-- ENDIF --> <!-- IF S_STORE_DB_DISABLED -->disabled="disabled" <!-- ENDIF -->/> {L_STORE_DATABASE}</label></dd>

- </dl>

- 'template_storedb' => array('BOOL', 0),

- $schema_data['phpbb_styles_template_data'] = array(

- 'COLUMNS' => array(

- 'template_id' => array('UINT', 0),

- 'template_filename' => array('VCHAR:100', ''),

- 'template_included' => array('TEXT', ''),

- 'template_mtime' => array('TIMESTAMP', 0),

- 'template_data' => array('MTEXT_UNI', ''),

- ),

- 'KEYS' => array(

- 'tid' => array('INDEX', 'template_id'),

- 'tfn' => array('INDEX', 'template_filename'),

- ),

- );

-

- 'theme_storedb' => array('BOOL', 0),

- 'theme_mtime' => array('TIMESTAMP', 0),

- 'theme_data' => array('MTEXT_UNI', ''),

- 'imageset_id' => array('UINT', 0),

- 'imageset_id' => array('INDEX', 'imageset_id'),

- $schema_data['phpbb_styles_imageset'] = array(

- 'COLUMNS' => array(

- 'imageset_id' => array('UINT', NULL, 'auto_increment'),

- 'imageset_name' => array('VCHAR_UNI:255', ''),

- 'imageset_copyright' => array('VCHAR_UNI', ''),

- 'imageset_path' => array('VCHAR:100', ''),

- ),

- 'PRIMARY_KEY' => 'imageset_id',

- 'KEYS' => array(

- 'imgset_nm' => array('UNIQUE', 'imageset_name'),

- ),

- );

-

- $schema_data['phpbb_styles_imageset_data'] = array(

- 'COLUMNS' => array(

- 'image_id' => array('UINT', NULL, 'auto_increment'),

- 'image_name' => array('VCHAR:200', ''),

- 'image_filename' => array('VCHAR:200', ''),

- 'image_lang' => array('VCHAR:30', ''),

- 'image_height' => array('USINT', 0),

- 'image_width' => array('USINT', 0),

- 'imageset_id' => array('UINT', 0),

- ),

- 'PRIMARY_KEY' => 'image_id',

- 'KEYS' => array(

- 'i_d' => array('INDEX', 'imageset_id'),

- ),

- );

-

- 'FEED_IMAGE' => ($user->img('site_logo', '', false, '', 'src')) ? $board_url . '/' . substr($user->img('site_logo', '', false, '', 'src'), strlen($phpbb_root_path)) : '',

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

- }

-

- var $imageset_cfg;

- var $imageset_keys;

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

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

-

- case 'imageset':

- $sql_from = STYLES_IMAGESET_TABLE;

- break;

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

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

- }

-

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

- $text .= "Errno $errno: $msg_text";

- if (defined('DEBUG_EXTRA') || defined('IN_INSTALL'))

- {

- $text .= " at $errfile line $errline";

- }

-* Return a nicely formatted backtrace (parts from the php manual by diz at ysagoon dot com)

- global $phpbb_root_path;

-

- $path = phpbb_realpath($phpbb_root_path);

- foreach ($backtrace as $number => $trace)

- {

- // We skip the first one, because it only shows this file/function

- if ($number == 0)

- {

- continue;

- }

- if (empty($trace['file']))

- {

- $trace['file'] = '';

- }

- else

- {

- $trace['file'] = str_replace(array($path, '\\'), array('', '/'), $trace['file']);

- $trace['file'] = substr($trace['file'], 1);

- }

- $args = array();

- // If include/require/include_once is not called, do not show arguments - they may contain sensible information

- if (!in_array($trace['function'], array('include', 'require', 'include_once')))

- {

- unset($trace['args']);

- }

- else

- // Path...

- if (!empty($trace['args'][0]))

- {

- $argument = htmlspecialchars($trace['args'][0]);

- $argument = str_replace(array($path, '\\'), array('', '/'), $argument);

- $argument = substr($argument, 1);

- $args[] = "'{$argument}'";

- }

- $output .= '<b>FILE:</b> ' . htmlspecialchars($trace['file']) . '<br />';

- $output .= '<b>CALL:</b> ' . htmlspecialchars($trace['class'] . $trace['type'] . $trace['function']) . '(' . ((sizeof($args)) ? implode(', ', $args) : '') . ')<br />';

- // remove complete path to installation, with the risk of changing backslashes meant to be there

- $errfile = str_replace(array(phpbb_realpath($phpbb_root_path), '\\'), array('', '/'), $errfile);

- $msg_text = str_replace(array(phpbb_realpath($phpbb_root_path), '\\'), array('', '/'), $msg_text);

- 'T_IMAGESET_PATH' => "{$web_path}styles/" . $user->theme['imageset_path'] . '/imageset',

- 'T_IMAGESET_LANG_PATH' => "{$web_path}styles/" . $user->theme['imageset_path'] . '/imageset/' . $user->lang_name,

- 'T_STYLESHEET_LINK' => (!$user->theme['theme_storedb']) ? "{$web_path}styles/" . $user->theme['theme_path'] . '/theme/stylesheet.css' : append_sid("{$phpbb_root_path}style.$phpEx", 'id=' . $user->theme['style_id'] . '&amp;lang=' . $user->lang_name),

- 'T_IMAGESET_NAME' => $user->theme['imageset_path'],

- 'T_IMAGESET_LANG_NAME' => $user->data['user_lang'],

- 'FORUM_FOLDER_IMG_SRC' => $user->img($folder_image, $folder_alt, false, '', 'src'),

- ob_start();

- $error_contents = ob_get_clean();

- global $config;

- ob_start();

- $err_msg = ob_get_clean();

- 'TOPIC_FOLDER_IMG_SRC' => $user->img($folder_img, $folder_alt, false, '', 'src'),

- $sql = 'SELECT s.style_id, t.template_storedb, t.template_path, t.template_id, t.bbcode_bitfield, t.template_inherits_id, t.template_inherit_path, c.theme_path, c.theme_name, c.theme_storedb, c.theme_id, i.imageset_path, i.imageset_id, i.imageset_name

- FROM ' . STYLES_TABLE . ' s, ' . STYLES_TEMPLATE_TABLE . ' t, ' . STYLES_THEME_TABLE . ' c, ' . STYLES_IMAGESET_TABLE . " i

- AND c.theme_id = s.theme_id

- AND i.imageset_id = s.imageset_id";

- $sql = 'SELECT s.style_id, t.template_storedb, t.template_path, t.template_id, t.bbcode_bitfield, c.theme_path, c.theme_name, c.theme_storedb, c.theme_id, i.imageset_path, i.imageset_id, i.imageset_name

- FROM ' . STYLES_TABLE . ' s, ' . STYLES_TEMPLATE_TABLE . ' t, ' . STYLES_THEME_TABLE . ' c, ' . STYLES_IMAGESET_TABLE . " i

- AND c.theme_id = s.theme_id

- AND i.imageset_id = s.imageset_id";

- 'parse_css_file' => (int) 0,

- // If the style author specified the theme needs to be cached

- // (because of the used paths and variables) than make sure it is the case.

- // For example, if the theme uses language-specific images it needs to be stored in db.

- if (!$this->theme['theme_storedb'] && $this->theme['parse_css_file'])

- {

- $this->theme['theme_storedb'] = 1;

-

- $stylesheet = file_get_contents("{$phpbb_root_path}styles/{$this->theme['theme_path']}/theme/stylesheet.css");

- // Match CSS imports

- $matches = array();

- preg_match_all('/@import url\(["\'](.*)["\']\);/i', $stylesheet, $matches);

-

- if (sizeof($matches))

- {

- $content = '';

- foreach ($matches[0] as $idx => $match)

- {

- if ($content = @file_get_contents("{$phpbb_root_path}styles/{$this->theme['theme_path']}/theme/" . $matches[1][$idx]))

- {

- $content = trim($content);

- }

- else

- {

- $content = '';

- }

- $stylesheet = str_replace($match, $content, $stylesheet);

- }

- unset($content);

- }

-

- $stylesheet = str_replace('./', 'styles/' . $this->theme['theme_path'] . '/theme/', $stylesheet);

-

- $sql_ary = array(

- 'theme_data' => $stylesheet,

- 'theme_mtime' => time(),

- 'theme_storedb' => 1

- );

-

- $sql = 'UPDATE ' . STYLES_THEME_TABLE . '

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

- WHERE theme_id = ' . $this->theme['theme_id'];

- $db->sql_query($sql);

-

- unset($sql_ary);

- }

-

- $this->img_lang = (file_exists($phpbb_root_path . 'styles/' . $this->theme['imageset_path'] . '/imageset/' . $this->lang_name)) ? $this->lang_name : $config['default_lang'];

-

- // Same query in style.php

- $sql = 'SELECT *

- FROM ' . STYLES_IMAGESET_DATA_TABLE . '

- WHERE imageset_id = ' . $this->theme['imageset_id'] . "

- AND image_filename <> ''

- AND image_lang IN ('" . $db->sql_escape($this->img_lang) . "', '')";

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

-

- $localised_images = false;

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

- {

- if ($row['image_lang'])

- {

- $localised_images = true;

- }

-

- $row['image_filename'] = rawurlencode($row['image_filename']);

- $this->img_array[$row['image_name']] = $row;

- }

- $db->sql_freeresult($result);

-

- // there were no localised images, try to refresh the localised imageset for the user's language

- if (!$localised_images)

- {

- // Attention: this code ignores the image definition list from acp_styles and just takes everything

- // that the config file contains

- $sql_ary = array();

-

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

-

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

- WHERE imageset_id = ' . $this->theme['imageset_id'] . '

- AND image_lang = \'' . $db->sql_escape($this->img_lang) . '\'';

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

-

- if (@file_exists("{$phpbb_root_path}styles/{$this->theme['imageset_path']}/imageset/{$this->img_lang}/imageset.cfg"))

- {

- $cfg_data_imageset_data = parse_cfg_file("{$phpbb_root_path}styles/{$this->theme['imageset_path']}/imageset/{$this->img_lang}/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);

- $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) $this->theme['imageset_id'],

- 'image_lang' => (string) $this->img_lang,

- );

- }

- }

- }

-

- if (sizeof($sql_ary))

- {

- $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_LANG_REFRESHED', $this->theme['imageset_name'], $this->img_lang);

- }

- else

- {

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

- add_log('admin', 'LOG_IMAGESET_LANG_MISSING', $this->theme['imageset_name'], $this->img_lang);

- }

- }

- * $suffix is no longer used - we know it. ;) It is there for backward compatibility.

- function img($img, $alt = '', $width = false, $suffix = '', $type = 'full_tag')

- static $imgs;

- global $phpbb_root_path;

-

- $img_data = &$imgs[$img];

-

- if (empty($img_data))

- {

- if (!isset($this->img_array[$img]))

- {

- // Do not fill the image to let designers decide what to do if the image is empty

- $img_data = '';

- return $img_data;

- }

-

- // Use URL if told so

- $root_path = (defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH) ? generate_board_url() . '/' : $phpbb_root_path;

-

- $path = 'styles/' . rawurlencode($this->theme['imageset_path']) . '/imageset/' . ($this->img_array[$img]['image_lang'] ? $this->img_array[$img]['image_lang'] .'/' : '') . $this->img_array[$img]['image_filename'];

-

- $img_data['src'] = $root_path . $path;

- $img_data['width'] = $this->img_array[$img]['image_width'];

- $img_data['height'] = $this->img_array[$img]['image_height'];

-

- // We overwrite the width and height to the phpbb logo's width

- // and height here if the contents of the site_logo file are

- // really equal to the phpbb_logo

- // This allows us to change the dimensions of the phpbb_logo without

- // modifying the imageset.cfg and causing a conflict for everyone

- // who modified it for their custom logo on updating

- if ($img == 'site_logo' && file_exists($phpbb_root_path . $path))

- {

- global $cache;

-

- $img_file_hashes = $cache->get('imageset_site_logo_md5');

-

- if ($img_file_hashes === false)

- {

- $img_file_hashes = array();

- }

-

- $key = $this->theme['imageset_path'] . '::' . $this->img_array[$img]['image_lang'];

- if (!isset($img_file_hashes[$key]))

- {

- $img_file_hashes[$key] = md5(file_get_contents($phpbb_root_path . $path));

- $cache->put('imageset_site_logo_md5', $img_file_hashes);

- }

-

- $phpbb_logo_hash = '0c461a32cd3621643105f0d02a772c10';

-

- if ($phpbb_logo_hash == $img_file_hashes[$key])

- {

- $img_data['width'] = '149';

- $img_data['height'] = '52';

- }

- }

- }

-

-

- switch ($type)

- {

- case 'src':

- return $img_data['src'];

- break;

-

- case 'width':

- return ($width === false) ? $img_data['width'] : $width;

- break;

-

- case 'height':

- return $img_data['height'];

- break;

-

- default:

- $use_width = ($width === false) ? $img_data['width'] : $width;

-

- return '<img src="' . $img_data['src'] . '"' . (($use_width) ? ' width="' . $use_width . '"' : '') . (($img_data['height']) ? ' height="' . $img_data['height'] . '"' : '') . ' alt="' . $alt . '" title="' . $alt . '" />';

- break;

- }

- * Compile variables

- * @return string compiled template code

- private function compile_var_tags(&$text_blocks)

- $new = $this->generate_block_varref($namespace, $varname, true, $var_val[2]);

- // Handle special language tags L_ and LA_

- $this->compile_language_tags($text_blocks);

- // This will handle the remaining root-level varrefs

- $text_blocks = preg_replace('#\{(' . self::REGEX_VAR . ')\}#', "<?php echo (isset(\$_rootref['\\1'])) ? \$_rootref['\\1'] : ''; /**/?>", $text_blocks);

- $text_blocks = preg_replace('#\{\$(' . self::REGEX_VAR . ')\}#', "<?php echo (isset(\$_tpldata['DEFINE']['.']['\\1'])) ? \$_tpldata['DEFINE']['.']['\\1'] : ''; /**/?>", $text_blocks);

- $text_blocks = preg_replace('#\{L_(' . self::REGEX_VAR . ')\}#', "<?php echo ((isset(\$_rootref['L_\\1'])) ? \$_rootref['L_\\1'] : ((isset(\$_lang['\\1'])) ? \$_lang['\\1'] : '{ \\1 }')); /**/?>", $text_blocks);

- $text_blocks = preg_replace('#\{LA_(' . self::REGEX_VAR . '+)\}#', "<?php echo ((isset(\$_rootref['LA_\\1'])) ? \$_rootref['LA_\\1'] : ((isset(\$_rootref['L_\\1'])) ? addslashes(\$_rootref['L_\\1']) : ((isset(\$_lang['\\1'])) ? addslashes(\$_lang['\\1']) : '{ \\1 }'))); /**/?>", $text_blocks);

- * @param bool $echo If true return an echo statement, otherwise a reference to the internal variable

- private function generate_block_varref($namespace, $varname, $echo = true, $defop = false)

- $isset = false;

- $isset = true;

- $varref = ($echo) ? '<?php echo ' . ($isset ? "isset($varref) ? $varref : ''" : $varref) . '; /**/?>' : (($expr || isset($varref)) ? $varref : '');

- $this->cachepath = $this->phpbb_root_path . 'cache/ctpl_' . str_replace('_', '-', $style_name) . '_';

- 'TOPIC_FOLDER_IMG_SRC' => $user->img($folder_img, $folder_alt, false, '', 'src'),

- 'FORUM_FOLDER_IMG_SRC' => $user->img($folder_image, $folder_alt, false, '', 'src'),

- 'TOPIC_FOLDER_IMG_SRC' => $user->img($folder_img, $folder_alt, false, '', 'src'),

- 'FOLDER_IMG_SRC' => $user->img($folder_img, $folder_alt, false, '', 'src'),

-// the acp template is never stored in the database

-$user->theme['template_storedb'] = false;

-

-

- $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['lang_iso']}/imageset.cfg"))

- {

- $cfg_data_imageset_data = parse_cfg_file("{$phpbb_root_path}styles/{$imageset_row['imageset_path']}/imageset/{$lang_pack['lang_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['lang_iso'],

- );

- }

- }

- }

- }

- }

- $db->sql_freeresult($result);

-

- if (sizeof($sql_ary))

- {

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

-

- if ($db->sql_error_triggered)

- {

- $error = $db->sql_error($db->sql_error_sql);

- $this->p_master->db_error($error['message'], $db->sql_error_sql, __LINE__, __FILE__);

- }

- }

- // still, the acp template is never stored in the database

- $user->theme['template_storedb'] = false;

-

- theme_id INTEGER DEFAULT 0 NOT NULL,

- imageset_id INTEGER DEFAULT 0 NOT NULL

-CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles(imageset_id);;

- template_storedb INTEGER DEFAULT 0 NOT NULL,

-# Table: 'phpbb_styles_template_data'

-CREATE TABLE phpbb_styles_template_data (

- template_id INTEGER DEFAULT 0 NOT NULL,

- template_filename VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,

- template_included BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL,

- template_mtime INTEGER DEFAULT 0 NOT NULL,

- template_data BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL

-);;

-

-CREATE INDEX phpbb_styles_template_data_tid ON phpbb_styles_template_data(template_id);;

-CREATE INDEX phpbb_styles_template_data_tfn ON phpbb_styles_template_data(template_filename);;

-

- theme_path VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,

- theme_storedb INTEGER DEFAULT 0 NOT NULL,

- theme_mtime INTEGER DEFAULT 0 NOT NULL,

- theme_data BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL

-# Table: 'phpbb_styles_imageset'

-CREATE TABLE phpbb_styles_imageset (

- imageset_id INTEGER NOT NULL,

- imageset_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

- imageset_copyright VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

- imageset_path VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL

-);;

-

-ALTER TABLE phpbb_styles_imageset ADD PRIMARY KEY (imageset_id);;

-

-CREATE UNIQUE INDEX phpbb_styles_imageset_imgset_nm ON phpbb_styles_imageset(imageset_name);;

-

-CREATE GENERATOR phpbb_styles_imageset_gen;;

-SET GENERATOR phpbb_styles_imageset_gen TO 0;;

-

-CREATE TRIGGER t_phpbb_styles_imageset FOR phpbb_styles_imageset

-BEFORE INSERT

-AS

-BEGIN

- NEW.imageset_id = GEN_ID(phpbb_styles_imageset_gen, 1);

-END;;

-

-

-# Table: 'phpbb_styles_imageset_data'

-CREATE TABLE phpbb_styles_imageset_data (

- image_id INTEGER NOT NULL,

- image_name VARCHAR(200) CHARACTER SET NONE DEFAULT '' NOT NULL,

- image_filename VARCHAR(200) CHARACTER SET NONE DEFAULT '' NOT NULL,

- image_lang VARCHAR(30) CHARACTER SET NONE DEFAULT '' NOT NULL,

- image_height INTEGER DEFAULT 0 NOT NULL,

- image_width INTEGER DEFAULT 0 NOT NULL,

- imageset_id INTEGER DEFAULT 0 NOT NULL

-);;

-

-ALTER TABLE phpbb_styles_imageset_data ADD PRIMARY KEY (image_id);;

-

-CREATE INDEX phpbb_styles_imageset_data_i_d ON phpbb_styles_imageset_data(imageset_id);;

-

-CREATE GENERATOR phpbb_styles_imageset_data_gen;;

-SET GENERATOR phpbb_styles_imageset_data_gen TO 0;;

-

-CREATE TRIGGER t_phpbb_styles_imageset_data FOR phpbb_styles_imageset_data

-BEFORE INSERT

-AS

-BEGIN

- NEW.image_id = GEN_ID(phpbb_styles_imageset_data_gen, 1);

-END;;

-

-

- [theme_id] [int] DEFAULT (0) NOT NULL ,

- [imageset_id] [int] DEFAULT (0) NOT NULL

-CREATE INDEX [imageset_id] ON [phpbb_styles]([imageset_id]) ON [PRIMARY]

-GO

-

- [template_storedb] [int] DEFAULT (0) NOT NULL ,

- Table: 'phpbb_styles_template_data'

-*/

-CREATE TABLE [phpbb_styles_template_data] (

- [template_id] [int] DEFAULT (0) NOT NULL ,

- [template_filename] [varchar] (100) DEFAULT ('') NOT NULL ,

- [template_included] [varchar] (8000) DEFAULT ('') NOT NULL ,

- [template_mtime] [int] DEFAULT (0) NOT NULL ,

- [template_data] [text] DEFAULT ('') NOT NULL

-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

-GO

-

-CREATE INDEX [tid] ON [phpbb_styles_template_data]([template_id]) ON [PRIMARY]

-GO

-

-CREATE INDEX [tfn] ON [phpbb_styles_template_data]([template_filename]) ON [PRIMARY]

-GO

-

-

-/*

- [theme_path] [varchar] (100) DEFAULT ('') NOT NULL ,

- [theme_storedb] [int] DEFAULT (0) NOT NULL ,

- [theme_mtime] [int] DEFAULT (0) NOT NULL ,

- [theme_data] [text] DEFAULT ('') NOT NULL

-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

- Table: 'phpbb_styles_imageset'

-*/

-CREATE TABLE [phpbb_styles_imageset] (

- [imageset_id] [int] IDENTITY (1, 1) NOT NULL ,

- [imageset_name] [varchar] (255) DEFAULT ('') NOT NULL ,

- [imageset_copyright] [varchar] (255) DEFAULT ('') NOT NULL ,

- [imageset_path] [varchar] (100) DEFAULT ('') NOT NULL

-) ON [PRIMARY]

-GO

-

-ALTER TABLE [phpbb_styles_imageset] WITH NOCHECK ADD

- CONSTRAINT [PK_phpbb_styles_imageset] PRIMARY KEY CLUSTERED

- (

- [imageset_id]

- ) ON [PRIMARY]

-GO

-

-CREATE UNIQUE INDEX [imgset_nm] ON [phpbb_styles_imageset]([imageset_name]) ON [PRIMARY]

-GO

-

-

-/*

- Table: 'phpbb_styles_imageset_data'

-*/

-CREATE TABLE [phpbb_styles_imageset_data] (

- [image_id] [int] IDENTITY (1, 1) NOT NULL ,

- [image_name] [varchar] (200) DEFAULT ('') NOT NULL ,

- [image_filename] [varchar] (200) DEFAULT ('') NOT NULL ,

- [image_lang] [varchar] (30) DEFAULT ('') NOT NULL ,

- [image_height] [int] DEFAULT (0) NOT NULL ,

- [image_width] [int] DEFAULT (0) NOT NULL ,

- [imageset_id] [int] DEFAULT (0) NOT NULL

-) ON [PRIMARY]

-GO

-

-ALTER TABLE [phpbb_styles_imageset_data] WITH NOCHECK ADD

- CONSTRAINT [PK_phpbb_styles_imageset_data] PRIMARY KEY CLUSTERED

- (

- [image_id]

- ) ON [PRIMARY]

-GO

-

-CREATE INDEX [i_d] ON [phpbb_styles_imageset_data]([imageset_id]) ON [PRIMARY]

-GO

-

-

-/*

- imageset_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

- KEY theme_id (theme_id),

- KEY imageset_id (imageset_id)

- template_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

-# Table: 'phpbb_styles_template_data'

-CREATE TABLE phpbb_styles_template_data (

- template_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

- template_filename varbinary(100) DEFAULT '' NOT NULL,

- template_included blob NOT NULL,

- template_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,

- template_data mediumblob NOT NULL,

- KEY tid (template_id),

- KEY tfn (template_filename)

-);

-

-

- theme_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

- theme_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,

- theme_data mediumblob NOT NULL,

-# Table: 'phpbb_styles_imageset'

-CREATE TABLE phpbb_styles_imageset (

- imageset_id mediumint(8) UNSIGNED NOT NULL auto_increment,

- imageset_name blob NOT NULL,

- imageset_copyright blob NOT NULL,

- imageset_path varbinary(100) DEFAULT '' NOT NULL,

- PRIMARY KEY (imageset_id),

- UNIQUE imgset_nm (imageset_name(255))

-);

-

-

-# Table: 'phpbb_styles_imageset_data'

-CREATE TABLE phpbb_styles_imageset_data (

- image_id mediumint(8) UNSIGNED NOT NULL auto_increment,

- image_name varbinary(200) DEFAULT '' NOT NULL,

- image_filename varbinary(200) DEFAULT '' NOT NULL,

- image_lang varbinary(30) DEFAULT '' NOT NULL,

- image_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

- image_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

- imageset_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

- PRIMARY KEY (image_id),

- KEY i_d (imageset_id)

-);

-

-

- imageset_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

- KEY theme_id (theme_id),

- KEY imageset_id (imageset_id)

- template_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

-# Table: 'phpbb_styles_template_data'

-CREATE TABLE phpbb_styles_template_data (

- template_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

- template_filename varchar(100) DEFAULT '' NOT NULL,

- template_included text NOT NULL,

- template_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,

- template_data mediumtext NOT NULL,

- KEY tid (template_id),

- KEY tfn (template_filename)

-) CHARACTER SET `utf8` COLLATE `utf8_bin`;

-

-

- theme_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

- theme_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,

- theme_data mediumtext NOT NULL,

-# Table: 'phpbb_styles_imageset'

-CREATE TABLE phpbb_styles_imageset (

- imageset_id mediumint(8) UNSIGNED NOT NULL auto_increment,

- imageset_name varchar(255) DEFAULT '' NOT NULL,

- imageset_copyright varchar(255) DEFAULT '' NOT NULL,

- imageset_path varchar(100) DEFAULT '' NOT NULL,

- PRIMARY KEY (imageset_id),

- UNIQUE imgset_nm (imageset_name)

-) CHARACTER SET `utf8` COLLATE `utf8_bin`;

-

-

-# Table: 'phpbb_styles_imageset_data'

-CREATE TABLE phpbb_styles_imageset_data (

- image_id mediumint(8) UNSIGNED NOT NULL auto_increment,

- image_name varchar(200) DEFAULT '' NOT NULL,

- image_filename varchar(200) DEFAULT '' NOT NULL,

- image_lang varchar(30) DEFAULT '' NOT NULL,

- image_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

- image_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

- imageset_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

- PRIMARY KEY (image_id),

- KEY i_d (imageset_id)

-) CHARACTER SET `utf8` COLLATE `utf8_bin`;

-

-

- imageset_id number(8) DEFAULT '0' NOT NULL,

-CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles (imageset_id)

-/

- template_storedb number(1) DEFAULT '0' NOT NULL,

- Table: 'phpbb_styles_template_data'

-*/

-CREATE TABLE phpbb_styles_template_data (

- template_id number(8) DEFAULT '0' NOT NULL,

- template_filename varchar2(100) DEFAULT '' ,

- template_included clob DEFAULT '' ,

- template_mtime number(11) DEFAULT '0' NOT NULL,

- template_data clob DEFAULT ''

-)

-/

-

-CREATE INDEX phpbb_styles_template_data_tid ON phpbb_styles_template_data (template_id)

-/

-CREATE INDEX phpbb_styles_template_data_tfn ON phpbb_styles_template_data (template_filename)

-/

-

-/*

- theme_storedb number(1) DEFAULT '0' NOT NULL,

- theme_mtime number(11) DEFAULT '0' NOT NULL,

- theme_data clob DEFAULT '' ,

- Table: 'phpbb_styles_imageset'

-*/

-CREATE TABLE phpbb_styles_imageset (

- imageset_id number(8) NOT NULL,

- imageset_name varchar2(765) DEFAULT '' ,

- imageset_copyright varchar2(765) DEFAULT '' ,

- imageset_path varchar2(100) DEFAULT '' ,

- CONSTRAINT pk_phpbb_styles_imageset PRIMARY KEY (imageset_id),

- CONSTRAINT u_phpbb_imgset_nm UNIQUE (imageset_name)

-)

-/

-

-

-CREATE SEQUENCE phpbb_styles_imageset_seq

-/

-

-CREATE OR REPLACE TRIGGER t_phpbb_styles_imageset

-BEFORE INSERT ON phpbb_styles_imageset

-FOR EACH ROW WHEN (

- new.imageset_id IS NULL OR new.imageset_id = 0

-)

-BEGIN

- SELECT phpbb_styles_imageset_seq.nextval

- INTO :new.imageset_id

- FROM dual;

-END;

-/

-

-

-/*

- Table: 'phpbb_styles_imageset_data'

-*/

-CREATE TABLE phpbb_styles_imageset_data (

- image_id number(8) NOT NULL,

- image_name varchar2(200) DEFAULT '' ,

- image_filename varchar2(200) DEFAULT '' ,

- image_lang varchar2(30) DEFAULT '' ,

- image_height number(4) DEFAULT '0' NOT NULL,

- image_width number(4) DEFAULT '0' NOT NULL,

- imageset_id number(8) DEFAULT '0' NOT NULL,

- CONSTRAINT pk_phpbb_styles_imageset_data PRIMARY KEY (image_id)

-)

-/

-

-CREATE INDEX phpbb_styles_imageset_data_i_d ON phpbb_styles_imageset_data (imageset_id)

-/

-

-CREATE SEQUENCE phpbb_styles_imageset_data_seq

-/

-

-CREATE OR REPLACE TRIGGER t_phpbb_styles_imageset_data

-BEFORE INSERT ON phpbb_styles_imageset_data

-FOR EACH ROW WHEN (

- new.image_id IS NULL OR new.image_id = 0

-)

-BEGIN

- SELECT phpbb_styles_imageset_data_seq.nextval

- INTO :new.image_id

- FROM dual;

-END;

-/

-

-

-/*

- imageset_id INT4 DEFAULT '0' NOT NULL CHECK (imageset_id >= 0),

-CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles (imageset_id);

- template_storedb INT2 DEFAULT '0' NOT NULL CHECK (template_storedb >= 0),

- Table: 'phpbb_styles_template_data'

-*/

-CREATE TABLE phpbb_styles_template_data (

- template_id INT4 DEFAULT '0' NOT NULL CHECK (template_id >= 0),

- template_filename varchar(100) DEFAULT '' NOT NULL,

- template_included varchar(8000) DEFAULT '' NOT NULL,

- template_mtime INT4 DEFAULT '0' NOT NULL CHECK (template_mtime >= 0),

- template_data TEXT DEFAULT '' NOT NULL

-);

-

-CREATE INDEX phpbb_styles_template_data_tid ON phpbb_styles_template_data (template_id);

-CREATE INDEX phpbb_styles_template_data_tfn ON phpbb_styles_template_data (template_filename);

-

-/*

- theme_storedb INT2 DEFAULT '0' NOT NULL CHECK (theme_storedb >= 0),

- theme_mtime INT4 DEFAULT '0' NOT NULL CHECK (theme_mtime >= 0),

- theme_data TEXT DEFAULT '' NOT NULL,

- Table: 'phpbb_styles_imageset'

-*/

-CREATE SEQUENCE phpbb_styles_imageset_seq;

-

-CREATE TABLE phpbb_styles_imageset (

- imageset_id INT4 DEFAULT nextval('phpbb_styles_imageset_seq'),

- imageset_name varchar(255) DEFAULT '' NOT NULL,

- imageset_copyright varchar(255) DEFAULT '' NOT NULL,

- imageset_path varchar(100) DEFAULT '' NOT NULL,

- PRIMARY KEY (imageset_id)

-);

-

-CREATE UNIQUE INDEX phpbb_styles_imageset_imgset_nm ON phpbb_styles_imageset (imageset_name);

-

-/*

- Table: 'phpbb_styles_imageset_data'

-*/

-CREATE SEQUENCE phpbb_styles_imageset_data_seq;

-

-CREATE TABLE phpbb_styles_imageset_data (

- image_id INT4 DEFAULT nextval('phpbb_styles_imageset_data_seq'),

- image_name varchar(200) DEFAULT '' NOT NULL,

- image_filename varchar(200) DEFAULT '' NOT NULL,

- image_lang varchar(30) DEFAULT '' NOT NULL,

- image_height INT2 DEFAULT '0' NOT NULL CHECK (image_height >= 0),

- image_width INT2 DEFAULT '0' NOT NULL CHECK (image_width >= 0),

- imageset_id INT4 DEFAULT '0' NOT NULL CHECK (imageset_id >= 0),

- PRIMARY KEY (image_id)

-);

-

-CREATE INDEX phpbb_styles_imageset_data_i_d ON phpbb_styles_imageset_data (imageset_id);

-

-/*

-INSERT INTO phpbb_styles (style_name, style_copyright, style_active, template_id, theme_id, imageset_id) VALUES ('prosilver', '&copy; phpBB Group', 1, 1, 1, 1);

-

-# -- phpbb_styles_imageset

-INSERT INTO phpbb_styles_imageset (imageset_name, imageset_copyright, imageset_path) VALUES ('prosilver', '&copy; phpBB Group', 'prosilver');

-

-# -- phpbb_styles_imageset_data

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('site_logo', 'site_logo.gif', '', 52, 139, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('forum_link', 'forum_link.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('forum_read', 'forum_read.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('forum_read_locked', 'forum_read_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('forum_read_subforum', 'forum_read_subforum.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('forum_unread', 'forum_unread.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('forum_unread_locked', 'forum_unread_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('forum_unread_subforum', 'forum_unread_subforum.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_moved', 'topic_moved.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_read', 'topic_read.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_read_mine', 'topic_read_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_read_hot', 'topic_read_hot.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_read_hot_mine', 'topic_read_hot_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_read_locked', 'topic_read_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_read_locked_mine', 'topic_read_locked_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_unread', 'topic_unread.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_unread_mine', 'topic_unread_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_unread_hot', 'topic_unread_hot.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_unread_hot_mine', 'topic_unread_hot_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_unread_locked', 'topic_unread_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('topic_unread_locked_mine', 'topic_unread_locked_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('sticky_read', 'sticky_read.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('sticky_read_mine', 'sticky_read_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('sticky_read_locked', 'sticky_read_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('sticky_read_locked_mine', 'sticky_read_locked_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('sticky_unread', 'sticky_unread.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('sticky_unread_mine', 'sticky_unread_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('sticky_unread_locked', 'sticky_unread_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('sticky_unread_locked_mine', 'sticky_unread_locked_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('announce_read', 'announce_read.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('announce_read_mine', 'announce_read_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('announce_read_locked', 'announce_read_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('announce_read_locked_mine', 'announce_read_locked_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('announce_unread', 'announce_unread.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('announce_unread_mine', 'announce_unread_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('announce_unread_locked', 'announce_unread_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('announce_unread_locked_mine', 'announce_unread_locked_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('global_read', 'announce_read.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('global_read_mine', 'announce_read_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('global_read_locked', 'announce_read_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('global_read_locked_mine', 'announce_read_locked_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('global_unread', 'announce_unread.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('global_unread_mine', 'announce_unread_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('global_unread_locked', 'announce_unread_locked.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('global_unread_locked_mine', 'announce_unread_locked_mine.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('pm_read', 'topic_read.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('pm_unread', 'topic_unread.gif', '', 27, 27, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_back_top', 'icon_back_top.gif', '', 11, 11, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_contact_aim', 'icon_contact_aim.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_contact_email', 'icon_contact_email.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_contact_icq', 'icon_contact_icq.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_contact_jabber', 'icon_contact_jabber.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_contact_msnm', 'icon_contact_msnm.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_contact_www', 'icon_contact_www.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_contact_yahoo', 'icon_contact_yahoo.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_post_delete', 'icon_post_delete.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_post_info', 'icon_post_info.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_post_report', 'icon_post_report.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_post_target', 'icon_post_target.gif', '', 9, 11, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_post_target_unread', 'icon_post_target_unread.gif', '', 9, 11, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_topic_attach', 'icon_topic_attach.gif', '', 10, 7, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_topic_latest', 'icon_topic_latest.gif', '', 9, 11, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_topic_newest', 'icon_topic_newest.gif', '', 9, 11, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_topic_reported', 'icon_topic_reported.gif', '', 14, 16, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_topic_unapproved', 'icon_topic_unapproved.gif', '', 14, 16, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('icon_user_warn', 'icon_user_warn.gif', '', 20, 20, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('subforum_read', 'subforum_read.gif', '', 9, 11, 1);

-INSERT INTO phpbb_styles_imageset_data (image_name, image_filename, image_lang, image_height, image_width, imageset_id) VALUES ('subforum_unread', 'subforum_unread.gif', '', 9, 11, 1);

-INSERT INTO phpbb_styles_template (template_name, template_copyright, template_path, bbcode_bitfield, template_storedb) VALUES ('prosilver', '&copy; phpBB Group', 'prosilver', 'lNg=', 0);

-INSERT INTO phpbb_styles_theme (theme_name, theme_copyright, theme_path, theme_storedb, theme_data) VALUES ('prosilver', '&copy; phpBB Group', 'prosilver', 1, '');

- theme_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

- imageset_id INTEGER UNSIGNED NOT NULL DEFAULT '0'

-CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles (imageset_id);

- template_storedb INTEGER UNSIGNED NOT NULL DEFAULT '0',

-# Table: 'phpbb_styles_template_data'

-CREATE TABLE phpbb_styles_template_data (

- template_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

- template_filename varchar(100) NOT NULL DEFAULT '',

- template_included text(65535) NOT NULL DEFAULT '',

- template_mtime INTEGER UNSIGNED NOT NULL DEFAULT '0',

- template_data mediumtext(16777215) NOT NULL DEFAULT ''

-);

-

-CREATE INDEX phpbb_styles_template_data_tid ON phpbb_styles_template_data (template_id);

-CREATE INDEX phpbb_styles_template_data_tfn ON phpbb_styles_template_data (template_filename);

-

- theme_path varchar(100) NOT NULL DEFAULT '',

- theme_storedb INTEGER UNSIGNED NOT NULL DEFAULT '0',

- theme_mtime INTEGER UNSIGNED NOT NULL DEFAULT '0',

- theme_data mediumtext(16777215) NOT NULL DEFAULT ''

-# Table: 'phpbb_styles_imageset'

-CREATE TABLE phpbb_styles_imageset (

- imageset_id INTEGER PRIMARY KEY NOT NULL ,

- imageset_name varchar(255) NOT NULL DEFAULT '',

- imageset_copyright varchar(255) NOT NULL DEFAULT '',

- imageset_path varchar(100) NOT NULL DEFAULT ''

-);

-

-CREATE UNIQUE INDEX phpbb_styles_imageset_imgset_nm ON phpbb_styles_imageset (imageset_name);

-

-# Table: 'phpbb_styles_imageset_data'

-CREATE TABLE phpbb_styles_imageset_data (

- image_id INTEGER PRIMARY KEY NOT NULL ,

- image_name varchar(200) NOT NULL DEFAULT '',

- image_filename varchar(200) NOT NULL DEFAULT '',

- image_lang varchar(30) NOT NULL DEFAULT '',

- image_height INTEGER UNSIGNED NOT NULL DEFAULT '0',

- image_width INTEGER UNSIGNED NOT NULL DEFAULT '0',

- imageset_id INTEGER UNSIGNED NOT NULL DEFAULT '0'

-);

-

-CREATE INDEX phpbb_styles_imageset_data_i_d ON phpbb_styles_imageset_data (imageset_id);

-

- 'ACP_IMAGESETS' => 'Imagesets',

- 'LOG_IMAGESET_ADD_DB' => '<strong>Added new imageset to database</strong><br />» %s',

- 'LOG_IMAGESET_ADD_FS' => '<strong>Add new imageset on filesystem</strong><br />» %s',

- 'LOG_IMAGESET_DELETE' => '<strong>Deleted imageset</strong><br />» %s',

- 'LOG_IMAGESET_EDIT_DETAILS' => '<strong>Edited imageset details</strong><br />» %s',

- 'LOG_IMAGESET_EDIT' => '<strong>Edited imageset</strong><br />» %s',

- 'LOG_IMAGESET_EXPORT' => '<strong>Exported imageset</strong><br />» %s',

- 'LOG_IMAGESET_LANG_MISSING' => '<strong>Imageset misses “%2$s” localisation</strong><br />» %1$s',

- 'LOG_IMAGESET_LANG_REFRESHED' => '<strong>Refreshed “%2$s” localisation of imageset</strong><br />» %1$s',

- 'LOG_IMAGESET_REFRESHED' => '<strong>Refreshed imageset</strong><br />» %s',

-

- 'ACP_IMAGESETS_EXPLAIN' => 'Imagesets comprise all the button, forum, folder, etc. and other non-style specific images used by the board. Here you can edit, export or delete existing imagesets and import or activate new sets.',

- 'ACP_STYLES_EXPLAIN' => 'Here you can manage the available styles on your board. A style consists of a template, theme and imageset. You may alter existing styles, delete, deactivate, reactivate, create or import new ones. You can also see what a style will look like using the preview function. The current default style is noted by the presence of an asterisk (*). Also listed is the total user count for each style, note that overriding user styles will not be reflected here.',

- 'ADD_IMAGESET' => 'Create imageset',

- 'ADD_IMAGESET_EXPLAIN' => 'Here you can create a new imageset. Depending on your server configuration and file permissions you may have additional options here. For example you may be able to base this imageset on an existing one. You may also be able to upload or import (from the store directory) a imageset archive. If you upload or import an archive the imageset name can be optionally taken from the archive name (to do this leave the imageset name blank).',

- 'CONFIRM_IMAGESET_REFRESH' => 'Are you sure you wish to refresh all imageset data? The settings from the imageset configuration file will overwrite all modifications to the imageset which have been carried out with the imageset editor.',

- 'CONFIRM_TEMPLATE_REFRESH' => 'Are you sure you wish to refresh all template data in the database with the contents of the template files on the filesystem? This will overwrite all modifications which have been carried out with the template editor while the template was stored in the database.',

- 'CONFIRM_THEME_REFRESH' => 'Are you sure you wish to refresh the theme data stored in the database with the contents of the theme on the filesystem? This will overwrite all modifications which have been carried out with the theme editor while the theme was stored in the database.',

- 'CREATE_IMAGESET' => 'Create new imageset',

- 'DELETE_IMAGESET' => 'Delete imageset',

- 'DELETE_IMAGESET_EXPLAIN' => 'Here you can remove the selected imageset from the database. Please note that there is no undo capability. It is recommended that you first export your set for possible future use.',

- 'EDIT_DETAILS_IMAGESET' => 'Edit imageset details',

- 'EDIT_DETAILS_IMAGESET_EXPLAIN' => 'Here you can edit certain imageset details such as its name.',

- 'EDIT_DETAILS_STYLE_EXPLAIN' => 'Using the form below you can modify this existing style. You may alter the combination of template, theme and imageset which define the style itself. You may also make the style the default one.',

- 'EDIT_DETAILS_TEMPLATE_EXPLAIN' => 'Here you can edit certain template details such as its name. You may also have the option to switch storage of the stylesheet from the filesystem to the database and vice versa. This option depends on your PHP configuration and whether your template set can be written to by the web server.',

- 'EDIT_DETAILS_THEME_EXPLAIN' => 'Here you can edit certain theme details such as its name. You may also have the option to switch storage of the stylesheet from the filesystem to the database and vice versa. This option depends on your PHP configuration and whether your stylesheet can be written to by the web server.',

- 'EDIT_IMAGESET' => 'Edit imageset',

- 'EDIT_IMAGESET_EXPLAIN' => 'Here you can edit the individual images which define the imageset. You can also specify dimensions for the image. Dimensions are optional, specifying them can overcome certain rendering issues with some browsers. By not specifying them you reduce the size of the database record a little.',

- 'EDIT_TEMPLATE_EXPLAIN' => 'Here you can edit your template set directly. Please remember that these edits are permanent and cannot be undone once submitted. If PHP can write to the template files in your styles directory any changes here will be written directly to those files. If PHP cannot write to those files they will be copied into the database and all changes will only be reflected there. Please take care when editing your template set, remember to close all replacement variable terms {XXXX} and conditional statements.',

- 'EDIT_TEMPLATE_STORED_DB' => 'The template file was unwritable so the template set is now stored in the database containing the modified file.',

- 'EDIT_THEME_STORED_DB' => 'The stylesheet file was unwritable so the stylesheet is now stored in the database containing your modification.',

- 'EDIT_THEME_STORE_PARSED' => 'The theme requires that its stylesheet is parsed. This is only possible if it’s stored in the database.',

- 'IMAGESET_ADDED' => 'New imageset added on filesystem.',

- 'IMAGESET_ADDED_DB' => 'New imageset added to database.',

- 'IMAGESET_DELETED' => 'Imageset deleted successfully.',

- 'IMAGESET_DELETED_FS' => 'Imageset removed from database but some files may remain on the filesystem.',

- 'IMAGESET_DETAILS_UPDATED' => 'Imageset details successfully updated.',

- 'IMAGESET_ERR_ARCHIVE' => 'Please select an archive method.',

- 'IMAGESET_ERR_COPY_LONG' => 'The copyright can be no longer than 60 characters.',

- 'IMAGESET_ERR_NAME_CHARS' => 'The imageset name can only contain alphanumeric characters, -, +, _ and space.',

- 'IMAGESET_ERR_NAME_EXIST' => 'A imageset with that name already exists.',

- 'IMAGESET_ERR_NAME_LONG' => 'The imageset name can be no longer than 30 characters.',

- 'IMAGESET_ERR_NOT_IMAGESET' => 'The archive you specified does not contain a valid imageset.',

- 'IMAGESET_ERR_STYLE_NAME' => 'You must supply a name for this imageset.',

- 'IMAGESET_EXPORT' => 'Export imageset',

- 'IMAGESET_EXPORT_EXPLAIN' => 'Here you can export an imageset in the form of an archive. This archive will contain all the data necessary to install the set of images on another board. You may select whether to download the file directly or to place it in your store folder for download later or via FTP.',

- 'IMAGESET_EXPORTED' => 'Imageset exported successfully and stored in %s.',

- 'IMAGESET_NAME' => 'Imageset name',

- 'IMAGESET_REFRESHED' => 'Imageset refreshed successfully.',

- 'IMAGESET_UPDATED' => 'Imageset updated successfully.',

- 'INCLUDE_IMAGESET' => 'Include imageset',

- 'INSTALL_IMAGESET' => 'Install imageset',

- 'INSTALL_IMAGESET_EXPLAIN' => 'Here you can install your selected imageset. You can edit certain details if you wish or use the installation defaults.',

- 'INSTALLED_IMAGESET' => 'Installed imagesets',

- 'KEEP_IMAGESET' => 'Keep “%s” imageset',

- 'LOCATION_DISABLED_EXPLAIN' => 'This setting is inherited and cannot be changed.',

- 'NO_IMAGESET' => 'Cannot find imageset on filesystem.',

- 'NO_UNINSTALLED_IMAGESET' => 'No uninstalled imagesets detected.',

- 'ONLY_IMAGESET' => 'This is the only remaining imageset, you cannot delete it.',

- 'REPLACE_IMAGESET' => 'Replace imageset with',

- 'REPLACE_IMAGESET_EXPLAIN' => 'This imageset will replace the one you are deleting in any styles that use it.',

- 'REQUIRES_IMAGESET' => 'This style requires the %s imageset to be installed.',

- 'SELECTED_IMAGESET' => 'Selected imageset',

- 'STORE_DATABASE' => 'Database',

- 'STYLE_ERR_NO_IDS' => 'You must select a template, theme and imageset for this style.',

- 'STYLE_EXPORT_EXPLAIN' => 'Here you can export a style in the form of an archive. A style does not need to contain all elements but it must contain at least one. For example if you have created a new theme and imageset for a commonly used template you could simply export the theme and imageset and omit the template. You may select whether to download the file directly or to place it in your store folder for download later or via FTP.',

- 'STYLE_IMAGESET' => 'Imageset',

- 'TEMPLATE_ADDED' => 'Template set added and stored on filesystem.',

- 'TEMPLATE_ADDED_DB' => 'Template set added and stored in database.',

- 'TEMPLATE_DELETED_FS' => 'Template set removed from database but some files may remain on the filesystem.',

- 'TEMPLATE_LOCATION' => 'Store templates in',

- 'TEMPLATE_LOCATION_EXPLAIN' => 'Images are always stored on the filesystem.',

- 'TEMPLATE_REFRESHED' => 'Template refreshed successfully.',

- 'THEME_ADDED' => 'New theme added on filesystem.',

- 'THEME_ADDED_DB' => 'New theme added to database.',

- 'THEME_ERR_REFRESH_FS' => 'This theme is stored on the filesystem so there is no need to refresh it.',

- 'THEME_LOCATION' => 'Store stylesheet in',

- 'THEME_LOCATION_EXPLAIN' => 'Images are always stored on the filesystem.',

- 'THEME_REFRESHED' => 'Theme refreshed successfully.',

- 'UNINSTALLED_IMAGESET' => 'Uninstalled imagesets',

- 'SUPPORT_BODY' => 'Full support will be provided for the current stable release of phpBB3, free of charge. This includes:</p><ul><li>installation</li><li>configuration</li><li>technical questions</li><li>problems relating to potential bugs in the software</li><li>updating from Release Candidate (RC) versions to the latest stable version</li><li>converting from phpBB 2.0.x to phpBB3</li><li>converting from other discussion board software to phpBB3 (please see the <a href="http://www.phpbb.com/community/viewforum.php?f=65">Convertors Forum</a>)</li></ul><p>We encourage users still running beta versions of phpBB3 to replace their installation with a fresh copy of the latest version.</p><h2>MODs / Styles</h2><p>For issues relating to MODs, please post in the appropriate <a href="http://www.phpbb.com/community/viewforum.php?f=81">Modifications Forum</a>.<br />For issues relating to styles, templates and imagesets, please post in the appropriate <a href="http://www.phpbb.com/community/viewforum.php?f=80">Styles Forum</a>.<br /><br />If your question relates to a specific package, please post directly in the topic dedicated to the package.</p><h2>Obtaining Support</h2><p><a href="http://www.phpbb.com/community/viewtopic.php?f=14&amp;t=571070">The phpBB Welcome Package</a><br /><a href="http://www.phpbb.com/support/">Support Section</a><br /><a href="http://www.phpbb.com/support/documentation/3.0/quickstart/">Quick Start Guide</a><br /><br />To ensure you stay up to date with the latest news and releases, why not <a href="http://www.phpbb.com/support/">subscribe to our mailing list</a>?<br /><br />',

- 'TOPIC_FOLDER_IMG_SRC' => $user->img($folder_img, $folder_alt, false, '', 'src'),

- 'TOPIC_FOLDER_IMG_WIDTH'=> $user->img($folder_img, '', false, '', 'width'),

- 'TOPIC_FOLDER_IMG_HEIGHT' => $user->img($folder_img, '', false, '', 'height'),

-<?php

-/**

-*

-* @package phpBB3

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

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

-*

-*/

-

-/**

-* @ignore

-*/

-define('IN_PHPBB', true);

-$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';

-$phpEx = substr(strrchr(__FILE__, '.'), 1);

-

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

-require($phpbb_root_path . 'config.' . $phpEx);

-

-if (!defined('PHPBB_INSTALLED') || empty($dbms) || empty($acm_type))

-{

- exit;

-}

-

-// Load Extensions

-if (!empty($load_extensions) && function_exists('dl'))

-{

- $load_extensions = explode(',', $load_extensions);

-

- foreach ($load_extensions as $extension)

- {

- @dl(trim($extension));

- }

-}

-

-// no $request here because it is not loaded yet

-$id = (isset($_GET['id'])) ? intval($_GET['id']) : 0;

-

-// This is a simple script to grab and output the requested CSS data stored in the DB

-// We include a session_id check to try and limit 3rd party linking ... unless they

-// happen to have a current session it will output nothing. We will also cache the

-// resulting CSS data for five minutes ... anything to reduce the load on the SQL

-// server a little

-if ($id)

-{

- // Include files

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

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

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

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

- require($phpbb_root_path . 'includes/utf/utf_tools.' . $phpEx);

-

- $class_loader = new phpbb_class_loader($phpbb_root_path, '.' . $phpEx);

- $class_loader->register();

-

- // set up caching

- $cache_factory = new phpbb_cache_factory($acm_type);

- $cache = $cache_factory->get_service();

- $class_loader->set_cache($cache->get_driver());

-

- $request = new phpbb_request();

- $db = new $sql_db();

-

- // make sure request_var uses this request instance

- request_var('', 0, false, false, $request); // "dependency injection" for a function

-

- // Connect to DB

- if (!@$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false, false))

- {

- exit;

- }

- unset($dbpasswd);

-

- $config = new phpbb_config_db($db, $cache->get_driver(), CONFIG_TABLE);

- set_config(null, null, null, $config);

- set_config_count(null, null, null, $config);

-

- $user = false;

-

- // try to get a session ID from REQUEST array

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

-

- if (!$sid)

- {

- // if that failed, then look in the cookies

- $sid = request_var($config['cookie_name'] . '_sid', '', false, true);

- }

-

- if (strspn($sid, 'abcdefABCDEF0123456789') !== strlen($sid))

- {

- $sid = '';

- }

-

- if ($sid)

- {

- $sql = 'SELECT u.user_id, u.user_lang

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

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

- AND s.session_user_id = u.user_id";

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

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

- $db->sql_freeresult($result);

- }

-

- $recompile = $config['load_tplcompile'];

- if (!$user)

- {

- $id = ($id) ? $id : $config['default_style'];

-// Commented out because calls do not always include the SID anymore

-// $recompile = false;

- $user = array('user_id' => ANONYMOUS);

- }

-

- $sql = 'SELECT s.style_id, c.theme_id, c.theme_data, c.theme_path, c.theme_name, c.theme_mtime, i.*, t.template_path

- FROM ' . STYLES_TABLE . ' s, ' . STYLES_TEMPLATE_TABLE . ' t, ' . STYLES_THEME_TABLE . ' c, ' . STYLES_IMAGESET_TABLE . ' i

- WHERE s.style_id = ' . $id . '

- AND t.template_id = s.template_id

- AND c.theme_id = s.theme_id

- AND i.imageset_id = s.imageset_id';

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

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

- $db->sql_freeresult($result);

-

- if (!$theme)

- {

- exit;

- }

-

- if ($user['user_id'] == ANONYMOUS)

- {

- $user['user_lang'] = $config['default_lang'];

- }

-

- $user_image_lang = (file_exists($phpbb_root_path . 'styles/' . $theme['imageset_path'] . '/imageset/' . $user['user_lang'])) ? $user['user_lang'] : $config['default_lang'];

-

- // Same query in session.php

- $sql = 'SELECT *

- FROM ' . STYLES_IMAGESET_DATA_TABLE . '

- WHERE imageset_id = ' . $theme['imageset_id'] . "

- AND image_filename <> ''

- AND image_lang IN ('" . $db->sql_escape($user_image_lang) . "', '')";

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

-

- $img_array = array();

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

- {

- $img_array[$row['image_name']] = $row;

- }

- $db->sql_freeresult($result);

-

- // gzip_compression

- if ($config['gzip_compress'])

- {

- // IE6 is not able to compress the style (do not ask us why!)

- $browser = strtolower($request->header('User-Agent'));

-

- if ($browser && strpos($browser, 'msie 6.0') === false && @extension_loaded('zlib') && !headers_sent())

- {

- ob_start('ob_gzhandler');

- }

- }

-

- // Expire time of seven days if not recached

- $expire_time = 7*86400;

- $recache = false;

-

- // Re-cache stylesheet data if necessary

- if ($recompile || empty($theme['theme_data']))

- {

- $recache = (empty($theme['theme_data'])) ? true : false;

- $update_time = time();

-

- // We test for stylesheet.css because it is faster and most likely the only file changed on common themes

- if (!$recache && $theme['theme_mtime'] < @filemtime("{$phpbb_root_path}styles/" . $theme['theme_path'] . '/theme/stylesheet.css'))

- {

- $recache = true;

- $update_time = @filemtime("{$phpbb_root_path}styles/" . $theme['theme_path'] . '/theme/stylesheet.css');

- }

- else if (!$recache)

- {

- $last_change = $theme['theme_mtime'];

- $dir = @opendir("{$phpbb_root_path}styles/{$theme['theme_path']}/theme");

-

- if ($dir)

- {

- while (($entry = readdir($dir)) !== false)

- {

- if (substr(strrchr($entry, '.'), 1) == 'css' && $last_change < @filemtime("{$phpbb_root_path}styles/{$theme['theme_path']}/theme/{$entry}"))

- {

- $recache = true;

- break;

- }

- }

- closedir($dir);

- }

- }

- }

-

- if ($recache)

- {

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

-

- $theme['theme_data'] = acp_styles::db_theme_data($theme);

- $theme['theme_mtime'] = $update_time;

-

- // Save CSS contents

- $sql_ary = array(

- 'theme_mtime' => $theme['theme_mtime'],

- 'theme_data' => $theme['theme_data']

- );

-

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

- WHERE theme_id = {$theme['theme_id']}";

- $db->sql_query($sql);

-

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

- }

-

- // Only set the expire time if the theme changed data is older than 30 minutes - to cope with changes from the ACP

- if ($recache || $theme['theme_mtime'] > (time() - 1800))

- {

- header('Expires: 0');

- }

- else

- {

- header('Expires: ' . gmdate('D, d M Y H:i:s \G\M\T', time() + $expire_time));

- }

-

- header('Content-type: text/css; charset=UTF-8');

-

- // Parse Theme Data

- $replace = array(

- '{T_THEME_PATH}' => "{$phpbb_root_path}styles/" . $theme['theme_path'] . '/theme',

- '{T_TEMPLATE_PATH}' => "{$phpbb_root_path}styles/" . $theme['template_path'] . '/template',

- '{T_IMAGESET_PATH}' => "{$phpbb_root_path}styles/" . $theme['imageset_path'] . '/imageset',

- '{T_IMAGESET_LANG_PATH}' => "{$phpbb_root_path}styles/" . $theme['imageset_path'] . '/imageset/' . $user_image_lang,

- '{T_STYLESHEET_NAME}' => $theme['theme_name'],

- '{S_USER_LANG}' => $user['user_lang']

- );

-

- $theme['theme_data'] = str_replace(array_keys($replace), array_values($replace), $theme['theme_data']);

-

- $matches = array();

- preg_match_all('#\{IMG_([A-Za-z0-9_]*?)_(WIDTH|HEIGHT|SRC)\}#', $theme['theme_data'], $matches);

-

- $imgs = $find = $replace = array();

- if (isset($matches[0]) && sizeof($matches[0]))

- {

- foreach ($matches[1] as $i => $img)

- {

- $img = strtolower($img);

- $find[] = $matches[0][$i];

-

- if (!isset($img_array[$img]))

- {

- $replace[] = '';

- continue;

- }

-

- if (!isset($imgs[$img]))

- {

- $img_data = &$img_array[$img];

- $imgsrc = ($img_data['image_lang'] ? $img_data['image_lang'] . '/' : '') . $img_data['image_filename'];

- $imgs[$img] = array(

- 'src' => $phpbb_root_path . 'styles/' . $theme['imageset_path'] . '/imageset/' . $imgsrc,

- 'width' => $img_data['image_width'],

- 'height' => $img_data['image_height'],

- );

- }

-

- switch ($matches[2][$i])

- {

- case 'SRC':

- $replace[] = $imgs[$img]['src'];

- break;

-

- case 'WIDTH':

- $replace[] = $imgs[$img]['width'];

- break;

-

- case 'HEIGHT':

- $replace[] = $imgs[$img]['height'];

- break;

-

- default:

- continue;

- }

- }

-

- if (sizeof($find))

- {

- $theme['theme_data'] = str_replace($find, $replace, $theme['theme_data']);

- }

- }

-

- echo $theme['theme_data'];

-

- if (!empty($cache))

- {

- $cache->unload();

- }

- $db->sql_close();

-}

-#

-# phpBB Imageset Configuration File

-#

-# @package phpBB3

-# @copyright (c) 2006 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.

-#

-#

-

-# Images

-img_icon_contact_pm = icon_contact_pm.gif*20*28

-

-img_icon_post_edit = icon_post_edit.gif*20*42

-img_icon_post_quote = icon_post_quote.gif*20*54

-

-img_icon_user_online = icon_user_online.gif*58*58

-img_icon_user_offline =

-img_icon_user_search =

-

-img_button_pm_forward = button_pm_forward.gif*25*96

-img_button_pm_new = button_pm_new.gif*25*84

-img_button_pm_reply = button_pm_reply.gif*25*96

-

-img_button_topic_locked = button_topic_locked.gif*25*88

-img_button_topic_new = button_topic_new.gif*25*96

-img_button_topic_reply = button_topic_reply.gif*25*96

-#

-# phpBB Imageset Configuration File

-#

-# @package phpBB3

-# @copyright (c) 2006 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 style

-name = prosilver

-copyright = &copy; phpBB Group, 2007

-version = 3.1.0-dev

-

-# Images

-img_site_logo = site_logo.gif*52*139

-img_poll_left =

-img_poll_center =

-img_poll_right =

-img_icon_friend =

-img_icon_foe =

-

-img_forum_link = forum_link.gif*27*27

-img_forum_read = forum_read.gif*27*27

-img_forum_read_locked = forum_read_locked.gif*27*27

-img_forum_read_subforum = forum_read_subforum.gif*27*27

-img_forum_unread = forum_unread.gif*27*27

-img_forum_unread_locked = forum_unread_locked.gif*27*27

-img_forum_unread_subforum = forum_unread_subforum.gif*27*27

-

-img_topic_moved = topic_moved.gif*27*27

-

-img_topic_read = topic_read.gif*27*27

-img_topic_read_mine = topic_read_mine.gif*27*27

-img_topic_read_hot = topic_read_hot.gif*27*27

-img_topic_read_hot_mine = topic_read_hot_mine.gif*27*27

-img_topic_read_locked = topic_read_locked.gif*27*27

-img_topic_read_locked_mine = topic_read_locked_mine.gif*27*27

-

-img_topic_unread = topic_unread.gif*27*27

-img_topic_unread_mine = topic_unread_mine.gif*27*27

-img_topic_unread_hot = topic_unread_hot.gif*27*27

-img_topic_unread_hot_mine = topic_unread_hot_mine.gif*27*27

-img_topic_unread_locked = topic_unread_locked.gif*27*27

-img_topic_unread_locked_mine = topic_unread_locked_mine.gif*27*27

-

-img_sticky_read = sticky_read.gif*27*27

-img_sticky_read_mine = sticky_read_mine.gif*27*27

-img_sticky_read_locked = sticky_read_locked.gif*27*27

-img_sticky_read_locked_mine = sticky_read_locked_mine.gif*27*27

-img_sticky_unread = sticky_unread.gif*27*27

-img_sticky_unread_mine = sticky_unread_mine.gif*27*27

-img_sticky_unread_locked = sticky_unread_locked.gif*27*27

-img_sticky_unread_locked_mine = sticky_unread_locked_mine.gif*27*27

-

-img_announce_read = announce_read.gif*27*27

-img_announce_read_mine = announce_read_mine.gif*27*27

-img_announce_read_locked = announce_read_locked.gif*27*27

-img_announce_read_locked_mine = announce_read_locked_mine.gif*27*27

-img_announce_unread = announce_unread.gif*27*27

-img_announce_unread_mine = announce_unread_mine.gif*27*27

-img_announce_unread_locked = announce_unread_locked.gif*27*27

-img_announce_unread_locked_mine = announce_unread_locked_mine.gif*27*27

-

-img_global_read = announce_read.gif*27*27

-img_global_read_mine = announce_read_mine.gif*27*27

-img_global_read_locked = announce_read_locked.gif*27*27

-img_global_read_locked_mine = announce_read_locked_mine.gif*27*27

-img_global_unread = announce_unread.gif*27*27

-img_global_unread_mine = announce_unread_mine.gif*27*27

-img_global_unread_locked = announce_unread_locked.gif*27*27

-img_global_unread_locked_mine = announce_unread_locked_mine.gif*27*27

-

-img_subforum_read = subforum_read.gif*9*11

-img_subforum_unread = subforum_unread.gif*9*11

-

-img_pm_read = topic_read.gif*27*27

-img_pm_unread = topic_unread.gif*27*27

-

-img_icon_back_top = icon_back_top.gif*11*11

-

-img_icon_contact_aim = icon_contact_aim.gif*20*20

-img_icon_contact_email = icon_contact_email.gif*20*20

-img_icon_contact_icq = icon_contact_icq.gif*20*20

-img_icon_contact_jabber = icon_contact_jabber.gif*20*20

-img_icon_contact_msnm = icon_contact_msnm.gif*20*20

-

-img_icon_contact_www = icon_contact_www.gif*20*20

-img_icon_contact_yahoo = icon_contact_yahoo.gif*20*20

-

-img_icon_post_delete = icon_post_delete.gif*20*20

-

-img_icon_post_info = icon_post_info.gif*20*20

-

-img_icon_post_report = icon_post_report.gif*20*20

-img_icon_post_target = icon_post_target.gif*9*11

-img_icon_post_target_unread = icon_post_target_unread.gif*9*11

-

-img_icon_topic_attach = icon_topic_attach.gif*10*7

-img_icon_topic_latest = icon_topic_latest.gif*9*11

-img_icon_topic_newest = icon_topic_newest.gif*9*11

-img_icon_topic_reported = icon_topic_reported.gif*14*16

-img_icon_topic_unapproved = icon_topic_unapproved.gif*14*16

-

-img_icon_user_profile =

-

-img_icon_user_warn = icon_user_warn.gif*20*20

- <!-- IF S_CLEAR_ALLOWED --><td width="5%" align="center"><input type="checkbox" name="marknote[]" id="note-{usernotes.ID}" value="{usernotes.ID}" /></td><!-- ENDIF -->

-.buttons div.reply-icon { width: {IMG_BUTTON_TOPIC_REPLY_WIDTH}px; height: {IMG_BUTTON_TOPIC_REPLY_HEIGHT}px; }

-.buttons div.post-icon { width: {IMG_BUTTON_TOPIC_NEW_WIDTH}px; height: {IMG_BUTTON_TOPIC_NEW_HEIGHT}px; }

-.buttons div.locked-icon { width: {IMG_BUTTON_TOPIC_LOCKED_WIDTH}px; height: {IMG_BUTTON_TOPIC_LOCKED_HEIGHT}px; }

-.buttons div.pmreply-icon { width: {IMG_BUTTON_PM_REPLY_WIDTH}px; height: {IMG_BUTTON_PM_REPLY_HEIGHT}px; }

-.buttons div.newpm-icon { width: {IMG_BUTTON_PM_NEW_WIDTH}px; height: {IMG_BUTTON_PM_NEW_HEIGHT}px; }

-.buttons div.forwardpm-icon { width: {IMG_BUTTON_PM_FORWARD_WIDTH}px; height: {IMG_BUTTON_PM_FORWARD_HEIGHT}px; }

-ul.profile-icons li.email-icon { width: {IMG_ICON_CONTACT_EMAIL_WIDTH}px; height: {IMG_ICON_CONTACT_EMAIL_HEIGHT}px; }

-ul.profile-icons li.aim-icon { width: {IMG_ICON_CONTACT_AIM_WIDTH}px; height: {IMG_ICON_CONTACT_AIM_HEIGHT}px; }

-ul.profile-icons li.yahoo-icon { width: {IMG_ICON_CONTACT_YAHOO_WIDTH}px; height: {IMG_ICON_CONTACT_YAHOO_HEIGHT}px; }

-ul.profile-icons li.web-icon { width: {IMG_ICON_CONTACT_WWW_WIDTH}px; height: {IMG_ICON_CONTACT_WWW_HEIGHT}px; }

-ul.profile-icons li.msnm-icon { width: {IMG_ICON_CONTACT_MSNM_WIDTH}px; height: {IMG_ICON_CONTACT_MSNM_HEIGHT}px; }

-ul.profile-icons li.icq-icon { width: {IMG_ICON_CONTACT_ICQ_WIDTH}px; height: {IMG_ICON_CONTACT_ICQ_HEIGHT}px; }

-ul.profile-icons li.jabber-icon { width: {IMG_ICON_CONTACT_JABBER_WIDTH}px; height: {IMG_ICON_CONTACT_JABBER_HEIGHT}px; }

-ul.profile-icons li.pm-icon { width: {IMG_ICON_CONTACT_PM_WIDTH}px; height: {IMG_ICON_CONTACT_PM_HEIGHT}px; }

-ul.profile-icons li.quote-icon { width: {IMG_ICON_POST_QUOTE_WIDTH}px; height: {IMG_ICON_POST_QUOTE_HEIGHT}px; }

-ul.profile-icons li.report-icon { width: {IMG_ICON_POST_REPORT_WIDTH}px; height: {IMG_ICON_POST_REPORT_HEIGHT}px; }

-ul.profile-icons li.edit-icon { width: {IMG_ICON_POST_EDIT_WIDTH}px; height: {IMG_ICON_POST_EDIT_HEIGHT}px; }

-ul.profile-icons li.delete-icon { width: {IMG_ICON_POST_DELETE_WIDTH}px; height: {IMG_ICON_POST_DELETE_HEIGHT}px; }

-ul.profile-icons li.info-icon { width: {IMG_ICON_POST_INFO_WIDTH}px; height: {IMG_ICON_POST_INFO_HEIGHT}px; }

-ul.profile-icons li.warn-icon { width: {IMG_ICON_USER_WARN_WIDTH}px; height: {IMG_ICON_USER_WARN_HEIGHT}px; }

- background-image: url("{T_THEME_PATH}/images/bg_header.gif");

- background-image: url("{T_THEME_PATH}/images/bg_list.gif");

- background-image: url("{T_THEME_PATH}/images/bg_header.gif");

- background-image: url("{T_THEME_PATH}/images/corners_left.png");

- background-image: url("{T_THEME_PATH}/images/corners_right.png");

- background-image: url("{T_THEME_PATH}/images/corners_left.png");

- background-image: url("{T_THEME_PATH}/images/corners_right.png");

- background-image: url("{T_THEME_PATH}/images/icon_pages.gif");

- background-image: url("{IMG_ICON_BACK_TOP_SRC}");

- background-image: url("{IMG_ICON_BACK_TOP_SRC}");

-a.up { background-image: url("{T_THEME_PATH}/images/arrow_up.gif") }

-a.down { background-image: url("{T_THEME_PATH}/images/arrow_down.gif") }

-a.left { background-image: url("{T_THEME_PATH}/images/arrow_left.gif") }

-a.right { background-image: url("{T_THEME_PATH}/images/arrow_right.gif") }

- background-image: url("{T_THEME_PATH}/images/gradient.gif");

- background-image: url("{IMG_SUBFORUM_READ_SRC}");

- background-image: url("{IMG_SUBFORUM_UNREAD_SRC}");

- background-image: url("{T_THEME_PATH}/images/quote.gif");

- background-image: url("{T_THEME_PATH}/images/quote_rtl.gif");

- background-image: url("{IMG_ICON_USER_ONLINE_SRC}");

-.reply-icon span { background-image: url("{IMG_BUTTON_TOPIC_REPLY_SRC}"); }

-.post-icon span { background-image: url("{IMG_BUTTON_TOPIC_NEW_SRC}"); }

-.locked-icon span { background-image: url("{IMG_BUTTON_TOPIC_LOCKED_SRC}"); }

-.pmreply-icon span { background-image: url("{IMG_BUTTON_PM_REPLY_SRC}") ;}

-.newpm-icon span { background-image: url("{IMG_BUTTON_PM_NEW_SRC}") ;}

-.forwardpm-icon span { background-image: url("{IMG_BUTTON_PM_FORWARD_SRC}") ;}

- background-image: url("{T_THEME_PATH}/images/icon_print.gif");

- background-image: url("{T_THEME_PATH}/images/icon_sendemail.gif");

-.sitehome { background-image: url("{T_THEME_PATH}/images/icon_home.gif"); }

-.icon-faq { background-image: url("{T_THEME_PATH}/images/icon_faq.gif"); }

-.icon-members { background-image: url("{T_THEME_PATH}/images/icon_members.gif"); }

-.icon-home { background-image: url("{T_THEME_PATH}/images/icon_home.gif"); }

-.icon-ucp { background-image: url("{T_THEME_PATH}/images/icon_ucp.gif"); }

-.icon-register { background-image: url("{T_THEME_PATH}/images/icon_register.gif"); }

-.icon-logout { background-image: url("{T_THEME_PATH}/images/icon_logout.gif"); }

-.icon-bookmark { background-image: url("{T_THEME_PATH}/images/icon_bookmark.gif"); }

-.icon-bump { background-image: url("{T_THEME_PATH}/images/icon_bump.gif"); }

-.icon-subscribe { background-image: url("{T_THEME_PATH}/images/icon_subscribe.gif"); }

-.icon-unsubscribe { background-image: url("{T_THEME_PATH}/images/icon_unsubscribe.gif"); }

-.icon-pages { background-image: url("{T_THEME_PATH}/images/icon_pages.gif"); }

-.icon-search { background-image: url("{T_THEME_PATH}/images/icon_search.gif"); }

-.email-icon, .email-icon a { background-image: url("{IMG_ICON_CONTACT_EMAIL_SRC}"); }

-.aim-icon, .aim-icon a { background-image: url("{IMG_ICON_CONTACT_AIM_SRC}"); }

-.yahoo-icon, .yahoo-icon a { background-image: url("{IMG_ICON_CONTACT_YAHOO_SRC}"); }

-.web-icon, .web-icon a { background-image: url("{IMG_ICON_CONTACT_WWW_SRC}"); }

-.msnm-icon, .msnm-icon a { background-image: url("{IMG_ICON_CONTACT_MSNM_SRC}"); }

-.icq-icon, .icq-icon a { background-image: url("{IMG_ICON_CONTACT_ICQ_SRC}"); }

-.jabber-icon, .jabber-icon a { background-image: url("{IMG_ICON_CONTACT_JABBER_SRC}"); }

-.pm-icon, .pm-icon a { background-image: url("{IMG_ICON_CONTACT_PM_SRC}"); }

-.quote-icon, .quote-icon a { background-image: url("{IMG_ICON_POST_QUOTE_SRC}"); }

-.report-icon, .report-icon a { background-image: url("{IMG_ICON_POST_REPORT_SRC}"); }

-.edit-icon, .edit-icon a { background-image: url("{IMG_ICON_POST_EDIT_SRC}"); }

-.delete-icon, .delete-icon a { background-image: url("{IMG_ICON_POST_DELETE_SRC}"); }

-.info-icon, .info-icon a { background-image: url("{IMG_ICON_POST_INFO_SRC}"); }

-.warn-icon, .warn-icon a { background-image: url("{IMG_ICON_USER_WARN_SRC}"); } /* Need updated warn icon */

-.global_read { background-image: url("{IMG_GLOBAL_READ_SRC}"); }

-.global_read_mine { background-image: url("{IMG_GLOBAL_READ_MINE_SRC}"); }

-.global_read_locked { background-image: url("{IMG_GLOBAL_READ_LOCKED_SRC}"); }

-.global_read_locked_mine { background-image: url("{IMG_GLOBAL_READ_LOCKED_MINE_SRC}"); }

-.global_unread { background-image: url("{IMG_GLOBAL_UNREAD_SRC}"); }

-.global_unread_mine { background-image: url("{IMG_GLOBAL_UNREAD_MINE_SRC}"); }

-.global_unread_locked { background-image: url("{IMG_GLOBAL_UNREAD_LOCKED_SRC}"); }

-.global_unread_locked_mine { background-image: url("{IMG_GLOBAL_UNREAD_LOCKED_MINE_SRC}"); }

-

-.announce_read { background-image: url("{IMG_ANNOUNCE_READ_SRC}"); }

-.announce_read_mine { background-image: url("{IMG_ANNOUNCE_READ_MINE_SRC}"); }

-.announce_read_locked { background-image: url("{IMG_ANNOUNCE_READ_LOCKED_SRC}"); }

-.announce_read_locked_mine { background-image: url("{IMG_ANNOUNCE_READ_LOCKED_MINE_SRC}"); }

-.announce_unread { background-image: url("{IMG_ANNOUNCE_UNREAD_SRC}"); }

-.announce_unread_mine { background-image: url("{IMG_ANNOUNCE_UNREAD_MINE_SRC}"); }

-.announce_unread_locked { background-image: url("{IMG_ANNOUNCE_UNREAD_LOCKED_SRC}"); }

-.announce_unread_locked_mine { background-image: url("{IMG_ANNOUNCE_UNREAD_LOCKED_MINE_SRC}"); }

-

-.forum_link { background-image: url("{IMG_FORUM_LINK_SRC}"); }

-.forum_read { background-image: url("{IMG_FORUM_READ_SRC}"); }

-.forum_read_locked { background-image: url("{IMG_FORUM_READ_LOCKED_SRC}"); }

-.forum_read_subforum { background-image: url("{IMG_FORUM_READ_SUBFORUM_SRC}"); }

-.forum_unread { background-image: url("{IMG_FORUM_UNREAD_SRC}"); }

-.forum_unread_locked { background-image: url("{IMG_FORUM_UNREAD_LOCKED_SRC}"); }

-.forum_unread_subforum { background-image: url("{IMG_FORUM_UNREAD_SUBFORUM_SRC}"); }

-

-.sticky_read { background-image: url("{IMG_STICKY_READ_SRC}"); }

-.sticky_read_mine { background-image: url("{IMG_STICKY_READ_MINE_SRC}"); }

-.sticky_read_locked { background-image: url("{IMG_STICKY_READ_LOCKED_SRC}"); }

-.sticky_read_locked_mine { background-image: url("{IMG_STICKY_READ_LOCKED_MINE_SRC}"); }

-.sticky_unread { background-image: url("{IMG_STICKY_UNREAD_SRC}"); }

-.sticky_unread_mine { background-image: url("{IMG_STICKY_UNREAD_MINE_SRC}"); }

-.sticky_unread_locked { background-image: url("{IMG_STICKY_UNREAD_LOCKED_SRC}"); }

-.sticky_unread_locked_mine { background-image: url("{IMG_STICKY_UNREAD_LOCKED_MINE_SRC}"); }

-

-.topic_moved { background-image: url("{IMG_TOPIC_MOVED_SRC}"); }

-.topic_read { background-image: url("{IMG_TOPIC_READ_SRC}"); }

-.topic_read_mine { background-image: url("{IMG_TOPIC_READ_MINE_SRC}"); }

-.topic_read_hot { background-image: url("{IMG_TOPIC_READ_HOT_SRC}"); }

-.topic_read_hot_mine { background-image: url("{IMG_TOPIC_READ_HOT_MINE_SRC}"); }

-.topic_read_locked { background-image: url("{IMG_TOPIC_READ_LOCKED_SRC}"); }

-.topic_read_locked_mine { background-image: url("{IMG_TOPIC_READ_LOCKED_MINE_SRC}"); }

-.topic_unread { background-image: url("{IMG_TOPIC_UNREAD_SRC}"); }

-.topic_unread_mine { background-image: url("{IMG_TOPIC_UNREAD_MINE_SRC}"); }

-.topic_unread_hot { background-image: url("{IMG_TOPIC_UNREAD_HOT_SRC}"); }

-.topic_unread_hot_mine { background-image: url("{IMG_TOPIC_UNREAD_HOT_MINE_SRC}"); }

-.topic_unread_locked { background-image: url("{IMG_TOPIC_UNREAD_LOCKED_SRC}"); }

-.topic_unread_locked_mine { background-image: url("{IMG_TOPIC_UNREAD_LOCKED_MINE_SRC}"); }

-

-.pm_read { background-image: url("{IMG_TOPIC_READ_SRC}"); }

-.pm_unread { background-image: url("{IMG_TOPIC_UNREAD_SRC}"); }

- background-image: url("{T_THEME_PATH}/images/bg_tabs1.gif");

- background-image: url("{T_THEME_PATH}/images/bg_tabs2.gif");

- background-image: url("{T_THEME_PATH}/images/bg_menu.gif");

- background-image: url("{T_THEME_PATH}/images/bg_menu_rtl.gif");

- background-image: url("{T_THEME_PATH}/images/corners_left2.gif");

- background-image: url("{T_THEME_PATH}/images/corners_right2.gif");

- background-image: url("{T_THEME_PATH}/images/corners_left2.gif");

- background-image: url("{T_THEME_PATH}/images/corners_right2.gif");

- background-image: url("{T_THEME_PATH}/images/corners_left.gif");

- background-image: url("{T_THEME_PATH}/images/corners_right.gif");

- background-image: url("{T_THEME_PATH}/images/corners_left.gif");