Another late night again

I cannot wait to share CF Shopkart 5.4 with all of you. Everything is running great so far in testing. I've had to fix a few minor things late today, but so far all seems to be going great as far as mysql is concerned.

Tomorrow I am going to test with MS Access and then do a followup on testing PayPal IPN to make sure that it is still working. Someone told me the the other day that it wasn't. I tried to fix it without getting into heavy testing, but haven't heard anything back. Hopefully it's working now. I will know tomorrow.

I finished today with adding CFQUERYPARAM tags to all the queries on the front end and some critical queries in the admin during the login and loading. This should really help big on keeping any hackers from being successful with the mysql injection attacks.

Among other security enhancements I have added in a check for such attacks when the site loads. Additionally, the page request is checked to see if index.cfm is called and if it's not, then it promptly redirects to it. This will keep people from trying to load any of the coldfusion scripts directly into their browser without going through the index file first.

I've also accomplished the following today:

- The email item link is back and working much better than before.
- Fixed a couple minor bugs in the wish lists feature.
- Added ability to turn on and off the wish lists feature in the settings.
- Now when you add a coupon for a specific item, it also adds the item to the cart.
- Coupons can be added via url now:
http://www.yourdomain.com/index.cfm?action=addtocart&couponcode=12345
- Changed the way option form fields assignments are stored in the database (no more list in products table. It's now a separate table). This was necessary for future enhancements.
- Fixed up the options administration in the control panel.
- Improved styles throughout the control panel.
- Completely redid the details page. I've broken up the elements of that page into separate files and changed the layout up some. It should be a lot easier to edit and customize it now!
- I've gone through all the bug reports that were sent and addressed every single one that I was able to.

Again, thanks to all those who submitted bug reports for version 5.3. It's been a BIG help!