Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by pafranklin

  1. pafranklin

    Moving from HTTP to HTTPS

    Hi, With news, rumors and articles suggesting that Google is starting to de-rank sites that are not HTTPS across the entire site I just want to double check how I do this. I currently have an SSL in place so is it simply a question of amending the 2 configure.php files on the admin and frontend? Any pointers would be very gratefully received! Paul
  2. pafranklin

    SQL Command Error

    Hi all, I've uploaded some products to my site and then started to make amendments. I've then spotted the date available is incorrect. Therefore I am trying to select products added today 11th December and updating all of them to be available on 10th February 2019. I have this so far but pretty sure this is not correct?! UPDATE `products_date_available`= `2019-02-10 00:00:00` FROM `products` WHERE `products_date_added` = `2018-12-12 00:00:00` Please would someone be kind enough to correct this or tell me where I am going wrong? Many thanks. Paul
  3. pafranklin

    SQL Command Error

    Duh, got there in the end so just in case anyone else ever looks for something like this its as follows: UPDATE `products` SET `products_date_available` = '2019-02-10' WHERE `products_date_added` = '2018-12-11' Paul
  4. pafranklin

    Jssor Slider

    Thanks for the thoughts everyone.. I think it would be interesting and keep thinks fresh, but how do we achieve this??
  5. pafranklin

    Jssor Slider

    Hi All, I'm loving this slider (kindly provided by Jack_mcs) and just one question if anyone familiar. Is there a way for the display of the slider images to be random rather than in the order they were added? A random display would make it look fresh and different every time. Many thanks in advance. Paul
  6. Hi all, I'm in the process of finishing a new bootstrap osc website, with the fantastic help from one of the members here and I have a question that I'm trying to sort myself around the display of manufacturers. Basically I want to sort the manufacturers so they display alphabetically. I've tried a few things but none have worked so wonder if someone could point me in the right direction please? My page so far is as follows: <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2010 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require('includes/languages/' . $language . '/manufacturers.php'); $breadcrumb->add(NAVBAR_TITLE, tep_href_link('manufacturers.php')); require('includes/template_top.php'); ?> <style> .cat-set2 { display: flex; flex-wrap:wrap; justify-content: space-between; } .cat-set2 > div { min-width:30%; margin: 10px; text-align: center; font-size: 30px; } .cat-image { background-color: white; min-width:30%; margin: 10px; padding:10px 0; text-align: center; font-size: 30px; border:1px solid #9a9a9a; border-radius:10px; } .cat-image:hover { border:1px solid #dd0000; } div.caption {background:white} </style> <div class="page-header"> <h1 class="h3"><?php echo HEADING_TITLE; ?></h1> </div> <?php //$manufacturers_query = tep_db_query("SELECT DISTINCT count(p2c.products_id) as prodcount, cd.categories_id, cd.categories_name, m.manufacturers_id, manufacturers_name, manufacturers_image FROM " . TABLE_PRODUCTS . " p, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_MANUFACTURERS ." m, " . TABLE_PRODUCTS_TO_CATEGORIES ." p2c WHERE p.manufacturers_id = m.manufacturers_id AND p.products_id = p2c.products_id AND p.products_status = 1 AND p2c.categories_id = c.categories_id and c.categories_id = cd.categories_id and cd.language_id = " . (int)$languages_id . " GROUP BY m.manufacturers_name, cd.categories_name"); $db_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image from manufacturers m left join manufacturers_info mi on m.manufacturers_id = mi.manufacturers_id where mi.languages_id = '" . (int)$languages_id . "'"); ?> <div class="contentContainer"> <div class="contentText"> <div><?php echo TEXT_INFORMATION; ?></div> <div class=" cat-set2"> <?php while ($db = tep_db_fetch_array($db_query)) { echo '<div>'; echo '<div class="cat-image equal-height" style="margin-bottom:0;">'; echo '<div class="text-center">'; echo '<a href="' . tep_href_link('index.php', 'manufacturers_id=' . $db['manufacturers_id']) . '">' . tep_image('images/' . $db['manufacturers_image'], htmlspecialchars($db['manufacturers_name']), '100', '100') . '</a>'; echo '</div>'; echo '</div>'; echo '<div class="caption text-center">'; echo '<h5><a href="' . tep_href_link('index.php', 'manufacturers_id=' . $db['manufacturers_id']) . '"><span itemprop="itemListElement">' . $db['manufacturers_name'] . '</span></a></h5>'; echo '</div>'; echo '</div>'; } ?> </div> </div> <div style="clear:both;"></div> <div class="buttonSet"> <div class="text-right"><?php echo tep_draw_button(IMAGE_BUTTON_CONTINUE, 'fa fa-angle-right', tep_href_link('index.php')); ?></div> </div> </div> <?php require('includes/template_bottom.php'); require('includes/application_bottom.php'); ?>
  7. Thank you for the reply. Its that first aspect I'm struggling with.
  8. pafranklin

    Moving from HTTP to HTTPS

    Thank you all for the comments. When I made the changes to the catalog/includes/configure file when the site went to checkout the pages lost all CSS, images and layout (as enclosed). Is this because I still need to make the changs to .htaccess? Thanks in advance. Paul
  9. pafranklin

    PayPal Website Payments Pro Hosted Solution (Official)

    Hi, I have been using PayPal Website Payments Pro Hosted for over a year without issue and the other day it simply stopped working. I receive a debug email which states.......... $HTTP_POST_VARS: x=71 y=12 $HTTP_GET_VARS: https://api-3t.paypal.com/nvp - array ( ) Can anyone point me in the right direction please to resolve this? Many thanks in advance. Paul
  10. pafranklin

    Manual Order Maker

    I installed this contribution after Order Editor and had a similar problem to a number of others. Upon creating a customer or selecting an existing customer and clicking on "Save" on the create_order.php page I would be taken to the create_order_process.php page which was blank. The fix in my case was to copy the password_funcs.php page from includes/functions/ to admin/includes/functions/ All works!
  11. pafranklin

    NEW! Complete Order Editing Tool!

    Although this thread is looking as though it gets very few visitors, I just wanted to post my solution to the problem (5.09 not working with PHP5.3) Having investigated with my host and an expert coder, no solution could be found. Therefore I went back to basics, uninstalled the contribution and then re-installed version 2.8.2 (link below) http://addons.oscommerce.com/info/1435 It works perfectly and I can always work thrugh the modifications since this older version to make any changes later. However for anyone having a problem with 5.0.9 on a PHP5.3 server then this may help! Paul
  12. pafranklin

    NEW! Complete Order Editing Tool!

    I have just installed 5.0.9 from scratch, uploaded the files and made the necessary amends. However, when I click on the edit button I receive a blank page (error 500). If I enter an incorrect order number I can see that the page is available and working due to the "Error: Order 4251 does not exist." I am running osC 2.2-MS2 with PHP5.3.10 and wonder if the PHP version may be the issue. I have scoured dozens of pages through the forum where there is a reference to blank pages but so far no luck. Has anyone come across this problem or can anyone poiunt me in the right direction please? Many thanks. Paul
  13. Further to the post above from andrew71 my host has moved to PHP5.3 and my product images no longer work. Is there a work around available to overcome the issue ( with register_long_arrays set to off, imagemagic doesn't work for me and just displays "error, file path incorrect, check configure.php". If I switch register_long_arrays back on, it works, but under PHP5.3, register_long_arrays is deprecated and can't be switched back on.) Please can anyone advise of a fix or work around? Many thanks. Paul
  14. pafranklin

    [Contribution] Ship In Cart

    Hi there, I haven't trawled every page in this thread but wanted to post an update for all of those who have experienced an error on the product page whereby anyone clicking on the "update cart" button gets an error of page cannot be dispayed and the url appears something like http://www.xyzdomain.com/_. To correct this find: <tr> <td> <br> <?php $cart->add_cart($product_info['products_id']); //add current to cart for estimator if (CARTSHIP_ONOFF == 'Enabled') { require(DIR_WS_MODULES . 'product_shipping_estimator.php'); } else {}; $cart->remove($product_info['products_id']); //lets remove current product from cart ?> </td> </tr> and add </form> just before it so that the code looks something like: </form> <tr> <td> <br> <?php $cart->add_cart($product_info['products_id']); //add current to cart for estimator if (CARTSHIP_ONOFF == 'Enabled') { require(DIR_WS_MODULES . 'product_shipping_estimator.php'); } else {}; $cart->remove($product_info['products_id']); //lets remove current product from cart ?> </td> </tr> I hope this helps someone - It worked for me and the module works well, so thanks to those for developing it. Paul.
  15. pafranklin

    API Certificate v API Signature

    Hi there, I am hoping to install this version but see that you need an API Certificate? Unfortunately I have (and still use) the more modern API Signature. According to PayPal you cannot have both an API Certificate and an API Signature. Is there away around this? Will this module be upgraded to use the API Signature method? Any comments would be greatly appreciated. Many thanks. Paul
  16. pafranklin

    Actual Attribute Price V1.0

    Thanks for the reply which is much appreciated. Unfortunately I think I will have to decide not to install this contrib as I have 192 fairly complex Attribute Sets with lots of attribues in each set so having to re-do each of them would be an absolute nightmare. Its a real shame as the current setup is not ideal for customers. Thanks again for the assistance and information!! Kind regards. Paul
  17. pafranklin

    Actual Attribute Price V1.0

    Sorry for the basic question but before I attempt the install of Actual Attribute Price v1.7 I just wanted to ask if this woks with Attribute Sets or if they would be incompatable? As I have an existing shop with lots of attributes and lots of Attribute Sets, I am just a little nervous about installing and then running the attribute update utility to change everything (even allowing for file and database backups) Any thoughts or information would be appreciated. Thanks. Paul
  18. pafranklin

    Opening Links in a new Window

    This is very helpful. Many thanks! Paul
  19. Hi there, Probably a really stupid question but I have a link that I want to have open in a new window. How do I change the code below to enable this please?? Many thanks. Paul
  20. Hi there, I have been doing some work on one of my sites and have come across an error. I have not installed any contribs but must have made some code changes somewhere. When I am updating a product information from the admin side (catalog/admin/categories.php) and I click on the "Update" button, I am now receiving the following two error messages.......... Line 98 - 100 in my admin/includes/functions/database.php file is as follows: Line 54 from my admin/includes/functions/general.php file is as follows: I am sure ther must be a simple solution but I cannot find the error. Please would someone be kind enough to point me in the right direction? Many thanks. Paul
  21. pafranklin

    PayPal WPP Direct Payments & Express Checkout Support

    Thanks Glen and good luck with the development. I see that the contrib listed is quite old (2004) and Centinel have just provided me with what may be a newer version of the osC Cartridge. I didn't like to upload this against the existing version as I was not sure but it can be found (for the next few days anyway) from this link. Centinel osC Cartridge If it is appropriate I will add this to the contrib? Thanks again. Paul
  22. pafranklin

    PayPal WPP Direct Payments & Express Checkout Support

    Hi Glen, I am one of probably many UK site owners using PayPal WPP. I have registered with Centinel and received their guides (including the Thin Client) and must confess that even for someone with a moderat level of knowledge and experience with osC, this looks complicated. Do you envisage the upgrade to the PayPal WPP Module including the Centinel Thin Client or will we need to arrange to have this installed separately? Many thanks in advance. Paul
  23. pafranklin

    Shipping Table Rate

    Hi there, I believe (and I could be wrong) so worth a test possibly that you need to confirm the zero range by adding something like 3.99:0, 4:4, 5:5, 8:6,13:8,27:15,49:28,57:33,69:41,87:54,94:60,103:68,117:83,140:95 This should set anything up to and including 3.99 as nil and then up to 4 as 4 and so on. Hope this helps. Paul
  24. pafranklin

    PayPal Payflow Pro [New Version]

    Hi there, I am really sorry for the apparently "stupid" question but I am using PayPal WPP Pro, although it does still have some glitches which can affect the ability of some to complete their transactions. Is PayPal Payflow Pro the same as PayPal WPP Pro or something entirely different? Also does this work with UK based PayPal accounts? Many thanks!! Paul
  25. pafranklin

    PayPal WPP Module - Adding Maestro Card option

    Hi again, I am getting more confused by the minute. I have made changes to remove Switch and replace with Maestro but from information I have not all Maestro cards have a "valid from" date (which the module seems to need. Therefore I am getting the following error............ "Error Your credit card was declined. Please try another card or contact your bank for more info. No response from PayPal No response was received from PayPal. Please contact the store owner for assistance." In this instance there is definitely no problem with the card and funds are available for the transaction but I get a PayPal error. Can anyone answer these questions: 1. Does the module need a "Valid From" date for Maestro cards or has simply replacing Switch with Maestro caused this problem? 2. Is there any other explanation for the error that I may have missed? 3. Is there a newer version of the module available somewhere which has Maestro instead of Switch? Any help would be very much appreciated............!! Thank you!!