Galcon Games
Phil Hassey - game dev blog
Phil Hassey as Snidely Whiplash
"You can't buy awesomeness.
You're born that way."

Archive for April, 2009

MySql 5 weirdness ..

Tuesday, April 21st, 2009

So, a user was having some issues with their ranks being calculated totally wrong.  They were seeing numerous games against themselves.  Turns out this was the issue – MySql treats varchar() text with trailing spaces the same as varchar text without trailing spaces.  So the name “philhassey” is the same as “philhassey ” or “philhassey     ” in a ‘select * from ip_stats3 where name = ?’ type of query.  Here’s a MySQL session below to demonstrate.

mysql> describe ip_stats3;

+———+————-+——+—–+———+——-+

| Field   | Type        | Null | Key | Default | Extra |

+———+————-+——+—–+———+——-+

| name    | varchar(32) | NO   | PRI | NULL    |       | 

| data    | longblob    | YES  |     | NULL    |       | 

| s_rank  | int(11)     | YES  |     | NULL    |       | 

| s_win   | int(11)     | YES  |     | NULL    |       | 

| s_value | int(11)     | YES  |     | NULL    |       | 

| s_total | int(11)     | YES  |     | NULL    |       | 

+———+————-+——+—–+———+——-+

6 rows in set (0.00 sec)

 

mysql> select name from ip_stats3 where name = ‘philhassey ‘;

+————+

| name       |

+————+

| philhassey | 

+————+

1 row in set (0.00 sec)

 

mysql> select name from ip_stats3 where name = ‘philhassey’;

+————+

| name       |

+————+

| philhassey | 

+————+

1 row in set (0.00 sec)

 

mysql> select name from ip_stats3 where name like ‘philhassey’;

+————+

| name       |

+————+

| philhassey | 

+————+

1 row in set (0.00 sec)

 

mysql> select name from ip_stats3 where name like ‘philhassey ‘;

Empty set (0.00 sec)

 

mysql> select name from ip_stats3 where name like ‘philhassey%’;

+————+

| name       |

+————+

| philhassey | 

+————+

1 row in set (0.00 sec)

Cosmic Nitro

Wednesday, April 15th, 2009

 

Hey,

So I finally got a new game out!  Yay!  And here it is:

www.cosmicnitro.com

“The end of the world is nigh!  Defend the world from the onslaught of an unfeeling universe!

“In Cosmic Nitro you must blast through nine different invasions.  To play merely touch the invaders to blast them, but when things get too tough you can swipe the screen to launch a shield.

“Designed by award winning game designer Phil Hassey winner of the IGFM Innovation in Game Design award.”

So check it out, the game is only 0.99 and totally worth every penny!  Be sure to tell your friends about it!

Cheers!
-Phil

P.S. I just submitted an update to Galcon to the App Store .. so keep an eye out for that in the next week or so!  :)

 

Cosmic Nitro

Wednesday, April 15th, 2009

 

Hey,

So I finally got a new game out!  Yay!  And here it is:

www.cosmicnitro.com

“The end of the world is nigh!  Defend the world from the onslaught of an unfeeling universe!

“In Cosmic Nitro you must blast through nine different invasions.  To play merely touch the invaders to blast them, but when things get too tough you can swipe the screen to launch a shield.

“Designed by award winning game designer Phil Hassey winner of the IGFM Innovation in Game Design award.”

So check it out, the game is only 0.99 and totally worth every penny!  Be sure to tell your friends about it!

Cheers!
-Phil

P.S. I just submitted an update to Galcon to the App Store .. so keep an eye out for that in the next week or so!  :)

RC1 ..

Monday, April 6th, 2009

So .. After recovering from GDC, I’m working on wrapping up my “new game” .. Which is in RC1 tonight.  Hope to package it up and ship it tomorrow with a hopeful launch date of next week.  I gotta get all my press materials together tomorrow so that when it does launch I’m ready.  Here’s a checklist of things I need to get together:

  • Website ?
  • Game page
  • More games page (linked to from game)
  • Newsletter announcement
  • Blog announcement
  • E-mail announcement for reviewers
  • AdHoc build with comments for reviewers
  • Get a banner ad ready & pay for ad slot
  • Description, title, screenshot, icon for AppStore
  • Game assets / screenshots for reviewers
  • YouTube video of gameplay
  • YouTube video trailer
Man .. these launches take a lot don’t they!  At least I’ve utilized my blog here to list all the things I plan on preparing.
 
So starting Wednesday I’m working on a iGalcon update *finally*.  I’ve got the most demanded features figured out, so I hope to package it and send it to Apple come Monday.  Fun bit is the game will probably be available on the AppStore during my sister’s wedding.  So .. I have to make sure all my announcements are all prepared a week in advance so I can “launch” my update with about 5 minutes of button pressing when I get the notification from Apple.
 
-Phil

Galcon   Watermelons   Dynamite   The Hairy Chestival
All content of imitation pickles (c) 1999-2008 - Phil Hassey  "we care"