Posts tagged db

Geekend 2011 Notes

Nov 17th

Posted by Dark-Ape in Randomness

No comments

Last Thursday night I received a call from my father telling me he was at this conference called Geekend, something I had never heard of before and had to get him to spell out for me. After about five minutes, of him talking while I was checking out the website, I was sold on it, told my bosses I’d be gone the next day and drove straight to Savannah to arrive around midnight. It was worth it.

Download: Geekend 2011 Session Notes; last updated 2011-11-17.
More >

, , , , ,
Cogs

iContact API v2.1: “No More Emails”

Aug 9th

Posted by Dark-Ape in Web Development

No comments

I’ve been told that it isn’t proper to call this an API. All I have to say in response is: I don’t care; that is what I see it as, so deal with it. I know I skipped a lot of versions between v1.0 and this 2.1 one, but they were just never published. :P

iContact-API-v2-1.php — View Source | Download Source
As an update to my original custom iContact API, version 2.1 took into account that weekends are my time off as well as that I don’t need all of these emails for when the iContact system is down for maintenance or the connection has temporarily been severed. With that in mind, I created a database table to handle any errors and relegated the emailing of any errors to be a redundancy option in case the database is down for some reason. Because there might be further problems, I also added a logging to file redundancy feature as well. (Paranoia?)

CREATE TABLE IF NOT EXISTS `icontact_errors` (
  `varSet` VARCHAR(20) NOT NULL,
  `list_id` mediumint(3) UNSIGNED NOT NULL,
  `list_txt` VARCHAR(60) NOT NULL,
  `email` VARCHAR(120) NOT NULL,
  `fname` VARCHAR(90) NOT NULL,
  `lname` VARCHAR(90) NOT NULL,
  `addedon` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

More >

, , , , ,