Jump to content

hellbound

Members
  • Content count

    28
  • Joined

  • Last visited

Posts posted by hellbound


  1. For those who have "products_options_sort_order" field in db "table products" :

     

    query on line 417 does not change:

    $products_options = tep_db_query("select pa.products_options_sort_order, pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . $products_id . "' and pa.options_id = '" . $products_options_name_values['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "'" . " order by pa.products_options_sort_order, 0+pov.products_options_values_name");

     

    otherwise:

     

    line 417 changes to:  

         

     $products_options = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . $products_id . "' and pa.options_id = '" . $products_options_name_values['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "'" . " order by 0+pov.products_options_values_name");

     

    SEE BUG FIX : "$languages_id" can be used now (instead of a numeric value) since the var is passed to function ProductsDataSheet()  by

    $pdf->ProductsDataSheet($languages_id, $products_id);

    (line 470)

     

    Did not believe it was so hard to make a contribution!

     

    ivan

     

     

    Now all its OK for me! :)

     

     

    Thanks for all your help


  2. I have applied the last patch, but now I see a very strange error. Sometimes the contrib is working and sometimes not (??).

     

    You can check it in mi shop www.sportlander.com

     

    For example if I choose the product 'BCAA 4' or 'Androtest' I see it OK in PDF format; but if I choose 'Isopro' it fails with this error:

     

    1054 - Unknown column 'pa.products_options_sort_order' in 'field list'
    
    
    
    select pa.products_options_sort_order, pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from products_attributes pa, products_options_values pov where pa.products_id = '47' and pa.options_id = '1' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '3' order by pa.products_options_sort_order, 0+pov.products_options_values_name
    
    
    
    [TEP STOP]

     

     

    And another error that I have is that If I have a description with html tags; they are not good printed (as html) in the PDF sheet.

     

     

    regards


  3. Please bear in mind that this solution uses the marquee tag.

     

    The marquee tag is a non-standard extension to HTML introduced by Microsoft and seems to also work with newer Mozilla browsers but will not work with older Netscape browsers or opera.

     

    Correct me if I'm wrong.

     

    Yes, you're right, but I prefer to have problem with old browsers only...that to have problem with old browsers and new ones, without a Virtual Java machine installed :(

     

    regards


  4. I have made a new version of the news scroller 1.2 by BluEdoG that uses no java. It works the same way as the old one, but because I was having lots of problems with users without the Java VM installed, I made this one...its done with html and loads faster than the java version; now i am working with php code to make a news.txt file for writing the news. Its almost done. :)

     

    If anyone is interested to me to do a contribution I can make it, but only if BluEdoG agrees with the idea; because the first idea of this contribution was his. :)

     

     

    regards.

×