Example #1
0
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 '&nbsp;' . $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') . '&nbsp;' . 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') . '&nbsp;' . 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']) . '&nbsp;' . 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));
Example #4
0
 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>