function cw_gb_get_category_value($category_id, $default_value) { global $tables; if (empty($category_id)) { return empty($default_value) ? FALSE : $default_value; } $attr_val_id = cw_query_first_cell("SELECT av.value\n\t\t FROM {$tables['attributes_values']} av, {$tables['attributes']} a\n\t\t WHERE av.item_id={$category_id}\n\t\t \tAND av.item_type='C'\n\t\t \tAND a.attribute_id=av.attribute_id\n\t\t \tAND a.field='g:google_product_category'"); if (empty($attr_val_id)) { // Get parent categories $parent_categories = array(); cw_category_generate_path($category_id, $parent_categories); if (count($parent_categories)) { foreach ($parent_categories as $parent_category_id) { $attr_val_id = cw_query_first_cell("SELECT av.value\n\t\t FROM {$tables['attributes_values']} av, {$tables['attributes']} a\n\t\t WHERE av.item_id={$parent_category_id}\n\t\t \tAND av.item_type='C'\n\t\t \tAND a.attribute_id=av.attribute_id\n\t\t \tAND a.field='g:google_product_category'"); if (!empty($attr_val_id)) { break; } } } } if ($attr_val_id) { $attr_val = cw_query_first_cell("SELECT value FROM {$tables['attributes_default']} WHERE attribute_value_id = " . $attr_val_id); if (empty($attr_val)) { return empty($default_value) ? FALSE : $default_value; } return $attr_val; } return empty($default_value) ? FALSE : $default_value; }
function cw_config_update($category, $options) { global $tables; $config_category_id = cw_query_first_cell("SELECT config_category_id FROM {$tables['config_categories']} WHERE category='{$category}'"); $var_properties = cw_query_hash("SELECT name, type FROM {$tables['config']} WHERE config_category_id='{$config_category_id}'", "name", false, true); $section_data = array(); foreach ($options as $key => $val) { if (isset($var_properties[$key])) { if ($var_properties[$key] == "numeric") { $val = doubleval(cw_convert_numeric($val)); } elseif ($var_properties[$key] == "textarea") { $val = strtr($val, array("\r" => '')); } elseif ($var_properties[$key] == "multiselector") { $val = implode(";", $val); } elseif ($var_properties[$key] == "checkbox") { $val = in_array($val, array('on', '1', 'Y')) ? 'Y' : 'N'; } elseif (in_array($var_properties[$key], array('shipping', 'memberships', 'doc_status'))) { $ret = array(); if (is_array($val)) { foreach ($val as $k => $v) { $ret[$v] = 1; } } $val = serialize($ret); } cw_array2update("config", array("value" => $val), "name='" . $key . "' AND config_category_id='" . $config_category_id . "'"); $section_data[stripslashes($key)] = stripslashes($val); } } }
function cw_barcode_print_doc($doc_id, $options) { global $tables, $user_account; $layout = cw_web_get_layout_by_id($options['template_id']); $doc = cw_doc_get($doc_id); $amount = $options['amount']; if (!$amount) { $amount = 1; } foreach ($doc['products'] as $product) { if (in_array($doc['type'], array('P', 'R', 'Q'))) { $product['supplier_code'] = $product['productcode']; } else { $product['supplier_code'] = cw_query_first_cell("select productcode from {$tables['products_supplied_amount']} where product_id='{$product_id}' order by date limit 1"); } if ($layout['data']['use_tax']) { $taxes = $product['extra_data']['taxes']; cw_get_products_taxes($product, $user_account, false, $taxes, true); $_tmp_price = $product['price']; $product['price'] = $product['list_price']; cw_get_products_taxes($product, $user_account, false, $taxes, true); $product['list_price'] = $product['display_price']; $product['price'] = $_tmp_price; } else { $product['display_price'] = $product['price']; } for ($i = 0; $i < $product['amount'] * $amount; $i++) { $products[] = $product; } } cw_barcode_print($products, $layout, $options, 0); }
function cw_serials_delete($customer_id, $product_id, $serial) { global $tables; $count = cw_query_first_cell("select count(*) from {$tables['serial_numbers']} where sn='{$serial}' and product_id='{$product_id}' and doc_id=0" . ($customer_id ? " and warehouse_customer_id='{$customer_id}'" : "")); if ($count) { db_query("delete from {$tables['serial_numbers']} where sn='{$serial}' and product_id='{$product_id}'" . ($customer_id ? " and warehouse_customer_id='{$customer_id}'" : "")); } }
function cw_mobile_get_mobile_host_attr_by_domain_id($domain_id) { global $tables; $mobile_mobile_flag = cw_session_register('mobile_mobile_flag'); cw_load('attributes'); $current_language = cw_query_first_cell("SELECT value FROM {$tables['config']} WHERE name='default_customer_language'"); $attributes = cw_func_call('cw_attributes_get', array('item_id' => $domain_id, 'item_type' => 'DM', 'language' => $current_language)); return !empty($attributes['mobile_host']['value']) ? trim($attributes['mobile_host']['value']) : ($mobile_mobile_flag == 'on' && $_GET['mobile_version'] != 'off' ? cw_mobile_get_host() : ''); }
function cw_objects_check_exist($object, $type = 'P') { global $tables, $customer_id; if (is_numeric($object)) { $query = "SELECT object_id \r\n\t\t\t\t\tFROM {$tables['objects_set']} \r\n\t\t\t\t\tWHERE object_id = {$object} \r\n\t\t\t\t\t\tAND customer_id = {$customer_id} \r\n\t\t\t\t\t\tAND set_type = '{$type}'"; return cw_query_first_cell($query) !== FALSE; } return FALSE; }
function cw_file_area_delete($type, $file_id) { global $tables; $file = cw_query_first_cell("select file_path from " . $tables[$type] . " where file_id='{$file_id}'"); if (is_file($file)) { @unlink($file); } db_query("delete from " . $tables[$type] . " where file_id='{$file_id}'"); }
function cw_pages_by_url($url, $check_redirect = true) { global $tables; $page_id = cw_query_first_cell("select * from {$tables['pages']} where url='{$url}'"); $page_data = cw_pages_get_page_content($page_id); if ($check_redirect && $page_data['redirect']) { cw_header_location($page_data['redirect'], true, false, 301); } return $page_data; }
function cw_add_class_data($data, $product_id) { global $tables; # Update class data $comp = $data['class']; $comp['product_id'] = $product_id; cw_unset($comp, "product_option_id"); $comp = cw_addslashes($comp); $product_option_id = cw_query_first_cell("SELECT product_option_id FROM {$tables['product_options']} WHERE class = '{$comp['class']}' AND product_id = '{$comp['product_id']}'"); $is_new = empty($product_option_id); if (!empty($product_option_id)) { cw_array2update("product_options", $comp, "product_option_id = '{$product_option_id}'"); } else { $product_option_id = cw_array2insert("product_options", $comp); } # Update class multilanguage data db_query("DELETE FROM {$tables['product_options_lng']} WHERE product_option_id = '{$product_option_id}'"); foreach ($data['product_options_lng'] as $v) { $v['product_option_id'] = $product_option_id; $v = cw_addslashes($v); cw_array2insert("product_options_lng", $v, true); } # Update class options $ids = array(); foreach ($data['product_options_values'] as $k => $opt) { $opt['product_option_id'] = $product_option_id; $old_option_id = $opt['option_id']; cw_unset($opt, "option_id"); $opt = cw_addslashes($opt); $option_id = cw_query_first_cell("SELECT option_id FROM {$tables['product_options_values']} WHERE product_option_id = '{$product_option_id}' AND name = '{$opt['name']}'"); if (empty($option_id)) { $option_id = cw_array2insert("product_options_values", $opt); } else { cw_array2update("product_options_values", $opt, "option_id = '{$option_id}'"); } $ids[$old_option_id] = $option_id; } # Update class option multilanguage data db_query("DELETE FROM {$tables['product_options_values_lng']} WHERE option_id = '{$option_id}'"); foreach ($data['product_options_values_lng'] as $v) { if (!isset($ids[$v['option_id']])) { continue; } $v['option_id'] = $ids[$v['option_id']]; $v = cw_addslashes($v); cw_array2insert("product_options_values_lng", $v, true); } # Detect and delete old product option class options $ids = cw_query_column("SELECT option_id FROM {$tables['product_options_values']} WHERE product_option_id = '{$product_option_id}' AND option_id NOT IN ('" . implode("','", $ids) . "')"); if (!empty($ids)) { db_query("DELETE FROM {$tables['product_options_values']} WHERE product_option_id = '{$product_option_id}' AND option_id IN ('" . implode("','", $ids) . "')"); db_query("DELETE FROM {$tables['product_options_values_lng']} WHERE option_id IN ('" . implode("','", $ids) . "')"); db_query("DELETE FROM {$tables['products_options_ex']} WHERE option_id IN ('" . implode("','", $ids) . "')"); } }
function cw_error_check_state($state, $section, &$full) { global $tables; $display_states = cw_query_first_cell("select display_states from {$tables['map_countries']} where code = '{$section['country']}'") == 'Y'; if (!$display_states) { return false; } if (empty($state) || !cw_user_check_state($state, $section['country'])) { return true; } return false; }
function cw_ebay_get_condition_value($var, $default_value) { global $tables; if (isset($var['ebay_condition_id']) && is_numeric($var['ebay_condition_id'])) { $condition_value = cw_query_first_cell("SELECT value_key FROM {$tables['attributes_default']} WHERE attribute_value_id = " . $var['ebay_condition_id']); if (empty($condition_value)) { return $default_value; } } else { return $default_value; } return $condition_value; }
/** * State lookup by zip * Table is loaded from csv with fields ZipCode,City,StateCode * SQL: load data local infile '/tmp/zip.txt' replace into table cw_map_zip fields terminated by ',' lines terminated by "\r\n" Ignore 1 lines; **/ function cw_map_get_state_by_zip($zip) { global $tables; if (empty($zip)) { return ''; } for ($i = strlen($zip); $i >= 2; $i--) { $state = cw_query_first_cell("SELECT state FROM {$tables['map_zip']} WHERE zip like '" . substr($zip, 0, $i) . "%'"); if (!empty($state)) { return $state; } } return ''; }
function cw_ps_bundle_show($product_id) { global $smarty, $tables, $config; $product_id = (int) $product_id; if (empty($product_id)) { return; } if ($_SERVER['REQUEST_METHOD'] != 'GET') { cw_ps_bundle_redirect($product_id); } $offer_id = cw_query_first_cell("SELECT offer_id FROM {$tables['ps_offers']} WHERE pid='{$product_id}' AND active='1'"); $product_offer = cw_call('cw_ps_offer', array($offer_id)); unset($product_offer['conditions']['P']['products'][$product_id]); $smarty->assign('product_offer', $product_offer); return $product_offer; }
function cw_session_start($sess_id = '') { global $APP_SESSION_VARS, $APP_SESS_ID; global $tables, $config; # $sess_id should contain only '0'..'9' or 'a'..'z' or 'A'..'Z' if (strlen($sess_id) > 32 || !empty($sess_id) && !preg_match('!^[0-9a-zA-Z]+$!S', $sess_id)) { $sess_id = ''; } $APP_SESSION_VARS = array(); $l = 0; if (isset($_SERVER['REMOTE_PORT'])) { $l = $_SERVER['REMOTE_PORT']; } list($usec, $sec) = explode(' ', microtime()); srand((double) $sec + (double) $usec * 1000000 + (double) $l); $curtime = cw_core_get_time(); $expiry_time = $curtime + USE_SESSION_LENGTH; if ($sess_id) { $sess_data = cw_query_first("select * from {$tables['sessions_data']} where sess_id='{$sess_id}' and expiry>{$curtime}"); if (!$sess_data) { $sess_id = ''; } } if (empty($sess_id)) { do { $sess_id = md5(uniqid(rand())); $already_exists = false; $already_exists = cw_query_first_cell("select count(*) from {$tables['sessions_data']} where sess_id='{$sess_id}'") > 0; } while ($already_exists); } if ($sess_data) { $APP_SESSION_VARS = unserialize($sess_data['data']); } else { if (!defined("NEW_SESSION")) { define("NEW_SESSION", true); } db_query("REPLACE INTO {$tables['sessions_data']} (sess_id, start, expiry, data) VALUES('{$sess_id}', '{$curtime}', '{$expiry_time}', '')"); } $APP_SESS_ID = $sess_id; global $app_config_file; setcookie(APP_SESSION_NAME, $APP_SESS_ID, 0, with_leading_slash_only($app_config_file['web']['web_dir'], true), $app_config_file['web']['http_host'], 0); if ($app_config_file['web']['http_host'] != $app_config_file['web']['https_host']) { setcookie(APP_SESSION_NAME, $APP_SESS_ID, 0, with_leading_slash_only($app_config_file['web']['web_dir'], true), $app_config_file['web']['https_host'], 0); } }
function cw_ppd_doc_change_status_C($doc_data, $return) { global $tables, $config; if (empty($doc_data) || !is_array($doc_data)) { return $return; } $doc_data['doc_id'] = (int) $doc_data['doc_id']; $_download_exists = cw_query_first_cell('SELECT download_id FROM ' . $tables['ppd_downloads'] . ' WHERE order_id = \'' . $doc_data['doc_id'] . '\''); if (!empty($_download_exists) || empty($doc_data['products'])) { return $return; } $values_for_ins = array(); $data = array(); $data['order_id'] = $doc_data['doc_id']; $data['customer_id'] = $doc_data['userinfo']['customer_id']; $data['allowed_number'] = (int) $config['ppd']['ppd_loading_attempts']; $data['counter'] = 0; $data['expiration_date'] = cw_core_get_time() + (int) $config['ppd']['ppd_link_lifetime'] * 60 * 60; foreach ($doc_data['products'] as $product) { $files = cw_query('SELECT file_id FROM ' . $tables['ppd_files'] . ' WHERE product_id = \'' . $product['product_id'] . '\' AND active = 1 AND perms_owner >= 4 AND perms_all = 0 ORDER BY number'); if (empty($files) || !is_array($files)) { continue; } $data['product_id'] = $product['product_id']; foreach ($files as $file) { $data['file_id'] = $file['file_id']; $_replace_data = cw_query_first_cell('SELECT download_id FROM ' . $tables['ppd_downloads'] . ' WHERE product_id = \'' . $data['product_id'] . '\' AND file_id = \'' . $data['file_id'] . '\''); if (!empty($_replace_data)) { $data['download_id'] = $_replace_data; $query = 'REPLACE INTO ' . $tables['ppd_downloads'] . ' (`' . implode('`, `', array_keys($data)) . '`) VALUES ' . '(\'' . implode('\', \'', $data) . '\')'; db_query($query); unset($data['download_id']); continue; } $values_for_ins[] = '(\'' . implode('\', \'', $data) . '\')'; } } if (empty($values_for_ins)) { return $return; } $query = 'INSERT INTO ' . $tables['ppd_downloads'] . ' (`' . implode('`, `', array_keys($data)) . '`) VALUES ' . implode(', ', $values_for_ins); db_query($query); return $return; }
function cw_product_filter_recalculate_price_ranges() { global $tables; $price_ranges = cw_product_filter_get_price_ranges(PRICE_ATTRIBUTE_ID); if ($price_ranges) { $min_price = cw_query_first_cell("SELECT MIN(price) FROM {$tables['products_prices']}"); $max_price = cw_query_first_cell("SELECT MAX(price) FROM {$tables['products_prices']}"); $min['id'] = $min['val'] = $max['id'] = $max['val'] = 0; foreach ($price_ranges as $pr) { $r = cw_product_filter_get_price_range_values($pr['id']); if ($min_price > $r[1] || $max_price < $r[0]) { cw_array2update('attributes_default', array('active' => 0), "attribute_value_id='{$pr['id']}'"); continue; } $price_ranges[$pr['id']]['min'] = $r[0]; $price_ranges[$pr['id']]['max'] = $r[1]; if ($min['id'] == 0) { $min['id'] = $max['id'] = $pr['id']; $min['val'] = $r[0]; $max['val'] = $r[1]; } else { if ($min['val'] > $r[0]) { $min['val'] = $r[0]; $min['id'] = $pr['id']; } if ($max['val'] < $r[1]) { $max['val'] = $r[1]; $max['id'] = $pr['id']; } } } if ($min_price != $min['val']) { cw_array2update('attributes_default', array('value_key' => $min_price . '-' . $price_ranges[$min['id']]['max']), "attribute_value_id='" . $min['id'] . "'"); } if ($max_price != $max['val']) { cw_array2update('attributes_default', array('value_key' => $price_ranges[$max['id']]['min'] . '-' . $max_price), "attribute_value_id='" . $max['id'] . "'"); } } }
function cw_product_shipping_option_shipping_get_rates($params, $return) { // cw_log_add('shipping_get_rates', array($params, $return)); global $config, $tables; if (empty($config['product_shipping_options']['dummy_shipping_method'])) { return $return; } $shipping = cw_func_call('cw_shipping_search', array('data' => array('active' => 1, 'where' => array("shipping_id = '" . $config['product_shipping_options']['dummy_shipping_method'] . "'")))); $pso_shipping = reset($shipping); if (!empty($pso_shipping)) { $total_optional_rate = 0; $products = $params['cart']['products']; foreach ($products as $product) { $product_shipping_cost = cw_query_first_cell("select price from {$tables['product_shipping_options_values']} where shipping_id='{$product['product_shipping_option']}' and product_id='{$product['product_id']}'"); if (!empty($product_shipping_cost)) { $total_optional_rate += floatval($product_shipping_cost); } } $shrate = array('rate_id' => 999999, 'shipping_id' => $pso_shipping['shipping_id'], 'zone_id' => 0, 'maxamount' => 0, 'minweight' => 0, 'maxweight' => 999999, 'mintotal' => 0, 'maxtotal' => 999999, 'rate' => $total_optional_rate, 'original_rate' => $total_optional_rate, 'item_rate' => 0.0, 'weight_rate' => 0.0, 'rate_p' => 0.0, 'warehouse_customer_id' => 0, 'type' => 'D', 'overweight' => 0.0, 'overweight_rate' => 0.0, 'apply_to' => 'ST'); $return = array($pso_shipping['shipping_id'] => array_merge($shrate, $pso_shipping)); } return $return; }
function dumpTableContent($table, $schema, $fd) { global $sql_backup_rows; if ($fd === false) { print "{$schema}\n\n"; } else { fwrite($fd, "{$schema}\n\n"); echo cw_get_langvar_by_name("lbl_dumping_table_n", array("table" => $table), false, true) . "<br />\n"; } $rows_cnt = 0; $current_row = 0; $count = cw_query_first_cell("SELECT count(*) FROM " . $table); if ($count < 1) { return; } for ($pos = 0; $count > 0; $count -= $sql_backup_rows, $pos += $sql_backup_rows) { $local_query = "SELECT * FROM {$table} LIMIT {$pos},{$sql_backup_rows}"; $result = db_query($local_query); if ($result != FALSE) { $fields_cnt = mysql_num_fields($result); $rows_cnt = mysql_num_rows($result); // Checks whether the field is an integer or not for ($j = 0; $j < $fields_cnt; $j++) { $field_set[$j] = mysql_field_name($result, $j); $type = mysql_field_type($result, $j); $field_num[$j] = ($type == 'tinyint' || $type == 'smallint' || $type == 'mediumint' || $type == 'int' || $type == 'bigint' || $type == 'timestamp') && (!defined("OVERRIDE_NUM_FIELD") || !constant("OVERRIDE_NUM_FIELD")); } // Sets the scheme $schema_insert = "INSERT INTO {$table} VALUES ("; $search = array("", "\n", "\r", ""); //\x08\\x09, not required $replace = array('0', '\\n', '\\r', '\\Z'); $current_row = 0; while ($row = mysql_fetch_row($result)) { $current_row++; for ($j = 0; $j < $fields_cnt; $j++) { if (!isset($row[$j])) { $values[] = 'NULL'; } else { if ($row[$j] == '0' || $row[$j] != '') { // a number if ($field_num[$j]) { $values[] = $row[$j]; } else { $values[] = "'" . str_replace($search, $replace, addslashes($row[$j])) . "'"; } } else { $values[] = "''"; } } // end if } // end for // Extended inserts case $insert_line = $schema_insert . implode(', ', $values) . ')'; unset($values); // Send the line if ($fd === false) { print $insert_line . ";\n"; flush(); } else { fwrite($fd, $insert_line . ";\n"); fflush($fd); } // loic1: send a fake header to bypass browser timeout if data // are bufferized } // end while } // end if ($result != FALSE) db_free_result($result); if ($fd !== false) { cw_flush(". "); } } // for if ($fd === false) { print "\n"; } else { fwrite($fd, "\n"); echo "<br />"; } }
if (zerolen($image_path) && !zerolen($_filename)) { cw_load("image"); $image_path = cw_image_dir($type) . "/" . $_filename; } db_free_result($result); break; } if ($is_substitute) { if (!empty($config['substitute_images'][$type]) && isset($config['available_images'][$config['substitute_images'][$type]]) && !isset($hash_types[$config['substitute_images'][$type]])) { $type = $config['substitute_images'][$type]; $hash_types[$type] = true; continue; } # kornev, TOFIX if ($type == "W") { $tmp_id = cw_query_first_cell("SELECT product_id FROM {$tables['product_variants']} WHERE variant_id = '{$id}'"); if ($tmp_id) { $id = $tmp_id; $type = "P"; $hash_types[$type] = true; continue; } } } db_free_result($result); break; } if (!zerolen($image_path) && !is_url($image_path)) { if (!file_exists($image_path) || !is_readable($image_path)) { $image_path = ""; } elseif ($config['setup_images'][$type]['md5_check'] == 'Y') {
} # Recalculate cart totals after updating $products = cw_call('cw_products_in_cart', array($cart, $user_account)); $cart = cw_func_call('cw_cart_calc', array('cart' => $cart, 'products' => $products, 'userinfo' => $user_account)); } ?> <script type="text/javascript"> <!-- if (window.opener) window.opener.location.reload(); window.close(); --> </script> <?php exit; } if (!$min_avail) { $min_avail = cw_query_first_cell("SELECT min_amount FROM {$tables['products']} WHERE product_id = '{$product_id}'"); } if (!$min_avail) { $min_avail = 1; } $smarty->assign('id', $id); $smarty->assign('mode', $mode); $smarty->assign('eventid', $eventid); $smarty->assign('min_avail', $min_avail); $smarty->assign('alert_msg', 'Y'); $smarty->assign('err', $err); $smarty->assign('home_style', 'popup'); $smarty->assign('current_main_dir', 'addons'); $smarty->assign('current_section_dir', 'product_options/main/options'); $smarty->assign('main', 'popup');
<?php $salesman =& cw_session_register("salesman"); $salesman_click_id =& cw_session_register("salesman_click_id"); $salesman_saleman =& cw_session_register("salesman_saleman"); $salesman_membership =& cw_session_register("salesman_membership"); if ($_GET['saleman']) { $salesman_saleman = $saleman; } if ($_GET['level'] && $_GET['saleman']) { $salesman_membership = $level; } if ($customer_id) { $possible_salesman = cw_query_first_cell("select salesman_customer_id from {$tables['customers_relations']} where customer_id='{$customer_id}'"); if ($possible_salesman) { $salesman = $possible_salesman; } } $_tmp_current_host = $app_http_host; $_tmp = parse_url($current_location); if (!empty($_tmp['host'])) { $_tmp_current_host = $_tmp['host']; } if (empty($salesman) && (!empty($_GET['salesman']) || !empty($_POST['salesman_customer_id']))) { # # Assign current salesman value # if (isset($_POST['salesman_customer_id']) && !empty($_POST['salesman_customer_id'])) { $salesman = $_POST['salesman_customer_id']; } else { $salesman = $_GET['salesman'];
$mysql_password = $app_config_file['sql']['password']; $mysql_host = $app_config_file['sql']['host']; $shell_comm = "echo {$arch_select_qry} | mysql --host={$mysql_host} --user={$mysql_user} --password={$mysql_password} {$mysql_db} > {$arch_log_name}"; shell_exec($shell_comm); if (file_exists($arch_log_name)) { cw_add_top_message("Current log saved to archive: <a style='color:white' href='{$var_dirs_web['logs_archive']}/{$arch_log_file_name}'>{$arch_log_name}"); if ($drop_archived == "1") { db_query("delete from ld using {$tables['logged_data']} as ld {$archive_where_string_qry}"); } } else { cw_add_top_message('Cannot save log to file: ' . $arch_log_name, 'E'); } } cw_header_location('index.php?target=logging'); } $total_items = cw_query_first_cell("select count(*) from {$tables['logged_data']} as ld {$where_string_qry}"); $navigation = cw_core_get_navigation($target, $total_items, $page); $navigation['script'] = 'index.php?target=' . $target; $smarty->assign('navigation', $navigation); $smarty->assign('page', $page); $limit_qry = " LIMIT {$navigation['first_page']}, {$navigation['objects_per_page']}"; $logged_data = cw_query($s = "select ld.*, IF(ld.customer_id>0,1,0) as is_logged from {$tables['logged_data']} as ld {$where_string_qry} {$orderby_qry} {$limit_qry}"); $session_ids = array(); foreach ($logged_data as $ld_k => $ld_v) { $session_ids[$ld_v['cwsid']] = 1; $logged_data[$ld_k]['GET_POST'] = unserialize($ld_v['GET_POST']); } $smarty->assign('logged_data', $logged_data); $_sess_data = cw_query("select * from {$tables['logged_data_sessions']} where cwsid in ('" . implode("', '", array_keys($session_ids)) . "')"); $sess_data = array(); foreach ($_sess_data as $s_data) {
cw_header_location('index.php?target=help§ion=login_customer'); } if ($mode == 'friends') { cw_include('addons/estore_gift/wishlist.php'); $smarty->assign('allow_edit', false); $smarty->assign('main', 'friends'); } elseif ($mode == 'giftcert' || $mode == 'preview' || $mode == 'gc2cart' || $mode == 'modify_gc' || $action == 'delgc' || $action == "addgc2wl") { cw_include('addons/estore_gift/cert.php'); } elseif ($mode == 'gifts') { $access_status =& cw_session_register('access_status', array()); if (!empty($cc)) { cw_include("addons/estore_gift/giftreg_confirm.php"); } if (!empty($eventid)) { if (!empty($wlid)) { if (cw_query_first_cell("SELECT event_id FROM {$tables['wishlist']} WHERE wishlist_id='{$wild}'") == $eventid) { $wlid_eventid =& cw_session_register("wlid_eventid"); $wlid_eventid = $eventid; cw_session_save("wlid_eventid"); } } cw_include("addons/estore_gift/event_guestbook.php"); cw_include("addons/estore_gift/giftreg_display.php"); } else { cw_include("addons/estore_gift/giftreg_search.php"); } } elseif ($mode == 'events') { if (isset($_GET['event_id'])) { cw_include('addons/estore_gift/event.php'); } else { cw_include('addons/estore_gift/events.php');
function cw_get_parents($user) { global $tables, $config; $parent = cw_query_first_cell("SELECT salesman_customer_id FROM {$tables['customers_relations']} WHERE customer_id='{$user}'"); if ($parent) { $parents[] = array("customer_id" => $parent, "level" => cw_get_affiliate_level($parent)); $parents = cw_array_merge($parents, cw_get_parents($parent)); } return $parents; }
function cw_faq_generate_path($rubrik_id, &$path) { global $tables; $parent = cw_query_first_cell("select parent_id from {$tables['faq_rubrik']} where rubrik_id='{$rubrik_id}'"); if ($parent) { cw_faq_generate_path($parent, $path); $path[] = $parent; } }
<?php cw_load('addons'); if ($action == 'update' && is_array($upd_addons)) { db_query("update {$tables['addons']} set active='0' where status>'" . constant('ADDON_TYPE_CORE') . "'"); foreach ($upd_addons as $addon => $val) { db_query("update {$tables['addons']} set active='1' where addon='{$addon}'"); } $disabled = cw_query_column("select addon from {$tables['addons']} where active = 0"); db_query("update {$tables['addons']} set active=0 where parent in ('" . implode("', '", $disabled) . "')"); cw_header_location("index.php?target={$target}&mode=addons"); } if ($action == 'ajax_update') { db_query("update {$tables['addons']} set active=abs(active-1) where addon='{$addon}' and status>'" . constant('ADDON_TYPE_CORE') . "'"); $active = cw_query_first_cell("select active from {$tables['addons']} where addon='{$addon}'"); cw_add_ajax_block(array('id' => 'script', 'content' => '$("#' . $addon . '").removeClass("on").removeClass("off").addClass("' . ($active == 1 ? 'on' : 'off') . '");')); cw_add_ajax_block(array('id' => 'script', 'content' => '$("[parent=' . $addon . ']").parent().removeClass("addon_locked")' . ($active == 1 ? '' : '.addClass("addon_locked")') . ';')); } $addon = $_GET['addon']; if (!empty($addon) && $mode == 'addons') { # kornev, TOFIX generally this should be removed if (is_file($app_main_dir . '/addons/' . $addon . '/admin/settings.php')) { cw_include('addons/' . $addon . '/admin/settings.php'); } if ($REQUEST_METHOD == 'POST') { cw_header_location("index.php?target={$target}&mode=addons&addon={$addon}"); } $smarty->assign('addon', $addon); $smarty->assign('addon_name', cw_get_langvar_by_name('addon_name_' . $addon)); $location[] = array(cw_get_langvar_by_name('lbl_addons'), 'index.php?target=' . $target); $location[] = array($addon, '');
function cw_ups_service_type($order) { global $tables; if (empty($order['order']['shipping_id'])) { return false; } $shipping = cw_query_first_cell("SELECT shipping FROM {$tables['shipping']} WHERE code = 'UPS' AND shipping_id = '" . $order['order']['shipping_id'] . "'"); if (empty($shipping)) { return false; } $str = false; if (strpos($shipping, "UPS Next Day Air A.M.") === 0 || strpos($shipping, "UPS Next Day Air") === 0 && strpos($shipping, "Early A.M.") !== false) { $str = "Next Day Air Early AM"; } elseif (strpos($shipping, "UPS Next Day Air Saver") === 0) { $str = "Next Day Air Saver"; } elseif (strpos($shipping, "UPS Next Day Air") === 0) { $str = "Next Day Air"; } elseif (strpos($shipping, "UPS 2nd Day Air A.M.") === 0) { $str = "2nd Day Air AM"; } elseif (strpos($shipping, "UPS 2nd Day Air") === 0) { $str = "2nd Day Air"; } elseif (strpos($shipping, "UPS 3 Day Select") === 0) { $str = "3 Day Select"; } elseif (strpos($shipping, "UPS Ground") === 0) { $str = "Ground"; } return $str; }
function cw_dod_generate() { global $tables, $config, $current_language; $generator = cw_query_first("select * from {$tables['dod_generators']} where active=1 and startdate<='" . time() . "' and enddate>'" . time() . "' and dod_interval<>0 order by position asc, generator_id asc"); if (!empty($generator)) { //check last generation date $last_gen_date = $generator['current_offer_date']; $hrs_since_last_generation = intval((time() - $last_gen_date) / 3600); $generate_again = false; if ($generator['dod_interval_type'] == 'D') { $generate_again = $hrs_since_last_generation >= $generator['dod_interval'] * 24; $offer_enddate = min($generator['enddate'], time() + $generator['dod_interval'] * 24 * 3600); } elseif ($generator['dod_interval_type'] == 'T') { $dod_period_hrs = intval(($generator['enddate'] - $generator['startdate']) / 3600); $hrs_interval = intval($dod_period_hrs / $generator['dod_interval']); $generate_again = $hrs_since_last_generation >= $hrs_interval; $offer_enddate = min($generator['enddate'], time() + $dod_period_hrs / $generator['dod_interval'] * 3600); } if ($generate_again || $_GET['force_generate']) { if (!empty($generator['used_pids'])) { $used_pids = explode(';', $generator['used_pids']); } else { $used_pids = array(); } $dod_products = cw_query_column("select dbd.object_id from {$tables['dod_bonus_details']} dbd inner join {$tables['dod_bonuses']} db on db.generator_id=dbd.generator_id and db.bonus_id=dbd.bonus_id and db.type='" . DOD_DISCOUNT . "' where dbd.generator_id='{$generator['generator_id']}' and dbd.object_type='" . DOD_OBJ_TYPE_PRODS . "'"); $dod_categories = cw_query_column("select dbd.object_id from {$tables['dod_bonus_details']} dbd inner join {$tables['dod_bonuses']} db on db.generator_id=dbd.generator_id and db.bonus_id=dbd.bonus_id and db.type='" . DOD_DISCOUNT . "' where dbd.generator_id='{$generator['generator_id']}' and dbd.object_type='" . DOD_OBJ_TYPE_CATS . "'"); $dod_manufacturers = cw_query_column("select dbd.object_id from {$tables['dod_bonus_details']} dbd inner join {$tables['dod_bonuses']} db on db.generator_id=dbd.generator_id and db.bonus_id=dbd.bonus_id and db.type='" . DOD_DISCOUNT . "' where dbd.generator_id='{$generator['generator_id']}' and dbd.object_type='" . DOD_OBJ_TYPE_MANS . "'"); $dod_attributes = cw_query("select dbd.* from {$tables['dod_bonus_details']} dbd inner join {$tables['dod_bonuses']} db on db.generator_id=dbd.generator_id and db.bonus_id=dbd.bonus_id and db.type='" . DOD_DISCOUNT . "' where dbd.generator_id='{$generator['generator_id']}' and dbd.object_type='" . DOD_OBJ_TYPE_ATTR . "'"); //select products by dod conditions $data = array(); $dod_data_where_pids = ''; if ($dod_products) { $dod_data_where_pids = "{$tables['products']}.product_id in ('" . implode("','", $dod_products) . "')"; } if ($dod_categories) { $data['search_in_subcategories'] = 1; $data['category_ids'] = $dod_categories; } if ($dod_manufacturers) { $manufacturer_id_attribute = cw_query_first_cell("select attribute_id from {$tables['attributes']} where field='manufacturer_id' and addon='manufacturers'"); if ($manufacturer_id_attribute) { if (!isset($ret_params)) { $ret_params = array(); } if (!isset($ret_params['query_joins'])) { $ret_params['query_joins'] = array(); } $ret_params['query_joins']['atv_manufacturer'] = array('tblname' => 'attributes_values', 'on' => "{$tables['products']}.product_id=atv_manufacturer.item_id and atv_manufacturer.item_type='P' and atv_manufacturer.attribute_id = '{$manufacturer_id_attribute}' and atv_manufacturer.code in ('{$current_language}', '') and atv_manufacturer.value in ('" . implode("','", $dod_manufacturers) . "')", 'is_inner' => 1); } } if ($dod_attributes) { $param2_sql = array('eq' => '=', 'lt' => '<', 'le' => '<=', 'gt' => '>', 'ge' => '=>'); foreach ($dod_attributes as $attr_data_k => $attr_data) { $is_def_values = cw_query_first("select * from {$tables['attributes_default']} where attribute_value_id='{$attr_data['param1']}' and attribute_id='{$attr_data['object_id']}'"); //print_r($is_def_values);print("<br><br>"); $sql_operation = $param2_sql[$attr_data['param2']]; if (empty($sql_operation)) { continue; } if (!isset($ret_params)) { $ret_params = array(); } if (!isset($ret_params['query_joins'])) { $ret_params['query_joins'] = array(); } if ($is_def_values) { $ret_params['query_joins']['atv_dod_' . $attr_data_k] = array('tblname' => 'attributes_values', 'on' => "{$tables['products']}.product_id=atv_dod_{$attr_data_k}.item_id and atv_dod_{$attr_data_k}.item_type='P' and atv_dod_{$attr_data_k}.attribute_id = '{$attr_data['object_id']}' and atv_dod_{$attr_data_k}.code in ('{$current_language}', '')", 'is_inner' => 1); $ret_params['query_joins']['atd_dod_' . $attr_data_k] = array('tblname' => 'attributes_default', 'on' => "atd_dod_{$attr_data_k}.attribute_value_id=atv_dod_{$attr_data_k}.value and atv_dod_{$attr_data_k}.attribute_id=atd_dod_{$attr_data_k}.attribute_id and atd_dod_{$attr_data_k}.value{$sql_operation}'" . addslashes($is_def_values['value']) . "'", 'is_inner' => 1); } else { $ret_params['query_joins']['atv_dod_' . $attr_data_k] = array('tblname' => 'attributes_values', 'on' => "{$tables['products']}.product_id=atv_dod_{$attr_data_k}.item_id and atv_dod_{$attr_data_k}.item_type='P' and atv_dod_{$attr_data_k}.attribute_id = '{$attr_data['object_id']}' and atv_dod_{$attr_data_k}.code in ('{$current_language}', '') and atv_dod_{$attr_data_k}.value{$sql_operation}'{$attr_data['param1']}'", 'is_inner' => 1); } } } global $user_account, $current_area, $items_per_page_targets, $target; $items_per_page_targets[$target] = 1; $new_pid = 0; $safety_cnt = 1000; while (!$new_pid && $safety_cnt > 0) { if (!empty($data) || !empty($dod_data_where_pids)) { $data['sort_field'] = 'rand'; $data['flat_search'] = 1; $dod_data_where = array(); if (!empty($dod_data_where_pids)) { $dod_data_where[] = $dod_data_where_pids; } if (!empty($used_pids)) { $dod_data_where[] = "{$tables['products']}.product_id not in ('" . implode("','", $used_pids) . "')"; } $data['where'] = implode(' and ', $dod_data_where); list($products, $nav, $product_filter) = cw_func_call('cw_product_search', array('data' => $data, 'user_account' => $user_account, 'current_area' => $current_area, 'info_type' => 8, 'product_id_only' => 1), $ret_params); } $product = reset($products); //print_r(array('product'=>$product));print("<br><br>"); $new_pid = $product['product_id']; if (!$new_pid) { if ($generator['no_item_repeat']) { break; } else { if (!empty($used_pids)) { array_shift($used_pids); } else { break; } } } $safety_cnt--; } //die; if ($new_pid) { $used_pids[] = $new_pid; } $generator['used_pids'] = implode(';', $used_pids); $regenerate_offer = true; if ($regenerate_offer) { //regenerate offer if (!empty($generator['current_offer_id'])) { $offer_ids = array($generator['current_offer_id']); $offer_ids_query = implode("', '", $offer_ids); db_query("DELETE FROM {$tables['ps_offers']} WHERE offer_id IN ('" . $offer_ids_query . "')"); db_query("DELETE FROM {$tables['ps_bonuses']} WHERE offer_id IN ('" . $offer_ids_query . "')"); db_query("DELETE FROM {$tables['ps_bonus_details']} WHERE offer_id IN ('" . $offer_ids_query . "')"); db_query("DELETE FROM {$tables['ps_conditions']} WHERE offer_id IN ('" . $offer_ids_query . "')"); db_query("DELETE FROM {$tables['ps_cond_details']} WHERE offer_id IN ('" . $offer_ids_query . "')"); db_query("DELETE FROM {$tables['attributes_values']} WHERE item_id IN ('" . $offer_ids_query . "') and item_type='PS'"); foreach ($offer_ids as $offer_id) { cw_image_delete($offer_id, PS_IMG_TYPE); } cw_attributes_cleanup($offer_ids, PS_ATTR_ITEM_TYPE); cw_cache_clean('shipping_rates'); } if ($new_pid) { cw_log_add('dod_generator', array('new DOD product selected' => $new_pid)); $new_offer_id = cw_array2insert('ps_offers', array('title' => 'Deal Of The Day', 'description' => $generator['description'], 'startdate' => time(), 'enddate' => $offer_enddate, 'active' => 1)); } $current_offer_id = 0; if ($new_offer_id) { $mdm_attribute_id = cw_query_first_cell("select attribute_id from {$tables['attributes']} where addon='multi_domains' and item_type='PS'"); if ($mdm_attribute_id) { cw_array2insert('attributes_values', array('item_id' => $new_offer_id, 'attribute_id' => $mdm_attribute_id, 'value' => 0, 'code' => '', 'item_type' => 'PS')); } //copy bonus and bonus details $dod_bonuses = cw_query("select * from {$tables['dod_bonuses']} where generator_id='{$generator['generator_id']}' and unused=0"); foreach ($dod_bonuses as $dod_bonus) { $_dod_bonus = $dod_bonus; unset($_dod_bonus['generator_id']); $_dod_bonus['offer_id'] = $new_offer_id; $new_bonus_id = cw_array2insert('ps_bonuses', $_dod_bonus); if ($_dod_bonus['type'] == 'D' && $_dod_bonus['apply'] == 3) { cw_array2insert('ps_bonus_details', array('bonus_id' => $new_bonus_id, 'offer_id' => $new_offer_id, 'object_id' => $new_pid, 'quantity' => 1, 'object_type' => DOD_OBJ_TYPE_PRODS)); } else { $dod_bonus_details = cw_query("select * from {$tables['dod_bonus_details']} where generator_id='{$generator['generator_id']}' and bonus_id='{$dod_bonus['bonus_id']}'"); if (!empty($dod_bonus_details)) { foreach ($dod_bonus_details as $dod_bonus_detail) { $_dod_bonus_detail = $dod_bonus_detail; unset($_dod_bonus_detail['generator_id']); $_dod_bonus_detail['offer_id'] = $new_offer_id; $_dod_bonus_detail['bonus_id'] = $new_bonus_id; cw_array2insert('ps_bonus_details', $_dod_bonus_detail); } } } } $new_cond_id = cw_array2insert('ps_conditions', array('type' => 'P', 'total' => '0.00', 'offer_id' => $new_offer_id)); if ($new_cond_id) { cw_array2insert('ps_cond_details', array('cond_id' => $new_cond_id, 'offer_id' => $new_offer_id, 'object_id' => $new_pid, 'quantity' => 1, 'object_type' => DOD_OBJ_TYPE_PRODS)); } $current_offer_id = $new_offer_id; } } //update dod_generator fields cw_array2update('dod_generators', array('current_offer_id' => $current_offer_id, 'used_pids' => $generator['used_pids'], 'current_offer_date' => $current_offer_id ? time() : 0), "generator_id='{$generator['generator_id']}'"); if ($current_offer_id && !empty($config['deal_of_day']['dod_news_template']) && $config['deal_of_day']['dod_newslist']) { $newslist = cw_query_first("select * from {$tables['newslists']} where list_id='" . $config['deal_of_day']['dod_newslist'] . "' and avail=1"); if (!empty($newslist)) { //create message global $smarty; $smarty->assign('promotion', $generator); $smarty->assign('product_id', $new_pid); $product_info = cw_func_call('cw_product_get', array('id' => $new_pid, 'user_account' => $user_account, 'info_type' => 65535)); $smarty->assign('product', $product_info); $smarty->assign('news_message', $config['deal_of_day']['dod_news_template']); $message = cw_display("addons/deal_of_day/admin/generate_news.tpl", $smarty, false, $newslist['lngcode']); $smarty->assign('news_message', $config['deal_of_day']['dod_news_template_subject']); $message_subject = cw_display("addons/deal_of_day/admin/generate_news.tpl", $smarty, false, $newslist['lngcode']); // $message = $smarty->display('addons/deal_of_day/admin/generate_news.tpl'); print $message_subject . "<hr />" . $message; if (!empty($message)) { cw_array2insert('newsletter', array('subject' => $message_subject, 'body' => $message, 'created_date' => time(), 'send_date' => time(), 'updated_date' => time(), 'status' => 'N', 'list_id' => $config['deal_of_day']['dod_newslist'], 'show_as_news' => 1, 'allow_html' => 1)); } } } } } return $new_pid; }
<?php if (cw_query_first_cell("SELECT COUNT(*) FROM {$tables['categories']} WHERE category_id='{$cat}'") == 0) { cw_header_location('index.php?target=categories'); } $category_page =& cw_session_register('category_page'); $data = array(); $data['flat_search'] = 1; $data['category_id'] = $cat; $data['category_main'] = "Y"; $data['category_extra'] = "Y"; $data['page'] = $page; $data['objects_per_page'] = $category_page['objects_per_page']; $data['sort_field'] = $category_page['sort_field']; $data['sort_direction'] = $category_page['sort_direction']; list($products, $navigation) = cw_func_call('cw_product_search', array('data' => $data, 'user_account' => $user_account, 'current_area' => $current_area, 'info_type' => 0)); $navigation['script'] = 'index.php?target=' . $target . '&mode=' . $mode . '&cat=' . $cat; $smarty->assign('navigation', $navigation); $smarty->assign('products', $products); $smarty->assign('current_category', cw_func_call('cw_category_get', array('cat' => $cat))); $smarty->assign('main', 'category_products');
$list = cw_query_first("select * from {$tables['newslists']} WHERE list_id='{$list_id}'"); if (empty($list['list_id'])) { $top_message['content'] = cw_get_langvar_by_name('msg_adm_err_newslist_not_exists'); cw_header_location('index.php?target=' . $target); } else { if ($list['lngcode'] != $current_language && is_array($d_langs) && !in_array($list['lngcode'], $d_langs)) { cw_header_location("index.php?target={$target}&mode=modify&list_id={$list_id}&edit_lng={$list['lngcode']}&old_lng={$current_language}"); } } $memberships = cw_query("select membership_id from {$tables['newslists_memberships']} where list_id='{$list['list_id']}'"); if ($memberships) { foreach ($memberships as $val) { $list['memberships'][$val['membership_id']] = true; } } $list_idname = cw_query_first_cell("SELECT name FROM {$tables['newslists']} WHERE list_id='{$list_id}'"); $smarty->assign('list_idname', $list_idname); $smarty->assign('list_id', $list_id); $smarty->assign('list', $list); # subscribers tabs $total_items = count($subscribers = cw_call('cw\\news\\get_subscribers', array($list_id))); if (!empty($total_items)) { $navigation = cw_core_get_navigation($target, $total_items, $page); $navigation['script'] = "index.php?target={$target}&js_tab=subscriptions&list_id=" . $list_id; $smarty->assign('navigation', $navigation); $subscribers = array_slice($subscribers, $navigation['first_page'], $navigation['objects_per_page']); } $smarty->assign('subscribers', $subscribers); # messages tab cw_load('map'); $countries = cw_map_get_countries();