Day: September 30, 2008
Database Query Upgrade
Coming soon. TH12’s postseason picks!
So you didn’t realize it, but there has been an error in a SQL query I have been using since I launched the website redesign two years ago. To be frank, it is all fixed – you didn’t notice anything wrong (it was a backend issue that affected me badly when I was posting). This fix makes my life a lot easier. If you’re interested in the geek behind it, read on. Not so technical? You better quit while you’re still with me.
Ok, ubergeek interested in the inner-workings of this site, here goes: Back in the day, the portfolioso.com homepage was a WordPress theme, that was customized to match my site template. When I decided to make my site XHTML strict, so the theme hacks would never work. As a result, I moved the blog to a subdomain and threw in a new layout for the main site. To get my news to the front page, I used a SQL query to the WordPress Database. Here is where the problem arose. It would query the last story in the database, whether it was marked as draft or published. I was working on an epic new post that is not ready for the public yet, and it really annoyed me that the draft of it was being fed onto my main page! How insecure to ignore the fact that it hasn’t been published yet. Well, at 2:23AM when there is homework due for a 9:30AM class, people like me start programming to fix these things. I dove right into the SQL queries until I found one that works, sorted it out for the site and “boom, there goes the dynamite.”
MySQL
Tags
Android Annoyances Apple Apps Bad Engineering Baseball business Cablevision Chats common sense Crime darwin awards drugs Environment Facebook FiOS Firefox Google Google Chrome Government Grammar Hicks Holiday Internet Explorer Malware Metallica Money MTA net neutrality NYC Philosophy Phones Politics Pride Programs satire Science Song of the week Stupidity Torrents Verizon war Weather WordPress Yankees
Townhouse 12 Spotlight + Postseason Picks
September 30, 2008
Sports, Useless Update
No Comments
Portfolioso
Welcome to the first annual house-wide MLB postseason bracket tournament. This year, me, Tom, Keith, Eric and Jon will be guiding us through the 2008 postseason. Here is the blatant Mirror 3×5 ripoff, Portfolioso style (5×6 and not a grid):
Joe
Keith
Tom
Eric
Jon
So there you have it. Here’s my opinion of postseason 2008. It would be wonderful to see Joe Torre beat the Red Sox (see Keith’s picks) but I highly doubt that will happen. Keith’s picks are really ballsy – but anything can happen. I’m also a Lou Pinella fan, and the Cubs have a decent team, but the whole 100 years thing makes everyone laugh. Time will tell.
Update 1 10/5 8:45AM: Thanks for making me look like an idiot, Lou. I swear I’m not this dumb, I did the whole 2004 bracket correctly (minus the Red Sox – which is kind of the important part.) Way to ruin my whole bracket. Once the entire media jumped on the Cubs bandwagon, I knew I’d be done. I’ll be going for Joe Torre all the way I guess.
BaseballSpotlight