Jump to content

rikic

Members
  • Content count

    30
  • Joined

  • Last visited

  • Days Won

    2

rikic last won the day on September 2 2013

rikic had the most liked content!

1 Follower

About rikic

  • Birthday 08/04/1968

Profile Information

  • Real Name
    riccardo
  • Gender
    Male
  • Location
    Rome
  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
×