Jump to content

jampjamp

Members
  • Content count

    38
  • Joined

  • Last visited


Reputation Activity

  1. 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
  2. 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
  3. 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?
  4. 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.
  5. 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.
  6. 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
  7. 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
  8. 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
  9. 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.
  10. 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
×