user warning: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, tz.offset_dst AS offset_dst, tz.dst_region, tz.is_dst, e.event_start ...' at line 1 query: SELECT e.event_start, e.event_end, e.timezone, e.has_time, e.has_end_date, tz.offset AS offset, tz.offset_dst AS offset_dst, tz.dst_region, tz.is_dst, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_start_utc, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_end_utc, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL 0 SECOND AS event_start_user, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL 0 SECOND AS event_end_user, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL -18000 SECOND AS event_start_site, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL -18000 SECOND AS event_end_site, tz.name as timezone_name FROM event e INNER JOIN event_timezones tz ON tz.timezone = e.timezone WHERE nid = 4162 in /var/www/clients/client2/web3/web/modules/event/event_database.mysql.inc on line 12.

Mass Effect 2 Bug * no spoilers *

By Akuf - Posted on 02 February 2010

Ok for those of you who have the game.
When you are doing the 'loyalty quests' Make sure you save a lot.
There is a bug that may cause the 'loyalty power' not to unlock.

I went through this with Grunt. Had to start the whole quest over again.
According to some forums it appears to be random. Happens most of the time with Grunt, Samarra and Thane mostly.

Xbox Customer Support seems totally on the ball

By Blackwalt - Posted on 01 February 2010

So which website for which courier?

I don't really care which courier has it as long as I get it back.

Unfortunately these are the same people I am depending on to have fixed my Halo Special Edition Xbox 360 in the first place.

Confidence level is low.

I Love my Family

By MauriceRevek - Posted on 31 January 2010

As most of you know, for the last 5 months or so, I had a roommate / tenant staying at my house while his own house was being built. This person was an old friend of mine from Montreal. What I did not know about him at the time that I decided to let him stay, was that he is a VERY loud snorer. He was in the guest room, with the door closed, I was in my room , with the door closed, and I could still hear him very clearly. And it was not the steady kind of droning, it was the varying intensity / wall shaking feel it in the very core of your body vibration kind of snoring. Read more

The Twenty Nerd Commandments

By Blackwalt - Posted on 30 January 2010

Only Two matter. Number 7 and number 8

 -Graphic from regretfulmorning.com (totally unrelated story)

-Graphic from regretfulmorning.com (totally unrelated story)

Topless Robot has provided us with the list of The 20 Nerd Commandments.

Some lines even Coxxorz won't cross

By Blackwalt - Posted on 29 January 2010

Blackwalt however? Full steam ahead!

So Coxxorz and I found ourselves in EBgames. Not that unusual a circumstance I admit, but this day? This day turned out to be slightly different.

Coxxorz is always the one looking for a deal but I was the one that spotted a potential deal standing in EBgames.

A guy in front of us was trading in three games toward something new. And one of them was a game I was interested in.

You can see where this is going, can't you?

Anti-Coxxorz Anti-Bargain Anti-Corner of the Anti-Day 01292010

By Blackwalt - Posted on 29 January 2010

Kudos to Future Shop for having the gall

Usually when you charge $10 more than everyone else you don't advertise it nationally.

If you price match this at a competitor does this mean they would charge you 10% more than the difference?

Whoot! More Borderlands DLC!

By Blackwalt - Posted on 29 January 2010

The Secret Armory of General Knoxx

    Here's the official announcement for the third Borderlands DLC, along with two screenshots!


The iPad fom MadTV

By Akuf - Posted on 29 January 2010

And the funniest thing this video is two years old!

HoC micro-review: Dragon Age: Origins

By Blackwalt - Posted on 28 January 2010

Too much talkie, talkie. Not enough fighty, fighty.

A 2004 "the Robinsons: Lost in Space" pilot?

By Blackwalt - Posted on 28 January 2010

Before you mock there are two important pieces of trivia involved

  1. It was directed by John Woo
  2. The spaceship went on to become the Battlestar Pegasus for Battlestar Galactica

The full unsold pilot is available (in 4 parts!) on YouTube:

There may be a 5 and 6 part for all I know as I initially missed parts 3 and 4.

Via io9.

Something

By Coxxorz - Posted on 27 January 2010

-00-00

Apparently I'm supposed to "post something" today, so here it is. Read more

First Edition Cover of The Pink Menace™ leaked online

By Blackwalt - Posted on 27 January 2010

We have it here first!

First news coverage of The Pink Menace™ available here.

High resolution PDFs are available. Contact me if you would like one. This is so going up on my office wall.

Ow! Ow! Ow! Someone get Stormblade to stop trying to kill me with his mind! I really didn't used to feel it but the last couple of years it's been starting to hurt. He must have changed his drug regimen.

Overheard at Blackwalt's yesterday

By Stormblade - Posted on 27 January 2010

You just can't make this stuff up.

Guba: I am going to be home alone tomorrow afternoon. I wonder what I will do.

Blackwalt (suggestively): I could come home early ...

Guba: Well, that will eat up 5 minutes.

Allons-y, Zombie Killers!

By Blackwalt - Posted on 26 January 2010

I told you that Level 28 was doable...

Revisiting the Catwalk of Hope and LoveRevisiting the Catwalk of Hope and Love

Not that we made it to Level 28

However Level 27? We did make it to Level 27.

Three Ring Circus down to a single ring

By Blackwalt - Posted on 26 January 2010

Two down one to go, another town and one more show

So I dropped off the two previously repaired Xbox 360s with our local repair guy, as discussed previously, and he managed to get them both going again with same day service. He fixed my core with the Halo 2 faceplate and Stormblade's Pro with the Pink "Zombie Killin'" faceplate.

COVID-19 Information

HoC's Most Anticipated

RANDOM QUOTE OF THE WEEK

I wear the mask to protect the people closest to me.

-Batman

HoC Random Poll

Why aren't you playing Red Dead Redemption 2?:

Recent comments

Random HoC Story

Trailer: Star Trek Beyond
Well that's just typical It almost makes me want to play the Star Trek game again. Almost.

WORLD MAP: IT'S RED TO HIDE THE BLOOD

Hatfall

From Zero Punctuation, Yahtzee presents, Hatfall (cue Adele)

Who's online

There are currently 0 users and 3 guests online.

Random HoC Image

ICOZA_wedding2_b

Syndicate content Syndicate content