$sql = 'UPDATE ' . STYLES_TABLE . '

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

WHERE style_id = ' . $style_id;

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

if ($action == 'deactivate')

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_style = ' . phpbb::$config['default_style'] . "

WHERE user_style = $style_id";

$sql = 'UPDATE ' . FORUMS_TABLE . '

SET forum_style = 0

WHERE forum_style = ' . $style_id;

}

break;

}

$sql = 'SELECT *

FROM ' . STYLES_TEMPLATE_TABLE . "

WHERE template_id = $style_id";

if (!$template_row)

{

$sql = 'SELECT *

FROM ' . STYLES_THEME_TABLE . "

WHERE theme_id = $style_id";

if (!$theme_row)

{

'theme_data' => self::db_theme_data($theme_row)

);

WHERE theme_id = $style_id";

phpbb::$acm->destroy_sql(STYLES_THEME_TABLE);

$sql = 'SELECT *

FROM ' . STYLES_IMAGESET_TABLE . "

WHERE imageset_id = $style_id";

if (!$imageset_row)

{

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

$sql = 'DELETE FROM ' . STYLES_IMAGESET_DATA_TABLE . '

WHERE imageset_id = ' . $style_id;

foreach ($cfg_data_imageset as $image_name => $value)

{

$sql = 'SELECT lang_dir

FROM ' . LANG_TABLE;

{

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

{

}

}

}

phpbb::$acm->destroy_sql(STYLES_IMAGESET_DATA_TABLE);

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

FROM ' . USERS_TABLE . '

GROUP BY user_style';

{

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

}

break;

$sql = "SELECT *

FROM $sql_from";

$installed = array();

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

{

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

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

)

);

}

// Grab uninstalled items

$new_ary = $cfg = array();

$sql = 'SELECT template_path, template_name

FROM ' . STYLES_TEMPLATE_TABLE . "

WHERE template_id = $template_id";

if (!$template_info)

{

$sql = 'SELECT *

FROM ' . STYLES_TEMPLATE_TABLE . "

WHERE template_id = $template_id";

if (!$template_row)

{

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

FROM ' . STYLES_THEME_TABLE . "

WHERE theme_id = $theme_id";

{

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

}

$theme_info['theme_id'] = $theme_id;

self::generate_stylesheets($theme_info);

'theme_data' => self::db_theme_data($theme_info, $theme_data),

);

$sql = 'UPDATE ' . STYLES_THEME_TABLE . '

WHERE theme_id = ' . $theme_id;

phpbb::$acm->destroy_sql(STYLES_THEME_TABLE);

$sql = 'SELECT imageset_path, imageset_name

FROM ' . STYLES_IMAGESET_TABLE . "

WHERE imageset_id = $imageset_id";

$imageset_path = $imageset_row['imageset_path'];

$imageset_name = $imageset_row['imageset_name'];

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

{

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

}

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

FROM ' . STYLES_IMAGESET_DATA_TABLE . "

WHERE imageset_id = $imageset_id

$image_filename = $imageset_data_row['image_filename'];

$image_width = $imageset_data_row['image_width'];

if ($imageset_data_row)

{

$sql = 'UPDATE ' . STYLES_IMAGESET_DATA_TABLE . '

WHERE image_id = $image_id";

}

// does not exist

else if (!$imageset_data_row)

{

$sql_ary['image_name'] = $imgname;

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

}

phpbb::$acm->destroy_sql(STYLES_IMAGESET_DATA_TABLE);

$sql = "SELECT $sql_select

FROM $sql_from

WHERE {$mode}_id = $style_id";

if (!$style_row)

{

WHERE {$mode}_id <> $style_id

$sql_where

ORDER BY {$mode}_name ASC";

$s_options = '';

{

do

{

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

}

}

else

{

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

}

if ($update)

{

$sql = "DELETE FROM $sql_from

WHERE {$mode}_id = $style_id";

if ($mode == 'style')

{

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_style = $new_id

WHERE user_style = $style_id";

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET forum_style = $new_id

WHERE forum_style = $style_id";

if ($style_id == phpbb::$config['default_style'])

{

{

$sql = 'DELETE FROM ' . STYLES_IMAGESET_DATA_TABLE . "

WHERE imageset_id = $style_id";

}

$sql = 'UPDATE ' . STYLES_TABLE . "

SET {$mode}_id = $new_id

WHERE {$mode}_id = $style_id";

}

phpbb::$acm->destroy_sql(STYLES_TABLE);

$sql = "SELECT $sql_select

FROM $sql_from

WHERE $sql_where";

if (!$style_row)

{

FROM ' . STYLES_IMAGESET_DATA_TABLE . "

WHERE imageset_id = $style_id

AND image_lang = ''";

{

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

}

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

{

FROM ' . STYLES_IMAGESET_DATA_TABLE . "

WHERE imageset_id = $style_id

AND image_lang <> ''";

{

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

}

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

{

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

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

WHERE {$mode}_id = $style_id";

if (!$style_row)

{

$sql = "SELECT *

FROM $sql_from

WHERE {$mode}_id = $style_id";

if (!$style_row)

{

$sql = "SELECT {$mode}_id

FROM $sql_from

WHERE {$mode}_id <> $style_id

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

{

if (sizeof($sql_ary))

{

$sql = "UPDATE $sql_from

WHERE {$mode}_id = $style_id";

// Making this the default style?

if ($mode == 'style' && $style_default)

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

FROM $table

ORDER BY {$element}_id ASC";

${$element . '_options'} = '';

{

$selected = ($row[$element . '_id'] == $style_row[$element . '_id']) ? ' selected="selected"' : '';

${$element . '_options'} .= '<option value="' . $row[$element . '_id'] . '"' . $selected . '>' . $row[$element . '_name'] . '</option>';

}

}

}

$sql = "SELECT $sql_select

FROM $sql_from

WHERE {$mode}_id = $basis";

if (!$row)

{

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

FROM $table

ORDER BY {$element}_id ASC";

${$element . '_options'} = '';

{

$selected = ($row[$element . '_id'] == $style_row[$element . '_id']) ? ' selected="selected"' : '';

${$element . '_options'} .= '<option value="' . $row[$element . '_id'] . '"' . $selected . '>' . $row[$element . '_name'] . '</option>';

}

}

}

// get all the lang_dirs

$sql = 'SELECT lang_dir

FROM ' . LANG_TABLE;

{

$lang_dirs[] = $row['lang_dir'];

}

// get all imagesets this theme is associated with

$sql = 'SELECT si.imageset_id, si.imageset_path, st.template_path

WHERE s.theme_id = ' . (int) $theme['theme_id'] . '

AND s.imageset_id = si.imageset_id

AND s.template_id = st.template_id';

{

foreach ($lang_dirs as $lang_dir)

{

FROM ' . STYLES_IMAGESET_DATA_TABLE . '

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

AND image_filename <> ''

$img_array = array();

{

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

}

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

file_put_contents(PHPBB_ROOT_PATH . '/store/' . $theme['theme_id'] . '_' . $theme['imageset_id'] . '_' . $lang_dir . '.css', $specific_theme_data, LOCK_EX);

}

}

}

/**

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

FROM $sql_from

{

$name = $row[$element . '_name'];

$id = $row[$element . '_id'];

unset($cfg);

}

}

/**

// Check if the name already exist

$sql = 'SELECT style_id

FROM ' . STYLES_TABLE . "

if ($row)

{

return false;

}

$sql_ary = array(

'style_name' => $name,

);

$sql = 'INSERT INTO ' . STYLES_TABLE . '

if ($default)

{

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_style = $id

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

set_config('default_style', $id);

}

add_log('admin', 'LOG_STYLE_ADD', $name);

}

// Check if the name already exist

$sql = "SELECT {$mode}_id

FROM $sql_from

if ($row)

break;

}

$sql = "INSERT INTO $sql_from

if ($mode == 'imageset')

{

'imageset_id' => (int) $id,

'image_lang' => '',

);

}

}

}

$sql = 'SELECT lang_dir

FROM ' . LANG_TABLE;

{

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

{

'imageset_id' => (int) $id,

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

);

}

}

}

unset($cfg_data_imageset_data);

}

}

}

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

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