function vam_remove_product($product_id) { // get content of product $product_content_query = vam_db_query("SELECT content_file FROM " . TABLE_PRODUCTS_CONTENT . " WHERE products_id = '" . vam_db_input($product_id) . "'"); // check if used elsewhere, delete db-entry + file if not while ($product_content = vam_db_fetch_array($product_content_query)) { $duplicate_content_query = vam_db_query("SELECT count(*) AS total FROM " . TABLE_PRODUCTS_CONTENT . " WHERE content_file = '" . vam_db_input($product_content['content_file']) . "' AND products_id != '" . vam_db_input($product_id) . "'"); $duplicate_content = vam_db_fetch_array($duplicate_content_query); if ($duplicate_content['total'] == 0) { @unlink(DIR_FS_DOCUMENT_ROOT . 'media/products/' . $product_content['content_file']); } //delete DB-Entry vam_db_query("DELETE FROM " . TABLE_PRODUCTS_CONTENT . " WHERE products_id = '" . vam_db_input($product_id) . "' AND (content_file = '" . $product_content['content_file'] . "' OR content_file = '')"); } $product_image_query = vam_db_query("SELECT products_image FROM " . TABLE_PRODUCTS . " WHERE products_id = '" . vam_db_input($product_id) . "'"); $product_image = vam_db_fetch_array($product_image_query); $duplicate_image_query = vam_db_query("SELECT count(*) AS total FROM " . TABLE_PRODUCTS . " WHERE products_image = '" . vam_db_input($product_image['products_image']) . "'"); $duplicate_image = vam_db_fetch_array($duplicate_image_query); if ($duplicate_image['total'] < 2) { vam_del_image_file($product_image['products_image']); } //delete more images $mo_images_query = vam_db_query("SELECT image_name FROM " . TABLE_PRODUCTS_IMAGES . " WHERE products_id = '" . vam_db_input($product_id) . "'"); while ($mo_images_values = vam_db_fetch_array($mo_images_query)) { $duplicate_more_image_query = vam_db_query("SELECT count(*) AS total FROM " . TABLE_PRODUCTS_IMAGES . " WHERE image_name = '" . $mo_images_values['image_name'] . "'"); $duplicate_more_image = vam_db_fetch_array($duplicate_more_image_query); if ($duplicate_more_image['total'] < 2) { vam_del_image_file($mo_images_values['image_name']); } } vam_db_query("DELETE FROM " . TABLE_SPECIALS . " WHERE products_id = '" . vam_db_input($product_id) . "'"); vam_db_query("DELETE FROM " . TABLE_PRODUCTS . " WHERE products_id = '" . vam_db_input($product_id) . "'"); vam_db_query("DELETE FROM " . TABLE_PRODUCTS_IMAGES . " WHERE products_id = '" . vam_db_input($product_id) . "'"); vam_db_query("DELETE FROM " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE products_id = '" . vam_db_input($product_id) . "'"); vam_db_query("DELETE FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . vam_db_input($product_id) . "'"); vam_db_query("DELETE FROM " . TABLE_PRODUCTS_ATTRIBUTES . " WHERE products_id = '" . vam_db_input($product_id) . "'"); vam_db_query("DELETE FROM " . TABLE_CUSTOMERS_BASKET . " WHERE products_id = '" . vam_db_input($product_id) . "'"); vam_db_query("DELETE FROM " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " WHERE products_id = '" . vam_db_input($product_id) . "'"); $customers_status_array = vam_get_customers_statuses(); for ($i = 0, $n = sizeof($customers_status_array); $i < $n; $i++) { if (isset($customers_statuses_array[$i]['id'])) { vam_db_query("delete from " . TABLE_PERSONAL_OFFERS . $customers_statuses_array[$i]['id'] . " where products_id = '" . vam_db_input($product_id) . "'"); } } $product_reviews_query = vam_db_query("select reviews_id from " . TABLE_REVIEWS . " where products_id = '" . vam_db_input($product_id) . "'"); while ($product_reviews = vam_db_fetch_array($product_reviews_query)) { vam_db_query("delete from " . TABLE_REVIEWS_DESCRIPTION . " where reviews_id = '" . $product_reviews['reviews_id'] . "'"); } vam_db_query("delete from " . TABLE_REVIEWS . " where products_id = '" . vam_db_input($product_id) . "'"); if (USE_CACHE == 'true') { vam_reset_cache_block('categories'); vam_reset_cache_block('also_purchased'); } }
"> <br><?php echo ' ' . $cInfo->categories_image; echo vam_draw_selection_field('del_cat_pic', 'checkbox', 'yes') . TEXT_DELETE; } ?> </td> </tr> </table> </div> <!-- images --> <?php if (GROUP_CHECK == 'true') { $customers_statuses_array = vam_get_customers_statuses(); $customers_statuses_array = array_merge(array(array('id' => 'all', 'text' => TXT_ALL)), $customers_statuses_array); ?> <div id="groups"> <table border="0"> <tr> <td class="main" width="200" valign="top"> <?php for ($i = 0; $n = sizeof($customers_statuses_array), $i < $n; $i++) { if ($category['group_permission_' . $customers_statuses_array[$i]['id']] == 1) { $checked = 'checked '; } else { $checked = ''; } echo '<input type="checkbox" name="groups[]" value="' . $customers_statuses_array[$i]['id'] . '"' . $checked . '> ' . $customers_statuses_array[$i]['text'] . '<br />';
$contents[] = array('text' => '<br />' . TEXT_INFO_CUSTOMERS_STATUS_DISCOUNT_OT_XMEMBER_INTRO . '<br /> ' . ENTRY_OT_XMEMBER . ' ' . vam_draw_pull_down_menu('customers_status_ot_discount_flag', $customers_status_ot_discount_flag_array, $cInfo->customers_status_ot_discount_flag) . '<br />' . TEXT_INFO_CUSTOMERS_STATUS_DISCOUNT_PRICE . '<br />' . vam_draw_input_field('customers_status_ot_discount', $cInfo->customers_status_ot_discount)); $contents[] = array('text' => '<br />' . TEXT_INFO_CUSTOMERS_STATUS_GRADUATED_PRICES_INTRO . '<br />' . ENTRY_GRADUATED_PRICES . ' ' . vam_draw_pull_down_menu('customers_status_graduated_prices', $customers_status_graduated_prices_array, $cInfo->customers_status_graduated_prices)); $contents[] = array('text' => '<br />' . TEXT_INFO_CUSTOMERS_STATUS_DISCOUNT_ATTRIBUTES_INTRO . '<br />' . ENTRY_CUSTOMERS_STATUS_DISCOUNT_ATTRIBUTES . ' ' . vam_draw_pull_down_menu('customers_status_discount_attributes', $customers_status_discount_attributes_array, $cInfo->customers_status_discount_attributes)); $contents[] = array('text' => '<br />' . TEXT_INFO_CUSTOMERS_STATUS_PAYMENT_UNALLOWED_INTRO . '<br />' . ENTRY_CUSTOMERS_STATUS_PAYMENT_UNALLOWED . ' ' . vam_draw_input_field('customers_status_payment_unallowed', $cInfo->customers_status_payment_unallowed)); $contents[] = array('text' => '<br />' . TEXT_INFO_CUSTOMERS_STATUS_SHIPPING_UNALLOWED_INTRO . '<br />' . ENTRY_CUSTOMERS_STATUS_SHIPPING_UNALLOWED . ' ' . vam_draw_input_field('customers_status_shipping_unallowed', $cInfo->customers_status_shipping_unallowed)); $contents[] = array('text' => '<br />' . TEXT_INFO_CUSTOMERS_FSK18_INTRO . '<br />' . ENTRY_CUSTOMERS_FSK18 . ' ' . vam_draw_pull_down_menu('customers_fsk18', $customers_fsk18_array, $cInfo->customers_fsk18)); $contents[] = array('text' => '<br />' . TEXT_INFO_CUSTOMERS_FSK18_DISPLAY_INTRO . '<br />' . ENTRY_CUSTOMERS_FSK18_DISPLAY . ' ' . vam_draw_pull_down_menu('customers_fsk18_display', $customers_fsk18_display_array, $cInfo->customers_fsk18_display)); $contents[] = array('text' => '<br />' . TEXT_INFO_CUSTOMERS_STATUS_WRITE_REVIEWS_INTRO . '<br />' . ENTRY_CUSTOMERS_STATUS_WRITE_REVIEWS . ' ' . vam_draw_pull_down_menu('customers_status_write_reviews', $customers_status_write_reviews_array, $cInfo->customers_status_write_reviews)); $contents[] = array('text' => '<br />' . TEXT_INFO_CUSTOMERS_STATUS_READ_REVIEWS_INTRO . '<br />' . ENTRY_CUSTOMERS_STATUS_READ_REVIEWS_DISPLAY . ' ' . vam_draw_pull_down_menu('customers_status_read_reviews', $customers_status_read_reviews_array, $cInfo->customers_status_read_reviews)); $contents[] = array('text' => '<br />' . TEXT_INFO_CUSTOMERS_STATUS_ACCUMULATED_LIMIT_INTRO . '<br />' . ENTRY_CUSTOMERS_STATUS_ACCUMULATED_LIMIT_DISPLAY . ' ' . vam_draw_input_field('customers_status_accumulated_limit', $cInfo->customers_status_accumulated_limit)); $contents[] = array('text' => '<br />' . TEXT_INFO_CUSTOMERS_STATUS_ORDERS_STATUS_INTRO . '<br />' . TEXT_INFO_CUSTOMERS_STATUS_ORDERS_STATUS_DISPLAY); $orders_status_query = vam_db_query("select * from " . TABLE_ORDERS_STATUS . " where language_id = " . $_SESSION['languages_id'] . " order by orders_status_id"); while ($orders_status = vam_db_fetch_array($orders_status_query)) { $contents[] = array('text' => '<input type="checkbox" name="orders_status_' . $orders_status['orders_status_id'] . '" value="1">' . $orders_status['orders_status_name'] . '<br />'); } $contents[] = array('text' => '<br />' . TEXT_INFO_CUSTOMERS_STATUS_BASE . '<br />' . ENTRY_CUSTOMERS_STATUS_BASE . '<br />' . vam_draw_pull_down_menu('customers_base_status', vam_get_customers_statuses())); $contents[] = array('text' => '<br />' . vam_draw_checkbox_field('default') . ' ' . TEXT_SET_DEFAULT); $contents[] = array('align' => 'center', 'text' => '<br /><span class="button"><button type="submit" value="' . BUTTON_INSERT . '">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/submit.png', '', '12', '12') . ' ' . BUTTON_INSERT . '</button></span> <a class="button" href="' . vam_href_link(FILENAME_CUSTOMERS_STATUS, 'page=' . $_GET['page']) . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/cancel.png', '', '12', '12') . ' ' . BUTTON_CANCEL . '</span></a>'); break; case 'edit': $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_EDIT_CUSTOMERS_STATUS . '</b>'); $contents = array('form' => vam_draw_form('status', FILENAME_CUSTOMERS_STATUS, 'page=' . $_GET['page'] . '&cID=' . $cInfo->customers_status_id . '&action=save', 'post', 'enctype="multipart/form-data"')); $contents[] = array('text' => TEXT_INFO_EDIT_INTRO); $customers_status_inputs_string = ''; $languages = vam_get_languages(); for ($i = 0; $i < sizeof($languages); $i++) { $customers_status_inputs_string .= '<br />' . vam_image(DIR_WS_CATALOG . 'lang/' . $languages[$i]['directory'] . '/admin/images/' . $languages[$i]['image'], $languages[$i]['name']) . ' ' . vam_draw_input_field('customers_status_name[' . $languages[$i]['id'] . ']', vam_get_customers_status_name($cInfo->customers_status_id, $languages[$i]['id'])); } $contents[] = array('text' => '<br />' . TEXT_INFO_CUSTOMERS_STATUS_NAME . $customers_status_inputs_string); $contents[] = array('text' => '<br />' . vam_image(DIR_WS_ICONS . $cInfo->customers_status_image, $cInfo->customers_status_name) . '<br />' . DIR_WS_ICONS . '<br /><b>' . $cInfo->customers_status_image . '</b>'); $contents[] = array('text' => '<br />' . TEXT_INFO_CUSTOMERS_STATUS_IMAGE . '<br />' . vam_draw_file_field('customers_status_image', $cInfo->customers_status_image));
function vamExport($filename) { $this->catDepth = 6; $this->languages = $this->get_lang(); $this->filename = $filename; $this->CAT = array(); $this->PARENT = array(); $this->counter = array('prod_exp' => 0); $this->time_start = time(); $this->man = $this->getManufacturers(); $this->TextSign = CSV_TEXTSIGN; $this->seperator = CSV_SEPERATOR; if (CSV_SEPERATOR == '') { $this->seperator = "\t"; } if (CSV_SEPERATOR == '\\t') { $this->seperator = "\t"; } $this->Groups = vam_get_customers_statuses(); }
<?php } } ?> </table> <?php break; // end default page // end default page case 'edit': $newsletters_query = vam_db_query("SELECT title,body,cc,bc FROM " . TABLE_MODULE_NEWSLETTER . " WHERE newsletter_id='" . (int) $_GET['ID'] . "'"); $newsletters_data = vam_db_fetch_array($newsletters_query); case 'safe': case 'new': // action for NEW newsletter! $customers_status = vam_get_customers_statuses(); echo vam_draw_form('edit_newsletter', FILENAME_MODULE_NEWSLETTER, 'action=save', 'post', 'enctype="multipart/form-data"') . vam_draw_hidden_field('ID', $_GET['ID']); ?> <br /><br /> <table class="main" width="100%" border="0"> </tr> <tr> <td width="10%"><?php echo TEXT_TITLE; ?> </td> <td width="90%"><?php echo vam_draw_input_field('title', $newsletters_data['title'], 'size=100'); ?> </td> </tr>