Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by Johnson

  1. Johnson

    Looking for a contribution

    Master Products will do this :D Matti
  2. Johnson

    Forum OC2.2 MS2

    You are missing a <?php tag :D Matti
  3. Johnson

    SSL with or without www's

    Either will work - if your http address is www, then the same would make the most sense. Make sure that you get your configuration address correct, otherwise it will pop up a browser warning when you switch to https. Matti
  4. I have installed this for the first time without any apparent problems other than: I have created a discount coupon for $2 . On the checkout payment page for a product worth $2 I can successfully redeem the coupon however the payment options still show and I am required to select one even though the order total is $0 Is this an omission/bug or have I missed something? Thanks! :D Matti
  5. Johnson

    [Support] Category Fields

    Not at all - you simply use the Products Extra Fields contribution :P The whole purpose of the Category Fields contribution is the ability to have *different* extra fields per category :-" Matti
  6. Johnson

    Where do files go

    The files in a contribution will go in the same directory structure as your store - the contribution directories do not replace your existing directories :D Matti
  7. Johnson

    Where do files go

    You have not added the define FILENAME_DEFINE_MAINPAGE to filenames.php :-" Matti
  8. Johnson

    Master Products - MS2

    You have made a sloppy install - the function is missing from general.php, so you didn't install the file included in the package or you installed in the wrong directory Matti :-"
  9. Johnson

    Question about developing payment modules

    That is the wy its generally done in that kind of situation. Now, please contribute your module :D Matti
  10. Johnson

    Master Products - MS2

    This is what immediately comes to my mind - your magazines are *each* a subcategory, then under these your years as Masters and the months as Slaves It will be important for the Search function that the name of the Masters and Slaves have the magazine name, eg. Master - "Magazine Name - 1973" Slave - Magazine Name - 1973-03" Matti
  11. Johnson

    Force Cookie = true

    Most likely that your cookie settings in your /includes/configure.php are incorrect. This is simple to check - when you browse your site does the osCsid appear in your browser address bar in a cookie enabled browser? If it does, a cookie is not being set because your configuration parameters are wrong. Matti
  12. Johnson

    Help with QT PRO install

    Look for the support thread in the Contributions Support channel :-" Matti
  13. I am currently re-developing a fixed width site..... if we wish to talk about 'empty space' which looks unprofessional, I cannot think of a better example than a fixed width site with a great deal of empty space on one side or both and everything else squished into 800 pixels (or less) :-" In regard to headers, why should a header design be the deciding factor? I know this is often the case and IMO it is because the logo/header is poorly designed, as is perhaps the remainder of the layout - all space is within the control of the designer.... :D I think a reason much closer to the mark is that there is an abundance of poorly designed templates that are difficult to integrate into anything but fixed width. I have a high resolution monitor (as do most people these days) and expect my screen to be filled - I have had the same thing said to me countless times by people who are just everyday internet users ;) Matti
  14. I couldn't disagree more with this - the correct way to code is so that the site will expand according to screen resolution - this can at times be a challenge, but worth the effort. Matti
  15. Johnson

    [Support] Category Fields

    You must define the table in /includes/database_tables.php :D Do this in both the admin and catalog files. Matti Your problem is that you have used: while ($cextra_fields = tep_db_fetch_array($cextra_fields_query)) { if ($cextra_fields['value'] != '') { Your query is not named $cextra_fields_query but the original $category_fields_query - just change this :D Matti The fields only show in product_info.php :D Matti
  16. Johnson


    The reason is clearly outlined in our forum rules: All external solutions (contributions) discussed in the forums must be freely available under the GNU General Public License (GPL), and must also be freely available for download at the Contributions section on the osCommerce support site. Postings regarding contributions that are not released under the GNU General Public License, or are not freely available, may be deleted without prior notification. This includes things like "I have a module that I am working on (or "I have one that works"), please give me feedback". The reason for this is very simple - in the past, developers have started 'development' threads, got their feedback, but the module was never released as a contribution :blink: All code discussed must be released first, even if its 'code in development'. :D Discussion of modules that have been removed from contributions is not going to last very long, and we ask that you refrain - if you have questions, please PM a moderator. For those wanting a module, you would do best to wait until one is released, or sponsor a developer to create one and contribute it - this process is not to be discussed on our forums, please keep it private. Thanks! Matti
  17. Johnson

    Generate random password

    osCommerce does it like this in password_forgotten.php: $new_password = tep_create_random_value(ENTRY_PASSWORD_MIN_LENGTH); $crypted_password = tep_encrypt_password($new_password); It wouldn't be difficult to get this into checkout_process.php :D Matti
  18. Johnson

    Contribution 2795 - Product Listing

    This works for me :D <?php /* ?$Id: report.php Exp $ ?osCommerce, Open Source E-Commerce Solutions ?http://www.oscommerce.com ?Copyright (c) 2003 osCommerce ? ?Suomedia - Dynamic Content Management ?http://suomedia.com ? ?Copyright (c) 2005 Suomedia ? ?Released under the GNU General Public License */ ?require('includes/application_top.php'); ?> <html> <head> <style type="text/css"> table.report { border: 1px solid Black; page-break-after: auto; page: auto; border-collapse: collapse; font-family: Arial, Verdana, sans-serif; font-size: 12px; padding: 6px; } h2.report { font-family: Arial, Verdana, sans-serif; font-size: 16px; } td.price { font-family: Arial, Verdana, sans-serif; font-size: 14px; text-align: right; border: 1px solid; padding: 3px; } td.report { border: 1px solid; padding: 3px; } </style> </head> <body> <?php $qry = "select distinct c.categories_name, a.parent_id, pd.products_name, pd.products_description, p.products_price, p.products_image, m.manufacturers_name" . ? ? ?" from " . TABLE_PRODUCTS . " p, " . TABLE_CATEGORIES_DESCRIPTION . " c, " . TABLE_CATEGORIES . " a, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m" . ? ? ?" where p.products_id = pd.products_id and p.manufacturers_id = m.manufacturers_id and p.products_id = pc.products_id and pc.categories_id = c.categories_id AND c.categories_id = a.categories_id AND c.language_id = '" . (int)$languages_id . "' and pd.language_id = '" . (int)$languages_id . "'" . ? ? ?" order by trim(c.categories_name), m.manufacturers_name, trim(pd.products_name) asc"; ? $records = tep_db_query($qry); $num_records = tep_db_num_rows($records); ? ?> <table width=600> ?<TR> ?<td align="center"> ? <p> </p> ? <p> </p> ? <h2><b><i>Price List: </i></b></h2> ? <p><? ? echo $num_records; ?> products <? $i = 0; ? ? ? ? ? ? ? $table = mysql_fetch_array($records); while ($table) { ?$parent_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd left join " . TABLE_CATEGORIES . " c on cd. categories_id = c.categories_id where c.categories_id = '" ?. $table['parent_id'] . "'"); ?$parent_result = tep_db_fetch_array($parent_query); ?$parent = $parent_result['categories_name']; ? ?$category1 = $table['categories_name']; ?$manufacturer1 = $table['manufacturers_name']; ? ?> ? <h2 class="report" align="left"> <? echo $parent . ": " . $category1 . ": " . $manufacturer1; ?> </h2> ? <table class="report"> ? <TR> ? ?<TH width=500 align="left" class="report">Product</TH> ? ?<th width=80 align="left" class="report">Price</th> ? </TR> <? ?do { ? $category = $table['categories_name']; ? $manufacturer = $table['manufacturers_name']; ? $product = $table['products_name']; ? $price = $table['products_price']; ? $description = $table['products_description']; ? if ($category != $category1 || $manufacturer != $manufacturer1) { ? ??> </table> <? ? ? ? break; ? } ? ? if (!($i%2)) {$color = "BGCOLOR = #FFFF99";} ? else { $color = "BGCOLOR = #FFFFFF";} ? ? ? ? ? ? ?> ?<tr> ? ? <td class="report"> ? ? ?<? echo '<b>' . $product . '</b><br><br>' . $description;?> ? ? </td> ? ? <td class="price"> ? ? ?<? echo number_format ($price,2,',','.');?> ? ? </td> ? ?</tr> ? <? ? $i++; ?} while ($table = mysql_fetch_array($records)); } ?> ?</td> ?</tr> </table> </body> </html>
  19. Johnson

    Contribution 2795 - Product Listing

    You already have the products description in the first code you posted - to display it: <?php echo $description; ?> :D Matti
  20. Johnson

    Contribution 2795 - Product Listing

    You need to add parent_id and TABLE_CATEGORIES to your query, then use something like this: <? $i = 0; $table = mysql_fetch_array($records); while ($table) { $parent_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd left join " . TABLE_CATEGORIES . " c on cd. categories_id = c.categories_id where c.categories_id = '" . $table['parent_id'] . "'"); $parent_result = tep_db_fetch_array($parent_query); $parent = $parent_result['categories_name']; $category1 = $table['categories_name']; $manufacturer1 = $table['manufacturers_name']; ?> You can echo the result with $parent :D Matti
  21. Check for a missing break; tag Matti
  22. It could be a problem with the query (wrong table definition), or perhaps the definition of the table name (most likely your categories table) in admin/includes/database_tables.php Matti
  23. This is a problem in your database - one of your contributions requires a 'sort_order' column to be present in your categories_description table - look for a *.sql file (or instructions) in the contribution package :D Matti
  24. Johnson

    Failed to Checkout!

    Yes - but you can turn this off. In /includes/configure.php and admin/includes/configure.php set: define('ENABLE_SSL', false); When your store is ready to go live it is recommended that you have an SSL certificate installed :D Matti
  25. Johnson

    Reqest for Quote - any solution?

    The Custom Computer Creator contribution can be used from computers to flower arrangements :D Matti