Jump to content

suhy

Members
  • Content count

    97
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by suhy

  1. suhy

    PDF Catalog v.1.5

    Hi, Another idea ... If anybode has it all working on PHP5+MYSQL5 can you PLEASE just post all admin and catalog files as a revised contribution http://www.oscommerce.com/community/contri...rch,pdf+catalog And we will also try to adopt it to match our store ... Thanks !
  2. suhy

    PDF Catalog v.1.5

    Hi, Does also somebody has problems when migrating to PHP5 + MYSQL5 ? - I made the changes neccessary for MYSQL5 and I now in admin get a blank page after pressing Make PDF Catalogs .. ??! - It appers that "left join" need different syntax with brackets ... If left alone I get error 1054 as usual, but after applaying changes I just get blank page ! Before mysql5 fix (admin area) $requete_prod="select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id='".$current_category_id."' order by pd.products_name, p.products_date_added DESC"; After change: $requete_prod="select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from [color="#FF0000"](([/color]" . TABLE_PRODUCTS . " p[color="#FF0000"])[/color] left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd[color="#FF0000"])[/color] left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id='".$current_category_id."' order by pd.products_name, p.products_date_added DESC"; I red is some post that if you have more than one left join, you have to make more brackets in the start and then close them just before left join ... Can anybody confirm this is OK ? And why am I getting blank page ? in CATALOGE area : The catalogs are generated as usualy, but no output ?!?! The last action when download link is shown is abviously too fast, the link shows, but no catalogs are generated ... I'm still modifying and applaying some changes for PHP5 compatibility .. Can please somebody point out what could also be wrong ?! I have enabled the following in my httacces file : php_flag register_globals on php_value register_long_arrays on For the long arrays, I don't know if it's OK ... Should I just replace all instances in all pages like : $HTTP_GET_VARS change to $_GET $HTTP_POST_VARS change to $_POST Please HELP ! I still have test shop on PHP4+MYSQL4 for testing and all works fine !!!! I'm forced to move to 5 as they will discontinue 4 in short time ... (my webspace providers)
  3. suhy

    "Dynamenu" for osCommerce

    Hello, I'm using dynamenu for some time now and it works great ! But recently ma webhost privider moved to PHP5+SQL5 .... I sometimes now get the categories (usig tree menu) very wide and not finish loading ... Instead of categorie name thze link is shown and it's very very wide at this time .... Can that be due to a PHP5 ? Reloading the page once usually helps, but sometimes not .... I found it quite disturbing ... Thanks for any help / comment.
  4. suhy

    PDF Catalog v.1.5

    Hi, My webservice provider just moved to PHP5 with MYSQL5 and I also now have some troubles getting it worked again... Ufff I fixed the MYSQL5 fix and I'm not getting any error message now. The catalogs are generated as ususaly, but the time after DOWNLOAD link is shown is too short and catalogs are not generated. Same in catalog and admin area ... Is there maybe also some fix neccessary for PHP5 ? I'll go after it in next days, but if someone has already a solution it would help. I have two online identical sites : - PHP4 + MYSQL4 (test site now) - still works great ! - PHP5 + MYSQL5 (sql5 fix OK!) - just doesn't work ... Thanks for ny help ! :thumbsup:
  5. suhy

    PDF Catalog v.1.5

    Hi, PDF catalog works fine. Please check the following, so we could find a solution ... - Are the PDF catalogs generated in the defined folder ? - If Yes, check the path of the generated files in that folder and compare it with the DOWNLOAD shortcut path - the output link is generated in two line - for combined categorries: $pdf->Output(DIR_FS_CATALOG . DIR_WS_PDF_CATALOGS . PDF_FILENAME_CATEGORIES . "_" . $languages[$i]['id']. " all selected.pdf",false); - for each categorroes in separate file : $pdf->Output(DIR_FS_CATALOG . "/" . DIR_WS_PDF_CATALOGS . PDF_FILENAME_CATEGORIES . "_" . $languages[$i]['id']."_".$KATEGORIE_SELECTED[$j].".pdf",false); Please see bolded selection ... it can't work in both options if the slash is inserted in only one .... Please chech and advise further ... regards, Gregor p.s. I still havent "hack" the Š and š and Č and č .....Anyone for some help with html entities ?
  6. suhy

    PDF Catalog v.1.5

    Anyone for some help on this one ?
  7. suhy

    PDF Catalog v.1.5

    Hi, Even that I usualy figure simple things out, I have often a problem with some basic stuff since I'm a self learning php begginer ... so please point me a bit ... I wanted to try if your above idea would also work to replace entities that are generated couse of mine HTML editor TyneMCE that we use. The problem is the output of our legeb our legendary characters like č and š. Other is OK ! String generated is for example : š = š Probably I'm failing at positioning the code at : $entities = get_html_translation_table(HTML_ENTITIES); $entities["abc"]="def"; Did I did it OK like : ? function DrawCells($entities = get_html_translation_table(HTML_ENTITIES);$entities["abc"]="def";$data_array) or should I put it somhere else ??? For the SHOW DESCRIPTION is obvious .... Do you think that the above could work for my č and š ? I also tried to change used fonts if these characters were missing ... I generated the php and z files and uploaded them. Then I had troubles with adding the font to fpdf and setting the font ... just didn't work for me. I would need more thorough instructions. I tried per fpdf instruction but no result. Is adding and setting fonts with this mod for Oscomm any different ? Or if somebody already have a solution for š and č, please post ! THANKS !
  8. suhy

    PDF Catalog v.1.5

    categories_8 all selected.pdf Don't mind the number in the file code as it's generated with . $languages[$i]['id']. and represents the language code ....
  9. suhy

    PDF Catalog v.1.5

    Hi, Try the following : for selecting multiple categories => PDF output in one file - line 860 defines PDF output and what the link of PDF looks like ! - make a single PDF catalog from multiple categories and just hoover the mouse on the link ! - read the link and compare it with the made PDF file in "catalogue" directory - Be carefull to undescores _ - bold "_" in bellow code puts _ in the PDF output file ... - Just tweak the code to match your PDF file output $pdf->Output(DIR_FS_CATALOG . DIR_WS_PDF_CATALOGS . PDF_FILENAME_CATEGORIES . "_" . $languages[$i]['id']. " all selected.pdf",false); categories_8 all selected.pdf => with "_" categories 8 all selected.pdf => without "_" - If your output file has a different name or you'll have problems, paste the name of PDF output and I'll try to help ... regards, suhy
  10. suhy

    PDF Catalog v.1.5

    Forgot to add categories language also for "all categories in one file pdf output" : in line 860 (pdf_catalog_info2.php) find : $pdf->Output(DIR_FS_CATALOG . DIR_WS_PDF_CATALOGS . PDF_FILENAME_CATEGORIES . " all selected.pdf",false); and replace with : $pdf->Output(DIR_FS_CATALOG . DIR_WS_PDF_CATALOGS . PDF_FILENAME_CATEGORIES . "_" . $languages[$i]['id']. " all selected.pdf",false); That's all, works fine now !
  11. suhy

    PDF Catalog v.1.5

    Hi, I also have a question ... The HTML entities now works better in English language ! But I still have troubles with Slovenian. ..... We are using eastern european language set and some characters are wrongly decoded .... Is it possible to hard code some entities ? Thanks for any help ! Without this solution the catalog looks very funny in Slovenian language .... Suhy
  12. suhy

    PDF Catalog v.1.5

    Hi, After a few days of tweaking I finaly got this incredible great contribution working in all ways !!! - I took v2.05 from 4th May 2007 as a base install - dont forget to copy FONT folder also in catalog folder !!! Missing in the decription and the path to admin in catalog area didn't work for me ... - The admin area works fine from the start ! - For the catalog area the language pick didn't work. I modified pdf_catalog_info2.php as follows after comparing with file from v2.06 : find in line 879 : $pdf->Output(DIR_FS_CATALOG . DIR_WS_PDF_CATALOGS . PDF_FILENAME_CATEGORIES . " " .$categories_name['categories_name'].".pdf",false); replace with : $pdf->Output(DIR_FS_CATALOG . "/" . DIR_WS_PDF_CATALOGS . PDF_FILENAME_CATEGORIES . "_" . $languages[$i]['id']."_".$KATEGORIE_SELECTED[$j].".pdf",false); - Carefuly follow the setup in both config files, in admin and catalog ! - Set the permission for catalugue to 757 ! 755 doesn't work for categories add on ! You can see it working at : - Shop is not online yet, but we are just about to get it running, so please be gentle ... :)) http://www.delko.si/sql/eshop/catalog/pdf_...php?language=en
  13. suhy

    META Tags on the Fly

    Helloou, Couldn't wait ... just installed it and it works perfectly. I had to use 2nd part - cutted - of SQL. With the complete SQL I still had an error, but probably forgot to restore DB in one of the previous installations ... Anyway it works now with no errors. "Meta Tags " is added to Configuration as a new option ! Also played a bit with keywords, description ... and it looks it will be OK ! I don't have my catalog filled yet, so I must wait for the final result , but as seen from Bill's page it will be perfect at the end ! You can use page like following to test your META TAGS : http://www.widexl.com/remote/search-engine...g-analyzer.html Thanks for your support ! Suhy
  14. suhy

    META Tags on the Fly

    Hi Bill, Thanks for your reply and effort ... I'll try this one in the evening and will see if it works. Please just correct me if I'm wrong on the following : - Since I always backup my DB before doing anything .... and later if it doesn't work always upload my backeg up DB ! So I have to run first uncutted SQL ?! - How exactly can I check in my DB configuration tables (through PhpMyAdmin) what ID groups do I already have ? - Do the ID groups have to be incremented by 1 (39, 40 ....) or you can choose any number ? Thanks for your help as my current knowlege on SQL is still rather poor ... but hopfully will upgrade in time ! Thanks ! Suhy
  15. suhy

    META Tags on the Fly

    Tried, but still getting the error ... I think it's the same... Hope to figure this out ... Thanks !
  16. suhy

    "Dynamenu" for osCommerce

    Hi Noy, You can delete it in a code, but since it's quite a code and if u r not too skilled you can always use a hack ... Find the image that is appearing on your menu and replace it with image same color as your background (you can use just a dot). But as I can see u are using submenus, so removing the ponter is not the best idea by my opinion ... regards, Suhy
  17. suhy

    "Dynamenu" for osCommerce

    I also found out if using tree menu the first category with subcats don't work properly. Even if you place on the top a cetegori with no subcat, the first category with subcat in the tree menu will not work properly. Please advise if you have some fix for this glitch Nate before we try some tricks to go around that ... Thanks !
  18. suhy

    "Dynamenu" for osCommerce

    Hi, Dyna menu is exactly what u r looking for I suppose. There are 4 different menus to choose from in the package and you can set the desired colors in css file, very easy to install .... Suhy
  19. suhy

    "Dynamenu" for osCommerce

    Hi All ! I've been testing a lot with category tree menus lately as it happens that I just love the look of that menu, fantastic contribution thoe ! I just can't find minor glitch ... The first category doesn't expand if you click on a category description ! It only expands if you click on a folder icon or + sign ... I could easily go around that with first category without subcategories, but .... don't wona ... :-" Bellow is my test site, so you could check it out ... http://www.delko.si/adapta/sql/commerce/ca...php?language=en Thanks for your help ! Gregor
  20. Sorry, the warning is shown at the bottom left corner of course !
  21. suhy

    New CC payment module

    Hi, Any freelancer who would make a "new" credit card module for use with oscommerce 2.2 milestone2 that is made for a particular market ? We have all the neccessary documentation from the gateway provider in our country, how to ... We will disscuss fees later when you establish the size of the project ... Thanks
×