qmail + vpopmail + ezmlm + mysql: ezmlm list-making notes

I've been setting up nginx, qmail, vpopmail, ezmlm-idx, etc., on my new VPS on slicehost (yay, slicehost!), and figured I'd post my notes in case they're useful to anyone else, since finding even tiny bits and pieces helped along the way and kept me from tearing my hair out while trying to work out how everything fits together. *vbg*

These are my (very brief) notes about how to set up a new mailing list in ezmlm, when using vpopmail's virtual domains with a mysql backend. (Yes, I realize I haven't posted about the parts of the server set up that came first, but these are the most complete notes I have at the moment. *g*)

Continued reading >

Arrrrrrrrrrrgh.

I like CodeIgniter so far (I've been fiddling with it on and off for a bit), but I've run into an issue that is driving me insane, so if anyone sees a typo that's causing the issue, I'd appreciate it if you'd let me know. *g*

I posted about the issue on the CI forums this afternoon, so all the relevant code's over there.

The gist of the problem is this: I'm using the same form for both adding a record and editing it. The model, view and controller work fine for the form when adding a new record. They also work fine when I submit the edited information. However, where it doesn't work is when I initially load the record to be edited by grabbing the data from the database and then filling the fields on form. Text and textarea inputs get filled in just fine, but radio and checkboxes do not get checked to match their stored values. *sigh*

Any ideas out there?

New work project up

Online school directory for El Paso and Teller counties, Colorado, USA (broken now). (The much better, non-corporate mush version is here on my site. [Also dead now, as I don't want to update the code for newer versions of php and mysql.]) I have a ton of additions and improvements that I want to add as I have time, not the least of which is point clustering and geocoding/adding an address marker and displaying schools within a certain radius.

To be added at a later date:

  • point clustering
  • figure out how to scan a JSON file to pull out just certain records from the array (all records in category c) so I can load everything once, rather than having to make a php/mysql call for each option; otherwise I need to figure out how to get an animated "I'm loading, dammit!" graphic to work with the asynchronous data call
  • zoom to district boundaries when displaying that district's schools
  • link to district info/schools from legend
  • label district polygons
  • display schools within x radius of a user input address (temp fix in the meantime: directions to and from links)
  • swap KML polygons out for encoded polygons for districts
  • display district data when brining up the district's schools
  • standardized test scores (and other associated CDE annual benchmarks) for each school and district

Suggestions and comments welcome, as they always are on everything I work on. :)

Google maps geocoder

Found a batch geocoder for Google maps a couple of weeks ago. It's pretty simple, and returns accuracy and status codes to help weed out the addresses you might need to check by hand. (Yay for not having to write one's own geocoding interface for Google!)

References: API docs for the status codes and address accuracy

Installing symfony on Dreamhost using PEAR

I tried to get all of the commands put down in this how-to, so that people of all skill levels could follow the instructions. Be sure to let me know if I missed any or something needs clarified. :) But as usual, use at your own risk, yadda, yadda. Continued reading >