function main($id, $mode) { global $db, $user, $auth, $template, $cache; global $k_config, $SID, $phpbb_root_path, $phpbb_admin_path, $phpEx; include $phpbb_root_path . 'includes/sgp_functions.' . $phpEx; include $phpbb_root_path . 'includes/sgp_functions_admin.' . $phpEx; $user->add_lang('acp/k_vars'); $this->tpl_name = 'acp_k_vars'; $this->page_title = 'ACP_K_VARS_CONFIG'; $form_key = 'acp_k_vars'; add_form_key($form_key); $choice = request_var('switch', ''); $block = request_var('block', ''); $mode = request_var('mode', ''); $switch = request_var('switch', ''); if ($block == '') { $block = 0; } if ($mode = 'config' && $choice == '') { $choice = 'config'; } if (isset($block)) { $sql = "SELECT id, title, var_file_name\n\t\t\t\tFROM " . K_BLOCKS_TABLE . "\n\t\t\t\tWHERE id = " . (int) $block; $result = $db->sql_query($sql); $row = $db->sql_fetchrow($result); $title = strtoupper($row['title']); $title = str_replace(' ', '_', $row['title']); $block_id = $row['id']; $var_file_name = $row['var_file_name']; $db->sql_freeresult($result); get_all_groups(); } $block = !empty($block) ? $block : 0; $action = request_var('action', ''); $submit = isset($_POST['submit']) ? true : false; // swicth to other var setups 11 March 2010 if ($switch) { get_reserved_words(); $var_file_name = $switch; } $template->assign_vars(array('S_SWITCH' => $var_file_name)); if ($submit && !check_form_key($form_key)) { $submit = false; $mode = ''; trigger_error($user->lang['FORM_INVALID']); } //$wheresql = ' WHERE block_id = ' . $block; $wheresql = ''; $sql = 'SELECT config_name, config_value FROM ' . K_BLOCKS_CONFIG_VAR_TABLE . $wheresql; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) { $k_config[$row['config_name']] = $row['config_value']; $template->assign_var('S_' . strtoupper($row['config_name']), $row['config_value']); } $db->sql_freeresult($result); $template->assign_vars(array('S_OPT' => 'config', 'MESSAGE' => '')); if ($submit) { $mode = 'save'; } else { $mode = 'reset'; } switch ($mode) { case 'save': //$news_forum_id = $_POST['news_forum_id']; $allow_acronyms = request_var('allow_acronyms', 1); $allow_announce = request_var('allow_announce', ''); $allow_bot_display = request_var('allow_bot_display', ''); $allow_footer_images = request_var('allow_footer_images', ''); $allow_news = request_var('allow_news', ''); $allow_rotating_logos = request_var('allow_rotating_logos', ''); $announce_type = request_var('announce_type', ''); $display_blocks_global = request_var('display_blocks_global', ''); $link_forum_id = request_var('link_forum_id', ''); $link_to_us_image = request_var('link_to_us_image', ''); $max_announce_item_length = request_var('max_announce_item_length', ''); $max_news_item_length = request_var('max_news_item_length', ''); $news_type = request_var('news_type', ''); $number_of_announce_items_to_display = request_var('number_of_announce_items_to_display', ''); $number_of_bots_to_display = request_var('number_of_bots_to_display', ''); $number_of_links_to_display = request_var('number_of_links_to_display', ''); $number_of_news_items_to_display = request_var('number_of_news_items_to_display', ''); $number_of_recent_topics_to_display = request_var('number_of_recent_topics_to_display', ''); $number_of_topics_per_forum = request_var('number_of_topics_per_forum', ''); $number_of_team_members_to_display = request_var('number_of_team_members_to_display', ''); $number_of_top_posters_to_display = request_var('number_of_top_posters_to_display', ''); $number_of_top_referrals_to_display = request_var('number_of_top_referrals_to_display', ''); $teams_to_display = request_var('teams_to_display', ''); $recent_topics_search_exclude = request_var('recent_topics_search_exclude', ''); $mini_mod_style_count = request_var('mini_mod_style_count', ''); $mini_mod_block_count = request_var('mini_mod_block_count', ''); $mini_mod_mod_count = request_var('mini_mod_mod_count', ''); $teamspeak_pw = request_var('teamspeak_pw', ''); $teamspeak_connection = request_var('teamspeak_connection', ''); $k_show_smilies = request_var('k_show_smilies', 1); $rand_banner = request_var('rand_banner', ''); $rand_header = request_var('rand_header', ''); $use_cookies = request_var('use_cookies', ''); $opt_irc_channels = request_var('opt_irc_channels', ''); $search_days = request_var('search_days', ''); $post_types = request_var('post_types', ''); $max_last_online = request_var('max_last_online', ''); $max_top_topics = request_var('max_top_topics', ''); $days_top_topics = request_var('days_top_topics', ''); $age_range_interval = request_var('age_range_interval', ''); $age_range_start = request_var('age_range_start', ''); $age_upper_limit = request_var('age_upper_limit', ''); $cloud_max_tags = request_var('cloud_max_tags', ''); $cloud_movie = request_var('cloud_movie', ''); $cloud_tcolour = request_var('cloud_tcolour', ''); $cloud_tcolour2 = request_var('cloud_tcolour2', ''); $cloud_hicolour = request_var('cloud_hicolour', ''); $cloud_width = request_var('cloud_width', ''); $cloud_height = request_var('cloud_height', ''); $cloud_bg_colour = request_var('cloud_bg_colour', ''); $cloud_speed = request_var('cloud_speed', ''); $cloud_mode = request_var('cloud_mode', ''); $cloud_wmode = request_var('cloud_wmode', ''); $cloud_distr = request_var('cloud_distr', ''); $cloud_search_allow = request_var('cloud_search_allow', 1); $cloud_search_cache = request_var('cloud_search_cache', 0); $teamspeak_pw = request_var('teamspeak_pw', ''); $teamspeak_connection = request_var('teamspeak_connection', ''); $sgp_quick_reply = request_var('sgp_quick_reply', 1); $k_yourtube_link = request_var('k_yourtube_link', ''); $block_cache_time_default = request_var('block_cache_time_default', ''); $block_recent_cache_time = request_var('block_recent_cache_time', ''); switch ($announce_type) { case 2: $announce_type = POST_ANNOUNCE; break; case 3: $announce_type = POST_GLOBAL; break; default: $announce_type = 0; break; } switch ($news_type) { case 4: $news_type = POST_NEWS; break; case 5: $news_type = POST_NEWS_GLOBAL; break; default: $news_type = 0; break; } // all data is escaped in sgp_acp_set_config // //sgp_acp_set_config('news_forum_id', $news_forum_id); sgp_acp_set_config('allow_acronyms', $allow_acronyms); sgp_acp_set_config('allow_announce', $allow_announce); sgp_acp_set_config('allow_bot_display', $allow_bot_display); sgp_acp_set_config('allow_footer_images', $allow_footer_images); sgp_acp_set_config('allow_news', $allow_news); sgp_acp_set_config('allow_rotating_logos', $allow_rotating_logos); sgp_acp_set_config('announce_type', $announce_type); sgp_acp_set_config('display_blocks_global', $display_blocks_global); sgp_acp_set_config('k_show_smilies', $k_show_smilies); sgp_acp_set_config('link_to_us_image', $link_to_us_image); sgp_acp_set_config('link_forum_id', $link_forum_id); sgp_acp_set_config('news_type', $news_type, true); sgp_acp_set_config('number_of_announce_items_to_display', $number_of_announce_items_to_display); sgp_acp_set_config('number_of_bots_to_display', $number_of_bots_to_display); sgp_acp_set_config('number_of_links_to_display', $number_of_links_to_display); sgp_acp_set_config('number_of_news_items_to_display', $number_of_news_items_to_display); sgp_acp_set_config('max_news_item_length', $max_news_item_length); sgp_acp_set_config('max_announce_item_length', $max_announce_item_length); sgp_acp_set_config('number_of_recent_topics_to_display', $number_of_recent_topics_to_display); sgp_acp_set_config('number_of_topics_per_forum', $number_of_topics_per_forum); sgp_acp_set_config('number_of_team_members_to_display', $number_of_team_members_to_display); sgp_acp_set_config('number_of_top_posters_to_display', $number_of_top_posters_to_display); sgp_acp_set_config('number_of_top_referrals_to_display', $number_of_top_referrals_to_display); sgp_acp_set_config('teams_to_display', $teams_to_display); sgp_acp_set_config('recent_topics_search_exclude', $recent_topics_search_exclude); sgp_acp_set_config('rand_banner', $rand_banner); sgp_acp_set_config('rand_header', $rand_header); sgp_acp_set_config('use_cookies', $use_cookies); sgp_acp_set_config('opt_irc_channels', $opt_irc_channels); sgp_acp_set_config('search_days', $search_days); sgp_acp_set_config('post_types', $post_types); sgp_acp_set_config('max_last_online', $max_last_online); sgp_acp_set_config('max_top_topics', $max_top_topics); sgp_acp_set_config('days_top_topics', $days_top_topics); sgp_acp_set_config('age_range_interval', $age_range_interval); sgp_acp_set_config('age_range_start', $age_range_start); sgp_acp_set_config('age_upper_limit', $age_upper_limit); sgp_acp_set_config('mini_mod_style_count', $mini_mod_style_count); sgp_acp_set_config('mini_mod_block_count', $mini_mod_block_count); sgp_acp_set_config('mini_mod_mod_count', $mini_mod_mod_count); sgp_acp_set_config('cloud_tcolour', $cloud_tcolour); sgp_acp_set_config('cloud_tcolour2', $cloud_tcolour2); sgp_acp_set_config('cloud_hicolour', $cloud_hicolour); sgp_acp_set_config('cloud_width', $cloud_width); sgp_acp_set_config('cloud_height', $cloud_height); sgp_acp_set_config('cloud_bg_colour', $cloud_bg_colour); sgp_acp_set_config('cloud_speed', $cloud_speed); sgp_acp_set_config('cloud_mode', $cloud_mode); sgp_acp_set_config('cloud_wmode', $cloud_wmode); sgp_acp_set_config('cloud_distr', $cloud_distr); sgp_acp_set_config('cloud_search_allow', $cloud_search_allow); sgp_acp_set_config('cloud_search_cache', $cloud_search_cache); sgp_acp_set_config('teamspeak_pw', $teamspeak_pw); sgp_acp_set_config('teamspeak_connection', $teamspeak_connection); sgp_acp_set_config('sgp_quick_reply', $sgp_quick_reply); sgp_acp_set_config('k_yourtube_link', $k_yourtube_link); sgp_acp_set_config('block_cache_time_default', $block_cache_time_default); sgp_acp_set_config('block_recent_cache_time', $block_recent_cache_time); $mode = 'reset'; $template->assign_vars(array('S_OPT' => $user->lang['SAVING'], 'MESSAGE' => $user->lang['SAVED'])); $cache->destroy('sql', K_BLOCKS_CONFIG_VAR_TABLE); if ($block) { meta_refresh(2, append_sid("{$phpbb_admin_path}index.{$phpEx}", "i=k_vars&mode=config&block=" . $block)); } else { meta_refresh(2, append_sid("{$phpbb_admin_path}index.{$phpEx}", "i=k_vars&mode=config&switch=" . $switch)); } return; case 'default': break; } switch ($action) { case 'submit': $mode = 'reset'; break; case 'default': break; } }
} // build sql for altering column domain if (isset($s_coldefs['mod']['domain']) && $s_coldefs['mod']['domain'] == 'Yes' && $_POST['cd_def_domainmod'] != $s_coldefs['mod']['type']) { $s_coldefs['mod']['type'] = $_POST['cd_def_domainmod']; $sql .= 'ALTER ' . $s_modify_col . ' ' . $s_coldefs['mod']['type'] . ', '; $mod_flag = TRUE; } // build sql for changing column position if ($_POST['tb_modcol_pos'] != '') { $sql .= 'ALTER ' . $s_modify_col . ' POSITION ' . $_POST['tb_modcol_pos'] . ', '; $mod_flag = TRUE; } // build sql for renaming of the column if ($_POST['cd_def_namemod'] != $s_modify_col) { // interbase keywords are not allowed as column names if (in_array(strtoupper($s_coldefs['mod']['name']), get_reserved_words(SERVER_FAMILY, SERVER_VERSION))) { $warning = sprintf($WARNINGS['NAME_IS_KEYWORD'], strtoupper($s_coldefs['mod']['name'])); } else { $sql .= 'ALTER ' . $s_modify_col . ' TO ' . $_POST['cd_def_namemod'] . ', '; $mod_flag = TRUE; } } if ($mod_flag) { $sql = substr($sql, 0, -2); // remove the trailing ', ' $sql .= ';'; } else { $sql = ''; } if ($s_wt['table'] == $s_modify_name) { $s_watch_buffer = '';