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 = 4963 in /var/www/clients/client2/web3/web/modules/event/event_database.mysql.inc on line 12.

I've already pre-ordered mine

By Blackwalt - Posted on 25 July 2010

I'll figure out the "PS3 only" problem later

Bang, bang, bang!Bang, bang, bang!

    The rifle, which connects wirelessly to the PS3 via USB dongle, has all the buttons found on a regular six-axis controller, including d-pad, start and select buttons, and clickable thumb sticks. ... The gun also packs a speaker for getting in-game sound effects all up in your face.

There is video.

Yes

By Blackwalt - Posted on 24 July 2010

This may or may not be a response to this.

Halo Reach Avatar Items just dropped

By Blackwalt - Posted on 24 July 2010

These avatar items are now available on Xbox Live Marketplace

Plus one more that I cropped off. Randomly. And because it didn't fit. A Firefight Hoodie.

See them/buy them online.

I'm not usually big on Avatar items but I do appreciate a good Boonie Hat.

Darth Vader Robs Bank

By Swag - Posted on 23 July 2010

His cape seems a shade bluer than I remember....

Halo Reach console bundle announced

By Blackwalt - Posted on 23 July 2010

This is the new Xbox 360 console now in silver

I spotted it everywhere but I am linking randomly to IGN.

    The bundle will be released along with Reach on September 14th and comes with Halo: Reach, two wireless controllers. This version of the redesigned console has a 250 GB hard drive, built-in wireless, and costs $399. There are also a few special pack-ins including a token for Limited Edition Elite armor set, an episode of Halo Legends, and a Reach themed wired headset. The announcement also states that silver console has "custom sound effects" from the Halo universe.

Yes I want one. It will go well with my Halo 3 Special Edition Console.

I'm hungry for some reason...

By Blackwalt - Posted on 23 July 2010

I'm glad it's Mutagen free cause I was concerned there for a minute

On second thought, I'll pass. I hope to never be that hungry.

    It’s green first off, which means that the quality of zombie meat is much higher than the blue stuff from Japan (which must have been mostly rotted noses and entrails). It’s also packed with 11 grams of protein per serving with only 1 gram of fat.

Via Nerd Approved.

W... T... F...?

By Blackwalt - Posted on 22 July 2010

Qbert joins DJ Hero 2 lineup

Breaking news at Joystiq: DJ Qbert joins DJ Hero 2 lineup.

Q-Bert's moonlighting again! One more game to add to the DO-NOT-BUY list.

    Though Qbert 2 featured zero DJ heroes, DJ Hero 2 will feature at least one Qbert: DJ Qbert, that is. Activision announced this morning that the California-based DJ will become a playable character in the upcoming scratch-em-up and add two "exclusive mixes" to the varied soundtrack (see the tracklist here).

Via Joystiq.

10 Underappreciated Sci-Fi movies

By Q-Bert - Posted on 22 July 2010

Gattaca: It introduced me to keyboard vacuumsGattaca: It introduced me to keyboard vacuumsI have only seen one of these. I bet Offal has seen at least 8 of them.
How about we grab 2 or 3 of these for the next LAN party ?
How many have you seen ?

Comic Con Girls

By Blackwalt - Posted on 22 July 2010

Another Katy Perry song? I hardly know who I am anymore...


I have no idea what caught my eye in this ComicCon mockery.

Apparently it parodies a Katy Perry/Snoop Dog song called California Gurls. I'll have to ask Ice to let me listen to that one.

Guess tonight's game, redux.

By Coxxorz - Posted on 21 July 2010

-00-00



Since last week's puzzle was clearly too difficult, I've made this week's game brutally easy to guess.
Read more

Rock-Paper-Scissors 101

By Q-Bert - Posted on 21 July 2010

Law: Figures it's a fist crushing a thumb.Law: Figures it's a fist crushing a thumb.No, it's not a high school class. For those who think that rock-paper-scissors is too easy, try the 101-item version.

From the page: "Video Game resists Porcupine and clutters Home"

See the rules here.

Another Game Movie: Dead Rising

By Blackwalt - Posted on 21 July 2010

And it's a Zombie film!

I only posted this because of the movie poster in case it wasn't obvious.

Wait a minute! Wasn't Dead Rising based on the Romero Zombie films? And now it's a film?

I even tracked down a trailer for you. It was really hard. It took me a whole two extra clicks.

Man charged in debit card scam after hotel staff find $100,000 in cash

By Coxxorz - Posted on 20 July 2010

The Ottawa Citizen reports that a 21-year old Quebec man has been charged in connection with a debit-card skimming scam in Saskatchewan that netted nearly $100,000 in cash.

I never thought...

By Akuf - Posted on 20 July 2010

...this day would come. I have stooped to a new low...

I actually went out and got the game Wet. And I am actually enjoying the mindless shoot em up not mention that I think if Rubi was real I would probably marry her.

Now, I know how swag feels when he watches his anime porn. Not sure if Revek is on that boat but wouldn't be surprised.

SyFy Original Movie: Red Faction Origins

By Blackwalt - Posted on 20 July 2010

March 2011

SyFY Original Movies and THQ have teamed up to produce a Original TV movie based on the Red Faction series. There are rumours that it may turn into a TV series.

Good news. Uwe Boll is not involved. Sorry Moricerevek.

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

Ascendance DLC releases today - new Exo Zombies!
I particularly appreciate the 13GB update required before I can get at the DLC

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 7 guests online.

Random HoC Image

blackwalt_ZL

Syndicate content Syndicate content