Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

JSR

Pioneers
  • Posts

    149
  • Joined

  • Last visited

Profile Information

  • Real Name
    Chanel
  • Gender
    Female
  • Location
    Planet Earth

JSR's Achievements

  1. Hi Jim, I suspect I was previously posting in the wrong thread, my appologies! I'd like to know if the checkboxes are supposed to remain unchecked after the form has been submitted. It seems to me they're supposed to stay checked, but that's not the case. I found a bit of code in that relates to this issue, but it's based on an older version of the contribution. How do I keep the checkboxes checked after form submission with the last version of the contribution?
  2. Thanks for the fast reply and insight! I thought it would be possible to either store the previous selected value in a session or redirecting the page and saving the "get" variables after submission. By searching the web I found several fora addressing this issue (saving selected checkboxes in php forms after submit). But my knowledge of php is pretty limited, so guess I'll have to stick with the submit button for now. :wacko:
  3. Hi kymation, I have a question about values as checkboxes. I added onClick for the checkboxes, but it only passes one value as link data at a time. I know I probably need to edit the tep_draw_pull_down_menu funtcion in html_output.php but I get stuck trying. How do I keep the selected value in the link data? I Hope you understand what I'm trying to do here...
  4. Hi Spooks, I've installed the contribution and was dealing with the same issue in IE8. I've tried adding the IE7 emulate code, but this didn't make a difference. The tooltip image still appeared behind the next main product thumb. I wanted the tooltip image to appear in exactly the same place as the main thumb because I'm using it swap the main thumb with another/additional product image. Mainly because I added adding left:0; to span.ttip a:hover img.large in page-header-inc.htc, the IE8 issue was fixed. I removed the if IE7 css bit....
  5. I'm experiencing the same thing in IE8, but I have noticed a pattern! When I load the page the borders are broken... When I hover over the page results OR choose to view all products the borders magically reappear! :huh:
  6. Ok ppl, so I contacted my host and the openbase restriction warning is finally solved now! Change line 178: if((!is_dir($file) && strtolower(substr($file, -4, 4)) === ".php") && !in_array($file ,$excluded_array)) TO: if(($file != "..") && (!is_dir($file) && strtolower(substr($file, -4, 4)) === ".php") && !in_array($file ,$excluded_array)) This should stop the code from trying to access the tmp directory that's located outside of the root.
  7. I'm getting the "openbase restriction is in effect" warning too. Strange thing though, the path also reads /var/www/vhosts/domain/httpdocs:/tmp but the : is not supposed to be there, right?? Has anyone else experienced this before?
  8. I've added this contribution because I also need an in/out of stock filter for sold products. I removed the category/manufacturer filter because it had the in stock filter only showing in certain instances and I want to have it in the top categories as well as the subs. So my code for the filter in index.php currently looks like this: if (isset($HTTP_GET_VARS['instock'])) { $listing_sql .= " and p.products_quantity > 0"; }else{ $listing_sql = $listing_sql; } if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) { for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { if ($column_list[$i] == 'PRODUCT_LIST_MANUFACTURER') { $HTTP_GET_VARS['sort'] = 'd'; $listing_sql .= " order by p.products_date_added desc"; break; } } } else { $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1); $sort_order = substr($HTTP_GET_VARS['sort'], 1); $listing_sql .= ' order by '; switch ($column_list[$sort_col-1]) { case 'PRODUCT_LIST_MODEL': $listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER': $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': $listing_sql .= "p.manufacturers_id"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } ?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="5"> <tr> <td align="left"><?php echo $breadcrumb->trail(' » '); ?></td> <?php // optional Product List Filter if (PRODUCT_LIST_FILTER > 0) { if (($HTTP_GET_VARS['cPath']) || ($HTTP_GET_VARS['manufacturers_id'])) { $filterlist_sql = "select p.products_carrot, p.products_id, p.manufacturers_id, pd.products_name, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((" . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p) left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_carrot = '0' and p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and " . $cat_Search . ""; } else { $filterlist_sql= "select p.products_carrot, p.products_id, p.manufacturers_id, pd.products_name, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_carrot = '0' and p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; } $filterlist_query = tep_db_query($filterlist_sql); if (tep_db_num_rows($filterlist_query) > 0) { echo ' <td align="center" class="SmallText2"><b>' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . ' '; echo tep_draw_checkbox_field('instock', 1, false, 'onClick="this.form.submit()"') . HEADER_INSTOCK . '</b></td>' . "\n"; }else{ echo tep_draw_checkbox_field('instock', 0, true, 'onClick="this.form.submit()"') . HEADER_OUT_OF_STOCK . '</b></td>' . "\n"; echo tep_hide_session_id() . '</form></td></tr>' . "\n"; } } Now one of the problems I'm having is that when you select this filter on say page 2 of a category, it redirects to the default page/ home page. Also, once a customer chooses to hide out of stock items, there is no switch to turn the filter off either. I've tried to have add that option, but it's not working. Can anyone (who actually knows what they're doing, cause I definitely don't :lol: ) please have a look at the code and explain what's causing these issues?
  9. Problem solved now. Re-uploading the images didn't work, but what does work is renaming them before uploading... :blink:
  10. I have not yet found the right sql query to achieve this so any help would be immensely appreciated... Anyone? Pls? :blush:
  11. Sorry, I forgot to mention that I have already changed the image length to 255 in the database... :rolleyes: And I have another question too: Are the additional images always supposed to be deleted when you remove a product? I have several linked products and when deleting in one category, it naturally deletes the AI for the same product linked in a different category. Which means you have to keep uploading them...
  12. Hi everyone, I finally upgraded to the latest version of additional image successfully but I've noticed something very weird. Some of the additional images disappear. I noticed that the last letter is missing from the image name, for example image name is "coat.jpg" but when I check the image properties it says "coa.jpg". I really don't know what's going on. Does anyone have a clue about what could possibly be causing this?
  13. I've been trying to include the manufacturers name in the manufacturers2 product listing. Does anyone know how to achieve this?
  14. Hi all, I've installed dynamic sitemap and I'm getting an "openbase restriction is in effect" warning on the catalog side. Seems the script is trying to access the tmp dir, which is in the root of my store. The warning states however, that it's not within the allowed path (/var/www/vhosts/domain/httpdocs:/tmp). Has anybody seen this before?
  15. I got it: $from_str = "from ((" . TABLE_PRODUCTS . " p) left join (" . TABLE_MANUFACTURERS . " m) USING(manufacturers_id) left join (" . TABLE_MANUFACTURERS3 . " m3) USING(manufacturers3_id) left join (" . TABLE_MANUFACTURERS4 . " m4) USING(manufacturers4_id)) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id"; This way it includes all the manufacturers in a search query on quick_search.php
×
×
  • Create New...