{

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

}

$this->page_title = 'EDIT_TEMPLATE';

$filelist = $filelist_cats = array();

// make sure template_file path doesn't go upwards

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

// Retrieve some information about the template

$sql = 'SELECT template_storedb, template_path, template_name

FROM ' . STYLES_TEMPLATE_TABLE . "

{

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

}

if ($save_changes && !check_form_key('acp_styles'))

{

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

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

foreach ($file_ary as $file)

{

$file = str_replace('/', '.', $file);

// perform some dirty guessing to get the path right.

// We assume that three dots in a row were '../'

$tpl_file = str_replace('.', '/', $file);

$tpl_file = str_replace('///', '../', $tpl_file);

$filename = "{$cache_prefix}_$file.html.$phpEx";

if (!file_exists("{$phpbb_root_path}cache/$filename"))

{

continue;

}

$file_tpl = "{$phpbb_root_path}styles/{$template_row['template_path']}/template/$tpl_file.html";

$inherited = false;

if (isset($template_row['template_inherits_id']) && $template_row['template_inherits_id'])

{

if (!$template_row['template_storedb'])

}

}

}

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

'U_VIEWSOURCE' => $this->u_action . "&action=cache&id=$template_id&source=$file",

// make sure theme_file path doesn't go upwards

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

// Retrieve some information about the theme

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

FROM ' . STYLES_THEME_TABLE . "

$imgsize = request_var('imgsize', false);

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

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

$imgname = preg_replace('#[^a-z0-9\-+_]#i', '', $imgname);

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

{

$msg .= '<br />' . $values['template_name'];

}

trigger_error($msg . adm_back_link($this->u_action), E_USER_WARNING);

}

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

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

FROM $sql_from

AND {$mode}_name = '" . $db->sql_escape(strtolower($name)) . "'";

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

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

$db->sql_freeresult($result);

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

{

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

}

}

}

if (!sizeof($error))

{

// Check length settings

$db->sql_freeresult($result);

}

}

if ($mode == 'template')

{

$super = array();

// we parse the cfg here (again)

$cfg_data = parse_cfg_file("$root_path$mode/$mode.cfg");

switch ($mode)

{

case 'template':

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

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

$db->sql_freeresult($result);

if ($row)

{

$inherit_id = 0;

$inherit_path = '';

}

if (sizeof($error))

{

// Return store_db in case it had to be altered

return $store_db;

}

/**

* Checks downwards dependencies

*

* @param string $mode The element type to check - only template is supported

* @param int $id The template id

* @returns false if no component inherits, array with name, path and id for each subtemplate otherwise

function check_inheritance($mode, $id)

{

global $db;

$l_type = strtoupper($mode);

switch ($mode)

WHERE {$mode}_inherits_id = " . (int) $id;

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

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

{

$names[$row["{$mode}_id"]] = array(

"{$mode}_id" => $row["{$mode}_id"],

"{$mode}_name" => $row["{$mode}_name"],

return false;

}

}

/**

* Checks upwards dependencies

*

* @param string $mode The element type to check - only template is supported

* @param int $id The template id

* @returns false if the component does not inherit, array with name, path and id otherwise

function get_super($mode, $id)

{

global $db;

$l_type = strtoupper($mode);

switch ($mode)

$sql_from = STYLES_IMAGESET_TABLE;

break;

}

FROM $sql_from

WHERE {$mode}_id = " . (int) $id;

$result = $db->sql_query_limit($sql, 1);

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

{

$db->sql_freeresult($result);

{

return false;

}

$super_id = $row["{$mode}_inherits_id"];

FROM $sql_from

WHERE {$mode}_id = " . (int) $super_id;

$db->sql_freeresult($result);

return $row;

}

return false;

}

/**

* Moves a template set and its subtemplates to the database

*

* @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

WHERE template_id = ' . (int) $id;

$result = $db->sql_query_limit($sql, 1);

{

return $error;

}

return false;

}

/**

* Moves a template set to the database

*

* @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

*

* @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;

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)

}

return false;

}

/**

* Moves a template set to the filesystem

*

* @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 && @is_writable("{$phpbb_root_path}styles/{$path}/template"))

SET template_storedb = 0

WHERE template_id = ' . $id;

$db->sql_query($sql);

return false;

}

/**

* Private method for performing sql statements (either execute them or return them)

*/

function _sql_run_sql($statements)

{

/**

* Function to prepare some column information for better usage

*/

function sql_prepare_column_data($table_name, $column_name, $column_data)

{

/**

* checks a link hash - for GET requests

* @param string $link_name The name of the link

* @return boolean true if all is fine

*/

*

* @param string $destination_path Destination path, for example $config['avatar_path']

* @param bool $overwrite If set to true, an already existing file will be overwritten

* @access public

*/

function move_file($destination, $overwrite = false, $skip_image_check = false, $chmod = false)

*

* @param mixed $user_row An array containing the following keys (and the appropriate values): username, group_id (the group to place the user in), user_email and the user_type(usually 0). Additional entries not overridden by defaults will be forwarded.

* @param string $cp_data custom profile fields, see custom_profile::build_insert_sql_array

*/

function user_add($user_row, $cp_data = false)

{

}

}

}

$sql = 'UPDATE ' . USERS_TABLE . '

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

WHERE user_id = ' . (($custom_userdata === false) ? $user->data['user_id'] : $custom_userdata['user_id']);

/**

* Set users default group

*

*/

function group_set_user_default($group_id, $user_id_ary, $group_attributes = false, $update_listing = false)

{

/**

* Parse code text from code tag

*/

function bbcode_parse_code($stx, &$code)

{