I have a feeling this is a small mistake but I can't trace a solution for it myself. Basically I made a small Resident Evil style room with multiple cameras. I also set up an actuator system to trigger the activation of each camera as active as the character moves in it's respective area. But when I press P for the scene preview it just shows the viewport view instead of the camera views. I'm losing my mind, can someone tell me what is going wrong here?
There's several issues on you file...
Try to read the BGE Guide To Character Setup, you will understand that an armature should not be the physics object of your character: make an physics object with physics type Capsule and parent the armature to it. Also, make sure to check the Actor checkbox, so your player can be detected by the zones.
Static objects can't detect collisions, so you have to change your zones physics types to Sensor and enable Detect actors. Also, disable the pulse mode on the collision sensors, it takes a lot of memory.
A Silly Mistake...
Your collision sensors are looking for an object with the property
Player, but your player does not have this property! Add it to your player and the sensors should detect it.
Also, there's a lot of optimization you could do, especially disabling the physics on objects that don't need it (paintings, lamps, statue, etc). Try to read these guides to learn a bit more about logic, structure and project management.