return;

}

break;

case 'install':

$this->install($mode);

return;

$this->add($mode);

return;

break;

case 'details':

if ($style_id)

{

return;

}

break;

case 'edit':

if ($style_id)

{

return $this->edit_imageset($style_id);

case 'template':

return $this->edit_template($style_id);

}

}

break;

switch ($mode)

{

case 'style':

switch ($action)

{

case 'activate':

}

$sql = 'UPDATE ' . STYLES_TABLE . '

WHERE style_id = ' . $style_id;

$db->sql_query($sql);

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

if ($action == 'deactivate')

{

WHERE user_style = $style_id";

$db->sql_query($sql);

SET forum_style = 0

WHERE forum_style = ' . $style_id;

$db->sql_query($sql);

{

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

FROM ' . STYLES_TPLDATA_TABLE . "

WHERE template_id = $style_id";

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

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

unset($filelist);

}

break;

}

{

// Refresh/Renew theme cache

case 'refresh':

$sql = 'SELECT *

FROM ' . STYLES_CSS_TABLE . "

WHERE theme_id = $style_id";

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

{

// Match CSS imports

$matches = array();

preg_match_all('/@import url\(\"(.*)\"\);/i', $theme_data, $matches);

if (sizeof($matches))

{

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

$theme_data = str_replace($match, $this->load_css_file($theme_row['theme_path'], $matches[1][$idx]), $theme_data);

}

}

// Save CSS contents

$sql_ary = array(

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

);

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

$sql_from = STYLES_TABLE;

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

GROUP BY user_style';

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

$db->sql_freeresult($result);

break;

case 'template':

$sql_from = STYLES_TPL_TABLE;

break;

)

);

FROM $sql_from";

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

{

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

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

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

$s_options = array();

{

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

}

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

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

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

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

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

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

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

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

// Grab uninstalled items

$new_ary = $cfg = array();

/**

* @todo grab templates/themes/imagesets from style directories

*/

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

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

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

// Retrieve some information about the template

$sql = 'SELECT template_storedb, template_path, template_name

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

{

WHERE template_id = ' . $template_id;

$db->sql_query($sql);

}

// Update the template_data table entry for this template file

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

$db->sql_query($sql);

// destroy the cached version of the template

@unlink("{$phpbb_root_path}cache/tpl_{$template_info['template_name']}_" . str_replace('/', '.', $template_file) . ".$phpEx");

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

}

}

else

{

WHERE template_id = $template_id";

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

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

'U_BACK' => $this->u_action,

'TEMPLATE_FILE' => $template_file,

'TEMPLATE_DATA' => htmlentities($template_data),

'TEXT_ROWS' => $text_rows)

}

/**

* Edit imagesets

*/

{

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

$imgsize = (!empty($_POST['imgsize'])) ? true : false;

$imgwidth = (isset($_POST['imgwidth'])) ? intval($_POST['imgwidth']) : '';

{

$sql_select = ($imgname) ? ", $imgname" : '';

$sql = "SELECT imageset_path, imageset_name, imageset_copyright$sql_select

FROM " . STYLES_IMAGE_TABLE . "

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

if (!extract($db->sql_fetchrow($result)))

'folders' => array(

'folder', 'folder_posted', 'folder_new', 'folder_new_posted', 'folder_hot', 'folder_hot_posted', 'folder_hot_new', 'folder_hot_new_posted', 'folder_locked', 'folder_locked_posted', 'folder_locked_new', 'folder_locked_new_posted', 'folder_sticky', 'folder_sticky_posted', 'folder_sticky_new', 'folder_sticky_new_posted', 'folder_announce', 'folder_announce_posted', 'folder_announce_new', 'folder_announce_new_posted',),

'polls' => array(

);

foreach ($imglist as $category => $img_ary)

$sql = 'UPDATE ' . STYLES_IMAGE_TABLE . "

SET $imgname = '" . $db->sql_escape($imgpath) . "'

$db->sql_query($sql);

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

'IMAGELIST_OPTIONS' => $imagesetlist_options,

'IMAGE_SIZE' => $imgsize_bool,

'IMAGE_REQUEST' => (!empty($imgname)) ? '../styles/' . $imageset_path . '/imageset/' . str_replace('{LANG}', $imglang, current(explode('*', $$imgname))) : '',

'U_BACK' => $this->u_action,

'NAME' => $imageset_name,

'ERROR' => !$valid_name

function remove($mode, $style_id)

{

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

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

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

}

$l_prefix = strtoupper($mode);

$sql = "SELECT $sql_select

WHERE {$mode}_id = $style_id";

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

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

{

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

}

ORDER BY {$mode}_name ASC";

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

if ($update)

{

WHERE {$mode}_id = $style_id";

$db->sql_query($sql);

if ($mode == 'style')

{

SET user_style = $new_id

WHERE user_style = $style_id";

$db->sql_query($sql);

SET forum_style = $new_id

WHERE forum_style = $style_id";

$db->sql_query($sql);

}

else

{

WHERE {$mode}_id = $style_id";

$db->sql_query($sql);

}

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

'U_BACK' => $this->u_action,

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

)

);

$l_prefix = 'IMAGESET';

break;

}

if ($update && !sizeof($error))

{

WHERE $sql_where";

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

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

$style_row[$var] = '';

}

}

$files = $data = array();

if ($mode == 'style')

{

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

$style_cfg .= (!$inc_template) ? "\ntemplate = {$style_row['template_name']}" : '';

$style_cfg .= (!$inc_theme) ? "\ntheme = {$style_row['theme_name']}" : '';

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

$data[] = array(

'prefix' => 'style.cfg'

);

$template_cfg .= "\nbbcode_bitfield = {$style_row['bbcode_bitfield']}";

$data[] = array(

'prefix' => 'template/template.cfg'

);

if (!$style_row['template_storedb'])

{

$files[] = array(

'exclude' => 'template.cfg'

);

}

else

{

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

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

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

{

$data[] = array(

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

);

}

if ($mode == 'theme' || $inc_theme)

{

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

// Read old cfg file

$items = $cache->obtain_cfg_items($style_row);

$items = $items['theme'];

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

$files[] = array(

);

$data[] = array(

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

);

if ($style_row['theme_storedb'])

{

$data[] = array(

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

);

}

$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_definitions = explode(', ', $this->imageset_keys);

foreach ($imageset_definitions as $key)

{

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

}

$files[] = array(

'exclude' => 'imageset.cfg'

);

$data[] = array(

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

);

unset($imageset_cfg);

}

{

$compress = new compress_tar('w', $phpbb_root_path . "store/$path$ext", $ext);

}

if (sizeof($files))

{

foreach ($files as $file_ary)

}

}

FROM " . (($mode == 'style') ? STYLES_TABLE : $sql_from) . "

WHERE {$mode}_id = $style_id";

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

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

$db->sql_freeresult($result);

if (!$style_row)

{

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

case 'style':

$sql_from = STYLES_TABLE;

break;

case 'template':

$sql_from = STYLES_TPL_TABLE;

break;

break;

}

FROM $sql_from

WHERE {$mode}_id = $style_id";

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

}

}

}

if ($update && sizeof($error))

{

$style_row = array_merge($style_row, array(

{

$theme_data = '';

{

// Match CSS imports

$matches = array();

preg_match_all('/@import url\(\"(.*)\"\);/i', $theme_data, $matches);

if (sizeof($matches))

{

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

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

{

$store_db = 1;

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;

$theme_data = str_replace('./', "styles/{$style_row['theme_path']}/theme/", $theme_data);

$sql_ary += array(

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

);

}

break;

case 'template':

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

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

{

WHERE template_id = $style_id";

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

if (!$store_db)

{

WHERE template_id = $style_id";

$db->sql_query($sql);

}

}

$sql_ary += array(

);

}

break;

if (sizeof($sql_ary))

{

WHERE {$mode}_id = $style_id";

$db->sql_query($sql);

foreach ($element_ary as $element => $table)

{

$sql = "SELECT {$element}_id, {$element}_name

ORDER BY {$element}_id ASC";

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

function load_css_file($path, $filename)

{

global $phpbb_root_path;

{

}

else

{

$content = '';

}

return $content;

}

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

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

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

);

if ($mode == 'insert')

}

else

{

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

}

$db->sql_query($sql);

$this->test_installed($element, $error, $root_path, ${'reqd_' . $element}, $style_row[$element . '_id'], $style_row[$element . '_name'], $style_row[$element . '_copyright']);

}

break;

case 'template':

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

$style_row['style_active'] = request_var('style_active', 1);

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

// User has submitted form and no errors have occured

if ($update && !sizeof($error))

{

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

'S_STYLE_ACTIVE' => (isset($style_row['style_active'])) ? $style_row['style_active'] : 0,

'S_STYLE_DEFAULT' => (isset($style_row['style_default'])) ? $style_row['style_default'] : 0,

'U_ACTION' => $this->u_action . "&amp;action=install&amp;path=" . urlencode($install_path),

'U_BACK' => $this->u_action,

break;

}

WHERE {$mode}_id = $basis";

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

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

$db->sql_freeresult($result);

{

$error[] = $user->lang['NO_' . $l_type];

}

foreach ($element_ary as $element => $table)

{

$sql = "SELECT {$element}_id, {$element}_name

ORDER BY {$element}_id ASC";

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

);

}

/**

* Is this element installed? If not, grab its cfg details

*/

case 'template':

$sql_from = STYLES_TPL_TABLE;

break;

case 'theme':

$sql_from = STYLES_CSS_TABLE;

break;

$chk_name = ($reqd_name !== false) ? $reqd_name : $name;

FROM $sql_from

WHERE {$element}_name = '" . $db->sql_escape($chk_name) . "'";

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

}

$cfg = parse_cfg_file("$root_path$element/$element.cfg", $cfg);

$name = $cfg['name'];

$copyright = $cfg['copyright'];

$id = 0;

$db->sql_transaction('begin');

$sql_ary = array(

);

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

$db->sql_query($sql);

if ($default)

{

WHERE user_style = " . $config['default_style'];

$db->sql_query($sql);

case 'theme':

$sql_from = STYLES_CSS_TABLE;

break;

case 'imageset':

$sql_from = STYLES_IMAGE_TABLE;

break;

{

@mkdir("{$phpbb_root_path}styles/$path", 0777);

@chmod("{$phpbb_root_path}styles/$path", 0777);

if ($root_path)

{

$this->copy_files("$root_path$type", filelist("$root_path$type", '', '*'), "$path/$type");

*/

$sql_ary = array(

$mode . '_name' => $name,

$mode . '_path' => $path,

);

case 'theme':

$sql_ary += array(

'theme_mtime' => ($store_db) ? filemtime("{$phpbb_root_path}styles/$path/theme/stylesheet.css") : 0

);

break;

$db->sql_transaction('begin');

" . $db->sql_build_array('INSERT', $sql_ary);

$db->sql_query($sql);

$id = $db->sql_nextid();

{

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

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