Jump to content

jampjamp

Members
  • Content count

    38
  • Joined

  • Last visited


Reputation Activity

  1. Like
    jampjamp got a reaction from Bobber in Old addon do not fit with osc2.3.4BS   
    @auzStar thanks for your link,
    I've done little change, because at default, your addon gets randomly any product, which means that all available products could be selected as new. So in mysql query I used the order type taken from original 'What's new' box.
    In lines 251-252 and 277-278 of bm_whats_new_scroller.php exchange:
    order by rand() to
    order by products_date_added desc Anyway very nice addon.
    I've changed also data-slides from next-prev to prev-next (lines 99-100 and 105-106), because I think it looks better, when it slides in this way, but it's only my own opinion.
  2. Like
    jampjamp reacted to raiwa in $order->info['total'] gets only sub-total + shipping, without order total modules   
    Hello Mick @jampjamp,
     
    I did some check for the issue with the order_qtpro class and found that it is not needed to include it in the header tag module, just as you stated at the beginning. It is included in checkout_process.php via qtpro_hook and all works correct like this. And yes, it is needed for stock substraction in checkout.
    So I uploaded a new version 5.5 where these lines are removed in ht_qtpro_stock_check.php and no additional modifications are needed in the core order class.
    If you wish to give it a try.
    rgds
    Rainer
  3. Like
    jampjamp reacted to auzStar in Old addon do not fit with osc2.3.4BS   
    Scroll Boxes (What's New and Specials) v1.7 (bootstrap) has been added to the add-on
    (non-bootstrap version is unchanged, still v1.3)

    CHANGES IN BOOTSTRAP VERSION:
    - Added new option to target products to current category, otherwise the default is storewide.
    - When "target products to current category" option is enabled the module checks to see if the "Index Nested - Product Listing" module is installed (this targets products to the current category including it's subcategories).
    - Fix issue where content inside boxes was out of alignment after recent update to jQuery to version 3.1.0 in latest osCommerce BS EDGE. (slight modification to scrolling scripts required)
    - jQuery Mobile Javascript (catalog\ext\jquery\jquery.mobile.custom.min.js) file is updated to version 1.5 (previously v1.4.5). This fixed issue where swipe didn't work after recent update to jQuery to version 3.1.0 in latest osCommerce BS EDGE.

    Download:
    http://addons.oscomm.../8065#tabs-hist
     
    Demos:
    Bootstrap version
    http://www.auzcommer.../osc234bs_test/
    Non-Bootstrap version
    http://www.auzcommer...osc234/catalog/
      
    cheers
  4. Like
    jampjamp reacted to auzStar in [Addon] Category New Products Carousel for osC 2.3.4 bootstrap   
    @jampjamp
    This is not part of this package. It is another add-on called Scroll Boxes found here https://apps.oscommerce.com/mXsqv. Latest version for osC Bootstrap is 1.7
    cheers
  5. Like
    jampjamp got a reaction from raiwa in $order->info['total'] gets only sub-total + shipping, without order total modules   
    @raiwa Thanks sir, looks like everything works now :)
  6. Like
    jampjamp reacted to raiwa in $order->info['total'] gets only sub-total + shipping, without order total modules   
    @jampjamp,
     
    the importance of this is the stock substraction for qtpro stock controlled attributes.
    It would be important to know if you modified the core order class: includes/classes/order.php, if yes, you should replicate your modifications into the order_qtpro.php class
  7. Like
    jampjamp reacted to raiwa in $order->info['total'] gets only sub-total + shipping, without order total modules   
    for now you could try to merge the modifications made in the order_qtpro.php class  into the core order class and remove all instances of:
    require('includes/classes/order_qtpro.php'); $order = new order_qtpro;  
    When I have a time I'll have a deeper look. Maybe it's because your payment service manipulates the core order class. Which was the exact payment service where it happens?
  8. Like
    jampjamp reacted to raiwa in $order->info['total'] gets only sub-total + shipping, without order total modules   
    I meant to combine (add the modifications) of the qtpro cart function to the core cart function, not to add.
    I checked now and the only difference is this:
    $attributes_query = tep_db_query("select popt.products_options_name, popt.products_options_track_stock, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa where pa.products_id = '" . (int)$products[$i]['id'] . "' and pa.options_id = '" . (int)$option . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . (int)$value . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . (int)$languages_id . "' and poval.language_id = '" . (int)$languages_id . "'"); $attributes = tep_db_fetch_array($attributes_query); $this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options_name'], 'value' => $attributes['products_options_values_name'], 'option_id' => $option, 'value_id' => $value, 'prefix' => $attributes['price_prefix'], 'price' => $attributes['options_values_price'], 'track_stock' => $attributes['products_options_track_stock']); "products_options_track_stock" is added to the $attributes_query and the array.
    If you apply this modification to your core order class and remove the qtpro_order instance, all should work correct.
    I remember now, this is only needed to restock the attribute stock if an order is deleted in admin, it is not needed for the order stock substraction of attributes, sorry.
  9. Like
    jampjamp reacted to raiwa in [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo   
    @Jack_mcs, @jampjamp,
    Here the fix:
    In: includes/classes/seo_class.php:
    line 77 change:
    function ConnectDB(){ $this->link_id = mysqli_connect($this->host, $this->user, $this->pass, $this->db); if (!$this->link_id) { die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); } } # end function to:
    function ConnectDB(){ $this->link_id = mysqli_connect($this->host, $this->user, $this->pass, $this->db); mysqli_set_charset($this->link_id, 'utf8'); if (!$this->link_id) { die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); } } # end function line 1859 remove this:
    if (CHARSET == 'utf-8') { $string = iconv("ISO-8859-1", "UTF-8//TRANSLIT", $string); }  
    Example product title: Ñiçrosoft €βČčûæĂŠŤ Explorer
    Result URL:nicrosoft-essccuaeast-explorer-p-26.html
    replacement pairs: Ñ=>n,Ç=>c,ñ=>n,ç=>c,€=>e,β=>ss,Č=>c,č=>c,û=>u,æ=>ae,Ă=>a,Š=>s,Ť=>t
     
    This will only work for OsCommerce versions since 2.3.3.4, full utf-8 support.
     
    This may work for all versions (using sqli):
    function ConnectDB(){ $this->link_id = mysqli_connect($this->host, $this->user, $this->pass, $this->db); if (CHARSET == 'utf-8') mysqli_set_charset($this->link_id, 'utf8'); if (!$this->link_id) { die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); } } # end function if (CHARSET != 'utf-8') { $string = iconv(CHARSET, "UTF-8//TRANSLIT", $string); } rgds
    Rainer
  10. Like
    jampjamp reacted to Jack_mcs in [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo   
    I don't understand what your image is showing. I see the characters in the setting and they look to be correct but what is the list of characters below it? And, just to be clear, the rewrite is for the url, not text on the page.
    I don't know if it was mentioned anywhere in this thread but if you have the English language installed, does the rewrite work with it?
  11. Like
    jampjamp reacted to raiwa in [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo   
    @jampjamp,
    As stated, without a look on your store, I have no more ideas what to check. Maybe it would be helpful to post a screenshot of an example product with special characters in the name and the produced URL.
  12. Like
    jampjamp reacted to Jack_mcs in [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo   
    I just tried it in a new BS shop and it worked as expected. The shop only has English installed but that uses UTF for the charset so it shouldn't make a difference. The only thing I can think it may be is the php version your shop is running. The test site here is using 5.6.
  13. Like
    jampjamp reacted to raiwa in [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo   
    @jampjamp,
    Do you have these problems with old polnish language files and your old imported/converted 2.2MS database??
     
    If yes:
    1. convert all your old language files to utf-8 encoding. How to do it depends on your text editor.
    2. Convert all your database (product and category tables are important) to utf-8 encoding. This can be easy done in Admin-Tools-Database Tables
    Hope this helps
    rgds
    Rainer
  14. Like
    jampjamp reacted to raiwa in [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo   
    The setting:
    // charset for web pages and emails
    define('CHARSET', 'utf-8');
    just tells the browser to render or decode your texts as utf-8. Another thing is that your texts (language files) are correct utf-8 encoded.
    The old polnish language files are for sure encoded in old ISO-xxxxx, not utf-8.
    You need first to make sure that your text editor uses utf-8, ( or by default or by changing the configuration setting) and then find a way to change the encoding, preserving that the special characters still show correct. To give more specific advice you need to tell us which text editor you are using.
     
    Another subject is the database encoding and the correct rendering of the category and product names in the SEO URLs which are extracted from the database, not from the language files.
    If you have converted the database tables to utf-8 encoding, check in PHP My Admin if the Category and Product names show correct the special characters in the correspondent tables.
    Sometimes if you did some conversions in your old 2.2MS database to use utf-8 encoding in your shop, the encoding may get corrupted.
    You must see in PHP my Admin all texts with special characters correct showing up.
    rgds
    Rainer
  15. Like
    jampjamp reacted to raiwa in [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo   
    Sorry, I do not understand what exact you wants to say here.
    Otherwise, as far as I understand, all seems correct with your store and I can't see a reason that the SEO URL character conversion shouldn't work.
     
    Maybe it would be helpful to have a look on your store if it's public available. If you do not wish to public it here, you can send me a private message.
     
    rgds
    Rainer
  16. Like
    jampjamp reacted to raiwa in [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo   
    all language support in 2.3.4 BS is utf-8 based and all languages including english (files and database) should support all special characters.
    Date localization has known issues (doesn't work) on local test installations under windows, but the SEO URL stuff should work.
    There must be something wrong in the setup, but without having a look on your store it is difficult to give further advice.
    Maybe @Jack_mcshas an idea.
  17. Like
    jampjamp reacted to raiwa in [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo   
    @jampjamp,
     
    just to be sure: did you reset the SEO URL cache after adding the special characters to the configuration list
×