There’s a current-age thingy now

Y’all might have noticed that now, in cases where there’s a date of birth available, the computer automatically calculates what the MP’s current age would be.

It’s kind of eerie for me. Like, I was touching up Breiton Ackerman‘s casefile and noticed: my god, this kid would be 18 now. Graduating high school, off to college or the workforce or the Army or wherever life would have taken him. But instead he’s four forever.

17 thoughts on “There’s a current-age thingy now

  1. Mcp January 16, 2018 / 2:54 am

    I didn’t see this mentioned in your other notes about little tweaks you need to make to the new website, but there are quite a few people whose date of disappearance is erroneously listed as January 9, 2018. (I was looking for recent cases, and that’s how I noticed it.) Great job, by the way, the website is incredible! Keep up the good work!

    • Meaghan January 16, 2018 / 8:27 am

      Yeah, I’m aware of that and I’m fixing it.

      • Mcp January 16, 2018 / 11:35 am

        Awesome! 🙂

  2. Mischa January 16, 2018 / 11:33 am

    Dorothy Arnold would be 133 🙂

    • Meaghan January 16, 2018 / 7:23 pm

      I hate to make assumptions about MP cases, but I think Dorothy is probably dead now.

      • vmulier January 17, 2018 / 10:27 am

        Did you check the Guinness Book of World Records?

  3. Leaman January 16, 2018 / 6:20 pm

    Hey Meaghan, congratulations on the site re-design. It looks great, and having a layout for mobile devices makes for a much better experience when browsing on a phone.

    But with my career being in IT, and wanting the Charley Project migration to go the best it can, I can’t hold myself back from offering help on a couple of things. Maybe Preston is already working on them. I’d be glad to donate my expertise if he needs assistance.

    All Google searches are broken, due to the format of the URLs changing. For example, if I search “rachel cooke charley project”, Google finds her old page and tries to go there, which results in a Page Not Found error on the site. As the new site is WordPress-based, re-direction rules can be set up that will fix this problem, as outlined here: http://www.wpbeginner.com/beginners-guide/beginners-guide-to-creating-redirects-in-wordpress/

    Also, the age calculations are only using the year, not the month and the day. I know this is a bit nit-picky, but using Rachel Cooke as an example again, she won’t turn 36 until May 10th of this year. Her current page shows her as already 36. Assuming that the cases are stored in a table called “posts” in the WordPress database, and the birthday is a field in that table called “bday”, this query will calculate the correct age, and show her as 35 until May 10th:

    SELECT DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(bday)), ‘%Y’)+0 AS age FROM posts;

    I’m not complaining, just want to help if I can. 🙂

    • Meaghan January 16, 2018 / 7:27 pm

      Sent your comment to Preston.

      • Leaman January 16, 2018 / 10:30 pm

        Meaghan, please pass this on too:

        The redirect issue is going to be more complicated to solve because the URL format has changed just a bit too much: dashes have replaced underscores, and the MP’s middle name is now included. All redirects could be automated if the new URL format was closer to the old one (the addition of the middle name is going to the biggest hurdle to automation).

        Without automation, one would be looking at creating 9,800-some redirect rules manually, one for each case file.

        Google and the other search engines will eventually re-index the site, but a bigger concern are all the external links to charleyproject.org. Every news article, Websleuths and Reddit thread–any site that has linked to a case in the past–will now find their links are broken until this has been addressed.

        Again, I’m happy to donate some time to finding a permanent fix. I can be reached at leamanc AT gmail dot com.

  4. Preston Winfrey January 16, 2018 / 10:57 pm

    301 redirects are now there. Thanks for mentioning it since I had forgot!

    • Catherine January 17, 2018 / 7:27 am

      Thanks for what you are doing, Preston. You are doing a wonderful thing for this amazing site.

    • Leaman January 17, 2018 / 12:18 am

      Great job, Preston! Glad you got the issues sorted out!

  5. Mia January 17, 2018 / 1:53 am

    I clicked on Breiton’s page, and it says he would be 84 (Date of Birth – 07/10/2000 (84)). Did I catch the page at a bad time?

    • Meaghan January 17, 2018 / 8:54 am

      Preston did something to the age calculation thingy last night. Obviously something went wrong; I’ve told him about it.

      • Leaman January 17, 2018 / 11:07 am

        Looks to be fixed now. I Googled a couple of case names this morning, and the redirects are working fine, as are the age calculations.

        Kudos again to Preston!

  6. Patrick Kerrigan January 17, 2018 / 7:19 pm

    Just for general information, Darla Kay Crist case has been assigned to a Detective Caleb Morris. He can be reached at 602-261-8047.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s