Searching and fixing

After getting this site to a point that it is fully functional and really just needs refinement and bug fixes more than anything I had taken a break from working on it although I have still been adding in films as I watch them. This was until I noticed a few little silly mistakes I had made in my haste to get the site fully functional. Whilst these do not break the site, they do show wrong information. For example when there is a count of films on a list it counts the total films logged to the list as you woudl expect. Unfortunately it also counts films that are not published yet so the count ends up off. I fixed this thanks to a tweak to the stored procedure, I also found another page, where something similar was happening and fixed this as well.

On the page where all the lists are displayed I added in a new column, so you can see when the lists were last updated along with the list name and the amount of films on that list. That way it makes it easier to keep track of and you can see how active a list is.

There were a few other minor things I spotted and foxed as I was going along, but these were mostly cosmetic and did not add or amend any of the functionality currently on the site. I have thought realised that my fix in the admin section for peoples names I have made a mistake. Now this is more about how that information is validated before added to the database not about the current information in the database thankfully. So I will be working on a little bit of functionality to sort this, I should be able to re-use some of the code I have already done else where and amend it to work here.