Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

dvale

Pioneers
  • Posts

    63
  • Joined

  • Last visited

Everything posted by dvale

  1. There is now a smart way to set special characters of filters over db table specification_filter_aliasses catalog/includes/modules/products_filter.php /////////////FIND///////////// $filters_select_array[$filter_index] = array ('id' => ($filter_id), 'text' => $filter_text, 'count' => $count ); $filter_index++; /////////////PLACE BEFORE///////////// $needles = array('slash', 'inch', 'comma'); $haystack = array('/', '"', ','); $filter_text = str_replace($needles, $haystack, $filter_text); /////////////So it looks like this///////////// $needles = array('slash', 'inch', 'comma'); $haystack = array('/', '"', ','); $filter_text = str_replace($needles, $haystack, $filter_text); //str_replace($needles, $replacements, $string); $filters_select_array[$filter_index] = array ('id' => ($filter_id), 'text' => $filter_text, 'count' => $count ); $filter_index++; So now you can replace special characters with keywords in this way: / = slash " = inch , = comma ...and so on, depending of your need. For example to type: 3/4" ...now you type: 3slash4inch In this way the filters and values are set with keywords allowing the proper display of the Special Characters. Live example here https://www.shopperstation.com/auto_parts/index.php?cPath=3_12 Full credit to Henry Withoot Donations will be accepted through PayPal [email protected] Regards, Paul
  2. I can't rewrite the code since I don't know how. I'm just a curious person that can pull the logic around. I thought that since you are the add on creator, you might see the advantage of the change and perhaps you could know faster than anybody else where to rewrite the code. I know someone that can rewrite the code but at a price. And he is actually thinking about create an add on for the filters only, without the other features products specifications add on have. I'm looking forward for your advice. Regards, Paul
  3. Healthy question about the problem with the filters special characters. Why not load the filter results by id instead of using the text content or name of filters and values ???? Why make all that code to sanitize ^%$#@#Q ................ if just tell spec1_id=4&spec7_id=56 etc etc ?? If have 5 products containing spec1_id=4 and spec7_id=56 ... show them after can filter for other specX_id=XX // Decode the URL-encoded names, including arrays $$var = tep_decode_recursive ($_GET[$var]); // Sanitize variables to prevent hacking $$var = tep_clean_get__recursive ($$var); Regards, Paul
  4. Special characters for the filters /"!*$+& etc................. I checked pages behind as you suggested. I didn't find the solution. Any updates for this little glitch ? Regards, Paul
  5. Full credit to Henry Withoot for fixing this bug. admin/categories.php Find : '" . (int) $specifications['specification_description_id'] . "', Replace for: '" . (int)$specifications['specifications_id'] . "', Thank you Henry Withoot for you help on this one. Regards, Paul
  6. I don't have a demo site, but I will get it done for you to test on it. Regards, Paul
  7. Thanks Jim. I'll be waiting for your posting about the bug in the copy feature. Are you part of Support Forum Sponsorships service? I was trying to subscribe to the Community Sponsorship but there is a problem with the currency. There is an option to change currency but doesn't keep the selection once you step in the next page. Any suggestion ? Regards, Paul
  8. Hello. I just need to know if is me with the issue that the filter specifications are not duplicating as the rest of the data when duplicate a product in the admin. I'm being trying to turn this in the right way but my lack of time is not helping. Does anybody have this problem? I really would like to know how to fix it. Regards, Paul
  9. Just to make sure we are in the same page. I'm using the filters ONLY. I already have the tab_descriptions installed in my website so I'm not using the tabs provided with the module. products_tab_1, products_tab_2, products_tab_3, products_tab_4, products_tab_5, products_tab_6, take a look: https://www.shopperstation.com/games-c-4_5_6/?language=en So when I duplicate a product, everything gets duplicate fine except for the filter selections and creates the problem described above in the database. What I'm doing right now is deleting manually the database entries created when duplicate a product. I guess until I figure how to duplicate everything properly. Regards, Vale
  10. I was looking at the code and I don't see any code provided for the specifications here. case 'copy_to_confirm': if (isset($HTTP_POST_VARS['products_id']) && isset($HTTP_POST_VARS['categories_id'])) { $products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']); $categories_id = tep_db_prepare_input($HTTP_POST_VARS['categories_id']); if ($HTTP_POST_VARS['copy_as'] == 'link') { if ($categories_id != $current_category_id) { $check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$products_id . "' and categories_id = '" . (int)$categories_id . "'"); $check = tep_db_fetch_array($check_query); if ($check['total'] < '1') { tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$products_id . "', '" . (int)$categories_id . "')"); } } else { $messageStack->add_session(ERROR_CANNOT_LINK_TO_SAME_CATEGORY, 'error'); } } elseif ($HTTP_POST_VARS['copy_as'] == 'duplicate') { $product_query = tep_db_query("select products_extra_charge, products_quantity, products_model, products_image, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); $product = tep_db_fetch_array($product_query); tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model, products_extra_charge, products_image, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . tep_db_input($product['products_extra_charge']) . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_price']) . "', now(), " . (empty($product['products_date_available']) ? "null" : "'" . tep_db_input($product['products_date_available']) . "'") . ", '" . tep_db_input($product['products_weight']) . "', '0', '" . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id'] . "')"); $dup_products_id = tep_db_insert_id(); Should I add the products_specifications line between the existing lines.............like this $product_query = tep_db_query("select products_extra_charge, products_specifications, products_quantity, products_model, products_image, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); $product = tep_db_fetch_array($product_query); tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_specifications, products_model, products_extra_charge, products_image, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . tep_db_input($product['products_extra_charge']) . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_price']) . "', now(), " . (empty($product['products_date_available']) ? "null" : "'" . tep_db_input($product['products_date_available']) . "'") . ", '" . tep_db_input($product['products_weight']) . "', '0', '" . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id'] . "')");
  11. Maybe if you point me in the right direction I can play around with the problem. Regards, Vale
  12. Thanks Jim, we highly appreciate the time and effort you dedicate. Regards, dvale
  13. I just installed this great contribution and is working fine. But I noticed something on the data base after Duplicate Product in admin. As you know duplicate a product is a fast way to insert similar products. Once you do this, the module duplicates, (as many times you duplicate the product), all the entries in the db defining the specifications_id as 0 for all the extra unnecessary rows and columns. This is not affecting the functionality of the module but it creates a huge unwanted extra data information in the data base. Any suggestion?
  14. Version 0.0 umm ? This promise to be a great contribution, but I bet it will take around 10 versions including 2 + 3 years of pages in the forum to finally make work fine, as everything else. Hope doesn’t take that long.
  15. THANK YOU for nothing. I solved the puzzle by myself after two weeks scratching my head to death.
  16. I would've like too see your post 3 weeks ago? lol…..as you said, I spend an age scratching my head. Thanks for the simple solution of my nightmare.
  17. Hello to all. I’ve been trying so hard to set the logic around a code for the Actual Price adjustment of the QTPro contribution. Version installed. 4.6.1 It’s very, very important to me to display just ONLY the Actual Price FROM THE ATTRIBUTE PRICE, like the old time Actual Price without QTPro installed. When I set to “true” the “Actual Price Pull Downs” in the admin, it will display not just the Attribute price as I wanted, but the MAIN PRICE of the product at the end of every option in place in the catalog. That’s suppose to be alright because there is a red note that sais: “This can only be used with a satisfying result if you have only one option per product” In my case I use many options per product and that’s why I need so much your help to code what’s necessary to make it happen. Examples (Assuming I'm using multiple dropdowns): Price: $175.00 Options set to "default" ....and is the selection I don't like :( COLOR: ..................Black COLOR: ..................White COLOR: ..................Pink CONDITION: ............New CONDITION: ............Refu ...(-$10.00) Options set to "true" ....and is the selection I hate :angry: COLOR: ..................Black.....$175.00 COLOR: ..................White.....$175.00 COLOR: ..................Pink.......$175.00 CONDITION: ............New.......$175.00 CONDITION: ............Refu .....$165.00 Options set to "I don't know how" ....and is the selection I want :) COLOR: ..................Black COLOR: ..................White COLOR: ..................Pink CONDITION: ............New CONDITION: ............Refu .....$165.00 Regards, Paul
  18. Hello to all. I’ve been trying so hard to set the logic around a code for the Actual Price adjustment of the QTPro contribution. Version installed. 4.6.1 It’s very, very important to me to display just ONLY the Actual Price FROM THE ATTRIBUTE PRICE, like the old time Actual Price without QTPro installed. When I set to “true” the “Actual Price Pull Downs” in the admin, it will display not just the Attribute price as I wanted, but the MAIN PRICE of the product at the end of every option in place in the catalog. That’s suppose to be alright because there is a red note that sais: “This can only be used with a satisfying result if you have only one option per product” In my case I use many options per product and that’s why I need so much your help to code what’s necessary to make it happen. Examples (Assuming I'm using multiple dropdowns): Price: $175.00 Options set to "default" ....and is the selection I don't like :( COLOR: ..................Black COLOR: ..................White COLOR: ..................Pink CONDITION: ............New CONDITION: ............Refu ...(-$10.00) Options set to "true" ....and is the selection I hate :angry: COLOR: ..................Black.....$175.00 COLOR: ..................White.....$175.00 COLOR: ..................Pink.......$175.00 CONDITION: ............New.......$175.00 CONDITION: ............Refu .....$165.00 Options set to "I don't know how" ....and is the selection I want :) COLOR: ..................Black COLOR: ..................White COLOR: ..................Pink CONDITION: ............New CONDITION: ............Refu .....$165.00 Regards, Paul
  19. Hello to all. I’ve been trying so hard to set the logic around a code for the Actual Price adjustment of the QTPro contribution. Version installed. 4.6.1 It’s very, very important to me to display just ONLY the Actual Price FROM THE ATTRIBUTE PRICE, like the old time Actual Price without QTPro installed. When I set to “true” the “Actual Price Pull Downs” in the admin, it will display not just the Attribute price as I wanted, but the MAIN PRICE of the product at the end of every option in place in the catalog. That’s suppose to be alright because there is a red note that sais: “This can only be used with a satisfying result if you have only one option per product” In my case I use many options per product and that’s why I need so much your help to code what’s necessary to make it happen. Regards, Paul
  20. I really need to adjust something at the Actual Price Pull Downs option in the admin. I know there is a note that sais that is recommended for one option per product, but I’m actually using more than one option per product and that truly looks bad with all those repeated prices. I don’t want that. I need the old time Actual Price way, that displays ONLY the price changes made in the attribute section, not the main price at ALL options. Can this be done? It will be really appreciated.
  21. Hello Jim. I've read the entire topic and I couldn’t find any problem solved related to translation in the product_description_insert mudule. In my case, two languages, English as the main language, and Spanish as second. I’m inserting the description manually for both English and Spanish. After saving, looks fine in DB and source meta tag page. When I'm attempting to edit the product in admin, it changes the Spanish description to the default English description, making me re-type the Spanish description manually before saving. In the case you suggest me to use the product_description instead of the product_decription_insert, I can tell you that I cannot use that module because I use several HTML coding before the description that gets in the way pretty bad. Regards, Paul
  22. I didn’t make any changes to the categories.php file. All I know is that file came with three different lines which are: // Modular SEO Header Tags include( DIR_WS_MODULES . 'header_tags/categories_products_process.php' ); // Modular SEO Header Tags include( DIR_WS_MODULES . 'header_tags/products_insert.php' ); // Modular SEO Header Tags include( DIR_WS_MODULES . 'header_tags/categories_insert.php' ); If I have to make any changes in that file, I will appreciate so much if you tell me what should I get there. Once again, thank you very much for your help.
  23. I’m not a PHP expert and I need your good will to help me out with an issue I got with the Header Tags Seo. I did install the Header Tags contribution from osCommerce Solution and everything is very fine. Just one little problem that I know can be solve easily. I’m using the Product Description –Insert and the Product Keywords – Insert at the admin/Modules/Header Tags. As you know, both fields are available for me to type the description and keywords manually for the product in the admin content. When I type the description and keywords in their corresponding fields and save, only the description is recorded but the keywords isn’t. The keywords insert field returns BLANK as you never wrote anything there. The only way to record the keywords content is doing it manually in the MySQL data base, by the “products_description/head_keywords” value, and that is what I’m being doing since I installed the contribution. I think it’s time for me to fix the issue to focus on the admin content only. I checked every corner in the uploaded files and I couldn’t find anything wrong. My only option is trying find an answer here. I will appreciate your help.
×
×
  • Create New...