Esempio n. 1
0
function zen_update_salemaker_product_prices($salemaker_id)
{
    global $db;
    $zv_categories = $db->Execute("select sale_categories_selected from " . TABLE_SALEMAKER_SALES . " where sale_id = '" . $salemaker_id . "'");
    $za_salemaker_categories = zen_parse_salemaker_categories($zv_categories->fields['sale_categories_selected']);
    $n = sizeof($za_salemaker_categories);
    for ($i = 0; $i < $n; $i++) {
        $update_products_price = $db->Execute("select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id='" . $za_salemaker_categories[$i] . "'");
        while (!$update_products_price->EOF) {
            zen_update_products_price_sorter($update_products_price->fields['products_id']);
            $update_products_price->MoveNext();
        }
    }
}
Esempio n. 2
0
function zen_update_salemaker_product_prices($salemaker_id)
{
    global $gBitDb;
    $zv_categories = $gBitDb->Execute("SELECT `sale_categories_selected` FROM " . TABLE_SALEMAKER_SALES . " WHERE `sale_id` = '" . $salemaker_id . "'");
    $za_salemaker_categories = zen_parse_salemaker_categories($zv_categories->fields['sale_categories_selected']);
    $n = sizeof($za_salemaker_categories);
    for ($i = 0; $i < $n; $i++) {
        $update_products_price = $gBitDb->Execute("SELECT `products_id` FROM " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE `categories_id`='" . $za_salemaker_categories[$i] . "'");
        while (!$update_products_price->EOF) {
            zen_update_lowest_purchase_price($update_products_price->fields['products_id']);
            $update_products_price->MoveNext();
        }
    }
}