› Developer's Log

2/19/06 -- Had the idea to start this project

2/21/06 -- Spoke with OFCC about idea briefly, may integrate later.

2/23/06 -- Actually started project. Originally 196 lines of PHP, and 1 DB. Took 42mins to create. Original URL was http://www.hipointtalk.com/county.php . URL now defunct for security reasons.

2/24/06 -- Put some new ideas to paper, added disclaimer, and prettied it up a bit.

2/25/06 -- 27'th b-day today, sure not working on anything!

2/26/06 -- Registered CCWhen.Com . About 40s later, I realised that I wanted OhioCCWhen.Com . Will fix later.

3/8/06 -- Finally got time to work on the backend some more. Made a data entry site(took 33mins to create), to start bringing in a relational database of counties that touch. All must be entered by hand, somewhat tedious. Asked for help at the ohioccw forums today. Hope to have relational DB complete no later than 3/12, so I may start on the meat of the backend. Main site is currently 300 lines of PHP, and 11901 bytes long. Data entry site is currently 188 lines of PHP, and 5931 bytes long. Main DB, with 87 entries(WHAT COUNTY AM I MISSING?!?!?!) is currently 4.6Kb, relational db, with 9 entries, is currently 2.5Kb. Main DB County entries are generated when a user selects that county for the first time. Therefore, I am assuming the missing county DB entry issue will work itself out, sooner or later. I thought I'd managed to select them all myself.

3/8/06 -- It took 4 1/2 hours, but, I got every county added. Finished tightening up the backend code, so now, when a county is selected, it also shows how good/bad it's neighboring counties are. Not sure what else to add from here, or, how to pretty it up much more.... Spose I'll think about that at work today :) Main site is now 13175 bytes long, and 321 lines. Relational DB is at 88 entries, just about complete, except for a couple counties that I have questions about, and it's size is currently 7.3Kb.

4/29/06 -- Added chat today. Chat ends up on #ohioccw on the freenode network.

4/30/06 -- Added status images to the ratings... it was a pain, but I got it eventually.... red = > 30 days, yellow = < 30 days and > 10 days, green = < 10 days, and grey w/ question mark = unknown(no ratings). And, thanks to an OFCC user, for pointing out to me, that I had the name of one of Cuyahoga's touching counties wrong :)

5/25/06 -- Completely redesigned the HTML of the site. In my opinion it looks 100% better now! Added links to My own site, moved the link to OFCC, added a link to Buckeye Firearms Association, and removed the link to OFCC's Forums.

5/25/06 -- Yaay! My first bug! Got home from the range, and noticed that my redesign was causing the rating to be OVERWRITTEN, instead of averaged. Looks like I have a few counties to fix by hand now.... thank goodness for logs.... also added a stats page today. You can click it on the right navbar. It lists the total number of entries received, and the average wait for Ohio as a whole.

5/26/06 -- Re-Wrote a lotta the internals. The navbar, head, footer, and county selector box used to be static on every page. Moved them to single functions, in an included PHP file. Added gzip support to all pages for faster, less bandwidth-intensive transfers. Re-Worded the County Selector box slightly, for better usability.

5/28/06 -- Got all of the contact info for Ohio's 88 sheriff's into the DB today. Took me a good 4 hours, to research, and enter it all. Look for it someday soon, at the top of each county's page. It's simple enough to display, however, I simply haven't the time right now, as I've got a buncha other projects going at the moment...

5/31/06 -- Changed the way CCWhen displays it's Data. It's all in a table now, and it all gets a status icon. That should make things easier to interpert. I also had it display info on the SO(i.e. Phone #, Address, URL). Debating on linking the Address to Google maps. Also added county view tracking today. Aggreate statistics are available on the stats page, individual statistics are currently available on each county's page. Also added a simple hit counter to all pages. Tracking for that is on the Stats page as well. Also, I finally was accepted to Google Analytics today. Integrated into this site, and my other sites.

6/1/06 -- Minor change, added 'Most viewed' and 'Most Rated' stats to the stats page

6/18/06 -- Added a news page, that pulls headlines from Ohio CCW news sites via RSS.

6/24/06 -- 2 morons today abusing the site. Sorry about the bad data. One was from NY ( 67.169.84.20 ), one was from FL ( 216.189.211.2 ). Added additional protections from this sort of behavior. UPDATE: Apparently, these people have been coming from Openwebdesign's links page. I guess they have nothing better to do than pollute our data, and this site. I have taken steps to stem this issue, and hopefully, it won't be an issue any longer.

8/30/06 -- Added forums today. Trying SMF at first...

9/26/06 -- Added 'Fastest County' and 'Slowest County' to the Stats Page. MySQL is a pain in the butt, to do math on the fly with, but, as you can see, it worked! :)

2/06/07 -- Removed the forums today. They were nothing but a spam magnet.

6/07/07 -- Integrated Goole Maps, moved address and info down to the bottom, and, moved up the submission form. Hopefully all went well!

6/10/07 -- Added Live feed images. Any county may be posted as an image like so: http://ccwhen.com/cimg/County/detail.jpg

6/11/07 -- Changed county lookup method from POST to GET. Made a way to hardlink to counties: http://ccwhen.com/go/County

6/12/07 -- Added a Manual for the new features.

6/25/07 -- Linked each neighboring county in the county stats pages. Added a disclaimer to Erie, Ottawa, Sandusky, and Huron counties.

4/02/08 -- Fixed mapping, apparently Yahoo! Started requiring an appkey, to use geocoding (and, google started offering it, under my present google API key...)