<?php 
/**
 * This script updates the theme's settings in the database to use the Settings API,
 * introduced in the theme since version 1.1.5
*/
function graphene_update_db(){
	global $graphene_defaults;
    
	if ( get_option( 'graphene_ga_code' ) === '' ){       
		graphene_update_db_to_1_0();
	}
	
	$current_settings = get_option( 'graphene_settings', array() );
	
	if ( $current_settings && array_key_exists( 'db_version', $current_settings ) ) {
		if ( $current_settings['db_version'] === '1.0' ) {
			graphene_update_db_to_1_1();
			$current_settings = get_option( 'graphene_settings', array() );
		}
	}

	if ( $current_settings && array_key_exists( 'db_version', $current_settings ) ) {
		if ( $current_settings['db_version'] === '1.1' ) {
			graphene_update_db_to_1_2();
			$current_settings = get_option( 'graphene_settings', array() );
		}
	}

	if ( $current_settings && array_key_exists( 'db_version', $current_settings ) ) {
		if ( $current_settings['db_version'] === '1.2' ) {
			set_transient( '_graphene_welcome_screen_redirect', true, 30 );
			graphene_update_db_to_1_3();
			$current_settings = get_option( 'graphene_settings', array() );
		}
	}

	// disect_it( $current_settings );
}

function graphene_update_db_to_1_0(){
    global $graphene_defaults;
        
	// Get the current options from the database
	$graphene_settings['slider_cat'] = get_option('graphene_slider_cat');
	$graphene_settings['slider_postcount'] = get_option('graphene_slider_postcount');
	$graphene_settings['slider_img'] = (get_option('graphene_slider_img')) ? get_option('graphene_slider_img') : 'featured_image';
	$graphene_settings['slider_imgurl'] = get_option('graphene_slider_imgurl');
	$graphene_settings['slider_height'] = get_option('graphene_slider_height');
	$graphene_settings['slider_speed'] = get_option('graphene_slider_speed');
	$graphene_settings['slider_position'] = get_option('graphene_slider_position');
	$graphene_settings['slider_disable'] = get_option('graphene_slider_disable');
	
	$graphene_settings['frontpage_posts_cats'] = get_option('graphene_frontpage_posts_cats');
	
	$graphene_settings['custom_feed_url'] = get_option('graphene_custom_feed_url');
	$graphene_settings['hide_feed_icon'] = get_option('graphene_hide_feed_icon');
	
	$graphene_settings['show_adsense'] = get_option('graphene_show_adsense');
	$graphene_settings['adsense_code'] = get_option('graphene_adsense_code');
	$graphene_settings['adsense_show_frontpage'] = get_option('graphene_adsense_show_frontpage');
	
	$graphene_settings['show_addthis'] = get_option('graphene_show_addthis');
	$graphene_settings['show_addthis_page'] = get_option('graphene_show_addthis_page');
	$graphene_settings['addthis_code'] = get_option('graphene_addthis_code');
	
	$graphene_settings['show_ga'] = get_option('graphene_show_ga');
	$graphene_settings['ga_code'] = get_option('graphene_ga_code');
	
	$graphene_settings['alt_home_sidebar'] = get_option('graphene_alt_home_sidebar');
	$graphene_settings['alt_home_footerwidget'] = get_option('graphene_alt_home_footerwidget');
	
	$graphene_settings['show_cc'] = get_option('graphene_show_cc');
	$graphene_settings['copy_text'] = get_option('graphene_copy_text');
	$graphene_settings['hide_copyright'] = get_option('graphene_hide_copyright');
	
	$graphene_settings['light_header'] = get_option('graphene_light_header');
	$graphene_settings['link_header_img'] = get_option('graphene_link_header_img');
	$graphene_settings['featured_img_header'] = get_option('graphene_featured_img_header');
	$graphene_settings['use_random_header_img'] = get_option('graphene_use_random_header_img');
	$graphene_settings['hide_top_bar'] = get_option('graphene_hide_top_bar');
	$graphene_settings['hide_feed_icon'] = get_option('graphene_hide_feed_icon');
	$graphene_settings['search_box_location'] = get_option('graphene_search_box_location');
	
	if (get_option('graphene_hide_sidebar')) {
		$graphene_settings['column_mode'] = 'one-col';
	} else {
		$graphene_settings['column_mode'] = get_option('graphene_content_sidebar_position')  == 'left' ? 'two-col-right' : 'two-col-left';
	}
	
	$graphene_settings['posts_show_excerpt'] = get_option('graphene_posts_show_excerpt');
	$graphene_settings['hide_post_author'] = get_option('graphene_hide_post_author');
        
	if (get_option(graphene_hide_post_date)) { // hide the date
		$graphene_settings['post_date_display'] = 'hidden';
	} elseif (get_option('graphene_show_post_year')) { // show the date and the year
		$graphene_settings['post_date_display'] = 'icon_plus_year';
	} else { // show the date but not the year (default)
		$graphene_settings['post_date_display'] = 'icon_no_year';
	}
	
	$graphene_settings['hide_post_commentcount'] = get_option('graphene_hide_post_commentcount');
	$graphene_settings['hide_post_cat'] = get_option('graphene_hide_post_cat');
	$graphene_settings['hide_post_tags'] = get_option('graphene_hide_post_tags');
	$graphene_settings['show_post_avatar'] = get_option('graphene_show_post_avatar');
	$graphene_settings['show_post_author'] = get_option('graphene_show_post_author');
	$graphene_settings['show_excerpt_more'] = get_option('graphene_show_excerpt_more');
	
	$graphene_settings['footerwidget_column'] = get_option('graphene_footerwidget_column');
	$graphene_settings['alt_footerwidget_column'] = get_option('graphene_alt_footerwidget_column');
	
	$graphene_settings['navmenu_child_width'] = get_option('graphene_navmenu_child_width');
	
	$graphene_settings['header_title_font_type'] = get_option('graphene_header_title_font_type');
	$graphene_settings['header_title_font_size'] = get_option('graphene_header_title_font_size');
	$graphene_settings['header_title_font_lineheight'] = get_option('graphene_header_title_font_lineheight');
	$graphene_settings['header_title_font_weight'] = get_option('graphene_header_title_font_weight');
	$graphene_settings['header_title_font_style'] = get_option('graphene_header_title_font_style');
	
	$graphene_settings['header_desc_font_type'] = get_option('graphene_header_desc_font_type');
	$graphene_settings['header_desc_font_size'] = get_option('graphene_header_desc_font_size');
	$graphene_settings['header_desc_font_lineheight'] = get_option('graphene_header_desc_font_lineheight');
	$graphene_settings['header_desc_font_weight'] = get_option('graphene_header_desc_font_weight');
	$graphene_settings['header_desc_font_style'] = get_option('graphene_header_desc_font_style');
	
	$graphene_settings['content_font_type'] = get_option('graphene_content_font_type');
	$graphene_settings['content_font_size'] = get_option('graphene_content_font_size');
	$graphene_settings['content_font_lineheight'] = get_option('graphene_content_font_lineheight');
	$graphene_settings['content_font_colour'] = get_option('graphene_content_font_colour');
	
	$graphene_settings['link_colour_normal'] = get_option('graphene_link_colour_normal');
	$graphene_settings['link_colour_visited'] = get_option('graphene_link_colour_visited');
	$graphene_settings['link_colour_hover'] = get_option('graphene_link_colour_hover');
	$graphene_settings['link_decoration_normal'] = get_option('graphene_link_decoration_normal');
	$graphene_settings['link_decoration_hover'] = get_option('graphene_link_decoration_hover');
	
	$graphene_settings['hide_allowedtags'] = get_option('graphene_hide_allowedtags');
	$graphene_settings['custom_css'] = get_option('graphene_custom_css');
	
	/* Merge current settings with the default settings */
	$graphene_settings = array_merge($graphene_defaults, $graphene_settings);
	
	/* Update the database, and delete the old settings if update successful */
	if (update_option('graphene_settings', $graphene_settings)) {
		
		delete_option('graphene_light_header');	
		delete_option('graphene_link_header_img');	
		delete_option('graphene_featured_img_header');
		delete_option('graphene_use_random_header_img');
		delete_option('graphene_hide_top_bar');
		delete_option('graphene_hide_feed_icon');
		delete_option('graphene_search_box_location');
		delete_option('graphene_content_sidebar_position');
		delete_option('graphene_hide_sidebar');
		delete_option('graphene_posts_show_excerpt');
		delete_option('graphene_hide_post_author');
		delete_option('graphene_hide_post_date');
		delete_option('graphene_show_post_year');
		delete_option('graphene_hide_post_commentcount');
		delete_option('graphene_hide_post_cat');
		delete_option('graphene_hide_post_tags');
		delete_option('graphene_show_post_avatar');
		delete_option('graphene_show_post_author');
		delete_option('graphene_show_excerpt_more');
		delete_option('graphene_header_title_font_type');
		delete_option('graphene_header_title_font_size');
		delete_option('graphene_header_title_font_lineheight');
		delete_option('graphene_header_title_font_weight');
		delete_option('graphene_header_title_font_style');
		delete_option('graphene_header_desc_font_type');
		delete_option('graphene_header_desc_font_size');
		delete_option('graphene_header_desc_font_lineheight');
		delete_option('graphene_header_desc_font_weight');
		delete_option('graphene_header_desc_font_style');
		delete_option('graphene_content_font_type');
		delete_option('graphene_content_font_size');
		delete_option('graphene_content_font_lineheight');
		delete_option('graphene_content_font_colour');
		delete_option('graphene_link_colour_normal');
		delete_option('graphene_link_colour_visited');
		delete_option('graphene_link_colour_hover');
		delete_option('graphene_link_decoration_normal');
		delete_option('graphene_link_decoration_hover');
		delete_option('graphene_footerwidget_column');
		delete_option('graphene_alt_footerwidget_column');
		delete_option('graphene_navmenu_child_width');
		delete_option('graphene_hide_allowedtags');
		delete_option('graphene_swap_title');
		delete_option('graphene_custom_css');
		delete_option('graphene_slider_cat');
		delete_option('graphene_slider_postcount');
		delete_option('graphene_slider_img');
		delete_option('graphene_slider_imgurl');
		delete_option('graphene_slider_height');
		delete_option('graphene_slider_speed');
		delete_option('graphene_slider_position');
		delete_option('graphene_slider_disable');
		delete_option('graphene_frontpage_posts_cats');
		delete_option('graphene_custom_feed_url');
		delete_option('graphene_hide_feed_icon');
		delete_option('graphene_show_adsense');
		delete_option('graphene_adsense_code');
		delete_option('graphene_adsense_show_frontpage');
		delete_option('graphene_show_addthis');
		delete_option('graphene_show_addthis_page');
		delete_option('graphene_addthis_code');
		delete_option('graphene_show_ga');
		delete_option('graphene_ga_code');
		delete_option('graphene_alt_home_sidebar');
		delete_option('graphene_alt_home_footerwidget');
		delete_option('graphene_show_cc');
		delete_option('graphene_copy_text');
		delete_option('graphene_hide_copyright');
                
                /* Delete DB Version from the database. This value is now included in the $graphene_defaults array */
		delete_option( 'graphene_dbversion' );
		
		return true;
		
	} else {
		return false;
	}
}

function graphene_update_db_to_1_1(){
    global $graphene_defaults;
        
    $graphene_settings = get_option( 'graphene_settings', array() );
    $graphene_settings['db_version'] = '1.1';
    $graphene_settings['social_profiles'] = $graphene_defaults['social_profiles'];
    
    if ( ! empty( $graphene_settings['custom_feed_url'] ) ) {
		$graphene_settings['social_profiles'][0]['url'] = $graphene_settings['custom_feed_url'];;
        unset( $graphene_settings['custom_feed_url'] );
    }
    
    // Remove the RSS profile if it is hidden
    if ( isset ( $graphene_settings['hide_feed_icon'] ) ) {
        unset( $graphene_settings['social_profiles'][0] );
        unset( $graphene_settings['hide_feed_icon'] );
    }
    
    // Add the Twitter profile if the url is set
    if ( ! empty( $graphene_settings['twitter_url'] ) ) {
        $graphene_settings['social_profiles'][] = array (  
            'type' 	=> 'twitter',
			'name' => 'Twitter',
			'title'	=> sprintf( __( 'Follow %s on Twitter', 'graphene' ), get_bloginfo( 'name' ) ),
            'url' 	=> $graphene_settings['twitter_url']
        );        
        unset( $graphene_settings['twitter_url'] );
    }
    
    // Add the Facebook url if the url is set
    if ( !empty( $graphene_settings['facebook_url'] ) ) {
        $graphene_settings['social_profiles'][] = array (  
            'type' => 'facebook',
			'name'	=> 'Facebook',
            'title' => sprintf( __( "Visit %s's Facebook page", 'graphene' ), get_bloginfo( 'name' ) ),
            'url' => $graphene_settings['facebook_url']
        );        
        unset( $graphene_settings['facebook_url'] );
    }
	
	// Convert the custom social media to social media of "Custom" type
	$social_media = $graphene_settings['social_media'];
	if ( ! empty( $social_media ) ){
		foreach ( $social_media as $slug => $social_medium ){
			$graphene_settings['social_profiles'][] = array(
				'type'		=> 'custom',
				'name'		=> 'Custom',
				'title'		=> $social_medium['title'],
				'url'		=> $social_medium['url'],
				'icon_url' 	=> $social_medium['icon'],
			);
		}
	}
	
	// If there is no social media (including RSS), set the setting to false
	if ( empty( $graphene_settings['social_profiles'] ) )
		$graphene_settings['social_profiles'] = array( 0 => false );
    
    /* Merge current settings with the default settings */
    $graphene_settings = array_merge($graphene_defaults, $graphene_settings);
	
	/* Only save options that have different values than the default values */
	foreach ( $graphene_settings as $key => $value ){
		if ( ( $graphene_defaults[$key] === $value || $value === '' ) && $key != 'db_version' ) {
			unset( $graphene_settings[$key] );
		}
	}
	
    update_option('graphene_settings', $graphene_settings);        
}

function graphene_update_db_to_1_2(){    
        
    $graphene_settings = get_option( 'graphene_settings', array() );
    $graphene_settings['db_version'] = '1.2';
    
    /* because the column modus have been renamed we need to update the DB! */
    if ( isset( $graphene_settings['column_mode'] ) ) {
        $graphene_settings['column_mode'] = str_replace( '-', '_', $graphene_settings['column_mode'] );
    }     
    if ( isset( $graphene_settings['bbp_column_mode'] ) ) {
        $graphene_settings['bbp_column_mode'] = str_replace( '-', '_', $graphene_settings['bbp_column_mode'] );
    } 
    
    if ( isset( $graphene_settings['column_width'] ) && is_array( $graphene_settings['column_width'] ) ) {
        $two_col = $graphene_settings['column_width']['two-col'];
        $three_col = $graphene_settings['column_width']['three-col'];
        $graphene_settings['column_width'] = array(
            'two_col' => $two_col,
            'three_col' => $three_col 
        );
    }    
    
    update_option('graphene_settings', $graphene_settings);
}


/**
 * Migrate options from previous versions
 */
function graphene_update_db_to_1_3(){

	global $graphene_defaults;

	$graphene_settings = get_option( 'graphene_settings', array() );
	update_option( 'graphene_legacy_settings', $graphene_settings );

    $graphene_settings['db_version'] = '1.3';

    /* Migrate our custom CSS option to WordPress native custom CSS feature */
	if ( isset( $graphene_settings['custom_css'] ) ) {

		$theme = wp_get_theme();
		$css = wp_get_custom_css( $theme->stylesheet );
		$css .= PHP_EOL . $graphene_settings['custom_css'];

		wp_update_custom_css_post( $css );
	}

	/* Migrate option for infinite scroll method */
	if ( isset( $graphene_settings['inf_scroll_click'] ) ) {
		$graphene_settings['inf_scroll_method'] = 'click';
	}

	/* Convert option for homepage panes post type */
	if ( isset( $graphene_settings['show_post_type'] ) && $graphene_settings['show_post_type'] == 'cat-latest-posts' ) {
		$graphene_settings['show_post_type'] = 'latest-posts';
	}

	/* Migrate options with modified field name */
	$field_map = array(
		'top_bar_top_bg'				=> 'top_bar_bg',
		'menu_primary_top_bg' 			=> 'menu_primary_bg',
		'menu_primary_active_top_bg'	=> 'menu_primary_active_bg',
		'menu_sec_dd_top_bg'			=> 'menu_sec_dd_bg',
		'bg_content_wrapper'			=> 'content_wrapper_bg',
		'bg_content'					=> 'content_bg',
		'bg_meta_border'				=> 'meta_border',
		'bg_sticky_content'				=> 'sticky_border',
		'bg_child_page_content'			=> 'child_page_content_bg',
		'bg_widget_item'				=> 'widget_item_bg',
		'bg_widget_list'				=> 'widget_list',
		'bg_widget_header_border'		=> 'widget_header_border',
		'bg_button'						=> 'button_bg',
		'bg_button_label'				=> 'button_label',
		'bg_archive_left'				=> 'archive_bg',
		'bg_archive_label'				=> 'archive_label',
		'bg_archive_text'				=> 'archive_text',
		'bg_comments'					=> 'comments_bg',
		'bg_author_comments_border'		=> 'author_comments_border',
	);
	foreach ( $field_map as $old_field => $new_field ){
		if ( isset( $graphene_settings[$old_field] ) ) {
			$graphene_settings[$new_field] = $graphene_settings[$old_field];
			unset( $graphene_settings[$old_field] );
		}
	}

	/* Remove values for options that are no longer available */
	foreach ( $graphene_settings as $key => $value ){
		if ( ! array_key_exists( $key, $graphene_defaults ) ) unset( $graphene_settings[$key] );
		elseif ( ( $graphene_defaults[$key] === $value || $value === '' ) && $key != 'db_version' ) {
			unset( $graphene_settings[$key] );
		}
	}

	/* Convert the column width settings */
	if ( isset( $graphene_settings['container_width'] ) && $graphene_settings['container_width'] <= $graphene_defaults['container_width'] ) unset( $graphene_settings['container_width'] );
	if ( isset( $graphene_settings['grid_width'] ) ) unset( $graphene_settings['grid_width'] );
	if ( isset( $graphene_settings['gutter_width'] ) ) unset( $graphene_settings['gutter_width'] );
	if ( isset( $graphene_settings['column_width'] ) ) {
		foreach ( $graphene_settings['column_width'] as $column_mode => $cols_width ) {
			$total_width = array_sum( $cols_width );
			foreach ( $cols_width as $col => $col_width ) {
				$graphene_settings['column_width'][$column_mode][$col] = round( $col_width / $total_width * 12 );
			}
		}
	}

	update_option( 'graphene_settings', $graphene_settings );
}


/**
 * This DB update converts the theme's custom fields into a single database entry for each posts and pages
 */
function graphene_convert_meta( $post_id ){
	
	/* Do the conversion */
	$custom_fields = graphene_custom_fields_defaults();
	
	$graphene_meta = array();
	foreach ( $custom_fields as $custom_field => $default_val ) {
		$current_value = get_post_meta( $post_id, '_graphene_' . $custom_field, true );
		if ( $current_value !== false ) {
			if ( $default_val !== $current_value && $current_value != 'global' ) $graphene_meta[$custom_field] = $current_value;
			delete_post_meta( $post_id, '_graphene_' . $custom_field );
		}
	}
	if ( $graphene_meta ) update_post_meta( $post_id, '_graphene_meta', $graphene_meta );
}