function thickbox_variation() { global $wpdb, $wpsc_siteurl; $variations_processor = new nzshpcrt_variations(); echo "<head>"; echo "<link rel='stylesheet' href='{$wpsc_siteurl}/wp-admin/wp-admin.css?ver=2.6.3' type='text/css' media='all' />\n\t<link rel='stylesheet' href='{$wpsc_siteurl}/wp-admin/css/colors-fresh.css?ver=2.6.3' type='text/css' media='all' />\n\t<link href='{$wpsc_siteurl}/wp-content/plugins/" . WPSC_DIR_NAME . "/admin.css' rel='stylesheet' type='text/css'/>\n\t<link rel='stylesheet' href='{$wpsc_siteurl}/wp-admin/css/global.css?ver=2.6.3' type='text/css' media='all' />"; echo "<script type='text/javascript' src='{$wpsc_siteurl}/wp-includes/js/jquery/jquery.js?ver=1.2.6'></script>"; echo "<script type='text/javascript' src='{$wpsc_siteurl}/wp-includes/js/thickbox/thickbox.js?ver=3.1-20080430'></script>\n\t<script language='JavaScript' type='text/javascript' src='{$wpsc_siteurl}/wp-content/plugins/" . WPSC_DIR_NAME . "/js/jquery.tooltip.js'></script>\n<script type='text/javascript' src='{$wpsc_siteurl}/wp-content/plugins/" . WPSC_DIR_NAME . "/js/jquery-ui.js?ver=1.6'></script>\n<script type='text/javascript' src='{$wpsc_siteurl}/wp-content/plugins/" . WPSC_DIR_NAME . "/js/jquery.jeditable.pack.js?ver=2.7.4'></script>\n<script type='text/javascript' src='{$wpsc_siteurl}/wp-includes/js/swfupload/swfupload.js?ver=2.0.2-20080430'></script>\n"; echo "<script language='JavaScript' type='text/javascript'>\n\t\t\tvar base_url = '" . $wpsc_siteurl . "';\n\t\t\tvar WPSC_URL = '" . WPSC_URL . "';\n\t\t\tvar WPSC_IMAGE_URL = '" . WPSC_IMAGE_URL . "';"; echo "var TXT_WPSC_DELETE = '" . TXT_WPSC_DELETE . "';\n\r"; echo "var TXT_WPSC_TEXT = '" . TXT_WPSC_TEXT . "';\n\r"; echo "var TXT_WPSC_EMAIL = '" . TXT_WPSC_EMAIL . "';\n\r"; echo "var TXT_WPSC_COUNTRY = '" . TXT_WPSC_COUNTRY . "';\n\r"; echo "var TXT_WPSC_TEXTAREA = '" . TXT_WPSC_TEXTAREA . "';\n\r"; echo "var TXT_WPSC_HEADING = '" . TXT_WPSC_HEADING . "';\n\r"; echo "var TXT_WPSC_COUPON = '" . TXT_WPSC_COUPON . "';\n\r"; echo "var HTML_FORM_FIELD_TYPES =\"<option value='text' >" . TXT_WPSC_TEXT . "</option>"; echo "<option value='email' >" . TXT_WPSC_EMAIL . "</option>"; echo "<option value='address' >" . TXT_WPSC_ADDRESS . "</option>"; echo "<option value='city' >" . TXT_WPSC_CITY . "</option>"; echo "<option value='country'>" . TXT_WPSC_COUNTRY . "</option>"; echo "<option value='delivery_address' >" . TXT_WPSC_DELIVERY_ADDRESS . "</option>"; echo "<option value='delivery_city' >" . TXT_WPSC_DELIVERY_CITY . "</option>"; echo "<option value='delivery_country'>" . TXT_WPSC_DELIVERY_COUNTRY . "</option>"; echo "<option value='textarea' >" . TXT_WPSC_TEXTAREA . "</option>"; echo "<option value='heading' >" . TXT_WPSC_HEADING . "</option>"; echo "<option value='coupon' >" . TXT_WPSC_COUPON . "</option>\";\n\r"; echo "</script>"; echo "<script language='JavaScript' type='text/javascript' src='" . WPSC_URL . "/wpsc_admin/js/jquery.livequery.js'></script>"; echo "<script language='JavaScript' type='text/javascript' src='" . WPSC_URL . "/wpsc_admin/js/admin.js'></script>"; echo "<script language='JavaScript' type='text/javascript' src='" . WPSC_URL . "/wpsc_admin/js/variations.js'></script>"; echo "</head>"; if ($_POST) { if ($_POST['submit_action'] == "add") { //exit("<pre>".print_r($_POST,true)."</pre>"); $variation_sql = "INSERT INTO `" . WPSC_TABLE_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 `" . WPSC_TABLE_PRODUCT_VARIATIONS . "` LIMIT 1", ARRAY_A); $variation_id = $variation_id[0]['id']; $variation_values = $_POST['variation_values']; $variation_value_sql = "INSERT INTO `" . WPSC_TABLE_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 "<head>"; echo "\n\t\t<script language='JavaScript' type='text/javascript' src='" . WPSC_URL . "/admin.js'></script>\n\t\t<script language='JavaScript' type='text/javascript'>\n\t\t\t\tparent.jQuery('#add_product_variations').html(\"" . nl2br($variations_processor->list_variations()) . "\");\n\t\t\t\tparent.tb_remove();\n\t\t</script>"; echo "</head>"; echo "<div class='updated'><p align='center'>" . TXT_WPSC_ITEMHASBEENADDED . "</p></div>"; } else { echo "<div class='updated'><p align='center'>" . TXT_WPSC_ITEMHASNOTBEENADDED . "</p></div>"; } } } echo " <table id='productpage'>\n\r"; echo " <tr>"; echo " <td class='secondcol'>\n\r"; echo " <div id='productform'>"; echo " <div class='categorisation_title'>\n\r"; echo "\t\t<strong class='form_group'>" . TXT_WPSC_EDITVARIATION . "</strong>\n\r"; echo "\t</div>\n\r"; echo "<form method='POST' enctype='multipart/form-data' name='editproduct{$num}'>"; echo " <div id='formcontent'>\n\r"; echo " </div>\n\r"; echo "</form>"; echo " </div>"; ?> <div id='additem'> <div class="categorisation_title"> <strong class="form_group"><?php echo TXT_WPSC_ADDVARIATION; ?> </strong> </div> <form method='POST' action='admin.php?thickbox_variations=true&width=550'> <table class='category_forms'> <tr> <td> <?php echo TXT_WPSC_NAME; ?> : </td> <td> <input type='text' class="text" name='name' value='<?php echo $variation_name; ?> ' /> </td> </tr> <tr> <td> <?php echo TXT_WPSC_VARIATION_VALUES; ?> : </td> <td> <div id='variation_values'> <?php if ($variation_value_count > 0) { $num = 0; foreach ($variation_values as $variation_value) { ?> <div class='variation_value'> <input type='text' class='text' name='variation_values[<?php echo $variation_value['id']; ?> ]' value='<?php echo htmlentities(stripslashes($variation_value['name']), ENT_QUOTES, 'UTF-8'); ?> ' /> <input type='hidden' class='variation_values_id' name='variation_values_id[]' value='<?php echo $variation_value['id']; ?> ' /> <?php if ($variation_value_count > 1) { ?> <a class='image_link delete_variation_value' href='#'> <img src='<?php echo WPSC_URL; ?> /images/trash.gif' alt='<?php echo TXT_WPSC_DELETE; ?> ' title='<?php echo TXT_WPSC_DELETE; ?> ' /> </a> <?php } ?> </div> <?php $num++; } } else { for ($i = 0; $i <= $value_form_count; $i++) { ?> <div class='variation_value'> <input type='text' class="text" name='new_variation_values[]' value='' /> <a class='image_link delete_variation_value' href='#'> <img src='<?php echo WPSC_URL; ?> /images/trash.gif' alt='<?php echo TXT_WPSC_DELETE; ?> ' title='<?php echo TXT_WPSC_DELETE; ?> ' /> </a> </div> <?php } } ?> </div> <a href='#' class='add_variation_item_form'>+ <?php _e('Add Value'); ?> </a> </td> </tr> <tr> <td> </td> <td> <?php wp_nonce_field('edit-variation', 'wpsc-edit-variation'); ?> <input type='hidden' name='wpsc_admin_action' value='wpsc-variation-set' /> <?php if ($variation_id > 0) { ?> <input type='hidden' name='variation_id' value='<?php echo $variation_id; ?> ' /> <input type='hidden' name='submit_action' value='edit' /> <input class='button' style='float:left;' type='submit' name='submit' value='<?php echo TXT_WPSC_EDIT; ?> ' /> <a class='button delete_button' href='<?php echo wp_nonce_url("admin.php?wpsc_admin_action=wpsc-delete-variation-set&deleteid={$variation_id}", 'delete-variation'); ?> ' onclick="return conf();" ><?php echo TXT_WPSC_DELETE; ?> </a> <?php } else { ?> <input type='hidden' name='submit_action' value='add' /> <input class='button' type='submit' name='submit' value='<?php echo TXT_WPSC_ADD; ?> ' /> <?php } ?> </td> </tr> </table> </form> </div> <?php echo " </td></tr>\n\r"; echo " </table>\n\r"; exit; }