Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

  • Days Won


douglaswalker last won the day on July 21 2021

douglaswalker had the most liked content!


About douglaswalker

  • Birthday 04/30/1967

Profile Information

  • Real Name
  • Gender
  • Location
    Western Australia

Recent Profile Visitors

19,810 profile views
  1. douglaswalker

    osCommerce site and Forums update notice

    Those apps are also a wonderful way to learn about code and to get ideas etc. A very bad decision to remove them. Hopefully one that will be rectified.
  2. douglaswalker

    Help with SQL

    Hi there I am trying to access 3 tables in Oscommerce Database to pull some orders showing products and attributes but cant get it to work. Just says I have an error in my SQL I am selecting from orders and orders_products and orders_products_attributes linked by orders_id... This is the original $products_query = tep_db_query("SELECT op.products_model, op.orders_id, op.products_quantity FROM orders_products op LEFT JOIN orders o ON op.orders_id = o.orders_id where op.orders_id IN (" . $orders_implode . ") and op.clubosc_shipping_type != 'dropshipped' ORDER BY op.orders_id DESC, op.products_id DESC"); This is what I have attempted $products_query = tep_db_query("SELECT op.products_model, op.orders_id, op.products_quantity, opa.orders_id, opa.products_options_values, FROM orders_products op, orders_products_attributes opa LEFT JOIN orders o ON op.orders_id = o.o orders_id JOIN orders_products op ON opa.orders_id = op.op orders_id where opa.orders_id IN (" . $orders_implode . ") and op.clubosc_shipping_type != 'dropshipped' ORDER BY op.orders_id DESC, op.products_id DESC");
  3. douglaswalker

    htaccess redirect

    Thank you sorry I should have been clearer product-name changes and so does 64.html only -pr- and -p- stays the same
  4. douglaswalker

    htaccess redirect

    Hi all I am trying to redirect a url in htaccess which is formed like this https://www.mysite.com.au/product-name-pr-64.html I need to remove the -pr- bit and replace it with -p- so it looks like this and 301 redirects https://www.mysite.com.au/product-name-p-64.html
  5. douglaswalker

    [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

    @BrockleyJohn Doh... yes of course.. anyway they are creating correctly I just checked,,, also now not getting the CHARSET error.. but the error below is still there when using afterpay and afterpay then returns the customer to the site after payment ..successful or otherwise... that error has always been there and is not to do with the php version... ahh sigh... This is the line in the seo class function InsertID() { return mysqli_insert_id($this->link_id); } PHP Warning: mysqli_insert_id() expects parameter 1 to be mysqli, null given
  6. douglaswalker

    [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

    Hi there... yes the urls are all being created perfectly elsewhere with the cache either on or off and i get no errors unless one of the payment modules are called I did wonder why the seo class was being called on the checkout pages as it is not needed there . I wondered like a module if there was a way to turn it off for those pages.
  7. douglaswalker

    [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

    @ecartz @Jack_mcsIt is still in my installation but as a define not a const ...can that be the issue? the only other one is also to do with a payment module when it calls back to the site. These are the only 2 warnings I now receive on php7.3 and both involve the seo.class.php The payment modules all work correctly so it is more something i am interested to find out why the mysqli warning happen. I have discovered it has always been there with the particular payment module and i just picked it up during the upgrade. PHP Warning: mysqli_insert_id() expects parameter 1 to be mysqli, null given in /home/***/public_html/includes/classes/seo.class.php on line 147
  8. douglaswalker

    [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

    Hi @Jack_mcs I have recently upgraded a bootstrap Gold/Frozen/Edge site to php 7.3 all is functioning well. I do however get a few warnings about the seo.class.php. Seems mostly to happen during checkout.. which is interesting because seo urls are not used during the checkout but I guess the class is still be called. Anyway the warning is Use of undefined constant CHARSET - assumed 'CHARSET' (this will throw an Error in a future version of PHP) in /home/woodtoys/public_html/includes/classes/seo.class.php on line 1831 I know this is not a big deal but would like to know what the issue might be. Doug
  9. douglaswalker

    [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

    Thank-you that did the trick
  10. douglaswalker

    [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

    @BrockleyJohn not sure what i am doing wrong here. I will go through the steps again and write them here to see if anyone can spot the issue https://www.site.com.au/product_info.php?cPath=28& &(space here)products_id=71 is a link that google has picked up somewhere on the web. It has a space wrongly placed between cPath=28&(space here) products_id=71 This is creating the page to fail and try to redirect over and over. It ultimately needs to go to https://www.mysite.com.au/product-product--toy-p-71.html once it has passed through SEO urls program So I am trying to strip the space out of cPath=28&(space here) products_id=71 using htaccess RewriteRule ^([^\s%20]*)(?:\s|%20)+(.*)$ $1$2 [L,R] then send it on its way. However the htaccess is not working
  11. douglaswalker

    [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

    The htaccecss file works for urls like https://www.site.com/name-of-product(accidentalspace)-p-1000.html but not https://www.site.com/product_info?cPath=28&(spaceishere)products_id=1000 I thought it should remove the incorrect space and then the program takes over and redirects to the properly formed url
  12. douglaswalker

    [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

    The htaccess bit I couldnt get to work. i placed it above all the other code. It goes to page not working. could it be this bit as i don't want to add just remove # replace spaces by - in between RewriteRule ^([^\s%20]*)(?:\s|%20)+(.*)$ $1-$2 [L,R]
  13. douglaswalker

    [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

    Thanks so much for this I re-coded the shopping cart header module using the code from the column box module so avoided sprintf public function getOutput() { GLOBAL $cart, $currencies, $PHP_SELF; $cart_contents_string = ''; if ($cart->count_contents() > 0) { $cart_contents_string = NULL; $products = $cart->get_products(); for ($i=0, $n=sizeof($products); $i<$n; $i++) { $cart_contents_string .= '<li>'; $cart_contents_string .= '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products[$i]['id']) . '">'; $cart_contents_string .= $products[$i]['quantity'] . '&nbsp;x&nbsp;'; $cart_contents_string .= $products[$i]['name']; $cart_contents_string .= '</a></li>'; } } and then called <?php echo $cart_contents_string; ?> in the template file will sort out the htaccess part you have offered when the site is a bit quieter
  14. douglaswalker

    [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

    The other question I have is over the years a few people have linked to the site incorrectly leaving a white space in the url which becomes %20 is there a way to use htaccess or any other method to strip out any whitespaces before any other redirects happen. The url in question is https://www.site.com/product_info?cPath=28&(spaceishere)products_id=1000