Jump to content
Latest News: (loading..)

JcMagpie

♥Ambassador
  • Content count

    1,369
  • Joined

  • Last visited

  • Days Won

    93

Everything posted by JcMagpie

  1. JcMagpie

    Moving from HTTP to HTTPS

    You are using a custom template which is calling many of it's resources from http: sites. You can either go back to the person you got the template and ask for an update to a SSL version or edit all the files to replace http with https and if they all have https alternatives ( and they probably will) you should be fine.
  2. JcMagpie

    Removing fake customers

    In my testing I could not get the code to break by simply removing data or messing data up in either the customer table , customer_info tabel or both.. The code just simply did not allow you to select the broken customer in admin/ customer So in Frozen which is what I did the testing the code is fine. Must be somthing else going on.
  3. JcMagpie

    Removing fake customers

    Yes Jack provides the edits for 3 pages, But you can add code to other pages.
  4. JcMagpie

    Moving from HTTP to HTTPS

    Sorry for second point you need to check and make sure your admin config seeting match your redirect. Or try stock redirect. RewriteEngine On RewriteCond %{HTTPS} off [OR] RewriteCond %{HTTP_HOST} ^www\. [NC] # this makes it a permanent redirect RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI} [R=301,L]
  5. JcMagpie

    Removing fake customers

    Happy to report installed @Jack_mcs HoneyPot yesterday and this morning problem site has seen a 90% reduction in spam. The stuff still getting in is geting past Google reCaptcha as well so I think the sod's are doing manual spamming as well. Still very happy with results. Thanks Jack
  6. JcMagpie

    Moving from HTTP to HTTPS

    You have mixed content on your site. Use browser inspect tool to see it. Edit the relavent files and replace http: with https:
  7. JcMagpie

    Removing fake customers

    I think that could be the case as I can not reproduce your error by removing data from a test account. You should take one or two of the emails and see if they are linked to any orders! As I said the emails look valid but names are jibrish as if they have been over writen by a script. I would also run a virus scan on your db and site.
  8. JcMagpie

    Removing fake customers

    😊 it is what it is. I did a few checks on my test site and I was unable to produce the error you have by simply removing data from customers or customer_info tables or changing it. The only way I was able to brake customers deleat was by chnging a customer id so it did not match that in customer_info but all that did was stop that customer from beeing selected. So I would say somthing else is going on with your db.
  9. JcMagpie

    Removing fake customers

    looking at your error codes you get, which would point to an issue in the data that is beeing merged posiably id's not matching up?
  10. JcMagpie

    Removing fake customers

    That's not relavent if your using CE as they all say 2.3.4.1! But if you go to admin/tools/version checker it will show you somthing like this,
  11. JcMagpie

    Removing fake customers

    ok that would explain that 😂
  12. JcMagpie

    Removing fake customers

    I'm not sure they are fake accounts! You bettter check first! Looking at some of the email used I would say it looks like your database has been comprmised and some data overwriten.
  13. JcMagpie

    Removing fake customers

    ok it's odd but looks like the fake accounts have no dob set! Have you checked?
  14. JcMagpie

    Removing fake customers

    No all you need to do is deleate from customer table.
  15. JcMagpie

    Removing fake customers

    That data looks fine. I would simply back up your database and then deleat one of the bad accounts. Log back in and check if all is well tthen simply remove the others. compare it to stock data.
  16. JcMagpie

    Removing fake customers

    Any input form on your site that accepts input from a user and stores it in your database is open to abuse. You just have to do what you can to secure each one. @Jack_mcs Honeypot lets you pick which pages to cover so should work for most issues. If it’s some idiot sitting at a pc with time on there hands doing the spamming ( and there are many doing this) then there is very little you can do to stop them. Blocking IP’s works for a while but the just move to another using VPN’s! If it’s bot’s then the honeypot should catch most of them. They look at the code and when they find a form/input filed they dump rubbish into it. Honeypots normally add a hidden ( to the user) filed to the page which the user will not see but the bot’s will and they dump rubbish into it which tells the honeypot that it’s not a human and it can block that bot.
  17. JcMagpie

    Removing fake customers

    remove them using phpMyAdmin directly in the db in customers table it will overcome this issue. I would imagine that the garbage they entered when making the account is causing issues.
  18. JcMagpie

    Removing fake customers

    Just checked Jack and it looks as if I have honypot on all the sites that have no spam! the few that have spam problems did not have it! So I guess problem solved! Note to self, stop beeing stupid and use what already works 😂. HoneyPot beeing installed now.
  19. JcMagpie

    Removing fake customers

    I have used a basic image captcha on that page but they get round it somehow! IP's are all over the place so that's not an option. I've just installed the Google reCAPTCHA found this add-on by @Demitry in the apps! must have missed it before! https://apps.oscommerce.com/f2UI4&recaptcha-2-form-validation-for-bs-edge Install needed a small edit to core files and to each page you need it on. Did not work for contactus page was a small error in code, Not found a support thread linked to the app but the change was easy fix, simply change in install instructions all cases of require(DIR_WS_CLASSES . 'recaptcha.php'); to require('includes/classes/recaptcha.php'); So let's see if the sod's get past this one.
  20. JcMagpie

    Removing fake customers

    I have found that my main issue on my osC test site is the contact_us page! I have it set so you can only resend after 30 miniutes but the sod's get round this by just using different emails. From look into this I think that the only solution is to install Google captcha to this and any other forms like make account and reviews, basickly any submit saving to db should have it applied. Only problem is this requires quite a lot of core changes in osC to implament fully.
  21. JcMagpie

    Removing fake customers

    Sorry about that I mistakenly uploaded the old code! This is what I used to clean the db. The plus was I could filter the large db by date and do a delet between dates or delet individual customers. As Jack said using the optimizer will probably help tidy up the db. Also not wating too long before cleaning would also help 😊 a little weekly house keeping would have avoided me having to clean 10 year old unused accounts! inactiveuser_CE_2_4.zip
  22. JcMagpie

    Display map to track shipment progress

    Customers are strange beings! We did not need to do that as we could simply add the customers email address into the shipping portal when booking the delivery. The customer then was automaticity notified by email with his/her tracking details. We had to remove this function as we had lots of complaints about receiving the tracking email. We now manually forward the link to any customer that requests it ( very few do!). anyone intrested in the tracking box can see it on the test site. Auto Geolocation should be working so you should see map update to your location. https://chilleddisplays.co.uk/
  23. JcMagpie

    New install. Error on admin page.

    Where did you download your software from! I suspect you got it from your webhost, if so they have an out of date version. The official version has been updated to work with MySQli so you should not get that error at all. If you want to keep using the official version and many webhost's will only support the official software then down load it from here. https://www.oscommerce.com/Products Having recently installed the official version I can tell you it works fine. However if your host allows then do install the Bootstrap version just be aware it's not official. official version as you can see line 19 is blank! and db is mysqli.
  24. JcMagpie

    Display map to track shipment progress

    Well failed miserably with this one! Could not find any API to use for testing so gave up. Managed to get the openmaps to finally behave and got leafletjs auto-geolocate to function with openmaps. Adding additional locations by pulling geo data from the shipping companies should not be too difficult it’s just getting access to the API’s that's the problem. So just got tracking option and geolocation map in box, will have to do for now.
  25. JcMagpie

    Display map to track shipment progress

    I had a look Eric and Google now have the API behind a payment login. You have to accept T&C and provide billing ie card data before they will issue a API they no longer supply development API's only the first $200 is free after tht they charge. I asked if I could have a test API but no joy. I looked at UPS and FDEX and both require you register before they let you have acess to the development SDK's so again unable to test. Marking the start point and end pint on the map is easy, it's the inbetween that's the problem as UP's only supplys this data in the US to some customers. Fedex are the same, Map View FedEx Delivery Manager® members can use map views to track a package visually: So it looks like Map view is a premium service. You can only do this if the tracking number is linked to the customer! which means it must be added to the db?
×