Menu
▾
▴
[mxbb-commits] core/admin admin_mx_page.php,1.19,1.20
|
From: Markus P. <mar...@us...> - 2005-04-03 13:35:17
|
Update of /cvsroot/mxbb/core/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv27745 Modified Files: admin_mx_page.php Log Message: Code clean-up. Introduced usage of mx_request_vars. Fixed bug #61 (missing AS keyword in SELECT fails on PostgreSQL). Index: admin_mx_page.php =================================================================== RCS file: /cvsroot/mxbb/core/admin/admin_mx_page.php,v retrieving revision 1.19 retrieving revision 1.20 diff -C2 -d -r1.19 -r1.20 *** admin_mx_page.php 17 Mar 2005 11:30:34 -0000 1.19 --- admin_mx_page.php 3 Apr 2005 13:34:50 -0000 1.20 *************** *** 21,131 **** $no_page_header = true; ! if ( !empty( $setmodules ) ) { ! $file = basename( __FILE__ ); ! $module['Portal - Pages']['Page_admin'] = 'admin/' . $file; return; } ! define( 'IN_PORTAL', 1 ); $mx_root_path = '../'; // Security and page header ! require( './pagestart.php' ); // Mode setting - if ( isset( $HTTP_POST_VARS['mode'] ) || isset( $HTTP_GET_VARS['mode'] ) ) - { - $mode = ( isset( $HTTP_POST_VARS['mode'] ) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode']; - $mode = htmlspecialchars( $mode ); - } - else - { - $mode = ''; - } - - if ( isset( $HTTP_POST_VARS['page_id'] ) || isset( $HTTP_GET_VARS['page_id'] ) ) - { - $page_id = ( isset( $HTTP_POST_VARS['page_id'] ) ) ? $HTTP_POST_VARS['page_id'] : $HTTP_GET_VARS['page_id']; - $page_id = intval( $page_id ); - } - else - { - $page_id = 1; - } ! if ( !empty( $mode ) ) { ! switch ( $mode ) { case 'add': case 'edit': ! page_edit( $mode, $page_id ); break; - case 'create': case 'modify': ! page_modify( $mode, $page_id ); break; - case 'delete': ! page_delete( $mode, $page_id ); break; - case 'delpage': ! page_delete( $mode, $page_id ); break; - default: ! mx_message_die( GENERAL_MESSAGE, $lang['No_mode'] ); break; } exit; } // CODE STARTS HERE ! $template->set_filenames( array( ! "body" => 'admin/mx_page_admin_edit.tpl' ) ! ); $sql = "SELECT * FROM " . PAGE_TABLE . " ORDER BY page_name"; ! ! if ( !( $result = $db->sql_query( $sql ) ) ) { ! mx_message_die( GENERAL_ERROR, "Couldn't get list of page", "", __LINE__, __FILE__, $sql ); } $row_count = 0; ! while ( $tblock[$row_count] = $db->sql_fetchrow( $result ) ) { ! $icon_tmp = ( !empty( $tblock[$row_count]['page_icon'] ) && $tblock[$row_count]['page_icon'] != 'none' ) ? '<img src="' . PORTAL_URL . TEMPLATE_ROOT_PATH . "images/page_icons/" . $tblock[$row_count]['page_icon'] . '" />' : ''; $page_id = $tblock[$row_count]['page_id']; ! $template->assign_block_vars( "pages", array( 'ID' => $page_id, ! 'NAME' => $tblock[$row_count]['page_name'], ! 'DESC' => $tblock[$row_count]['page_desc'], ! 'U_PAGES' => append_sid( PORTAL_URL . "admin/admin_mx_page_setting.php?page_id=" . $page_id ), ! 'ICON' => $icon_tmp, ! 'U_EDIT' => append_sid( PORTAL_URL . "admin/admin_mx_page.$phpEx?mode=edit&page_id=$page_id" ), ! 'U_SETTING' => append_sid( PORTAL_URL . "admin/admin_mx_page_setting.php?page_id=" . $page_id ), ! 'U_DELETE' => append_sid( PORTAL_URL . "admin/admin_mx_page.$phpEx?mode=delete&page_id=$page_id" ) ! ) ); ! $row_count++; } ! $template->assign_vars( array( 'S_ACTION' => append_sid( PORTAL_URL . "admin/admin_mx_page.$phpEx?mode=add" ), ! 'BLOCK_SIZE' => ( !empty( $block_size ) ? $block_size : '100%' ) , ! 'L_TITLE' => $lang['Page_admin'], ! 'L_EDIT' => $lang['Edit'], ! 'L_SETTING' => $lang['Settings'], ! 'L_DELETE' => $lang['Delete'], ! 'L_CREATE_PAGE' => $lang['Add_Page'] ! ) ); ! include_once( './page_header_admin.' . $phpEx ); ! $template->pparse( "body" ); ! include_once( './page_footer_admin.' . $phpEx ); // CODE ENDS HERE (obviously) exit; --- 21,112 ---- $no_page_header = true; ! if ( !empty($setmodules) ) { ! $module['Portal - Pages']['Page_admin'] = 'admin/' . basename(__FILE__); return; } ! define('IN_PORTAL', 1); $mx_root_path = '../'; // Security and page header ! require('./pagestart.php'); + // // Mode setting + // + $mode = $mx_request_vars->request('mode', MX_TYPE_NO_TAGS, ''); + $page_id = $mx_request_vars->request('page_id', MX_TYPE_INT, 1); ! if ( !empty($mode) ) { ! switch( $mode ) { case 'add': case 'edit': ! page_edit($mode, $page_id); break; case 'create': case 'modify': ! page_modify($mode, $page_id); break; case 'delete': ! page_delete($mode, $page_id); break; case 'delpage': ! page_delete($mode, $page_id); break; default: ! mx_message_die(GENERAL_MESSAGE, $lang['No_mode']); break; } exit; } + // CODE STARTS HERE ! $template->set_filenames(array( ! 'body' => 'admin/mx_page_admin_edit.tpl') ! ); $sql = "SELECT * FROM " . PAGE_TABLE . " ORDER BY page_name"; ! if ( !( $result = $db->sql_query($sql) ) ) { ! mx_message_die(GENERAL_ERROR, "Couldn't get list of page", '', __LINE__, __FILE__, $sql); } $row_count = 0; ! while ( $tblock[$row_count] = $db->sql_fetchrow($result) ) { ! $icon_tmp = ( !empty($tblock[$row_count]['page_icon']) && $tblock[$row_count]['page_icon'] != 'none' ) ? '<img src="' . PORTAL_URL . TEMPLATE_ROOT_PATH . "images/page_icons/" . $tblock[$row_count]['page_icon'] . '" />' : ''; $page_id = $tblock[$row_count]['page_id']; ! $template->assign_block_vars('pages', array( ! 'ID' => $page_id, ! 'NAME' => $tblock[$row_count]['page_name'], ! 'DESC' => $tblock[$row_count]['page_desc'], ! 'U_PAGES' => append_sid(PORTAL_URL . "admin/admin_mx_page_setting.$phpEx?page_id=$page_id"), ! 'ICON' => $icon_tmp, ! 'U_EDIT' => append_sid(PORTAL_URL . "admin/admin_mx_page.$phpEx?mode=edit&page_id=$page_id"), ! 'U_SETTING' => append_sid(PORTAL_URL . "admin/admin_mx_page_setting.$phpEx?page_id=$page_id"), ! 'U_DELETE' => append_sid(PORTAL_URL . "admin/admin_mx_page.$phpEx?mode=delete&page_id=$page_id") ! )); $row_count++; } ! $template->assign_vars(array( ! 'S_ACTION' => append_sid(PORTAL_URL . "admin/admin_mx_page.$phpEx?mode=add"), ! 'BLOCK_SIZE' => ( !empty($block_size) ? $block_size : '100%' ), ! 'L_TITLE' => $lang['Page_admin'], ! 'L_EDIT' => $lang['Edit'], ! 'L_SETTING' => $lang['Settings'], ! 'L_DELETE' => $lang['Delete'], ! 'L_CREATE_PAGE' => $lang['Add_Page'] ! )); ! include_once('./page_header_admin.' . $phpEx); ! $template->pparse('body'); ! include_once('./page_footer_admin.' . $phpEx); // CODE ENDS HERE (obviously) exit; *************** *** 134,170 **** // ****************************************************************** ! function page_edit( $mode, $page_id ) { ! global $template, $lang, $db, $board_config, $theme, $HTTP_GET_VARS, $HTTP_POST_VARS; ! $auth_fields = array( 'auth_view' ); ! $auth_ary = array( "auth_view" => AUTH_ALL ! ); ! $auth_levels = array( 'ALL', 'REG', 'PRIVATE', 'MOD', 'ADMIN', 'ANONYMOUS' ); ! $auth_const = array( AUTH_ALL, AUTH_REG, AUTH_ACL, AUTH_MOD, AUTH_ADMIN, AUTH_ANONYMOUS ); - $field_names = array( 'auth_view' => $lang['View'] ); - // Show form to create/modify a page ! if ( $mode == 'edit' ) ! { // $newmode determines if we are going to INSERT or UPDATE after posting? $newmode = 'modify'; $buttonvalue = $lang['Update']; ! $row = get_info( PAGE_TABLE, 'page_id', $page_id ); $page_name = $row['page_name']; $page_desc = $row['page_desc']; ! // $page_icon = $row['page_icon']; ! $page_icon = post_icons( 'page_icons/', $row['page_icon'] ); ! $page_header = empty( $row['page_header'] ) ? 'overall_header.tpl' : $row['page_header']; $page_graph_border = $row['page_graph_border']; ! //$page_group_auth_id = $row['auth_view_group']; ! $l_choose_page_template = ""; ! $template_list = ""; } else --- 115,149 ---- // ****************************************************************** ! function page_edit($mode, $page_id) { ! global $template, $lang, $db, $board_config, $theme, $HTTP_GET_VARS, $HTTP_POST_VARS, $phpEx; ! $auth_fields = array('auth_view'); ! $auth_ary = array('auth_view' => AUTH_ALL); ! $auth_levels = array('ALL', 'REG', 'PRIVATE', 'MOD', 'ADMIN', 'ANONYMOUS'); ! $auth_const = array(AUTH_ALL, AUTH_REG, AUTH_ACL, AUTH_MOD, AUTH_ADMIN, AUTH_ANONYMOUS); ! $field_names = array('auth_view' => $lang['View']); // Show form to create/modify a page ! if ( $mode == 'edit' ) ! { // $newmode determines if we are going to INSERT or UPDATE after posting? $newmode = 'modify'; $buttonvalue = $lang['Update']; ! $row = get_info(PAGE_TABLE, 'page_id', $page_id); $page_name = $row['page_name']; $page_desc = $row['page_desc']; ! // $page_icon = $row['page_icon']; ! $page_icon = post_icons('page_icons/', $row['page_icon']); ! $page_header = empty($row['page_header']) ? 'overall_header.tpl' : $row['page_header']; $page_graph_border = $row['page_graph_border']; ! // $page_group_auth_id = $row['auth_view_group']; ! $l_choose_page_template = ''; ! $template_list = ''; } else *************** *** 172,211 **** $newmode = 'create'; $buttonvalue = $lang['Submit']; ! $page_name = $HTTP_POST_VARS[page_name]; ! $page_desc = $HTTP_POST_VARS[page_desc]; ! // $page_icon = empty($row['page_icon']) ? 'icon_home.gif' : $row['page_icon']; ! $page_icon = post_icons( 'page_icons/' ); $page_header = 'overall_header.tpl'; ! $page_graph_border = '' ; ! $sql = "SELECT max( page_id ) page_id FROM " . PAGE_TABLE; ! if ( !$result = $db->sql_query( $sql ) ) { ! mx_message_die( GENERAL_ERROR, "Couldn't get page information", "", __LINE__, __FILE__, $sql ); } ! $row = $db->sql_fetchrow( $result ); ! $page_id = $row['page_id'] + 1; ! // Page templates dropdown ! ! $template_list = get_list( "use_template", PAGE_TEMPLATES, "page_template_id", "template_name", 1, true ); ! $l_choose_page_template = empty( $lang['Choose_page_template'] ) ? "Choose page template" : $lang['Choose_page_template']; } ! $template->set_filenames( array( "edit_page" => "admin/mx_page_edit_body.tpl" ) ! ); - $s_hidden_fields = '<input type="hidden" name="mode" value="' . $newmode . '" /><input type="hidden" name="page_id" value="' . $page_id . '" />'; - - // Output values of individual // fields ! ! for( $j = 0; $j < count( $auth_fields ); $j++ ) { $custom_auth[$j] = ' <select name="' . $auth_fields[$j] . '">'; ! for( $k = 0; $k < count( $auth_levels ); $k++ ) { $selected = ( $row[$auth_fields[$j]] == $auth_const[$k] ) ? ' selected="selected"' : ''; --- 151,191 ---- $newmode = 'create'; $buttonvalue = $lang['Submit']; ! $page_name = $HTTP_POST_VARS['page_name']; ! $page_desc = $HTTP_POST_VARS['page_desc']; ! // $page_icon = empty($row['page_icon']) ? 'icon_home.gif' : $row['page_icon']; ! $page_icon = post_icons('page_icons/'); $page_header = 'overall_header.tpl'; ! $page_graph_border = ''; ! $sql = "SELECT MAX(page_id) AS page_id FROM " . PAGE_TABLE; ! if ( !( $result = $db->sql_query($sql) ) ) { ! mx_message_die(GENERAL_ERROR, "Couldn't get page information", '', __LINE__, __FILE__, $sql); } ! $row = $db->sql_fetchrow($result); ! $page_id = $row['page_id'] + 1; ! // Page templates dropdown ! ! $template_list = get_list('use_template', PAGE_TEMPLATES, 'page_template_id', 'template_name', 1, true); ! $l_choose_page_template = empty($lang['Choose_page_template']) ? "Choose page template" : $lang['Choose_page_template']; } ! $template->set_filenames(array( ! 'edit_page' => 'admin/mx_page_edit_body.tpl') ! ); ! ! $s_hidden_fields = '<input type="hidden" name="mode" value="' . $newmode . '" /><input type="hidden" name="page_id" value="' . $page_id . '" />'; ! // Output values of individual // fields ! ! for( $j = 0; $j < count($auth_fields); $j++ ) { $custom_auth[$j] = ' <select name="' . $auth_fields[$j] . '">'; ! for( $k = 0; $k < count($auth_levels); $k++ ) { $selected = ( $row[$auth_fields[$j]] == $auth_const[$k] ) ? ' selected="selected"' : ''; *************** *** 214,262 **** $custom_auth[$j] .= '</select> '; ! // $custom_group_auth = mx_get_groups( $page_group_auth_id ); $cell_title = $field_names[$auth_fields[$j]]; ! $template->assign_block_vars( 'page_auth_titles', array( 'CELL_TITLE' => $cell_title ) ! ); ! $template->assign_block_vars( 'page_auth_data', array( ! 'S_AUTH_LEVELS_SELECT' => $custom_auth[$j] ) ! ); $s_column_span++; } ! $template->assign_vars( array( 'L_TITLE' => $lang['Page_admin'], ! 'L_EXPLAIN' => $lang['Page_admin_explain'], ! 'L_PAGE_NAME' => $lang['Page'], ! 'L_PAGE_DESC' => $lang['Page_desc'], ! 'L_PAGE_ID' => empty( $lang['Page_Id'] ) ? "Page Id" : $lang['Page_Id'] , ! 'L_PAGE_ICON' => empty( $lang['Page_icon'] ) ? "Page Icon" : $lang['Page_icon'] , ! 'L_PAGE_HEADER' => empty( $lang['Page_header'] ) ? "Page header file" : $lang['Page_header'] , ! 'L_PAGE_GRAPH_BORDER' => empty( $lang['Page_graph_border'] ) ? "Page border graphics" : $lang['Page_graph_border'] , ! 'L_PAGE_GRAPH_BORDER_EXPLAIN' => $lang['Page_graph_border_explain'], ! 'L_AUTH_TITLE' => empty( $lang['Auth_Page'] ) ? "Permission" : $lang['Auth_Page'], ! 'L_CHOOSE_PAGE_TEMPLATE' => $l_choose_page_template, ! ! 'PAGE_ID' => $page_id, ! 'PAGE_NAME' => $page_name, ! 'PAGE_DESC' => $page_desc, ! 'S_PAGE_ICON' => $page_icon, ! 'PAGE_HEADER' => $page_header, ! 'PAGE_GRAPH_BORDER' => $page_graph_border, ! 'S_ACTION' => append_sid( "admin_mx_page.php" ), ! 'S_HIDDEN_FIELDS' => $s_hidden_fields, ! 'S_SUBMIT_VALUE' => $buttonvalue, ! 'S_FUNCTION_LIST' => $functionlist, ! 'S_TEMPLATE_LIST' => $template_list ! ) ); ! define( 'IN_ADMIN', 1 ); ! include( './page_header_admin.php' ); ! $template->pparse( "edit_page" ); ! include( './page_footer_admin.php' ); } // ****************************************************************** --- 194,243 ---- $custom_auth[$j] .= '</select> '; ! // $custom_group_auth = mx_get_groups($page_group_auth_id); $cell_title = $field_names[$auth_fields[$j]]; ! $template->assign_block_vars('page_auth_titles', array( ! 'CELL_TITLE' => $cell_title ! )); ! $template->assign_block_vars('page_auth_data', array( ! 'S_AUTH_LEVELS_SELECT' => $custom_auth[$j] ! )); $s_column_span++; } ! $template->assign_vars(array( ! 'L_TITLE' => $lang['Page_admin'], ! 'L_EXPLAIN' => $lang['Page_admin_explain'], ! 'L_PAGE_NAME' => $lang['Page'], ! 'L_PAGE_DESC' => $lang['Page_desc'], ! 'L_PAGE_ID' => empty($lang['Page_Id']) ? "Page Id" : $lang['Page_Id'] , ! 'L_PAGE_ICON' => empty($lang['Page_icon']) ? "Page Icon" : $lang['Page_icon'] , ! 'L_PAGE_HEADER' => empty($lang['Page_header']) ? "Page header file" : $lang['Page_header'] , ! 'L_PAGE_GRAPH_BORDER' => empty($lang['Page_graph_border']) ? "Page border graphics" : $lang['Page_graph_border'] , ! 'L_PAGE_GRAPH_BORDER_EXPLAIN'=> $lang['Page_graph_border_explain'], ! 'L_AUTH_TITLE' => empty($lang['Auth_Page']) ? "Permission" : $lang['Auth_Page'], ! 'L_CHOOSE_PAGE_TEMPLATE' => $l_choose_page_template, ! 'PAGE_ID' => $page_id, ! 'PAGE_NAME' => $page_name, ! 'PAGE_DESC' => $page_desc, ! 'S_PAGE_ICON' => $page_icon, ! 'PAGE_HEADER' => $page_header, ! 'PAGE_GRAPH_BORDER' => $page_graph_border, ! 'S_ACTION' => append_sid("admin_mx_page.$phpEx"), ! 'S_HIDDEN_FIELDS' => $s_hidden_fields, ! 'S_SUBMIT_VALUE' => $buttonvalue, ! 'S_FUNCTION_LIST' => $functionlist, ! 'S_TEMPLATE_LIST' => $template_list ! )); ! define('IN_ADMIN', 1); ! include("./page_header_admin.$phpEx"); ! $template->pparse('edit_page'); ! include("./page_footer_admin.$phpEx"); } // ****************************************************************** *************** *** 265,354 **** // ****************************************************************** ! function page_modify( $mode, $page_id ) { ! global $template, $lang, $db, $board_config, $theme, $HTTP_POST_VARS; ! if ( $mode == "modify" ) { ! if ( $page_id != intval( $HTTP_POST_VARS['page_id_new'] ) ) { $sql = "UPDATE " . COLUMN_TABLE . " ! SET page_id = " . intval( $HTTP_POST_VARS['page_id_new'] ) . " WHERE page_id = " . $page_id; ! ! if ( !$result = $db->sql_query( $sql ) ) { ! mx_message_die( GENERAL_ERROR, "Couldn't update page information", "", __LINE__, __FILE__, $sql ); } } $sql = "UPDATE " . PAGE_TABLE . " ! SET page_id = " . intval( $HTTP_POST_VARS['page_id_new'] ) . ", ! page_name = '" . str_replace( "\'", "''", $HTTP_POST_VARS['page_name'] ) . "', ! page_desc = '" . str_replace( "\'", "''", $HTTP_POST_VARS['page_desc'] ) . "', ! page_icon = '" . str_replace( "\'", "''", $HTTP_POST_VARS['menuicons'] ) . "', ! page_header = '" . str_replace( "\'", "''", $HTTP_POST_VARS['page_header'] ) . "', ! page_graph_border = '" . str_replace( "\'", "''", $HTTP_POST_VARS['page_graph_border'] ) . "', auth_view = '" . $HTTP_POST_VARS['auth_view'] . "' WHERE page_id = " . $page_id; ! ! if ( !$result = $db->sql_query( $sql ) ) { ! mx_message_die( GENERAL_ERROR, "Couldn't update page information", "", __LINE__, __FILE__, $sql ); } } ! if ( $mode == "create" ) { $sql = "INSERT INTO " . PAGE_TABLE . " ( page_id, page_name, page_desc, page_icon, page_graph_border, auth_view, page_header ) VALUES ( '$HTTP_POST_VARS[page_id_new]' , '$HTTP_POST_VARS[page_name]', '$HTTP_POST_VARS[page_desc]', '$HTTP_POST_VARS[menuicons]', '$HTTP_POST_VARS[page_graph_border]', '$HTTP_POST_VARS[auth_view]', '$HTTP_POST_VARS[page_header]' )"; ! ! if ( !$result = $db->sql_query( $sql ) ) { ! mx_message_die( GENERAL_ERROR, "Couldn't insert page information", "", __LINE__, __FILE__, $sql ); ! } ! // Page templates ! if ( isset( $HTTP_POST_VARS['use_template'] ) || isset( $HTTP_GET_VARS['use_template'] ) ) { ! $use_template = ( isset( $HTTP_POST_VARS['use_template'] ) ) ? $HTTP_POST_VARS['use_template'] : $HTTP_GET_VARS['use_template']; } else { ! $use_template = ""; } ! if ( $use_template != "" && $use_template != "1" ) { $sql = " SELECT * FROM " . COLUMN_TEMPLATES . " WHERE page_template_id = " . $use_template; ! ! if ( !$result = $db->sql_query( $sql ) ) { ! mx_message_die( GENERAL_ERROR, "Couldn't get list of Columns for this template", "", __LINE__, __FILE__, $sql ); } ! $row = $db->sql_fetchrowset( $result ); ! for( $row_count = 0; $row_count < count( $row ); $row_count++ ) { $sql1 = "INSERT INTO " . COLUMN_TABLE . " (column_title, column_order, column_size, page_id) VALUES ( '" . $row[$row_count]['column_title'] . "', '" . $row[$row_count]['column_order'] . "', '" . $row[$row_count]['column_size'] . "', '" . $HTTP_POST_VARS['page_id_new'] . "' )"; ! if ( !$result = $db->sql_query( $sql1 ) ) { ! mx_message_die( GENERAL_ERROR, "Couldn't insert page information", "", __LINE__, __FILE__, $sql ); } } ! } ! // End of Page templates ! } ! // Update cache ! update_session_cache( $block_id ); ! ! $message = $lang['Portal_Config_updated'] . "<br /><br />" . sprintf( $lang['Click_return_portal_config'], "<a href=\"" . append_sid( "admin_mx_page.php" ) . "\">", "</a>" ) . "<br /><br />" . sprintf( $lang['Click_return_admin_index'], "<a href=\"" . append_sid( "index.php?pane=right" ) . "\">", "</a>" ); ! mx_message_die( GENERAL_MESSAGE, $message ); ! }; // ****************************************************************** --- 246,331 ---- // ****************************************************************** ! function page_modify($mode, $page_id) { ! global $template, $lang, $db, $board_config, $theme, $HTTP_POST_VARS, $phpEx; ! if ( $mode == 'modify' ) { ! if ( $page_id != intval($HTTP_POST_VARS['page_id_new']) ) { $sql = "UPDATE " . COLUMN_TABLE . " ! SET page_id = " . intval($HTTP_POST_VARS['page_id_new']) . " WHERE page_id = " . $page_id; ! if ( !( $result = $db->sql_query($sql) ) ) { ! mx_message_die(GENERAL_ERROR, "Couldn't update page information", '', __LINE__, __FILE__, $sql); } } $sql = "UPDATE " . PAGE_TABLE . " ! SET page_id = " . intval($HTTP_POST_VARS['page_id_new']) . ", ! page_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['page_name']) . "', ! page_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['page_desc']) . "', ! page_icon = '" . str_replace("\'", "''", $HTTP_POST_VARS['menuicons']) . "', ! page_header = '" . str_replace("\'", "''", $HTTP_POST_VARS['page_header']) . "', ! page_graph_border = '" . str_replace("\'", "''", $HTTP_POST_VARS['page_graph_border']) . "', auth_view = '" . $HTTP_POST_VARS['auth_view'] . "' WHERE page_id = " . $page_id; ! if ( !( $result = $db->sql_query($sql) ) ) { ! mx_message_die( GENERAL_ERROR, "Couldn't update page information", '', __LINE__, __FILE__, $sql); } } ! if ( $mode == 'create' ) { $sql = "INSERT INTO " . PAGE_TABLE . " ( page_id, page_name, page_desc, page_icon, page_graph_border, auth_view, page_header ) VALUES ( '$HTTP_POST_VARS[page_id_new]' , '$HTTP_POST_VARS[page_name]', '$HTTP_POST_VARS[page_desc]', '$HTTP_POST_VARS[menuicons]', '$HTTP_POST_VARS[page_graph_border]', '$HTTP_POST_VARS[auth_view]', '$HTTP_POST_VARS[page_header]' )"; ! if ( !( $result = $db->sql_query($sql) ) ) { ! mx_message_die(GENERAL_ERROR, "Couldn't insert page information", '', __LINE__, __FILE__, $sql); ! } ! // Page templates ! if ( isset($HTTP_POST_VARS['use_template']) || isset($HTTP_GET_VARS['use_template']) ) { ! $use_template = ( isset($HTTP_POST_VARS['use_template']) ) ? $HTTP_POST_VARS['use_template'] : $HTTP_GET_VARS['use_template']; } else { ! $use_template = ''; } ! if ( $use_template != '' && $use_template != '1' ) { $sql = " SELECT * FROM " . COLUMN_TEMPLATES . " WHERE page_template_id = " . $use_template; ! if ( !( $result = $db->sql_query($sql) ) ) { ! mx_message_die(GENERAL_ERROR, "Couldn't get list of Columns for this template", '', __LINE__, __FILE__, $sql); } ! $row = $db->sql_fetchrowset($result); ! for( $row_count = 0; $row_count < count($row); $row_count++ ) { $sql1 = "INSERT INTO " . COLUMN_TABLE . " (column_title, column_order, column_size, page_id) VALUES ( '" . $row[$row_count]['column_title'] . "', '" . $row[$row_count]['column_order'] . "', '" . $row[$row_count]['column_size'] . "', '" . $HTTP_POST_VARS['page_id_new'] . "' )"; ! if ( !( $result = $db->sql_query($sql1) ) ) { ! mx_message_die(GENERAL_ERROR, "Couldn't insert page information", '', __LINE__, __FILE__, $sql); } } ! } ! // End of Page templates ! } ! // Update cache ! update_session_cache($block_id); ! $message = $lang['Portal_Config_updated'] . '<br /><br />' . sprintf($lang['Click_return_portal_config'], '<a href="' . append_sid("admin_mx_page.$phpEx") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>'); ! ! mx_message_die(GENERAL_MESSAGE, $message); ! } // ****************************************************************** *************** *** 356,367 **** // ****************************************************************** ! function page_delete( $mode, $page_id ) { ! global $template, $lang, $db, $board_config, $theme, $HTTP_POST_VARS; ! if ( $mode == "delete" ) { ! $template->set_filenames( array( "admin_page" => "admin/mx_page_delete_body.tpl" ) ! ); $buttonvalue = $lang['Delete']; --- 333,345 ---- // ****************************************************************** ! function page_delete($mode, $page_id) { ! global $template, $lang, $db, $board_config, $theme, $HTTP_POST_VARS, $phpEx; ! if ( $mode == 'delete' ) { ! $template->set_filenames(array( ! 'admin_page' => 'admin/mx_page_delete_body.tpl') ! ); $buttonvalue = $lang['Delete']; *************** *** 370,433 **** $s_hidden_fields = '<input type="hidden" name="mode" value="' . $newmode . '" />'; ! $page_name = get_list( "page_id", PAGE_TABLE, 'page_id', 'page_name', $page_id, true ); ! ! $template->assign_vars( array( 'NAME' => $name, ! ! 'L_PAGE_DELETE' => $lang['Page_admin'], ! 'L_PAGE_DELETE_EXPLAIN' => $lang['Page_admin_explain'], ! 'L_PAGE_NAME' => $lang['Page'], ! 'NAME' => $page_name, ! "S_HIDDEN_FIELDS" => $s_hidden_fields, ! 'S_PAGE_ACTION' => append_sid( "admin_mx_page.php" ), ! 'S_SUBMIT_VALUE' => $buttonvalue ! ) ); ! define( 'IN_ADMIN', 1 ); ! include_once( './page_header_admin.php' ); ! $template->pparse( "admin_page" ); ! include_once( './page_footer_admin.php' ); } ! if ( $mode == "delpage" ) { $sql = "SELECT column_id FROM " . COLUMN_TABLE . " WHERE page_id = " . $page_id; ! if ( !$result = $db->sql_query( $sql ) ) { ! mx_message_die( GENERAL_ERROR, "Couldn't get list of Column", "", __LINE__, __FILE__, $sql ); } ! while ( $row = $db->sql_fetchrow( $result ) ) { $sql = "DELETE FROM " . COLUMN_BLOCK_TABLE . " ! WHERE column_id = " . $row[column_id] ; ! if ( !$result = $db->sql_query( $sql ) ) { ! mx_message_die( GENERAL_ERROR, "Couldn't delete column/block information", "", __LINE__, __FILE__, $sql ); } } $sql = "DELETE FROM " . COLUMN_TABLE . " WHERE page_id = " . $page_id; ! ! if ( !$result = $db->sql_query( $sql ) ) { ! mx_message_die( GENERAL_ERROR, "Couldn't delete page information", "", __LINE__, __FILE__, $sql ); } $sql = "DELETE FROM " . PAGE_TABLE . " WHERE page_id = " . $page_id; ! ! if ( !$result = $db->sql_query( $sql ) ) { ! mx_message_die( GENERAL_ERROR, "Couldn't delete page information", "", __LINE__, __FILE__, $sql ); } ! $message = $lang['Portal_Config_updated'] . "<br /><br />" . sprintf( $lang['Click_return_portal_config'], "<a href=\"" . append_sid( "admin_mx_page.php" ) . "\">", "</a>" ) . "<br /><br />" . sprintf( $lang['Click_return_admin_index'], "<a href=\"" . append_sid( "index.php?pane=right" ) . "\">", "</a>" ); // Update cache ! update_session_cache( $block_id ); ! ! mx_message_die( GENERAL_MESSAGE, $message ); } ! }; ?> \ No newline at end of file --- 348,407 ---- $s_hidden_fields = '<input type="hidden" name="mode" value="' . $newmode . '" />'; ! $page_name = get_list('page_id', PAGE_TABLE, 'page_id', 'page_name', $page_id, true); ! $template->assign_vars(array( ! 'L_PAGE_DELETE' => $lang['Page_admin'], ! 'L_PAGE_DELETE_EXPLAIN' => $lang['Page_admin_explain'], ! 'L_PAGE_NAME' => $lang['Page'], ! 'NAME' => $page_name, ! 'S_HIDDEN_FIELDS' => $s_hidden_fields, ! 'S_PAGE_ACTION' => append_sid("admin_mx_page.$phpEx"), ! 'S_SUBMIT_VALUE' => $buttonvalue ! )); ! define('IN_ADMIN', 1); ! include_once("./page_header_admin.$phpEx"); ! $template->pparse('admin_page'); ! include_once("./page_footer_admin.$phpEx"); } ! if ( $mode == 'delpage' ) { $sql = "SELECT column_id FROM " . COLUMN_TABLE . " WHERE page_id = " . $page_id; ! if ( !( $result = $db->sql_query($sql) ) ) { ! mx_message_die(GENERAL_ERROR, "Couldn't get list of Column", '', __LINE__, __FILE__, $sql); } ! while( $row = $db->sql_fetchrow($result) ) { $sql = "DELETE FROM " . COLUMN_BLOCK_TABLE . " ! WHERE column_id = " . $row['column_id']; ! if ( !( $result = $db->sql_query($sql) ) ) { ! mx_message_die(GENERAL_ERROR, "Couldn't delete column/block information", '', __LINE__, __FILE__, $sql); } } $sql = "DELETE FROM " . COLUMN_TABLE . " WHERE page_id = " . $page_id; ! if ( !( $result = $db->sql_query($sql) ) ) { ! mx_message_die(GENERAL_ERROR, "Couldn't delete page information", '', __LINE__, __FILE__, $sql); } $sql = "DELETE FROM " . PAGE_TABLE . " WHERE page_id = " . $page_id; ! if ( !( $result = $db->sql_query($sql) ) ) { ! mx_message_die(GENERAL_ERROR, "Couldn't delete page information", '', __LINE__, __FILE__, $sql); } ! $message = $lang['Portal_Config_updated'] . '<br /><br />' . sprintf($lang['Click_return_portal_config'], '<a href="' . append_sid("admin_mx_page.$phpEx") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>'); // Update cache ! update_session_cache($block_id); ! ! mx_message_die(GENERAL_MESSAGE, $message); } ! } ?> \ No newline at end of file |
