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.

Death Zone Zero: Update: Basic Attack AI now working

The enemies now attack your units in addition to fleeing.


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

Death Zone Zero: Update: Preliminary AI now working

The enemies will now retreat when their HP becomes 50% or lower. That's about it.


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