Jump to content
Latest News: (loading..)

pafranklin

Members
  • Content count

    288
  • Joined

  • Last visited

About pafranklin

  • Birthday 01/25/1963

Profile Information

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

Recent Profile Visitors

14,598 profile views
  1. pafranklin

    Jssor Slider

    Thanks for the thoughts everyone.. I think it would be interesting and keep thinks fresh, but how do we achieve this??
  2. 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
  3. pafranklin

    Missing admin/includes/filenames.php

    I think I've found it myself and the code enclosed seems to work (so far)! <? require('includes/application_top.php'); require('includes/classes/currencies.php'); $currencies = new currencies(); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <? if ( ! $_REQUEST['print'] ) { require('includes/template_top.php') ?> <? } ?> <td valign="top"> <div class="pageHeading"><?= HEADING_TITLE ?></div><br /> <table border="0" width='100%' cellspacing="0" cellpadding="2"> <? if ( isset( $_REQUEST['year'] ) && isset( $_REQUEST['month'] ) ) { if ( ! in_array( $_REQUEST['month'], explode( ',', MONTH_LIST ) ) ) { ?> <tr> <td class="pageHeading">Error!</td> </tr> <tr> <td class="dataTableContent">'<?= $_REQUEST['month'] ?>' is not a valid month!</td> </tr> <? } else { ?> <tr> <td class="pageHeading" colspan="6"><?= $_REQUEST['year'] ?> &raquo; <?= $_REQUEST['month'] ?></td> </tr> <tr> <td class="dataTableContent" colspan="3"><a href="stats_detailed_monthly_sales.php">Back</a></td> <td class="dataTableContent" colspan="3" align="right"><? if ( ! $_REQUEST['print'] ) { ?><a href="stats_detailed_monthly_sales.php?year=<?= $_REQUEST['year'] ?>&amp;month=<?= $_REQUEST['month'] ?>&amp;print=true" target="_blank">Printer Friendly Version (New Window)</a></td><? } ?> </tr> <tr> <td class="dataTableContent" colspan="6">&nbsp;</td> </tr> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent">Order #</td> <td class="dataTableHeadingContent">Customer</td> <td class="dataTableHeadingContent">Date</td> <td class="dataTableHeadingContent" align="right">Order Subtotal</td> <td class="dataTableHeadingContent" align="right">Shipping Total</td> <td class="dataTableHeadingContent" align="right">Tax Total</td> <td class="dataTableHeadingContent" align="right">Order Total</td> </tr> <? $orders_query = tep_db_query( "SELECT * FROM orders WHERE year( date_purchased ) = " . $_REQUEST['year'] . " AND monthname( date_purchased ) = '" . $_REQUEST['month'] . "' ORDER BY date_purchased DESC" ); $running_net_total = 0; $running_tax_total = 0; $running_shipping_total = 0; $order_count=0; while ( $orders = tep_db_fetch_array( $orders_query ) ) { $order_count++; $net_total_query = tep_db_query( "SELECT value AS total FROM orders_total WHERE orders_id = " . $orders['orders_id'] . " AND class = 'ot_subtotal'" ); $net_total = tep_db_fetch_array( $net_total_query ); $shipping_total_query = tep_db_query( "SELECT value AS total FROM orders_total WHERE orders_id = " . $orders['orders_id'] . " AND class = 'ot_shipping'" ); $shipping_total = tep_db_fetch_array( $shipping_total_query ); $tax_total_query = tep_db_query( "SELECT value AS total FROM orders_total WHERE orders_id = " . $orders['orders_id'] . " AND class = 'ot_tax'" ); $tax_total = tep_db_fetch_array( $tax_total_query ); $running_net_total += $net_total['total']; $running_shipping_total += $shipping_total['total']; $running_tax_total += $tax_total['total']; ?> <tr class="dataTableRow"> <td class="dataTableContent"><a href="invoice.php?oID=<?= $orders['orders_id'] ?>" target="_blank"><?= $orders['orders_id'] ?><a href="invoice.php?oID=<?= $orders['orders_id'] ?>"></td> <td class="dataTableContent"><?= $orders['customers_name'] ?></td> <td class="dataTableContent"><?= date( 'd/m/Y', strtotime( $orders['date_purchased'] ) ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $net_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $shipping_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $tax_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $net_total['total'] + $shipping_total['total'] + $tax_total['total'], 2 ) ?></td> </tr> <? } ?> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><?php echo $order_count ?> orders</td> <td class="dataTableHeadingContent" colspan="2">&nbsp;</td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $running_net_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $running_shipping_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $running_tax_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $running_net_total + $running_shipping_total + $running_tax_total, 2 ) ?></td> </tr> <? } } else { $count = 0; $years_query = tep_db_query( "SELECT DISTINCT( year( date_purchased ) ) AS y FROM " . TABLE_ORDERS . " ORDER BY date_purchased DESC" ); $total_running_net_total =0; $total_running_shipping_total =0; $total_running_tax_total =0; while ( $years = tep_db_fetch_array( $years_query ) ) { if ( $count > 0 ) { ?> <tr> <td class="dataTableContent">&nbsp; </tr> <? } ?> <tr> <td class="pageHeading" colspan="4"><?= $years['y'] ?></td> </tr> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" width="20%" align="left"><?= TABLE_HEADING_MONTH ?></td> <td class="dataTableHeadingContent" width="20%" align="right"><?= TABLE_HEADING_TOTAL_SALES_NET ?></td> <td class="dataTableHeadingContent" width="20%" align="right"><?= TABLE_HEADING_TOTAL_SHIPPING ?></td> <td class="dataTableHeadingContent" width="20%" align="right"><?= TABLE_HEADING_TOTAL_TAX ?></td> <td class="dataTableHeadingContent" width="20%" align="right"><?= TABLE_HEADING_TOTAL_SALES_GROSS ?></td> </tr> <? $months_query = tep_db_query( "SELECT DISTINCT( monthname( date_purchased ) ) AS month, month( date_purchased ) AS m FROM " . TABLE_ORDERS . " WHERE date_purchased LIKE '" . $years['y'] . "-%' ORDER BY date_purchased DESC" ); while ( $months = tep_db_fetch_array( $months_query ) ) { $net_total_query = tep_db_query( "SELECT SUM( value ) AS total FROM orders_total ot, orders o WHERE ot.orders_id=o.orders_id AND year( o.date_purchased ) = " . $years['y'] . " AND month( o.date_purchased ) = " . $months['m'] . " AND ot.class = 'ot_subtotal'" ); $net_total = tep_db_fetch_array( $net_total_query ); $shipping_total_query = tep_db_query( "SELECT SUM( value ) AS total FROM orders_total ot, orders o WHERE ot.orders_id=o.orders_id AND year( o.date_purchased ) = " . $years['y'] . " AND month( o.date_purchased ) = " . $months['m'] . " AND ot.class = 'ot_shipping'" ); $shipping_total = tep_db_fetch_array( $shipping_total_query ); $tax_total_query = tep_db_query( "SELECT SUM( value ) AS total FROM orders_total ot, orders o WHERE ot.orders_id=o.orders_id AND year( o.date_purchased ) = " . $years['y'] . " AND month( o.date_purchased ) = " . $months['m'] . " AND ot.class = 'ot_tax'" ); $tax_total = tep_db_fetch_array( $tax_total_query ); $yearly_running_net_total += $net_total['total']; $yearly_running_shipping_total += $shipping_total['total']; $yearly_running_tax_total += $tax_total['total']; $total_running_net_total += $net_total['total']; $total_running_shipping_total += $shipping_total['total']; $total_running_tax_total += $tax_total['total']; ?> <tr class="dataTableRow"> <td class="dataTableContent"><a href="stats_detailed_monthly_sales.php?year=<?= $years['y'] ?>&amp;month=<?= $months['month'] ?>"><?= $months['month'] ?></a></td> <td class="dataTableContent" align="right">$<?= number_format( $net_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $shipping_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $tax_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $net_total['total'] + $shipping_total['total'] + $tax_total['total'], 2 ) ?></td> </tr> <? $count ++; } ?> <tr class="dataTableHeadingRow"> <td class="dataTableContent"><?= $years['y'] ?> Total</a></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $yearly_running_net_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $yearly_running_shipping_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $yearly_running_tax_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $yearly_running_net_total + $yearly_running_shipping_total + $yearly_running_tax_total, 2 ) ?></td> </tr> <? $yearly_running_net_total =0; $yearly_running_shipping_total =0; $yearly_running_tax_total =0; } ?> <tr> <td colspan="5">&nbsp;</td> </tr> <tr> <td class="pageHeading" colspan="5">TOTAL</td> </tr> <tr class="dataTableHeadingRow"> <td class="dataTableContent">Store Total</a></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $total_running_net_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $total_running_shipping_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $total_running_tax_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $total_running_net_total + $total_running_shipping_total + $total_running_tax_total, 2 ) ?></td> </tr> <? } ?> </table> </td> </tr> </table> <? if ( ! $_REQUEST['print'] ) require('includes/template_bottom.php'); require('includes/application_bottom.php'); ?> </body> </html>
  4. pafranklin

    Missing admin/includes/filenames.php

    Thank you and I hadn't realised that. Files changed but now throwing a 500 Error. I don't suppose anyone can see if there is anything wrong with the enclosed code please? <? require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <? if ( ! $_REQUEST['print'] ) { require(DIR_WS_INCLUDES . 'template_top.php') ?> <? } ?> <td valign="top"> <div class="pageHeading"><?= HEADING_TITLE ?></div><br /> <table border="0" width='100%' cellspacing="0" cellpadding="2"> <? if ( isset( $_REQUEST['year'] ) && isset( $_REQUEST['month'] ) ) { if ( ! in_array( $_REQUEST['month'], explode( ',', MONTH_LIST ) ) ) { ?> <tr> <td class="pageHeading">Error!</td> </tr> <tr> <td class="dataTableContent">'<?= $_REQUEST['month'] ?>' is not a valid month!</td> </tr> <? } else { ?> <tr> <td class="pageHeading" colspan="6"><?= $_REQUEST['year'] ?> &raquo; <?= $_REQUEST['month'] ?></td> </tr> <tr> <td class="dataTableContent" colspan="3"><a href="stats_detailed_monthly_sales.php">Back</a></td> <td class="dataTableContent" colspan="3" align="right"><? if ( ! $_REQUEST['print'] ) { ?><a href="stats_detailed_monthly_sales.php?year=<?= $_REQUEST['year'] ?>&amp;month=<?= $_REQUEST['month'] ?>&amp;print=true" target="_blank">Printer Friendly Version (New Window)</a></td><? } ?> </tr> <tr> <td class="dataTableContent" colspan="6">&nbsp;</td> </tr> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent">Order #</td> <td class="dataTableHeadingContent">Customer</td> <td class="dataTableHeadingContent">Date</td> <td class="dataTableHeadingContent" align="right">Order Subtotal</td> <td class="dataTableHeadingContent" align="right">Shipping Total</td> <td class="dataTableHeadingContent" align="right">Tax Total</td> <td class="dataTableHeadingContent" align="right">Order Total</td> </tr> <? $orders_query = tep_db_query( "SELECT * FROM orders WHERE year( date_purchased ) = " . $_REQUEST['year'] . " AND monthname( date_purchased ) = '" . $_REQUEST['month'] . "' ORDER BY date_purchased DESC" ); $running_net_total = 0; $running_tax_total = 0; $running_shipping_total = 0; $order_count=0; while ( $orders = tep_db_fetch_array( $orders_query ) ) { $order_count++; $net_total_query = tep_db_query( "SELECT value AS total FROM orders_total WHERE orders_id = " . $orders['orders_id'] . " AND class = 'ot_subtotal'" ); $net_total = tep_db_fetch_array( $net_total_query ); $shipping_total_query = tep_db_query( "SELECT value AS total FROM orders_total WHERE orders_id = " . $orders['orders_id'] . " AND class = 'ot_shipping'" ); $shipping_total = tep_db_fetch_array( $shipping_total_query ); $tax_total_query = tep_db_query( "SELECT value AS total FROM orders_total WHERE orders_id = " . $orders['orders_id'] . " AND class = 'ot_tax'" ); $tax_total = tep_db_fetch_array( $tax_total_query ); $running_net_total += $net_total['total']; $running_shipping_total += $shipping_total['total']; $running_tax_total += $tax_total['total']; ?> <tr class="dataTableRow"> <td class="dataTableContent"><a href="invoice.php?oID=<?= $orders['orders_id'] ?>" target="_blank"><?= $orders['orders_id'] ?><a href="invoice.php?oID=<?= $orders['orders_id'] ?>"></td> <td class="dataTableContent"><?= $orders['customers_name'] ?></td> <td class="dataTableContent"><?= date( 'd/m/Y', strtotime( $orders['date_purchased'] ) ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $net_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $shipping_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $tax_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $net_total['total'] + $shipping_total['total'] + $tax_total['total'], 2 ) ?></td> </tr> <? } ?> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><?php echo $order_count ?> orders</td> <td class="dataTableHeadingContent" colspan="2">&nbsp;</td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $running_net_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $running_shipping_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $running_tax_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $running_net_total + $running_shipping_total + $running_tax_total, 2 ) ?></td> </tr> <? } } else { $count = 0; $years_query = tep_db_query( "SELECT DISTINCT( year( date_purchased ) ) AS y FROM " . TABLE_ORDERS . " ORDER BY date_purchased DESC" ); $total_running_net_total =0; $total_running_shipping_total =0; $total_running_tax_total =0; while ( $years = tep_db_fetch_array( $years_query ) ) { if ( $count > 0 ) { ?> <tr> <td class="dataTableContent">&nbsp; </tr> <? } ?> <tr> <td class="pageHeading" colspan="4"><?= $years['y'] ?></td> </tr> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" width="20%" align="left"><?= TABLE_HEADING_MONTH ?></td> <td class="dataTableHeadingContent" width="20%" align="right"><?= TABLE_HEADING_TOTAL_SALES_NET ?></td> <td class="dataTableHeadingContent" width="20%" align="right"><?= TABLE_HEADING_TOTAL_SHIPPING ?></td> <td class="dataTableHeadingContent" width="20%" align="right"><?= TABLE_HEADING_TOTAL_TAX ?></td> <td class="dataTableHeadingContent" width="20%" align="right"><?= TABLE_HEADING_TOTAL_SALES_GROSS ?></td> </tr> <? $months_query = tep_db_query( "SELECT DISTINCT( monthname( date_purchased ) ) AS month, month( date_purchased ) AS m FROM " . TABLE_ORDERS . " WHERE date_purchased LIKE '" . $years['y'] . "-%' ORDER BY date_purchased DESC" ); while ( $months = tep_db_fetch_array( $months_query ) ) { $net_total_query = tep_db_query( "SELECT SUM( value ) AS total FROM orders_total ot, orders o WHERE ot.orders_id=o.orders_id AND year( o.date_purchased ) = " . $years['y'] . " AND month( o.date_purchased ) = " . $months['m'] . " AND ot.class = 'ot_subtotal'" ); $net_total = tep_db_fetch_array( $net_total_query ); $shipping_total_query = tep_db_query( "SELECT SUM( value ) AS total FROM orders_total ot, orders o WHERE ot.orders_id=o.orders_id AND year( o.date_purchased ) = " . $years['y'] . " AND month( o.date_purchased ) = " . $months['m'] . " AND ot.class = 'ot_shipping'" ); $shipping_total = tep_db_fetch_array( $shipping_total_query ); $tax_total_query = tep_db_query( "SELECT SUM( value ) AS total FROM orders_total ot, orders o WHERE ot.orders_id=o.orders_id AND year( o.date_purchased ) = " . $years['y'] . " AND month( o.date_purchased ) = " . $months['m'] . " AND ot.class = 'ot_tax'" ); $tax_total = tep_db_fetch_array( $tax_total_query ); $yearly_running_net_total += $net_total['total']; $yearly_running_shipping_total += $shipping_total['total']; $yearly_running_tax_total += $tax_total['total']; $total_running_net_total += $net_total['total']; $total_running_shipping_total += $shipping_total['total']; $total_running_tax_total += $tax_total['total']; ?> <tr class="dataTableRow"> <td class="dataTableContent"><a href="stats_detailed_monthly_sales.php?year=<?= $years['y'] ?>&amp;month=<?= $months['month'] ?>"><?= $months['month'] ?></a></td> <td class="dataTableContent" align="right">$<?= number_format( $net_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $shipping_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $tax_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $net_total['total'] + $shipping_total['total'] + $tax_total['total'], 2 ) ?></td> </tr> <? $count ++; } ?> <tr class="dataTableHeadingRow"> <td class="dataTableContent"><?= $years['y'] ?> Total</a></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $yearly_running_net_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $yearly_running_shipping_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $yearly_running_tax_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $yearly_running_net_total + $yearly_running_shipping_total + $yearly_running_tax_total, 2 ) ?></td> </tr> <? $yearly_running_net_total =0; $yearly_running_shipping_total =0; $yearly_running_tax_total =0; } ?> <tr> <td colspan="5">&nbsp;</td> </tr> <tr> <td class="pageHeading" colspan="5">TOTAL</td> </tr> <tr class="dataTableHeadingRow"> <td class="dataTableContent">Store Total</a></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $total_running_net_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $total_running_shipping_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $total_running_tax_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $total_running_net_total + $total_running_shipping_total + $total_running_tax_total, 2 ) ?></td> </tr> <? } ?> </table> </td> </tr> </table> <? if ( ! $_REQUEST['print'] ) require(DIR_WS_INCLUDES . 'template_bottom.php'); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> </body> </html>
  5. Hi, I'm installing a small reporting contribution that states: In the file '/admin/includes/filenames.php', add the following line: define('FILENAME_STATS_DETAILED_MONTHLY_SALES', 'stats_detailed_monthly_sales.php'); However this file does not seem to exist in 2.3. Please can someone tell me where this define now goes? Many thanks. Paul
  6. Thank you for the reply. Its that first aspect I'm struggling with.
  7. 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'); ?>
  8. Thanks Jack and I've not seen a commercial area so will try to track it down.
  9. Thanks @Jack_mcs, You are definitely giving wise advice. My issue is that (a) I don't have the skills to migrate and upgrade myself, (b) it's a small business website so needs to remain operational and (c) I wouldn't know where to look for someone capable to carry out and support the upgrades. I've been with osC MS2.2 since around 2005 and have always loved it so contemplating a move is traumatic to say the least! Paul
  10. Thank you both for your comments and information.Really helpful. As much as I love my old osC site and CE is appealing, it actually sounds as though it could be time to move on to a new site and a new platform. Thank you again. Paul
  11. Hi, I have a long standing osCommerce 2.2-MS2 site that over time was pretty heavily modified. Is it possible somehow to make this site responsive so that its suitable for use on tablets and mobile devices? I'm really not keen to have to migrate to a new platform but these days responsive is becoming important. Many thanks for any input or suggestions. Paul
  12. pafranklin

    Shop redirect, htaccess

    Thank you everyone for your help. Very much appreciated and all working now :) Best regards. Paul
  13. pafranklin

    Shop redirect, htaccess

    Hi, Thank you for the help so far - I am eternally grateful! I think I'm really close and after some input from the webhosts have the following: #redirect index.php to root #RewriteCond %{THE_REQUEST} ^[A-Z]{3,9}\ /index\.php\ HTTP/ #RewriteRule ^index\.php$ https://www.martinberrillsports.com/ [R=301,L] #redirect non-www to www #RewriteCond %{HTTP_HOST} ^martinberrillsports\.com #RewriteRule ^(.*)$ https://www.martinberrillsports.com/$1 [R=permanent,L] RewriteEngine On RewriteCond %{ENV:HTTPS} !=on RewriteRule ^.*$ https://www.%{SERVER_NAME}%{REQUEST_URI} [R,L] The only remaining problem seems to be that http://www.martinberrillsports.com redirects to https://www.www.martinberrillsports.com. Please can anyone see which redirect is causing this and how to correct? Many thanks in advance. Paul
  14. pafranklin

    Shop redirect, htaccess

    Thank you for spotting the missing ".". I have checked and it definitely should be Port 80 but when added this seems to "break" the site.
  15. pafranklin

    Shop redirect, htaccess

    Hi, Yes I did current extract from .htaccess is: RewriteEngine On RewriteBase / RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-c-(.*).html$ index.php?cPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-m-(.*).html$ index.php?manufacturers_id=$2&%{QUERY_STRING} #redirect index.php to root RewriteCond %{THE_REQUEST} ^[A-Z]{3,9}\ /index\.php\ HTTP/ RewriteRule ^index\.php$ https://www.martinberrillsportscom/ [R=301,L] #redirect non-www to www RewriteCond %{HTTP_HOST} ^example\.com RewriteRule ^(.*)$ https://www.martinberrillsports.com/$1 [R=permanent,L] However adding this next bit results in website not loading / crashing. RewriteCond %{SERVER_PORT} 80RewriteRule ^(.*)$ https://www.martinberrillsports.com/$1 [R,L] Thank you. Paul
×