bruyndoncx

think i have done this as an extension to seo urls, gotta dig up some code ...

the sort order is missing from your configuration, probably you need to add the field into your product listing first for it to be available as sort option under mega menu.

I really prefer a separate country and language selection like all big brands do nowadays

I attended local seminar about GDPR by our accounting firm and their security and audit department. Basically GDPR lays out common sense for security measures to protect the privacy of personall data of your customers. Plus you need to document who the consumer can contact for personal data (verification, correction or removal) Adres information that you keep with the orders in the accounts is not sensitive data. If you start to profile and keep track of the age of their kids and stuff then you can become in the grey area of things. If you have a doctors practice with medical records that is a big difference from an ecommerce operation. So you need to do common sense to ensure data theft is not possible (securing logins, pasword policy, no usb stick backups, servers behind lock). Make sure that (paper) processes are documented and paper records are destroyed so that private and sensitive personal data can not end up in the wrong hands. Also in a bigger setting with sensitive data, staff should only have access to the (sensitive) data that they need to know. Eg the janitor should not be able to access medical records to be blunt about it ... :D I personally think it is a good effort to raise the awareness, it is just peoples reaction is over the top if they don't understand the concept of sensitive data and overall risk mitigation. Edit: big caveat, if you sell personal data then you are in trouble :D

how about spelling out the where clause with numerics without the year and adding the specific year end and year begin as extra where or where statements besides the typical date ranage ? (%c and %d) not using any year reference in the where clause. Sorry, I'm still pretty busy, might have some time tonight ...

I just have the specials page sorted by specials_id desc, so newly added show first ... would that work for you ?

i did check some account file didnt see it, should have checkef better Good job @burt

fyi https://mobiforge.com/design-development/html5-mobile-web-forms-and-input-types this triggers the appropriate mobile keyboard

multisafepay creates the order first with an awaiting payment status and then updates to payment received and sends the order confirmation email

noop you dont tep_db_fetch_array is needed even if you just return one field in one row, it is still an array needing parsing

You are missing code to fetch the result array Googling tep_db_query has this nice tutorial on mysql, and the oscommerce equivalent code required http://www.oscommerce-template-easy.com/basic-php-mysql-tutorial-for-oscommerce/mysql-database-query.html HTH

in mysql 5.6 you have the locate function with this as example, if you cannot order by immediately in the sql, you can wrap it in an extra sql clause and order in the outer clause SELECT pub_name,LOCATE('at',pub_name) FROM publisher WHERE locate('at',pub_name)>0;

think you have to add a routine to the freeamount routine to disable it when a product from that category is in the order. maybe you can post yhe shipping module you use and someone can tell you what needs to be inserted where exactly ...