get_results("SELECT * FROM `".$wpdb->prefix."product_categories` WHERE `group_id` IN ('$group_id') AND `active`='1' AND `category_parent` = '$category_id' ORDER BY `id` ASC",ARRAY_A); } else { $values = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."product_categories` WHERE `group_id` IN ('$group_id') AND `active`='1' AND `category_parent` = '0' ORDER BY `id` ASC",ARRAY_A); } foreach((array)$values as $option) { if(is_numeric($product_id) && ($product_id > 0)) { $category_assoc = $wpdb->get_row("SELECT * FROM `".$wpdb->prefix."item_category_associations` WHERE `product_id` IN('".$product_id."') AND `category_id` IN('".$option['id']."') LIMIT 1",ARRAY_A); //echo "
".print_r($category_assoc,true)."
"; if(is_numeric($category_assoc['id']) && ($category_assoc['id'] > 0)) { $selected = "checked='true'"; } } if(is_numeric($category_id) && ($iteration > 0)) { if($iteration > 1) { if($iteration > 3) { $output .= str_repeat(" ", $iteration); } $output .= str_repeat(" ", $iteration); } $output .= "- "; } $output .= "
"; $output .= categorylist($group_id, $product_id, $unique_id, $option['id'], $iteration+1); $selected = ""; } return $output; } function nzshpcrt_country_list($selected_country = null) { global $wpdb; $output = ""; if($selected_country == null) { $output = ""; } $country_data = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."currency_list` ORDER BY `country` ASC",ARRAY_A); foreach ($country_data as $country) { $selected =''; if($selected_country == $country['isocode']) { $selected = "selected='true'"; } $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 `".$wpdb->prefix."region_tax`.* FROM `".$wpdb->prefix."region_tax`, `".$wpdb->prefix."currency_list` WHERE `".$wpdb->prefix."currency_list`.`isocode` IN('".$selected_country."') AND `".$wpdb->prefix."currency_list`.`id` = `".$wpdb->prefix."region_tax`.`country_id`",ARRAY_A) ; if($region_list != null) { $output .= "\n\r"; } else { $output .= "\n\r"; } return $output; } function nzshpcrt_form_field_list($selected_field = null) { global $wpdb; $output = ""; $output .= ""; $form_sql = "SELECT * FROM `".$wpdb->prefix."collect_data_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='true'"; } $output .= ""; } return $output; } function wpsc_parent_category_list($group_id, $category_id, $category_parent_id) { global $wpdb,$category_data; $options = ""; $options .= "\r\n"; $options .= wpsc_category_options((int)$group_id, (int)$category_id, null, 0, (int)$category_parent_id); $concat .= "\r\n"; return $concat; } function wpsc_category_options($group_id, $this_category = null, $category_id = null, $iteration = 0, $selected_id = null) { /* * Displays the category forms for adding and editing products * Recurses to generate the branched view for subcategories */ global $wpdb; $siteurl = get_option('siteurl'); if(is_numeric($category_id)) { $values = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."product_categories` WHERE `group_id` = '$group_id' AND `active`='1' AND `id` != '$this_category' AND `category_parent` = '$category_id' ORDER BY `id` ASC",ARRAY_A); } else { $values = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."product_categories` WHERE `group_id` = '$group_id' AND `active`='1' AND `id` != '$this_category' AND `category_parent` = '0' ORDER BY `id` ASC",ARRAY_A); } foreach((array)$values as $option) { if($selected_id == $option['id']) { $selected = "selected='selected'"; } $output .= "\r\n"; $output .= wpsc_category_options($group_id, $this_category, $option['id'], $iteration+1, $selected_id); $selected = ""; } return $output; } function wpsc_uploaded_files() { global $wpdb; /* $product_files = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}product_list", ARRAY_A); foreach($product_files as $product_file){ $filelist[] = $product_file['file']; } $filelist = implode(',', $filelist); $files = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}product_files WHERE id IN ($filelist)", ARRAY_A); $num = 0; foreach ($files as $file_data) { if ($file_data != null){ $dirlist[$num]['display_filename'] = $file_data['filename']; $dirlist[$num]['file_id'] = $file_data['id']; $dirlist[$num]['real_filename'] = $file_data['idhash']; } $num++; } */ $dir = @opendir(WPSC_FILE_DIR); $num = 0; 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 = $wpdb->get_row("SELECT `id`,`filename` FROM `".$wpdb->prefix."product_files` WHERE `idhash` LIKE '".$file."' LIMIT 1",ARRAY_A); if($file_data != null) { $dirlist[$num]['display_filename'] = $file_data['filename']; $dirlist[$num]['file_id'] = $file_data['id']; } else { $dirlist[$num]['display_filename'] = $file; $dirlist[$num]['file_id'] = null; } $dirlist[$num]['real_filename'] = $file; $num++; } } return $dirlist; } function wpsc_select_product_file($product_id = null) { global $wpdb; //return false; $file_list = wpsc_uploaded_files(); $file_id = $wpdb->get_var("SELECT `file` FROM `".$wpdb->prefix."product_list` WHERE `id` = '".$product_id."' LIMIT 1"); $output = "".TXT_WPSC_CHOOSE_DOWNLOADABLE_PRODUCT.""; $output .= "
"; //$output .= "
"; $num = 0; $output .= "

0) ? '' : "class='alt'").">

"; //$output .= "
".print_r($file_list,true)."
"; foreach((array)$file_list as $file) { $num++; $output .= "

0) ? '' : "class='alt'").">

"; } $output .= "
"; $output .= "
"; $output .= ""; return $output; } function wpsc_select_variation_file($variation_ids, $variation_combination_id = null) { global $wpdb; //return false; $file_list = wpsc_uploaded_files(); $file_id = 0; if((int)$variation_combination_id > 0) { $file_id = $wpdb->get_var("SELECT `file` FROM `{$wpdb->prefix}variation_priceandstock` WHERE `id` = '".(int)$variation_combination_id."' LIMIT 1"); } else { $variation_combination_id = 0; } $unique_id_component = $variation_combination_id."_".str_replace(",","_",$variation_ids); $output = "
\n\r"; $output .= "".TXT_WPSC_CHOOSE_DOWNLOADABLE_VARIATIONS."\n\r"; $output .= "
\n\r"; $num = 0; $output .= "

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

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

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

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