kedo fucked around with this message at 21:21 on Feb 4, 2013

function generate_csv2(){
		global $wpdb;
		
		$args = array('post_type'=>'members','post_status'=>'publish','numberposts'=>'-1', 'order'=>'ASC', 'order_by'=>'post_title');
		$members = get_posts($args);

		$mem_arr = array();
		foreach($members as $member){
			$member_meta = get_post_meta($member->ID);
			
			$query = "SELECT wp_p2p.p2p_from
				FROM wp_p2p
				WHERE wp_p2p.p2p_to = '".$member->ID."'";
			$result = $wpdb->get_results($query);
			

			$location = get_post($result[0]->p2p_from);
	
			$location_meta = get_post_meta($location->ID);
			print_r($location_meta);
			
			$member_data = new stdClass();
			$member_data->Company = $location->post_title;
			$member_data->First_Name = $member_meta['member_first_name'][0];
			$member_data->Last_Name = $member_meta['member_last_name'][0];
			$member_data->Title = $member_meta['member_title'][0];
			$member_data->Address_1 = $location_meta['location_address_1'][0];
			$member_data->Address_2 = $location_meta['location_address_2'][0];
			$member_data->City = $location_meta['location_city'][0];
			$member_data->Province = $location_meta['location_province'][0];
			$member_data->Postal_Code = $location_meta['location_postal'][0];
			$member_data->Phone = $location_meta['location_phone'][0];
			$member_data->Fax = $location_meta['location_fax'][0];
			$member_data->Toll_Free_Phone = $location_meta['location_phone_toll_free'][0];
			$member_data->Toll_Free_Fax = $location_meta['location_fax_toll_free'][0];
			$member_data->Website = $location_meta['location_website'][0];
			$member_data->Email = $member_meta['member_email'][0];
			$member_data->MemberType = $member_meta['member_type'][0].' Member';
			$member_data->Area = $location_meta['location_area'][0];
			$member_data->Franchise = $location_meta['location_franchise'][0];
			
			$mem_arr[] = $member_data;
		}

		// Loop through $mem_arr, print header_row

		$csv_head = '';
		$i=0;
		foreach($mem_arr[0] as $key=>$val){
			++$i;
			$csv_head.= '"'.str_replace("_", " " , $key).'"';
			$csv_head.= ($i<count( (array) $mem_arr[0])) ? ',' : "\r\n";
		}
		
		foreach($mem_arr as $mem){
			$myvars = get_object_vars($mem);
			$i=0;
			foreach($myvars as $vars){
				$i++;
				$csv_body.= '"'. $vars .'"'; 
				$csv_body.= ($i<count( $myvars)) ? ',' : "\r\n";
			}
		}
		header('Content-type: application/excel');
		header('Content-Disposition: attachment; filename="mmda_member_roster.csv"');
		header('Content-Transfer-Encoding: binary');
		print($csv_head.$csv_body);
		exit;
	}

function create_custom_post_types() {
		register_post_type( 'members',
			array(
				'labels' => array(
				    'name' => _x( 'Members','' ),
				    'singular_name' => _x( 'Member' ,'' ),
				    'add_new' => _x( 'Add New', '' ),
				    'add_new_item' => __( 'Add New Member' ),
					'edit' => __( 'Edit' ),
				    'edit_item' => __( 'Edit Member' ),
				    'new_item' => __( 'New Member' ),
					'view' => __( 'View Member' ),
				    'all_items' => __( 'All Members' ),
				    'view_item' => __( 'View Member' ),
				    'search_items' => __( 'Search Members' ),
				    'not_found' =>  __( 'No Members found' ),
				    'not_found_in_trash' => __( 'No members found in Trash' ),
				),
			    'public' => true,
			    'publicly_queryable' => true,
			    'show_ui' => true, 
			    'show_in_menu' => true, 
			    'query_var' => true,
			    'rewrite' => true,
			    'capability_type' => 'post',
			    'has_archive' => true, 
			    'hierarchical' => false,
			    'menu_position' => null,
			    'supports' => array( 'thumbnail','page-attributes' )
			)
		);

Vintersorg fucked around with this message at 23:25 on Feb 4, 2013

cheese eats mouse fucked around with this message at 17:32 on Feb 5, 2013

add_theme_support( 'post-thumbnails' );
add_image_size( 'feature-slider-image', 650, 300, true);
function bavg_image_sizes_choose( $sizes ) {  
    $custom_sizes = array(  
        'feature-slider-image' => 'Featured Post Slider Panel'  
    );
    return array_merge( $sizes, $custom_sizes );  
}

add_filter( 'image_size_names_choose', 'bavg_image_sizes_choose' );  

putin is a cunt fucked around with this message at 00:34 on Feb 6, 2013

putin is a cunt fucked around with this message at 01:34 on Feb 6, 2013

Maniaman fucked around with this message at 21:24 on Feb 8, 2013