-/***************************************************************************

- * admin_styles.php

- * -------------------

- * begin : Thu Aug 7 2003

- * copyright : © 2001 The phpBB Group

- * email : support@phpbb.com

- *

- * $Id$

- *

- ****************************************************************************/

-

-/***************************************************************************

- *

- * This program is free software; you can redistribute it and/or modify

- * it under the terms of the GNU General Public License as published by

- * the Free Software Foundation; either version 2 of the License, or

- * (at your option) any later version.

- *

- ***************************************************************************/

- $module['STYLE']['MANAGE_STYLE'] = $filename . "$SID&mode=styles";

- $module['STYLE']['MANAGE_THEME'] = $filename . "$SID&mode=themes";

-

-

- if ($update)

- $sql_from = STYLES_TABLE . ' s';

- $sql_where = "s.style_id = $style_id";

-

- if ($inc_template)

- {

- $sql_select .= ', t.*';

- $sql_from .= ', ' . STYLES_TPL_TABLE . ' t';

- $sql_where .= ' AND t.template_id = s.template_id';

- }

- if ($inc_theme)

- {

- $sql_select .= ', c.*';

- $sql_from .= ', ' . STYLES_CSS_TABLE . ' c';

- $sql_where .= ' AND c.theme_id = s.theme_id';

- }

- if ($inc_imageset)

- {

- $sql_select .= ', i.*';

- $sql_from .= ', ' . STYLES_IMAGE_TABLE . ' i';

- $sql_where .= ' AND i.imageset_id = s.imageset_id';

- }

- FROM $sql_from

- WHERE $sql_where";

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

- $$var = (!empty($row[$var])) ? $row[$var] : '';

- unset($row[$var]);

- $template_cfg = addslashes($template_name) . "\n";

- $template_cfg .= addslashes($template_copyright) . "\n";

- $template_cfg .= addslashes($config['version']) . "\n";

- $template_cfg .= addslashes($bbcode_bitfield) . "\n";

-

- $theme_cfg = addslashes($theme_name) . "\n";

- $theme_cfg .= addslashes($theme_copyright) . "\n";

- $theme_cfg .= addslashes($config['version']) . "\n";

- $imageset_cfg = addslashes($imageset_name) . "\n";

- $imageset_cfg .= addslashes($imageset_copyright) . "\n";

- $imageset_cfg .= addslashes($config['version']) . "\n";

-

- foreach (array_keys($row) as $key)

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

- unset($row[$key]);

- $files = array(

- array(

- 'src' => "styles/$template_path/template/",

- 'prefix-' => "styles/$template_path/",

- 'prefix+' => false,

- 'exclude' => 'template.cfg'),

- array(

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

- ),

- array(

- ),

- );

- $data = array(

- array(

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

- 'prefix' => 'style.cfg'

- ),

- array(

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

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

- ),

- array(

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

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

- ),

- array(

- ),

- );

-

- if ($css_storedb)

- {

- $data += array(

- array(

- 'src' => $css_data,

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

- ),

- unset($theme_data);

- unset($style_cfg);

- unset($theme_cfg);

- unset($template_cfg);

- unset($imageset_cfg);

-

-// export('style', $style_id, $style_name, str_replace(' ', '_', $style_name), $files, $data);

- else

- if (isset($_POST['update']))

- if ($action == 'install')

- $style_path = htmlspecialchars($_POST['style_path']);

- if (!($cfg = file("{$phpbb_root_path}styles/$style_path/style.cfg")))

- {

- trigger_error($user->lang['NO_STYLE']);

- }

- $style_name = trim($cfg[0]);

- $style_copyright = trim($cfg[1]);

- // Imageset

- if (!($cfg = file("{$phpbb_root_path}styles/$style_path/imageset/imageset.cfg")))

- {

- trigger_error($user->lang['NO_IMAGESET']);

- }

- $imageset_name = trim($cfg[0]);

- $imageset_copyright = trim($cfg[1]);

- $sql = 'SELECT imageset_id, imageset_name

- FROM ' . STYLES_IMAGE_TABLE . "

- WHERE imageset_name = '" . $db->sql_escape($imageset_name) . "'";

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

- // If an entry already exists we need not install this one

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

- if (empty($imageset_name))

- {

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

- }

-

- if (strlen($imageset_name) > 30)

- {

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

- }

-

- if (!preg_match('#^[a-z0-9_\-\+\. ]+$#i', $imageset_name))

- {

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

- }

-

- if (strlen($imageset_copyright) > 60)

- {

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

- }

-

- if (!sizeof($error))

- {

- $sql_img_ary = array();

-

- for ($i = 3; $i < sizeof($cfg); $i++)

- {

- $tmp = explode('||', $cfg[$i]);

- $sql_img_ary[$tmp[0]] = str_replace('{PATH}', "styles/$style_path/imageset/", trim($tmp[1]));

- }

-

- $sql_ary = array(

- 'imageset_name' => $imageset_name,

- 'imageset_copyright' => $imageset_copyright,

- 'imageset_path' => str_replace(' ', '_', $style_path),

- );

- $sql_ary += $sql_img_ary;

-

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

- $db->sql_query($sql);

- $imageset_id = $db->sql_nextid();

-

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

- }

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

- $db->sql_freeresult($result);

- unset($cfg);

- // Theme

- if (!($cfg = file("{$phpbb_root_path}styles/$style_path/theme/theme.cfg")))

- trigger_error($user->lang['NO_THEME']);

- }

- $theme_name = trim($cfg[0]);

- $theme_copyright = trim($cfg[1]);

-

- $sql = 'SELECT theme_id, theme_name

- FROM ' . STYLES_CSS_TABLE . "

- WHERE theme_name = '" . $db->sql_escape($theme_name) . "'";

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

- // If an entry already exists we need not install this one

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

- {

- if (empty($theme_name))

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

-

- if (strlen($theme_name) > 30)

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

- if (!preg_match('#^[a-z0-9_\-\+\. ]+$#i', $theme_name))

- {

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

- }

- if (strlen($theme_copyright) > 60)

- {

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

- }

- if (!sizeof($error))

- {

- $theme_storedb = 0;

- $theme_data = '';

- if (!is_writeable("{$phpbb_root_path}styles/$style_path/theme/stylesheet.css"))

- {

- $theme_data = implode('', file("{$phpbb_root_path}styles/$style_path/theme/stylesheet.css"));

- $theme_storedb = 1;

- }

- $sql_ary = array(

- 'theme_name' => $theme_name,

- 'theme_copyright' => $theme_copyright,

- 'theme_path' => str_replace(' ', '_', $style_path),

- 'theme_storedb' => $theme_storedb,

- 'theme_data' => $theme_data,

- );

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

- $db->sql_query($sql);

- $theme_id = $db->sql_nextid();

- $log = ($css_storedb) ? 'LOG_ADD_THEME_DB' : 'LOG_ADD_THEME_FS';

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

- }

- }

- else

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

- }

- $db->sql_freeresult($result);

- unset($cfg);

-

- // Template

- if (!($cfg = file("{$phpbb_root_path}styles/$style_path/template/template.cfg")))

- {

- trigger_error($user->lang['NO_TEMPLATE']);

- }

- $template_name = trim($cfg[0]);

- $template_copyright = trim($cfg[1]);

- $sql = 'SELECT template_id, template_name

- FROM ' . STYLES_TPL_TABLE . "

- WHERE template_name = '" . $db->sql_escape($template_name) . "'";

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

- // If an entry already exists we need not install this one

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

- {

- if (empty($template_name))

- {

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

- }

- if (strlen($template_name) > 30)

- {

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

- }

- if (!preg_match('#^[a-z0-9_\-\+\. ]+$#i', $template_name))

- {

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

- }

- if (strlen($template_copyright) > 60)

- {

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

- }

- if (!sizeof($error))

- {

- $sql_ary = array(

- 'template_name' => $template_name,

- 'template_copyright' => $template_copyright,

- 'template_path' => str_replace(' ', '_', $style_path),

- );

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

- $db->sql_query($sql);

- $template_id = $db->sql_nextid();

- $log = ($storedb) ? 'LOG_ADD_TEMPLATE_FS' : 'LOG_ADD_TEMPLATE_DB';

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

- }

- }

- else

- {

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

- }

- $db->sql_freeresult($result);

- unset($cfg);

- }

- else

- {

- $style_name = (isset($_POST['style_name'])) ? stripslashes(htmlspecialchars($_POST['style_name'])) : '';

- $style_copyright = (isset($_POST['style_copyright'])) ? stripslashes(htmlspecialchars($_POST['style_copyright'])) : '';

- $template_id = (!empty($_POST['template_id'])) ? intval($_POST['template_id']) : 0;

- $theme_id = (!empty($_POST['theme_id'])) ? intval($_POST['theme_id']) : 0;

- $imageset_id = (!empty($_POST['imageset_id'])) ? intval($_POST['imageset_id']) : 0;

- }

- $style_active = (!empty($_POST['style_active'])) ? 1 : 0;

- $style_default = (!empty($_POST['default_style'])) ? 1 : 0;

- if (empty($style_name))

- {

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

- }

- if (strlen($style_name) > 30)

- {

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

- }

- if (!preg_match('#^[a-z0-9_\-\+\. ]+$#i', $style_name))

- {

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

- }

- if (strlen($style_copyright) > 60)

- {

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

- }

- if (!$template_id || !$theme_id || !$imageset_id)

- {

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

- }

- $sql_where = ($action == 'add' || $action == 'install') ? "WHERE style_name = '" . $db->sql_escape($style_name) . "'" : "WHERE style_id <> $style_id AND style_name = '" . $db->sql_escape($style_name) . "'";

- $sql = 'SELECT style_name

- FROM ' . STYLES_TABLE . "

- $sql_where";

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

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

- {

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

- }

- $db->sql_freeresult($result);

- if (!sizeof($error))

- {

- $sql_ary = array(

- 'style_name' => $style_name,

- 'style_copyright' => $style_copyright,

- 'template_id' => $template_id,

- 'theme_id' => $theme_id,

- 'imageset_id' => $imageset_id,

- );

- $sql = ($action == 'add' || $action == 'install') ? 'INSERT INTO ' . STYLES_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary) : 'UPDATE ' . STYLES_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . " WHERE style_id = $style_id";

- $db->sql_query($sql);

- if ($action == 'add' || $action == 'install')

- {

- $style_id = $db->sql_nextid();

- }

- if ($style_default)

- {

- set_config('default_style', $style_id);

- }

- $log = ($action == 'add' || $action == 'install') ? 'LOG_ADD_STYLE' : 'LOG_EDIT_STYLE';

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

- $message = ($action == 'add' || $action == 'install') ? 'STYLED_ADDED' : 'STYLE_EDITED';

- trigger_error($user->lang[$message]);

- }

- }

- if (!sizeof($error))

- {

- if ($style_id)

- {

- $sql = 'SELECT *

- FROM ' . STYLES_TABLE . "

- WHERE style_id = $style_id";

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

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

- {

- trigger_error($user->lang['NO_STYLE']);

- $db->sql_freeresult($result);

- $style_default = ($config['default_style'] == $style_id) ? 1 : 0;

- }

- else

- {

- if ($action == 'install' && !empty($_GET['name']))

- $style_path = htmlspecialchars($_GET['name']);

- if (!file_exists("{$phpbb_root_path}styles/$style_path/style.cfg"))

- trigger_error($user->lang['NO_STYLE']);

- if (!($cfg = file("{$phpbb_root_path}styles/$style_path/style.cfg")))

- trigger_error($user->lang['NO_STYLE']);

- $style_version = preg_replace('#^2\.([0-9]+?)\.([0-9]+?).*?$#', '\1.\2', trim($cfg[2]));

- $phpbbversion = preg_replace('#^2\.([0-9]+?)\.([0-9]+?).*?$#', '\1.\2', $config['version']);

-

- if ($style_version != $phpbbversion)

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

- $style_name = trim($cfg[0]);

- $style_copyright = trim($cfg[1]);

-

- if (!($cfg = file("{$phpbb_root_path}styles/$style_path/imageset/imageset.cfg")))

- trigger_error($user->lang['NO_IMAGESET']);

- $imageset_name = trim($cfg[0]);

- unset($cfg);

- if (!($cfg = file("{$phpbb_root_path}styles/$style_path/theme/theme.cfg")))

- trigger_error($user->lang['NO_THEME']);

- $theme_name = trim($cfg[0]);

- unset($cfg);

- if (!($cfg = file("{$phpbb_root_path}styles/$style_path/template/template.cfg")))

- trigger_error($user->lang['NO_TEMPLATE']);

- $template_name = trim($cfg[0]);

- unset($cfg);

- $style_active = 1;

- $s_hidden_fields = '<input type="hidden" name="style_path" value="' . $style_path . '" />';

- }

- else

- {

- $style_name = (isset($_POST['style_name'])) ? stripslashes(htmlspecialchars($_POST['style_name'])) : '';

- $style_copyright = '';

- $style_active = 1;

- $template_id = $theme_id = $imageset_id = $style_default = 0;

- $field_ary = array(STYLES_CSS_TABLE => 'theme', STYLES_TPL_TABLE => 'template', STYLES_IMAGE_TABLE => 'imageset');

- foreach ($field_ary as $table => $field)

- $sql = "SELECT {$field}_id, {$field}_name

- ORDER BY {$field}_id";

- $selected = ($row[$field . '_id'] == ${$field . '_id'}) ? ' selected="selected"' : '';

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

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

-<h1><?php echo $user->lang['EDIT_STYLE']; ?></h1>

-<p><?php echo $user->lang['EDIT_STYLE_EXPLAIN']; ?></p>

- <th colspan="2"><?php echo $user->lang['EDIT_STYLE']; ?></th>

-

- <td class="row2"><input class="post" type="text" name="style_name" maxlength="30" size="30" value="<?php echo $style_name; ?>" /></td>

- echo ($action == 'edit' || $action == 'install') ? '<b>' . $style_copyright . '</b>' : '<input class="post" type="text" name="style_copyright" maxlength="60" size="30" value="' . $style_copyright . '" />';

- <td class="cat" colspan="2" align="center"><?php echo $s_hidden_fields; ?><input class="btnmain" type="submit" name="update" value="<?php echo $user->lang['SUBMIT']; ?>" />&nbsp;&nbsp;<!-- input class="btnlite" type="submit" name="preview" value="<?php echo $user->lang['PREVIEW']; ?>" />&nbsp;&nbsp;--><input class="btnlite" type="reset" value="<?php echo $user->lang['RESET']; ?>" /></td>

-</table></form>

- <td class="cat" colspan="6" align="right"><?php echo $user->lang['CREATE_STYLE']; ?>: <input class="post" type="text" name="style_name" value="" maxlength="30" size="25" /> <input class="btnmain" type="submit" name="add" value="<?php echo $user->lang['SUBMIT']; ?>" /></td>

- if (isset($_POST['update']))

- if (empty($_POST['update']))

- else if ($action == 'install' && empty($_POST['update']))

- if (isset($_POST['update']))

- <td class="row2"><input class="post" type="text" name="name" value="<?php echo $name; ?>" maxlength="30" size="25" /></td>

- echo ($action == 'add') ? '<input class="post" type="text" name="copyright" value="' . $copyright . '" maxlength="30" size="25" />' : "<b>$copyright</b>";

- $l_prefix = strtoupper($type);

-

- if (isset($_POST['update']))

- switch ($_POST['format'])

- {

- case 'tar':

- $ext = 'tar';

- $mimetype = 'x-tar';

- $compress = 'compress_tar';

- break;

-

- case 'zip':

- if (!extension_loaded('zlib'))

- {

- trigger_error($user->lang['NO_SUPPORT_ZIP']);

- }

- $ext = 'zip';

- $mimetype = 'zip';

- $compress = 'compress_zip';

- break;

-

- case 'tar.gz':

- if (!extension_loaded('zlib'))

- {

- trigger_error($user->lang['NO_SUPPORT_GZ']);

- }

- $ext = 'tar.gz';

- $mimetype = 'x-gzip';

- $compress = 'compress_tar';

- break;

-

- case 'tar.bz2':

- if (!extension_loaded('bz2'))

- {

- trigger_error($user->lang['NO_SUPPORT_BZ2']);

- }

- $ext = 'tar.bz2';

- $mimetype = 'x-bzip2';

- $compress = 'compress_tar';

- break;

-

- default:

- $error[] = $user->lang[$l_prefix . '_ERR_ARCHIVE'];

- }

-

- if (!sizeof($error))

- {

- if (!($zip = new $compress('w', "{$phpbb_root_path}store/$path.$ext")))

- {

- trigger_error($user->lang['STORE_UNWRITEABLE']);

- }

-

- if ($files)

- {

- foreach ($files as $file_ary)

- {

- $zip->add_file($file_ary['src'], $file_ary['prefix-'], $file_ary['prefix+'], $file_ary['exclude']);

- }

- }

-

- if ($data)

- {

- foreach ($data as $data_ary)

- {

- $zip->add_data($data_ary['src'], $data_ary['prefix']);

- }

- }

-

- $zip->close();

-

- add_log('admin', 'LOG_EXPORT_' . $l_prefix, $name);

-

- if (empty($_POST['store']))

- {

- header('Pragma: no-cache');

- header("Content-Type: application/$mimetype; name=\"$path.$ext\"");

- header("Content-disposition: attachment; filename=$path.$ext");

-

- $fp = fopen("{$phpbb_root_path}store/$path.$ext", 'rb');

- while ($buffer = fread($fp, 1024))

- {

- echo $buffer;

- }

- fclose($fp);

- @unlink("{$phpbb_root_path}store/{$type}_$path.$ext");

- exit;

- }

-

- trigger_error(sprintf($user->lang[$l_prefix . '_EXPORTED'], "store/$path.$ext"));

- }