Jump to content
Latest News: (loading..)


  • Content count

  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    jonathan steward
  1. jonsteward

    [Contribution] Product Sort Order

    I have tried to install this contribution but I am getting the following error whilst trying to view my products can someone tell me why? 1054 - Unknown column 'p.products_sort_order' in 'field list' select p.products_sort_order, p.products_image, pd.products_name, m.manufacturers_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_sort_order, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '68' order by p.products_sort_order limit 0, 20 [TEP STOP]
  2. jonsteward

    [Contribution] CC_CVV+UK Switch v1.0

    Has anybody got the switch validation running reliably yet on the post November snapshot.
  3. jonsteward

    [Contribution] CC_CVV+UK Switch v1.0

    I changed the } elseif (ereg('^6759[0-9]{2}([0-9]{10})?$', $this->cc_number)) { $this->cc_type = 'UK Switch'; to } elseif (ereg('^6759[0-9]{2}([0-9]{12})?$', $this->cc_number)) { $this->cc_type = 'UK Switch'; and now my HSBC card works the only problem is my Natwest card won't work. I think it is because it has 19 digits. I then changed } elseif (ereg('^6759[0-9]{2}([0-9]{12})?$', $this->cc_number)) { $this->cc_type = 'UK Switch'; to } elseif (ereg('^6759[0-9]{2}([0-9]{13})?$', $this->cc_number)) { $this->cc_type = 'UK Switch'; but now my HSBC card won't work. I have now set it up like: } elseif (ereg('^6759[0-9]{2}([0-9]{13})?$', $this->cc_number)) { $this->cc_type = 'UK Switch'; } elseif (ereg('^6759[0-9]{2}([0-9]{13})?$', $this->cc_number)) { $this->cc_type = 'UK Switch'; and now both my cards work but i'm a bit worried that other peoples card's might not work.