" . __( 'Please select', 'wpsc' ) . ""; $country_data = $wpdb->get_results( "SELECT * FROM `" . WPSC_TABLE_CURRENCY_LIST . "` ORDER BY `country` ASC", ARRAY_A ); foreach ( $country_data as $country ) { $selected = ''; if ( $selected_country == $country['isocode'] ) $selected = "selected='selected'"; $output .= ""; } return $output; } function nzshpcrt_region_list( $selected_country = null, $selected_region = null ) { global $wpdb; if ( $selected_region == null ) $selected_region = get_option( 'base_region' ); $output = ""; $region_list = $wpdb->get_results( "SELECT `" . WPSC_TABLE_REGION_TAX . "`.* FROM `" . WPSC_TABLE_REGION_TAX . "`, `" . WPSC_TABLE_CURRENCY_LIST . "` WHERE `" . WPSC_TABLE_CURRENCY_LIST . "`.`isocode` IN('" . $selected_country . "') AND `" . WPSC_TABLE_CURRENCY_LIST . "`.`id` = `" . WPSC_TABLE_REGION_TAX . "`.`country_id`", ARRAY_A ); if ( $region_list != null ) { $output .= ""; foreach ( $region_list as $region ) { if ( $selected_region == $region['id'] ) { $selected = "selected='selected'"; } else { $selected = ""; } $output .= "\r\n"; } } else { $output .= "\r\n"; } return $output; } function nzshpcrt_form_field_list( $selected_field = null ) { global $wpdb; $output = ""; $form_sql = "SELECT * FROM `" . WPSC_TABLE_CHECKOUT_FORMS . "` WHERE `active` = '1';"; $form_data = $wpdb->get_results( $form_sql, ARRAY_A ); foreach ( (array)$form_data as $form ) { $selected = ''; if ( $selected_field == $form['id'] ) { $selected = "selected='selected'"; } $output .= ""; } return $output; } function wpsc_parent_category_list( $taxonomies, $args, $parent, $current_term_id ) { $myterms = get_terms( $taxonomies, $args ); $output = ""; return $output; } /* * Displays the category forms for adding and editing products * Recurses to generate the branched view for subcategories */ function wpsc_category_options( $group_id, $this_category = null, $category_id = null, $iteration = 0, $selected_id = null ) { global $wpdb; $siteurl = get_option( 'siteurl' ); $selected_term = get_term($selected_id,'wpsc_product_category'); $values = get_terms( 'wpsc_product_category', 'hide_empty=0&parent=' . $group_id ); $selected = ""; $output = ""; foreach ( (array)$values as $option ) { if ( $option->term_id != $this_category ) { if ( isset($selected_term->parent) && $selected_term->parent == $option->term_id ) { $selected = "selected='selected'"; } $output .= "\r\n"; $output .= wpsc_category_options( $option->term_id, $this_category, $option->term_id, $iteration + 1, $selected_id ); $selected = ""; } } return $output; } /* * TODO: If the uploads directory of wordpress doesn't have the right permissions there * is a memory exhausting problem in this function. */ function wpsc_uploaded_files() { global $wpdb, $wpsc_uploaded_file_cache; $dir = @opendir( WPSC_FILE_DIR ); $num = 0; $dirlist = array( ); if ( count( $wpsc_uploaded_file_cache ) > 0 ) { $dirlist = $wpsc_uploaded_file_cache; } elseif ( $dir ) { while ( ($file = @readdir( $dir )) !== false ) { //filter out the dots, macintosh hidden files and any backup files if ( ($file != "..") && ($file != ".") && ($file != "product_files") && ($file != "preview_clips") && !stristr( $file, "~" ) && !( strpos( $file, "." ) === 0 ) && !strpos( $file, ".old" ) ) { $file_data = null; $args = array( 'post_type' => 'wpsc-product-file', 'post_name' => $file, 'numberposts' => 1, 'post_status' => 'all' ); //// @TODO broken, does not select by post_name, need to loop at wordpress API to fix. //$file_data = (array)get_posts($args); if ( $file_data[0] != null ) { $dirlist[$num]['display_filename'] = $file_data[0]->post_title; $dirlist[$num]['file_id'] = $file_data[0]->ID; } else { $dirlist[$num]['display_filename'] = $file; $dirlist[$num]['file_id'] = null; } $dirlist[$num]['real_filename'] = $file; $num++; } } if ( count( $dirlist ) > 0 ) { $wpsc_uploaded_file_cache = $dirlist; } } $dirlist = apply_filters( 'wpsc_downloadable_file_list', $dirlist ); return $dirlist; } // JS - For 3.8, function re-worked to only show files attached to product, separate thickbox with all products, to be associated with product. function wpsc_select_product_file( $product_id = null ) { global $wpdb; $product_id = absint( $product_id ); $file_list = wpsc_uploaded_files(); $args = array( 'post_type' => 'wpsc-product-file', 'post_parent' => $product_id, 'numberposts' => -1, 'post_status' => 'all' ); $attached_files = (array)get_posts( $args ); $output = "" . __( 'File(s) attached: ', 'wpsc' ) . "
"; $output .= "
"; $num = 0; foreach ( (array)$attached_files as $file ) { $num++; $deletion_url = wp_nonce_url( "admin.php?wpsc_admin_action=delete_file&file_name={$file->post_title}&product_id={$product_id}&row_number={$num}", 'delete_file_' . $file->post_title ); $output .= "

0) ? '' : "class='alt'") . " id='select_product_file_row_$num'>\n"; $output .= " \n"; $output .= " \n"; $output .= " \n"; $output .= " \n"; $output .= "

\n"; } $no_file_style = empty( $attached_files ) ? '' : ' style="display:none;"'; $output .= "

" . __( 'There are no files attached to this product. Upload a new file or select from other product files.', 'wpsc' ) . "

"; $output .= "
"; $output .= "
"; $output .= ""; return $output; } function wpsc_select_variation_file( $file_id, $variation_ids, $variation_combination_id = null ) { global $wpdb; $file_list = wpsc_uploaded_files(); $unique_id_component = ((int)$variation_combination_id) . "_" . str_replace( ",", "_", $variation_ids ); $output = "
\r\n"; $output .= "" . __( 'Choose a downloadable file for this variation', 'wpsc' ) . "\r\n"; $output .= "
\r\n"; $num = 0; $output .= "

\r\n"; $output .= " \r\n"; $output .= " \r\n"; $output .= "

\r\n"; foreach ( (array)$file_list as $file ) { $num++; $output .= "

\r\n"; $output .= " \r\n"; $output .= " \r\n"; $output .= "

\r\n"; } $output .= "
\r\n"; $output .= "
\r\n"; return $output; } function wpsc_list_product_themes( $theme_name = null ) { global $wpdb; if ( !$selected_theme = get_option( 'wpsc_selected_theme' ) ) $selected_theme = 'default'; $theme_list = wpsc_list_dir( $theme_path ); foreach ( $theme_list as $theme_file ) { if ( is_dir( WPSC_CORE_THEME_PATH . $theme_file ) && is_file( WPSC_CORE_THEME_PATH . $theme_file . "/" . $theme_file . ".css" ) ) { $theme[$theme_file] = get_theme_data( WPSC_CORE_THEME_PATH . $theme_file . "/" . $theme_file . ".css" ); } } $output .= "\r\n"; return $output; } ?>