lang['EDIT_TEMPLATE_EXPLAIN']; ?>
lang['SELECTED_TEMPLATE'] . ": $template_name"; ?>
sql_query($sql); if (!(extract($db->sql_fetchrow($result)))) { trigger_error($user->lang['NO_TEMPLATE']); } $db->sql_freeresult($result); $cache_prefix = "tpl_$template_path"; // User wants to delete one or more files ... if ($_POST['update'] && $file_ary) { foreach ($file_ary as $file) { $file = "{$phpbb_root_path}cache/{$cache_prefix}_$file.html.$phpEx"; if (file_exists($file) && is_file($file)) { @unlink($file); } } unset($file_ary); add_log('admin', 'LOG_CLEAR_TPLCACHE', $template_name); trigger_error($user->lang['TEMPLATE_CACHE_CLEARED']); } // Someone wants to see the cached source ... so we'll highlight it, // add line numbers and indent it appropriately. This could be nasty // on larger source files ... if ($source && file_exists("{$phpbb_root_path}cache/{$cache_prefix}_$source.html.$phpEx")) { adm_page_header($user->lang['TEMPLATE_CACHE']); ?> ', '', '','[', ']', '.');
$str_to = array('';
$str_to[] = '';
$str_from[] = '<?php ';
$str_to[] = '';
$str_from[] = '?>';
$str_to[] = '';
}
$code = str_replace($str_from, $str_to, $code);
$code = preg_replace('#^()\n?(.*?)\n?()$#is', '\1\2\3', $code);
$code = explode("$marker", $code);
?>
| $j) { $indent = substr($indent, 0, -6); $j++; } unset($code[$key]); ?> |
lang['TEMPLATE_CACHE_EXPLAIN']; ?>
sql_query($sql); if (!extract($db->sql_fetchrow($result))) { trigger_error($user->lang['NO_TEMPLATE']); } $db->sql_freeresult($result); if ($template_storedb && file_exists("{$phpbb_root_path}styles/$template_path/template/")) { $filelist = array('/' => array()); $sql = 'SELECT template_filename, template_mtime FROM ' . STYLES_TPLDATA_TABLE . " WHERE template_id = $id"; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) { if (@filemtime("{$phpbb_root_path}styles/$template_path/template/" . $row['template_filename']) > $row['template_mtime']) { $filelist['/'][] = $row['template_filename']; } } $db->sql_freeresult($result); store_templates('update', $id, $template_path, $filelist); unset($filelist); } } break; } // Front page frontend('template', array('cache', 'details', 'refresh', 'export', 'delete')); break; // THEMES case 'theme': switch ($action) { case 'edit': // General parameters $class = (isset($_POST['classname'])) ? htmlspecialchars($_POST['classname']) : ''; $customclass = (!empty($_POST['customclass'])) ? htmlspecialchars($_POST['customclass']) : ''; $txtcols = (isset($_POST['txtcols'])) ? max(20, intval($_POST['txtcols'])) : 76; $txtrows = (isset($_POST['txtrows'])) ? max(5, intval($_POST['txtrows'])) : 10; $showcss = (!empty($_POST['showcss'])) ? true : ((!empty($_POST['hidecss'])) ? false : ((!empty($_GET['showcss'])) ? true : false)); // List of default classes, categorised $base_classes = array( 'text' => array( 'body', 'p', 'h1', 'h2', 'h3', '.tabletitle', '.cattitle', '.topictitle', '.topicauthor', '.topicdetails', '.postdetails', '.postbody', '.posthilit', '.postauthor', '.mainmenu', '.nav', '.genmed', '.gensmall', '.copyright', ), 'tables' => array( 'table', 'th', '.cat', '.catdiv', 'td', '.row1', '.row2', '.row3', '.spacer', 'hr', ), 'forms' => array( 'form', 'input', 'select', 'textarea', '.post', '.btnlite', '.btnmain', '.btnbbcode', ), 'bbcode' => array( '.b', '.u', '.i', '.color', '.size', '.code', '.quote', '.flash', '.syntaxbg', '.syntaxcomment', '.syntaxdefault', '.syntaxhtml', '.syntaxkeyword', '.syntaxstring', ), 'custom' => array(), ); // We categorise the elements which comprise the css class so that we set // any appropriate additional data, e.g. sizes require the scale type to be set, // images require the relevant image be pulled and selected in the dropdown, etc. $match_elements = array( 'colors' => array('background-color', 'color',), 'sizes' => array('font-size', 'line-height',), 'images' => array('background-image',), 'repeat' => array('background-repeat',), 'other' => array('font-weight', 'font-family', 'font-style', 'text-decoration',), ); // Used in an sprintf statement to generate appropriate output for rawcss mode $map_elements = array( 'colors' => '%s', 'sizes' => '%d%s', 'images' => 'url(\'./%s\')', 'repeat' => '%s', 'other' => '%s', ); $s_hidden_fields = ''; // Do we want to edit an existing theme? if ($id) { $sql = 'SELECT * FROM ' . STYLES_CSS_TABLE . " WHERE theme_id = $id"; $result = $db->sql_query($sql); if (!(extract($db->sql_fetchrow($result)))) { trigger_error($user->lang['NO_THEME']); } $db->sql_freeresult($result); // Where is the CSS stored? if (!$theme_storedb) { if (!($fp = fopen("{$phpbb_root_path}styles/$theme_path/theme/stylesheet.css", 'rb'))) { trigger_error($user->lang['NO_THEME']); } $stylesheet = fread($fp, filesize("{$phpbb_root_path}styles/$theme_path/theme/stylesheet.css")); fclose($fp); } else { $stylesheet = &$theme_data; } // Pull out list of "custom" tags $class_used = $test_ary = array(); if (preg_match_all('/^([a-z0-9\.:#>]+?)[ \t]*?\{.*?\}/msi', $stylesheet, $matches)) { foreach ($base_classes as $category => $class_ary) { $test_ary = array_merge($test_ary, $class_ary); } foreach ($matches[1] as $value) { if (!in_array($value, $test_ary)) { $base_classes['custom'][] = $value; } else { $class_used[] = $value; } } unset($matches); unset($test_ary); } } // Do we have a class set? If so, we need to extract and set the relevant data if (!empty($class)) { // We must generate the relevant data ... what we need depends on whether // we are looking @ the rawcss or the simplified settings and whether we // have just selected a class. We must also cope with switching between // simple and rawcss mode $css_element = array(); if (!empty($_POST['rawcss']) && (!empty($_POST['hidecss']) || !empty($_POST['preview']) || $update)) { $css_element = trim(stripslashes(htmlspecialchars(preg_replace("#;[\r\n]*#s", "\n", $_POST['rawcss'])))); $css_element = explode("\n", $css_element); } else if (($showcss && !empty($_POST['showcss'])) || !empty($_POST['preview']) || $update) { if (!empty($_POST['cssother'])) { $css_element = explode(';', stripslashes(htmlspecialchars(trim($_POST['cssother'])))); } foreach ($match_elements as $type => $match_ary) { foreach ($match_ary as $match) { $var = str_replace('-', '_', $match); if (!empty($_POST[$var])) { $css_element[] = str_replace('_', '-', $var) . ': ' . (($type == 'sizes') ? sprintf($map_elements[$type], stripslashes($_POST[$var]), $_POST[$var . '_units']) : sprintf($map_elements[$type], stripslashes($_POST[$var]))); } } } } else if (preg_match('#^' . $class . '[ \t]*?\{(.*?)\}#ms', $stylesheet, $matches)) { $css_element = explode(';', substr(trim($matches[1]), 0, -1)); } $css_element = preg_replace('#^\s*(.*?)\s*$#', '\1', $css_element); // User wants to submit data ... if ($update || $customclass) { if ($update) { $updated_element = trim(implode('; ', $css_element)) . ';'; if (preg_match('#^' . $class . '[ \t]*?\{(.*?)\}#ms', $stylesheet)) { $stylesheet = preg_replace('#^(' . $class . '[ \t]*?\{).*?(\})#m', '\1 ' . $updated_element . ' \2', $stylesheet); } $error[] = $user->lang['THEME_UPDATED']; } else { // Check custom class name is valid if (!preg_match('/^[a-z0-9#:\.]+$/i', $customclass)) { $error[] = $user->lang['THEME_ERR_CLASS_CHARS']; } else { $stylesheet .= "\n$customclass { }"; $base_classes['custom'][] = $customclass; $error[] = $user->lang['THEME_CLASS_ADDED']; } } // Where is the CSS stored? if (!$storedb && is_writeable("{$phpbb_root_path}styles/$theme_path/theme/stylesheet.css")) { // Grab template data if (!($fp = fopen("{$phpbb_root_path}styles/$theme_path/theme/stylesheet.css", 'wb'))) { trigger_error($user->lang['NO_THEME']); } $stylesheet = fwrite($fp, $stylesheet); fclose($fp); } else { // We change the path to one relative to the root rather than the theme folder $sql_ary = array( 'theme_storedb' => 1, 'theme_data' => str_replace('./', "styles/$theme_path/theme/", $stylesheet), ); $sql = 'UPDATE ' . STYLES_CSS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . ' WHERE theme_id = ' . $id; $db->sql_query($sql); } $cache->destroy('sql', STYLES_CSS_TABLE); add_log('admin', 'LOG_EDIT_THEME', $theme_name); } // I guess really this needs some basic examples, pulled from subSilver // to demonstrate the default classes. Other, custom classes can just use // the div/span and some text? This is gonna get nasty :( if (!empty($_POST['preview'])) { // Temp, just to get this out of the way theme_preview($theme_path, $stylesheet, $class, $css_element); exit; } // Here we pull out the appropriate class entry then proceed to pull it apart, // setting appropriate variables to their respective values. We only match // certain css elements, the rest are "hidden" and can be accessed by exposing // the raw css if (!$showcss) { foreach ($match_elements as $type => $match_ary) { foreach ($match_ary as $match) { $var = str_replace('-', '_', $match); $$var = ''; if (sizeof($css_element)) { foreach ($css_element as $key => $element) { if (preg_match('#^' . preg_quote($match, '#') . ':[ \t]*?(.*?)$#', $element, $matches)) { switch ($type) { case 'sizes': if (preg_match('#(.*?)(px|%|em|pt)#', $matches[1], $matches)) { ${$var . '_units'} = trim($matches[2]); } $$var = trim($matches[1]); break; case 'images': if (preg_match('#url\(\'(.*?)\'\)#', $matches[1], $matches)) { $$var = trim($matches[1]); $$var = str_replace('./', $theme_name . '/', $$var); } break; default: $$var = trim($matches[1]); } // Remove this element from array unset($css_element[$key]); break; } } } } } // Any remaining elements must be custom data so we save that // in a hidden field if (sizeof($css_element)) { $s_hidden_fields .= ''; } } } // End of class element variable setting // Generate list of class options $class_options = ''; foreach ($base_classes as $category => $class_ary) { $class_options .= ''; foreach ($class_ary as $class_name) { $used = (in_array($class_name, $class_used) || $category == 'custom') ? ' style="color:red"' : ''; $selected = ($class_name == $class) ? ' selected="selected"' : ''; $class_options .= 'lang['EDIT_THEME_EXPLAIN']; ?>
lang['SELECTED_THEME'] . ": $theme_name"; ?>
lang['SHOW_RAW_CSS_EXPLAIN']; ?>
array( 'btn_post', 'btn_reply', 'btn_locked', 'btn_quote', 'btn_edit', 'btn_delete', 'btn_report', 'btn_post_pm', 'btn_reply_pm', 'btn_profile', 'btn_pm', 'btn_ip', 'btn_search', 'btn_email', 'btn_www', 'btn_icq', 'btn_aim', 'btn_yim', 'btn_msnm', 'btn_jabber', 'btn_online', 'btn_offline', ), 'icons' => array( 'icon_unapproved', 'icon_reported', 'icon_attach', 'icon_post', 'icon_post_new', 'icon_post_latest', 'icon_post_newest',), 'forums' => array( 'forum', 'forum_new', 'forum_locked', 'forum_link', 'sub_forum', 'sub_forum_new',), '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( 'poll_left', 'poll_center', 'poll_right',), ); switch ($action) { case 'edit': $imgname = (!empty($_POST['imgname'])) ? htmlspecialchars($_POST['imgname']) : ''; $imgpath = (isset($_POST['imgpath'])) ? htmlspecialchars($_POST['imgpath']) : ''; $imgsize = (!empty($_POST['imgsize'])) ? true : false; $imgwidth = (isset($_POST['imgwidth'])) ? intval($_POST['imgwidth']) : ''; if ($id) { $sql_select = ($imgname) ? ", $imgname" : ''; $sql = "SELECT imageset_path, imageset_name, imageset_copyright$sql_select FROM " . STYLES_IMAGE_TABLE . " WHERE imageset_id = $id"; $result = $db->sql_query($sql); if (!extract($db->sql_fetchrow($result))) { trigger_error($user->lang['NO_IMAGESET']); } $db->sql_freeresult($result); // Check to see whether the selected image exists in the table $valid_name = false; foreach ($imglist as $category => $img_ary) { if (in_array($imgname, $img_ary)) { $valid_name = true; break; } } if (!$valid_name) { $error[] = $user->lang['NO_IMAGE']; } if ($update && $imgpath) { if (!sizeof($error)) { // 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 = $imgheight = ''; if ($imgsize) { list($imgwidth, $imgheight) = getimagesize("{$phpbb_root_path}styles/$imageset_path/imageset/$imgpath"); $imgwidth = ($imgname != 'poll_center') ? " width=\"$imgwidth\"" : ''; $imgheight = " height=\"$imgheight\""; } $imgpath = '"styles/' . $imageset_path . '/imageset/' . preg_replace('#^(.*?)/(.*?)$#', '{LANG}/\2', $imgpath) . '" border="0"' . $imgwidth . $imgheight; $sql = 'UPDATE ' . STYLES_IMAGE_TABLE . " SET $imgname = '$imgpath' WHERE imageset_id = $id"; $db->sql_query($sql); $cache->destroy('sql', STYLES_IMAGE_TABLE); add_log('admin', 'LOG_EDIT_IMAGESET', $imageset_name); $error[] = $user->lang['IMAGESET_UPDATED']; $$imgname = $imgpath; } } $test_ary = array(); foreach ($imglist as $category => $img_ary) { foreach ($img_ary as $img) { if (!empty($$img)) { $test_ary[] = preg_replace('#^"styles/' . $imageset_path . '/imageset/(\{LANG\}/)?(.*?)".*$#', '\2', $$img); } } } unset($test_ary); } // Generate list of image options $img_options = ''; foreach ($imglist as $category => $img_ary) { $img_options .= (sizeof($img_ary)) ? '' : ''; foreach ($img_ary as $img) { $selected = ($img == $imgname) ? ' selected="selected"' : ''; $img_options .= ''; } } // TODO // Check whether localised buttons exist in admins language first // Clean up this code $imglang = ''; $imagesetlist = array('nolang' => array(), 'lang' => array()); $dp = opendir("{$phpbb_root_path}styles/$imageset_path/imageset"); while ($file = readdir($dp)) { if (!is_file($file) && !is_link($file) && $file{0} != '.' && strtoupper($file) != 'CVS' && !sizeof($imagesetlist['lang'])) { $dp2 = opendir("{$phpbb_root_path}styles/$imageset_path/imageset/$file"); while ($file2 = readdir($dp2)) { $imglang = $file; if (preg_match('#\.(gif|jpg|png)$#', $file2)) { $imagesetlist['lang'][] = "$file/$file2"; } } closedir($dp2); } else if (preg_match('#\.(gif|jpg|png)$#', $file)) { $imagesetlist['nolang'][] = $file; } } closedir($dp); $imagesetlist_options = ''; foreach ($imagesetlist as $type => $img_ary) { $imagesetlist_options .= ($type == 'lang') ? '' : ''; foreach ($img_ary as $img) { $imgvalue = preg_replace('#^.*?/(.*?)$#', '\1', $img); $selected = (strstr($$imgname, $imgvalue)) ? ' selected="selected"' : ''; $imagesetlist_options .= ''; } } $imagesetlist_options = '' . $imagesetlist_options; unset($imagesetlist); $imgsize_no = $imgsize_yes = ''; if ($imgsize || preg_match('# height="[0-9]+?#', $$imgname)) { $imgsize_yes = ' checked="checked"'; } else { $imgsize_no = ' checked="checked"'; } adm_page_header($user->lang['EDIT_IMAGESET']); ?>lang['EDIT_IMAGESET_EXPLAIN']; ?>
lang['SELECTED_IMAGESET'] . ": $imageset_name"; ?>
lang[$l_prefix . 'S']); ?>lang[$l_prefix . 'S_EXPLAIN']; ?>
sql_query($sql); if (!extract($db->sql_fetchrow($result))) { trigger_error($user->lang['NO_' . $l_prefix]); } $path = ($type != 'style') ? ${$type . '_path'} : ''; $storedb = (isset(${$type . '_storedb'})) ? ${$type . '_storedb'} : false; $sql = "SELECT {$type}_id, {$type}_name FROM $sql_from WHERE {$type}_id <> $id ORDER BY {$type}_id"; $result = $db->sql_query($sql); $options = ''; if (!($row = $db->sql_fetchrow($result))) { trigger_error($user->lang['ONLY_' . $l_prefix]); } do { $options .= ''; } while ($row = $db->sql_fetchrow($result)); if ($update) { $sql = "DELETE FROM $sql_from WHERE {$type}_id = $id"; $db->sql_query($sql); $onfs = 0; if ($type == 'style') { $sql = 'UPDATE ' . USERS_TABLE . " SET user_style = $new_id WHERE user_style = $id"; $db->sql_query($sql); } else { $sql = 'UPDATE ' . STYLES_TABLE . " SET {$type}_id = $new_id WHERE {$type}_id = $id"; $db->sql_query($sql); if ($deletefs && is_writeable("{$phpbb_root_path}styles/$path/{$type}")) { $filelist = filelist("{$phpbb_root_path}styles/$path/{$type}", '', '*'); krsort($filelist); foreach ($filelist as $subpath => $file_ary) { $subpath = "{$phpbb_root_path}styles/$path/{$type}$subpath"; foreach ($file_ary as $file) { /* if (!@unlink("$subpath$file")) { $onfs = 1; } */ } /* if (!@rmdir($subpath)) { $onfs = 1; } */ } } else { $onfs = (file_exists("{$phpbb_root_path}styles/$path/{$type}")) ? 1 : 0; } } $cache->destroy('sql', STYLES_TABLE); add_log('admin', 'LOG_DELETE_' . $l_prefix, ${$type . '_name'}); $message = ($onfs) ? $l_prefix . '_DELETED_FS' : $l_prefix . '_DELETED'; trigger_error($user->lang[$message]); } // Output list of themes adm_page_header($user->lang['DELETE_' . $l_prefix]); ?>lang['DELETE_' . $l_prefix . '_EXPLAIN']; ?>
lang['STYLE_ERR_MORE_ELEMENTS']; } $style_id = &$id; $name = 'style_name'; $sql_select = 's.style_id, s.style_name, s.style_copyright'; $sql_select .= ($inc_template) ? ', t.*' : ', t.template_name'; $sql_select .= ($inc_theme) ? ', c.*' : ', c.theme_name'; $sql_select .= ($inc_imageset) ? ', i.*' : ', i.imageset_name'; $sql_from = STYLES_TABLE . ' s, ' . STYLES_TPL_TABLE . ' t, ' . STYLES_CSS_TABLE . ' c, ' . STYLES_IMAGE_TABLE . ' i'; $sql_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"; $l_prefix = 'STYLE'; break; case 'template': $template_id = &$id; $name = 'template_name'; $sql_select = '*'; $sql_from = STYLES_TPL_TABLE; $sql_where = "template_id = $id"; $l_prefix = 'TEMPLATE'; break; case 'theme': $theme_id = &$id; $name = 'theme_name'; $sql_select = '*'; $sql_from = STYLES_CSS_TABLE; $sql_where = "theme_id = $id"; $l_prefix = 'THEME'; break; case 'imageset': $imageset_id = &$id; $name = 'imageset_name'; $sql_select = '*'; $sql_from = STYLES_IMAGE_TABLE; $sql_where = "imageset_id = $id"; $l_prefix = 'IMAGESET'; break; } // Lets do a merry dance ... either that or generate the archive if ($update && !sizeof($error)) { $sql = "SELECT $sql_select FROM $sql_from WHERE $sql_where"; $result = $db->sql_query($sql); if (!($style_row = ($db->sql_fetchrow($result)))) { trigger_error($user->lang['NO_' . $l_prefix]); } $db->sql_freeresult($result); $var_ary = array('style_id', 'style_name', 'style_copyright', 'template_id', 'template_name', 'template_path', 'template_copyright', 'template_storedb', 'bbcode_bitfield', 'theme_id', 'theme_name', 'theme_path', 'theme_copyright', 'theme_storedb', 'theme_mtime', 'theme_data', 'imageset_id', 'imageset_name', 'imageset_path', 'imageset_copyright'); foreach ($var_ary as $var) { $$var = (!empty($style_row[$var])) ? $style_row[$var] : ''; unset($style_row[$var]); } $files = $data = array(); if ($mode == 'style') { $style_cfg = addslashes($style_name) . "\n"; $style_cfg .= addslashes($style_copyright) . "\n"; $style_cfg .= addslashes($config['version']) . "\n"; $style_cfg .= ((!$inc_template) ? addslashes($template_name) : '') . "\n"; $style_cfg .= ((!$inc_theme) ? addslashes($theme_name) : '') . "\n"; $style_cfg .= ((!$inc_imageset) ? addslashes($imageset_name) : ''); $data[] = array( 'src' => $style_cfg, 'prefix' => 'style.cfg' ); unset($style_cfg); } // Export template core code if ($mode == 'template' || $inc_template) { $template_cfg = addslashes($template_name) . "\n"; $template_cfg .= addslashes($template_copyright) . "\n"; $template_cfg .= addslashes($config['version']) . "\n"; $template_cfg .= addslashes($bbcode_bitfield); $data[] = array( 'src' => $template_cfg, 'prefix' => 'template/template.cfg' ); // This is potentially nasty memory-wise ... if (!$template_storedb) { $files[] = array( 'src' => "styles/$template_path/template/", 'prefix-' => "styles/$template_path/", 'prefix+' => false, 'exclude' => 'template.cfg' ); } else { $sql = 'SELECT template_filename, template_data FROM ' . STYLES_TPLDATA_TABLE . " WHERE template_id = $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); } unset($template_cfg); } // Export theme core code if ($mode == 'theme' || $inc_theme) { $theme_cfg = addslashes($theme_name) . "\n"; $theme_cfg .= addslashes($theme_copyright) . "\n"; $theme_cfg .= addslashes($config['version']); $files[] = array( 'src' => "styles/$theme_path/theme/", 'prefix-' => "styles/$theme_path/", 'prefix+' => false, 'exclude' => ($theme_storedb) ? 'stylesheet.css,theme.cfg' : 'theme.cfg' ); $data[] = array( 'src' => $theme_cfg, 'prefix' => 'theme/theme.cfg' ); if ($theme_storedb) { $data[] = array( 'src' => $theme_data, 'prefix' => 'theme/stylesheet.css' ); } unset($theme_data); unset($theme_cfg); } // Export imageset core code if ($mode == 'imageset' || $inc_imageset) { $imageset_cfg = addslashes($imageset_name) . "\n"; $imageset_cfg .= addslashes($imageset_copyright) . "\n"; $imageset_cfg .= addslashes($config['version']) . "\n"; foreach (array_keys($style_row) as $key) { $imageset_cfg .= $key . '||' . str_replace("styles/$imageset_path/imageset/", '{PATH}', $style_row[$key]) . "\n"; unset($style_row[$key]); } $imageset_cfg = rtrim($imageset_cfg); $files[] = array( 'src' => "styles/$imageset_path/imageset/", 'prefix-' => "styles/$imageset_path/", 'prefix+' => false, 'exclude' => 'imageset.cfg' ); $data[] = array( 'src' => trim($imageset_cfg), 'prefix' => 'imageset/imageset.cfg' ); unset($imageset_cfg); } switch ($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)) { include($phpbb_root_path . 'includes/functions_compress.'.$phpEx); $path = str_replace(' ', '_', $$name); 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 (!$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/$path.$ext"); exit; } trigger_error(sprintf($user->lang[$l_prefix . '_EXPORTED'], "store/$path.$ext")); } } else { $sql = "SELECT {$mode}_id, {$mode}_name FROM " . (($mode == 'style') ? STYLES_TABLE : $sql_from) . " WHERE {$mode}_id = $id"; $result = $db->sql_query($sql); if (!extract($db->sql_fetchrow($result))) { trigger_error($user->lang['NO_' . $l_prefix]); } $db->sql_freeresult($result); } // Output list adm_page_header($user->lang[$l_prefix . '_EXPORT']); ?>lang[$l_prefix . '_EXPORT_EXPLAIN']; ?>
$file_ary) { foreach ($file_ary as $file) { if (!($fp = fopen("{$phpbb_root_path}styles/$path$pathfile/$file", 'r'))) { trigger_error("Could not open {$phpbb_root_path}styles/$path/$pathfile/$file"); } $template_data = fread($fp, filesize("{$phpbb_root_path}styles/$path$pathfile/$file")); fclose($fp); if (preg_match_all('##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' => $id, 'template_filename' => $file, 'template_included' => (!empty($includes[$file])) ? implode(':', $includes[$file]) . ':' : '', 'template_mtime' => filemtime("{$phpbb_root_path}styles/$path$pathfile/$file"), 'template_data' => implode('', file("{$phpbb_root_path}styles/$path$pathfile/$file")), ); $sql = ($mode == 'insert') ? 'INSERT INTO ' . STYLES_TPLDATA_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary) : 'UPDATE ' . STYLES_TPLDATA_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary) . " WHERE template_id = $id AND template_filename = '" . $db->sql_escape($file) . "'"; $db->sql_query($sql); } } } // Does what it says in the function title ... give it a src location, array of files // and destination function copy_files($src, $filelist, $dst) { global $phpbb_root_path; if (!(is_writable("{$phpbb_root_path}styles"))) { return false; } umask(0); if (!file_exists("{$phpbb_root_path}styles/$dst")) { @mkdir("{$phpbb_root_path}styles/$dst", 0777); chmod("{$phpbb_root_path}styles/$dst", 0777); } @ksort($filelist); foreach ($filelist as $filepath => $file_ary) { $filepath = (substr($filepath, 0, 1) != '/') ? "/$filepath" : $filepath; if ($filepath && !file_exists("{$phpbb_root_path}styles/$dst$filepath")) { @mkdir("{$phpbb_root_path}styles/$dst$filepath", 0777); chmod("{$phpbb_root_path}styles/$dst$filepath", 0777); } foreach ($file_ary as $file) { if (!file_exists("{$phpbb_root_path}styles/$dst$filepath$file")) { @copy("$src$filepath$file", "{$phpbb_root_path}styles/$dst$filepath$file"); @chmod("{$phpbb_root_path}styles/$dst$filepath$file", 0777); } } } } // You can guess what this does ... just give it a path function cleanup_folder($path) { $filelist = filelist($path, '', '*'); krsort($filelist); foreach ($filelist as $filepath => $file_ary) { foreach ($file_ary as $file) { @unlink("$path$filepath$file"); } if (file_exists("$path$filepath")) { @rmdir("$path$filepath"); } } @rmdir("$path"); } // Is this element installed? If not, grab its cfg details function test_installed($element, &$error, $root_path, $reqd_name, &$id, &$name, &$copyright) { global $db, $user; switch ($element) { case 'template': $sql_from = STYLES_TPL_TABLE; break; case 'theme': $sql_from = STYLES_CSS_TABLE; break; case 'imageset': $sql_from = STYLES_IMAGE_TABLE; break; } $l_element = strtoupper($element); $chk_name = ($reqd_name) ? $reqd_name : $name; $sql = "SELECT {$element}_id, {$element}_name FROM $sql_from WHERE {$element}_name = '" . $db->sql_escape($chk_name) . "'"; $result = $db->sql_query($sql); if ($row = $db->sql_fetchrow($result)) { $name = $row[$element . '_name']; $id = $row[$element . '_id']; } else { if (!($cfg = @file("$root_path$element/$element.cfg"))) { $error[] = sprintf($user->lang['REQUIRES_' . $l_element], $reqd_name); return false; } $name = trim($cfg[0]); $copyright = trim($cfg[1]); $id = 0; unset($cfg); } $db->sql_freeresult($result); } // Install an element, doing various checks as we go function install_element($type, &$error, $action, $root_path, &$id, $name, $copyright, $storedb = 0) { global $phpbb_root_path, $db, $user; switch ($type) { case 'template': $sql_from = STYLES_TPL_TABLE; break; case 'theme': $sql_from = STYLES_CSS_TABLE; break; case 'imageset': $sql_from = STYLES_IMAGE_TABLE; break; } $l_type = strtoupper($type); $path = str_replace(' ', '_', $name); if (empty($name)) { $error[] = $user->lang[$l_type . '_ERR_STYLE_NAME']; } if (strlen($name) > 30) { $error[] = $user->lang[$l_type . '_ERR_NAME_LONG']; } if (!preg_match('#^[a-z0-9_\-\+\. ]+$#i', $name)) { $error[] = $user->lang[$l_type . '_ERR_NAME_CHARS']; } if (strlen($copyright) > 60) { $error[] = $user->lang[$l_type . '_ERR_COPY_LONG']; } $sql = "SELECT {$type}_name FROM $sql_from WHERE {$type}_name = '" . $db->sql_escape($name) . "'"; $result = $db->sql_query($sql); if (extract($db->sql_fetchrow($result))) { $error[] = $user->lang[$l_type . '_ERR_NAME_EXIST']; } $db->sql_freeresult($result); if (sizeof($error)) { return false; } if ($action != 'install') { @mkdir("{$phpbb_root_path}styles/$path", 0777); @chmod("{$phpbb_root_path}styles/$path", 0777); if ($root_path) { copy_files("$root_path$type", filelist("$root_path$type", '', '*'), "$path/$type"); } } $sql_ary = array( $type . '_name' => $name, $type . '_copyright'=> $copyright, $type . '_path' => $path, ); if ($type != 'imageset') { switch ($type) { case 'template': $sql_ary += array( $type . '_storedb' => (!is_writeable("{$phpbb_root_path}styles/$path/$type")) ? 1 : 0 ); break; case 'theme': $sql_ary += array( 'theme_storedb' => (!is_writeable("{$phpbb_root_path}styles/$path/theme/stylesheet.css")) ? 1 : $storedb, 'theme_data' => ($storedb) ? (($root_path) ? str_replace('./', "styles/$path/theme/", implode('', file("$root_path/$type/stylesheet.css"))) : '') : '', 'theme_mtime' => ($storedb) ? filemtime("{$phpbb_root_path}styles/$path/theme/stylesheet.css") : 0 ); break; } } else { $cfg = file("$root_path$type/imageset.cfg"); for ($i = 3; $i < sizeof($cfg); $i++) { $tmp = explode('||', $cfg[$i]); $sql_ary[$tmp[0]] = str_replace('{PATH}', "styles/$path/imageset/", trim($tmp[1])); } unset($cfg); } $db->sql_transaction('begin'); $sql = "INSERT INTO $sql_from " . $db->sql_build_array('INSERT', $sql_ary); $db->sql_query($sql); $id = $db->sql_nextid(); if ($type == 'template' && $storedb) { $filelist = filelist("{$root_path}template", '', 'html'); store_templates('insert', $id, $path, $filelist); } $db->sql_transaction('commit'); $log = ($storedb) ? 'LOG_ADD_' . $l_type . '_FS' : 'LOG_ADD_' . $l_type . '_DB'; add_log('admin', $log, $name); } function install_style($action, &$error, $name, $copyright, $active, $default, $root_path, &$template_id, &$template_name, &$template_copyright, &$theme_id, &$theme_name, &$theme_copyright, &$imageset_id, &$imageset_name, &$imageset_copyright) { global $config, $db, $user; $element_ary = array('template', 'theme', 'imageset'); if (empty($name)) { $error[] = $user->lang['STYLE_ERR_STYLE_NAME']; } if (strlen($name) > 30) { $error[] = $user->lang['STYLE_ERR_NAME_LONG']; } if (!preg_match('#^[a-z0-9_\-\+\. ]+$#i', $name)) { $error[] = $user->lang['STYLE_ERR_NAME_CHARS']; } if (strlen($copyright) > 60) { $error[] = $user->lang['STYLE_ERR_COPY_LONG']; } $sql = 'SELECT style_name FROM ' . STYLES_TABLE . " WHERE style_name = '" . $db->sql_escape($name) . "'"; $result = $db->sql_query($sql); if (extract($db->sql_fetchrow($result))) { $error[] = $user->lang['STYLE_ERR_NAME_EXIST']; } $db->sql_freeresult($result); foreach ($element_ary as $element) { // Zero id value ... need to install element ... run usual checks // and do the install if necessary if (!${$element . '_id'}) { $error = install_element($element, $action, $root_path, ${$element . '_id'}, ${$element . '_name'}, ${$element . '_copyright'}); } } if (!$template_id || !$theme_id || !$imageset_id) { $error[] = $user->lang['STYLE_ERR_NO_IDS']; } if (sizeof($error)) { return false; } $db->sql_transaction('begin'); $sql_ary = array( 'style_name' => $name, 'style_copyright' => $copyright, 'style_active' => $active, 'template_id' => $template_id, 'theme_id' => $theme_id, 'imageset_id' => $imageset_id, ); $sql = 'INSERT INTO ' . STYLES_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary); $db->sql_query($sql); $id = $db->sql_nextid(); if ($default) { $sql = 'UPDATE ' . USERS_TABLE . " SET user_style = $id WHERE user_style = " . $config['default_style']; $db->sql_query($sql); set_config('default_style', $id); } $db->sql_transaction('commit'); add_log('admin', 'LOG_ADD_STYLE', $name); } // Commented inline function install($type, $action, $id) { global $phpbb_root_path, $phpEx, $SID, $config, $db, $cache, $user; global $safe_mode, $file_uploads, $archive_preg; $install_path = (isset($_REQUEST['path'])) ? htmlspecialchars($_REQUEST['path']) : ''; $update = (isset($_POST['update'])) ? true : false; $installcfg = $error = array(); $template_storedb = $theme_storedb = $basis = false; $root_path = $tmp_path = $theme_data = $s_hidden_fields = ''; $template_id = $template_name = $template_copyright =$theme_id = $theme_name = $theme_copyright = $imageset_id = $imageset_name = $imageset_copyright = ''; $l_type = strtoupper($type); $l_prefix = ($action == 'add') ? 'ADD' : (($action == 'details') ? 'EDIT_DETAILS' : 'INSTALL'); $element_ary = array('template' => STYLES_TPL_TABLE, 'theme' => STYLES_CSS_TABLE, 'imageset' => STYLES_IMAGE_TABLE); $phpbbversion = preg_replace('#^2\.([0-9]+?)\.([0-9]+?).*?$#', '\1.\2', $config['version']); switch ($type) { case 'style': $sql_from = STYLES_TABLE; break; case 'template': $sql_from = STYLES_TPL_TABLE; break; case 'theme': $sql_from = STYLES_CSS_TABLE; break; case 'imageset': $sql_from = STYLES_IMAGE_TABLE; break; } // Importing/uploading then check data and extract archive if (!empty($_FILES['upload_file']['name']) || !empty($_POST['import_file'])) { if (!empty($_FILES['upload_file']['name'])) { $realname = htmlspecialchars($_FILES['upload_file']['name']); $filename = htmlspecialchars($_FILES['upload_file']['tmp_name']); if (!is_uploaded_file($filename)) { trigger_error("$filename was not uploaded"); } } else { $realname = htmlspecialchars($_POST['import_file']); $filename = "{$phpbb_root_path}store/$realname"; } if (!preg_match('#(' . $archive_preg . ')$#i', $realname, $match)) { $error[] = sprintf($user->lang['UPLOAD_WRONG_TYPE'], $archive_types); } $path = preg_replace('#^(.*?)' . preg_quote($match[0]) . '$#', '\1', $realname); // Attempt to extract the files to a temporary directory in store $tmp_path = $phpbb_root_path . 'store/tmp_' . substr(uniqid(''), 0, 10) . '/'; if (!@mkdir($tmp_path)) { trigger_error("Cannot create $tmp_path", E_USER_ERROR); } include($phpbb_root_path . 'includes/functions_compress.'.$phpEx); switch ($match[0]) { case '.zip': $zip = new compress_zip('r', $filename); break; default: $zip = new compress_tar('r', $filename, $match[0]); } $zip->extract($tmp_path); $zip->close(); unset($cfg); } // Installing, importing/uploading then obtain the style cfg information if (($action == 'install' && $install_path) || (!empty($_FILES['upload_file']['name']) || !empty($_POST['import_file']))) { $root_path = ($action == 'install') ? "{$phpbb_root_path}styles/$install_path/" : "$tmp_path"; $cfg_path = ($type == 'style') ? "$root_path$type.cfg" : "$root_path$type/$type.cfg"; if (!($fp = @fopen($cfg_path, 'rb'))) { $error[] = $user->lang[$l_type . '_ERR_NOT_' . $l_type]; } else { $installcfg = explode("\n", fread($fp, filesize($cfg_path))); } fclose($fp); } // Installing, importing/uploading then grab the element info else grab the // submitted params ... stylecfg will be set if this is true (see above) if (sizeof($installcfg)) { $name = trim($installcfg[0]); $copyright = trim($installcfg[1]); $version = preg_replace('#^2\.([0-9]+?)\.([0-9]+?).*?$#', '\1.\2', trim($installcfg[2])); switch ($type) { case 'style': $reqd_template = trim($installcfg[3]); $reqd_theme = trim($installcfg[4]); $reqd_imageset = trim($installcfg[5]); // Check to see if each element is already installed, if it is grab the id foreach ($element_ary as $element => $table) { ${$element . '_id'} = ${$element . '_name'} = ${$element . '_copyright'} = ''; test_installed($element, $error, $root_path, ${'reqd_' . $element}, ${$element . '_id'}, ${$element . '_name'}, ${$element . '_copyright'}); } break; case 'template': test_installed('template', $error, $root_path, false, $template_id, $template_name, $template_copyright); break; case 'theme': test_installed('theme', $error, $root_path, false, $theme_id, $theme_name, $theme_copyright); break; case 'imageset': test_installed('imageset', $error, $root_path, false, $imageset_id, $imageset_name, $imageset_copyright); break; } $s_hidden_fields = ''; } else { // NOTE: Data here is stripslashed! Ensure it's escaped when entering the DB $name = (!empty($_POST['name'])) ? stripslashes(htmlspecialchars($_POST['name'])) : ''; $copyright = (!empty($_POST['copyright'])) ? stripslashes(htmlspecialchars($_POST['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; $basis = (isset($_POST['basis'])) ? intval($_POST['basis']) : 0; // If we have a basis or we're editing we want some additional info ... else // we need nothing if ($basis || ($update && $action != 'add')) { switch ($type) { case 'style': $sql_select = ($action != 'details') ? 'style_name, template_id, theme_id, imageset_id' : 'style_name'; break; case 'template': $sql_select = 'template_id, template_name, template_path, template_storedb'; break; case 'theme': $sql_select = 'theme_id, theme_name, theme_path, theme_data, theme_storedb'; break; case 'imageset': $sql_select = 'imageset_id, imageset_name, imageset_path'; break; } $sql = "SELECT $sql_select FROM $sql_from WHERE {$type}_id = " . (($basis) ? $basis : $id); $result = $db->sql_query($sql); if (!extract($db->sql_fetchrow($result))) { $error[] = $user->lang['NO_' . $l_type]; } $db->sql_freeresult($result); $s_hidden_fields .= ''; } } $storedb = (!empty($_POST['storedb'])) ? 1 : 0; $style_active = (isset($_POST['style_active'])) ? ((!empty($_POST['style_active'])) ? 1 : 0) : 1; $style_default = (isset($_POST['style_default'])) ? ((!empty($_POST['style_default'])) ? 1 : 0) : (($config['default_style'] == $id) ? 1 : 0); // User has submitted form and no errors have occured if ($update && !sizeof($error)) { $sql_ary = array(); // We're installing/uploading/importing if ($action == 'install') { switch ($type) { case 'style': install_style($action, $error, $name, $copyright, $style_active, $style_default, $root_path, $template_id, $template_name, $template_copyright, $theme_id, $theme_name, $theme_copyright, $imageset_id, $imageset_name, $imageset_copyright); break; case 'template': install_element('template', $error, $action, $root_path, $id, $name, $copyright); break; case 'theme': install_element('theme', $error, $action, $root_path, $id, $name, $copyright); break; case 'imageset': install_element('imageset', $error, $action, $root_path, $id, $name, $copyright); break; } if ($tmp_path) { cleanup_folder($tmp_path); } if (!sizeof($error)) { $cache->destroy('sql', STYLES_TABLE); $message = ($storedb) ? '_ADDED_DB' : '_ADDED'; trigger_error($user->lang[$l_type . $message]); } } else if ($action == 'add') { if ($type == 'style') { install_style($action, $error, $name, $copyright, $style_active, $style_default, $root_path, $template_id, $template_name, $template_copyright, $theme_id, $theme_name, $theme_copyright, $imageset_id, $imageset_name, $imageset_copyright); } else { // Create path if it doesn't exist $storedb = 1; umask(0); if (file_exists("{$phpbb_root_path}styles/$path") || @mkdir("{$phpbb_root_path}styles/$path", 0777)) { if (@chmod("{$phpbb_root_path}styles/$path", 0777)) { $storedb = 0; } } if ($basis && ($template_storedb || $theme_storedb)) { $tmp_path = $phpbb_root_path . 'store/tmp_' . substr(uniqid(''), 0, 10) . '/'; if (!@mkdir($tmp_path, 0777)) { trigger_error("Cannot create $tmp_path", E_USER_ERROR); } @chmod($tmp_path, 0777); if (!@mkdir("$tmp_path$type", 0777)) { trigger_error("Cannot create $tmp_path$type", E_USER_ERROR); } @chmod("$tmp_path$type", 0777); switch ($type) { case 'theme': copyfiles("{$phpbb_root_path}styles/$path/theme/", filelist("{$phpbb_root_path}styles/$path/theme/", '', '*'), "$tmp_path$type/"); $fp = fopen("$tmp_path$type/stylesheet.css", 'wb'); fwrite($fp, $theme_data); fclose($theme_data); break; case 'template': copyfiles("{$phpbb_root_path}styles/$path/$type/", filelist("{$phpbb_root_path}styles/$path/$type/", '', '*'), "$tmp_path$type/"); $sql = 'SELECT template_filename, template_mtime, template_data FROM ' . STYLES_TPLDATA_TABLE . " WHERE template_id = $basis"; $result = $db->sql_fetchrow($result); while ($row = $db->sql_fetchrow($result)) { $fp = fopen("$tmp_path$type/" . $row['template_filename'], 'wb'); fwrite($fp, $row['template_data']); fclose($fp); } $db->sql_freeresult($result); break; } } $root_path = ($tmp_path) ? $tmp_path : (($basis) ? $phpbb_root_path . 'styles/' . ${$type . '_path'} . '/' : ''); install_element($type, $error, $action, $root_path, $id, $name, $copyright, $storedb); } if ($tmp_path) { cleanup_folder($tmp_path); } if (!sizeof($error)) { $cache->destroy('sql', STYLES_TABLE); $message = ($storedb) ? '_ADDED_DB' : '_ADDED'; trigger_error($user->lang["$l_type$message"]); } } else if ($action == 'details') { if ($type == 'style') { $sql_ary = array( 'template_id' => $template_id, 'theme_id' => $theme_id, 'imageset_id' => $imageset_id, 'style_active' => $style_active, ); } else if ($type != 'imageset') { switch ($type) { case 'theme': if ($theme_storedb != $storedb) { $theme_data = implode('', file("{$phpbb_root_path}styles/$theme_path/theme/stylesheet.css")); if (!$storedb && !$safe_mode && is_writeable("{$phpbb_root_path}styles/$theme_path/theme/stylesheet.css")) { $storedb = 1; if ($fp = @fopen("{$phpbb_root_path}styles/$theme_path/$type/stylesheet.css", 'wb')) { $storedb = (@fwrite($fp, str_replace("styles/$theme_path/theme/", './', $theme_data))) ? 0 : 1; } fclose($fp); } $theme_data = str_replace('./', "styles/$theme_path/theme/", $theme_data); $sql_ary = array( 'theme_mtime' => ($storedb) ? filemtime("{$phpbb_root_path}styles/$theme_path/theme/stylesheet.css") : 0, 'theme_storedb' => $storedb, 'theme_data' => ($storedb) ? $theme_data : '', ); } break; case 'template': if ($theme_storedb != $storedb) { $filelist = filelist("{$phpbb_root_path}styles/$template_path/template", '', 'html'); if (!$storedb && !$safe_mode && is_writeable("{$phpbb_root_path}styles/$template_path/template")) { $sql = 'SELECT * FROM ' . STYLES_TPLDATA_TABLE . " WHERE template_id = $id"; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) { if (!($fp = @fopen("{$phpbb_root_path}styles/$template_path/template/" . $row['template_filename'], 'wb'))) { $storedb = 1; break; } fwrite($fp, $row['template_data']); fclose($fp); } $db->sql_freeresult($result); if (!$storedb) { $sql = 'DELETE FROM ' . STYLES_TPLDATA_TABLE . " WHERE template_id = $id"; $db->sql_query($sql); } } $sql_ary = array( 'template_storedb' => $storedb, ); } break; } } if ($type != 'imageset' && sizeof($sql_ary)) { $sql = "UPDATE $sql_from SET " . $db->sql_build_array('UPDATE', $sql_ary) . " WHERE {$type}_id = $id"; $db->sql_query($sql); if ($type == 'style' && $style_default) { set_config('default_style', $id); } } $cache->destroy('sql', STYLES_TABLE); add_log('admin', 'LOG_EDIT_' . $l_type, $name); trigger_error($user->lang[$l_type . '_EDITED']); } } // Something went wrong ... so we'll clean up any decompressed uploaded/imported archives. if ($tmp_path) { cleanup_folder($tmp_path); } // Either an error occured or the user has just entered the form if (!sizeof($error) && !$update && $id) { $sql = "SELECT * FROM $sql_from WHERE {$type}_id = $id"; $result = $db->sql_query($sql); if (!extract($db->sql_fetchrow($result))) { trigger_error($user->lang['NO_' . $l_type]); } $db->sql_freeresult($result); $style_default = ($type == 'style' && $config['default_style'] == $id) ? 1 : 0; $storedb = (!empty(${$type . '_storedb'})) ? true : false; // Fudged because we use $storedb when submitting data } if ($type == 'style' && $action != 'install') { $style_options = array(); foreach ($element_ary as $element => $table) { $sql = "SELECT {$element}_id, {$element}_name FROM $table ORDER BY {$element}_id ASC"; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) { $selected = ($row[$element . '_id'] == ${$element . '_id'}) ? ' selected="selected"' : ''; ${$element . '_options'} .= ''; } $db->sql_freeresult($result); } } // Output the page adm_page_header($user->lang[$l_prefix . '_' . $l_type]); ?>lang[$l_prefix . '_' . $l_type . '_EXPLAIN']; ?>
h1 |
h2 |
h3 |
| mainmenu | ||
| titles |
| navlink |
| th | ||
|---|---|---|
| cattitle / cat | catdiv | |
| topictitle / row1 | topicdetails / row1 | |
| row3 | ||
| spacer | ||
| postdetails / row2 | postbody / row1 posthilit | |
| gen | genmed | gensmall |
| copyright phpBB | ||
| postbody / bold italic underline | ||
|
||
|
||
|