Jump to content
Latest News: (loading..)


  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by burt

  1. https://github.com/gburton/Responsive-osCommerce/releases/tag/2341-Frozen There will be no further Code Changes. Issues will be immediately closed. What is broken, stays broken. PRs will be immediately closed. What is now there, is there. Thank You to all Shopowners and Developers who have supported the Project in the last 4 and a bit years. Personal Thanks go out to all those Shopowners who were able to support my 28d bits and pieces for 3 of those 4 years - it is you guys who have made it possible for the hundreds of other Shopowners to continue using osCommerce. A big Thank You and from me, I will not leave you guys high and dry - you have my support always, we are a Band Of Brothers. Onwards!
  2. 28d, 2018

    Here is the next part of the Puzzle. 0:00 Donald Duck makes an account using create_account.php on this page there is a MATC checkbox that MUST be ticked to allow the account to be created also two modals, one for privacy, one for terms Donald agrees and sets up an account. 0:36 Donald now goes to account.php and clicks to get to the GDPR page 0:44 Donald now sees everything the site knows about him of particular interest is SITE ACTIONS, where shopowner has stored the fact that Donald signed up *and* agreed to T&C/Privacy In the Database, shopowner has also stored the details; 1:03 Donald now checks out. 1:24 Donald hits checkout_confirmation.php on this page there is a MATC checkbox that MUST be ticked to allow the order to be processed also two modals, one for privacy, one for terms Donald agrees and completes his Order 2:04 Donald now goes back to GDPR page of particular interest is SITE ACTIONS, where shopowner has stored the fact that Donald agreed to his details being passed to external companies In the Database, shopowner has also stored the details;
  3. Third installment of the 28d Project. I missed last year for reasons, but this year it's back. I'm running it slightly differently to previous versions, as this time there will be no option to buy each days package - that was frustratingly difficult to manage - sorry. Instead there will be a very simple "buy now" price for everything, and that will go up in price as February goes by, therefore those who can buy earlier...pay less...and those who buy later...pay more. Hit the [Follow] button in the right hand corner of this page as I shall be updating this post as the days go by. Should anyone wish to pre-buy...thank you for your consideration and support. PM me and we can arrange it. Don't know what the 28d Project is? I make code available during February (each year, usually). This is code that I have created or updated and make available for an all-in price. Had a couple of questions by PM; Edge Compatible: Yes Gold Compatible: Yes(ish), you might need to update some files to the Edge version, I will point these out in the individual "readme" for each. Certainly nothing to be worried about! PHP7 Compatible: Yes Official osCommerce Compatible: No, sorry Core Code Changes: Will be kept to an absolute minimum, you guys know I hate to change Core and I know you guys hate Core Code Changes...but sometimes, it is, unfortunately, unavoidable. Progress: I have 21 things coded and ready for finalised checking. 1 thing is being live tested by a shop. 6 or 7 things more to write; ideas would be welcomed for small to medium things Thanks for all the PMs and Feedback so far!
  4. http://template.me.uk/234bs3/index.php?cPath=3_10 Please go here and test Grid/List system. Any problems ?
  5. 28d, 2018

    Updated "IP Address" module has just been emailed. Thank You. And, FAIR WARN; Price of 28d package has been the same for the last 5 months. I'm increasing the price on Saturday 26th
  6. Here's what I want to get done to set the Community Version to a "Final" release; 1a. Modularisation of index COMPLETE Title Standardise Module Name and Template Name (each) 1b. Modularisation of index_nested COMPLETE Title Standardise Module Name and Template Name (each) 1c. Modularisation of index_products COMPLETE @BrockleyJohn has coded, thank you Title Description Products 2. Modularisation of product_info COMPLETE Strip Schema Schema Buttons Date Info Options Description Gallery Price Name Model Not Found Message Standardise Module Name and Template Name (each) 3. Bootstrap v4 CANCELLED Updating full shopside to BSv4 4. php7.0 COMPLETE Updating full shopside and full adminside to be 7.0 compliant. 5. getContent calls DISCUSSION Discussion needed 6. Hook calls COMPLETE @raiwa has coded, thank you Auto Register Hook for each page What I don't have plans for, so will not happen; Everything else Why go "Final" Too many shopowners and developers wanting a fixed release; almost all feedback tells me rolling updates are not welcome. After "Final" No further changes will be made. Date for "Final" I was hoping to get it done by the end of this Month, but that is not going to happen. Sorry Folks, it'll be as and when I have time.
  7. Dead? It's at a place I am mostly happy with; php7, a bit modular, responsive etc. Good Luck to all Shopowners.
  8. 28d, 2018

    Updated "Contact Details" module has just been emailed. Thank You.
  9. MATC

    I'd say in two places; create_account.php a. records the customer signed up on X date at X time and that he says he has read your Terms/Privacy policies b. It also appears that best practice is to store the exact terms/privacy that the client signed up to. checkout_confirmation.php a. records the customer giving her permission for you to possibly divulge some of her details to external companies - payment processor, mail delivery, perhaps other things ? For #2 I say checkout_confirmation as that is the last page in the checkout procedure prior to the order being placed - I think we all agree that consent must come before the order is placed. I place it on that page also because by the time this page is reached...buyer has already made the buying decision so 1 extra tickbox here is not a deal breaker..
  10. 28d, 2018

    Updates to come prior to 25th, all of which have been pointed out by users; Missing "Telephone" in gdpr_contact_details [emailed 9:55 on 21.05] Include stored IP addresses from action_recorder table in gdpr_ip_addresses [emailed 11:50 on 22.05] There will also be updates to add in more anonymize/delete buttons as well. I am also working out some logic to have a system of checkboxes which will allow shopowner to record consent... <--- I will need a guinea-pig for that if possible please...
  11. Thank you to all for testing. This code is now in 2341CE (aka Frozen).
  12. Any responsive site now has another advantage over a non-responsive site.
  13. @14steve14 Obviously with a backup done first!! This first query is the "Master Blaster"... delete from customers where customers_id not in (select customers_id from orders) and customers_newsletter = 0 that will remove all customers that have never made an order AND are not a subscriber. You then need to clean out other tables, and we know that any ID that does not exist in the customers table, should not exist anywhere else; delete from action_recorder where user_id NOT IN (select customers_id from customers); delete from address_book where customers_id NOT IN (select customers_id from customers); delete from customers_basket where customers_id NOT IN (select customers_id from customers); delete from customers_basket_attributes where customers_id NOT IN (select customers_id from customers); delete from customers_info where customers_info_id NOT IN (select customers_id from customers); delete from products_notifications where customers_id NOT IN (select customers_id from customers); delete from whos_online where customer_id NOT IN (select customers_id from customers); delete from reviews where customer_id NOT IN (select customers_id from customers); delete from reviews_description where reviews_id NOT IN (select reviews_id from reviews); And that should do it. But all of this is UNTESTED...
  14. Good catch, yes I think it does. I'm still going to remove it though, one less thing to load each page.
  15. Thank you all for testing. Another bonus to this new system is that the page loads faster as it does not need to pull in this file; https://github.com/gburton/Responsive-osCommerce/blob/master/ext/jquery/cookie.js This is only a small file, admittedly. But it is an extra request that has to be performed. 1 less request = faster page.
  16. 28d, 2018

    Part of the GDPR list of to-do's is "Data Portability". If a customer asks shopowner for a portable copy of his/her data, you must action this within 30 days. I guesstimate that collating all the data is going to take around 30 minutes for an experienced [knows a bit of osc, the database, where to find the data] shopowner to a couple of hours for an inexperienced shopowner... Now, let us imagine that at the start of the GDPR Era, customers of shops go mad for wanting their data, and you get 4 requests per week for customer data. At the least this is TWO HOURS of wasted time! With the latest Mod (which everyone does now have)...all you have to do when you get such a request; Now instead of taking 2 hours to do 4 of these customers each week, it'll take you 30 seconds to ask them to login and download their data Let us say that instead of 4 per week, you get 4 per day (this is not outside the realms of possibility) as the whole of Europe now has access to their data ...and that would be at least hours out of each week. In My Opinion Module pays for itself after the first couple of Data requests Upcoming I still have a couple more pieces of the GDPR jigsaw puzzle to come, and these will come before the 25th. I want to try to help to smooth what could be a rough time for us all.
  17. The main reason I would like to use this new code is to dump this Cookie that the grid_list uses. If we can dump that Cookie, shopowners may no longer have to ask people to accept Cookies as all the Cookies in the Edge download are then absolutely required for it to perform its primary function => allow shoppers to buy your stuff. Please feel free to have your say on that.
  18. http://template.me.uk/234bs3/products_new.php or http://template.me.uk/234bs3/index.php?cPath=3_10
  19. http://ec.europa.eu/ipg/basics/legal/cookies/index_en.htm EU Legislation On Cookies (I have highlighted the relevant parts for osCommerce, by *my* understanding); BLAH BLAH ... some cookies are exempt from this requirement. Consent is not required if the cookie is: used for the sole purpose of carrying out the transmission of a communication, and strictly necessary in order for the provider of an information society service explicitly required by the user to provide that service. Cookies clearly exempt from consent according to the EU advisory body on data protection include; user‑input cookies (session-id) such as first‑party cookies to keep track of the user's input when filling online forms, shopping carts, etc., for the duration of a session or persistent cookies limited to a few hours in some cases authentication cookies, to identify the user once he has logged in, for the duration of a session user‑centric security cookies, used to detect authentication abuses, for a limited persistent duration multimedia content player cookies, used to store technical data to play back video or audio content, for the duration of a session load‑balancing cookies, for the duration of session user‑interface customisation cookies such as language or font preferences, for the duration of a session (or slightly longer) third‑party social plug‑in content‑sharing cookies, for logged‑in members of a social network. So, we can clearly (by *my* understanding) not have to do anything about cookie acceptance for; please_accept_for_session aka "cookie test" oscSid As both of these Cookies; do not include any personal data are absolutely required by the software for the software to function Anyone else like to add more thoughts? Other NOT ESSENTIAL Cookies If shopowner has other cookies on board....that DO have personal info (eg Analytics passing IP Address) or ARE not required by the software to perform its function (sell stuff)...then shopowner must get permission for these cookies. There is ONE cookie in Edge that shopowner MUST get permission for as it is a Cookie that is useless to the softwares primary function: the cookie in the ht_grid_list module. If I can get rid of that Cookie, we are good to go (in my opinion).
  20. That has always been the case (very brief show of list) if grid is selected, even with the old list/grid thing. No ?
  21. 28d, 2018

    Updated GDPR Mods are sent. If anyone needs help to install, please *email* me.
  22. Price should be set to $99999999999999.00 in this case. Where is the problem? So long as you check that the input here is a number, you are good to go; filter_var($input, FILTER_VALIDATE_FLOAT) Note that this is good for "0" prices as well, and should also allow fractional prices; 9.99 You maybe allowing fractional prices as it is much easier to spend 9.99 than it is to spend 10 (mentally).
  23. Example site of (more or less) 2.3.4 with Bootstrap 3. http://template.me.uk/234bs3/index.php Please point out any areas that you feel need attention. Thanks Gold Download: https://github.com/gburton/osCommerce-234-bootstrap/archive/v2.3.4-GOLD.zip EDGE: Gold + Extra Commits such as bugfixes: https://github.com/gburton/osCommerce-234-bootstrap/archive/master.zip