".TXT_WPSC_SELECTAVARIATION."\r\n"; $values = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."product_categories` ORDER BY `id` ASC",ARRAY_A); foreach($values as $option) { if($curent_variation == $option['id']) { $selected = "selected='selected'"; } $options .= "\r\n"; $selected = ""; } $concat .= "\r\n"; return $concat; } function display_variation_row($variation) { // displays the row the variation is on echo " \n\r"; echo " \n\r"; echo "".htmlentities(stripslashes($variation['name']), ENT_QUOTES, 'UTF-8').""; echo " \n\r"; echo " \n\r"; echo "".TXT_WPSC_EDIT.""; echo " \n\r"; echo " \n\r"; } $imagedir = WPSC_FILE_PATH."/variation_images/"; /* delete variation_value */ if($_GET['delete_value'] == 'true') { if(is_numeric($_GET['variation_id']) && is_numeric($_GET['value_id'])) { //exit("DELETE FROM `".$wpdb->prefix."variation_values_associations` WHERE `value_id` = '".$_GET['value_id']."'"); $wpdb->query("DELETE FROM `".$wpdb->prefix."variation_values_associations` WHERE `value_id` = '".$_GET['value_id']."'"); $wpdb->query("DELETE FROM `".$wpdb->prefix."variation_values` WHERE `id` = '".$_GET['value_id']."' AND `variation_id` = '".$_GET['variation_id']."' LIMIT 1"); } } /* add variation */ if($_POST['submit_action'] == "add") { //exit("

".print_r($_POST,true)."

"); $variation_sql = "INSERT INTO `".$wpdb->prefix."product_variations` (`name`, `variation_association`) VALUES ( '".$_POST['name']."', 0);"; if($wpdb->query($variation_sql)) { $variation_id = $wpdb->get_results("SELECT LAST_INSERT_ID() AS `id` FROM `".$wpdb->prefix."product_variations` LIMIT 1",ARRAY_A); $variation_id = $variation_id[0]['id']; $variation_values = $_POST['variation_values']; $variation_value_sql ="INSERT INTO `".$wpdb->prefix."variation_values` ( `name` , `variation_id` ) VALUES "; $num = 0; foreach($variation_values as $variation_value) { switch($num) { case 0: $comma = ''; break; default: $comma = ', '; break; } $variation_value_sql .= "$comma( '".$wpdb->escape(trim($variation_value))."', '".$variation_id."')"; $num++; } $variation_value_sql .= ";"; $wpdb->query($variation_value_sql); echo "

".TXT_WPSC_ITEMHASBEENADDED."

"; } else { echo "

".TXT_WPSC_ITEMHASNOTBEENADDED."

"; } } /* edit variation */ if(($_POST['submit_action'] == "edit") && is_numeric($_POST['prodid'])) { //exit("

".print_r($_POST,true)."

"); $variation_id = $_POST['prodid']; foreach($_POST['variation_values'] as $variation_value_id => $variation_value) { if(is_numeric($variation_value_id)) { $variation_value_state = $wpdb->get_results("SELECT `name` FROM `".$wpdb->prefix."variation_values` WHERE `id` = '$variation_value_id' AND `variation_id` = '$variation_id' LIMIT 1",ARRAY_A); $variation_value_state = $variation_value_state[0]['name']; } if($variation_value_state != $variation_value) { $wpdb->query("UPDATE `".$wpdb->prefix."variation_values` SET `name` = '".$wpdb->escape($variation_value)."' WHERE `id` = '$variation_value_id' AND `variation_id` = '".$variation_id."' LIMIT 1;"); } } $variation_value_sql ="INSERT INTO `".$wpdb->prefix."variation_values` ( `name` , `variation_id` ) VALUES "; $num = 0; if($_POST['new_variation_values'] != null) { $num = 0; foreach($_POST['new_variation_values'] as $variation_value) { switch($num) { case 0: $comma = ''; break; default: $comma = ', '; break; } $variation_value_sql .= "$comma('".$wpdb->escape(trim($variation_value))."', '".$variation_id."')"; $num++; } $variation_value_sql .= ";"; $wpdb->query($variation_value_sql); } $updatesql = "UPDATE `".$wpdb->prefix."product_variations` SET `name` = '".$wpdb->escape($_POST['title'])."' WHERE `id`='".$variation_id."' LIMIT 1"; $wpdb->query($updatesql); echo "

".TXT_WPSC_VARIATIONHASBEENEDITED."

"; } if(is_numeric($_GET['deleteid'])) { $delete_value_assoc_sql = "DELETE FROM `".$wpdb->prefix."variation_values_associations` WHERE `variation_id` = '".$_GET['deleteid']."'"; $delete_variation_assoc_sql = "DELETE FROM `".$wpdb->prefix."variation_associations` WHERE `variation_id` = '".$_GET['deleteid']."'"; $delete_values_sql = "DELETE FROM `".$wpdb->prefix."variation_values` WHERE `variation_id` = '".$_GET['deleteid']."';"; $delete_variation_sql = "DELETE FROM `".$wpdb->prefix."product_variations` WHERE `id`='".$_GET['deleteid']."' LIMIT 1"; $wpdb->query($delete_value_assoc_sql); $wpdb->query($delete_variation_assoc_sql); $wpdb->query($delete_values_sql); $wpdb->query($delete_variation_sql); } ?>

\n\r"; echo " \n\r"; if (IS_WP27) { echo "

"; echo "

".TXT_WPSC_VARIATION_LIST."

"; echo "

"; } else { echo "

\n\r"; echo " ".TXT_WPSC_VARIATION_LIST."\n\r"; echo "

\n\r"; } echo " \n\r"; echo " \n\r"; echo " \n\r"; echo " \n\r"; echo " \n\r"; $variation_sql = "SELECT * FROM `".$wpdb->prefix."product_variations` ORDER BY `id`"; $variation_list = $wpdb->get_results($variation_sql,ARRAY_A); if($variation_list != null) { foreach($variation_list as $variation) { display_variation_row($variation); } } echo "

\n\r"; echo TXT_WPSC_NAME; echo "

\n\r"; echo TXT_WPSC_EDIT; echo "

\n\r"; if (IS_WP27) echo "

"; echo " \n\r"; echo "

"; if (IS_WP27) { echo "

"; echo "

".TXT_WPSC_EDITVARIATION."

"; echo "

"; } else { echo "

\n\r"; echo " ".TXT_WPSC_EDITVARIATION."\n\r"; echo "

\n\r"; } echo ""; echo "

"; if (IS_WP27) { echo "

"; } ?>

"; } echo " \n\r"; echo " \n\r"; ?>