Warren Shea - World of Warren

Archive for the ‘Archives’ Category

WTB – December 2011 Edition

Friday, December 2nd, 2011 at 7:14 pm

Things I’m expecting in December – Total $460.76

Zelda: Skyward Sword Collector’s Edition w/ Gold Remote
$151.63 – Price I Paid (total)
Ordered Dec 12, 2011
Purchased at eBay.ca

Shigenori Soejima Artworks
$26.33 – Price I Paid (total)
Ordered July 11, 2011
Purchased at Amazon.ca

Megaman Zero
$31.99 – Price I Paid (total)
Pre-orderered July 30, 2011
Release Date Oct 2011
Purchased at The Big Bad Toy Store

Kotobukiya Marvel Comics: Elektra Bishoujo Statue
$51.99 – Price I Paid (total)
Pre-orderered May 21, 2011
Release Date Dec 2011
Purchased at The Big Bad Toy Store

Kotobukiya DC Comics: Batgirl Black Bishoujo Statue
$51.99 – Price I Paid (total)
Pre-orderered July 7, 2011
Release Date Jan 2012
Purchased at The Big Bad Toy Store

Batman Arkham City
$101.64 – Price I Paid (total)
Purchased Dec 5, 2011
Received Dec 7, 2011
Purchased at Amazon.ca

Mario Kart 7
$45.19 – Price I Paid (total)
Received Dec 4, 2011
Purchased at Best Buy

Things I received in November – Total $126.16

Mario 3D Land
$45.19 – Price I Paid (total)
Received Nov 15, 2011
Purchased at Best Buy

D-Arts Megaman X
$41.99 – Price I Paid (total)
Pre-orderered May 21, 2011
Release Date Sept 2011
Received Nov 7, 2011
Purchased at The Big Bad Toy Store

RAH DX Gundam Seed Destiny Meer Campbell PVC Model
$38.98 – Price I Paid (total)
Ordered Oct 16, 2011
Received Nov 2, 2011
Purchased at eBay.com

Posted in All Posts, New Stuff (monthly) | No Comments »

Accomplishments – December 2011 Edition

Friday, December 2nd, 2011 at 12:34 am

What I accomplished in November
Shows / Movies
The Rise of the Planet of the Apes – Done
Memento [Rewatched] – Done
Jurassic Park [Rewatched] – Done
The Lost World [Rewatched] – Done
Jurassic Park III [Rewatched] – Done

Books & Manga
Hikaru no Go fanfiction – The Neverending Road – Chapter 79/79 – Done

worldofwarren.com
13 posts…just like November…a few posts below what I wanted.

warrenshea.com

secretproject [to be renamed]

Gaming
Kirby: Return to Dreamland [Wii] – 100% – Done
Kirby Mass Attack [DS] – 100% – Done
New Super Mario Bros [DS] – 100% – Done
Super Mario 3D Land [3DS] – 100% – Done

Web Development and Design

Other

Notes
This was definitely a gaming month. I spent a LOT of time gaming. Despite the beginning of my month being very work oriented, I was still able to accomplish a lot this month. Not as much as I wanted to web wise…but it was still better than previous months. I also read quite a bit…burned through 79 chapters of Hikaru no Go fanfiction in like, 20 days.

What I want to accomplish in December
Shows / Movies
50/50
Hugo
Another Earth
She’s All That [again]
Tarzan [again]

Books & Manga
Steve Jobs
Bakuman

worldofwarren.com
15+ posts
SpeedyGlass Post
Is it okay to break up a relationship?
New friends
Deep talks

warrenshea.com
Started to get antsy to actually finish this……maybe I’ll work on it soon.

Gaming
Mario Kart 7

Web Development and Design

Other
Get new camera

Notes
This month is holiday party month. I’m not taking vacation….maybe I’ll work on my site (warrenshea.com) maybe :D

Posted in Accomplishments (monthly), All Posts | No Comments »

Update

Tuesday, November 29th, 2011 at 1:24 am

Sorry, I know I haven’t blogged in a while. Too long. Sigh. I was on my way to getting a good post count this month but fell behind near the end.

Some updates:
We got our windshield repaired after about 2 weeks. There was a crack growing for a while. I’m planning to write a whole post on my horrible SpeedyGlass experience and great Sprint Auto Glass experience. Will definitely write that soon as I want to show it to the SpeedyGlass folk >:(

I found this place on Bloor between my place and work called Japanese Foundation. It’s a little library all about Japan. Coolest thing is that they have manga to borrow. I borrowed 5 mangas, 3 Hikaru no Go and 2 Bakuman. I have a thing for Takeshi Obata (‘s art).

Z and I had a dinner party last weekend. We had about 7 people over, so 9 people in the condo. The girls made Carrot Cake and Macaroons and the guys played games…and then we all played some Wii Dance games, Taboo, and Friends Scene It. I believe I was the most skilled at the game, but unfortunately I lost due to people ganging up on me and making me lose turns. hmph. They were afraid of my RAW POWER. My competition were some pretty skilled Friends people too though…including Z who has probably seen Friends almost as much as me simply due to proximity.

I’m spending most of my nights lately playing LOL and reading this Hikaru no Go fanfiction. I’m on like, chapter 71 of 79, I hope to finish by the 31st. Starting Dec 1, I plan to start reading the Steve Jobs book. Reading a lot lately! It’s definitely fun.

I beat Super Mario 3D Land….going to get Mario Kart 7 when it comes out.

I’ve got some TO DOs lately…including: donate some clothes, get rid of an old computer monitor, build old Gundam models, get Video8 tapes restored….

Life’s been busy….the thing is that blogging isn’t my priority during the nights as I’m trying to finish reading the fanfiction by month’s end (for my Accomplishments post).

Also, my sleeping has been super messed up. I have a 9:30-10am call every morning, which is my usual get ready/walk to work time. Because of this, I get to work at 10:30….come home, take a nap, sleep really late (last night I slept at 4am…woke up at 9am for work). I need to get that back on track. Maybe today.

Okay, enough randomness for now….hopefully I’ll squeeze a post or two in before month’s end.

Posted in All Posts, Daily Randomness | No Comments »

One SQL Statement to Destory the World (of Warren)

Wednesday, November 23rd, 2011 at 4:34 pm

^ That’s supposed to be a play on “One Ring to Rule the World”….which is my butchered version of
One Ring to rule them all, One Ring to find them,
One Ring to bring them all and in the darkness bind them
from LOTR.

Anyways.

So I brought my site down today. Well, technically I only brought the blog portion down, but that’s 99% of my site.

This is how it happened.

When I did my migration a month ago, for some reason apostrophes were replaced with an obscure character encoding, probably due to the Database not being the correct coding (ISO-8859-1 instead of UTF-8 or vice versa).

I was trying to do a SQL statement on the wp_posts table to replace all instances of
Ã¢â‚¬â„¢ to ‘

This was the SQL command I ran:

UPDATE wp_posts

SET post_title = REPLACE(post_title, “Ã¢â‚¬â„¢”, “‘”)

WHERE (post_title LIKE ‘%Ã¢%’)

To translate: If there’s an instance of Ã¢ in the title of the post, find Ã¢â‚¬â„¢ and replace it with ‘

Simple. Anyways, I ran the code and it worked like a charm on all the titles. I next had to replace the content of the post. Easy right?

The SQL command should have been

UPDATE wp_posts

SET post_content = REPLACE(post_content, “Ã¢â‚¬â„¢”, “‘”)

WHERE (post_content LIKE ‘%Ã¢%’)

But instead, I wrote

UPDATE wp_posts

SET post_content = REPLACE(post_title, “Ã¢â‚¬â„¢”, “‘”)

WHERE (post_content LIKE ‘%Ã¢%’)

To translate (minus insignificant details): If there’s an instance of Ã¢ in the content of the post, replace the content of the post with the title of the post.

As a result, all my old posts’ content was replaced with the title of the post. OMG >_< I created a ticket with my hosting provider and they happened to have a backup of the database from yesterday morning (so I was only missing 3 comments from then, of which I obtained through Google Reader/Feedburner + FireBug). I got it restored within an hour or so…. But I still have to fix that apostrophe problem still….but this time, I’m kinda really afraid to do so :'(

Posted in All Posts, Development, My Life, Web Development, worldofwarren.com | 1 Comment »

One of many Addictions: Video Game Guide Books

Tuesday, November 22nd, 2011 at 3:16 am

I won’t lie. I have a weak willpower. It’s the thing that makes me think “I’ll just have a little Bacon on that Double Cheeseburger” instead of “Salad is the way to go”.
I’m not weak willed but I’ve definitely got a highly addictive personality.

I’ve collected Books (Garfield, Calvin and Hobbes), Comics (16 large boxes, having collected comics for over 10 years), Manga (DBZ, Naruto, Death Note, Neon Genesis Evangelion), Magazines (PSN, Wizard), Artbooks (maybe I’ll do another post on these), Toys (RAH DX Gundam Seed toys, Adam Hughes DC Statues, Jim Lee’s DC Universe Online Statues, and most recently Marvel and DC’s Kotobukiya line) and finally: Video Game Guides.

Now, that’s not to say I buy them all. No, far from it. But when I see a guide to a game that I know I might play, as opposed to one I do or have played, I have to have it. Even more so, if there’s a collector’s edition: I have to have it. And I have to have it new. Yes, I’m weak like that.

Today, I had some time to kill so I went to Indigo. A hundred and something dollars later, I have these 3 books:

My reasoning for each book:
Batman Arkham City Collector’s Edition Guide because: I have the Batman: Arkham Asylum Guide and EVENTUALLY, I plan to play this game.
Zelda: Skyward Sword Collector’s Edition Guide because: Given the buzz around the game, maybe eventually I’ll play it. Also, I have another guide like it….(see below)
And finally a Super Mario 3D Land Guide because: I don’t know, I’ve finished the game and gotten all the gold medals…there’s very little this guide can tell me.
(in fact, after reading the guide, I realize I’m not done the game..I have 4/5 stars. The last star involves reaching the top of EVERY flagpole AND beating every level with Luigi…currently, after 1 day, I’m on World 3…again >_<). Anyways, I'm stupid in the way of buying guidebooks and games. Even worse, Collector's Editions always really screw me over. I have a Collector's Edition DC Universe Online [PC], BlazBlue [PS3], Gran Turismo 5 [PS3], Catherine [PS3], Marvel VS Capcom 3 [PS3], Street Fighter 4 [PS3]....AND a Final Fantasy XIII [PS3] and Metal Gear Solid 4 [PS3]....and those last two both remain sealed still -_-; Another example of my addiction:

Well, I have 2 regular Zelda Guides because Z and I both got one before we moved in together. We have two Twilight Princesses [Wii] and two Wii’s too :) But one of the guides is still shrink wrapped.
And then I have the Collector’s Edition Guide because….well, I wanted that one over the regular one. I just HAD to have it, despite 98% of the content being the same probably. Also, the Collector’s Edition Guide is still shrink wrapped too! (Well, why use that when I have a regular guide to “destroy”).

Click the image above for a larger one
I have tons of Video game Guidebooks, many for games that don’t need one or of which I’ve never/rarely used:
Street Fighter IV, Smash Bros Brawl? Why would I need fighting game guides?

Games I’ve never played, but have guides for: Kingdom Hearts II, Metal Gear Solid 4, Final Fantasy X, Final Fantasy XII, Dissidia: Final Fantasy

Games I’ve only played for a moment, but got distracted: Super Paper Mario, Metal Gear Solid 3, Zelda: Major’s Mask, Final Fantasy VII: Dirge of Cerberus, Batman: Arkham Asylum

I will admit that I love guidebooks, even if I don’t use them really. I love looking through them, looking at the art (same reason I buy artbooks), looking at the strategies, even if I may never use them.

I don’t regret buying these guides, but it does seem a bit unnecessary some times. Still, who’s to say what games I could be playing in the future. I played 5 year old New Super Mario Bros. [DS] just last month, I played 10 year old Zelda: Ocarina of Time [N64/3DS] last/this year.

I would much rather buy the guide new, when it’s out than buy an old, damaged guide for a high price. Seriously, a New/Like New Majora’s Mask guide is IMPOSSIBLE to find. Even old beat up guides range from like, $60 to $200. Ridiculous. I was able to get 1 off ebay in horrid condition for $30ish and another one from my local vintage gamestore for a bit more than cover price (that was like finding gold, seriously).

I just wanted to write about game guides, since I bought 3 of them today….and since I haven’t blogged in a while. ANY TYPE OF INSPIRATION WILL DO.

Posted in All Posts, Art, Design & Art, Games, My Life, Shopping, Things I Own | 1 Comment »