From 44c849564fe7e0211dee134e9133c0c7f29ed03a Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" Date: Sat, 24 Nov 2001 01:51:36 +0000 Subject: Various updates git-svn-id: file:///svn/phpbb/trunk@1432 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/admin/admin_styles.php | 1223 +++++++++++++++++++++--------------------- 1 file changed, 619 insertions(+), 604 deletions(-) (limited to 'phpBB/admin/admin_styles.php') diff --git a/phpBB/admin/admin_styles.php b/phpBB/admin/admin_styles.php index 4043580a4c..98c8100c43 100644 --- a/phpBB/admin/admin_styles.php +++ b/phpBB/admin/admin_styles.php @@ -43,7 +43,7 @@ $cancel = ( $HTTP_POST_VARS['cancel'] ) ? TRUE : FALSE; if($cancel) { - header("Location: $PHP_SELF"); + header("Location: admin_styles.$phpEx"); } if(!$HTTP_POST_VARS['send_file']) @@ -63,273 +63,367 @@ else switch($mode) { case "addnew": - $install_to = ($HTTP_GET_VARS['install_to']) ? urldecode($HTTP_GET_VARS['install_to']) : $HTTP_POST_VARS['install_to']; - $style_name = ($HTTP_GET_VARS['style']) ? urldecode($HTTP_GET_VARS['style']) : $HTTP_POST_VARS['style']; + $install_to = ($HTTP_GET_VARS['install_to']) ? urldecode($HTTP_GET_VARS['install_to']) : $HTTP_POST_VARS['install_to']; + $style_name = ($HTTP_GET_VARS['style']) ? urldecode($HTTP_GET_VARS['style']) : $HTTP_POST_VARS['style']; - if(isset($install_to)) - { - include($phpbb_root_dir . "templates/" . $install_to . "/theme_info.cfg"); - $template_name = $$install_to; - $found = FALSE; - - for($i = 0; $i < count($template_name) && !$found; $i++) + if(isset($install_to)) { - if($template_name[$i]['style_name'] == $style_name) + include($phpbb_root_dir . "templates/" . $install_to . "/theme_info.cfg"); + + $template_name = $$install_to; + $found = FALSE; + + for($i = 0; $i < count($template_name) && !$found; $i++) { - while(list($key, $val) = each($template_name[$i])) + if($template_name[$i]['style_name'] == $style_name) { - $db_fields[] = $key; - $db_values[] = $val; + while(list($key, $val) = each($template_name[$i])) + { + $db_fields[] = $key; + $db_values[] = $val; + } } } - } + + $sql = "INSERT INTO " . THEMES_TABLE . " ("; + + for($i = 0; $i < count($db_fields); $i++) + { + $sql .= $db_fields[$i]; + if($i != (count($db_fields) - 1)) + { + $sql .= ", "; + } - $sql = "INSERT INTO " . THEMES_TABLE . " ("; - for($i = 0; $i < count($db_fields); $i++) - { - $sql .= $db_fields[$i]; - if($i != (count($db_fields) - 1)) + } + + $sql .= ") VALUES ("; + + for($i = 0; $i < count($db_values); $i++) { - $sql .= ", "; + $sql .= "'" . $db_values[$i] . "'"; + if($i != (count($db_values) - 1)) + { + $sql .= ", "; + } } + $sql .= ")"; - } - $sql .= ") VALUES ("; - for($i = 0; $i < count($db_values); $i++) - { - $sql .= "'" . $db_values[$i] . "'"; - if($i != (count($db_values) - 1)) + if(!$result = $db->sql_query($sql)) { - $sql .= ", "; + message_die(GENERAL_ERROR, "Could not insert theme data!", "Error", __LINE__, __FILE__, $sql); } - } - $sql .= ")"; - - if(!$result = $db->sql_query($sql)) - { - message_die(GENERAL_ERROR, "Could not insert theme data!", "Error", __LINE__, __FILE__, $sql); - } - - message_die(GENERAL_MESSAGE, $lang['Theme_installed'], $lang['Success']); + + $message = $lang['Theme_installed'] . "

" . sprintf($lang['Click_return_styleadmin'], "", "") . "

" . sprintf($lang['Click_return_admin_index'], "", ""); - } - else - { - - $installable_themes = array(); - - if($dir = opendir($phpbb_root_dir . "templates/")) + message_die(GENERAL_MESSAGE, $message); + } + else { - while($sub_dir = readdir($dir)) + + $installable_themes = array(); + + if( $dir = @opendir($phpbb_root_dir . "templates/") ) { - if($sub_dir != "." && $sub_dir != ".." && $sub_dir != "CVS") + while( $sub_dir = @readdir($dir) ) { - if(file_exists($phpbb_root_dir . "templates/" . $sub_dir . "/theme_info.cfg")) + if( $sub_dir != "." && $sub_dir != ".." && $sub_dir != "CVS" ) { - include($phpbb_root_dir . "templates/" . $sub_dir . "/theme_info.cfg"); - - for($i = 0; $i < count($$sub_dir); $i++) + if( @file_exists($phpbb_root_dir . "templates/" . $sub_dir . "/theme_info.cfg") ) { - $working_data = $$sub_dir; + include($phpbb_root_dir . "templates/" . $sub_dir . "/theme_info.cfg"); - $style_name = $working_data[$i]['style_name']; - - $sql = "SELECT themes_id FROM " . THEMES_TABLE . " WHERE style_name = '$style_name'"; - if(!$result = $db->sql_query($sql)) - { - message_die(GENREAL_ERROR, "Could not query themes table!", "Error", __LINE__, __FILE__, $sql); - } - if(!$db->sql_numrows($result)) + for($i = 0; $i < count($$sub_dir); $i++) { - $installable_themes[] = $working_data[$i]; + $working_data = $$sub_dir; + + $style_name = $working_data[$i]['style_name']; + + $sql = "SELECT themes_id + FROM " . THEMES_TABLE . " + WHERE style_name = '$style_name'"; + if(!$result = $db->sql_query($sql)) + { + message_die(GENREAL_ERROR, "Could not query themes table!", "Error", __LINE__, __FILE__, $sql); + } + if(!$db->sql_numrows($result)) + { + $installable_themes[] = $working_data[$i]; + } } } } } - } - - $template->set_filenames(array( - "body" => "admin/styles_addnew_body.tpl") - ); - - $template->assign_vars(array( - "L_STYLES_TITLE" => $lang['Styles_admin'], - "L_STYLES_ADD_TEXT" => $lang['Styles_addnew_explain'], - "L_STYLE" => $lang['Style'], - "L_TEMPLATE" => $lang['Template'], - "L_INSTALL" => $lang['Install'], - "L_ACTION" => $lang['Action']) - ); - for($i = 0; $i < count($installable_themes); $i++) - { - $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2']; - $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2']; - - $template->assign_block_vars("styles", array( - "STYLE_NAME" => $installable_themes[$i]['style_name'], - "TEMPLATE_NAME" => $installable_themes[$i]['template_name'], - "ROW_CLASS" => $row_class, - "ROW_COLOR" => $row_color, - "U_STYLES_INSTALL" => append_sid("admin_styles.$phpEx?mode=addnew&style=" . urlencode($installable_themes[$i]['style_name']) . "&install_to=" . urlencode($installable_themes[$i]['template_name']))) + $template->set_filenames(array( + "body" => "admin/styles_addnew_body.tpl") ); - - } - $template->pparse("body"); - } - closedir($dir); - } + $template->assign_vars(array( + "L_STYLES_TITLE" => $lang['Styles_admin'], + "L_STYLES_ADD_TEXT" => $lang['Styles_addnew_explain'], + "L_STYLE" => $lang['Style'], + "L_TEMPLATE" => $lang['Template'], + "L_INSTALL" => $lang['Install'], + "L_ACTION" => $lang['Action']) + ); + + for($i = 0; $i < count($installable_themes); $i++) + { + $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2']; + $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2']; - - break; + $template->assign_block_vars("styles", array( + "ROW_CLASS" => $row_class, + "ROW_COLOR" => "#" . $row_color, + "STYLE_NAME" => $installable_themes[$i]['style_name'], + "TEMPLATE_NAME" => $installable_themes[$i]['template_name'], + + "U_STYLES_INSTALL" => append_sid("admin_styles.$phpEx?mode=addnew&style=" . urlencode($installable_themes[$i]['style_name']) . "&install_to=" . urlencode($installable_themes[$i]['template_name']))) + ); + + } + $template->pparse("body"); + + } + closedir($dir); + } + break; case "create": case "edit": - $submit = (isset($HTTP_POST_VARS['submit'])) ? 1 : 0; - - if($submit) - { - // - // DAMN! Thats alot of data to validate... - // - $updated['style_name'] = $HTTP_POST_VARS['style_name']; - $updated['template_name'] = $HTTP_POST_VARS['template_name']; - $updated['head_stylesheet'] = $HTTP_POST_VARS['head_stylesheet']; - $updated['body_background'] = $HTTP_POST_VARS['body_background']; - $updated['body_bgcolor'] = $HTTP_POST_VARS['body_bgcolor']; - $updated['body_link'] = $HTTP_POST_VARS['body_link']; - $updated['body_vlink'] = $HTTP_POST_VARS['body_vlink']; - $updated['body_alink'] = $HTTP_POST_VARS['body_alink']; - $updated['body_hlink'] = $HTTP_POST_VARS['body_hlink']; - $updated['tr_color1'] = $HTTP_POST_VARS['tr_color1']; - $updated_name['tr_color1_name'] = $HTTP_POST_VARS['tr_color1_name']; - $updated['tr_color2'] = $HTTP_POST_VARS['tr_color2']; - $updated_name['tr_color2_name'] = $HTTP_POST_VARS['tr_color2_name']; - $updated['tr_color3'] = $HTTP_POST_VARS['tr_color3']; - $updated_name['tr_color3_name'] = $HTTP_POST_VARS['tr_color3_name']; - $updated['tr_class1'] = $HTTP_POST_VARS['tr_class1']; - $updated_name['tr_class1_name'] = $HTTP_POST_VARS['tr_class1_name']; - $updated['tr_class2'] = $HTTP_POST_VARS['tr_class2']; - $updated_name['tr_class2_name'] = $HTTP_POST_VARS['tr_class2_name']; - $updated['tr_class3'] = $HTTP_POST_VARS['tr_class3']; - $updated_name['tr_class3_name'] = $HTTP_POST_VARS['tr_class3_name']; - $updated['th_color1'] = $HTTP_POST_VARS['th_color1']; - $updated_name['th_color1_name'] = $HTTP_POST_VARS['th_color1_name']; - $updated['th_color2'] = $HTTP_POST_VARS['th_color2']; - $updated_name['th_color2_name'] = $HTTP_POST_VARS['th_color2_name']; - $updated['th_color3'] = $HTTP_POST_VARS['th_color3']; - $updated_name['th_color3_name'] = $HTTP_POST_VARS['th_color3_name']; - $updated['th_class1'] = $HTTP_POST_VARS['th_class1']; - $updated_name['th_class1_name'] = $HTTP_POST_VARS['th_class1_name']; - $updated['td_color1'] = $HTTP_POST_VARS['td_color1']; - $updated_name['td_color1_name'] = $HTTP_POST_VARS['td_color1_name']; - $updated['td_color2'] = $HTTP_POST_VARS['td_color2']; - $updated_name['td_color2_name'] = $HTTP_POST_VARS['td_color2_name']; - $updated['td_color3'] = $HTTP_POST_VARS['td_color3']; - $updated_name['td_color3_name'] = $HTTP_POST_VARS['td_color3_name']; - $updated['td_class1'] = $HTTP_POST_VARS['td_class1']; - $updated_name['td_class1_name'] = $HTTP_POST_VARS['td_class1_name']; - $updated['td_class2'] = $HTTP_POST_VARS['td_class2']; - $updated_name['td_class2_name'] = $HTTP_POST_VARS['td_class2_name']; - $updated['td_class3'] = $HTTP_POST_VARS['td_class3']; - $updated_name['td_class3_name'] = $HTTP_POST_VARS['td_class3_name']; - $updated['fontface1'] = $HTTP_POST_VARS['fontface1']; - $updated_name['fontface1_name'] = $HTTP_POST_VARS['fontface1_name']; - $updated['fontface2'] = $HTTP_POST_VARS['fontface2']; - $updated_name['fontface2_name'] = $HTTP_POST_VARS['fontface2_name']; - $updated['fontface3'] = $HTTP_POST_VARS['fontface3']; - $updated_name['fontface3_name'] = $HTTP_POST_VARS['fontface3_name']; - $updated['fontsize1'] = intval($HTTP_POST_VARS['fontsize1']); - $updated_name['fontsize1_name'] = $HTTP_POST_VARS['fontsize1_name']; - $updated['fontsize2'] = intval($HTTP_POST_VARS['fontsize2']); - $updated_name['fontsize2_name'] = $HTTP_POST_VARS['fontsize2_name']; - $updated['fontsize3'] = intval($HTTP_POST_VARS['fontsize3']); - $updated_name['fontsize3_name'] = $HTTP_POST_VARS['fontsize3_name']; - $updated['fontcolor1'] = $HTTP_POST_VARS['fontcolor1']; - $updated_name['fontcolor1_name'] = $HTTP_POST_VARS['fontcolor1_name']; - $updated['fontcolor2'] = $HTTP_POST_VARS['fontcolor2']; - $updated_name['fontcolor2_name'] = $HTTP_POST_VARS['fontcolor2_name']; - $updated['fontcolor3'] = $HTTP_POST_VARS['fontcolor3']; - $updated_name['fontcolor3_name'] = $HTTP_POST_VARS['fontcolor3_name']; - $updated['span_class1'] = $HTTP_POST_VARS['span_class1']; - $updated_name['span_class1_name'] = $HTTP_POST_VARS['span_class1_name']; - $updated['span_class2'] = $HTTP_POST_VARS['span_class2']; - $updated_name['span_class2_name'] = $HTTP_POST_VARS['span_class2_name']; - $updated['span_class3'] = $HTTP_POST_VARS['span_class3']; - $updated_name['span_class3_name'] = $HTTP_POST_VARS['span_class3_name']; - $style_id = intval($HTTP_POST_VARS['style_id']); - // - // Wheeeew! Thank heavens for copy and paste and search and replace :D - // + $submit = (isset($HTTP_POST_VARS['submit'])) ? 1 : 0; - if($mode == "edit") + if($submit) { - $sql = "UPDATE " . THEMES_TABLE . " SET "; - $count = 0; - while(list($key, $val) = each($updated)) - { - if($count != 0) - { - $sql .= ", "; - } - // I don't like this but it'll keep MSSQL from throwing an error and save me alot of typing - if(stristr($key, "fontsize")) - { - $sql .= "$key = $val"; - } - else - { - $sql .= "$key = '$val'"; - } - $count++; - } - - $sql .= " WHERE themes_id = $style_id"; - - if(!$result = $db->sql_query($sql)) - { - message_die(GENERAL_ERROR, "Could not update themes table!", "Error", __LINE__, __FILE__, $sql); - } - + // + // DAMN! Thats alot of data to validate... // - // Check if there's a names table entry for this style + $updated['style_name'] = $HTTP_POST_VARS['style_name']; + $updated['template_name'] = $HTTP_POST_VARS['template_name']; + $updated['head_stylesheet'] = $HTTP_POST_VARS['head_stylesheet']; + $updated['body_background'] = $HTTP_POST_VARS['body_background']; + $updated['body_bgcolor'] = $HTTP_POST_VARS['body_bgcolor']; + $updated['body_link'] = $HTTP_POST_VARS['body_link']; + $updated['body_vlink'] = $HTTP_POST_VARS['body_vlink']; + $updated['body_alink'] = $HTTP_POST_VARS['body_alink']; + $updated['body_hlink'] = $HTTP_POST_VARS['body_hlink']; + $updated['tr_color1'] = $HTTP_POST_VARS['tr_color1']; + $updated_name['tr_color1_name'] = $HTTP_POST_VARS['tr_color1_name']; + $updated['tr_color2'] = $HTTP_POST_VARS['tr_color2']; + $updated_name['tr_color2_name'] = $HTTP_POST_VARS['tr_color2_name']; + $updated['tr_color3'] = $HTTP_POST_VARS['tr_color3']; + $updated_name['tr_color3_name'] = $HTTP_POST_VARS['tr_color3_name']; + $updated['tr_class1'] = $HTTP_POST_VARS['tr_class1']; + $updated_name['tr_class1_name'] = $HTTP_POST_VARS['tr_class1_name']; + $updated['tr_class2'] = $HTTP_POST_VARS['tr_class2']; + $updated_name['tr_class2_name'] = $HTTP_POST_VARS['tr_class2_name']; + $updated['tr_class3'] = $HTTP_POST_VARS['tr_class3']; + $updated_name['tr_class3_name'] = $HTTP_POST_VARS['tr_class3_name']; + $updated['th_color1'] = $HTTP_POST_VARS['th_color1']; + $updated_name['th_color1_name'] = $HTTP_POST_VARS['th_color1_name']; + $updated['th_color2'] = $HTTP_POST_VARS['th_color2']; + $updated_name['th_color2_name'] = $HTTP_POST_VARS['th_color2_name']; + $updated['th_color3'] = $HTTP_POST_VARS['th_color3']; + $updated_name['th_color3_name'] = $HTTP_POST_VARS['th_color3_name']; + $updated['th_class1'] = $HTTP_POST_VARS['th_class1']; + $updated_name['th_class1_name'] = $HTTP_POST_VARS['th_class1_name']; + $updated['td_color1'] = $HTTP_POST_VARS['td_color1']; + $updated_name['td_color1_name'] = $HTTP_POST_VARS['td_color1_name']; + $updated['td_color2'] = $HTTP_POST_VARS['td_color2']; + $updated_name['td_color2_name'] = $HTTP_POST_VARS['td_color2_name']; + $updated['td_color3'] = $HTTP_POST_VARS['td_color3']; + $updated_name['td_color3_name'] = $HTTP_POST_VARS['td_color3_name']; + $updated['td_class1'] = $HTTP_POST_VARS['td_class1']; + $updated_name['td_class1_name'] = $HTTP_POST_VARS['td_class1_name']; + $updated['td_class2'] = $HTTP_POST_VARS['td_class2']; + $updated_name['td_class2_name'] = $HTTP_POST_VARS['td_class2_name']; + $updated['td_class3'] = $HTTP_POST_VARS['td_class3']; + $updated_name['td_class3_name'] = $HTTP_POST_VARS['td_class3_name']; + $updated['fontface1'] = $HTTP_POST_VARS['fontface1']; + $updated_name['fontface1_name'] = $HTTP_POST_VARS['fontface1_name']; + $updated['fontface2'] = $HTTP_POST_VARS['fontface2']; + $updated_name['fontface2_name'] = $HTTP_POST_VARS['fontface2_name']; + $updated['fontface3'] = $HTTP_POST_VARS['fontface3']; + $updated_name['fontface3_name'] = $HTTP_POST_VARS['fontface3_name']; + $updated['fontsize1'] = intval($HTTP_POST_VARS['fontsize1']); + $updated_name['fontsize1_name'] = $HTTP_POST_VARS['fontsize1_name']; + $updated['fontsize2'] = intval($HTTP_POST_VARS['fontsize2']); + $updated_name['fontsize2_name'] = $HTTP_POST_VARS['fontsize2_name']; + $updated['fontsize3'] = intval($HTTP_POST_VARS['fontsize3']); + $updated_name['fontsize3_name'] = $HTTP_POST_VARS['fontsize3_name']; + $updated['fontcolor1'] = $HTTP_POST_VARS['fontcolor1']; + $updated_name['fontcolor1_name'] = $HTTP_POST_VARS['fontcolor1_name']; + $updated['fontcolor2'] = $HTTP_POST_VARS['fontcolor2']; + $updated_name['fontcolor2_name'] = $HTTP_POST_VARS['fontcolor2_name']; + $updated['fontcolor3'] = $HTTP_POST_VARS['fontcolor3']; + $updated_name['fontcolor3_name'] = $HTTP_POST_VARS['fontcolor3_name']; + $updated['span_class1'] = $HTTP_POST_VARS['span_class1']; + $updated_name['span_class1_name'] = $HTTP_POST_VARS['span_class1_name']; + $updated['span_class2'] = $HTTP_POST_VARS['span_class2']; + $updated_name['span_class2_name'] = $HTTP_POST_VARS['span_class2_name']; + $updated['span_class3'] = $HTTP_POST_VARS['span_class3']; + $updated_name['span_class3_name'] = $HTTP_POST_VARS['span_class3_name']; + $style_id = intval($HTTP_POST_VARS['style_id']); + // + // Wheeeew! Thank heavens for copy and paste and search and replace :D // - $sql = "SELECT themes_id FROM " . THEMES_NAME_TABLE . " WHERE themes_id = $style_id"; - if(!$result = $db->sql_query($sql)) - { - message_die(GENERAL_ERROR, "Could not get data from themes_name table", "Error", __LINE__, __FILE__, $sql); - } - - - if($db->sql_numrows($result) > 0) + if($mode == "edit") { - $sql = "UPDATE " . THEMES_NAME_TABLE . " SET "; + $sql = "UPDATE " . THEMES_TABLE . " SET "; $count = 0; - while(list($key, $val) = each($updated_name)) + + while(list($key, $val) = each($updated)) { if($count != 0) { $sql .= ", "; } - - $sql .= "$key = '$val'"; - + + // + // I don't like this but it'll keep MSSQL from throwing + // an error and save me alot of typing + // + $sql .= ( stristr($key, "fontsize") ) ? "$key = $val" : "$key = '$val'"; + $count++; } $sql .= " WHERE themes_id = $style_id"; + + if(!$result = $db->sql_query($sql)) + { + message_die(GENERAL_ERROR, "Could not update themes table!", "Error", __LINE__, __FILE__, $sql); + } + + // + // Check if there's a names table entry for this style + // + $sql = "SELECT themes_id + FROM " . THEMES_NAME_TABLE . " + WHERE themes_id = $style_id"; + if(!$result = $db->sql_query($sql)) + { + message_die(GENERAL_ERROR, "Could not get data from themes_name table", "Error", __LINE__, __FILE__, $sql); + } + + if($db->sql_numrows($result) > 0) + { + $sql = "UPDATE " . THEMES_NAME_TABLE . " + SET "; + $count = 0; + while(list($key, $val) = each($updated_name)) + { + if($count != 0) + { + $sql .= ", "; + } + + $sql .= "$key = '$val'"; + + $count++; + } + + $sql .= " WHERE themes_id = $style_id"; + } + else + { + // + // Nope, no names entry so we create a new one. + // + $sql = "INSERT INTO " . THEMES_NAME_TABLE . " (themes_id, "; + while(list($key, $val) = each($updated_name)) + { + $fields[] = $key; + $vals[] = $val; + } + + for($i = 0; $i < count($fields); $i++) + { + if($i > 0) + { + $sql .= ", "; + } + $sql .= $fields[$i]; + } + + $sql .= ") VALUES ($style_id, "; + for($i = 0; $i < count($vals); $i++) + { + if($i > 0) + { + $sql .= ", "; + } + $sql .= "'" . $vals[$i] . "'"; + } + + $sql .= ")"; + } + + if(!$result = $db->sql_query($sql)) + { + message_die(GENERAL_ERROR, "Could not update themes name table!", "Error", __LINE__, __FILE__, $sql); + } + + $message = $lang['Theme_updated'] . "

" . sprintf($lang['Click_return_styleadmin'], "", "") . "

" . sprintf($lang['Click_return_admin_index'], "", ""); + + message_die(GENERAL_MESSAGE, $message); } else { - // Nope, no names entry so we create a new one. + while(list($key, $val) = each($updated)) + { + $field_names[] = $key; + + if(stristr($key, "fontsize")) + { + $values[] = "$val"; + } + else + { + $values[] = "'$val'"; + } + } + + $sql = "INSERT INTO " . THEMES_TABLE . " ("; + for($i = 0; $i < count($field_names); $i++) + { + if($i != 0) + { + $sql .= ", "; + } + $sql .= $field_names[$i]; + } + + $sql .= ") VALUES ("; + for($i = 0; $i < count($values); $i++) + { + if($i != 0) + { + $sql .= ", "; + } + $sql .= $values[$i]; + } + $sql .= ")"; + + if(!$result = $db->sql_query($sql)) + { + message_die(GENERAL_ERROR, "Could not update themes table!", "Error", __LINE__, __FILE__, $sql); + } + + $style_id = $db->sql_nextid(); + + // + // Insert names data + // $sql = "INSERT INTO " . THEMES_NAME_TABLE . " (themes_id, "; while(list($key, $val) = each($updated_name)) { $fields[] = $key; $vals[] = $val; } + for($i = 0; $i < count($fields); $i++) { if($i > 0) @@ -344,432 +438,341 @@ switch($mode) { if($i > 0) { - $sql .= ", "; + $sql .= ", "; } - $sql .= "'" . $vals[$i] . "'"; + $sql .= "'" . $vals[$i] . "'"; } $sql .= ")"; + + if(!$result = $db->sql_query($sql)) + { + message_die(GENERAL_ERROR, "Could not insert themes name table!", "Error", __LINE__, __FILE__, $sql); + } + + $message = $lang['Theme_created'] . "

" . sprintf($lang['Click_return_styleadmin'], "", "") . "

" . sprintf($lang['Click_return_admin_index'], "", ""); + + message_die(GENERAL_MESSAGE, $message); } - - if(!$result = $db->sql_query($sql)) - { - message_die(GENERAL_ERROR, "Could not update themes name table!", "Error", __LINE__, __FILE__, $sql); - } - - message_die(GENERAL_MESSAGE, $lang['Theme_updated'], $lang['Success']); } else { - while(list($key, $val) = each($updated)) - { - $field_names[] = $key; - - if(stristr($key, "fontsize")) - { - $values[] = "$val"; - } - else - { - $values[] = "'$val'"; - } - } - - $sql = "INSERT INTO " . THEMES_TABLE . " ("; - for($i = 0; $i < count($field_names); $i++) + if($mode == "edit") { - if($i != 0) + $themes_title = $lang['Edit_theme']; + $themes_explain = $lang['Edit_theme_explain']; + + $style_id = $HTTP_GET_VARS['style_id']; + + // + // Fetch the Theme Info from the db + // + $sql = "SELECT * + FROM " . THEMES_TABLE . " + WHERE themes_id = $style_id"; + if(!$result = $db->sql_query($sql)) { - $sql .= ", "; + message_die(GENERAL_ERROR, "Could not get data from themes table", "Error", __LINE__, __FILE__, $sql); } - $sql .= $field_names[$i]; - } - - $sql .= ") VALUES ("; - for($i = 0; $i < count($values); $i++) - { - if($i != 0) + + $selected_values = $db->sql_fetchrow($result); + + // + // Fetch the Themes Name data + // + $sql = "SELECT * + FROM " . THEMES_NAME_TABLE . " + WHERE themes_id = $style_id"; + if(!$result = $db->sql_query($sql)) { - $sql .= ", "; + message_die(GENERAL_ERROR, "Could not get data from themes name table", "Error", __LINE__, __FILE__, $sql); } - $sql .= $values[$i]; + + $selected_names = $db->sql_fetchrow($result); + + $selected = array_merge($selected_values, $selected_names); + + $s_hidden_fields = ''; } - $sql .= ")"; - - if(!$result = $db->sql_query($sql)) + else { - message_die(GENERAL_ERROR, "Could not update themes table!", "Error", __LINE__, __FILE__, $sql); + $themes_title = $lang['Create_theme']; + $themes_explain = $lang['Create_theme_explain']; } - $style_id = $db->sql_nextid(); - - // - // Insert names data - // - $sql = "INSERT INTO " . THEMES_NAME_TABLE . " (themes_id, "; - while(list($key, $val) = each($updated_name)) - { - $fields[] = $key; - $vals[] = $val; - } - for($i = 0; $i < count($fields); $i++) - { - if($i > 0) - { - $sql .= ", "; - } - $sql .= $fields[$i]; - } + $template->set_filenames(array( + "body" => "admin/styles_edit_body.tpl") + ); - $sql .= ") VALUES ($style_id, "; - for($i = 0; $i < count($vals); $i++) - { - if($i > 0) - { - $sql .= ", "; + if( $dir = @opendir($phpbb_root_path . 'templates/') ) + { + $s_template_select = ''; + + $template->assign_vars(array( + "L_THEMES_TITLE" => $themes_title, + "L_THEMES_EXPLAIN" => $themes_explain, + "L_THEME_NAME" => $lang['Theme_name'], + "L_TEMPLATE" => $lang['Template'], + "L_THEME_SETTINGS" => $lang['Theme_settings'], + "L_THEME_ELEMENT" => $lang['Theme_element'], + "L_SIMPLE_NAME" => $lang['Simple_name'], + "L_VALUE" => $lang['Value'], + "L_STYLESHEET" => $lang['Stylesheet'], + "L_BACKGROUND_IMAGE" => $lang['Background_image'], + "L_BACKGROUND_COLOR" => $lang['Background_color'], + "L_BODY_LINK" => $lang['Link_color'], + "L_BODY_VLINK" => $lang['VLink_color'], + "L_BODY_ALINK" => $lang['ALink_color'], + "L_BODY_HLINK" => $lang['HLink_color'], + "L_TR_COLOR1" => $lang['Tr_color1'], + "L_TR_COLOR2" => $lang['Tr_color2'], + "L_TR_COLOR3" => $lang['Tr_color3'], + "L_TR_CLASS1" => $lang['Tr_class1'], + "L_TR_CLASS2" => $lang['Tr_class2'], + "L_TR_CLASS3" => $lang['Tr_class3'], + "L_TH_COLOR1" => $lang['Th_color1'], + "L_TH_COLOR2" => $lang['Th_color2'], + "L_TH_COLOR3" => $lang['Th_color3'], + "L_TH_CLASS1" => $lang['Th_class1'], + "L_TH_CLASS2" => $lang['Th_class2'], + "L_TH_CLASS3" => $lang['Th_class3'], + "L_TD_COLOR1" => $lang['Td_color1'], + "L_TD_COLOR2" => $lang['Td_color2'], + "L_TD_COLOR3" => $lang['Td_color3'], + "L_TD_CLASS1" => $lang['Td_class1'], + "L_TD_CLASS2" => $lang['Td_class2'], + "L_TD_CLASS3" => $lang['Td_class3'], + "L_FONTFACE_1" => $lang['fontface1'], + "L_FONTFACE_2" => $lang['fontface2'], + "L_FONTFACE_3" => $lang['fontface3'], + "L_FONTSIZE_1" => $lang['fontsize1'], + "L_FONTSIZE_2" => $lang['fontsize2'], + "L_FONTSIZE_3" => $lang['fontsize3'], + "L_FONTCOLOR_1" => $lang['fontcolor1'], + "L_FONTCOLOR_2" => $lang['fontcolor2'], + "L_FONTCOLOR_3" => $lang['fontcolor3'], + "L_SPAN_CLASS_1" => $lang['span_class1'], + "L_SPAN_CLASS_2" => $lang['span_class2'], + "L_SPAN_CLASS_3" => $lang['span_class3'], + + "THEME_NAME" => $selected['style_name'], + "HEAD_STYLESHEET" => $selected['head_stylesheet'], + "BODY_BACKGROUND" => $selected['body_background'], + "BODY_BGCOLOR" => $selected['body_bgcolor'], + "BODY_LINK" => $selected['body_link'], + "BODY_VLINK" => $selected['body_vlink'], + "BODY_ALINK" => $selected['body_alink'], + "BODY_HLINK" => $selected['body_hlink'], + "TR_COLOR1" => $selected['tr_color1'], + "TR_COLOR2" => $selected['tr_color2'], + "TR_COLOR3" => $selected['tr_color3'], + "TR_CLASS1" => $selected['tr_class1'], + "TR_CLASS2" => $selected['tr_class2'], + "TR_CLASS3" => $selected['tr_class3'], + "TH_COLOR1" => $selected['th_color1'], + "TH_COLOR2" => $selected['th_color2'], + "TH_COLOR3" => $selected['th_color3'], + "TH_CLASS1" => $selected['th_class1'], + "TH_CLASS2" => $selected['th_class2'], + "TH_CLASS3" => $selected['th_class3'], + "TD_COLOR1" => $selected['td_color1'], + "TD_COLOR2" => $selected['td_color2'], + "TD_COLOR3" => $selected['td_color3'], + "TD_CLASS1" => $selected['td_class1'], + "TD_CLASS2" => $selected['td_class2'], + "TD_CLASS3" => $selected['td_class3'], + "FONTFACE1" => $selected['fontface1'], + "FONTFACE2" => $selected['fontface2'], + "FONTFACE3" => $selected['fontface3'], + "FONTSIZE1" => $selected['fontsize1'], + "FONTSIZE2" => $selected['fontsize2'], + "FONTSIZE3" => $selected['fontsize3'], + "FONTCOLOR1" => $selected['fontcolor1'], + "FONTCOLOR2" => $selected['fontcolor2'], + "FONTCOLOR3" => $selected['fontcolor3'], + "SPAN_CLASS1" => $selected['span_class1'], + "SPAN_CLASS2" => $selected['span_class2'], + "SPAN_CLASS3" => $selected['span_class3'], + + "TR_COLOR1_NAME" => $selected['tr_color1_name'], + "TR_COLOR2_NAME" => $selected['tr_color2_name'], + "TR_COLOR3_NAME" => $selected['tr_color3_name'], + "TR_CLASS1_NAME" => $selected['tr_class1_name'], + "TR_CLASS2_NAME" => $selected['tr_class2_name'], + "TR_CLASS3_NAME" => $selected['tr_class3_name'], + "TH_COLOR1_NAME" => $selected['th_color1_name'], + "TH_COLOR2_NAME" => $selected['th_color2_name'], + "TH_COLOR3_NAME" => $selected['th_color3_name'], + "TH_CLASS1_NAME" => $selected['th_class1_name'], + "TH_CLASS2_NAME" => $selected['th_class2_name'], + "TH_CLASS3_NAME" => $selected['th_class3_name'], + "TD_COLOR1_NAME" => $selected['td_color1_name'], + "TD_COLOR2_NAME" => $selected['td_color2_name'], + "TD_COLOR3_NAME" => $selected['td_color3_name'], + "TD_CLASS1_NAME" => $selected['td_class1_name'], + "TD_CLASS2_NAME" => $selected['td_class2_name'], + "TD_CLASS3_NAME" => $selected['td_class3_name'], + "FONTFACE1_NAME" => $selected['fontface1_name'], + "FONTFACE2_NAME" => $selected['fontface2_name'], + "FONTFACE3_NAME" => $selected['fontface3_name'], + "FONTSIZE1_NAME" => $selected['fontsize1_name'], + "FONTSIZE2_NAME" => $selected['fontsize2_name'], + "FONTSIZE3_NAME" => $selected['fontsize3_name'], + "FONTCOLOR1_NAME" => $selected['fontcolor1_name'], + "FONTCOLOR2_NAME" => $selected['fontcolor2_name'], + "FONTCOLOR3_NAME" => $selected['fontcolor3_name'], + "SPAN_CLASS1_NAME" => $selected['span_class1_name'], + "SPAN_CLASS2_NAME" => $selected['span_class2_name'], + "SPAN_CLASS3_NAME" => $selected['span_class3_name'], + + "S_THEME_ACTION" => append_sid("admin_styles.$phpEx"), + "S_TEMPLATE_SELECT" => $s_template_select, + "S_HIDDEN_FIELDS" => $s_hidden_fields) + ); - - message_die(GENERAL_MESSAGE, $lang['Theme_created'], $lang['Success']); - + $template->pparse("body"); } - - - - - - + break; - - } - else - { - if($mode == "edit") + case "export"; + if($HTTP_POST_VARS['export_template']) { - $themes_title = $lang['Edit_theme']; - $themes_explain = $lang['Edit_theme_explain']; - - $style_id = $HTTP_GET_VARS['style_id']; - - // - // Fetch the Theme Info from the db - // - $sql = "SELECT * FROM " . THEMES_TABLE . " WHERE themes_id = $style_id"; + $template_name = $HTTP_POST_VARS['export_template']; + + $sql = "SELECT * + FROM " . THEMES_TABLE . " + WHERE template_name = '$template_name'"; if(!$result = $db->sql_query($sql)) { - message_die(GENERAL_ERROR, "Could not get data from themes table", "Error", __LINE__, __FILE__, $sql); + message_die(GENERAL_ERROR, "Could not get theme data for selected template", "", __LINE__, __FILE__, $sql); } - $selected_values = $db->sql_fetchrow($result); + $theme_rowset = $db->sql_fetchrowset($result); - // - // Fetch the Themes Name data - // - $sql = "SELECT * FROM " . THEMES_NAME_TABLE . " WHERE themes_id = $style_id"; - if(!$result = $db->sql_query($sql)) + if( count($theme_rowset) == 0 ) { - message_die(GENERAL_ERROR, "Could not get data from themes name table", "Error", __LINE__, __FILE__, $sql); + message_die(GENERAL_MESSAGE, $lang['No_themes']); } - $selected_names = $db->sql_fetchrow($result); + $theme_data = ''; - } - else - { - $themes_title = $lang['Create_theme']; - $themes_explain = $lang['Create_theme_explain']; - } - - $template->set_filenames(array( - "body" => "admin/styles_edit_body.tpl") - ); - - - if($dir = opendir($phpbb_root_path . 'templates/')) - { - $s_template_select = ''; - $template->assign_vars(array( - "L_THEMES_TITLE" => $themes_title, - "L_THEMES_EXPLAIN" => $themes_explain, - "S_THEME_ACTION" => append_sid("$PHP_SELF"), - "L_THEME_NAME" => $lang['Theme_name'], - "L_TEMPLATE" => $lang['Template'], - "L_THEME_SETTINGS" => $lang['Theme_settings'], - "L_THEME_ELEMENT" => $lang['Theme_element'], - "L_SIMPLE_NAME" => $lang['Simple_name'], - "L_VALUE" => $lang['Value'], - "L_STYLESHEET" => $lang['Stylesheet'], - "L_BACKGROUND_IMAGE" => $lang['Background_image'], - "L_BACKGROUND_COLOR" => $lang['Background_color'], - "L_BODY_LINK" => $lang['Link_color'], - "L_BODY_VLINK" => $lang['VLink_color'], - "L_BODY_ALINK" => $lang['ALink_color'], - "L_BODY_HLINK" => $lang['HLink_color'], - "L_TR_COLOR1" => $lang['Tr_color1'], - "L_TR_COLOR2" => $lang['Tr_color2'], - "L_TR_COLOR3" => $lang['Tr_color3'], - "L_TR_CLASS1" => $lang['Tr_class1'], - "L_TR_CLASS2" => $lang['Tr_class2'], - "L_TR_CLASS3" => $lang['Tr_class3'], - "L_TH_COLOR1" => $lang['Th_color1'], - "L_TH_COLOR2" => $lang['Th_color2'], - "L_TH_COLOR3" => $lang['Th_color3'], - "L_TH_CLASS1" => $lang['Th_class1'], - "L_TH_CLASS2" => $lang['Th_class2'], - "L_TH_CLASS3" => $lang['Th_class3'], - "L_TD_COLOR1" => $lang['Td_color1'], - "L_TD_COLOR2" => $lang['Td_color2'], - "L_TD_COLOR3" => $lang['Td_color3'], - "L_TD_CLASS1" => $lang['Td_class1'], - "L_TD_CLASS2" => $lang['Td_class2'], - "L_TD_CLASS3" => $lang['Td_class3'], - "L_FONTFACE_1" => $lang['fontface1'], - "L_FONTFACE_2" => $lang['fontface2'], - "L_FONTFACE_3" => $lang['fontface3'], - "L_FONTSIZE_1" => $lang['fontsize1'], - "L_FONTSIZE_2" => $lang['fontsize2'], - "L_FONTSIZE_3" => $lang['fontsize3'], - "L_FONTCOLOR_1" => $lang['fontcolor1'], - "L_FONTCOLOR_2" => $lang['fontcolor2'], - "L_FONTCOLOR_3" => $lang['fontcolor3'], - "L_SPAN_CLASS_1" => $lang['span_class1'], - "L_SPAN_CLASS_2" => $lang['span_class2'], - "L_SPAN_CLASS_3" => $lang['span_class3'], - "S_TEMPLATE_SELECT" => $s_template_select, - "THEME_NAME" => $selected['style_name'], - "HEAD_STYLESHEET" => $selected['head_stylesheet'], - "BODY_BACKGROUND" => $selected['body_background'], - "BODY_BGCOLOR" => $selected['body_bgcolor'], - "BODY_LINK" => $selected['body_link'], - "BODY_VLINK" => $selected['body_vlink'], - "BODY_ALINK" => $selected['body_alink'], - "BODY_HLINK" => $selected['body_hlink'], - "TR_COLOR1" => $selected['tr_color1'], - "TR_COLOR2" => $selected['tr_color2'], - "TR_COLOR3" => $selected['tr_color3'], - "TR_CLASS1" => $selected['tr_class1'], - "TR_CLASS2" => $selected['tr_class2'], - "TR_CLASS3" => $selected['tr_class3'], - "TH_COLOR1" => $selected['th_color1'], - "TH_COLOR2" => $selected['th_color2'], - "TH_COLOR3" => $selected['th_color3'], - "TH_CLASS1" => $selected['th_class1'], - "TH_CLASS2" => $selected['th_class2'], - "TH_CLASS3" => $selected['th_class3'], - "TD_COLOR1" => $selected['td_color1'], - "TD_COLOR2" => $selected['td_color2'], - "TD_COLOR3" => $selected['td_color3'], - "TD_CLASS1" => $selected['td_class1'], - "TD_CLASS2" => $selected['td_class2'], - "TD_CLASS3" => $selected['td_class3'], - "FONTFACE1" => $selected['fontface1'], - "FONTFACE2" => $selected['fontface2'], - "FONTFACE3" => $selected['fontface3'], - "FONTSIZE1" => $selected['fontsize1'], - "FONTSIZE2" => $selected['fontsize2'], - "FONTSIZE3" => $selected['fontsize3'], - "FONTCOLOR1" => $selected['fontcolor1'], - "FONTCOLOR2" => $selected['fontcolor2'], - "FONTCOLOR3" => $selected['fontcolor3'], - "SPAN_CLASS1" => $selected['span_class1'], - "SPAN_CLASS2" => $selected['span_class2'], - "SPAN_CLASS3" => $selected['span_class3'], - - "TR_COLOR1_NAME" => $selected['tr_color1_name'], - "TR_COLOR2_NAME" => $selected['tr_color2_name'], - "TR_COLOR3_NAME" => $selected['tr_color3_name'], - "TR_CLASS1_NAME" => $selected['tr_class1_name'], - "TR_CLASS2_NAME" => $selected['tr_class2_name'], - "TR_CLASS3_NAME" => $selected['tr_class3_name'], - "TH_COLOR1_NAME" => $selected['th_color1_name'], - "TH_COLOR2_NAME" => $selected['th_color2_name'], - "TH_COLOR3_NAME" => $selected['th_color3_name'], - "TH_CLASS1_NAME" => $selected['th_class1_name'], - "TH_CLASS2_NAME" => $selected['th_class2_name'], - "TH_CLASS3_NAME" => $selected['th_class3_name'], - "TD_COLOR1_NAME" => $selected['td_color1_name'], - "TD_COLOR2_NAME" => $selected['td_color2_name'], - "TD_COLOR3_NAME" => $selected['td_color3_name'], - "TD_CLASS1_NAME" => $selected['td_class1_name'], - "TD_CLASS2_NAME" => $selected['td_class2_name'], - "TD_CLASS3_NAME" => $selected['td_class3_name'], - "FONTFACE1_NAME" => $selected['fontface1_name'], - "FONTFACE2_NAME" => $selected['fontface2_name'], - "FONTFACE3_NAME" => $selected['fontface3_name'], - "FONTSIZE1_NAME" => $selected['fontsize1_name'], - "FONTSIZE2_NAME" => $selected['fontsize2_name'], - "FONTSIZE3_NAME" => $selected['fontsize3_name'], - "FONTCOLOR1_NAME" => $selected['fontcolor1_name'], - "FONTCOLOR2_NAME" => $selected['fontcolor2_name'], - "FONTCOLOR3_NAME" => $selected['fontcolor3_name'], - "SPAN_CLASS1_NAME" => $selected['span_class1_name'], - "SPAN_CLASS2_NAME" => $selected['span_class2_name'], - "SPAN_CLASS3_NAME" => $selected['span_class3_name'], - - "S_HIDDEN_FIELDS" => $s_hidden_fields) - ); - - - $template->pparse("body"); + $theme_data .= '?' . '>'; // Done this to prevent highlighting editors getting confused! - - - - } - - break; - case "export"; - - if($HTTP_POST_VARS['export_template']) - { - $template_name = $HTTP_POST_VARS['export_template']; - $sql = "SELECT * FROM " . THEMES_TABLE . " WHERE template_name = '$template_name'"; - - if(!$result = $db->sql_query($sql)) - { - message_die(GENERAL_ERROR, "Could not get theme data for selected template", "Error", __LINE__, __FILE__, $sql); - } - - $theme_rowset = $db->sql_fetchrowset($result); - - if(count($theme_rowset) == 0) - { - message_die(GENERAL_MESSAGE, $lang['No_themes'], $lang['Export_themes']); - } - - $theme_data = ''; // Done this to prevent highlighting editors getting confused! - - - @umask(0111); + // + // Unable to open the file writeable do something here as an attempt + // to get around that... + // + $s_hidden_fields = ''; + $s_hidden_fields .= ''; + + $download_form = '
' . $s_hidden_fields; - $fp = @fopen($phpbb_root_path . 'templates/' . $template_name . '/theme_info.cfg', 'w'); - if( !$fp ) - { - // - // Unable to open the file writeable do something here as an attempt - // to get around that... - // - $s_hidden_fields = ''; - $s_hidden_fields .= ''; - - $download_form = '' . $s_hidden_fields; - $template->set_filenames(array( - "body" => "message_body.tpl") - ); + $template->set_filenames(array( + "body" => "message_body.tpl") + ); - $template->assign_vars(array( - "MESSAGE_TITLE" => $lang['Export_themes'], - "MESSAGE_TEXT" => $lang['Download_theme_cfg'] . "
" . $download_form) - ); + $template->assign_vars(array( + "MESSAGE_TITLE" => $lang['Export_themes'], + "MESSAGE_TEXT" => $lang['Download_theme_cfg'] . "

" . $download_form) + ); - $template->pparse('body'); - exit(); - } + $template->pparse('body'); + exit(); + } - $result = @fputs($fp, $theme_data, strlen($theme_data)); - fclose($fp); - - message_die(GENERAL_MESSAGE, $lang['Theme_info_saved'], $lang['Success']); + $result = @fputs($fp, $theme_data, strlen($theme_data)); + fclose($fp); + + $message = $lang['Theme_info_saved'] . "

" . sprintf($lang['Click_return_styleadmin'], "", "") . "

" . sprintf($lang['Click_return_admin_index'], "", ""); + message_die(GENERAL_MESSAGE, $message); - } - else if($HTTP_POST_VARS['send_file']) - { - - header("Content-Type: text/x-delimtext; name=\"theme_info.cfg\""); - header("Content-disposition: attachment; filename=theme_info.cfg"); - if( get_magic_quotes_gpc() ) + } + else if($HTTP_POST_VARS['send_file']) { - $HTTP_POST_VARS['theme_info'] = stripslashes($HTTP_POST_VARS['theme_info']); + + header("Content-Type: text/x-delimtext; name=\"theme_info.cfg\""); + header("Content-disposition: attachment; filename=theme_info.cfg"); + + echo stripslashes($HTTP_POST_VARS['theme_info']); } - echo $HTTP_POST_VARS['theme_info']; - } - else - { - $template->set_filenames(array( - "body" => "admin/styles_exporter.tpl") - ); - - if($dir = opendir($phpbb_root_path . 'templates/')) - { - $s_template_select = ''; + while( $file = @readdir($dir) ) + { + if( $file != "." && $file != ".." && $file != "CVS" ) + { + $s_template_select .= '\n"; + } } } + else + { + message_die(GENERAL_MESSAGE, $lang['No_template_dir']); + } + + $template->assign_vars(array( + "L_STYLE_EXPORTER" => $lang['Export_themes'], + "L_EXPORTER_EXPLAIN" => $lang['Export_explain'], + "L_TEMPLATE_SELECT" => $lang['Select_template'], + "L_SUBMIT" => $lang['Submit'], + + "S_EXPORTER_ACTION" => append_sid("admin_styles.$phpEx?mode=export"), + "S_TEMPLATE_SELECT" => $s_template_select) + ); + + $template->pparse("body"); + } - else - { - message_die(GENERAL_ERROR, $lang['No_template_dir'], $lang['Error'], __LINE__, __FILE__); - } - - $template->assign_vars(array( - "L_STYLE_EXPORTER" => $lang['Export_themes'], - "L_EXPORTER_EXPLAIN" => $lang['Export_explain'], - "S_EXPORTER_ACTION" => append_sid("$PHP_SELF?mode=export"), - "L_TEMPLATE_SELECT" => $lang['Select_template'], - "S_TEMPLATE_SELECT" => $s_template_select, - "L_SUBMIT" => $lang['Submit']) - ); - - $template->pparse("body"); - - } + break; - break; case "delete": $style_id = ($HTTP_GET_VARS['style_id']) ? intval($HTTP_GET_VARS['style_id']) : intval($HTTP_POST_VARS['style_id']); @@ -777,7 +780,7 @@ switch($mode) { if($style_id == $board_config['default_style']) { - message_die(GENERAL_MESSAGE, $lang['Cannot_remove_style'], $lang['Error']); + message_die(GENERAL_MESSAGE, $lang['Cannot_remove_style']); } $hidden_fields = ''; @@ -806,34 +809,43 @@ switch($mode) else { // - // The user has confirmed the delete. Remove the style, the style element names and update any users - // who might be using this style + // The user has confirmed the delete. Remove the style, the style element + // names and update any users who might be using this style // - $sql = "DELETE FROM " . THEMES_TABLE . " WHERE themes_id = $style_id"; + $sql = "DELETE FROM " . THEMES_TABLE . " + WHERE themes_id = $style_id"; if(!$result = $db->sql_query($sql, BEGIN_TRANSACTION)) { message_die(GENERAL_ERROR, "Could not remove style data!", "Error", __LINE__, __FILE__, $sql); } - $sql = "DELETE FROM " . THEMES_NAME_TABLE . " WHERE themes_id = $style_id"; - - // There may not be any theme name data so don't throw an error if the SQL dosan't work + // + // There may not be any theme name data so don't throw an error + // if the SQL dosan't work + // + $sql = "DELETE FROM " . THEMES_NAME_TABLE . " + WHERE themes_id = $style_id"; $db->sql_query($sql); - - $sql = "UPDATE " . USERS_TABLE . " SET user_style = " . $board_config['default_style'] . " WHERE user_style = $style_id"; + + $sql = "UPDATE " . USERS_TABLE . " + SET user_style = " . $board_config['default_style'] . " + WHERE user_style = $style_id"; if(!$result = $db->sql_query($sql, END_TRANSACTION)) { message_die(GENERAL_ERROR, "Could not update user style information", "Error", __LINE__, __FILE__, $sql); } - message_die(GENERAL_MESSAGE, $lang['Style_removed'], $lang['Success']); + $message = $lang['Style_removed'] . "

" . sprintf($lang['Click_return_styleadmin'], "", "") . "

" . sprintf($lang['Click_return_admin_index'], "", ""); + + message_die(GENERAL_MESSAGE, $message); } - - - break; + break; + default: - $sql = "SELECT themes_id, template_name, style_name FROM ".THEMES_TABLE." ORDER BY template_name"; + $sql = "SELECT themes_id, template_name, style_name + FROM " . THEMES_TABLE . " + ORDER BY template_name"; if(!$result = $db->sql_query($sql)) { message_die(GENERAL_ERROR, "Could not get style information!", "Error", __LINE__, __FILE__, $sql); @@ -845,35 +857,38 @@ switch($mode) "body" => "admin/styles_list_body.tpl") ); - $template->assign_vars(array("L_STYLES_TITLE" => $lang['Styles_admin'], + $template->assign_vars(array( + "L_STYLES_TITLE" => $lang['Styles_admin'], "L_STYLES_TEXT" => $lang['Styles_explain'], "L_STYLE" => $lang['Style'], "L_TEMPLATE" => $lang['Template'], "L_EDIT" => $lang['Edit'], - "L_DELETE" => $lang['Delete'])); + "L_DELETE" => $lang['Delete']) + ); for($i = 0; $i < count($style_rowset); $i++) { $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2']; $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2']; - $template->assign_block_vars("styles", array("ROW_CLASS" => $row_class, + $template->assign_block_vars("styles", array( + "ROW_CLASS" => $row_class, "ROW_COLOR" => $row_color, "STYLE_NAME" => $style_rowset[$i]['style_name'], "TEMPLATE_NAME" => $style_rowset[$i]['template_name'], - "U_STYLES_EDIT" => append_sid("$PHP_SELF?mode=edit&style_id=" . $style_rowset[$i]['themes_id']), - "U_STYLES_DELETE" => append_sid("$PHP_SELF?mode=delete&style_id=" . $style_rowset[$i]['themes_id']))); + + "U_STYLES_EDIT" => append_sid("admin_styles.$phpEx?mode=edit&style_id=" . $style_rowset[$i]['themes_id']), + "U_STYLES_DELETE" => append_sid("admin_styles.$phpEx?mode=delete&style_id=" . $style_rowset[$i]['themes_id'])) + ); } $template->pparse("body"); - - - break; + break; } -if(!$HTTP_POST_VARS['send_file']) +if( !$HTTP_POST_VARS['send_file'] ) { include('page_footer_admin.'.$phpEx); } -?> +?> \ No newline at end of file -- cgit v1.2.1