Jump to content

rikic

Members
  • Content count

    30
  • Joined

  • Last visited

  • Days Won

    2

Everything posted by rikic

  1. Hi Richard, I'va just tested your last version: everything is working. Great! thank you again! :thumbsup:
  2. Hi richard, I've tested last version of yo our contribution on my website abnd I think there's a bug: it doesn't charge the "coma" in the price. I mean, if the price is € 109,00 it shows 10900. any idea? thank you very much riccardo
  3. Hi richard, I've tested your updated version and it works great as it is, even with SPPC installed. Great job! thank you very much! riccardo
  4. Hi Richard, I thought I've solved the problem doing this change in FILENAME_PRODUCT_INFO, but it seems doesn't work correctly. case FILENAME_PRODUCT_INFO: global $_GET; if(tep_not_null($_GET['products_id'])){ $return[0] = "'" . $_GET['products_id'] . "'"; global $product_info; if ($new_price = tep_get_products_special_price($product_info['products_id'])) { $product_info['specials_new_products_price'] = $new_price; } $return[2] = $product_info['specials_new_products_price'] ? $product_info['specials_new_products_price'] : $product_info['products_price']; } $return[1] = 'product'; break; do you other ideas... ? I'm not a professional coder.... :- thank you riccardo
  5. hi Richard, thank you for your contribution. I've just a little problem: I've installed SPPC on my web page and when I made a special offer the tag doesn't charge the special price but only the original price. I think that it should be very important for the remarketing campaign that the special would be shown. do you have any idea? thank you again for your help. riccardo
  6. rikic

    Support forum for [HTML Mail]

    @ ok, it's all clear. thank you for your answer riccardo
  7. rikic

    [Addon] Generic Box

    @@kymation Hi jim! First thank you for your contibution! I’m having a problem with trying to display a image in the box. In the contents box seems it put a slash before each " and the image doesn’t show. I put in window contents: <img src="/images/myimage.jpg"> and submit, the system changes it to <img src=\"/images/myimage.png\"> everytime I try to modify it, it add a new slash... I've already tried to re install the modul, but the problem always apperas. Any idea? thank you very much for your help. Riccardo
  8. rikic

    Support forum for [HTML Mail]

    Hi Robert and thank you very much for you r contributions. I've tried to install it on my Oscommerce 2.3.3 shop but it seems it doesn't work for me... 'cause I'm dummy and maybe a little dumb, but I haven't understood how it should work: if I set "all Email" that means all the mail sent should be sent in Html format, right? even mail sent through the normal admin/send mail page? thank you for your help bye riccardo
  9. rikic

    Simply Hide Products (SHP)

    hi lorraine, at the end I've removed TotalB2B for SPPC. If I'll have a little bit of time, I'll try to help you. bye R.
  10. rikic

    Simply Hide Products (SHP)

    Hi lorraine, My "problem" is that on my site I've installed TotalB2b, which seems doesn't fit with hide categories. Or maybe I was wrong during the installation.... I don't know. That way I was trying with SHP.... But if you say that, I'll think if it's better to remove TB2b for SPPC and use hide categories. let me know if you'll find a solution. R.
  11. rikic

    Simply Hide Products (SHP)

    Me too. I'm prepared to pay someone to solve this problem.
  12. rikic

    Simply Hide Products (SHP)

    Hi Lorraine, I did exactly the change you did. With the same result, obviously.... ;( I tried to install several contribution to hide product or categories (which is very important for me), but seems that no one is working correctly with 2.3.3. Or maybe there are some conflicts with other contributions that I've installed before... I think that maybe the solution should be to insert the string $shp directly in index.php queries, as it is in this contribution http://addons.oscommerce.com/info/3059. this maybe would resolve the duplicate of clauses "where". But it's only an hipothesis... I really hope in a pronux's "reaction".... Bye Riccardo
  13. rikic

    Simply Hide Products (SHP)

    sorry I think I was wrong. I suppoese the problem is in includes/functions/database.php here: //START SHP if(stristr($query, ' '.TABLE_PRODUCTS.' ') && !strstr($query, ' shp.products_id ') && isset($_SESSION['hidden_products'])) { if(strlen($_SESSION['hidden_products']) > 1) { $prefix = ""; if(stristr($query, " ".TABLE_PRODUCTS." p")) { $prefix = "p."; } $shp = " where ".$prefix."products_id not in (".mysql_real_escape_string($_SESSION['hidden_products']).")"; if(substr($query, 0, 8) == 'describe') { //do not modify query } else if(stristr($query, " where ")) { $query = str_ireplace(" where ", $shp." and ", $query); } else { $query .= $shp; } } } if(stristr($query, ' '.TABLE_CATEGORIES.' ') && !strstr($query, ' shp.categories_id ') && isset($_SESSION['hidden_categories'])) { if(strlen($_SESSION['hidden_categories']) > 1) { $prefix = ""; if(stristr($query, " ".TABLE_CATEGORIES." c")) { $prefix = "c."; } $shp = " where ".$prefix."categories_id not in (".mysql_real_escape_string($_SESSION['hidden_categories']).")"; if(substr($query, 0, 8) == 'describe') { //do not modify query } else if(stristr($query, " where ")) { $query = str_ireplace(" where ", $shp." and ", $query); } else { $query .= $shp; } } } //END SHP bye riccardo
  14. rikic

    Simply Hide Products (SHP)

    hi Lorraine, I have the same problem. the problem (but I don't have the solution.... :( ) is in includes/functions/general.php in part part of code: //Simply Hide Products (SHP) function tep_set_hidden_products($force_recheck = false){ $recheck_time_seconds = 100; if(!isset($_SESSION['hidden_products_timestamp']) || !isset($_SESSION['hidden_products'])) { $force_recheck = true; } if($force_recheck || $_SESSION['hidden_products_timestamp'] < time()) { if(!$force_recheck) { $check_query = tep_db_query("SELECT unixtime FROM hidden_products WHERE unixtime > ".((int)$_SESSION['hidden_products_timestamp'] - $recheck_time_seconds)); if (tep_db_num_rows($check_query) == 0) { $_SESSION['hidden_products_timestamp'] = time() + $recheck_time_seconds; return; } else if (USE_CACHE == 'true') { if ($dir = @opendir(DIR_FS_CACHE)) { while ($cache_file = readdir($dir)) { if (stristr($cache_file, 'categories_box-')) { @unlink(DIR_FS_CACHE . $cache_file); } } closedir($dir); } } } $hidden_products_timestamp = time() + $recheck_time_seconds; if(!tep_session_is_registered('hidden_products') || !tep_session_is_registered('hidden_categories') || !tep_session_is_registered('hidden_products_timestamp')) { tep_session_register('hidden_products'); tep_session_register('hidden_categories'); tep_session_register('hidden_products_timestamp'); } //find hidden products if(isset($_SESSION['customer_id']) && !empty($_SESSION['customer_id'])) { $shp_cust_where = " WHERE products_id NOT IN (SELECT products_id FROM hidden_products WHERE customers_id = '" . (int) $_SESSION['customer_id']."')"; $shp_cat_where = " AND categories_id NOT IN (SELECT categories_id FROM hidden_products WHERE customers_id = '" . (int) $_SESSION['customer_id']."')"; } $check_query = tep_db_query("SELECT DISTINCT products_id FROM hidden_products ".$shp_cust_where); $has_hidden_categories = false; $hidden_categories = "0"; $hidden_products = "0"; if (tep_db_num_rows($check_query) > 0) { while($h_prods = tep_db_fetch_array($check_query)) { if($h_prods['products_id'] == '0') { $has_hidden_categories = true; continue; } $hidden_products .= $h_prods['products_id'].', '; } if($hidden_products != "0") { if(substr($hidden_products, 0, 1) == '0') { $hidden_products = substr($hidden_products, 1); } $hidden_products = substr($hidden_products, 0, -2); //find hidden categories $check_cats_query = tep_db_query("SELECT DISTINCT shp.categories_id FROM ".TABLE_CATEGORIES." shp WHERE shp.categories_id > 0 AND shp.categories_id NOT IN (SELECT categories_id FROM ".TABLE_PRODUCTS_TO_CATEGORIES." WHERE products_id NOT IN (".$hidden_products.")) AND shp.categories_id IN (SELECT categories_id FROM ".TABLE_PRODUCTS_TO_CATEGORIES.")"); if (tep_db_num_rows($check_cats_query) > 0) { while($h_cats = tep_db_fetch_array($check_cats_query)) { $hidden_categories .= $h_cats['categories_id'].", "; } $hidden_categories = substr($hidden_categories, 1, -2); } } } //find hidden categories and also all products in there if($has_hidden_categories){ $check_query = tep_db_query("SELECT DISTINCT shp.categories_id FROM hidden_products shp WHERE shp.categories_id > 0 ".$shp_cat_where); $all_categories_temp = ""; while(tep_db_num_rows($check_query) > 0) { $hidden_categories_temp = ""; while($h_prods = tep_db_fetch_array($check_query)) { $hidden_categories_temp .= $h_prods['categories_id'].", "; } $all_categories_temp .= $hidden_categories_temp; $check_query = tep_db_query("SELECT DISTINCT shp.categories_id FROM ".TABLE_CATEGORIES." shp WHERE shp.parent_id IN (".substr($hidden_categories_temp, 0, -2).")"); } if($all_categories_temp != "") { $all_categories_temp = substr($all_categories_temp, 0, -2); if($hidden_categories == '0') { $hidden_categories = $all_categories_temp; } else { $hidden_categories .= ", ".$all_categories_temp; } $check_query = tep_db_query("SELECT DISTINCT shp.products_id FROM ".TABLE_PRODUCTS." shp WHERE shp.products_id NOT IN (".$hidden_products.") AND shp.products_status = '1' AND shp.products_id IN (SELECT products_id FROM ".TABLE_PRODUCTS_TO_CATEGORIES." WHERE categories_id IN (".$all_categories_temp."))"); if (tep_db_num_rows($check_query) > 0){ if($hidden_products != "0") { $hidden_products .= ", "; } else { $hidden_products = ""; } while($h_prods = tep_db_fetch_array($check_query)) { $hidden_products .= $h_prods['products_id'].", "; } $hidden_products = substr($hidden_products, 0, -2); } } } $_SESSION['hidden_products'] = $hidden_products; $_SESSION['hidden_categories'] = $hidden_categories; $_SESSION['hidden_products_timestamp'] = $hidden_products_timestamp; } } where in this 2 queries appears two times the clauses where $check_cats_query = tep_db_query("SELECT DISTINCT shp.categories_id FROM ".TABLE_CATEGORIES." shp WHERE shp.categories_id > 0 AND shp.categories_id NOT IN (SELECT categories_id FROM ".TABLE_PRODUCTS_TO_CATEGORIES." WHERE products_id NOT IN (".$hidden_products.")) AND shp.categories_id IN (SELECT categories_id FROM ".TABLE_PRODUCTS_TO_CATEGORIES.")"); $check_query = tep_db_query("SELECT DISTINCT shp.products_id FROM ".TABLE_PRODUCTS." shp WHERE shp.products_id NOT IN (".$hidden_products.") AND shp.products_status = '1' AND shp.products_id IN (SELECT products_id FROM ".TABLE_PRODUCTS_TO_CATEGORIES." WHERE categories_id IN (".$all_categories_temp."))"); I'm not a coder, please tell me if you find how to solve it. bye riccardo
  15. rikic

    Simply Hide Products (SHP)

    hi pronux and thank you very much for your contribution. I'm trying to install it on my website which runs with 2.3.3 but in catalog/admin/categories.php I cannot find this part of code: while (list($key, $value) = each($HTTP_POST_VARS)) { if (!is_array($HTTP_POST_VARS[$key])) { echo tep_draw_hidden_field($key, htmlspecialchars(stripslashes($value))); } what can i do? thank y ou very much. riccardo
  16. rikic

    Simply Hide Products (SHP)

    HI pronux and thank you very much for your contribution. I'm trying to install it on my web site which runs with 2.3.3 but I cannot find in catalog/admin/categories.php this part of code while (list($key, $value) = each($HTTP_POST_VARS)) { if (!is_array($HTTP_POST_VARS[$key])) { echo tep_draw_hidden_field($key, htmlspecialchars(stripslashes($value))); } what can I do? thank you very much Riccardo
  17. rikic

    Skip Payments Page - Support Page

    HI Geoffrey, thank you for your answer. I've tried to insert the code you pasted but it seems doesn't work (I've changed cart total to $cart_total, I don't if it's right but I'm quite dummy...) and it doesn't work. I've also tried to search in the forum for allow zero value order wwithout finding a good answer (by the way, your guide is really helpful!). any idea? thank you a lot. riccardo
  18. rikic

    Skip Payments Page - Support Page

    hi! thank you for your contribution but I have a little problem with it. If I insert a free product (price = 0,00 €), checkout_payment.php page reporto this error: Fatal error: Call to a member function selection() on a non-object in /web/htdocs/www.dinamo-italia.it/home/checkout_payment.php on line 74 where line 74 is: $payment_select = $payment_modules->selection(); do you know why and I can solve it? thank you very much riccardo
  19. hi guys! I think I've found the solution. If someone could be interested, in module paypal_standard.php you have to change function update_status() to: function update_status() { global $order; if ( ($this->enabled == true) && ((int)MODULE_PAYMENT_PAYPAL_STANDARD_ZONE > 0) ) { $check_flag = false; $check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_PAYMENT_PAYPAL_STANDARD_ZONE . "' and zone_country_id = '" . $order->billing['country']['id'] . "' order by zone_id"); while ($check = tep_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->billing['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } // disable the module if the order only contains item out of stock if ($this->enabled == true) { for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { $stock_left_prod = tep_get_products_stock($order->products[$i]['id']) - $order->products[$i]['qty']; if (($stock_left_prod < 0) && (STOCK_ALLOW_CHECKOUT == 'true')) { $this->enabled = false; } } } } I've checked it with Firefox, IE and Chrome and it seems is working. bye riccardo
  20. Hi to everybody! We are working on 2.3.3 and we use 3 payment method: Cod, Paypal with standard module and bank transfert. when the item is "out of stock" and with "stock_allow_checkout" is true, I'd like to disable the Paypal payment in checkout_payment.php page, enabling payments only with Cod and banck transfert. Anyone know how I can solve it? I'm not such an expert, sorry... Trying to solve my problem, in module paypal_standard.php I've changed this code function update_status() { global $order; if ( ($this->enabled == true) && ((int)MODULE_PAYMENT_PAYPAL_STANDARD_ZONE > 0) ) { $check_flag = false; $check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_PAYMENT_PAYPAL_STANDARD_ZONE . "' and zone_country_id = '" . $order->billing['country']['id'] . "' order by zone_id"); while ($check = tep_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->billing['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } } to function update_status() { global $order; if ( ($this->enabled == true) && ((int)MODULE_PAYMENT_PAYPAL_STANDARD_ZONE > 0) ) { $check_flag = false; $check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_PAYMENT_PAYPAL_STANDARD_ZONE . "' and zone_country_id = '" . $order->billing['country']['id'] . "' order by zone_id"); while ($check = tep_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->billing['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } // disable the module if the order only contains items out of stock if ($this->enabled == true) { if (STOCK_ALLOW_CHECKOUT == 'true') { if ($order->products[$i]['qty'] < 1) { $this->enabled = false; } } } } but it doesn't is working..... I also tried with function update_status() { global $order; if ( ($this->enabled == true) && ((int)MODULE_PAYMENT_PAYPAL_STANDARD_ZONE > 0) ) { $check_flag = false; $check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_PAYMENT_PAYPAL_STANDARD_ZONE . "' and zone_country_id = '" . $order->billing['country']['id'] . "' order by zone_id"); while ($check = tep_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->billing['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } // disable the module if the order only contains items out of stock if ($this->enabled == true) { if (STOCK_ALLOW_CHECKOUT == 'true') { $stock_left = $stock_values['products_quantity'] - $order->products[$i]['qty']; if ($stock_left < 1) { $this->enabled = false; } } } } but it doesn't work neather.... is there someone that can help me? thank you very much Riccardo
  21. rikic

    Shipping in cart

    hi! thank you very much for your great contribution! I've a little problem that I can't understand how to resolve. The total cost it's regulary calculated, but it show a wrong shipping cost, actually it always show a cost of 21€.... for example, with real shipping cost of 10 euros, it show me: shipping cost: € 21 sub-total: € 100 total: € 110 do you have any idea? where I'm wrong? thank you very much Riccardo
  22. hi to everybody and thank you very much for your great job jetta! I've installed the contribution and it seems working great. I'd like to do some changes but I don't get them: 1 - I'd to pass directy from shopping cart to checkout page, including the account modules inside. it will reduce the numbers of click in the buying process. Someone know how to do that? 2 - when I add some item product in checkuot page and the "out of stock" error appears, it doesn't write the "out_of_stock_cant_checkout" message. how I can fix it? 3 - clicking on the buttons, the text is trasformed in uppercase style. how I can change it? I don't want to trasform it. thank you very much! riccardo
  23. rikic

    [Addon} Modular SEO Header Tags

    hi jim,in database the configuration_value is correctly "it". I don't know either what's the problem... I'll keep on investigating. maybe it's a conflict with another modules or add-on installed. thank you riccardo
  24. rikic

    [Addon} Modular SEO Header Tags

    actually I didn't delete the english language in Admin, I've just changed the italian as the default one. I've unistalled english language only in my web page. I've installed the modules after making this change. thank you riccardo
  25. rikic

    [Addon} Modular SEO Header Tags

    hi jim! just for understand and tring to debug my problem. I've disinstalled english language (I don't need for the monent) and installing MSHT i've only renamed the directories "english" as "italian". does it have something to do? is there a default setup that use the code for english language? thank you riccardo
×