Differences

This shows you the differences between two versions of the page.

--- izgames:start [2019/08/09 17:02]
ironk
+++ izgames:start [2020/01/05 01:12] (current)
@@ Line 1: / Line 1: @@
-===== Industrial Zone games =====
+====== Industrial Zone games ======
-<sql>SELECT ga.GaName as Game, ga.GaZoID FROM game ga
+===== Season 2 =====
-ORDER BY ga.GaZoID</sql>
+==== Orbital Base ====
+<sql>CALL GetGamesInZone(1)</sql>
+==== Chemical Plant ====
+<sql>CALL GetGamesInZone(2)</sql>
+==== The Factory ====
+<sql>CALL GetGamesInZone(3)</sql>
+==== Security Station ====
+Games here involve sensors and buttons, trying to avoid setting off gunge devices by sneaking through.
+<sql>CALL GetGamesInZone(4)</sql>
+===== Season 3 =====
+==== The Laboratory ====
+The laboratory is where teams enter the Industrial Zone, a brightly lit white-tiled circular area with [[izgames:The Pod]] placed imposingly at its centre. Various game rooms can be entered on the outside edge of the circle, with corridors leading to the Processing and Storage wings on opposite sides of the space.
+<sql>CALL GetGamesInZone(5)</sql>
+==== Storage Wing ====
+The Storage Wing is a dimly-lit section of the base carved into the rock that the base was built on. The team find themselves in a set of corridors with stony walls with bare bulbs hanging from overhead wooden beams, with mysterious equipment altered to create messy challenges.
+<sql>CALL GetGamesInZone(6)</sql>
+==== Processing Wing ====
+The Processing Wing is where materials were shipped from and received into the ocean base. Grey-blue and metallic, the area is based around a hangar with [[izgames:The Shuttle]] standing in its centre, with game rooms accessible from floor level and a gantry around the wall.
+<sql>CALL GetGamesInZone(7)</sql>
+==== Undersea Level ====
+The undersea level is a dark, corroded area underneath the main facility - the Industrial Zone's muckiest games are down here, often using tanks of murkier slime that contrasts with the bright, smooth gunge in the other areas. Entrance is via a small hatch and stairs descending into the dark room with the [[izgames:Treatment Pool]], or down a rusty lift into the room that houses the [[izgames:Sludgecube]].
+<sql>CALL GetGamesInZone(8)</sql>
-<sql>SELECT ga.GaName as Game, COUNT(pl.PlID) as Appearances FROM game ga
-INNER JOIN gameplay pl ON ga.GaID = pl.PlGaID
-GROUP BY ga.GaName
-ORDER BY Appearances</sql>

User Tools

Site Tools

Differences

Page Tools