Jump to content


  • Content count

  • Joined

  • Last visited

About pafranklin

  • Birthday 01/25/1963

Profile Information

  • Real Name
    Paul Franklin
  • Gender
  • Location
    Gloucestershire, UK
  • Interests
    OSC (Obviously), general website design, cricket, cinema and theatre. Oh yes - and red wine!
  • Website

Recent Profile Visitors

14,874 profile views
  1. 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
  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

    Jssor Slider

    Thanks for the thoughts everyone.. I think it would be interesting and keep thinks fresh, but how do we achieve this??
  4. 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
  5. Thank you for the reply. Its that first aspect I'm struggling with.
  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. 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
  8. 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
  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