Time Heals All Wounds.. And Then Kills the Patient
<Previous Next>
Wed May 12 23:16:00 2004
Soot Storm

Ash is kind of like soot, eh? I finished tonight's BLOG hacking, and now user accounts happen through the database instead of through email. It should be easier than ever to make a new account, so if you lack one, now's a fine time to make one. For the geeks: I extended the person table with a validated attribute, updated all existing entries so validated is true, and then made the field not null. I then altered the new user form to submit via a POST instead of by email, and added a handler to catch the new POST at the appropriate URL. The handler spits out what it gets, and for every field that can be present and is allowed to be set by the user, if it is, it chunks it into a SQL string to insert a new person into the person table, with the validated flag set to false. I finally modified my authentication code to only let people in with the validated flag set true (and, na klar, with the right password). Finally, I wrote a little seperate script that runs via cron every day that checks for the presence of nonvalidated people and if present, it nags me. Pretty simple.