My Reward

I figured out what my problem was with running the Pinball Locator locally this morning... the table that stores all the pinball data didn't have all the right fields with the correct names and types. There are some subtle yet irritating differences between how my machine and the live server work, and I'm having a really hard time believing that it's because I have a newer version of PHP. For now I've just got an ever-growing set of includes to deal with the differences, so we'll see how that goes.


As a reward for getting the core functionality of PL running locally, I treated myself to some time reading Pinball News' Iron Man rule porn, which was just published today. And it's just like real porn, because 90% of the rules they talk about are unattainable to schlubs like me. ^_^

I Contribute to the Pinball Community!

OK, this isn't about T2, but this all happened kind of without warning.


About two weeks or so, I was on RGP and there was a post complaining about the Stern Pinball web site search function. Well, when I went to look at it, it was none other than the good ol' Pinball Locator. I defended it as best as I could, then fired off my semi-annual letter to Ken at PinballRebel.com offering to fix some glaring issues. To my shock and awe he responded positively. This time I took a different tact: Rather than honestly conveying my skill set (I don't know PHP because we use Javascript and JSP at my work), I just told him I know PHP. This was apparently what he was looking for, and after a brief negotiation he sent me the Pinball Locator source files.


Well, yay for our team! It took me a couple of hours of monkeyin' around to get everything up to the point where I could run the site on my computer. Mac OS X comes with the Apache Web Server, but you have to turn it on and activate PHP. Then I had to install MySQL and a program to monitor and query MySQL. Then I had to figure out what the heck PHP was doing (honestly, it's nothing surprising... after 34 years of programming in a dozen or so languages there really isn't a lot that can shock me in a programming language). The biggest problem ended up being that I can't seem to access the database from PHP... it doesn't give me an error message when I run a query, but it doesn't do anything either. 


Anyway, I fixed the glaring issues and sent the files back for review. I'm really anxious to see how it works out... just in the past week I've come up with about 10 neat new features, and I'm sure Ken's got a bunch as well. Fun!

Time Out for Fun!

The Terminator rebuild is proceeding like gangbusters, but since there's a lot to write about and it's really late, I thought I'd post this cool stuff that I just got.

A few weeks ago, Boing Boing had a post of cool video game propaganda posters. I thought they were pretty amazing, so I ordered them as soon as I had some free money from our larger than expected tax refund (plus Zazzle, the printing company selling them, was doing a Tax Day 10.40% off sale... I've since found that they have better sales, like 40% off, so be patient).

The artist, Steve Thomas, has put out more since I bought these, and he's also got some cool Solar System travel posters that my wife really likes. 

I framed them with cheap frames on sale from Michaels and hung them in our living room just before everyone arrived for my daughter's graduation. I opted for the pretty big size, 2 x 3 feet, for maximum impact. Of course most of our family didn't realize what they were, but my wife and I like them for their sublime blend of extreme subtlety and awesomeness.

Here's the Joust poster, which was the one pictured in the Boing Boing post and pretty much immediately sold me. I loved the Joust video game as a youth.

I put the Donkey Kong poster over the couch in the most prominent position, not because it's my favorite but because it's the one that most people will be able to figure out. 

Dig Dug is, in my opinion, the least obvious, as evidenced by the fact that my daughter thought it was Speed Racer. Why would Speed Racer be pumping something and have a Pooka reflected in his visor? I believe this reflects poorly on the quality of the education that we just paid so dearly for.

There are a bunch of other posters... some I didn't care much for (like Tron) and some I like but just came out, and I've pretty much used up my free wall space. If he comes out with a Crystal Castles poster (unlikely, I know) that would be an auto-buy, but otherwise I'll just wait until he finishes the series and decide then.


OK, next time T2 rebuild stuff for real.

A hollow voice says "PLUGH".

Yes, a title that's a bizarre and/or obscure 70's/80's pop culture reference means it's Tech Tip Time!

While my Dad and brother were here for my daughter's graduation, they were casting about for something to do on an off day (funny/irritating story: My Dad said he wanted to take a Dan Brown tour of locations around DC featured in The Lost Symbol (Robert Langdon, No. 3). There didn't appear to be any pre-made tours, so I bought the book from Audible [yes, I know, it was infected with DRM] and listened to it, taking detailed notes about locations in the book. When I was done, I wrote up a pretty-much complete list, sent it to my Dad, and blocked out an unused day for the tour. So when my Dad gets here, I asked him what he wanted to see. He told me he didn't want me to go through all the trouble, and that he only wanted to go on an actual packaged tour. So since we didn't go on the tour, we had an off day.) and I happened to mention that I was planning to splice a power cord with a legitimate 3-pronged plug onto the European plug attached to Terminator 2. My brother scoffed at that, saying we can just pick up a plug a The Home Depot that he can attach in five minutes with just a screwdriver. We did and he did, and it was pretty easy. After they left, I decided to do the same thing to Paragon, because the ground had been cut off by a previous owner and it's been on my list to do for quite some time (and as I've mentioned before my wife and daughter were grounding it themselves for a while until they learned not to reach back while they're watching TV).


Here's the original plug with the ground cut off. You can see that I helpfully label all of my power cords to avoid confusion at the power strip.

So first, I cut the old plug off and teased out the three wires. Since this vintage 70's era plug didn't use the traditional black-white-green wire color scheme, I made note of which identical black wire went to which side of the plug, even though I don't think it makes a huge difference.

I pulled the back off the new plug, which exposes the connectors. This is a really good time to feed the power cord through the back of plug before you attach the wires (I was feeling pretty smug for not forgetting it this time, but when I changed the plug on T2 again I did forget and had to detach the wires). Then I stripped the ends off the wires.

With the back of the plug on the power cord, I attached the wires to the business end of the plug. There's a little gap that you can feed the stripped wire into, then you just tighten the screw to close the gap.

Put everything back together and we're done! Look at that beautiful three-pronged outlet... just look at it.

And as a special bonus...

RARRR!

This was super-easy and fast... so much so that I didn't hesitate to change the plug on T2 for reasons which will be benounced later. Things are moving apace on T2, so I'll have a lot to discuss if I can find the time to blog this weekend.