Death Zone Zero: Update: New Unit "Doc"

The Doc is your post-apocalyptic healing unit. He can heal a large amount of health to one organic ally unit. The problem is he has no combat training so he can't attack.

Still to come: The Doc's support ability, Steroids, which enhances an organic ally unit's attack damage but damages that unit itself as a side-effect.

Death Zone Zero: Update: New Unit "Gunslinger"

The Gunslinger is like your standard ranged-attack unit, except that he really shines in indoor maps where there are lots of walls, because his shots ricochet off them. This also means you can attack units hiding behind cover, while being behind cover, provided you can find an angle that allows you to do so.

Again, I'm still using the placeholder 3d model, so they all look alike right now.



As usual, the work-in-progress, playable demo is available at http://anomalousunderdog.herobo.com/Unity/DZZPrototype.html

I made some dummy walls in order to demonstrate the Gunslinger's ricochet ability.

Death Zone Zero: Minor Update: Bullet Ricochet Test

In this post I show a work-in-progress of the Gunslinger unit's special ability to make his shots ricochet off walls. Its kinda like in billiards games where you see the potential trajectory your ball will make before you make a shot.



I got my inspiration for this from Metal Gear Solid 1 where you fight Revolver Ocelot and his bullet shots would ricochet off the walls.

Retrieving player's ranking in MySQL

Here's a neat little trick I figured out for myself when I was coding in MySQL. How to retrieve a player's current rank in a Leaderboards sort-of table.

-- this will calculate our current rank
SELECT count(DISTINCT exp) AS rank FROM player WHERE (exp > $exp);

-- this will retrieve 3 players that are of greater rank than us
SELECT * FROM player WHERE (exp > $exp) ORDER BY exp, username ASC LIMIT 3

-- this will retrieve 3 players that are of lower rank than us (or equal rank)
SELECT * FROM player WHERE (exp <= $exp) && (username != '$username') ORDER BY exp DESC LIMIT 3

-- top ten players
SELECT * FROM player ORDER BY exp DESC LIMIT 10

My example code comes from a PHP environment so $exp is a variable storing the selected player's current experience points, which in this example determines his rank. The greater one's experience points, the greater his rank. $username is a variable storing the selected player's unique username.

Death Zone Zero: More Concept Art

Here's an update on the Rifleman concept art, together with the female version.



I'm not sure if I made the female version look "post-apocalyptic" enough. Maybe I'll redo it sometime.

Death Zone Zero: Update: New Unit "Cannoneer"

New in this update is the Cannoneer, a mobile artillery unit with a devastating, far-reaching attack. The only problem is the projectile takes a long time to get there; when the Cannoneer attacks, his shot only arrives at the target at the next turn, giving enemies a chance to run and take cover from his attack.


http://anomalousunderdog.herobo.com/Unity/DZZPrototype.html

Note that I don't have a 3d model for the Cannoneer yet— heck, I still don't have concept art for him yet, so I'm still using the placeholder 3d model of the Rifleman.

Death Zone Zero: Rifleman Concept Art

So I decided to take a break from programming and do some concept art.

The Rifleman 3d model I'm using right now is in fact just placeholder art. Its not the real Rifleman that I'll be using in the final version of the game. So me and my buddies made some concept art for the new Rifleman.


This one is made by Ryan Sumo. Here's his blog and portfolio.




This one I made myself. I'm heavily influenced by art from STALKER.