brchalla Posted January 30, 2014 Share Posted January 30, 2014 i encoded here in categories.php page in <tr> <td class="main" valign="top"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?> </td> <td class="main"><?php echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (isset($products_description[$languages[$i]['id']]) ? htmlspecialchars_decode($products_description[$languages[$i]['id']]) : tep_get_products_description($pInfo->products_id, $languages[$i]['id']))); ?></td> </tr> i checked in query also i am unable to find it please help where to encode it to escape from special characters Quote Link to comment Share on other sites More sharing options...
lbdublb Posted January 30, 2014 Share Posted January 30, 2014 Hi Jim! Thanks for your great contrib! At first: I cannot find catalog/includes/boxes/products_filter.php in your package V1.11 Second: I do not get the tabs in the right format...just a list: http://www.flipflopper.de/product_info.php?cPath=34_46&products_id=101&language=en Thanks for your help! Quote Link to comment Share on other sites More sharing options...
♥kymation Posted January 30, 2014 Author Share Posted January 30, 2014 1. That file has passed on! It is no more! It has ceased to be! It's expired and gone to ... catalog/includes/modules/boxes/products_filter.php. Oh, and that one has a known formatting bug. If you want to use it, look up in this thread a bit for the posted fix. 2. That's a bug in jQuery. There's a patch for that back a page or two. I really need to package up all of these changes and make a new release. Someday.... Regards Jim Quote See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
♥kymation Posted January 30, 2014 Author Share Posted January 30, 2014 (edited) oops ... please ignore. Edited January 30, 2014 by kymation Quote See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
brchalla Posted January 31, 2014 Share Posted January 31, 2014 @@kymation thank you for this addon i fixed that issue(escaping form special characters) check my shop(http://2ml.org/deals/) for comparison of products i am not getting any button to compare? Quote Link to comment Share on other sites More sharing options...
♥kymation Posted January 31, 2014 Author Share Posted January 31, 2014 It looks like you are using a template. The proper placement of the code may be different than for stock osC, or it may need to be in a different file altogether. The code is normally in index.php: // Start Product Specifications // Check the number of products is above the minimum for the comparison table $check_query_raw = "select distinct p2c.products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_SPECIFICATION_GROUPS . " sg, " . TABLE_SPECIFICATIONS_TO_CATEGORIES . " sg2c where sg.show_comparison = 'True' and sg.specification_group_id = sg2c.specification_group_id and p2c.categories_id = sg2c.categories_id and sg2c.categories_id = '" . (int) $current_category_id . "' "; // print $check_query_raw . "<br>\n"; $check_query = tep_db_query ($check_query_raw); $show_comparison = SPECIFICATIONS_MINIMUM_COMPARISON <= tep_db_num_rows ($check_query); if (SPECIFICATIONS_BOX_COMP_INDEX == 'False' && SPECIFICATIONS_COMP_LINK == 'True' && $current_category_id != 0 && $show_comparison == true && tep_has_spec_group ($current_category_id, 'show_comparison') == true) { echo ' <td align="center"><a href="' . tep_href_link (FILENAME_COMPARISON, 'cPath=' . $cPath) . '">' . tep_image_button ('button_products_comparison.gif', TEXT_BUTTON_COMPARISON) . '</a></td>' . "\n"; } // if (SPECIFICATIONS_BOX_COMP_INDEX // End Product Specifications Also note that this code requires the proper value for $current_category_id. It will not work if that value is not set or if it is set to zero. Regards Jim Quote See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
brchalla Posted January 31, 2014 Share Posted January 31, 2014 okay jim thank you Quote Link to comment Share on other sites More sharing options...
lbdublb Posted January 31, 2014 Share Posted January 31, 2014 1. That file has passed on! It is no more! It has ceased to be! It's expired and gone to ... catalog/includes/modules/boxes/products_filter.php. Oh, and that one has a known formatting bug. If you want to use it, look up in this thread a bit for the posted fix. 2. That's a bug in jQuery. There's a patch for that back a page or two. I really need to package up all of these changes and make a new release. Someday.... Regards Jim Hi Jim, 1. There is only bm_products_filter.php in catalog/includes/modules/boxes/ and there is catalog/includes/modules/products_filter.php...is that correct? 2. I added <script type="text/javascript"> // fix jQuery base tag bug $.fn.__tabs = $.fn.tabs; $.fn.tabs = function (a, b, c, d, e, f) { var base = location.href.replace(/#.*$/, ''); $('ul>li>a[href^="#"]', this).each(function () { var href = $(this).attr('href'); $(this).attr('href', base + href); }); $(this).__tabs(a, b, c, d, e, f); }; </script> in the two includes/template_top.php, but there are no changes about the tabs behaviour... Quote Link to comment Share on other sites More sharing options...
brchalla Posted January 31, 2014 Share Posted January 31, 2014 hello @@kymation If i want to make all specifications under thier respective specification group names where should i change the code here in addon Quote Link to comment Share on other sites More sharing options...
brchalla Posted January 31, 2014 Share Posted January 31, 2014 tell a friend tab,ask ur friend tab ,reviews tab are not storing in our database these tabs are not working Quote Link to comment Share on other sites More sharing options...
brchalla Posted January 31, 2014 Share Posted January 31, 2014 @@kymation is thier any way to keep specifications under a specification group Quote Link to comment Share on other sites More sharing options...
♥kymation Posted January 31, 2014 Author Share Posted January 31, 2014 @@lbdublb 1. Right. the file in catalog/includes/modules/boxes/ is the filters box to go in the left/right column, and the one in catalog/includes/modules/ is the equivalent that goes in the center column. 2. That should fix the jQuery bug. Check that all of your jQuery files are in place and being called correctly in the head section of the page, and that the Javascript that invokes the tabs is present on the page. @@brchalla All specifications are in a Specification Group. Apparently I don't understand the question. Please explain. If the data is stored in the database but is not being displayed, there is a problem in the products_info.php or in one of the included files. I don't know where the error is. Check all of your edits again, or add some debugging commands. Regards Jim Quote See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
lbdublb Posted January 31, 2014 Share Posted January 31, 2014 @@lbdublb 1. Right. the file in catalog/includes/modules/boxes/ is the filters box to go in the left/right column, and the one in catalog/includes/modules/ is the equivalent that goes in the center column. 2. That should fix the jQuery bug. Check that all of your jQuery files are in place and being called correctly in the head section of the page, and that the Javascript that invokes the tabs is present on the page. @@brchalla All specifications are in a Specification Group. Apparently I don't understand the question. Please explain. If the data is stored in the database but is not being displayed, there is a problem in the products_info.php or in one of the included files. I don't know where the error is. Check all of your edits again, or add some debugging commands. Regards Jim If you scroll down the product page, there you can see another Tab Module...that cannot be the cause, right? Quote Link to comment Share on other sites More sharing options...
♥kymation Posted January 31, 2014 Author Share Posted January 31, 2014 I used Firebug to remove the second set of tabs, but the first set still didn't work. Try moving the Javascript that is just ahead of the tabs to down below the tabs. There could be something else here that I'm just not seeing. Regards Jim Quote See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
brchalla Posted February 1, 2014 Share Posted February 1, 2014 @@kymation I will explain clearly. i created two specification groups & created some specifications in both. then i linked both specification groups to only one category .here i can all see specifications names & attributes which i have given in product info page,istead i want them to display with specification group and specification for ex: spec group1: spec1:attribut1 spec2:attrbut2 specgroup2: spec1:attribut1 spec2:attrbut2 Quote Link to comment Share on other sites More sharing options...
♥kymation Posted February 1, 2014 Author Share Posted February 1, 2014 The groups were never intended to be displayed. You can change the code in includes/modules/products_specifications from this $specifications_query_raw = "select ps.specification, s.filter_display, s.enter_values, sd.specification_name, sd.specification_prefix, sd.specification_suffix from " . TABLE_PRODUCTS_SPECIFICATIONS . " ps, " . TABLE_SPECIFICATION . " s, " . TABLE_SPECIFICATION_DESCRIPTION . " sd, " . TABLE_SPECIFICATION_GROUPS . " sg, " . TABLE_SPECIFICATIONS_TO_CATEGORIES . " sg2c where sg.show_products = 'True' and s.show_products = 'True' and s.specification_group_id = sg.specification_group_id and sg.specification_group_id = sg2c.specification_group_id and sd.specifications_id = s.specifications_id and ps.specifications_id = sd.specifications_id and sg2c.categories_id = '" . (int) $current_category_id . "' and ps.products_id = '" . (int) $_GET['products_id'] . "' and sd.language_id = '" . (int) $languages_id . "' and ps.language_id = '" . (int) $languages_id . "' order by s.specification_sort_order, sd.specification_name "; to something like this: $specifications_query_raw = "select ps.specification, s.filter_display, s.enter_values, sd.specification_name, sd.specification_prefix, sd.specification_suffix, sg.specification_group_name from " . TABLE_PRODUCTS_SPECIFICATIONS . " ps, " . TABLE_SPECIFICATION . " s, " . TABLE_SPECIFICATION_DESCRIPTION . " sd, " . TABLE_SPECIFICATION_GROUPS . " sg, " . TABLE_SPECIFICATIONS_TO_CATEGORIES . " sg2c where sg.show_products = 'True' and s.show_products = 'True' and s.specification_group_id = sg.specification_group_id and sg.specification_group_id = sg2c.specification_group_id and sd.specifications_id = s.specifications_id and ps.specifications_id = sd.specifications_id and sg2c.categories_id = '" . (int) $current_category_id . "' and ps.products_id = '" . (int) $_GET['products_id'] . "' and sd.language_id = '" . (int) $languages_id . "' and ps.language_id = '" . (int) $languages_id . "' order by sg.specification_group_name, s.specification_sort_order, sd.specification_name "; Then you can use $specifications['specification_group_name'] to display the group name. Regards Jim frankl 1 Quote See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
brchalla Posted February 1, 2014 Share Posted February 1, 2014 I have pasted the code,it is showing like : spec group1: spec1:attribut1 spec group1: spec2:attrbut2 spec group2: spec1:attribut1 spec group2: spec2:attrbut2. i have included $specifications['specification_group_name'] in includes/modules/product_specifications.php while ($specifications = tep_db_fetch_array ($specifications_query) ) { if ($specifications['specification'] != '') { $specification_text .= '<li>'; if (SPECIFICATIONS_SHOW_NAME_PRODUCTS == 'True') { $specification_text .= $specifications['specification_group_name'] . ': ' ; $specification_text .= $specifications['specification_name'] . ': '; } $specification_text .= $specifications['specification_prefix'] . ' '; please let me know where to include $specifications['specification_group_name'] to display specifications under the specification group name. like: spec group1: spec1:attribut1 spec group1: spec2:attrbut2 spec group2: spec1:attrbut1 spec group2: spec2:attrbut2 please tell me Quote Link to comment Share on other sites More sharing options...
brchalla Posted February 1, 2014 Share Posted February 1, 2014 Sorry like please let me know where to include $specifications['specification_group_name'] to display specifications under the specification group name. like: spec group1: spec1:attribut1 spec2:attrbut2 spec group2: spec1:attrbut1 spec2:attrbut2 please tell me Quote Link to comment Share on other sites More sharing options...
♥kymation Posted February 1, 2014 Author Share Posted February 1, 2014 What you want is custom code. I don't have the time to write a custom application just for you. I've given you hints and sample code to point you in the right direction. The rest is your job. Regards Jim Quote See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
brchalla Posted February 1, 2014 Share Posted February 1, 2014 @@kymation Thank you Quote Link to comment Share on other sites More sharing options...
lbdublb Posted February 2, 2014 Share Posted February 2, 2014 I used Firebug to remove the second set of tabs, but the first set still didn't work. Try moving the Javascript that is just ahead of the tabs to down below the tabs. There could be something else here that I'm just not seeing. Regards Jim Thanks! Solved! There had to be some mistake in the jquery folder files....I renewed them and now it works. How do I change the design of the tabs? I would likr to use the design of the template like the tabs below the spec tabs... Quote Link to comment Share on other sites More sharing options...
♥kymation Posted February 2, 2014 Author Share Posted February 2, 2014 The tabs use the Theme design, so use Themeroller to generate a new theme. Regards Jim Quote See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
brchalla Posted February 3, 2014 Share Posted February 3, 2014 hello @@kymation please tell me if i need to change in sql query in includes/modules/product_specifications.php. to group all specification names under specification group name tried with creating a temp array but it not worked.please let me know where i have to change code here. thyank you... Quote Link to comment Share on other sites More sharing options...
brchalla Posted February 4, 2014 Share Posted February 4, 2014 Hello @@kymation Thank you for your contribution. specifications are working fine in my shop (http://2ml.org/deals/Power-Adapter/5V1APowerSupplyAdapter5.5mm21mmPlugPin.htm). Now i have to work with comparison and filters. regards: brchalla.......... Quote Link to comment Share on other sites More sharing options...
brchalla Posted February 4, 2014 Share Posted February 4, 2014 @@kymation to add all these (specification group name ,specification name, specifications and category which is linked ) into database through excel sheet do you have any plugin because i have many specification groups .i dont want to add manually. help me if their is any addon to add all these values Thanks®ards: brchalla Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.