Robert’s Rants & Rationalizations

A monthly cron job to email site’s users to click a link to verify they are still using the email listed in their account. Assumption that if user logs into site, their info is up to date, too.

Every 30 days, check if user has not verified in last 30 days

• or, has not logged into site in last 30 days
• If not, send email with link
• update tracking table with internal_table_id, date, time, user_id, event_code (for ‘validating attempt’)
  

When user clicks on embedded link in email,

• script parses URL
• update tracking table with internal_table_id, date, time, user_id, event_code (for ‘verfied’)
  

I’ll use the tracking info to put an icon, next to their name in the list of users, to show if the info is current.

BTW, writing this out helps in seeing the event, and I can’t always find that scrap of paper I first started to write this all out!
—
Check who is using Reunion Hall!
 ::: http://www.twitter.com/reunionhallorg :::

Posted via email from Reunion Hall (dot) org

A monthly cron job to email site’s users to click a link to verify they are still using the email listed in their account. Assumption that if user logs into site, their info is up to date, too.

Every 30 days, check if user has not verified in last 30 days

• or, has not logged into site in last 30 days
• If not, send email with link
• update tracking table with internal_table_id, date, time, user_id, event_code (for ‘validating attempt’)
  

When user clicks on embedded link in email,

• script parses URL
• update tracking table with internal_table_id, date, time, user_id, event_code (for ‘verfied’)
  

I’ll use the tracking info to put an icon, next to their name in the list of users, to show if the info is current.

BTW, writing this out helps in seeing the event, and I can’t always find that scrap of paper I first started to write this all out!
—
Check who is using Reunion Hall!
 ::: http://www.twitter.com/reunionhallorg :::

Posted via email from Robert’s View

Now, let’s just wait to ensure that this change doesn’t break something else!  Ug!
—
View my photo clips!
 ::: http://byrobert.posterous.com :::

Posted via email from Robert’s View

Earlier this month of December, I broke the code which updates a user’s profile on one of my sites, Reunion Hall.  Of course, I didn’t know I broke the PHP code when I modified it because a few rows in the db wasn’t used any longer.  Ahh, the script wasn’t modified to reflect the missing rows…well, they weren’t missing.  I modified another piece of the code in the ‘add user’ script.   It has taken me, part time, several weeks to find the ‘errors of my ways’, a phrase my teacher would say. So what’s so big about this?  I’m not a programmer.  I can’t write code from scratch!  And, I can now mess with this stuff (php, mysql, etc.) because of open-source!  This saves me yearly fees of proprietary software such as cgis, databases, hardware, etc. Anyways, I found the problem, and I did it before the end of this year!  I have learned and hope I remember, next time.